ACPRODUSER FILE
Product List Price/Cost
The ACPRODUSER file stores data for the various product prices available based
on the quantity of users purchased. This file is primarily updated by the
Product Price Detail (BR50.5) and Product Cost Detail (BR50.4) forms. The
ACPRODUSER file has relations with the ACPRODLST and ACPRODLSTX files.
REFERENCED BY
BR250 BR51.1 BR51.2 BR52.1 BR52.4 BR52.5
UPDATED BY
BR50.4 BR50.5 BR50.1 BR50.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BRU-RECORD-TYPE Alpha 1 BR50.4 BR50.5
Element: Record Type This field identifies the type of
record defined.
Valid values are:
S = Summary
D = Detail
1 = Price
2 = Cost
3 = Suite
BRU-PRODUCT-LIST Alpha 10 BR50.4 BR50.5
Element: Product List
BRU-PRODUCT Alpha 15 BR50.4 BR50.5
Element: Product
BRU-PROD-VERSION Alpha 10 BR50.4 BR50.5
Element: Prod Version
BRU-MAX-USERS Numeric 12 BR50.4 BR50.5
Element: Users
BRU-EFFECTIVE-DT Numeric 8 (yyyymmdd) BR50.4 BR50.5
Element: Effective Date
BRU-COST-PERCENT Signed 7.3 BR50.4
Element: Percent
BRU-BASE-PRICE Signed 15.2 BR50.4 BR50.5
Element: Adj Amt
BRU-BASE-INC-AMT Signed 15.2 BR50.4 BR50.5
Element: Adj Amt
BRU-BASE-INC-USER Numeric 12 BR50.4 BR50.5
Element: Users
BRU-USER-PRICE Signed 15.2 BR50.4 BR50.5
Element: Adj Amt
BRU-MIN-USERS Numeric 12 BR50.4 BR50.5
Element: Users
ACPRODUSER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BRUSET1 RECORD-TYPE BR250 BR50.1
PRODUCT-LIST BR50.4 BR50.5
PRODUCT BR51.1 BR51.2
PROD-VERSION BR52.1 BR52.4
EFFECTIVE-DT* BR52.5
MAX-USERS
BRUSET2 PRODUCT-LIST BR50.1 BR50.3
PRODUCT
PROD-VERSION
EFFECTIVE-DT*
RECORD-TYPE
MAX-USERS*
ACPRODUSER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acprodlst ACPRODLST Required
BRU-PRODUCT-LIST -> BRP-PRODUCT-LIST
Acprodlstx ACPRODLSTX Required
BRU-PRODUCT-LIST -> BRQ-PRODUCT-LIST
BRU-PRODUCT -> BRQ-PRODUCT
BRU-PROD-VERSION -> BRQ-PROD-VERSION
|
