Versions Compared

Key

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

...

Element

Data Type

Required?

Default

Description

Sample Data

AllowAttachReceiptsToCcFlag

Boolean

On Insert: No

On Update: No

Dependent on installation setting



AllowAttachReceiptsToEdFlag

Boolean

On Insert: No

On Update: No

Dependent on installation setting



CostCards

PwsCostCardElement[]

On Insert: No

On Update: No


The complete set of information regarding cost cards on this expense document


DisbursedCurrencyIdentity

PwsCurrencyRef

On Insert: Yes

On Update: No


The currency associated with disbursed amount on this expense document


DocumentCount

Int32

On Insert: No

On Update: No


The number of receipts attached to this expense document 


ExpenseDocumentDetail

PwsExpenseDocumentDetail

On Insert: Yes

On Update: Yes


The complete set of information regarding cost cards on this expense document


ExpenseDocumentVatFlag

Boolean

On Insert: No

On Update: No

false

If set to 'true', the expense document includes VAT (value added tax)


Invoices

PwsExpenseEntryInvoice

On Insert: No

On Update: No


The invoice(s) associated with the expense document


Locations

PwsLocationSummary

On Insert: No

On Update: No


The location(s) associated with the expense document


LockedFlag

Boolean

On Insert: No

On Update: No

false

If set to 'true', the expense document is locked


NoteCount

Int32

On Insert: No

On Update: No


The number of receipt notes attached to this expense document


PayeeVendors

PwsVendorSummary

On Insert: No

On Update: No


The payee vendor(s) associated with the expense document


Projects

PwsExpenseEntryProject

On Insert: No

On Update: No


The project(s) associated with the expense document


Receipts

PwsReceiptDetail

On Insert: No

On Update: No


The receipt(s) associated with the expense document


TitleIdentity

PwsTitleRef

On Insert: No

On Update: No


The title(s) of the resource(s) with cost cards on the expense document


Vouchers

PwsPaymentVoucherSummary[]

On Insert: No

On Update: No


The payment voucher(s) associated with the expense document


AllowCloneFlag

Boolean

On Insert: No

On Update: No

This is dependent on permission settings

If set to 'true', this expense document can be cloned


AllowDeleteFlag

Boolean

On Insert: No

On Update: No

This is dependent on the expense document status. Expense documents that have a status of partially approved or higher cannot be deleted.

If set to 'true', this expense document can be deleted


Category

String

On Insert: No

On Update: No


The category the expense document falls under in Projector Web's expense document landing page. When the cost cards in the expense document have different statuses, the expense document will have a partial status, the "partial" status will take on the highest level status (i.e. Partially Rejected, Partially Submitted or Partially Approved)

Draft (all cost cards in the expense document are in Draft status)

Partially Rejected (one or more cost cards in the expense document is in Rejected status)

Rejected (all cost cards in the expense document are in Rejected status)

Partially Submitted (one or more cost cards in the expense document is in Submitted status)

Submitted (all cost cards in the expense document are in Submitted status)

Partially Approved (one or more cost cards in the expense document is in Approved status)

Approved (all cost cards in the expense document are in Submitted status)


CreatedByUser

PwsUserSummary

On Insert: No

On Update: No


The identity of the user who created the expense document


CreatedTimestamp

DateTime

On Insert: No

On Update: No


The date and time this expense document was created (in UTC format)


LastUpdatedByUser

PwsUserSummary

On Insert: No

On Update: No


The identity of the user who last updated the expense document


LastUpdatedTimestamp

DateTime

On Insert: No

On Update: No


The date and time this expense document was last updated (in UTC format)


PaymentVoucherItems

PwsPaymentVoucherItem[]

On Insert: No

On Update: No


The payment voucher(s) associated with this expense document


Status

String

On Insert: No

On Update: No


The status of the expense document


DisbursedCurrencyDecimalDigits

Byte

On Insert: No

On Update: No


The number of decimal places displayed and stored with the disbursed amount


MileageUom

String

On Insert: No

On Update: No


The unit of measure associated with mileage expense types (i.e. miles / kilometers)


ExpenseDocumentLockedFlag

Boolean

On Insert: No

On Update: No


If set to 'true', the expense document is locked


ApprovalWorkflowStatus

String

On Insert: No

On Update: No


The expense document's approval workflow status. When the cost cards in the expense document have different approval workflow statuses, the expense document will have a partial approval workflow status, the "partial" status will take on the highest level status (i.e. Partially Rejected, Partially Submitted or Partially Approved)

"D" for Draft (all cost cards in the expense document are in Draft status)

"PR" for Partially Rejected (one or more cost cards in the expense document is in Rejected status)

"R" for Rejected (all cost cards in the expense document are in Rejected status)

"PS" for Partially Submitted (one or more cost cards in the expense document is in Submitted status)

"S" for Submitted (all cost cards in the expense document are in Submitted status)

"PA" for Partially Approved (one or more cost cards in the expense document is in Approved status)

"A" for Approved (all cost cards in the expense document are in Submitted status)


CostCardTotalDisbursedAmount

Double

On Insert: No

On Update: No


The expense document's total disbursed amount


DeleteExpenseDocumentUnavailableReason

String

On Insert: No

On Update: No




DueToOtherPayeesAmount

Double

On Insert: No

On Update: No


The amount due to be paid back to a payee other than the resource associated with the expense document (i.e. a third party / company credit card)

"N" for Not approved

"PA" for Partially Approved

"A" for Approved

"P.." for Partially Invoiced (Draft)

".." for Invoiced (Draft)

"P" for Partially Invoiced

.. for Invoiced


InvoiceWorkflowStatus

String

On Insert: No

On Update: No


The expense document's invoice workflow status. When the cost cards in the expense document have different invoice workflow statuses, the expense document will have a partial invoice workflow status, the "partial" status will take on the highest level status (i.e. Partially Approved, Partially Transmitted, Partially Paid or Partially Received)

"N" for Not Approvedapproved

"PA" for Partially Approved

"A" for Approved

"PTPI" for Partially TransmittedInvoiced (Draft)

"TI" for TransmittedInvoiced (Draft)

"RPB" for ReceivedPartially Invoiced

"PRB" for Partially ReceivedInvoiced


MaintainExpenseDocumentUnavailableReason

String

On Insert: No

On Update: No




PaymentWorkflowStatus

String

On Insert: No

On Update: No


The expense document's payment workflow status. When the cost cards in the expense document have different payment workflow statuses, the expense document will have a partial payment workflow status, the "partial" status will take on the highest level status (i.e. Partially Approved, Partially Transmitted, Partially Paid or Partially Received)

"N" for Not Approved

"PA" for Partially Approved

"A" for Approved

"PT" for Partially Transmitted

"T" for Transmitted

"R" for Received

"PR" for Partially Received


ViewInExpenseEntryFlag

Boolean

On Insert: No

On Update: No


If set to 'true', this expense document can be viewed in Projector Web's Expense Entry


...