IN
INTran2
Added for join purpose
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AMBatNbr | nvarchar(15) | MFG Batch Nbr | AMBatch | |
Description:No description available | ||||
AMDocType | char(1) | MFG Doc. Type | - | |
Description:No description available | ||||
AMLineNbr | int | MFG Line Nbr. | - | |
Description:No description available | ||||
AMOrderType | char(2) | Prod. Order Type | - | |
Description:No description available | ||||
AMProdOrdID | nvarchar(19) | Production Nbr. | INTranExt | |
Description:No description available | ||||
ARDocType | nvarchar(3) | ARRegister | ||
Description:No description available | ||||
ARLineNbr | int | ARTran | ||
Description:No description available | ||||
ARRefNbr | nvarchar(15) | ARRegister | ||
Description:No description available | ||||
AccrueCost | bit | - | ||
Description:When set to "true", indicates that cost will be processed using expense accrual account. | ||||
AcctID | int | Account | Account | |
Description:No description available | ||||
AppointmentLineNbr | int | Appointment Line Nbr. | - | |
Description:No description available | ||||
AppointmentRefNbr | nvarchar(20) | Appointment Nbr. | - | |
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 | ||||
CostLayerType | char(1) | Cost Layer Type | - | |
Description:No description available | ||||
CostedQtyNonexistent in DB | decimal? | - | ||
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 | ||||
DestBranchID | int | Branch | ||
Description:No description available | ||||
DocType | char(1) | Document Type | - | |
Description:No description available | ||||
ExactCost | bit | - | ||
Description:No description available | ||||
ExpireDate | datetime | Expiration Date | - | |
Description:No description available | ||||
FinPeriodID | string | - | ||
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 | InventoryItem | |
Description:No description available | ||||
InventorySource | char(1) | Inventory Source | - | |
Description:The source of material for a transaction line. | ||||
InvtAcctID | int | Account | Account | |
Description:No description available | ||||
InvtMult | smallint | Multiplier | - | |
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 | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineNbr | int | Line Number | - | |
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) | INRegister | ||
Description:No description available | ||||
OrigFullQty | decimal | - | ||
Description:No description available | ||||
OrigIsLotSerial | bit | - | ||
Description:Denormalization of INTranSplit.LotSerialNbr | ||||
OrigLineNbr | int | INTran | ||
Description:No description available | ||||
OrigModule | char(2) | Source | - | |
Description:No description available | ||||
OrigNoteID | uniqueidentifier | - | ||
Description:Denormalization of INRegister.NoteID | ||||
OrigPlanType | char(2) | INPlanType | ||
Description:No description available | ||||
OrigQtyNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | Receipt Nbr. | INRegister | |
Description:No description available | ||||
OrigToLocationID | int | INLocation | ||
Description:Denormalization of INTranSplit.ToLocationID | ||||
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 | bool? | - | ||
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 | POReceipt | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
Qty | decimal | 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 | ||||
RefNbr | nvarchar(15) | Reference Nbr. | INRegister | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
ReleasedDateTime | datetime | Release Date | - | |
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 | ||||
SOShipmentLineNbr | int | SOShipLine | ||
Description:No description available | ||||
SOShipmentNbr | nvarchar(15) | SO Shipment Nbr. | SOShipment | |
Description:No description available | ||||
SOShipmentType | char(1) | SOShipment | ||
Description:No description available | ||||
SalesMultNonexistent in DB | short? | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ServiceContractPeriodIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
ServiceContractRefNbrNonexistent in DB | string | - | ||
Description:No description available | ||||
ServiceOrderLineNbr | int | Service Order Line Nbr. | - | |
Description:No description available | ||||
ServiceOrderRefNbr | nvarchar(15) | Service Order Nbr. | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SortOrder | int | Line Order | - | |
Description:No description available | ||||
SpecialOrderCostCenterIDNonexistent in DB | int? | Special Order Nbr. | INCostCenter | |
Description:No description available | ||||
SrvOrdType | char(4) | Service Order Type | - | |
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
ToCostCenterID | int | - | ||
Description:No description available | ||||
ToCostCodeID | int | To Cost Code | PMCostCode | |
Description:No description available | ||||
ToCostLayerType | char(1) | To Cost Layer Type | - | |
Description:No description available | ||||
ToInventorySource | char(1) | To Inventory Source | - | |
Description:The destination source of material for a transaction line. | ||||
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. | INCostCenter | |
Description:No description available | ||||
ToTaskID | int | To Project Task | PMTask | |
Description:No description available | ||||
TranAmt | decimal | Ext. Price | - | |
Description:No description available | ||||
TranCost | decimal | Ext. Cost | - | |
Description:No description available | ||||
TranDate | datetime | - | ||
Description:No description available | ||||
TranDesc | nvarchar(256) | Description | - | |
Description:No description available | ||||
TranPeriodID | string | - | ||
Description:No description available | ||||
TranType | char(3) | Tran. Type | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UnassignedQty | decimal | - | ||
Description:No description available | ||||
UnitCost | decimal | Unit Cost | - | |
Description:No description available | ||||
UnitPrice | decimal | Unit Price | - | |
Description:No description available | ||||
UpdateShippedNotInvoiced | bit | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||