|
|
CBRTPLOAD FILE
Return Payment Conversion/Imp
UPDATED BY
CB44.1 CB544
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RPL-CASH-CODE Alpha 4 CB44.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.
RPL-BANK-INST-CODE Alpha 3 CB44.1
Element: Bank Inst CodeA transaction code represents a type of
cash payment, bill of exchange payment,
or bank service transaction.
RPL-TRANS-NBR Alpha 10 (Right Justified) CB44.1 CB544
Element: Trans Nbr A unique, user-defined value used to
identify the transaction.
RPL-SEQ-NBR Numeric 4 CB44.1
Element: Seq Nbr An automatically assigned sequence
number.
RPL-REC-STATUS Numeric 1 CB44.1
Element: Rec Status The record status.
0 = Unreleased
1 = Released
RPL-COMPANY Numeric 4 CB44.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.
RPL-RET-DATE Numeric 8 (yyyymmdd) CB44.1
Element: Date This field displays the system date
when this was created.
RPL-POST-DATE Numeric 8 (yyyymmdd) CB44.1 CB544
Element: Date This field displays the system date
when this was created.
RPL-DESCRIPTION Alpha 30 (Lower Case) CB44.1 CB544
Element: Description This field displays the description.
RPL-DEP-BANK-INST Alpha 3 CB44.1
Element: Bank Inst CodeA transaction code represents a type of
cash payment, bill of exchange payment,
or bank service transaction.
RPL-DEPOSIT-NBR Alpha 10 (Right Justified) CB44.1
Element: Trans Nbr A unique, user-defined value used to
identify the transaction.
RPL-DEPOSIT-TYPE Alpha 1 CB44.1
Element: Trans Type Determines if amounts or units are
processed in each transaction.
" " = Manual
1 = Wire
2 = Credit Card
3 = Lockbox
4 = EFT Extract
RPL-EFT-NUMBER Alpha 10 (Right Justified) CB44.1
Element: Trans Nbr A unique, user-defined value used to
identify the transaction.
RPL-BEXP-TRAN-AMT Signed 18.2 CB44.1
Element: Intl Amt
RPL-BEXP-COMPANY Numeric 4 CB44.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.
RPL-BEXP-ACCT-UNIT Alpha 15 CB44.1 CB544
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.
RPL-BEXP-ACCOUNT Numeric 6 CB44.1 CB544
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
RPL-BEXP-SUB-ACCT Numeric 4 CB44.1 CB544
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.
RPL-BEXP-ACTIVITY Alpha 15 CB44.1
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.
RPL-BEXP-ACCT-CAT Alpha 5 CB44.1 CB544
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
RPL-USER-FIELD1 Alpha 30 CB44.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.
RPL-USER-FIELD2 Alpha 30 CB44.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.
RPL-USER-FIELD3 Alpha 30 CB44.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.
RPL-USER-FIELD4 Alpha 30 CB44.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.
RPL-RCPT-COMPANY Numeric 4 CB44.1 CB544
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.
RPL-RCPT-ACCT-UNIT Alpha 15 CB44.1 CB544
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.
RPL-RCPT-ACCOUNT Numeric 6 CB44.1 CB544
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
RPL-RCPT-SUB-ACCT Numeric 4 CB44.1 CB544
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.
RPL-RECEIPT-AMOUNT Signed 18.2 CB44.1 CB544
Element: Intl Amt
RPL-REFERENCE Alpha 10 (Lower Case) CB44.1
Element: Reference The reference number associated with
the transaction.
RPL-TAX-CODE Alpha 10 CB44.1
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
RPL-TAXABLE-AMT Signed 18.2 CB44.1
Element: Intl Amt
RPL-ACTIVITY Alpha 15 CB44.1
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.
RPL-ACCT-CATEGORY Alpha 5 CB44.1 CB544
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
RPL-SEGMENT-BLOCK Alpha 103 CB44.1 CB544
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.
RPL-SOURCE-CODE Alpha 2 CB44.1 CB544
Element: Source Code A two character code assigned to a
transaction to identify where the
transaction was created.
RPL-RECON-STMT-NBR Numeric 12 CB44.1
Element: Recon Stmt NbrThe bank-assigned reconciliation
statement number. Used only for cash
codes that require reconciliation
statements.
CBRTPLOAD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RPLSET1 CASH-CODE CB44.1 CB544
BANK-INST-CODE
TRANS-NBR
SEQ-NBR
|
