PWICUST

UPDATED BY
AR09.1 AR09.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PWI-CUST-GROUP
Element: Buyer Grp
Alpha 5
The user defined buyer group.
AR09.1 AR09.4
PWI-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
AR09.1 AR09.4
PWI-SEARCH-NAME
Element: Vendor Name
Alpha 30
The requester can enter the recommended vendor's name for the requested items.
AR09.1 AR09.4
PWI-NAME
Element: Name
Alpha 30 (Lower Case)
Displays the company description.
AR09.1 AR09.4
PWI-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR09.1 AR09.4
PWI-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR09.1 AR09.4
PWI-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR09.1 AR09.4
PWI-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR09.1 AR09.4
PWI-CITY
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
AR09.1 AR09.4
PWI-STATE-PROV
Element: State Prov
Alpha 2
The state or province.
AR09.1 AR09.4
PWI-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
This field contains the postal code.
AR09.1 AR09.4
PWI-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
AR09.1 AR09.4
PWI-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
AR09.1 AR09.4
PWI-COUNTRY
Element: Country
Alpha 30 (Lower Case)
This field contains the country of the address, or it can be used for additional information such as an attention name.
AR09.1 AR09.4
PWI-PHONE-PREFIX
Element: Phone Prefix
Alpha 6
The telephone number country code.
AR09.1 AR09.4
PWI-PHONE-NUM
Element: Phone
Alpha 15
Phone number.
AR09.1 AR09.4
PWI-PHONE-EXT
Element: Phone Ext
Alpha 5
This field contains the telephone extension number.
AR09.1 AR09.4
PWI-SEARCH-NAME2
Element: Vendor Name
Alpha 30
The requester can enter the recommended vendor's name for the requested items.
AR09.1 AR09.4
PWI-CONTACT
Element: Contact
Alpha 20
This is the name of the main contact.
AR09.1 AR09.4
PWI-BILL-TO
Element: Ship To
Numeric 4
This field contains the number representing the ship to customer.
AR09.1 AR09.4
PWI-BILL-NAME
Element: Name
Alpha 30 (Lower Case)
Displays the company description.
AR09.1 AR09.4
PWI-BILL-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR09.1 AR09.4
PWI-BILL-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR09.1 AR09.4
PWI-BILL-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR09.1 AR09.4
PWI-BILL-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR09.1 AR09.4
PWI-BILL-CITY
Element: Bill City
Alpha 18
AR09.1 AR09.4
PWI-BILL-STATE
Element: State Prov
Alpha 2
The state or province.
AR09.1 AR09.4
PWI-BILL-POSTAL-CD
Element: Bill Postal Cd
Alpha 10 (Lower Case)
AR09.1 AR09.4
PWI-BILL-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
AR09.1 AR09.4
PWI-BILL-CNTRY-CD
Element: Bill Cntry Cd
Alpha 2
The Bill-To country code; must be defined in IN01.1 (Country Maintenance).
AR09.1 AR09.4
PWI-BILL-COUNTRY
Element: Bill Country
Alpha 30
AR09.1 AR09.4
PWI-DEFAULT-BILLTO
Element: Default Billto
Alpha 1
AR09.1 AR09.4
PWI-ORIG-OBJ-ID
Element: Orig Obj Id
Numeric 12
PWI-IMPORT-STATUS
Element: Import Status
Numeric 1
AR09.1 AR09.4


PWICUST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PWISET1 CUST-GROUP
CUSTOMER
AR09.1 AR09.4
PWISET2 CUST-GROUP
CUSTOMER
Subset
WhereIMPORT-STATUS =1
PWISET3 CUST-GROUP
CUSTOMER
Subset
WhereIMPORT-STATUS =Zeroes
PWISET4 CUST-GROUP
CUSTOMER
Subset
WhereIMPORT-STATUS =2


File created: Thu Jun 09 11:28:28 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.