Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBDISTRIB


                             CBDISTRIB FILE

                        Transaction Distribution

The Transaction Distribution file contains all distribution records
associated with a Cash Ledger transaction.

REFERENCED BY

CB195     CB221     CB99.1    TX226

UPDATED BY

AP170     AP180     AP181     AP190     AP255     AP265
AP81.1    AP90.5    AR115     AR124     AR20.1    AR21.1
AR21.2    AR21.3    AR24.1    AR30.1    AR30.2    AR30.4
AR570     AR575     AR580     AR82.1    CB06.2    CB10.1
CB15.1    CB15.2    CB175     CB180     CB185     CB190
CB191     CB20.1    CB25.1    CB30.1    CB300     CB500
CB80.1    DT180     DT181     DT185     DT92.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CBD-CASH-CODE          Alpha 4                                   AP170   AP180
Accounts Receivable    The cash code. Represents a bank          AP181   AP190
Code                   account. Must be a valid record in the    AP255   AP265
                       Cash Code file.                           AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-BANK-INST-CODE     Alpha 3                                   AP170   AP180
Element: Transaction CoThe transaction code. Represents a type   AP181   AP190
                       of cash payment, bill of exchange         AP255   AP265
                       payment, or bank service transaction.     AP81.1  AP90.5
                       Must be a valid record in the Bank        AR115   AR124
                       Transaction Code file.                    AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-TRANS-IDENT        Numeric 10                                AP170   AP180
Element: Transaction IDA unique system-generated                 AP181   AP190
                       identification value assigned to the      AP255   AP265
                       transaction to make this record unique.   AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-TRANS-NBR          Alpha 10  (Right Justified)               AP170   AP180
Element: Transaction NuThe unique number used to identify the    AP181   AP190
                       transaction. Must be a valid record in    AP255   AP265
                       the Bank Transaction file.                AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-SUFFIX             Numeric 3                                 AP170   AP180
Element: Transaction SuThe transaction suffix number.            AP181   AP190
                       Represents the occurrence value of the    AP255   AP265
                       transaction.                              AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-SOURCE-CODE        Alpha 2                                   AP170   AP180
Element: Source Code   Identifies where the bank transaction     AP181   AP190
                       was created. Valid values are:            AP255   AP265
                                                                 AP81.1  AP90.5
                       AP = Accounts Payable.                    AR115   AR124
                       AR = Accounts Receivable.                 AR20.1  AR21.1
                       CB = Cash Ledger.                         AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-COMPANY            Numeric 4                                 AP170   AP180
Element: Company       The company number that initiated or      AP181   AP190
                       created the transaction. Must be a valid  AP255   AP265
                       record in the General Ledger Company      AP81.1  AP90.5
                       file.                                     AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-SEQ-NBR            Numeric 4                                 AP170   AP180
Element: Sequence NumbeContains a system-assigned sequence       AP181   AP190
                       number.                                   AP255   AP265
                                                                 AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-DIST-COMPANY       Numeric 4                                 AP170   AP180
Element: Company       The company number the bank transaction   AP181   AP190
                       is to be posted to. Must be a valid       AP255   AP265
                       record in the General Ledger Company      AP81.1  AP90.5
                       file.                                     AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-DIST-TYPE          Alpha 1                                   AP170   AP180
Element: Distribution TThe distribution type. Valid values are:  AP181   AP190
                                                                 AP255   AP265
                       E = Entry.                                AP81.1  AP90.5
                       R = Reconciliation.                       AR115   AR124
                       V = Cash Ledger Void Update               AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-RECORD-TYPE        Alpha 1                                   AP170   AP180
Element: Record Type   Identifies the type of distribution       AP181   AP190
                       record. Valid values are:                 AP255   AP265
                                                                 AP81.1  AP90.5
                       C = Cash Account Distribution.            AR115   AR124
                       Blank = Not a cash account distribution.  AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-REC-STATUS         Numeric 1                                 AP170   AP180
Element: Record Status The status of the transaction             AP181   AP190
                       distribution. Valid values are:           AP255   AP265
                                                                 AP81.1  AP90.5
                       0 = Unreleased.                           AR115   AR124
                       1 = Released.                             AR20.1  AR21.1
                       9 = Posted.                               AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB175   CB180
                                                                 CB185   CB190
                                                                 CB191   CB20.1
                                                                 CB25.1  CB30.1
                                                                 CB500   CB80.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-POST-DATE          Numeric 8  (yyyymmdd)                     AP170   AP180
Element: Date          The date for using to post the            AP181   AP190
                       transaction to the general ledger.        AP255   AP265
                                                                 AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-DIS-ACCT-UNIT      Alpha 15                                  AP170   AP180
