Skip to main content
EP

EPExpenseClaimForCurrentUser

PX.Objects.EP.DACRelease 2025.2

No summary is documented for this DAC in the release source.

Field NameTypeDisplay NameForeign Key
ApproveDate
datetimeApproval Date-
Description:The date when the claim was approved.
Approved
bit-
Description:Specifies (if set to "true") that the expense claim has been approved by a responsible person and is in the Approved status now.
ApprovedByIDDefault Navigation
intApproved ByContact
Description:The identifier of the contact who actually approved the document.
ApproverIDDefault Navigation
intApproverContact
Description:The identifier of the contact responsible for the document approval process. Corresponds to the Contact.ContactID field.
BranchIDDefault Navigation
intBranchBranch
Description:The branch of the claim. Corresponds to the value of the Branch.BranchID field.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
CuryDocBal
decimalClaim Total-
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.
CuryIDDefault Navigation
nvarchar(5)CurrencyCurrencyList
Description:The code of the currency of the document. Defaults to the company's base currency.
CuryInfoID
bigint-
Description:The identifier of the CurrencyInfo object associated with the document. Is generated automatically, and corresponds to the CurrencyInfo.CurrencyInfoID field.
CuryLineTotalNonexistent in DBObsolete
decimal?Detail Total-
Description:No description available
CuryTaxRoundDiff
decimalTax Discrepancy-
Description:The difference between the original document amount and the rounded amount in the selected currency.
CuryTaxTotal
decimalTax Total-
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)
CuryVatExemptTotal
decimalVAT Exempt Total-
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)
CuryVatTaxableTotal
decimalVAT Taxable Total-
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)
CustomerIDDefault Navigation
intCustomerCustomer
Description:The identifier of the Customer associated with the expense claim.
CustomerLocationIDDefault Navigation
intLocationLocation
Description:The identifier of the customer location associated with the document.
DepartmentIDDefault Navigation
nvarchar(10)Department IDEPDepartment
Description:The department associated with the expense claim. Corresponds to the value of the EPEmployee.DepartmentID field.
DocBal
decimal-
Description:The total amount of the claim in the base currency of the company. The amount is calculated as the sum of the amounts in the Claim Amount column for all lines specified for the claim, with taxes applied.
DocDate
datetimeDate-
Description:The date when the claim was entered.
DocDesc
nvarchar(256)Description-
Description:A description of the claim.
EmployeeIDDefault Navigation
intClaimed ByEPEmployee
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.
FinPeriodIDDefault Navigation
stringPost to PeriodFinPeriod
Description:The period to which the AP document should be posted. The selected period is copied to the Post Period box on the Bills and Adjustments form (AP301000) (which corresponds to the APInvoiceEntry graph) for the AP document created upon the release of the expense claim. Corresponds to the value of the FinPeriod.FinPeriodID field.
FormCaptionDescriptionNonexistent in DB
string-
Description:No description available
HasUseTaxNonexistent in DB
bool?-
Description:A Boolean value that indicates whether use taxes are applied to the document. This is a technical field, which is calculated on the fly and is used to restrict the values of the TaxCalcMode field.
HasWithHoldTaxNonexistent in DB
bool?-
Description:A Boolean value that indicates whether withholding taxes are applied to the document. This is a technical field, which is calculated on the fly and is used to restrict the values of the TaxCalcMode field.
Hold
bit-
Description:Specifies (if set to "true") that the expense claim is in the On Hold status, which means that the claim can be edited but cannot be release.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
LineTotalNonexistent in DBObsolete
decimal?-
Description:No description available
LocationIDDefault Navigation
intLocationLocation
Description:The location ID that is set to the AP bill created as a result of claim release. Corresponds to the value of the Location.LocationID field.
NoteID
uniqueidentifier-
Description:No description available
OwnerIDNonexistent in DB
int?-
Description:The Contact responsible for the document approval process. Corresponds to the Contact.ContactID field.
RefNbrDefault Navigation
nvarchar(15)Reference Nbr.EPExpenseClaim
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.
Rejected
bit-
Description:Specifies (if set to "true") that the expense claim has been rejected by a responsible person. When the claim is rejected, its status changes to Rejected.
Released
bitReleased-
Description:Specifies (if set to "true") that the expense claim was released and is in the Released status now.
SelectedNonexistent in DB
bool?-
Description:No description available
Status
nvarchar(1)Status-
Description:The status of the expense claim. The field can have one of the values described in EPExpenseClaimStatus.ListAttribute.
TaxCalcMode
char(1)Tax Calculation Mode-
Description:The tax calculation mode, which defines which amounts (tax-inclusive or tax-exclusive) should be entered in the detail lines of a document. This field is displayed only if the FeaturesSet.NetGrossEntryMode field is set to "true". The field can have one of the following values: ""T"" (Tax Settings): The tax amount for the document is calculated according to the settings of the applicable tax or taxes. ""G"" (Gross): The amount in the document detail line includes a tax or taxes. ""N"" (Net): The amount in the document detail line does not include taxes.
TaxRoundDiff
decimal-
Description:The difference between the original document amount and the rounded amount in the base currency.
TaxTotal
decimal-
Description:The total amount of taxes associated with the document in the base currency of the company. (Presented in the base currency of the company, see Company.BaseCuryID)
TaxZoneIDDefault Navigation
nvarchar(10)Tax ZoneTaxZone
Description:The tax zone associated with the branch. Corresponds to the value of the TaxZone.TaxZoneID field.
TranPeriodID
string-
Description:The financial period of the document. Is determined by the date of the document. Unlike EPExpenseClaim.FinPeriodID the value of this field can't be overridden by user.
VatExemptTotal
decimal-
Description:The document total (in the base currency of the company) 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 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 base currency of the company, see Company.BaseCuryID)
VatTaxableTotal
decimal-
Description:The document total (in the base currency of the company) 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 base currency of the company, see Company.BaseCuryID)
WorkgroupIDDefault Navigation
intApproval WorkgroupEPCompanyTreeOwner
Description:The workgroup that is responsible for the document approval process.
tstamp
timestamp-
Description:No description available