CPO

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	CPO_CUM_CUST_USER_MAP	Stores the customer User mapping details.	CUM_DESTOUID	int	Destination Organizartion Unit Id	No	No
			CUM_GUID	sql_variant	Guid
			CUM_CUSTCODE		Customer Code
			CUM_CUSTNAME		Customer Name
			CUM_REGATOU		Organization Unit
			CUM_USERNAME		User Name
			CUM_EFFECTIVEFROMDATE	datetime	Effective From Date
			CUM_EFFECTIVETODATE		Effective To Date
			CUM_REMARKS	sql_variant	Remarks
			CUM_CREATEDBY		Created By
			CUM_CREATEDDATE	datetime	Created Date
			CUM_MODIFIEDBY	sql_variant	Modified By
			CUM_MODIFIEDDATE	datetime	Modified Date
			CUM_TIMESTAMP	int	Time Stamp
			CUM_STATUS	sql_variant	Status.Values M-Mapped,UN-Unmapped
			CUM_SERLNO	int	Serial Number
	CPO_CUM_CUST_USER_MAP_TMP		CUM_DESTOUID_TMP		Destination Organization Unit Id
			CUM_GUID_TMP	sql_variant	Guid
			CUM_CUSTCODE_TMP		Customer Code
			CUM_CUSTNAME_TMP		Customer Name
			CUM_REGATOU_TMP		Organization Unit
			CUM_USERNAME_TMP		User Name
			CUM_EFFECTIVEFROMDATE_TMP	datetime	Effective From Date
			CUM_EFFECTIVETODATE_TMP		Effective To Date
			CUM_REMARKS_TMP	sql_variant	Remarks
			CUM_CREATEDBY_TMP		Created By
			CUM_CREATEDDATE_TMP	datetime	Created Date
			CUM_MODIFIEDBY_TMP	sql_variant	Modified By
			CUM_MODIFIEDDATE_TMP	datetime	Modified Date
			CUM_TIMESTAMP_TMP	int	Time Stamp
			CUM_STATUS_TMP	sql_variant	Status
			CUM_SERLNO_tmp	int	Serial Number
	cpo_customer_mst	Stores Customer master details and their login details.	cust_code	sql_variant	Customer Code
			cust_name		Customer Name
			cou_lo		Login
			cou_bu		Business Unit
			cou_ou	int	Organization Unit
			login_user	sql_variant	Login User
			login_ou	int	Login Organization Unit
	CPO_VwOrderDtl_tmp		CPO_po_no	sql_variant	Purchase Order Number
			CPO_order_no		Order Number
			CPO_order_ou	int	Order Organization Unit
			CPO_order_date	datetime	Order Date
			CPO_currency	sql_variant	Currency
			CPO_work_status		Work Status
			CPO_Percent_completion	int	Percent Completion
			CPO_Invoice_status	sql_variant	Invoice Status
			CPO_promdelivery_date	datetime	Delivery Date
			CPO_Expdelivery_date		Expiry Delivery Date
			CPO_Delay	sql_variant	Delay
			CPO_Shipstatus		Ship Status
			CPO_airbillnum		Air Bill Number
			CPO_portal_comments		Portal Comments
			CPO_Guid		Guid