CBRETPMT – Return Payment

System: Cash Ledger (CB)
Prefix: CRP
Primary key: CASH-CODE, BANK-INST-CODE, TRANS-IDENT
Fields: 39
Updated by: 4 programs
Referenced by: 2 programs

CBRETPMT is the Return Payment table in Lawson Cash Ledger (prefix CRP). It is indexed by CASH-CODE, BANK-INST-CODE, TRANS-IDENT (CRPSET1); alternate indexes: CRPSET2. It is related 1:1 to CBFTTRANS and CBTRANS and 1:M to CBDISTRIB. It is updated by CB150, CB300, CB46.1 and CB544 and referenced by CB195 and CB246. The table has 39 fields, 2 indexes and 4 documented relations.

About CBRETPMT

No description in the Lawson data dictionary.

Fields (39)

Column = COBOL field name without the CRP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`CRP-CASH-CODE` PK CASH_CODE	Alpha 4	A cash code represents a bank account. More than one company can use the same cash code. The cash code must be linked to a bank in the Lawson Cash Ledger system.	CB46.1, CB544
`CRP-BANK-INST-CODE` PK BANK_INST_CODE	Alpha 3	A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.	CB46.1, CB544
`CRP-TRANS-NBR` TRANS_NBR	Alpha 10 (Right Justified)	A unique, user-defined value used to identify the transaction.	CB46.1, CB544
`CRP-TRANS-IDENT` PK TRANS_IDENT	Numeric 10	A unique system-generated identification value assigned to the transaction to make this record unique.	CB46.1, CB544
`CRP-REC-STATUS` REC_STATUS	Numeric 1	The record status. `0` Unreleased `1` Released	CB150, CB46.1, CB544
`CRP-COMPANY` COMPANY	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	CB46.1, CB544
`CRP-DEPOSIT-AMOUNT` DEPOSIT_AMOUNT	Signed 18.2	—	CB46.1, CB544
`CRP-DEPOSIT-DATE` DEPOSIT_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	CB46.1, CB544
`CRP-RETURN-AMOUNT` RETURN_AMOUNT	Signed 18.2	—	CB46.1, CB544
`CRP-BASE-RET-AMT` BASE_RET_AMT	Signed 18.2	—	CB46.1, CB544
`CRP-TO-RET-AMT` TO_RET_AMT	Signed 18.2	—	CB544
`CRP-TRAN-ND` TRAN_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	CB46.1, CB544
`CRP-BASE-ND` BASE_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	CB46.1, CB544
`CRP-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the bank account currency defined for the cash code.	CB46.1, CB544
`CRP-EXCHANGE-RATE` EXCHANGE_RATE	Signed 14.7	The currency rate.	CB46.1, CB544
`CRP-DEP-JBK-NBR` DEP_JBK_NBR	Alpha 12	The journal book assigned to the transaction.	CB46.1, CB544
`CRP-DEP-JBK-SEQ` DEP_JBK_SEQ	Numeric 10	The journal book sequence number assigned to a journal book transaction when it is added or interfaced to the Lawson system. Used only when Auto Journal Book Seq Nbr is set to Yes in GL10.1 (Company).	—
`CRP-RET-DATE` RET_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	CB46.1, CB544
`CRP-POST-DATE` POST_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	CB46.1, CB544
`CRP-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	CB46.1, CB544
`CRP-DEP-BANK-INST` DEP_BANK_INST	Alpha 3	A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.	CB46.1, CB544
`CRP-DEPOSIT-NBR` DEPOSIT_NBR	Alpha 10 (Right Justified)	A unique, user-defined value used to identify the transaction.	CB46.1, CB544
`CRP-DEPOSIT-TYPE` DEPOSIT_TYPE	Alpha 1	Determines if amounts or units are processed in each transaction. " " = Manual `1` Wire `2` Credit Card `3` Lockbox `4` EFT Extract	CB46.1, CB544
`CRP-DEP-TRANS-IDEN` DEP_TRANS_IDEN	Numeric 10	A unique system-generated identification value assigned to the transaction to make this record unique.	CB544
`CRP-EFT-NUMBER` EFT_NUMBER	Alpha 10 (Right Justified)	A unique, user-defined value used to identify the transaction.	CB46.1, CB544
`CRP-BEXP-TRAN-AMT` BEXP_TRAN_AMT	Signed 18.2	—	CB46.1, CB544
`CRP-BEXP-COMPANY` BEXP_COMPANY	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	CB46.1
`CRP-BEXP-ACCT-UNIT` BEXP_ACCT_UNIT	Alpha 15	The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	CB46.1, CB544
`CRP-BEXP-ACCOUNT` BEXP_ACCOUNT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	CB46.1, CB544
`CRP-BEXP-SUB-ACCT` BEXP_SUB_ACCT	Numeric 4	This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	CB46.1, CB544
`CRP-BEXP-ACTIVITY` BEXP_ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	CB46.1, CB544
`CRP-BEXP-ACCT-CAT` BEXP_ACCT_CAT	Alpha 5	Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru	CB46.1, CB544
`CRP-USER-FIELD1` USER_FIELD1	Alpha 30	This is the first user definable field. It can be used to capture any data that the user wants. The title of the field is setup in IC00.	CB46.1, CB544
`CRP-USER-FIELD2` USER_FIELD2	Alpha 30	This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.	CB46.1, CB544
`CRP-USER-FIELD3` USER_FIELD3	Alpha 30	This is the first user definable field. It can be used to capture any data that the user wants. The title of the field is setup in IC00.	CB46.1, CB544
`CRP-USER-FIELD4` USER_FIELD4	Alpha 30	This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.	CB46.1, CB544
`CRP-LAST-DIST-SEQ` LAST_DIST_SEQ	Numeric 4	An automatically assigned sequence number.	CB46.1, CB544
`CRP-SOURCE-CODE` SOURCE_CODE	Alpha 2	A two character code assigned to a transaction to identify where the transaction was created.	CB46.1, CB544
`CRP-RECON-STMT-NBR` RECON_STMT_NBR	Numeric 12	The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.	CB46.1, CB544

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
`CRPSET1`	`CASH-CODE`, `BANK-INST-CODE`, `TRANS-IDENT`	Primary		CB150, CB246, CB300
`CRPSET2`	`CASH-CODE`, `BANK-INST-CODE`, `TRANS-NBR`, `TRANS-IDENT`			CB150, CB195, CB46.1

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Cbfttrans	CBFTTRANS	Required		`CRP-CASH-CODE` → `CFT-CASH-CODE`, `CRP-BANK-INST-CODE` → `CFT-BANK-INST-CODE`, `CRP-TRANS-IDENT` → `CFT-TRANS-IDENT`
Cbtrans	CBTRANS	Required		`CRP-BANK-INST-CODE` → `CBT-BANK-INST-CODE`, `CRP-TRANS-IDENT` → `CBT-TRANS-IDENT`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Cbdistrib	CBDISTRIB			`CRP-CASH-CODE` → `CBD-CASH-CODE`, `CRP-BANK-INST-CODE` → `CBD-BANK-INST-CODE`, `CRP-TRANS-IDENT` → `CBD-TRANS-IDENT`, → `CBD-DIST-TYPE`, → `CBD-SEQ-NBR`
Cbdistrib1	CBDISTRIB			`CRP-CASH-CODE` → `CBD-CASH-CODE`, `CRP-DEP-BANK-INST` → `CBD-BANK-INST-CODE`, `CRP-DEP-TRANS-IDEN` → `CBD-TRANS-IDENT`, → `CBD-DIST-TYPE`, → `CBD-SEQ-NBR`

CBRETPMT – Return Payment

About CBRETPMT

Fields (39)

Indexes (2)

Relations

One to one (2) — lookups and parents

One to many (2) — child tables

Programs

Updated by (4)

Referenced by (2)