RQ
RQRequestLineOwned
PX.Objects.RQ54 of 54 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
OrderNbr | nvarchar(20) | Ref. Nbr. | - | |
Description:No description available | ||||
AlternateID | nvarchar(50) | Alternate ID | - | |
Description:No description available | ||||
Approved | bit | Approved | - | |
Description:No description available | ||||
BaseIssuedQtyObsolete | decimal | - | ||
Description:No description available | ||||
BaseOpenQty | decimal | - | ||
Description:No description available | ||||
BaseOrderQty | decimal | - | ||
Description:No description available | ||||
BaseOriginQtyObsolete | decimal | - | ||
Description:No description available | ||||
BaseReqQty | decimal | - | ||
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 | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryEstExtCost | decimal | Est. Ext. Cost | - | |
Description:No description available | ||||
CuryEstUnitCost | decimal | Est. Unit Cost | - | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CustomerRequest | bit | Customer Request | - | |
Description:No description available | ||||
DepartmentID | nvarchar(10) | Department | - | |
Description:No description available | ||||
Description | nvarchar(256) | Description | - | |
Description:No description available | ||||
EmployeeID | int | Requested By | BAccount | |
Description:No description available | ||||
EstExtCost | decimal | Est. Ext. Cost | - | |
Description:No description available | ||||
EstUnitCost | decimal | 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 | - | |
Description:No description available | ||||
IssuedQtyObsolete | decimal | 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 | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LocationID | int | Location | - | |
Description:No description available | ||||
ManualPrice | bit | Manual Cost | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpenQty | decimal | Open Qty. | - | |
Description:No description available | ||||
OrderDate | datetime2 | Date | - | |
Description:No description available | ||||
OrderQty | decimal | Order Qty. | - | |
Description:No description available | ||||
OriginQtyObsolete | decimal | Original Qty. | - | |
Description:No description available | ||||
Priority | int | Priority | - | |
Description:No description available | ||||
PromisedDate | datetime2 | Promised Date | - | |
Description:No description available | ||||
ReqClassID | nvarchar(10) | Request Class | RQRequestClass | |
Description:No description available | ||||
ReqQty | decimal | Requisition Qty. | - | |
Description:No description available | ||||
RequestedDate | datetime2 | Required Date | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ShipDestType | char(1) | Shipping Destination Type | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | - | |
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 | ||||