Главная Обзор Помощь
Регистрация Вход
GlobalCube
/
C11
3
0
Ответвить 0
Файлы Задачи 0 Запросы на слияние 0 Вики
Дерево: 2177bf8213
Ветки Метки
C11
/
System
/
AUTOLINE
/
SQL
/
schema
/
AUTOLINE
/
tables
/
import.VS_UsedVehicleStock.sql

import.VS_UsedVehicleStock.sql 13 KB
История Исходник

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329 
  1. CREATE TABLE [import].[VS_UsedVehicleStock] (
    2. 

  2.    [StockbookNumber] [int] NOT NULL,
    3. 

  3.    [Franchise] [varchar](1) NULL,
    4. 

  4.    [ModelCode] [varchar](15) NULL,
    5. 

  5.    [ModelVariant] [varchar](15) NULL,
    6. 

  6.    [VehicleDescriptio001] [varchar](100) NULL,
    7. 

  7.    [VehicleDescriptio002] [varchar](100) NULL,
    8. 

  8.    [VehicleDescriptio003] [varchar](100) NULL,
    9. 

  9.    [VehicleDescriptio004] [varchar](100) NULL,
    10. 

  10.    [VehicleDescriptio005] [varchar](100) NULL,
    11. 

  11.    [VehicleDescriptio006] [varchar](100) NULL,
    12. 

  12.    [VehicleDescriptio007] [varchar](100) NULL,
    13. 

  13.    [VehicleDescriptio008] [varchar](100) NULL,
    14. 

  14.    [VehicleDescriptio009] [varchar](100) NULL,
    15. 

  15.    [DummyValuesIgnore] [varchar](5) NULL,
    16. 

  16.    [ColourWheelbaseDesc] [varchar](50) NULL,
    17. 

  17.    [BY054100] [varchar](5) NULL,
    18. 

  18.    [TrimCabtypeDesc] [varchar](50) NULL,
    19. 

  19.    [WhereAddressFrom001] [varchar](1) NULL,
    20. 

  20.    [WhereAddressFrom002] [varchar](1) NULL,
    21. 

  21.    [PhysicalBranch] [varchar](3) NULL,
    22. 

  22.    [ProgressCode] [varchar](1) NULL,
    23. 

  23.    [ACSStatus] [varchar](1) NULL,
    24. 

  24.    [FullChassis] [varchar](30) NULL,
    25. 

  25.    [EngineNumber] [varchar](20) NULL,
    26. 

  26.    [BY065300] [varchar](20) NULL,
    27. 

  27.    [SupplierName] [varchar](50) NULL,
    28. 

  28.    [SupplierAddress001] [varchar](35) NULL,
    29. 

  29.    [SupplierAddress002] [varchar](35) NULL,
    30. 

  30.    [SupplierAddress003] [varchar](35) NULL,
    31. 

  31.    [SupplierAddress004] [varchar](35) NULL,
    32. 

  32.    [SupplierAddress005] [varchar](35) NULL,
    33. 

  33.    [SupplierPostcode] [varchar](10) NULL,
    34. 

  34.    [NonRecoverableCos001] [decimal](17,2) NULL,
    35. 

  35.    [NonRecoverableCos002] [decimal](17,2) NULL,
    36. 

  36.    [NonRecoverableCos003] [decimal](17,2) NULL,
    37. 

  37.    [RegistrationNumber] [varchar](20) NULL,
    38. 

  38.    [RegDate] [datetime] NULL,
    39. 

  39.    [InputVAT] [decimal](17,2) NULL,
    40. 

  40.    [CustomerName] [varchar](152) NULL,
    41. 

  41.    [CustomerAddress001] [varchar](35) NULL,
    42. 

  42.    [CustomerAddress002] [varchar](35) NULL,
    43. 

  43.    [CustomerAddress003] [varchar](35) NULL,
    44. 

  44.    [CustomerAddress004] [varchar](35) NULL,
    45. 

  45.    [CustomerAddress005] [varchar](35) NULL,
    46. 

  46.    [CustomerPostcode] [varchar](10) NULL,
    47. 

  47.    [TelephoneNumber] [varchar](23) NULL,
    48. 

  48.    [InvoiceName] [varchar](152) NULL,
    49. 

  49.    [InvoiceAddress001] [varchar](35) NULL,
    50. 

  50.    [InvoiceAddress002] [varchar](35) NULL,
    51. 

  51.    [InvoiceAddress003] [varchar](35) NULL,
    52. 

  52.    [InvoiceAddress004] [varchar](35) NULL,
    53. 

  53.    [InvoiceAddress005] [varchar](35) NULL,
    54. 

  54.    [InvAddrPostcode] [varchar](10) NULL,
    55. 

  55.    [CustomerOrderNo] [varchar](20) NULL,
    56. 

  56.    [OrderDate] [datetime] NULL,
    57. 

  57.    [SOrderType] [varchar](1) NULL,
    58. 

  58.    [SalesExecutive001] [varchar](8) NULL,
    59. 

  59.    [SalesExecutive002] [varchar](8) NULL,
    60. 

  60.    [SalesExecutive003] [varchar](8) NULL,
    61. 

  61.    [SalesExecutive004] [varchar](8) NULL,
    62. 

  62.    [DeliveryDate] [datetime] NULL,
    63. 

  63.    [SalesInvoiceNumber] [decimal](10,0) NULL,
    64. 

  64.    [DateTaxPoint] [datetime] NULL,
    65. 

  65.    [NettTotal] [decimal](17,2) NULL,
    66. 

  66.    [SalesDiscount] [decimal](17,2) NULL,
    67. 

  67.    [VATTotal] [decimal](17,2) NULL,
    68. 

  68.    [Cost] [decimal](17,2) NULL,
    69. 

  69.    [GrossTotal] [decimal](17,2) NULL,
    70. 

  70.    [TradeInReference001] [int] NULL,
    71. 

  71.    [TradeInReference002] [int] NULL,
    72. 

  72.    [TradeInReference003] [int] NULL,
    73. 

  73.    [FinanceDue] [decimal](17,2) NULL,
    74. 

  74.    [CustomerDue] [decimal](17,2) NULL,
    75. 

  75.    [OtherCosts001] [decimal](17,2) NULL,
    76. 

  76.    [OtherCosts002] [decimal](17,2) NULL,
    77. 

  77.    [OtherCosts003] [decimal](17,2) NULL,
    78. 

  78.    [OtherCosts004] [decimal](17,2) NULL,
    79. 

  79.    [OtherCosts005] [decimal](17,2) NULL,
    80. 

  80.    [OtherCosts006] [decimal](17,2) NULL,
    81. 

  81.    [OtherCosts007] [decimal](17,2) NULL,
    82. 

  82.    [OtherCosts008] [decimal](17,2) NULL,
    83. 

  83.    [OtherCosts009] [decimal](17,2) NULL,
    84. 

  84.    [OtherCosts010] [decimal](17,2) NULL,
    85. 

  85.    [OtherCosts011] [decimal](17,2) NULL,
    86. 

  86.    [OtherCosts012] [decimal](17,2) NULL,
    87. 

  87.    [OtherCosts013] [decimal](17,2) NULL,
    88. 

  88.    [OtherCosts014] [decimal](17,2) NULL,
    89. 

  89.    [OtherCosts015] [decimal](17,2) NULL,
    90. 

  90.    [TotalNRCosts] [decimal](17,2) NULL,
    91. 

  91.    [OverAllowance001] [decimal](17,2) NULL,
    92. 

  92.    [OverAllowance002] [decimal](17,2) NULL,
    93. 

  93.    [OverAllowance003] [decimal](17,2) NULL,
    94. 

  94.    [LatestProfitValue] [decimal](17,2) NULL,
    95. 

  95.    [InvoicedProfitValu] [decimal](17,2) NULL,
    96. 

  96.    [InvoicedProfitDate] [datetime] NULL,
    97. 

  97.    [ProfitLastVSBPend] [decimal](17,2) NULL,
    98. 

  98.    [DateLastVSBPEnd] [datetime] NULL,
    99. 

  99.    [ProfitLastNLPEnd] [decimal](17,2) NULL,
    100. 

  100.    [DateLastNLPEnd] [datetime] NULL,
    101. 

  101.    [EstimatedCosts] [decimal](17,2) NULL,
    102. 

  102.    [LateCosts] [decimal](17,2) NULL,
    103. 

  103.    [Locator] [varchar](16) NULL,
    104. 

  104.    [DefaultPictureCode] [varchar](10) NULL,
    105. 

  105.    [SpecialForKEY9] [varchar](20) NULL,
    106. 

  106.    [PreReserveProgress] [varchar](1) NULL,
    107. 

  107.    [DateReserved] [datetime] NULL,
    108. 

  108.    [TimeReserved] [decimal](8,4) NULL,
    109. 

  109.    [ReservedBy] [varchar](8) NULL,
    110. 

  110.    [SupplierAccount] [varchar](8) NULL,
    111. 

  111.    [InvoiceAccount] [varchar](8) NULL,
    112. 

  112.    [CustomerAccount] [varchar](8) NULL,
    113. 

  113.    [EstimatedDeposit] [decimal](17,2) NULL,
    114. 

  114.    [InvoiceTotal] [decimal](17,2) NULL,
    115. 

  115.    [ReValuationCond] [varchar](1) NULL,
    116. 

  116.    [CustomerACAmount] [decimal](17,2) NULL,
    117. 

  117.    [DepositAmounts001] [decimal](17,2) NULL,
    118. 

  118.    [DepositAmounts002] [decimal](17,2) NULL,
    119. 

  119.    [DepositAmounts003] [decimal](17,2) NULL,
    120. 

  120.    [DepositReferences001] [decimal](10,0) NULL,
    121. 

  121.    [DepositReferences002] [decimal](10,0) NULL,
    122. 

  122.    [DepositReferences003] [decimal](10,0) NULL,
    123. 

  123.    [DepositTotal] [decimal](17,2) NULL,
    124. 

  124.    [InvoiceACAmount] [decimal](17,2) NULL,
    125. 

  125.    [NetAllowanceTotal] [decimal](17,2) NULL,
    126. 

  126.    [NetAllowances001] [decimal](17,2) NULL,
    127. 

  127.    [NetAllowances002] [decimal](17,2) NULL,
    128. 

  128.    [NetAllowances003] [decimal](17,2) NULL,
    129. 

  129.    [OverAllowanceTotal] [decimal](17,2) NULL,
    130. 

  130.    [SupplYValueTotal] [decimal](17,2) NULL,
    131. 

  131.    [MainInvoiceTotal] [decimal](17,2) NULL,
    132. 

  132.    [InvoiceVatCodes001] [varchar](1) NULL,
    133. 

  133.    [InvoiceVatCodes002] [varchar](1) NULL,
    134. 

  134.    [InvoiceVatCodes003] [varchar](1) NULL,
    135. 

  135.    [InvoiceVatCodes004] [varchar](1) NULL,
    136. 

  136.    [InvoiceVatCodes005] [varchar](1) NULL,
    137. 

  137.    [InvoiceVatCodes006] [varchar](1) NULL,
    138. 

  138.    [InvoiceVatCodes007] [varchar](1) NULL,
    139. 

  139.    [InvoiceVatCodes008] [varchar](1) NULL,
    140. 

  140.    [InvoiceVatCodes009] [varchar](1) NULL,
    141. 

  141.    [InvoiceVatCodes010] [varchar](1) NULL,
    142. 

  142.    [TOAtThisCode001] [decimal](17,2) NULL,
    143. 

  143.    [TOAtThisCode002] [decimal](17,2) NULL,
    144. 

  144.    [TOAtThisCode003] [decimal](17,2) NULL,
    145. 

  145.    [TOAtThisCode004] [decimal](17,2) NULL,
    146. 

  146.    [TOAtThisCode005] [decimal](17,2) NULL,
    147. 

  147.    [TOAtThisCode006] [decimal](17,2) NULL,
    148. 

  148.    [TOAtThisCode007] [decimal](17,2) NULL,
    149. 

  149.    [TOAtThisCode008] [decimal](17,2) NULL,
    150. 

  150.    [TOAtThisCode009] [decimal](17,2) NULL,
    151. 

  151.    [TOAtThisCode010] [decimal](17,2) NULL,
    152. 

  152.    [VatAtThisCode001] [decimal](17,2) NULL,
    153. 

  153.    [VatAtThisCode002] [decimal](17,2) NULL,
    154. 

  154.    [VatAtThisCode003] [decimal](17,2) NULL,
    155. 

  155.    [VatAtThisCode004] [decimal](17,2) NULL,
    156. 

  156.    [VatAtThisCode005] [decimal](17,2) NULL,
    157. 

  157.    [VatAtThisCode006] [decimal](17,2) NULL,
    158. 

  158.    [VatAtThisCode007] [decimal](17,2) NULL,
    159. 

  159.    [VatAtThisCode008] [decimal](17,2) NULL,
    160. 

  160.    [VatAtThisCode009] [decimal](17,2) NULL,
    161. 

  161.    [VatAtThisCode010] [decimal](17,2) NULL,
    162. 

  162.    [LastPLMagicNo] [int] NULL,
    163. 

  163.    [LastSLMagicNo] [int] NULL,
    164. 

  164.    [InvoiceProduced] [tinyint] NULL,
    165. 

  165.    [QualifyingForVAT] [varchar](1) NULL,
    166. 

  166.    [Condition001] [varchar](30) NULL,
    167. 

  167.    [Condition002] [varchar](30) NULL,
    168. 

  168.    [Condition003] [varchar](30) NULL,
    169. 

  169.    [Features001] [varchar](30) NULL,
    170. 

  170.    [Features002] [varchar](30) NULL,
    171. 

  171.    [Features003] [varchar](30) NULL,
    172. 

  172.    [Mileage] [decimal](10,0) NULL,
    173. 

  173.    [MOTExpiry] [datetime] NULL,
    174. 

  174.    [PreviousOwners] [decimal](4,0) NULL,
    175. 

  175.    [LastOwnerSName] [varchar](50) NULL,
    176. 

  176.    [LastOwnerSAddress001] [varchar](30) NULL,
    177. 

  177.    [LastOwnerSAddress002] [varchar](30) NULL,
    178. 

  178.    [LastOwnerSAddress003] [varchar](30) NULL,
    179. 

  179.    [LastOwnerSAddress004] [varchar](30) NULL,
    180. 

  180.    [LastOwnerSAddress005] [varchar](30) NULL,
    181. 

  181.    [InvoiceNumber] [varchar](10) NULL,
    182. 

  182.    [InvoiceDate] [datetime] NULL,
    183. 

  183.    [SupplierVATNo] [varchar](20) NULL,
    184. 

  184.    [BoughtBy] [varchar](8) NULL,
    185. 

  185.    [PartExReference] [varchar](7) NULL,
    186. 

  186.    [PurchasePrice] [decimal](17,2) NULL,
    187. 

  187.    [StockValue] [decimal](17,2) NULL,
    188. 

  188.    [AdjustedStockValue] [decimal](17,2) NULL,
    189. 

  189.    [VATableAmount] [decimal](17,2) NULL,
    190. 

  190.    [TotalPurchasePrice] [decimal](17,2) NULL,
    191. 

  191.    [HPCompany] [varchar](30) NULL,
    192. 

  192.    [HPOwing] [decimal](17,2) NULL,
    193. 

  193.    [SellingPrice] [decimal](17,2) NULL,
    194. 

  194.    [RFLRefund] [decimal](17,2) NULL,
    195. 

  195.    [VATOnLease] [decimal](17,2) NULL,
    196. 

  196.    [ReRegistrationDate] [datetime] NULL,
    197. 

  197.    [Letter] [int] NULL,
    198. 

  198.    [DateSent] [datetime] NULL,
    199. 

  199.    [Confirmed] [tinyint] NULL,
    200. 

  200.    [LogBook] [varchar](1) NULL,
    201. 

  201.    [ProofOfHistory] [varchar](1) NULL,
    202. 

  202.    [DocumentPrintedIC] [varchar](1) NULL,
    203. 

  203.    [PurchaseDocumentNo] [decimal](10,0) NULL,
    204. 

  204.    [HPPurchaseAccount] [varchar](8) NULL,
    205. 

  205.    [HPICheck] [varchar](10) NULL,
    206. 

  206.    [FinanceAgeement] [varchar](10) NULL,
    207. 

  207.    [UsedVehicleVATCOST] [decimal](17,2) NULL,
    208. 

  208.    [LastPXMagicNumber] [int] NULL,
    209. 

  209.    [CostOfSelprice] [decimal](17,2) NULL,
    210. 

  210.    [OverallSaleNet] [decimal](17,2) NULL,
    211. 

  211.    [OverallSaleDisc] [decimal](17,2) NULL,
    212. 

  212.    [OverallSaleVat] [decimal](17,2) NULL,
    213. 

  213.    [OverallSaleGross] [decimal](17,2) NULL,
    214. 

  214.    [FinanceAgreement] [varchar](30) NULL,
    215. 

  215.    [RadioSecurityCode] [varchar](10) NULL,
    216. 

  216.    [CDSecurityCode] [varchar](10) NULL,
    217. 

  217.    [PreviousVehicleNo] [varchar](6) NULL,
    218. 

  218.    [ExpectedPXReceipt] [datetime] NULL,
    219. 

  219.    [MarginVATRate] [decimal](6,2) NULL,
    220. 

  220.    [RecoverableValue001] [decimal](17,2) NULL,
    221. 

  221.    [RecoverableValue002] [decimal](17,2) NULL,
    222. 

  222.    [RecoverableValue003] [decimal](17,2) NULL,
    223. 

  223.    [RecoverableValue004] [decimal](17,2) NULL,
    224. 

  224.    [RecoverableValue005] [decimal](17,2) NULL,
    225. 

  225.    [RecoverableValue006] [decimal](17,2) NULL,
    226. 

  226.    [RecoverableValue007] [decimal](17,2) NULL,
    227. 

  227.    [RecoverableValue008] [decimal](17,2) NULL,
    228. 

  228.    [RecoverableValue009] [decimal](17,2) NULL,
    229. 

  229.    [RecoverableValue010] [decimal](17,2) NULL,
    230. 

  230.    [RecoverableValue011] [decimal](17,2) NULL,
    231. 

  231.    [RecoverableValue012] [decimal](17,2) NULL,
    232. 

  232.    [RecoverableValue013] [decimal](17,2) NULL,
    233. 

  233.    [RecoverableValue014] [decimal](17,2) NULL,
    234. 

  234.    [RecoverableValue015] [decimal](17,2) NULL,
    235. 

  235.    [AutosellLotNumber] [int] NULL,
    236. 

  236.    [CreditNoteDate] [datetime] NULL,
    237. 

  237.    [FleetnetCode] [varchar](30) NULL,
    238. 

  238.    [FleetnetID] [int] NULL,
    239. 

  239.    [InterCoTransRef] [varchar](10) NULL,
    240. 

  240.    [USTaxCodes001] [varchar](5) NULL,
    241. 

  241.    [USTaxCodes002] [varchar](5) NULL,
    242. 

  242.    [VSPostingCode] [varchar](1) NULL,
    243. 

  243.    [RecalculateVehicle] [varchar](1) NULL,
    244. 

  244.    [SupplierReference] [varchar](10) NULL,
    245. 

  245.    [CAPVehicleIDNo] [varchar](5) NULL,
    246. 

  246.    [RecoverableCost001] [decimal](17,2) NULL,
    247. 

  247.    [RecoverableCost002] [decimal](17,2) NULL,
    248. 

  248.    [RecoverableCost003] [decimal](17,2) NULL,
    249. 

  249.    [RecoverableCost004] [decimal](17,2) NULL,
    250. 

  250.    [RecoverableCost005] [decimal](17,2) NULL,
    251. 

  251.    [RecoverableCost006] [decimal](17,2) NULL,
    252. 

  252.    [RecoverableCost007] [decimal](17,2) NULL,
    253. 

  253.    [RecoverableCost008] [decimal](17,2) NULL,
    254. 

  254.    [RecoverableCost009] [decimal](17,2) NULL,
    255. 

  255.    [RecoverableCost010] [decimal](17,2) NULL,
    256. 

  256.    [RecoverableCost011] [decimal](17,2) NULL,
    257. 

  257.    [RecoverableCost012] [decimal](17,2) NULL,
    258. 

  258.    [RecoverableCost013] [decimal](17,2) NULL,
    259. 

  259.    [RecoverableCost014] [decimal](17,2) NULL,
    260. 

  260.    [RecoverableCost015] [decimal](17,2) NULL,
    261. 

  261.    [PreviousRegNumber] [varchar](20) NULL,
    262. 

  262.    [PreviousRegDate] [datetime] NULL,
    263. 

  263.    [PreviousRegPlace] [varchar](30) NULL,
    264. 

  264.    [StockCheckDate] [datetime] NULL,
    265. 

  265.    [StockCheckPerson] [varchar](8) NULL,
    266. 

  266.    [StockCheckRef] [varchar](6) NULL,
    267. 

  267.    [BuyingBranch] [varchar](3) NULL,
    268. 

  268.    [SellingBranch] [varchar](3) NULL,
    269. 

  269.    [CRMCustomerMagic] [int] NULL,
    270. 

  270.    [CRMVehicleMagic] [int] NULL,
    271. 

  271.    [StockSuspenseAC] [decimal](14,0) NULL,
    272. 

  272.    [CurrentPrevPrice] [varchar](1) NULL,
    273. 

  273.    [DatePriceEffective] [datetime] NULL,
    274. 

  274.    [EstimatedSalesVal] [decimal](17,2) NULL,
    275. 

  275.    [EstActCosts] [decimal](17,2) NULL,
    276. 

  276.    [Unit10] [decimal](4,0) NULL,
    277. 

  277.    [LifetimeCare] [tinyint] NULL,
    278. 

  278.    [ShortChassis] [varchar](30) NULL,
    279. 

  279.    [PurchaseVATCode] [varchar](1) NULL,
    280. 

  280.    [HeavyLightCommercl] [varchar](1) NULL,
    281. 

  281.    [CCBHP] [int] NULL,
    282. 

  282.    [DiscountValues001] [decimal](17,2) NULL,
    283. 

  283.    [DiscountValues002] [decimal](17,2) NULL,
    284. 

  284.    [DiscountValues003] [decimal](17,2) NULL,
    285. 

  285.    [DiscountValues004] [decimal](17,2) NULL,
    286. 

  286.    [DiscountValues005] [decimal](17,2) NULL,
    287. 

  287.    [DiscountValues006] [decimal](17,2) NULL,
    288. 

  288.    [DiscountValues007] [decimal](17,2) NULL,
    289. 

  289.    [DiscountValues008] [decimal](17,2) NULL,
    290. 

  290.    [DiscountValues009] [decimal](17,2) NULL,
    291. 

  291.    [DiscountValues010] [decimal](17,2) NULL,
    292. 

  292.    [DiscountValues011] [decimal](17,2) NULL,
    293. 

  293.    [DiscountValues012] [decimal](17,2) NULL,
    294. 

  294.    [DiscountValues013] [decimal](17,2) NULL,
    295. 

  295.    [DiscountValues014] [decimal](17,2) NULL,
    296. 

  296.    [DiscountValues015] [decimal](17,2) NULL,
    297. 

  297.    [VehicleDiscount] [decimal](17,2) NULL,
    298. 

  298.    [CurrencyCode] [varchar](3) NULL,
    299. 

  299.    [ExchangeRate] [decimal](12,5) NULL,
    300. 

  300.    [BulkInvoice] [tinyint] NULL,
    301. 

  301.    [AvailableForSale] [datetime] NULL,
    302. 

  302.    [ModelYear] [varchar](4) NULL,
    303. 

  303.    [ModelAnalysisCode] [varchar](6) NULL,
    304. 

  304.    [GenericColourCode] [varchar](3) NULL,
    305. 

  305.    [GenericTrimCode] [varchar](3) NULL,
    306. 

  306.    [CAPPricingCode] [varchar](26) NULL,
    307. 

  307.    [CAPKey] [varchar](20) NULL,
    308. 

  308.    [CAPYear] [varchar](4) NULL,
    309. 

  309.    [CAPRegLetter] [varchar](2) NULL,
    310. 

  310.    [FuelType] [varchar](1) NULL,
    311. 

  311.    [MileageOnSale] [decimal](10,0) NULL,
    312. 

  312.    [PXHPSettlements001] [decimal](17,2) NULL,
    313. 

  313.    [PXHPSettlements002] [decimal](17,2) NULL,
    314. 

  314.    [PXHPSettlements003] [decimal](17,2) NULL,
    315. 

  315.    [TotalPXSettlements] [decimal](17,2) NULL,
    316. 

  316.    [DeliveryTime] [varchar](5) NULL,
    317. 

  317.    [TransmissionType] [varchar](1) NULL,
    318. 

  318.    [RFLExpiryDate] [datetime] NULL,
    319. 

  319.    [OldFranchiseCode] [varchar](1) NULL,
    320. 

  320.    [OldModelCode] [varchar](15) NULL,
    321. 

  321.    [OldVariantCode] [varchar](15) NULL,
    322. 

  322.    [Client_DB] [varchar](50) NOT NULL
    323. 

  323.        DEFAULT ('1')
    324. 

  324. 

  325.    ,CONSTRAINT [VS_UsedVehicleStock$0] PRIMARY KEY CLUSTERED ([StockbookNumber], [Client_DB])
    326. 

  326. )
    327. 

  327. 

  328. 

  329. GO
    330.