Lawson Insight Technical Documentation |
|
DTCUSTBANK
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
AR110 AR31.5 AR33.5 AR42.1 AR42.2 AR42.6
AR42.7 AR43.1 AR44.3 AR502 AR560 ARLL.1
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 AR25.1
UPDATED BY
AR09.1 AR09.2 AR10.1 AR105 AR115 AR301
AR501 AR550 BL02.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DTB-CUST-GROUP Alpha 5 AR09.1 AR09.2
Element: Customer GroupThe customer group assigned to the AR10.1 AR301
customer. Must be a valid record in the AR501 AR550
AR Customer Group file. BL02.1
DTB-COMPANY Numeric 4 AR09.1 AR09.2
Element: Company Identifies the AP company if the AR10.1 AR301
resource type = V. Identifies the HR AR501 AR550
company if the resource type = E. It is BL02.1
blank for type A, P or Q resources.
DTB-CUSTOMER Alpha 9 (Right Justified) AR09.1 AR09.2
Element: Customer The customer number. Must be a valid AR10.1 AR301
record in the AR Company Customer file. AR501 AR550
BL02.1
DTB-BANK-ENTITY Alpha 15 AR09.1 AR09.2
Element: Bank A bank identification representing a AR10.1 AR301
bank location for the customer. Must be AR501 AR550
a valid record in the Cash Ledger Bank BL02.1 DT155
file. DT90.1 DT92.1
DTB-BANK-ACCT-NBR Alpha 35 AR09.1 AR09.2
Element: Bank Account NThe bank-assigned identification number AR10.1 AR301
of the customer's bank account. AR501 AR550
Represents a bank account the customer BL02.1 DT155
pays bills of exchange from. DT90.1 DT92.1
DTB-DEFAULT-BNK Alpha 1 AR09.1 AR09.2
Element: Default Bank Indicates whether this bank and account AR10.1 AR301
number is the default bank information AR501 AR550
for the customer. Only one bank and BL02.1
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 AR09.1 AR09.2
Element: Bank Type This will show if the bank account is AR10.1 AR301
for use in bill of exchange or EFT AR501 AR550
processing. Valid values are: BL02.1
B = Bills of Exchange
E = EFT
DTB-START-DATE Numeric 8 (yyyymmdd) AR09.1 AR09.2
Element: Start Date The start date for EFT selection. AR10.1 AR301
AR501 AR550
BL02.1
DTB-END-DATE Numeric 8 (yyyymmdd) AR09.1 AR09.2
Element: Ending Date The end date for EFT selection. AR10.1 AR301
AR501 AR550
BL02.1
DTB-PRENOTE Numeric 8 (yyyymmdd) AR09.1 AR09.2
Element: Prenote Date This is the date the prenote was sent AR10.1 AR115
to the customer in EFT processing. AR301 AR501
AR550 BL02.1
DTB-FT-TYPE Alpha 1 AR09.1 AR09.2
Element: FT Type This the type of bank account. Valid AR10.1 AR301
values are: AR501 AR550
BL02.1
Blank = Debit and credit account
C = Credit account
D = Debit account
DTB-PRE-NOTE Alpha 1 AR09.1 AR09.2
Element: Prenote RequirIndicates is sending a prenote is AR10.1 AR301
required for this bank account. AR501 AR550
BL02.1
N = No
Y = Yes
DTB-PRENOTE-STATUS Numeric 1 AR09.1 AR09.2
Element: Prenote StatusThis is the status of the pre note for AR10.1 AR105
this bank record. Valid values are: AR115 AR301
AR501 AR550
0 = Not Prenoted (default) BL02.1
1 = Printed
9 = EFT Record Sent
DTB-CUST-ACCT-TYPE Alpha 1 AR09.1 AR09.2
Element: Cust Acct TypeThe type of account the customer has: AR10.1 AR301
C = Check AR501 AR550
S = Savings BL02.1
DTB-BANK-TRAN-CD Alpha 2 AR09.1 AR09.2
Element: Bank Tran Cd The value used for bank account edit AR10.1 AR115
verification. AR301 AR501
AR550 BL02.1
DTB-VBANK-IDENT Alpha 1 AR09.1 AR09.2
Element: Alphadata1 This field indicates if the account AR10.1 AR301
number is an IBAN number that requires AR501 AR550
an account validation check. BL02.1
DTCUSTBANK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DTBSET1 CUST-GROUP This the primary path used to access AR09.1 AR09.2
COMPANY records. AR09.5 AR10.1
CUSTOMER AR110 AR301
BANK-ENTITY AR31.5 AR33.5
BANK-ACCT-NBR AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR501 AR502
AR550 AR560
ARLL.1 BL02.1
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT42.1
...
DTBSET2 CUST-GROUP This path is used to validate a AR09.2 AR31.5
COMPANY customer's default bank. AR33.5 AR42.1
CUSTOMER Subset AR42.2 AR42.6
Where DEFAULT-BNK = "Y" AR42.7 AR43.1
AR44.3 AR502
AR560 ARLL.1
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
...
DTBSET4 CUST-GROUP This index will contain only those AR09.2 AR09.7
COMPANY banks used in EFT processing. AR100 AR105
CUSTOMER Subset AR110 AR115
BANK-ENTITY Where BANK-TYPE = "E" AR25.1
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
|