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     CB245     CB246     CB255     CB99.1
TX101

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    AR32.1    AR34.1
AR570     AR575     AR580     AR82.1    CB06.2    CB10.1
CB145     CB15.1    CB15.2    CB150     CB175     CB180
CB185     CB186     CB187     CB190     CB191     CB20.1
CB25.1    CB30.1    CB300     CB45.1    CB46.1    CB500
CB543     CB544     CB55.1    CB554     CB80.1    CB82.1
DT180     DT181     DT185     DT92.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CBD-CASH-CODE          Alpha 4                                   AP170   AP180
Element: Cash Code     The cash code. Represents a bank          AP181   AP190
                       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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB80.1  CB82.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. Must be a valid source       AP255   AP265
                       code.                                     AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-SEQ-NBR            Numeric 4                                 AP170   AP180
Element: Seq Nbr       Contains 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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-DIST-TYPE          Alpha 1                                   AP170   AP180
Element: Dist Type     The 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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.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
                       E = EFT Payment distribution.             AR20.1  AR21.1
                       P = CB Payment distribution.              AR21.2  AR21.3
                       O = Offset CB payment distribution        AR24.1  AR30.1
                       Blank = Not a cash account distribution.  AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-REC-STATUS         Numeric 1                                 AP170   AP180
Element: Rec 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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB175   CB180
                                                                 CB185   CB186
                                                                 CB187   CB190
                                                                 CB191   CB20.1
                                                                 CB25.1  CB30.1
                                                                 CB45.1  CB46.1
                                                                 CB500   CB543
                                                                 CB544   CB55.1
                                                                 CB554   CB80.1
                                                                 CB82.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-POST-DATE          Numeric 8  (yyyymmdd)                     AP170   AP180
Element: Post 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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-DIS-ACCT-UNIT      Alpha 15                                  AP170   AP180
Element: Acct Unit     The 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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-DIS-SUB-ACCT       Numeric 4                                 AP170   AP180
Element: Sub Acct      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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-ACT-CNV-RATE       Signed 14.7                               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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-BANK-DIST-AMT      Signed 18.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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-ORIG-BASE-AMT      Signed 18.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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-DIST-BASE-AMT      Signed 18.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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-TO-BNK-DST-AMT     Signed 18.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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-REFERENCE          Alpha 10  (Lower Case)                    AP170   AP180
Element: Reference     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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.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,     AR32.1  AR34.1
                       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
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

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

CBD-TRAN-TAXABLE       Signed 18.2                               CB10.1  CB145
Element: Intl Amt      The taxable amount of the bank            CB150   CB180
                       transaction distribution in the currency  CB20.1  CB30.1
                       of the bank account.                      CB45.1  CB46.1
                                                                 CB500   CB543
                                                                 CB55.1  CB554

CBD-TAX-TYPE           Alpha 1                                   CB145   CB150
Element: Tax Type      If a Tax Code is present, this field      CB180   CB20.1
                       indicates the type of tax. Valid values   CB30.1  CB45.1
                       are:                                      CB46.1  CB500
                                                                 CB554
                       I = Invoiced. The tax amount is
                       included in the transaction amount.

CBD-TO-BASE-ND         Numeric 1                                 AP170   AP180
Element: Acct Nd       The number of decimal places defined      AP181   AP190
                       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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-TRAN-ND            Numeric 1                                 AP170   AP180
Transaction Number     The number of decimal places defined for  AP181   AP190
of Decimals            the bank account currency.                AP255   AP265
                                                                 AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-BASE-ND            Numeric 1                                 AP170   AP180
Base Currency Nbr      The number of decimal places defined for  AP181   AP190
of Decimals            the 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
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 CB186   CB187
                                                                 CB190   CB191
                                                                 CB20.1  CB25.1
                                                                 CB30.1  CB45.1
                                                                 CB46.1  CB500
                                                                 CB543   CB544
                                                                 CB55.1  CB554
                                                                 CB80.1  CB82.1
                                                                 DT180   DT181
                                                                 DT185   DT92.1

