Customer

Customer

Table Name AGP_CAM_Cust_ActGrp_Map

Table Comment This table holds the data of customer account group mapping information
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CAM_Created_OUInstance	int	NOT NULL	created instance	No	No
CAM_Cust_Act_Grp_Code	varchar(18)	NOT NULL	unique code for customer account group	No	No
CAM_Customer_Code	varchar(18)	NOT NULL	customer code	No	No
CAM_Customer_OU	int	NULL	customer created instance	No	No
CAM_Created_By	varchar(30)	NOT NULL	created user name	No	No
CAM_Created_Date	datetime	NOT NULL	created date	No	No
CAM_Modified_By	varchar(30)	NOT NULL	modified user name	No	No
CAM_Modified_Date	datetime	NOT NULL	modified date	No	No
CAM_Timestamp	int	NULL	timestamp for not allowing more than one user to process the same data	No	No

Table Name Cu_ARD_Acr_Req_Dtl

Table Comment This Table Stores the Aircraft Certificate Details across Sales Point
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ARD_Created_OU	int	NOT NULL	created instance	Yes	No
ARD_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	No
ARD_ACft_RegNo	varchar(30)	NOT NULL	aircraft register no	Yes	No
ARD_Cert_Typ	varchar(25)	NOT NULL	aircraft certification type	Yes	No
ARD_ACft_OU	int	NOT NULL	aircraft created instance	No	No
ARD_Desc	varchar(150)	NULL	description	No	No
ARD_Remarks	varchar(255)	NULL	remarks	No	No
ARD_Tmplt	varchar(50)	NULL	template	No	No
ARD_Created_By	varchar(30)	NOT NULL	created user name	No	No
ARD_Created_Date	datetime	NOT NULL	created date	No	No
ARD_Modified_By	varchar(30)	NULL	modified user name	No	No
ARD_Modified_Date	datetime	NULL	modified date	No	No

Table Name Cu_CAD_Cust_AddressId_Dtl

Table Comment This Table Stores the Address Details of Customer irrespective of Sales Point
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CAD_Created_Ouinstance	int	NOT NULL	created instance	Yes	No
CAD_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	No
CAD_Address_ID	varchar(12)	NOT NULL	address id	Yes	No
CMH_Created_Ouinstance	int	NOT NULL	created instance	Yes	Yes
CMH_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	Yes
CAD_Address1	varchar(40)	NULL	address1	No	No
CAD_Address2	varchar(40)	NULL	address2	No	No
CAD_Address3	varchar(40)	NULL	address3	No	No
CAD_City	varchar(32)	NULL	city	No	No
CAD_ZipCode	varchar(15)	NULL	zip code	No	No
CAD_State	varchar(32)	NULL	state	No	No
CAD_Country	varchar(5)	NULL	country	No	No
CAD_phone_No	varchar(18)	NULL	Phone no	No	No
CAD_Fax_No	varchar(20)	NULL	fax no	No	No
CAD_Email_Id	varchar(60)	NULL	mail id	No	No
CAD_Spec_Code	varchar(5)	NULL	spec_code	No	No
CAD_Sita_Code	varchar(45)	NULL	sita_code	No	No
CAD_Inco_Term	varchar(15)	NULL	Inco term	No	No
CAD_Inco_Place_air	varchar(40)	NULL	inco through air	No	No
CAD_Inco_Place_road	varchar(40)	NULL	inco place road	No	No
CAD_Inco_Place_rail	varchar(40)	NULL	inco place rail	No	No
CAD_Inco_place_ship	varchar(40)	NULL	inco place ship	No	No
CAD_Delivery_Code	varchar(18)	NULL	delivery code	No	No

Table Name cu_cbum_cus_base_user_map

Table Comment this table stores the details of user mapping
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cbum_ouinstance	int	NOT NULL	user mapping instance	Yes	No
cbum_customer_code	varchar(18)	NOT NULL	customer code	Yes	No
cbum_base	varchar(30)	NOT NULL	base	Yes	No
cbum_user	varchar(30)	NOT NULL	current user	Yes	No
cbum_effective_from	datetime	NOT NULL	effectivity of the user from	Yes	No
cbum_effective_to	datetime	NULL	effectivity of the user to	No	No
cbum_timestamp	int	NULL	timestamp for not allowing more than one user to process the same data	No	No
cbum_created_by	varchar(30)	NULL	created user name	No	No
cbum_created_date	datetime	NULL	created date	No	No
cbum_modified_by	varchar(30)	NULL	modified user name	No	No
cbum_modified_date	datetime	NULL	modified date	No	No

Table Name Cu_CCD_Cus_Comp_Dtl

