Data Dictionary -- Customer

Srl. No.	Table Name	Comment
1	CUS_MASTER_ADD_INFO_DTL	To store the Customer mater additional Information details
2	Cu_ARD_ACr_Req_Dtl	Customer Acr Request Details
3	Cu_CAD_Cust_AddressId_Dtl	Customer Address Details
4	cu_cbum_cus_base_user_map	Customer User Mapp details
5	Cu_CCD_Cus_Comp_Dtl	Customer Component details
6	Cu_CD_Certificate_Dtl	Customer Certification details
7	Cu_CGD_Cust_Group_Dtl	Customer Group Details
8	Cu_CGH_Cust_Group_Hdr	Customer Group Header
9	Cu_CI_Commercial_Info	Customer Commerical Informatioin
10	Cu_CLH_Company_Level_Hdr	Company Level Hdr
11	Cu_CLSV_Company_LSV_Dtl	Company LSV Details
12	Cu_CMH_Cust_Master_Hdr	Customer Master Header
13	CU_CMI_Cus_Mod_Dtl	Customer Modification details
14	Cu_CPD_Cust_Part_Dtl	Customer Part Details
15	Cu_CPI_Contact_Person_Info	Customer Contact Person Details
16	Cu_CRD_CCer_Req_Dtl	Custoerm Ccer Required Details
17	Cu_Cuctm_Cust_TCD_Map	Customer TCD Map
18	Cu_CuPrm_Parameter_Details	Customer Parameter details
19	Cu_CuTCD_Cust_TCD_StaDefTax	Customer Standard Default Tax
20	Cu_CuTCD_Cust_TCD_Tax_Reg_Dtl	Customer TCD Tax Registration details
21	CU_DSB_Def_Ship_Bill_Info	Defatut Billing & Shipping details
22	CU_PMD_Prt_Mst_Dtl	Customer Part Master Details
23	Cu_PPL_PartPrice_List_Dtl	Customer Part Price List Details
24	CU_SLD_Sts_Log_Dtl	Customer Status Log Details
25	Cu_SLI_Sales_int_contact_Info	To Store The Sales Internal Contract Information
26	Cu_SLI_Sales_Location_Info	Customer Sales Location Info
27	CU_SPD_Ser_PrLst_Dtl	Customer Service / Part Price List Details
28	CU_SPH_Ser_PrLst_Hdr	Customer Service / Part Price Header
29	CU_TMD_Task_Mstr_Dtl	Customer Task Master Details
30	sal_processparam_sys	Sales Process Parameters

Table Name :	CUS_MASTER_ADD_INFO_DTL
Comment :	To store the Customer mater additional Information details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CUS_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Organisation unit	No
CUS_CUSTOMER_CODE	UDD_CUSTOMER_ID	varchar(18)	Yes	Customer Code	No
CUS_CATEGORY	UDD_OPTIONCODE	varchar(8)	Yes	Customer Category	No
CUS_ATTRIBUTE	UDD_OPTIONCODE	varchar(8)	Yes	Customer Attribute	No
CUS_STATUS	UDD_OPTIONCODE	varchar(8)	Yes	Customer Status	No
CUS_VALUE	UDD_TXT255	varchar(255)	Yes	Customer Value	No
CUS_NOTES	UDD_TXT255	varchar(255)	Yes	Customer Notes	No
CUS_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	Created By	No
CUS_CREAED_DATE	UDD_DATETIME1	datetime(8)	Yes	Created Date	No
CUS_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	Modified By	No
CUS_MODIFIED_DATE	UDD_DATETIME1	datetime(8)	Yes	Modified Date	No
CUS_TIMESTAMP	UDD_TIMESTAMP	int(4)	Yes	Time Stamp	No
CUS_SEQNO	udd_SEQNO	int(4)	No	Seq No	Yes

Table Name :	Cu_ARD_ACr_Req_Dtl
Comment :	Customer Acr Request Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ARD_Created_OU	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
ARD_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
ARD_ACft_RegNo	udd_aircraftnumber	varchar(30)	No	Aircraft Register Number	Yes
ARD_ACft_OU	udd_ctxt_ouinstance	int(4)	No	Aircraft Ouinstance	No
ARD_Cert_Typ	udd_flag1	varchar(25)	No	Certification Type	Yes
ARD_Desc	udd_txt150	varchar(150)	Yes	Description	No
ARD_Remarks	udd_text255	varchar(255)	Yes	Remarks	No
ARD_Tmplt	udd_filename	varchar(50)	Yes	Template	No
ARD_Created_By	udd_ctxt_user	varchar(30)	No	Created By	No
ARD_Created_Date	udd_datetime1	datetime(8)	No	Created Date	No
ARD_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
ARD_Modified_Date	udd_datetime1	datetime(8)	Yes	Modified Date	No

