Import Specification:  Time-Phased Baseline Plans

Table Name: TransactionsTimePhasedBaselinePlans 

Table Type:  Reporting

Current Import Version: 1.0


Data Specification

Field Name

Data Type

Requires Value?

Max Length

Related Table

TaskCode

String

Yes

50

Tasks

SubTaskCode

String

Yes

50

Sub-Tasks

EffectiveFinancialMonthCode

FinancialMonth

Yes

6

Financial Months

VirtualAccountCode

CleanString

Yes

50

Virtual Accounts

FinancialMonthCode

FinancialMonth

Yes

6

Financial Months

EmployeeCode

String

No

50

Employees

LaborClassCode

String

No

50

Labor Classes

LaborSubclassCode

String

No

50

Labor Subclasses

VendorCode

String

No

50

Vendors

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