Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBCHECK


                              CBCHECK FILE

                     Accounts Payable Cash Payment

The Accounts Payable Cash Payment file contains all accounts payable cash
payment records for a cash code (bank account).

REFERENCED BY

AP213     AP284     AP57.2    AP90.5    AP90.1    AP195
AP255     AP265     AP520     CB20.1    CB50.1    CB80.1
CB82.1    AC160     AM115     AM117     AM15.1    AM15.2
AM15.3    AM15.4    AM19.1    AM19.2    AM20.1    AM20.3
AM21.1    AM21.3    AM500     AM51.1    AM551     AM97.1
AP03.3    AP110     AP115     AP125     AP126     AP131
AP210     AP220     AP30.2    AP30.4    AP300     AP510
AP91.1    API1.1    API2.1    API3.1    API4.1    BL120
BL122     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     BL92.1    MX123
MX500     MA180     MA279     MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA63.1    MA65.1    MA66.2
MA66.3    MA67.2    MA67.3    MA68.2    MA68.3    MA68.5
MA70.1    MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2
PD130     PD20.1    PD20.2    PD20.3    PD235     PO10.1
PO100     PO101     PO120     PO122     PO131     PO20.1
PO21.1    PO21.2    PO21.3    PO21.4    PO21.5    PO22.1
PO220     PO223     PO23.1    PO233     PO24.1    PO25.1
PO25.5    PO25.6    PO25.7    PO253     PO254     PO27.2
PO278     PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.2    PO32.4    PO33.1    PO34.1
PO35.1    PO36.1    PO36.2    PO38.1    PO39.1    PO39.2
PO44.1    PO50.1    PO52.1    PO520     PO536     PO54.1
PO54.2    PO54.3    PO54.4    POI3.1    POID.1    POII.1
POIJ.1    PR05.1    PR05.3    PR226     PR247     PR26.1
PR47.1    PR514     UK47.1    RQ10.1    RQ10.2    WH20.2
WH20.7

UPDATED BY

AP150     AP155     AP160     AP161     AP170     AP190
AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.6
AP20.7    AP20.8    AP21.1    AP23.1    AP25.2    AP26.1
AP27.1    AP305     AP55.1    AP55.2    AP81.1    CB06.2
CB191     CB300     CB500     CB85.1    EE20.1    EE20.2
EE35.1    EE35.2    MA41.1    MA41.2    MA41.4    MA41.7
MA43.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CHK-CASH-CODE          Alpha 4                                   AP150   AP155
Element: Cash Code     The cash code. Represents the bank        AP20.1  AP20.2
                       account the payment was issued from.      AP20.3  AP20.4
                       Must be a valid record in the Cash Code   AP20.5  AP20.6
                       file.                                     AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP55.1
                                                                 AP81.1  CB06.2
                                                                 CB500   EE20.1
                                                                 EE20.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

CHK-BANK-INST-CODE     Alpha 3                                   AP150   AP155
Element: Payment Code  The payment code. Represents the type     AP20.1  AP20.2
                       of cash payment. Must be a valid cash     AP20.3  AP20.4
                       payment type transaction code record in   AP20.5  AP20.6
                       the Bank Transaction Code file.           AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP55.1
                                                                 AP81.1  CB06.2
                                                                 CB500   EE20.1
                                                                 EE20.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

CHK-TRANS-NBR          Alpha 10  (Right Justified)               AP150   AP155
Element: Payment NumberThe payment number. Represents a unique   AP160   AP161
                       value used to identify the cash payment   AP20.1  AP20.2
                       transaction.                              AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP55.1  AP81.1
                                                                 CB06.2  CB500
                                                                 EE20.1  EE20.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-TRANS-IDENT        Numeric 10                                AP150   AP155
Element: Transaction IDAn identification number assigned by      AP20.1  AP20.2
                       the system upon creation. Used as a       AP20.3  AP20.4
                       unique identifier by the system.          AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP55.1  AP81.1
                                                                 CB06.2  CB500
                                                                 EE20.1  EE20.2
                                                                 EE35.1  EE35.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-COMPANY            Numeric 4                                 AP150   AP155
Element: Company       The company number. Must be a valid       AP20.1  AP20.2
                       record in the Accounts Payable Company    AP20.3  AP20.4
                       file.                                     AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP55.1
                                                                 AP81.1  CB06.2
                                                                 CB500   EE20.1
                                                                 EE20.2  EE35.1
                                                                 EE35.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

