CV1:Customer v2.00 3/17/2009

Format : PIDF
Topic : CU
Usage : Customer information.

Description Length From To Format Required Comments
Topic 2 1 2 A Y Literal "CU"
CV1 Customer Number 6 3 6 N N If not provided, a new customer with a randomly generated customer number is created.
Name 35 9 43 A N  
Address 1 30 44 73 A N  
City 30 74 103 A N  
State 2 104 105 A N  
Branch Code 6 106 111 A N The warehouse that this customer purchases from.
Salesman# 6 112 117 A N Employee ID in DAC.
Transaction Terminator Symbol 2 118 119 A Y Literal "//"
Total Len= 119          

 

 


CV1:Customer v1.10 4/30/2009

Format : PIDF

Topic : CU

Usage : Customer information.

Description Len From To Mask Fmt Req Format/Comments
CV1 Customer Number 6 1 6 999999 N N If not provided, a new customer with a randomly generated customer number is created.
Customer's ID of Self 30 7 36   A N The number that the customer uses to Identify themselves to themselves. In CV1, this is setup in the customer's EDI Options. It is optional.
Corporate # 6 37 42 999999 N N  
Salesman # 6 43 48   A N  
Terms Code 3 49 51   A N  
Terms Description 25 52 76   A N  
Name 35 77 111   A N  
Addr 1 30 112 141   A N  
Addr 2 30 142 171   A N  
Addr 3 30 172 201   A N  
City 30 202 231   A N  
State 2 232 233   A N  
Zip 5 234 238   A N  
Zip Ext 4 239 242   N N  
Phone Area 3 243 245   N N  
Phone Number 7 246 252   N N  
Fax Area 3 253 255   N N  
Fax Number 7 256 262   N N  
Contact 1 30 263 292   A N  
Contact 2 30 293 322   A N  
Contact 3 30 323 352   A N  
Contact Title 1 30 353 382   A N  
Contact Title 2 30 383 412   A N  
Contact Title 3 30 413 442   A N  
Credit Limit 17 443 459   R N  
Exclude from Promos? 1 460 460   A N Y/N (Blank means assume N)
Billing Matrix 6 461 466   N N  
Amount Due 17 467 483   R N  
Last Pay Date 8 484 491   N N (YYYYMMDD)
Last Order Date 8 492 499   N N (YYYYMMDD)
Sales WTD 17 500 516   R N  
Sales PTD 17 517 533   R N  
Sales YTD 17 534 550   R N  
Authorized? 1 551 551   A N (Y/N)
Call Route 1 6 552 557   A N  
Call Route 2 6 558 563   A N  
Call Route 3 6 564 569   A N  
Call Route 4 6 570 575   A N  
Call Route 5 6 576 581   A N  
Call Route 6 6 582 587   A N  
Call Route 7 6 588 593   A N  
Call Sequence 1 5 594 598   N N  
Call Sequence 2 5 599 603   N N  
Call Sequence 3 5 604 608   N N  
Call Sequence 4 5 609 613   N N  
Call Sequence 5 5 614 618   N N  
Call Sequence 6 5 619 623   N N  
Call Sequence 7 5 624 628   N N  
Pricing Alias 6 629 634   N N  
Tax Jurisdiction 6 635 640   A N  
Email1 70 641 710   A N  
Email2 70 711 780   A N  
Charge Limit 17 781 797   R N  
Gender 1 798 798   A N M=Male, F=Female
Date of Birth 8 799 806   N N (YYYYMMDD)
Status 1 807 807       A=Active, D=Marked for Delete, I=Inactive
Password 8 808 815   A N  
Web Console Profile 6 816 821   A N Used if customer is designated as a WebConsole customer.
Retail Matrix 6 822 827   N N Retail Matrix Code
Web Console Wks of Order History 3 828 830   N N How many weeks of order history to retain in Web Console.
Web Console Wks of Sales History 3 831 833   N N How many weeks of sales history to retain in Web Console.
Branch Code 6 834 839   A N The warehouse that this customer purchases from.
Allowance Based Retails? 1 840 840   A N Are retail prices based on costs reflecting promotions? Y/N
Transaction Terminator Symbol 2 841 842   A Y Literal "//"
Total Len= 842            

 

