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.

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
INTERFACE_STS
Numeric 1WH130, 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
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 15WH130, 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 18WH130, 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 18WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WSO-BILL-TO-STATE
BILL_TO_STATE
Alpha 2WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WSO-BILL-TO-ZIP
BILL_TO_ZIP
Alpha 10WH130, 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 1WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WSO-PACKING-REQ
PACKING_REQ
Alpha 1WH130, 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 20WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WSO-FREIGHT-REQ
FREIGHT_REQ
Alpha 1WH130, 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.2WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WSO-WHS-CARTONS
WHS_CARTONS
Numeric 6WH130, 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 1WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WSO-POD-PRT-FL
POD_PRT_FL
Alpha 1WH130, 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 3WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WSO-TO-ISO-CTRY
TO_ISO_CTRY
Numeric 3WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WSO-BILL-CTRY-CD
BILL_CTRY_CD
Alpha 2WH130, 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 3WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WSO-BILL-ISO-CTRY
BILL_ISO_CTRY
Numeric 3WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more

Indexes (3)

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

IndexKeysFlagsConditionUsed in
WSOSET1COMPANY, LOCATION, SHIPMENT-NBR, CREATION-DATE, CREATION-TIMEPrimaryWH330
WSOSET2COMPANY, LOCATION, INTERFACE-STS, SHIPMENT-NBR, CREATION-DATE, CREATION-TIME
WSOSET3COMPANY, LOCATION, BATCH-NBR, SHIPMENT-NBR

Programs

Updated by (33)