PM
PMProjectAPHistoryAccum
PX.Objects.PM74 of 74 fields
| Field Name | Type | Display Name | Foreign 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 | int | INUnit | ||
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 | decimal | AP Amount (Base Curr.) | - | |
Description:No description available | ||||
APCashDiscount | decimal | AP Cash Discount (Base Curr.) | - | |
Description:No description available | ||||
APRetainageHeld | decimal | AP Retained Amount (Base Curr.) | - | |
Description:No description available | ||||
APRetainedTaxHeld | decimal | AP Retained Taxes (Base Curr.) | - | |
Description:No description available | ||||
BaseCuryInfoID | bigint | - | ||
Description:No description available | ||||
BilledExclusiveTax | decimal | Billed Tax (Base Curr.) | - | |
Description:No description available | ||||
BilledInclusiveTax | decimal | Billed Inclusive Tax (Base Curr.) | - | |
Description:No description available | ||||
BilledQty | decimal | Billed Qty. | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CommittedAmt | decimal | Committed Amount (Base Curr.) | - | |
Description:No description available | ||||
CommittedQty | decimal | Committed Qty. | - | |
Description:No description available | ||||
CommittedRetainage | decimal | 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 | Extended Cost (Base Curr.) | - | |
Description:No description available | ||||
IsRetainageDocument | bit | Retainage Document | - | |
Description:No description available | ||||
PaidAPAmount | decimal | AP Paid Amount (Base Curr.) | - | |
Description:No description available | ||||
PaidExclusiveTax | decimal | Exclusive Taxes on Paid AP (Base Curr.) | - | |
Description:No description available | ||||
PaidInclusiveTax | decimal | Paid Inclusive Tax (Base Curr.) | - | |
Description:No description available | ||||
ProjectCuryAPAmount | decimal | AP Amount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryAPCashDiscount | decimal | AP Cash Discount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryAPRetainageHeld | decimal | AP Retained Amount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryAPRetainedTaxHeld | decimal | AP Retained Taxes (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryBilledExclusiveTax | decimal | Billed Tax (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryBilledInclusiveTax | decimal | Billed Inclusive Tax (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryCommittedAmt | decimal | Committed Amount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryCommittedRetainage | decimal | Committed Retainage (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryCommittedUnitCost | decimal | Committed Unit Cost (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryExtCost | decimal | Extended Cost (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryInfoID | bigint | - | ||
Description:No description available | ||||
ProjectCuryPaidAPAmount | decimal | AP Paid Amount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryPaidExclusiveTax | decimal | Exclusive Taxes on Paid AP (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryPaidInclusiveTax | decimal | Paid Inclusive Tax (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryRGOL | decimal | Realized Gain/Loss (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryUnitCost | decimal | Unit Cost (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryUseTax | decimal | Use Tax (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryWithheldTax | decimal | Withheld Tax Amount (Project Curr.) | - | |
Description:No description available | ||||
RGOL | decimal | Realized Gain/Loss (Base Curr.) | - | |
Description:No description available | ||||
TranCuryAPAmount | decimal | AP 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 | decimal | Extended Cost | - | |
Description:No description available | ||||
TranCuryPaidAPAmount | decimal | AP 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 | decimal | Unit Cost (Base Curr.) | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||
UseTax | decimal | Use Tax (Base Curr.) | - | |
Description:No description available | ||||
VendorID | int | Vendor | BAccount | |
Description:No description available | ||||
WithheldTax | decimal | Withheld Tax Amount (Base Curr.) | - | |
Description:No description available | ||||