Story Behind your date of Birth

This  z  99%   true !! how abt u?? 

I never believed in this sort of stuff but when i read it i found some of the points are true :)         ------------ --------- --------- ---------   Story Behind Your Date Of Birth ->   STORY BEHIND YOUR DATE OF BIRTH   If U were born on the 1st, 10th, 19th, 28th of any month U r number 1...   If U were born on the 2nd, 11th, 20th, 29th of any month then U r number 2...   If U were born on the 3rd, 12th, 21st, 30th of any month then U r number 3...   If U were born on the 4th, 13th, 22nd, 31st of any month then U r number 4....   If U were born on the 5th, 14th, 23rd of any month then U r number 5..   If U were born on the 6th, 15th, 24th of any month then U r number 6..   If U were born on the 7th, 16th, 25th of any month then U r number 7..   If U were born on the 8th,17th,26th of any month then U r number 8...   If U were born on the 9th,18th,27th of any month then U r number 9...   Number 1   You are smart, straight talking, funny, stubborn, hardworking, honest, Jealous on competing basis, kind hearted, angry, friendly, authorities, Famous person...always want to be and regarded as first on people Position, they are often like to be independent, will never be under Others, self confident people!   You are most likely to fall in love in the younger age, but will get Marry when you mature! You are likely to have problems with people who have opposite views And you are most likely to take revenge over your Enemies in a long time basis. You are a spender, but you will have a good profession in the future. If you are guy you will be very popular that everybody will have mental attraction and respect at you. You can go anywhere from the local shop to the heart of the parliament because you are positive and Well talented in numerous issues!! But in your life you will always have some people who will work hard To bring you & your name down. This is undercover!! Coz of your smart behavior you will be hated by some People too...   Your family life is very cool, you will have a very nice partner & Wonderful children... You are pioneer, independent & original...   Your best match is 4,6,8 good match is 3,5,7 !!!   Number 2   No matter what, you will be loved by every one coz your ruler is the Moon and every one loves the Moon. Well... You are a person who day dream a lot, You have very low-self confidence, you need back up for every move in your life, you Are very much unpredictable. Means you do change according to time and circumstances, Kind a selfish, have a very strong sense of musical, artistic talent, verbal communication. Your attitudes are like the Moon, comes to gloom and fade away so everybody can expect Changes in you. You can be a next Mahatma Gandhi who does peace love or you can be a Hitler who wants to destroy the man kind and peace (I mean in the community and your own home).   If you really have a deep thought about your own believe in God you can Feel the difference which will make you stronger! Most of the time your Words are a kind of would be happening true! So without any knowledge You can predict the situation. You will become poets, writers, any Artistic business people!   You are not strong in love, so you will be there and here till you get Marry.. If U r a girl you will be a responsible woman in the whole Family. If U r a man you will involve in fights & arguments in the family or Vice-versa. Means you will sacrifice your life for the goodness sake of Your family...You are gentle , intuitive with a broad vision, a power Behind the scenes, well balanced People!!!   Your best match is 2 ,5 ,9 no other people can put up with you !!!   Number 3   You are a person of hard hearted, selfish most of the times, religious, Loves to climb up in your life. You always tend to have lots of problems Within your family in the early stages but you will put up with everything.. You have the strong word power, pretty happy face.. So wherever you go always You have got what you wanted!!! And from the birth always wanted to work hard in order To achieve something.. You will not get Anything without hard work! When you reach a man/ woman age you want other younger Once to listen to you because you want younger people to respect people older than them. You do set so many examples to others. Generally you are not a cool person. It's not easy thing dealing with you. A tough player you are! But once you like someone's attitude! e then here you go, what can I say? It will be a lasting friendship. You always have respect from others. Your life seems to have lots of worries and problems but sure they won't be long.. You will always have brilliant kids!!! You love the money a bit too much so temptation will push you to endless trying and trying.. If you are a guy then it's over. Looking after your family and help friends, so you will spend a life time just being generous and kind (except 21st born men). And number 3s you will be such an example of how to be in the culture & life!!! If you are girl then you have good character and culture & hardworking attitude. You always follow. You are a freedom lover, creative, ambition focused, a person who brings beauty , hope & joy to this world!!!   Your best match 6 ,9. Good match 1 ,3 ,5 !!!   Number 4   You are very stubborn too, very hard working but unlucky in important matters in life, very cool, helpful, you have rough word power.. Might put lots of people away from you, you may cause nuisance to others if you are a man, and you often understands others and their problems well. If you are a girl you are very good with studies and arts. If you are a guy you spend most of the time after girl friends (almost) at times, you will have sort of too much fun life with mates & girls. Your friends will spend your time & money and get away with their life and you will become empty handed and don't know what to do... So be careful!! You love to spend anyway!!! Your good will is you are always there to help family and friends. Tell you what you people are little gem! s, specially the girls.. You always fall in love in younger age as well. You often live with disappointments, for an example you have got a degree in some thing... but you will be unemployed.. or will do very ordinary jobs. But you will take care of your family very well...All you need to be careful of people who will take advantage of your kind heart. And beware of your relations too.. You are radical, patient, persistent, a bit old-fashioned, you live with foundation & order...   Your best Match 1, 8. Good match 5 ,6 , 7 !!!   Number 5   You are very popular within the community, you can get things done by just chatting..to even enemies! You have a pretty good business mind, you are often have no-idea what is today is like, or tomorrow is like, you are a person who does anything when your head thinks "lets do this". You will be famous if you open up a business, get involve in share dealings, music etc.. Very popular with sense of humor ,you are the one your friends and families will always ask for help, and you are the one actually get money on credit and help your friends. You will have more than 1 relationship, but when u get settle down you will be a bit selfish anyway. Coz your other half will have a pretty good amount of control in you, be careful! You tend to go for other relationships! Contacts even you are married at times 'coz your popularity.. . You are someone who get along with anyone coz the number 5 is the middle number.. Changes & freedom lovers you are! You are an explorer with magic on your face. You learn your life through experience and it's your best teacher!!!   Your best match 1 ,2 ,9. Good match 6 ,8 !!!   Number 6   Ooopppss..you are born to enjoy.. You don't care about others. I mean you are always want to enjoy your life time, you are a person.. You will be very good in either education or work wise or business management! You are talented, kind (but with only people who you think are nice), very beautiful girls and guys, popular and more than lucky with anything in your lives. All the goodness does come with you. Your mind and body is just made perfect for love. You are lovable by any other numbers. But if you are a number 6 man, you will experience kind of looks from most girls and will involve in more than few relationships until you get married. If you are girl, most of you will get marry/engaged early. You are ! a caring person towards your family & friends . If you miss the half-way mark then you are about to suffer physically and mentally. Generally you will lead a very good inner-home happiness with nothing short of. You are a person of compassion, comfort & fairness, domestic responsibility, good judgment, and after all you can heal this world wounds to make peace for every life coz you have the great power of caring talent to make this world of love one step further...   Your best match 1, 6, 9. Good match 4, 5!!!   Number 7   You have got the attraction to anyone out there, you are realistic, very confident, happy, such a talented individual with your education, music, arts, singing, and most importantly acting too. You have real problems with bad temper! If you are a girl, you are popular with the subjects listed above. You give up things for your parents. I mean you value your family status a lot, you will be in the top rank when you reach a certain age. If you are a guy you are popular with girls, you are a very talented too. Most of the number 7s face lots of problems with their marriage life. Only a very few are happy.. You have everything in your life, but still always number 7s have some sort of unfullfilness, such worries all their lifetime. It's probably the Lord given you al! l sort of over the standard humans talents and you are about to suffer in family life. So you need to get ready looking for a partner rather than waiting. If you don't, then you might end-up single. So take care with this issue, ok? You are wonderful, friendly, artistic, happy person.. You are born to contribute lots to this world!!!   Your best match is 2. Good matches are 1,4 !!!   Number 8   You are a very strong personality, there's no one out there will understand you. You are very good at pointing your finger at some thing and say "this is what". You are more likely to suffer from the early ages. I mean poverty. If your times are not good you might lose either of your parent and end up looking after your entire family. You often suffer all the way in life. The problems will not allow you to study further, but you will learn the life in a very practical way. You are the one who will fight for justice and may die in the war too. You are normally very reserved with handful of friends and most of the time live life lonely and always prepared to help others. Well. once you get married (which is often late) then your bad lucks will go away a bit and you! u become safe. You will face un-expected problems such as : the error, government, poisonous animals, accidents. You are some one with great discipline, persistence, courage, strength which will take you to success. You are a great part of a family team. You are a fighter!   Your Best match 1 ,4, 8. Good match 5 !!!   Number 9   Hey...you guys are the incompatibles people in the world. You are so strong, physically and mentally... You are often have big-aims. You will work hard and hard to get there. Normally you suffer in the early age from family problems and generally you will have fighting life.. But when you achieve what you have done, it's always a big task you have done! You are so much respected in the community, you are a person who can make a challenge and successfully finish the matter off. You are very naughty in your younger age, often beaten up by your parents and involve in fights and you seemed to have lots of injuries in your life time. But when u grow you become calm and macho type. Love is not an easy matter for you. You are good in engineering or banking jobs coz people always trust you. Your family life is very good, but will have worries over your children. Your such qualities are humanitarian, patient, very wise & compassionate. You are born to achieve targets and serve every one all equally without any prejudice. You are totally a role model to anybody in the world for a great inspiration.   Your Best match 3, 5, 6, 9. Good match 2 GOOD LUCK!

  

