CBRECPTHDR

Cash Receipt Deposit

The Cash Receipt file contains cash receipt deposit header records.

REFERENCED BY
AP10.1 AP10.2 AP100 AP109 AP110 AP111
AP115 AP125 AP126 AP14.1 AP14.2 AP14.5
AP150 AP151 AP16.1 AP16.2 AP160 AP161
AP170 AP180 AP181 AP190 AP193 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.6 AP20.7
AP21.1 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
AP28.1 AP28.2 AP30.1 AP30.2 AP30.4 AP300
AP305 AP510 AP520 AP590 API1.1 API2.1
CB00.1 CB06.2 CB15.1 CB15.2 CB20.1 CB210
CB43.1 CB44.1 CB544 EE135 EE20.1 EE20.2
EE35.1 EE35.2 EE520 IC64.6 MA41.1 MA41.2
MA41.4 MA41.7 MA42.1 MA42.2 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA44.1 MA44.2 MA60.2
MA60.3 MA60.4 MA61.1 MA64.6 MA64.9 MA65.1
MA66.1 MA66.2 MA66.3 MA67.3 MA68.2 MA68.4
MA70.1 MA75.1 MAED.1 MAI1.1 CB195 CB221


UPDATED BY
CB10.1 CB10.3 CB10.5 CB150 CB180 CB300
CB543

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBP-CASH-CODE
Element: Cash Code
Alpha 4
The cash code. Represents the bank account you are depositing cash receipt funds to. Must be a valid record in the Cash Code file.
CB10.1 CB543
CBP-BANK-INST-CODE
Element: Transaction Code
Alpha 3
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.
CB10.1 CB543
CBP-TRANS-NBR
Element: Deposit Number
Alpha 10 (Right Justified)
A unique number assigned to the deposit.
CB10.1 CB543
CBP-TRANS-TYPE
Element: Trans Type
Alpha 1
Determines if amounts or units are processed in each transaction.
" " = Manual
1 = Wire
3 = Lockbox
CB10.1 CB543
CBP-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.
CB10.1 CB543
CBP-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.
CB10.1 CB543
CBP-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.
CB10.1 CB543
CBP-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.
CB10.1 CB543
CBP-DEPOSIT-AMOUNT
Element: Intl Amt
Signed 18.2
The amount of the deposit in the currency of the bank account.
CB10.1 CB543
CBP-BASE-AMOUNT
Element: Base Deposit Amount
Signed 18.2
The amount of the deposit in the company base currency.
CB10.1 CB543
CBP-TRAN-ND
Element: Acct Nd
Numeric 1
The number of decimal places defined for the currency of the bank account.
CB10.1 CB543
CBP-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal places defined for the company base currency.
CB10.1 CB543
CBP-COMPANY
Element: Company
Numeric 4
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.
CB10.1 CB543
CBP-PROC-LEVEL
Element: Process Level
Alpha 5
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.
CB10.1 CB543
CBP-DEPOSIT-DATE
Element: Deposit Date
Numeric 8 (yyyymmdd)
The date the funds will be deposited. If left blank, the system date defaults.
CB10.1 CB543
CBP-POST-DATE
Element: Post Date
Numeric 8 (yyyymmdd)
The date used for posting the cash receipt deposit to the general ledger. If left blank, the Deposit Date defaults.
CB10.1 CB543
CBP-CURRENCY-CODE
Bank Account
Currency
Alpha 5
The bank account currency defined for the cash code.
CB10.1 CB543
CBP-EXCHANGE-RATE
Element: Curr Rate
Signed 14.7
The currency exchange rate used to convert the bank account currency deposit amount to the company base currency.
CB10.1 CB543
CBP-DEP-APPL-AMT
Element: Applied Amount
Signed 18.2
The total cash receipt distribution amount in the currency of the bank account.
CB10.3 CB10.5
CB543
CBP-BASE-APPL-AMT
Element: Intl Amt
Signed 18.2
The total cash receipt distribution amount in the company base currency.
CB10.3 CB10.5
CB543
CBP-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The description of the cash receipt deposit.
CB10.1 CB543
CBP-LAST-DIST-SEQ
Element: Seq Nbr
Numeric 4
The last system-assigned sequence number assigned to distributions for the cash receipt deposit.
CB10.3 CB10.5
CB180 CB543
CBP-REC-STATUS
Element: Rec Status
Numeric 1
The status of the cash receipt deposit. Valid values are: 0 = Unreleased. 1 = Released.
CB10.1 CB150
CB543
CBP-ACTIVITY
Element: Activity
Alpha 15
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.
CB10.1
CBP-ACCT-CATEGORY
Element: Acct Category
Alpha 5
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.
CB10.1
CBP-JRNL-BOOK-NBR
Element: Jrnl Book Nbr
Alpha 12
The journal book assigned to the cash receipt deposit. Must be a valid record in the Journal Book Header file.
CB10.1 CB543
CBP-RECON-STMT-NBR
Element: Recon Stmt Nbr
Numeric 12
The reconciliation statement number assigned to the cash receipt deposit. Used only for cash codes that require reconciliation statements.
CB10.1 CB543
CBP-JBK-SEQ-NBR
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).
CB10.1 CB543
CBP-SEGMENT-BLOCK
Element: Segment Block
Alpha 103
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.
CB10.1
CBP-SOURCE-CODE
Element: Source Code
Alpha 2
A two character code assigned to a transaction to identify where the transaction was created.
CB10.1 CB543


CBRECPTHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBPSET1 CASH-CODE
BANK-INST-CODE
TRANS-NBR
...
AP10.1 AP10.2
AP100 AP109
AP110 AP111
AP115 AP125
AP126 AP14.1
AP14.2 AP14.5
AP150 AP151
AP16.1 AP16.2
AP160 AP161
AP170 AP180
AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
CBPSET2 CASH-CODE
BANK-INST-CODE
TRANS-NBR
Subset
WhereREC-STATUS =Zeroes
CB195 CB221


CBRECPTHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Cbrchdbod CBRCHDBOD Not Required, Delete Cascades
CBP-CASH-CODE->YBJ-CASH-CODE
CBP-BANK-INST-CODE->YBJ-BANK-INST-CODE
CBP-TRANS-NBR->YBJ-TRANS-NBR


CBRECPTHDR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:12:08 2016

Home
Contact Us



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