Dynamics GP Table Reference - COMPANY..ItemMth fields

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

Module List > Module TM tables ItemMth

You are currently viewing the COMPANY database.
Change

COMPANY..ItemMth Table Definition

(COMPANY..)

Field Definitions:

	Column Name	Data Type Default Value		Source
	ITEMNMBR	char ''	span style...(more) Join Now	JC00701.ITEMNMBR
join ... more text available
	ITEMDESC	char ''	Item Descr...(more) Join Now	WO010116.ITEMDESC

	ITMSHNAM	char ''

	ITMGEDSC	char ''

	ITMCLSCD	char ''	Item Class...(more) Join Now	IV00101.ITMCLSCD

	DECPLQTY	smallint 0	Decimal Pl...(more) Join Now

	QTYBSUOM	numeric 0.00	QTY In Bas...(more) Join Now	PK010033.QTYBSUOM

	QTYONHND	numeric 0.00

	ATYALLOC	numeric 0.00	QTY Alloca...(more) Join Now	IV00112.ATYALLOC

	AA_QTY_Available_Month00	numeric 0.00

	AA_QTY_Available_Month01	numeric 0.00

	AA_QTY_Available_Month02	numeric 0.00

	AA_QTY_Available_Month03	numeric 0.00

	AA_QTY_Available_Month04	numeric 0.00

	AA_QTY_Available_Month05	numeric 0.00

	AA_QTY_Available_Month06	numeric 0.00

	QTYBKORD	numeric 0.00

	AA_QTY_Back_Ordered_N01	numeric 0.00

	AA_QTY_Back_Ordered_N02	numeric 0.00

	AA_QTY_Back_Ordered_N03	numeric 0.00

	AA_QTY_Back_Ordered_N04	numeric 0.00

	AA_QTY_Back_Ordered_N05	numeric 0.00

	AA_QTY_Back_Ordered_N06	numeric 0.00

	AA_QTY_Back_Ordered_Mont	numeric 0.00

	AA_QTY_Back_Ordered_01	numeric 0.00

	AA_QTY_Back_Ordered_02	numeric 0.00

	AA_QTY_Back_Ordered_03	numeric 0.00

	AA_QTY_Back_Ordered_04	numeric 0.00

	AA_QTY_Back_Ordered_05	numeric 0.00

	AA_QTY_Back_Ordered_06	numeric 0.00

	AA_QTY_Forecast	numeric 0.00

	AA_QTY_Forecast_MonthN01	numeric 0.00

	AA_QTY_Forecast_MonthN02	numeric 0.00

	AA_QTY_Forecast_MonthN03	numeric 0.00

	AA_QTY_Forecast_MonthN04	numeric 0.00

	AA_QTY_Forecast_MonthN05	numeric 0.00

	AA_QTY_Forecast_MonthN06	numeric 0.00

	AA_QTY_Forecast_Month_00	numeric 0.00

	AA_QTY_Forecast_Month_01	numeric 0.00

	AA_QTY_Forecast_Month_02	numeric 0.00

	AA_QTY_Forecast_Month_03	numeric 0.00

	AA_QTY_Forecast_Month_04	numeric 0.00

	AA_QTY_Forecast_Month_05	numeric 0.00

	AA_QTY_Forecast_Month_06	numeric 0.00

	QTYONORD	numeric 0.00

	AA_QTY_On_Order_N01	numeric 0.00

	AA_QTY_On_Order_N02	numeric 0.00

	AA_QTY_On_Order_N03	numeric 0.00

	AA_QTY_On_Order_N04	numeric 0.00

	AA_QTY_On_Order_N05	numeric 0.00

	AA_QTY_On_Order_N06	numeric 0.00

	AA_QTY_On_Order_Month_00	numeric 0.00

	AA_QTY_On_Order_Month_01	numeric 0.00

	AA_QTY_On_Order_Month_02	numeric 0.00

	AA_QTY_On_Order_Month_03	numeric 0.00

	AA_QTY_On_Order_Month_04	numeric 0.00

	AA_QTY_On_Order_Month_05	numeric 0.00

	AA_QTY_On_Order_Month_06	numeric 0.00

	AA_QTY_PO_Forecast	numeric 0.00

	AA_QTY_PO_Forecast_MN0	numeric 0.00

	AA_QTY_PO_Forecast_MN02	numeric 0.00

	AA_QTY_PO_Forecast_MN03	numeric 0.00

	AA_QTY_PO_Forecast_MN04	numeric 0.00

	AA_QTY_PO_Forecast_MN05	numeric 0.00

	AA_QTY_PO_Forecast_M06	numeric 0.00

	AA_QTY_PO_Forecast_M00	numeric 0.00

	AA_QTY_PO_Forecast_M01	numeric 0.00

	AA_QTY_PO_Forecast_M02	numeric 0.00

	AA_QTY_PO_Forecast_M03	numeric 0.00

	AA_QTY_PO_Forecast_M04	numeric 0.00

	AA_QTY_PO_Forecast_M05	numeric 0.00

	AA_QTY_PO_ForecastM06	numeric 0.00

	QTYORDER	numeric 0.00

	AA_QTY_Ordered_Month_01	numeric 0.00

	AA_QTY_Ordered_Month_02	numeric 0.00

	AA_QTY_Ordered_Month_03	numeric 0.00

	AA_QTY_Ordered_Month_04	numeric 0.00

	AA_QTY_Ordered_Month_05	numeric 0.00

	AA_QTY_Ordered_Month_06	numeric 0.00

	AA_QTY_Ordered_Month_00	numeric 0.00

	AA_QTY_Ordered_Month01	numeric 0.00

	AA_QTY_Ordered_Month02	numeric 0.00

	AA_QTY_Ordered_Month03	numeric 0.00

	AA_QTY_Ordered_Month04	numeric 0.00

	AA_QTY_Ordered_Month05	numeric 0.00

	AA_QTY_Ordered_Month06	numeric 0.00

	AA_QTY_Projected	numeric 0.00

	AA_QTY_Projected_MthN01	numeric 0.00

	AA_QTYProjected_MtnN02	numeric 0.00

	AA_QTYProjected_MthN03	numeric 0.00

	AA_QTYProjected_Mthn04	numeric 0.00

	AA_QTYProjected_MthN05	numeric 0.00

	AA_QTYProjected_MthN06	numeric 0.00

	AA_QTY_Projected_Month0	numeric 0.00

	AA_QTY_Projected_Month01	numeric 0.00

	AA_QTY_Projected_Month02	numeric 0.00

	AA_QTY_Projected_Month03	numeric 0.00

	AA_QTY_Projected_Month04	numeric 0.00

	AA_QTY_Projected_Month05	numeric 0.00

	AA_QTY_Projected_Month06	numeric 0.00

	AA_QTY_Sold	numeric 0.00

	AA_QTY_Sold_MonthN01	numeric 0.00

	AA_QTY_Sold_MonthN02	numeric 0.00

	AA_QTY_Sold_MonthN03	numeric 0.00

	AA_QTY_Sold_MonthN04	numeric 0.00

	AA_QTY_Sold_MonthN05	numeric 0.00

	AA_QTY_Sold_MonthN06	numeric 0.00

	AA_QTY_Sold_Month_00	numeric 0.00

	AA_QTY_Sold_Month_01	numeric 0.00

	AA_QTY_Sold_Month_02	numeric 0.00

	AA_QTY_Sold_Month_03	numeric 0.00

	AA_QTY_Sold_Month_04	numeric 0.00

	AA_QTY_Sold_Month_05	numeric 0.00

	AA_QTY_Sold_Month_06	numeric 0.00

	DEX_ROW_ID	int auto number (1,1)	Unique ide...(more) Join Now

DynDeveloper.com

COMPANY..ItemMth Table Definition

Field Definitions: