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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#OEA-COMPANY PK
COMPANY		Numeric 4This field contains the company number.WH20.7
#OEA-ORDER-NBR PK
ORDER_NBR		Numeric 8This field contains the order number.WH20.7
#OEA-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the number of the line.WH20.7
#OEA-FLD-NBR PK
FLD_NBR		Numeric 4This 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 6This field contains the system time when the record was updated.WH20.7
#OEA-BEFORE-IMAGE
BEFORE_IMAGE		Alpha 32This field contains the field image before the change.WH20.7
#OEA-AFTER-IMAGE
AFTER_IMAGE		Alpha 32This 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 5This 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 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
OEASET1
  1. COMPANY
  2. ORDER-NBR
  3. LINE-NBR
  4. FLD-NBR
  5. UPDATE-DATE
  6. UPDATE-TIME
Primary—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
COLINECUSTORDEROECOMPANYOEPROCLEVOPERATOROEAUDIT

One to one (5) — lookups and parents

RelationTableRulesConditionField map
ColineCOLINERequiredWhen OEA-LINE-NBR != Zeroes
OEA-COMPANY→COL-COMPANY
OEA-ORDER-NBR→COL-ORDER-NBR
OEA-LINE-NBR→COL-LINE-NBR
CustorderCUSTORDERRequired
OEA-COMPANY→COR-COMPANY
OEA-ORDER-NBR→COR-ORDER-NBR
OecompanyOECOMPANYRequired
OEA-COMPANY→OEC-COMPANY
OeproclevOEPROCLEVRequired
OEA-COMPANY→OEP-COMPANY
OEA-PROCESS-LEVEL→OEP-PROCESS-LEVEL
OperatorOPERATORRequired
OEA-COMPANY→OPE-DEF-COMPANY
OEA-OPR-CODE→OPE-OPR-CODE

Programs

Updated by (1)