ACPRODUSER

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
Element: Record Type
Alpha 1
This field identifies the type of record defined. Valid values are: S = Summary D = Detail
1 = Price
2 = Cost
3 = Suite
BR50.4 BR50.5
BRU-PRODUCT-LIST
Element: Product List
Alpha 10
BR50.4 BR50.5
BRU-PRODUCT
Element: Product
Alpha 15
BR50.4 BR50.5
BRU-PROD-VERSION
Element: Prod Version
Alpha 10
BR50.4 BR50.5
BRU-MAX-USERS
Element: Users
Numeric 12
BR50.4 BR50.5
BRU-EFFECTIVE-DT
Element: Effective Dt
Numeric 8 (yyyymmdd)
The effective date is the date the record is first valid.
BR50.4 BR50.5
BRU-COST-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.
BR50.4
BRU-BASE-PRICE
Element: Intl Amt
Signed 18.2
BR50.4 BR50.5
BRU-BASE-INC-AMT
Element: Intl Amt
Signed 18.2
BR50.4 BR50.5
BRU-BASE-INC-USER
Element: Users
Numeric 12
BR50.4 BR50.5
BRU-USER-PRICE
Element: Intl Amt
Signed 18.2
BR50.4 BR50.5
BRU-MIN-USERS
Element: Users
Numeric 12
BR50.4 BR50.5


ACPRODUSER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BRUSET1 RECORD-TYPE
PRODUCT-LIST
PRODUCT
PROD-VERSION
EFFECTIVE-DT*
MAX-USERS
BR250 BR50.1
BR50.4 BR50.5
BR51.1 BR51.2
BR52.1 BR52.4
BR52.5 BR570
BR70.1 BR70.2
BRUSET2 PRODUCT-LIST
PRODUCT
PROD-VERSION
EFFECTIVE-DT*
RECORD-TYPE
MAX-USERS*
BR50.1 BR50.3


ACPRODUSER FILE RELATIONS


ONE TO ONE RELATIONS

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


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

Home
Contact Us



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