|
|
CBRETPMT FILE
Return Payment
REFERENCED BY
CB246
UPDATED BY
CB150 CB300 CB46.1 CB544
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CRP-CASH-CODE Alpha 4 CB46.1 CB544
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.
CRP-BANK-INST-CODE Alpha 3 CB46.1 CB544
Element: Bank Inst CodeA transaction code represents a type of
cash payment, bill of exchange payment,
or bank service transaction.
CRP-TRANS-NBR Alpha 10 (Right Justified) CB46.1 CB544
Element: Trans Nbr A unique, user-defined value used to
identify the transaction.
CRP-TRANS-IDENT Numeric 10 CB46.1 CB544
Element: Trans Ident A unique system-generated
identification value assigned to the
transaction to make this record unique.
CRP-REC-STATUS Numeric 1 CB150 CB46.1
Element: Rec Status The record status. CB544
0 = Unreleased
1 = Released
CRP-COMPANY Numeric 4 CB46.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.
CRP-DEPOSIT-AMOUNT Signed 18.2 CB46.1 CB544
Element: Intl Amt
CRP-DEPOSIT-DATE Numeric 8 (yyyymmdd) CB46.1 CB544
Element: Date This field displays the system date
when this was created.
CRP-RETURN-AMOUNT Signed 18.2 CB46.1 CB544
Element: Intl Amt
CRP-BASE-RET-AMT Signed 18.2 CB46.1 CB544
Element: Intl Amt
CRP-TO-RET-AMT Signed 18.2 CB544
Element: Intl Amt
CRP-TRAN-ND Numeric 1 CB46.1 CB544
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
CRP-BASE-ND Numeric 1 CB46.1 CB544
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
CRP-CURRENCY-CODE Alpha 5 CB46.1 CB544
Element: Currency Code This field contains the bank account
currency defined for the cash code.
CRP-EXCHANGE-RATE Signed 14.7 CB46.1 CB544
Element: Curr Rate The currency rate.
CRP-DEP-JBK-NBR Alpha 12 CB46.1 CB544
Element: Jrnl Book Nbr The journal book assigned to the
transaction.
CRP-DEP-JBK-SEQ Numeric 10
Element: Jbk Seq Nbr 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).
CRP-RET-DATE Numeric 8 (yyyymmdd) CB46.1 CB544
Element: Date This field displays the system date
when this was created.
CRP-POST-DATE Numeric 8 (yyyymmdd) CB46.1 CB544
Element: Date This field displays the system date
when this was created.
CRP-DESCRIPTION Alpha 30 (Lower Case) CB46.1 CB544
Element: Description This field displays the description.
CRP-DEP-BANK-INST Alpha 3 CB46.1 CB544
Element: Bank Inst CodeA transaction code represents a type of
cash payment, bill of exchange payment,
or bank service transaction.
CRP-DEPOSIT-NBR Alpha 10 (Right Justified) CB46.1 CB544
Element: Trans Nbr A unique, user-defined value used to
identify the transaction.
CRP-DEPOSIT-TYPE Alpha 1 CB46.1 CB544
Element: Trans Type Determines if amounts or units are
processed in each transaction.
" " = Manual
1 = Wire
2 = Credit Card
3 = Lockbox
4 = EFT Extract
CRP-DEP-TRANS-IDEN Numeric 10 CB544
Element: Trans Ident A unique system-generated
identification value assigned to the
transaction to make this record unique.
CRP-EFT-NUMBER Alpha 10 (Right Justified) CB46.1 CB544
Element: Trans Nbr A unique, user-defined value used to
identify the transaction.
CRP-BEXP-TRAN-AMT Signed 18.2 CB46.1 CB544
Element: Intl Amt
CRP-BEXP-COMPANY Numeric 4 CB46.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.
CRP-BEXP-ACCT-UNIT Alpha 15 CB46.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.
CRP-BEXP-ACCOUNT Numeric 6 CB46.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.
CRP-BEXP-SUB-ACCT Numeric 4 CB46.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.
CRP-BEXP-ACTIVITY Alpha 15 CB46.1 CB544
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.
CRP-BEXP-ACCT-CAT Alpha 5 CB46.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
CRP-USER-FIELD1 Alpha 30 CB46.1 CB544
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.
CRP-USER-FIELD2 Alpha 30 CB46.1 CB544
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.
CRP-USER-FIELD3 Alpha 30 CB46.1 CB544
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.
CRP-USER-FIELD4 Alpha 30 CB46.1 CB544
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.
CRP-LAST-DIST-SEQ Numeric 4 CB46.1 CB544
Element: Seq Nbr An automatically assigned sequence
number.
CRP-SOURCE-CODE Alpha 2 CB46.1 CB544
Element: Source Code A two character code assigned to a
transaction to identify where the
transaction was created.
CRP-RECON-STMT-NBR Numeric 12 CB46.1 CB544
Element: Recon Stmt NbrThe bank-assigned reconciliation
statement number. Used only for cash
codes that require reconciliation
statements.
CBRETPMT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CRPSET1 CASH-CODE CB150 CB246
BANK-INST-CODE CB300
TRANS-IDENT
CRPSET2 CASH-CODE CB150 CB46.1
BANK-INST-CODE
TRANS-NBR
TRANS-IDENT
CBRETPMT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cbfttrans CBFTTRANS Required
CRP-CASH-CODE -> CFT-CASH-CODE
CRP-BANK-INST-CODE -> CFT-BANK-INST-CODE
CRP-TRANS-IDENT -> CFT-TRANS-IDENT
Cbtrans CBTRANS Required
CRP-BANK-INST-CODE -> CBT-BANK-INST-CODE
CRP-TRANS-IDENT -> CBT-TRANS-IDENT
CBRETPMT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cbdistrib CBDISTRIB
CRP-CASH-CODE -> CBD-CASH-CODE
CRP-BANK-INST-CODE -> CBD-BANK-INST-CODE
CRP-TRANS-IDENT -> CBD-TRANS-IDENT
CBD-DIST-TYPE
CBD-SEQ-NBR
Cbdistrib1 CBDISTRIB
CRP-CASH-CODE -> CBD-CASH-CODE
CRP-DEP-BANK-INST -> CBD-BANK-INST-CODE
CRP-DEP-TRANS-IDEN -> CBD-TRANS-IDENT
CBD-DIST-TYPE
CBD-SEQ-NBR
|