CHK-PROC-LEVEL         Alpha 5                                   AP150   AP20.1
Element: Process Level The process level. Must be a valid        AP20.2  AP20.3
                       record in the Process Level file.         AP20.4  AP20.5
                       Updated only when AP150 (Cash             AP20.6  AP20.7
                       Requirements) is run by process level.    AP20.8  AP21.1
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP55.1  AP81.1
                                                                 CB06.2  CB500
                                                                 EE20.1  EE20.2
                                                                 EE35.1  EE35.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-REC-STATUS         Numeric 1                                 AP150   AP155
Element: Reconcile StatThe payment record status. Valid values   AP160   AP161
                       are:                                      AP170   AP190
                                                                 AP20.1  AP20.2
                       0 = Scheduled by AP150.                   AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                       1 = Processed by AP155 or AP160 or a      AP20.7  AP20.8
                       manual payment entered in AP20 or AP55.   AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                       2 = Closed by AP170.                      AP27.1  AP55.1
                                                                 AP81.1  CB06.2
                       3 = Tape Reject (not reinstated).         CB500   CB85.1
                                                                 EE20.1  EE20.2
                       4 = Tape Reject (reinstated).             EE35.1  EE35.2
                                                                 MA41.1  MA41.2
                       5 = Temporary Void.                       MA41.4  MA41.7
                                                                 MA43.2
                       9 = Reserved for Manual Payment.

CHK-VENDOR-GROUP       Alpha 4                                   AP150   AP20.1
Element: Vendor Group  The vendor group associated with the      AP20.2  AP20.3
                       pay vendor. Must be a valid record in     AP20.4  AP20.5
                       the Vendor Group file.                    AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP55.1  AP81.1
                                                                 CB06.2  CB500
                                                                 EE20.1  EE20.2
                                                                 EE35.1  EE35.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-PAY-GROUP          Alpha 4                                   AP150   AP155
Element: Pay Group     The pay group. Must be a valid record     AP20.1  AP20.2
                       in the Pay Group file.                    AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP55.1  AP81.1
                                                                 CB500   EE20.1
                                                                 EE20.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

CHK-PAID-VENDOR        Alpha 9  (Right Justified)                AP150   AP20.1
Element: Pay Vendor    The vendor the payment was issued to.     AP20.2  AP20.3
                       Must be a valid record in the Vendor      AP20.4  AP20.5
                       file.                                     AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP55.1  AP81.1
                                                                 CB06.2  CB500
                                                                 EE20.1  EE20.2
                                                                 EE35.1  EE35.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-PAID-NAME          Alpha 30                                  AP150   AP155
Element: Pay Vendor NamThe name of the vendor the payment was    AP20.1  AP20.2
                       issued to.                                AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP55.1
                                                                 AP81.1  CB06.2
                                                                 CB500   EE20.1
                                                                 EE20.2  EE35.1
                                                                 EE35.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

CHK-REMIT-TO-CODE      Alpha 4                                   AP150   AP20.1
Element: Remit To Code The remit-to location the payment was     AP20.2  AP20.3
                       issued to, if applicable. Represents an   AP20.4  AP20.5
                       alternate remittance location for the     AP20.6  AP20.7
                       vendor. Must be a valid remit-to type     AP20.8  AP21.1
                       location record in the Vendor Location    AP23.1  AP25.2
                       file.                                     AP26.1  AP27.1
                                                                 AP55.1  AP81.1
                                                                 CB06.2  CB500
                                                                 EE20.1  EE20.2
                                                                 EE35.1  EE35.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-BASE-PMT-AMT       Signed 18.2                               AP150   AP20.1
Element: Base Payment AThe amount of the payment in the          AP20.2  AP20.3
                       company base currency.                    AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP55.1  AP81.1
                                                                 CB06.2  CB500
                                                                 EE20.1  EE20.2
                                                                 EE35.1  EE35.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-BASE-ND            Numeric 1                                 AP150   AP20.1
Base Number of         The number of decimal places defined      AP20.2  AP20.3
Decimals               for the company base currency.            AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP55.1
                                                                 AP81.1  CB06.2
                                                                 CB500   EE20.1
                                                                 EE20.2  EE35.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-TRAN-PMT-AMT       Signed 18.2                               AP150   AP20.1
