EPExpenseClaimDetails

PX.Objects.EP

106 of 106 fields

	Field Name	Type	Display Name	Foreign Key
	`ClaimDetailCD`Default Navigation	`nvarchar(15)`	Receipt Number	-
Description:The user-friendly unique identifier of the receipt.
	`APDocType`	`char(3)`	AP Document Type	-
Description:The type of ARPdocument created as a result of releasing a claim. The field can have one of the values described in APDocType.ListAttribute.
	`APLineNbr`	`int`	AP Document Line Nbr.	APTran
Description:The number of the AP document line created as a result of releasing an expense claim.
	`Approved`	`bit`		-
Description:Specifies (if set to "true") that the expense receipt has been approved by a responsible person and has the Approved status.
	`APRefNbr`Default Navigation	`nvarchar(15)`	AP Reference Nbr.	APInvoice
Description:The reference number of the AR document created as a result of releasing a claim.
	`ARDocType`	`char(3)`	AR Doument Type	-
Description:The type of AR document created as a result of billing a claim. The field can have one of the values described in ARDocType.ListAttribute.
	`ARRefNbr`Default Navigation	`nvarchar(15)`	AR Reference Nbr.	ARInvoice
Description:The reference number of the AR document created as a result of billing a claim.
	`BankTranDate`	`datetime2`		-
Description:The CA bank transaction date.
	`Billable`	`bit`	Billable	-
Description:Indicates (if set to "true") that the customer should be billed for the claim amount. You can use the Bill Expense Claims (EP502000) form to bill the customer if no project is specified.
	`Billed`	`bit`	Billed	-
Description:Indicates (if set to "true") that current receipt was billed.
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:The company branch that will incur the expenses. If multiple expense receipts associated with different branches are added to one expense claim, the branch specified for the claim on the Financial Details tab of the Expense Claim (EP301000) form (which corresponds to the ExpenseClaimEntry graph) will reimburse the expenses and the branches specified in this box for the receipts will incur the expenses.
	`CardCuryID`	`nvarchar(5)`	CardCuryID	-
Description:The currency of the corporate card.
	`CardCuryInfoID`	`bigint`		-
Description:The identifier of the CurrencyInfo record that stores exchange rate from the corporate card currency to the base currency.
	`ClaimCuryInfoID`	`bigint`		-
Description:The code of the currency of the claim in which the current receipt is included. Defaults to the company's base currency.
	`ClaimCuryTaxRoundDiff`	`decimal(19, 4)`		-
Description:The difference between the original document amount and the rounded amount in the expense claim currency.
	`ClaimCuryTaxTotal`	`decimal(19, 4)`	Amount in Claim Curr.	-
Description:The total amount (in the currency of the expense claim) of taxes that are associated with the document.
	`ClaimCuryTranAmt`	`decimal(19, 4)`	Amount in Claim Curr.	-
Description:The amount to be reimbursed to the employee, which is calculated as the difference between the total amount and the employee part in the currency of the claim in which the current receipt is included.
	`ClaimCuryTranAmtWithTaxes`	`decimal(19, 4)`	Amount in Claim Curr.	-
Description:The amount claimed by the employee, which is expressed in the currency of the expense claim.
	`ClaimCuryVatExemptTotal`	`decimal(19, 4)`		-
Description:The document total that is exempt from VAT in the expense claim currency. This total is calculated as the taxable amount for the tax with the Tax.ExemptTax field set to (that is, with the Include in VAT Exempt Total check box selected on the Taxes (TX205000) form).
	`ClaimCuryVatTaxableTotal`	`decimal(19, 4)`		-
Description:The document total that is subjected to VAT in the expense claim currency. The field is displayed only if the Tax.IncludeInTaxable field is set to (that is, the Include in VAT Exempt Total check box is selected on the Taxes (TX205000) form).
	`ClaimDetailID`	`int`	Receipt Number	-
Description:The identifier of the receipt record in the system, which the system assigns automatically when you save a newly entered receipt. This field is the key field.
	`ClaimTaxRoundDiff`	`decimal(19, 4)`		-
