|
|
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
AP10.1 AP10.2 AP150 AP190 AP30.3 AP510
AP520 API1.1 EE20.1 EE20.2 EE20.4 EE520
UPDATED BY
AP155 AP160 AP161 CB00.2 CB00.5
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CCF-PROC-GRP Alpha 4 (Lower Case) CB00.5
Element: Process Group A process group is an identifier used
for separating vendors into different
groups to enable concurrent processing
within the cash payment cycle.
CCF-CASH-CODE Alpha 4 CB00.5
Element: 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
Element: Transaction CoThe 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
Element: 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
Element: 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
Element: Remittance OptIdentifies 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
Element: Payment Tape IThe 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 AP10.1 AP10.2
BANK-INST-CODEcash payment format records unique by AP150 AP155
PROC-GRP cash code (bank account) and bank AP160 AP161
transaction code. AP190 AP30.3
AP510 AP520
API1.1 CB00.2
CB00.5 EE20.1
EE20.2 EE20.4
EE520
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
|
