|
|
PWICUST FILE
UPDATED BY
AR09.1 AR09.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PWI-CUST-GROUP Alpha 5 AR09.1 AR09.4
Element: Buyer Group
PWI-CUSTOMER Alpha 9 (Right Justified) AR09.1 AR09.4
Element: Customer NumbeThis field contains the number that
represents a customer.
PWI-SEARCH-NAME Alpha 30 AR09.1 AR09.4
Element: Vendor Name
PWI-NAME Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Name Displays the company description.
PWI-ADDR1 Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Address 1 This field contains the first line of
address information.
PWI-ADDR2 Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Address 1
PWI-ADDR3 Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Address 1
PWI-ADDR4 Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Address 1
PWI-CITY Alpha 18 (Lower Case) AR09.1 AR09.4
Element: City This field contains the city of the
address.
PWI-STATE-PROV Alpha 2 AR09.1 AR09.4
Element: State or ProviThe state or province.
PWI-POSTAL-CODE Alpha 10 (Lower Case) AR09.1 AR09.4
Element: Postal Code This field contains the postal code.
PWI-COUNTY Alpha 25 (Lower Case) AR09.1 AR09.4
Element: County The county for the company address.
PWI-COUNTRY-CODE Alpha 2 AR09.1 AR09.4
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
PWI-COUNTRY Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Country or OthThis field contains the country of the
address, or it can be used for
additional information such as an
attention name.
PWI-PHONE-PREFIX Alpha 6 AR09.1 AR09.4
Telephone Country The telephone number country code.
Code
PWI-PHONE-NUM Alpha 15 AR09.1 AR09.4
Element: Telephone NumbThis is the main telephone number.
PWI-PHONE-EXT Alpha 5 AR09.1 AR09.4
Element: Telephone ExteThis field contains the telephone
extension number.
PWI-SEARCH-NAME2 Alpha 30 AR09.1 AR09.4
Element: Vendor Name
PWI-CONTACT Alpha 20 AR09.1 AR09.4
Element: Primary ContacThis is the name of the main contact.
PWI-BILL-TO Numeric 4 AR09.1 AR09.4
Element: Ship-to Code
PWI-BILL-NAME Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Name
PWI-BILL-ADDR1 Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Address 1
PWI-BILL-ADDR2 Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Address 1
PWI-BILL-ADDR3 Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Address 1
PWI-BILL-ADDR4 Alpha 30 (Lower Case) AR09.1 AR09.4
Element: Address 1
PWI-BILL-CITY Alpha 18 AR09.1 AR09.4
Element: Billing City
PWI-BILL-STATE Alpha 2 AR09.1 AR09.4
Element: State or Province
PWI-BILL-POSTAL-CD Alpha 10 (Lower Case) AR09.1 AR09.4
Element: Bill Postal Cd
PWI-BILL-COUNTY Alpha 25 (Lower Case) AR09.1 AR09.4
Element: County
PWI-BILL-CNTRY-CD Alpha 2 AR09.1 AR09.4
Element: Bill Cntry Cd The Bill-To country code; must be
defined in IN01.1 (Country Maintenance).
PWI-BILL-COUNTRY Alpha 30 AR09.1 AR09.4
Element: Bill Country
PWI-DEFAULT-BILLTO Alpha 1 AR09.1 AR09.4
Element: Default Billto
PWI-ORIG-OBJ-ID Numeric 12
Element: Orig Obj Id This is the unique record identifier in
the Account4 Company file.
PWI-IMPORT-STATUS Numeric 1 AR09.1 AR09.4
Element: Import Status This field is used to designate when a
imported record has an error that needs
to be repaired before it can be
imported. A record ready for import will
have a value of "0", "1" = error
If this field has a "2" the records has
been exported from Lawson and should
designate to Lawson PSA that it should
be imported into Lawson PSA.
PWICUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PWISET1 CUST-GROUP AR09.1 AR09.4
CUSTOMER
PWISET2 CUST-GROUP Subset
CUSTOMER Where IMPORT-STATUS = 1
PWISET3 CUST-GROUP Subset
CUSTOMER Where IMPORT-STATUS = Zeroes
PWISET4 CUST-GROUP Subset
CUSTOMER Where IMPORT-STATUS = 2
|
