ACTRANSERR – No description in the Lawson data dictionary
- System
- AC Billing Revenue (BR)
- Prefix
TER- Primary key
OBJ-ID- Fields
- 9
- Updated by
- 5 programs
- Referenced by
- 4 programs
ACTRANSERR is a Lawson AC Billing Revenue table (prefix TER); no description in the lawson data dictionary. It is indexed by OBJ-ID (TERSET1); alternate indexes: TERSET2 and TERSET3. It is related 1:1 to ACTRANS. It is updated by AC300, AC311, BR130, BR140 and BR530 and referenced by AC310, BR10.1, BR12.1 and BR580. The table has 9 fields, 3 indexes and 1 documented relation.
About ACTRANSERR
No description in the Lawson data dictionary.
Fields (9)
Column = COBOL field name without the TER- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
TER-OBJ-ID PKOBJ_ID | Numeric 12 | This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. | BR130, BR530 |
TER-ACTIVITYACTIVITY | Alpha 15 | Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. | BR130, BR530 |
TER-ACCT-CATEGORYACCT_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 | BR130, BR530 |
TER-JOURNAL-CODEJOURNAL_CODE | Alpha 4 | — | BR130, BR530 |
TER-STATUSSTATUS | Numeric 1 | This field displays the status of the transaction.
| BR130, BR530 |
TER-BRDN-ORG-OBJIDBRDN_ORG_OBJID | Numeric 12 | — | — |
TER-AUTO-JRL-CDAUTO_JRL_CD | Alpha 4 | — | — |
TER-REVENUE-AMTREVENUE_AMT | Signed 18.2 | — | — |
TER-APPLY-TOL-AMTAPPLY_TOL_AMT | Signed 18.2 | — | BR130, BR530 |
Indexes (3)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
TERSET1 | OBJ-ID | Primary | AC310, AC311, BR130, BR140, BR530, BR580 | |
TERSET2 | JOURNAL-CODE, OBJ-ID | KeyChange | BR12.1 | |
TERSET3 | STATUS, ACTIVITY, ACCT-CATEGORY, OBJ-ID | KeyChange | AC300, BR10.1 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Actrans | ACTRANS | Required | TER-ACCT-CATEGORY → ATN-ACCT-CATEGORY, TER-OBJ-ID → ATN-OBJ-ID |
Programs
Updated by (5)
- AC300 Activity Group Purge
- AC311 Purge and Archive
- BR130 Revenue Calculation
- BR140 Billing and Revenue Backout
- BR530 Revenue Import