PM
PMProjectAPHistory
PX.Objects.PM74 of 74 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountGroupID | int | Account Group | PMAccountGroup | |
Description:No description available | ||||
APDocType | char(3) | AP Document Type | - | |
Description:No description available | ||||
APLineNbr | int | AP Document Line Nbr. | - | |
Description:No description available | ||||
APRefNbr | nvarchar(30) | AP Document Ref. Nbr. | APInvoice | |
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
Date | datetime2 | Date | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
POLineNbr | int | Commitment Line Nbr. | - | |
Description:No description available | ||||
POOrderNbr | nvarchar(30) | Commitment Ref. Nbr. | POOrder | |
Description:No description available | ||||
POOrderType | char(3) | Commitment Doc. Type | - | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
RefLineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
APAmount | decimal(19, 4) | AP Amount (Base Curr.) | - | |
Description:No description available | ||||
APCashDiscount | decimal(19, 4) | AP Cash Discount (Base Curr.) | - | |
Description:No description available | ||||
APRetainageHeld | decimal(19, 4) | AP Retained Amount (Base Curr.) | - | |
Description:No description available | ||||
APRetainedTaxHeld | decimal(19, 4) | AP Retained Taxes (Base Curr.) | - | |
Description:No description available | ||||
BaseCuryInfoID | bigint | - | ||
Description:No description available | ||||
BilledExclusiveTax | decimal(19, 4) | Billed Tax (Base Curr.) | - | |
Description:No description available | ||||
BilledInclusiveTax | decimal(19, 4) | Billed Inclusive Tax (Base Curr.) | - | |
Description:No description available | ||||
BilledQty | decimal(19, 6) | Billed Qty. | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CommittedAmt | decimal(19, 4) | Committed Amount (Base Curr.) | - | |
Description:No description available | ||||
CommittedQty | decimal(19, 6) | Committed Qty. | - | |
Description:No description available | ||||
CommittedRetainage | decimal(19, 4) | Committed Retainage (Base Curr.) | - | |
Description:No description available | ||||
CommittedUnitCost | decimal | Committed 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 | decimal(19, 4) | Extended Cost (Base Curr.) | - | |
Description:No description available | ||||
IsRetainageDocument | bit | Retainage Document | - | |
Description:No description available | ||||
PaidAPAmount | decimal(19, 4) | AP Paid Amount (Base Curr.) | - | |
Description:No description available | ||||
PaidExclusiveTax | decimal(19, 4) | Exclusive Taxes on Paid AP (Base Curr.) | - | |
Description:No description available | ||||
PaidInclusiveTax | decimal(19, 4) | Paid Inclusive Tax (Base Curr.) | - | |
Description:No description available | ||||
ProjectCuryAPAmount | decimal(19, 4) | AP Amount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryAPCashDiscount | decimal(19, 4) | AP Cash Discount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryAPRetainageHeld | decimal(19, 4) | AP Retained Amount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryAPRetainedTaxHeld | decimal(19, 4) | AP Retained Taxes (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryBilledExclusiveTax | decimal(19, 4) | Billed Tax (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryBilledInclusiveTax | decimal(19, 4) | Billed Inclusive Tax (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryCommittedAmt | decimal(19, 4) | Committed Amount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryCommittedRetainage | decimal(19, 4) | Committed Retainage (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryCommittedUnitCost | decimal | Committed Unit Cost (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryExtCost | decimal(19, 4) | Extended Cost (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryInfoID | bigint | - | ||
Description:No description available | ||||
ProjectCuryPaidAPAmount | decimal(19, 4) | AP Paid Amount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryPaidExclusiveTax | decimal(19, 4) | Exclusive Taxes on Paid AP (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryPaidInclusiveTax | decimal(19, 4) | Paid Inclusive Tax (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryRGOL | decimal(19, 4) | Realized Gain/Loss (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryUnitCost | decimal | Unit Cost (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryUseTax | decimal(19, 4) | Use Tax (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryWithheldTax | decimal(19, 4) | Withheld Tax Amount (Project Curr.) | - | |
Description:No description available | ||||
RGOL | decimal(19, 4) | Realized Gain/Loss (Base Curr.) | - | |
Description:No description available | ||||
TranCuryAPAmount | decimal(19, 4) | AP Amount | - | |
Description:No description available | ||||
TranCuryAPCashDiscount | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryAPRetainageHeld | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryAPRetainedTaxHeld | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryBilledExclusiveTax | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryBilledInclusiveTax | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryCommittedAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryCommittedRetainage | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryExtCost | decimal(19, 4) | Extended Cost | - | |
Description:No description available | ||||
TranCuryPaidAPAmount | decimal(19, 4) | AP Paid Amount | - | |
Description:No description available | ||||
TranCuryPaidExclusiveTax | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryPaidInclusiveTax | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryUseTax | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryWithheldTax | decimal(19, 4) | - | ||
Description:No description available | ||||
UnitCost | decimal | Unit Cost (Base Curr.) | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UseTax | decimal(19, 4) | Use Tax (Base Curr.) | - | |
Description:No description available | ||||
VendorID | int | Vendor | Vendor | |
Description:No description available | ||||
WithheldTax | decimal(19, 4) | Withheld Tax Amount (Base Curr.) | - | |
Description:No description available | ||||