CV1:Customer Version 1.08 4/2/2004

Format : PIDF

Topic : CU

Usage : Customer information.

Description Len From To Mask Fmt Req Format/Comments
CV1 Customer Number 6 1 6 999999 N N If not provided, a new customer with a randomly generated customer number is created.
Customer's ID of Self 30 7 36   A N The number that the customer uses to Identify themselves to themselves. In CV1, this is setup in the customer's EDI Options. It is optional.
Corporate # 6 37 42 999999 N N  
Salesman # 6 43 48   A N  
Terms Code 3 49 51   A N  
Terms Description 25 52 76   A N  
Name 35 77 111   A N  
Addr 1 30 112 141   A N  
Addr 2 30 142 171   A N  
Addr 3 30 172 201   A N  
City 30 202 231   A N  
State 2 232 233   A N  
Zip 5 234 238   A N  
Zip Ext 4 239 242   N N  
Phone Area 3 243 245   N N  
Phone Number 7 246 252   N N  
Fax Area 3 253 255   N N  
Fax Number 7 256 262   N N  
Contact 1 30 263 292   A N  
Contact 2 30 293 322   A N  
Contact 3 30 323 352   A N  
Contact Title 1 30 353 382   A N  
Contact Title 2 30 383 412   A N  
Contact Title 3 30 413 442   A N  
Credit Limit 17 443 459   R N  
Exclude from Promos? 1 460 460   A N Y/N (Blank means assume N)
Billing Matrix 6 461 466   N N  
Amount Due 17 467 483   R N  
Last Pay Date 8 484 491   N N (YYYYMMDD)
Last Order Date 8 492 499   N N (YYYYMMDD)
Sales WTD 17 500 516   R N  
Sales PTD 17 517 533   R N  
Sales YTD 17 534 550   R N  
Authorized? 1 551 551   A N (Y/N)
Call Route 1 6 552 557   A N  
Call Route 2 6 558 563   A N  
Call Route 3 6 564 569   A N  
Call Route 4 6 570 575   A N  
Call Route 5 6 576 581   A N  
Call Route 6 6 582 587   A N  
Call Route 7 6 588 593   A N  
Call Sequence 1 5 594 598   N N  
Call Sequence 2 5 599 603   N N  
Call Sequence 3 5 604 608   N N  
Call Sequence 4 5 609 613   N N  
Call Sequence 5 5 614 618   N N  
Call Sequence 6 5 619 623   N N  
Call Sequence 7 5 624 628   N N  
Pricing Alias 6 629 634   N N  
Tax Jurisdiction 6 635 640   A N  
Email1 70 641 710   A N  
Email2 70 711 780   A N  
Charge Limit 17 781 797   R N  
Gender 1 798 798   A N M=Male, F=Female
Date of Birth 8 799 806   N N (YYYYMMDD)
Status 1 807 807       A=Active, D=Marked for Delete, I=Inactive
Password 8 808 815   A N  
Web Console Profile 6 816 821   A N Used if customer is designated as a WebConsole customer.
Retail Matrix 6 822 827   N N Retail Matrix Code
Transaction Terminator Symbol 2 828 829   A Y Literal "//"
Total Len= 829             


CV1:Customer Version 1.07 1/27/03

Format : PIDF

Topic : CU

Usage : Customer information.