Table Name :	Cu_CAD_Cust_AddressId_Dtl
Comment :	Customer Address Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CAD_Created_Ouinstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CAD_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
CAD_Address_ID	udd_addressid	varchar(12)	No	Address ID	Yes
CAD_Address1	udd_address	varchar(40)	Yes	Address1	No
CAD_Address2	udd_address	varchar(40)	Yes	Address2	No
CAD_Address3	udd_address	varchar(40)	Yes	Address3	No
CAD_City	udd_city	varchar(32)	Yes	City	No
CAD_ZipCode	udd_zip	varchar(15)	Yes	Zip Code	No
CAD_State	udd_state	varchar(32)	Yes	State	No
CAD_Country	udd_countrycode	varchar(5)	Yes	Country	No
CAD_phone_No	udd_phone	varchar(18)	Yes	Phone Number	No
CAD_Fax_No	udd_contactnumber	varchar(20)	Yes	Fax Number	No
CAD_Email_Id	udd_email	varchar(60)	Yes	Email Id	No
CAD_Spec_Code	udd_spec2kmfgcode	varchar(5)	Yes	Specific Code	No
CAD_Sita_Code	udd_vendorcode	varchar(45)	Yes	Sita Code	No
CAD_Inco_Term	udd_terms	varchar(15)	Yes	INCO Term	No
CAD_Inco_Place_air	udd_address	varchar(40)	Yes	INCO Place Air	No
CAD_Inco_Place_road	udd_address	varchar(40)	Yes	INCO Place Road	No
CAD_Inco_Place_rail	udd_address	varchar(40)	Yes	INCO Place Rail	No
CAD_Inco_place_ship	udd_address	varchar(40)	Yes	INCO Place Ship	No
CAD_Delivery_Code	udd_deliveryarea	varchar(18)	Yes	Delivery Area Code	No

Table Name :	cu_cbum_cus_base_user_map
Comment :	Customer User Mapp details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cbum_ouinstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
cbum_customer_code	udd_customer_id	varchar(18)	No	Customer Code	Yes
cbum_base	udd_wccode	varchar(30)	No	Base Model Number	Yes
cbum_user	udd_ctxt_user	varchar(30)	No	User	Yes
cbum_effective_from	udd_datetime1	datetime(8)	No	Effectivity From	Yes
cbum_effective_to	udd_datetime1	datetime(8)	Yes	Efffectivity To	No
cbum_timestamp	udd_timestampint	int(4)	Yes	Timestamp	No
cbum_created_by	udd_ctxt_user	varchar(30)	Yes	Created By	No
cbum_created_date	udd_datetime1	datetime(8)	Yes	Created Date	No
cbum_modified_by	udd_ctxt_user	varchar(30)	Yes	Modified By	No
cbum_modified_date	udd_datetime1	datetime(8)	Yes	Modified Date	No

Table Name :	Cu_CCD_Cus_Comp_Dtl
Comment :	Customer Component details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CCD_Created_OU	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
CCD_Cust_Code	udd_customer_id	varchar(18)	Yes	Customer Code	No
CCD_Compnt_Code	udd_componentid	varchar(90)	Yes	Component Code	No
CCD_Compnt_OU	udd_ctxt_ouinstance	int(4)	Yes	Component Ouinstance	No
CCD_PartNo	udd_partno	varchar(40)	Yes	Part Number	No
CCD_PartNo_OU	udd_ctxt_ouinstance	int(4)	Yes	Part Ouinstnace	No
CCD_Mft_SNo	udd_partserialnumber	varchar(40)	Yes	Manufacturer Serial Number	No
CCD_Enga_Type	udd_designparamcode	varchar(5)	Yes	Eng Type	No
CCD_Created_By	udd_ctxt_user	varchar(30)	Yes	Created By	No
CCD_Created_Date	udd_date1	varchar(15)	Yes	Created Date	No
CCD_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
CCD_Modified_Date	udd_date1	varchar(15)	Yes	Modified Date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication Key	Yes

Table Name :	Cu_CD_Certificate_Dtl
Comment :	Customer Certification details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CD_Created_OUInstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CD_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
CD_SalesLoc_OU	udd_ctxt_ouinstance	int(4)	No	Sale Ouistance	Yes
CD_Part_No	udd_partno	varchar(40)	No	Part Number	Yes
CD_Cert_Type	udd_txt80	varchar(80)	No	Certification Type	Yes
CD_Remarks	udd_txt255	varchar(255)	Yes	Remarks	No
CD_Filename	udd_filename	varchar(50)	Yes	Filename	No
CD_Created_By	udd_ctxt_user	varchar(30)	Yes	Created By	No
CD_Created_Date	_datetime_8	datetime(8)	Yes	Created Date	No
CD_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
CD_Modified_Date	_datetime_8	datetime(8)	Yes	Modified Date	No

Table Name :	Cu_CGD_Cust_Group_Dtl
Comment :	Customer Group Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CGD_Created_OuInstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CGD_Cust_Group_Code	udd_code	varchar(6)	No	Customer Group Code	Yes
CGD_Cust_Created_Ou	udd_ctxt_ouinstance	int(4)	No	Customer Created Ouinstance	Yes
CGD_Customer_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes

Table Name :	Cu_CGH_Cust_Group_Hdr
Comment :	Customer Group Header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CGH_Created_OuInstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CGH_Cust_Group_Code	udd_code	varchar(6)	No	Group Code	Yes
CGH_Cust_Group_Desc	udd_custname	varchar(40)	Yes	Group Description	No
CGH_Group_Type_Code	udd_grouptypecode	varchar(20)	Yes	Group Type Code	No
CGH_Group_Status	udd_designparamcode	varchar(5)	Yes	Group Status	No
CGH_Controlled_Group	udd_designparamcode	varchar(5)	Yes	Controlled Group	No
CGH_Created_By	udd_ctxt_user	varchar(30)	Yes	Created By	No
CGH_Created_Date	_datetime_8	datetime(8)	Yes	Created Date	No
CGH_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
CGH_Modified_Date	_datetime_8	datetime(8)	Yes	Modified Date	No
CGH_Remarks	udd_txt255	varchar(255)	Yes	Remarks	No
CGH_TimeStamp	udd_timestampint	int(4)	Yes	Timestamp	No