Table Comment This table stores the customer company details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CCD_Created_OU	int	NULL	created instance	No	No
CCD_Cust_Code	varchar(18)	NULL	customer code	No	No
CCD_Compnt_Code	varchar(90)	NULL	customer component code	No	No
CCD_Compnt_OU	int	NULL	customer component created instance	No	No
CCD_PartNo	varchar(40)	NULL	part no	No	No
CCD_PartNo_OU	int	NULL	customer part created instance	No	No
CCD_Mft_SNo	varchar(40)	NULL	customer part manufactured serial no	No	No
CCD_Enga_Type	varchar(5)	NULL	engagement type	No	No
CCD_Created_By	varchar(30)	NULL	created user name	No	No
CCD_Created_Date	varchar(15)	NULL	created date	No	No
CCD_Modified_By	varchar(30)	NULL	modified user name	No	No
CCD_Modified_Date	varchar(15)	NULL	modified date	No	No

Table Name Cu_CD_Certificate_Dtl

Table Comment This Table Saves Certificate Details in a Sales Point
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CD_Created_OUInstance	int	NOT NULL	created instance	Yes	No
CD_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	No
CD_SalesLoc_OU	int	NOT NULL	sales location instance	Yes	No
CD_Part_No	varchar(40)	NOT NULL	part no	Yes	No
CD_Cert_Type	varchar(80)	NOT NULL	certification type for the part	Yes	No
CPD_Created_OUInstance	int	NOT NULL	created instance	Yes	Yes
CPD_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	Yes
CPD_SalesLoc_OU	int	NOT NULL	sales location instance	Yes	Yes
CPD_Part_No	varchar(40)	NOT NULL	part no	Yes	Yes
CD_Remarks	varchar(255)	NULL	remarks for the certification detail of the part	No	No
CD_Filename	varchar(50)	NULL	file name used for reference	No	No
CD_Created_By	varchar(30)	NULL	created user name	No	No
CD_Created_Date	datetime	NULL	created date	No	No
CD_Modified_By	varchar(30)	NULL	modified user name	No	No
CD_Modified_Date	datetime	NULL	modified date	No	No

Table Name Cu_CGD_Cust_Group_Dtl

Table Comment This Table Stores the details of a Customer Group
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CGD_Created_OuInstance	int	NOT NULL	created instance	Yes	No
CGD_Cust_Group_Code	varchar(6)	NOT NULL	customer group code	Yes	No
CGD_Cust_Created_Ou	int	NOT NULL	created customer instance	Yes	No
CGD_Customer_Code	varchar(18)	NOT NULL	customer code	Yes	No
CGH_Created_OuInstance	int	NOT NULL	created instance	Yes	Yes
CGH_Cust_Group_Code	varchar(6)	NOT NULL	customer group code	Yes	Yes

Table Name Cu_CGH_Cust_Group_Hdr

Table Comment This is the Header Table for Customer Group
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CGH_Created_OuInstance	int	NOT NULL	created instance	Yes	No
CGH_Cust_Group_Code	varchar(6)	NOT NULL	customer group code Unique code for each group	Yes	No
CGH_Cust_Group_Desc	varchar(40)	NULL	group description	No	No
CGH_Group_Type_Code	varchar(20)	NULL	group type code	No	No
CGH_Group_Status	varchar(5)	NULL	group status values will be Active Inactive	No	No
CGH_Controlled_Group	varchar(5)	NULL	controlled group yes or no	No	No
CGH_Created_By	varchar(30)	NULL	created user name	No	No
CGH_Created_Date	datetime	NULL	created date	No	No
CGH_Modified_By	varchar(30)	NULL	modified user name	No	No
CGH_Modified_Date	datetime	NULL	modified date	No	No
CGH_TimeStamp	int	NULL	timestamp for not allowing more than one user to access the same data	No	No
CGH_Remarks	varchar(255)	NULL	remarks for the customer group to be generated	No	No

Table Name Cu_CI_Commercial_Info