Element: Accounting UniThe general ledger distribution           AP181   AP190
                       accounting unit. Must be a valid record   AP255   AP265
                       in the General Ledger Names file.         AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-DIS-ACCOUNT        Numeric 6                                 AP170   AP180
Element: Account       The general ledger distribution account   AP181   AP190
                       number. Must be a valid record in the     AP255   AP265
                       General Ledger Account Master file.       AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-DIS-SUB-ACCT       Numeric 4                                 AP170   AP180
Element: Subaccount    The general ledger distribution           AP181   AP190
                       subaccount number. Must be a valid        AP255   AP265
                       record in the General Ledger Account      AP81.1  AP90.5
                       Master file.                              AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-ACT-CNV-RATE       Signed 12.6                               AP170   AP180
Element: Exchange Rate The currency exchange rate used to        AP181   AP190
                       convert the bank account currency         AP255   AP265
                       distribution amount to the company base   AP81.1  AP90.5
                       currency.                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-BANK-DIST-AMT      Signed 15.2                               AP170   AP180
Acct Currency          The distribution amount in the currency   AP181   AP190
Distribution Amt       of the bank account.                      AP255   AP265
                                                                 AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-ORIG-BASE-AMT      Signed 15.2                               AP170   AP180
Base Currency          The distribution amount in the base       AP181   AP190
Distribution Amt       currency of the originating company.      AP255   AP265
                                                                 AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-DIST-BASE-AMT      Signed 15.2                               AP170   AP180
To Company             The distribution amount in the base       AP181   AP190
Distribution Amount    currency of the distribution company.     AP255   AP265
                                                                 AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-TO-BNK-DST-AMT     Signed 15.2                               AP170   AP180
To Acct Curr           The distribution amount in the currency   AP181   AP190
Distribution Amt       of the to bank account.                   AP255   AP265
                                                                 AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-REFERENCE          Alpha 10  (Lower Case)                    AP170   AP180
Element: Requester     The reference value assigned to the       AP181   AP190
                       transaction distribution. Used for        AP255   AP265
                       informational purposes.                   AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-DESCRIPTION        Alpha 30  (Lower Case)                    AP170   AP180
Element: Description   The description of the transaction        AP181   AP190
                       distribution.                             AP255   AP265
                                                                 AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-ACTIVITY           Alpha 15                                  AP170   AP180
Element: Activity      The activity assigned to the bank         AP181   AP190
                       transaction distribution. Must be a       AP255   AP265
                       valid record in the Activity Header       AP81.1  AP90.5
                       file.                                     AR115   AR124
                                                                 AR20.1  AR21.1
                       Activities are the tasks that make up     AR21.2  AR21.3
                       an activity group. Activities identify    AR24.1  AR30.1
                       work being done, such as work orders,     AR30.2  AR30.4
                       phases, products, and so on. A variety    AR570   AR575
                       of costs, revenues, or both make up an    AR580   AR82.1
                       activity.                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-TAX-CODE           Alpha 10                                  CB10.1  CB180
Element: Tax Code      The tax code to be applied to the bank    CB20.1  CB30.1
                       transaction distribution. Must be a       CB500
                       valid record in the Tax Code file.

CBD-TRAN-TAXABLE       Signed 15.2                               CB10.1  CB180
Element: Item Tax      The taxable amount of the bank            CB20.1  CB30.1
                       transaction distribution in the currency  CB500
                       of the bank account.

CBD-TAX-TYPE           Alpha 1                                   CB180   CB20.1
Element: Tax Type      If a Tax Code is present, this field      CB30.1  CB500
                       indicates the type of tax. Valid values
                       are:

                       I = Invoiced. The tax amount is
                       included in the transaction amount.

CBD-TO-BASE-ND         Numeric 1                                 AP170   AP180
Account Currency       The number of decimal places defined      AP181   AP190
Code                   for the base currency of the              AP255   AP265
                       distribution company.                     AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-TO-TRAN-ND         Numeric 1                                 AP170   AP180
To Transaction Nbr     The number of decimal places defined      AP181   AP190
of Decimals            for the currency of the to bank account.  AP255   AP265
                                                                 AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-TRAN-ND            Numeric 1                                 AP170   AP180
Transaction Number     The number of decimal places defined      AP181   AP190
of Decimals            for the base currency of the originating  AP255   AP265
                       company.                                  AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-BASE-ND            Numeric 1                                 AP170   AP180
Base Currency Nbr      The number of decimal places defined      AP181   AP190
of Decimals            for the currency of the bank account.     AP255   AP265
                                                                 AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-GLT-OBJ-ID         Numeric 12                                AP170   AP180
Object                                                           AP181   AP190
Identification                                                   AP255   AP265
                                                                 AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB175   CB180
                                                                 CB185   CB190
                                                                 CB191   CB20.1
                                                                 CB25.1  CB30.1
                                                                 CB500   CB80.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-ACT-OBJ-ID         Numeric 12                                AP170   AP180