Table Name :	Cu_CI_Commercial_Info
Comment :	Customer Commerical Informatioin

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CI_Created_OUInstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CI_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
CI_Cust_Type	udd_designparamcode	varchar(5)	Yes	Customer Type	No
CI_Currency	udd_currency	varchar(20)	Yes	Currency	No
CI_CrdCurrency	udd_currency	varchar(20)	Yes	Crd Currency	No
CI_Crd_Term_code	udd_creditterm	varchar(20)	Yes	CRD Term Code	No
CI_Pay_Term	fin_payterm	varchar(30)	Yes	Pay Term	No
CI_Tax_Payer_ID	udd_desc40	varchar(40)	Yes	Tax Paid ID	No
CI_Collector	udd_salespersonname	varchar(40)	Yes	Collector	No
CI_send_Stmnt	udd_flag	varchar(25)	Yes	Send Statement?	No
CI_Stmnt_Int_Days	udd_number	int(4)	Yes	Statement in Days	No
CI_Crd_ChkAction	udd_checkaction	varchar(40)	Yes	Check Action	No
CI_Dunning_Reqd	udd_option	Varchar(40)	Yes	Dunning Required?	No
CI_Single_Ord_Lmt	udd_amount	numeric(13)	Yes	Single Order Limit	No
CI_Total_Ord_Lmt	udd_amount	numeric(13)	Yes	Total Order Limit	No
CI_Recv_Grace_Days	udd_number	int(4)	Yes	Receipt Grace Days	No
CI_Disc_Grace_Days	udd_number	int(4)	Yes	Discount Grace Days	No
CI_Res_WrOff_Perc	udd_discountpercentage	numeric(5)	Yes	Residual Write Off Percentage	No
CI_Res_WrOff_Amt	udd_amount	numeric(13)	Yes	Residual Write Off Amount	No
CI_Identification_Ref	udd_trackingnumber	varchar(20)	Yes	Identification Reference	No
CI_Identification_No	udd_documentno	varchar(40)	Yes	Identification Number	No
CI_DNB_Code	udd_documentno	varchar(40)	Yes	DNB Code	No
CI_DNB_Rating	udd_documentno	varchar(40)	Yes	DNB Rating	No
CI_SIC_Code	udd_typecode	varchar(10)	Yes	SIC Code	No
CI_ISO_Code	udd_code	varchar(6)	Yes	ISO Code	No
CI_Market	udd_identificationnumber1	varchar(5)	Yes	Market	No
CI_Industory	udd_identificationnumber1	varchar(5)	Yes	Industry	No
CI_Region	udd_identificationnumber1	varchar(5)	Yes	Region	No
CI_Segment	udd_identificationnumber1	varchar(5)	Yes	Segment	No
CI_SubSegment	udd_identificationnumber1	varchar(5)	Yes	Subsgement	No
CI_Created_By	udd_ctxt_user	varchar(30)	Yes	Created By	No
CI_Created_Date	_datetime_8	datetime(8)	Yes	Created Date	No
CI_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
CI_Modified_Date	_datetime_8	datetime(8)	Yes	Modified Date	No
CI_Gen_Con_eval	fin_designparamcode	varchar(5)	Yes	General Contract Evaluation Allowed ?	No

Table Name :	Cu_CLH_Company_Level_Hdr
Comment :	Company Level Hdr

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CLH_Created_Ouinstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CLH_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
CLH_Vat_Class	udd_vatclass	varchar(40)	Yes	Vat Class	No
CLH_Vat_Category	udd_vatcategory	varchar(40)	Yes	Vat Category	No
CLH_Euro_Vat_Id	udd_desc40	varchar(40)	Yes	Euro Vat ID	No
CLH_Swiss_Vat_Id	udd_desc40	varchar(40)	Yes	Swiss Vat ID	No
CLH_Comp_BankAcc_No	udd_accountcode	varchar(32)	Yes	Company Bank A/c No	No
CLH_Recpt_Mode	udd_receiptmode	varchar(25)	Yes	Receipt Mode	No
CLH_Cust_Bank_Code	udd_bankcode	varchar(32)	Yes	Customer Bank Code	No
CLH_Cust_BankAcc_No	udd_accountcode	varchar(32)	Yes	Customer Ban A/c No	No
CLH_Bank_Esr_Flag	udd_designparamcode	varchar(5)	Yes	Bank Esr Flag	No
CLH_Esr_Bank_Code	udd_bankcode	varchar(32)	Yes	Bank Esr Code	No
CLH_Bank_Esr_Type	udd_designparamcode	varchar(5)	Yes	Bank Esr Type	No
CLH_Ptt_Esr_Flag	udd_designparamcode	varchar(5)	Yes	Ptt Esr Flag	No
CLH_Cust_PttAcc_No	udd_accountcode	varchar(32)	Yes	Customer Ptt Account Number	No
CLH_Esr_Ptt_Code	udd_bankcode	varchar(32)	Yes	Est Ptt Code	No
CLH_Ptt_Esr_Type	udd_designparamcode	varchar(5)	Yes	Esr PTT Type	No
CLH_Created_By	udd_ctxt_user	varchar(30)	Yes	Created By	No
CLH_Created_Date	_datetime_8	datetime(8)	Yes	Created Date	No
CLH_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
CLH_Modified_Date	_datetime_8	datetime(8)	Yes	Modified Date	No

