CBRTPLOAD – Return Payment Conversion/Imp

System: Cash Ledger (CB)
Prefix: RPL
Primary key: CASH-CODE, BANK-INST-CODE, TRANS-NBR, SEQ-NBR
Fields: 37
Updated by: 2 programs
Referenced by: 0 programs

CBRTPLOAD is the Return Payment Conversion/Imp table in Lawson Cash Ledger (prefix RPL). It is indexed by CASH-CODE, BANK-INST-CODE, TRANS-NBR, SEQ-NBR (RPLSET1). It is updated by CB44.1 and CB544. The table has 37 fields, 1 index and 0 documented relations.

About CBRTPLOAD

No description in the Lawson data dictionary.

Fields (37)

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

Field / column	Type	Description & values	Updated by
`RPL-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.	CB44.1
`RPL-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.	CB44.1
`RPL-TRANS-NBR` PK TRANS_NBR	Alpha 10 (Right Justified)	A unique, user-defined value used to identify the transaction.	CB44.1, CB544
`RPL-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	CB44.1
`RPL-REC-STATUS` REC_STATUS	Numeric 1	The record status. `0` Unreleased `1` Released	CB44.1
`RPL-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.	CB44.1
`RPL-RET-DATE` RET_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	CB44.1
`RPL-POST-DATE` POST_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	CB44.1, CB544
`RPL-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	CB44.1, CB544
`RPL-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.	CB44.1
`RPL-DEPOSIT-NBR` DEPOSIT_NBR	Alpha 10 (Right Justified)	A unique, user-defined value used to identify the transaction.	CB44.1
`RPL-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	CB44.1
`RPL-EFT-NUMBER` EFT_NUMBER	Alpha 10 (Right Justified)	A unique, user-defined value used to identify the transaction.	CB44.1
`RPL-BEXP-TRAN-AMT` BEXP_TRAN_AMT	Signed 18.2	—	CB44.1
`RPL-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.	CB44.1
`RPL-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.	CB44.1, CB544
`RPL-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.	CB44.1, CB544
`RPL-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.	CB44.1, CB544
`RPL-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.	CB44.1
`RPL-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	CB44.1, CB544
`RPL-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.	CB44.1
`RPL-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.	CB44.1
`RPL-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.	CB44.1
`RPL-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.	CB44.1
`RPL-RCPT-COMPANY` RCPT_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.	CB44.1, CB544
`RPL-RCPT-ACCT-UNIT` RCPT_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.	CB44.1, CB544
`RPL-RCPT-ACCOUNT` RCPT_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.	CB44.1, CB544
`RPL-RCPT-SUB-ACCT` RCPT_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.	CB44.1, CB544
`RPL-RECEIPT-AMOUNT` RECEIPT_AMOUNT	Signed 18.2	—	CB44.1, CB544
`RPL-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	The reference number associated with the transaction.	CB44.1
`RPL-TAX-CODE` TAX_CODE	Alpha 10	This field contains a code representing specific tax information. This must be valid Tax Code.	CB44.1
`RPL-TAXABLE-AMT` TAXABLE_AMT	Signed 18.2	—	CB44.1
`RPL-ACTIVITY` 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.	CB44.1
`RPL-ACCT-CATEGORY` ACCT_CATEGORY	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	CB44.1, CB544
`RPL-SEGMENT-BLOCK` SEGMENT_BLOCK	Alpha 103	This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.	CB44.1, CB544
`RPL-SOURCE-CODE` SOURCE_CODE	Alpha 2	A two character code assigned to a transaction to identify where the transaction was created.	CB44.1, CB544
`RPL-RECON-STMT-NBR` RECON_STMT_NBR	Numeric 12	The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.	CB44.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
`RPLSET1`	`CASH-CODE`, `BANK-INST-CODE`, `TRANS-NBR`, `SEQ-NBR`	Primary		CB44.1, CB544

Programs

Updated by (2)

CB44.1 Returned Payment Maintenance
CB544 Returned Payment Load