Lawson Insight Technical Documentation |
|
OEAUDIT
OEAUDIT FILE
Order Entry Audit
The Order Entry Audit file audits changes made to an order by a user.
UPDATED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEA-COMPANY Numeric 4 BL120 BL122
Element: Company This field contains the company number. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEA-ORDER-NBR Numeric 8 BL120 BL122
Element: Order Nbr This field contains the order number. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEA-LINE-NBR Numeric 6 BL120 BL122
Element: Line Nbr This field contains the number of the BL130 BL20.1
line. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEA-FLD-NBR Numeric 4 BL120 BL122
Element: Fld Nbr This field contains the dictionary BL130 BL20.1
field number of the field that was BL20.3 BL21.2
changed. BL21.5 BL29.1
0010 = Order Type BL29.2 BL520
0020 = Price Date BL820 BL92.1
0030 = Cust PO Nbr WH20.7
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
OEA-UPDATE-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Update Date This field contains the date the record BL130 BL20.1
was updated. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEA-UPDATE-TIME Numeric 6 BL120 BL122
Element: Update Time This field contains the system time BL130 BL20.1
when the record was updated. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEA-BEFORE-IMAGE Alpha 32 BL120 BL122
Element: Before Image This field contains the field image BL130 BL20.1
before the change. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEA-AFTER-IMAGE Alpha 32 BL120 BL122
Element: Before Image This field contains the field image BL130 BL20.1
before the change. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEA-OPR-CODE Alpha 10 (Lower Case) BL120 BL122
Element: Opr Code This field contains the operator code. BL130 BL20.1
This is the user ID of the person who BL20.3 BL21.2
last maintained this record. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEA-PROCESS-LEVEL Alpha 5 BL120 BL122
Element: Process Level This field contains the process level. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEA-CUSTOMER Alpha 9 (Right Justified) BL120 BL122
Element: Customer This field contains the number that BL130 BL20.1
represents a customer. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OEASET1 COMPANY
ORDER-NBR
LINE-NBR
FLD-NBR
UPDATE-DATE
UPDATE-TIME
OEAUDIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|