Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBPAYMENT


                             CBPAYMENT FILE

                              Cash Payment

REFERENCED BY

AP265     CB170     CB175     CB186     CB187     CB255
CB286     CB56.1

UPDATED BY

AP150     AP155     AP160     AP161     AP170     AP190
CB150     CB300     CB55.1    CB554

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CBM-CASH-CODE          Alpha 4                                   AP160   AP161
Element: Cash Code     A cash code represents a bank account.    CB55.1  CB554
                       More than one company can use the same
                       cash code.  The cash code must be linked
                       to a bank in the Lawson Cash Ledger
                       system.


CBM-BANK-INST-CODE     Alpha 3                                   AP150   AP160
Element: Bank Inst CodeA transaction code represents a type of   AP161   CB55.1
                       cash payment, bill of exchange payment,   CB554
                       or bank service transaction.

CBM-TRANS-IDENT        Numeric 10                                AP190   CB55.1
Element: Trans Ident   A unique system-generated                 CB554
                       identification value assigned to the
                       transaction to make this record unique.

CBM-REFERENCE-NO       Alpha 10  (Lower Case)                    CB55.1  CB554
Element: Reference     The reference number associated with
                       the transaction.

CBM-VOID-DATE          Numeric 8  (yyyymmdd)                     AP190
Element: Date          This field displays the system date
                       when this was created.

CBM-TRANS-NBR          Alpha 10  (Right Justified)               AP155   AP160
Element: Trans Nbr     A unique, user-defined value used to      AP161   AP190
                       identify the transaction.


CBM-CHECK-DATE         Numeric 8  (yyyymmdd)                     AP155   AP160
Element: Date          This field displays the system date       AP161   AP190
                       when this was created.

CBM-REC-STATUS         Numeric 1                                 AP150   AP155
Element: Rec Status    The record status.                        AP160   AP161
                       0 = Unreleased                            AP170   AP190
                       1 = Released                              CB150   CB55.1
                       2 = Selected for Payment                  CB554
                       3 = System Generated
                       8 = Voided
                       9 = Historical

CBM-COMPANY            Numeric 4                                 CB55.1  CB554
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

CBM-VENDOR             Alpha 9  (Right Justified)                CB55.1  CB554
Element: Vendor        The vendor's identification code.



CBM-BANK-CHK-AMT       Signed 18.2                               AP150   CB55.1
Element: Intl Amt                                                CB554

CBM-BANK-ND            Numeric 1                                 AP150   CB55.1
Element: Acct Nd       The number of decimals assigned to a      CB554
                       particular account as determined by the
                       account currency.


CBM-BASE-PMT-AMT       Signed 18.2                               CB55.1  CB554
Element: Intl Amt

CBM-BASE-ND            Numeric 1                                 CB55.1  CB554
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


CBM-BASE-CHK-AMT       Signed 18.2                               AP150
Element: Intl Amt

CBM-EXCHANGE-RATE      Signed 14.7                               CB55.1  CB554
Element: Curr Rate     The currency rate.

CBM-CURRENCY-CODE      Alpha 5                                   CB55.1  CB554
Element: Currency Code This field contains the bank account
                       currency defined for the cash code.

CBM-POST-DATE          Numeric 8  (yyyymmdd)                     CB55.1  CB554
Element: Date          This field displays the system date
                       when this was created.

CBM-DESCRIPTION        Alpha 30  (Lower Case)                    CB55.1  CB554
Element: Description   This field displays the description.

CBM-PROC-GRP           Alpha 4  (Lower Case)                     CB55.1  CB554
Element: Proc Grp      A process group is an identifier used
                       for separating vendors into different
                       groups to enable concurrent processing
                       within the cash payment cycle.

CBM-PAY-GROUP          Alpha 4                                   CB55.1  CB554
Element: Pay Group     A pay group is used for processing
                       accounts payable payments. A pay group
                       lets you create a single payment for a
                       vendor to pay invoices received by all
                       company process levels assigned to the
                       pay group.

CBM-OVERRIDE-COMP      Numeric 4                                 CB55.1  CB554
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

CBM-PAYEE-NAME         Alpha 80  (Lower Case)                    CB55.1  CB554
Element: Legal Name    Institution's legal name used on the
                       GM269 and GM272 reports.

CBM-PAYEE-ADDR1        Alpha 30  (Lower Case)                    CB55.1  CB554
Element: Addr1         This field contains the first line of
                       address information.

CBM-PAYEE-ADDR2        Alpha 30  (Lower Case)                    CB55.1  CB554
Element: Addr1         This field contains the first line of
                       address information.

CBM-PAYEE-ADDR3        Alpha 30  (Lower Case)                    CB55.1  CB554
Element: Addr1         This field contains the first line of
                       address information.

CBM-PAYEE-ADDR4        Alpha 30  (Lower Case)                    CB55.1  CB554
Element: Addr1         This field contains the first line of
                       address information.

CBM-PAYEE-ADDR5        Alpha 30  (Lower Case)                    CB55.1  CB554
Element: Addr1         This field contains the first line of
                       address information.

CBM-PAYEE-ST-PROV      Alpha 2                                   CB55.1  CB554
Element: State Prov    The state or province.

CBM-PAY-POSTAL-CD      Alpha 10  (Lower Case)                    CB55.1  CB554
Element: Postal Code   This field contains the postal code.

CBM-PAY-COUNTY         Alpha 25  (Lower Case)                    CB55.1  CB554
Element: County        The county for the company address.

CBM-PAY-CTRY-CODE      Alpha 2                                   CB55.1  CB554
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

