|
|
ACPRODDTL FILE
The ACPRODDTL file contains detail information about a product included on a
product contract. This file is primarily updated by Product Contract (BR51).
The ACPRODDTL file has relationships with the following files: ACPRODHDR,
ACPRODLSTX, ACREASONCD, ACCNTRACT, ACGLCODE, ACCNTRCMTX, ACDEFREV, and
ACPRODUSER.
REFERENCED BY
BR15.1 BR151 BR31.2 BR52.4 BR54.2 BR54.3
BR54.4 BRPI.1 BR251 BR253
UPDATED BY
BR153 BR51.1 BR51.2 BR53.1 BR53.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AHD-CONTRACT Alpha 10 BR51.1
Element: Contract
AHD-OBJ-ID Numeric 12 BR51.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.
AHD-PRODUCT Alpha 15 BR51.1
Element: Product
AHD-PROD-VERSION Alpha 10 BR51.1
Element: Prod Version
AHD-EFFECTIVE-DT Numeric 8 (yyyymmdd) BR51.1
Element: Effective Date
AHD-USERS Numeric 12 BR51.1
Element: Users
AHD-LIST-PRICE Signed 15.2 BR51.1
Element: Adj Amt
AHD-DISCOUNT-AMT Signed 15.2 BR51.1
Element: Adj Amt
AHD-NET-PRICE Signed 15.2 BR51.1
Element: Adj Amt
AHD-FREE-MAINT Signed 15.2 BR51.1
Element: Adj Amt
AHD-SHIP-DATE Numeric 8 (yyyymmdd) BR51.1
Element: Ship Date This field contains the ship date. If
left blank, the system date defaults.
AHD-ANT-SHIP-DATE Numeric 8 (yyyymmdd) BR51.1
Element: Ship Date
AHD-DEFERRED-FL Alpha 1 BR153 BR51.1
Element: Deferred Fl Y = Yes
N = No
X = Not Shipped
AHD-DEFERRED-AMT Signed 15.2 BR153 BR51.1
Element: Adj Amt BR53.1 BR53.2
AHD-REASON-CODE Alpha 4 BR51.1
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
AHD-TOT-REV-AMT Signed 15.2 BR153
Element: Adj Amt
AHD-DISCOUNT-PCT Signed 8.5 BR51.1
Element: Discount Pct
AHD-MAINT-PERCENT Signed 7.3 BR51.1
Element: Percent
AHD-LIST-NET-FLAG Alpha 1 BR51.1
Element: List Net Flag 1 = List
2 = Net
AHD-MAINT-PERIOD Numeric 2
Element: Last Closed Period
AHD-INCLUDE-BASE Alpha 1 BR51.1
Element: Include Base Y = Yes
N = No
AHD-REV-ACCT-CAT Alpha 5 BR51.1
Element: Account Category
AHD-REV-GL-CD Alpha 4 BR51.1
Element: Ac Gl Code
AHD-REV-ACCOUNT Numeric 6 BR51.1
Element: Account
AHD-REV-SUB-ACCT Numeric 4 BR51.1
Element: Subaccount
AHD-COST-BASIS-FL Alpha 1
Element: List Net Flag 1 = List
2 = Net
AHD-TOTAL-COST Signed 15.2 BR51.1 BR51.2
Element: Adj Amt
AHD-PREV-EXP-AMT Signed 15.2 BR153
Element: Adj Amt
AHD-CGSL-ACCT-CAT Alpha 5 BR51.1 BR51.2
Element: Account Category
AHD-CGSL-GL-CD Alpha 4 BR51.1 BR51.2
Element: Ac Gl Code
AHD-CGSL-ACCOUNT Numeric 6 BR51.1 BR51.2
Element: Account
AHD-CGSL-SUB-ACCT Numeric 4 BR51.1 BR51.2
Element: Subaccount
AHD-CGSX-ACCT-CAT Alpha 5 BR51.1 BR51.2
Element: Account Category
AHD-CGSX-GL-CD Alpha 4 BR51.1 BR51.2
Element: Ac Gl Code
AHD-CGSX-ACCOUNT Numeric 6 BR51.1 BR51.2
Element: Account
AHD-CGSX-SUB-ACCT Numeric 4 BR51.1 BR51.2
Element: Subaccount
AHD-LAST-SEQ-NBR Numeric 6
Element: Last Seq Nbr
AHD-TAX-EXEMPT-CD Alpha 1
Element: Tax Exempt CodE = Exempt
T = Taxable
AHD-OPERATOR Alpha 10 BR51.1 BR51.2
Element: Operator Code This field is used to store the login
id of the person who entered the record.
AHD-DATE-STAMP Numeric 8 (yyyymmdd) BR51.1 BR51.2
Element: Date This field contains the server date
(month, date, and year) of the last
change to this record.
AHD-TIME-STAMP Numeric 6 (hhmmss) BR51.1 BR51.2
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
AHD-REVENUE-FLAG Alpha 1 BR153 BR51.1
Element: Revenue Flag Y = Yes BR51.2
N = No
AHD-USER-FIELD1 Alpha 15 (Lower Case) BR51.1 BR51.2
Element: User Defined FThis is the first user definable field.
It can be used to capture any data that
the user wants. The title of the field
is setup in IC00.
AHD-USER-FIELD2 Alpha 15 (Lower Case) BR51.1 BR51.2
Element: User Defined FThis is the second user definable
field. This field can be used to enter
any data that the user wants to capture
for this item. The title of the field
is setup in IC00.
AHD-USER-FIELD3 Alpha 15 (Lower Case) BR51.1 BR51.2
Element: User Defined Field 3
AHD-SITE-LOCATION Numeric 2 BR51.1 BR51.2
Element: Site Location
AHD-INV-NET-PRICE Signed 15.2 BR51.1
Element: Adj Amt
AHD-SUITE Alpha 6 BR51.1
Element: Prod Suite
AHD-ACTUAL-PRICE Signed 15.2 BR51.1
Element: Adj Amt
AHD-NET-PROD-REV Derived
Element: Net Prod Rev
AHD-END-DATE Numeric 8 (yyyymmdd) BR51.1
Element: Date The ending date in a range of dates.
AHD-TOT-DEF-AMT Signed 15.2 BR51.1 BR53.1
Element: Adj Amt BR53.2
AHD-DELIV-METHOD Alpha 1 BR51.1
Element: Deliv Method S = Shipped
H = Hosted at
E = Electronic
L = Loaded
1 = Method 1
2 = Method 2
3 = Method 3
ACPRODDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AHDSET1 CONTRACT BR15.1 BR151
OBJ-ID BR153 BR31.2
BR51.1 BR51.2
BR52.4 BR53.1
BR53.2 BR54.2
BR54.3 BR54.4
BRPI.1
AHDSET2 CONTRACT KeyChange BR153 BR251
PRODUCT BR253 BR31.2
PROD-VERSION BR51.1 BR51.2
OBJ-ID BR53.1 BR53.2
ACPRODDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Required
AHD-CONTRACT -> CNT-CONTRACT
Acglcode Cgsl ACGLCODE Not Required
AHD-CGSL-GL-CD -> AGC-AC-GL-CODE
Acglcode Cgsx ACGLCODE Not Required
AHD-CGSX-GL-CD -> AGC-AC-GL-CODE
Acglcode Rev ACGLCODE Not Required
AHD-REV-GL-CD -> AGC-AC-GL-CODE
Acprodhdr ACPRODHDR Required
AHD-CONTRACT -> AHR-CONTRACT
Acprodlstx ACPRODLSTX Required
AHR-PRODUCT-LIST -> BRQ-PRODUCT-LIST
AHD-PRODUCT -> BRQ-PRODUCT
AHD-PROD-VERSION -> BRQ-PROD-VERSION
Acreasoncd ACREASONCD Not Required
AHD-REASON-CODE -> CDE-REASON-CODE
ACPRODDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntrcmtx ACCNTRCMTX
AHD-CONTRACT -> CXM-CONTRACT
Spaces -> CXM-MAINT-SCHEDULE
AHD-PRODUCT -> CXM-PRODUCT
AHD-PROD-VERSION -> CXM-PROD-VERSION
AHD-OBJ-ID -> CXM-OBJ-ID
CXM-COMMENT-TYPE
CXM-DATE
CXM-SEQ-NBR
Acdefrev ACDEFREV
AHD-CONTRACT -> DRD-CONTRACT
AHD-PRODUCT -> DRD-PRODUCT
AHD-PROD-VERSION -> DRD-PROD-VERSION
AHD-OBJ-ID -> DRD-OBJ-ID
DRD-SEQ-NBR
Acprodtax ACPRODTAX
AHD-REV-ACCT-CAT -> BTX-TAX-ACCT-CAT
AHD-DELIV-METHOD -> BTX-DELIV-METHOD
BTX-EFFECTIVE-DATE
Acproduser ACPRODUSER
AHR-PRODUCT-LIST -> BRU-PRODUCT-LIST
AHD-PRODUCT -> BRU-PRODUCT
AHD-PROD-VERSION -> BRU-PROD-VERSION
AHD-EFFECTIVE-DT -> BRU-EFFECTIVE-DT
BRU-RECORD-TYPE
BRU-MAX-USERS
|
