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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PWI-CUST-GROUP PK
CUST_GROUP		Alpha 5The 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 30The 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 2The 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 2The 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 6The telephone number country code.AR09.1, AR09.4
#PWI-PHONE-NUM
PHONE_NUM		Alpha 15Phone number.AR09.1, AR09.4
#PWI-PHONE-EXT
PHONE_EXT		Alpha 5This field contains the telephone extension number.AR09.1, AR09.4
#PWI-SEARCH-NAME2
SEARCH_NAME2		Alpha 30The requester can enter the recommended vendor's name for the requested items.AR09.1, AR09.4
#PWI-CONTACT
CONTACT		Alpha 20This is the name of the main contact.AR09.1, AR09.4
#PWI-BILL-TO
BILL_TO		Numeric 4This 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 2The 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 2The 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PWISET1
  1. CUST-GROUP
  2. CUSTOMER
PrimaryAR09.1, AR09.4
PWISET2
  1. CUST-GROUP
  2. CUSTOMER
SubsetWhere IMPORT-STATUS = 1—
PWISET3
  1. CUST-GROUP
  2. CUSTOMER
SubsetWhere IMPORT-STATUS = Zeroes—
PWISET4
  1. CUST-GROUP
  2. CUSTOMER
SubsetWhere IMPORT-STATUS = 2—

Programs

Updated by (2)