ACRETNGX FILE
REFERENCED BY
BR450
UPDATED BY
AC300 AC310 BR01.1 BR01.2 BR01.3 BR120
BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RGX-ACTIVITY Alpha 15 BR01.1 BRIP.1
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.
RGX-ACCT-CAT-CLASS Alpha 5 BR01.1 BRIP.1
Acct Cat Class
RGX-ACCT-CATEGORY Alpha 5 BR01.1 BRIP.1
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.
RGX-SEQ-NBR Numeric 4 BR01.1 BRIP.1
Sequence Number An automatically assigned sequence
number.
RGX-STATUS Numeric 1 BR01.1 BR120
Status This field displays the status of the BRIP.1
transaction.
RGX-DESCRIPTION Alpha 30 (Lower Case) BR01.1 BRIP.1
Description This field displays the description.
RGX-DATE Numeric 8 (yyyymmdd) BRIP.1
Date This field displays the system date
when this was created.
RGX-PST-ACTIVITY Alpha 15 BR01.1 BRIP.1
Pst Activity
RGX-PST-ACCT-CAT Alpha 5 BR01.1 BRIP.1
Pst Acct Cat
RGX-PST-GL-CODE Alpha 4 BRIP.1
Pst Gl Code
RGX-RETAINAGE-AMT Signed 15.2 BR01.1 BRIP.1
Retainage Amt
RGX-RELEASED-AMT Signed 15.2 BR01.1 BR120
Released Amt
RGX-BILL-AMT Signed 15.2 BR01.1 BR120
Bill Amt BRIP.1
RGX-INVOICE-PREFIX Alpha 2 BR01.1 BRIP.1
Invoice Prefix
RGX-INVOICE-NBR Numeric 8 BR01.1 BRIP.1
Invoice Nbr
RGX-OBJ-ID Numeric 12 BRIP.1
Object This is the object identifier. It is
Identification 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.
ACRETNGX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RGXSET1 ACTIVITY AC300 AC310
ACCT-CAT-CLASS BR01.1 BR01.2
ACCT-CATEGORY BR01.3 BR120
SEQ-NBR BR450
ACRETNGX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
RGX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acacctclss ACACCTCLSS Required
RGX-ACCT-CAT-CLASS -> AXA-ACCT-CAT-CLASS
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
|