Table Comment This Table Saves the Commercial details across Sales Point
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CI_Created_OUInstance	int	NOT NULL	created instance	Yes	No
CI_Cust_Code	varchar(18)	NOT NULL	customer code: unique code to identify each customer	Yes	No
CMH_Created_Ouinstance	int	NOT NULL	created organization instance	Yes	Yes
CMH_Cust_Code	varchar(18)	NOT NULL	unique code for identification of the customer	Yes	Yes
CI_Cust_Type	varchar(5)	NULL	type of customer values like domestic export	No	No
CI_Currency	varchar(20)	NULL	currency defined for the customer predefined currencies would be the values	No	No
CI_Crd_Term_code	varchar(20)	NULL	credit term code	No	No
CI_Pay_Term	varchar(15)	NULL	pay term code	No	No
CI_Tax_Payer_ID	varchar(40)	NULL	tax payer id no	No	No
CI_Collector	varchar(40)	NULL	collector no	No	No
CI_send_Stmnt	varchar(25)	NULL	whether to send the statement or not values will be yes or no	No	No
CI_Stmnt_Int_Days	int	NULL	if statement to be sent then on which interval to be sent	No	No
CI_Crd_ChkAction	varchar(40)	NULL	credit check action values will be the codes for the below descriptions hold pack slip hold order release hold order and shipping hold order acceptance	No	No
CI_Dunning_Reqd	nvarchar(20)	NULL	dunning required	No	No
CI_Single_Ord_Lmt	numeric	NULL	single order limit amount	No	No
CI_Total_Ord_Lmt	numeric	NULL	total order limit amount	No	No
CI_Recv_Grace_Days	int	NULL	Receivable Grace Days	No	No
CI_Disc_Grace_Days	int	NULL	Discount Grace Days	No	No
CI_Res_WrOff_Perc	numeric	NULL	Residual Writeoff Percentage	No	No
CI_Res_WrOff_Amt	numeric	NULL	Residual Writeoff Amount	No	No
CI_Identification_Ref	varchar(20)	NULL	Company Identification Reference values will be the quick codes defined for company identification reference	No	No
CI_Identification_No	varchar(40)	NULL	Identification No.	No	No
CI_DNB_Code	varchar(40)	NULL	D&B Code No.	No	No
CI_DNB_Rating	varchar(40)	NULL	D&B Rating	No	No
CI_SIC_Code	varchar(10)	NULL	SIC Code	No	No
CI_ISO_Code	varchar(6)	NULL	ISO Code	No	No
CI_Market	varchar(5)	NULL	market	No	No
CI_Industory	varchar(5)	NULL	industry	No	No
CI_Region	varchar(5)	NULL	region	No	No
CI_Segment	varchar(5)	NULL	segment	No	No
CI_SubSegment	varchar(5)	NULL	subsegment	No	No
CI_Created_By	varchar(30)	NULL	created username	No	No
CI_Created_Date	datetime	NULL	created date	No	No
CI_Modified_By	varchar(30)	NULL	modified user name	No	No
CI_Modified_Date	datetime	NULL	Modified date	No	No
CI_CrdCurrency	nvarchar(20)	NULL	Added for Rel6 Changes (For Credit Currency in Edit Commercial Information)	No	No

Table Name Cu_CLH_Company_Level_Hdr

Table Comment This is the Header table for Payment Receipt Details of a Customer across Sales Point
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CLH_Created_Ouinstance	int	NOT NULL	created instance	Yes	No
CLH_Cust_Code	varchar(18)	NOT NULL	customer unique code	Yes	No
CLH_Vat_Class	varchar(40)	NULL	vat class	No	No
CLH_Vat_Category	varchar(40)	NULL	vat category	No	No
CLH_Euro_Vat_Id	varchar(40)	NULL	euro id for vat	No	No
CLH_Swiss_Vat_Id	varchar(40)	NULL	swiss id for vat	No	No
CLH_Comp_BankAcc_No	varchar(32)	NULL	COMPANY BANK ACCOUNT NO	No	No
CLH_Recpt_Mode	varchar(25)	NULL	RECEIPT MODE VALUES WILL BE cheque, credit card, debit card, direct demand draft.	No	No
CLH_Cust_Bank_Code	varchar(32)	NULL	customer bank code	No	No
CLH_Cust_BankAcc_No	varchar(32)	NULL	customer bank account no	No	No
CLH_Bank_Esr_Flag	varchar(5)	NULL	bank esr flag	No	No
CLH_Esr_Bank_Code	varchar(32)	NULL	bank esr code	No	No
CLH_Bank_Esr_Type	varchar(5)	NULL	esr type	No	No
CLH_Ptt_Esr_Flag	varchar(5)	NULL	ptt esr flag	No	No
CLH_Cust_PttAcc_No	varchar(32)	NULL	customer ptt account no	No	No
CLH_Esr_Ptt_Code	varchar(32)	NULL	esr ptt code	No	No
CLH_Ptt_Esr_Type	varchar(5)	NULL	ptt esr type	No	No
CLH_Created_By	varchar(30)	NULL	created user name	No	No
CLH_Modified_By	varchar(30)	NULL	modified user name	No	No
CLH_Created_Date	datetime	NULL	created date	No	No
CLH_Modified_Date	datetime	NULL	modified date	No	No

Table Name Cu_CLSV_Company_LSV_Dtl

