ExportCostCards

Request

The service request contains:

Name

Data Type

Required?

Default Value

Discussion

MinIncurredDate

date

no

 

Export is limited to cards no earlier than this date.

MaxIncurredDate

date

no

 

Export is limited to cards no later than this date.

ApprovedMinTimestamp

dateTime

no

 

Export is limited to cards approved on or after this time. To avoid skipping or duplicating cards set this to the last ApprovedTimestamp from the previous result set.

ApprovedIdsAfter

int

no

0

Export is limited to cards with a ReferenceSystemId greater than this. Note that Projector assigns a ReferenceSystemId that is greater than any previously assigned value. To avoid skipping or duplicating cards set this to the last ReferenceSystemId from the previous result set.

MaxRowsToReturn

int

no

1000

The maximum number of cards to be exported. Values greater than 1000 may fail due to system-enforced transaction time limits.

CurrencyCode

string

no

 

If the currency is not specified, then monetary amounts are returned in the engagement currency.

IncludeBillableOnly

boolean

no

false

If true, include billable cost cards only.

OnlyCountRows

boolean

no

false

If true, then only the RowCount is returned.


Response

For each card in the result set the following data is returned:

Name

Data Type

Discussion

ApprovedTimestamp

dateTime

Time at which the card was approved.

ReferenceSystemId

int

Unique integer identifying the card.

ProjectCode

string

Unique code identifying the project

ExpenseReportNumber

string

Identifies the expense report that the card is assigned to. Null if the cost card is not associated with an expense report.

ExpenseReportName

string

Description attached to the cost card

ResourceReferenceSystemId

string

Unique code identifying the resource.

IncurredDate

date

Date for which the cost was reported.

CostCodeName

string

Name of the expense type for the cost card

Description

string

Description of the cost

DisbursedAmount

double

In the currency indicated by CurrencyCode

ClientAmount

double

In the currency indicated by CurrencyCode

RevenueAmount

double

In the currency indicated by CurrencyCode

ExpenseAmount

double

In the currency indicated by CurrencyCode

CurrencyCode

string

Currency of the reported monetary amounts. This is either the engagement currency (if no currency is specified in the request) or the specified currency.

DisbursedAmountDisbursedCurrency

double

Disbursed amount in the disbursing currency

VATAmountDisbursedCurrency

double

VAT amount in the disbursing currency

TotalAmountDisbursedCurrency

double

Total amount (DisbursedAmountDisbursedCurrency + VATAmountDisbursedCurrency)in the disbursing currency

DisbursedCurrencyCode

string

Disbursing currency code

LocationName

string

Location name

CostCardUnits

double

Units (for mileage and unit driven costs)

NonBillableFlag

boolean

True if cost card has been marked non-billable

CostCardUid

int

Unique identifier for cost card

ResourceDisplayName

string

Resource display name

PayeeVendorNumber

string

Payee vendor number

PayeeVendorName

string

Payee vendor name

ExpenseDocumentuid

int

Unique identifier for expense document containing cost card

VendorUid

int

Unique identifier for payee vendor

CostCenteruid

int

Unique identifier for expense document's disbursing cost center