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

REFERENCED BY

AC10.1	AC10.5	AC200	AC210	ACAC.1	AP125
AP126	AP131	AP170	AP193	AP20.1	AP20.2
AP20.3	AP20.4	AP20.5	AP20.7	AP21.1	AP211
AP23.1	AP25.1	AP25.2	AP26.1	AP27.1	AP30.2
AP30.4	AP520	API1.1	API2.1	CB10.1	CB15.1
CB15.2	CB150	CB191	CB20.1	CB30.1	CB45.1
CB46.1	CB500	CB543	CB544	CB55.1	CB554
EE11.1	EE135	EE20.3	EE35.1	EE35.2	EE520
GL146	GL165	GL170	GL197	GL299	GL40.1
GL40.2	GL40.3	GL40.7	GL40.8	GL44.1	GL45.1
GL70.1	GL70.2	GL70.3	GL70.5	GL70.6	GL75.1
EX545	IFEB.1	MA41.1	MA41.2	MA41.4	MA41.7
MA43.1	MA43.2	MA43.3	MA43.4	MA43.6	MA43.7
MAI1.1	PO136	PO190	PO300	PO520	POCP.1
POI3.1	POIG.1	POII.1	POIJ.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
AIV-RUN-GROUP Element: Run Group	Alpha 15 Required. This is the run group for the import of non-Lawson activity or project information.
AIV-OLD-ACTIVITY Element: Old Activity	Alpha 35 This 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.
AIV-ACTIVITY Element: Activity	Alpha 15 This is the new, or Lawson, activity. Either this field or the Old Activity field is required.
AIV-DESCRIPTION Element: Description	Alpha 30 (Lower Case) This is the activity description.
AIV-ACTIVITY-GRP Element: Activity Grp	Alpha 15 The activity group is the overall project.
AIV-OLD-ACT-GRP Element: Old Act Grp	Alpha 35 This is the old, or non-Lawson, project or activity group. Required.
AIV-COMPANY Element: Company	Numeric 4 Required. This is the company for the imported activity.
AIV-ACCT-UNIT Element: Acct Unit	Alpha 15 This is the accounting unit for the imported activity.
AIV-ACCOUNT Element: Account	Numeric 6 This is the account for the imported activity.
AIV-SUB-ACCT Element: Sub Acct	Numeric 4 This is the subaccount for the imported activity.
AIV-ACCT-CATEGORY Element: Acct Category	Alpha 5 This 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.
AIV-USR-STATUS Element: Usr Status	Alpha 2 Required. This is the status of the imported activity.
AIV-LEVEL-ONE Element: Level Detail	Numeric 15 Required. 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.
AIV-LEVEL-TWO Element: Level Detail	Numeric 15 Required. 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.
AIV-LEVEL-THREE Element: Level Detail	Numeric 15 Required. 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.
AIV-LEVEL-FOUR Element: Level Detail	Numeric 15 Required. 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.
AIV-LEVEL-FIVE Element: Level Detail	Numeric 15 Required. 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.
AIV-BEGIN-DATE Element: 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.
AIV-END-DATE Element: End Date	Numeric 8 (yyyymmdd) This is the ending date for the activity.
AIV-LONG-DESC Element: 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.
AIV-ESTIMATE Element: Intl Amt	Signed 18.2 This is the estimated amount for the activity.
AIV-BILLABLE-FLAG Element: Billable	Alpha 1 This field indicates whether the activity is billable. The default is "N".
AIV-POSTING-FLAG Element: Posting Flag	Alpha 1 Required. This field indicates whether the activity is a posting-level activity. Use P for posting level and S for summary level.
AIV-ADDRESS-CODE Element: Address Code	Alpha 9 This is the address code for the new activity. Address codes are defined in AC10.4 (Location).
AIV-ADDR-DESC Element: Addr Desc	Alpha 30 This is the address description.
AIV-RESOURCE-TYPE Element: Resource Type	Alpha 1 This 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).
AIV-RES-COMPANY Element: Company	Numeric 4 This is the company for the activity resource. Required for resource types "H" and "V".
AIV-RES-EMPLOYEE Element: Res Employee	Alpha 10 Required 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).
AIV-RES-DESC Element: Res Desc	Alpha 30 If blank and a resource is used, AC500 (Activity Import) will default the description from the AP vendor, HR employee, or AC person.
AIV-STD-RATE Element: Std Rate	Signed 13.5 This is the standard rate for the resource.
AIV-UNIT-MEASURE Element: Unit Measure	Alpha 12 This is the unit of measure code for the resource. This field is required if you enter a standard rate.
AIV-RES-TO-COMP Element: Company	Numeric 4 This is the post-to company for the default expense account.
AIV-RES-ACCT-UNIT Element: Acct Unit	Alpha 15 This is the accounting unit for the default expense account.
AIV-RES-ACCOUNT Element: Account	Numeric 6 This is the account for the default expense account.
AIV-RES-SUB-ACCT Element: Sub Acct	Numeric 4 This is the subaccount for the default expense account.
AIV-MATRIX-CAT-11 Element: Matrix Cat 11	Alpha 12 This is the billing category attribute that can be associated with the manager resource for this activity.
AIV-MX-VALUE-11 Element: Mx Value 11	Alpha 32 This is the value for the billing category attribute associated with the manager resource for this activity.
AIV-MATRIX-CAT-1 Element: Matrix Cat	Alpha 12 This is the first attribute to import.
AIV-MX-VALUE-1 Element: Mx Value 1	Alpha 32 This is the first attribute value to import.
AIV-MATRIX-CAT-2 Element: Matrix Cat	Alpha 12 This is the second attribute to import.
AIV-MX-VALUE-2 Element: Mx Value 2	Alpha 32 This is the second attribute value to import.
AIV-MATRIX-CAT-3 Element: Matrix Cat	Alpha 12 This is the third attribute to import.
AIV-MX-VALUE-3 Element: Mx Value	Alpha 32 This is the third attribute value to import.
AIV-MATRIX-CAT-4 Element: Matrix Cat	Alpha 12 This is the fourth attribute to import.
AIV-MX-VALUE-4 Element: Mx Value	Alpha 32 This is the fourth attribute value to import.
AIV-MATRIX-CAT-5 Element: Matrix Cat	Alpha 12 This is the fifth attribute to import.
AIV-MX-VALUE-5 Element: Mx Value	Alpha 32 This is the fifth attribute value to import.
AIV-MATRIX-CAT-6 Element: Matrix Cat	Alpha 12 This is the sixth attribute to import.
AIV-MX-VALUE-6 Element: Mx Value	Alpha 32 This is the sixth attribute value to import.
AIV-MATRIX-CAT-7 Element: Matrix Cat	Alpha 12 This is the seventh attribute to import.
AIV-MX-VALUE-7 Element: Mx Value	Alpha 32 This is the seventh attribute value to import.
AIV-MATRIX-CAT-8 Element: Matrix Cat	Alpha 12 This is the eighth attribute to import.
AIV-MX-VALUE-8 Element: Mx Value	Alpha 32 This is the eighth attribute value to import.
AIV-MATRIX-CAT-9 Element: Matrix Cat	Alpha 12 This is the ninth attribute to import.
AIV-MX-VALUE-9 Element: Mx Value	Alpha 32 This is the ninth attribute value to import.
AIV-MATRIX-CAT-10 Element: Matrix Cat	Alpha 12 This is the tenth attribute to import.
AIV-MX-VALUE-10 Element: Mx Value	Alpha 32 This is the tenth attribute value to import.
AIV-SEGMENT-BLOCK Element: Segment Block	Alpha 103 This 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.
AIV-CURRENCY-CODE Element: Currency Code	Alpha 5 This field contains the company base currency code established in Company (GL10.1 ).
AIV-OUTPUT-MEASURE Element: Intl Amt	Signed 18.2
AIV-OUTPUT-DESC Element: Output Desc	Alpha 30 This is the description of the output measure. If you enter an output measure, this field is required.
AIV-BILL-WBS-CODE Element: Bill Wbs Code	Alpha 3
AIV-RES-CURR-CODE Element: Res Curr Code	Alpha 5
AIV-EFFECTIVE-DATE Element: Effective Date	Numeric 8 (yyyymmdd) The effective date for the rate assignment for the resource.
AIV-BILL-RATE Element: Bill Rate	Signed 13.4 The billing rate that is set up for a resource for a specific activity.
AIV-ACTIVE-FLAG Element: Active Flag	Alpha 1 The status of the rate assignment for a resource. A = Active I = Inactive
AIV-RESC-BEG-DATE Element: Date	Numeric 8 (yyyymmdd) The beginning of the date range that this resource assignment is effective for.
AIV-RESC-END-DATE Element: Date	Numeric 8 (yyyymmdd) The end of the date range that this resource assignment is effective for.
AIV-AWARD-FLAG Element: Award Flag	Alpha 1 Flag to indicate whether this activity is an award for the GM system or a posting level activity within an award. Y = Yes N = No
AIV-EFFORT-FLAG Element: Effort Flag	Alpha 1 Flag 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
AIV-SALARY-CAP-FL Element: Salary Cap Fl	Alpha 1 This 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
AIV-SALARY-CAP-AMT Element: Intl Amt	Signed 18.2
AIV-FRNG-RATE Element: Curr Rate	Signed 14.7 The currency rate.
AIV-FRNG-ACCT-CAT Element: Frng Acct Cat	Alpha 5 A 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.
AIV-FRNG-ACCOUNT Element: Frng Account	Numeric 6 A 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.
AIV-FRNG-SUB-ACCT Element: Frng Sub Acct	Numeric 4 A 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.
AIV-STRUCTURE Element: Structure	Alpha 15 The name of the category structure.
AIV-BUDGET-EDIT Element: Budget Edit	Alpha 1 1 = No Edit 2 = Period Edit 3 = Annual Edit 4 = Total Edit
AIV-BUDGET-LEVEL Element: Budget Level	Alpha 1 1 = Activity-Acct Cat 3 = Activity 4 = Activity-Summary Account Cat 5 = Contract Funding
AIV-BUD-TOLERANCE Element: Bud Tolerance	Signed 5.2
AIV-SCHEDULE Element: Schedule	Alpha 9 A salary cap schedule is required if the activity is subject to a salary cap (SALARY-CAP-FL=Y).
AIV-CURRENT-CAP Element: Flag	Alpha 1 This 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
AIV-CAP-ACTIVITY Element: Activity	Alpha 15 Identifies 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.
AIV-CAP-ACCT-CAT Element: Acct Category	Alpha 5 Identifies 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.
AIV-CAP-COMPANY Element: Company	Numeric 4 This 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).
AIV-CAP-ACCT-UNIT Element: Acct Unit	Alpha 15 This 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).
AIV-CAP-ACCOUNT Element: Account	Numeric 6 This 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).
AIV-CAP-SUB-ACCT Element: Sub Acct	Numeric 4 This 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).
AIV-CAP-SEG-BLOCK Element: Segment Block	Alpha 103 This 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.)

ACIFACTV FILE INDEX

All trademarks and registered trademarks are the property of their respective owners.