WHSHPMTOUT – No description in the Lawson data dictionary

System
Warehouse (WH)
Prefix
WSO
Primary key
COMPANY, LOCATION, SHIPMENT-NBR, CREATION-DATE, CREATION-TIME
Fields
73
Updated by
33 programs
Referenced by
0 programs

WHSHPMTOUT is a Lawson Warehouse table (prefix WSO); no description in the lawson data dictionary. It is indexed by COMPANY, LOCATION, SHIPMENT-NBR, CREATION-DATE, CREATION-TIME (WSOSET1); alternate indexes: WSOSET2 and WSOSET3. It is updated by WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 and 25 more. The table has 73 fields, 3 indexes and 0 documented relations.

About WHSHPMTOUT

No description in the Lawson data dictionary.

Fields (73)

Column = COBOL field name without the WSO- 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
#WSO-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-SHIPMENT-NBR PK
SHIPMENT_NBR		Numeric 10This field contains the shipment number. One order can have several shipment numbers if the items of the order were not shipped at the same time.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-CREATION-DATE PK
CREATION_DATE		Numeric 8 (yyyymmdd)This is the date that this line was added to the requisition.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-CREATION-TIME PK
CREATION_TIME		Numeric 6 (hhmmss)The creation time.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-INTERFACE-STS SET2
INTERFACE_STS		Numeric 1—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-SYSTEM-CD
SYSTEM_CD		Alpha 2This field indicates on what system the transaction originated.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-DOC-NBR
DOC_NBR		Alpha 10 (Right Justified)—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-DOC-TYPE
DOC_TYPE		Alpha 2This field contains the type of transaction.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-BATCH-NBR SET3
BATCH_NBR		Numeric 6This identifies the batch the entered invoices, debit memos, and credit memos are a part of.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-STATUS
STATUS		Numeric 1This field displays the status of the transaction.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-CUST-PO-NBR
CUST_PO_NBR		Alpha 22——
#WSO-OPR-CODE
OPR_CODE		Alpha 10 (Lower Case)This field contains the operator code. This is the user ID of the person who last maintained this record.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-DESTINATION
DESTINATION		Alpha 15—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-CUSTOMER
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents a customer.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-CUST-SHIP-TO
CUST_SHIP_TO		Numeric 4This field contains the number representing the ship to customer.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-REQ-LOCATION
REQ_LOCATION		Alpha 5The location requisitioning items. This location can be an inventory or noninventory location.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-SHIP-TO-NAME
SHIP_TO_NAME		Alpha 30 (Lower Case)Displays the company description.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-SHIP-TO-ADDR1
SHIP_TO_ADDR1		Alpha 30 (Lower Case)This field contains the first line of address information.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-SHIP-TO-ADDR2
SHIP_TO_ADDR2		Alpha 30 (Lower Case)This field contains the first line of address information.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-SHIP-TO-ADDR3
SHIP_TO_ADDR3		Alpha 30 (Lower Case)This field contains the first line of address information.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-SHIP-TO-ADDR4
SHIP_TO_ADDR4		Alpha 30 (Lower Case)This field contains the first line of address information.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-SHIP-TO-CITY
SHIP_TO_CITY		Alpha 18—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-SHIP-TO-STATE
SHIP_TO_STATE		Alpha 2The state or province.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-SHIP-TO-ZIP
SHIP_TO_ZIP		Alpha 10This field contains the postal code of the address.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-SHIP-TO-CNTRY
SHIP_TO_CNTRY		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.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-BILL-TO-NAME
BILL_TO_NAME		Alpha 30 (Lower Case)—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-BILL-TO-ADDR1
BILL_TO_ADDR1		Alpha 30 (Lower Case)—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-BILL-TO-ADDR2
BILL_TO_ADDR2		Alpha 30 (Lower Case)—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-BILL-TO-ADDR3
BILL_TO_ADDR3		Alpha 30 (Lower Case)—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-BILL-TO-ADDR4
BILL_TO_ADDR4		Alpha 30 (Lower Case)—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-BILL-TO-CITY
BILL_TO_CITY		Alpha 18—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-BILL-TO-STATE
BILL_TO_STATE		Alpha 2—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-BILL-TO-ZIP
BILL_TO_ZIP		Alpha 10—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-BILL-TO-CNTRY
BILL_TO_CNTRY		Alpha 30 (Lower Case)—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-PHONE-NMBR
PHONE_NMBR		Alpha 15Phone number.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-PICKING-REQ
PICKING_REQ		Alpha 1—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-PACKING-REQ
PACKING_REQ		Alpha 1—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-ORDER-DATE
ORDER_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-PRINT-DATE
PRINT_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-PICK-DATE
PICK_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-PACK-DATE
PACK_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-SHIP-DATE
SHIP_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-GL-DATE
GL_DATE		Numeric 8 (yyyymmdd)This field contains the general ledger posting date.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-EST-DEL-DATE
EST_DEL_DATE		Numeric 8 (yyyymmdd)—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-PO-FLAG
PO_FLAG		Alpha 1——
#WSO-ROUTE
ROUTE		Numeric 4This field contains the route number. The route assigned to the ship-to customer defaults from the Order Entry Route file.—
#WSO-STOP
STOP		Numeric 4This field contains the stop within the route. If left blank, the stop associated with the ship to customer defaults from OEROUTE.—
#WSO-BOL-NBR
BOL_NBR		Alpha 22This field contains the Bill of Lading number.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-CARRIER
CARRIER		Alpha 9 (Right Justified)The vendor's identification code.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-METHOD
METHOD		Alpha 10The method.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-TRANS-ID
TRANS_ID		Alpha 20—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-FREIGHT-REQ
FREIGHT_REQ		Alpha 1—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-FREIGHT-CODE
FREIGHT_CODE		Alpha 2This field contains the freight code. This is must be valid in OEFRTCODE. This determines whether carrier and charge are allowed for the shipment.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-FRT-CHG-CURR
FRT_CHG_CURR		Signed 18.2—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-WHS-CARTONS
WHS_CARTONS		Numeric 6—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-CUBIC-FEET
CUBIC_FEET		Signed 9.3This field contains the unit cubic feet of the item based on the stocking UOM.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-WEIGHT
WEIGHT		Signed 9.3This field contains the unit weight of the item based on the stocking UOM.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-PACK-LIST-FL
PACK_LIST_FL		Alpha 1—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-POD-PRT-FL
POD_PRT_FL		Alpha 1—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-POD-RETRN-DT
POD_RETRN_DT		Numeric 8 (yyyymmdd)This field displays the system date when this was created.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-INVC-PREFIX
INVC_PREFIX		Alpha 2This field contains the invoice prefix that is assigned from either the company or process level, depending on the invoice-level option chosen.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-INVC-NUMBER
INVC_NUMBER		Numeric 8This field contains the invoice number assigned by the system. Invoice numbers are assigned at the company or process level, depending on an invoice-level option on the company file.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-TO-CNTRY-CD
TO_CNTRY_CD		Alpha 2The Ship-To country code. Must be defined in IN01.1 (Country Maintenaance).WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-SHIP-TO-REGION
SHIP_TO_REGION		Alpha 2The ship-to region code. Must be a valid region for the country, defined in IN02.1 (Region Maintenance).WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-TO-EC-CTRY
TO_EC_CTRY		Numeric 3—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-TO-ISO-CTRY
TO_ISO_CTRY		Numeric 3—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-BILL-CTRY-CD
BILL_CTRY_CD		Alpha 2—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-BILL-REGION
BILL_REGION		Alpha 2The Bill-To region code. Must be a valid region for the country, defined in IN02.1 (Region Maintenance).WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-BILL-EC-CTRY
BILL_EC_CTRY		Numeric 3—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WSO-BILL-ISO-CTRY
BILL_ISO_CTRY		Numeric 3—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more

Indexes (3)

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
WSOSET1
  1. COMPANY
  2. LOCATION
  3. SHIPMENT-NBR
  4. CREATION-DATE
  5. CREATION-TIME
PrimaryWH330
WSOSET2
  1. COMPANY
  2. LOCATION
  3. INTERFACE-STS
  4. SHIPMENT-NBR
  5. CREATION-DATE
  6. CREATION-TIME
—
WSOSET3
  1. COMPANY
  2. LOCATION
  3. BATCH-NBR
  4. SHIPMENT-NBR
—

Programs

Updated by (33)