Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EECDISTRIB


                            EECDISTRIB FILE

                     Expense Distribution Interface

The Expense Distribution Interface file is used by the Expense Interface
program to interface expense distribution records to the Lawson Employee
Expense and Accounts Payable systems. When you run EE520 (Expense Interface),
the system reads records in this file for interface into the Expense
Distribution file and, for released status expenses, into the Invoice
Distribution file.

When Distribution Interface records are successfully interfaced from the
Expense Distribution Interface file, they are purged from the interface file.
You can use EE52.2 (Distribution) to add records to the interface file or
maintain records already loaded into the file before interfacing the records.

UPDATED BY

EE52.1    EE52.2    EE520

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CVT-COMPANY            Numeric 4                                 EE52.2
Element: Company       Required. The company number. Must be a
                       valid record in the Accounts Payable
                       Company file.

CVT-VENDOR             Alpha 9  (Right Justified)                EE52.2
Element: Employee      Required. The employee number. Must be
                       a valid vendor record in the Accounts
                       Payable Vendor file.

CVT-EXPENSE-NBR        Alpha 10                                  EE52.2
Element: Expense NumberRequired. The expense report number.

CVT-SEQ-NBR            Numeric 4                                 EE52.2
Element: Sequence NumbeRequired if you have more than one line
                       of distribution for an expense. A unique
                       system-assigned identification value
                       assigned to the distribution to make the
                       record unique.

CVT-REC-STATUS         Numeric 1                                 EE52.2
Element: Record Status Required. The record status of the
                       distribution. Valid values are:

                       0 = Unreleased.
                       1 = Open.

CVT-CATEGORY           Alpha 9                                   EE52.2
Element: Category      Required. The category code assigned to
                       the expense distribution. Identifies the
                       type of expense. Represents a general
                       ledger account and optional distribution
                       information. Must be a valid record in
                       the Category Code file.

CVT-TRAN-EXP-AMT       Signed 15.2                               EE52.2
Element: Adj Amt       Required. The amount of the
                       distribution in the currency of the
                       expense.

CVT-BASE-EXP-AMT       Signed 15.2
Element: Adj Amt

CVT-TAX-CODE           Alpha 10                                  EE52.2
Element: Tax Code      The tax code assigned to the expense
                       distribution. Must be a valid record in
                       the Tax Code file.

CVT-TAX-RATE           Percent 7.5  (Percent)
Element: Chrg Rate     The tax rate defined for the tax code.

CVT-ACCR-CODE          Alpha 4                                   EE52.2
Element: Invoice AccruaThe invoice accrual code assigned to a
                       company-paid expense distribution. Used
                       to default a general ledger accrual
                       account to the expense. Must be a valid
                       record in the Invoice Accrual Code file.

CVT-TAXABLE-AMT        Signed 15.2                               EE52.2
Element: Adj Amt       The amount of the expense distribution
                       that is taxable.

CVT-EXP-CURRENCY       Alpha 5                                   EE52.2
Element: Expense CurrenThe currency of the expense
                       distribution. Must be a valid record in
                       the Currency Codes file.

CVT-CURR-RATE          Signed 13.6                               EE52.2
Element: Exchange Rate The exchange rate for the expense
                       distribution. Used to convert a non-base
                       currency expense amount to the company
                       base currency.

CVT-CURR-EFF-DATE      Numeric 8  (yyyymmdd)                     EE52.2
Element: Date          The effective date for the currency
                       exchange rate.

CVT-EXPENSE-DATE       Numeric 8  (yyyymmdd)                     EE52.2
Element: Date

CVT-DIST-COMPANY       Numeric 4                                 EE52.2
Element: Posting CompanThe company the distribution will be
                       posted to. Must be a valid record in the
                       General Ledger Company file and a valid
                       intercompany relationship must exist in
                       the Lawson General Ledger system.

CVT-EXP-ACCT-UNIT      Alpha 15                                  EE52.2
Distribution           The general ledger distribution
Accounting Unit        accounting unit. Must be a valid record
                       in the Lawson General Ledger system.

CVT-EXP-ACCOUNT        Numeric 6                                 EE52.2
Distribution           The general ledger distribution account
Account Number         number. Must be a valid record in the
                       Lawson General Ledger system.

CVT-EXP-SUB-ACCT       Numeric 4                                 EE52.2
Distribution           The general ledger distribution
Subaccount Number      subaccount number. Must be a valid
                       record in the Lawson General Ledger
                       system.

CVT-ACTIVITY           Alpha 15                                  EE52.2
Element: Activity      The activity assigned to the
                       distribution. Must be a valid record in
                       the Lawson Activity Management system.

CVT-REFERENCE          Alpha 10  (Lower Case)                    EE52.2
Element: Requester     The reference value assigned to the
                       distribution.

CVT-DESCRIPTION        Alpha 30  (Lower Case)                    EE52.2
Element: Description   The description assigned to the
                       distribution.

CVT-ACCT-CATEGORY      Alpha 5                                   EE52.2
Element: Account CategoThe account category assigned to the
                       distribution. Must be a valid record in
                       the Lawson Activity Management system.

CVT-SEGMENT-BLOCK      Alpha 103                                 EE52.2
Element: User Analysis This field identifies the user analysis
                       values included in the transaction.

                       You can either type up to four values
                       or use Define (F6) to open the User
                       Analysis Entry subform. Use this subform
                       to select the user analysis values you
                       want to include in the transaction. If
                       you choose to type values, use commas to
                       separate them. For example:
                       value1,value2,value3,value4

                       There are three conditions that affect
                       how you can select user analysis values.
                       See the User Analysis Entry form help or
                       the Strategic Ledger procedures manual
                       for additional information.

                         EECDISTRIB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CVTSET1   COMPANY       This index is used to access interface   EE52.1  EE52.2
          VENDOR        records.                                 EE520
          EXPENSE-NBR
          SEQ-NBR