CBM-VBANK-IDENT        Alpha 1                                   CB55.1  CB554
Element: Alphadata1    " " = Standard Account Number
                       Y = IBAN Account Number

CBM-BANK-ACCT          Alpha 35                                  CB55.1  CB554
Element: Bank Acct Nbr The bank-assigned account number
                       identification to be used for the cash
                       code.


CBM-BANK-ENTITY        Alpha 15                                  CB55.1  CB554
Element: Bank Entity   Represents a bank institution location.


CBM-ACH-PRENOTE        Alpha 1                                   AP160   CB150
Element: Ach Prenot    N = Not Prenotified                       CB55.1  CB554
                       P = Prenotified
                       A = Accepted

CBM-VBANK-ACCT-TP      Alpha 1                                   CB55.1  CB554
Element: Vbank Acct Tp C = Current/Checking
                       S = Savings

CBM-BUILD-SOC-REF      Alpha 18                                  CB55.1  CB554
Element: Build Soc Ref This field holds an individual account
                       number reference for the Building
                       Society

CBM-BUILD-ACCT-NM      Alpha 18                                  CB55.1  CB554
Element: Account Name

CBM-CROSS-IDENT        Alpha 1                                   CB55.1  CB554
Element: Cross Ident   This field is used to distinguish
                       between SWIFT ID numbers and Routing
                       numbers.
                       S = SWIFT
                       R = Routing

CBM-SWIFT-ID           Alpha 12                                  CB55.1  CB554
Element: Swift Id

CBM-PMT-CAT-CODE       Alpha 6                                   CB55.1  CB554
Element: Pmt Cat Code

CBM-NORM-EXP-CODE      Alpha 1                                   CB55.1  CB554
Element: Charge Code   N = Normal
                       E = Express

CBM-PMT-FORM           Alpha 2                                   CB55.1  CB554
Element: Pmt Form

CBM-CHARGE-CODE        Alpha 1                                   CB55.1  CB554
Element: Charge Code

CBM-USER-FIELD1        Alpha 30                                  CB55.1  CB554
Element: User Field1   This is the first user definable field.
                       It can be used to capture any data that
                       the user wants.  The title of the field
                       is setup in IC00.


CBM-USER-FIELD2        Alpha 30                                  CB55.1  CB554
Element: User Field2   This is the second user definable
                       field. This field can be used to enter
                       any data that the user wants to capture
                       for this item.  The title of the field
                       is setup in IC00.


CBM-USER-FIELD3        Alpha 30                                  CB55.1  CB554
Element: User Field1   This is the first user definable field.
                       It can be used to capture any data that
                       the user wants.  The title of the field
                       is setup in IC00.


CBM-USER-FIELD4        Alpha 30                                  CB55.1  CB554
Element: User Field2   This is the second user definable
                       field. This field can be used to enter
                       any data that the user wants to capture
                       for this item.  The title of the field
                       is setup in IC00.


CBM-LANGUAGE-CODE      Alpha 10                                  CB55.1  CB554
Element: Language Code Language Code (LOCALE).

CBM-TAX-FLAG           Alpha 1                                   CB554
Element: All Flag      " " = Not Interfaced
                       I = Interfaced

CBM-JRNL-BOOK-NBR      Alpha 12                                  CB55.1  CB554
Element: Jrnl Book Nbr The journal book assigned to the
                       transaction.

CBM-JBK-SEQ-NBR        Numeric 10                                CB55.1  CB554
Element: Jbk Seq Nbr   The journal book sequence number
                       assigned to a journal book transaction
                       when it is added or interfaced to the
                       Lawson system. Used only when  Auto
                       Journal Book Seq Nbr is set to Yes in
                       GL10.1 (Company).


CBM-LAST-DIST-SEQ      Numeric 4                                 AP170   AP190
Element: Seq Nbr       An automatically assigned sequence        CB150   CB55.1
                       number.                                   CB554

CBM-SOURCE-CODE        Alpha 2                                   CB55.1  CB554
Element: Source Code   A two character code assigned to a
                       transaction to identify where the
                       transaction was created.

                         CBPAYMENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CBMSET1   CASH-CODE                                              AP150   AP155
          BANK-INST-CODE                                         AP160   AP170
          TRANS-IDENT                                            AP265   CB170
                                                                 CB175   CB186
                                                                 CB187   CB255
                                                                 CB286   CB300

CBMSET2   CASH-CODE                                              AP160   CB150
          BANK-INST-CODE                                         CB55.1
          REFERENCE-NO
          TRANS-IDENT

CBMSET3   CASH-CODE     KeyChange                                CB255
          BANK-INST-CODE
          TRANS-NBR
          TRANS-IDENT

CBMSET4   PAY-GROUP     KeyChange                                AP150   AP160
          REC-STATUS                                             AP170
          PROC-GRP
          BANK-INST-CODE
          TRANS-IDENT
          CASH-CODE

CBMSET5   PAY-GROUP     KeyChange                                AP150   AP155
          BANK-INST-CODE                                         AP160   AP161
          TRANS-IDENT                                            AP190
          CASH-CODE

CBMSET6   CHECK-DATE*   KeyChange                                CB56.1
          USER-FIELD1
          CASH-CODE
          BANK-INST-CODE
          TRANS-IDENT

                         CBPAYMENT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cbdistrib      CBDISTRIB

                            CBM-CASH-CODE         -> CBD-CASH-CODE
                            CBM-BANK-INST-CODE    -> CBD-BANK-INST-CODE
                            CBM-TRANS-IDENT       -> CBD-TRANS-IDENT
                                                     CBD-DIST-TYPE
                                                     CBD-SEQ-NBR