Skip to main content

Featured

Constraints

NOT NULL CONSTRAINT -    Ensures that a column cannot have a null value. DEFAULT CONSTRAINT -    Provides a default value for a column when none is specified  UNIQUE CONSTRAINT -   Ensures that all values in columns are different  CHECK CONSTRAINT -   Makes sure that all values in a column satisfy certain criteria  PRIMARY KEY CONSTRAINT -   Used to uniquely identify a row in the table  FOREIGN KEY CONSTRAINT -   Used to ensure referential integrity of the data  Primary Key - is used uniquely to identify each row in a table . It can consist of one or more columns on a table . When Multiple columns are used on a table it is called composite key.  Foreign Key - Foreign key is a column or columns that references a column most often primary key of another table . The purpose of foreign key is to maintain referential integrity of the data. Pg admin  Data base - training - right click on training - ...
Post a Comment
Read more
Labels

Leasing

Leasing -  it is a contract Owner gives right to use the asset and the time period is in the contract 

What is accounting standard ? 

So if you see the balance sheet of the company, there are different justification to add the item in balance sheet , Accounting standard 19 is governed to know how to value asset.

Lessor - owner of asset 

Lessee - user of the asset 

Owners give the right to use the asset.

2 types broad - Finance and Operating lease 

I have asset of life 10 years and out of 10 years i give this asset for lease for 8 years so A leasor B is Leasee . B is almost using the asset . 

Finance  Lease- it is the lease where the lessor transfers substantially all the risks and rewards of ownership of assets to the lessee for lease rentals .

Operating lease - is opposite to finance where risks and rewards incidental to the owner and are not transferred by lessor to the lessee. For example - Life is 10 years and life is 2 years for lessee.

Based on life of asset determine substantial or not .



Labels:

Comments

Post a Comment

Popular Posts