ACDEFREV

Activity Deferred Revenue

REFERENCED BY
BR253


UPDATED BY
BR153 BR53.1 BR53.2 BR51.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DRD-CONTRACT
Element: Contract
Alpha 15
Activity Management contract.
BR53.1 BR53.2
DRD-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.
BR53.1 BR53.2
DRD-PRODUCT
Element: Product
Alpha 15
BR53.1 BR53.2
DRD-PROD-VERSION
Element: Prod Version
Alpha 10
BR53.1 BR53.2
DRD-SEQ-NBR
Element: Sequence
Numeric 6
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).
BR53.1 BR53.2
DRD-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
BR53.1 BR53.2
DRD-AMOUNT
Element: Intl Amt
Signed 18.2
BR53.1 BR53.2
DRD-PERCENT
Element: Percent
Signed 7.3
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
Element: Status
Numeric 1
This field displays the status of the transaction.
1 = To Process
2 = Processed
3 = Anticipated Hold
4 = Tentative Hold
BR153 BR53.1
BR53.2
DRD-ATN-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.
BR153
DRD-GLT-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.
BR153


ACDEFREV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DRDSET1 CONTRACT
OBJ-ID
SEQ-NBR
BR51.1 BR53.1
BR53.2
DRDSET2 CONTRACT
PRODUCT
PROD-VERSION
OBJ-ID
SEQ-NBR
KeyChange
BR153 BR253
BR51.1 BR51.2
BR53.1 BR53.2
DRDSET3 GLT-OBJ-ID
ATN-OBJ-ID
CONTRACT
PRODUCT
PROD-VERSION
OBJ-ID
SEQ-NBR
KeyChange


ACDEFREV FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


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

Home
Contact Us



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