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 Nbr   Required. The expense report number.

CVT-SEQ-NBR            Numeric 4                                 EE52.2
Element: Seq Nbr       Required 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: Rec 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 18.2                               EE52.2
Element: Intl Amt      Required. The amount of the
                       distribution in the currency of the
                       expense.

CVT-BASE-EXP-AMT       Signed 18.2
Element: Intl Amt

CVT-TAX-INDICATOR      Numeric 1                                 EE52.2
Element: Tax Indicator

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     Charge rate by month.

CVT-ACCR-CODE          Alpha 4                                   EE52.2  EE520
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 18.2                               EE52.2
Element: Intl 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 14.7                               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          This field displays the system date
                       when this was created.

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
                       Project Accounting.

CVT-REFERENCE          Alpha 10  (Lower Case)                    EE52.2
Element: Reference     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: Acct Category The account category assigned to the
                       distribution. Must be a valid record in
                       Project Accounting.

CVT-SEGMENT-BLOCK      Alpha 103                                 EE52.2
Element: Segment Block 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                                                EE52.1  EE52.2
          VENDOR                                                 EE520
          EXPENSE-NBR
          SEQ-NBR