professortaya.blogg.se - Tutorial of workdone

#TUTORIAL OF WORKDONE VERIFICATION#
#TUTORIAL OF WORKDONE CODE#

To specify item as per national and international standards.To fix essential parameters for specifying an item.To establish a common language for the identification of an item.To reveal excessive variety and promote standardization and variety reduction.

#TUTORIAL OF WORKDONE CODE#

To give a unique code number to each item to avoid duplication and ambiguity.

To classify an item according to its characteristics.

To enable putting up of any future item in its proper place.

The objectives of a rationalized material coding system are: Each digit must be significant enough to represent some characteristic of the item. The groupings should be logical, holding similar parts near to one another. Codification should be compact, concise, consistent and flexible enough to accommodate new items. It should be simple and capable of being understood by all. Whatever may be the basis, each code should uniquely represent one item. constitute further three digits and the last digit is reserved for minor variations. Dimensional characteristics of length, width, head diameter etc. The next two digits indicate the sub-groups, such as, ferrous, non-ferrous etc. The first two digits represents the major groups, such as raw materials, spare parts, sub-contracted items, hardware items, packing material, tools, oil, stationery etc. Many organizations in the public and private sectors, railways have their own system of codification, varying from eight to thirteen digits. Codification is a process of representing each item by a number, the digit of which indicates the group, the sub-group, the type and the dimension of the item. It is one of the functions of stores management.

#TUTORIAL OF WORKDONE VERIFICATION#

To assist in verification and provide supporting information for effective purchase action.To ensure good house keeping so that material handling, material preservation, stocking, receipt and issue can be done adequately.To highlight stock accumulation, discrepancies and abnormal consumption and effect control measures.To minimize obsolescence, surplus and scrap through proper codification, preservation and handling.To meet the demands of the consuming departments by proper issues and account for the consumption.To provide adequate and proper storage and preservation to the various items.To receive raw materials, components, tools, equipment’s and other items and account for them.The functions of stores can be classified as follows: Further, stores are often equated directly with money, as money is locked up in the stores.

The most important purpose served by the stores is to provide uninterrupted service to the manufacturing divisions. It is in direct touch with the user departments in its day-to-day activities. Oracle DBA, SQL Server DBA, APPS DBA, Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için a mail atabilirsiniz.The Objectives of Stores management play a vital role in the operations of company. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA, Exadata, Goldengate, EBS Consultancy and Training you can send my email adress. I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc.

SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,ĭo you want to learn Oracle Database for Beginners, then read the following articles.

You can monitor Datapump Export ,Import and other long operations with following script. ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE" SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, You can see and monitor RMAN Backup progress with following script. If you start long operations such as RMAN Backup and Datapump Export in Oracle database, probably you want to see progress of these operations. If you have big database about more than 1 TB, then your backup and export operations are taking long times.