FS
FSSODetSplit
PX.Objects.FS77 of 77 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | FSSODet | ||
Description:No description available | ||||
RefNbr | nvarchar(15) | FSServiceOrder | ||
Description:No description available | ||||
SplitLineNbr | int | Allocation ID | FSSODetSplit | |
Description:No description available | ||||
SrvOrdType | char(4) | Service Order Type | FSSrvOrdType | |
Description:No description available | ||||
AllocatedPlanType | unspecified | - | ||
Description:No description available | ||||
AssignedNbrNonexistent in DB | nvarchar(30) | - | ||
Description:No description available | ||||
BackOrderPlanType | unspecified | - | ||
Description:No description available | ||||
BaseOpenQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
BaseQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseReceivedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseShippedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseUnreceivedQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
Completed | bit | Completed | - | |
Description:No description available | ||||
CostCenterID | int | INCostCenter | ||
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 | ||||
CuryExtCost | decimal(19, 6) | Ext. Cost | - | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryUnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
ExpireDate | datetime2 | Expiration Date | - | |
Description:No description available | ||||
ExtCost | decimal(19, 6) | - | ||
Description:No description available | ||||
FixedSource | nchar(1) | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InvtMult | smallint | - | ||
Description:No description available | ||||
IsAllocated | bit | Allocated | - | |
Description:No description available | ||||
IsMergeableNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsStockItem | bit | - | ||
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 | ||||
LineType | char(2) | - | ||
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
LotSerClassIDNonexistent in DB | nvarchar(10) | - | ||
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | INLotSerialStatus | |
Description:No description available | ||||
OpenQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
Operation | char(1) | SOOrderTypeOperation | ||
Description:No description available | ||||
OrderDate | datetime2 | - | ||
Description:No description available | ||||
OrigPlanType | char(2) | INPlanType | ||
Description:No description available | ||||
ParentSplitLineNbr | int | Parent Allocation ID | - | |
Description:No description available | ||||
PlanID | bigint | INItemPlan | ||
Description:No description available | ||||
PlanType | nchar(2) | - | ||
Description:No description available | ||||
POCancelled | bit | - | ||
Description:No description available | ||||
POCompleted | bit | - | ||
Description:No description available | ||||
POCreate | bit | Mark for PO | - | |
Description:No description available | ||||
POLineNbr | int | PO Line Nbr. | POLine | |
Description:No description available | ||||
PONbr | nvarchar(15) | PO Nbr. | POOrder | |
Description:No description available | ||||
POReceiptNbr | nvarchar(15) | PO Receipt Nbr. | POReceipt | |
Description:No description available | ||||
POReceiptType | char(2) | PO Receipt Type | - | |
Description:No description available | ||||
POSiteID | int | INSite | ||
Description:No description available | ||||
POSource | char(1) | - | ||
Description:No description available | ||||
POType | char(2) | PO Type | - | |
Description:No description available | ||||
ProjectIDNonexistent in DB | int | - | ||
Description:No description available | ||||
Qty | decimal(25, 6) | Quantity | - | |
Description:No description available | ||||
ReceivedQty | decimal(25, 6) | Qty. Received | - | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | Related Document | - | |
Description:No description available | ||||
RequireAllocationNonexistent in DB | bit | - | ||
Description:No description available | ||||
RequireLocationNonexistent in DB | bit | - | ||
Description:No description available | ||||
RequireShippingNonexistent in DB | bit | - | ||
Description:No description available | ||||
ShipComplete | char(1) | - | ||
Description:No description available | ||||
ShipDate | datetime2 | Ship On | - | |
Description:No description available | ||||
ShipmentNbr | nvarchar(15) | Shipment Nbr. | SOShipment | |
Description:No description available | ||||
ShippedQty | decimal(25, 6) | Qty. On Shipments | - | |
Description:No description available | ||||
SiteID | int | Alloc. Warehouse | INSite | |
Description:No description available | ||||
SOLineNbr | int | - | ||
Description:No description available | ||||
SOOrderNbr | nvarchar(15) | - | ||
Description:No description available | ||||
SOOrderType | char(2) | - | ||
Description:No description available | ||||
SOSplitLineNbr | int | - | ||
Description:No description available | ||||
SubItemID | int | Subitem | INLocationStatus | |
Description:No description available | ||||
TaskIDNonexistent in DB | int | - | ||
Description:No description available | ||||
ToSiteID | int | Orig. Warehouse | INSite | |
Description:No description available | ||||
TranTypeNonexistent in DB | nchar(3) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnitCost | decimal(19, 6) | - | ||
Description:No description available | ||||
UnreceivedQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
VendorID | int | Vendor | ||
Description:No description available | ||||