Description:The difference between the original document amount and the rounded amount in the base currency of the tenant for the claim in which the current receipt is included.
	`ClaimTaxTotal`	`decimal(19, 4)`	Amount in Claim Original	-
Description:The total amount of taxes (in the base currency of the tenant) for the claim in which the current receipt is included.
	`ClaimTranAmt`	`decimal(19, 4)`	Amount in Claim Original	-
Description:The amount to be reimbursed to the employee, which is calculated as the difference between the total amount and the employee part in the base currency of the company of the claim in which the current receipt is included.
	`ClaimTranAmtWithTaxes`	`decimal(19, 4)`	Amount in Claim Original	-
Description:The amount (in the base currency of the tenant) that the employee has specified in the claim in which the current receipt is included.
	`ClaimVatExemptTotal`	`decimal(19, 4)`		-
Description:The document total that is exempt from VAT in the base currency of the tenant for the claim in which the current receipt is included.
	`ClaimVatTaxableTotal`	`decimal(19, 4)`		-
Description:The document total that is subjected to VAT in the base currency of the tenant for the claim in which the current receipt is included.
	`ContractID`Default Navigation	`int`	Project/Contract	PMProject
Description:No description available
	`CorpCardID`Default Navigation	`int`	Corporate Card	CACorpCard
Description:No description available
	`CostCodeID`Default Navigation	`int`	Cost Code	PMCostCode
Description:The identifier of the cost code associated with the record.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`CreatedFromClaim`	`bit`	Created from Claim	-
Description:A Boolean value that indicates whether an expense receipt was created from an expense claim.
	`CuryAmountWithTaxes`	`decimal(19, 4)`		-
Description:The amount of the expense receipt with taxes in the currency of the document.
	`CuryEmployeePart`	`decimal(19, 6)`	Employee Part	-
Description:The part of the total amount that will not be paid back to the employee in the currency of the document.
	`CuryExtCost`	`decimal(19, 6)`	Amount	-
Description:The total amount of the receipt in the currency of the document.
	`CuryID`Default Navigation	`nvarchar(5)`	Currency	CurrencyList
Description:The code of the currency of the document. By default, the receipt currency is the currency specified as the default for the employee. 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.
	`CuryNetAmount`Nonexistent in DB	`decimal`	Net Amount	-
Description:The net amount in the currency of the document.
	`CuryTaxableAmt`	`decimal(19, 4)`		-
Description:The taxable amount in the currency of the document.
	`CuryTaxableAmtFromTax`	`decimal(19, 4)`		-
Description:The taxable amount in the currency of the document.
	`CuryTaxAmt`	`decimal(19, 4)`		-
Description:The tax amount to be paid for the document in the document currency.
	`CuryTaxRoundDiff`	`decimal(19, 4)`	Tax Discrepancy	-
Description:The difference between the original document amount and the rounded amount in the selected currency.
	`CuryTaxTipTotal`Nonexistent in DB	`decimal`		-
Description:A fake field for correct working a Tax attribute. Always must be zero because a tip is tax exempt. The total amount of tips taxes associated with the document in the currency of the document.
	`CuryTaxTotal`	`decimal(19, 4)`	Tax Total	-
Description:The total amount of taxes associated with the document in the currency of the document.
	`CuryTipAmt`	`decimal(19, 4)`	Tip Amount	-
Description:No description available
	`CuryTranAmt`	`decimal(19, 4)`	Claim Amount	-
Description:The amount to be reimbursed to the employee, which is calculated as the difference between the total amount and the employee part in the currency of the document.
	`CuryTranAmtWithTaxes`	`decimal(19, 4)`	Claim Amount	-
Description:The amount to be reimbursed to the employee in the currency of the document.
	`CuryUnitCost`	`decimal(19, 6)`	Unit Cost	-
Description:The cost of one unit of the expense item in the currency of the document. If a standard cost is specified for the expense non-stock item, the standard cost is used as the default unit cost.
	`CuryVatExemptTotal`	`decimal(19, 4)`		-
