|
|
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 CB43.1
CB44.1 CB544 CB195 CB221
UPDATED BY
CB10.1 CB10.3 CB150 CB300 CB543
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBP-CASH-CODE Alpha 4 CB10.1 CB543
Element: 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 CB543
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 CB543
Element: Deposit NumberA unique number assigned to the deposit.
CBP-TRANS-TYPE Alpha 1 CB10.1 CB543
Element: Trans Type Determines if amounts or units are
processed in each transaction.
" " = Manual
1 = Wire
3 = Lockbox
CBP-USER-FIELD1 Alpha 30 CB10.1 CB543
Element: User Field1 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.
CBP-USER-FIELD2 Alpha 30 CB10.1 CB543
Element: User Field2 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.
CBP-USER-FIELD3 Alpha 30 CB10.1 CB543
Element: User Field1 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.
CBP-USER-FIELD4 Alpha 30 CB10.1 CB543
Element: User Field2 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.
CBP-DEPOSIT-AMOUNT Signed 18.2 CB10.1 CB543
Element: Intl Amt The amount of the deposit in the
currency of the bank account.
CBP-BASE-AMOUNT Signed 18.2 CB10.1 CB543
Element: Base Deposit AThe amount of the deposit in the
company base currency.
CBP-TRAN-ND Numeric 1 CB10.1 CB543
Element: Acct Nd The number of decimal places defined
for the currency of the bank account.
CBP-BASE-ND Numeric 1 CB10.1 CB543
Element: Base Nd The number of decimal places defined
for the company base currency.
CBP-COMPANY Numeric 4 CB10.1 CB543
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 CB543
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 CB543
Element: Deposit Date The date the funds will be deposited.
If left blank, the system date defaults.
CBP-POST-DATE Numeric 8 (yyyymmdd) CB10.1 CB543
Element: Post 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 CB543
Bank Account The bank account currency defined for
Currency the cash code.
CBP-EXCHANGE-RATE Signed 14.7 CB10.1 CB543
Element: Curr Rate The currency exchange rate used to
convert the bank account currency
deposit amount to the company base
currency.
CBP-DEP-APPL-AMT Signed 18.2 CB10.3 CB543
Element: Applied AmountThe total cash receipt distribution
amount in the currency of the bank
account.
CBP-BASE-APPL-AMT Signed 18.2 CB10.3 CB543
Element: Intl Amt The total cash receipt distribution
amount in the company base currency.
CBP-DESCRIPTION Alpha 30 (Lower Case) CB10.1 CB543
Element: Description The description of the cash receipt
deposit.
CBP-LAST-DIST-SEQ Numeric 4 CB10.3 CB543
Element: Seq Nbr The last system-assigned sequence
number assigned to distributions for the
cash receipt deposit.
CBP-REC-STATUS Numeric 1 CB10.1 CB150
Element: Rec Status The status of the cash receipt deposit. CB543
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: Acct 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 CB543
Element: Jrnl Book Nbr 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 CB543
Element: Recon Stmt NbrThe reconciliation statement number
assigned to the cash receipt deposit.
Used only for cash codes that require
reconciliation statements.
CBP-JBK-SEQ-NBR Numeric 10 CB10.1 CB543
Element: Jbk Seq Nbr 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).
CBP-SEGMENT-BLOCK Alpha 103 CB10.1
Element: Segment Block 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.
CBP-SOURCE-CODE Alpha 2 CB10.1 CB543
Element: Source Code A two character code assigned to a
transaction to identify where the
transaction was created.
CBRECPTHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBPSET1 CASH-CODE CB06.2 CB10.1
BANK-INST-CODE CB10.3 CB15.1
TRANS-NBR CB15.2 CB150
CB20.1 CB210
CB300 CB43.1
CB44.1 CB543
CB544
CBPSET2 CASH-CODE Subset CB195 CB221
BANK-INST-CODEWhere REC-STATUS = Zeroes
TRANS-NBR
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
|