Cloud Computing

Oracle Financials / E Business Suite

Oracle General Ledger

Gl_code_combinations
##Setup > Accounts > Combinations

 This table stores the valid account combinations.
The value in the chart of account segments are stored in the columns segment1 to segment30 depending on application configuration.
For example, say your chart of accounts is
Company – Cost Centre – Account
then segment1 = company, segment 2 = cost centre and segment3 = account.

Another important column is the account_type which signifies the account is an Asset, Liability, Revenue, Expense or Owners Equity account.


Gl_je_batches
##Journals > Enter
This table stores the journal entry batches. Journal entries are batched in General Ledger.
Some columns of interest includes :
• Name
• Set_of_books_id (when we have more than one set of book, we’ll also need to link to gl_sets_of_books)
• Status
• Default_period_name
• Posted_date
• Posting_run_id

Gl_je_headers
##Journals > Enter
This table stores the journal entry headers. There is always two journal lines for each journal header.
Some columns of interest includes :
• Je_category
• Period_name
• Set_of_books_id (when we have more than one set of book, we’ll also need to link to gl_sets_of_books)
• Posted_flag
• Je_source
• Name
• Status

Gl_je_lines
##Journals > Enter
This table stores the journal entry lines.
The entered_dr and entered_cr stores the amount in the entered currency whereas the accounted_dr and accounted_cr stores the amount in the functional currency.
Other columns of interest includes :
• Set_of_books_id (when we have more than one set of book, we’ll also need to link to gl_sets_of_books)
• Period_name
• Status
• Description
• Reference_1..reference10 (these columns links back to the Subledgers)
For example, for Purchasing transactions
Reference_1 = ‘PO’
Reference_2 = po_headers_all.po_header_id
Reference_3 = po_distributions_all.po_distribution_id
Reference_4 = po_headers_all.segment? (this is the purchase order number)

