|
|
ACRETNG FILE
REFERENCED BY
AC04.1 BR00.1 BR10.1 BR121 BR15.1 BR420
BR450 BR901
UPDATED BY
AC300 AC310 BR01.1 BR01.2 BR01.3 BR120
BR122 BR521 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTG-ACTIVITY Alpha 15 BR01.2 BR01.3
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-ACCT-CAT-CLASS Alpha 5 BR01.2 BR01.3
Element: Acct Cat Class
RTG-ACCT-CATEGORY Alpha 5 BR01.2 BR01.3
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.
RTG-RETAINAGE-TYPE Alpha 1 BR01.2 BR01.3
Element: Retainage Type1 = by Invoice
2 = by Total
RTG-PST-ACCT-CAT Alpha 5 BR01.2 BR01.3
Element: Pst Acct Cat
RTG-PST-GL-CODE Alpha 4 BR01.2 BR01.3
Element: Pst Gl Code
RTG-PERCENT Signed 7.3 BR01.2 BR01.3
Element: Percent
RTG-BAL-RET-AMT Signed 15.2 AC300 BR521
Element: Bal Ret Amt BRIP.1
RTG-BAL-BILL-AMT Signed 15.2 AC300 BR120
Element: Bal Bill Amt BR122 BR521
BRIP.1
RTG-BAL-REL-AMT Signed 15.2 AC300 BR01.1
Element: Bal Rel Amt BR120
RTG-CEILING Signed 15.2 BR01.2 BR01.3
Element: Ceiling
RTG-SEQ-NBR Numeric 4 BR122 BR521
Element: Sequence NumbeAn automatically assigned sequence BRIP.1
number.
RTG-UNBILL-CEILING Signed 15.2 BR01.3
Element: Unbill Ceiling
RTG-UNBILL-RET-BAL Signed 15.2 BR120 BR122
Element: Unbill Ret Bal BR521 BRIP.1
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 BR10.1
BR120 BR121
BR122 BR15.1
BR420 BR450
BR521 BR901
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
|
