DTCUSTBANK FILE
AR Customer Paying Bank
The AR Customer Paying Bank file contains paying banks for a customer and the
bank accounts associated with each bank location.
REFERENCED BY
AR31.5 AR42.1 AR42.2 AR42.6 AR42.7 AR43.1
AR44.3 AR502 AR560 DT150 DT155 DT160
DT165 DT166 DT180 DT30.1 DT30.2 DT40.1
DT42.1 DT45.1 DT52.1 DT520 DT60.1 DT60.2
DT70.1 DT70.3 DT80.1 DT85.1 DT85.2 DT92.1
DT90.1 AR100 AR110 AR25.1
UPDATED BY
AR105 AR115 AR301 AR501 AR550
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DTB-CUST-GROUP Alpha 5 AR501 AR550
Customer Group The customer group assigned to the
customer. Must be a valid record in the
AR Customer Group file.
DTB-COMPANY Numeric 4 AR501 AR550
Company The company number represents an
established company and is entered on
all function codes.
DTB-CUSTOMER Alpha 9 (Right Justified) AR501 AR550
Customer The customer number. Must be a valid
record in the AR Company Customer file.
DTB-BANK-ENTITY Alpha 15 AR501 AR550
Bank A bank identification representing a DT155 DT90.1
bank location for the customer. Must be DT92.1
a valid record in the Cash Ledger Bank
file.
DTB-BANK-ACCT-NBR Alpha 17 AR501 AR550
Bank Account Number The bank-assigned identification number DT155 DT90.1
of the customer's bank account. DT92.1
Represents a bank account the customer
pays bills of exchange from.
DTB-DEFAULT-BNK Alpha 1 AR501 AR550
Default Bank Indicates whether this bank and account
number is the default bank information
for the customer. Only one bank and
account number can be designated as the
default bank information for the
customer. Valid values are:
N = No
Y = Yes
DTB-BANK-TYPE Alpha 1 AR501 AR550
Bank Type This will show if the bank account is
for use in bill of exchange or EFT
processing. Valid values are:
B = Bills of Exchange
E = EFT
DTB-START-DATE Numeric 8 (yyyymmdd) AR501 AR550
Start Date The start date for EFT selection.
DTB-END-DATE Numeric 8 (yyyymmdd) AR501 AR550
Ending Date The end date for EFT selection.
DTB-PRENOTE Numeric 8 (yyyymmdd) AR115 AR501
Prenote Date This is the date the prenote was sent AR550
to the customer in EFT processing.
DTB-FT-TYPE Alpha 1 AR501 AR550
FT Type This the type of bank account. Valid
values are:
Blank = Debit and credit account
C = Credit account
D = Debit account
DTB-PRE-NOTE Alpha 1 AR501 AR550
Prenote Required Indicates is sending a prenote is
required for this bank account.
N = No
Y = Yes
DTB-PRENOTE-STATUS Numeric 1 AR105 AR115
Prenote Status This is the status of the pre note for AR501 AR550
this bank record. Valid values are:
0 = Not Prenoted (default)
1 = Printed
9 = EFT Record Sent
DTB-CUST-ACCT-TYPE Alpha 1 AR501 AR550
Cust Acct Type The type of account the customer has:
C = Check
S = Savings
DTB-BANK-TRAN-CD Alpha 2 AR115 AR501
Bank Tran Cd Indicates whether first, regular or last AR550
direct debit transaction for a customer.
DTCUSTBANK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DTBSET1 CUST-GROUP This the primary path used to access AR301 AR31.5
COMPANY records. AR42.1 AR42.2
CUSTOMER AR42.6 AR42.7
BANK-ENTITY AR43.1 AR44.3
BANK-ACCT-NBR AR501 AR502
AR550 AR560
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT42.1
DT45.1 DT52.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
...
DTBSET2 CUST-GROUP This path is used to validate a AR31.5 AR42.1
COMPANY customer's default bank. AR42.2 AR42.6
CUSTOMER Subset AR42.7 AR43.1
Where DEFAULT-BNK = "Y" AR44.3 AR502
AR560 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT52.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT90.1 DT92.1
DTBSET3 CUST-GROUP This index will contain only those
COMPANY banks used in bill of exchange
CUSTOMER processing.
BANK-ENTITY Subset
BANK-ACCT-NBR Where BANK-TYPE = "B"
DTBSET4 CUST-GROUP This index will contain only those AR100 AR105
COMPANY banks used in EFT processing. AR110 AR115
CUSTOMER Subset AR25.1
BANK-ENTITY Where BANK-TYPE = "E"
BANK-ACCT-NBR
DTCUSTBANK FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcustgrp ARCUSTGRP Required
DTB-CUST-GROUP -> ACG-CUST-GROUP
Cbbankent CBBANKENT Required
DTB-BANK-ENTITY -> CBE-BANK-ENTITY
Custdesc CUSTDESC Required
DTB-CUST-GROUP -> CUD-CUST-GROUP
DTB-CUSTOMER -> CUD-CUSTOMER
|
