IN
INComponentTran
PX.Objects.IN112 of 112 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
DocType | char(1) | - | ||
Description:No description available | ||||
LineNbr | int | - | ||
Description:No description available | ||||
RefNbr | nvarchar(15) | INRegister | ||
Description:No description available | ||||
AccrueCost | bit | - | ||
Description:No description available | ||||
AcctID | int | Account | Account | |
Description:No description available | ||||
ARDocType | varchar(3) | - | ||
Description:No description available | ||||
ARLineNbr | int | ARTran | ||
Description:No description available | ||||
ARRefNbr | nvarchar(15) | ARRegister | ||
Description:No description available | ||||
AssyType | char(1) | - | ||
Description:No description available | ||||
AvgCostNonexistent in DB | decimal | - | ||
Description:No description available | ||||
BAccountID | int | BAccount | ||
Description:No description available | ||||
BaseOrigFullQty | decimal | - | ||
Description:No description available | ||||
BaseQty | decimal | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
COGSAcctID | int | Account | Account | |
Description:No description available | ||||
COGSSubID | int | Subaccount | Sub | |
Description:No description available | ||||
CostCenterID | int | - | ||
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
CostedQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
CostLayerType | char(1) | Cost Layer Type | - | |
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 | ||||
DestBranchID | int | Branch | ||
Description:No description available | ||||
ExactCost | bit | - | ||
Description:No description available | ||||
ExpireDate | datetime2 | Expiration Date | - | |
Description:No description available | ||||
FinPeriodID | char(6) | - | ||
Description:No description available | ||||
INTransitBaseQtyNonexistent in DB | decimal | In-Transit Base Qty. | - | |
Description:No description available | ||||
INTransitQtyNonexistent in DB | decimal | In-Transit Qty. | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
InventorySource | char(1) | Inventory Source | - | |
Description:No description available | ||||
InvtAcctID | int | Account | Account | |
Description:No description available | ||||
InvtMult | smallint | - | ||
Description:No description available | ||||
InvtSubID | int | Subaccount | Sub | |
Description:No description available | ||||
IsComponentItem | bit | - | ||
Description:No description available | ||||
IsCostUnmanaged | bit | - | ||
Description:No description available | ||||
IsIntercompany | bit | - | ||
Description:No description available | ||||
IsSpecialOrder | bit | Special Order | - | |
Description:No description available | ||||
IsStockItem | bit | - | ||
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 | INLocation | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | - | |
Description:No description available | ||||
ManualCost | bit | Manual Cost | - | |
Description:No description available | ||||
MaxTransferBaseQty | decimal | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigDocType | char(1) | - | ||
Description:No description available | ||||
OrigFullQty | decimal | - | ||
Description:No description available | ||||
OrigIsLotSerial | bit | - | ||
Description:No description available | ||||
OrigLineNbr | int | - | ||
Description:No description available | ||||
OrigModule | char(2) | - | ||
Description:No description available | ||||
OrigNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigPlanType | char(2) | INPlanType | ||
Description:No description available | ||||
OrigQty | decimal | - | ||
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | Receipt Nbr. | INRegister | |
Description:No description available | ||||
OrigToLocationID | int | INLocation | ||
Description:No description available | ||||
OrigTranAmtNonexistent in DB | decimal | - | ||
Description:No description available | ||||
OrigTranCostNonexistent in DB | decimal | - | ||
Description:No description available | ||||
OrigTranType | char(3) | - | ||
Description:No description available | ||||
OrigUOM | nvarchar(6) | - | ||
Description:No description available | ||||
OverrideUnitCostNonexistent in DB | bit | - | ||
Description:No description available | ||||
PIID | nvarchar(15) | INPIHeader | ||
Description:No description available | ||||
PILineNbr | int | PI Line Nbr. | INPIDetail | |
Description:No description available | ||||
POLineType | char(2) | - | ||
Description:No description available | ||||
POReceiptLineNbr | int | POReceiptLine | ||
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 | ||||
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 | ||||
ReceiptedBaseQtyNonexistent in DB | decimal | Received Base Qty. | - | |
Description:No description available | ||||
ReceiptedQtyNonexistent in DB | decimal | Received Qty. | - | |
Description:No description available | ||||
ReclassificationProhibited | bit | - | ||
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
ReleasedDateTime | datetime | Release Date | - | |
Description:No description available | ||||
SalesMultNonexistent in DB | smallint | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | int | INCostCenter | ||
Description:No description available | ||||
SOLineType | char(2) | - | ||
Description:No description available | ||||
SOOrderLineNbr | int | SOLine | ||
Description:No description available | ||||
SOOrderNbr | nvarchar(15) | SO Order Nbr. | SOOrder | |
Description:No description available | ||||
SOOrderType | char(2) | SO Order Type | SOOrderType | |
Description:No description available | ||||
SortOrder | int | Line Order | - | |
Description:No description available | ||||
SOShipmentLineNbr | int | SOShipLine | ||
Description:No description available | ||||
SOShipmentNbr | nvarchar(15) | SO Shipment Nbr. | SOOrderShipment | |
Description:No description available | ||||
SOShipmentType | char(1) | - | ||
Description:No description available | ||||
SpecialOrderCostCenterIDNonexistent in DB | int | Special Order Nbr. | - | |
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
SubItemID | int | Subitem | - | |
Description:No description available | ||||
TaskID | int | Project Task | - | |
Description:No description available | ||||
ToCostCenterID | int | - | ||
Description:No description available | ||||
ToCostCodeID | int | To Cost Code | - | |
Description:No description available | ||||
ToCostLayerType | char(1) | To Cost Layer Type | - | |
Description:No description available | ||||
ToInventorySource | char(1) | To Inventory Source | - | |
Description:No description available | ||||
ToLocationID | int | To Location ID | INLocation | |
Description:No description available | ||||
ToProjectID | int | To Project | PMProject | |
Description:No description available | ||||
ToSiteID | int | To Site ID | INSite | |
Description:No description available | ||||
ToSpecialOrderCostCenterIDNonexistent in DB | int | To Special Order Nbr. | - | |
Description:No description available | ||||
ToTaskID | int | To Project Task | PMTask | |
Description:No description available | ||||
TranAmt | decimal | Ext. Price | - | |
Description:No description available | ||||
TranCost | decimal(19, 6) | Ext. Cost | - | |
Description:No description available | ||||
TranDate | datetime2 | - | ||
Description:No description available | ||||
TranDesc | nvarchar(256) | Description | - | |
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
TranType | char(3) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnassignedQty | decimal | - | ||
Description:No description available | ||||
UnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
UnitPrice | decimal | Unit Price | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||
UpdateShippedNotInvoiced | bit | - | ||
Description:No description available | ||||