CBCASHFORM – Cash Payment Format

System
Cash Ledger (CB)
Prefix
CCF
Primary key
CASH-CODE, BANK-INST-CODE, PROC-GRP
Fields
13
Updated by
6 programs
Referenced by
90 programs

CBCASHFORM is the Cash Payment Format table in Lawson Cash Ledger (prefix CCF). It is indexed by CASH-CODE, BANK-INST-CODE, PROC-GRP (CCFSET1); alternate indexes: CCFSET2 and CCFSET3. It is related 1:1 to CBBANKENT, CBBANKINST and CBCASHCODE. It is updated by AP155, AP160, AP161, CB00.2, CB00.5 and ZA161 and referenced by AP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 and 82 more. The table has 13 fields, 3 indexes and 3 documented relations.

About CBCASHFORM

The Cash Payment format file contains all valid cash payment format records for a cash code (bank account). A cash payment format represents a printed cash payment form or type of cash payment tape.

Fields (13)

Column = COBOL field name without the CCF- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CCF-PROC-GRP PK
PROC_GRP		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.CB00.5
CCF-CASH-CODE PK
CASH_CODE		Alpha 4The cash code. Represents a bank account. Must be a valid record in the Cash Code file.CB00.5
CCF-BANK-INST-CODE PK
BANK_INST_CODE		Alpha 3The cash payment transaction code. Represents a type of cash payment. Must be a valid cash payment type bank transaction code record in the Bank Transaction Code file. Each Cash Code - Transaction Code combination must be unique.CB00.5
CCF-SOURCE-CODE
SOURCE_CODE		Alpha 2Indicates the Lawson system where the cash payment form is created. THIS FIELD IS NOT CURRENTLY USED. Valid values are:
  • AP Accounts Payable.
  • AR Accounts Receivable.
CB00.5
CCF-FORMAT-NBR
FORMAT_NBR		Numeric 2The cash payment format for this Cash Code - cash payment Transaction Code combination.CB00.5
CCF-START-DOC-NBR
START_DOC_NBR		Numeric 10If the Format Option is a printed document, this field may contain the starting document number. If left blank, the system begins numbering with 1.AP155, AP160, AP161, CB00.5, ZA161
CCF-REMIT-OPTION
REMIT_OPTION		Alpha 1Identifies the type of remittance to create.
  • N No Remittance.
  • A Always Attached.
  • O Overflow Document.
  • S Separate Remittance.
CB00.5
CCF-HDR-DTL-LINES
HDR_DTL_LINES		Numeric 3If printing remittance forms, this field indicates the number of detail lines to print on the attached or original remittance form. If left blank, 14 defaults.CB00.5
CCF-OVR-DTL-LINES
OVR_DTL_LINES		Numeric 3If the Remittance Option field = O, this field indicates the number of detail lines to print on the overflow remittance form. If left blank, 58 defaults.CB00.5
CCF-SCRIPT-OPTION
SCRIPT_OPTION		Alpha 1Identifies the language used to print payment documents and remittance forms. Valid values are:
  • 1 English. Default value.
  • 2 Spanish.
  • 3 France (not currently available).
  • 4 German (not currently available).
CB00.5
CCF-TAPE-ID-NBR
TAPE_ID_NBR		Alpha 30The identification number assigned to the bank account by the clearing house for tape or electronic payment transmissions. THIS FIELD IS NOT CURRENTLY USED.—
CCF-TAPE-REJ-CODE
TAPE_REJ_CODE		Alpha 3Used only if the Format Option = 11 (ACH Tape) or 21 (BACS Tape). The bank service transaction code used to create a bank transaction adjustment when the bank rejects a portion of an ACH or BACS payment tape submission. Must be a valid bank service type transaction code record in the Bank Transaction Code file.CB00.5
CCF-COUNTRY-CODE
COUNTRY_CODE		Alpha 2—CB00.5

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CCFSET1CASH-CODE, BANK-INST-CODE, PROC-GRPPrimaryAP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 +22 more (list truncated in source)
CCFSET2COUNTRY-CODE, FORMAT-NBR, CASH-CODE, BANK-INST-CODE, PROC-GRP—
CCFSET3FORMAT-NBR, COUNTRY-CODE, CASH-CODE, BANK-INST-CODE, PROC-GRP—

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CbbankentCBBANKENTRequiredCBC-BANK-ENTITY → CBE-BANK-ENTITY (CBESET1)
CbbankinstCBBANKINSTRequiredCCF-BANK-INST-CODE → CBI-BANK-INST-CODE
CbcashcodeCBCASHCODERequiredCCF-CASH-CODE → CBC-CASH-CODE

Programs

Updated by (6)

Referenced by (90)