API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 22nd, 2017
69
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 4.38 KB | None | 0 0
raw download clone embed print report
  1.  INSERT INTO [dbo].[DocumentHeaders]([Name]
  2.       ,[FullName]
  3.       ,[DocType]
  4.       ,[HeaderScheme]
  5.       ,[NumberingInterval]
  6.       ,[IsActive])
  7.       values('FVZ', 'Faktura VAT Zakupu', 1, 'FVZ/#n4#/#M#/#Y#', 1, 1)
  8.      
  9.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  10.       ,[FullName]
  11.       ,[DocType]
  12.       ,[HeaderScheme]
  13.       ,[NumberingInterval]
  14.       ,[IsActive])
  15.       values('PZ', 'Przyjęcie Zewnętrzne', 2, 'PZ/#n4#/#M#/#Y#', 1, 1)
  16.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  17.       ,[FullName]
  18.       ,[DocType]
  19.       ,[HeaderScheme]
  20.       ,[NumberingInterval]
  21.       ,[IsActive])
  22.       values('WZ', 'Wydanie Zewnętrzne', 3, 'WZ/#n4#/#M#/#Y#', 1, 1)
  23.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  24.       ,[FullName]
  25.       ,[DocType]
  26.       ,[HeaderScheme]
  27.       ,[NumberingInterval]
  28.       ,[IsActive])
  29.       values('FVS', 'Faktura VAT Sprzedaży', 4, 'FVS/#n4#/#M#/#Y#', 1, 1)
  30.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  31.       ,[FullName]
  32.       ,[DocType]
  33.       ,[HeaderScheme]
  34.       ,[NumberingInterval]
  35.       ,[IsActive])
  36.       values('PW', 'Przyjęcie Wewnętrzne', 5, 'PW/#n4#/#M#/#Y#', 1, 1)
  37.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  38.       ,[FullName]
  39.       ,[DocType]
  40.       ,[HeaderScheme]
  41.       ,[NumberingInterval]
  42.       ,[IsActive])
  43.       values('RW', 'Rozchód Wewnętrzny', 6, 'RW/#n4#/#M#/#Y#', 1, 1)
  44.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  45.       ,[FullName]
  46.       ,[DocType]
  47.       ,[HeaderScheme]
  48.       ,[NumberingInterval]
  49.       ,[IsActive])
  50.       values('MM-', 'Przesunięcie Międzymagazynowe Minus', 7, 'MM-/#n4#/#M#/#Y#', 1, 1)
  51.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  52.       ,[FullName]
  53.       ,[DocType]
  54.       ,[HeaderScheme]
  55.       ,[NumberingInterval]
  56.       ,[IsActive])
  57.       values('MM+', 'Przesunięcie Międzymagazynowe Plus', 8, 'MM+/#n4#/#M#/#Y#', 1, 1)
  58.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  59.       ,[FullName]
  60.       ,[DocType]
  61.       ,[HeaderScheme]
  62.       ,[NumberingInterval]
  63.       ,[IsActive])
  64.       values('InPlus', 'Inwentura In Plus', 9, 'In+/#n4#/#M#/#Y#', 1, 1)
  65.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  66.       ,[FullName]
  67.       ,[DocType]
  68.       ,[HeaderScheme]
  69.       ,[NumberingInterval]
  70.       ,[IsActive])
  71.       values('InMinus', 'Inwentura In Minus', 10, 'In-/#n4#/#M#/#Y#', 1, 1)
  72.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  73.       ,[FullName]
  74.       ,[DocType]
  75.       ,[HeaderScheme]
  76.       ,[NumberingInterval]
  77.       ,[IsActive])
  78.       values('FVZK', 'Faktura VAT Zakupu Korekta', 11, 'FVZK/#n4#/#M#/#Y#', 1, 1)
  79.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  80.       ,[FullName]
  81.       ,[DocType]
  82.       ,[HeaderScheme]
  83.       ,[NumberingInterval]
  84.       ,[IsActive])
  85.       values('PZK', 'Przyjęcie Zewnętrzne Korekta', 12, 'PZK/#n4#/#M#/#Y#', 1, 1)
  86.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  87.       ,[FullName]
  88.       ,[DocType]
  89.       ,[HeaderScheme]
  90.       ,[NumberingInterval]
  91.       ,[IsActive])
  92.       values('WZK', 'Wydanie Zewnętrzne Korekta', 13, 'WZK/#n4#/#M#/#Y#', 1, 1)
  93.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  94.       ,[FullName]
  95.       ,[DocType]
  96.       ,[HeaderScheme]
  97.       ,[NumberingInterval]
  98.       ,[IsActive])
  99.       values('FVSK', 'Faktura VAT Sprzedaży Korekta', 14, 'FVSK/#n4#/#M#/#Y#', 1, 1)
  100.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  101.       ,[FullName]
  102.       ,[DocType]
  103.       ,[HeaderScheme]
  104.       ,[NumberingInterval]
  105.       ,[IsActive])
  106.       values('PWK', 'Przyjęcie Wewnętrzne Korekta', 15, 'PWK/#n4#/#M#/#Y#', 1, 1)
  107.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  108.       ,[FullName]
  109.       ,[DocType]
  110.       ,[HeaderScheme]
  111.       ,[NumberingInterval]
  112.       ,[IsActive])
  113.       values('RWK', 'Rozchód Wewnętrzny Korekta', 16, 'RWK/#n4#/#M#/#Y#', 1, 1)
  114.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  115.       ,[FullName]
  116.       ,[DocType]
  117.       ,[HeaderScheme]
  118.       ,[NumberingInterval]
  119.       ,[IsActive])
  120.       values('MMK-', 'Przesunięcie Międzymagazynowe Minus Korekta', 17, 'MMK-/#n4#/#M#/#Y#', 1, 1)
  121.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  122.       ,[FullName]
  123.       ,[DocType]
  124.       ,[HeaderScheme]
  125.       ,[NumberingInterval]
  126.       ,[IsActive])
  127.       values('MMK+', 'Przesunięcie Międzymagazynowe Plus Korekta', 18, 'MMK+/#n4#/#M#/#Y#', 1, 1)
  128.        INSERT INTO [dbo].[DocumentHeaders]([Name]
  129.       ,[FullName]
  130.       ,[DocType]
  131.       ,[HeaderScheme]
  132.       ,[NumberingInterval]
  133.       ,[IsActive])
  134.       values('Inwentura', 'Inwentura', 19, 'Inwentura/#n4#/#M#/#Y#', 1, 1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!