31 lines
1.2 KiB
MySQL
31 lines
1.2 KiB
MySQL
|
CREATE TABLE YingShouZhanKuanMX (
|
|||
|
|
[DATE] NVARCHAR(3000), -- ǩ<><C7A9><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
CONTRACTNUMBER NVARCHAR(3000), -- <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
ProjectName NVARCHAR(3000), -- <20><>Ŀ<EFBFBD><C4BF><EFBFBD><EFBFBD>
|
|||
|
|
SizeModel NVARCHAR(3000), -- <20><><EFBFBD><EFBFBD><EFBFBD>ͺ<EFBFBD>
|
|||
|
|
FQty DECIMAL(23, 10), -- <20><><EFBFBD><EFBFBD>/̨
|
|||
|
|
FTaxPrice DECIMAL(23, 10), -- <20><><EFBFBD><EFBFBD>
|
|||
|
|
FAllAmount DECIMAL(23, 10), -- <20><>˰<EFBFBD>ϼ<EFBFBD>
|
|||
|
|
OrderAmount DECIMAL(23, 10), -- <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
ShipmentsDate NVARCHAR(3000), -- <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
ShipmentsNum DECIMAL(23, 10), -- <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
ShipmentsAmount DECIMAL(23, 10), -- <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
ReturnDate NVARCHAR(3000), -- <20>˻<EFBFBD><CBBB><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
ReturnNum DECIMAL(23, 10), -- <20>˻<EFBFBD><CBBB><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
ReturnAmount DECIMAL(23, 10), -- <20>˻<EFBFBD><CBBB><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
ZPBillingDate NVARCHAR(3000), -- רƱ<D7A8><C6B1>Ʊ<EFBFBD><C6B1><EFBFBD><EFBFBD>
|
|||
|
|
ZPBillingAmount DECIMAL(23, 10), -- רƱ<D7A8><C6B1>Ʊ<EFBFBD><C6B1><EFBFBD><EFBFBD>
|
|||
|
|
PPBillingDate NVARCHAR(3000), --<EFBFBD><EFBFBD>Ʊ<EFBFBD><EFBFBD>Ʊ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
PPBillingAmount DECIMAL(23, 10), -- <20><>Ʊ<EFBFBD><C6B1>Ʊ<EFBFBD><C6B1><EFBFBD><EFBFBD>
|
|||
|
|
BillingAmount DECIMAL(23, 10), -- <20><>Ʊ<EFBFBD><C6B1><EFBFBD><EFBFBD>
|
|||
|
|
PaymentDate NVARCHAR(3000), -- <20>ؿ<EFBFBD><D8BF><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
PaymentAmount DECIMAL(23, 10), -- <20>ؿ<EFBFBD><D8BF><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
ShippedDebt DECIMAL(23, 10), -- <20>ѳ<EFBFBD><D1B3><EFBFBD>Ƿ<EFBFBD><C7B7>
|
|||
|
|
InvoicedDebt DECIMAL(23, 10), -- <20>ѿ<EFBFBD>ƱǷ<C6B1><C7B7>
|
|||
|
|
OwedTickets DECIMAL(23, 10), -- ǷƱ
|
|||
|
|
IsEnded NVARCHAR(3000), -- <20>Ƿ<EFBFBD><C7B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
Remark NVARCHAR(3000) -- <20><>ע
|
|||
|
|
);
|
|||
|
|
|
|||
|
|
|
|||
|
|
DROP TABLE YingShouZhanKuanMX
|