Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

DTCASHING


                             DTCASHING FILE

                        AR Bank Cashing Charges

The AR Bank Cashing Charges file contains expenses associated with a bank
account (cash code).

UPDATED BY

DT180     DT181     DT80.4    DT90.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DTS-CASH-CODE          Alpha 4                                   DT80.4  DT90.3
Element: Cash Code     A cash code represents a specific bank
                       account at a bank location. Must be a
                       valid record in the Cash Ledger Cash Cod
                        file.

DTS-BANK-INST-CODE     Alpha 3                                   DT80.4  DT90.3
Element: Payment Code  The bank service transaction code used
                       to identify the type of expenses. Must
                       be a valid record in the Cash Ledger
                       Bank Transaction  Code file.

DTS-TRAN-DATE          Numeric 8  (yyyymmdd)                     DT80.4  DT90.3
Element: GL Posting DatThe general ledger posting date
                       assigned to the charges.

DTS-SEQ-NBR            Numeric 4                                 DT80.4  DT90.3
Element: Seq Nbr       This field contains the sequence
                       number, which is incremented if
                       duplicate records exist when a new
                       record is created.

DTS-COMPANY            Numeric 4                                 DT80.4  DT90.3
Element: Company       The company number represents an
                       established company. Must be a valid
                       record in the AR Company file.

DTS-TRAN-EXP-AMT       Signed 18.2                               DT80.4  DT90.3
Base Currency          The amount of the bank expense in the
Expense Amount         company base currency.

DTS-ORIG-EXP-AMT       Signed 18.2                               DT80.4  DT90.3
Transaction Curr       The amount of the bank expense in the
Expense Amt            currency of the bank account.

DTS-EXP-ACCT-UNIT      Alpha 15                                  DT80.4  DT90.3
Element: Acct Unit     The distribution accounting unit used
                       for posting the bank expense to the
                       general ledger.

DTS-EXP-ACCOUNT        Numeric 6                                 DT80.4  DT90.3
Expense Account        The distribution account number used
Number                 for posting the bank expense to the
                       general ledger.

DTS-EXP-SUB-ACCT       Numeric 4                                 DT80.4  DT90.3
Expense Subaccount     The distribution subaccount number used
Number                 for posting the bank expense to the
                       general ledger.

DTS-TRAN-ADMIN-AMT     Signed 18.2                               DT80.4  DT90.3
Base Curr Admin        The administration expense amount in
Expense Amount         the company base currency.

DTS-ORIG-ADMIN-AMT     Signed 18.2                               DT80.4  DT90.3
Administration         The administration expense amount in
Expense Amount         the currency of the bank account.

DTS-ADMN-ACCT-UNIT     Alpha 15                                  DT80.4  DT90.3
Admin Expense          The accounting unit used for posting
Accounting Unit        the administration expense to the
                       general ledger.

DTS-ADMN-ACCOUNT       Numeric 6                                 DT80.4  DT90.3
Admin Expense          The account number used for posting the
Account Number         administration expense to the general
                       ledger.

DTS-ADMN-SUB-ACCT      Numeric 4                                 DT80.4  DT90.3
Admin Expense          The subaccount number used for posting
Subaccount Nbr         the administration expense to the
                       general ledger.

DTS-EXCHANGE-RATE      Signed 14.7                               DT80.4  DT90.3
Element: Acct Rate     The exchange rate used to convert a
                       bank account currency amount to the
                       company base currency.

DTS-CURRENCY-CD        Alpha 5                                   DT80.4  DT90.3
Bank Account           The currency code assigned to the cash
Currency               code. Represents the currency of the
                       bank account. Must be a valid record in
                       the Currency Code file.

DTS-GL-UPDATE-FL       Alpha 1                                   DT180   DT181
General Ledger         Indicates whether accounts receivable     DT80.4  DT90.3
Update Flag            distribution records have been created
                       by DT180 (Bank Presentation, Cashing
                       Update). Valid values are:

                       N = No
                       Y = Yes

DTS-TRANS-IDENT        Numeric 10                                DT180   DT181
Element: Transaction IDA unique, system-generated
                       identification value assigned to the
                       transaction to make this record unique.

DTS-JRNL-BOOK-NBR      Alpha 12
Element: Journal Book NThis field contains the journal book
                       number.

                         DTCASHING FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DTSSET1   CASH-CODE                                              DT180   DT181
          BANK-INST-CODE                                         DT80.4  DT90.3
          TRAN-DATE
          SEQ-NBR

DTSSET2   BANK-INST-CODEKeyChange, Subset
          TRANS-IDENT   Where BANK-INST-CODE != Spaces
                        And   TRANS-IDENT    != Zeroes