<?php
class SalesQuotationTable extends Table {
	
	const C_TABLE                       = "SALES_QUOTATION" ;
	const C_PK                          = "SALES_QUOTATION_ID";
	const C_ID                          = "SALES_QUOTATION_ID";
	const C_BU                    	 	= "SALES_QUOTATION_BU";
	const C_TYPE                    	= "SALES_QUOTATION_TYPE";
	const C_NUMBER                      = "SALES_QUOTATION_NUMBER";
	const C_DATE                        = "SALES_QUOTATION_DATE";
	const C_CUSTOMER_ID                 = "SALES_QUOTATION_CUSTOMER_ID";
	const C_CONTACT_ID           		= "SALES_QUOTATION_CONTACT_ID";
	const C_CONTACT_EMAIL           	= "SALES_QUOTATION_CONTACT_EMAIL";
	const C_CONTACT_MOBILE		        = "SALES_QUOTATION_CONTACT_MOBILE";
	const C_CONTACT_TELEPHONE           = "SALES_QUOTATION_CONTACT_TELEPHONE";
	const C_CURRENCY           			= "SALES_QUOTATION_CURRENCY";
	const C_PROSPECT                 	= "SALES_QUOTATION_IS_PROSPECT";
	const C_PROSPECT_NAME               = "SALES_QUOTATION_PROSPECT_NAME";
	const C_PROSPECT_CONTACT            = "SALES_QUOTATION_PROSPECT_CONTACT_NAME";
	const C_STATUS                 		= "SALES_QUOTATION_STATUS";
	const C_ISSUE_DATE                 	= "SALES_QUOTATION_ISSUE_DATE";
	const C_REVISE_TYPE              	= "SALES_QUOTATION_REVISE_TYPE";
	const C_REVISE_DATE                 = "SALES_QUOTATION_REVISE_DATE";
	const C_REVISE_VERSION              = "SALES_QUOTATION_REVISE_VERSION";
	const C_CUSTOMER_REVISE_DATE        = "SALES_QUOTATION_CUSTOMER_REVISE_DATE";
	const C_CUSTOMER_REVISE_VERSION     = "SALES_QUOTATION_CUSTOMER_REVISE_VERSION";
	const C_CUSTOMER_NUMBER     		= "SALES_QUOTATION_CUSTOMER_NUMBER";
	const C_ACCEPT_DATE                 = "SALES_QUOTATION_ACCEPT_DATE";
	const C_FOOTER             			= "SALES_QUOTATION_FOOTER";
	const C_ISSUE             			= "SALES_QUOTATION_ISSUE";
	const C_ITEMS_TOTAL           		= "SALES_QUOTATION_ITEMS_TOTAL";
	const C_ITEMS_GST           		= "SALES_QUOTATION_ITEMS_GST";
	const C_ISSUE_PRINT           		= "SALES_QUOTATION_ISSUE_PRINT";
	const C_ISSUE_PRINT_PAGE           	= "SALES_QUOTATION_ISSUE_PRINT_PAGE";
	const C_ITEMS_PRINT           		= "SALES_QUOTATION_ITEMS_PRINT";
	const C_ITEMS_PRINT_PAGE           	= "SALES_QUOTATION_ITEMS_PRINT_PAGE";
	const C_MAINTENANCE_PRINT           = "SALES_QUOTATION_MAINTENANCE_PRINT";
	const C_MAINTENANCE_PRINT_PAGE      = "SALES_QUOTATION_MAINTENANCE_PRINT_PAGE";
	const C_PROJECT_PLAN_PRINT          = "SALES_QUOTATION_PROJECT_PLAN_PRINT";
	const C_PROJECT_PLAN_PRINT_PAGE     = "SALES_QUOTATION_PROJECT_PLAN_PRINT_PAGE";
	const C_COVER_PRINT           		= "SALES_QUOTATION_COVER_PRINT";
	const C_COVER_PRINT_PAGE           	= "SALES_QUOTATION_COVER_PRINT_PAGE";
	const C_FOOTER_PRINT           		= "SALES_QUOTATION_FOOTER_PRINT";
	const C_FOOTER_PRINT_PAGE           = "SALES_QUOTATION_FOOTER_PRINT_PAGE";
	const C_APPENDIX_PRINT           	= "SALES_QUOTATION_APPENDIX_PRINT";
	const C_APPENDIX_PRINT_PAGE         = "SALES_QUOTATION_APPENDIX_PRINT_PAGE";
	const C_REF_ID        				= "SALES_QUOTATION_REF_ID";
	const C_TITLE       				= "SALES_QUOTATION_TITLE";
	const C_ADDITIONAL_CONTACT       	= "SALES_QUOTATION_ADDITIONAL_CONTACT";
	const C_ADDITIONAL_APPENDIX         = "SALES_QUOTATION_ADDITIONAL_APPENDIX";
	const C_IS_CLOSED                 	= "SALES_QUOTATION_IS_CLOSED";
	const C_CLOSED_DATE                 = "SALES_QUOTATION_CLOSED_DATE";
	const C_CLOSED_BY                 	= "SALES_QUOTATION_CLOSED_BY";
	const C_PREFERRED_INVOICE_DATE		= "SALES_QUOTATION_PREFERRED_INVOICE_DATE";
	const C_EXPECTED_ACCEPT_DATE		= "SALES_QUOTATION_EXPECTED_ACCEPT_DATE";
	const C_EXPECTED_PAY_DATE			= "SALES_QUOTATION_EXPECTED_PAY_DATE";
	const C_PERCENTAGE_PAYMENT			= "SALES_QUOTATION_PERCENTAGE_PAYMENT";
	const C_USER_DEFINED_1				= "SALES_QUOTATION_USER_DEFINED_1";
	const C_USER_DEFINED_2				= "SALES_QUOTATION_USER_DEFINED_2";
	const C_USER_DEFINED_3				= "SALES_QUOTATION_USER_DEFINED_3";
	const C_USER_DEFINED_4				= "SALES_QUOTATION_USER_DEFINED_4";
	const C_SUBMIT_DATE					= "SALES_QUOTATION_SUBMIT_DATE";
	const C_APPROVED_DATE				= "SALES_QUOTATION_APPROVED_DATE";
	const C_APPROVED_BY					= "SALES_QUOTATION_APPROVED_BY";
	const C_REJECT_REASON				= "SALES_QUOTATION_REJECT_REASON";
	const C_VIEWED						= "SALES_QUOTATION_IS_VIEWED";
	const C_VIEWED_DATE					= "SALES_QUOTATION_VIEWED_DATE";
	const C_PROBABILITY					= "SALES_QUOTATION_PROBABILITY";

}

