CBRETPMT

Return Payment
UPDATED BY
CB150 CB300 CB46.1 CB544 CB246

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CRP-CASH-CODE
Element: 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
Element: 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
Element: Trans Nbr
Alpha 10 (Right Justified)
A unique, user-defined value used to identify the transaction.
CB46.1 CB544
CRP-TRANS-IDENT
Element: 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
Element: Rec Status
Numeric 1
The record status.
0 = Unreleased
1 = Released
CB150 CB46.1
CB544
CRP-COMPANY
Element: 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
Element: Intl Amt
Signed 18.2
CB46.1 CB544
CRP-DEPOSIT-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
CB46.1 CB544
CRP-RETURN-AMOUNT
Element: Intl Amt
Signed 18.2
CB46.1 CB544
CRP-BASE-RET-AMT
Element: Intl Amt
Signed 18.2
CB46.1 CB544
CRP-TO-RET-AMT
Element: Intl Amt
Signed 18.2
CB544
CRP-TRAN-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
CB46.1 CB544
CRP-BASE-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
CB46.1 CB544
CRP-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the bank account currency defined for the cash code.
CB46.1 CB544
CRP-EXCHANGE-RATE
Element: Curr Rate
Signed 14.7
The currency rate.
CB46.1 CB544
CRP-DEP-JBK-NBR
Element: Jrnl Book Nbr
Alpha 12
The journal book assigned to the transaction.
CB46.1 CB544
CRP-DEP-JBK-SEQ
Element: Jbk Seq Nbr
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
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
CB46.1 CB544
CRP-POST-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
CB46.1 CB544
CRP-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
CB46.1 CB544
CRP-DEP-BANK-INST
Element: 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-DEPOSIT-NBR
Element: Trans Nbr
Alpha 10 (Right Justified)
A unique, user-defined value used to identify the transaction.
CB46.1 CB544
CRP-DEPOSIT-TYPE
Element: Trans 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
Element: Trans Ident
Numeric 10
A unique system-generated identification value assigned to the transaction to make this record unique.
CB544
CRP-EFT-NUMBER
Element: Trans Nbr
Alpha 10 (Right Justified)
A unique, user-defined value used to identify the transaction.
CB46.1 CB544
CRP-BEXP-TRAN-AMT
Element: Intl Amt
Signed 18.2
CB46.1 CB544
CRP-BEXP-COMPANY
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
CB46.1 CB544
CRP-USER-FIELD1
Element: 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
Element: 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
Element: 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-FIELD4
Element: 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-LAST-DIST-SEQ
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
CB46.1 CB544
CRP-SOURCE-CODE
Element: 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
Element: Recon Stmt Nbr
Numeric 12
The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.
CB46.1 CB544


CBRETPMT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CRPSET1 CASH-CODE
BANK-INST-CODE
TRANS-IDENT
CB150 CB246
CB300
CRPSET2 CASH-CODE
BANK-INST-CODE
TRANS-NBR
TRANS-IDENT
CB150 CB46.1


CBRETPMT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


CBRETPMT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Wed Jun 08 20:48:23 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.