CBD-GLT-OBJ-ID         Numeric 12                                AP170   AP180
Element: Obj Id        This is the object identifier. It is      AP181   AP190
                       used to relate commitments or posted      AP255   AP265
                       transactions back to the originating      AP81.1  AP90.5
                       subsystems. Each subsystem record that    AR115   AR124
                       is updated as a commitment or posted      AR20.1  AR21.1
                       transaction is assigned an object         AR21.2  AR21.3
                       identifier. The object identifier is      AR24.1  AR30.1
                       maintained in the subsystem files and in  AR32.1  AR34.1
                       the Activity Commitments Detail and       AR570   AR575
                       Activity Transaction files. The object    AR580   AR82.1
                       identifier is a unique key used to drill  CB06.2  CB10.1
                       back from Activity Management to the      CB145   CB15.1
                       subsystems.                               CB15.2  CB150
                                                                 CB175   CB180
                                                                 CB185   CB186
                                                                 CB187   CB190
                                                                 CB191   CB20.1
                                                                 CB25.1  CB30.1
                                                                 CB45.1  CB46.1
                                                                 CB500   CB543
                                                                 CB544   CB55.1
                                                                 CB554   CB80.1
                                                                 CB82.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-ACT-OBJ-ID         Numeric 12                                AP170   AP180
Element: Obj Id        This is the object identifier. It is      AP181   AP190
                       used to relate commitments or posted      AP255   AP265
                       transactions back to the originating      AP81.1  AP90.5
                       subsystems. Each subsystem record that    AR115   AR124
                       is updated as a commitment or posted      AR20.1  AR21.1
                       transaction is assigned an object         AR21.2  AR21.3
                       identifier. The object identifier is      AR24.1  AR30.1
                       maintained in the subsystem files and in  AR32.1  AR34.1
                       the Activity Commitments Detail and       AR570   AR575
                       Activity Transaction files. The object    AR580   AR82.1
                       identifier is a unique key used to drill  CB06.2  CB10.1
                       back from Activity Management to the      CB145   CB15.1
                       subsystems.                               CB15.2  CB150
                                                                 CB175   CB180
                                                                 CB185   CB186
                                                                 CB187   CB190
                                                                 CB191   CB20.1
                                                                 CB25.1  CB30.1
                                                                 CB45.1  CB46.1
                                                                 CB500   CB543
                                                                 CB544   CB55.1
                                                                 CB554   CB80.1
                                                                 CB82.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBD-ACCT-CATEGORY      Alpha 5                                   CB10.1  CB145
Element: Acct Category The account category assigned to the      CB15.1  CB15.2
                       bank transaction distribution. Must be a  CB150   CB191
                       valid record in the Activity Account      CB20.1  CB30.1
                       Category file.                            CB45.1  CB46.1
                                                                 CB500   CB543
                       Account categories are the Activity       CB544   CB55.1
                       Management accounts by which activity     CB554
                       transactions are grouped for budgeting
                       and reporting.

CBD-ANALYSIS-FLD       Alpha 32                                  CB145   CB20.1
Element: Analysis Fld  Currently not in use.                     CB30.1

CBD-RECON-STMT-NBR     Numeric 12                                CB145
Element: Recon Stmt NbrThe bank-assigned reconciliation
                       statement number. Used only for cash
                       codes that require reconciliation
                       statements.


CBD-TAX-AMOUNT         Signed 18.2                               CB150   CB45.1
Element: Intl Amt

CBD-BASE-TAX-AMT       Signed 18.2                               CB150   CB45.1
Element: Intl Amt

                         CBDISTRIB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CBDSET1   CASH-CODE                                              AP170   AP180
          BANK-INST-CODE                                         AP181   AP190
          TRANS-IDENT                                            AP255   AP265
          DIST-TYPE                                              AP81.1  AP90.5
          SEQ-NBR                                                AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB175   CB180
                                                                 ...

CBDSET2   DIST-COMPANY  KeyChange                                CB55.1
          DIS-ACCT-UNIT
          DIS-ACCOUNT
          DIS-SUB-ACCT
          GLT-OBJ-ID
          CASH-CODE
          TRANS-NBR
          BANK-INST-CODE
          DIST-TYPE
          SEQ-NBR
          TRANS-IDENT

CBDSET3   ACT-OBJ-ID    KeyChange, Subset
          CASH-CODE     Where ACT-OBJ-ID != Zeroes
          BANK-INST-CODE
          TRANS-IDENT
          DIST-TYPE
          SEQ-NBR

CBDSET4   COMPANY       KeyChange                                CB150   CB175
          REC-STATUS                                             CB191   CB195
          CASH-CODE                                              CB20.1  CB30.1
          BANK-INST-CODE                                         CB45.1  CB46.1
          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

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

                         CBDISTRIB FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cbstmtdtl      CBSTMTDTL

                            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
                                                     CSD-LINE-NBR