C11/System/OPTIMA/SQL/schema/OPTIMA/tables/import.CUSTOMER_TRANSACT.sql

CREATE TABLE [import].[CUSTOMER_TRANSACT] (
   [CUSTOMER_NUMBER] [char](10) NOT NULL,
   [VOUCHER_NO] [numeric](10,0) NOT NULL,
   [LINE_NO_CU] [numeric](4,0) NOT NULL,
   [TRANSACTION_STATUS] [char](1) NOT NULL,
   [DUE_DATE] [datetime] NOT NULL,
   [BOOKKEEP_DATE] [datetime] NOT NULL,
   [STATE_CODE] [char](1) NOT NULL,
   [TRANSACT_DATE] [datetime] NOT NULL,
   [HANDLER] [varchar](10) NOT NULL,
   [CREATION_DATE] [datetime] NOT NULL,
   [CREATION_TIME_8] [char](8) NOT NULL,
   [STATUS] [char](2) NOT NULL,
   [MODUL] [char](1) NOT NULL,
   [BATCH_NUMBER] [numeric](10,0) NOT NULL,
   [JOURNAL_NO] [numeric](10,0) NOT NULL,
   [DOCUMENT_NO] [numeric](10,0) NOT NULL,
   [DOCUMENT_DATE] [datetime] NOT NULL,
   [DISCOUNT_DATE] [datetime] NOT NULL,
   [DUNNING_DATE] [datetime] NOT NULL,
   [START_INT_DATE] [datetime] NOT NULL,
   [LAST_INT_DATE] [datetime] NOT NULL,
   [PMT_TERM] [varchar](10) NOT NULL,
   [DUNTIMES] [char](1) NOT NULL,
   [TAX_CODE] [char](1) NOT NULL,
   [REMINDER_CODE] [char](1) NOT NULL,
   [SUM_C_U] [numeric](15,2) NOT NULL,
   [TAX_C_U] [numeric](15,2) NOT NULL,
   [CASH_DISCOUNT_C_U] [numeric](15,2) NOT NULL,
   [INTEREST_PERC] [numeric](5,2) NOT NULL,
   [PAID_C_U] [numeric](15,2) NOT NULL,
   [COMMENT_CU] [varchar](max) NOT NULL,
   [SETOFF_ACCT] [char](10) NOT NULL,
   [COLLECT_ACCT] [char](10) NOT NULL,
   [INTEREST_CALC] [char](1) NOT NULL,
   [EEC_VAT_WORK_CODE] [char](1) NOT NULL,
   [EEC_VAT_LIST_NO] [numeric](10,0) NOT NULL,
   [SPLIT_CODE_CU] [char](1) NOT NULL,
   [PMT_PROPOSAL] [char](1) NOT NULL,
   [APPROVED] [char](1) NULL,
   [BOOK_NO] [char](3) NULL,
   [CHECK_NUMBER] [char](10) NULL,
   [ACTIVITY_CODE] [varchar](20) NULL,
   [SALES_TYPE] [char](1) NULL,
   [INT_VOUCHER_NO] [numeric](15,0) NULL,
   [DEPARTMENT] [char](4) NULL,
   [CONV_FLAG] [char](1) NULL,
   [timestamp] [binary](8) NOT NULL,
   [UNIQUE_IDENT] [numeric](12,0) NOT NULL,
   [FEE_STATUS] [char](1) NULL,
   [CLIENT_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [PK_CUSTOMER_TRANSACTUNIQUE_IDENT] PRIMARY KEY CLUSTERED ([UNIQUE_IDENT], [CLIENT_DB])
)


GO