Column nameData type

Client id (PK)Numeric(18,0)

Client nameVarchar(50)

Client addressVarchar(250)

TelephoneVarchar(50)

Contact personVarchar(50)

EmailVarchar(50)

Mobile numberVarchar(50)

TIN numberVarchar(50)

CST numberVarchar(50)

1. Table name: Client Detail

2. Table Name : Vendor

Column nameData type

Vendor_no (PK)Numeric(18,0)

Vendor_nameVarchar(50)

Vendor_addressVarchar(50)

TelephoneVarchar(50)

Con_personVarchar(50)

EmailVarchar(50)

Mob_niumberVarchar(50)

Tin_numberVarchar(50)

Cst_numberVarchar(50)

3. Table name: Rawmaterial

Column nameData type

Mat_code (PK)Numeric(18,0)

Mat_nameVarchar(50)

WeightVarchar(50)

Unit_pricemoney

CategoryVarchar(50)

Stock_handNumeric(18,0)

Vendor_id (FK)Numeric(18,0)

4. Table name: Subcontractor

Column nameData type

Sub_id (PK)Numeric(18,0)

Sub-_nameVarchar(50)

Sub_addressVarchar(50)

TephoneVarchar(50)

Con_personVarchar(50)

EmailVarchar(50)

Mob_numberVarchar(50)

Tin_numberVarchar(50)

Cst_numberVarchar(50)

Job_processVarchar(50)

5. Table name:customer order

Column nameData type

Order number (PK)Numeric(18,0)

Order dateVarchar(50)

Client code (FK)Numeric(18,0)

Raw code (FK)Numeric(18,0)

Items oresderNumeric(18,0)

Lead dateVarchar(50)

6. Table name:purchase order

Column nameData type

Po number (PK)Numeric(18,0)

Po dateVarchar(50)

Raw code (FK)Numeric(18,0)

Vender code(FK) Numeric(18,0)

No item_orderNumeric(18,0)

Rate_itemmony

_total_pur_valuemoney

Tax_perfloat

Tax_typeVarchar(50)

Tax_amountmoney

Net_amountmoney

7. Table name:work order

Column nameData type

Wo_no (PK)Numeric(18,0)

Wo_dateVarchar(50)

Sub_code (FK)Numeric(18,0)

Raw_code (FK)Numeric(18,0)

ProcessVarchar(50)

Inward_dateVarchar(50)

Ratew_itemMoney

No_qty_delNumeric(18,0)

Total_process_valuemoney

Outward_darVarchar(50)

No_qty_recdNumeric(18,0)

No_qty_damageNumeric(18,0)

Wastage_valueMoney

Additional_chargeMoney

Total_amount_billedmoney

8. Table name: Customer bill

Column nameData type

Bill number (PK)Numeric(18,0)

Bill dateVarchar(50)

Client code (FK)Numeric(18,0)

Order umberNumeric(18,0)

Raw code (FK)Numeric(18,0)

Rate itemmoney

Total item Numeric(18,0)

Total amountmoney

Tax perfloat

Tax amountmoney

Tax typeVarchar(50)

Net amountmouny