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.

REFERENCED BY

OE210

UPDATED BY

BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     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     OE111     OE113     OE114     OE116     OE129
OE13.2    OE13.3    OE13.5    OE13.6    OE14.4    OE30.1
OE30.2    OE30.3    OE30.4    OE30.5    OE30.6    OE30.7
OE30.9    OE310     OE510     OE530     OE810     OE830
OE90.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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   OE90.1
                                                                 WH20.7

OEA-ORDER-NBR          Numeric 8                                 BL120   BL122
Element: Order Number  This field contains the order number.     BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   OE90.1
                                                                 WH20.7

OEA-LINE-NBR           Numeric 6                                 BL120   BL122
Element: Line Number   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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   OE90.1
                                                                 WH20.7

OEA-FLD-NBR            Numeric 4                                 BL120   BL122
Dictionary Field       This field contains the dictionary        BL130   BL20.1
Number                 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                        OE10.1  OE10.2
                       0040 = Letter Of Credit                   OE10.3  OE10.4
                       0050 = Bill Name                          OE10.5  OE10.6
                       0060 = Bill Addr 1                        OE10.7  OE10.8
                       0070 = Bill Addr 2                        OE11.1  OE11.4
                       0080 = Bill Addr 3                        OE11.8  OE11.9
                       0090 = Bill Addr 4                        OE110   OE111
                       0100 = Bill City                          OE113   OE114
                       0110 = Bill State                         OE116   OE129
                       0120 = Bill Zip                           OE13.2  OE13.3
                       0130 = Bill Country                       OE13.5  OE13.6
                       0140 = Exp Ship Date                      OE14.4  OE30.1
                       0150 = Request Date                       OE30.2  OE30.3
                       0160 = Tax Exempt Code                    OE30.4  OE30.5
                       0170 = Ship To                            OE30.6  OE30.7
                       0180 = Ship To Name                       OE30.9  OE510
                       0190 = Ship To Addr 1                     OE530   OE810
                       0200 = Ship To Addr 2                     OE830   OE90.1
                       0210 = Ship To Addr 3                     WH20.7
                       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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   OE90.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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   OE90.1
                                                                 WH20.7

OEA-BEFORE-IMAGE       Alpha 32                                  BL120   BL122
Element: Before Change 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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   OE90.1
                                                                 WH20.7

OEA-AFTER-IMAGE        Alpha 32                                  BL120   BL122
Element: Before Change This field contains the field image       BL130   BL20.1
                       after the change.                         BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   OE90.1
                                                                 WH20.7

OEA-OPR-CODE           Alpha 10  (Lower Case)                    BL120   BL122
Element: Operator 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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   OE90.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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   OE90.1
                                                                 WH20.7

OEA-CUSTOMER           Alpha 9  (Right Justified)                BL120   BL122
Element: Customer NumbeThis 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
                                                                 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   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   OE90.1
                                                                 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