CB145 – EFT Extract Update
- System
- Cash Ledger (CB)
- Type
- Batch program
- Updates
- 14 tables
- References
- 26 tables
CB145 (EFT Extract Update) is a Lawson Cash Ledger batch program. It updates ADDRDATA, CBBANKENT, CBBANKINST, CBCASHCODE, CBCONSOL, CBCPYCASH, CBDISTRIB, CBFTTRANS and 6 more and references CBADJUST, CBAUTONBR, CBBALANCE, CBCCGRP, CBGRPCC, CBMXVALUE, CBSTATEMNT, CBSTMTDTL and 18 more.
About CB145
Run EFT Extract Update (CB145) to process released cash ledger EFT payment or credit card extract. CB145 produces a report that lists transactions by cash code, with cash code and report totals. Cash Ledger transaction and distribution records are also created for a cash code if at least one cash ledger EFT payment receipt request isprocessed. **Processing Effect CB145 creates an ACH formatted payment file in theLAWDIR/(productline)/work/CB145ACHTAPE directory. The ACH file name is a combination of the company, cash code, date, and time. For example, processing company 72, cash code CASH, on July 31, 2004 creates the following file: 0072CASH07310407554300
Updated files (14)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| CBBANKENT | Bank | CB |
| CBBANKINST | Bank Transaction Code | CB |
| CBCASHCODE | Cash Code | CB |
| CBCONSOL | This file is updated by a batch program that consolidated CBTRANS amounts by Cash Code/Bank Inst Code/Company. | CB |
| CBCPYCASH | Company-Cash Code Relationship | CB |
| CBDISTRIB | Transaction Distribution | CB |
| CBFTTRANS | EFT Deposit Extract Data | CB |
| CBTRANS | Bank Transaction | CB |
| CBTRANSAUD | No description in the Lawson data dictionary | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| JBOOKHDR | Journal Book Header | IF |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
Referenced files (26)
| Table | Description | System |
|---|---|---|
| CBADJUST | Reconciliation Adjustment | CB |
| CBAUTONBR | No description in the Lawson data dictionary | CB |
| CBBALANCE | Bank Account Balance | CB |
| CBCCGRP | Cash Code Group | CB |
| CBGRPCC | Cash Code Group Cash Codes | CB |
| CBMXVALUE | Cash Code Attribute Value | CB |
| CBSTATEMNT | Reconciliation Statement | CB |
| CBSTMTDTL | Cash Staement Detail | CB |
| CBUSER | Cash Ledger User | CB |
| CBUSRCLASS | Cash Ledger User Class | CB |
| CUACCT | Currency Gain and Loss Account | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCODES | General Ledger Codes | IF |
| GLCPYGRP | General Ledger Company Group | IF |
| GLSYSTEM | General Ledger Company | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| JBKOPCODE | Journal Book Operator Code | IF |
| JBKSYSCODE | Journal Book System | IF |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
Program calls
Invoked programs (11)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU