|
|
ACPRODUSER FILE
REFERENCED BY
BR250 BR51.1 BR51.2 BR52.1 BR52.4 BR52.5
BR570 BR70.1 BR70.2
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 Dt The effective date is the date the
record is first valid.
BRU-COST-PERCENT Signed 7.3 BR50.4
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.
BRU-BASE-PRICE Signed 18.2 BR50.4 BR50.5
Element: Intl Amt
BRU-BASE-INC-AMT Signed 18.2 BR50.4 BR50.5
Element: Intl Amt
BRU-BASE-INC-USER Numeric 12 BR50.4 BR50.5
Element: Users
BRU-USER-PRICE Signed 18.2 BR50.4 BR50.5
Element: Intl 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 BR570
MAX-USERS BR70.1 BR70.2
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
|
