Page Comparison

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 the cost cards card(s) 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 the 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 cost card(s) on this expense document

Locations

PwsLocationSummary

On Insert: No

On Update: No

The location(s) associated with the cost card(s) on this 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 the cost card(s) on this expense document or the entire 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 cost card(s) 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 cost card(s) on this 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 . The "partial" status will take on adopt the status of the cost card with the highest level of status (i.e. Partially Rejected, Partially Submitted or Partially Approved)

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

"PR" - Partially Rejected (- one or more cost cards (but not all) in the expense document is in Rejected status)Rejected (has a status of Rejected

"R" - Rejected - all cost cards in the expense document are in Rejected status)Partially Submitted (has a status of Rejected

"PS" - Partially Submitted - one or more cost cards (but not all) in the expense document is in Submitted status)Submitted (has a status of Submitted

"S" - Submitted - all cost cards in the expense document are in Submitted status)Partially Approved (has a status of Submitted

"PA" - Partially Approved - one or more cost cards (but not all) in the expense document is in Approved status)Approved (has a status of Approved

"A" - Approved - all cost cards in the expense document are in Submitted status)has a status of Approved

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 (but not all) in the expense document is in Rejected status)have a status of Rejected

"R" for - Rejected (- all cost cards in the expense document are in Rejected status)have a status of Rejected

"PS" for - Partially Submitted (- one or more cost cards (but not all) in the expense document is in Submitted status)have a status of Submitted

"S" for - Submitted (- all cost cards in the expense document are in Submitted status)have a status of Submitted

"PA" for - Partially Approved (- one or more cost cards (but not all) in the expense document is in Approved status)have a status of Approved

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

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 If an expense document cannot be deleted, this code indicates the reason:

"LOK" - The expense document is locked. This could be the result of multiple reasons including the presence of an approved cost card.

"PRM" - The user attempting to edit the expense document lacks permission

Null - Unknown reason

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)

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 approved- Not approved - all cost cards in the expense document have not been approved to invoice

"PA" for - Partially Approved - one or more cost cards (but not all) in the expense document have been approved to invoice

"A" for Approved- Approved - all cost cards in the expense document have been approved to invoice

"PI" for - Partially Invoiced (Draft) - one or more cost cards (but not all) in the expense document is on a Draft invoice

"I" for - Invoiced (Draft) - all cost cards in the expense document is on a draft invoice

"PB" for Partially Invoiced"B" for Invoiced- Partially Invoiced - one or more cost cards (but not all) in the expense document is on an issued invoice

"B" - Invoiced -all cost cards in the expense document is on an issued invoice

MaintainExpenseDocumentUnavailableReason

String

On Insert: No

On Update: No

If an expense document cannot be maintained/updated, this code indicates the reason:

"LOK" - The expense document is locked. This could be the result of multiple reasons including the presence of an approved cost card.

"PRM" - The user attempting to edit the expense document lacks permission

Null - Unknown reason

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 - all cost cards in the expense document have not been approved to pay

"PA" for - Partially Approved - one or more cost cards (but not all) in the expense document have been approved to pay

"A" for Approved- Approved - all cost cards in the expense document have not been approved

"PT" for Partially Transmitted- Partially Transmitted - one or more cost cards (but not all) in the expense document have been transmitted to an accounting system (i.e. Great Plains)

"T" for Transmitted

"R" for Received

"PR" for Partially Received- Transmitted - all cost cards in the expense document have been transmitted to an accounting system (i.e. Great Plains)

"PR" - Partially Received - one or more cost cards (but not all) in the expense document have been received by the vendor/resource

"R" - Received - all cost cards in the expense document have been received by the vendor/resource

ViewInExpenseEntryFlag

Boolean

On Insert: No

On Update: No

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