Lawson Insight Technical Documentation |
|
WHDVAUDIT
WHDVAUDIT FILE
UPDATED BY
POD0.1 POD1.1 RQD0.1 RQD1.1 WH440 WHD0.1
WHD1.1 WHD2.1 WHD3.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHV-PROGRAM Alpha 5 POD0.1 POD1.1
Element: Program This field designates the program this RQD0.1 RQD1.1
record was created by WH440 WHD0.1
WHD1.1 WHD2.1
WHD3.1
WHV-REPORT-NAME Alpha 10 POD0.1 POD1.1
Element: Job Name RQD0.1 RQD1.1
WH440 WHD0.1
WHD1.1 WHD2.1
WHD3.1
WHV-RECORD-NUMBER Numeric 7 POD0.1 POD1.1
Element: Record Number This is the ASCII file record number. RQD0.1 RQD1.1
WH440 WHD0.1
WHD1.1 WHD2.1
WHD3.1
WHV-ACTION Alpha 1 POD0.1 POD1.1
Element: Action C RQD0.1 RQD1.1
D WH440 WHD0.1
A WHD1.1 WHD2.1
R WHD3.1
U
E
F
WHV-TABLE Alpha 10 POD0.1 POD1.1
Element: Table RQD0.1 RQD1.1
WHD0.1 WHD1.1
WHD2.1 WHD3.1
WHV-UPDATE-DATE Numeric 8 (yyyymmdd) POD0.1 POD1.1
Element: Update Date This field contains the date the record RQD0.1 RQD1.1
was updated. WH440 WHD0.1
WHD1.1 WHD2.1
WHD3.1
WHV-UPDATE-TIME Numeric 6 POD0.1 POD1.1
Element: Update Time This field contains the system time RQD0.1 RQD1.1
when the record was updated. WH440 WHD0.1
WHD1.1 WHD2.1
WHD3.1
WHV-OPR-CODE Alpha 10 POD0.1 POD1.1
Element: Operator This field is used to store the login RQD0.1 RQD1.1
id of the person who entered the record. WH440 WHD0.1
WHD1.1 WHD2.1
WHD3.1
WHV-FIELD-NAME Alpha 20 (Lower Case) POD0.1 POD1.1
Element: Field Name RQD0.1 RQD1.1
WHD0.1 WHD1.1
WHD2.1 WHD3.1
WHV-BEFORE-IMAGE Alpha 32 POD0.1 POD1.1
Element: Before Image This field contains the field image RQD0.1 RQD1.1
before the change. WHD0.1 WHD2.1
WHD3.1
WHV-AFTER-IMAGE Alpha 32 POD0.1 POD1.1
Element: Before Image This field contains the field image RQD0.1 RQD1.1
before the change. WHD0.1 WHD1.1
WHD2.1 WHD3.1
WHV-COMPANY Numeric 4 POD0.1 POD1.1
Element: Company Identifies the AP company if the RQD0.1 RQD1.1
resource type = V. Identifies the HR WH440 WHD0.1
company if the resource type = E. It is WHD1.1 WHD2.1
blank for type A, P or Q resources. WHD3.1
WHV-LOCATION Alpha 5 POD0.1 POD1.1
Element: Location This field contains a valid stocking RQD0.1 RQD1.1
location within the company inventory. WHD0.1 WHD1.1
WHD2.1 WHD3.1
WHV-ITEM Alpha 32 POD0.1 POD1.1
Element: Item This field contains the item RQD0.1 RQD1.1
identifier. WHD0.1 WHD1.1
WHD2.1 WHD3.1
WHV-DOC-NUMBER Alpha 14 (Right Justified) POD0.1 POD1.1
Element: Doc Number RQD0.1 RQD1.1
WHD0.1 WHD1.1
WHD2.1 WHD3.1
WHV-DOC-TYPE Alpha 2 POD0.1 POD1.1
Element: Doc Type This field contains the type of RQD0.1 RQD1.1
transaction. WHD0.1 WHD2.1
WHD3.1
WHV-LINE-NBR Numeric 6 POD0.1 POD1.1
Element: Line Nbr This field contains the line number. RQD0.1 RQD1.1
WHD0.1 WHD1.1
WHD2.1 WHD3.1
WHV-SEQ Numeric 3 POD0.1 POD1.1
Element: Seq This field contains the record sequence RQD0.1 RQD1.1
number. WHD0.1 WHD2.1
WHD3.1
WHV-BIN Alpha 7 POD0.1 RQD0.1
Element: Bin This field contains a storage area for RQD1.1 WHD0.1
an item or any number of items. WHD2.1 WHD3.1
WHV-LOT Alpha 10 POD0.1 RQD0.1
Element: Lot This field contains the identifier for WHD0.1 WHD2.1
the homogeneous quantity of material. WHD3.1
WHV-SUBLOT Alpha 6 POD0.1 RQD0.1
Element: Sublot This field contains the identifier for WHD0.1 WHD2.1
a detail breakdown of a lot number. WHD3.1
WHV-SERIAL Alpha 16 POD0.1 RQD0.1
Element: Serial WHD0.1 WHD2.1
WHD3.1
WHV-UOM Alpha 4 POD0.1 POD1.1
Element: Uom This field contains the valid stock RQD0.1 RQD1.1
unit of measure for this item. WHD0.1 WHD2.1
WHD3.1
WHV-QUANTITY Signed 13.4 POD0.1 POD1.1
Element: Quantity This field contains the desired RQD0.1 RQD1.1
quantity. WHD0.1 WHD2.1
WHD3.1
WHV-AGREEMENT-REF Alpha 30 POD0.1
Element: Agreement Ref
WHV-PROC-GROUP Alpha 10 POD0.1 RQD0.1
Element: Proc Group Contains the processing group (head
process level).The processing group
identifies a group of process levels.
WHV-PO-NBR Alpha 14 POD0.1 POD1.1
Element: Po Nbr 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.
WHV-PO-RELEASE Numeric 4 POD0.1 POD1.1
Element: Po Release Used to identify a purchase order
release (created from a Blanket or
Standing order).
WHV-PO-CODE Alpha 4 POD0.1 POD1.1
Element: Po Code This is the purchase order code. RQD0.1
WHV-SHIPMENT-NBR Numeric 10 POD0.1 WHD0.1
Element: Shipment Nbr This field contains the shipment WHD2.1 WHD3.1
number. One order can have several
shipment numbers if the items of the
order were not shipped at the same time.
WHV-RECORD-TYPE Alpha 1 POD0.1 POD1.1
Element: Record Type This field identifies the type of RQD0.1 RQD1.1
record defined. WHD0.1 WHD1.1
WHD2.1 WHD3.1
Valid values are:
S = Summary
D = Detail
WHDVAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WHVSET1 COMPANY WH440
UPDATE-DATE
UPDATE-TIME
REPORT-NAME
PROGRAM
RECORD-NUMBER
|