Accueil Explorer Aide
S'inscrire Connexion
GlobalCube
/
C11
3
0
Fork 0
Fichiers Tickets 0 Pull Requests 0 Wiki
Aborescence: 5447efb09e
Branches Tags
C11
/
System
/
OPTIMA
/
SQL
/
schema
/
GC
/
tables
/
optima.Bilanzbelege_O21.sql

optima.Bilanzbelege_O21.sql 2.1 KB
Historique Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061 
  1. CREATE TABLE [optima].[Bilanzbelege_O21] (
    2. 

  2.    [Acct Nr] [varchar](100) NULL,
    3. 

  3.    [Ledger Accts Name] [varchar](100) NULL,
    4. 

  4.    [Ledger Accts Name2] [varchar](255) NULL,
    5. 

  5.    [Handler] [varchar](100) NULL,
    6. 

  6.    [Dept Split] [varchar](100) NULL,
    7. 

  7.    [Type Acctt] [varchar](100) NULL,
    8. 

  8.    [Acct No] [varchar](100) NULL,
    9. 

  9.    [Bookkeep Date] [datetime] NULL,
    10. 

  10.    [Bookkeep Period] [varchar](100) NULL,
    11. 

  11.    [Document No] [varchar](100) NULL,
    12. 

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

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

  14.    [Debit Amount] [decimal](28,8) NULL,
    15. 

  15.    [Credit Amount] [decimal](28,8) NULL,
    16. 

  16.    [Debit Quantity] [varchar](100) NULL,
    17. 

  17.    [Credit Quantity] [varchar](100) NULL,
    18. 

  18.    [Aa Trtype] [varchar](100) NULL,
    19. 

  19.    [Department] [varchar](100) NULL,
    20. 

  20.    [Stock] [varchar](100) NULL,
    21. 

  21.    [Make Family] [varchar](100) NULL,
    22. 

  22.    [Make] [varchar](100) NULL,
    23. 

  23.    [Vehicle Type] [varchar](100) NULL,
    24. 

  24.    [Model Line] [varchar](100) NULL,
    25. 

  25.    [Factory Model] [varchar](100) NULL,
    26. 

  26.    [Workshop Model] [varchar](100) NULL,
    27. 

  27.    [Product Group] [varchar](100) NULL,
    28. 

  28.    [Repair Group] [varchar](100) NULL,
    29. 

  29.    [Kit Group] [varchar](100) NULL,
    30. 

  30.    [Time Code] [varchar](100) NULL,
    31. 

  31.    [Int Voucher No] [varchar](100) NULL,
    32. 

  32.    [Balancing Mark] [varchar](100) NULL,
    33. 

  33.    [Used Veh Dest Code] [varchar](100) NULL,
    34. 

  34.    [Use Of Vehicle] [varchar](100) NULL,
    35. 

  35.    [Acct No Next Chart] [varchar](100) NULL,
    36. 

  36.    [Reference Ident] [varchar](100) NULL,
    37. 

  37.    [Transact Date] [datetime] NULL,
    38. 

  38.    [Handler2] [varchar](100) NULL,
    39. 

  39.    [Program] [varchar](100) NULL,
    40. 

  40.    [Function Code] [varchar](100) NULL,
    41. 

  41.    [Modul] [varchar](100) NULL,
    42. 

  42.    [Document Key] [varchar](100) NULL,
    43. 

  43.    [Comment] [varchar](200) NULL,
    44. 

  44.    [Department Type Id] [varchar](100) NULL,
    45. 

  45.    [Description] [varchar](100) NULL,
    46. 

  46.    [Department Group] [varchar](100) NULL,
    47. 

  47.    [Aa Trtype Id] [varchar](100) NULL,
    48. 

  48.    [Description2] [varchar](100) NULL,
    49. 

  49.    [Own Description] [varchar](100) NULL,
    50. 

  50.    [Rechtseinheit] [varchar](100) NULL,
    51. 

  51.    [Betrieb] [varchar](100) NULL,
    52. 

  52.    [Marke] [varchar](100) NULL,
    53. 

  53.    [Betrag] [decimal](28,8) NULL,
    54. 

  54.    [Menge] [varchar](100) NULL,
    55. 

  55.    [Mandant] [varchar](100) NULL,
    56. 

  56.    [Susa] [varchar](100) NULL,
    57. 

  57.    [Text] [varchar](100) NULL
    58. 

  58. )
    59. 

  59. 

  60. 

  61. GO
    62.