IN
INTranCost
PX.Objects.IN39 of 39 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CostDocType | char(1) | - | ||
Description:No description available | ||||
CostID | bigint | - | ||
Description:No description available | ||||
CostRefNbr | nvarchar(15) | INRegister | ||
Description:No description available | ||||
DocType | char(1) | - | ||
Description:No description available | ||||
LineNbr | int | INTran | ||
Description:No description available | ||||
RefNbr | nvarchar(15) | Ref. Number | INRegister | |
Description:No description available | ||||
COGSAcctID | int | Account | Account | |
Description:No description available | ||||
COGSSubID | int | Subaccount | Sub | |
Description:No description available | ||||
CostSiteID | int | INSite | ||
Description:No description available | ||||
CostSubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
CostType | char(1) | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created | - | |
Description:No description available | ||||
FinPeriodID | char(6) | - | ||
Description:No description available | ||||
InventoryID | int | InventoryItem | ||
Description:No description available | ||||
InvtAcctID | int | Account | Account | |
Description:No description available | ||||
InvtMult | smallint | Inventory Multiplier | - | |
Description:No description available | ||||
InvtSubID | int | Subaccount | Sub | |
Description:No description available | ||||
IsOversold | bit | - | ||
Description:No description available | ||||
IsVirtualObsolete | 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 | ||||
LotSerialNbr | nvarchar(100) | - | ||
Description:No description available | ||||
OversoldQty | decimal(25, 6) | - | ||
Description:No description available | ||||
OversoldTranCost | decimal(25, 6) | - | ||
Description:No description available | ||||
Qty | decimal(25, 6) | Qty. | - | |
Description:No description available | ||||
QtyOnHandNonexistent in DB | decimal | - | ||
Description:No description available | ||||
SiteID | int | - | ||
Description:The identifier of the warehouse | ||||
TotalCostNonexistent in DB | decimal | - | ||
Description:No description available | ||||
TranAmtNonexistent in DB | decimal | - | ||
Description:No description available | ||||
TranCost | decimal(19, 4) | Transaction Cost | - | |
Description:No description available | ||||
TranDate | datetime2 | Transaction Date | - | |
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
TranType | char(3) | Transaction Type | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnitCostNonexistent in DB | decimal | - | ||
Description:No description available | ||||
VarCost | decimal(19, 4) | - | ||
Description:No description available | ||||