Table Comment This Table Stores the details of Payment Receipt for a Customer across Sales Point
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CLSV_Created_OUInstance	int	NOT NULL	created instance	Yes	No
CLSV_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	No
CLSV_Line_No	int	NOT NULL	line no for multi value reference	Yes	No
CLH_Created_Ouinstance	int	NOT NULL	created instance	Yes	Yes
CLH_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	Yes
CLSV_Receipt_method	varchar(5)	NULL	receipt method	No	No
CLSV_Default_Flag	varchar(5)	NULL	default flag	No	No
CLSV_Bank_Code	varchar(32)	NULL	bank code given by the customer	No	No
CLSV_LSV_ContractId	varchar(30)	NULL	contract id	No	No
CLSV_Contract_Ref	varchar(120)	NULL	contract reference	No	No
CLSV_Cust_BankAcc_No	varchar(32)	NULL	customer bank account no	No	No
CLSV_Cust_Bank_Ref	varchar(32)	NULL	customer bank reference details	No	No
CLSV_Remarks	varchar(255)	NULL	remarks	No	No
CLSV_EffFrom_Date	datetime	NULL	effectivity from date	No	No
CLSV_EffTo_Date	datetime	NULL	effectivity to date	No	No

Table Name Cu_CMH_Cust_Master_Hdr

Table Comment This is the Master Table For BAS Customer Component
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CMH_Created_Ouinstance	int	NOT NULL	created instance	Yes	No
CMH_Cust_Code	varchar(18)	NOT NULL	customer code unique code to identify the customer	Yes	No
CMH_Cust_Name	varchar(40)	NOT NULL	customer name	No	No
CMH_Cust_Nature	varchar(5)	NOT NULL	Nature of the customer values will be external internal group company	No	No
CMH_Reference_Status	varchar(5)	NOT NULL	reference status of the customer can be active inactive under creation	No	No
CMH_Operator_Code	varchar(30)	NULL	Operator code	No	No
CMH_ParCust_Code	varchar(18)	NULL	parent customer code	No	No
CMH_Supl_Code	varchar(45)	NULL	supplier code	No	No
CMH_Spec_Code	varchar(5)	NULL	SPEC code	No	No
CMH_Sita_Code	varchar(45)	NULL	SITA / ARINC code	No	No
CMH_Register_Date	datetime	NULL	registration date	No	No
CMH_Address1	varchar(40)	NULL	address 1 of the customer	No	No
CMH_Address2	varchar(40)	NULL	address2 of the customer	No	No
CMH_Address3	varchar(40)	NULL	address3 of the customer	No	No
CMH_City	varchar(32)	NULL	city defined for the customer	No	No
CMH_ZipCode	varchar(15)	NULL	zipcode defined for the customer	No	No
CMH_State	varchar(32)	NULL	state defined for the customer	No	No
CMH_Country	varchar(5)	NULL	country defined for the customer	No	No
CMH_phone_No	varchar(18)	NULL	phone no defined for the customer	No	No
CMH_Mobile_No	varchar(20)	NULL	mobile no defined for the customer	No	No
CMH_Fax_No	varchar(20)	NULL	fax no defined for the customer	No	No
CMH_Email_Id	varchar(60)	NULL	mail id defined for the customer	No	No
CMH_Url_Id	varchar(60)	NULL	url id defined for the customer	No	No
CMH_Company_Code	varchar(10)	NULL	company code defined for the customer	No	No
CMH_BU_Code	varchar(20)	NULL	bu code defined for the customer	No	No
CMH_PartSale_Flag	varchar(25)	NULL	nature of relationship is chosen for part sale flag value will be 1 else 0	No	No
CMH_SerSale_Flag	varchar(25)	NULL	nature of relationship is chosen for ser sale flag value will be 1 else 0	No	No
CMH_CompLoan_Flag	varchar(25)	NULL	nature of relationship is chosen for comploan sale flag value will be 1 else 0	No	No
CMH_CompExange_Flag	varchar(25)	NULL	nature of relationship is chosen for compexchange sale flag value will be 1 else 0	No	No
CMH_Credcheck_Code	varchar(40)	NULL	credit check code values will be codes defined for customer up to hierarchy total hierarchy	No	No
CMH_FileName	varchar(50)	NULL	file name for reference	No	No
CMH_Remarks	varchar(255)	NULL	remarks	No	No
CMH_Enga_Type	varchar(5)	NULL	engagement type of the customer values will be the codes of full time maintenance on request	No	No
CMH_Created_By	varchar(30)	NULL	created user name	No	No
CMH_Modified_By	varchar(30)	NULL	modified user name	No	No
CMH_Timestamp	int	NULL	timestamp for not allowing more than one user to process the same data	No	No
CMH_Modified_Date	datetime	NULL	modified date	No	No
CMH_Created_Date	datetime	NULL	created date	No	No
CMH_UserName	varchar(25)	NULL	user name	No	No
CMH_Restrict_Type	nvarchar(25)	NULL	CMH_Restrict_Type col is added for Rel 6	No	No

Table Name CU_CMI_Cus_Mod_Dtl

