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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#CRP-CASH-CODE PK
CASH_CODE		Alpha 4A 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 3A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.CB46.1, CB544
#CRP-TRANS-NBR SET2
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 10A unique system-generated identification value assigned to the transaction to make this record unique.CB46.1, CB544
#CRP-REC-STATUS
REC_STATUS		Numeric 1The record status.
  • 0 Unreleased
  • 1 Released
CB150, CB46.1, CB544
#CRP-COMPANY
COMPANY		Numeric 4Identifies 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 1The number of decimals assigned to a particular account as determined by the account currency.CB46.1, CB544
#CRP-BASE-ND
BASE_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.CB46.1, CB544
#CRP-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the bank account currency defined for the cash code.CB46.1, CB544
#CRP-EXCHANGE-RATE
EXCHANGE_RATE		Signed 14.7The currency rate.CB46.1, CB544
#CRP-DEP-JBK-NBR
DEP_JBK_NBR		Alpha 12The journal book assigned to the transaction.CB46.1, CB544
#CRP-DEP-JBK-SEQ
DEP_JBK_SEQ		Numeric 10The 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 3A 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 1Determines 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 10A 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 4Identifies 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 15The 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 6This 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 4This 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 15Activities 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 5Account 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 thruCB46.1, CB544
#CRP-USER-FIELD1
USER_FIELD1		Alpha 30This 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 30This 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 30This 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 30This 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 4An automatically assigned sequence number.CB46.1, CB544
#CRP-SOURCE-CODE
SOURCE_CODE		Alpha 2A 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 12The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.CB46.1, CB544

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.

IndexKeysFlagsConditionUsed in
CRPSET1
  1. CASH-CODE
  2. BANK-INST-CODE
  3. TRANS-IDENT
PrimaryCB150, CB246, CB300
CRPSET2
  1. CASH-CODE
  2. BANK-INST-CODE
  3. TRANS-NBR
  4. TRANS-IDENT
CB150, CB195, CB46.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CBFTTRANSCBTRANSCBDISTRIBCBRETPMT

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CbfttransCBFTTRANSRequired
CRP-CASH-CODE→CFT-CASH-CODE
CRP-BANK-INST-CODE→CFT-BANK-INST-CODE
CRP-TRANS-IDENT→CFT-TRANS-IDENT
CbtransCBTRANSRequired
CRP-BANK-INST-CODE→CBT-BANK-INST-CODE
CRP-TRANS-IDENT→CBT-TRANS-IDENT

One to many (2) — child tables

RelationTableRulesConditionField map
CbdistribCBDISTRIB
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
Cbdistrib1CBDISTRIB
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

Programs

Updated by (4)

Referenced by (2)