This file contains activity import information from AC500 (Activity Import).
REFERENCED BY
AC50.1 | AC500 |
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.) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AIVSET1 |
RUN-GROUP OLD-ACTIVITY ACTIVITY |
|
| ||||||||||||||||||||||||||||||||||||||||||
AIVSET2 |
RUN-GROUP ACTIVITY-GRP LEVEL-ONE LEVEL-TWO LEVEL-THREE LEVEL-FOUR LEVEL-FIVE |
|
|
All trademarks and registered trademarks are the property of their
respective owners.