Table Comment This Table Trace the Customer Details Modification (Used for "View Customer Modification Information")
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CMI_Created_OU	int	NOT NULL	created instance	Yes	No
CMI_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	No
CMI_From_Date	datetime	NOT NULL	customer effectivity date from	Yes	No
CMI_Cust_Name	varchar(40)	NULL	customer name for the code given	No	No
CMI_Address	varchar(255)	NOT NULL	address of the customer	No	No
CMI_To_Date	datetime	NULL	customer effectivity date to	No	No
CMI_Created_By	varchar(30)	NOT NULL	created user name	No	No
CMI_Created_Date	datetime	NOT NULL	created date	No	No
CMI_Modified_By	varchar(30)	NULL	modified user name	No	No
CMI_Modified_Date	datetime	NULL	modified date	No	No

Table Name Cu_CPD_Cust_Part_Dtl

Table Comment This Table Saves the Customer Part Details for a Customer in a Sales Point
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CPD_Created_OUInstance	int	NOT NULL	created instance	Yes	No
CPD_Cust_Code	varchar(18)	NOT NULL	unique customer code	Yes	No
CPD_SalesLoc_OU	int	NOT NULL	sales location instance	Yes	No
CPD_Part_No	varchar(40)	NOT NULL	part no	Yes	No
CPD_Cust_Part_No	varchar(40)	NULL	customer part no	No	No
CPD_Ship_Point	varchar(16)	NULL	shipping point (instance)	No	No
CPD_WH_Code	varchar(10)	NULL	ware house code	No	No
CPD_Created_By	varchar(30)	NULL	created user name	No	No
CPD_Created_Date	datetime	NULL	created date	No	No
CPD_Modified_By	varchar(30)	NULL	modified user name	No	No
CPD_Modified_Date	datetime	NULL	modified date	No	No
CPD_Part_Crt_Ou	int	NULL	part created instance	No	No
CPD_WH_Ouinstance	int	NULL	ware house instance	No	No

Table Name Cu_CPI_Contact_Person_Info

Table Comment This Table Stores the Details of Contact Person for a Customer in a Sales Point
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CPI_EMail_Id	varchar(60)	NULL	email id of the customer	No	No
CPI_phone_No	varchar(18)	NULL	phone no of the customer	No	No
CPI_Fax_No	varchar(20)	NULL	fax no of the customer	No	No
CPI_Visit_Hrs	varchar(40)	NULL	visiting hours of the customer	No	No
CPI_ZipCode	varchar(15)	NULL	zipcode of the address given	No	No
CPI_Country	varchar(5)	NULL	country of the address	No	No
CPI_state	varchar(32)	NULL	state of the address mentioned	No	No
CPI_City	varchar(32)	NULL	city of address	No	No
CPI_Created_Date	datetime	NULL	created date	No	No
CPI_Created_By	varchar(30)	NULL	created user name	No	No
CPI_Modified_By	varchar(30)	NULL	modified user name	No	No
CPI_Birth_Date	datetime	NULL	birth date of the customer	No	No
CPI_Marriage_Date	datetime	NULL	marriage date of the customer	No	No
CPI_Default_Flag	varchar(5)	NULL	default flag	No	No
CPI_Remarks	varchar(255)	NULL	remarks	No	No
CPI_Modified_Date	datetime	NULL	modified date	No	No
CPI_LineNo	int	NOT NULL	Line no for multiple value reference	Yes	No
CPI_Address_Id	varchar(12)	NOT NULL	address id	Yes	No
SLI_Created_OUInstance	int	NOT NULL	created instance	Yes	Yes
SLI_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	Yes
CPI_Created_OUInstance	int	NOT NULL	created instance	Yes	No
CPI_SalesLoc_Ou	int	NOT NULL	sales location instance	Yes	No
CPI_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	No
CPI_Address3	varchar(40)	NULL	address3 of the customer	No	No
CPI_Address1	varchar(40)	NULL	address1 of the customer	No	No
CPI_Department	varchar(40)	NULL	department	No	No
CPI_Address2	varchar(40)	NULL	address2 of the customer	No	No
SLI_salesLoc_Ou	int	NOT NULL	sales location instance	Yes	Yes
CMH_Created_Ouinstance	int	NOT NULL	created instance	Yes	Yes
CPI_Designation	varchar(40)	NULL	customer designation	No	No
CMH_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	Yes
CPI_Person_Name	varchar(40)	NULL	customer name	No	No

Table Name Cu_CRD_CCer_Req_Dtl

Table Comment This table Stores the Part Details in a Sales Point
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CRD_Created_OU	int	NOT NULL	created instance	Yes	No
CRD_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	No
CRD_PartNo	varchar(40)	NOT NULL	part no defined for the particular customer code	Yes	No
CRD_Cert_Typ	varchar(25)	NOT NULL	type of certification for the part	Yes	No
CRD_PartNo_OU	int	NOT NULL	part created instance	No	No
CRD_Remarks	varchar(255)	NULL	remarks	No	No
CRD_Template	varchar(50)	NULL	templates	No	No
CRD_Created_By	varchar(30)	NOT NULL	created user name	No	No
CRD_Created_Date	datetime	NOT NULL	created date	No	No
CRD_Modified_By	varchar(30)	NULL	modified user name	No	No
CRD_Modified_Date	datetime	NULL	Modified date	No	No

