Table Reports : HTM-Reports (BASCU.ER1, Saturday, April 28, 2007 14:04:55, 408 rows)

HTM-Reports

Table Owner Table Name Table Comment Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

dbo AGP_CAM_Cust_ActGrp_Map This table holds the data of customer accout group mapping information CAM_Created_OUInstance int NOT NULL created instance No No

CAM_Cust_Act_Grp_Code sql_variant unique code for customer account group

CAM_Customer_Code cutomer code

CAM_Customer_OU int NULL customer created instance

CAM_Created_By sql_variant NOT NULL created user name

CAM_Created_Date datetime created date

CAM_Modified_By sql_variant modified user name

CAM_Modified_Date datetime modified date

CAM_Timestamp int NULL timestamp for not allowing more than one user to process the same data

Cu_ARD_Acr_Req_Dtl This Table Stores the AirCraft Certificate Details across Sales Point ARD_Created_OU NOT NULL created instance Yes

ARD_Cust_Code sql_variant customer code

ARD_ACft_RegNo varchar(30) aircraft register no

ARD_Cert_Typ sql_variant aircraft certification type

ARD_ACft_OU int aircraft created instance No

ARD_Desc sql_variant NULL description

ARD_Remarks remarks

ARD_Tmplt template

ARD_Created_By NOT NULL created user name

ARD_Created_Date datetime created date

ARD_Modified_By sql_variant NULL modified user name

ARD_Modified_Date datetime modified date

Cu_CAD_Cust_AddressId_Dtl This Table Stores the Address Details of Customer irrespective of Sales Point CAD_Created_Ouinstance int NOT NULL created instance Yes

CAD_Cust_Code sql_variant customer code

CAD_Address_ID addresss id

CMH_Created_Ouinstance int created instance Yes

CMH_Cust_Code sql_variant customer code

CAD_Address1 NULL address1 No No

CAD_Address2 address2

CAD_Address3 address3

CAD_City city

CAD_ZipCode zip code

CAD_State state

CAD_Country country

CAD_phone_No Phone no

CAD_Fax_No fax no

CAD_Email_Id mail id

CAD_Spec_Code spec_code

CAD_Sita_Code sita_code

CAD_Inco_Term Inco term

CAD_Inco_Place_air inco through air

CAD_Inco_Place_road inco place road

CAD_Inco_Place_rail inco place rail

CAD_Inco_place_ship inco place ship

CAD_Delivery_Code delivery code

cu_cbum_cus_base_user_map this table stores the details of user mapping cbum_ouinstance int NOT NULL user mapping instance Yes

cbum_customer_code sql_variant customer code

cbum_base base

cbum_user current user

cbum_effective_from datetime effectivity of the user from

cbum_effective_to NULL effectivity of the user to No

cbum_timestamp int timestamp for not allowing more than one user to process the same data

cbum_created_by sql_variant created user name

cbum_created_date datetime created date

cbum_modified_by sql_variant modified user name

cbum_modified_date datetime modified date

Cu_CCD_Cus_Comp_Dtl This table stores the customer company details CCD_Created_OU int created instance

CCD_Cust_Code sql_variant customer code

CCD_Compnt_Code customer component code

CCD_Compnt_OU int customer component created instance

CCD_PartNo sql_variant part no

CCD_PartNo_OU int customer part created instance

CCD_Mft_SNo sql_variant customer part manufactured serial no

CCD_Enga_Type engagement type

CCD_Created_By created user name

CCD_Created_Date created date

CCD_Modified_By modified user name

CCD_Modified_Date modified date

Cu_CD_Certificate_Dtl This Table Saves Certificate Details in a Sales Point CD_Created_OUInstance int NOT NULL created instance Yes

CD_Cust_Code sql_variant customer code

CD_SalesLoc_OU int sales location instance

CD_Part_No sql_variant part no

CD_Cert_Type certification type for the part

CPD_Created_OUInstance int created instance Yes

