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
| ARLL.1 |
| AR09.1 | AR09.2 | AR10.1 | AR301 | AR501 | AR550 |
| TX140 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| DTB-CUST-GROUP Element: Customer Group | Alpha 5 The customer group assigned to the customer. Must be a valid record in the AR Customer Group file. |
|
||||||||
| DTB-COMPANY Element: Company | 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. |
|
||||||||
| DTB-CUSTOMER Element: Customer | Alpha 9 (Right Justified) The customer number. Must be a valid record in the AR Company Customer file. |
|
||||||||
| DTB-BANK-ENTITY Element: Bank | Alpha 15 A bank identification representing a bank location for the customer. Must be a valid record in the Cash Ledger Bank file. |
|
||||||||
| DTB-BANK-ACCT-NBR Element: Bank Account Number | Alpha 35 The bank-assigned identification number of the customer's bank account. Represents a bank account the customer pays bills of exchange from. |
|
||||||||
| DTB-DEFAULT-BNK Element: Default Bank | 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: N = No Y = Yes |
|
||||||||
| DTB-BANK-TYPE Element: Bank Type | Alpha 1 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 Element: Start Date | Numeric 8 (yyyymmdd) The start date for EFT selection. |
|
||||||||
| DTB-END-DATE Element: End Date | Numeric 8 (yyyymmdd) The end date for EFT selection. |
|
||||||||
| DTB-PRENOTE Element: Prenote Date | Numeric 8 (yyyymmdd) This is the date the prenote was sent to the customer in EFT processing. |
|
||||||||
| DTB-FT-TYPE Element: FT Type | Alpha 1 This is the type of bank account. Valid values are: Blank = Debit and credit account C = Credit account D = Debit account |
|
||||||||
| DTB-PRE-NOTE Element: Prenote Required | Alpha 1 Indicates is sending a prenote is required for this bank account. N = No Y = Yes |
|
||||||||
| DTB-PRENOTE-STATUS Element: Prenote Status | Numeric 1 This is the status of the pre note for this bank record. Valid values are: 0 = Not Prenoted (default) 1 = Printed 9 = EFT Record Sent |
|
||||||||
| DTB-CUST-ACCT-TYPE Element: Cust Acct Type | Alpha 1 The type of account the customer has: C = Check S = Savings |
|
||||||||
| DTB-BANK-TRAN-CD Element: Bank Tran Cd | Alpha 2 The value used for bank account edit verification. |
|
||||||||
| DTB-VBANK-IDENT Element: Alphadata1 | Alpha 1 |
|
||||||||
| DTB-BIC-ID Element: Swift Id | Alpha 12 |
|
||||||||
| DTB-MANDATE-FLAG Element: Flag1 | Alpha 1 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DTBSET1 |
CUST-GROUP COMPANY CUSTOMER BANK-ENTITY BANK-ACCT-NBR |
|
| ||||||||||||||||
| DTBSET2 |
CUST-GROUP COMPANY CUSTOMER |
|
| ||||||||||||||||
| DTBSET4 |
CUST-GROUP COMPANY CUSTOMER BANK-ENTITY BANK-ACCT-NBR |
|
| ||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
|---|---|---|---|---|---|---|---|---|
| Arcustgrp | ARCUSTGRP |
Required
| ||||||
| Cbbankent | CBBANKENT |
Required
| ||||||
| Custdesc | CUSTDESC |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.