ACIFACTV

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

REFERENCED BY
AC10.1 AC10.5 AC112 AC113 AC120 AC121
AC123 AC128 AC135 AC145 AC147 AC160
AC165 AC169 AC190 AC191 AC197 AC198
AC200 AC203 AC206 AC207 AC210 AC213
AC218 AC220 AC225 AC240 AC246 AC247
AC261 AC265 AC290 AC295 AC297 AC298
AC310 AC311 AC346 AC40.1 AC40.4 AC400
AC401 AC41.1 AC41.4 AC410 AC412 AC42.1
AC420 AC421 AC440 AC45.1 AC45.4 AC46.1
AC460 AC471 AC472 AC473 AC480 AC490
AC493 AC494 AC527 AC54.1 AC540 AC56.1
AC560 AC90.1 AC90.2 AC90.4 AC90.6 AC90.8
AC92.1 AC92.2 AC92.4 AC92.6 AC93.4 AC93.5
AC94.1 AC94.2 AC94.4 AC94.6 AC95.1 AC95.2
AC95.4 AC95.6 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 BR00.1 BR00.2 BR00.3 BR02.1
BR02.3 BR10.1 BR120 BR121 BR122 BR123
BR130 BR131 BR140 BR142 BR145 BR151
BR152 BR153 BR154 BR155 BR156 BR157
BR165 BR19.1 BR190 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR20.6 BR200 BR202 BR204
BR205 BR210 BR212 BR215 BR220 BR245
BR251 BR252 BR253 BR265 BR300 BR40.3
BR40.4 BR400 BR405 BR41.1 BR41.4 BR42.1
BR420 BR422 BR43.1 BR430 BR44.1 BR450
BR46.1 BR46.2 BR46.4 BR52.2 BR52.4 BR52.5
BR521 BR530 BR580 CB10.1 CB15.1 CB15.2
CB150 CB191 CB20.1 CB30.1 CB45.1 CB46.1
CB500 CB543 CB544 CB55.1 CB554 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CXCP.1 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 GL76.1 DR100 IC140
IC66.1 IC83.1 EX545 IFEB.1 MA180 MA41.1
MA41.2 MA41.4 MA41.7 MA42.2 MA43.2 MA43.7
MA44.1 MA44.2 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PO100 PO101 PO122 PO131 PO136
PO150 PO190 PO20.1 PO20.6 PO20.9 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO26.2 PO26.3 PO26.4 PO26.5 PO26.6
PO26.7 PO26.9 PO27.2 PO28.2 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.5 POCP.1 POI3.1
POID.1 POIG.1 POII.1 POIJ.1 POIK.1 RQ10.1
RQ10.2 RQ10.4 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ500 RQIF.1 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830 ZW130 AC110 AC12.1 ACBA.1 BR01.1
BR01.2 BR03.1 BR03.2 BR03.3 BR05.2 BR05.3
BR05.4 BR05.5 BR206 BR54.2 BR54.3 BR54.4
BR96.1


