2022
...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
USE [DBSyncDB]
CREATE TABLE [dbo].[qbcustomer](
[name] [varchar](50) NULL,
[phone] [nchar](20) NULL,
[fax] [nchar](20) NULL,
[billingstreet] [varchar](200) NULL,
[billingcity] [varchar](50) NULL,
[billingstate] [varchar](50) NULL,
[billingcountry] [varchar](50) NULL,
[billingcode] [nchar](10) NULL,
[id] [nchar](50) NULL
) ON [PRIMARY]
GO
USE [DBSyncDB]
CREATE TABLE [dbo].[qbinvoice](
[invoice_no] [nchar](10) NULL,
[customername] [nchar](100) NULL,
[item] [nchar](100) NULL,
[itemdesc] [nchar](1000) NULL,
[quantity] [nchar](10) NULL,
[uom] [nchar](50) NULL,
[salesprice] [nchar](10) NULL,
[total] [nchar](10) NULL
) ON [PRIMARY]
GO
|