首页 发现 帮助
注册 登录
GlobalCube
/
C11
3
0
派生 0
文件 工单管理 0 合并请求 0 Wiki
目录树: 9eb59ecb4b
分支列表 标签列表
C11
/
System
/
LOCOSOFT
/
Catalogs
/
Locosoft.icr

Locosoft.icr 16 KB
文件历史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255 
  1. Kataloginformationen
    2. 

  2. 	Katalog-Dateiname: C:\GlobalCube\System\LOCOSOFT\Catalogs\Locosoft.cat
    3. 

  3. 	Beschreibung:      
    4. 

  4. 

  5. Datenbankinformationen
    6. 

  6. 	Datenbankname: GC_LOCOSOFT
    7. 

  7. 	Verbindungszeichenkette:  DSN=GC_LOCOSOFT;UID=%s;PWD=%s@ASYNC=0@0/0@COLSEQ=
    8. 

  8. 

  9. Datenbankstruktur
    10. 

  10. 

  11. 	Table: accounts_characteristics
    12. 

  12. 		Spalte: skr51_branch  (longint)
    13. 

  13. 		Spalte: skr51_make  (longint)
    14. 

  14. 		Spalte: skr51_cost_center  (longint)
    15. 

  15. 		Spalte: skr51_sales_channel  (longint)
    16. 

  16. 		Spalte: skr51_cost_unit  (longint)
    17. 

  17. 		Spalte: skr51_brach_name  (varchar)
    18. 

  18. 		Spalte: skr51_make_description  (varchar)
    19. 

  19. 		Spalte: skr51_cost_center_name  (varchar)
    20. 

  20. 		Spalte: skr51_sales_channel_name  (varchar)
    21. 

  21. 		Spalte: skr51_cost_unit_name  (varchar)
    22. 

  22. 		Spalte: subsidiary_to_company_ref  (longint)
    23. 

  23. 	Table: customers_suppliers
    24. 

  24. 		Spalte: customer_number  (int)
    25. 

  25. 		Spalte: is_supplier  (varchar)
    26. 

  26. 		Spalte: is_natural_person  (varchar)
    27. 

  27. 		Spalte: name_prefix  (varchar)
    28. 

  28. 		Spalte: first_name  (varchar)
    29. 

  29. 		Spalte: family_name  (varchar)
    30. 

  30. 		Spalte: name_postfix  (varchar)
    31. 

  31. 		Spalte: country_iso3166_alpha2  (varchar)
    32. 

  32. 		Spalte: zip_code  (varchar)
    33. 

  33. 		Spalte: home_city  (varchar)
    34. 

  34. 		Spalte: parts_rebate_group_buy  (int)
    35. 

  35. 		Spalte: parts_rebate_group_sell  (int)
    36. 

  36. 		Spalte: rebate_labour_percent  (decimal)
    37. 

  37. 		Spalte: rebate_material_percent  (decimal)
    38. 

  38. 		Spalte: rebate_new_vehicles_percent  (decimal)
    39. 

  39. 		Spalte: cash_discount_percent  (decimal)
    40. 

  40. 		Spalte: vat_id_number  (varchar)
    41. 

  41. 	Table: document_types
    42. 

  42. 		Spalte: document_type_in_journal  (varchar)
    43. 

  43. 		Spalte: document_type_description  (varchar)
    44. 

  44. 	Table: journal_accountings
    45. 

  45. 		Spalte: accounting_date  (date)
    46. 

  46. 		Spalte: document_type  (varchar)
    47. 

  47. 		Spalte: document_number  (longint)
    48. 

  48. 		Spalte: position_in_document  (longint)
    49. 

  49. 		Spalte: customer_number  (longint)
    50. 

  50. 		Spalte: nominal_account_number  (longint)
    51. 

  51. 		Spalte: is_balanced  (varchar)
    52. 

  52. 		Spalte: clearing_number  (longint)
    53. 

  53. 		Spalte: document_date  (date)
    54. 

  54. 		Spalte: posted_value  (longint)
    55. 

  55. 		Spalte: debit_or_credit  (varchar)
    56. 

  56. 		Spalte: posted_count  (longint)
    57. 

  57. 		Spalte: branch_number  (longint)
    58. 

  58. 		Spalte: customer_contra_account  (longint)
    59. 

  59. 		Spalte: nominal_contra_account  (longint)
    60. 

  60. 		Spalte: contra_account_text  (varchar)
    61. 

  61. 		Spalte: account_form_page_number  (longint)
    62. 

  62. 		Spalte: account_form_page_line  (longint)
    63. 

  63. 		Spalte: serial_number_each_month  (longint)
    64. 

  64. 		Spalte: employee_number  (longint)
    65. 

  65. 		Spalte: invoice_date  (date)
    66. 

  66. 		Spalte: invoice_number  (varchar)
    67. 

  67. 		Spalte: dunning_level  (varchar)
    68. 

  68. 		Spalte: last_dunning_date  (date)
    69. 

  69. 		Spalte: journal_page  (longint)
    70. 

  70. 		Spalte: journal_line  (longint)
    71. 

  71. 		Spalte: cash_discount  (longint)
    72. 

  72. 		Spalte: term_of_payment  (longint)
    73. 

  73. 		Spalte: posting_text  (varchar)
    74. 

  74. 		Spalte: vehicle_reference  (varchar)
    75. 

  75. 		Spalte: vat_id_number  (varchar)
    76. 

  76. 		Spalte: account_statement_number  (longint)
    77. 

  77. 		Spalte: account_statement_page  (longint)
    78. 

  78. 		Spalte: vat_key  (varchar)
    79. 

  79. 		Spalte: days_for_cash_discount  (longint)
    80. 

  80. 		Spalte: day_of_actual_accounting  (date)
    81. 

  81. 		Spalte: skr51_branch  (longint)
    82. 

  82. 		Spalte: skr51_make  (longint)
    83. 

  83. 		Spalte: skr51_cost_center  (longint)
    84. 

  84. 		Spalte: skr51_sales_channel  (longint)
    85. 

  85. 		Spalte: skr51_cost_unit  (longint)
    86. 

  86. 		Spalte: previously_used_account_no  (varchar)
    87. 

  87. 		Spalte: free_form_accounting_text  (varchar)
    88. 

  88. 		Spalte: free_form_document_text  (varchar)
    89. 

  89. 		Spalte: subsidiary_to_company_ref  (longint)
    90. 

  90. 	Table: nominal_accounts
    91. 

  91. 		Spalte: nominal_account_number  (longint)
    92. 

  92. 		Spalte: account_description  (varchar)
    93. 

  93. 		Spalte: is_profit_loss_account  (varchar)
    94. 

  94. 		Spalte: vat_key  (varchar)
    95. 

  95. 		Spalte: create_date  (date)
    96. 

  96. 		Spalte: create_employee_number  (longint)
    97. 

  97. 		Spalte: oldest_accountable_month  (date)
    98. 

  98. 		Spalte: subsidiary_to_company_ref  (longint)
    99. 

  99. 	Table: parts_rebate_groups_buy
    100. 

  100. 		Spalte: code  (int)
    101. 

  101. 		Spalte: description  (varchar)
    102. 

  102. 	Table: parts_rebate_groups_sell
    103. 

  103. 		Spalte: code  (int)
    104. 

  104. 		Spalte: description  (varchar)
    105. 

  105. 	Table: vat_keys
    106. 

  106. 		Spalte: vat_key  (varchar)
    107. 

  107. 		Spalte: key_validity_date  (date)
    108. 

  108. 		Spalte: branch  (longint)
    109. 

  109. 		Spalte: description  (varchar)
    110. 

  110. 		Spalte: vat_rate  (longint)
    111. 

  111. 		Spalte: create_date  (date)
    112. 

  112. 		Spalte: vat_account  (longint)
    113. 

  113. 		Spalte: advanced_turnover_tax_pos  (longint)
    114. 

  114. 

  115. Katalogordner
    116. 

  116. 

  117. 	Ordner: Accounts Characteristics
    118. 

  118. 		Spalte: Skr51 Branch ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_branch], Zahl)
    119. 

  119. 		Spalte: Skr51 Make ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_make], Zahl)
    120. 

  120. 		Spalte: Skr51 Cost Center ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_center], Zahl)
    121. 

  121. 		Spalte: Skr51 Sales Channel ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_sales_channel], Zahl)
    122. 

  122. 		Spalte: Skr51 Cost Unit ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_unit], Zahl)
    123. 

  123. 		Spalte: Skr51 Brach Name ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_brach_name], Zeichenkette)
    124. 

  124. 		Spalte: Skr51 Make Description ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_make_description], Zeichenkette)
    125. 

  125. 		Spalte: Skr51 Cost Center Name ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_center_name], Zeichenkette)
    126. 

  126. 		Spalte: Skr51 Sales Channel Name ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_sales_channel_name], Zeichenkette)
    127. 

  127. 		Spalte: Skr51 Cost Unit Name ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_unit_name], Zeichenkette)
    128. 

  128. 		Spalte: Subsidiary To Company Ref ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.subsidiary_to_company_ref], Zahl)
    129. 

  129. 	Ordner: Customers Suppliers
    130. 

  130. 		Spalte: Customer Number ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.customer_number], Zahl)
    131. 

  131. 		Spalte: Is Supplier ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.is_supplier], Zeichenkette)
    132. 

  132. 		Spalte: Is Natural Person ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.is_natural_person], Zeichenkette)
    133. 

  133. 		Spalte: Name Prefix ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.name_prefix], Zeichenkette)
    134. 

  134. 		Spalte: First Name ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.first_name], Zeichenkette)
    135. 

  135. 		Spalte: Family Name ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.family_name], Zeichenkette)
    136. 

  136. 		Spalte: Name Postfix ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.name_postfix], Zeichenkette)
    137. 

  137. 		Spalte: Country Iso3166 Alpha2 ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.country_iso3166_alpha2], Zeichenkette)
    138. 

  138. 		Spalte: Zip Code ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.zip_code], Zeichenkette)
    139. 

  139. 		Spalte: Home City ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.home_city], Zeichenkette)
    140. 

  140. 		Spalte: Parts Rebate Group Buy ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.parts_rebate_group_buy], Zahl)
    141. 

  141. 		Spalte: Parts Rebate Group Sell ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.parts_rebate_group_sell], Zahl)
    142. 

  142. 		Spalte: Rebate Labour Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.rebate_labour_percent], Zahl)
    143. 

  143. 		Spalte: Rebate Material Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.rebate_material_percent], Zahl)
    144. 

  144. 		Spalte: Rebate New Vehicles Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.rebate_new_vehicles_percent], Zahl)
    145. 

  145. 		Spalte: Cash Discount Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.cash_discount_percent], Zahl)
    146. 

  146. 		Spalte: Vat Id Number ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.vat_id_number], Zeichenkette)
    147. 

  147. 	Ordner: Document Types
    148. 

  148. 		Spalte: Document Type In Journal ([GC_LOCOSOFT.LOCOSOFT.dbo.document_types.document_type_in_journal], Zeichenkette)
    149. 

  149. 		Spalte: Document Type Description ([GC_LOCOSOFT.LOCOSOFT.dbo.document_types.document_type_description], Zeichenkette)
    150. 

  150. 	Ordner: Journal Accountings
    151. 

  151. 		Spalte: Accounting Date ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.accounting_date], Datum)
    152. 

  152. 		Spalte: Document Type ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.document_type], Zeichenkette)
    153. 

  153. 		Spalte: Document Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.document_number], Zahl)
    154. 

  154. 		Spalte: Position In Document ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.position_in_document], Zahl)
    155. 

  155. 		Spalte: Customer Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.customer_number], Zahl)
    156. 

  156. 		Spalte: Nominal Account Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.nominal_account_number], Zahl)
    157. 

  157. 		Spalte: Is Balanced ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.is_balanced], Zeichenkette)
    158. 

  158. 		Spalte: Clearing Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.clearing_number], Zahl)
    159. 

  159. 		Spalte: Document Date ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.document_date], Datum)
    160. 

  160. 		Spalte: Posted Value ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.posted_value], Zahl)
    161. 

  161. 		Spalte: Debit Or Credit ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.debit_or_credit], Zeichenkette)
    162. 

  162. 		Spalte: Posted Count ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.posted_count], Zahl)
    163. 

  163. 		Spalte: Branch Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.branch_number], Zahl)
    164. 

  164. 		Spalte: Customer Contra Account ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.customer_contra_account], Zahl)
    165. 

  165. 		Spalte: Nominal Contra Account ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.nominal_contra_account], Zahl)
    166. 

  166. 		Spalte: Contra Account Text ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.contra_account_text], Zeichenkette)
    167. 

  167. 		Spalte: Account Form Page Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.account_form_page_number], Zahl)
    168. 

  168. 		Spalte: Account Form Page Line ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.account_form_page_line], Zahl)
    169. 

  169. 		Spalte: Serial Number Each Month ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.serial_number_each_month], Zahl)
    170. 

  170. 		Spalte: Employee Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.employee_number], Zahl)
    171. 

  171. 		Spalte: Invoice Date ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.invoice_date], Datum)
    172. 

  172. 		Spalte: Invoice Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.invoice_number], Zeichenkette)
    173. 

  173. 		Spalte: Dunning Level ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.dunning_level], Zeichenkette)
    174. 

  174. 		Spalte: Last Dunning Date ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.last_dunning_date], Datum)
    175. 

  175. 		Spalte: Journal Page ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.journal_page], Zahl)
    176. 

  176. 		Spalte: Journal Line ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.journal_line], Zahl)
    177. 

  177. 		Spalte: Cash Discount ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.cash_discount], Zahl)
    178. 

  178. 		Spalte: Term Of Payment ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.term_of_payment], Zahl)
    179. 

  179. 		Spalte: Posting Text ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.posting_text], Zeichenkette)
    180. 

  180. 		Spalte: Vehicle Reference ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.vehicle_reference], Zeichenkette)
    181. 

  181. 		Spalte: Vat Id Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.vat_id_number], Zeichenkette)
    182. 

  182. 		Spalte: Account Statement Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.account_statement_number], Zahl)
    183. 

  183. 		Spalte: Account Statement Page ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.account_statement_page], Zahl)
    184. 

  184. 		Spalte: Vat Key ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.vat_key], Zeichenkette)
    185. 

  185. 		Spalte: Days For Cash Discount ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.days_for_cash_discount], Zahl)
    186. 

  186. 		Spalte: Day Of Actual Accounting ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.day_of_actual_accounting], Datum)
    187. 

  187. 		Spalte: Skr51 Branch ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_branch], Zahl)
    188. 

  188. 		Spalte: Skr51 Make ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_make], Zahl)
    189. 

  189. 		Spalte: Skr51 Cost Center ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_cost_center], Zahl)
    190. 

  190. 		Spalte: Skr51 Sales Channel ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_sales_channel], Zahl)
    191. 

  191. 		Spalte: Skr51 Cost Unit ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_cost_unit], Zahl)
    192. 

  192. 		Spalte: Previously Used Account No ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.previously_used_account_no], Zeichenkette)
    193. 

  193. 		Spalte: Free Form Accounting Text ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.free_form_accounting_text], Zeichenkette)
    194. 

  194. 		Spalte: Free Form Document Text ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.free_form_document_text], Zeichenkette)
    195. 

  195. 		Spalte: Subsidiary To Company Ref ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.subsidiary_to_company_ref], Zahl)
    196. 

  196. 	Ordner: Nominal Accounts
    197. 

  197. 		Spalte: Nominal Account Number ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.nominal_account_number], Zahl)
    198. 

  198. 		Spalte: Account Description ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.account_description], Zeichenkette)
    199. 

  199. 		Spalte: Is Profit Loss Account ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.is_profit_loss_account], Zeichenkette)
    200. 

  200. 		Spalte: Vat Key ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.vat_key], Zeichenkette)
    201. 

  201. 		Spalte: Create Date ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.create_date], Datum)
    202. 

  202. 		Spalte: Create Employee Number ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.create_employee_number], Zahl)
    203. 

  203. 		Spalte: Oldest Accountable Month ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.oldest_accountable_month], Datum)
    204. 

  204. 	Ordner: Parts Rebate Groups Buy
    205. 

  205. 		Spalte: Code ([GC_LOCOSOFT.LOCOSOFT.dbo.parts_rebate_groups_buy.code], Zahl)
    206. 

  206. 		Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.parts_rebate_groups_buy.description], Zeichenkette)
    207. 

  207. 	Ordner: Parts Rebate Groups Sell
    208. 

  208. 		Spalte: Code ([GC_LOCOSOFT.LOCOSOFT.dbo.parts_rebate_groups_sell.code], Zahl)
    209. 

  209. 		Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.parts_rebate_groups_sell.description], Zeichenkette)
    210. 

  210. 	Ordner: Vat Keys
    211. 

  211. 		Spalte: Vat Key ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.vat_key], Zeichenkette)
    212. 

  212. 		Spalte: Key Validity Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.key_validity_date], Datum)
    213. 

  213. 		Spalte: Branch ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.branch], Zahl)
    214. 

  214. 		Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.description], Zeichenkette)
    215. 

  215. 		Spalte: Vat Rate ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.vat_rate], Zahl)
    216. 

  216. 		Spalte: Create Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.create_date], Datum)
    217. 

  217. 		Spalte: Vat Account ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.vat_account], Zahl)
    218. 

  218. 		Spalte: Advanced Turnover Tax Pos ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.advanced_turnover_tax_pos], Zahl)
    219. 

  219. 

  220. Tabellenverbindungen: 
    221. 

  221. 

  222. 	nominal_accounts - journal_accountings: Geschlossene Verbindung
    223. 

  223. 	[GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.nominal_account_number] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.nominal_account_number] UND [GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.subsidiary_to_company_ref] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.subsidiary_to_company_ref]
    224. 

  224. 

  225. 	accounts_characteristics - journal_accountings: Rechte offene Verbindung
    226. 

  226. 	[GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.subsidiary_to_company_ref] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.subsidiary_to_company_ref] UND [GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_branch] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_branch] UND [GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_make] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_make] UND [GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_center] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_cost_center] UND [GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_sales_channel] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_sales_channel] UND [GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_unit] = [GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_cost_unit]
    227. 

  227. 

  228. 'Benutzerklasseninformationen
    229. 

  229. 

  230. 	Benutzerklasse: Ersteller
    231. 

  231. 		Client/Server-Informationen
    232. 

  232. 			Abfrageverarbeitung: Flexible Verarbeitung
    233. 

  233. 			Verbindungsdauer minimieren: False
    234. 

  234. 

  235. 		Gouverneur-Informationen
    236. 

  236. 			Neue Berichte erstellen: True
    237. 

  237. 			Ordner hinzufügen/ändern: True
    238. 

  238. 			Benutzerklassen hinzufügen/ändern: True
    239. 

  239. 			SQL-Direkteingabe: True
    240. 

  240. 			'Über-Kreuz'-Produktabfragen: Verhindern
    241. 

  241. 			Offene Verbindungen zulassen: Zulassen
    242. 

  242. 			Sortieren an nicht-indizierten Spalten: Zulassen
    243. 

  243. 			'Select Distinct' zulassen: Zulassen
    244. 

  244. 			Abruf der Zeilen aus der Datenbank beschränken
    245. 

  245. 				Warnen bei: 0
    246. 

  246. 				Stoppen bei: 0
    247. 

  247. 			Abfrageausführungs-Zeitlimits
    248. 

  248. 				Warnen bei: 0
    249. 

  249. 				Stoppen bei: 0
    250. 

  250. 			Tabellen-Limit je Bericht
    251. 

  251. 				Warnen bei: 0
    252. 

  252. 				Stoppen bei: 0
    253. 

  253. 			Text-Blob-Limit: False
    254. 

  254. 			Max. Text-Blob-Zeichen: nv
    255. 

  255.