IN
InventoryTranByAcctEnq.INSite2
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AMMRPFcst | bit | Forecasts | - | |
Description:MRP Include Forecasts | ||||
AMMRPFlag | bit | Inventory On Hand | - | |
Description:MRP Include Inventory On Hand | ||||
AMMRPMPS | bit | MPS | - | |
Description:MRP Include MPS | ||||
AMMRPPO | bit | Purchase Orders | - | |
Description:MRP Include Purchase Orders | ||||
AMMRPProd | bit | Production Orders | - | |
Description:MRP Include Production Orders | ||||
AMMRPSO | bit | Sales Orders | - | |
Description:MRP Include Sales Orders | ||||
AMMRPShip | bit | Shipments | - | |
Description:MRP Include Shipments | ||||
AMScrapLocationID | int | Scrap Location | INLocation | |
Description:No description available | ||||
AMScrapSiteID | int | Scrap Warehouse | - | |
Description:No description available | ||||
AMWIPAcctID | int | Work in Process Account | Account | |
Description:No description available | ||||
AMWIPSubID | int | Work In Process Sub. | Sub | |
Description:No description available | ||||
AMWIPVarianceAcctID | int | WIP Variance Account | Account | |
Description:No description available | ||||
AMWIPVarianceSubID | int | WIP Variance Sub. | Sub | |
Description:No description available | ||||
Active | bit | Active | - | |
Description:No description available | ||||
AddressID | int | Address | ||
Description:No description available | ||||
AvgDefaultCost | char(1) | Average Default Cost | - | |
Description:No description available | ||||
BAccountID | int | - | ||
Description:No description available | ||||
BaseCuryID | nvarchar(5) | Base Currency ID | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
BuildingID | int | Building ID | INSiteBuilding | |
Description:No description available | ||||
COGSAcctID | int | COGS/Expense Account | Account | |
Description:No description available | ||||
COGSSubID | int | COGS/Expense Sub. | Sub | |
Description:No description available | ||||
CarrierFacility | nvarchar(50) | Carrier Facility | - | |
Description:No description available | ||||
ContactID | int | Contact | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
Descr | nvarchar(60) | Description | - | |
Description:No description available | ||||
DiscAcctIDNonexistent in DBObsolete | int? | - | ||
Description:No description available | ||||
DiscSubIDNonexistent in DBObsolete | int? | - | ||
Description:No description available | ||||
DropShipLocationID | int | Drop-Ship Location | INLocation | |
Description:No description available | ||||
FIFODefaultCost | char(1) | FIFO Default Cost | - | |
Description:No description available | ||||
FreightAcctIDNonexistent in DBObsolete | int? | - | ||
Description:No description available | ||||
FreightSubIDNonexistent in DBObsolete | int? | - | ||
Description:No description available | ||||
GroupMask | varbinary | - | ||
Description:No description available | ||||
IncludedNonexistent in DB | bool? | Included | - | |
Description:No description available | ||||
InvtAcctID | int | Inventory Account | Account | |
Description:No description available | ||||
InvtSubID | int | Inventory Sub. | Sub | |
Description:No description available | ||||
LCVarianceAcctID | int | Landed Cost Variance Account | Account | |
Description:No description available | ||||
LCVarianceSubID | int | Landed Cost Variance Sub. | Sub | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LocationValid | char(1) | Location Entry | - | |
Description:No description available | ||||
MiscAcctIDNonexistent in DBObsolete | int? | - | ||
Description:No description available | ||||
MiscSubIDNonexistent in DBObsolete | int? | - | ||
Description:No description available | ||||
NonStockPickingLocationID | int | Non-Stock Location | INLocation | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OverrideInvtAccSub | bit | Override Inventory Account/Sub. | - | |
Description:No description available | ||||
POAccrualAcctID | int | PO Accrual Account | Account | |
Description:No description available | ||||
POAccrualSubID | int | PO Accrual Sub. | Sub | |
Description:No description available | ||||
PPVAcctID | int | Purchase Price Variance Account | Account | |
Description:No description available | ||||
PPVSubID | int | Purchase Price Variance Sub. | Sub | |
Description:No description available | ||||
ReasonCodeSubID | int | Reason Code Sub. | Sub | |
Description:No description available | ||||
ReceiptLocationID | int | Receiving Location | INLocation | |
Description:No description available | ||||
ReceiptLocationIDOverrideNonexistent in DB | bool? | - | ||
Description:No description available | ||||
ReplenishmentClassID | nvarchar(10) | Replenishment Class | INReplenishmentClass | |
Description:No description available | ||||
ReturnLocationID | int | RMA Location | INLocation | |
Description:No description available | ||||
SalesAcctID | int | Sales Account | Account | |
Description:No description available | ||||
SalesSubID | int | Sales Sub. | Sub | |
Description:No description available | ||||
ShipLocationID | int | Shipping Location | INLocation | |
Description:No description available | ||||
ShipLocationIDOverrideNonexistent in DB | bool? | - | ||
Description:No description available | ||||
SiteCD | nvarchar(30) | Warehouse ID | INSite | |
Description:No description available | ||||
SiteID | int | - | ||
Description:No description available | ||||
StdCstRevAcctID | int | Standard Cost Revaluation Account | Account | |
Description:No description available | ||||
StdCstRevSubID | int | Standard Cost Revaluation Sub. | Sub | |
Description:No description available | ||||
StdCstVarAcctID | int | Standard Cost Variance Account | Account | |
Description:No description available | ||||
StdCstVarSubID | int | Standard Cost Variance Sub. | Sub | |
Description:No description available | ||||
UseItemDefaultLocationForPicking | bit | Use Item Default Location for Picking | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||