     SO_ShipToAddress                       SO Ship to Address             Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: SO_ShipToAddress_bus
     SQL Def: Y  SysDB: N                                      "MAS_"+%C$+"/SO"+%C$+"/SO_ShipToAddress.M4T"

     KPRIMARY: ARDivisionNo+CustomerNo+ShipToCode
     KADDRESS1: ShipToAddress1+ARDivisionNo+CustomerNo+ShipToCode
     KADDRESS2: ShipToAddress2+ARDivisionNo+CustomerNo+ShipToCode
     KADDRESS3: ShipToAddress3+ARDivisionNo+CustomerNo+ShipToCode
     KZIPCODE: ShipToZipCode+ARDivisionNo+CustomerNo+ShipToCode

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  ARDivisionNo. . . . . . . . .     2 SNY  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: Validated against
                                                    AR_Division {SOB$(1,2)}
       2  CustomerNo. . . . . . . . . .    20 SYY  Customer Number . . . . . . . .CUSTOMERNO
                                                    FmtType:MASTERNUMC ChngTag:Re
                                                    place1/ARDivisionNo$ Notes:
                                                    Validated against AR_Customer
                                                     {SOB$(3,7)}
       3  ShipToCode. . . . . . . . . .     4 SYY  Ship-To Code. . . . . . . . . .SHIPTO
                                                    Next:ShipToCode$ Notes:
                                                    {SOB$(10,4)}
       4  ShipToName. . . . . . . . . .    30 SNN  Ship To Name. . . . . . . . . .NAME
                                                    Notes: {SOB$(14,30)}
       5  ShipToAddress1. . . . . . . .    30 SNN  Ship To Address Line 1. . . . .ADDRESSLINE
                                                    ValGroup:CRM Notes: {SOB$(44,
                                                    30)}
       6  ShipToAddress2. . . . . . . .    30 SNN  Ship To Address Line 2. . . . .ADDRESSLINE
                                                    ValGroup:CRM Notes: {SOB$(74,
                                                    30)}
       7  ShipToAddress3. . . . . . . .    30 SNN  Ship To Address Line 3. . . . .ADDRESSLINE
                                                    ValGroup:CRM Notes:
                                                    {SOB$(194,30)}
       8  ShipToCity. . . . . . . . . .    20 SNN  Ship To City. . . . . . . . . .CITY
                                                    ValGroup:CRM Notes:
                                                    {SOB$(104,20)}
       9  ShipToState . . . . . . . . .     2 SYN  Ship To State . . . . . . . . .STATE
                                                    ValGroup:CRM Notes:
                                                    {SOB$(124,2)}
      10  ShipToZipCode . . . . . . . .    10 SYN  Ship To Zip Code. . . . . . . .ZIPCODE
                                                    ValGroup:CRM Notes:
                                                    {SOB$(126,10)}
      11  ShipToCountryCode . . . . . .     3 SYN  Ship To Country Code. . . . . .COUNTRY
                                                    ValGroup:CRM Notes:
                                                    {SOB$(161,3)}
      12  TelephoneNo . . . . . . . . .    17 SNN  Telephone Number. . . . . . . .TELEPHONENO
                                                    Notes: {SOB$(224,17)}
      13  TelephoneExt. . . . . . . . .     5 SNN  Telephone Extension . . . . . .TELEPHONEEXT
                                                    Notes: {SOB$(146,5)}
      14  FaxNo . . . . . . . . . . . .    17 SNN  Fax Number. . . . . . . . . . .TELEPHONENO
                                                    DepVal:REQUIRED Notes:
                                                    {SOB$(241,17)}
      15  BatchFax. . . . . . . . . . .     1 SYN  Batch Fax . . . . . . . . . . .YESNO
                                                    DfltVal:N Notes: {SOB$(258,
                                                    1)}
      16  BatchEmail. . . . . . . . . .     1 SYN  Batch Email . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      17  EmailAddress. . . . . . . . .    50 SNN  Email Address . . . . . . . . .EMAILADDRESS
      18  ContactCode . . . . . . . . .    10 SYN  Contact Code. . . . . . . . . .ARCONTACT
                                                    Notes: Validated against
                                                    AR_CustomerContact {SOB$(151,
                                                    10)}
      19  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    ChngTag:Replace2/ARDivisionNo
                                                    $/CustomerNo$
      20  SalespersonNo . . . . . . . .     4 SYN  Salesperson Number. . . . . . .SALESPERSONNO
                                                    FmtType:CHARNUM Notes:
                                                    Validated against AR_Salesper
                                                    son {SOB$(190,4)}
      21  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM Notes:
                                                    Validated against IM_Warehous
                                                    e {SOB$(164,3)}
      22  TaxSchedule . . . . . . . . .     9 SYN  Tax Schedule. . . . . . . . . .TAXSCHEDULE
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED Notes: {SOB$(181,9)}
      23  ResidentialAddress. . . . . .     1 SYN  Residential Address . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      24  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      25  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                    Read Only:Y
      26  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL
      27  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      28  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y
      29  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL