ACIFACTV – This file contains activity import information from AC500 (Activity Import).

System
Activity Management (AC)
Prefix
AIV
Primary key
RUN-GROUP, OLD-ACTIVITY, ACTIVITY
Fields
89
Updated by
2 programs
Referenced by
444 programs

ACIFACTV is the This file contains activity import information from AC500 (Activity Import). table in Lawson Activity Management (prefix AIV). It is indexed by RUN-GROUP, OLD-ACTIVITY, ACTIVITY (AIVSET1); alternate indexes: AIVSET2. It is updated by AC50.1 and AC500 and referenced by AC10.1, AC10.5, AC110, AC112, AC113, AC12.1, AC120, AC121 and 436 more. The table has 89 fields, 2 indexes and 0 documented relations.

About ACIFACTV

This file contains activity import information from AC500 (Activity Import).

Fields (89)

Column = COBOL field name without the AIV- 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 / columnTypeDescription & valuesUpdated by
#AIV-RUN-GROUP PK
RUN_GROUP
Alpha 15Required. This is the run group for the import of non-Lawson activity or project information.AC50.1
#AIV-OLD-ACTIVITY PK
OLD_ACTIVITY
Alpha 35This is the old, or non-Lawson activity. Either this field or the Activity field is required. If you enter an Old Activity and leave the Activity field blank, you must define a relationship in AC29.1 (Activity Relationship). If you enter both the Old Activity and Activity the AC500 will define the relationship in AC29 for you.AC50.1
#AIV-ACTIVITY PK
ACTIVITY
Alpha 15This is the new, or Lawson, activity. Either this field or the Old Activity field is required.AC50.1
#AIV-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This is the activity description.AC50.1
#AIV-ACTIVITY-GRP SET2
ACTIVITY_GRP
Alpha 15The activity group is the overall project.AC50.1
#AIV-OLD-ACT-GRP
OLD_ACT_GRP
Alpha 35This is the old, or non-Lawson, project or activity group. Required.AC50.1
#AIV-COMPANY
COMPANY
Numeric 4Required. This is the company for the imported activity.AC50.1
#AIV-ACCT-UNIT
ACCT_UNIT
Alpha 15This is the accounting unit for the imported activity.AC50.1
#AIV-ACCOUNT
ACCOUNT
Numeric 6This is the account for the imported activity.AC50.1
#AIV-SUB-ACCT
SUB_ACCT
Numeric 4This is the subaccount for the imported activity.AC50.1
#AIV-ACCT-CATEGORY
ACCT_CATEGORY
Alpha 5This is the account category for the imported activity. You can enter an account category that is assigned to the activity group in the AC06.1 (Account Category Assignment). If you plan to do assignments by activity, leave this field blank.AC50.1
#AIV-USR-STATUS
USR_STATUS
Alpha 2Required. This is the status of the imported activity.AC50.1
#AIV-LEVEL-ONE SET2
LEVEL_ONE
Numeric 15Required. Levels define an addressing system that organizes activities into a reporting hierarchy. Levels facilitate rollup or consolidation of budgets, costs, and revenues from activities at lower levels to activities at a higher level within the hierarchy. This is the first level.AC50.1
#AIV-LEVEL-TWO SET2
LEVEL_TWO
Numeric 15Required. Levels define an addressing system that organizes activities into a reporting hierarchy. Levels facilitate rollup or consolidation of budgets, costs, and revenues from activities at lower levels to activities at a higher level within the hierarchy. This is the second level.AC50.1
#AIV-LEVEL-THREE SET2
LEVEL_THREE
Numeric 15Required. Levels define an addressing system that organizes activities into a reporting hierarchy. Levels facilitate rollup or consolidation of budgets, costs, and revenues from activities at lower levels to activities at a higher level within the hierarchy. This is the third level.AC50.1
#AIV-LEVEL-FOUR SET2
LEVEL_FOUR
Numeric 15Required. Levels define an addressing system that organizes activities into a reporting hierarchy. Levels facilitate rollup or consolidation of budgets, costs, and revenues from activities at lower levels to activities at a higher level within the hierarchy. This is the fourth level.AC50.1
#AIV-LEVEL-FIVE SET2
LEVEL_FIVE
Numeric 15Required. Levels define an addressing system that organizes activities into a reporting hierarchy. Levels facilitate rollup or consolidation of budgets, costs, and revenues from activities at lower levels to activities at a higher level within the hierarchy. This is the fifth level.AC50.1
#AIV-BEGIN-DATE
BEGIN_DATE
Numeric 8 (yyyymmdd)This is the beginning date for the activity. If left blank, AC500 (Activity Import) will default the values from the activity group date range.AC50.1, AC500
#AIV-END-DATE
END_DATE
Numeric 8 (yyyymmdd)This is the ending date for the activity.AC50.1, AC500
#AIV-LONG-DESC
LONG_DESC
Alpha 60 (Lower Case)This is the long description of the activity. If left blank, AC500 (Activity Import) will default the short description.AC50.1
#AIV-ESTIMATE
ESTIMATE
Signed 18.2This is the estimated amount for the activity.AC50.1
#AIV-BILLABLE-FLAG
BILLABLE_FLAG
Alpha 1This field indicates whether the activity is billable. The default is "N".AC50.1
#AIV-POSTING-FLAG
POSTING_FLAG
Alpha 1Required. This field indicates whether the activity is a posting-level activity. Use P for posting level and S for summary level.AC50.1
#AIV-ADDRESS-CODE
ADDRESS_CODE
Alpha 9This is the address code for the new activity. Address codes are defined in AC10.4 (Location).AC50.1
#AIV-ADDR-DESC
ADDR_DESC
Alpha 30This is the address description.AC50.1
#AIV-RESOURCE-TYPE
RESOURCE_TYPE
Alpha 1This is the type for the activity resource, it can be used to import a manager for the activity. This field is required if you enter a resource employee. Valid values are Human Resource Employee (H), Activity Management Person (P), or Accounts Payable Vendor (V).AC50.1
#AIV-RES-COMPANY
RES_COMPANY
Numeric 4This is the company for the activity resource. Required for resource types "H" and "V".AC50.1
#AIV-RES-EMPLOYEE
RES_EMPLOYEE
Alpha 10Required if the resource type is not blank. Enter the HR Employee number (numeric 9), the AP vendor number (alpha 9), or the AC person code (alpha 10).AC50.1, AC500
#AIV-RES-DESC
RES_DESC
Alpha 30If blank and a resource is used, AC500 (Activity Import) will default the description from the AP vendor, HR employee, or AC person.AC50.1, AC500
#AIV-STD-RATE
STD_RATE
Signed 13.5This is the standard rate for the resource.AC50.1
#AIV-UNIT-MEASURE
UNIT_MEASURE
Alpha 12This is the unit of measure code for the resource. This field is required if you enter a standard rate.AC50.1
#AIV-RES-TO-COMP
RES_TO_COMP
Numeric 4This is the post-to company for the default expense account.AC50.1
#AIV-RES-ACCT-UNIT
RES_ACCT_UNIT
Alpha 15This is the accounting unit for the default expense account.AC50.1
#AIV-RES-ACCOUNT
RES_ACCOUNT
Numeric 6This is the account for the default expense account.AC50.1
#AIV-RES-SUB-ACCT
RES_SUB_ACCT
Numeric 4This is the subaccount for the default expense account.AC50.1
#AIV-MATRIX-CAT-11
MATRIX_CAT_11
Alpha 12This is the billing category attribute that can be associated with the manager resource for this activity.AC50.1
#AIV-MX-VALUE-11
MX_VALUE_11
Alpha 32This is the value for the billing category attribute associated with the manager resource for this activity.AC50.1
#AIV-MATRIX-CAT-1
MATRIX_CAT_1
Alpha 12This is the first attribute to import.AC50.1
#AIV-MX-VALUE-1
MX_VALUE_1
Alpha 32This is the first attribute value to import.AC50.1
#AIV-MATRIX-CAT-2
MATRIX_CAT_2
Alpha 12This is the second attribute to import.AC50.1
#AIV-MX-VALUE-2
MX_VALUE_2
Alpha 32This is the second attribute value to import.AC50.1
#AIV-MATRIX-CAT-3
MATRIX_CAT_3
Alpha 12This is the third attribute to import.AC50.1
#AIV-MX-VALUE-3
MX_VALUE_3
Alpha 32This is the third attribute value to import.AC50.1
#AIV-MATRIX-CAT-4
MATRIX_CAT_4
Alpha 12This is the fourth attribute to import.AC50.1
#AIV-MX-VALUE-4
MX_VALUE_4
Alpha 32This is the fourth attribute value to import.AC50.1
#AIV-MATRIX-CAT-5
MATRIX_CAT_5
Alpha 12This is the fifth attribute to import.AC50.1
#AIV-MX-VALUE-5
MX_VALUE_5
Alpha 32This is the fifth attribute value to import.AC50.1
#AIV-MATRIX-CAT-6
MATRIX_CAT_6
Alpha 12This is the sixth attribute to import.AC50.1
#AIV-MX-VALUE-6
MX_VALUE_6
Alpha 32This is the sixth attribute value to import.AC50.1
#AIV-MATRIX-CAT-7
MATRIX_CAT_7
Alpha 12This is the seventh attribute to import.AC50.1
#AIV-MX-VALUE-7
MX_VALUE_7
Alpha 32This is the seventh attribute value to import.AC50.1
#AIV-MATRIX-CAT-8
MATRIX_CAT_8
Alpha 12This is the eighth attribute to import.AC50.1
#AIV-MX-VALUE-8
MX_VALUE_8
Alpha 32This is the eighth attribute value to import.AC50.1
#AIV-MATRIX-CAT-9
MATRIX_CAT_9
Alpha 12This is the ninth attribute to import.AC50.1
#AIV-MX-VALUE-9
MX_VALUE_9
Alpha 32This is the ninth attribute value to import.AC50.1
#AIV-MATRIX-CAT-10
MATRIX_CAT_10
Alpha 12This is the tenth attribute to import.AC50.1
#AIV-MX-VALUE-10
MX_VALUE_10
Alpha 32This is the tenth attribute value to import.AC50.1
#AIV-SEGMENT-BLOCK
SEGMENT_BLOCK
Alpha 103This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.AC50.1
#AIV-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AC50.1
#AIV-OUTPUT-MEASURE
OUTPUT_MEASURE
Signed 18.2AC50.1
#AIV-OUTPUT-DESC
OUTPUT_DESC
Alpha 30This is the description of the output measure. If you enter an output measure, this field is required.AC50.1
#AIV-BILL-WBS-CODE
BILL_WBS_CODE
Alpha 3AC50.1
#AIV-RES-CURR-CODE
RES_CURR_CODE
Alpha 5AC50.1
#AIV-EFFECTIVE-DATE
EFFECTIVE_DATE
Numeric 8 (yyyymmdd)The effective date for the rate assignment for the resource.AC50.1
#AIV-BILL-RATE
BILL_RATE
Signed 13.4The billing rate that is set up for a resource for a specific activity.AC50.1
#AIV-ACTIVE-FLAG
ACTIVE_FLAG
Alpha 1The status of the rate assignment for a resource.
  • A Active
  • I Inactive
AC50.1
#AIV-RESC-BEG-DATE
RESC_BEG_DATE
Numeric 8 (yyyymmdd)The beginning of the date range that this resource assignment is effective for.AC50.1
#AIV-RESC-END-DATE
RESC_END_DATE
Numeric 8 (yyyymmdd)The end of the date range that this resource assignment is effective for.AC50.1
#AIV-AWARD-FLAG
AWARD_FLAG
Alpha 1Flag to indicate whether this activity is an award for the GM system or a posting level activity within an award.
  • Y Yes
  • N No
AC50.1
#AIV-EFFORT-FLAG
EFFORT_FLAG
Alpha 1Flag to indicate whether this activity is subject to effort reporting, and if it is, whether it prints in the sponsored or non-sponsored section of the report for effort reporting.
  • Y Yes
  • N No
AC50.1
#AIV-SALARY-CAP-FL
SALARY_CAP_FL
Alpha 1This flag indicates whether the salary cap applies to this grant/project. The actual salary cap amount is stored on the GMSALCAP record.
  • Y Yes
  • N No
AC50.1
#AIV-SALARY-CAP-AMT
SALARY_CAP_AMT
Signed 18.2
#AIV-FRNG-RATE
FRNG_RATE
Signed 14.7The currency rate.AC50.1
#AIV-FRNG-ACCT-CAT
FRNG_ACCT_CAT
Alpha 5A default post-to fringe account category that can be used by GM110 program to create commitments for fringe amounts. There is a parameter choice on the GM110 program that allows the user to default the rate, post-to account and account category information from the activity or employee.AC50.1
#AIV-FRNG-ACCOUNT
FRNG_ACCOUNT
Numeric 6A default post-to fringe account that can be used by the GM110 program to create commitments for fringe amounts. There is a parameter choice on the GM110 program that allows the user to default the fringe rate, post-to account and account category information from the activity or employee.AC50.1
#AIV-FRNG-SUB-ACCT
FRNG_SUB_ACCT
Numeric 4A default post-to fringe sub account that can be used by the GM110 program to create commitments for fringe amounts. There is a parameter choice on the GM110 program that allows the user to default the fringe rate, post-to account and account category information from the activity or employee.AC50.1
#AIV-STRUCTURE
STRUCTURE
Alpha 15The name of the category structure.
#AIV-BUDGET-EDIT
BUDGET_EDIT
Alpha 1
  • 1 No Edit
  • 2 Period Edit
  • 3 Annual Edit
  • 4 Total Edit
AC50.1
#AIV-BUDGET-LEVEL
BUDGET_LEVEL
Alpha 1
  • 1 Activity-Acct Cat
  • 3 Activity
  • 4 Activity-Summary Account Cat
  • 5 Contract Funding
AC50.1
#AIV-BUD-TOLERANCE
BUD_TOLERANCE
Signed 5.2AC50.1
#AIV-SCHEDULE
SCHEDULE
Alpha 9A salary cap schedule is required if the activity is subject to a salary cap (SALARY-CAP-FL=Y).AC50.1
#AIV-CURRENT-CAP
CURRENT_CAP
Alpha 1This flag determines which salary cap amount is used to determine salary cap overage in labor distribution templates and reports. Y indicates that the most recent active salary cap in the schedule is used. N or blank indicates that the salary cap amount in effect on the activity's start date is used.
  • Y Yes
  • N No
AC50.1
#AIV-CAP-ACTIVITY
CAP_ACTIVITY
Alpha 15Identifies the activity to be charged with the salary cap overage when the salary cap is applied to the labor distribution template. If blank, the salary cap overage is not charged to any activity or account category.AC50.1
#AIV-CAP-ACCT-CAT
CAP_ACCT_CAT
Alpha 5Identifies the account category to be charged with salary cap overage when the salary cap is applied to a labor distribution template. If the account category field is blank and the activity field is polupated, overage is charged to the account category in the template line from which the overage is initiated. If the activity field is blank, no account category can be specified.AC50.1
#AIV-CAP-COMPANY
CAP_COMPANY
Numeric 4This field identifies the GL company to be charged with the salary cap overage when the salary cap is applied to the labor distribution template. If this field is blank, the overage is charged to the GL company on the labor distribution template from which the overage is initiated (GMLABDISTX.COMPANY).AC50.1
#AIV-CAP-ACCT-UNIT
CAP_ACCT_UNIT
Alpha 15This field identifies the accounting unit to charge with the salary cap overage when a salary cap is applied to the salary distribution template. If this field is blank, the overage is charged to the accounting unit on the labor distribution template line from which the overage was initiated (GMLABDISTX.ACCT-UNIT).AC50.1
#AIV-CAP-ACCOUNT
CAP_ACCOUNT
Numeric 6This field identifies the account to charge with the salary cap overage when a salary cap is applied to the labor distribution template If this field is blank, the overage is charged to the account on the labor distribution template line from which the overage is initiated (GMLABDISTX.ACCOUNT).AC50.1
#AIV-CAP-SUB-ACCT
CAP_SUB_ACCT
Numeric 4This field identifies the subaccount to charge with the salary cap overage when a salary cap is applied to the labor distribution template. If this field is blank, the overage is charged to the subaccount on the labor distribution template line from which the overage is inititated (GMLABDISTX.SUB-ACCOUNT).AC50.1
#AIV-CAP-SEG-BLOCK
CAP_SEG_BLOCK
Alpha 103This field identifies the SL user analysis (if any) to charge with the salary cap overage when a salary cap is applied to the labor distribution template. This field determines whether the salary cap overage should be posted to the Strategic Ledger; if overage user analysis values are populated the ACV-CAP-SEG-FLAG flag is set to Y and user analysis values for overage are stored in the ACACTSEG file. If the overages user analysis values are blank, the overage is charged to the user analysis (if any) on the labor distribution teamplate line from which the overage is intitiated. (GMLABDISTX.SEGMENT=N and values come from the GMGMASEG file.)AC50.1

Indexes (2)

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.

IndexKeysFlagsConditionUsed in
AIVSET1
  1. RUN-GROUP
  2. OLD-ACTIVITY
  3. ACTIVITY
PrimaryAC50.1, AC500
AIVSET2
  1. RUN-GROUP
  2. ACTIVITY-GRP
  3. LEVEL-ONE
  4. LEVEL-TWO
  5. LEVEL-THREE
  6. LEVEL-FOUR
  7. LEVEL-FIVE
KeyChange, SubsetWhere LEVEL-ONE != ZeroesAC10.1, AC10.5, AC110, AC112, AC113, AC12.1, AC120, AC121 +22 more (list truncated in source)

Programs

Updated by (2)

Referenced by (444)