Skip to main content
EP

ExpenseClaimEntry.EPExpenseClaimDetailsForSubmit

PX.Objects.EPRelease 2025.2

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

Field NameTypeDisplay NameForeign Key
APDocType
char(3)AP Document TypeAPInvoice
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
intAP Document Line Nbr.APTran
Description:The number of the AP document line created as a result of releasing an expense claim.
APRefNbrDefault 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 TypeARInvoice
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.
ARRefNbrDefault Navigation
nvarchar(15)AR Reference Nbr.ARInvoice
Description:The reference number of the AR document created as a result of billing a 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.
BankTranDate
datetime-
Description:The CA bank transaction date.
BankTranStatus
nvarcharBank Transaction Status-
Description:No description available
Billable
bitBillable-
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
bitBilled-
Description:Indicates (if set to "true") that current receipt was billed.
BranchIDDefault Navigation
intBranchBranch
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)-
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.
Category
nvarchar(100)Category-
Description:No description available
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-
Description:The difference between the original document amount and the rounded amount in the expense claim currency.
ClaimCuryTaxTotal
decimalAmount in Claim Curr.-
Description:The total amount (in the currency of the expense claim) of taxes that are associated with the document.
ClaimCuryTranAmt
decimalAmount 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
decimalAmount in Claim Curr.-
Description:The amount claimed by the employee, which is expressed in the currency of the expense claim.
ClaimCuryVatExemptTotal
decimal-
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 true (that is, with the Include in VAT Exempt Total check box selected on the Taxes (TX205000) form).
ClaimCuryVatTaxableTotal
decimal-
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 true (that is, the Include in VAT Exempt Total check box is selected on the Taxes (TX205000) form).
ClaimDetailCDDefault Navigation
nvarchar(15)Receipt NumberEPExpenseClaimDetails
Description:The user-friendly unique identifier of the receipt.
ClaimDetailID
intReceipt 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-
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
decimalAmount 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
decimalAmount 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
decimalAmount 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-
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-
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.
ContractIDDefault Navigation
intProject/ContractPMProject
Description:The project or contract, which should be specified if the employee incurred the expenses while working on a particular project or contract. The value of this field can be specified only if the Project Accounting or Contract Management feature, respectively, is enabled on the Enable/Disable Features (CS100000) form.
CorpCardIDDefault Navigation
intCorporate CardCACorpCard
Description:The identifier of the corporate card that is used to pay the expense receipt.
CostCodeIDDefault Navigation
intCost CodePMCostCode
Description:The identifier of the cost code associated with the record.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
CreatedFromClaim
bitCreated from Claim-
Description:A Boolean value that indicates whether an expense receipt was created from an expense claim.
CuryAmountWithTaxes
decimal-
Description:The amount of the expense receipt with taxes in the currency of the document.
CuryEmployeePart
decimalEmployee Part-
Description:The part of the total amount that will not be paid back to the employee in the currency of the document.
CuryExtCost
decimalAmount-
Description:The total amount of the receipt in the currency of the document.
CuryIDDefault Navigation
nvarchar(5)CurrencyCurrencyList
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.
CuryNetAmountNonexistent in DB
decimal?Net Amount-
Description:The net amount in the currency of the document.
CuryTaxAmt
decimal-
Description:The tax amount to be paid for the document in the document currency.
CuryTaxRoundDiff
decimalTax Discrepancy-
Description:The difference between the original document amount and the rounded amount in the selected currency.
CuryTaxTipTotalNonexistent 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
decimalTax Total-
Description:The total amount of taxes associated with the document in the currency of the document.
CuryTaxableAmt
decimal-
Description:The taxable amount in the currency of the document.
CuryTaxableAmtFromTax
decimal-
Description:The taxable amount in the currency of the document.
CuryTipAmt
decimalTip Amount-
Description:The amount of non-taxable tips in the document currency that will not be included in the tax base of the receipt.
CuryTranAmt
decimalClaim 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
decimalClaim Amount-
Description:The amount to be reimbursed to the employee in the currency of the document.
CuryUnitCost
decimalUnit 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-
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 true (that is, with the Include in VAT Exempt Total check box selected on the Taxes (TX205000) form).
CuryVatTaxableTotal
decimal-
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 true (that is, the Include in VAT Exempt Total check box is selected on the Taxes (TX205000) form).
CustomerIDDefault Navigation
intCustomerCustomer
Description:The customer, which should be specified if the employee incurred the expenses while working for a particular customer. If a contract or project is selected, the customer associated with this contract or project is automatically filled in and the box becomes read-only.
CustomerLocationIDDefault Navigation
intLocationLocation
Description:The location of the customer related to the expenses. Corresponds to the value of the Location.LocationID field.
DailyFieldReportIdNonexistent in DB
int?-
Description:No description available
EmployeeIDDefault Navigation
intClaimed byEPEmployee
Description:The identifier of the employee who is claiming the expenses. Corresponds to the value of the EPEmployee.bAccountID field.
EmployeePart
decimalOriginal 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.
ExpenseAccountIDDefault Navigation
intExpense AccountAccount
Description:The expense account to which the system records the part of the expense to be paid back to the employee.
ExpenseDate
datetimeDate-
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.
ExpenseSubIDDefault Navigation
intExpense 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
decimalOriginal Total Amount-
Description:The total amount of the receipt in the base currency of the company.
FSBillable
bitBillable in Svc. Doc.-
Description:No description available
FSEntityNoteID
uniqueidentifierRelated Svc. Doc. Nbr.-
Description:No description available
FSEntityTypeNonexistent in DB
string-
Description:No description available
FSEntityTypeUINonexistent in DB
stringRelated Svc. Doc. Type-
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 receipt has the On Hold status, which means that the receipt can be edited but cannot be added to a claim and released.
HoldClaimNonexistent in DB
bool?-
Description:Specifies (if set to "true") that the Expense Claim (EP301000) (which corresponds to the ExpenseClaimEntry graph) has the On Hold status, which means that user can pick another claim, otherwise user cannot change claim.
InventoryIDDefault Navigation
intExpense ItemInventoryItem
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.
IsDocBilledOrClosedNonexistent in DB
bool?-
Description:No description available
IsDocRelatedToProjectNonexistent in DB
bool?-
Description:No description available
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
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.
NetAmountNonexistent in DB
decimal?-
Description:The net amount in the base currency of the tenant.
NoteID
uniqueidentifier-
Description:No description available
OwnerIDDefault Navigation
intOwnerContact
Description:The Contact responsible for the document approval process. Corresponds to the Contact.ContactID field.
PaidWith
nvarchar(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
decimalQuantity-
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.
RefNbrDefault Navigation
nvarchar(15)Expense Claim Ref. Nbr.EPExpenseClaim
Description:The reference number, which usually matches the number of the original receipt.
RefNbrNotFilteredDefault NavigationNonexistent in DB
stringEPExpenseClaim
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
bitReleased-
Description:Specifies (if set to "true") that the expense receipt was released and has the Released status.
SalesAccountIDDefault Navigation
intSales AccountAccount
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.
SalesSubIDDefault Navigation
intSales 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.
SelectedNonexistent in DB
bool?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.
StatusClaimNonexistent in DB
stringExpense Claim Status-
Description:The status of the Expense Claim (EP301000) form (which corresponds to the ExpenseClaimEntry graph). The field can have one of the values described in EPExpenseClaimStatus.ListAttribute.
SubmitedDate
datetime-
Description:The date when the expense receipt was included in the expense claim.
TaskIDDefault Navigation
intProject TaskPMTask
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.
TaxAmt
decimal-
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.
TaxCategoryIDDefault Navigation
nvarchar(15)Tax CategoryTaxCategory
Description:The tax category associated with the expense item. Corresponds to the value of the TaxCategory.TaxCategoryID field.
TaxRoundDiff
decimal-
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.
TaxTipTotalNonexistent 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-
Description:The total amount of taxes associated with the document in the base currency of the company.
TaxZoneIDDefault Navigation
nvarchar(10)Tax ZoneTaxZone
Description:The identifier of the tax zone associated with the receipt.
TaxableAmt
decimal-
Description:The taxable amount in the base currency of the tenant.
TaxableAmtFromTax
decimal-
Description:The taxable amount in the base currency of the tenant.
TipAmt
decimalOriginal 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
decimalOriginal 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
decimalOriginal 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.
UOMDefault Navigation
nvarchar(6)UOMINUnit
Description:The unit of measure of the expense item.
UnitCost
decimal-
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.
VatExemptTotal
decimal-
Description:The document total that is exempt from VAT in the base currency of the tenant.
VatTaxableTotal
decimal-
Description:The document total that is subjected to VAT in the base currency of the tenant.
WorkgroupIDDefault Navigation
intWorkgroupEPCompanyTree
Description:The workgroup that is responsible for the document approval process.
tstamp
timestamp-
Description:No description available