Hi All,

anyone can explain me about precision n scale properties.
while extending one column in a table we will cum under
these properties.

Thanks n advance.



Hi All, anyone can explain me about precision n scale properties. while extending one column in..

Answer / neha

Scale is the total no of digits that can come for a
particular numeric field to the right and left of the
decimal point.
Precision is the number of digits to the right of decimal point.
Eg. for numeric field the scale is 6 and precision is 2.
Then it can accomodate:

9999.99 and 99999.9 are valid but 999.999 is invalid and
will give Data Type not found/mismatch error.

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More Siebel Interview Questions

This is krishna, I created new Table,Bc,Link,Bo,view,screen TABLE : CX_ECB_S_TAT BC : ECB TAT BC Link : ECB TAT BC/Service Request Bo : ECB TAT BO View : ECB TAT View Screen : ECB TAT Screen and I created new "X_ECB_TAT_ID" Column for foregin key relation ship in "S_SRV_REQ" Table [in colum properties I specified Forieignkey Table-CX_ECB_S_TAT] and I created "TAT Id Ext" Field with "X_ECB_TAT_ID" Column in "Service Request" BC. I created Link"ECB TAT BC/Service Request". in this link I specified "Destination Field-TAT Id EXT".( Parent BC : ECB TAT BC, Child BC : Service Request) --------------------------------------------------- There is two Screens 1)ECB TAT Screen 2)Service Request Screen in First Screen : ECB TAT Screen Parent BC : ECB TAT BC Fields : Type,Area,Sub Area,TAT I given the field values to Type,Area,Sub Area and based on field values I given "TAT" field value. now we will go to Second Screen : Service Request Screen Child BC : Service Request Fields : INS Product,INS Area,INS Sub-Area,TAT I given same values(Parent bc Field Values) to INS Product,INS Area,INS Sub-Area then should be update "TAT" Field value (I mean Parent BC same "TAT" Field vaue should be update in "TAT" Field in Child BC) I wrote script for above requirement in "SetFieldValue" Event in "ECB TAT BC" function BusComp_PreSetFieldValue (FieldName, FieldValue) { if(FieldName == "TAT") { var Bo = TheApplication().GetBusObject("ECB TAT BO"); var Bc = Bo.GetBusComp("Service Request"); this.ActivateField("Type"); this.ActivateField("Area"); this.ActivateField("Sub Area"); this.ActivateField("TAT"); var sType = this.GetFieldValue("Type"); var sArea = this.GetFieldValue("Area"); var sSubArea = this.GetFieldValue("Sub Area"); var sTAT = FieldValue; //this.GetFieldValue("TAT"); var Bc1 = Bo.GetBusComp("Service Request") with(Bc1) { var exp = "[INS Product] = '" + sType + "' AND [INS Area] = '" + sArea + "' AND [INS Sub-Area] = '" + sSubArea + "'"; ActivateField("INS Product"); ActivateField("INS Area"); ActivateField("INS Sub-Area"); ClearToQuery(); SetViewMode(AllView); SetSearchExpr(exp); ExecuteQuery(ForwardOnly); var cnt = CountRecords(); ActivateField("TAT"); var fst = FirstRecord(); while(fst) { SetFieldValue("TAT",sTAT); fst = NextRecord(); } } } return(ContinueOperation); } but in "Service Request" BC "TAT" field value updating existing records,not updating creating new necords. I should update "TAT" field value to creating new records. where I have to write script in which event in which BC for this. please post detail script for this. from last 15 days i'm working on this. please help me on this. thank you so much in advance.

2 Answers   Ecobank,


Explain how would you send an email using siebel realtime application?

0 Answers  


What is difference between join specification and join definition?

0 Answers  


Explain where did you use wf in your last project?

0 Answers  


i want interview question on siebel testing.very urgent

0 Answers   IBM,


What are the steps for using a standard 1:1 extension table?

0 Answers  


What exactly use of s_party concept in siebel?

0 Answers  


Define nameserver and the uses of it?

2 Answers   Cap Gemini, Siebel Systems,


What is position type field in position applet?

4 Answers  


What are the different Entities available in Siebel?

2 Answers   Cap Gemini,


What is the "parent category" property for a screen view?

0 Answers  


what is difference between bounded and unbounded picklist?

6 Answers   IBM,


Categories