Description Len From To Mask Fmt Req Format/Comments
CV1 Customer Number 6 1 6 999999 N N If not provided, a new customer with a randomly generated customer number is created.
Customer's ID of Self 30 7 36   A N The number that the customer uses to Identify themselves to themselves. In CV1, this is setup in the customer's EDI Options. It is optional.
Corporate # 6 37 42 999999 N N  
Salesman # 6 43 48   A N  
Terms Code 3 49 51   A N  
Terms Description 25 52 76   A N  
Name 35 77 111   A N  
Addr 1 30 112 141   A N  
Addr 2 30 142 171   A N  
Addr 3 30 172 201   A N  
City 30 202 231   A N  
State 2 232 233   A N  
Zip 5 234 238   A N  
Zip Ext 4 239 242   N N  
Phone Area 3 243 245   N N  
Phone Number 7 246 252   N N  
Fax Area 3 253 255   N N  
Break at 255 0            
Fax Number 7 256 262   N N  
Contact 1 30 263 292   A N  
Contact 2 30 293 322   A N  
Contact 3 30 323 352   A N  
Contact Title 1 30 353 382   A N  
Contact Title 2 30 383 412   A N  
Contact Title 3 30 413 442   A N  
Credit Limit 17 443 459   R N  
Exclude from Promos? 1 460 460   A N Y/N (Blank means assume N)
Billing Matrix 6 461 466   N N  
Amount Due 17 467 483   R N  
Last Pay Date 8 484 491   N N (YYYYMMDD)
Last Order Date 8 492 499   N N (YYYYMMDD)
Sales WTD 17 500 516   R N  
Break at 510 0            
Sales PTD 17 517 533   R N  
Sales YTD 17 534 550   R N  
Authorized? 1 551 551   A N (Y/N)
Call Route 1 6 552 557   A N  
Call Route 2 6 558 563   A N  
Call Route 3 6 564 569   A N  
Call Route 4 6 570 575   A N  
Call Route 5 6 576 581   A N  
Call Route 6 6 582 587   A N  
Call Route 7 6 588 593   A N  
Call Sequence 1 5 594 598   N N  
Call Sequence 2 5 599 603   N N  
Call Sequence 3 5 604 608   N N  
Call Sequence 4 5 609 613   N N  
Call Sequence 5 5 614 618   N N  
Call Sequence 6 5 619 623   N N  
Call Sequence 7 5 624 628   N N  
Pricing Alias 6 629 634   N N  
Tax Jurisdiction 6 635 640   A N  
Email1 70 641 710   A N  
Email2 70 711 780   A N  
Break at 765 0            
Charge Limit 17 781 797   R N  
Gender 1 798 798   A N M=Male, F=Female
Date of Birth 8 799 806   N N (YYYYMMDD)
Status 1 807 807       A=Active, D=Marked for Delete, I=Inactive
Password 8 808 815   A N  
Web Console Profile 6 816 821   A N Used if customer is designated as a WebConsole customer.
Transaction Terminator Symbol 2 822 823   A Y Literal "//"
Total Len= 823             



CV1:Customer Version
1.06 9/27/01



Format : PIDF



Topic : CU