CPD_Cust_Code sql_variant customer code

CPD_SalesLoc_OU int sales location instance

CPD_Part_No sql_variant part no

CD_Remarks NULL remarks for the certification detail of the part No No

CD_Filename file name used for reference

CD_Created_By created user name

CD_Created_Date datetime created date

CD_Modified_By sql_variant modified user name

CD_Modified_Date datetime modified date

Cu_CGD_Cust_Group_Dtl This Table Stores the details of a Customer Group CGD_Created_OuInstance int NOT NULL created instance Yes

CGD_Cust_Group_Code sql_variant customer group code

CGD_Cust_Created_Ou int created customer instance

CGD_Customer_Code sql_variant customer code

CGH_Created_OuInstance int created instance Yes

CGH_Cust_Group_Code sql_variant customer group code

Cu_CGH_Cust_Group_Hdr This is the Header Table for Customer Group CGH_Created_OuInstance int created instance No

CGH_Cust_Group_Code sql_variant customer group code Unique code for each group

CGH_Cust_Group_Desc NULL group description No

CGH_Group_Type_Code group type code

CGH_Group_Status group status values will be Active Inactive

CGH_Controlled_Group controlled group yes or no

CGH_Created_By created user name

CGH_Created_Date datetime created date

CGH_Modified_By sql_variant modfiied user name

CGH_Modified_Date datetime modified date

CGH_TimeStamp int timestamp for not allowing more than one user to access the same data

CGH_Remarks sql_variant remarks for the customer group to be generated

Cu_CI_Commercial_Info This Table Saves the Commercial details across Sales Point CI_Created_OUInstance int NOT NULL created instance Yes

CI_Cust_Code sql_variant customer code: unique code to identify each customer

CMH_Created_Ouinstance int created organization instance Yes

CMH_Cust_Code sql_variant unique code for identification of the customer

CI_Cust_Type NULL type of customer values like domestic export No No

CI_Currency currency defined for the customer predefined curencies would be the values

CI_Crd_Term_code credit term code

CI_Pay_Term pay term code

CI_Tax_Payer_ID tax payer id no

CI_Collector collector no

CI_send_Stmnt whether to send the statement or not values will be yes or no

CI_Stmnt_Int_Days int if statement to be sent then on which interval to be sent

CI_Crd_ChkAction sql_variant 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

CI_Dunning_Reqd dunning required

CI_Single_Ord_Lmt bigint single order limit amount

CI_Total_Ord_Lmt total order limit amount

CI_Recv_Grace_Days int Receivable Grace Days

CI_Disc_Grace_Days Discount Grace Days

CI_Res_WrOff_Perc bigint Residual Writeoff %

CI_Res_WrOff_Amt Residual Writeoff Amount

CI_Identification_Ref sql_variant Company Identification Reference values will be the quick codes defined for company identification reference

CI_Identification_No Identification No.

CI_DNB_Code D&B Code No.

CI_DNB_Rating D&B Rating

CI_SIC_Code SIC Code

CI_ISO_Code ISO Code

CI_Market market

CI_Industory industry

CI_Region region

CI_Segment segment

CI_SubSegment subsegment

CI_Created_By created username

CI_Created_Date datetime created date

CI_Modified_By sql_variant modified user name

CI_Modified_Date datetime Modified date

CI_CrdCurrency nvarchar(20) Added for Rel6 Changes (For Credit Currency in Edit Commercial Information)

Cu_CLH_Company_Level_Hdr This is the Header table for Payment Receipt Details of a Customer across Sales Point CLH_Created_Ouinstance int NOT NULL created instance Yes

CLH_Cust_Code sql_variant customer unique code

CLH_Vat_Class NULL vat class No

CLH_Vat_Category vat category

CLH_Euro_Vat_Id euro id for vat

CLH_Swiss_Vat_Id swiss id for vat

CLH_Comp_BankAcc_No COMPANY BANK ACCOUNT NO

