Import Specification:  Purchase Requests

Table Name: TransactionsPurchaseRequests 

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

No

50

Sub-Tasks

AccountCode

String

No

50

Accounts

FinancialMonthCode

FinancialMonth

Yes

6

Financial Months

RequestDate

Date

Yes

-


Dollars

Decimal

Yes

-


Units

Decimal

No

-


VendorCode

String

No

50

Vendors

PONumber

String

No

50


ContactName

String

No

50


Justification

String

No

300


Comment

String

No

300


Status

String

No

150


Custom1

String

No

100


Custom2

String

No

100


Custom3

String

No

100


Custom4

String

No

100


Custom5

String

No

100


SourceTransactionID

String

No

100



Available Import Header Commands


* This is the default behavior for file import processing of this table.


Page ID:8070-6994-7454