CBCCTRNJB – Cash Code Journal Book
- System
- Cash Ledger (CB)
- Prefix
CJB- Primary key
COMPANY,CASH-CODE,BANK-INST-CODE- Fields
- 4
- Updated by
- 1 program
- Referenced by
- 47 programs
CBCCTRNJB is the Cash Code Journal Book table in Lawson Cash Ledger (prefix CJB). It is indexed by COMPANY, CASH-CODE, BANK-INST-CODE (CJBSET1). It is updated by CB05.1 and referenced by AP125, AP126, AP150, AP151, AP155, AP156, AP160, AP161 and 39 more. The table has 4 fields, 1 index and 0 documented relations.
About CBCCTRNJB
The Cash Code Journal Book file contains default journal book numbers for each transaction code that is defined for a company cash code.
Fields (4)
Column = COBOL field name without the CJB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CJB-COMPANY PKCOMPANY | Numeric 4 | The company number. Must be a valid record in the General Ledger Company file. | CB05.1 |
CJB-CASH-CODE PKCASH_CODE | Alpha 4 | The cash code. Represents a bank account. Must be a valid record in the Cash Code file and a valid relationship must exist between the company and the cash code in the Company - Cash Code Relationship file. | CB05.1 |
CJB-BANK-INST-CODE PKBANK_INST_CODE | Alpha 3 | The transaction code. Represents a type of cash payment, bill of exchange payment, or bank service transaction. Must be a valid record in the Bank Transaction Code file. | CB05.1 |
CJB-JRNL-BOOK-NBRJRNL_BOOK_NBR | Alpha 12 | The default journal book assigned to the transaction code for the company - cash code relationship. Must be a valid record in the Journal Book Header file. | CB05.1 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
CJBSET1 | COMPANY, CASH-CODE, BANK-INST-CODE | Primary | AP125, AP126, AP150, AP151, AP155, AP156, AP160, AP161 +22 more (list truncated in source) |
Programs
Updated by (1)
- CB05.1 Cash Code Journal Book
Referenced by (47)
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP150 Cash Requirements
- AP151 Bill of Exchange Generation
- AP155 Payment Forms Creation
- AP156 Bill of Exchange Creation
- AP160 Payment Tape Creation
- AP161 Electronic Payment File Creation
- AP170 Payment Closing
- AP176 Match Discount Accrual
- AP180 Bill of Exchange Cashing Update
- AP190 Invoice Reinstatement
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP20.8 Payment Schedule
- AP21.1 View Distributions
- AP213 Vendor Account Balance
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- AP28.1 Bill of Exchange Acceptance by Vendor
- AP28.2 Bill of Exchange Acceptance by Date
- AP284 Vendor Grand Livre
- AP56.1 Bill of Exchange Entry
- AP56.2 Bill of Exchange Invoice Application
- AP80.1 Bill of Exchange Cashing Selection
- CB00.3 Company Cash Code Relationships
- CB20.1 Bank Transaction Entry
- CB55.1 Payment Entry
- CB554 Payment Load
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.2 Memo Line AOC Detail
- MA43.2 Purchase Order Lookup
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA61.1 Match Invoice Approval
- MAI1.1 Invoke for MAMATCH Object
- ZA161 Electronic Payment File Creation