CLH_Recpt_Mode RECEIPT MODE VALUES WILL BE cheque credit credit cared debit card direct demand draft

CLH_Cust_Bank_Code customer bank code

CLH_Cust_BankAcc_No customer bank account no

CLH_Bank_Esr_Flag bank esr flag

CLH_Esr_Bank_Code bank esr code

CLH_Bank_Esr_Type esr type

CLH_Ptt_Esr_Flag ptt esr flag

CLH_Cust_PttAcc_No customer ptt account no

CLH_Esr_Ptt_Code esr ptt code

CLH_Ptt_Esr_Type ptt esr type

CLH_Created_By created user name

CLH_Modified_By modified user name

CLH_Created_Date datetime created date

CLH_Modified_Date modified date

Cu_CLSV_Company_LSV_Dtl This Table Stores the details of Payment Recepit for a Customer across Sales Point CLSV_Created_OUInstance int NOT NULL created instance Yes

CLSV_Cust_Code sql_variant customer code

CLSV_Line_No int line no for multi value reference

CLH_Created_Ouinstance created instance Yes

CLH_Cust_Code sql_variant customer code

CLSV_Receipt_method NULL receipt method No No

CLSV_Default_Flag default flag

CLSV_Bank_Code bank code given by the customer

CLSV_LSV_ContractId contract id

CLSV_Contract_Ref contract reference

CLSV_Cust_BankAcc_No customer bank account no

CLSV_Cust_Bank_Ref customer bank reference details

CLSV_Remarks remarks

CLSV_EffFrom_Date datetime effectivity from date

CLSV_EffTo_Date effectivity to date

Cu_CMH_Cust_Master_Hdr This is the Master Table For BAS Customer Component CMH_Created_Ouinstance int NOT NULL created instance Yes

CMH_Cust_Code sql_variant customer code unique code to identify the customer

CMH_Cust_Name customer name No

CMH_Cust_Nature Nature of the customer values will be external internal group company

CMH_Reference_Status reference status of the customer can be active inactive under creation

CMH_Operator_Code NULL Operator code

CMH_ParCust_Code parent customer code

CMH_Supl_Code supplier code

CMH_Spec_Code SPEC code

CMH_Sita_Code SITA / ARINC code

CMH_Register_Date datetime registration date

CMH_Address1 sql_variant address 1 of the customer

CMH_Address2 address2 of the customer

CMH_Address3 address3 of the customer

CMH_City city defined for the customer

CMH_ZipCode zipcode defined for the customer

CMH_State state defined for the customer

CMH_Country country defined for the customer

CMH_phone_No phone no defined for the customer

CMH_Mobile_No mobile no defined for the customer

CMH_Fax_No fax no defined for the customer

CMH_Email_Id mail id defined for the customer

CMH_Url_Id url id defined for the customer

CMH_Company_Code company code defined for the customer

CMH_BU_Code bu code defeined for the customer

CMH_PartSale_Flag nature of relationship is choosen for part sale flag value will be 1 else 0

CMH_SerSale_Flag nature of relationship is choosen for ser sale flag value will be 1 else 0

CMH_CompLoan_Flag nature of relationship is choosen for comploan sale flag value will be 1 else 0

CMH_CompExange_Flag nature of relationship is choosen for compexchange sale flag value will be 1 else 0

CMH_Credcheck_Code credit check code values will be codes defined for customer up to hirerchy total hirerchy

CMH_FileName file name for reference

CMH_Remarks remarks

CMH_Enga_Type engagement type of the customer values will be the codes of full time maintenance on request

CMH_Created_By created user name

CMH_Modified_By modified user name

CMH_Timestamp int timestamp for not allowing more than one user to process the same data

CMH_Modified_Date datetime modified date

CMH_Created_Date created date

CMH_UserName sql_variant user name

CMH_Restrict_Type nvarchar(25) CMH_Restrict_Type col is added for Rel 6

CU_CMI_Cus_Mod_Dtl This Table Trace the Customer Details Modification(Used for "View Customer Modification Information") CMI_Created_OU int NOT NULL created instance Yes

CMI_Cust_Code sql_variant customer code

CMI_From_Date datetime customer effectivity date from

CMI_Cust_Name sql_variant NULL customer name for the code given No

CMI_Address NOT NULL address of the customer

CMI_To_Date datetime NULL customer effectivity date to

CMI_Created_By sql_variant NOT NULL created user name

CMI_Created_Date datetime created date

CMI_Modified_By sql_variant NULL modified user name

CMI_Modified_Date datetime modified date

Cu_CPD_Cust_Part_Dtl This Table Saves the Customer Part Details for a Customer in a Sales Point CPD_Created_OUInstance int NOT NULL created instance Yes

CPD_Cust_Code sql_variant unique customer code

CPD_SalesLoc_OU int sales location instance

CPD_Part_No sql_variant part no

CPD_Cust_Part_No NULL customer part no No

CPD_Ship_Point shipping point (instance)

CPD_WH_Code ware house code

CPD_Created_By created user name

CPD_Created_Date datetime created date

CPD_Modified_By sql_variant modified user name

CPD_Modified_Date datetime modified date

CPD_Part_Crt_Ou int part created instance

CPD_WH_Ouinstance ware house instance

Cu_CPI_Contact_Person_Info This Table Stores the Details of Contact Person for a Customer in a Sales Point CPI_EMail_Id sql_variant email id of the customer

CPI_phone_No phone no of the customer

CPI_Fax_No fax no of the customer

CPI_Visit_Hrs visiting hours of the customer

CPI_ZipCode zipcode of the address given

CPI_Country country of the address

CPI_state state of the address mentioned

CPI_City city of address

CPI_Created_Date datetime created date

CPI_Created_By sql_variant created user name

CPI_Modified_By modified user name

CPI_Birth_Date datetime birth date of the customer

CPI_Marriage_Date marriage date of the customer

CPI_Default_Flag sql_variant default flag

CPI_Remarks remarks

CPI_Modified_Date datetime modified date

CPI_LineNo int NOT NULL Line no for multiple value reference Yes

CPI_Address_Id sql_variant address id

SLI_Created_OUInstance int created instance Yes

SLI_Cust_Code sql_variant customer code

CPI_Created_OUInstance int created instance No

CPI_SalesLoc_Ou sales location instance

CPI_Cust_Code sql_variant customer code

CPI_Address3 NULL address3 of the customer No

CPI_Address1 address1 of the customer

CPI_Department department

CPI_Address2 address2 of the customer

SLI_salesLoc_Ou int NOT NULL sales location instance Yes Yes

CMH_Created_Ouinstance created instance

CPI_Designation sql_variant NULL customer designation No No

CMH_Cust_Code NOT NULL customer code Yes Yes

CPI_Person_Name NULL customer name No No

Cu_CRD_CCer_Req_Dtl This table Stores the Part Details in a Sales Point CRD_Created_OU int NOT NULL created instance Yes

CRD_Cust_Code sql_variant customer code

CRD_PartNo part no defined for the particular customer code

CRD_Cert_Typ type of certification for the part

CRD_PartNo_OU int NULL part created instance No

CRD_Remarks sql_variant remarks

CRD_Template templates

CRD_Created_By NOT NULL created user name

CRD_Created_Date datetime created date

CRD_Modified_By sql_variant NULL modified user name

CRD_Modified_Date datetime Modified date

Cu_Cuctm_Cust_TCD_Map Added for Rel6 Changes ( For Maint. TCD) Edit Customer Tax & Charges Information - to update TCD for the Customer & corresponding delivery area and application CUCTM_OUInstance int NOT NULL current instance Yes

CUCTM_Cust_Code sql_variant customer code for which the TCD details were to be entered

CUCTM_Delarea delivery area for the customer

