ACPRODACCT – Activity Product Account

System
AC Billing Revenue (BR)
Prefix
BRR
Primary key
PRODUCT-LIST, PRODUCT, RECORD-TYPE
Fields
23
Updated by
3 programs
Referenced by
10 programs

ACPRODACCT is the Activity Product Account table in Lawson AC Billing Revenue (prefix BRR). It is indexed by PRODUCT-LIST, PRODUCT, RECORD-TYPE (BRRSET1). It is related 1:1 to ACGLCODE and ACPRODLST. It is updated by BR50.1, BR50.2 and BR50.3 and referenced by BR155, BR250, BR51.1, BR51.2, BR52.1, BR52.4, BR52.5, BR570 and 2 more. The table has 23 fields, 1 index and 6 documented relations.

About ACPRODACCT

No description in the Lawson data dictionary.

Fields (23)

Column = COBOL field name without the BRR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
BRR-PRODUCT-LIST PK
PRODUCT_LIST		Alpha 10—BR50.2
BRR-PRODUCT PK
PRODUCT		Alpha 15—BR50.2
BRR-RECORD-TYPE PK
RECORD_TYPE		Alpha 1This field identifies the type of record defined. Valid values are:
  • S Summary
  • D Detail
  • 1 Product
  • 2 Free Maintenance
  • 3 Billed Maintenance
  • 4 All
BR50.2
BRR-BILL-ACCT-CAT
BILL_ACCT_CAT		Alpha 5Account 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 thruBR50.2
BRR-BILL-GL-CD
BILL_GL_CD		Alpha 4—BR50.2
BRR-BILL-ACCOUNT
BILL_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.BR50.2
BRR-BILL-SUB-ACCT
BILL_SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.BR50.2
BRR-UNBL-ACCT-CAT
UNBL_ACCT_CAT		Alpha 5Account 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 thruBR50.2
BRR-UNBL-GL-CD
UNBL_GL_CD		Alpha 4—BR50.2
BRR-UNBL-ACCOUNT
UNBL_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.BR50.2
BRR-UNBL-SUB-ACCT
UNBL_SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.BR50.2
BRR-REV-ACCT-CAT
REV_ACCT_CAT		Alpha 5Account 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 thruBR50.2
BRR-REV-GL-CD
REV_GL_CD		Alpha 4—BR50.2
BRR-REV-ACCOUNT
REV_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.BR50.2
BRR-REV-SUB-ACCT
REV_SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.BR50.2
BRR-CGSL-ACCT-CAT
CGSL_ACCT_CAT		Alpha 5Account 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 thruBR50.2
BRR-CGSL-GL-CD
CGSL_GL_CD		Alpha 4—BR50.2
BRR-CGSL-ACCOUNT
CGSL_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.BR50.2
BRR-CGSL-SUB-ACCT
CGSL_SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.BR50.2
BRR-CGSX-ACCT-CAT
CGSX_ACCT_CAT		Alpha 5Account 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 thruBR50.2
BRR-CGSX-GL-CD
CGSX_GL_CD		Alpha 4—BR50.2
BRR-CGSX-ACCOUNT
CGSX_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.BR50.2
BRR-CGSX-SUB-ACCT
CGSX_SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.BR50.2

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BRRSET1PRODUCT-LIST, PRODUCT, RECORD-TYPEPrimaryBR155, BR250, BR50.1, BR50.2, BR50.3, BR51.1, BR51.2, BR52.1 +5 more

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
Acglcode BillACGLCODENot RequiredBRR-BILL-GL-CD → AGC-AC-GL-CODE
Acglcode CgslACGLCODENot RequiredBRR-CGSL-GL-CD → AGC-AC-GL-CODE
Acglcode CgsxACGLCODENot RequiredBRR-CGSX-GL-CD → AGC-AC-GL-CODE
Acglcode RevACGLCODENot RequiredBRR-REV-GL-CD → AGC-AC-GL-CODE
Acglcode UnblACGLCODENot RequiredBRR-UNBL-GL-CD → AGC-AC-GL-CODE
AcprodlstACPRODLSTRequiredBRR-PRODUCT-LIST → BRP-PRODUCT-LIST

Programs

Updated by (3)

Referenced by (10)