Designing Sale Return Form using Oracle Developer 6i (Urdu/Hindi)

In this video, we will build sale return form form form using Oracle Developer 6i (Urdu/Hindi).
Tables for POS System
Create table USERS
(
userid NUMBER not null,
username VARCHAR2(30) not null,
password VARCHAR2(30) not null,

)

alter table USERS
add constraint USERS_PK primary key (USERID)

alter table USERS
add constraint UQ_NAME unique (USERNAME)
----------------------------------------------------------

create table MAIN_ITEM
(
mitem_id VARCHAR2(10) not null,
mitem_desc VARCHAR2(75),

)

alter table MAIN_ITEM
add primary key (MITEM_ID )

alter table MAIN_ITEM
add constraint UQ_DESC_MAIN_ITEM unique (mitem_desc)

----------------------------------------------------------------------------------

create table ITEM
(
mitem_id VARCHAR2(10),
item_code VARCHAR2(30),
item_desc VARCHAR2(100),
uom VARCHAR2(10),
rate NUMBER(10,2),
st_amount NUMBER(10,2),
min_level NUMBER,
max_level NUMBER,

item_id NUMBER not null
)

alter table ITEM
add constraint PK_ITEM_ID primary key (item_id)

alter table ITEM
add constraint UK_ITEM_CODE unique (ITEM_CODE)

alter table ITEM
add constraint MITEM_ID_FK foreign key (MITEM_ID)
references MAIN_ITEM (MITEM_ID)
-----------------------------------------------------------------------------------------

create table PARTY
(
party_id NUMBER(10,2) not null,
party_name VARCHAR2(75),
address VARCHAR2(300),
phone VARCHAR2(20),
party_type VARCHAR2(1),


)

alter table PARTY
add primary key (PARTY_ID)
--------------------------------------------------------------------------------------------
create table QUOTATION_M
(
trn_id NUMBER not null,
dated DATE,
party_name VARCHAR2(100),
expiry VARCHAR2(10),
payment_term VARCHAR2(10),
address VARCHAR2(100),
contact VARCHAR2(50)
)

alter table QUOTATION_M
add primary key (TRN_ID)

create table QUOTATION_D
(
trn_id NUMBER,
sr NUMBER,
item_code NUMBER,
item_name VARCHAR2(100),
qty NUMBER,
uom VARCHAR2(10),
vat NUMBER,
amount NUMBER,
rate VARCHAR2(10)
)
alter table QUOTATION_D
add constraint TRN_ID_FK foreign key (TRN_ID)
references QUOTATION_M(TRN_ID);

-----------------------------------------------------------------------------------------------
create table TRN_MASTER
(
trans_id NUMBER(10) not null,
doc_no NUMBER(10),
doc_date DATE,
party_id NUMBER(10),
tamount NUMBER
)

alter table TRN_MASTER
add primary key (TRANS_ID)

create table TRN_DETAIL
(
trans_id NUMBER(10),
doc_no NUMBER(10),
doc_date DATE,
item_code VARCHAR2(20),
uom VARCHAR2(10),
qty NUMBER(10,2),
item_sale_rate NUMBER(10,2),
item_pur_rate NUMBER(10,2),
amount NUMBER(10),
net_amount NUMBER(10),
dis_amount NUMBER(10,4),
exp_date DATE,
vat NUMBER

alter table TRN_DETAIL
add constraint TRANS_ID_FK foreign key (TRANS_ID)
references TRN_MASTER (TRANS_ID);
Step by step explanation.
Easy to follow and understand.
#itseries#OracleDeveloper#POS

[AtifShahzadVlogs]

Aslam o alikum, dear ap ki videos bohat achi hoti hain or kafi helpful b hain, C or C++ boaht achy andaz sy sikhai hy, kindly POS development py b koi series bna dyn, ajkl POS ki bohat kafi demand hy kindly es py tutorial series bna dyn Oracle wala POS b or PHP k zariye POS development.

[AtifShahzadVlogs]

Dear apki video kafi achi hoti hain or achi smj b ati hy, Jis trha ap ny C, C++ or PHP ki series bnai hy, Kindly Laravel Framework ki b aik detail Video Series bna dyn agr possible hy to.

[AtifShahzadVlogs]

Dear Aslam o alikum, apky channel sy kafi kuch sekhny ko mila hy. Kindly Visual Programming ki b Tutorials Series bna dyn. Apki Book phr smjnny main asani ho jati hy, jis trha ap ny C++ ki bnai hain videos.

[bgmiesports]

Sir...car wash website ka files themes kaha hai...please woo toh dedo..bohot meherbani hogi.🙏