Startsida Utforska Hjälp
Registrera dig Logga in
GlobalCube
/
C11
3
0
Fork 0
Filer Ärenden 0 Pull-förfrågningar 0 Wiki
Träd: d247d68133
Grenar Taggar
C11
/
System
/
OPTIMA
/
SQL
/
schema
/
OPTIMA4
/
tables
/
import.VEHICLE_DOCKETCARD.sql

import.VEHICLE_DOCKETCARD.sql 5.6 KB
Historik Rå

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144 
  1. CREATE TABLE [import].[VEHICLE_DOCKETCARD] (
    2. 

  2.    [CHASSIS_NUMBER] [varchar](20) NOT NULL,
    3. 

  3.    [STATUS_CODE] [char](1) NOT NULL,
    4. 

  4.    [DATE_DOC_STATUS] [datetime] NOT NULL,
    5. 

  5.    [FIRST_REG_NO] [varchar](11) NOT NULL,
    6. 

  6.    [UNIT_NUMBER] [varchar](20) NOT NULL,
    7. 

  7.    [SATZART] [char](3) NOT NULL,
    8. 

  8.    [STEERING_FIELD] [char](1) NOT NULL,
    9. 

  9.    [NSC_ORDER_NUMBER] [char](4) NULL,
    10. 

  10.    [DEALER_NUMBER_DOC] [char](5) NOT NULL,
    11. 

  11.    [AOD_SUB_DEALER] [char](5) NOT NULL,
    12. 

  12.    [SALES_DATE] [datetime] NOT NULL,
    13. 

  13.    [DELIVERY_DATE_VEHI] [datetime] NOT NULL,
    14. 

  14.    [FIRST_REG_DATE] [datetime] NOT NULL,
    15. 

  15.    [MACHINE_TIME] [char](4) NOT NULL,
    16. 

  16.    [DEALER_ORDER_FORD] [char](4) NULL,
    17. 

  17.    [SALESMAN] [char](5) NOT NULL,
    18. 

  18.    [USED_CAR_KEY] [char](7) NOT NULL,
    19. 

  19.    [MAILSTOP_FORD] [char](1) NULL,
    20. 

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

  21.    [LEASING_NUMBER] [char](6) NOT NULL,
    22. 

  22.    [CARD_NUMBER] [char](7) NOT NULL,
    23. 

  23.    [DISCOUNT_DOCKED] [numeric](4,0) NOT NULL,
    24. 

  24.    [LEASING_G_P] [char](1) NOT NULL,
    25. 

  25.    [LEASING_RECIEPIENT] [char](6) NOT NULL,
    26. 

  26.    [LEASING_CARD_NUMB] [char](7) NOT NULL,
    27. 

  27.    [ECS_VEHICLE] [char](1) NOT NULL,
    28. 

  28.    [CATEGORY_DOCKED] [char](1) NOT NULL,
    29. 

  29.    [TITLE_CODE_DOCKED] [char](1) NOT NULL,
    30. 

  30.    [TITLE_DOCKED] [varchar](60) NOT NULL,
    31. 

  31.    [FIRST_NAME_DOCKED] [varchar](60) NOT NULL,
    32. 

  32.    [NAME_DOCKED] [varchar](60) NOT NULL,
    33. 

  33.    [COUNTRY_CODE] [char](5) NOT NULL,
    34. 

  34.    [POSTAL_CODE] [char](5) NOT NULL,
    35. 

  35.    [TOWN_DOCKED] [varchar](60) NOT NULL,
    36. 

  36.    [STREET_DOCKED] [varchar](60) NOT NULL,
    37. 

  37.    [STREET_NUMBER_DOC] [char](4) NOT NULL,
    38. 

  38.    [PHONE] [varchar](50) NULL,
    39. 

  39.    [SERVICE_DEALER] [char](5) NOT NULL,
    40. 

  40.    [AOS_DEAL_NUMBER] [char](4) NULL,
    41. 

  41.    [USER_NAME] [varchar](60) NULL,
    42. 

  42.    [USER_STREET] [varchar](60) NULL,
    43. 

  43.    [USER_ZIPCODE] [varchar](10) NULL,
    44. 

  44.    [USER_PHONE] [varchar](20) NULL,
    45. 

  45.    [COMPANY_NAME] [varchar](30) NULL,
    46. 

  46.    [COMPANY_ADDRESS] [varchar](30) NULL,
    47. 

  47.    [COMPANY_ZIPCODE] [varchar](10) NULL,
    48. 

  48.    [COMPANY_PHONE] [varchar](20) NULL,
    49. 

  49.    [OKB_VEHICLE] [char](1) NOT NULL,
    50. 

  50.    [BANK_DEPARTMENT] [char](1) NOT NULL,
    51. 

  51.    [EXTENSION_CODE] [char](1) NOT NULL,
    52. 

  52.    [RESERVED_1] [char](5) NOT NULL,
    53. 

  53.    [RESERVED_2] [char](5) NOT NULL,
    54. 

  54.    [RESERVED_3] [char](3) NOT NULL,
    55. 

  55.    [RESERVED_4] [char](2) NOT NULL,
    56. 

  56.    [RESERVED_5] [char](2) NOT NULL,
    57. 

  57.    [ERROR_TYPE_1] [numeric](2,0) NOT NULL,
    58. 

  58.    [ITEM_NO_1] [numeric](2,0) NOT NULL,
    59. 

  59.    [ERROR_TYPE_2] [numeric](2,0) NOT NULL,
    60. 

  60.    [ITEM_NO_2] [numeric](2,0) NOT NULL,
    61. 

  61.    [ERROR_TYPE_3] [numeric](2,0) NOT NULL,
    62. 

  62.    [ITEM_NO_3] [numeric](2,0) NOT NULL,
    63. 

  63.    [ERROR_TYPE_4] [numeric](2,0) NOT NULL,
    64. 

  64.    [ITEM_NO_4] [numeric](2,0) NOT NULL,
    65. 

  65.    [ERROR_TYPE_5] [numeric](2,0) NOT NULL,
    66. 

  66.    [ITEM_NO_5] [numeric](2,0) NOT NULL,
    67. 

  67.    [ERROR_TYPE_6] [numeric](2,0) NOT NULL,
    68. 

  68.    [ITEM_NO_6] [numeric](2,0) NOT NULL,
    69. 

  69.    [ERROR_TYPE_7] [numeric](2,0) NOT NULL,
    70. 

  70.    [ITEM_NO_7] [numeric](2,0) NOT NULL,
    71. 

  71.    [ERROR_TYPE_8] [numeric](2,0) NOT NULL,
    72. 

  72.    [ITEM_NO_8] [numeric](2,0) NOT NULL,
    73. 

  73.    [ERROR_TYPE_9] [numeric](2,0) NOT NULL,
    74. 

  74.    [ITEM_NO_9] [numeric](2,0) NOT NULL,
    75. 

  75.    [ERROR_TYPE_10] [numeric](2,0) NOT NULL,
    76. 

  76.    [ITEM_NO_10] [numeric](2,0) NOT NULL,
    77. 

  77.    [ERROR_TYPE_11] [numeric](2,0) NOT NULL,
    78. 

  78.    [ITEM_NO_11] [numeric](2,0) NOT NULL,
    79. 

  79.    [ERROR_TYPE_12] [numeric](2,0) NOT NULL,
    80. 

  80.    [ITEM_NO_12] [numeric](2,0) NOT NULL,
    81. 

  81.    [ERROR_TYPE_13] [numeric](2,0) NOT NULL,
    82. 

  82.    [ITEM_NO_13] [numeric](2,0) NOT NULL,
    83. 

  83.    [ERROR_TYPE_14] [numeric](2,0) NOT NULL,
    84. 

  84.    [ITEM_NO_14] [numeric](2,0) NOT NULL,
    85. 

  85.    [ERROR_TYPE_15] [numeric](2,0) NOT NULL,
    86. 

  86.    [ITEM_NO_15] [numeric](2,0) NOT NULL,
    87. 

  87.    [ERROR_TYPE_16] [numeric](2,0) NOT NULL,
    88. 

  88.    [ITEM_NO_16] [numeric](2,0) NOT NULL,
    89. 

  89.    [ERROR_TYPE_17] [numeric](2,0) NOT NULL,
    90. 

  90.    [ITEM_NO_17] [numeric](2,0) NOT NULL,
    91. 

  91.    [ERROR_TYPE_18] [numeric](2,0) NOT NULL,
    92. 

  92.    [ITEM_NO_18] [numeric](2,0) NOT NULL,
    93. 

  93.    [ERROR_TYPE_19] [numeric](2,0) NOT NULL,
    94. 

  94.    [ITEM_NO_19] [numeric](2,0) NOT NULL,
    95. 

  95.    [ERROR_TYPE_20] [numeric](2,0) NOT NULL,
    96. 

  96.    [ITEM_NO_20] [numeric](2,0) NOT NULL,
    97. 

  97.    [ERROR_TYPE_21] [numeric](2,0) NOT NULL,
    98. 

  98.    [ITEM_NO_21] [numeric](2,0) NOT NULL,
    99. 

  99.    [ERROR_TYPE_22] [numeric](2,0) NOT NULL,
    100. 

  100.    [ITEM_NO_22] [numeric](2,0) NOT NULL,
    101. 

  101.    [ERROR_TYPE_23] [numeric](2,0) NOT NULL,
    102. 

  102.    [ITEM_NO_23] [numeric](2,0) NOT NULL,
    103. 

  103.    [ERROR_TYPE_24] [numeric](2,0) NOT NULL,
    104. 

  104.    [ITEM_NO_24] [numeric](2,0) NOT NULL,
    105. 

  105.    [ERROR_TYPE_25] [numeric](2,0) NOT NULL,
    106. 

  106.    [ITEM_NO_25] [numeric](2,0) NOT NULL,
    107. 

  107.    [ERROR_TYPE_26] [numeric](2,0) NOT NULL,
    108. 

  108.    [ITEM_NO_26] [numeric](2,0) NOT NULL,
    109. 

  109.    [ERROR_TYPE_27] [numeric](2,0) NOT NULL,
    110. 

  110.    [ITEM_NO_27] [numeric](2,0) NOT NULL,
    111. 

  111.    [ERROR_TYPE_28] [numeric](2,0) NOT NULL,
    112. 

  112.    [ITEM_NO_28] [numeric](2,0) NOT NULL,
    113. 

  113.    [ERROR_TYPE_29] [numeric](2,0) NOT NULL,
    114. 

  114.    [ITEM_NO_29] [numeric](2,0) NOT NULL,
    115. 

  115.    [ERROR_TYPE_30] [numeric](2,0) NOT NULL,
    116. 

  116.    [ITEM_NO_30] [numeric](2,0) NOT NULL,
    117. 

  117.    [ERROR_TYPE_31] [numeric](2,0) NOT NULL,
    118. 

  118.    [ITEM_NO_31] [numeric](2,0) NOT NULL,
    119. 

  119.    [ERROR_TYPE_32] [numeric](2,0) NOT NULL,
    120. 

  120.    [ITEM_NO_32] [numeric](2,0) NOT NULL,
    121. 

  121.    [ERROR_TYPE_33] [numeric](2,0) NOT NULL,
    122. 

  122.    [ITEM_NO_33] [numeric](2,0) NOT NULL,
    123. 

  123.    [ERROR_TYPE_34] [numeric](2,0) NOT NULL,
    124. 

  124.    [ITEM_NO_34] [numeric](2,0) NOT NULL,
    125. 

  125.    [ERROR_TYPE_35] [numeric](2,0) NOT NULL,
    126. 

  126.    [ITEM_NO_35] [numeric](2,0) NOT NULL,
    127. 

  127.    [ERROR_TYPE_36] [numeric](2,0) NOT NULL,
    128. 

  128.    [ITEM_NO_36] [numeric](2,0) NOT NULL,
    129. 

  129.    [ERROR_TYPE_37] [numeric](2,0) NOT NULL,
    130. 

  130.    [ITEM_NO_37] [numeric](2,0) NOT NULL,
    131. 

  131.    [ERROR_TYPE_38] [numeric](2,0) NOT NULL,
    132. 

  132.    [ITEM_NO_38] [numeric](2,0) NOT NULL,
    133. 

  133.    [ERROR_TYPE_39] [numeric](2,0) NOT NULL,
    134. 

  134.    [ITEM_NO_39] [numeric](2,0) NOT NULL,
    135. 

  135.    [ERROR_TYPE_40] [numeric](2,0) NOT NULL,
    136. 

  136.    [ITEM_NO_40] [numeric](2,0) NOT NULL,
    137. 

  137.    [CONV_FLAG] [char](1) NULL,
    138. 

  138.    [timestamp] [binary](8) NOT NULL,
    139. 

  139.    [UNIQUE_IDENT] [numeric](12,0) NOT NULL,
    140. 

  140.    [CLIENT_DB] [varchar](20) NOT NULL
    141. 

  141. )
    142. 

  142. 

  143. 

  144. GO
    145.