ACPRODLSTX

REFERENCED BY
BR124 BR153 BR154 BR155 BR157 BR252
BR253 BR51.1 BR51.2 BR52.1 BR52.4 BR52.5
BR53.1 BR53.2 BR70.1 BR70.2 BRIP.1 BR250
BR31.2 BR31.4 BR570


UPDATED BY
BR50.1 BR50.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BRQ-PRODUCT-LIST
Element: Product List		Alpha 10
BR50.1
BRQ-PRODUCT
Element: Product		Alpha 15
BR50.1
BRQ-PROD-VERSION
Element: Prod Version		Alpha 10
BR50.1
BRQ-STATUS
Element: Status Cd		Alpha 1
Status Code.
A = Active
I = Inactive
BR50.1
BRQ-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
BR50.1
BRQ-MAINT-FLAG
Element: Maint Flag		Alpha 1

Y = Yes
N = No
BR50.1
BRQ-COST-BASIS
Element: List Net Flag		Alpha 1

1 = List
2 = Net
BR50.1
BRQ-MAINT-BASIS
Element: List Net Flag		Alpha 1

1 = List
2 = Net
BR50.1
BRQ-DECOM-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
BR50.1


ACPRODLSTX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BRQSET1 PRODUCT-LIST
PRODUCT
PROD-VERSION
BR124 BR153
BR154 BR155
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
BR570 BR70.1
BR70.2 BRIP.1


ACPRODLSTX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Acprodlst ACPRODLST Required
BRQ-PRODUCT-LIST->BRP-PRODUCT-LIST


ACPRODLSTX FILE RELATIONS


ONE TO MANY RELATIONS

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

File created: Thu Jun 09 11:11:01 2016

Home
Contact Us



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