|
|
ACPRODACCT FILE
REFERENCED BY
BR155 BR250 BR51.1 BR51.2 BR52.1 BR52.4
BR52.5 BR570 BR70.1 BR70.2
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: Acct Category Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
BRR-BILL-GL-CD Alpha 4 BR50.2
Element: Ac Gl Code
BRR-BILL-ACCOUNT Numeric 6 BR50.2
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
BRR-BILL-SUB-ACCT Numeric 4 BR50.2
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
BRR-UNBL-ACCT-CAT Alpha 5 BR50.2
Element: Acct Category Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
BRR-UNBL-GL-CD Alpha 4 BR50.2
Element: Ac Gl Code
BRR-UNBL-ACCOUNT Numeric 6 BR50.2
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
BRR-UNBL-SUB-ACCT Numeric 4 BR50.2
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
BRR-REV-ACCT-CAT Alpha 5 BR50.2
Element: Acct Category Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
BRR-REV-GL-CD Alpha 4 BR50.2
Element: Ac Gl Code
BRR-REV-ACCOUNT Numeric 6 BR50.2
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
BRR-REV-SUB-ACCT Numeric 4 BR50.2
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
BRR-CGSL-ACCT-CAT Alpha 5 BR50.2
Element: Acct Category Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
BRR-CGSL-GL-CD Alpha 4 BR50.2
Element: Ac Gl Code
BRR-CGSL-ACCOUNT Numeric 6 BR50.2
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
BRR-CGSL-SUB-ACCT Numeric 4 BR50.2
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
BRR-CGSX-ACCT-CAT Alpha 5 BR50.2
Element: Acct Category Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
BRR-CGSX-GL-CD Alpha 4 BR50.2
Element: Ac Gl Code
BRR-CGSX-ACCOUNT Numeric 6 BR50.2
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
BRR-CGSX-SUB-ACCT Numeric 4 BR50.2
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
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
BR570 BR70.1
BR70.2
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
|
