import.Customer.sql 512 B

1234567891011121314151617
  1. CREATE TABLE [import].[Customer] (
  2. [timestamp] [binary](8) NOT NULL,
  3. [No_] [varchar](20) NOT NULL,
  4. [Name] [varchar](100) NOT NULL,
  5. [Payment Terms Code] [varchar](10) NULL,
  6. [Gen_ Bus_ Posting Group] [varchar](10) NOT NULL,
  7. [Address No_] [int] NULL,
  8. [Last Name] [varchar](100) NOT NULL,
  9. [First Name] [varchar](50) NOT NULL,
  10. [Customer Group Code] [varchar](20) NOT NULL,
  11. [Client_DB] [varchar](20) NOT NULL
  12. ,CONSTRAINT [Customer$0] PRIMARY KEY CLUSTERED ([No_], [Client_DB])
  13. )
  14. GO