Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              DTREMIT FILE

                     AR Bill of Exchange Remittance

The AR Bill of Exchange Remittance file contains bill of exchange remittance
information that has been processed. This information is used to remit one or
more bills of exchange to a bank for cashing.

REFERENCED BY

DT170     DT220

UPDATED BY

DT160     DT161     DT165     DT166     DT180     DT181
DT60.1    DT60.2    DT70.1    DT70.3    DT80.1    DT90.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

DRM-COMPANY          Numeric 4                                   DT160   DT161
Company              The remittance company number. Must be      DT180   DT60.1
                     a valid record in the AR Company file.      DT60.2  DT70.1
                                                                 DT70.3  DT80.1

DRM-PROCESS-LEVEL    Alpha 5                                     DT160   DT161
Process Level        The process level the remittance was        DT180   DT60.1
                     created for, if limited to a specific       DT60.2  DT70.1
                     process level. Must be a valid record in    DT70.3  DT80.1
                     the AR Process Level file.

DRM-CASH-CODE        Alpha 4                                     DT160   DT161
Cash Code            The cash code represents the bank           DT180   DT60.1
                     account the bills of exchange will be       DT60.2  DT70.1
                     remitted to for deposit. Must be a valid    DT70.3  DT80.1
                     record in the Cash Ledger Cash Code
                     file.

DRM-REMIT-TYPE       Alpha 1                                     DT160   DT161
Remittance Type      Indicates the type of remittance. Valid     DT180   DT60.1
                     values are:                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                     E = Encashed
                     D = Discounted

DRM-REMIT-NBR        Numeric 7                                   DT160   DT161
Remittance Number    The system-generated number that            DT165   DT166
                     identifies a remittance.                    DT180   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1

DRM-STATUS           Numeric 1                                   DT160   DT161
Status               Indicates the status of the bill of         DT165   DT166
                     exchange remittance. Valid values are:      DT180   DT181
                                                                 DT60.1  DT60.2
                     0 = Selected                                DT70.1  DT70.3
                     1 = Generated                               DT80.1
                     2 = Presented
                     8 = Canceled
                     9 = Cashed

DRM-MIN-AMT          Signed 15.2                                 DT160   DT180
Minimum Amount       The minimum total amount of bills of        DT60.1  DT60.2
                     exchange that can be included in the        DT70.1  DT70.3
                     remittance.                                 DT80.1

DRM-MAX-AMT          Signed 15.2                                 DT160   DT180
Maximum Amount       The maximum total amount of bills of        DT60.1  DT60.2
                     exchange that can be included in the        DT70.1  DT70.3
                     remittance.                                 DT80.1

DRM-CREDIT-LINE      Alpha 4                                     DT160   DT161
Credit Line          The credit line used for the                DT180   DT60.1
                     remittance. Represents a credit line at     DT60.2  DT70.1
                     the bank the bills of exchange will be      DT70.3  DT80.1
                     remitted to for deposit. Valid only with
                     discounted remittance types and only for
                     remittance companies defined for bank
                     risk processing.

                     This code represents a unique line of
                     credit for the financial institution.

DRM-REMIT-AMT        Signed 15.2                                 DT160   DT161
Remittance Amount    The total amount of the remittance.         DT180   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1

DRM-REMIT-DATE       Numeric 8  (yyyymmdd)                       DT160   DT161
Remittance Date      The date assigned to the printed            DT165   DT166
                     remittance.                                 DT180   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1

DRM-PRESENT-DATE     Numeric 8  (yyyymmdd)                       DT160   DT161
Presented Date       The date the bill of exchange               DT180   DT60.1
                     remittance was presented to the bank.       DT60.2  DT70.1
                                                                 DT70.3  DT80.1

DRM-CASHED-DATE      Numeric 8  (yyyymmdd)                       DT160   DT180
Cashed Date          The date the bill of exchange               DT181   DT60.1
                     remittance was cashed.                      DT60.2  DT70.1
                                                                 DT70.3  DT80.1

DRM-CANCEL-DATE      Numeric 8  (yyyymmdd)                       DT160   DT180
Cancel Date          The date the bill of exchange               DT60.1  DT60.2
                     remittance was canceled, if applicable.     DT70.1  DT70.3
                                                                 DT80.1

DRM-CASHED-AMT       Signed 15.2                                 DT160   DT180
Cashed Amount        The total amount of bills of exchange       DT181   DT60.1
                     on the remittance that has been cashed.     DT60.2  DT70.1
                                                                 DT70.3  DT80.1

DRM-UNPAY-AMT        Signed 15.2                                 DT160   DT180
Dishonored Amount    The total amount of bills of exchange       DT60.1  DT60.2
                     on the remittance that has been             DT70.1  DT70.3
                     dishonored.                                 DT80.1  DT90.1

