Time-Phased Baseline Plans
Import Specification: Time-Phased Baseline Plans
Table Name: TransactionsTimePhasedBaselinePlans
Table Type: Reporting
Current Import Version: 1.0
Data Specification
Field Name |
Requires Value? |
Max Length |
Related Table |
|
TaskCode |
String |
Yes |
50 |
|
SubTaskCode |
String |
Yes |
50 |
|
EffectiveFinancialMonthCode |
FinancialMonth |
Yes |
6 |
|
VirtualAccountCode |
CleanString |
Yes |
50 |
|
FinancialMonthCode |
FinancialMonth |
Yes |
6 |
|
EmployeeCode |
String |
No |
50 |
|
LaborClassCode |
String |
No |
50 |
|
LaborSubclassCode |
String |
No |
50 |
|
VendorCode |
String |
No |
50 |
|
Dollars |
Decimal |
Yes |
- |
|
Hours |
Decimal |
Yes |
- |
|
RevisionNumber |
Numeric |
Yes |
Min: 0 Max: 9999 |
|
Custom1 |
String |
No |
100 |
|
Custom2 |
String |
No |
100 |
|
Custom3 |
String |
No |
100 |
|
Custom4 |
String |
No |
100 |
|
Custom5 |
String |
No |
100 |
|
Custom6 |
String |
No |
100 |
|
Custom7 |
String |
No |
100 |
|
Custom8 |
String |
No |
100 |
|
Custom9 |
String |
No |
100 |
|
Custom10 |
String |
No |
100 |
|
SourceTransactionID |
String |
No |
100 |
|
Available Import Header Commands
- Overwrite
- Append *
- ReplaceByKey
- Available Fields
- TaskCode
- TaskCode,SubTaskCode
- FinancialMonthMapping
- Available Fields
- EffectiveFinancialMonthCode
- FinancialMonthCode
- Custom1
- Custom2
- Custom3
- Custom4
- Custom5
- Custom6
- Custom7
- Custom8
- Custom9
- Custom10
* This is the default behavior for file import processing of this table.
Page ID:3105-2149-5760