class SalesQuotationTableDetail extends TableDetail {
	
	const C_ID                          = "identity|||";
	const C_BU                 			= "int||NO|(0)";
	const C_TYPE                 		= "int||NO|(0)";
	const C_NUMBER                 		= "nvarchar|50|NO|''";
	const C_DATE                 		= "datetime||NO|getdate()";
	const C_CUSTOMER_ID                 = "int||NO|(0)";
	const C_CONTACT_ID              	= "int||NO|(0)";
	const C_CONTACT_EMAIL              	= "nvarchar|100|NO|''";
	const C_CONTACT_MOBILE		        = "nvarchar|20|NO|''";
	const C_CONTACT_TELEPHONE           = "nvarchar|20|NO|''";
	const C_CURRENCY                 	= "int||NO|(0)";
	const C_PROSPECT                 	= "tinyint||NO|(0)";
	const C_PROSPECT_NAME              	= "nvarchar|255|NO|''";
	const C_PROSPECT_CONTACT            = "nvarchar|20|NO|''";
	const C_STATUS                 		= "int||NO|(0)";
	const C_ISSUE_DATE                 	= "datetime||NO|getdate()";
	const C_REVISE_TYPE         		= "int||NO|(0)";
	const C_REVISE_DATE                 = "datetime||NO|getdate()";
	const C_REVISE_VERSION              = "nvarchar|10|NO|''";
	const C_CUSTOMER_REVISE_DATE        = "datetime||NO|getdate()";
	const C_CUSTOMER_REVISE_VERSION     = "nvarchar|10|NO|''";
	const C_CUSTOMER_NUMBER             = "nvarchar|50|NO|''";
	const C_ACCEPT_DATE                 = "datetime||NO|getdate()";
	const C_FOOTER              		= "ntext||NO|''";
	const C_ISSUE              			= "ntext||NO|''";
	const C_ITEMS_TOTAL           		= "decimal|18,4|NO|(0)";
	const C_ITEMS_GST           		= "decimal|18,4|NO|(0)";
	const C_ISSUE_PRINT                 = "int||NO|(0)";
	const C_ISSUE_PRINT_PAGE            = "int||NO|(0)";
	const C_ITEMS_PRINT                	= "int||NO|(0)";
	const C_ITEMS_PRINT_PAGE           	= "int||NO|(0)";
	const C_MAINTENANCE_PRINT           = "int||NO|(0)";
	const C_MAINTENANCE_PRINT_PAGE      = "int||NO|(0)";
	const C_PROJECT_PLAN_PRINT          = "int||NO|(0)";
	const C_PROJECT_PLAN_PRINT_PAGE     = "int||NO|(0)";
	const C_COVER_PRINT                 = "int||NO|(0)";
	const C_COVER_PRINT_PAGE            = "int||NO|(0)";
	const C_FOOTER_PRINT                = "int||NO|(0)";
	const C_FOOTER_PRINT_PAGE           = "int||NO|(0)";
	const C_APPENDIX_PRINT              = "int||NO|(0)";
	const C_APPENDIX_PRINT_PAGE         = "int||NO|(0)";
	const C_REF_ID              		= "nvarchar|255|NO|''";
	const C_TITLE              			= "nvarchar|255|NO|''";
	const C_ADDITIONAL_CONTACT          = "nvarchar|255|NO|''";
	const C_ADDITIONAL_APPENDIX         = "nvarchar|255|NO|''";
	const C_IS_CLOSED         			= "int||NO|(0)";
	const C_CLOSED_DATE                 = "datetime||NO|getdate()";
	const C_CLOSED_BY         			= "int||NO|(0)";
	const C_PREFERRED_INVOICE_DATE      = "datetime||NO|getdate()";
	const C_EXPECTED_ACCEPT_DATE		= "datetime||NO|getdate()";
	const C_EXPECTED_PAY_DATE			= "datetime||NO|getdate()";
	const C_PERCENTAGE_PAYMENT			= "decimal|18,2|NO|(0)";
	const C_USER_DEFINED_1         		= "nvarchar|50|NO|''";
	const C_USER_DEFINED_2         		= "nvarchar|50|NO|''";
	const C_USER_DEFINED_3         		= "nvarchar|50|NO|''";
	const C_USER_DEFINED_4         		= "nvarchar|50|NO|''";
	const C_SUBMIT_DATE      			= "datetime||NO|getdate()";
	const C_APPROVED_DATE      			= "datetime||NO|getdate()";
	const C_APPROVED_BY         		= "int||NO|(0)";
	const C_REJECT_REASON         		= "nvarchar|255|NO|''";
	const C_VIEWED         				= "int||NO|(0)";
	const C_VIEWED_DATE      			= "datetime||NO|getdate()";
	const C_PROBABILITY         		= "int||NO|(0)";
}
?>