Table Name :	Cu_CLSV_Company_LSV_Dtl
Comment :	Company LSV Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CLSV_Created_OUInstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CLSV_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
CLSV_Line_No	udd_seqno	int(4)	No	Line Number	Yes
CLSV_Receipt_method	udd_designparamcode	varchar(5)	Yes	Receipt Method	No
CLSV_Default_Flag	udd_designparamcode	varchar(5)	Yes	Default Flag	No
CLSV_Bank_Code	udd_bankcode	varchar(32)	Yes	Bank Code	No
CLSV_LSV_ContractId	udd_participationid	varchar(30)	Yes	LSV Contract id	No
CLSV_Contract_Ref	udd_desc120	varchar(120)	Yes	Contract Reference	No
CLSV_EffFrom_Date	_datetime_8	datetime(8)	Yes	Effectivity From Date	No
CLSV_EffTo_Date	_datetime_8	datetime(8)	Yes	Effectivity To Date	No
CLSV_Cust_BankAcc_No	udd_accountcode	varchar(32)	Yes	Customer Bank A/C No	No
CLSV_Cust_Bank_Ref	udd_bankcode	varchar(32)	Yes	Customer Bank Reference	No
CLSV_Remarks	udd_txt255	varchar(255)	Yes	Remarks	No

Table Name :	Cu_CMH_Cust_Master_Hdr
Comment :	Customer Master Header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMH_Created_Ouinstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CMH_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
CMH_Cust_Name	udd_custname	varchar(40)	No	Customer Name	No
CMH_Cust_Nature	udd_designparamcode	varchar(5)	No	Customer Nature	No
CMH_Reference_Status	udd_designparamcode	varchar(5)	No	Reference Status	No
CMH_Operator_Code	udd_airlineoperatorcode	varchar(30)	Yes	Operator Code	No
CMH_ParCust_Code	udd_customer_id	varchar(18)	Yes	Part Customer Code	No
CMH_Supl_Code	udd_vendorcode	varchar(45)	Yes	Supplier Code	No
CMH_Spec_Code	udd_spec2kmfgcode	varchar(5)	Yes	Specific Code	No
CMH_Sita_Code	udd_vendorcode	varchar(45)	Yes	Sita Code	No
CMH_Register_Date	_datetime_8	datetime(8)	Yes	Register Date	No
CMH_Address1	udd_address	varchar(40)	Yes	Address 1	No
CMH_Address2	udd_address	varchar(40)	Yes	Address 2	No
CMH_Address3	udd_address	varchar(40)	Yes	Address 3	No
CMH_City	udd_city	varchar(32)	Yes	City	No
CMH_ZipCode	udd_zip	varchar(15)	Yes	Zip Code	No
CMH_State	udd_state	varchar(32)	Yes	State	No
CMH_Country	udd_countrycode	varchar(5)	Yes	Country	No
CMH_phone_No	udd_phone	varchar(18)	Yes	Phone Number	No
CMH_Mobile_No	udd_contactnumber	varchar(20)	Yes	Mobile Number	No
CMH_Fax_No	udd_contactnumber	varchar(20)	Yes	Fax Number	No
CMH_Email_Id	udd_email	varchar(60)	Yes	Email Id	No
CMH_Url_Id	udd_homepage	varchar(60)	Yes	URL ID	No
CMH_Company_Code	udd_companycode	varchar(10)	Yes	Company Code	No
CMH_BU_Code	udd_buid	varchar(20)	Yes	BU Code	No
CMH_PartSale_Flag	udd_flag2	varchar(25)	Yes	Part Sale Applicability?	No
CMH_SerSale_Flag	udd_flag2	varchar(25)	Yes	Service Sale Applicability?	No
CMH_CompLoan_Flag	udd_flag2	varchar(25)	Yes	Component Loan Flag ?	No
CMH_CompExange_Flag	udd_flag2	varchar(25)	Yes	Component Exchange Flag?	No
CMH_Credcheck_Code	udd_creditchk	varchar(40)	Yes	Credit Check Code	No
CMH_FileName	udd_filename	varchar(50)	Yes	File Name	No
CMH_Remarks	udd_txt255	varchar(255)	Yes	Remarks	No
CMH_Enga_Type	udd_designparamcode	varchar(5)	Yes	Engagement Type	No
CMH_Created_By	udd_ctxt_user	varchar(30)	Yes	Created By	No
CMH_Created_Date	_datetime_8	datetime(8)	Yes	Created Date	No
CMH_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
CMH_Modified_Date	_datetime_8	datetime(8)	Yes	Modified Date	No
CMH_Timestamp	udd_timestampint	int(4)	Yes	Timestamp	No
CMH_UserName	udd_hrusername	varchar(25)	Yes	User Name	No
CMH_Restrict_Type	udd_flag1	varchar(25)	Yes	Restrict Type	No
CMH_LastReviewedDate	udd_date	varchar(15)	Yes	Last Reviewed Date	No
CMH_ValidTillDate	udd_date	varchar(15)	Yes	Valid Till Date	No
CMH_cuscatogerycode	udd_designparamcode	varchar(5)	Yes	Customer Catergory code	No
CMH_cuscatogerydesc	udd_txt255	varchar(255)	Yes	Customer Catergory Description	No