Object                                                           AP181   AP190
Identification                                                   AP255   AP265
                                                                 AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB175   CB180
                                                                 CB185   CB190
                                                                 CB191   CB20.1
                                                                 CB25.1  CB30.1
                                                                 CB500   CB80.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-ACCT-CATEGORY      Alpha 5                                   CB10.1  CB191
Element: Account CategoThe account category assigned to the      CB20.1  CB30.1
                       bank transaction distribution. Must be a
                       valid record in the Activity Account
                       Category file.

                       Account categories are the Activity
                       Management accounts by which activity
                       transactions are grouped for budgeting
                       and reporting.

CBD-ANALYSIS-FLD       Alpha 32                                  CB20.1  CB30.1
Element: Analysis FieldThe user-defined analysis field
                       assigned to the bank transaction
                       distribution.

CBD-RECON-STMT-NBR     Numeric 12
Reconciliation         The bank-assigned reconciliation
Statement              statement number. Used only for cash
                       codes that require reconciliation
                       statements.

                         CBDISTRIB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CBDSET1   CASH-CODE     The index is used to group all general   AP170   AP180
          BANK-INST-CODEledger distributions for a bank          AP181   AP190
          TRANS-IDENT   transaction.                             AP255   AP265
          DIST-TYPE                                              AP81.1  AP90.5
          SEQ-NBR                                                AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB175   CB180
                                                                 CB185   CB190
                                                                 ...

CBDSET2   DIST-COMPANY  This index is used to sequence general
          DIS-ACCT-UNIT ledger distributions by general ledger
          DIS-ACCOUNT   account number.
          DIS-SUB-ACCT  KeyChange
          GLT-OBJ-ID
          CASH-CODE
          TRANS-NBR
          BANK-INST-CODE
          DIST-TYPE
          SEQ-NBR
          TRANS-IDENT

CBDSET3   ACT-OBJ-ID    This index is used to show the
          CASH-CODE     committed cost in Cash Ledger for the
          BANK-INST-CODEActivity Management system.
          TRANS-IDENT   KeyChange, Subset
          DIST-TYPE     Where ACT-OBJ-ID != Zeroes
          SEQ-NBR

CBDSET4   COMPANY       KeyChange                                CB175   CB191
          REC-STATUS                                             CB195   CB20.1
          CASH-CODE                                              CB30.1  CB500
          BANK-INST-CODE
          TRANS-IDENT
          DIST-TYPE
          SEQ-NBR

                         CBDISTRIB FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cbbankent      CBBANKENT    Required

                            CBC-BANK-ENTITY       -> CBE-BANK-ENTITY

Cbcashcode     CBCASHCODE   Required

                            CBD-CASH-CODE         -> CBC-CASH-CODE

Cbsegblock     CBSEGBLOCK   Required

                            CBD-CASH-CODE         -> CBK-CASH-CODE
                            CBD-BANK-INST-CODE    -> CBK-BANK-INST-CODE
                            CBD-TRANS-IDENT       -> CBK-TRANS-IDENT
                            CBD-DIST-TYPE         -> CBK-DIST-TYPE
                            CBD-SEQ-NBR           -> CBK-SEQ-NBR

Cbstatemnt     CBSTATEMNT   Not Required
                            Valid When CBD-RECON-STMT-NBR != Zeroes

                            CBD-CASH-CODE         -> CSM-CASH-CODE
                            CBD-RECON-STMT-NBR    -> CSM-RECON-STMT-NBR

Cbstmtdtl      CBSTMTDTL    Required
                            When CBD-RECON-STMT-NBR != Zeroes

                            CBD-BANK-INST-CODE    -> CSD-BANK-INST-CODE
                            CBD-RECON-STMT-NBR    -> CSD-RECON-STMT-NBR
                            CBD-TRANS-NBR         -> CSD-PAYMENT-NBR
                            "G"                   -> CSD-TRANS-TYPE
                            CBD-CASH-CODE         -> CSD-CASH-CODE

Cbtrans        CBTRANS      Required

                            CBD-BANK-INST-CODE    -> CBT-BANK-INST-CODE
                            CBD-TRANS-IDENT       -> CBT-TRANS-IDENT

Glmaster       GLMASTER     Required

                            CBD-DIST-COMPANY      -> GLM-COMPANY
                            CBD-DIS-ACCT-UNIT     -> GLM-ACCT-UNIT
                            CBD-DIS-ACCOUNT       -> GLM-ACCOUNT
                            CBD-DIS-SUB-ACCT      -> GLM-SUB-ACCOUNT

Glsystem       GLSYSTEM     Required

                            CBD-DIST-COMPANY      -> GLS-COMPANY

Glsystem Orig  GLSYSTEM     Required

                            CBD-COMPANY           -> GLS-COMPANY