How to insert multiple sales orders to single sales

Question

1.00/5 (3 votes)

See more:

SQL-Server-2008R2

Hi I need add multiple sales orders for a single sale how to do it?

Actually suppose if a customer purchases four items on single bill then what is the table structure for it?

Posted 12-Sep-14 1:42am

Shiva nag

Updated 12-Sep-14 1:46am

v2

Add a Solution

Comments

Magic Wonder 12-Sep-14 7:44am

Not a good question. Not enough info to help you out.

Neetin_1809 12-Sep-14 8:28am

Hello ,
Use Should uSe The Parent Child Relation SHip if you are the aware.
Kindly see the solution 2 which will give you the clear Id

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Magic Wonder · Answer 1 · 2014-09-12T01:54:00

Hi,

From your query below should be the table structure.

SQL

CREATE TABLE tbl_Purchase_Dtls
(
PD_ID BIGINT IDENTITY(1,1),
PD_CUST_ID BIGINT,
PD_ITEM_ID INT,
PD_ITEM_QTY INT,
PD_ITEM_AMT DECIMAL(10,2),
PD_BILL_NO VARCHAR(50),
PD_CREATED_DT DATETIME DEFAULT GETDATE(),
PD_CREATED_BY VARCHAR(100),
PD_UPDATED_DT DATETIME,
PD_UPDATED_BY VARCHAR(100),
PD_STATUS_FLAG INT
)

Hope this will help you.

Cheers

Dilan Shaminda · Answer 2 · 2014-09-12T18:06:00

According to your explanation, suppose you have two tables in your sql database called Transaction and TransactionItemWise. Transaction table stores any transaction as a summary and TransactionItemWise table keeps them itemwise. That means there is 1:M relationship between Transaction and TransactionItemWise tabels. So as we know 1 side key goes to M side. See the example below

SQL

CREATE TABLE Transaction(
TrxID varchar(3),
TotAmount float,
TotQty int,
TrxDate DateTime,
CONSTRAINT pk_Transaction PRIMARY KEY (TrxID)
)

SQL

CREATE TABLE TransactionItemWise(
TrxID varchar(3),
ItemNo varchar(3),
ItemAmount float,
ItemQty int,
CONSTRAINT pk_TransactionItemWise PRIMARY KEY (TrxID,ItemNo),
CONSTRAINT fk_PerOrders FOREIGN KEY (TrxID)
REFERENCES Transaction(TrxID)
)

Gihan Liyanage · Answer 3 · 2014-09-12T01:59:00

Solution 2

Please see following structure.

You Can have multiple orders (Order Header)for the customer
Multiple Order Lines(different items) for One Order
Further you should have product table

SalesOrders[^]

Posted 12-Sep-14 1:59am

Gihan Liyanage

How to insert multiple sales orders to single sales

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0