ACRETAIN FILE
REFERENCED BY
AC121 AC123 AC130 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC32.1 AC490 BR120 BR202
BR420 BR450
UPDATED BY
AC300 AC310 BR02.1 BR02.2 BR121 BR21.1
BR00.1 BR10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RET-ACTIVITY Alpha 15 BR02.1
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 BR21.1
Retain Id
RET-DESCRIPTION Alpha 30 (Lower Case) BR02.1
Description This field displays the description.
RET-RETAINER-TYPE Alpha 1 BR02.1 BR21.1
Retainer Type F = First
L = Last
S = Specific
RET-AMOUNT Currency 15.2 BR02.1 BR21.1
Amount This is the amounts by period for the
specified record.
RET-APPLIED-AMT Signed 15.2 AC300 BR121
Applied Amount BR21.1
RET-CURRENCY-CODE Alpha 5 BR02.1
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
RET-STATUS Numeric 1 AC300 BR02.1
Status This field displays the status of the BR121 BR21.1
transaction.
0 = Open
1 = Applied
RET-RETAIN-GL-CD Alpha 4
Retain Gl Cd
RET-ACCT-CATEGORY Alpha 5
Account 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.
RET-RETAINER-BAL Signed 15.2 AC300 BR02.2
Retainer Bal BR21.1
RET-RETAIN-PCT-BAL Signed 7.4 BR02.2 BR21.1
Retain Pct Bal
RET-RETAIN-RULE Alpha 1 BR02.1
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 AC490
BR00.1 BR02.1
BR02.2 BR02.3
BR10.1 BR120
BR121 BR202
BR21.1 BR420
BR450
RETSET2 ACTIVITY KeyChange BR21.1
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
|