Description:The document total that is exempt from VAT in the selected currency. This total is calculated as the taxable amount for the tax with the Tax.ExemptTax field set to (that is, with the Include in VAT Exempt Total check box selected on the Taxes (TX205000) form).
	`CuryVatTaxableTotal`	`decimal(19, 4)`		-
Description:The document total that is subjected to VAT in the selected currency. The field is displayed only if the Tax.IncludeInTaxable field is set to (that is, the Include in VAT Exempt Total check box is selected on the Taxes (TX205000) form).
	`CustomerID`Default Navigation	`int`	Customer	Customer
Description:No description available
	`CustomerLocationID`Default Navigation	`int`	Location	Location
Description:No description available
	`EmployeeID`Default Navigation	`int`	Claimed by	EPEmployee
Description:The identifier of the employee who is claiming the expenses. Corresponds to the value of the EPEmployee.bAccountID field.
	`EmployeePart`	`decimal(19, 6)`	Original Employee Part	-
Description:The part of the total amount that will not be paid back to the employee in the base currency of the company.
	`ExpenseAccountID`Default Navigation	`int`	Expense Account	Account
Description:No description available
	`ExpenseDate`	`datetime2`	Date	-
Description:The date of the receipt. By default, the current business date is used when a new receipt is created.
	`ExpenseRefNbr`	`nvarchar(40)`	Ref. Nbr.	-
Description:The reference number, which usually matches the number of the original receipt.
	`ExpenseSubID`Default Navigation	`int`	Expense Sub.	Sub
Description:The corresponding subaccount the system uses to record the part of the expense to be paid back to the employee. The segments of the expense subaccount are combined according to the settings specified on the Time and Expenses Preferences (EP101000) form.
	`ExtCost`	`decimal(19, 6)`	Original Total Amount	-
Description:The total amount of the receipt in the base currency of the company.
	`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`	Hold	-
Description:Specifies (if set to "true") that the expense receipt has the On Hold status, which means that the receipt can be edited but cannot be added to a claim and released.
	`HoldClaim`Nonexistent in DB	`bit`	HoldClaim	-
Description:No description available
	`InventoryID`Default Navigation	`int`	Expense Item	InventoryItem
Description:The non-stock item of the expense, which determines the financial accounts, the default tax category, and the unit of measure used for the receipt.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`		-
Description:No description available
	`LegacyReceipt`	`bit`		-
Description:A Boolean value that indicates whether the expense receipt was created in a previous version of Acumatica ERP. Taxes for this receipt will be calculated on update of the Tax Zone, Tax Category, Tax Calculation Mode, or Amount fields.
	`NetAmount`Nonexistent in DB	`decimal`		-
Description:The net amount in the base currency of the tenant.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OwnerID`Default Navigation	`int`	Owner	Contact
Description:The Contact responsible for the document approval process. Corresponds to the Contact.ContactID field.
	`PaidWith`	`varchar(8)`	Paid With	-
Description:The way the expense receipt has been paid. The field can have one of the following values: - "PersAcc": Personal Account - "CardComp": Corporate Card, Company Expense - "CardPers": Corporate Card, Personal Expense
	`Qty`	`decimal(25, 6)`	Quantity	-
Description:The quantity of the expense item that the employee purchased according to the receipt. The quantity is expressed in the unit of measure specified for the selected expense non-stock item.
	`RefNbr`Default Navigation	`nvarchar(15)`	Expense Claim Ref. Nbr.	EPExpenseClaim
Description:The reference number, which usually matches the number of the original receipt.
	`RefNbrNotFiltered`Default NavigationNonexistent in DB	`nvarchar(15)`		-
Description:The service field that is used in PXFormula for the HoldClaim and StatusClaim fields, which don't need restrictions of original RefNbr in a selector.
	`Rejected`	`bit`		-
Description:Specifies (if set to "true") that the expense receipt has been rejected by a responsible person. When the receipt is rejected, its status changes to Rejected.
	`Released`	`bit`	Released	-
