ACRETNGX

Activity Bill Retention Detail

REFERENCED BY
BR450


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
RGX-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.1 BR122
BRIP.1
RGX-SUM-ACCT-CAT
Element: Sum Acct Cat		Alpha 5
The name of the summary account category.
BR01.1 BR122
BRIP.1
RGX-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.1 BR122
BRIP.1
RGX-SEQ-NBR
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
BR01.1 BR122
BRIP.1
RGX-STATUS
Element: Status		Numeric 1
This field displays the status of the transaction.
BR01.1 BR02.3
BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521 BRIP.1
RGX-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
BR01.1 BR122
BRIP.1
RGX-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
BR122 BRIP.1
RGX-PST-ACTIVITY
Element: Pst Activity		Alpha 15
BR01.1 BR122
BRIP.1
RGX-PST-ACCT-CAT
Element: Pst Acct Cat		Alpha 5
BR01.1 BR122
BRIP.1
RGX-PST-GL-CODE
Element: Pst Gl Code		Alpha 4
BR122 BRIP.1
RGX-RETAINAGE-AMT
Element: Intl Amt		Signed 18.2
BR01.1 BR122
BRIP.1
RGX-RELEASED-AMT
Element: Intl Amt		Signed 18.2
BR01.1 BR02.3
BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521
RGX-BILL-AMT
Element: Intl Amt		Signed 18.2
BR01.1 BR02.3
BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521
RGX-INVOICE-PREFIX
Element: Invoice Prefix		Alpha 2
BR01.1 BR122
BRIP.1
RGX-INVOICE-NBR
Element: Invoice Nbr		Numeric 8
BR01.1 BR122
BRIP.1
RGX-OBJ-ID
Element: Obj Id		Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
BR122 BRIP.1
RGX-CTR-CAT-GRP
Element: Ctr Cat Grp		Alpha 5
BR01.1 BR122
BRIP.1


ACRETNGX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RGXSET1 ACTIVITY
SUM-ACCT-CAT
CTR-CAT-GRP
ACCT-CATEGORY
SEQ-NBR
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
BR450 BR521
BRIP.1


ACRETNGX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
RGX-ACCT-CATEGORY->AAX-ACCT-CATEGORY
Acactivity ACACTIVITY Required
RGX-ACTIVITY->ACV-ACTIVITY
Pst Acct Cat ACACCTCAT Required
RGX-PST-ACCT-CAT->AAX-ACCT-CATEGORY
Pst Activity ACACTIVITY Required
RGX-PST-ACTIVITY->ACV-ACTIVITY
Pst Gl Code ACGLCODE Required
RGX-PST-GL-CODE->AGC-AC-GL-CODE

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

Home
Contact Us



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