ACRETNG

Activity Bill Retention

REFERENCED BY
AC04.1 BR00.1 BR18.1


UPDATED BY
AC300 BR01.1 BR01.2 BR02.3 BR120 BR121
BR122 BR123 BR140 BR151 BR152 BR156
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR420
BR521 BRIP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTG-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
BR01.2
RTG-SUM-ACCT-CAT
Element: Sum Acct Cat
Alpha 5
The name of the summary account category.
BR01.2
RTG-ACCT-CATEGORY
Element: Acct Category
Alpha 5
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. Valid account category types are: cost revenue accrual pass thru
BR01.2
RTG-PST-ACCT-CAT
Element: Pst Acct Cat
Alpha 5
BR01.2
RTG-PST-GL-CODE
Element: Pst Gl Code
Alpha 4
BR01.2
RTG-PERCENT
Element: Percent
Signed 7.3
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.
BR01.2
RTG-BAL-RET-AMT
Element: Intl Amt
Signed 18.2
AC300 BR140
BRIP.1
RTG-BAL-BILL-AMT
Element: Intl Amt
Signed 18.2
AC300 BR02.3
BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521
RTG-BAL-REL-AMT
Element: Intl Amt
Signed 18.2
AC300 BR01.1
BR02.3 BR120
BR121 BR122
BR123 BR140
BR151 BR152
BR156 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR521
RTG-CEILING
Element: Intl Amt
Signed 18.2
AC300 BR01.2
RTG-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
BR122 BRIP.1
RTG-UNBILL-RET-BAL
Element: Intl Amt
Signed 18.2
AC300 BR120
BR121 BR122
BR123 BR140
BR151 BR152
BR156 BR420
BR521 BRIP.1
RTG-CTR-CAT-GRP
Element: Ctr Cat Grp
Alpha 5
BR01.2


ACRETNG FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTGSET1 ACTIVITY
SUM-ACCT-CAT
CTR-CAT-GRP
ACCT-CATEGORY
AC04.1 AC300
BR00.1 BR01.1
BR01.2 BR02.3
BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR156
BR18.1 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR521
BRIP.1


ACRETNG FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 02:11:12 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.