|
|
ACPRODACCT FILE
The ACPRODACCT file contains the default accounts for each product in a
prodcut list (ACPRODLSTX). The accounts are stored for Product, Free
Maintenance, and Billed Maintenance types of billing and revenue. Records in
this file are primarily maintained on Product List Accounts (BR50.2). The
ACPRODACCT file is related to the ACGLCODE file, and the ACPRODLST file.
REFERENCED BY
BR155 BR250 BR51.1 BR51.2 BR52.1 BR52.4
BR52.5
UPDATED BY
BR50.2 BR50.1 BR50.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BRR-PRODUCT-LIST Alpha 10 BR50.2
Element: Product List
BRR-PRODUCT Alpha 15 BR50.2
Element: Product
BRR-RECORD-TYPE Alpha 1 BR50.2
Element: Record Type This field identifies the type of
record defined.
Valid values are:
S = Summary
D = Detail
1 = Product
2 = Free Maintenance
3 = Billed Maintenance
4 = All
BRR-BILL-ACCT-CAT Alpha 5 BR50.2
Element: Account Category
BRR-BILL-GL-CD Alpha 4 BR50.2
Element: Ac Gl Code
BRR-BILL-ACCOUNT Numeric 6 BR50.2
Element: Account
BRR-BILL-SUB-ACCT Numeric 4 BR50.2
Element: Subaccount
BRR-UNBL-ACCT-CAT Alpha 5 BR50.2
Element: Account Category
BRR-UNBL-GL-CD Alpha 4 BR50.2
Element: Ac Gl Code
BRR-UNBL-ACCOUNT Numeric 6 BR50.2
Element: Account
BRR-UNBL-SUB-ACCT Numeric 4 BR50.2
Element: Subaccount
BRR-REV-ACCT-CAT Alpha 5 BR50.2
Element: Account Category
BRR-REV-GL-CD Alpha 4 BR50.2
Element: Ac Gl Code
BRR-REV-ACCOUNT Numeric 6 BR50.2
Element: Account
BRR-REV-SUB-ACCT Numeric 4 BR50.2
Element: Subaccount
BRR-CGSL-ACCT-CAT Alpha 5 BR50.2
Element: Account Category
BRR-CGSL-GL-CD Alpha 4 BR50.2
Element: Ac Gl Code
BRR-CGSL-ACCOUNT Numeric 6 BR50.2
Element: Account
BRR-CGSL-SUB-ACCT Numeric 4 BR50.2
Element: Subaccount
BRR-CGSX-ACCT-CAT Alpha 5 BR50.2
Element: Account Category
BRR-CGSX-GL-CD Alpha 4 BR50.2
Element: Ac Gl Code
BRR-CGSX-ACCOUNT Numeric 6 BR50.2
Element: Account
BRR-CGSX-SUB-ACCT Numeric 4 BR50.2
Element: Subaccount
ACPRODACCT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BRRSET1 PRODUCT-LIST BR155 BR250
PRODUCT BR50.1 BR50.2
RECORD-TYPE BR50.3 BR51.1
BR51.2 BR52.1
BR52.4 BR52.5
ACPRODACCT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acglcode Bill ACGLCODE Not Required
BRR-BILL-GL-CD -> AGC-AC-GL-CODE
Acglcode Cgsl ACGLCODE Not Required
BRR-CGSL-GL-CD -> AGC-AC-GL-CODE
Acglcode Cgsx ACGLCODE Not Required
BRR-CGSX-GL-CD -> AGC-AC-GL-CODE
Acglcode Rev ACGLCODE Not Required
BRR-REV-GL-CD -> AGC-AC-GL-CODE
Acglcode Unbl ACGLCODE Not Required
BRR-UNBL-GL-CD -> AGC-AC-GL-CODE
Acprodlst ACPRODLST Required
BRR-PRODUCT-LIST -> BRP-PRODUCT-LIST
|