Oracle Payables

Ap_invoices_all
##Invoices > Entry > Invoices
This table stores all the invoices entered in. For an invoice to be approved, the total invoice amount must be stored in ap_invoice_distributions_all and ap_payment_schedules_all.
Some columns of interest includes :
• Invoice_num
• Invoice_date
• Amount_paid
• Invoice_currency_code
• Invoice_type_lookup_code
• Payment_status_flag

Ap_invoice_distributions_all
##Invoices > Entry > Invoices
This table stores the accounting information for the invoice what have entered. There is one row for each invoice disribution, that is this table corresponds to the Distributions window.
Some columns of interest includes :
• Line_type_lookup_code
• Dist_code_combination_id (credit entry)
• Accts_pay_code_combination_id (debit_entry)
• Base_amount (in functional currency)

Ap_checks_all
##Payments > Entry > Payments
This table stores payments to suppliers.
Some columns of interest includes :
• Amount (in functional currency)
• Check_date
• Bank_account_name
• Check_number
• Payment_method_lookup_code
• Payment_type_flag

Ap_invoice_payments_all
##Payments > Entry > Payments
This table stores invoice payments to suppliers. This table is updated when we confirm an automatic payment batch, enter a manual payment or process a Quick Payment. Void payments are represented as a negative of the original payment line.
Some columns of interest includes :
• Accounting_date
• Period_name
• Amount
• Payment_num

