DTCUSTBANK – AR Customer Paying Bank
- System
- DT (DT)
- Prefix
DTB- Primary key
CUST-GROUP,COMPANY,CUSTOMER,BANK-ENTITY,BANK-ACCT-NBR- Fields
- 18
- Updated by
- 7 programs
- Referenced by
- 1 program
DTCUSTBANK is the AR Customer Paying Bank table in Lawson DT (prefix DTB). It is indexed by CUST-GROUP, COMPANY, CUSTOMER, BANK-ENTITY, BANK-ACCT-NBR (DTBSET1); alternate indexes: DTBSET2 and DTBSET4. It is related 1:1 to ARCUSTGRP, CBBANKENT and CUSTDESC. It is updated by AR09.1, AR09.2, AR10.1, AR301, AR501, AR550 and TX140 and referenced by ARLL.1. The table has 18 fields, 3 indexes and 3 documented relations.
About DTCUSTBANK
The AR Customer Paying Bank file contains paying banks for a customer and the bank accounts associated with each bank location.
Fields (18)
Column = COBOL field name without the DTB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#DTB-CUST-GROUP PKCUST_GROUP | Alpha 5 | The customer group assigned to the customer. Must be a valid record in the AR Customer Group file. | AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140 |
#DTB-COMPANY PKCOMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140 |
#DTB-CUSTOMER PKCUSTOMER | Alpha 9 (Right Justified) | The customer number. Must be a valid record in the AR Company Customer file. | AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140 |
#DTB-BANK-ENTITY PKBANK_ENTITY | Alpha 15 | A bank identification representing a bank location for the customer. Must be a valid record in the Cash Ledger Bank file. | AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140 |
#DTB-BANK-ACCT-NBR PKBANK_ACCT_NBR | Alpha 35 | The bank-assigned identification number of the customer's bank account. Represents a bank account the customer pays bills of exchange from. | AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140 |
#DTB-DEFAULT-BNKDEFAULT_BNK | Alpha 1 | 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:
| AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140 |
#DTB-BANK-TYPEBANK_TYPE | Alpha 1 | This will show if the bank account is for use in bill of exchange or EFT processing. Valid values are:
| AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140 |
#DTB-START-DATESTART_DATE | Numeric 8 (yyyymmdd) | The start date for EFT selection. | AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140 |
#DTB-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | The end date for EFT selection. | AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140 |
#DTB-PRENOTEPRENOTE | Numeric 8 (yyyymmdd) | This is the date the prenote was sent to the customer in EFT processing. | AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140 |
#DTB-FT-TYPEFT_TYPE | Alpha 1 | This is the type of bank account. Valid values are:
| AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140 |
#DTB-PRE-NOTEPRE_NOTE | Alpha 1 | Indicates is sending a prenote is required for this bank account.
| AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140 |
#DTB-PRENOTE-STATUSPRENOTE_STATUS | Numeric 1 | This is the status of the pre note for this bank record. Valid values are:
| AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140 |
#DTB-CUST-ACCT-TYPECUST_ACCT_TYPE | Alpha 1 | The type of account the customer has:
| AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140 |
#DTB-BANK-TRAN-CDBANK_TRAN_CD | Alpha 2 | The value used for bank account edit verification. | AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140 |
#DTB-VBANK-IDENTVBANK_IDENT | Alpha 1 | — | AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140 |
#DTB-BIC-IDBIC_ID | Alpha 12 | — | — |
#DTB-MANDATE-FLAGMANDATE_FLAG | Alpha 1 | — | — |
Indexes (3)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
DTBSET1 |
| Primary | AR09.1, AR09.2, AR09.5, AR10.1, AR301, AR501, AR550, ARLL.1 +1 more | |
DTBSET2 |
| Subset | Where DEFAULT-BNK = "Y" | AR09.2, ARLL.1 |
DTBSET4 |
| Subset | Where BANK-TYPE = "E" | AR09.2, AR09.7 |
Relations
One to one (3) — lookups and parents
Programs
Updated by (7)
- AR09.1 Customer Group Address
- AR09.2 Banks
- AR10.1 Customer
- AR301 Customer Purge
- AR501 Customer Conversion
- AR550 Customer Interface
- TX140 Vertex Geocode Update
Referenced by (1)
- ARLL.1 AR Transaction Interface