|
|
CBRECPTHDR FILE
Cash Receipt
The Cash Receipt file contains cash receipt deposit header records.
REFERENCED BY
CB210
UPDATED BY
CB10.1 CB10.3 CB300 CB733
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBP-CASH-CODE Alpha 4 CB10.1
Cash Code The cash code. Represents the bank
account you are depositing cash receipt
funds to. Must be a valid record in the
Cash Code file.
CBP-BANK-INST-CODE Alpha 3 CB10.1
Transaction Code The bank service transaction code.
Represents a deposit for the cash code.
Must be a valid bank service type
transaction code record in the Bank
Transaction Code file.
CBP-TRANS-NBR Alpha 10 (Right Justified) CB10.1
Deposit Number A unique number assigned to the
deposit.
CBP-DEPOSIT-AMOUNT Signed 15.2 CB10.1
Deposit Amount The amount of the deposit in the
currency of the bank account.
CBP-BASE-AMOUNT Signed 15.2 CB10.1
Base Deposit Amount The amount of the deposit in the
company base currency.
CBP-TRAN-ND Numeric 1 CB10.1
Transaction Number The number of decimal places defined
of Decimals for the currency of the bank account.
CBP-BASE-ND Numeric 1 CB10.1
Base Number Of The number of decimal places defined
Decimals for the company base currency.
CBP-COMPANY Numeric 4 CB10.1
Company The company number associated with the
deposit. Must be a valid record in the
General Ledger Company file and a valid
relationship record in the Company-Cash
Code Relationship file.
CBP-PROC-LEVEL Alpha 5 CB10.1
Process Level If using cash receipt process levels,
this field contains the process level
associated with the cash receipt
deposit. Must be a valid record in the
Cash Receipt Process Level file.
CBP-DEPOSIT-DATE Numeric 8 (yyyymmdd) CB10.1
Deposit Date The date the funds will be deposited.
If left blank, the system date defaults.
CBP-POST-DATE Numeric 8 (yyyymmdd) CB10.1
General Ledger The date used for posting the cash
Posting Date receipt deposit to the general ledger.
If left blank, the Deposit Date
defaults.
CBP-CURRENCY-CODE Alpha 5 CB10.1
Bank Account The bank account currency defined for
Currency the cash code.
CBP-EXCHANGE-RATE Signed 12.6 CB10.1
Exchange Rate The currency exchange rate used to
convert the bank account currency
deposit amount to the company base
currency.
CBP-DEP-APPL-AMT Signed 15.2 CB10.3
Applied Amount The total cash receipt distribution
amount in the currency of the bank
account.
CBP-BASE-APPL-AMT Signed 15.2 CB10.3
Base Applied Amount The total cash receipt distribution
amount in the company base currency.
CBP-DESCRIPTION Alpha 30 (Lower Case) CB10.1
Description The description of the cash receipt
deposit.
CBP-LAST-DIST-SEQ Numeric 4 CB10.3
Last Distribution The last system-assigned sequence
Sequence Nbr number assigned to distributions for the
cash receipt deposit.
CBP-REC-STATUS Numeric 1 CB10.1
Record Status The status of the cash receipt deposit.
Valid values are:
0 = Unreleased.
1 = Released.
CBP-ACTIVITY Alpha 15 CB10.1
Activity The activity assigned to the cash
receipt deposit. Must be a valid record
in the Activity file.
Activities are the tasks that make up
an activity group. Activities identify
work being done, such as work orders,
phases, products, and so on. A variety
of costs, revenues, or both make up an
activity. The Activity Management system
stores information such as
responsibility and schedule for each
activity. The breakdown of activity
costs and revenues is defined by account
categories. An activity must belong to
an activity group.
CBP-ACCT-CATEGORY Alpha 5 CB10.1
Account Category The account category assigned to the
cash receipt header. Must be a valid
record in the Activity Account Category
file.
Account categories are the Activity
Management accounts by which activity
transactions are grouped for budgeting
and reporting. Set up account categories
for an activity before you do any
budgeting or transaction processing.
Using account categories, you can sort
and combine incoming amounts into groups
for reporting and inquiry on activities.
CBP-JRNL-BOOK-NBR Alpha 12 CB10.1
Journal Book The journal book assigned to the cash
receipt deposit. Must be a valid record
in the Journal Book Header file.
CBP-RECON-STMT-NBR Numeric 12 CB10.1
Reconciliation The reconciliation statement number
Statement assigned to the cash receipt deposit.
Used only for cash codes that require
reconciliation statements.
CBP-JBK-SEQ-NBR Numeric 10 CB10.1
Journal Book The journal book sequence number
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).
CBRECPTHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBPSET1 CASH-CODE This is the primary index and is used CB10.1 CB10.3
BANK-INST-CODEto keep cash receipt deposit records CB210 CB300
TRANS-NBR unique for a specific cash code. CB733
CBPSET2 CASH-CODE This index is used to access unreleased
BANK-INST-CODEcash receipt deposit records.
TRANS-NBR Duplicates, Subset
Where REC-STATUS = Zeroes
CBRECPTHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cbbankent CBBANKENT Required
CBC-BANK-ENTITY -> CBE-BANK-ENTITY (CBESET1)
Cbbankinst CBBANKINST Required
CBP-BANK-INST-CODE -> CBI-BANK-INST-CODE
Cbcashcode CBCASHCODE Required
CBP-CASH-CODE -> CBC-CASH-CODE
Cbcpycash CBCPYCASH Required
CBP-COMPANY -> CBY-COMPANY
CBP-CASH-CODE -> CBY-CASH-CODE
CBRECPTHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cbrecptdtl CBRECPTDTL
CBP-CASH-CODE -> CBA-CASH-CODE
CBP-BANK-INST-CODE -> CBA-BANK-INST-CODE
CBP-TRANS-NBR -> CBA-TRANS-NBR
CBA-SEQ-NBR
|