CREATE TABLE IV70500(
	PRTBYSIT smallint NOT NULL,
	PRNTOPTN smallint NOT NULL,
	STTGNDSC char(11) NOT NULL,
	ENGENDSC char(11) NOT NULL,
	ENUSRCAT_1 char(11) NOT NULL,
	ENUSRCAT_2 char(11) NOT NULL,
	ENUSRCAT_3 char(11) NOT NULL,
	ENUSRCAT_4 char(11) NOT NULL,
	ENUSRCAT_5 char(11) NOT NULL,
	ENUSRCAT_6 char(11) NOT NULL,
	KITSRTBY smallint NOT NULL,
	STRTUCAT_1 char(11) NOT NULL,
	STRTUCAT_2 char(11) NOT NULL,
	STRTUCAT_3 char(11) NOT NULL,
	STRTUCAT_4 char(11) NOT NULL,
	STRTUCAT_5 char(11) NOT NULL,
	STRTUCAT_6 char(11) NOT NULL,
	STTITNUM char(31) NOT NULL,
	ENITMNBR char(31) NOT NULL,
	PRVDRINF smallint NOT NULL,
	PRTDSCNT tinyint NOT NULL,
	FINRPTNM char(31) NOT NULL,
	PRNTNOTS tinyint NOT NULL,
	PRNTTYPE smallint NOT NULL,
	ASKECHTM tinyint NOT NULL,
	INCLGNDS tinyint NOT NULL,
	PRNTOFIL tinyint NOT NULL,
	PRTOPRTR tinyint NOT NULL,
	PRTOSCRN tinyint NOT NULL,
	IFFILXST smallint NOT NULL,
	FILEXPNM char(255) NOT NULL,
	EXPTTYPE smallint NOT NULL,
	RPTGRIND smallint NOT NULL,
	STTCLASS char(11) NOT NULL,
	ENDCLASS char(11) NOT NULL,
	STTSCHED char(11) NOT NULL,
	ENSCHDUL char(11) NOT NULL,
	STTLOCCD char(11) NOT NULL,
	ENLOCNCD char(11) NOT NULL,
	STTLOTTY char(11) NOT NULL,
	ENLOTTYP char(11) NOT NULL,
	STRTNGDT datetime NOT NULL,
	ENDINGDT datetime NOT NULL,
	ENDTKNDT smallint NOT NULL,
	STTOKNDT smallint NOT NULL,
	STRCTNUM char(21) NOT NULL,
	ENRCTNBR char(21) NOT NULL,
	RTPACHIN smallint NOT NULL,
	RTGRSBIN numeric(19, 5) NOT NULL,
	SORTBY smallint NOT NULL,
	PRTSRLOT tinyint NOT NULL,
	INZROQTY tinyint NOT NULL,
	PRTITQTY tinyint NOT NULL,
	STTBINUM char(21) NOT NULL,
	ENBINNBR char(21) NOT NULL,
	STDOCNUM char(21) NOT NULL,
	ENDOCNUM char(21) NOT NULL,
	STDOCTYP smallint NOT NULL,
	ENDOCTYP smallint NOT NULL,
	STTMODUL char(3) NOT NULL,
	ENDMODUL char(3) NOT NULL,
	STRXSRC char(13) NOT NULL,
	ENTRXSRC char(13) NOT NULL,
	STBCHSRC char(15) NOT NULL,
	ENBCHSRC char(15) NOT NULL,
	STBCHNUM char(15) NOT NULL,
	ENDBNMBR char(15) NOT NULL,
	STVNDRID char(15) NOT NULL,
	ENDVNDID char(15) NOT NULL,
	INQTYREQ tinyint NOT NULL,
	INZRORLV tinyint NOT NULL,
	CALSGQTY smallint NOT NULL,
	RCPTOPTS smallint NOT NULL,
	VENDROPT smallint NOT NULL,
	SEGSRTBY smallint NOT NULL,
	STTACNUM_1 char(7) NOT NULL,
	STTACNUM_2 char(7) NOT NULL,
	STTACNUM_3 char(7) NOT NULL,
	STTACNUM_4 char(7) NOT NULL,
	STTACNUM_5 char(7) NOT NULL,
	EACCNBR_1 char(7) NOT NULL,
	EACCNBR_2 char(7) NOT NULL,
	EACCNBR_3 char(7) NOT NULL,
	EACCNBR_4 char(7) NOT NULL,
	EACCNBR_5 char(7) NOT NULL,
	SEGMNTRG smallint NOT NULL,
	Start_PriceLevel char(11) NOT NULL,
	End_PriceLevel char(11) NOT NULL,
	Start_QTY_Type smallint NOT NULL,
	End_QTY_Type smallint NOT NULL,
	Start_Component_Item_Num char(31) NOT NULL,
	End_Component_Item_Numbe char(31) NOT NULL,
	BM_Assembly_Journal tinyint NOT NULL,
	BM_Distribution_Detail tinyint NOT NULL,
	BM_Bill_Status_Active tinyint NOT NULL,
	BM_Bill_Status_Pending tinyint NOT NULL,
	BM_Bill_Status_Obsolete tinyint NOT NULL,
	BM_Comp_Status_Active tinyint NOT NULL,
	BM_Comp_Status_Pending tinyint NOT NULL,
	BM_Comp_Status_Obsolete tinyint NOT NULL,
	BM_Comp_Type_Misc_Charge tinyint NOT NULL,
	BM_Comp_Type_Services tinyint NOT NULL,
	BM_Comp_Type_Flat_Fee tinyint NOT NULL,
	BM_Print_Notes_Bill tinyint NOT NULL,
	BM_Print_Notes_Comp tinyint NOT NULL,
	BM_Print_Cost_Options smallint NOT NULL,
	Max_Levels smallint NOT NULL,
	DATE1 datetime NOT NULL,
	BMTRXSTATNOTREL tinyint NOT NULL,
	BMTRXSTATREL tinyint NOT NULL,
	OPTIONS smallint NOT NULL,
	Start_TRX_ID char(19) NOT NULL,
	End_TRX_ID char(19) NOT NULL,
	Starting_TRX_Date datetime NOT NULL,
	Ending_TRX_Date datetime NOT NULL,
	STRTSRLT char(21) NOT NULL,
	ENDSERLT char(21) NOT NULL,
	StartPriceGroup char(11) NOT NULL,
	EndPriceGroup char(11) NOT NULL,
	STCURRID char(15) NOT NULL,
	ENDCURID char(15) NOT NULL,
	STRTABCCD smallint NOT NULL,
	ENDABCCD smallint NOT NULL,
	STRTSTCKCNTID char(15) NOT NULL,
	ENDSTCKCNTID char(15) NOT NULL,
	Start_Landed_Cost_ID char(15) NOT NULL,
	End_Landed_Cost_ID char(15) NOT NULL,
	Start_LandedCostGroupID char(15) NOT NULL,
	End_LandedCostGroupID char(15) NOT NULL,
	ASOFDATE datetime NOT NULL,
	INZRQTYI tinyint NOT NULL,
	STARTBIN char(15) NOT NULL,
	ENDBIN char(15) NOT NULL,
	LNGSTRTDESC char(101) NOT NULL,
	LNGENDDESC char(101) NOT NULL,
	USEGLPOSTINGDATE tinyint NOT NULL,
	INNGVQTY tinyint NOT NULL,
	COSTAVGPERIODIC smallint NOT NULL,
	DEX_ROW_ID int NOT NULL
) character set utf8;