OEAUDIT FILE
Order Entry Audit
The Order Entry Audit file audits changes made to an order by a user.
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEA-COMPANY Numeric 4
Company This field contains the company number.
OEA-ORDER-NBR Numeric 8
Order Number This field contains the order number.
OEA-LINE-NBR Numeric 6
Line Number This field contains the number of the
line.
OEA-FLD-NBR Numeric 4
Dictionary Field This field contains the dictionary
Number 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
OEA-UPDATE-DATE Numeric 8 (yyyymmdd)
Update Date This field contains the date the record
was updated.
OEA-UPDATE-TIME Numeric 6
Update Time This field contains the system time
when the record was updated.
OEA-BEFORE-IMAGE Alpha 32
Before Change Image This field contains the field image
before the change.
OEA-AFTER-IMAGE Alpha 32
After Change Image This field contains the field image
after the change.
OEA-OPR-CODE Alpha 10 (Lower Case)
Operator Code This field contains the operator code.
This is the user ID of the person who
last maintained this record.
OEA-PROCESS-LEVEL Alpha 5
Process Level This field contains the process level.
OEA-CUSTOMER Alpha 9 (Right Justified)
Customer Number This field contains the number that
represents a customer.
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
|
