CBCASHFORM

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 AP100 AP109 AP110 AP111
AP115 AP125 AP126 AP14.1 AP14.2 AP14.5
AP150 AP151 AP16.1 AP16.2 AP170 AP180
AP181 AP190 AP193 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.6 AP20.7 AP21.1 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP28.1 AP28.2
AP30.1 AP30.2 AP30.3 AP30.4 AP300 AP305
AP510 AP520 AP590 API1.1 API2.1 CB10.1
CB150 CB54.1 CB55.1 CB554 EE135 EE20.1
EE20.2 EE20.4 EE35.1 EE35.2 EE520 IC64.6
MA41.1 MA41.2 MA41.4 MA41.7 MA42.1 MA42.2
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA44.1
MA44.2 MA60.2 MA60.3 MA60.4 MA61.1 MA64.6
MA64.9 MA65.1 MA66.1 MA66.2 MA66.3 MA67.3
MA68.2 MA68.4 MA70.1 MA75.1 MAED.1 MAI1.1


UPDATED BY
AP155 AP160 AP161 ZA161 CB00.2 CB00.5

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CCF-PROC-GRP
Element: Process Group
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
Element: Cash Code
Alpha 4
The cash code. Represents a bank account. Must be a valid record in the Cash Code file.
CB00.5
CCF-BANK-INST-CODE
Element: Transaction Code
Alpha 3
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.
CB00.5
CCF-SOURCE-CODE
Element: Source Code
Alpha 2
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.
CB00.5
CCF-FORMAT-NBR
Element: Format Option
Numeric 2
The cash payment format for this Cash Code - cash payment Transaction Code combination.
CB00.5
CCF-START-DOC-NBR
Starting Document
Number
Numeric 10
If 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
Element: Remittance Option
Alpha 1
Identifies the type of remittance to create. N = No Remittance. A = Always Attached. O = Overflow Document. S = Separate Remittance.
CB00.5
CCF-HDR-DTL-LINES
Remittance Detail
Lines-Attach
Numeric 3
If 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
Remittance Detail
Lines-Overfl
Numeric 3
If 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
Scripted Amount
Option
Alpha 1
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).
CB00.5
CCF-TAPE-ID-NBR
Element: Payment Tape ID
Alpha 30
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
Tape Payment
Rejection Code
Alpha 3
Used 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
Element: Country Code
Alpha 2
CB00.5


CBCASHFORM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CCFSET1 CASH-CODE
BANK-INST-CODE
PROC-GRP
...
AP10.1 AP10.2
AP100 AP109
AP110 AP111
AP115 AP125
AP126 AP14.1
AP14.2 AP14.5
AP150 AP151
AP155 AP16.1
AP16.2 AP160
AP161 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
CCFSET2 COUNTRY-CODE
FORMAT-NBR
CASH-CODE
BANK-INST-CODE
PROC-GRP
CCFSET3 FORMAT-NBR
COUNTRY-CODE
CASH-CODE
BANK-INST-CODE
PROC-GRP


CBCASHFORM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cbbankent CBBANKENT Required
CBC-BANK-ENTITY->CBE-BANK-ENTITY (CBESET1)
Cbbankinst CBBANKINST Required
CCF-BANK-INST-CODE->CBI-BANK-INST-CODE
Cbcashcode CBCASHCODE Required
CCF-CASH-CODE->CBC-CASH-CODE


File created: Thu Jun 09 02:12:00 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.