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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#BRB-TEMPLATE PKTEMPLATE | Alpha 15 | The name of the template the detail records are associated to. | BR47.2 |
#BRB-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | BR47.2 |
#BRB-ACCT-CATEGORY PKACCT_CATEGORY | Alpha 5 | 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 | BR47.2 |
#BRB-REVENUE-GL-CDREVENUE_GL_CD | Alpha 4 | — | BR47.2 |
#BRB-REV-ACCT-CATREV_ACCT_CAT | Alpha 5 | 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 | BR47.2 |
#BRB-REV-ACCTREV_ACCT | Numeric 6 | This 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-ACCTREV_SUB_ACCT | Numeric 4 | This 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-CDLOSS_GL_CD | Alpha 4 | — | BR47.2 |
#BRB-LOSS-ACCT-CATLOSS_ACCT_CAT | Alpha 5 | 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 | BR47.2 |
#BRB-RSRV-LSS-GL-CDRSRV_LSS_GL_CD | Alpha 4 | — | BR47.2 |
#BRB-ADJ-ACCT-CATADJ_ACCT_CAT | Alpha 5 | 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 | BR47.2 |
#BRB-ADJ-ACCOUNTADJ_ACCOUNT | Numeric 6 | This 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-ACCTADJ_SUB_ACCT | Numeric 4 | This 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
BRBSET1 |
| Primary | AC56.1, AC560, BR10.1, BR247, BR47.2 |
Programs
Updated by (1)
- BR47.2 Contract Account Template