|
|
ACDEFREV FILE
REFERENCED BY
BR51.1 BR51.2 BR253
UPDATED BY
BR153 BR53.1 BR53.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DRD-CONTRACT Alpha 15 BR53.1 BR53.2
Element: Contract Activity Management contract.
DRD-OBJ-ID Numeric 12 BR53.1 BR53.2
Element: Obj Id 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.
DRD-PRODUCT Alpha 15 BR53.1 BR53.2
Element: Product
DRD-PROD-VERSION Alpha 10 BR53.1 BR53.2
Element: Prod Version
DRD-SEQ-NBR Numeric 6 BR53.1 BR53.2
Element: Sequence The Sequence field show the sequence of
a member as it is entered in either the
Budget Member Names or Fiscal Year
Variances subforms in AC87.1 (Financial
OLAP Dimensions).
DRD-DATE Numeric 8 (yyyymmdd) BR53.1 BR53.2
Element: Date This field displays the system date
when this was created.
DRD-AMOUNT Signed 18.2 BR53.1 BR53.2
Element: Intl Amt
DRD-PERCENT Signed 7.3
Element: Percent 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.
DRD-STATUS Numeric 1 BR153 BR53.1
Element: Status This field displays the status of the BR53.2
transaction.
1 = To Process
2 = Processed
3 = Anticipated Hold
4 = Tentative Hold
DRD-ATN-OBJ-ID Numeric 12 BR153
Element: Obj Id 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.
DRD-GLT-OBJ-ID Numeric 12 BR153
Element: Obj Id 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.
ACDEFREV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DRDSET1 CONTRACT BR51.1 BR53.1
OBJ-ID BR53.2
SEQ-NBR
DRDSET2 CONTRACT KeyChange BR153 BR253
PRODUCT BR51.1 BR51.2
PROD-VERSION BR53.1 BR53.2
OBJ-ID
SEQ-NBR
DRDSET3 GLT-OBJ-ID KeyChange
ATN-OBJ-ID
CONTRACT
PRODUCT
PROD-VERSION
OBJ-ID
SEQ-NBR
ACDEFREV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Required
DRD-CONTRACT -> CNT-CONTRACT (CNTSET1)
Acproddtl ACPRODDTL Required
DRD-CONTRACT -> AHD-CONTRACT
DRD-PRODUCT -> AHD-PRODUCT
DRD-PROD-VERSION -> AHD-PROD-VERSION
DRD-OBJ-ID -> AHD-OBJ-ID
Acprodhdr ACPRODHDR Required
DRD-CONTRACT -> AHR-CONTRACT
Acprodlstx ACPRODLSTX Required
AHR-PRODUCT-LIST -> BRQ-PRODUCT-LIST
DRD-PRODUCT -> BRQ-PRODUCT
DRD-PROD-VERSION -> BRQ-PROD-VERSION
Actrans ACTRANS Not Required
DRD-ATN-OBJ-ID -> ATN-OBJ-ID
Gltrans GLTRANS Not Required
DRD-GLT-OBJ-ID -> GLT-OBJ-ID
|
