Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEDIST


                              OEDIST FILE

                      Order Entry GL Distribution

This file stores all the records that will create the journal entries created
when the orders are finally invoiced.

REFERENCED BY

BL293     TX101

UPDATED BY

BL123     BL199

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ODI-COMPANY            Numeric 4                                 BL123
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

ODI-GLT-OBJ-ID         Numeric 12                                BL123
Element: Obj Id        This is a subsystem General Ledger
                       interface identification number. It is
                       used for Drill Around purposes.

ODI-ATN-OBJ-ID         Numeric 12                                BL123
Element: Obj Id        Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity. Activities and
                       cost object activities are used
                       synonymously in the Activity Management
                       system. Direct costs are posted to
                       activities, and indirect costs are
                       allocated to activities based on
                       activity drivers.

                       Activities are grouped or organized by
                       activity levels. There are two types of
                       activities: "posting allowed" and
                       "summary only." Use posting level
                       activities to budget and maintain all
                       posted transactions. Summary activities
                       or macro activities combine information
                       and balances from lower level activities
                       for reporting and inquiries.

ODI-PROCESS-LEVEL      Alpha 5                                   BL123
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

ODI-GL-DATE            Numeric 8  (yyyymmdd)                     BL123
Element: Gl Date       The general ledger posting date for
                       this particular journal entry.

ODI-ACCT-UNIT          Alpha 15                                  BL123
Element: Acct Unit     This is the accounting unit that will
                       be debited or credited in general ledger
                       when this journal entry distribution is
                       interfaced into the General Ledger
                       system.

ODI-ACCOUNT            Numeric 6                                 BL123
Element: Account       This field indicates the general ledger
                       account number that will be debited or
                       credited when this journal entry
                       distribution is interfaced into the
                       General Ledger system.

ODI-SUB-ACCOUNT        Numeric 4                                 BL123
Element: Sub Acct      This is the general ledger subaccount
                       number that will be debited or credited
                       when this journal entry distribution is
                       interfaced into the General Ledger
                       system.

ODI-INVC-PREFIX        Alpha 2                                   BL123
Element: Invc Prefix   This field contains the invoice prefix
                       that is assigned from either the company
                       or process level, depending on the
                       invoice-level option chosen.

ODI-INVC-NUMBER        Numeric 8                                 BL123
Element: Invc Number   Invoice number associated with this
                       journal entry distribution. Invoice
                       numbers are assigned at the company or
                       process level, depending on an invoice
                       level option on the company file.

ODI-AUTH-NO            Numeric 10                                BL123
Element: Auth No       This is the returns authorization
                       number associated with a distribution
                       record that was created in relation to a
                       return to stock credit memo added to the
                       Order Entry system using the returns
                       feature.

ODI-LINE-NBR           Numeric 6                                 BL123
Element: Line Nbr      Identifies the line number on the
                       invoice this distribution journal entry
                       is associated with.

ODI-SEQ                Numeric 3                                 BL123
Element: Seq           If this distribution record pertains to
                       an add-on charge that was attached to a
                       line on an invoice, this sequence number
                       identifies which add-on charge tied to
                       the line this is.

ODI-POSTING-TYPE       Alpha 2                                   BL123
Element: Posting Type  This field indicates what type of
                       account this distribution journal entry
                       is debiting or crediting.
                       AD = Add-on Discount (Db)
                       AS = A/R Add-on Discount (Cr)
                       CR = Cash In Advance (Cr)
                       CA = Cash In Advance (Db)
                       CI = Cost To Inventory (Cr)
                       CC = Cost Of Goods Sold (Db)
                       CV = Cost Variance (Db,Cr)
                       D1 = Line Discount (Db)
                       D2 = Line Discount (Db)
                       D3 = Line Discount (Db)
                       D4 = Line Discount (Cr)
                       D5 = Line Discount (Cr)
                       D6 = Line Discount (Cr)
                       FF = Freight (Db)
                       FA = Freight (Cr)
                       MS = Miscellaneous Sales (Cr)
                       MO = Miscellaneous Offset (Db)
                       MC = Miscellaneous Cost (Db)
                       MR = Miscellaneous A/R (Db)
                       OD = Order Discount (Db)
                       OS = Order Discount (Cr)
                       PS = Product Sales (Cr)
                       PA = Product A/R (Db)
                       S1 = Line Sales Tax (Db)
                       S2 = Line Sales Tax (Db)
                       S3 = Line Sales Tax (Db)
                       S4 = Line Sales Tax (Cr)
                       S5 = Line Sales Tax (Db)
                       S6 = Line Sales Tax (Cr)
                       M1 = Miscellaneous Sales Tax (Db)
                       M2 = Miscellaneous Sales Tax (Db)
                       M3 = Miscellaneous Sales TAx (Db)
                       M4 = Miscellaneous Sales Tax (Cr)
                       M5 = Miscellaneous Sales Tax (Cr)
                       M6 = Miscellaneous Sales Tax (Cr)
                       AR = Accounts Receivable
                       FR = Freight
                       TX = Vertex Tax
                       CP = Credit card payment

