CBDRFTFORM – Bill of Exchange Paymnt Format

System
Cash Ledger (CB)
Prefix
CBF
Primary key
COMPANY, BANK-INST-CODE
Fields
8
Updated by
1 program
Referenced by
21 programs

CBDRFTFORM is the Bill of Exchange Paymnt Format table in Lawson Cash Ledger (prefix CBF). It is indexed by COMPANY, BANK-INST-CODE (CBFSET1). It is updated by CB01.2 and referenced by AP156, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 and 13 more. The table has 8 fields, 1 index and 0 documented relations.

About CBDRFTFORM

The Bill of Exchange Payment Format file contains all valid bill of exchange payment format records for a company. A bill of exchange payment format represents a printed bill of exchange payment form.

Fields (8)

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

Field / columnTypeDescription & valuesUpdated by
CBF-COMPANY PK
COMPANY		Numeric 4The company number. Must be a valid record in the General Ledger Company file.CB01.2
CBF-BANK-INST-CODE PK
BANK_INST_CODE		Alpha 3The bill of exchange payment transaction code. Represents a type of bill of exchange payment. Must be a valid bill of exchange payment type bank transaction code record in the Bank Transaction Code file.CB01.2
CBF-FORMAT-NBR
FORMAT_NBR		Numeric 2The bill of exchange payment format for this Company - bill of exchange payment Transaction Code combination. Valid values are:
  • 01 Spanish Formal BOE (AR).
  • 02 Spanish Informal BOE (AR).
  • 03 Spanish Pagare (AP).
  • 55 French BOE Print Format.
  • 56 French BOE Tape Format.
CB01.2
CBF-REMIT-OPTION
REMIT_OPTION		Alpha 1Identifies the type of remittance to create. Valid values are:
  • N No Remittance.
  • A Always Attached.
  • O Overflow Document.
  • S Separate
CB01.2
CBF-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.CB01.2
CBF-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.CB01.2
CBF-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 French (not currently available).
  • 4 German (not currently available).
CB01.2
CBF-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.CB01.2

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CBFSET1COMPANY, BANK-INST-CODEPrimaryAP156, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +14 more

Programs

Updated by (1)

Referenced by (21)