Transaction Payment    The amount of the invoices to be          AP20.2  AP20.3
Amount                 applied to the payment in the currency    AP20.4  AP20.5
                       of the invoices.                          AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP55.1  AP81.1
                                                                 CB06.2  CB500
                                                                 EE20.1  EE20.2
                                                                 EE35.1  EE35.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-TRAN-ND            Numeric 1                                 AP150   AP20.1
Transaction Number     The number of decimal places defined      AP20.2  AP20.3
of Decimals            for the invoice currency.                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP55.1
                                                                 AP81.1  CB06.2
                                                                 CB500   EE20.1
                                                                 EE20.2  EE35.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-TOT-INV-PAID       Signed 18.2                               AP150   AP20.1
Element: Total Invoice The total amount of invoices applied to   AP20.2  AP20.3
                       the payment in invoice currency.          AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP55.1  AP55.2
                                                                 AP81.1  CB06.2
                                                                 CB500   EE20.1
                                                                 EE20.2  EE35.1
                                                                 EE35.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

CHK-CHECK-DATE         Numeric 8  (yyyymmdd)                     AP150   AP155
Element: Check Date    The payment date assigned to the payment  AP160   AP161
                       in AP20, AP55, AP155, AP157, AP160, or    AP20.1  AP20.2
                       AP161.                                    AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP55.1
                                                                 AP81.1  CB06.2
                                                                 CB500   EE20.1
                                                                 EE20.2  EE35.1
                                                                 EE35.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

CHK-PAY-CURRENCY       Alpha 5                                   AP150   AP20.1
Element: Payment CurrenThe currency of the payment.              AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP55.1  AP81.1
                                                                 CB06.2  CB500
                                                                 EE20.1  EE20.2
                                                                 EE35.1  EE35.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-ACT-CNV-RATE       Signed 14.7                               AP150   AP20.1
Trans to Base          The currency exchange rate in effective   AP20.2  AP20.3
Exchange Rate          at the time of payment. Used to convert   AP20.4  AP20.5
                       the payment amount from the invoice       AP20.6  AP20.7
                       currency to the company base currency.    AP20.8  AP21.1
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP55.1  AP81.1
                                                                 CB06.2  CB500
                                                                 EE20.1  EE20.2
                                                                 EE35.1  EE35.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-SERIAL-NUM         Numeric 8                                 AP160   AP161
Element: Serial Number A system-defined number assigned to an    AP20.1  AP20.2
                       electronic payment tape created in AP160  AP20.3  AP20.4
                       (Payment Tape Creation) or an electronic  AP20.5  AP20.6
                       payment file in AP161 (Electonic Payment  AP20.7  AP20.8
                       Creation). This serial number is          AP21.1  AP23.1
                       required to recreate a payment tape in    AP55.1  AP81.1
                       AP160 or a file AP161.                    CB06.2  CB500
                                                                 EE20.1  EE20.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-CHECK-TYPE         Alpha 1                                   AP150   AP20.1
Payment Record         Identifies where the cash payment record  AP20.2  AP20.3
Origin                 originated. Valid values are:             AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                       Blank. A system generated payment         AP20.8  AP21.1
                       created in AP150, AP157, AP160, or        AP23.1  AP25.2
                       AP161.                                    AP26.1  AP27.1
                                                                 AP55.1  AP81.1
                       M = Manual. A manual payment created in   CB06.2  CB500
                       AP20 or AP55.                             EE20.1  EE20.2
                                                                 EE35.1  EE35.2
                       A = Alignment Form. A system voided       MA41.1  MA41.2
                       payment used as an alignment form in      MA41.4  MA41.7
                       AP155.                                    MA43.2

                       L = Leader Form. A system voided payment
                       used as a leader form in AP155.

                       O = Overflow Form. A system voided
                       payment used as an overflow form in
                       AP155.
                       C = CB Payment

CHK-RELEASE-FL         Alpha 1                                   AP20.1  AP20.2
Element: Release Flag  Indicates whether the payment has been    AP20.3  AP20.4
                       released. Valid values are:               AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                       N = No.                                   AP21.1  AP23.1
                       Y = Yes.                                  AP25.2  AP26.1
                                                                 AP27.1  AP55.1
                                                                 AP81.1  CB06.2
                                                                 CB191   CB500
                                                                 EE20.1  EE20.2
                                                                 EE35.1  EE35.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-BASE-APPL-AMT      Signed 18.2                               AP150   AP20.1
Base Application       The total amount of invoices applied to   AP20.2  AP20.3
Amount                 the payment in the company base           AP20.4  AP20.5
                       currency.                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP55.1  AP55.2
                                                                 AP81.1  CB06.2
                                                                 CB500   EE20.1
                                                                 EE20.2  EE35.1
                                                                 EE35.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

CHK-BANK-CURR-AMT      Signed 18.2                               AP150   AP20.1
Element: Bank Currency The payment amount in the currency of     AP20.2  AP20.3
                       the bank account.                         AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP55.1
                                                                 AP81.1  CB06.2
                                                                 CB500   EE20.1
                                                                 EE20.2  EE35.1
                                                                 EE35.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

CHK-BNK-CNV-RATE       Signed 14.7                               AP150   AP20.1
Trans to Bank          The currency exchange rate at the time    AP20.2  AP20.3
Exchange Rate          of payment. Used to convert the payment   AP20.4  AP20.5
                       amount from the invoice currency to the   AP20.6  AP20.7
                       bank account currency.                    AP20.8  AP21.1
                                                                 AP23.1  AP55.1
                                                                 AP81.1  CB500
                                                                 EE20.1  EE20.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-BANK-APPL-AMT      Signed 18.2                               AP150   AP20.1
Element: Bank Applied AThe amount of invoices applied to the     AP20.2  AP20.3
                       payment in the currency of the bank       AP20.4  AP20.5
                       account.                                  AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP55.1
                                                                 AP55.2  AP81.1
                                                                 EE20.1  EE20.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-BANK-ND            Numeric 1                                 AP150   AP20.1
Bank Number of         The number of decimals defined for the    AP20.2  AP20.3
Decimals               bank account currency.                    AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP55.1
                                                                 AP81.1  CB500
                                                                 EE20.1  EE20.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

CHK-REJECT-DATE        Numeric 8  (yyyymmdd)                     CB500   CB85.1
Element: Reject Date   If the payment was created in AP160 and
                       was rejected by the bank, this field
                       contains the date the tape payment
                       record was rejected by the bank.

CHK-SORT-OPTION1       Alpha 15                                  AP150   CB06.2
Element: Sort Option 1 Sort option one used for sorting the
                       payment in AP150.

CHK-SORT-OPTION2       Alpha 15                                  AP150   CB06.2
Element: Sort Option 2 Sort option 2 used for sorting the
                       payment in AP150.

CHK-SORT-OPTION3       Alpha 15                                  AP150   CB06.2
Element: Sort Option 3 Sort option 3 used for sorting the
                       payment in AP150.

CHK-INVOICE-GROUP      Alpha 4                                   AP150   AP20.1
Element: Invoice Group The invoice group assigned to the         AP20.2  AP20.3
                       payment.                                  AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

CHK-PROC-GRP           Alpha 4  (Lower Case)                     AP150   AP155
Element: Process Group A process group is an identifier used
                       for separating vendors into different
                       groups to enable concurrent processing
                       within the cash payment cycle.

CHK-CHK-STATUS         Derived
Element: Check Status  Indicates the status of the payment.

CHK-SHORT-PAYEE        Derived
Element: Short Payee   A sort name for the vendor.

CHK-RECON-STMT-NBR     Numeric 12                                AP55.1
Reconcile Statement    The bank-assigned reconciliation
Number                 statement number. Used only for cash
                       codes that require reconciliation
                       statements.


                         CBCHECK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CHKSET1   CASH-CODE                                              AP155   AP160
          BANK-INST-CODE                                         AP161   AP170
          TRANS-IDENT                                            AP190   AP20.6
                                                                 AP20.8  AP213
                                                                 AP284   AP57.2
                                                                 CB300   EE20.1
                                                                 EE20.2

CHKSET10  PAY-GROUP     KeyChange                                AP155   AP160
          REC-STATUS                                             AP161   AP170
          CASH-CODE
          BANK-INST-CODE
          PROC-GRP
          TRANS-NBR
          TRANS-IDENT

CHKSET2   PAY-GROUP     KeyChange                                AP161   AP90.5
          CASH-CODE                                              CB06.2  CB191
          BANK-INST-CODE
          TRANS-NBR
          TRANS-IDENT

CHKSET3   PAY-GROUP     KeyChange                                AP150   AP155
          REC-STATUS                                             AP160   AP161
          CASH-CODE                                              AP170   AP190
          BANK-INST-CODE                                         AP195   AP255
          TRANS-NBR                                              AP265   AP55.1
          TRANS-IDENT                                            AP55.2

