OEAUDIT FILE
Order Entry Audit
The Order Entry Audit file audits changes made to an order by a user.
REFERENCED BY
OE210
UPDATED BY
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 OE113 OE114 OE129 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE310 OE510 OE810 OE90.1 OE920 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEA-COMPANY Numeric 4 BL92.1 OE10.1
Company This field contains the company number. OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.1 OE920
WH20.7
OEA-ORDER-NBR Numeric 8 BL92.1 OE10.1
Order Number This field contains the order number. OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.1 OE920
WH20.7
OEA-LINE-NBR Numeric 6 BL92.1 OE10.1
Line Number This field contains the number of the OE10.2 OE10.3
line. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.1 OE920
WH20.7
OEA-FLD-NBR Numeric 4 BL92.1 OE10.1
Field Number This field contains the dictionary OE10.2 OE10.3
field number of the field that was OE10.4 OE10.5
changed. OE10.6 OE10.7
0010 = Order Type OE10.8 OE11.1
0020 = Price Date OE11.4 OE11.8
0030 = Cust PO Nbr OE11.9 OE110
0040 = Letter Of Credit OE113 OE114
0050 = Bill Name OE129 OE14.4
0060 = Bill Addr 1 OE15.1 OE15.2
0070 = Bill Addr 2 OE15.3 OE15.4
0080 = Bill Addr 3 OE15.5 OE15.7
0090 = Bill Addr 4 OE510 OE810
0100 = Bill City OE90.1 OE920
0110 = Bill State WH20.7
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
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
0960 = Product Tax Category
OEA-UPDATE-DATE Numeric 8 (yyyymmdd) BL92.1 OE10.1
Update Date This field contains the date the record OE10.2 OE10.3
was updated. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.1 OE920
WH20.7
OEA-UPDATE-TIME Numeric 6 BL92.1 OE10.1
Update Time This field contains the system time OE10.2 OE10.3
when the record was updated. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.1 OE920
WH20.7
OEA-BEFORE-IMAGE Alpha 32 BL92.1 OE10.1
Before Image This field contains the field image OE10.2 OE10.3
before the change. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.1 OE920
WH20.7
OEA-AFTER-IMAGE Alpha 32 BL92.1 OE10.1
After Image This field contains the field image OE10.2 OE10.3
after the change. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.1 OE920
WH20.7
OEA-OPR-CODE Alpha 10 (Lower Case) BL92.1 OE10.1
Operator Code This field contains the operator code. OE10.2 OE10.3
This is the user ID of the person who OE10.4 OE10.5
last maintained this record. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.1 OE920
WH20.7
OEA-PROCESS-LEVEL Alpha 5 BL92.1 OE10.1
Process Level This field contains the process level. OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.1 OE920
WH20.7
OEA-CUSTOMER Alpha 9 (Right Justified) BL92.1 OE10.1
Customer This field contains the number that OE10.2 OE10.3
represents a customer. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.1 OE920
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
|