Lawson Insight Technical Documentation |
|
OEAUDIT
OEAUDIT FILE
Order Entry Audit
The Order Entry Audit file audits changes made to an order by a user.
REFERENCED BY
OE210
UPDATED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE111 OE113 OE114 OE116 OE129
OE13.2 OE13.3 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE310 OE510 OE530 OE810 OE830
OE90.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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.1
WH20.7
OEA-ORDER-NBR Numeric 8 BL120 BL122
Element: Order Number This field contains the order number. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.1
WH20.7
OEA-LINE-NBR Numeric 6 BL120 BL122
Element: Line Number 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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.1
WH20.7
OEA-FLD-NBR Numeric 4 BL120 BL122
Dictionary Field This field contains the dictionary BL130 BL20.1
Number 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 OE10.1 OE10.2
0040 = Letter Of Credit OE10.3 OE10.4
0050 = Bill Name OE10.5 OE10.6
0060 = Bill Addr 1 OE10.7 OE10.8
0070 = Bill Addr 2 OE11.1 OE11.4
0080 = Bill Addr 3 OE11.8 OE11.9
0090 = Bill Addr 4 OE110 OE111
0100 = Bill City OE113 OE114
0110 = Bill State OE116 OE129
0120 = Bill Zip OE13.2 OE13.3
0130 = Bill Country OE13.5 OE13.6
0140 = Exp Ship Date OE14.4 OE30.1
0150 = Request Date OE30.2 OE30.3
0160 = Tax Exempt Code OE30.4 OE30.5
0170 = Ship To OE30.6 OE30.7
0180 = Ship To Name OE30.9 OE510
0190 = Ship To Addr 1 OE530 OE810
0200 = Ship To Addr 2 OE830 OE90.1
0210 = Ship To Addr 3 WH20.7
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.1
WH20.7
OEA-BEFORE-IMAGE Alpha 32 BL120 BL122
Element: Before Change 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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.1
WH20.7
OEA-AFTER-IMAGE Alpha 32 BL120 BL122
Element: Before Change This field contains the field image BL130 BL20.1
after the change. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.1
WH20.7
OEA-OPR-CODE Alpha 10 (Lower Case) BL120 BL122
Element: Operator 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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.1
WH20.7
OEA-CUSTOMER Alpha 9 (Right Justified) BL120 BL122
Element: Customer NumbeThis 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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 OE90.1
WH20.7
OEAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OEASET1 COMPANY OE210 OE310
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
|