SABOOKADDR FILE
Booked Order Address
The Booked Order Address file is used to store an override address for booked
orders. Records will exist in this file only if the address on an order is
different than the customer master's address.
UPDATED BY
SA100 SA101 SA110 SA300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SBA-COMPANY Numeric 4 SA100 SA110
Company The company number represents the SA300
highest organizational level and is
required on all form action codes.
SBA-ORDER-NBR Numeric 8 SA100 SA110
Order Number Each order is assigned a unique number. SA300
Order numbers are either manually
assigned or system assigned based on a
company-level option.
SBA-BILL-NAME Alpha 30 (Lower Case) SA100 SA110
Bill Name Override bill-to name. SA300
SBA-BILL-ADDR1 Alpha 30 (Lower Case) SA100 SA110
Bill Address 1 Override bill-to address line 1. SA300
SBA-BILL-ADDR2 Alpha 30 (Lower Case) SA100 SA110
Bill Address 2 Override bill-to address line 2. SA300
SBA-BILL-ADDR3 Alpha 30 (Lower Case) SA100 SA110
Bill Address 3 Override bill-to address line 3. SA300
SBA-BILL-ADDR4 Alpha 30 (Lower Case) SA100 SA110
Bill Address 4 Override bill-to address line 4. SA300
SBA-BILL-CITY Alpha 18 SA100 SA110
Bill City Override bill-to city. SA300
SBA-BILL-STATE Alpha 2 SA100 SA110
Bill State Override bill-to state. SA300
SBA-BILL-ZIP Alpha 10 SA100 SA110
Bill Zip Code Override bill-to zip code. SA300
SBA-BILL-CNTRY Alpha 30 (Lower Case) SA100 SA110
Bill Country Override bill-to country. SA300
SBA-SHIP-TO-NAME Alpha 30 (Lower Case) SA100 SA110
Ship To Name Override ship-to address name. SA300
SBA-SHIP-TO-ADDR1 Alpha 30 (Lower Case) SA100 SA110
Ship To Address 1 Override ship-to address line 1. SA300
SBA-SHIP-TO-ADDR2 Alpha 30 (Lower Case) SA100 SA110
Ship To Address 2 Override ship-to address line 2. SA300
SBA-SHIP-TO-ADDR3 Alpha 30 (Lower Case) SA100 SA110
Ship To Address 3 Override ship-to address line 3. SA300
SBA-SHIP-TO-ADDR4 Alpha 30 (Lower Case) SA100 SA110
Ship To Address 4 Override ship-to address line 4. SA300
SBA-SHIP-TO-CITY Alpha 18 SA100 SA110
Ship To City Override ship-to city. SA300
SBA-SHIP-TO-STATE Alpha 2 SA100 SA110
Ship To State Override ship-to state. SA300
SBA-SHIP-TO-ZIP Alpha 10 SA100 SA110
Ship To Zip Code Override ship-to zip code. SA300
SBA-SHIP-TO-CNTRY Alpha 30 (Lower Case) SA100 SA110
Ship To Country Override ship-to country. SA300
SABOOKADDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SBASET1 COMPANY SA100 SA101
ORDER-NBR SA110 SA300
SABOOKADDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sabooked SABOOKED Required
SBA-COMPANY -> SAB-COMPANY
SBA-ORDER-NBR -> SAB-ORDER-NBR
Sacompany SACOMPANY Required
SBA-COMPANY -> SAC-COMPANY
|