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 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 BL802 PW550 TX140
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 BL802
PW550 TX140
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 BL802
blank for type A, P or Q resources. PW550 TX140
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 BL802
PW550 TX140
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 BL802
file. DT155 DT90.1
DT92.1 PW550
TX140
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 BL802
pays bills of exchange from. DT155 DT90.1
DT92.1 PW550
TX140
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 BL802
account number can be designated as the PW550 TX140
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 BL802
PW550 TX140
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 BL802
PW550 TX140
DTB-END-DATE Numeric 8 (yyyymmdd) AR09.1 AR09.2
Element: End Date The end date for EFT selection. AR10.1 AR301
AR501 AR550
BL02.1 BL802
PW550 TX140
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
BL802 PW550
TX140
DTB-FT-TYPE Alpha 1 AR09.1 AR09.2
Element: FT Type This is the type of bank account. Valid AR10.1 AR301
values are: AR501 AR550
BL02.1 BL802
Blank = Debit and credit account PW550 TX140
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
N = No BL02.1 BL802
Y = Yes PW550 TX140
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 BL802
1 = Printed PW550 TX140
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 BL802
PW550 TX140
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
BL802 PW550
TX140
DTB-VBANK-IDENT Alpha 1 AR09.1 AR09.2
Element: Alphadata1 AR10.1 AR301
AR501 AR550
BL02.1 BL802
PW550 TX140
DTCUSTBANK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DTBSET1 CUST-GROUP AR09.1 AR09.2
COMPANY AR09.5 AR10.1
CUSTOMER AR110 AR301
BANK-ENTITY AR33.5 AR42.1
BANK-ACCT-NBR AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR501
AR502 AR550
AR560 ARLL.1
BL02.1 BL802
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT42.1
...
DTBSET2 CUST-GROUP Subset AR09.2 AR33.5
COMPANY Where DEFAULT-BNK = "Y" AR42.1 AR42.2
CUSTOMER AR42.6 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 DT85.2
...
DTBSET4 CUST-GROUP Subset AR09.2 AR09.7
COMPANY Where BANK-TYPE = "E" AR100 AR105
CUSTOMER AR110 AR115
BANK-ENTITY 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
|