|
|
ACRETAIN FILE
REFERENCED BY
AC121 AC123 AC130 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC32.1 AC37.1 AC490 BR00.1
BR120 BR202 BR420 BR450 BR521
UPDATED BY
AC300 AC310 BR02.1 BR02.2 BR121 BR122
BR10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RET-ACTIVITY Alpha 15 BR02.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.
RET-RETAIN-ID Numeric 6 BR02.1 BR122
Element: Retain Id
RET-DESCRIPTION Alpha 30 (Lower Case) BR02.1
Element: Description This field displays the description.
RET-RETAINER-TYPE Alpha 1 BR02.1 BR122
Element: Retainer Type F = First
L = Last
S = Specific
RET-AMOUNT Currency 15.2 BR02.1 BR122
Element: Amount This is the amounts by period for the
specified record.
RET-APPLIED-AMT Signed 15.2 AC300 BR121
Element: Adj Amt BR122
RET-CURRENCY-CODE Alpha 5 BR02.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
RET-STATUS Numeric 1 AC300 BR02.1
Element: Status This field displays the status of the BR121 BR122
transaction.
0 = Open
1 = Applied
RET-RETAIN-GL-CD Alpha 4
Element: Retain Gl Cd
RET-ACCT-CATEGORY Alpha 5
Element: Account CategoAccount 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.
RET-RETAINER-BAL Signed 15.2 AC300 BR02.2
Element: Retainer Bal BR122
RET-RETAIN-PCT-BAL Signed 7.4 BR02.2 BR122
Element: Retain Pct Bal
RET-RETAIN-RULE Alpha 1 BR02.1
Element: Retain Rule
ACRETAIN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RETSET1 ACTIVITY AC121 AC123
RETAIN-ID AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC300 AC310
AC32.1 AC37.1
AC490 BR00.1
BR02.1 BR02.2
BR02.3 BR10.1
BR120 BR121
BR122 BR202
BR420 BR450
BR521
RETSET2 ACTIVITY KeyChange BR122
RETAIN-ID*
ACRETAIN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
RET-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acactivity ACACTIVITY Required
RET-ACTIVITY -> ACV-ACTIVITY
Acbill ACBILL Required
RET-ACTIVITY -> ACI-ACTIVITY
Acglcode ACGLCODE Not Required
RET-RETAIN-GL-CD -> AGC-AC-GL-CODE
ACRETAIN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acretainx ACRETAINX
RET-ACTIVITY -> REX-ACTIVITY
RET-RETAIN-ID -> REX-RETAIN-ID
REX-RETAIN-CODE
|