Table Name Cu_Cuctm_Cust_TCD_Map

Table Comment Added for Rel6 Changes ( For Maint. TCD) Edit Customer Tax & Charges Information - to update TCD for the Customer & corresponding delivery area and application
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CUCTM_OUInstance	int	NOT NULL	current instance	Yes	No
CUCTM_Cust_Code	varchar(18)	NOT NULL	customer code for which the TCD details were to be entered	Yes	No
CUCTM_Delarea	varchar(18)	NOT NULL	delivery area for the customer	Yes	No
CUCTM_Appl_On	nvarchar(5)	NOT NULL	applicable on value values can be like order level material level services	Yes	No
CUCTM_Seq_No	int	NOT NULL	sequence no reference for multi value given for the same customer	Yes	No
CUCTM_Tcd_Code	nvarchar(10)	NOT NULL	Tcd code from TCD Master	Yes	No
CUCTM_Tcd_Variant	nvarchar(10)	NOT NULL	TCD Variant code from TCD Master	Yes	No
CUCTM_Tcd_OU	int	NOT NULL	TCD Created instance	Yes	No
CUCTM_Billable_Flag	nvarchar(5)	NULL	Billable flag to define whether the defined TCD , TCD Variant combination is a billable one or not values will be Yes NO	No	No

Table Name Cu_CuPrm_Parameter_Details

Table Comment This table Contains the Parameter Details (Meta Data)
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CuPrm_ComponentName	varchar(80)	NULL	component name	No	No
Cuprm_ParamCategory	varchar(10)	NULL	parameter category	No	No
Cuprm_ParamType	varchar(25)	NULL	parameter type of the category mentioned	No	No
Cuprm_Paramcode	varchar(5)	NULL	param code defined for the parttype, category and component name combination	No	No
CuPrm_ParamDesc	varchar(80)	NULL	param description defined for the partcode,parttype, category and component name combination	No	No
CuPrm_Langid	int	NULL	language id	No	No
Cuprm_Sort_by	int	NOT NULL	sort by field for display of data in some order	No	No

Table Name CU_CUTCD_CUST_TCD_STADEFTAX
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CuTcd_SDT_Created_OU	int	NOT NULL	Ouinstance	Yes	No
CuTcd_SDT_TaxNo	varchar(25)	NOT NULL	Tax Number	Yes	No
CuTcd_SDT_Tax_VarNo	varchar(25)	NOT NULL	Tax variance number	Yes	No
CuTcd_SDT_Cust_Code	varchar(18)	NULL	Customer code	No	No
CuTCD_SDT_Created_By	varchar(30)	NULL	Created By	No	No
CuTCD_SDT_Created_Date	varchar(30)	NULL	Created Date	No	No
CuTCD_SDT_Modified_By	varchar(30)	NULL	Modified By	No	No
CuTcd_SDT_Modified_Date	varchar(30)	NULL	Modified Date	No	No

Table Name CU_CUTCD_CUST_TCD_TAX_REG_DTL
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CuTcd_CRD_Created_OU	int	NOT NULL	Created Ouinstance	Yes	No
CuTcd_CRD_Cust_Code	varchar(18)	NOT NULL	Customer Code	Yes	No
CuTcd_CRD_RegNo	varchar(35)	NOT NULL	Customer Registration Number	Yes	No
CuTcd_CRD_Address_ID	varchar(12)	NOT NULL	Address Id	No	No
CuTcd_CRD_TaxType	varchar(35)	NOT NULL	Tax type	No	No
CuTCD_CRD_Created_By	varchar(30)	NULL	Created by	No	No
CuTCD_CRD_Created_Date	varchar(30)	NULL	Created date	No	No
CuTCD_CRD_Modified_By	varchar(30)	NULL	Modified by	No	No
CuTcd_CRD_Modified_Date	varchar(30)	NULL	Modified date	No	No

Table Name CU_DSB_Def_Ship_Bill_Info

Table Comment This Table Saves the Default Bill/Ship to Customer details for a Sales Point
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
DSB_Created_OUInstance	int	NOT NULL	created instance	Yes	No
DSB_Cust_Code_Hdr	varchar(18)	NOT NULL	Unique customer code	Yes	No
DSB_SalesLoc_OU	int	NOT NULL	sales location instance	Yes	No
DSB_Cust_Code_Mlt	varchar(18)	NOT NULL	customer code	Yes	No
DSB_ShipBill_Type	varchar(5)	NULL	shipping bill type	No	No
DSB_Created_By	varchar(30)	NULL	created user name	No	No
DSB_Modified_By	varchar(30)	NULL	modified user name	No	No
DSB_Modified_Date	datetime	NULL	Modified date	No	No
DSB_Created_Date	datetime	NULL	created date	No	No

