RQ
RQRequisitionLine
PX.Objects.RQ56 of 56 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
ReqNbr | nvarchar(20) | Req. Nbr. | RQRequisition | |
Description:No description available | ||||
AlternateID | nvarchar(50) | Alternate ID | - | |
Description:No description available | ||||
Approved | bit | Approved | - | |
Description:No description available | ||||
AvailabilityNonexistent in DB | nvarchar(MAX) | Availability | - | |
Description:No description available | ||||
BaseBiddingQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseOpenQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseOrderQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseOriginQtyObsolete | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseTransferQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BiddingQty | decimal(25, 6) | Bidding Qty. | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
ByRequest | bit | - | ||
Description:No description available | ||||
Cancelled | bit | Canceled | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryEstExtCost | decimal(19, 4) | Est. Ext. Cost | - | |
Description:No description available | ||||
CuryEstUnitCost | decimal(19, 6) | Est. Unit Cost | - | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
Description | nvarchar(256) | Description | - | |
Description:No description available | ||||
EstExtCost | decimal(19, 4) | Est. Ext. Cost | - | |
Description:No description available | ||||
EstUnitCost | decimal(19, 6) | Est. Unit Cost | - | |
Description:No description available | ||||
ExpenseAcctID | int | Account | Account | |
Description:No description available | ||||
ExpenseSubID | int | Sub. | Sub | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsUseMarkup | bit | Use Markup | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineSourceNonexistent in DB | nchar(1) | Line Source | - | |
Description:No description available | ||||
LineType | char(2) | Line Type | - | |
Description:No description available | ||||
ManualPrice | bit | Manual Cost | - | |
Description:No description available | ||||
MarkupPct | decimal(19, 6) | Markup, % | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpenQty | decimal(25, 6) | Open Qty. | - | |
Description:No description available | ||||
OrderQty | decimal(25, 6) | Order Qty. | - | |
Description:No description available | ||||
OriginQtyObsolete | decimal(25, 6) | Original Qty. | - | |
Description:No description available | ||||
PromisedDate | datetime | Promised Date | - | |
Description:No description available | ||||
QTLineNbr | int | - | ||
Description:No description available | ||||
QTOrderNbr | nvarchar(15) | - | ||
Description:No description available | ||||
RcptQtyAction | char(1) | Receipt Action | - | |
Description:No description available | ||||
RcptQtyMax | decimal(25, 6) | Max. Receipt, % | - | |
Description:No description available | ||||
RcptQtyMin | decimal(25, 6) | Min. Receipt, % | - | |
Description:No description available | ||||
RcptQtyThreshold | decimal(25, 6) | Complete On, % | - | |
Description:No description available | ||||
RequestedDate | datetime | Required Date | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SourceTranLineNbr | int | Source Transfer Line | - | |
Description:No description available | ||||
SourceTranReqNbr | nvarchar(20) | Source Transfer | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TransferQty | decimal(25, 6) | Transfer Qty. | - | |
Description:No description available | ||||
TransferRequest | bit | Transfer | - | |
Description:No description available | ||||
TransferType | char(1) | Transfer Type | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UOM | nvarchar(20) | UOM | INUnit | |
Description:No description available | ||||