PM
PMProjectARHistoryAccum
PX.Objects.PM59 of 59 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountGroupID | int | - | ||
Description:No description available | ||||
ARDocType | char(3) | - | ||
Description:No description available | ||||
ARLineNbr | int | - | ||
Description:No description available | ||||
ARRefNbr | 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 | ||||
ProjectID | int | - | ||
Description:No description available | ||||
RefLineNbr | int | - | ||
Description:No description available | ||||
RefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
TaskID | int | - | ||
Description:No description available | ||||
ARAmount | decimal | AR Amount (Base Curr.) | - | |
Description:No description available | ||||
ARCashDiscount | decimal | AR Cash Discount (Base Curr.) | - | |
Description:No description available | ||||
ARRetainageHeld | decimal | AR Retained Amount (Base Curr.) | - | |
Description:No description available | ||||
ARRetainedTaxHeld | decimal | 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 | BAccount | |
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 | Extended Price (Base Curr.) | - | |
Description:No description available | ||||
InvoicedExclusiveTax | decimal | Exclusive Taxes on AR (Base Curr.) | - | |
Description:No description available | ||||
InvoicedInclusiveTax | decimal | Inclusive Taxes on AR (Base Curr.) | - | |
Description:No description available | ||||
InvoicedQty | decimal | AR Document Qty. | - | |
Description:No description available | ||||
IsRetainageDocument | bit | Retainage Document | - | |
Description:No description available | ||||
PaidARAmount | decimal | AR Paid Amount (Base Curr.) | - | |
Description:No description available | ||||
PaidExclusiveTax | decimal | Exclusive Taxes on Paid AR (Base Curr.) | - | |
Description:No description available | ||||
PaidInclusiveTax | decimal | Paid Inclusive Tax (Base Curr.) | - | |
Description:No description available | ||||
ProjectCuryARAmount | decimal | AR Amount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryARCashDiscount | decimal | AR Cash Discount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryARRetainageHeld | decimal | AR Retained Amount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryARRetainedTaxHeld | decimal | AR Retained Taxes (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryExtPrice | decimal | Extended Price (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryInfoID | bigint | - | ||
Description:No description available | ||||
ProjectCuryInvoicedExclusiveTax | decimal | Exclusive Taxes on AR (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryInvoicedInclusiveTax | decimal | Inclusive Taxes on AR (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryPaidARAmount | decimal | AR Paid Amount (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryPaidExclusiveTax | decimal | Exclusive Taxes on Paid AR (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 | ||||
ProjectCuryUnitPrice | decimal | Unit Price (Project Curr.) | - | |
Description:No description available | ||||
ProjectCuryWriteOff | decimal | Write-Off Amount (Project Curr.) | - | |
Description:No description available | ||||
RGOL | decimal | Realized Gain/Loss (Base Curr.) | - | |
Description:No description available | ||||
TranCuryARAmount | decimal | AR Amount | - | |
Description:No description available | ||||
TranCuryARCashDiscount | decimal | - | ||
Description:No description available | ||||
TranCuryARRetainageHeld | decimal | - | ||
Description:No description available | ||||
TranCuryARRetainedTaxHeld | decimal | - | ||
Description:No description available | ||||
TranCuryExtPrice | decimal | Extended Price | - | |
Description:No description available | ||||
TranCuryInvoicedExclusiveTax | decimal | - | ||
Description:No description available | ||||
TranCuryInvoicedInclusiveTax | decimal | - | ||
Description:No description available | ||||
TranCuryPaidARAmount | decimal | AR Paid Amount | - | |
Description:No description available | ||||
TranCuryPaidExclusiveTax | decimal | - | ||
Description:No description available | ||||
TranCuryPaidInclusiveTax | decimal | - | ||
Description:No description available | ||||
TranCuryWriteOff | decimal | - | ||
Description:No description available | ||||
UnitPrice | decimal | Unit Price (Base Curr.) | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||
WriteOff | decimal | Write-Off Amount (Base Curr.) | - | |
Description:No description available | ||||