Table Name CU_PMD_Prt_Mst_Dtl

Table Comment This table Stores the Part Details across Sales Point
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PMD_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	No
PMD_Created_OU	int	NOT NULL	created instance	Yes	No
PMD_PartNo	varchar(40)	NOT NULL	part no	Yes	No
PMD_PartNo_OU	int	NOT NULL	part created instance	No	No
PMD_Cus_PartNO	varchar(40)	NULL	customers part no	No	No
PMD_Supp_By	varchar(150)	NOT NULL	supplied by	No	No
PMD_Rep_Policy	varchar(25)	NOT NULL	Replenishment Policy	No	No
PMD_Created_By	varchar(30)	NOT NULL	created user name	No	No
PMD_Created_Date	datetime	NOT NULL	created date	No	No
PMD_Modified_By	varchar(30)	NULL	modified user name	No	No
PMD_Modified_Date	datetime	NULL	modified date	No	No

Table Name Cu_PPL_PartPrice_List_Dtl

Table Comment This Table Saves the Associated Part Price List for a Customer in a Sales Point
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PPL_Created_OUInstance	int	NOT NULL	created instance	Yes	No
PPL_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	No
PPL_SalesLoc_OU	int	NOT NULL	sales location instance	Yes	No
PPL_Seq_No	int	NOT NULL	sequence no for multi value identification	Yes	No
SLI_Created_OUInstance	int	NOT NULL	created instance	Yes	Yes
SLI_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	Yes
SLI_salesLoc_Ou	int	NOT NULL	sales location instance	Yes	Yes
CMH_Created_Ouinstance	int	NOT NULL	customer created instance	Yes	Yes
CMH_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	Yes
PPL_Price_List	varchar(40)	NULL	part price list defined	No	No
PPL_Eff_From	datetime	NULL	part price list effectivity from date	No	No
PPL_Eff_To	datetime	NULL	part price list effectivity to date	No	No

Table Name CU_SLD_Sts_Log_Dtl

Table Comment This table is used to Trace the Status Modifications done for a Customer (Used for "View Status Log")
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SLD_Created_OU	int	NOT NULL	created instance	Yes	No
SLD_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	No
SLD_Changed_On	datetime	NOT NULL	details changed on	Yes	No
SLD_Changed_by	varchar(30)	NOT NULL	details changed by	Yes	No
SLD_Ref_Status	varchar(5)	NOT NULL	reference status	No	No
SLD_Opr_Status	varchar(5)	NULL	opr status	No	No
SLD_Comments	varchar(255)	NULL	comments	No	No
SLD_Created_By	varchar(30)	NOT NULL	created user name	No	No
SLD_Created_Date	datetime	NOT NULL	created date	No	No
SLD_Modified_By	varchar(30)	NULL	modified user name	No	No
SLD_Modified_Date	datetime	NULL	modified date	No	No

Table Name Cu_SLI_Sales_Location_Info

Table Comment This Table Saves the Sales Point information for a Customer.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SLI_Created_OUInstance	int	NOT NULL	created instance	Yes	No
SLI_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	No
SLI_salesLoc_Ou	int	NOT NULL	sales location instance	Yes	No
CMH_Created_Ouinstance	int	NOT NULL	created instance	Yes	Yes
CMH_Cust_Code	varchar(18)	NOT NULL	unique customer code	Yes	Yes
SLI_Opera_Status	varchar(5)	NULL	Operational status values will be active and inactive	No	No
SLI_Deft_ShipTo_Cust	varchar(18)	NULL	default shipment to customer needed or not value will be 1 or 0	No	No
SLI_Deft_BillTo_Cust	varchar(18)	NULL	Default Bill To Information value will be 0 if not needed and 1 if needed	No	No
SLI_Auto_InvAuth_flag	varchar(25)	NULL	Automatic authorization of invoice needed or not if needed will be 1 else will be 0	No	No
SLI_Freight_Billable	varchar(12)	NULL	freight billable value yes or no	No	No
SLI_Elgble_For_Rebate	varchar(25)	NULL	elegable for rebate values will be yes or no	No	No
SLI_TaxExempt_Flag	varchar(25)	NULL	taxexempt flag will be yes or no	No	No
SLI_TaxExempt_No	varchar(40)	NULL	taxexempt no	No	No
SLI_Inv_Appl_flag	varchar(25)	NULL	invoice applicable flag value will be yes or no	No	No
SLI_No_Of_InvCopies	int	NULL	no of invoice copies	No	No
SLI_Ship_Point	varchar(16)	NULL	ship point will be instance	No	No
SLI_Transport_Mode	varchar(25)	NULL	mode of transport	No	No
SLI_Prfrd_Carrier	varchar(20)	NULL	preferred carrier	No	No
SLO_Freight_Term	varchar(150)	NULL	freight term	No	No
SLI_PartShip_Allowed	varchar(25)	NULL	part ship allowed or not value will be yes or no	No	No
SLI_Tranship_Allowed	varchar(25)	NULL	Transhipment Allowed yes or no	No	No
SLI_ShipTot_Neg	int	NULL	Shipping Tol -Ve	No	No
SLI_ShipTot_Pos	int	NULL	Shipping Tol +Ve	No	No
SLI_BilTo_Id	varchar(18)	NULL	Bill To ID	No	No
SLI_ShipTo_Id	varchar(6)	NULL	Ship To ID	No	No
SLI_Order_From_Id	varchar(18)	NULL	Order From ID	No	No
SLI_Created_By	varchar(30)	NULL	created user name	No	No
SLI_Created_Date	datetime	NULL	created date	No	No
SLI_Modified_By	varchar(30)	NULL	modified user name	No	No
SLI_Modified_Date	datetime	NULL	modified date	No	No

