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