OEAUDIT

Order Entry Audit

The Order Entry Audit file audits changes made to an order by a user.
UPDATED BY
WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEA-COMPANY
Element: Company
Numeric 4
This field contains the company number.
WH20.7
OEA-ORDER-NBR
Element: Order Nbr
Numeric 8
This field contains the order number.
WH20.7
OEA-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the number of the line.
WH20.7
OEA-FLD-NBR
Element: Fld Nbr
Numeric 4
This 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
Element: Update Date
Numeric 8 (yyyymmdd)
This field contains the date the record was updated.
WH20.7
OEA-UPDATE-TIME
Element: Update Time
Numeric 6
This field contains the system time when the record was updated.
WH20.7
OEA-BEFORE-IMAGE
Element: Before Image
Alpha 32
This field contains the field image before the change.
WH20.7
OEA-AFTER-IMAGE
Element: Before Image
Alpha 32
This field contains the field image before the change.
WH20.7
OEA-OPR-CODE
Element: 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
Element: Process Level
Alpha 5
This field contains the process level.
WH20.7
OEA-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
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
NAME
RELATED 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


File created: Thu Jun 09 02:24:29 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.