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