Task Planning Packages
Import Specification: Task Planning Packages
Table Name: TaskPlanPackages
Table Type: Task Management
Current Import Version: 1.0
Data Specification
|
Field Name |
Requires Value? |
Max Length |
Related Table |
Precision |
|
|
TaskCode |
String |
Yes |
50 |
|
|
|
Package Number |
Numeric |
Yes |
Min: 1 Max:32767 |
|
|
|
PackageStatusTypeId |
Numeric |
Yes |
- |
0 |
|
|
PackageStartDate |
Date |
Yes |
- |
|
|
|
PackageEndDate |
Date |
Yes |
- |
|
|
|
PackageEffectiveDate |
Date |
No |
- |
|
|
|
PackageLocationCode |
String |
No |
50 |
|
|
|
OrderLineNumber |
Numeric |
No |
- |
|
|
|
LocationCode |
String |
No |
50 |
|
|
|
OrderLineType |
String |
Yes |
50 |
|
|
|
VirtualAccountCode |
String |
Yes |
50 |
|
|
|
LaborFTE |
Numeric |
No |
- |
|
|
|
StartDate |
String |
No |
- |
|
|
|
EndDate |
String |
No |
- |
|
|
|
Dollars |
Numeric |
No |
- |
|
2 |
|
SubtaskCode |
String |
Yes |
50 |
|
|
|
ResponseLineType |
String |
Yes |
50 |
|
|
|
LaborClassCode |
String |
No |
50 |
|
|
|
LaborSubclassCode |
String |
No |
50 |
|
|
|
EmployeeCode |
String |
No |
50 |
|
|
|
StatusTypeId |
Numeric |
Yes |
- |
|
0 |
Available Import Header Commands
* This is the default behavior for file import processing of this table.
Page ID:5468-9315-9863