PM
PMProjectARHistory
PX.Objects.PM59 of 59 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountGroupID | int | Account Group | PMAccountGroup | |
Description:No description available | ||||
ARDocType | char(3) | AR Document Type | - | |
Description:No description available | ||||
ARLineNbr | int | AR Document Line Nbr. | - | |
Description:No description available | ||||
ARRefNbr | nvarchar(30) | AR Document Ref. Nbr. | ARInvoice | |
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 | ||||
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 | ||||
ARAmount | decimal(19, 4) | AR Amount (Base Curr.) | - | |
Description:No description available | ||||
ARCashDiscount | decimal(19, 4) | AR Cash Discount (Base Curr.) | - | |
Description:No description available | ||||
ARRetainageHeld | decimal(19, 4) | AR Retained Amount (Base Curr.) | - | |
Description:No description available | ||||
ARRetainedTaxHeld | decimal(19, 4) | AR Retained Taxes (Base Curr.) | - | |
Description:No description available | ||||
BaseCuryInfoID | bigint | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CuryID | nvarchar(5) | Project Currency | - | |
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
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 | ||||
ExtPrice | decimal(19, 4) | Extended Price (Base Curr.) | - | |
Description:No description available | ||||
InvoicedExclusiveTax | decimal(19, 4) | Exclusive Taxes on AR (Base Curr.) | - | |
Description:No description available | ||||
InvoicedInclusiveTax | decimal(19, 4) | Inclusive Taxes on AR (Base Curr.) | - | |
Description:No description available | ||||
InvoicedQty | decimal(19, 6) | AR Document Qty. | - | |
Description:No description available | ||||
IsRetainageDocument | bit | Retainage Document | - | |
Description:No description available | ||||
PaidARAmount | decimal(19, 4) | AR Paid Amount (Base Curr.) | - | |
Description:No description available | ||||
PaidExclusiveTax | decimal(19, 4) | Exclusive Taxes on Paid AR (Base Curr.) | - | |
Description:No description available | ||||
PaidInclusiveTax | decimal(19, 4) | Paid Inclusive Tax (Base Curr.) | - | |
Description:No description available | ||||
ProjectCuryARAmount | decimal(19, 4) | AR Amount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryARCashDiscount | decimal(19, 4) | AR Cash Discount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryARRetainageHeld | decimal(19, 4) | AR Retained Amount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryARRetainedTaxHeld | decimal(19, 4) | AR Retained Taxes (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryExtPrice | decimal(19, 4) | Extended Price (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryInfoID | bigint | - | ||
Description:No description available | ||||
ProjectCuryInvoicedExclusiveTax | decimal(19, 4) | Exclusive Taxes on AR (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryInvoicedInclusiveTax | decimal(19, 4) | Inclusive Taxes on AR (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryPaidARAmount | decimal(19, 4) | AR Paid Amount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryPaidExclusiveTax | decimal(19, 4) | Exclusive Taxes on Paid AR (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 | ||||
ProjectCuryUnitPrice | decimal | Unit Price (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryWriteOff | decimal(19, 4) | Write-Off Amount (Project Curr.) | - | |
Description:No description available | ||||
RGOL | decimal(19, 4) | Realized Gain/Loss (Base Curr.) | - | |
Description:No description available | ||||
TranCuryARAmount | decimal(19, 4) | AR Amount | - | |
Description:No description available | ||||
TranCuryARCashDiscount | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryARRetainageHeld | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryARRetainedTaxHeld | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryExtPrice | decimal(19, 4) | Extended Price | - | |
Description:No description available | ||||
TranCuryInvoicedExclusiveTax | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryInvoicedInclusiveTax | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryPaidARAmount | decimal(19, 4) | AR Paid Amount | - | |
Description:No description available | ||||
TranCuryPaidExclusiveTax | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryPaidInclusiveTax | decimal(19, 4) | - | ||
Description:No description available | ||||
TranCuryWriteOff | decimal(19, 4) | - | ||
Description:No description available | ||||
UnitPrice | decimal | Unit Price (Base Curr.) | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
WriteOff | decimal(19, 4) | Write-Off Amount (Base Curr.) | - | |
Description:No description available | ||||