Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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