Overview
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 | ||
|---|---|---|
| ||
|
Elements
Element | Data Type | Required? | Default | Description | Sample Data |
|---|---|---|---|---|---|
PoolItemId | Int32 |
PoolItemUid
Int64
Description
String
ExpenseTypeName
String
IncurredAmount
Double
IncurredAmountString
String
IncurredDate
DateTime
IncurredDateString
String
IncurredOpsCurrencyCode
String
IncurredVatAmount
Double
IncurredVatAmountString
String
LocationName
String
NonBillableFlag
Boolean
NonBillableFlagString
String
NonImportedComment
String
OverrideClientAmount
Double
OverrideClientAmountString
String
PayeeVendorName
String
ProjectCode
String
ResourceDisplayName
String
TotalAmountDisbursedCurrency
Double
TotalAmountDisbursedCurrencyString
String
Udf1
Udf1String
String
Udf2
Udf2String
String
Units
Double
UnitsString
String
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>1152921504606847183<PoolItemUid>1152921504606882533</a:PoolItemUid>
<a:Description>MIXBOOK.COM: a photo album you love<Description>Hotel stay</a:Description>
<a:ExpenseTypeName>unit_item<ExpenseTypeName>Personal Auto Mileage</a:ExpenseTypeName>
<a:IncurredAmount i:nil="true"/>IncurredAmount>9.12</a:IncurredAmount>
<a:IncurredAmountString i:nil="true"/>IncurredAmountString>9.12</a:IncurredAmountString>
<a:IncurredDate>2012IncurredDate>2018-1103-28T0001T00:00:00Z</a:IncurredDate>
<a:IncurredDateString>2012IncurredDateString>2018-1103-28<01</a:IncurredDateString>
<a:IncurredOpsCurrencyCode i:nil="true"/>IncurredOpsCurrencyCode>CAD</a:IncurredOpsCurrencyCode>
<a:IncurredVatAmount i:nil="true"/>IncurredVatAmount>0</a:IncurredVatAmount>
<a:IncurredVatAmountString i:nil="true"/>IncurredVatAmountString>0</a:IncurredVatAmountString>
<a:LocationName i:nil="true"/>LocationName>London</a:LocationName>
<a:NonBillableFlag>false</a:NonBillableFlag>
<a:NonBillableFlagString i:nil="true"/>
<a:NonImportedComment i:nil="true"/>NonImportedComment>-</a:NonImportedComment>
<a:OverrideClientAmount i:nil="true"/>
<a:OverrideClientAmountString i:nil="true"/>
<a:PayeeVendorName i:nil="true"/>
<a:ProjectCode>P001038ProjectCode>P001053-001</a:ProjectCode>
<a:ResourceDisplayName>BarryResourceDisplayName>Bruce Allen<Wayne</a:ResourceDisplayName>
<a:TotalAmountDisbursedCurrency>-68TotalAmountDisbursedCurrency>9.59<12</a:TotalAmountDisbursedCurrency>
<a:TotalAmountDisbursedCurrencyString>-68TotalAmountDisbursedCurrencyString>9.59<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 i:nil="true" xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
<b:BooleanValue>true</b:BooleanValue>
<b:DateValue i:nil="true"/>
<a:Udf2String <b:IntegerValue i:nil="true"/>
<b:TextValue i:nil="true"/>
<b:RelationValue i:nil="true"/>
<a:Units <b:NumericValue i:nil="true"/>
</a:Udf2>
<a:UnitsStringUdf2String i:nil="true"/>
<a:Units>12</a:Units>
<a:UnitsString>12</a:UnitsString>
</a:PoolItem>
|