CUCTM_Appl_On nvarchar(5) applicable on value values can be like order level material level services

CUCTM_Seq_No int sequence no reference for multi value given for the same customer

CUCTM_Tcd_Code nvarchar(10) Tcd code from TCD Master

CUCTM_Tcd_Variant TCD Variant code from TCD Master

CUCTM_Tcd_OU int TCD Created instance

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

Cu_CuPrm_Parameter_Details This table Contains the Parameter Details(Meta Data) CuPrm_ComponentName sql_variant component name

Cuprm_ParamCategory parameter category

Cuprm_ParamType parameter type of the category mentioned

Cuprm_Paramcode param code defined for the parttype, category and component name combination

CuPrm_ParamDesc param description defined for the partcode,parttype, category and component name combination

CuPrm_Langid int language id

Cuprm_Sort_by NOT NULL sort by field for display of data in some order

CU_DSB_Def_Ship_Bill_Info This Table Saves the Default Bill/Ship to Customer details for a Sales Point DSB_Created_OUInstance created instance Yes

DSB_Cust_Code_Hdr sql_variant Unique customer code

DSB_SalesLoc_OU int sales location instance

DSB_Cust_Code_Mlt sql_variant customer code

DSB_ShipBill_Type NULL shipping bill type No

DSB_Created_By created user name

DSB_Modified_By modified user name

DSB_Modified_Date datetime Modified date

DSB_Created_Date created date

CU_PMD_Prt_Mst_Dtl This table Stores the Part Details across Sales Point PMD_Cust_Code sql_variant NOT NULL customer code Yes

PMD_Created_OU int created instance

PMD_PartNo sql_variant part no

PMD_PartNo_OU int part created instance No

PMD_Cus_PartNO sql_variant NULL customers part no

PMD_Supp_By NOT NULL supplied by

PMD_Rep_Policy Replenishment Policy

PMD_Created_By created user name

PMD_Created_Date datetime created date

PMD_Modified_By sql_variant NULL modified user name

PMD_Modified_Date datetime modified date

Cu_PPL_PartPrice_List_Dtl This Table Saves the Associated Part Price List for a Customer in a Sales Point PPL_Created_OUInstance int NOT NULL created instance Yes

PPL_Cust_Code sql_variant customer code

PPL_SalesLoc_OU int sales location instance

PPL_Seq_No sequence no for multi value identification

SLI_Created_OUInstance created instance Yes

SLI_Cust_Code sql_variant customer code

SLI_salesLoc_Ou int sales location instance

CMH_Created_Ouinstance customer created instance

CMH_Cust_Code sql_variant customer code

PPL_Price_List NULL part price list defined No No

PPL_Eff_From datetime part price list effectivity from date

PPL_Eff_To part price list effectivity to date

CU_SLD_Sts_Log_Dtl This table is used to Trace the Status Modifications done for a Customer (Used for "View Status Log") SLD_Created_OU int NOT NULL created instance Yes

SLD_Cust_Code sql_variant customer code

SLD_Changed_On datetime details changed on

SLD_Changed_by sql_variant details changed by

SLD_Ref_Status reference status No

SLD_Opr_Status NULL opr status

SLD_Comments comments

SLD_Created_By NOT NULL created user name

SLD_Created_Date datetime created date

SLD_Modified_By sql_variant NULL modified user name

SLD_Modified_Date datetime modified date

Cu_SLI_Sales_Location_Info This Table Saves the Sales Point information for a Customer. SLI_Created_OUInstance int NOT NULL created instance Yes

SLI_Cust_Code sql_variant customer code

SLI_salesLoc_Ou int sales location instance

CMH_Created_Ouinstance created instance Yes

CMH_Cust_Code sql_variant unique customer code

SLI_Opera_Status NULL Operational status values will be active and inactive No No

SLI_Deft_ShipTo_Cust default shipment to customer needed or not value will be 1 or 0

SLI_Deft_BillTo_Cust Default Bill To Information value will be 0 if not needed and 1 if needed