Table Name :	CU_CMI_Cus_Mod_Dtl
Comment :	Customer Modification details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMI_Created_OU	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CMI_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
CMI_Cust_Name	udd_custname	varchar(40)	Yes	Customer Name	No
CMI_Address	udd_txt255	varchar(255)	No	Address	No
CMI_From_Date	udd_datetime1	datetime(8)	No	From Date	Yes
CMI_To_Date	udd_datetime1	datetime(8)	Yes	To Date	No
CMI_Created_By	udd_ctxt_user	varchar(30)	No	Created By	No
CMI_Created_Date	udd_datetime1	datetime(8)	No	Created Date	No
CMI_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
CMI_Modified_Date	udd_datetime1	datetime(8)	Yes	Modified Date	No

Table Name :	Cu_CPD_Cust_Part_Dtl
Comment :	Customer Part Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPD_Created_OUInstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CPD_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
CPD_SalesLoc_OU	udd_ctxt_ouinstance	int(4)	No	Sale Ouinstance	Yes
CPD_Part_Crt_Ou	udd_ctxt_ouinstance	int(4)	Yes	Part Crt Ouinstance	No
CPD_Part_No	udd_partno	varchar(40)	No	Part Number	Yes
CPD_Cust_Part_No	udd_partno	varchar(40)	Yes	Customer Part Number	No
CPD_Ship_Point	udd_ouinstname	varchar(16)	Yes	Shipment Point	No
CPD_WH_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Warehouse Ouinstance	No
CPD_WH_Code	udd_warehouse	varchar(10)	Yes	Warehouse Code	No
CPD_Created_By	udd_ctxt_user	varchar(30)	Yes	Created By	No
CPD_Created_Date	_datetime_8	datetime(8)	Yes	Created Date	No
CPD_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
CPD_Modified_Date	_datetime_8	datetime(8)	Yes	Modified Date	No

Table Name :	Cu_CPI_Contact_Person_Info
Comment :	Customer Contact Person Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPI_Created_OUInstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CPI_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
CPI_SalesLoc_Ou	udd_ctxt_ouinstance	int(4)	No	Sale Ouinstance	Yes
CPI_Address_Id	udd_addressid	varchar(12)	No	Address_Id	Yes
CPI_LineNo	udd_seqno	int(4)	No	Line Number	Yes
CPI_Person_Name	udd_custname	varchar(40)	Yes	Person Name	No
CPI_Designation	udd_contact	varchar(40)	Yes	Designation	No
CPI_Department	udd_contact	varchar(40)	Yes	Department	No
CPI_Address1	udd_address	varchar(40)	Yes	Address 1	No
CPI_Address2	udd_address	varchar(40)	Yes	Address 2	No
CPI_Address3	udd_address	varchar(40)	Yes	Address 3	No
CPI_City	udd_city	varchar(32)	Yes	City	No
CPI_ZipCode	udd_zip	varchar(15)	Yes	Zip Code	No
CPI_state	udd_state	varchar(32)	Yes	State	No
CPI_Country	udd_countrycode	varchar(5)	Yes	Country	No
CPI_phone_No	udd_phone	varchar(18)	Yes	Phone Number	No
CPI_EMail_Id	udd_email	varchar(60)	Yes	Email Id	No
CPI_Fax_No	udd_contactnumber	varchar(20)	Yes	Fax Number	No
CPI_Visit_Hrs	udd_desc40	varchar(40)	Yes	Visit Hours	No
CPI_Birth_Date	_datetime_8	datetime(8)	Yes	Birth Date	No
CPI_Marriage_Date	_datetime_8	datetime(8)	Yes	Marriage Date	No
CPI_Remarks	udd_txt255	varchar(255)	Yes	Remarks	No
CPI_Default_Flag	udd_designparamcode	varchar(5)	Yes	Default Flag	No
CPI_Created_By	udd_ctxt_user	varchar(30)	Yes	Created By	No
CPI_Created_Date	_datetime_8	datetime(8)	Yes	Created Date	No
CPI_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
CPI_Modified_Date	_datetime_8	datetime(8)	Yes	Modified Date	No

Table Name :	Cu_CRD_CCer_Req_Dtl
Comment :	Custoerm Ccer Required Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CRD_Created_OU	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CRD_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
CRD_PartNo	udd_partno	varchar(40)	No	Part Number	Yes
CRD_PartNo_OU	udd_ctxt_ouinstance	int(4)	Yes	Part Ouinstance	No
CRD_Cert_Typ	udd_flag1	varchar(25)	No	Certification Type	Yes
CRD_Remarks	udd_text255	varchar(255)	Yes	Remarks	No
CRD_Template	udd_filename	varchar(50)	Yes	Template	No
CRD_Created_By	udd_ctxt_user	varchar(30)	No	Created By	No
CRD_Created_Date	udd_datetime1	datetime(8)	No	Created Date	No
CRD_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
CRD_Modified_Date	udd_datetime1	datetime(8)	Yes	Modified Date	No

