CBCASHFORM FILE
Cash Payment Format
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.
REFERENCED BY
AP150 AP190
UPDATED BY
AP155 AP160 AP161 CB00.2 CB00.5
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CCF-CASH-CODE Alpha 4 CB00.5
Cash Code The cash code. Represents a bank
account. Must be a valid record in the
Cash Code file.
CCF-BANK-INST-CODE Alpha 3 CB00.5
Transaction Code The 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.
CCF-SOURCE-CODE Alpha 2 CB00.5
Source Code Indicates 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.
CCF-FORMAT-NBR Numeric 2 CB00.5
Format Option The cash payment format for this Cash
Code - cash payment Transaction Code
combination. Valid values are:
01 = Standard Check.
02 = Extended Check.
03 = UK Check.
04 = Spanish Check.
11 = ACH Tape.
21 = BACS Tape.
22 = EDI File.
23 = Swift File.
CCF-START-DOC-NBR Numeric 10 AP155 AP160
Starting Document If the Format Option is a printed AP161 CB00.5
Number document, this field may contain the
starting document number. If left blank,
the system begins numbering with 1.
CCF-REMIT-OPTION Alpha 1 CB00.5
Remittance Option Identifies the type of remittance to
create.
N = No Remittance.
A = Always Attached.
O = Overflow Document.
S = Separate Remittance.
CCF-HDR-DTL-LINES Numeric 3 CB00.5
Remittance Detail If printing remittance forms, this
Lines-Attach field indicates the number of detail
lines to print on the attached or
original remittance form. If left blank,
14 defaults.
CCF-OVR-DTL-LINES Numeric 3 CB00.5
Remittance Detail If the Remittance Option field = O,
Lines-Overfl this field indicates the number of
detail lines to print on the overflow
remittance form. If left blank, 58
defaults.
CCF-SCRIPT-OPTION Alpha 1 CB00.5
Scripted Amount Identifies the language used to print
Option payment documents and remittance forms.
Valid values are:
1 = English. Default value.
2 = Spanish.
3 = France (not currently available).
4 = German (not currently available).
CCF-TAPE-ID-NBR Alpha 30
Payment Tape ID The 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 Alpha 3 CB00.5
Tape Payment Used only if the Format Option = 11
Rejection Code (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.
CBCASHFORM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CCFSET1 CASH-CODE This is the primary index used to keep AP150 AP155
BANK-INST-CODEcash payment format records unique by AP160 AP161
cash code (bank account) and bank AP190 CB00.2
transaction code. CB00.5
CBCASHFORM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cbbankent CBBANKENT Required
CBC-BANK-ENTITY -> CBE-BANK-ENTITY
Cbbankinst CBBANKINST Required
CCF-BANK-INST-CODE -> CBI-BANK-INST-CODE
Cbcashcode CBCASHCODE Required
CCF-CASH-CODE -> CBC-CASH-CODE
|
