|
CBRECLOAD FILE
Cash Receipt Conversion/Import
UPDATED BY
CB43.1 CB543
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CRC-RUN-GROUP Alpha 15 CB43.1
Element: Run Group Run Group and Seq Number are the keys
to the file. They should be used to
group records together for interfacing.
CRC-CASH-CODE Alpha 4 CB43.1
Element: Cash Code 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 Alpha 3 CB43.1
Element: Bank Inst CodeA transaction code represents a type of
cash payment, bill of exchange payment,
or bank service transaction.
CRC-TRANS-NBR Alpha 10 (Right Justified) CB43.1 CB543
Element: Trans Nbr A unique, user-defined value used to
identify the transaction.
CRC-SEQ-NBR Numeric 4 CB43.1
Element: Seq Nbr An automatically assigned sequence
number.
CRC-TRANS-TYPE Alpha 1 CB43.1 CB543
Element: Trans Type Determines if amounts or units are
processed in each transaction.
1 = Wire
2 = Credit Card
3 = Lockbox
4 = EFT Extract
CRC-REC-STATUS Numeric 1 CB43.1
Element: Rec Status The record status.
0 = Unreleased
1 = Released
CRC-COMPANY Numeric 4 CB43.1
Element: Company 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 Numeric 8 (yyyymmdd) CB43.1
Element: Date This field displays the system date
when this was created.
CRC-POST-DATE Numeric 8 (yyyymmdd) CB43.1 CB543
Element: Date This field displays the system date
when this was created.
CRC-DESCRIPTION Alpha 30 (Lower Case) CB43.1 CB543
Element: Description This field displays the description.
CRC-PROC-LEVEL Alpha 5 CB43.1
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
CRC-ACH-PRENOTE Alpha 1 CB43.1 CB543
Element: Ach Prenot N = Not Prenotified
A = Accepted
CRC-JRNL-BOOK-NBR Alpha 12 CB43.1
Element: Jrnl Book Nbr The journal book assigned to the
transaction.
CRC-RECON-STMT-NBR Numeric 12 CB43.1
Element: Recon Stmt NbrThe bank-assigned reconciliation
statement number. Used only for cash
codes that require reconciliation
statements.
CRC-CUST-NAME Alpha 30 CB43.1
Element: Search Name
CRC-CUST-BANK Alpha 15 CB43.1
Element: Bank Entity Represents a bank institution location.
CRC-CUST-ACCOUNT Alpha 35 CB43.1
Element: Bank Acct Nbr The bank-assigned account number
identification to be used for the cash
code.
CRC-VBANK-IDENT Alpha 1 CB43.1
Element: Alphadata1 " " = Standard Account Number
Y = IBAN Account Number
CRC-USER-FIELD1 Alpha 30 CB43.1
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.
CRC-USER-FIELD2 Alpha 30 CB43.1
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.
CRC-USER-FIELD3 Alpha 30 CB43.1
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.
CRC-USER-FIELD4 Alpha 30 CB43.1
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.
CRC-RCPT-COMPANY Numeric 4 CB43.1 CB543
Element: Company 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 Alpha 15 CB43.1
Element: Prod Tax Cat 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 Alpha 15 CB43.1
Element: Acct Unit 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 Numeric 6 CB43.1 CB543
Element: Account 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 Numeric 4 CB43.1 CB543
Element: Sub Acct 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 Signed 18.2 CB43.1
Element: Intl Amt
CRC-TAX-CODE Alpha 10 CB43.1 CB543
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
CRC-TAXABLE-AMT Signed 18.2 CB43.1 CB543
Element: Intl Amt
CRC-TAX-AMOUNT Signed 18.2 CB43.1 CB543
Element: Intl Amt
CRC-ACTIVITY Alpha 15 CB43.1 CB543
Element: Activity 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 Alpha 5 CB43.1 CB543
Element: Acct Category 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 Alpha 103 CB43.1 CB543
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.
CRC-SOURCE-CODE Alpha 2 CB43.1 CB543
Element: Source Code A two character code assigned to a
transaction to identify where the
transaction was created.
CBRECLOAD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CRCSET1 RUN-GROUP CB43.1 CB543
CASH-CODE
BANK-INST-CODE
TRANS-NBR
SEQ-NBR
|