ACRETNG FILE
REFERENCED BY
AC04.1 BR00.1 BR121 BR420 BR450
UPDATED BY
AC300 AC310 BR01.1 BR01.2 BR01.3 BR120
BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTG-ACTIVITY Alpha 15 BR01.2 BR01.3
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-ACCT-CAT-CLASS Alpha 5 BR01.2 BR01.3
Acct Cat Class
RTG-ACCT-CATEGORY Alpha 5 BR01.2 BR01.3
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.
RTG-RETAINAGE-TYPE Alpha 1 BR01.2 BR01.3
Retainage Type 1 = by Invoice
2 = by Total
RTG-PST-ACCT-CAT Alpha 5 BR01.2 BR01.3
Pst Acct Cat
RTG-PST-GL-CODE Alpha 4 BR01.2 BR01.3
Pst Gl Code
RTG-PERCENT Signed 7.3 BR01.2 BR01.3
Percent
RTG-BAL-RET-AMT Signed 15.2 AC300 BRIP.1
Bal Ret Amt
RTG-BAL-BILL-AMT Signed 15.2 AC300 BR120
Bal Bill Amt BRIP.1
RTG-BAL-REL-AMT Signed 15.2 AC300 BR01.1
Bal Rel Amt BR120
RTG-CEILING Signed 15.2 BR01.2 BR01.3
Ceiling
RTG-SEQ-NBR Numeric 4 BRIP.1
Sequence Number An automatically assigned sequence
number.
RTG-UNBILL-CEILING Signed 15.2 BR01.3
Unbill Ceiling
RTG-UNBILL-RET-BAL Signed 15.2 BR120 BRIP.1
Unbill Ret Bal
ACRETNG FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTGSET1 ACTIVITY AC04.1 AC300
ACCT-CAT-CLASS AC310 BR00.1
ACCT-CATEGORY BR01.1 BR01.2
BR01.3 BR120
BR121 BR420
BR450 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
Acacctclss ACACCTCLSS Required
RTG-ACCT-CAT-CLASS -> AXA-ACCT-CAT-CLASS
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-ACCT-CAT-CLASS -> RGX-ACCT-CAT-CLASS
RTG-ACCT-CATEGORY -> RGX-ACCT-CATEGORY
RGX-SEQ-NBR
|
