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. |
|
||
OEA-ORDER-NBR Element: Order Nbr | Numeric 8 This field contains the order number. |
|
||
OEA-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the number of the line. |
|
||
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 |
|
||
OEA-UPDATE-DATE Element: Update Date | Numeric 8 (yyyymmdd) This field contains the date the record was updated. |
|
||
OEA-UPDATE-TIME Element: Update Time | Numeric 6 This field contains the system time when the record was updated. |
|
||
OEA-BEFORE-IMAGE Element: Before Image | Alpha 32 This field contains the field image before the change. |
|
||
OEA-AFTER-IMAGE Element: Before Image | Alpha 32 This field contains the field image before the change. |
|
||
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. |
|
||
OEA-PROCESS-LEVEL Element: Process Level | Alpha 5 This field contains the process level. |
|
||
OEA-CUSTOMER Element: Customer | Alpha 9 (Right Justified) This field contains the number that represents a customer. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | |||||||
---|---|---|---|---|---|---|---|---|---|---|
OEASET1 |
COMPANY ORDER-NBR LINE-NBR FLD-NBR UPDATE-DATE UPDATE-TIME |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Coline | COLINE |
Required
| |||||||||||||||
Custorder | CUSTORDER |
Required
| |||||||||||||||
Oecompany | OECOMPANY |
Required
| |||||||||||||||
Oeproclev | OEPROCLEV |
Required
| |||||||||||||||
Operator | OPERATOR |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.