ACDEFREV FILE
The ACDEFREV file stores information about deferred revenue schedules for a
product contract. This field is primarily updated by Product Deferred Revenue
Schedule (BR53.1). The ACDEFREV file has relationships with the ACPRODDTL and
ACTRANS files.
REFERENCED BY
BR51.1 BR51.2 BR253
UPDATED BY
BR153 BR53.1 BR53.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DRD-CONTRACT Alpha 10 BR53.1 BR53.2
Element: Contract
DRD-OBJ-ID Numeric 12 BR53.1 BR53.2
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.
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 An automatically assigned sequence
number.
DRD-DATE Numeric 8 (yyyymmdd) BR53.1 BR53.2
Element: Date This field displays the system date
when this was created.
DRD-AMOUNT Signed 15.2 BR53.1 BR53.2
Element: Adj Amt This is the amounts by period for the
specified record.
DRD-PERCENT Signed 7.3
Element: Percent
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
Object
Identification
DRD-GLT-OBJ-ID Numeric 12 BR153
Object
Identification
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
|
