|
|
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 AP157 AP160 AP161 AP956 CB00.2
CB00.5
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CCF-CASH-CODE Alpha 4 AP956 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 AP956 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 AP956 CB00.5
Source Code Indicates the Lawson system where the
cash payment form is created. Valid
values are:
AP = Accounts Payable.
AR = Accounts Receivable.
CCF-FORMAT-NBR Numeric 2 AP956 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 AP157
Starting Document If the Format Option is a printed AP160 AP161
Number document, this field may contain the AP956 CB00.5
starting document number. If left blank,
the system begins numbering with 1.
CCF-REMIT-OPTION Alpha 1 AP956 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 AP956 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 AP956 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 AP956 CB00.5
Language Identifies 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).
5= Language preference of vendor) This
gives the capability to associate
multiple languages to a cash code based
on the language preference of the
vendor.
CCF-TAPE-ID-NBR Alpha 30 AP956
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 AP956 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.
CCF-PRINT-22-INV Alpha 1 AP956 CB00.5
Print Full Invoice Indicates whether to print the full
Number 22-character invoice number on
remittance forms. If No is selected, the
first ten characters of the invoice
number and the invoice suffix prints.
Valid values are:
N = No.
Y = Yes.
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 AP157 AP160
cash code (bank account) and bank AP161 AP190
transaction code. CB00.2 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
|