PWICUST – No description in the Lawson data dictionary

System: PW (PW)
Prefix: PWI
Primary key: CUST-GROUP, CUSTOMER
Fields: 34
Updated by: 2 programs
Referenced by: 0 programs

PWICUST is a Lawson PW table (prefix PWI); no description in the lawson data dictionary. It is indexed by CUST-GROUP, CUSTOMER (PWISET1); alternate indexes: PWISET2, PWISET3 and PWISET4. It is updated by AR09.1 and AR09.4. The table has 34 fields, 4 indexes and 0 documented relations.

About PWICUST

No description in the Lawson data dictionary.

Fields (34)

Column = COBOL field name without the PWI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PWI-CUST-GROUP` PK CUST_GROUP	Alpha 5	The user defined buyer group.	AR09.1, AR09.4
`PWI-CUSTOMER` PK CUSTOMER	Alpha 9 (Right Justified)	This field contains the number that represents a customer.	AR09.1, AR09.4
`PWI-SEARCH-NAME` SEARCH_NAME	Alpha 30	The requester can enter the recommended vendor's name for the requested items.	AR09.1, AR09.4
`PWI-NAME` NAME	Alpha 30 (Lower Case)	Displays the company description.	AR09.1, AR09.4
`PWI-ADDR1` ADDR1	Alpha 30 (Lower Case)	This field contains the first line of address information.	AR09.1, AR09.4
`PWI-ADDR2` ADDR2	Alpha 30 (Lower Case)	This field contains the first line of address information.	AR09.1, AR09.4
`PWI-ADDR3` ADDR3	Alpha 30 (Lower Case)	This field contains the first line of address information.	AR09.1, AR09.4
`PWI-ADDR4` ADDR4	Alpha 30 (Lower Case)	This field contains the first line of address information.	AR09.1, AR09.4
`PWI-CITY` CITY	Alpha 18 (Lower Case)	This field contains the city of the address.	AR09.1, AR09.4
`PWI-STATE-PROV` STATE_PROV	Alpha 2	The state or province.	AR09.1, AR09.4
`PWI-POSTAL-CODE` POSTAL_CODE	Alpha 10 (Lower Case)	This field contains the postal code.	AR09.1, AR09.4
`PWI-COUNTY` COUNTY	Alpha 25 (Lower Case)	The county for the company address.	AR09.1, AR09.4
`PWI-COUNTRY-CODE` 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` 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` PHONE_PREFIX	Alpha 6	The telephone number country code.	AR09.1, AR09.4
`PWI-PHONE-NUM` PHONE_NUM	Alpha 15	Phone number.	AR09.1, AR09.4
`PWI-PHONE-EXT` PHONE_EXT	Alpha 5	This field contains the telephone extension number.	AR09.1, AR09.4
`PWI-SEARCH-NAME2` SEARCH_NAME2	Alpha 30	The requester can enter the recommended vendor's name for the requested items.	AR09.1, AR09.4
`PWI-CONTACT` CONTACT	Alpha 20	This is the name of the main contact.	AR09.1, AR09.4
`PWI-BILL-TO` BILL_TO	Numeric 4	This field contains the number representing the ship to customer.	AR09.1, AR09.4
`PWI-BILL-NAME` BILL_NAME	Alpha 30 (Lower Case)	Displays the company description.	AR09.1, AR09.4
`PWI-BILL-ADDR1` BILL_ADDR1	Alpha 30 (Lower Case)	This field contains the first line of address information.	AR09.1, AR09.4
`PWI-BILL-ADDR2` BILL_ADDR2	Alpha 30 (Lower Case)	This field contains the first line of address information.	AR09.1, AR09.4
`PWI-BILL-ADDR3` BILL_ADDR3	Alpha 30 (Lower Case)	This field contains the first line of address information.	AR09.1, AR09.4
`PWI-BILL-ADDR4` BILL_ADDR4	Alpha 30 (Lower Case)	This field contains the first line of address information.	AR09.1, AR09.4
`PWI-BILL-CITY` BILL_CITY	Alpha 18	—	AR09.1, AR09.4
`PWI-BILL-STATE` BILL_STATE	Alpha 2	The state or province.	AR09.1, AR09.4
`PWI-BILL-POSTAL-CD` BILL_POSTAL_CD	Alpha 10 (Lower Case)	—	AR09.1, AR09.4
`PWI-BILL-COUNTY` BILL_COUNTY	Alpha 25 (Lower Case)	The county for the company address.	AR09.1, AR09.4
`PWI-BILL-CNTRY-CD` 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` BILL_COUNTRY	Alpha 30	—	AR09.1, AR09.4
`PWI-DEFAULT-BILLTO` DEFAULT_BILLTO	Alpha 1	—	AR09.1, AR09.4
`PWI-ORIG-OBJ-ID` ORIG_OBJ_ID	Numeric 12	—	—
`PWI-IMPORT-STATUS` IMPORT_STATUS	Numeric 1	—	AR09.1, AR09.4

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PWISET1`	`CUST-GROUP`, `CUSTOMER`	Primary		AR09.1, AR09.4
`PWISET2`	`CUST-GROUP`, `CUSTOMER`	Subset	Where IMPORT-STATUS = 1	—
`PWISET3`	`CUST-GROUP`, `CUSTOMER`	Subset	Where IMPORT-STATUS = Zeroes	—
`PWISET4`	`CUST-GROUP`, `CUSTOMER`	Subset	Where IMPORT-STATUS = 2	—

Programs

Updated by (2)

AR09.1 Customer Group Address
AR09.4 Bill To