问题描述
我需要一种方法来每月从多个订单创建发票?
在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)
这篇关于多个订单发票?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!