Lawson Insight Technical Documentation |
|
PWICUST
PWICUST FILE
UPDATED BY
AR09.1 AR09.4 PW110 PW55.1 PW550 PW555
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PWI-CUST-GROUP Alpha 5 AR09.1 AR09.4
Element: Buyer Grp PW110 PW55.1
PW555
PWI-CUSTOMER Alpha 9 (Right Justified) AR09.1 AR09.4
Element: Customer PW110 PW55.1
PW555
PWI-SEARCH-NAME Alpha 30 AR09.1 AR09.4
Element: Vendor Name PW110 PW55.1
PW555
PWI-NAME Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Name PW110 PW55.1
PW555
PWI-ADDR1 Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Addr1 PW110 PW55.1
PW555
PWI-ADDR2 Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Addr1 PW110 PW55.1
PW555
PWI-ADDR3 Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Addr1 PW110 PW55.1
PW555
PWI-ADDR4 Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Addr1 PW110 PW55.1
PW555
PWI-CITY Alpha 18 (Lower Case) AR09.1 AR09.4
Element: City PW110 PW55.1
PW555
PWI-STATE-PROV Alpha 2 AR09.1 AR09.4
Element: State Prov PW110 PW55.1
PW555
PWI-POSTAL-CODE Alpha 10 (Lower Case) AR09.1 AR09.4
Element: Postal Code PW110 PW55.1
PW555
PWI-COUNTY Alpha 25 (Lower Case) AR09.1 AR09.4
Element: County PW110 PW55.1
PW555
PWI-COUNTRY-CODE Alpha 2 AR09.1 AR09.4
Element: Country Code PW110 PW55.1
PW555
PWI-COUNTRY Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Country PW110 PW55.1
PW555
PWI-PHONE-PREFIX Alpha 6 AR09.1 AR09.4
Element: Phone Prefix PW110 PW55.1
PW555
PWI-PHONE-NUM Alpha 15 AR09.1 AR09.4
Element: Phone PW110 PW55.1
PW555
PWI-PHONE-EXT Alpha 5 AR09.1 AR09.4
Element: Phone Ext PW110 PW55.1
PW555
PWI-SEARCH-NAME2 Alpha 30 AR09.1 AR09.4
Element: Vendor Name PW110
PWI-CONTACT Alpha 20 AR09.1 AR09.4
Element: Contact PW110 PW55.1
PW555
PWI-BILL-TO Numeric 4 AR09.1 AR09.4
Element: Ship To PW110 PW55.1
PW555
PWI-BILL-NAME Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Name PW110 PW55.1
PW555
PWI-BILL-ADDR1 Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Addr1 PW110 PW55.1
PW555
PWI-BILL-ADDR2 Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Addr1 PW110 PW55.1
PW555
PWI-BILL-ADDR3 Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Addr1 PW110 PW55.1
PW555
PWI-BILL-ADDR4 Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Addr1 PW110 PW55.1
PW555
PWI-BILL-CITY Alpha 18 AR09.1 AR09.4
Element: Bill City PW110 PW55.1
PW555
PWI-BILL-STATE Alpha 2 AR09.1 AR09.4
Element: State Prov PW110 PW55.1
PW555
PWI-BILL-POSTAL-CD Alpha 10 (Lower Case) AR09.1 AR09.4
Element: Bill Postal Cd PW110 PW55.1
PW555
PWI-BILL-COUNTY Alpha 25 (Lower Case) AR09.1 AR09.4
Element: County PW110 PW55.1
PW555
PWI-BILL-CNTRY-CD Alpha 2 AR09.1 AR09.4
Element: Bill Cntry Cd PW110 PW55.1
PW555
PWI-BILL-COUNTRY Alpha 30 AR09.1 AR09.4
Element: Bill Country PW110 PW55.1
PW555
PWI-DEFAULT-BILLTO Alpha 1 AR09.1 AR09.4
Element: Default Billto PW110 PW55.1
PW555
PWI-ORIG-OBJ-ID Numeric 12
Element: Orig Obj Id
PWI-IMPORT-STATUS Numeric 1 AR09.1 AR09.4
Element: Import Status PW110 PW55.1
PW550 PW555
PWICUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PWISET1 CUST-GROUP AR09.1 AR09.4
CUSTOMER PW110 PW55.1
PW555
PWISET2 CUST-GROUP Subset
CUSTOMER Where IMPORT-STATUS = 1
PWISET3 CUST-GROUP Subset PW550
CUSTOMER Where IMPORT-STATUS = Zeroes
PWISET4 CUST-GROUP Subset
CUSTOMER Where IMPORT-STATUS = 2
|