 |
Lawson Insight Technical Documentation |
|
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 AP91.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
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
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
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
Payment Number The 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
Transaction ID An 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
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
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
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
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
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
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
Pay Vendor Name The 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
Remit To Location The remit-to location the payment was AP20.2 AP20.3
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
Base Payment Amount 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
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 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
Payment Amount 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
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 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
Total of Invoices The total amount of invoices applied to AP20.2 AP20.3
Paid 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
Payment 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
Payment Currency The currency of the payment. AP20.2 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-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
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
Base Applied Amount 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
Bank Currency Amount 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
Bank Applied Amount The 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
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
Sort Option 1 Sort option one used for sorting the
payment in AP150.
CHK-SORT-OPTION2 Alpha 15 AP150 CB06.2
Sort Option 2 Sort option 2 used for sorting the
payment in AP150.
CHK-SORT-OPTION3 Alpha 15 AP150 CB06.2
Sort Option 3 Sort option 3 used for sorting the
payment in AP150.
CHK-INVOICE-GROUP Alpha 4 AP150 AP20.1
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
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
Payment Status Indicates the status of the payment.
CHK-SHORT-PAYEE Derived
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
EE20.1 EE20.2
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 CB300
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 CB80.1
SERIAL-NUM number. CB85.1
TRANS-NBR KeyChange
TRANS-IDENT
CHKSET8 VENDOR-GROUP This index is used to display all cash AP305 AP91.1
PAID-VENDOR payment transactions for a vendor
COMPANY regardless of the issuing company.
CHECK-DATE* KeyChange
BANK-INST-CODE
CASH-CODE
TRANS-IDENT
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 (CHK-REC-STATUS < 9 )
And (CHK-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
|