Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBCASHFORM


                            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