|
|
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 The payment or transaction code assigned DT180 DT60.1
to the bill of exchange. Represents a DT60.2 DT70.1
transacion code of type BOE. DT70.3 DT80.1
DRM-MATURITY-DATE Numeric 8 (yyyymmdd) DT160 DT161
Maturity Date The date when the remittance is due to DT180 DT60.1
be paid in full. DT60.2 DT70.1
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 DT60.1 DT60.2
REMIT-TYPE DT70.1 DT70.3
REMIT-NBR DT80.1 DT90.1
MATURITY-DATE
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 DT60.2 DT70.1
REMIT-TYPE 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 Used in the generation of a bank file DT160 DT166
PROCESS-LEVEL output. DT180 DT60.1
CASH-CODE Duplicates, Subset DT60.2 DT70.1
REMIT-TYPE Where BANK-INST-CODE != Spaces DT70.3 DT80.1
BANK-INST-CODE
REMIT-NBR
DRMSET6 COMPANY Used in the generation of a bank DT161
PROCESS-LEVEL remittance statement containing all
CASH-CODE remittances with a common maturity date.
BANK-INST-CODEKeyChange
REMIT-TYPE
REMIT-NBR
MATURITY-DATE
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-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-DRAFT-NBR
ARD-SUFFIX
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-DRAFT-NBR
ARD-SUFFIX
ARD-CUSTOMER
ARD-MATURITY-DATE
|