Ap_payment_distributions_all
##Payments > Entry > Payments
This table stores accounting information for payments. There is at least one CASH payment distribution for each invoice payment. Additional rows may include DISCOUNT, GAIN and LOSS distributions where appropriate.
Some columns of interest includes :
• Line_type_lookup_code (CASH/DISCOUNT/GAIN/LOSS)
• Base_amount

Oracle Purchasing

Po_vendors
##Supply Base > Suppliers
This table stores supplier information.
Some columns of interest includes :
• Segment1 (supplier number)
• Vendor_name
• Terms_id
• Vendor_type
• Ship_to_location (link to hr_locations for location information)
• Bill_to_location (link to hr_locations for location information)

Po_vendor_sites_all
##Supply Base > Suppliers
This table stores supplier sites information.
Some columns of interest includes :
• Pay_site_flag
• Purchasing_site_flag
• Address_line1 to address_line3
• City
• State
• Area_code
• Zip

Po_headers_all
##Purchase Orders > Purchase Orders
This table stores the seven types of purchasing documents such as Purchase Order and Blanket Agreement.
Segment1 is the document number (i.e. purchase order number)
Some columns of interest includes :
• Agent_id (link to per_people_f for the buyer)
• Type_lookup_code

Po_lines_all
##Purchase Orders > Purchase Orders
This table stores purchasing document lines.
Some columns of interest includes :
• Line_num
• Item_description
• Unit_price
• Unit_meas_lookup_code (unit of measure)
• Quantity
• Item_id (link to mtl_system_items for the item number)
• Category_id (link to mtl_categories for the category name)

Po_line_locations_all
##Purchase Orders > Purchase Orders
This table stores purchase order shipment schedules and blanket agreement price breaks. A purchase order is closed when QUANTITY is equal to QUANTITY_RECEIVED.
Some columns of interest includes :
• Quantity
• Quantity_accepted
• Quantity_received
• Quantity_cancelled
• Need_by_date
• Ship_to_organization_id (link to org_organization_definitions for the organization code)

Po_distributions_all
##Purchase Orders > Purchase Orders
This table stores the accounting information on a purchase order shipment. This table is used for Standard and Planned Purchase Orders and Planned and Blanket Purchase Order Release.
Some columns of interest includes :
• Quantity_ordered
• Quantity_billed
• Amount_billed
• Quantity_delivered
• Quantity_cancelled
• Destination_organization_id (link to org_organization_definitions for the organization code)
• Destination_subinventory

Rcv_shipment_headers
##Receiving > Receipts
This table stores the receiving information. The three receipt sources are Supplier, Inventory and Internal Order. There is one receipt header per receipt source.
Some columns of interest includes :
• Receipt_num
• Shipment_num
• Receipt_source_code
• Shipped_date
• Ship_to_org_id

Rcv_shipment_lines
##Receiving > Receipts
This table stores information about items that have been shipped and/or received from a receipt source.
Some columns of interest includes :
• Line_num
• Quantity_shipped
• Unit_of_measure
• Item_id (link to mtl_system_items for item number)
• To_organization_id (link to org_organization_definitions for organization code)
• To_subinventory
• Shipment_line_status_code (EXPECTED, FULLY RECEIVED, PARTIALLY RECEIVED)
• Quantity_received
• Quantity_shipped

Oracle Inventory

Org_organization_definitions
##Setup > Organizations > Parameters
This view contains basic information on all inventory organisations.
Some columns of interest includes :
• Organization_code
• Organization_name
• Set_of_books_id (when we have more than one set of book, we’ll also need to link to gl_sets_of_books)
• Inventory_enabled_flag

