|
|
ACRETNGX FILE
REFERENCED BY
BR450
UPDATED BY
AC300 AC310 BR01.1 BR01.2 BR01.3 BR120
BR122 BR521 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RGX-ACTIVITY Alpha 15 BR01.1 BR122
Element: Activity Activities are the processes or BR521 BRIP.1
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 BR122
Element: Acct Cat Class BR521 BRIP.1
RGX-ACCT-CATEGORY Alpha 5 BR01.1 BR122
Element: Account CategoAccount categories are groupings of BR521 BRIP.1
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 BR122
Element: Sequence NumbeAn automatically assigned sequence BR521 BRIP.1
number.
RGX-STATUS Numeric 1 BR01.1 BR120
Element: Status This field displays the status of the BR122 BR521
transaction. BRIP.1
RGX-DESCRIPTION Alpha 30 (Lower Case) BR01.1 BR122
Element: Description This field displays the description. BR521 BRIP.1
RGX-DATE Numeric 8 (yyyymmdd) BR122 BR521
Element: Date This field displays the system date BRIP.1
when this was created.
RGX-PST-ACTIVITY Alpha 15 BR01.1 BR122
Element: Pst Activity BR521 BRIP.1
RGX-PST-ACCT-CAT Alpha 5 BR01.1 BR122
Element: Pst Acct Cat BR521 BRIP.1
RGX-PST-GL-CODE Alpha 4 BR122 BR521
Element: Pst Gl Code BRIP.1
RGX-RETAINAGE-AMT Signed 15.2 BR01.1 BR122
Element: Retainage Amt BR521 BRIP.1
RGX-RELEASED-AMT Signed 15.2 BR01.1 BR120
Element: Released Amt
RGX-BILL-AMT Signed 15.2 BR01.1 BR120
Element: Bill Amt BR122 BR521
BRIP.1
RGX-INVOICE-PREFIX Alpha 2 BR01.1 BR122
Element: Invoice Prefix BR521 BRIP.1
RGX-INVOICE-NBR Numeric 8 BR01.1 BR122
Element: Invoice Nbr BR521 BRIP.1
RGX-OBJ-ID Numeric 12 BR122 BR521
Object This is the object identifier. It is BRIP.1
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
|
