EP
ExpenseClaimEntry.EPExpenseClaimDetailsForSubmit
PX.Objects.EP106 of 106 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ClaimDetailCD | nvarchar(15) | Receipt Number | - | |
Description:No description available | ||||
ClaimDetailID | int | - | ||
Description:No description available | ||||
APDocType | char(3) | AP Document Type | - | |
Description:No description available | ||||
APLineNbr | int | AP Document Line Nbr. | APTran | |
Description:No description available | ||||
Approved | bit | - | ||
Description:No description available | ||||
APRefNbr | nvarchar(15) | AP Reference Nbr. | APInvoice | |
Description:No description available | ||||
ARDocType | char(3) | AR Doument Type | - | |
Description:No description available | ||||
ARRefNbr | nvarchar(15) | AR Reference Nbr. | ARInvoice | |
Description:No description available | ||||
BankTranDate | datetime2 | - | ||
Description:No description available | ||||
Billable | bit | Billable | - | |
Description:No description available | ||||
Billed | bit | Billed | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CardCuryID | nvarchar(5) | CardCuryID | - | |
Description:No description available | ||||
CardCuryInfoID | bigint | - | ||
Description:No description available | ||||
ClaimCuryInfoID | bigint | - | ||
Description:No description available | ||||
ClaimCuryTaxRoundDiff | decimal | - | ||
Description:No description available | ||||
ClaimCuryTaxTotal | decimal | Amount in Claim Curr. | - | |
Description:No description available | ||||
ClaimCuryTranAmt | decimal | Amount in Claim Curr. | - | |
Description:No description available | ||||
ClaimCuryTranAmtWithTaxes | decimal | Amount in Claim Curr. | - | |
Description:No description available | ||||
ClaimCuryVatExemptTotal | decimal | - | ||
Description:No description available | ||||
ClaimCuryVatTaxableTotal | decimal | - | ||
Description:No description available | ||||
ClaimTaxRoundDiff | decimal | - | ||
Description:No description available | ||||
ClaimTaxTotal | decimal | Amount in Claim Original | - | |
Description:No description available | ||||
ClaimTranAmt | decimal | Amount in Claim Original | - | |
Description:No description available | ||||
ClaimTranAmtWithTaxes | decimal | Amount in Claim Original | - | |
Description:No description available | ||||
ClaimVatExemptTotal | decimal | - | ||
Description:No description available | ||||
ClaimVatTaxableTotal | decimal | - | ||
Description:No description available | ||||
ContractID | int | Project/Contract | PMProject | |
Description:No description available | ||||
CorpCardID | int | Corporate Card | CACorpCard | |
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CreatedFromClaim | bit | Created from Claim | - | |
Description:No description available | ||||
CuryAmountWithTaxes | decimal | - | ||
Description:No description available | ||||
CuryEmployeePart | decimal | Employee Part | - | |
Description:No description available | ||||
CuryExtCost | decimal | Amount | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | CurrencyList | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryNetAmountNonexistent in DB | decimal | Net Amount | - | |
Description:No description available | ||||
CuryTaxableAmt | decimal | - | ||
Description:No description available | ||||
CuryTaxableAmtFromTax | decimal | - | ||
Description:No description available | ||||
CuryTaxAmt | decimal | - | ||
Description:No description available | ||||
CuryTaxRoundDiff | decimal | Tax Discrepancy | - | |
Description:No description available | ||||
CuryTaxTipTotalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
CuryTaxTotal | decimal | Tax Total | - | |
Description:No description available | ||||
CuryTipAmt | decimal(19, 4) | Tip Amount | - | |
Description:No description available | ||||
CuryTranAmt | decimal | Claim Amount | - | |
Description:No description available | ||||
CuryTranAmtWithTaxes | decimal | Claim Amount | - | |
Description:No description available | ||||
CuryUnitCost | decimal | Unit Cost | - | |
Description:No description available | ||||
CuryVatExemptTotal | decimal | - | ||
Description:No description available | ||||
CuryVatTaxableTotal | decimal | - | ||
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
CustomerLocationID | int | Location | Location | |
Description:No description available | ||||
EmployeeID | int | Claimed by | EPEmployee | |
Description:No description available | ||||
EmployeePart | decimal | Original Employee Part | - | |
Description:No description available | ||||
ExpenseAccountID | int | Expense Account | Account | |
Description:No description available | ||||
ExpenseDate | datetime2 | Date | - | |
Description:No description available | ||||
ExpenseRefNbr | nvarchar(40) | Ref. Nbr. | - | |
Description:No description available | ||||
ExpenseSubID | int | Expense Sub. | Sub | |
Description:No description available | ||||
ExtCost | decimal | Original Total Amount | - | |
Description:No description available | ||||
HasUseTaxNonexistent in DB | bit | - | ||
Description:No description available | ||||
HasWithHoldTaxNonexistent in DB | bit | - | ||
Description:No description available | ||||
Hold | bit | Hold | - | |
Description:No description available | ||||
HoldClaimNonexistent in DB | bit | HoldClaim | - | |
Description:No description available | ||||
InventoryID | int | Expense Item | InventoryItem | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LegacyReceipt | bit | - | ||
Description:No description available | ||||
NetAmountNonexistent in DB | decimal | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
PaidWith | varchar(8) | Paid With | - | |
Description:No description available | ||||
Qty | decimal | Quantity | - | |
Description:No description available | ||||
RefNbr | nvarchar(15) | EPExpenseClaim | ||
Description:No description available | ||||
RefNbrNotFilteredNonexistent in DB | nvarchar(15) | - | ||
Description:No description available | ||||
Rejected | bit | - | ||
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
SalesAccountID | int | Sales Account | Account | |
Description:No description available | ||||
SalesSubID | int | Sales Sub. | Sub | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
StatusClaimNonexistent in DB | nchar(1) | Expense Claim Status | - | |
Description:No description available | ||||
SubmitedDate | datetime2 | - | ||
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TaxableAmt | decimal | - | ||
Description:No description available | ||||
TaxableAmtFromTax | decimal | - | ||
Description:No description available | ||||
TaxAmt | decimal | - | ||
Description:No description available | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | TaxCategory | ||
Description:No description available | ||||
TaxRoundDiff | decimal | - | ||
Description:No description available | ||||
TaxTipCategoryID | nvarchar(15) | TaxCategory | ||
Description:No description available | ||||
TaxTipTotalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
TaxTotal | decimal | - | ||
Description:No description available | ||||
TaxZoneID | nvarchar(10) | Tax Zone | TaxZone | |
Description:No description available | ||||
TipAmt | decimal | Original Tip Amount | - | |
Description:No description available | ||||
TranAmt | decimal | Original Claim Amount | - | |
Description:No description available | ||||
TranAmtWithTaxes | decimal | Original Claim Amount with Taxes | - | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Description | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnitCost | decimal | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
VatExemptTotal | decimal | - | ||
Description:No description available | ||||
VatTaxableTotal | decimal | - | ||
Description:No description available | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||