Table Name CU_SPD_Ser_PrLst_Dtl

Table Comment This Table Stores the Service Price List details for Customer in a Sales Point
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SPD_Created_OU	int	NOT NULL	created instance	Yes	No
SPD_Cust_Code	varchar(18)	NOT NULL	customer code	Yes	No
SPD_SalesLocOU	int	NOT NULL	sales location instance	Yes	No
SPD_Ser_PrLst	varchar(40)	NOT NULL	service pricelist	Yes	No
SPD_SrPrLst_OU	int	NOT NULL	service pricelist instance	No	No
SPD_Eff_From	datetime	NULL	service pricelist effectivity from	No	No
SPD_Eff_To	datetime	NULL	service pricelist effectivity to	No	No
SPD_Created_By	varchar(30)	NOT NULL	created user name	No	No
SPD_Created_Date	datetime	NOT NULL	created date	No	No
SPD_Modified_By	varchar(30)	NULL	modified user name	No	No
SPD_Modified_Date	datetime	NULL	modified date	No	No

Table Name CU_SPH_Ser_PrLst_Hdr

Table Comment This Header Table Stores the Service Price List Details for Customer in a Sales Point
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SPH_Created_OU	int	NOT NULL	created instance	Yes	No
SPH_Cust_Code	varchar(18)	NOT NULL	unique customer code	Yes	No
SPH_SalesLocOU	int	NOT NULL	sales location instance	No	No
SPH_Adv_Payable	varchar(5)	NULL	advance payable flag value will be yes or no	No	No
SPH_Adv_Tolerance	numeric	NULL	Advance Tolerance	No	No
SPH_Adv_Percent	int	NULL	Advance Percent	No	No
SPH_Adv_PercentON	varchar(25)	NULL	Advance Percent On	No	No
SPH_Act_Non_Pay	varchar(25)	NULL	Action on Non Payment values will be prevent work order planning Prevent resource assignment Prevent WO reporting	No	No
SPH_Created_By	varchar(30)	NOT NULL	created user name	No	No
SPH_Created_Date	datetime	NOT NULL	created date	No	No
SPH_Modified_By	varchar(30)	NULL	modified user name	No	No
SPH_Modified_Date	datetime	NULL	modified date	No	No

Table Name CU_TMD_Task_Mstr_Dtl

Table Comment This Table Stores the Customer Task Master List across Sales Point
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
TMD_Created_OU	int	NOT NULL	created instance	Yes	No
TMD_Cust_Code	varchar(18)	NOT NULL	unique customer code	Yes	No
TMD_Task_No	varchar()	NOT NULL	task no	Yes	No
TMD_Mnt_Obj	varchar(40)	NOT NULL	maintenance object	Yes	No
TMD_Cust_OU	int	NOT NULL	customer instance	No	No
TMD_Task_Desc	varchar(150)	NULL	task description	No	No
TMD_Applicability	varchar(5)	NOT NULL	applicability	No	No
TMD_WU_Typ	varchar(5)	NOT NULL	work unit type	No	No
TMD_WU_Code	varchar(30)	NOT NULL	work unit code	No	No
TMD_WU_OU	int	NOT NULL	work unit instance	No	No
TMD_Remarks	varchar(150)	NULL	remarks	No	No
TMD_FileName	varchar(50)	NULL	file name	No	No
TMD_Created_By	varchar(30)	NOT NULL	created user name	No	No
TMD_Created_Date	datetime	NOT NULL	created date	No	No
TMD_Modified_By	varchar(30)	NULL	modified user name	No	No
TMD_Modified_Date	datetime	NULL	modified date	No	No
TMD_BaseModel_OU	int	NOT NULL	Added for Rel 6 Changes (For Edit Customer Task Master List)	No	No
TMD_BaseModel_No	nvarchar(20)	NULL	Added for Rel 6 Changes (For Edit Customer Task Master List)	No	No