Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This structure contains the complete set of information about a resource's expense import pool item. The structure is used both to retrieve and pass detailed resource expense import pool item back to the server to get updated.

An expense import pool item represents data about incurred costs that has been extracted from a source (such as a comma separated file) but not yet used to create Projector cost cards. Many of the fields pertaining to incurred costs are stored in both a native format (e.g. date/time or double) and a string format. This is so that the actual values can be persisted in the string format even when the actual content could not be parsed into a native format (for example, an incurred date that was not in a valid date format).

Format

Panel
titlePwsResourceExpenseImportPoolItemDetail
  • PwsResourceExpenseImportPoolItemDetail
    • PoolItemId: Int32
    • PoolItemUid: Int64
    • Description: String (4000)
    • ExpenseTypeName: String (255)
    • IncurredAmount: Double
    • IncurredAmountString: String (255)
    • IncurredDate: DateTime
    • IncurredDateString: String (255)
    • IncurredOpsCurrencyCode: String (255)
    • IncurredVatAmount: Double
    • IncurredVatAmountString: String (255)
    • LocationName: String (255)
    • NonBillableFlag: Boolean (255)
    • NonBillableFlagString: String (255)
    • NonImportedComment: String (255)
    • OverrideClientAmount: Double
    • OverrideClientAmountString: String (255)
    • PayeeVendorName: String (255)
    • ProjectCode: String (255)
    • ResourceDisplayName: String (30)
    • TotalAmountDisbursedCurrency: Double
    • TotalAmountDisbursedCurrencyString: String (255)
    • Udf1: PwsCardUdfValue
    • Udf1String: String (255)
    • Udf2: PwsCardUdfValue
    • Udf2String: String (255)
    • Units: Double
    • UnitsString: String (255)

...

Element

Data Type

Required?

Default

Description

Sample Data

PoolItemId

Int32



The pool item Id is a unique identifier for an item. For internal use only.


PoolItemUid

Int64



The pool item Uid is a unique identifier for an item.


Description

String (4000)



The description of an item.

Dinner with one coworker

ExpenseTypeName

String (255)



The expense type name of an item.

Travel

IncurredAmount

Double



Incurred amount of an item in double format.

2.31

IncurredAmountString

String (255)



Incurred amount of an item in string format.

2.31

IncurredDate

DateTime



Incurred date of an item in date format.

2018-03-01T00:00:00Z

IncurredDateString

String (255)



Incurred date of an item in string format.

2018-03-01

IncurredOpsCurrencyCode

String (255)



The currency code of the incurred amount.

CAD

IncurredVatAmount

Double



Incurred Vat amount of an item in double format.

0

IncurredVatAmountString

String (255)



Incurred Vat amount of an item in string format.

0

LocationName

String (255)



The location name of an item.


NonBillableFlag

Boolean



The non billable flag of an item in boolean format. If set to 'true', this item is not billable.

false

NonBillableFlagString

String (255)



The non billable flag of an item in string format.


NonImportedComment

String (255)



A value that is not imported into a cost card but can be pulled from the source data to provide context.


OverrideClientAmount

Double



Override client amount of an item in double format.


OverrideClientAmountString

String (255)



Override client amount of an item in string format.


PayeeVendorName

String (255)



The name of the payee vendor of an item.


ProjectCode

String (255)



The project code of an item.

P001053-001

ResourceDisplayName

String (30)



The resource display name of an item.

Bruce Wayne

TotalAmountDisbursedCurrency

Double



Total amount (disbursed currency) in double format.

9.12

TotalAmountDisbursedCurrencyString

String (255)



Total amount (disbursed currency) in string format.

9.12

Udf1

PwsCardUdfValue



The value of the Udf1 of an item. Click here for more information.


Udf1String

String (255)



The value of the Udf1 of an item in string format.


Udf2

PwsCardUdfValue



The value of the Udf2 of an item. Click here for more information.


Udf2String

String (255)



The value of the Udf1 of an item in string format.


Units

Double



The unit number in double format. Applies to only unit based expense type.

12

UnitsString

String (255)



The unit number in string format.


...