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

Precision

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

-


2

Hours

Decimal

Yes

-


2

RevisionNumber

Numeric

Yes

Min: 0

Max: 9999


0

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