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. |
|
||
| 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. |
|
||
| 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. |
|
||
| CRC-TRANS-NBR Element: Trans Nbr | Alpha 10 (Right Justified) A unique, user-defined value used to identify the transaction. |
|
||
| CRC-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||
| 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 |
|
||
| CRC-REC-STATUS Element: Rec Status | Numeric 1 The record status. 0 = Unreleased 1 = Released |
|
||
| 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. |
|
||
| CRC-TRANS-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||
| CRC-POST-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||
| CRC-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||
| CRC-PROC-LEVEL Element: Process Level | Alpha 5 This field contains the process level, which is the reporting hierarchy below company. |
|
||
| CRC-ACH-PRENOTE Element: Ach Prenot | Alpha 1 N = Not Prenotified A = Accepted |
|
||
| CRC-JRNL-BOOK-NBR Element: Jrnl Book Nbr | Alpha 12 The journal book assigned to the transaction. |
|
||
| 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. |
|
||
| CRC-CUST-NAME Element: Search Name | Alpha 30 |
|
||
| CRC-CUST-BANK Element: Bank Entity | Alpha 15 Represents a bank institution location. |
|
||
| CRC-CUST-ACCOUNT Element: Bank Acct Nbr | Alpha 35 The bank-assigned account number identification to be used for the cash code. |
|
||
| CRC-VBANK-IDENT Element: Alphadata1 | Alpha 1 " " = Standard Account Number Y = IBAN Account Number |
|
||
| 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. |
|
||
| 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. |
|
||
| 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. |
|
||
| 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. |
|
||
| 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. |
|
||
| 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. |
|
||
| 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. |
|
||
| 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. |
|
||
| 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. |
|
||
| CRC-RECEIPT-AMOUNT Element: Intl Amt | Signed 18.2 |
|
||
| CRC-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code. |
|
||
| CRC-TAXABLE-AMT Element: Intl Amt | Signed 18.2 |
|
||
| CRC-TAX-AMOUNT Element: Intl Amt | Signed 18.2 |
|
||
| 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. |
|
||
| 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 |
|
||
| 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. |
|
||
| CRC-SOURCE-CODE Element: Source Code | Alpha 2 A two character code assigned to a transaction to identify where the transaction was created. |
|
||
| CRC-CONTRACT-GROUP Element: Enterprise Grp | Alpha 4 |
|
||
| CRC-CM-CONTRACT Element: Cm Contract | Numeric 15 |
|
||
| CRC-REBATE-TYPE Element: Rebate Type | Alpha 25 |
|
||
| CRC-REBATE-DUE-DTE Element: Date | Numeric 8 (yyyymmdd) |
|
||
| CRC-PAYMENT-NBR Element: Payment Nbr | Alpha 10 (Right Justified) |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CRCSET1 |
RUN-GROUP CASH-CODE BANK-INST-CODE TRANS-NBR SEQ-NBR |
|
| ||||||||
All trademarks and registered trademarks are the property of their
respective owners.