<?php
class QuotationTable extends Table {
	
	const C_TABLE                       = "QUOTATION" ;
	const C_ID                          = "QUOTATION_ID";
	const C_CODE                        = "QUOTATION_CODE";
	const C_DATE                        = "QUOTATION_DATE";
	const C_CUST_ID                 	= "QUOTATION_CUSTOMER_ID";
	const C_IS_CUST                 	= "IS_CUSTOMER";
	const C_PROSPECT_NAME               = "QUOTATION_PROSPECT_NAME";
	const C_PROSPECT_CODE               = "QUOTATION_PROSPECT_CODE";
	const C_CONTACT_NAME           		= "QUOTATION_CONTACT_NAME";
	const C_CONTACT_PHONE           	= "QUOTATION_CONTACT_PHONE";
	const C_CONTACT_EMAIL           	= "QUOTATION_CONTACT_EMAIL";
	const C_COMMENT                 	= "QUOTATION_COMMENT";
	const C_FOOTER                 		= "QUOTATION_FOOTER";
	const C_TOTAL_QTY                 	= "QUOTATION_TOTAL_QTY";
	const C_GRAND_TOTAL                 = "QUOTATION_GRAND_TOTAL";
	const C_STATUS                 		= "QUOTATION_STATUS";
}

class QuotationTableDetail extends TableDetail {
	
	const C_ID                          = "identity|||";
	const C_CODE                 		= "nvarchar|50|NO|''";
	const C_DATE                 		= "datetime||NO|getdate()";
	const C_CUST_ID                 	= "int||NO|(0)";
	const C_IS_CUST                 	= "int||NO|(0)";
	const C_PROSPECT_NAME              	= "nvarchar|255|NO|''";
	const C_PROSPECT_CODE              	= "nvarchar|20|NO|''";
	const C_CONTACT_NAME              	= "nvarchar|100|NO|''";
	const C_CONTACT_PHONE              	= "nvarchar|20|NO|''";
	const C_CONTACT_EMAIL              	= "nvarchar|100|NO|''";
	const C_COMMENT                 	= "text||NO|''";
	const C_FOOTER                 		= "text||NO|''";
	const C_TOTAL_QTY                 	= "int||NO|(0)";
	const C_GRAND_TOTAL                 = "decimal|18,4|NO|(0)";
	const C_STATUS                 		= "int||NO|(0)";
}
?>