CBCHECK

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
AP10.1 AP10.2 AP100 AP109 AP111 AP14.1
AP14.2 AP14.5 AP151 AP16.1 AP16.2 AP180
AP181 AP193 AP213 AP225 AP28.1 AP28.2
AP284 AP520 AP57.2 AP590 CB00.1 CB10.1
CB150 EE135 EE520 MA64.6 MA64.9 MAED.1
AP255 CB20.1 CB50.1


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 AP25.1
AP26.1 AP27.1 AP30.3 AP30.2 AP30.4 AP305
AP55.1 AP55.2 AP81.1 ZA161 CB06.2 CB191
CB300 CB500 CB55.1 CB85.1 EE20.1 EE20.2
EE35.1 EE35.2 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA42.1 MA43.2 MA43.1 MA43.3 MA43.4
MA43.6 MA43.7 MA44.1 MA44.2 AP110 AP115
AP125 AP126 AP300 AP510 API1.1 API2.1
IC64.6 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.7 IC64.8 IC64.9 MA60.2 MA60.3 MA60.5
MA61.1 MA65.1 MA66.2 MA67.3 MA67.2 MA68.2
MA68.3 MA68.5 MA70.1 MA75.1 MAI1.1 AP90.1
AP195 AP265 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 AM22.1
AM500 AM51.1 AM551 AM97.1 AP03.3 AP131
AP210 AP220 AP271 AP91.1 API3.1 API4.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC12.1
IC140 IC141 IC142 IC145 IC243 IC330
IC66.1 IC83.1 IC840 MX123 MX500 MA126
MA180 MA278 MA279 MA53.1 MA530 MA531
MA540 MA63.1 MA69.1 MA80.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PD235 PD570
PO04.1 PO04.2 PO10.1 PO10.2 PO100 PO101
PO115 PO120 PO122 PO131 PO132 PO136
PO15.1 PO15.2 PO15.4 PO150 PO17.1 PO190
PO192 PO195 PO20.1 PO20.6 PO20.9 PO204
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.2 PO22.3 PO22.4 PO22.5 PO220 PO222
PO223 PO224 PO225 PO229 PO23.1 PO230
PO233 PO234 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO251 PO253 PO254 PO26.3 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO278 PO28.2 PO280 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 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 PO529 PO536 PO54.1 PO54.2
PO54.3 PO54.4 PO54.5 POCP.1 POI3.1 POID.1
POII.1 POIJ.1 PR05.1 PR05.3 PR226 PR247
PR26.1 PR47.1 PR514 RQ01.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ260 RQ35.1 RQ44.1 RQ500 RQ810
RQIB.1 RQIF.1 RQII.1 RQIJ.1 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CHK-CASH-CODE
Element: Cash Code
Alpha 4
The cash code. Represents the bank account the payment was issued from. Must be a valid record in the Cash Code file.
AP150 AP155
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 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
CHK-BANK-INST-CODE
Element: Payment Code
Alpha 3
The payment code. Represents the type of cash payment. Must be a valid cash payment type transaction code record in the Bank Transaction Code file.
AP150 AP155
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 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
CHK-TRANS-NBR
Element: Payment Number
Alpha 10 (Right Justified)
The payment number. Represents a unique value used to identify the cash payment transaction.
AP150 AP155
AP160 AP161
AP20.1 AP20.2
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
MA42.2 MA43.2
MA44.1 MA44.2
ZA161
CHK-TRANS-IDENT
Element: Transaction ID
Numeric 10
An identification number assigned by the system upon creation. Used as a unique identifier by the system.
AP150 AP155
AP20.1 AP20.2
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
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
CHK-TRANS-ID-CBT
Element: Trans Id Cbt
Numeric 10
CHK-COMPANY
Element: Company
Numeric 4
The company number. Must be a valid record in the Accounts Payable Company file.
AP150 AP155
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 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
CHK-PROC-LEVEL
Element: Process Level
Alpha 5
The process level. Must be a valid record in the Process Level file. Updated only when AP150 (Cash Requirements) is run by process level.
AP150 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
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
CHK-REC-STATUS
Element: Reconcile Status
Numeric 1
The payment record status. Valid values are: 0 = Scheduled by AP150. 1 = Processed by AP155 or AP160 or a manual payment entered in AP20 or AP55. 2 = Closed by AP170. 3 = Tape Reject (not reinstated). 4 = Tape Reject (reinstated). 5 = Temporary Void. 9 = Reserved for Manual Payment.
AP150 AP155
AP160 AP161
AP170 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP225
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB500
CB85.1 EE20.1
EE20.2 EE35.1
EE35.2 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 ZA161
CHK-VENDOR-GROUP
Element: Vendor Group
Alpha 4
The vendor group associated with the pay vendor. Must be a valid record in the Vendor Group file.
AP150 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
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
CHK-PAY-GROUP
Element: Pay Group
Alpha 4
The pay group. Must be a valid record in the Pay Group file.
AP150 AP155
AP20.1 AP20.2
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 MA42.2
MA43.2 MA44.1
MA44.2
CHK-PAID-VENDOR
Element: Pay Vendor
Alpha 9 (Right Justified)
The vendor the payment was issued to. Must be a valid record in the Vendor file.
AP150 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
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
CHK-PAID-NAME
Element: Pay Vendor Name
Alpha 30
The name of the vendor the payment was issued to.
AP150 AP155
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 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
CHK-REMIT-TO-CODE
Element: Remit To Code
Alpha 4
The remit-to location the payment was issued to, if applicable. Represents an alternate remittance location for the vendor. Must be a valid remit-to type location record in the Vendor Location file.
AP150 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
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
CHK-BASE-PMT-AMT
Element: Base Payment Amount
Signed 18.2
The amount of the payment in the company base currency.
AP150 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
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
CHK-BASE-ND
Base Number of
Decimals
Numeric 1
The number of decimal places defined for the company base currency.
AP150 AP20.1
AP20.2 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 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
CHK-TRAN-PMT-AMT
Transaction Payment
Amount
Signed 18.2
The amount of the invoices to be applied to the payment in the currency of the invoices.
AP150 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
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
CHK-TRAN-ND
Transaction Number
of Decimals
Numeric 1
The number of decimal places defined for the invoice currency.
AP150 AP20.1
AP20.2 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 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
CHK-TOT-INV-PAID
Element: Total Invoice Paid
Signed 18.2
The total amount of invoices applied to the payment in invoice currency.
AP150 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
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 MA42.2
MA43.2 MA44.1
MA44.2
CHK-CHECK-DATE
Element: Check Date
Numeric 8 (yyyymmdd)
The payment date assigned to the payment in AP20, AP55, AP155, AP157, AP160, or AP161.
AP150 AP155
AP160 AP161
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 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 ZA161
CHK-PAY-CURRENCY
Element: Payment Currency
Alpha 5
The currency of the payment.
AP150 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
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
CHK-ACT-CNV-RATE
Trans to Base
Exchange Rate
Signed 14.7
The currency exchange rate in effective at the time of payment. Used to convert the payment amount from the invoice currency to the company base currency.
AP150 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
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
CHK-SERIAL-NUM
Element: Serial Number
Numeric 8
A system-defined number assigned to an electronic payment tape created in AP160 (Payment Tape Creation) or an electronic payment file in AP161 (Electonic Payment Creation). This serial number is required to recreate a payment tape in AP160 or a file AP161.
AP160 AP161
AP20.1 AP20.2
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
MA42.2 MA43.2
MA44.1 MA44.2
ZA161
CHK-CHECK-TYPE
Payment Record
Origin
Alpha 1
Identifies where the cash payment record originated. Valid values are: Blank. A system generated payment created in AP150, AP157, AP160, or AP161. M = Manual. A manual payment created in AP20 or AP55. A = Alignment Form. A system voided payment used as an alignment form in AP155. 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
AP150 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
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
CHK-RELEASE-FL
Element: Release Flag
Alpha 1
Indicates whether the payment has been released. Valid values are: N = No. Y = Yes.
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 AP55.1
AP81.1 CB06.2
CB191 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
CHK-BASE-APPL-AMT
Base Application
Amount
Signed 18.2
The total amount of invoices applied to the payment in the company base currency.
AP150 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
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 MA42.2
MA43.2 MA44.1
MA44.2
CHK-BANK-CURR-AMT
Element: Bank Currency Amount
Signed 18.2
The payment amount in the currency of the bank account.
AP150 AP20.1
AP20.2 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 EE35.1
EE35.2 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
CHK-BNK-CNV-RATE
Trans to Bank
Exchange Rate
Signed 14.7
The currency exchange rate at the time of payment. Used to convert the payment amount from the invoice currency to the bank account currency.
AP150 AP20.1
AP20.2 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
MA42.2 MA43.2
MA44.1 MA44.2
CHK-BANK-APPL-AMT
Element: Bank Applied Amount
Signed 18.2
The amount of invoices applied to the payment in the currency of the bank account.
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
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
MA42.2 MA43.2
MA44.1 MA44.2
CHK-BANK-ND
Bank Number of
Decimals
Numeric 1
The number of decimals defined for the bank account currency.
AP150 AP20.1
AP20.2 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
MA42.2 MA43.2
MA44.1 MA44.2
CHK-REJECT-DATE
Element: Reject Date
Numeric 8 (yyyymmdd)
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.
CB500 CB85.1
CHK-SORT-OPTION1
Element: Sort Option 1
Alpha 15
Sort option one used for sorting the payment in AP150.
AP150 CB06.2
CHK-SORT-OPTION2
Element: Sort Option 2
Alpha 15
Sort option 2 used for sorting the payment in AP150.
AP150 CB06.2
CHK-SORT-OPTION3
Element: Sort Option 3
Alpha 15
Sort option 3 used for sorting the payment in AP150.
AP150 CB06.2
CHK-INVOICE-GROUP
Element: Invoice Group
Alpha 4
The invoice group assigned to the payment.
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
CHK-PROC-GRP
Element: Process Group
Alpha 4 (Lower Case)
A process group is an identifier used for separating vendors into different groups to enable concurrent processing within the cash payment cycle.
AP150 AP155
CHK-CHK-STATUS
Element: Check Status
Derived
Indicates the status of the payment.
CHK-SHORT-PAYEE
Element: Short Payee
Derived
A sort name for the vendor.
CHK-RECON-STMT-NBR
Reconcile Statement
Number
Numeric 12
The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.
AP55.1
CHK-TEMP-HOLD
Element: Temp Hold
Alpha 1

