Skip to main content
PM

PMProjectAPHistoryAccum

PX.Objects.PM
Field NameTypeDisplay NameForeign Key
AccountGroupID
int-
Description:No description available
APDocType
char(3)-
Description:No description available
APLineNbr
int-
Description:No description available
APRefNbr
nvarchar(30)-
Description:No description available
CostCodeID
int-
Description:No description available
Date
datetime2-
Description:No description available
InventoryID
intINUnit
Description:No description available
POLineNbr
int-
Description:No description available
POOrderNbr
nvarchar(30)-
Description:No description available
POOrderType
char(3)-
Description:No description available
ProjectID
int-
Description:No description available
RefLineNbr
int-
Description:No description available
RefNoteID
uniqueidentifier-
Description:No description available
TaskID
int-
Description:No description available
APAmount
decimalAP Amount (Base Curr.)-
Description:No description available
APCashDiscount
decimalAP Cash Discount (Base Curr.)-
Description:No description available
APRetainageHeld
decimalAP Retained Amount (Base Curr.)-
Description:No description available
APRetainedTaxHeld
decimalAP Retained Taxes (Base Curr.)-
Description:No description available
BaseCuryInfoID
bigint-
Description:No description available
BilledExclusiveTax
decimalBilled Tax (Base Curr.)-
Description:No description available
BilledInclusiveTax
decimalBilled Inclusive Tax (Base Curr.)-
Description:No description available
BilledQty
decimalBilled Qty.-
Description:No description available
BranchIDDefault Navigation
intBranchBranch
Description:No description available
CommittedAmt
decimalCommitted Amount (Base Curr.)-
Description:No description available
CommittedQty
decimalCommitted Qty.-
Description:No description available
CommittedRetainage
decimalCommitted Retainage (Base Curr.)-
Description:No description available
CommittedUnitCost
decimalCommitted Unit Cost (Base Curr.)-
Description:No description available
CuryID
nvarchar(5)-
Description:No description available
EntityDocType
char(3)Document Type-
Description:No description available
EntityRefNbr
nvarchar(30)Ref. Nbr.-
Description:No description available
EntityType
char(1)Record Type-
Description:No description available
ExtCost
decimalExtended Cost (Base Curr.)-
Description:No description available
IsRetainageDocument
bitRetainage Document-
Description:No description available
PaidAPAmount
decimalAP Paid Amount (Base Curr.)-
Description:No description available
PaidExclusiveTax
decimalExclusive Taxes on Paid AP (Base Curr.)-
Description:No description available
PaidInclusiveTax
decimalPaid Inclusive Tax (Base Curr.)-
Description:No description available
ProjectCuryAPAmount
decimalAP Amount (Project Curr.)-
Description:No description available
ProjectCuryAPCashDiscount
decimalAP Cash Discount (Project Curr.)-
Description:No description available
ProjectCuryAPRetainageHeld
decimalAP Retained Amount (Project Curr.)-
Description:No description available
ProjectCuryAPRetainedTaxHeld
decimalAP Retained Taxes (Project Curr.)-
Description:No description available
ProjectCuryBilledExclusiveTax
decimalBilled Tax (Project Curr.)-
Description:No description available
ProjectCuryBilledInclusiveTax
decimalBilled Inclusive Tax (Project Curr.)-
Description:No description available
ProjectCuryCommittedAmt
decimalCommitted Amount (Project Curr.)-
Description:No description available
ProjectCuryCommittedRetainage
decimalCommitted Retainage (Project Curr.)-
Description:No description available
ProjectCuryCommittedUnitCost
decimalCommitted Unit Cost (Project Curr.)-
Description:No description available
ProjectCuryExtCost
decimalExtended Cost (Project Curr.)-
Description:No description available
ProjectCuryInfoID
bigint-
Description:No description available
ProjectCuryPaidAPAmount
decimalAP Paid Amount (Project Curr.)-
Description:No description available
ProjectCuryPaidExclusiveTax
decimalExclusive Taxes on Paid AP (Project Curr.)-
Description:No description available
ProjectCuryPaidInclusiveTax
decimalPaid Inclusive Tax (Project Curr.)-
Description:No description available
ProjectCuryRGOL
decimalRealized Gain/Loss (Project Curr.)-
Description:No description available
ProjectCuryUnitCost
decimalUnit Cost (Project Curr.)-
Description:No description available
ProjectCuryUseTax
decimalUse Tax (Project Curr.)-
Description:No description available
ProjectCuryWithheldTax
decimalWithheld Tax Amount (Project Curr.)-
Description:No description available
RGOL
decimalRealized Gain/Loss (Base Curr.)-
Description:No description available
TranCuryAPAmount
decimalAP Amount-
Description:No description available
TranCuryAPCashDiscount
decimal-
Description:No description available
TranCuryAPRetainageHeld
decimal-
Description:No description available
TranCuryAPRetainedTaxHeld
decimal-
Description:No description available
TranCuryBilledExclusiveTax
decimal-
Description:No description available
TranCuryBilledInclusiveTax
decimal-
Description:No description available
TranCuryCommittedAmt
decimal-
Description:No description available
TranCuryCommittedRetainage
decimal-
Description:No description available
TranCuryExtCost
decimalExtended Cost-
Description:No description available
TranCuryPaidAPAmount
decimalAP Paid Amount-
Description:No description available
TranCuryPaidExclusiveTax
decimal-
Description:No description available
TranCuryPaidInclusiveTax
decimal-
Description:No description available
TranCuryUseTax
decimal-
Description:No description available
TranCuryWithheldTax
decimal-
Description:No description available
UnitCost
decimalUnit Cost (Base Curr.)-
Description:No description available
UOMDefault Navigation
nvarchar(6)UOM-
Description:No description available
UseTax
decimalUse Tax (Base Curr.)-
Description:No description available
VendorIDDefault Navigation
intVendorBAccount
Description:No description available
WithheldTax
decimalWithheld Tax Amount (Base Curr.)-
Description:No description available