PO
POLineR
PX.Objects.PO37 of 37 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
OrderNbr | nvarchar(15) | Order Nbr. | POOrderR | |
Description:No description available | ||||
OrderType | char(2) | Order Type | - | |
Description:No description available | ||||
AllowComplete | bit | Allow Complete | - | |
Description:No description available | ||||
BaseOpenQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseOrderedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseOrderQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseReceivedQty | decimal(25, 6) | Base Received Qty. | - | |
Description:No description available | ||||
BilledAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
BilledQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BLOrderedCost | decimal(19, 4) | - | ||
Description:No description available | ||||
Cancelled | bit | - | ||
Description:No description available | ||||
Closed | bit | - | ||
Description:No description available | ||||
Completed | bit | - | ||
Description:No description available | ||||
CompletePOLine | char(1) | - | ||
Description:No description available | ||||
CuryBLOrderedCost | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
DRTermEndDate | datetime2 | Term End Date | - | |
Description:No description available | ||||
DRTermStartDate | datetime2 | Term Start Date | - | |
Description:No description available | ||||
ExtCost | decimal(19, 4) | - | ||
Description:No description available | ||||
InventoryID | int | InventoryItem | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineType | char(2) | Line Type | - | |
Description:No description available | ||||
OpenQty | decimal(25, 6) | Open Qty. | - | |
Description:No description available | ||||
OrderedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
OrderQty | decimal(25, 6) | - | ||
Description:No description available | ||||
POLineNbr | int | POLineR | ||
Description:No description available | ||||
PONbr | nvarchar(15) | POOrderR | ||
Description:No description available | ||||
POType | char(2) | - | ||
Description:No description available | ||||
RcptQtyThreshold | decimal(9, 6) | - | ||
Description:No description available | ||||
ReceivedQty | decimal(25, 6) | Received Qty. | - | |
Description:No description available | ||||
RetainageAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
SortOrder | int | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||