Stratus Aperture

API Family:Default

Version:20.200.001

DAC Mapping:PX.Objects.EP.EPExpenseClaim

Screen ID:EP301000

Properties

Select a row for its DAC field and description

	Property	Type	Data Type
	`ApprovalDate`	`DateTimeValue`	DateTime
DAC Field:`PX.Objects.EP.EPExpenseClaim.ApproveDate` Description:The date when the claim was approved.
	`ApprovalDetails`	`List`	Approval
DAC Field:Not mapped to a DAC field Description:No description available
	`BaseCurrencyID`	`StringValue`	string
DAC Field:`PX.Objects.CM.CurrencyInfo.BaseCuryID` Description:Identifier of the base Currency. Defaults to the base currency of the company.
	`ClaimedBy`	`StringValue`	string
DAC Field:`PX.Objects.EP.EPExpenseClaim.EmployeeID` Description:The identifier of the employee who claims the expenses. When the claim is released, an Accounts Payable bill will be generated for this employee. Corresponds to the value of the EPEmployee.bAccountID field.
	`ClaimTotal`	`DecimalValue`	decimal
DAC Field:`PX.Objects.EP.EPExpenseClaim.CuryDocBal` Description:The total amount of the claim in the currency of the document. The amount is calculated as the sum of the amounts in the Claim Amount column of the Expense Claim Details table located on the Expense Claim (EP301000) form for all lines specified for the claim with taxes applied.
	`CurrencyID`	`StringValue`	string
DAC Field:`PX.Objects.EP.EPExpenseClaim.CuryID` Description:The code of the currency of the document. Defaults to the company's base currency.
	`CurrencyRate`	`DecimalValue`	decimal
DAC Field:`PX.Objects.CM.CurrencyInfo.SampleCuryRate` Description:The exchange rate used for calculations and determined by the values of the CuryMultDiv, CuryRate and RecipRate fields.
	`CustomerID`	`StringValue`	string
DAC Field:`PX.Objects.EP.EPExpenseClaim.CustomerID` Description:The identifier of the Customer associated with the expense claim.
	`Date`	`DateTimeValue`	DateTime
DAC Field:`PX.Objects.EP.EPExpenseClaim.DocDate` Description:The date when the claim was entered.
	`DepartmentID`	`StringValue`	string
DAC Field:`PX.Objects.EP.EPExpenseClaim.DepartmentID` Description:The department associated with the expense claim. Corresponds to the value of the EPEmployee.DepartmentID field.
	`Description`	`StringValue`	string
DAC Field:`PX.Objects.EP.EPExpenseClaim.DocDesc` Description:A description of the claim.
	`Details`	`List`	ExpenseClaimDetails
DAC Field:Not mapped to a DAC field Description:No description available
	`FinancialDetails`	`ExpenseClaimFinancialDetail`	ExpenseClaimFinancialDetail
DAC Field:Not mapped to a DAC field Description:No description available
	`LastModifiedDateTime`	`DateTimeValue`	DateTime
DAC Field:`PX.Objects.EP.EPExpenseClaim.LastModifiedDateTime` Description:No description available
	`LocationID`	`StringValue`	string
DAC Field:`PX.Objects.EP.EPExpenseClaim.CustomerLocationID` Description:The identifier of the customer location associated with the document.
	`ReciprocalRate`	`DecimalValue`	decimal
DAC Field:`PX.Objects.CM.CurrencyInfo.SampleRecipRate` Description:The inverse of the SampleCuryRate. This value is also determined by the values of the CuryMultDiv, CuryRate and RecipRate fields.
	`RefNbr`	`StringValue`	string
DAC Field:`PX.Objects.EP.EPExpenseClaim.RefNbr` Description:The unique reference number of the expense claim document, which the system assigns based on the numbering sequence specified for claims on the Time and Expenses Preferences (EP101000) form (which corresponds to the EPSetupMaint graph). This field is the key field.
	`Status`	`StringValue`	string
DAC Field:`PX.Objects.EP.EPExpenseClaim.Status` Description:The status of the expense claim. The field can have one of the values described in EPExpenseClaimStatus.ListAttribute.
	`TaxDetails`	`List`	ExpenseClaimTaxDetail
DAC Field:Not mapped to a DAC field Description:No description available
	`TaxTotal`	`DecimalValue`	decimal
DAC Field:`PX.Objects.EP.EPExpenseClaim.CuryTaxTotal` Description:The total amount of taxes associated with the document in the currency of the document. (Presented in the currency of the document, see CuryID)
	`VATExemptTotal`	`DecimalValue`	decimal
DAC Field:`PX.Objects.EP.EPExpenseClaim.CuryVatExemptTotal` Description:The document total (in the currency of the document) that is exempt from VAT. This total is calculated as the taxable amount for the tax with the Include in VAT Exempt Total check box selected on the Taxes (TX205000) form. This box is available only if the VAT Reporting feature is enabled on the Enable/Disable Features (CS100000) form (which corresponds to the FeaturesMaint graph). (Presented in the currency of the document, see CuryID)
	`VATTaxableTotal`	`DecimalValue`	decimal
DAC Field:`PX.Objects.EP.EPExpenseClaim.CuryVatTaxableTotal` Description:The document total (in the currency of the document) that is subject to VAT. This box is available only if the VAT Reporting feature is enabled on the Enable/Disable Features (CS100000) form (which corresponds to the FeaturesMaint graph). The VAT taxable amount is displayed in this box only if the Include in VAT Taxable Total check box is selected for the applicable tax on the Taxes (TX205000) form (which corresponds to the SalesTaxMaint graph). If the check box is cleared, this box will be empty. (Presented in the currency of the document, see CuryID)

Minimum Payload

Derived from static analysis of the 2025.2 source; runtime configuration may require additional fields.

{
  "CurrencyRate": {
    "value": 0
  },
  "Description": {
    "value": "string"
  },
  "Details": [
    {
      "Description": {
        "value": "string"
      },
      "ExpenseAccount": {
        "value": "string"
      },
      "ExpenseItemID": {
        "value": "string"
      },
      "ExpenseSubaccount": {
        "value": "string"
      },
      "UOM": {
        "value": "string"
      }
    }
  ]
}

For every property this entity accepts, see the properties table.

Details is the detail-lines collection (ExpenseClaimDetails); one example row is included above because a document usually has lines, and each row needs DescriptionExpenseAccountExpenseItemIDExpenseSubaccountUOM of its own.

Optional Children

None of these child collections is required — a payload without them is valid. If you do include one, these are the fields each row of it needs; keys the parent record supplies are named separately and must not be sent.

TaxDetailsa list of ExpenseClaimTaxDetailrequired if you include one:TaxID

Available in Versions

25.200.001 24.200.001 23.200.001 22.200.001 20.200.001