Table Name :	Cu_Cuctm_Cust_TCD_Map
Comment :	Customer TCD Map

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CUCTM_OUInstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CUCTM_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
CUCTM_Delarea	udd_deliveryarea	varchar(18)	No	Delivery Area	Yes
Cuctm_Appl_On	udd_designparamcode	varchar(5)	No	Applied On	Yes
CUCTM_Seq_No	udd_seqno	int(4)	No	Sequence Number	Yes
CUCTM_Tcd_Code	udd_quickcodes	varchar(25)	No	TCD Code	Yes
CUCTM_Tcd_Variant	udd_quickcodes	varchar(25)	No	TCD Variant	Yes
CUCTM_Tcd_OU	udd_ctxt_ouinstance	int(4)	No	TCD Ouinstance	Yes
CUCTM_Billable_Flag	udd_designparamcode	varchar(5)	Yes	Billable Flag	No

Table Name :	Cu_CuPrm_Parameter_Details
Comment :	Customer Parameter details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CuPrm_ComponentName	udd_txt80	varchar(80)	Yes	Component Name	No
Cuprm_ParamCategory	udd_paramcategory	varchar(10)	Yes	Parameter category	No
Cuprm_ParamType	udd_paramtype	varchar(25)	Yes	Parameter Type	No
Cuprm_Paramcode	udd_designparamcode	varchar(5)	Yes	Parameter code	No
CuPrm_ParamDesc	udd_gtext	varchar(80)	Yes	Parameter Description	No
CuPrm_Langid	udd_ctxt_language	int(4)	Yes	Language ID	No
Cuprm_Sort_by	_int_0	int(0)	No	Modified By	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication Key	Yes

Table Name :	Cu_CuTCD_Cust_TCD_StaDefTax
Comment :	Customer Standard Default Tax

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CuTcd_SDT_Created_OU	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CuTcd_SDT_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
CuTcd_SDT_TaxNo	udd_flag1	varchar(25)	No	Task Number	Yes
CuTcd_SDT_Tax_VarNo	udd_flag1	varchar(25)	No	Task Variance Number	Yes
CuTCD_SDT_Created_By	udd_ctxt_user	varchar(30)	No	Created By	No
CuTCD_SDT_Created_Date	udd_datetime	varchar(30)	No	Created Date	No
CuTCD_SDT_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
CuTcd_SDT_Modified_Date	udd_datetime	varchar(30)	Yes	Modified Date	No

Table Name :	Cu_CuTCD_Cust_TCD_Tax_Reg_Dtl
Comment :	Customer TCD Tax Registration details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CuTcd_CRD_Created_OU	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CuTcd_CRD_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
CuTcd_CRD_Address_ID	udd_addressid	varchar(12)	No	Address ID	No
CuTcd_CRD_TaxType	udd_applicableon	varchar(20)	No	Tax Type	No
CuTcd_CRD_RegNo	udd_Desc35	varchar(35)	No	CRD Register Number	No
CuTcd_CRD_LineNo	udd_seqno	int(4)	No	CRD Line Number	Yes
CuTCD_CRD_Created_By	udd_ctxt_user	varchar(30)	No	Created By	No
CuTCD_CRD_Created_Date	udd_datetime	varchar(30)	No	Created Date	No
CuTCD_CRD_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
CuTcd_CRD_Modified_Date	udd_datetime	varchar(30)	Yes	Modified Date	No

Table Name :	CU_DSB_Def_Ship_Bill_Info
Comment :	Defatut Billing & Shipping details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DSB_Created_OUInstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
DSB_Cust_Code_Hdr	udd_customer_id	varchar(18)	No	Customer Code	Yes
DSB_SalesLoc_OU	udd_ctxt_ouinstance	int(4)	No	Sale Ouinstance	Yes
DSB_Cust_Code_Mlt	udd_customer_id	varchar(18)	No	Customer Code In Multiine	Yes
DSB_ShipBill_Type	udd_designparamcode	varchar(5)	Yes	Billing Type	No
DSB_Created_By	udd_ctxt_user	varchar(30)	Yes	Created By	No
DSB_Created_Date	_datetime_8	datetime(8)	Yes	Created Date	No
DSB_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
DSB_Modified_Date	_datetime_8	datetime(8)	Yes	Modified Date	No

Table Name :	CU_PMD_Prt_Mst_Dtl
Comment :	Customer Part Master Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PMD_Created_OU	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
PMD_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
PMD_PartNo	udd_partno	varchar(40)	No	Part Number	Yes
PMD_PartNo_OU	udd_ctxt_ouinstance	int(4)	No	Part Ouinstance	No
PMD_Cus_PartNO	udd_partno	varchar(40)	Yes	Customer Part Number	No
PMD_Supp_By	udd_txt150	varchar(150)	Yes	Supplied By	No
PMD_Rep_Policy	udd_flag2	varchar(25)	Yes	Receipt Policy	No
PMD_Created_By	udd_ctxt_user	varchar(30)	No	Created By	No
PMD_Created_Date	udd_datetime1	datetime(8)	No	Created Date	No
PMD_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
PMD_Modified_Date	udd_datetime1	datetime(8)	Yes	Modified Date	No
PMD_mfrpartno	fin_partno	varchar(40)	Yes	Manufacturer Part Number	No
PMD_mfrno	fin_vendorcode	varchar(45)	Yes	Manufacture Number	No

