PM
POLinePM
PX.Objects.PM41 of 41 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | PO Line Nbr. | - | |
Description:No description available | ||||
OrderNbr | nvarchar(15) | PO Nbr. | POOrder | |
Description:No description available | ||||
OrderType | char(2) | PO Type | - | |
Description:No description available | ||||
AlternateID | nvarchar(50) | Alternate ID | - | |
Description:No description available | ||||
BaseOpenQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseOrderQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseReceivedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
CalcCuryOpenAmtNonexistent in DB | decimal | Open Amount | - | |
Description:No description available | ||||
CalcOpenQtyNonexistent in DB | decimal | Open Qty. | - | |
Description:No description available | ||||
Cancelled | bit | Canceled | - | |
Description:No description available | ||||
Completed | bit | - | ||
Description:No description available | ||||
CostCodeCD | nvarchar(30) | Cost Code | - | |
Description:No description available | ||||
CostCodeID | int | Cost Code | - | |
Description:No description available | ||||
CuryExtCost | decimal(19, 4) | Line Amount | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryLineAmt | decimal(19, 4) | Ext. Cost | - | |
Description:No description available | ||||
CuryUnbilledAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryUnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
ExpenseAcctID | int | Account | ||
Description:No description available | ||||
ExtCost | decimal(19, 4) | Line Amount in Base Currency | - | |
Description:No description available | ||||
HasMultipleProjects | bit | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
LineType | char(2) | Status | - | |
Description:No description available | ||||
OpenQty | decimal(25, 6) | - | ||
Description:No description available | ||||
OrderDate | datetime2 | Order Date | - | |
Description:No description available | ||||
OrderQty | decimal(25, 6) | Order Qty. | - | |
Description:No description available | ||||
ProjectID | int | Project | - | |
Description:No description available | ||||
PromisedDate | datetime2 | Promised | - | |
Description:No description available | ||||
ReceivedQty | decimal(25, 6) | Qty. On Receipts | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | int | INSite | ||
Description:No description available | ||||
SubItemID | int | Subitem | - | |
Description:No description available | ||||
TaskID | int | Project Task | - | |
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Line Description | - | |
Description:No description available | ||||
UnbilledQty | decimal(25, 6) | - | ||
Description:No description available | ||||
UnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||
VendorID | int | Vendor | - | |
Description:No description available | ||||
VendorRefNbr | nvarchar(40) | Vendor Ref. | - | |
Description:No description available | ||||