|
|
ACPRODLSTX FILE
The ACPRODLSTX file contains the master list of products that an organization
sells and supports. The products created in this file are assigned to a
Product Contract record and ultimately appear on the invoice the customer
receives. Information related to the products in this file includes base
price, price per user, and default billing and revenue accounts. Records are
primarily maintained on Product List (BR50.1). The ACPRODLSTX file is related
to the ACPRODLST file, the ACPRODACCT file, and the ACPRODUSER file.
REFERENCED BY
BR124 BR153 BR154 BR155 BR157 BR250
BR252 BR253 BR31.2 BR31.4 BR51.1 BR51.2
BR52.1 BR52.4 BR52.5 BR53.1 BR53.2 BRPI.1
UPDATED BY
BR50.1 BR50.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BRQ-PRODUCT-LIST Alpha 10 BR50.1
Element: Product List
BRQ-PRODUCT Alpha 15 BR50.1
Element: Product
BRQ-PROD-VERSION Alpha 10 BR50.1
Element: Prod Version
BRQ-STATUS Alpha 1 BR50.1
Element: Status Cd This field displays the status of the
transaction.
A = Active
I = Inactive
BRQ-DESCRIPTION Alpha 30 (Lower Case) BR50.1
Element: Description This field displays the description.
BRQ-MAINT-FLAG Alpha 1 BR50.1
Element: Maint Flag Y = Yes
N = No
BRQ-COST-BASIS Alpha 1 BR50.1
Element: List Net Flag 1 = List
2 = Net
BRQ-MAINT-BASIS Alpha 1 BR50.1
Element: List Net Flag 1 = List
2 = Net
BRQ-DECOM-DATE Numeric 8 (yyyymmdd) BR50.1
Element: Date
ACPRODLSTX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BRQSET1 PRODUCT-LIST BR124 BR153
PRODUCT BR154 BR155
PROD-VERSION BR157 BR250
BR252 BR253
BR31.2 BR31.4
BR50.1 BR50.2
BR50.3 BR50.4
BR50.5 BR51.1
BR51.2 BR52.1
BR52.4 BR52.5
BR53.1 BR53.2
BRPI.1
ACPRODLSTX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acprodlst ACPRODLST Required
BRQ-PRODUCT-LIST -> BRP-PRODUCT-LIST
ACPRODLSTX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acprodacct ACPRODACCT
BRQ-PRODUCT-LIST -> BRR-PRODUCT-LIST
BRQ-PRODUCT -> BRR-PRODUCT
BRR-RECORD-TYPE
Acproduser ACPRODUSER
BRQ-PRODUCT-LIST -> BRU-PRODUCT-LIST
BRQ-PRODUCT -> BRU-PRODUCT
BRQ-PROD-VERSION -> BRU-PROD-VERSION
BRU-EFFECTIVE-DT
BRU-RECORD-TYPE
BRU-MAX-USERS
Acproduser Cst ACPRODUSER
"2" -> BRU-RECORD-TYPE
BRQ-PRODUCT-LIST -> BRU-PRODUCT-LIST
BRQ-PRODUCT -> BRU-PRODUCT
BRQ-PROD-VERSION -> BRU-PROD-VERSION
BRU-EFFECTIVE-DT
BRU-MAX-USERS
Acproduser Prc ACPRODUSER
"1" -> BRU-RECORD-TYPE
BRQ-PRODUCT-LIST -> BRU-PRODUCT-LIST
BRQ-PRODUCT -> BRU-PRODUCT
BRQ-PROD-VERSION -> BRU-PROD-VERSION
BRU-EFFECTIVE-DT
BRU-MAX-USERS
|
