Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

DTREMIT


                              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
Element: 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
Element: 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
Element: 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
Element: Remittance TypIndicates 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
Element: Remittance NumThe 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
Element: 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 18.2                               DT160   DT180
Element: Intl Amt      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 18.2                               DT160   DT180
Element: Intl Amt      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
Element: 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 18.2                               DT160   DT161
Element: Remittance AmoThe total amount of the remittance.       DT180   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1

DRM-REMIT-DATE         Numeric 8  (yyyymmdd)                     DT160   DT161
Element: Remittance DatThe 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
Element: Presented DateThe 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
Element: 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
Element: 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 18.2                               DT160   DT180
Element: 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 18.2                               DT160   DT180
Element: Dishonored AmoThe 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 18.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 18.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 18.2                               DT160   DT180
Element: Bank Expense AThe 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 18.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
Element: Accounting UniThe accounting unit used for posting      DT60.1  DT60.2
                       the bank expenses to the general ledger.  DT70.1  DT70.3
                                                                 DT80.1

DRM-BEXP-ACCOUNT       Numeric 6                                 DT160   DT180
Element: 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 14.7                               DT160   DT161
Element: 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
Element: Process AmountUsed in program processing.

DRM-CASH-RATE          Signed 14.7                               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
Element: Deposit PaymenThe 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
Element: Transaction IDA unique system-generated
                       identification value assigned to the
                       transaction to make this record unique.

DRM-BANK-INST-CODE     Alpha 3                                   DT160   DT161
Element: Transaction CoA 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
Element: 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