<?php
class GoodsReceivingTable extends Table {
	
	const C_TABLE                       = "GOOD_RECEIVING" ;
	const C_PK                          = "GOOD_RECEIVING_ID";
	const C_ID                          = "GOOD_RECEIVING_ID";
	const C_CODE                        = "GOOD_RECEIVING_CODE";
	const C_USER_ID           			= "GOOD_RECEIVING_USER_ID";
	const C_USER_LOC_ID           		= "GOOD_RECEIVING_USER_LOCATION_ID";
	const C_STATUS_CUST           		= "GOOD_RECEIVING_STATUS_CUST";
	const C_CUST_ID                 	= "GOOD_RECEIVING_CUSTOMER_ID";
	const C_PROSPECT_NAME               = "GOOD_RECEIVING_PROSPECT_NAME";
	const C_CONTACT_NAME           		= "GOOD_RECEIVING_CONTACT_NAME";
	const C_CONTACT_PHONE           	= "GOOD_RECEIVING_CONTACT_PHONE";
	const C_CONTACT_EMAIL           	= "GOOD_RECEIVING_CONTACT_EMAIL";
	const C_STATUS                 		= "GOOD_RECEIVING_STATUS";
	const C_DATE                 		= "GOOD_RECEIVING_DATE";
}

class GoodsReceivingTableDetail extends TableDetail {
	
	const C_ID                          = "identity|||";
	const C_CODE              			= "nvarchar|50|NO|''";
	const C_USER_ID                 	= "int||NO|(0)";
	const C_USER_LOC_ID                 = "int||NO|(0)";
	const C_STATUS_CUST           		= "int||NO|(0)";
	const C_CUST_ID                 	= "int||NO|(0)";
	const C_PROSPECT_NAME              	= "nvarchar|255|NO|''";
	const C_CONTACT_NAME              	= "nvarchar|100|NO|''";
	const C_CONTACT_PHONE              	= "nvarchar|20|NO|''";
	const C_CONTACT_EMAIL              	= "nvarchar|100|NO|''";
	const C_STATUS           			= "int||NO|(0)";
	const C_DATE              			= "datetime||NO|getdate()";
}
?>