Home Explore Help
Register Sign In
GlobalCube
/
C11
3
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: d247d68133
Branches Tags
C11
/
System
/
OPTIMA
/
SQL
/
schema
/
OPTIMA4
/
tables
/
import.VEH_ORDER_OPTION.sql

import.VEH_ORDER_OPTION.sql 2.2 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 
  1. CREATE TABLE [import].[VEH_ORDER_OPTION] (
    2. 

  2.    [ORDER_NUMBER] [numeric](7,0) NOT NULL,
    3. 

  3.    [UNIT_NUMBER] [varchar](10) NOT NULL,
    4. 

  4.    [LINE_TYPE_SPEC] [char](1) NOT NULL,
    5. 

  5.    [LINE_NO_VO] [numeric](3,0) NOT NULL,
    6. 

  6.    [OPTION_TYPE] [char](1) NOT NULL,
    7. 

  7.    [OPTION_CODE_PF] [varchar](20) NOT NULL,
    8. 

  8.    [HANDLER] [char](4) NOT NULL,
    9. 

  9.    [CREATION_DATE] [datetime] NOT NULL,
    10. 

  10.    [OPTION_TEXT_1] [varchar](50) NOT NULL,
    11. 

  11.    [OPTION_TEXT_2] [varchar](50) NOT NULL,
    12. 

  12.    [OPTION_TEXT_3] [varchar](50) NOT NULL,
    13. 

  13.    [OPTION_TEXT_4] [varchar](50) NOT NULL,
    14. 

  14.    [OPTION_UPDATE] [char](1) NOT NULL,
    15. 

  15.    [PRINT_OPTION] [char](1) NOT NULL,
    16. 

  16.    [LIST_PRICE] [numeric](15,2) NOT NULL,
    17. 

  17.    [REAL_PRICE] [numeric](15,2) NOT NULL,
    18. 

  18.    [PURCHASE_PRICE] [numeric](15,2) NOT NULL,
    19. 

  19.    [VAT_CODE] [char](2) NOT NULL,
    20. 

  20.    [TRANSACTION_CODE] [char](3) NOT NULL,
    21. 

  21.    [REG_CODE] [char](2) NOT NULL,
    22. 

  22.    [DEDUCT_CODE] [char](2) NOT NULL,
    23. 

  23.    [DISCOUNT_PERC_VEH] [numeric](5,2) NOT NULL,
    24. 

  24.    [LIST_PRICE_DATE] [datetime] NOT NULL,
    25. 

  25.    [PURCH_PRICE_DATE] [datetime] NOT NULL,
    26. 

  26.    [PACKAGE_VEH] [char](1) NOT NULL,
    27. 

  27.    [CONNECT_PACK_NO] [char](5) NOT NULL,
    28. 

  28.    [TAX_PERC] [numeric](4,2) NOT NULL,
    29. 

  29.    [ACCT_NR] [varchar](10) NOT NULL,
    30. 

  30.    [LINE_NO_OLD_VO] [numeric](3,0) NOT NULL,
    31. 

  31.    [PRINT_TEXT_VO] [char](1) NOT NULL,
    32. 

  32.    [PRINT_PRICE_VO] [char](1) NOT NULL,
    33. 

  33.    [VAT_PRINT_CHARS] [char](2) NOT NULL,
    34. 

  34.    [PAYER_NO] [varchar](10) NOT NULL,
    35. 

  35.    [SUB_ORDER_NO] [numeric](7,0) NOT NULL,
    36. 

  36.    [WUST_CODE] [char](1) NOT NULL,
    37. 

  37.    [ACCOUNT_TYPE] [char](1) NOT NULL,
    38. 

  38.    [BOOKKEEP_ACCT] [varchar](10) NOT NULL,
    39. 

  39.    [BOOKKEEP_DEPT] [char](4) NOT NULL,
    40. 

  40.    [REMAIN_DEBT] [char](1) NOT NULL,
    41. 

  41.    [REQUISITION] [varchar](10) NULL,
    42. 

  42.    [BPM_AMOUNT] [numeric](15,2) NULL,
    43. 

  43.    [REFERENCE_IDENT] [numeric](12,0) NULL,
    44. 

  44.    [ACCT_SCHEDULE_ID] [varchar](10) NULL,
    45. 

  45.    [DEPOSIT_PRINTED] [char](1) NULL,
    46. 

  46.    [QUANTITY] [numeric](15,2) NULL,
    47. 

  47.    [PRICE] [numeric](15,2) NULL,
    48. 

  48.    [DISCOUNT_PERCENTAGE] [numeric](8,2) NULL,
    49. 

  49.    [DISCOUNT_AMOUNT] [numeric](15,2) NULL,
    50. 

  50.    [CONV_FLAG] [char](1) NULL,
    51. 

  51.    [timestamp] [binary](8) NOT NULL,
    52. 

  52.    [UNIQUE_IDENT] [numeric](12,0) NOT NULL,
    53. 

  53.    [PMT_LINE_TYPE] [char](1) NULL,
    54. 

  54.    [CLIENT_DB] [varchar](20) NOT NULL
    55. 

  55. 

  56.    ,CONSTRAINT [PKVEH_ORDER_OPTION_UNIQUE_IDENT] PRIMARY KEY CLUSTERED ([UNIQUE_IDENT], [CLIENT_DB])
    57. 

  57. )
    58. 

  58. 

  59. 

  60. GO
    61.