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.

Field / column	Type	Description & values	Updated by
`YCL-CASH-CODE` PK CASH_CODE	Alpha 4	—	CBOD.1
`YCL-BANK-INST-CODE` PK BANK_INST_CODE	Alpha 3	—	CBOD.1
`YCL-TRANS-NBR` PK TRANS_NBR	Alpha 10 (Right Justified)	—	CBOD.1
`YCL-SUFFIX` PK SUFFIX	Numeric 3	—	CBOD.1
`YCL-TRANS-IDENT` PK TRANS_IDENT	Numeric 10	—	CBOD.1
`YCL-BOD-DOC-ID` BOD_DOC_ID	Alpha 100 (Lower Case)	—	CBOD.1
`YCL-BOD-ACCT-ENT` BOD_ACCT_ENT	Alpha 22 (Lower Case)	—	CBOD.1
`YCL-BOD-LOCATION` BOD_LOCATION	Alpha 22 (Lower Case)	—	CBOD.1
`YCL-BOD-REVISION` BOD_REVISION	Alpha 22 (Lower Case)	—	CBOD.1
`YCL-BOD-SOR` BOD_SOR	Alpha 1	—	CBOD.1
`YCL-BOD-VAR-ID` BOD_VAR_ID	Alpha 22 (Lower Case)	—	CBOD.1

Indexes (2)

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
`YCLSET1`	`CASH-CODE`, `BANK-INST-CODE`, `TRANS-NBR`, `SUFFIX`, `TRANS-IDENT`	Primary		AP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 +22 more (list truncated in source)
`YCLSET2`	`BOD-DOC-ID`, `BOD-ACCT-ENT`, `BOD-LOCATION`, `BOD-REVISION`			CBOD.1, CBOD.2

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Cbtrans	CBTRANS	Required		`YCL-CASH-CODE` → `CBT-CASH-CODE`, `YCL-BANK-INST-CODE` → `CBT-BANK-INST-CODE`, `YCL-TRANS-NBR` → `CBT-TRANS-NBR`, `YCL-SUFFIX` → `CBT-SUFFIX`, `YCL-TRANS-IDENT` → `CBT-TRANS-IDENT`

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