ACSTATUS – Activity Status
- System
- Activity Management (AC)
- Prefix
STS- Primary key
USR-STATUS- Fields
- 9
- Updated by
- 1 program
- Referenced by
- 170 programs
ACSTATUS is the Activity Status table in Lawson Activity Management (prefix STS). It is indexed by USR-STATUS (STSSET1). It is updated by AC02.1 and referenced by AC00.1, AC00.2, AC00.3, AC05.2, AC05.3, AC08.1, AC08.2, AC08.3 and 162 more. The table has 9 fields, 1 index and 0 documented relations.
About ACSTATUS
This file contains activity status information from AC02.1 (Status). It includes status code and description, as well as a variety of flags to select for assigning properties to the activity status.
Fields (9)
Column = COBOL field name without the STS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
STS-USR-STATUS PKUSR_STATUS | Alpha 2 | Key field. This is a user-defined code for activity status. | AC02.1 |
STS-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | Required. This is the status description. | AC02.1 |
STS-POST-FLAGPOST_FLAG | Alpha 1 | Required. This flag indicates whether you can post to activities with this status code. This field is used by AC40.1 (Journal Entry) and all subsystem transaction entry programs. Use X to select posting to transactions with this status code.
| AC02.1 |
STS-BUDGET-FLAGBUDGET_FLAG | Alpha 1 | Required. This field indicates whether activities with this status code can have budgets. This flag is used by the AC20 (Budget) forms and all activity budget programs. Use X to indicate budgets can be created.
| AC02.1 |
STS-ALLOCATE-FLAGALLOCATE_FLAG | Alpha 1 | Required. This field indicates whether activities with this status code can have costs allocated to them. This flag is used by the allocation programs. Use X to allocate costs.
| AC02.1 |
STS-BILLABLE-FLAGBILLABLE_FLAG | Alpha 1 | Required. This flag indicates whether activities with this status code can calculate and create billing transactions. This field is used by AC115 (Billing Calculation) and BL20 (Invoice Entry). Use X to indicate billing transactions can be calculated for this activity.
| AC02.1, AC190 |
STS-REV-REC-FLAGREV_REC_FLAG | Alpha 1 | Required. This flag indicates whether activities with this status code can calculate and create AC170 (Revenue Calculation) information. Use X to indicate that you can calculate revenue transactions for this activity.
| AC02.1, AC190 |
STS-CAPITAL-FLAGCAPITAL_FLAG | Alpha 1 | Required. This flag indicates whether activities with this status code can be capitalized, or can create asset transactions. This field is used by AM20.2 (Additions and Adjustments). Use X to indicate this activity can be capitalized.
| AC02.1 |
STS-PURGE-FLAGPURGE_FLAG | Alpha 1 | Required. This flag indicates whether activities with this status code can be purged. This field is used by AC310 (Activity Purge). Use X to indicate records can be purged for activities with this status code.
| AC02.1 |
Indexes (1)
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 |
|---|---|---|---|---|
STSSET1 | USR-STATUS | Primary | AC00.1, AC00.2, AC00.3, AC02.1, AC05.2, AC05.3, AC08.1, AC08.2 +22 more (list truncated in source) |
Programs
Updated by (1)
- AC02.1 Status
Referenced by (170)
- AC00.1 Activity Group
- AC00.2 Calendar
- AC00.3 Activity Group Purge Status
- AC05.2 Account Category Group
- AC05.3 Account Category Mass Addition
- AC08.1 Category Structure
- AC08.2 Define Category Structure
- AC08.3 Account Category Detail
- AC08.4 Copy Category Structure
- AC08.5 Account Category Load
- AC08.6 Move Summary Account Category
- AC08.7 Move Detail Account Category
- AC10.1 Activity
- AC112 Mass Activity Status Change
- AC113 Activity Mass Change
- AC12.1 Activity Status
- AC121 Budget Calculation
- AC123 Budget Copy
- AC127 Budget Interface
- AC128 Mass Budget Lock
- AC130 Allocation Calculation
- AC135 Attribute Effective Date Update
- AC145 Mass Transaction Backout
- AC147 Activity Commitment Capture
- AC160 Asset Management Interface
- AC165 Percent Complete Calculation
- AC169 Mass Capitalization Hold
- AC190 Activity Posting
- AC191 Accounting Unit Balance Post
- AC197 Burden Recalculation Based on Total Cost
- AC198 Burden Rate Recalculation
- AC20.1 Life Only Budget
- AC20.2 Annual Budget
- AC20.3 Period Budget
- AC20.4 Activity Budgets by Activity
- AC20.5 Activity Budgets by Account Category
- AC20.7 Activity Budget Header
- AC200 Activity Grp Listing and Audit
- AC202 Status Listing and Audit
- AC203 Resource Assignment Listing
- AC206 Acct Cat Ovrd List and Audit
- AC207 Account Assignment Listing
- AC21.1 Life Only Budget Change Order
- AC21.2 Annual Budget Change Order
- AC21.3 Period Budget Change Order
- AC21.4 Activity Budget Change Orders by Activity
- AC21.5 Period Budget Change Order Import
- AC210 Activity Listing and Audit
- AC213 Activity Attribute Listing
- AC218 Activity Resource Rate Listing
- AC220 Budget Listing
- AC225 Budget Control Report
- AC240 Journal Edit Listing
- AC246 Manual Commitment Listing
- AC247 Activity Commitment History
- AC25.1 Budget Control
- AC261 Burden Assignment Listing
- AC265 Percent Complete Report
- AC27.1 Budget Interface Adjustment
- AC290 Transaction Listing
- AC295 Activity Commitment Summary
- AC297 Commitment Analysis Summary
- AC298 Commitment Detail Report
- AC30.1 Allocation
- AC30.2 Multiple Pool Allocation
- AC30.3 List Allocation
- AC30.4 New Allocation
- AC305 Activity Audit Analysis Purge
- AC310 Transaction Consolidation
- AC311 Purge and Archive
- AC346 Manual Commitments Purge
- AC40.1 Journal Entry (AC only)
- AC40.4 Journal Entry (AC and GL)
- AC400 Activity Group Analysis Report
- AC401 Activity Trend
- AC41.1 Resource Time Entry (AC only)
- AC41.4 Resource Time Entry (AC and GL)
- AC410 Activity Analysis Report
- AC412 Activity Status Report
- AC42.1 Subcontractor Time and Material Entry
- AC420 Budget Variance Report
- AC421 Change Order History
- AC440 Resource Charge
- AC460 Capitalization History
- AC471 Bill of Costs
- AC472 Bill of Activities
- AC473 Profit and Loss Statement
- AC480 Activity Balances
- AC490 Activity Reconciliation
- AC493 Output Measure Analysis
- AC494 Activity Accounting Unit Analysis
- AC50.1 Activity Interface Adjustment
- AC500 Activity Interface
- AC527 AC to GL Budget Interface
- AC54.1 Transaction Interface Adjustment
- AC540 Transaction Interface
- AC56.1 Setup Interface Adjustment
- AC560 Setup Interface
- AC583 Activity Transaction Rebuild
- AC65.1 Activity Percentage of Completion
- AC65.2 Percent Complete by Account Category
- AC71.1 Activity Template
- AC90.1 Activity Analysis
- AC92.1 Resource Analysis
- AC93.1 Output Measure Analysis
- AC94.1 Activity Accounting Unit Analysis
- AC95.1 Account Category Analysis
- AC97.1 Account Category Encumbrance Analysis
- ACAC.1 Activity Management Activity Edit
- AP211 Vendor Invoicing
- BR02.1 Retainer Parameters
- BR02.2 Retainer Detail
- BR02.3 Retainer Invoice Entry
- BR120 Invoice Calculation
- BR121 Invoice Print and Interface
- BR124 Deferred Revenue Adjustment
- BR130 Revenue Calculation
- BR131 Revenue Realization
- BR140 Billing and Revenue Backout
- BR142 Mass Transaction Hold
- BR145 Invoice Control Maintenance
- BR151 Product Invoicing
- BR152 Maintenance Invoicing
- BR153 Product Revenue Calculation
- BR154 Maintenance Revenue Calculation
- BR155 Maintenance Schedule Copy
- BR156 Maintenance Quote
- BR157 Maintenance Cancel
- BR165 Percent Complete Calculation
- BR19.1 Single Invoice Calculation
- BR19.2 Filter
- BR190 Billing and Revenue Recalculation
- BR20.6 Invoice Edit Detail
- BR20.9 Filter
- BR200 Billing Listing
- BR202 Retainer Listing
- BR204 Burden Billing Rate Listing
- BR205 Milestone Listing
- BR210 Contract Listing
- BR212 Contract Modification Listing
- BR215 Fee Code Listing
- BR220 Invoice Audit Listing
- BR245 Invoice Control Listing
- BR251 Product Contract Listing
- BR252 Maintenance Schedule Listing
- BR253 Deferred Revenue Listing
- BR254 Product Milestone Listing
- BR265 Percent of Completion Report
- BR300 Invoice Purge
- BR40.3 Transfer
- BR400 Invoice History
- BR405 Milestone Analysis
- BR422 Contract Change Order History Report
- BR43.1 Revenue Adjustment
- BR430 Revenue History
- BR44.1 Mass Transaction Transfer
- BR450 Activity Aging
- BR46.1 Bill in Advance
- BR46.2 Transfer Invoice Transaction
- BR46.4 Split Transfer
- BR51.1 Product Contract
- BR521 Billing Import
- BR530 Revenue Import
- BR580 Applied Balance Rebuild
- BR65.1 Percent Complete by Contract
- BR65.2 Percent Complete by Activity
- BR65.3 Percent Complete by Account Category
- BR70.1 Product Contract Interface Adjustment
- GL299 GL and AC History commitment
- SE90.1 Analysis by Activity