Table Name :	Cu_PPL_PartPrice_List_Dtl
Comment :	Customer Part Price List Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PPL_Created_OUInstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
PPL_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
PPL_SalesLoc_OU	udd_ctxt_ouinstance	int(4)	No	Sale Ouinstance	Yes
PPL_Seq_No	udd_seqno	int(4)	No	Part Sequence Number	Yes
PPL_Price_List	udd_pricelist	varchar(40)	Yes	Part Price List	No
PPL_Eff_From	_datetime_8	datetime(8)	Yes	Effectivity From	No
PPL_Eff_To	_datetime_8	datetime(8)	Yes	Effectivity To	No

Table Name :	CU_SLD_Sts_Log_Dtl
Comment :	Customer Status Log Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SLD_Created_OU	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
SLD_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
SLD_Changed_On	udd_datetime1	datetime(8)	No	Changed On	Yes
SLD_Changed_by	udd_ctxt_user	varchar(30)	No	Changed By	Yes
SLD_Ref_Status	udd_designparamcode	varchar(5)	No	Reference Status	No
SLD_Opr_Status	udd_designparamcode	varchar(5)	Yes	Operation Status	No
SLD_Comments	udd_text255	varchar(255)	Yes	Comments	No
SLD_Created_By	udd_ctxt_user	varchar(30)	No	Created By	No
SLD_Created_Date	udd_datetime1	datetime(8)	No	Created Date	No
SLD_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
SLD_Modified_Date	udd_datetime1	datetime(8)	Yes	Modified Date	No

Table Name :	Cu_SLI_Sales_int_contact_Info
Comment :	To Store The Sales Internal Contract Information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SLI_Deft_OUINSTANCE	UDD_CTXT_OUINSTANCE	int(4)	Yes	Organisation Unit	No
SLI_Deft_CUSTOMER_CODE	UDD_CUSTOMER_ID	varchar(18)	Yes	Customer Code	No
SLI_Deft_CONCATEGORY	UDD_OPTIONCODE	varchar(8)	Yes	Contract Category	No
SLI_Deft_CONCATEGORY_DESC	udd_txt255	varchar(255)	Yes	Contract Category Description	No
SLI_Deft_EmpNO	fin_employee_code	Char(60)	Yes	Employee Code	No
SLI_Deft_SEQNO	udd_SEQNO	int(4)	No	Seq no	Yes
SLI_Deft_Remarks	udd_remarks	varchar(255)	Yes	Remarks	No

Table Name :	Cu_SLI_Sales_Location_Info
Comment :	Customer Sales Location Info

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SLI_Created_OUInstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
SLI_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
SLI_salesLoc_Ou	udd_ctxt_ouinstance	int(4)	No	Sale Ouinstance	Yes
SLI_Opera_Status	udd_designparamcode	varchar(5)	Yes	Operation Status	No
SLI_Deft_ShipTo_Cust	udd_customer_id	varchar(18)	Yes	Default Ship To Customer	No
SLI_Deft_BillTo_Cust	udd_customer_id	varchar(18)	Yes	Default Bill To Customer	No
SLI_Auto_InvAuth_flag	udd_flag	varchar(25)	Yes	Auto Invoice Authorization Flag	No
SLI_Freight_Billable	udd_tcd_bill	varchar(12)	Yes	Freight Billable	No
SLI_Elgble_For_Rebate	udd_flag	varchar(25)	Yes	Rebate Eligible	No
SLI_TaxExempt_Flag	udd_flag	varchar(25)	Yes	Tax exempted Flag	No
SLI_TaxExempt_No	udd_documentno	varchar(40)	Yes	Tax exempted Number	No
SLI_Inv_Appl_flag	udd_flag	varchar(25)	Yes	Invoice Applicable Flag	No
SLI_No_Of_InvCopies	udd_order	int(4)	Yes	Number of Invoice Copies	No
SLI_Ship_Point	udd_ouinstname	varchar(16)	Yes	Shipping Point	No
SLI_Transport_Mode	udd_transportationmode	varchar(25)	Yes	Transport Mode	No
SLI_Prfrd_Carrier	udd_carriercode	varchar(20)	Yes	Preferred Carrier	No
SLO_Freight_Term	udd_txt150	varchar(150)	Yes	Freight Term	No
SLI_PartShip_Allowed	udd_flag	varchar(25)	Yes	Part shipment allowed?	No
SLI_Tranship_Allowed	udd_flag	varchar(25)	Yes	Transaction shipment Allowed?	No
SLI_ShipTot_Neg	udd_tolerance	int(4)	Yes	Ship to Neg	No
SLI_ShipTot_Pos	udd_tolerance	int(4)	Yes	Ship to Pos	No
SLI_BilTo_Id	udd_customer_id	varchar(18)	Yes	Bill To ID	No
SLI_ShipTo_Id	udd_customer_id	varchar(18)	Yes	Ship To ID	No
SLI_Order_From_Id	udd_customer_id	varchar(18)	Yes	Order From ID	No
SLI_Created_By	udd_ctxt_user	varchar(30)	Yes	Created By	No
SLI_Created_Date	_datetime_8	datetime(8)	Yes	Created Date	No
SLI_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
SLI_Modified_Date	_datetime_8	datetime(8)	Yes	Modified Date	No