SLI_Auto_InvAuth_flag Automatic atuthorixatin of invoice needed or not if needed will be 1 else will be 0

SLI_Freight_Billable freight billable value yes or no

SLI_Elgble_For_Rebate elegable for rebate values will be yes or no

SLI_TaxExempt_Flag taxexempt flag will be yes or no

SLI_TaxExempt_No taxexemt no

SLI_Inv_Appl_flag invoice applicable flag value will be yes or no

SLI_No_Of_InvCopies int no of invoice copies

SLI_Ship_Point sql_variant ship point will be instance

SLI_Transport_Mode mode of transport

SLI_Prfrd_Carrier perfered carrier

SLO_Freight_Term freight term

SLI_PartShip_Allowed part ship allowed or not value will be yes or no

SLI_Tranship_Allowed Transhipment Allowed yes or no

SLI_ShipTot_Neg int Shipping Tol -Ve

SLI_ShipTot_Pos Shipping Tol +Ve

SLI_BilTo_Id sql_variant Bill To ID

SLI_ShipTo_Id Ship To ID

SLI_Order_From_Id Order From ID

SLI_Created_By created user name

SLI_Created_Date datetime created date

SLI_Modified_By sql_variant modified user name

SLI_Modified_Date datetime modified date

CU_SPD_Ser_PrLst_Dtl This Table Stores the Service Price List details for Customer in a Sales Point SPD_Created_OU int NOT NULL created instance Yes

SPD_Cust_Code sql_variant customer code

SPD_SalesLocOU int sales location instance

SPD_Ser_PrLst sql_variant service pricelist

SPD_SrPrLst_OU int service pricelist instance No

SPD_Eff_From datetime NULL service pricelist effectivity from

SPD_Eff_To service pricelist effectivity to

SPD_Created_By sql_variant NOT NULL created user name

SPD_Created_Date datetime created date

SPD_Modified_By sql_variant NULL modified user name

SPD_Modified_Date datetime modified date

CU_SPH_Ser_PrLst_Hdr This Header Table Stores the Service Price List Details for Customer in a Sales Point SPH_Created_OU int NOT NULL created instance Yes

SPH_Cust_Code sql_variant unique customer code

SPH_SalesLocOU int NULL sales location instance No

SPH_Adv_Payable sql_variant avance payable flag value will be yes or no

SPH_Adv_Tolerance bigint Advance Tolerance %

SPH_Adv_Percent int Advance Percent

SPH_Adv_PercentON sql_variant Advance Percent On

SPH_Act_Non_Pay Action on Non Payment values will be prevent work order planning Prevent resource assignment Prevent WO reporting

SPH_Created_By NOT NULL created user name

SPH_Created_Date datetime created date

SPH_Modified_By sql_variant NULL modified user name

SPH_Modified_Date datetime modified date

CU_TMD_Task_Mstr_Dtl This Table Stores the Customer Task Master List across Sales Point TMD_Created_OU int NOT NULL created instance Yes

TMD_Cust_Code sql_variant unique customer code

TMD_Task_No varchar() task no

TMD_Mnt_Obj varchar(40) maintenance object

TMD_Cust_OU int customer instance No

TMD_Task_Desc sql_variant NULL task description

TMD_Applicability varchar(5) NOT NULL applicability

TMD_WU_Typ sql_variant work unit type

TMD_WU_Code varchar(30) work unit code

TMD_WU_OU int work unit instance

TMD_Remarks sql_variant NULL remarks

TMD_FileName file name

TMD_Created_By NOT NULL created user name

TMD_Created_Date datetime created date

TMD_Modified_By sql_variant NULL modified user name

TMD_Modified_Date datetime modified date

TMD_BaseModel_OU int -- Added for Rel 6 Changes (For Edit Customer Task Master List)

TMD_BaseModel_No nvarchar(20) Added for Rel 6 Changes (For Edit Customer Task Master List)