...
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 | On Insert: No On Update: No | The complete set of information regarding cost cards on this expense document | |||
DisbursedCurrencyIdentity | 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 | 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 | On Insert: No On Update: No | The invoice(s) associated with the expense document | |||
Locations | 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 | On Insert: No On Update: No | The payee vendor(s) associated with the expense document | |||
Projects | On Insert: No On Update: No | The project(s) associated with the expense document | |||
Receipts | On Insert: No On Update: No | The receipt(s) associated with the expense document | |||
TitleIdentity | On Insert: No On Update: No | The title(s) of the resource(s) with cost cards on the expense document | |||
Vouchers | 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 | 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 | 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 | 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 |
...