...
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 | ||
|---|---|---|
| ||
|
...
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 | 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 | 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. |
Usage Example(s)
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
<a:PoolItem>
<a:PoolItemId i:nil="true"/>
<a:PoolItemUid>1152921504606882533</a:PoolItemUid>
<a:Description>Hotel stay</a:Description>
<a:ExpenseTypeName>Personal Auto Mileage</a:ExpenseTypeName>
<a:IncurredAmount>9.12</a:IncurredAmount>
<a:IncurredAmountString>9.12</a:IncurredAmountString>
<a:IncurredDate>2018-03-01T00:00:00Z</a:IncurredDate>
<a:IncurredDateString>2018-03-01</a:IncurredDateString>
<a:IncurredOpsCurrencyCode>CAD</a:IncurredOpsCurrencyCode>
<a:IncurredVatAmount>0</a:IncurredVatAmount>
<a:IncurredVatAmountString>0</a:IncurredVatAmountString>
<a:LocationName>London</a:LocationName>
<a:NonBillableFlag>false</a:NonBillableFlag>
<a:NonBillableFlagString i:nil="true"/>
<a:NonImportedComment>-</a:NonImportedComment>
<a:OverrideClientAmount i:nil="true"/>
<a:OverrideClientAmountString i:nil="true"/>
<a:PayeeVendorName i:nil="true"/>
<a:ProjectCode>P001053-001</a:ProjectCode>
<a:ResourceDisplayName>Bruce Wayne</a:ResourceDisplayName>
<a:TotalAmountDisbursedCurrency>9.12</a:TotalAmountDisbursedCurrency>
<a:TotalAmountDisbursedCurrencyString>9.12</a:TotalAmountDisbursedCurrencyString>
<a:Udf1 xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
<b:BooleanValue i:nil="true"/>
<b:DateValue i:nil="true"/>
<b:IntegerValue i:nil="true"/>
<b:TextValue i:nil="true"/>
<b:RelationValue i:nil="true"/>
<b:NumericValue i:nil="true"/>
</a:Udf1>
<a:Udf1String i:nil="true"/>
<a:Udf2 xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
<b:BooleanValue>true</b:BooleanValue>
<b:DateValue i:nil="true"/>
<b:IntegerValue i:nil="true"/>
<b:TextValue i:nil="true"/>
<b:RelationValue i:nil="true"/>
<b:NumericValue i:nil="true"/>
</a:Udf2>
<a:Udf2String i:nil="true"/>
<a:Units>12</a:Units>
<a:UnitsString>12</a:UnitsString>
</a:PoolItem>
|