Lawson Insight Technical Documentation |
|
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 AP195 AP255
AP265 AP520 CB20.1 CB80.1 AM115 AM15.1
AM15.2 AM15.3 AM15.4 AM20.1 AM20.3 AM21.1
AM21.3 AM500 AM51.1 AM551 AM97.1 AP300
AP91.1 API3.1 API4.1 IC840 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 PR514 UK47.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 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.2 MA43.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CHK-CASH-CODE Alpha 4 AP150 AP155
Accounts Receivable The cash code. Represents the bank AP20.1 AP20.2
Code 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
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
MA41.2 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
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
MA41.2 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
AP23.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 MA41.2
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
AP23.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.2
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
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.2 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 AP23.1
AP25.2 AP26.1
AP27.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.2
MA43.2
CHK-REC-STATUS Numeric 1 AP150 AP155
Element: Record Status The 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. AP23.1 AP25.2
AP26.1 AP27.1
2 = Closed by AP170. AP55.1 AP81.1
CB06.2 CB500
3 = Tape Reject (not reinstated). CB85.1 EE20.1
EE20.2 EE35.1
4 = Tape Reject (reinstated). EE35.2 MA41.2
MA43.2
5 = Temporary Void.
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 AP23.1
AP25.2 AP26.1
AP27.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.2
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
AP23.1 AP55.1
AP81.1 CB500
EE20.1 EE20.2
MA41.2 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 AP23.1
AP25.2 AP26.1
AP27.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.2
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
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.2 MA43.2
CHK-REMIT-TO-CODE Alpha 4 AP150 AP20.1
Purchase From The remit-to location the payment was AP20.2 AP20.3
Location Code 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 AP23.1
location record in the Vendor Location AP25.2 AP26.1
file. AP27.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.2
MA43.2
CHK-BASE-PMT-AMT Signed 15.2 AP150 AP20.1
Element: Adj Amt The amount of the payment in the AP20.2 AP20.3
company base currency. AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP23.1
AP25.2 AP26.1
AP27.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.2
MA43.2
CHK-BASE-ND Numeric 1 AP150 AP20.1
Account Currency The number of decimal places defined AP20.2 AP20.3
Code for the company base currency. AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP23.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.2 MA41.2
MA43.2
CHK-TRAN-PMT-AMT Signed 15.2 AP150 AP20.1
Element: Adj Amt The amount of the invoices to be AP20.2 AP20.3
applied to the payment in the currency AP20.4 AP20.5
of the invoices. AP20.6 AP20.7
AP20.8 AP23.1
AP25.2 AP26.1
AP27.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.2
MA43.2
CHK-TRAN-ND Numeric 1 AP150 AP20.1
Account Currency The number of decimal places defined AP20.2 AP20.3
Code for the invoice currency. AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP23.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.2 MA41.2
MA43.2
CHK-TOT-INV-PAID Signed 15.2 AP150 AP20.1
Element: Detail Total 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 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.2 MA43.2
CHK-CHECK-DATE Numeric 8 (yyyymmdd) AP150 AP155
Element: 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
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.2 MA43.2
CHK-PAY-CURRENCY Alpha 5 AP150 AP20.1
To Company Base The currency of the payment. AP20.2 AP20.3
Currency AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP23.1
AP25.2 AP26.1
AP27.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.2
MA43.2
CHK-ACT-CNV-RATE Signed 12.6 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 AP23.1
AP25.2 AP26.1
AP27.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.2
MA43.2
CHK-SERIAL-NUM Numeric 8 AP160 AP161
Payment Run Serial A system-defined number assigned to an AP20.1 AP20.2
Number 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 AP23.1 AP55.1
required to recreate a payment tape in AP81.1 CB06.2
AP160 or a file AP161. CB500 EE20.1
EE20.2 MA41.2
MA43.2
CHK-CHECK-TYPE Alpha 1 AP20.1 AP20.2
Payment Record Identifies where the cash payment record AP20.3 AP20.4
Origin originated. Valid values are: AP20.5 AP20.6
AP20.7 AP20.8
Blank. A system generated payment AP23.1 AP25.2
created in AP150, AP157, AP160, or AP26.1 AP27.1
AP161. AP55.1 AP81.1
CB06.2 CB500
M = Manual. A manual payment created in EE20.1 EE20.2
AP20 or AP55. EE35.1 EE35.2
MA41.2 MA43.2
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.
CHK-RELEASE-FL Alpha 1 AP20.1 AP20.2
Element: Released Indicates whether the payment has been AP20.3 AP20.4
released. Valid values are: AP20.5 AP20.6
AP20.7 AP20.8
N = No. AP23.1 AP25.2
Y = Yes. AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB191
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.2
MA43.2
CHK-BASE-APPL-AMT Signed 15.2 AP150 AP20.1
Element: Adj Amt The total amount of invoices applied to AP20.2 AP20.3
the payment in the company base AP20.4 AP20.5
currency. AP20.6 AP20.7
AP20.8 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.2 MA43.2
CHK-BANK-CURR-AMT Signed 15.2 AP150 AP20.1
Element: Adj Amt The payment amount in the currency of AP20.2 AP20.3
the bank account. AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP23.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.2 MA43.2
CHK-BNK-CNV-RATE Signed 12.6 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 AP23.1
AP55.1 AP81.1
CB500 EE20.1
EE20.2 MA41.2
MA43.2
CHK-BANK-APPL-AMT Signed 15.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 AP23.1
AP55.1 AP55.2
AP81.1 EE20.1
EE20.2 MA41.2
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 AP23.1
AP55.1 AP81.1
CB500 EE20.1
EE20.2 MA41.2
MA43.2
CHK-REJECT-DATE Numeric 8 (yyyymmdd) CB500 CB85.1
Element: 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 AP23.1
MA41.2 MA43.2
CHK-PROC-GRP Alpha 4 (Lower Case) AP150
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: Payment StatusIndicates 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
Reconciliation The bank-assigned reconciliation
Statement 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 This index is used to access and update AP155 AP160
BANK-INST-CODEcash payment records. 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 This index is used to inquire on AP161 AP90.5
CASH-CODE specific cash payment records by pay CB06.2 CB191
BANK-INST-CODEgroup, cash code, transaction code, and
TRANS-NBR payment number.
TRANS-IDENT KeyChange
CHKSET3 PAY-GROUP This index is used to access cash AP150 AP155
REC-STATUS payment records for an accounts payable AP160 AP161
CASH-CODE company's bank account. AP170 AP190
BANK-INST-CODEKeyChange AP195 AP255
TRANS-NBR AP265 AP55.1
TRANS-IDENT AP55.2
CHKSET4 CASH-CODE This index is used to access AP155 AP160
BANK-INST-CODEunreconciled cash payment records AP161 AP190
TRANS-NBR (processed cash payment records). Also AP20.1 AP20.2
TRANS-IDENT used to inquire on cash payment records AP20.3 AP20.4
by cash code, transaction code, and AP20.5 AP20.6
payment number. AP20.7 AP20.8
KeyChange AP23.1 AP25.2
AP26.1 AP27.1
AP520 AP55.1
AP81.1 CB06.2
CB20.1 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.2 MA43.2
CHKSET5 CASH-CODE This index is by AP160 (Invoice Accrual AP160 AP161
BANK-INST-CODEReconciliation) to access a serial AP190 CB300
SERIAL-NUM number. CB80.1 CB85.1
TRANS-NBR KeyChange
TRANS-IDENT
CHKSET8 VENDOR-GROUP This index is used to display all cash AM115 AM15.1
PAID-VENDOR payment transactions for a vendor AM15.2 AM15.3
COMPANY regardless of the issuing company. AM15.4 AM20.1
CHECK-DATE* KeyChange AM20.3 AM21.1
BANK-INST-CODE AM21.3 AM500
CASH-CODE AM51.1 AM551
TRANS-IDENT AM97.1 AP300
AP305 AP91.1
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
CHKSET9 PAY-GROUP This index is used to select records to AP265
CASH-CODE print on the payment register.
CHECK-DATE KeyChange
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
|