CBTRFTABLE – Fund Transfer Table
- System
- Cash Ledger (CB)
- Prefix
CBX- Primary key
CASH-CODE- Fields
- 4
- Updated by
- 1 program
- Referenced by
- 3 programs
CBTRFTABLE is the Fund Transfer Table table in Lawson Cash Ledger (prefix CBX). It is indexed by CASH-CODE (CBXSET1). It is related 1:1 to CBBANKENT, CBBANKINST and CBCASHCODE. It is updated by CB02.1 and referenced by CB15.1, CB15.2 and CB150. The table has 4 fields, 1 index and 5 documented relations.
About CBTRFTABLE
The Fund Transfer Table file identifies the bank service transaction codes used for bank fund transfers for a cash code (bank account). The bank service transaction codes represent a withdrawal from the account, a deposit to the account, and a bank expense associated with the funds transfer.
Fields (4)
Column = COBOL field name without the CBX- 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 |
|---|---|---|---|
#CBX-CASH-CODE PKCASH_CODE | Alpha 4 | The cash code. Represents a bank account. Must be a valid record in the Cash Code file. | CB02.1 |
#CBX-FROM-INST-CODEFROM_INST_CODE | Alpha 3 | The bank service transaction code used for transferring funds from the bank account (withdrawal). Must be a valid bank debit type bank service transaction code record in the Bank Transaction Code file. | CB02.1 |
#CBX-TO-INST-CODETO_INST_CODE | Alpha 3 | The bank service transaction code used for transferring funds to the bank account (deposit). Must be a valid bank credit type bank service transaction code record in the Bank Transaction Code file. | CB02.1 |
#CBX-EXP-INST-CODEEXP_INST_CODE | Alpha 3 | The bank service transaction code used for bank expenses associated with funds transfers for bank account. Must be a valid bank debit type bank service transaction code record in the Bank Transaction Code file. | CB02.1 |
Indexes (1)
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 |
|---|---|---|---|---|
CBXSET1 |
| Primary | CB02.1, CB15.1, CB15.2, CB150 |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Cbbankent | CBBANKENT | Required |
| ||||
| Cbbankinstexp | CBBANKINST | Required |
| ||||
| Cbbankinstfrom | CBBANKINST | Required |
| ||||
| Cbbankinstto | CBBANKINST | Required |
| ||||
| Cbcashcode | CBCASHCODE | Required |
|
Programs
Updated by (1)
- CB02.1 Bank Transfer Table