UPDATED 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.
AC50.1
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.
AC50.1
AIV-ACTIVITY
Element: Activity
Alpha 15
This is the new, or Lawson, activity. Either this field or the Old Activity field is required.
AC50.1
AIV-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This is the activity description.
AC50.1
AIV-ACTIVITY-GRP
Element: Activity Grp
Alpha 15
The activity group is the overall project.
AC50.1
AIV-OLD-ACT-GRP
Element: Old Act Grp
Alpha 35
This is the old, or non-Lawson, project or activity group. Required.
AC50.1
AIV-COMPANY
Element: Company
Numeric 4
Required. This is the company for the imported activity.
AC50.1
AIV-ACCT-UNIT
Element: Acct Unit
Alpha 15
This is the accounting unit for the imported activity.
AC50.1
AIV-ACCOUNT
Element: Account
Numeric 6
This is the account for the imported activity.
AC50.1
AIV-SUB-ACCT
Element: Sub Acct
Numeric 4
This is the subaccount for the imported activity.
AC50.1
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.
AC50.1
AIV-USR-STATUS
Element: Usr Status
Alpha 2
Required. This is the status of the imported activity.
AC50.1
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.
AC50.1
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.
AC50.1
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.
AC50.1
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.
AC50.1
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.
AC50.1
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.
AC50.1 AC500
AIV-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
This is the ending date for the activity.
AC50.1 AC500
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.
AC50.1
AIV-ESTIMATE
Element: Intl Amt
Signed 18.2
This is the estimated amount for the activity.
AC50.1
AIV-BILLABLE-FLAG
Element: Billable
Alpha 1
This field indicates whether the activity is billable. The default is "N".
AC50.1
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.
AC50.1
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).
AC50.1
AIV-ADDR-DESC
Element: Addr Desc
Alpha 30
This is the address description.
AC50.1
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).
AC50.1
AIV-RES-COMPANY
Element: Company
Numeric 4
This is the company for the activity resource. Required for resource types "H" and "V".
AC50.1
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).
AC50.1 AC500
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.
AC50.1 AC500
AIV-STD-RATE
Element: Std Rate
Signed 13.5
This is the standard rate for the resource.
AC50.1
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.
AC50.1
AIV-RES-TO-COMP
Element: Company
Numeric 4
This is the post-to company for the default expense account.
AC50.1
AIV-RES-ACCT-UNIT
Element: Acct Unit
Alpha 15
This is the accounting unit for the default expense account.
AC50.1
AIV-RES-ACCOUNT
Element: Account
Numeric 6
This is the account for the default expense account.
AC50.1
AIV-RES-SUB-ACCT
Element: Sub Acct
Numeric 4
This is the subaccount for the default expense account.
AC50.1
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.
AC50.1
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.
AC50.1
AIV-MATRIX-CAT-1
Element: Matrix Cat
Alpha 12
This is the first attribute to import.
AC50.1
AIV-MX-VALUE-1
Element: Mx Value 1
Alpha 32
This is the first attribute value to import.
AC50.1
AIV-MATRIX-CAT-2
Element: Matrix Cat
Alpha 12
This is the second attribute to import.
AC50.1
AIV-MX-VALUE-2
Element: Mx Value 2
Alpha 32
This is the second attribute value to import.
AC50.1
AIV-MATRIX-CAT-3
Element: Matrix Cat
Alpha 12
This is the third attribute to import.
AC50.1
AIV-MX-VALUE-3
Element: Mx Value
Alpha 32
This is the third attribute value to import.
AC50.1
AIV-MATRIX-CAT-4
Element: Matrix Cat
Alpha 12
This is the fourth attribute to import.
AC50.1
AIV-MX-VALUE-4
Element: Mx Value
Alpha 32
This is the fourth attribute value to import.
AC50.1
AIV-MATRIX-CAT-5
Element: Matrix Cat
Alpha 12
This is the fifth attribute to import.
AC50.1
AIV-MX-VALUE-5
Element: Mx Value
Alpha 32
This is the fifth attribute value to import.
AC50.1
AIV-MATRIX-CAT-6
Element: Matrix Cat
Alpha 12
This is the sixth attribute to import.
AC50.1
AIV-MX-VALUE-6
Element: Mx Value
Alpha 32
This is the sixth attribute value to import.
AC50.1
AIV-MATRIX-CAT-7
Element: Matrix Cat
Alpha 12
This is the seventh attribute to import.
AC50.1
AIV-MX-VALUE-7
Element: Mx Value
Alpha 32
This is the seventh attribute value to import.
AC50.1
AIV-MATRIX-CAT-8
Element: Matrix Cat
Alpha 12
This is the eighth attribute to import.
AC50.1
AIV-MX-VALUE-8
Element: Mx Value
Alpha 32
This is the eighth attribute value to import.
AC50.1
AIV-MATRIX-CAT-9
Element: Matrix Cat
Alpha 12
This is the ninth attribute to import.
AC50.1
AIV-MX-VALUE-9
Element: Mx Value
Alpha 32
This is the ninth attribute value to import.
AC50.1
AIV-MATRIX-CAT-10
Element: Matrix Cat
Alpha 12
This is the tenth attribute to import.
AC50.1
AIV-MX-VALUE-10
Element: Mx Value
Alpha 32
This is the tenth attribute value to import.
AC50.1
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.
AC50.1
AIV-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
AC50.1
AIV-OUTPUT-MEASURE
Element: Intl Amt
Signed 18.2
AC50.1
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.
AC50.1
AIV-BILL-WBS-CODE
Element: Bill Wbs Code
Alpha 3
AC50.1
AIV-RES-CURR-CODE
Element: Res Curr Code
Alpha 5
AC50.1
AIV-EFFECTIVE-DATE
Element: Effective Date
Numeric 8 (yyyymmdd)
The effective date for the rate assignment for the resource.
AC50.1
AIV-BILL-RATE
Element: Bill Rate
Signed 13.4
The billing rate that is set up for a resource for a specific activity.
AC50.1
AIV-ACTIVE-FLAG
Element: Active Flag
Alpha 1
The status of the rate assignment for a resource.
A = Active
I = Inactive
AC50.1
AIV-RESC-BEG-DATE
Element: Date
Numeric 8 (yyyymmdd)
The beginning of the date range that this resource assignment is effective for.
AC50.1
AIV-RESC-END-DATE
Element: Date
Numeric 8 (yyyymmdd)
The end of the date range that this resource assignment is effective for.
AC50.1
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
AC50.1
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
AC50.1
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
AC50.1
AIV-SALARY-CAP-AMT
Element: Intl Amt
Signed 18.2
AIV-FRNG-RATE
Element: Curr Rate
Signed 14.7
The currency rate.
AC50.1
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.
AC50.1
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.
AC50.1
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.
AC50.1
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
AC50.1
AIV-BUDGET-LEVEL
Element: Budget Level
Alpha 1

1 = Activity-Acct Cat
3 = Activity
4 = Activity-Summary Account Cat
5 = Contract Funding
AC50.1
AIV-BUD-TOLERANCE
Element: Bud Tolerance
Signed 5.2
AC50.1
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).
AC50.1
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
AC50.1
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.
AC50.1
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.
AC50.1
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).
AC50.1
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).
AC50.1
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).
AC50.1
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).
AC50.1
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.)
AC50.1


ACIFACTV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AIVSET1 RUN-GROUP
OLD-ACTIVITY
ACTIVITY
AC50.1 AC500
AIVSET2 RUN-GROUP
ACTIVITY-GRP
LEVEL-ONE
LEVEL-TWO
LEVEL-THREE
LEVEL-FOUR
LEVEL-FIVE
KeyChange, Subset
WhereLEVEL-ONE !=Zeroes
...
AC10.1 AC10.5
AC110 AC112
AC113 AC12.1
AC120 AC121
AC123 AC128
AC135 AC145
AC147 AC160
AC165 AC169
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC225 AC240


File created: Thu Jun 09 11:04:09 2016

Home
Contact Us



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