EPExpenseClaim

PX.Objects.EP

View API Entity: ExpenseClaim/entity/Default/24.200.001/ExpenseClaim

48 of 48 fields

	Field Name	Type	Display Name	Foreign Key
	`RefNbr` API Default Navigation	`nvarchar(15)`	Reference Nbr.	-
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.
	`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.
	`ApproveDate`	`datetime2`	Approval Date	-
Description:The date when the claim was approved.
	`ApprovedByID`Default Navigation	`int`	Approved By	Contact
Description:The identifier of the contact who actually approved the document.
	`ApproverID`Default Navigation	`int`	Approver	Contact
Description:No description available
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`CuryDocBal`	`decimal(19, 4)`	Claim 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.
	`CuryID`Default Navigation	`nvarchar(5)`	Currency	CurrencyList
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.
	`CuryLineTotal`Nonexistent in DBObsolete	`decimal`	Detail Total	-
Description:No description available
	`CuryTaxRoundDiff`	`decimal(19, 4)`	Tax Discrepancy	-
Description:The difference between the original document amount and the rounded amount in the selected currency.
	`CuryTaxTotal`	`decimal(19, 4)`	Tax 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`	`decimal(19, 4)`	VAT 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`	`decimal(19, 4)`	VAT 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)
	`CustomerID` API Default Navigation	`int`	Customer	Customer
Description:The identifier of the Customer associated with the expense claim.
	`CustomerLocationID`Default Navigation	`int`	Location	Location
Description:The identifier of the customer location associated with the document.
	`DepartmentID` API Default Navigation	`nvarchar(10)`	Department ID	EPDepartment
Description:The department associated with the expense claim. Corresponds to the value of the EPEmployee.DepartmentID field.
	`DocBal`	`decimal(19, 4)`		-
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`	`datetime2`	Date	-
Description:The date when the claim was entered.
	`DocDesc`	`nvarchar(256)`	Description	-
Description:A description of the claim.
	`EmployeeID`Default Navigation	`int`	Claimed By	EPEmployee
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.
	`FinPeriodID`Default Navigation	`char(6)`	Post to Period	-
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.
	`HasUseTax`Nonexistent in DB	`bit`		-
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.
	`HasWithHoldTax`Nonexistent in DB	`bit`		-
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.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime` API	`datetime`		-
Description:No description available
	`LineTotal`Nonexistent in DBObsolete	`decimal`		-
Description:No description available
	`LocationID` API Default Navigation	`int`	Location	Location
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
	`OwnerID`Nonexistent in DB	`int`		-
Description:The Contact responsible for the document approval process. Corresponds to the Contact.ContactID 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`	`bit`	Released	-
Description:Specifies (if set to "true") that the expense claim was released and is in the Released status now.
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:No description available
	`Status` API	`char(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(19, 4)`		-
Description:The difference between the original document amount and the rounded amount in the base currency.
	`TaxTotal` API	`decimal(19, 4)`		-
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)
	`TaxZoneID`Default Navigation	`nvarchar(10)`	Tax Zone	TaxZone
Description:No description available
	`TranPeriodID`	`char(6)`		-
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.
	`tstamp`	`timestamp`		-
Description:No description available
	`VatExemptTotal` API	`decimal(19, 4)`		-
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` API	`decimal(19, 4)`		-
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)
	`WorkgroupID`Default Navigation	`int`	Approval Workgroup	EPCompanyTreeOwner
Description:The workgroup that is responsible for the document approval process.