CBTRANSBOD – No description in the Lawson data dictionary
- System
- Cash Ledger (CB)
- Prefix
YCL- Primary key
CASH-CODE,BANK-INST-CODE,TRANS-NBR,SUFFIX,TRANS-IDENT- Fields
- 11
- Updated by
- 1 program
- Referenced by
- 88 programs
CBTRANSBOD is a Lawson Cash Ledger table (prefix YCL); no description in the lawson data dictionary. It is indexed by CASH-CODE, BANK-INST-CODE, TRANS-NBR, SUFFIX, TRANS-IDENT (YCLSET1); alternate indexes: YCLSET2. It is related 1:1 to CBTRANS. It is updated by CBOD.1 and referenced by AP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 and 80 more. The table has 11 fields, 2 indexes and 1 documented relation.
About CBTRANSBOD
No description in the Lawson data dictionary.
Fields (11)
Column = COBOL field name without the YCL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#YCL-CASH-CODE PKCASH_CODE | Alpha 4 | — | CBOD.1 |
#YCL-BANK-INST-CODE PKBANK_INST_CODE | Alpha 3 | — | CBOD.1 |
#YCL-TRANS-NBR PKTRANS_NBR | Alpha 10 (Right Justified) | — | CBOD.1 |
#YCL-SUFFIX PKSUFFIX | Numeric 3 | — | CBOD.1 |
#YCL-TRANS-IDENT PKTRANS_IDENT | Numeric 10 | — | CBOD.1 |
#YCL-BOD-DOC-ID SET2BOD_DOC_ID | Alpha 100 (Lower Case) | — | CBOD.1 |
#YCL-BOD-ACCT-ENT SET2BOD_ACCT_ENT | Alpha 22 (Lower Case) | — | CBOD.1 |
#YCL-BOD-LOCATION SET2BOD_LOCATION | Alpha 22 (Lower Case) | — | CBOD.1 |
#YCL-BOD-REVISION SET2BOD_REVISION | Alpha 22 (Lower Case) | — | CBOD.1 |
#YCL-BOD-SORBOD_SOR | Alpha 1 | — | CBOD.1 |
#YCL-BOD-VAR-IDBOD_VAR_ID | Alpha 22 (Lower Case) | — | CBOD.1 |
Indexes (2)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
YCLSET1 |
| Primary | AP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 +22 more (list truncated in source) | |
YCLSET2 |
| CBOD.1, CBOD.2 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cbtrans | CBTRANS | Required |
|
Programs
Updated by (1)
- CBOD.1 CB BOD Maintenance
Referenced by (88)
- AP10.1 Vendor
- AP10.2 Vendor Location
- AP100 Vendor Group Copy
- AP109 Vendor Current Address Update
- AP110 Mass Vendor Update
- AP111 Vendor Deletion
- AP115 Vendor Merge
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP14.1 Vendor Contact
- AP14.2 Vendor Contact Address
- AP14.5 1099 Tax Identification Information
- AP150 Cash Requirements
- AP151 Bill of Exchange Generation
- AP16.1 Vendor Bank
- AP16.2 Vendor Location Bank
- AP160 Payment Tape Creation
- AP161 Electronic Payment File Creation
- AP170 Payment Closing
- AP180 Bill of Exchange Cashing Update
- AP181 Bill of Exchange Statement Update
- AP190 Invoice Reinstatement
- AP193 Recurring Invoice Update
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.6 Prepayment
- AP20.7 Distributions
- AP21.1 View Distributions
- 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
- AP30.1 Invoice Maintenance
- AP30.2 Distribution Adjustments
- AP30.4 Invoice Cancel
- AP300 Invoice and Vendor History Purge
- AP305 Accounts Payable Company Purge
- AP510 Vendor Conversion
- AP520 Invoice Interface
- AP590 AP Vendor CSV
- API1.1 Add Invoice
- API2.1 Add Invoice
- CB00.1 Bank
- CB10.1 Cash Receipt Deposit
- CB150 Mass Release
- EE135 Mass Employee Release
- EE20.1 Employee Advance
- EE20.2 Employee Expense
- EE35.1 Advance Release
- EE35.2 Expense Release
- EE520 Expense Interface
- IC64.6 Global Location Number Assignment Vendor
- 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.1 Memo Line Detail - Purchase Order
- MA42.2 Memo Line AOC Detail
- MA43.1 Invoice Line Detail - Purchase Order
- MA43.2 Purchase Order Lookup
- MA43.3 Invoice Line Detail - Receipt
- MA43.4 Invoice Line Detail - Service
- MA43.6 Service Agreement Detail
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA60.2 Invoice Level Match
- MA60.3 Detail Level Match
- MA60.4 Invoice Match Reference Adjustment
- MA61.1 Match Invoice Approval
- MA64.6 Message Detail by Invoice
- MA64.9 PO Cost Message Accept Upload
- MA65.1 Invoice Line Adjustment
- MA66.1 Review Invoice Message
- MA66.2 Invoice Message - Details
- MA66.3 Purchase Order Cost Review Message
- MA67.3 Detail Match from frontend
- MA68.2 Invoice Level Match - Prepaid
- MA68.4 Invoice Match Reference Adjustment
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MAED.1 Vendor
- MAI1.1 Invoke for MAMATCH Object