Usage : Customer information.




    

        Description
        Len
        From
        To
        Mask
        Fmt
        Req
        Format/Comments
    

    

        CV1 Customer Number
        6
        1
        6
        999999
        N
        N
        If not
          provided, a new customer with a randomly generated customer number is
          created.
    

    

        Customer's ID of Self
        30
        7
        36
         
        A
        N
        The number that the customer uses to
        Identify themselves to themselves. In CV1, this is setup
        in the customer's EDI Options. It is optional.
    

    

        Corporate #
        6
        37
        42
        
        999999
        N
        N
         
    

    

        Salesman #
        6
        43
        48
         
        A
        N
         
    

    

        Terms Code
        3
        49
        51
         
        A
        N
         
    

    

        Terms Description
        25
        52
        76
         
        A
        N
         
    

    

        Name
        35
        77
        111
         
        A
        N
         
    

    

        Addr 1
        30
        112
        141
         
        A
        N
         
    

    

        Addr 2
        30
        142
        171
         
        A
        N
         
    

    

        Addr 3
        30
        172
        201
         
        A
        N
         
    

    

        City
        30
        202
        231
         
        A
        N
         
    

    

        State
        2
        232
        233
         
        A
        N
         
    

    

        Zip
        5
        234
        238
         
        A
        N
         
    

    

        Zip Ext
        4
        239
        242
         
        N
        N
         
    

    

        Phone Area
        3
        243
        245
         
        N
        N
         
    

    

        Phone Number
        7
        246
        252
         
        N
        N
         
    

    

        Fax Area
        3
        253
        255
         
        N
        N
         
    

    

        Break at 255
        0
         
         
         
         
         
         
    

    

        Fax Number
        7
        256
        262
         
        N
        N
         
    

    

        Contact 1
        30
        263
        292
         
        A
        N
         
    

    

        Contact 2
        30
        293
        322
         
        A
        N
         
    

    

        Contact 3
        30
        323
        352
         
        A
        N
         
    

    

        Contact Title 1
        30
        353
        382
         
        A
        N
         
    

    

        Contact Title 2
        30
        383
        412
         
        A
        N
         
    

    

        Contact Title 3
        30
        413
        442
         
        A
        N
         
    

    

        Credit Limit
        17
        443
        459
         
        R
        N
         
    

    

        Exclude from Promos?
        1
        460
        460
         
        A
        N
        Y/N (Blank means assume N)
    

    

        Billing Matrix
        6
        461
        466
         
        N
        N
         
    

    

        Amount Due
        17
        467
        483
         
        R
        N
         
    

    

        Last Pay Date
        8
        484
        491
         
        N
        N
        (YYYYMMDD)
    

    

        Last Order Date
        8
        492
        499
         
        N
        N
        (YYYYMMDD)
    

    

        Sales WTD
        17
        500
        516
         
        R
        N
         
    

    

        Break at 510
        0
         
         
         
         
         
         
    

    

        Sales PTD
        17
        517
        533
         
        R
        N
         
    

    

        Sales YTD
        17
        534
        550
         
        R
        N
         
    

    

        Authorized?
        1
        551
        551
         
        A
        N
        (Y/N)
    

    

        Call Route 1
        6
        552
        557
         
        A
        N
         
    

    

        Call Route 2
        6
        558
        563
         
        A
        N
         
    

    

        Call Route 3
        6
        564
        569
         
        A
        N
         
    

    

        Call Route 4
        6
        570
        575
         
        A
        N
         
    

    

        Call Route 5
        6
        576
        581
         
        A
        N
         
    

    

        Call Route 6
        6
        582
        587
         
        A
        N
         
    

    

        Call Route 7
        6
        588
        593
         
        A
        N
         
    

    

        Call Sequence 1
        5
        594
        598
         
        N
        N
         
    

    

        Call Sequence 2
        5
        599
        603
         
        N
        N
         
    

    

        Call Sequence 3
        5
        604
        608
         
        N
        N
         
    

    

        Call Sequence 4
        5
        609
        613
         
        N
        N
         
    

    

        Call Sequence 5
        5
        614
        618
         
        N
        N
         
    

    

        Call Sequence 6
        5
        619
        623
         
        N
        N
         
    

    

        Call Sequence 7
        5
        624
        628
         
        N
        N
         
    

    

        Pricing Alias
        6
        629
        634
         
        N
        N
         
    

    

        Tax
          Jurisdiction
        6
        635
        640
         
        A
        N
         
    

    

        Email1
        70
        641
        710
         
        A
        N
         
    

    

        Email2
        70
        711
        780
         
        A
        N
         
    

    

        Break at 765
        0
         
         
         
         
         
         
    

    

        Charge Limit
        17
        781
        797
         
        R
        N
         
    

    

        Gender
        1
        798
        798
         
        A
        N
        M=Male,
          F=Female
    

    

        Date of Birth
        8
        799
        806
         
        N
        N
        (YYYYMMDD)
    

    

        Status
        1
        807
        807
         
         
         
        A=Active,
          D=Marked for Delete, I=Inactive
    

    

        Password
        8
        808
        815
         
        A
        N
         
    

    

        Transaction Terminator Symbol
        2
        816
        817
         
        A
        Y
        Literal "//"
    

    

        Total Len=
        817