IN
INKitRegister
PX.Objects.IN82 of 82 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
DocType | char(1) | Type | - | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Reference Nbr. | INRegister | |
Description:No description available | ||||
AssyType | char(1) | - | ||
Description:No description available | ||||
BaseQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BatchNbr | nvarchar(15) | Batch Nbr. | Batch | |
Description:No description available | ||||
BranchBaseCuryIDNonexistent in DB | nvarchar(5) | Currency | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
ControlAmount | decimal(19, 4) | Control Amount | - | |
Description:No description available | ||||
ControlCost | decimal(19, 4) | Control Cost | - | |
Description:No description available | ||||
ControlQty | decimal(25, 6) | Control Qty. | - | |
Description:No description available | ||||
CostCenterID | int | - | ||
Description:No description available | ||||
CostLayerType | char(1) | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
ExpireDate | datetime2 | Expiration Date | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
Hold | bit | Hold | - | |
Description:No description available | ||||
InventoryID | int | InventoryItem | ||
Description:This field declaration is for population of INTran.InventoryID within projection | ||||
InventorySource | char(1) | - | ||
Description:No description available | ||||
InvtMult | smallint | - | ||
Description:No description available | ||||
IsIntercompany | bit | - | ||
Description:No description available | ||||
IsStockItem | bit | - | ||
Description:No description available | ||||
KitInventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
KitLineNbr | int | INTran | ||
Description:No description available | ||||
KitRequestDate | datetime2 | Requested On | - | |
Description:No description available | ||||
KitRevisionID | nvarchar(10) | Revision | INKitSpecHdr | |
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 | ||||
LineCntr | int | - | ||
Description:No description available | ||||
LineNbr | int | INTran | ||
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | - | |
Description:No description available | ||||
LotSerTrackNonexistent in DB | nvarchar(1) | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigModule | char(2) | - | ||
Description:No description available | ||||
ProjectID | int | PMProject | ||
Description:No description available | ||||
Qty | decimal(25, 6) | Quantity | - | |
Description:No description available | ||||
ReasonCode | nvarchar(20) | Reason Code | ReasonCode | |
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TaskID | int | PMTask | ||
Description:No description available | ||||
ToCostCenterID | int | - | ||
Description:No description available | ||||
ToCostLayerType | char(1) | - | ||
Description:No description available | ||||
ToInventorySource | char(1) | - | ||
Description:No description available | ||||
TotalAmount | decimal(19, 4) | Total Amount | - | |
Description:No description available | ||||
TotalCost | decimal(19, 4) | Total Cost | - | |
Description:No description available | ||||
TotalCostNonStockNonexistent in DB | decimal | Non-Stock Total Cost | - | |
Description:No description available | ||||
TotalCostStockNonexistent in DB | decimal | Stock Total Cost | - | |
Description:No description available | ||||
TotalQty | decimal(25, 6) | Total Qty. | - | |
Description:No description available | ||||
TranAmt | decimal(19, 4) | Ext. Price | - | |
Description:No description available | ||||
TranBranchID | int | - | ||
Description:No description available | ||||
TranCost | decimal(19, 6) | Ext. Cost | - | |
Description:No description available | ||||
TranCreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
TranCreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
TranCreatedDateTime | datetime | - | ||
Description:No description available | ||||
TranDate | datetime2 | Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Description | - | |
Description:No description available | ||||
TranDocType | char(1) | - | ||
Description:No description available | ||||
TranFinPeriodID | char(6) | - | ||
Description:No description available | ||||
TranLastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
TranLastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
TranLastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
TranOrigModule | char(2) | - | ||
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
TranRefNbr | nvarchar(15) | - | ||
Description:No description available | ||||
TranReleased | bit | - | ||
Description:No description available | ||||
TransferType | char(1) | Transfer Type | - | |
Description:No description available | ||||
TranTranDate | datetime2 | - | ||
Description:No description available | ||||
TranTranDesc | nvarchar(256) | Description | - | |
Description:No description available | ||||
TranTranPeriodID | char(6) | - | ||
Description:No description available | ||||
Trantstamp | timestamp | - | ||
Description:No description available | ||||
TranType | char(3) | Tran. Type | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnassignedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
UnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
UnitPrice | decimal(19, 6) | Unit Price | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||
UpdateShippedNotInvoiced | bit | - | ||
Description:No description available | ||||