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
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 AP10.1 AP10.2 AP110 AP111 AP115
AP125 AP126 AP131 AP14.5 AP16.1 AP195
AP210 AP213 AP220 AP271 AP284 AP30.2
AP30.4 AP300 AP510 AP57.2 API1.1 API2.1
API3.1 API4.1 ZA586 CB80.1 CB82.1 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CXCP.1 EE135 EE520 DR100
IC140 IC142 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 IC840 MX123 MX500 MA180 MA279
MA310 MA530 MA531 MA60.2 MA60.3 MA60.4
MA60.5 MA61.1 MA63.1 MA64.6 MA64.9 MA65.1
MA66.1 MA66.2 MA66.3 MA67.2 MA67.3 MA68.2
MA68.3 MA68.4 MA68.5 MA69.1 MA70.1 MA75.1
MA80.1 MAED.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PD235 PO10.1 PO100
PO101 PO120 PO122 PO131 PO136 PO150
PO190 PO20.1 PO20.6 PO20.9 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.2 PO22.3
PO22.4 PO22.5 PO220 PO223 PO23.1 PO233
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO253
PO254 PO27.2 PO278 PO28.2 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 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 UK47.1 RQ10.1 RQ10.2 RQ10.4
RQ12.1 RQ13.1 RQ13.2 RQ260 RQ35.1 RQ500
RQIF.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
ZW130


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 AP255
AP26.1 AP265 AP27.1 AP305 AP520 AP55.1
AP55.2 AP81.1 AP90.5 AP91.1 ZA161 CB06.2
CB191 CB20.1 CB300 CB50.1 CB500 CB85.1
EE20.1 EE20.2 EE35.1 EE35.2 MA41.1 MA41.2
MA41.4 MA41.7 MA42.2 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA44.1 MA44.2

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-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 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


CBCHECK FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CHKSET1 CASH-CODE
BANK-INST-CODE
TRANS-IDENT
...
AP10.1 AP10.2
AP110 AP111
AP125 AP126
AP14.5 AP155
AP16.1 AP160
AP161 AP170
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP213 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP284 AP30.2
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
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 11:11:38 2016

Home
Contact Us



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