ACRETNGX

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
BR450 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 11:11:03 2016

Home
Contact Us



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