WHDVAUDIT – No description in the Lawson data dictionary

System: Warehouse (WH)
Prefix: WHV
Primary key: COMPANY, UPDATE-DATE, UPDATE-TIME, REPORT-NAME, PROGRAM, RECORD-NUMBER
Fields: 31
Updated by: 9 programs
Referenced by: 0 programs

WHDVAUDIT is a Lawson Warehouse table (prefix WHV); no description in the lawson data dictionary. It is indexed by COMPANY, UPDATE-DATE, UPDATE-TIME, REPORT-NAME, PROGRAM, RECORD-NUMBER (WHVSET1). It is updated by POD0.1, POD1.1, RQD0.1, RQD1.1, WH440, WHD0.1, WHD1.1, WHD2.1 and 1 more. The table has 31 fields, 1 index and 0 documented relations.

About WHDVAUDIT

No description in the Lawson data dictionary.

Fields (31)

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

Field / column	Type	Description & values	Updated by
`WHV-PROGRAM` PK PROGRAM	Alpha 5	This field designates the program this record was created by	POD0.1, POD1.1, RQD0.1, RQD1.1, WH440, WHD0.1, WHD1.1, WHD2.1 +1 more
`WHV-REPORT-NAME` PK REPORT_NAME	Alpha 10	—	POD0.1, POD1.1, RQD0.1, RQD1.1, WH440, WHD0.1, WHD1.1, WHD2.1 +1 more
`WHV-RECORD-NUMBER` PK RECORD_NUMBER	Numeric 7	This is the ASCII file record number.	POD0.1, POD1.1, RQD0.1, RQD1.1, WH440, WHD0.1, WHD1.1, WHD2.1 +1 more
`WHV-ACTION` ACTION	Alpha 1	C D A R U E F	POD0.1, POD1.1, RQD0.1, RQD1.1, WH440, WHD0.1, WHD1.1, WHD2.1 +1 more
`WHV-TABLE` TABLE	Alpha 10	—	POD0.1, POD1.1, RQD0.1, RQD1.1, WHD0.1, WHD1.1, WHD2.1, WHD3.1
`WHV-UPDATE-DATE` PK UPDATE_DATE	Numeric 8 (yyyymmdd)	This field contains the date the record was updated.	POD0.1, POD1.1, RQD0.1, RQD1.1, WH440, WHD0.1, WHD1.1, WHD2.1 +1 more
`WHV-UPDATE-TIME` PK UPDATE_TIME	Numeric 6	This field contains the system time when the record was updated.	POD0.1, POD1.1, RQD0.1, RQD1.1, WH440, WHD0.1, WHD1.1, WHD2.1 +1 more
`WHV-OPR-CODE` OPR_CODE	Alpha 10	This field is used to store the login id of the person who entered the record.	POD0.1, POD1.1, RQD0.1, RQD1.1, WH440, WHD0.1, WHD1.1, WHD2.1 +1 more
`WHV-FIELD-NAME` FIELD_NAME	Alpha 20 (Lower Case)	—	POD0.1, POD1.1, RQD0.1, RQD1.1, WHD0.1, WHD1.1, WHD2.1, WHD3.1
`WHV-BEFORE-IMAGE` BEFORE_IMAGE	Alpha 32	This field contains the field image before the change.	POD0.1, POD1.1, RQD0.1, RQD1.1, WHD0.1, WHD2.1, WHD3.1
`WHV-AFTER-IMAGE` AFTER_IMAGE	Alpha 32	This field contains the field image before the change.	POD0.1, POD1.1, RQD0.1, RQD1.1, WHD0.1, WHD1.1, WHD2.1, WHD3.1
`WHV-COMPANY` PK COMPANY	Numeric 4	Identifies 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.	POD0.1, POD1.1, RQD0.1, RQD1.1, WH440, WHD0.1, WHD1.1, WHD2.1 +1 more
`WHV-LOCATION` LOCATION	Alpha 5	This field contains a valid stocking location within the company inventory.	POD0.1, POD1.1, RQD0.1, RQD1.1, WHD0.1, WHD1.1, WHD2.1, WHD3.1
`WHV-ITEM` ITEM	Alpha 32	This field contains the item identifier.	POD0.1, POD1.1, RQD0.1, RQD1.1, WHD0.1, WHD1.1, WHD2.1, WHD3.1
`WHV-DOC-NUMBER` DOC_NUMBER	Alpha 14 (Right Justified)	—	POD0.1, POD1.1, RQD0.1, RQD1.1, WHD0.1, WHD1.1, WHD2.1, WHD3.1
`WHV-DOC-TYPE` DOC_TYPE	Alpha 2	This field contains the type of transaction.	POD0.1, POD1.1, RQD0.1, RQD1.1, WHD0.1, WHD2.1, WHD3.1
`WHV-LINE-NBR` LINE_NBR	Numeric 6	This field contains the line number.	POD0.1, POD1.1, RQD0.1, RQD1.1, WHD0.1, WHD1.1, WHD2.1, WHD3.1
`WHV-SEQ` SEQ	Numeric 3	This field contains the record sequence number.	POD0.1, POD1.1, RQD0.1, RQD1.1, WHD0.1, WHD2.1, WHD3.1
`WHV-BIN` BIN	Alpha 7	This field contains a storage area for an item or any number of items.	POD0.1, RQD0.1, RQD1.1, WHD0.1, WHD2.1, WHD3.1
`WHV-LOT` LOT	Alpha 10	This field contains the identifier for the homogeneous quantity of material.	POD0.1, RQD0.1, WHD0.1, WHD2.1, WHD3.1
`WHV-SUBLOT` SUBLOT	Alpha 6	This field contains the identifier for a detail breakdown of a lot number.	POD0.1, RQD0.1, WHD0.1, WHD2.1, WHD3.1
`WHV-SERIAL` SERIAL	Alpha 16	—	POD0.1, RQD0.1, WHD0.1, WHD2.1, WHD3.1
`WHV-UOM` UOM	Alpha 4	This field contains the valid stock unit of measure for this item.	POD0.1, POD1.1, RQD0.1, RQD1.1, WHD0.1, WHD2.1, WHD3.1
`WHV-QUANTITY` QUANTITY	Signed 13.4	This field contains the desired quantity.	POD0.1, POD1.1, RQD0.1, RQD1.1, WHD0.1, WHD2.1, WHD3.1
`WHV-AGREEMENT-REF` AGREEMENT_REF	Alpha 30	—	POD0.1
`WHV-PROC-GROUP` PROC_GROUP	Alpha 10	Contains the processing group (head process level).The processing group identifies a group of process levels.	POD0.1, RQD0.1
`WHV-PO-NBR` PO_NBR	Alpha 14	The purchase order number field is an optional field for your reference. It is assumed to contain the original purchase order number on which this asset was included.	POD0.1, POD1.1
`WHV-PO-RELEASE` PO_RELEASE	Numeric 4	Used to identify a purchase order release (created from a Blanket or Standing order).	POD0.1, POD1.1
`WHV-PO-CODE` PO_CODE	Alpha 4	This is the purchase order code.	POD0.1, POD1.1, RQD0.1
`WHV-SHIPMENT-NBR` SHIPMENT_NBR	Numeric 10	This 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.	POD0.1, WHD0.1, WHD2.1, WHD3.1
`WHV-RECORD-TYPE` RECORD_TYPE	Alpha 1	This field identifies the type of record defined. Valid values are: `S` Summary `D` Detail	POD0.1, POD1.1, RQD0.1, RQD1.1, WHD0.1, WHD1.1, WHD2.1, WHD3.1

Indexes (1)

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
`WHVSET1`	`COMPANY`, `UPDATE-DATE`, `UPDATE-TIME`, `REPORT-NAME`, `PROGRAM`, `RECORD-NUMBER`	Primary		WH440

Programs

Updated by (9)

POD0.1 Po Orphan Record Check
POD1.1 Po Document Integrity Check
RQD0.1 Invoke for RQ Orphan Check
RQD1.1 Invoke for RQ Integrity Check
WH440 Data Verification Audit Report
WHD0.1 WH Orphan Record Check
WHD1.1 WH Document Integrity Check
WHD2.1 WH-IC Integrity Check
WHD3.1 WH-IC Detail Integrity Check