DRM-ORIG-ADMIN-AMT   Signed 15.2                                 DT160   DT180
Administration       The total amount of administration          DT60.1  DT60.2
Amount               expense associated with the bill of         DT70.1  DT70.3
                     exchange remittance in the currency of      DT80.1
                     the bank account.

DRM-ADMIN-AMT        Signed 15.2                                 DT160   DT180
Base Curr            The total amount of administration          DT60.1  DT60.2
Administration Amt   expense associated with the bill of         DT70.1  DT70.3
                     exchange remittance in the company base     DT80.1
                     currency.

DRM-ADMN-ACCT-UNIT   Alpha 15                                    DT160   DT180
Admin Expense        The accounting unit used for posting        DT60.1  DT60.2
Accounting Unit      the administration expenses to the          DT70.1  DT70.3
                     general ledger.                             DT80.1

DRM-ADMN-ACCOUNT     Numeric 6                                   DT160   DT180
Admin Expense        The account number used for posting the     DT60.1  DT60.2
Account Number       administration expenses to the general      DT70.1  DT70.3
                     ledger.                                     DT80.1

DRM-ADMN-SUB-ACCT    Numeric 4                                   DT160   DT180
Admin Expense        The subaccount number used for posting      DT60.1  DT60.2
Subaccount Nbr       the administration expenses to the          DT70.1  DT70.3
                     general ledger.                             DT80.1

DRM-ORIG-BNK-EXP     Signed 15.2                                 DT160   DT180
Bank Expense Amount  The total bank expense charges              DT60.1  DT60.2
                     associated with the bill of exchange        DT70.1  DT70.3
                     remittance in the currency of the bank      DT80.1
                     account.

DRM-BNK-EXP-AMT      Signed 15.2                                 DT160   DT180
Base Curr Bank       The total bank expense charges              DT60.1  DT60.2
Expense Amount       associated with the bill of exchange        DT70.1  DT70.3
                     remittance in the company base currency.    DT80.1

DRM-BEXP-ACCT-UNIT   Alpha 15                                    DT160   DT180
Bank Expense         The accounting unit used for posting        DT60.1  DT60.2
Accounting Unit      the bank expenses to the general ledger.    DT70.1  DT70.3
                                                                 DT80.1

DRM-BEXP-ACCOUNT     Numeric 6                                   DT160   DT180
Bank Expense Account The account number used for posting the     DT60.1  DT60.2
                     bank expenses to the general ledger.        DT70.1  DT70.3
                                                                 DT80.1

DRM-BEXP-SUB-ACCT    Numeric 4                                   DT160   DT180
Bank Expense         The subaccount number used for posting      DT60.1  DT60.2
Subaccount           the bank expenses to the general ledger.    DT70.1  DT70.3
                                                                 DT80.1

DRM-CURRENCY-CODE    Alpha 5                                     DT160   DT161
Remittance Cash      The bank account currency of the cash       DT180   DT60.1
Code Currency        code used in the remittance.                DT60.2  DT70.1
                                                                 DT70.3  DT80.1

DRM-ORIG-RATE        Signed 12.6                                 DT160   DT161
Exchange Rate        The exchange rate in effect when the        DT180   DT60.1
                     bill of exchange remittance was             DT60.2  DT70.1
                     presented to the bank. Used to convert a    DT70.3  DT80.1
                     bank account currency amount to the
                     remittance company's base currency.

DRM-GL-UPDATE-CODE   Alpha 1                                     DT160   DT180
General Ledger       Indicates the status of the bill of         DT181   DT60.1
Update Code          exchange remittance based on how DT180      DT60.2  DT70.1
                     (Bank Presentation, Cashing Update) has     DT70.3  DT80.1
                     updated the general ledger. Valid values
                     are:

                     Blank = Not processed by DT180

                     P = Remittance presentation has been
                     posted to the general ledger

                     C = Cashing of discounted remittance
                     has been posted to the general ledger

                     X = Cancellation of remittance has been
                     posted to the general ledger

DRM-PROCESS-AMT      Derived
Process Amount       Used in program processing.

DRM-CASH-RATE        Signed 12.6                                 DT160   DT180
Cashing Exchange     The currency exchange rate used             DT60.1  DT60.2
Rate                 when cashing a discounted remittance.       DT70.1  DT70.3
                                                                 DT80.1

DRM-DEP-INST-CODE    Alpha 3                                     DT180   DT181
Deposit Payment Code The bank service transaction code used
                     for depositing the bill of exchange
                     remittance. Must be a valid record in
                     the Cash Ledger Bank Transaction Code
                     file.

DRM-TRANS-IDENT      Numeric 10                                  DT180   DT181
Transaction ID       A unique system-generated
                     identification value assigned to the
                     transaction to make this record unique.

