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