S = Sent for Approval
A = Approved by Engine
AP150 AP30.3
CB55.1


CBCHECK FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CHKSET1 CASH-CODE
BANK-INST-CODE
TRANS-IDENT
...
AP10.1 AP10.2
AP100 AP109
AP110 AP111
AP115 AP125
AP126 AP14.1
AP14.2 AP14.5
AP150 AP151
AP155 AP16.1
AP16.2 AP160
AP161 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
CHKSET10 PAY-GROUP
REC-STATUS
CASH-CODE
BANK-INST-CODE
PROC-GRP
TRANS-NBR
TRANS-IDENT
KeyChange
AP155 AP160
AP161 AP170
ZA161
CHKSET2 PAY-GROUP
CASH-CODE
BANK-INST-CODE
TRANS-NBR
TRANS-IDENT
KeyChange
AP161 AP55.1
AP90.5 ZA161
CB06.2 CB191
CHKSET3 PAY-GROUP
REC-STATUS
CASH-CODE
BANK-INST-CODE
TRANS-NBR
TRANS-IDENT
KeyChange
AP150 AP155
AP160 AP161
AP170 AP190
AP195 AP255
AP265 AP55.1
AP55.2 ZA161
CHKSET4 CASH-CODE
BANK-INST-CODE
TRANS-NBR
TRANS-IDENT
KeyChange
...
AP155 AP160
AP161 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 AP520
AP55.1 AP81.1
ZA161 CB06.2
CB20.1 CB50.1
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.1
CHKSET5 CASH-CODE
BANK-INST-CODE
SERIAL-NUM
TRANS-NBR
TRANS-IDENT
KeyChange
AP160 AP161
AP190 ZA161
CB300 CB80.1
CB82.1 CB85.1
CHKSET7 CASH-CODE
BANK-INST-CODE
TRANS-IDENT
TRANS-ID-CBT
CHKSET8 VENDOR-GROUP
PAID-VENDOR
COMPANY
CHECK-DATE*
BANK-INST-CODE
CASH-CODE
TRANS-IDENT
KeyChange
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
CHKSET9 PAY-GROUP
CASH-CODE
CHECK-DATE
BANK-INST-CODE
TRANS-NBR
TRANS-IDENT
KeyChange
AP265


CBCHECK FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 02:12:01 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.