Mtl_secondary_inventories
##Setup > Organizations > Subinventories
This table stores all subinventory information for an inventory organisation.
Some columns of interest includes :
• Secondary_inventory_name
• Description

Mtl_material_transactions
##Transactions > Material Transactions (Inquiry)
This table stores all inventory transactions including cost updates.
Some columns of interest includes :
• Transaction_quantity
• Transaction_type_id
• Transaction_source_type_id
• Transaction_source_name

Mtl_transaction_accounts
##Transactions > Material Distributions (Inquiry)
This table stores the inventory accounting information. There are two rows in this table for each transaction in mtl_material_transactions.
Some columns of interest includes :
• Transaction_date
• Gl_batch_id
• Accounting_line_type
• Base_transaction_value

Mtl_system_items
##Items > Master Items or Items > Organization Items
This table stores the item definition. An item must exist in an inventory organisation.
item number is stored in the columns segment1 to segment20 depending on the application configuration. If the application have configured the items to have to segments then we may be using segment1 and segment2
Some columns of interest includes :
• Segment1 to segment20
• Description
• Invetory_item_flag
• Purchasing_item_flag
• Inventory_asset_flag
• Stock_enabled_flag
• Invoiceable_item_flag
• Shippable_item_flag
• So_transaction_flag
• Mtl_transactions_enabled_flag
• Primary_unit_of_measure

Mtl_onhand_quantities
##On-hand, Availability > On-hand Quantities
This table stores quantity on hand in a location for each item.
Some columns of interest includes :
• Date_received
• Transaction_quantity
• Subinventory_code

Cst_item_costs
##Costs > Item Costs
This table stores the item cost information. Note that there can be multiple costs per item and the actual cost is where the cost type is Frozen.
Some columns of interest includes :
• Cost_type_id (link to cst_cost_types)
• Item_cost

Oracle Receivables

Ra_customers
##Customers > Standard
This table stores customer information.
Some columns of interest includes :
• Customer_name
• Customer_number
• Status
• Customer_prospect_code
• Customer_type
• Orig_system_reference (for imported customers from an external source)

Ra_addresses_all
Customers > Standard
This table stores customer address information and what remit-to addresses.
Some columns of interest includes :
• Status
• Orig_system_reference (for imported customer addresses from an external source)
• Address1 to address4
• City
• State
• Postal_code

Ra_site_uses_all
##Customers > Standard
This table stores the customer’s site and site purpose. we must have one row for each address. A customer must have one bill to address for Receivables. A customer must have one ship to address and one bill to address for Order Entry.
Some columns of interest includes :
• Site_use_code (BILL_TO, SHIP_TO, STMTS, DUN/LEGAL)
• Primary_flag
• Status
• Location

Ra_customer_trx_all
##Transactions > Transactions
This table stores invoice, debit memo, chargeback, commitment and credit memo header information.
Some columns of interest includes :
• Cust_trx_type_id (link to ra_cust_trx_types_all)
• Set_of_books_id (when we have more than one set of book, we’ll also need to link to gl_sets_of_books)
• Terms_id (link to ra_terms)
• Trx_number (invoice number)
• Trx_date (invoice date)

Ra_customer_trx_lines_all
##Transactions > Transactions
This table stores the invoice, debit memo, chargeback, commitment and credit memo line information.
Some columns of interest includes :
• Line_number
• Description
• Quantity_ordered
• Quantity_credited
• Quantity_invoiced
• Unit_standard_price
• Unit_selling_price
• Line_type
• Extended_amount
• Revenue_amount

Ra_cust_trx_line_gl_dist_all
##Transactions > Transactions
This table stores the accounting information for revenue, unearned revenue, unbilled receivables, receivables, charges, freight and tax for each invoice or credit memo line.
Some columns of interest includes :
• Amount_gl_date
• Gl_posted_date
• Account_class (CHARGES/FREIGHT/TAX/REC/REV/UNBILL/UNEARN)
• Acctd_amount (functional currency)

