本文介绍了多个订单发票?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我需要一种方法来每月从多个订单创建发票?



在tbl_order表中,我有一个订单列表来自客户。

  tbl_order表

OrderID(PK)
ShopID(FK)
CustomerID(FK)
Statu
总计
OrderDate

让我们说,我想创建一个发票,期限为:从$ code> tbl_order.ShopID = 2





发票应该有发票号和发票日期,在发票中会有多个OrderID。



我需要创建发票表,如果是这样的表设计应该是什么?

解决方案

您将需要2张表。



发票表。

  InvoiceID(PK)
InvoiceDate
InvoicePrice
InvoiceBtw
ect。

订单和发票之间的链接表。
所以你可以跟踪在哪个发票处理哪个订单。

  InvoiceID(FK to tbl_invoices.InvoiceID)
OrderID(FK to tbl_orders.OrderID)


I need a way to create an invoice from multiple orders every month?

In the tbl_order table, I have a list of orders from the customer.

tbl_order table

OrderID (PK)
ShopID (FK)
CustomerID (FK)
Statu
Total
OrderDate

Let say I want to create an invoice for period: 1 to 31 May from tbl_order.ShopID = 2

(From there, I can an invoice report to a Shop/Company of Commission they owe me, etc. When I do recieved commission from them - I need a way to update invoice status)

The invoice should have Invoice Number and Invoice Date, in the invoice there will be multiple OrderID.

Do I need to create an invoice table, if so what the table design should be?

解决方案

You would need 2 tables.

The invoice table.

InvoiceID (PK)
InvoiceDate
InvoicePrice
InvoiceBtw
ect. etc.

An link table between orders and invoices.So you can keep track which order is processed in which invoice.

InvoiceID (FK to tbl_invoices.InvoiceID)
OrderID (FK to tbl_orders.OrderID)

这篇关于多个订单发票?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-18 19:58
查看更多