DRM-BANK-INST-CODE   Alpha 3                                     DT160   DT161
Transaction Code     A transaction code represents a type of     DT180   DT60.1
                     cash payment, bill of exchange payment,     DT60.2  DT70.1
                     or bank service transaction.                DT70.3  DT80.1

DRM-MATURITY-DATE    Numeric 8  (yyyymmdd)                       DT160   DT161
Maturity Date        The remittance due date.  Indicates when    DT180   DT60.1
                     the remittance is due to be paid in         DT60.2  DT70.1
                     full.                                       DT70.3  DT80.1

                         DTREMIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DRMSET1   COMPANY       This is the primary path used to access  DT160   DT165
          PROCESS-LEVEL records.                                 DT170   DT180
          CASH-CODE                                              DT181   DT60.1
          REMIT-TYPE                                             DT60.2  DT70.1
          REMIT-NBR                                              DT70.3  DT80.1
          MATURITY-DATE                                          DT90.1

DRMSET2   COMPANY       This path is used to span records for    DT160   DT165
          REMIT-NBR     reprinting remittances.                  DT166   DT180
                        Subset                                   DT220   DT60.1
                        Where  STATUS    >  Zeroes               DT60.2  DT70.1
                        And   (REMIT-NBR != Zeroes )             DT70.3  DT80.1

DRMSET3   CASH-CODE     This path is used in the remittance      DT160   DT180
          COMPANY       presentation process.                    DT181   DT60.1
          PROCESS-LEVEL KeyChange, Subset                        DT60.2  DT70.1
          REMIT-TYPE    Where (REMIT-NBR != Zeroes )             DT70.3  DT80.1
          STATUS
          REMIT-NBR

DRMSET4   DEP-INST-CODE This path is used to allow drill down
          TRANS-IDENT   from cash ledger screens back into the
                        remittance file.
                        KeyChange, Subset
                        Where DEP-INST-CODE != Spaces

DRMSET5   COMPANY       Subset                                   DT160   DT166
          PROCESS-LEVEL Where BANK-INST-CODE != Spaces           DT180   DT60.1
          CASH-CODE                                              DT60.2  DT70.1
          REMIT-TYPE                                             DT70.3  DT80.1
          BANK-INST-CODE
          REMIT-NBR

DRMSET6   COMPANY                                                DT161
          PROCESS-LEVEL
          CASH-CODE
          BANK-INST-CODE
          REMIT-TYPE
          REMIT-NBR
          MATURITY-DATE

DRMSET7   CASH-CODE     This index was created as a solution to  DT181
          COMPANY       the Find Next/Prev Flag error. It is
          PROCESS-LEVEL only used where a modify must be done
          REMIT-TYPE    within a 850-FIND-NLT or 850-FIND-BEGRNG
          REMIT-NBR     loop.
          STATUS        Subset
                        Where (REMIT-NBR != Zeroes )

                         DTREMIT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            DRM-COMPANY          -> ACO-COMPANY

Cbcashcode     CBCASHCODE   Required

                            DRM-CASH-CODE        -> CBC-CASH-CODE

                         DTREMIT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ardrafts       ARDRAFTS

                            DRM-COMPANY          -> ARD-REMIT-COMPANY
                            DRM-PROCESS-LEVEL    -> ARD-REMIT-PROC-LEV
                            DRM-CASH-CODE        -> ARD-CASH-CODE
                            DRM-REMIT-TYPE       -> ARD-REMIT-TYPE
                                                    ARD-MATURITY-DATE
                                                    ARD-CUSTOMER
                                                    ARD-AR-DRAFT-NBR
                                                    ARD-SUFFIX

Remitted Draft ARDRAFTS
                            Valid When DRM-STATUS > Zeroes

                            DRM-COMPANY          -> ARD-REMIT-COMPANY
                            DRM-PROCESS-LEVEL    -> ARD-REMIT-PROC-LEV
                            DRM-REMIT-NBR        -> ARD-REMIT-NBR
                                                    ARD-CUSTOMER
                                                    ARD-AR-DRAFT-NBR
                                                    ARD-SUFFIX
                                                    ARD-COMPANY
                                                    ARD-CANCEL-SEQ
                                                    ARD-DRAFT-SOURCE

Selected Draft ARDRAFTS

                            DRM-COMPANY          -> ARD-REMIT-COMPANY
                            DRM-PROCESS-LEVEL    -> ARD-REMIT-PROC-LEV
                            DRM-CASH-CODE        -> ARD-CASH-CODE
                            DRM-REMIT-TYPE       -> ARD-REMIT-TYPE
                                                    ARD-AR-DRAFT-NBR
                                                    ARD-SUFFIX
                                                    ARD-CUSTOMER
                                                    ARD-MATURITY-DATE