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.

Field / columnTypeDescription & valuesUpdated by
DTB-CUST-GROUP PK
CUST_GROUP		Alpha 5The 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 PK
COMPANY		Numeric 4Identifies 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 PK
CUSTOMER		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 PK
BANK_ENTITY		Alpha 15A 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 PK
BANK_ACCT_NBR		Alpha 35The 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-BNK
DEFAULT_BNK		Alpha 1Indicates 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
AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140
DTB-BANK-TYPE
BANK_TYPE		Alpha 1This 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
AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140
DTB-START-DATE
START_DATE		Numeric 8 (yyyymmdd)The start date for EFT selection.AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140
DTB-END-DATE
END_DATE		Numeric 8 (yyyymmdd)The end date for EFT selection.AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140
DTB-PRENOTE
PRENOTE		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-TYPE
FT_TYPE		Alpha 1This is the type of bank account. Valid values are:
  • Blank Debit and credit account
  • C Credit account
  • D Debit account
AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140
DTB-PRE-NOTE
PRE_NOTE		Alpha 1Indicates is sending a prenote is required for this bank account.
  • N No
  • Y Yes
AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140
DTB-PRENOTE-STATUS
PRENOTE_STATUS		Numeric 1This is the status of the pre note for this bank record. Valid values are:
  • 0 Not Prenoted (default)
  • 1 Printed
  • 9 EFT Record Sent
AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140
DTB-CUST-ACCT-TYPE
CUST_ACCT_TYPE		Alpha 1The type of account the customer has:
  • C Check
  • S Savings
AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140
DTB-BANK-TRAN-CD
BANK_TRAN_CD		Alpha 2The value used for bank account edit verification.AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140
DTB-VBANK-IDENT
VBANK_IDENT		Alpha 1—AR09.1, AR09.2, AR10.1, AR301, AR501, AR550, TX140
DTB-BIC-ID
BIC_ID		Alpha 12——
DTB-MANDATE-FLAG
MANDATE_FLAG		Alpha 1——

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
DTBSET1CUST-GROUP, COMPANY, CUSTOMER, BANK-ENTITY, BANK-ACCT-NBRPrimaryAR09.1, AR09.2, AR09.5, AR10.1, AR301, AR501, AR550, ARLL.1 +1 more
DTBSET2CUST-GROUP, COMPANY, CUSTOMERSubsetWhere DEFAULT-BNK = "Y"AR09.2, ARLL.1
DTBSET4CUST-GROUP, COMPANY, CUSTOMER, BANK-ENTITY, BANK-ACCT-NBRSubsetWhere BANK-TYPE = "E"AR09.2, AR09.7

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ArcustgrpARCUSTGRPRequiredDTB-CUST-GROUP → ACG-CUST-GROUP
CbbankentCBBANKENTRequiredDTB-BANK-ENTITY → CBE-BANK-ENTITY
CustdescCUSTDESCRequiredDTB-CUST-GROUP → CUD-CUST-GROUP, DTB-CUSTOMER → CUD-CUSTOMER

Programs

Updated by (7)

Referenced by (1)