|
|
CBRECPTHDR FILE
Cash Receipt
The Cash Receipt file contains cash receipt deposit header records.
REFERENCED BY
CB06.2 CB15.1 CB15.2 CB20.1 CB210 CB195
CB221
UPDATED BY
CB10.1 CB10.3 CB300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBP-CASH-CODE Alpha 4 CB10.1
Accounts Receivable The cash code. Represents the bank
Code 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
Element: Transaction CoThe 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
Element: Deposit NumberA unique number assigned to the deposit.
CBP-DEPOSIT-AMOUNT Signed 15.2 CB10.1
Element: Adj Amt The amount of the deposit in the
currency of the bank account.
CBP-BASE-AMOUNT Signed 15.2 CB10.1
Element: Base Deposit AThe amount of the deposit in the
company base currency.
CBP-TRAN-ND Numeric 1 CB10.1
Account Currency The number of decimal places defined
Code for the currency of the bank account.
CBP-BASE-ND Numeric 1 CB10.1
Account Currency The number of decimal places defined
Code for the company base currency.
CBP-COMPANY Numeric 4 CB10.1
Element: 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
Element: 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
Element: Date The date the funds will be deposited.
If left blank, the system date defaults.
CBP-POST-DATE Numeric 8 (yyyymmdd) CB10.1
Element: Date The date used for posting the cash
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
Element: Account 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
Element: Applied AmountThe total cash receipt distribution
amount in the currency of the bank
account.
CBP-BASE-APPL-AMT Signed 15.2 CB10.3
Element: Adj Amt The total cash receipt distribution
amount in the company base currency.
CBP-DESCRIPTION Alpha 30 (Lower Case) CB10.1
Element: Description The description of the cash receipt
deposit.
CBP-LAST-DIST-SEQ Numeric 4 CB10.3
Element: Sequence NumbeThe last system-assigned sequence
number assigned to distributions for the
cash receipt deposit.
CBP-REC-STATUS Numeric 1 CB10.1
Element: Record Status The status of the cash receipt deposit.
Valid values are:
0 = Unreleased.
1 = Released.
CBP-ACTIVITY Alpha 15 CB10.1
Element: 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
Element: Account CategoThe 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
Element: 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).
CBP-SEGMENT-BLOCK Alpha 103 CB10.1
Element: User Analysis 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.
CBRECPTHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBPSET1 CASH-CODE This is the primary index and is used CB06.2 CB10.1
BANK-INST-CODEto keep cash receipt deposit records CB10.3 CB15.1
TRANS-NBR unique for a specific cash code. CB15.2 CB20.1
CB210 CB300
CBPSET2 CASH-CODE This index is used to access unreleased CB195 CB221
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
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
|