ODI-CUSTOMER           Alpha 9  (Right Justified)                BL123
Element: Customer      This field contains the number that
                       represents a customer.

ODI-ACTIVITY           Alpha 15                                  BL123
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity. Activities and
                       cost object activities are used
                       synonymously in the Activity Management
                       system. Direct costs are posted to
                       activities, and indirect costs are
                       allocated to activities based on
                       activity drivers.

                       Activities are grouped or organized by
                       activity levels. There are two types of
                       activities: "posting allowed" and
                       "summary only." Use posting level
                       activities to budget and maintain all
                       posted transactions. Summary activities
                       or macro activities combine information
                       and balances from lower level activities
                       for reporting and inquiries.

ODI-ACCT-CATEGORY      Alpha 5                                   BL123
Element: Acct Category Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       general ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

ODI-AMOUNT-BASE        Signed 18.2                               BL123
Element: Intl Amt      Amount of distribution journal entry in
                       company base currency.

ODI-AMOUNT-CURR        Signed 18.2                               BL123
Element: Intl Amt      Amount of distribution journal entry in
                       original billing currency.

ODI-CURRENCY-CODE      Alpha 5                                   BL123
Element: Currency Code This field contains the company's base
                       currency code established in the General
                       Ledger system.

ODI-CURR-RATE          Signed 14.7                               BL123
Element: Curr Rate     The currency rate used to convert this
                       distribution amount from original
                       billing currency to company base
                       currency.

                         OEDIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ODISET1   COMPANY                                                BL199   BL293
          GL-DATE
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          INVC-PREFIX
          INVC-NUMBER
          AUTH-NO
          LINE-NBR
          SEQ
          POSTING-TYPE

ODISET2   COMPANY                                                TX101
          INVC-PREFIX
          INVC-NUMBER
          AUTH-NO
          LINE-NBR
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          SEQ
          POSTING-TYPE

ODISET3   GLT-OBJ-ID    KeyChange
          INVC-PREFIX
          INVC-NUMBER
          AUTH-NO
          LINE-NBR
          SEQ
          POSTING-TYPE

ODISET4   ATN-OBJ-ID    KeyChange, Subset
          INVC-PREFIX   Where ATN-OBJ-ID != Zeroes
          INVC-NUMBER
          AUTH-NO
          LINE-NBR
          SEQ
          POSTING-TYPE

                         OEDIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            ODI-COMPANY          -> -COMPANY  (XXXXXXXXXX)

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP       -> CUD-CUST-GROUP
                            ODI-CUSTOMER         -> CUD-CUSTOMER

Glchartdtl     GLCHARTDTL   Required

                            GLS-CHART-NAME       -> GDT-CHART-NAME
                            GLM-SUMM-ACCT-ID     -> GDT-SUMRY-ACCT-ID
                            ODI-ACCOUNT          -> GDT-ACCOUNT
                            ODI-SUB-ACCOUNT      -> GDT-SUB-ACCOUNT

Glmaster       GLMASTER     Not Required

                            ODI-COMPANY          -> GLM-COMPANY
                            ODI-ACCT-UNIT        -> GLM-ACCT-UNIT
                            ODI-ACCOUNT          -> GLM-ACCOUNT
                            ODI-SUB-ACCOUNT      -> GLM-SUB-ACCOUNT

Glsystem       GLSYSTEM     Required

                            ODI-COMPANY          -> GLS-COMPANY

Oecompany      OECOMPANY    Required

                            ODI-COMPANY          -> OEC-COMPANY

Oeinvcline     OEINVCLINE   Not Required
                            Valid When ODI-LINE-NBR != Zeroes
                                  And  ODI-SEQ      =  Zeroes

                            ODI-COMPANY          -> OIL-COMPANY
                            ODI-INVC-PREFIX      -> OIL-INVC-PREFIX
                            ODI-INVC-NUMBER      -> OIL-INVC-NUMBER
                            ODI-LINE-NBR         -> OIL-LINE-NBR

Oeinvcmisc     OEINVCMISC   Not Required
                            Valid When ODI-LINE-NBR != Zeroes
                                  And  ODI-SEQ      != Zeroes

                            ODI-COMPANY          -> OIM-COMPANY
                            ODI-INVC-PREFIX      -> OIM-INVC-PREFIX
                            ODI-INVC-NUMBER      -> OIM-INVC-NUMBER
                            ODI-LINE-NBR         -> OIM-LINE-NBR
                            ODI-SEQ              -> OIM-SEQ

Oeinvoice      OEINVOICE    Required

                            ODI-COMPANY          -> OEI-COMPANY
                            ODI-INVC-PREFIX      -> OEI-INVC-PREFIX
                            ODI-INVC-NUMBER      -> OEI-INVC-NUMBER

Oeproclev      OEPROCLEV    Required

                            ODI-COMPANY          -> OEP-COMPANY
                            ODI-PROCESS-LEVEL    -> OEP-PROCESS-LEVEL

                         OEDIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sltrans        SLTRANS

                            ODI-GLT-OBJ-ID       -> SLT-GLT-OBJ-ID
                                                    SLT-OBJ-ID