RQ
RQRequestLine
PX.Objects.RQ47 of 47 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
OrderNbr | nvarchar(20) | Ref. Nbr. | RQRequest | |
Description:No description available | ||||
AlternateID | nvarchar(50) | Alternate ID | - | |
Description:No description available | ||||
Approved | bit | Approved | - | |
Description:No description available | ||||
BaseIssuedQtyObsolete | 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 | ||||
BaseReqQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
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 | ||||
DepartmentID | nvarchar(10) | - | ||
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 | InventoryItem | |
Description:No description available | ||||
IssuedQtyObsolete | decimal(25, 6) | Issued Qty. | - | |
Description:No description available | ||||
IssueStatusNonexistent in DB | nvarchar(MAX) | Issue Status | - | |
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 | ||||
ManualPrice | bit | Manual Cost | - | |
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 | ||||
ReqQty | decimal(25, 6) | Requisition Qty. | - | |
Description:No description available | ||||
RequestedDate | datetime | Required Date | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UpdatableNonexistent in DB | bit | - | ||
Description:No description available | ||||
VendorDescription | nvarchar(100) | Vendor Description | - | |
Description:No description available | ||||
VendorID | int | Vendor | BAccount | |
Description:No description available | ||||
VendorLocationID | int | Location | Location | |
Description:No description available | ||||
VendorName | nvarchar(50) | Vendor Name | - | |
Description:No description available | ||||
VendorRefNbr | nvarchar(40) | Vendor Ref. | - | |
Description:No description available | ||||