create table InvoiceData(
|
InvoiceID int no 4 10 0 no (n/a) (n/a) NULL
|
ServiceOrderIDPK bigint no 8 19 0 yes (n/a) (n/a) NULL
|
InvoiceType int no 4 10 0 yes (n/a) (n/a) NULL
|
InvoiceName nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
InvoiceMakeout nvarchar no 2000 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
InvoiceCompanyPhone nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
InvoiceCompanyID nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
InvoiceCompanyAdd nvarchar no 200 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
InvoiceCompanyBank nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
InvoiceCompanyBankNo nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
InvoiceZipCode nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
Invoice_strAdd nvarchar no 200 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
Invoice_strName nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
Invoice_strPhone nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
Invoice_strEmail nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
ApplicationTime datetime no 8 yes (n/a) (n/a) NULL
|
AuditTime datetime no 8 yes (n/a) (n/a) NULL
|
AuditStatus int no 4 10 0 yes (n/a) (n/a) NULL
|
AuditOAID int no 4 10 0 yes (n/a) (n/a) NULL
|
AuditMakeout nvarchar no 200 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
InvoiceMoney money no 8 19 4 yes (n/a) (n/a) NULL
|
InvoiceNo nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
InvoiceURL nvarchar no 2000 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
InvoiceOddNo nvarchar no 400 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
EleCloud_ZTDM nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
EleCloud_ZTXX nvarchar no 200 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
EleCloud_PDF nvarchar no 200 yes (n/a) (n/a) Chinese_PRC_CI_AS
|
EleCloud_Time datetime no 8 yes (n/a) (n/a) NULL
|
ApplyOAID int no 4 10 0 yes (n/a) (n/a) NULL
|
)
|
