|
|
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
Element: 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
Element: 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
Element: Name Override bill-to name. SA300
SBA-BILL-ADDR1 Alpha 30 (Lower Case) SA100 SA110
Element: Address 1 Override bill-to address line 1. SA300
SBA-BILL-ADDR2 Alpha 30 (Lower Case) SA100 SA110
Element: Address 1 Override bill-to address line 2. SA300
SBA-BILL-ADDR3 Alpha 30 (Lower Case) SA100 SA110
Element: Address 1 Override bill-to address line 3. SA300
SBA-BILL-ADDR4 Alpha 30 (Lower Case) SA100 SA110
Element: Address 1 Override bill-to address line 4. SA300
SBA-BILL-CITY Alpha 18 SA100 SA110
Element: Billing City Override bill-to city. SA300
SBA-BILL-STATE Alpha 2 SA100 SA110
Element: State or ProviOverride bill-to state. SA300
SBA-BILL-ZIP Alpha 10 SA100 SA110
Element: Postal Code Override bill-to zip code. SA300
SBA-BILL-CNTRY Alpha 30 (Lower Case) SA100 SA110
Element: Country or OthOverride bill-to country. SA300
SBA-SHIP-TO-NAME Alpha 30 (Lower Case) SA100 SA110
Element: Name Override ship-to address name. SA300
SBA-SHIP-TO-ADDR1 Alpha 30 (Lower Case) SA100 SA110
Element: Address 1 Override ship-to address line 1. SA300
SBA-SHIP-TO-ADDR2 Alpha 30 (Lower Case) SA100 SA110
Element: Address 1 Override ship-to address line 2. SA300
SBA-SHIP-TO-ADDR3 Alpha 30 (Lower Case) SA100 SA110
Element: Address 1 Override ship-to address line 3. SA300
SBA-SHIP-TO-ADDR4 Alpha 30 (Lower Case) SA100 SA110
Element: Address 1 Override ship-to address line 4. SA300
SBA-SHIP-TO-CITY Alpha 18 SA100 SA110
Element: Billing City Override ship-to city. SA300
SBA-SHIP-TO-STATE Alpha 2 SA100 SA110
Element: State or ProviOverride ship-to state. SA300
SBA-SHIP-TO-ZIP Alpha 10 SA100 SA110
Element: Postal Code Override ship-to zip code. SA300
SBA-SHIP-TO-CNTRY Alpha 30 (Lower Case) SA100 SA110
Element: Country or OthOverride ship-to country. SA300
SBA-BILL-CTRY-CD Alpha 2 SA100 SA110
Element: Bill Ctry Cd SA300
SBA-BILL-REGION Alpha 2 SA100 SA110
Element: Bill Region The Bill-To region code. Must be a SA300
valid region for the country, defined in
IN02.1 (Region Maintenance).
SBA-BILL-EC-CTRY Numeric 3 SA100 SA110
Element: Bill Ec Ctry SA300
SBA-BILL-ISO-CTRY Numeric 3 SA100 SA110
Element: Bill Iso Ctry SA300
SBA-TO-CNTRY-CD Alpha 2 SA100 SA110
Element: To Cntry Cd The Ship-To country code. Must be SA300
defined in IN01.1 (Country
Maintenaance).
SBA-SHIP-TO-REGION Alpha 2 SA100 SA110
Element: Ship To RegionThe ship-to region code. SA300
Must be a valid region for the country,
defined in IN02.1 (Region
Maintenance).
SBA-TO-EC-CTRY Numeric 3 SA100 SA110
Element: To Ec Ctry SA300
SBA-TO-ISO-CTRY Numeric 3 SA100 SA110
Element: To Iso Ctry 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
|
