OEAUDIT – Order Entry Audit

System: OE (OE)
Prefix: OEA
Primary key: COMPANY, ORDER-NBR, LINE-NBR, FLD-NBR, UPDATE-DATE, UPDATE-TIME
Fields: 11
Updated by: 1 program
Referenced by: 0 programs

OEAUDIT is the Order Entry Audit table in Lawson OE (prefix OEA). It is indexed by COMPANY, ORDER-NBR, LINE-NBR, FLD-NBR, UPDATE-DATE, UPDATE-TIME (OEASET1). It is related 1:1 to COLINE, CUSTORDER, OECOMPANY, OEPROCLEV and OPERATOR. It is updated by WH20.7. The table has 11 fields, 1 index and 5 documented relations.

About OEAUDIT

No description in the Lawson data dictionary.

Fields (11)

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

Field / column	Type	Description & values	Updated by
`OEA-COMPANY` PK COMPANY	Numeric 4	This field contains the company number.	WH20.7
`OEA-ORDER-NBR` PK ORDER_NBR	Numeric 8	This field contains the order number.	WH20.7
`OEA-LINE-NBR` PK LINE_NBR	Numeric 6	This field contains the number of the line.	WH20.7
`OEA-FLD-NBR` PK FLD_NBR	Numeric 4	This field contains the dictionary field number of the field that was changed. `0010` Order Type `0020` Price Date `0030` Cust PO Nbr `0040` Letter Of Credit `0050` Bill Name `0060` Bill Addr 1 `0070` Bill Addr 2 `0080` Bill Addr 3 `0090` Bill Addr 4 `0100` Bill City `0110` Bill State `0120` Bill Zip `0130` Bill Country `0140` Exp Ship Date `0150` Request Date `0160` Tax Exempt Code `0170` Ship To `0180` Ship To Name `0190` Ship To Addr 1 `0200` Ship To Addr 2 `0210` Ship To Addr 3 `0220` Ship To Addr 4 `0230` Ship To City `0240` Ship To State `0250` Ship To Zip `0260` Ship To Country `0270` Hold Code `0280` Hold Approval Flag `0290` Location `0300` Territory `0310` Salesman `0320` Salesman 2 `0330` Commission Split `0340` Commission Rate `0350` Commission Rate 2 `0360` Credit Card Type `0370` Credit Card Number `0380` Credit Card Expiration Date `0390` Terms Code `0400` COD Flag `0410` Cash In Advance Flag `0420` Cash In Advance Percent `0430` Entered Payment `0440` Entered Discount `0450` Tax Code `0460` Tax Date `0470` Vertex Code `0480` Order Source `0490` Freight Code `0500` Freight Charge `0510` Carrier `0520` Method `0530` Transport Id `0540` Pick Priority `0550` Ship Immediate Flag `0560` Acknowledgement Flag `0570` Back Order Flag `0580` Ship Complete Flag `0590` User Date 1 `0600` User Date 2 `0610` Trans User 1 `0620` Trans User 2 `0630` Trans User 3 `0640` Trans User 4 `0650` Trans User 5 `0660` Sales Quote Flag `0670` Future Flag `0680` POD Required Flag `0690` POD Grace Period `0700` Currency Code `0710` Currency Rate `0720` Currency Rate Freeze Code `0730` Pricing UOM `0740` Selling UOM `0750` Secondary UOM `0760` No Charge Flag `0770` Entered Price `0780` Unit Cost `0790` Create PO Flag `0800` Drop Ship Flag `0810` PO Number `0815` PO Code `0820` Vendor `0830` Route `0840` Stop `0850` Taxable Amount `0860` Override Taxable Amount `0870` Early Delivery Date `0880` Late Delivery Date `0890` User Date 3 `0900` User Date 4 `0910` User Field 1 `0920` User Field 2 `0930` User Field 3 `0940` Order Quantity `0950` MSDS Required Flag	WH20.7
`OEA-UPDATE-DATE` PK UPDATE_DATE	Numeric 8 (yyyymmdd)	This field contains the date the record was updated.	WH20.7
`OEA-UPDATE-TIME` PK UPDATE_TIME	Numeric 6	This field contains the system time when the record was updated.	WH20.7
`OEA-BEFORE-IMAGE` BEFORE_IMAGE	Alpha 32	This field contains the field image before the change.	WH20.7
`OEA-AFTER-IMAGE` AFTER_IMAGE	Alpha 32	This field contains the field image before the change.	WH20.7
`OEA-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.	WH20.7
`OEA-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	This field contains the process level.	WH20.7
`OEA-CUSTOMER` CUSTOMER	Alpha 9 (Right Justified)	This field contains the number that represents a customer.	WH20.7

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
`OEASET1`	`COMPANY`, `ORDER-NBR`, `LINE-NBR`, `FLD-NBR`, `UPDATE-DATE`, `UPDATE-TIME`	Primary		—

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Condition	Field map
Coline	COLINE	Required	When OEA-LINE-NBR != Zeroes	`OEA-COMPANY` → `COL-COMPANY`, `OEA-ORDER-NBR` → `COL-ORDER-NBR`, `OEA-LINE-NBR` → `COL-LINE-NBR`
Custorder	CUSTORDER	Required		`OEA-COMPANY` → `COR-COMPANY`, `OEA-ORDER-NBR` → `COR-ORDER-NBR`
Oecompany	OECOMPANY	Required		`OEA-COMPANY` → `OEC-COMPANY`
Oeproclev	OEPROCLEV	Required		`OEA-COMPANY` → `OEP-COMPANY`, `OEA-PROCESS-LEVEL` → `OEP-PROCESS-LEVEL`
Operator	OPERATOR	Required		`OEA-COMPANY` → `OPE-DEF-COMPANY`, `OEA-OPR-CODE` → `OPE-OPR-CODE`

Programs

Updated by (1)

WH20.7 Substitute Location