|
|
ACRETNG FILE
REFERENCED BY
AC04.1 BR00.1 BR18.1 BR450
UPDATED BY
AC300 AC310 BR01.1 BR01.2 BR02.3 BR120
BR121 BR122 BR140 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR420 BR521 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTG-ACTIVITY Alpha 15 BR01.2
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.
RTG-SUM-ACCT-CAT Alpha 5 BR01.2
Element: Sum Acct Cat The name of the summary account
category.
RTG-ACCT-CATEGORY Alpha 5 BR01.2
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.
Valid account category types are:
cost
revenue
accrual
pass thru
RTG-PST-ACCT-CAT Alpha 5 BR01.2
Element: Pst Acct Cat
RTG-PST-GL-CODE Alpha 4 BR01.2
Element: Pst Gl Code
RTG-PERCENT Signed 7.3 BR01.2
Element: Percent The percentage determines how much
retention is held. It can either be a
percentage of each invoice, or it can be
a percentage of a total.
RTG-BAL-RET-AMT Signed 18.2 AC300 BR140
Element: Intl Amt This field stores the amount of BRIP.1
retention that has been held ot date.
The value stored in this field will be
in contract currency.
RTG-BAL-BILL-AMT Signed 18.2 AC300 BR02.3
Element: Intl Amt This field stores the amount of BR120 BR121
retention that has been billed to date. BR122 BR140
The value is stored in contract BR20.1 BR20.2
currency. BR20.3 BR20.4
BR20.5 BR420
BR521
RTG-BAL-REL-AMT Signed 18.2 AC300 BR01.1
Element: Intl Amt The amount of retention that has been BR02.3 BR120
released for billing. The value stored BR121 BR122
in this feild will be in contract BR140 BR20.1
currency. When a value is entered to BR20.2 BR20.3
release retention it should be entered BR20.4 BR20.5
in contract currency. BR420 BR521
RTG-CEILING Signed 18.2 AC300 BR01.2
Element: Intl Amt
RTG-SEQ-NBR Numeric 4 BR122 BRIP.1
Element: Sequence NumbeAn automatically assigned sequence
number.
RTG-UNBILL-RET-BAL Signed 18.2 AC300 BR120
Element: Intl Amt BR121 BR122
BR140 BR420
BR521 BRIP.1
RTG-CTR-CAT-GRP Alpha 5 BR01.2
Element: Ctr Cat Grp
ACRETNG FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTGSET1 ACTIVITY AC04.1 AC300
SUM-ACCT-CAT AC310 BR00.1
CTR-CAT-GRP BR01.1 BR01.2
ACCT-CATEGORY BR02.3 BR120
BR121 BR122
BR140 BR18.1
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR450 BR521
BRIP.1
ACRETNG FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
RTG-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acactivity ACACTIVITY Required
RTG-ACTIVITY -> ACV-ACTIVITY
Acglcode ACGLCODE Not Required
RTG-PST-GL-CODE -> AGC-AC-GL-CODE
ACRETNG FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acretngx ACRETNGX
RTG-ACTIVITY -> RGX-ACTIVITY
RTG-SUM-ACCT-CAT -> RGX-SUM-ACCT-CAT
RTG-CTR-CAT-GRP -> RGX-CTR-CAT-GRP
RTG-ACCT-CATEGORY -> RGX-ACCT-CATEGORY
RGX-SEQ-NBR
|
