ACTEMPACCT – Activity Account Template

System
AC Billing Revenue (BR)
Prefix
BRB
Primary key
TEMPLATE, ACCT-CATEGORY
Fields
13
Updated by
1 program
Referenced by
4 programs

ACTEMPACCT is the Activity Account Template table in Lawson AC Billing Revenue (prefix BRB). It is indexed by TEMPLATE, ACCT-CATEGORY (BRBSET1). It is updated by BR47.2 and referenced by AC56.1, AC560, BR10.1 and BR247. The table has 13 fields, 1 index and 0 documented relations.

About ACTEMPACCT

No description in the Lawson data dictionary.

Fields (13)

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

Field / columnTypeDescription & valuesUpdated by
BRB-TEMPLATE PK
TEMPLATE
Alpha 15The name of the template the detail records are associated to.BR47.2
BRB-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field displays the description.BR47.2
BRB-ACCT-CATEGORY PK
ACCT_CATEGORY
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 thruBR47.2
BRB-REVENUE-GL-CD
REVENUE_GL_CD
Alpha 4BR47.2
BRB-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 thruBR47.2
BRB-REV-ACCT
REV_ACCT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.BR47.2
BRB-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.BR47.2
BRB-LOSS-GL-CD
LOSS_GL_CD
Alpha 4BR47.2
BRB-LOSS-ACCT-CAT
LOSS_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 thruBR47.2
BRB-RSRV-LSS-GL-CD
RSRV_LSS_GL_CD
Alpha 4BR47.2
BRB-ADJ-ACCT-CAT
ADJ_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 thruBR47.2
BRB-ADJ-ACCOUNT
ADJ_ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.BR47.2
BRB-ADJ-SUB-ACCT
ADJ_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.BR47.2

Indexes (1)

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

IndexKeysFlagsConditionUsed in
BRBSET1TEMPLATE, ACCT-CATEGORYPrimaryAC56.1, AC560, BR10.1, BR247, BR47.2

Programs

Updated by (1)

Referenced by (4)