CBRECLOAD

Cash Receipt Conversion/Import
UPDATED BY
CB43.1 CB543

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CRC-RUN-GROUP
Element: Run Group
Alpha 15
Run Group and Seq Number are the keys to the file. They should be used to group records together for interfacing.
CB43.1
CRC-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.
CB43.1
CRC-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.
CB43.1
CRC-TRANS-NBR
Element: Trans Nbr
Alpha 10 (Right Justified)
A unique, user-defined value used to identify the transaction.
CB43.1 CB543
CRC-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
CB43.1
CRC-TRANS-TYPE
Element: Trans Type
Alpha 1
Determines if amounts or units are processed in each transaction.
1 = Wire
2 = Credit Card
3 = Lockbox
4 = EFT Extract
CB43.1 CB543
CRC-REC-STATUS
Element: Rec Status
Numeric 1
The record status.
0 = Unreleased
1 = Released
CB43.1
CRC-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.
CB43.1
CRC-TRANS-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
CB43.1
CRC-POST-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
CB43.1 CB543
CRC-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
CB43.1 CB543
CRC-PROC-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
CB43.1
CRC-ACH-PRENOTE
Element: Ach Prenot
Alpha 1

N = Not Prenotified
A = Accepted
CB43.1 CB543
CRC-JRNL-BOOK-NBR
Element: Jrnl Book Nbr
Alpha 12
The journal book assigned to the transaction.
CB43.1
CRC-RECON-STMT-NBR
Element: Recon Stmt Nbr
Numeric 12
The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.
CB43.1
CRC-CUST-NAME
Element: Search Name
Alpha 30
CB43.1
CRC-CUST-BANK
Element: Bank Entity
Alpha 15
Represents a bank institution location.
CB43.1
CRC-CUST-ACCOUNT
Element: Bank Acct Nbr
Alpha 35
The bank-assigned account number identification to be used for the cash code.
CB43.1
CRC-VBANK-IDENT
Element: Alphadata1
Alpha 1

" " = Standard Account Number
Y = IBAN Account Number
CB43.1
CRC-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.
CB43.1
CRC-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.
CB43.1
CRC-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.
CB43.1
CRC-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.
CB43.1
CRC-RCPT-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.
CB43.1 CB543
CRC-PROD-TAX-CAT
Element: Prod Tax Cat
Alpha 15
A classification of items for determining taxes using the VERTEX system in Lawson Order Entry system or the cash receipts programs in the Lawson Cash Ledger system.
CB43.1
CRC-RCPT-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.
CB43.1 CB543
CRC-RCPT-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.
CB43.1 CB543
CRC-RCPT-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.
CB43.1 CB543
CRC-RECEIPT-AMOUNT
Element: Intl Amt
Signed 18.2
CB43.1 CB543
CRC-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
CB43.1 CB543
CRC-TAXABLE-AMT
Element: Intl Amt
Signed 18.2
CB43.1
CRC-TAX-AMOUNT
Element: Intl Amt
Signed 18.2
CB43.1 CB543
CRC-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.
CB43.1 CB543
CRC-ACCT-CATEGORY
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
CB43.1 CB543
CRC-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.
CB43.1 CB543
CRC-SOURCE-CODE
Element: Source Code
Alpha 2
A two character code assigned to a transaction to identify where the transaction was created.
CB43.1 CB543
CRC-CONTRACT-GROUP
Element: Enterprise Grp
Alpha 4
CB43.1
CRC-CM-CONTRACT
Element: Cm Contract
Numeric 15
CB43.1
CRC-REBATE-TYPE
Element: Rebate Type
Alpha 25
CB43.1
CRC-REBATE-DUE-DTE
Element: Date
Numeric 8 (yyyymmdd)
CB43.1
CRC-PAYMENT-NBR
Element: Payment Nbr
Alpha 10 (Right Justified)


CBRECLOAD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CRCSET1 RUN-GROUP
CASH-CODE
BANK-INST-CODE
TRANS-NBR
SEQ-NBR
CB43.1 CB543


File created: Thu Jun 09 11:11:44 2016

Home
Contact Us



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