|
|
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
Accounts Receivable The cash code represents the bank DT180 DT60.1
Code 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 15.2 DT160 DT180
Element: Adj 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 15.2 DT160 DT180
Element: Adj 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 15.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: 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
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: 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: 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
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 15.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 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
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 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
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 12.6 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 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
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: 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
|