Ar_cash_receipts
##Receipts > Receipts
This table stores the payment information.
Some columns of interest includes :
• Set_of_books_id (when we have more than one set of book, we’ll also need to link to gl_sets_of_books)
• Status (APP, UNAPP, UNID, NSF, STOP, REV)
• Type (CASH, MISC)
• Receipt_number
• Amount
• Currency_code
• Pay_from_customer
• Receipt_date

Ar_receivable_applications
##Receipts > Receipts
This table stores accounting entries for cash and credit memo applications.
Some columns of interest includes :
• Amount_applied
• Line_applied
• Tax_applied
• Application_type
• Display
• Gl_date
• Set_of_books_id (when we have more than one set of book, we’ll also need to link to gl_sets_of_books)

Ar_payment_schedules
##Transactions > Transactions and Receipts > Receipts
This table stores all transactions except adjustments and miscellaneous cash receipts. This table is updated when a transaction occurs against an invoice, debit memo, chargeback, credit memo, on-account credit, or receipt.
Some columns of interest includes :
• Amount_due_original
• Status
• Class (DEP, DM, PMT, GUAR, CM, CB, INV)
• Due_date
• Amount_due_remaining
• Invoice_currency_code
• Amount_applied
• Anmount_credited
• Amount_adjusted

Road Map

Month End

How to get the IP address in SQL

select client_net_address, session_id from sys.dm_exec_connections where net_transport = 'TCP

This may search only for the "TCP" but there were "namepipe" as well which may unknown to me..

http://www.sqlservercentral.com/Forums/Topic1010535-391-1.aspx#bm1010543


To get the database ID

SELECT SUBSTRING(db.name,1,30) AS Database_Name,
db.database_id AS Database_ID
FROM sys.databases db
ORDER BY Database_ID;
go

What does a Business Analyst Do…..

The qualified business analyst wears many hats. He or she is a negotiator, a skilled listener, a motivational speaker, and a team leader. His or her title may include that of systems analyst, requirements analyst, or project manager. The business analyst may or may not have a degree in business analysis. He or she may not be able to write code. However, the business analyst is educated in the process necessary to produce the code. He or she may even come from an IT department. But what is it they do?

The business analyst is someone capable of troubleshooting.. He or she will be able examine data and other information gathered to determine losses experienced by the company. The business analyst will be able to compare previous facts and figures to current numbers to deduce or predict where failure may occur. He or she will be able to examine information gathered by stakeholders to assess risks of certain project programs.

The business analyst is an objective listener. He or she will be able to speak to stakeholders and hear the needs determined by the management. The business analyst will be able to ask questions which could lead to certain discoveries once overlooked. The qualified business analyst gain knowledge of a situation by listening to team leaders and end users. He or she will hear the underlying message of what is being developed versus what is needed.

The business analyst is a negotiator. He or she will be able to involve themselves with departments and teams to allow the teams to work together. The business analyst will realize conflicts among departments. He or she will work side by side with each team to negotiate a compromise so the project is not jeopardized. The business analyst will motivate the teams to recognize their strength and weakness and allow them to excel and overcome. He or she will develop a rapport with department heads and stakeholders to rally the teams into completing the tasks at hand.

The business analyst may be asked to centralize services for more efficient work environments. He or she may be asked to reduce duplication processes occurring between departments. The qualified business analyst may be asked to develop relations with external sources when necessary to deliver services needed for project completion. The duties of the business analyst are never ending. He or she is a useful asset to the company.

The business analyst is a visionary. He or she usually thinks outside the box. Always in the know about latest technological advances, the business analyst will know when a program is capable of being utilized by the company. He or she will know how to determine a need when the situation arises. This way the business is not left behind and can keep up with corporate peers.

Sometimes the business analyst is forgotten amongst the bustle of corporate strategy. However the business analyst will be the always be the innovative link between each and every department and stage of development in the project program.

Author: Tony de Bree

Abstraction

http://www.modernanalyst.com/Resources/Articles/tabid/115/articleType/ArticleView/articleId/196/What-Does-a-Business-Analyst-Do.aspx