Table Name :	CU_SPD_Ser_PrLst_Dtl
Comment :	Customer Service / Part Price List Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SPD_Created_OU	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
SPD_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
SPD_SalesLocOU	udd_ctxt_ouinstance	int(4)	No	Sale Ouinstance	Yes
SPD_Ser_PrLst	udd_pricelist	varchar(40)	No	Service / Part Price List	Yes
SPD_SrPrLst_OU	udd_ctxt_ouinstance	int(4)	No	Service Price List Ouinstance	No
SPD_Eff_From	udd_datetime1	datetime(8)	Yes	Effectivity From	No
SPD_Eff_To	udd_datetime1	datetime(8)	Yes	Effectivity To	No
SPD_Created_By	udd_ctxt_user	varchar(30)	No	Created By	No
SPD_Created_Date	udd_datetime1	datetime(8)	No	Created Date	No
SPD_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
SPD_Modified_Date	udd_datetime1	datetime(8)	Yes	Modified Date	No
SPD_Rev_no	udd_revisionno	varchar(40)	No	Revision Number	Yes

Table Name :	CU_SPH_Ser_PrLst_Hdr
Comment :	Customer Service / Part Price Header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SPH_Created_OU	udd_ctxt_ouinstance	int(4)	No	PH Ouinstance	Yes
SPH_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
SPH_SalesLocOU	udd_ctxt_ouinstance	int(4)	Yes	PH Sale Ouinstance	No
SPH_Adv_Payable	udd_designparamcode	varchar(5)	Yes	Advance Payable	No
SPH_Adv_Tolerance	udd_discountpercentage	numeric(5)	Yes	Advance Tolerance	No
SPH_Adv_Percent	udd_paymentpercent	numeric(13)	Yes	Advance Percentage	No
SPH_Adv_PercentON	udd_flag2	varchar(25)	Yes	Advance Percentage On	No
SPH_Act_Non_Pay	udd_flag2	varchar(25)	Yes	Account Non Pay	No
SPH_Created_By	udd_ctxt_user	varchar(30)	No	Created By	No
SPH_Created_Date	udd_datetime1	datetime(8)	No	Created Date	No
SPH_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
SPH_Modified_Date	udd_datetime1	datetime(8)	Yes	Modified Date	No

Table Name :	CU_TMD_Task_Mstr_Dtl
Comment :	Customer Task Master Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TMD_Created_OU	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
TMD_Cust_Code	udd_customer_id	varchar(18)	No	Customer Code	Yes
TMD_Cust_OU	udd_ctxt_ouinstance	int(4)	No	Customer Ouinstance	No
TMD_Task_No	udd_workunitcode	varchar(30)	No	Task Number	Yes
TMD_Task_Desc	udd_txt150	varchar(150)	Yes	Task Description	No
TMD_Applicability	udd_designparamcode	varchar(5)	No	Applicability	No
TMD_Mnt_Obj	udd_itemcode	varchar(32)	No	Maintance Objects	Yes
TMD_WU_Typ	udd_designparamcode	varchar(5)	No	Work unit Type	No
TMD_WU_Code	udd_workunitcode	varchar(30)	No	Warehouse Code	No
TMD_WU_OU	udd_ctxt_ouinstance	int(4)	No	Warehouse Ouinstance	No
TMD_Remarks	udd_txt150	varchar(150)	Yes	Remarks	No
TMD_FileName	udd_filename	varchar(50)	Yes	File Name	No
TMD_Created_By	udd_ctxt_user	varchar(30)	No	Created By	No
TMD_Created_Date	udd_datetime1	datetime(8)	No	Created Date	No
TMD_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
TMD_Modified_Date	udd_datetime1	datetime(8)	Yes	Modified Date	No
TMD_BaseModel_OU	udd_ctxt_ouinstance	int(4)	Yes	Bas Model Ouinstance	No
TMD_BaseModel_No	udd_model	varchar(20)	Yes	Base Model Number	No

Table Name :	sal_processparam_sys
Comment :	Sales Process Parameters

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sale_ou	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
sale_lang_id	fin_ctxt_language	int(4)	Yes	Language ID	No
sale_component_code	fin_component	varchar(16)	Yes	Component Code	No
sale_component_desc	fin_param_text	varchar(255)	Yes	Component Description	No
sale_param_code	fin_paramcode	varchar(30)	Yes	Parameter code	No
sale_param_desc	fin_param_text	varchar(255)	Yes	Parameter Description	No
sale_param_value	fin_paramvalue	varchar(30)	Yes	Parameter Value	No
sale_param_remarks	fin_param_text	varchar(255)	Yes	Remarks	No
sale_createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
sale_createddate	fin_date	datetime(8)	Yes	Created Date	No
sale_modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
sale_modifieddate	fin_date	datetime(8)	Yes	Modified Date	No
Sale_lineno	fin_lineno	int(4)	Yes	Line Number	No