Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEAUDIT


                              OEAUDIT FILE

                           Order Entry Audit

The Order Entry Audit file audits changes made to an order by a user.

UPDATED BY

BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.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
                                                                 WH20.7

OEA-ORDER-NBR          Numeric 8                                 BL120   BL122
Element: Order Nbr     This field contains the order number.     BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OEA-LINE-NBR           Numeric 6                                 BL120   BL122
Element: Line Nbr      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
                                                                 WH20.7

OEA-FLD-NBR            Numeric 4                                 BL120   BL122
Element: Fld Nbr       This field contains the dictionary        BL130   BL20.1
                       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                        WH20.7
                       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)                     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
                                                                 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
                                                                 WH20.7

OEA-BEFORE-IMAGE       Alpha 32                                  BL120   BL122
Element: Before Image  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
                                                                 WH20.7

OEA-AFTER-IMAGE        Alpha 32                                  BL120   BL122
Element: Before Image  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
                                                                 WH20.7

OEA-OPR-CODE           Alpha 10  (Lower Case)                    BL120   BL122
Element: Opr 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
                                                                 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
                                                                 WH20.7

OEA-CUSTOMER           Alpha 9  (Right Justified)                BL120   BL122
Element: Customer      This 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
                                                                 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       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