Description:Specifies (if set to "true") that the expense receipt was released and has the Released status.
	`SalesAccountID`Default Navigation	`int`	Sales Account	Account
Description:The sales account to which the system records the part of the amount to charge the customer for. If the Billable check box is selected, the sales account specified for the expense non-stock item is filled in by default.
	`SalesSubID`Default Navigation	`int`	Sales Sub.	Sub
Description:The corresponding subaccount the system uses to record the amount to charge the customer for. If the Billable check box is selected, the sales subaccount specified for the expense non-stock item is filled in by default. The segments of the sales subaccount are combined according to the settings specified on the Time and Expenses Preferences (EP101000) form.
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:No description available
	`Status`	`char(1)`	Status	-
Description:The status of the expense receipt. The field can have one of the values described in EPExpenseClaimDetailsStatus.ListAttribute.
	`StatusClaim`Nonexistent in DB	`nchar(1)`	Expense Claim Status	-
Description:No description available
	`SubmitedDate`	`datetime`		-
Description:The date when the expense receipt was included in the expense claim.
	`TaskID`Default Navigation	`int`	Project Task	PMTask
Description:The project task to which the expenses are related. This box is available only if the Project Management feature is enabled on the Enable/Disable Features (CS100000) form.
	`TaxableAmt`	`decimal(19, 4)`		-
Description:The taxable amount in the base currency of the tenant.
	`TaxableAmtFromTax`	`decimal(19, 4)`		-
Description:The taxable amount in the base currency of the tenant.
	`TaxAmt`	`decimal(19, 4)`		-
Description:The tax amount to be paid for the document in the base currency of the tenant.
	`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.
	`TaxCategoryID`Default Navigation	`nvarchar(15)`	Tax Category	TaxCategory
Description:The tax category associated with the expense item. Corresponds to the value of the TaxCategory.TaxCategoryID field.
	`TaxRoundDiff`	`decimal(19, 4)`		-
Description:The difference between the original document amount and the rounded amount in the base currency of the tenant.
	`TaxTipCategoryID`	`nvarchar(15)`		TaxCategory
Description:The tax category associated with the tip item. Corresponds to the value of the TaxCategory.TaxCategoryID field.
	`TaxTipTotal`Nonexistent in DB	`decimal`		-
Description:A fake field for correct working a Tax attribute. Always must be zero because a tip is tax exempt. The total amount of tips taxes associated with the document in the base currency of the company.
	`TaxTotal`	`decimal(19, 4)`		-
Description:The total amount of taxes associated with the document in the base currency of the company.
	`TaxZoneID`Default Navigation	`nvarchar(10)`	Tax Zone	TaxZone
Description:No description available
	`TipAmt`	`decimal(19, 4)`	Original Tip Amount	-
Description:The amount of non-taxable tips in the base currency of the tenant that will not be included in the tax base of the receipt.
	`TranAmt`	`decimal(19, 4)`	Original Claim Amount	-
Description:The amount to be reimbursed to the employee, which is calculated as the difference between the total amount and the employee part in the base currency of the company.
	`TranAmtWithTaxes`	`decimal(19, 4)`	Original Claim Amount with Taxes	-
Description:The amount to be reimbursed to the employee in the base currency of the tenant.
	`TranDesc`	`nvarchar(256)`	Description	-
Description:The description of the expense.
	`tstamp`	`timestamp`		-
Description:No description available
	`UnitCost`	`decimal(19, 6)`		-
Description:The cost of one unit of the expense item in the base currency of the company. If a standard cost is specified for the expense non-stock item, the standard cost is used as the default unit cost.
	`UOM`Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:The unit of measure of the expense item.
	`VatExemptTotal`	`decimal(19, 4)`		-
Description:The document total that is exempt from VAT in the base currency of the tenant.
	`VatTaxableTotal`	`decimal(19, 4)`		-
Description:The document total that is subjected to VAT in the base currency of the tenant.
	`WorkgroupID`Default Navigation	`int`	Workgroup	EPCompanyTree
Description:The workgroup that is responsible for the document approval process.