CHKSET4   CASH-CODE     KeyChange                                AP155   AP160
          BANK-INST-CODE                                         AP161   AP190
          TRANS-NBR                                              AP20.1  AP20.2
          TRANS-IDENT                                            AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP520
                                                                 AP55.1  AP81.1
                                                                 CB06.2  CB20.1
                                                                 CB50.1  CB500
                                                                 EE20.1  EE20.2
                                                                 EE35.1  EE35.2
                                                                 MA41.1  MA41.2
                                                                 ...

CHKSET5   CASH-CODE     KeyChange                                AP160   AP161
          BANK-INST-CODE                                         AP190   CB300
          SERIAL-NUM                                             CB80.1  CB82.1
          TRANS-NBR                                              CB85.1
          TRANS-IDENT

CHKSET8   VENDOR-GROUP  KeyChange                                AC160   AM115
          PAID-VENDOR                                            AM117   AM15.1
          COMPANY                                                AM15.2  AM15.3
          CHECK-DATE*                                            AM15.4  AM19.1
          BANK-INST-CODE                                         AM19.2  AM20.1
          CASH-CODE                                              AM20.3  AM21.1
          TRANS-IDENT                                            AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP03.3
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 ...

CHKSET9   PAY-GROUP     KeyChange                                AP265
          CASH-CODE
          CHECK-DATE
          BANK-INST-CODE
          TRANS-NBR
          TRANS-IDENT

                         CBCHECK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            CHK-COMPANY           -> CPY-COMPANY

Approclev      APPROCLEV    Required
                            When (-REC-STATUS <  "9" )
                            And  (-PROC-LEVEL != Spaces )

                            CHK-COMPANY           -> APR-COMPANY
                            CHK-PROC-LEVEL        -> APR-PROC-LEVEL

Apvenmast      APVENMAST    Required

                            CHK-VENDOR-GROUP      -> VEN-VENDOR-GROUP
                            CHK-PAID-VENDOR       -> VEN-VENDOR

Cbcashcode     CBCASHCODE   Required

                            CHK-CASH-CODE         -> CBC-CASH-CODE

Cbcpycash      CBCPYCASH    Required

                            CHK-COMPANY           -> CBY-COMPANY
                            CHK-CASH-CODE         -> CBY-CASH-CODE

Cbtrans        CBTRANS      Not Required
                            Valid When CHK-SERIAL-NUM = Zeroes

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

Cbtrans Tape   CBTRANS      Not Required
                            Valid When CHK-SERIAL-NUM != Zeroes

                            CHK-BANK-INST-CODE    -> CBT-BANK-INST-CODE
                            CHK-SERIAL-NUM        -> CBT-SERIAL-NUM
                            CHK-TRANS-IDENT       -> CBT-TRANS-IDENT

Glsystem       GLSYSTEM     Required

                            CHK-COMPANY           -> GLS-COMPANY

                         CBCHECK FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apapphist      APAPPHIST

                            CHK-PAY-GROUP         -> AH3-PAY-GROUP
                            CHK-BANK-INST-CODE    -> AH3-BANK-INST-CODE
                            CHK-TRANS-IDENT       -> AH3-TRANS-IDENT
                                                     AH3-VENDOR
                                                     AH3-INVOICE
                                                     AH3-SUFFIX
                                                     AH3-CANCEL-SEQ
                                                     AH3-SEQ-NBR
                                                     AH3-VOID-SEQ
                                                     AH3-COMPANY

Appayment      APPAYMENT

                            CHK-PAY-GROUP         -> APP-PAY-GROUP
                            CHK-BANK-INST-CODE    -> APP-BANK-INST-CODE
                            CHK-TRANS-IDENT       -> APP-TRANS-IDENT
                                                     APP-VENDOR
                                                     APP-INVOICE
                                                     APP-SUFFIX
                                                     APP-CANCEL-SEQ
                                                     APP-SEQ-NBR
                                                     APP-VOID-SEQ
                                                     APP-COMPANY

Cbdistrib      CBDISTRIB

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

Cbpayment      CBPAYMENT

                            CHK-PAY-GROUP         -> CBM-PAY-GROUP
                            CHK-BANK-INST-CODE    -> CBM-BANK-INST-CODE
                            CHK-TRANS-IDENT       -> CBM-TRANS-IDENT
                                                     CBM-CASH-CODE