Locosoft.icr 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255
  1. Kataloginformationen
  2. Katalog-Dateiname: C:\GlobalCube\System\LOCOSOFT\Catalogs\Locosoft.cat
  3. Beschreibung:
  4. Datenbankinformationen
  5. Datenbankname: GC_LOCOSOFT
  6. Verbindungszeichenkette: DSN=GC_LOCOSOFT;UID=%s;PWD=%s@ASYNC=0@0/0@COLSEQ=
  7. Datenbankstruktur
  8. Table: accounts_characteristics
  9. Spalte: skr51_branch (longint)
  10. Spalte: skr51_make (longint)
  11. Spalte: skr51_cost_center (longint)
  12. Spalte: skr51_sales_channel (longint)
  13. Spalte: skr51_cost_unit (longint)
  14. Spalte: skr51_brach_name (varchar)
  15. Spalte: skr51_make_description (varchar)
  16. Spalte: skr51_cost_center_name (varchar)
  17. Spalte: skr51_sales_channel_name (varchar)
  18. Spalte: skr51_cost_unit_name (varchar)
  19. Spalte: subsidiary_to_company_ref (longint)
  20. Table: customers_suppliers
  21. Spalte: customer_number (int)
  22. Spalte: is_supplier (varchar)
  23. Spalte: is_natural_person (varchar)
  24. Spalte: name_prefix (varchar)
  25. Spalte: first_name (varchar)
  26. Spalte: family_name (varchar)
  27. Spalte: name_postfix (varchar)
  28. Spalte: country_iso3166_alpha2 (varchar)
  29. Spalte: zip_code (varchar)
  30. Spalte: home_city (varchar)
  31. Spalte: parts_rebate_group_buy (int)
  32. Spalte: parts_rebate_group_sell (int)
  33. Spalte: rebate_labour_percent (decimal)
  34. Spalte: rebate_material_percent (decimal)
  35. Spalte: rebate_new_vehicles_percent (decimal)
  36. Spalte: cash_discount_percent (decimal)
  37. Spalte: vat_id_number (varchar)
  38. Table: document_types
  39. Spalte: document_type_in_journal (varchar)
  40. Spalte: document_type_description (varchar)
  41. Table: journal_accountings
  42. Spalte: accounting_date (date)
  43. Spalte: document_type (varchar)
  44. Spalte: document_number (longint)
  45. Spalte: position_in_document (longint)
  46. Spalte: customer_number (longint)
  47. Spalte: nominal_account_number (longint)
  48. Spalte: is_balanced (varchar)
  49. Spalte: clearing_number (longint)
  50. Spalte: document_date (date)
  51. Spalte: posted_value (longint)
  52. Spalte: debit_or_credit (varchar)
  53. Spalte: posted_count (longint)
  54. Spalte: branch_number (longint)
  55. Spalte: customer_contra_account (longint)
  56. Spalte: nominal_contra_account (longint)
  57. Spalte: contra_account_text (varchar)
  58. Spalte: account_form_page_number (longint)
  59. Spalte: account_form_page_line (longint)
  60. Spalte: serial_number_each_month (longint)
  61. Spalte: employee_number (longint)
  62. Spalte: invoice_date (date)
  63. Spalte: invoice_number (varchar)
  64. Spalte: dunning_level (varchar)
  65. Spalte: last_dunning_date (date)
  66. Spalte: journal_page (longint)
  67. Spalte: journal_line (longint)
  68. Spalte: cash_discount (longint)
  69. Spalte: term_of_payment (longint)
  70. Spalte: posting_text (varchar)
  71. Spalte: vehicle_reference (varchar)
  72. Spalte: vat_id_number (varchar)
  73. Spalte: account_statement_number (longint)
  74. Spalte: account_statement_page (longint)
  75. Spalte: vat_key (varchar)
  76. Spalte: days_for_cash_discount (longint)
  77. Spalte: day_of_actual_accounting (date)
  78. Spalte: skr51_branch (longint)
  79. Spalte: skr51_make (longint)
  80. Spalte: skr51_cost_center (longint)
  81. Spalte: skr51_sales_channel (longint)
  82. Spalte: skr51_cost_unit (longint)
  83. Spalte: previously_used_account_no (varchar)
  84. Spalte: free_form_accounting_text (varchar)
  85. Spalte: free_form_document_text (varchar)
  86. Spalte: subsidiary_to_company_ref (longint)
  87. Table: nominal_accounts
  88. Spalte: nominal_account_number (longint)
  89. Spalte: account_description (varchar)
  90. Spalte: is_profit_loss_account (varchar)
  91. Spalte: vat_key (varchar)
  92. Spalte: create_date (date)
  93. Spalte: create_employee_number (longint)
  94. Spalte: oldest_accountable_month (date)
  95. Spalte: subsidiary_to_company_ref (longint)
  96. Table: parts_rebate_groups_buy
  97. Spalte: code (int)
  98. Spalte: description (varchar)
  99. Table: parts_rebate_groups_sell
  100. Spalte: code (int)
  101. Spalte: description (varchar)
  102. Table: vat_keys
  103. Spalte: vat_key (varchar)
  104. Spalte: key_validity_date (date)
  105. Spalte: branch (longint)
  106. Spalte: description (varchar)
  107. Spalte: vat_rate (longint)
  108. Spalte: create_date (date)
  109. Spalte: vat_account (longint)
  110. Spalte: advanced_turnover_tax_pos (longint)
  111. Katalogordner
  112. Ordner: Accounts Characteristics
  113. Spalte: Skr51 Branch ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_branch], Zahl)
  114. Spalte: Skr51 Make ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_make], Zahl)
  115. Spalte: Skr51 Cost Center ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_center], Zahl)
  116. Spalte: Skr51 Sales Channel ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_sales_channel], Zahl)
  117. Spalte: Skr51 Cost Unit ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_unit], Zahl)
  118. Spalte: Skr51 Brach Name ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_brach_name], Zeichenkette)
  119. Spalte: Skr51 Make Description ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_make_description], Zeichenkette)
  120. Spalte: Skr51 Cost Center Name ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_center_name], Zeichenkette)
  121. Spalte: Skr51 Sales Channel Name ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_sales_channel_name], Zeichenkette)
  122. Spalte: Skr51 Cost Unit Name ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.skr51_cost_unit_name], Zeichenkette)
  123. Spalte: Subsidiary To Company Ref ([GC_LOCOSOFT.LOCOSOFT.dbo.accounts_characteristics.subsidiary_to_company_ref], Zahl)
  124. Ordner: Customers Suppliers
  125. Spalte: Customer Number ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.customer_number], Zahl)
  126. Spalte: Is Supplier ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.is_supplier], Zeichenkette)
  127. Spalte: Is Natural Person ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.is_natural_person], Zeichenkette)
  128. Spalte: Name Prefix ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.name_prefix], Zeichenkette)
  129. Spalte: First Name ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.first_name], Zeichenkette)
  130. Spalte: Family Name ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.family_name], Zeichenkette)
  131. Spalte: Name Postfix ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.name_postfix], Zeichenkette)
  132. Spalte: Country Iso3166 Alpha2 ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.country_iso3166_alpha2], Zeichenkette)
  133. Spalte: Zip Code ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.zip_code], Zeichenkette)
  134. Spalte: Home City ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.home_city], Zeichenkette)
  135. Spalte: Parts Rebate Group Buy ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.parts_rebate_group_buy], Zahl)
  136. Spalte: Parts Rebate Group Sell ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.parts_rebate_group_sell], Zahl)
  137. Spalte: Rebate Labour Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.rebate_labour_percent], Zahl)
  138. Spalte: Rebate Material Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.rebate_material_percent], Zahl)
  139. Spalte: Rebate New Vehicles Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.rebate_new_vehicles_percent], Zahl)
  140. Spalte: Cash Discount Percent ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.cash_discount_percent], Zahl)
  141. Spalte: Vat Id Number ([GC_LOCOSOFT.LOCOSOFT.dbo.customers_suppliers.vat_id_number], Zeichenkette)
  142. Ordner: Document Types
  143. Spalte: Document Type In Journal ([GC_LOCOSOFT.LOCOSOFT.dbo.document_types.document_type_in_journal], Zeichenkette)
  144. Spalte: Document Type Description ([GC_LOCOSOFT.LOCOSOFT.dbo.document_types.document_type_description], Zeichenkette)
  145. Ordner: Journal Accountings
  146. Spalte: Accounting Date ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.accounting_date], Datum)
  147. Spalte: Document Type ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.document_type], Zeichenkette)
  148. Spalte: Document Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.document_number], Zahl)
  149. Spalte: Position In Document ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.position_in_document], Zahl)
  150. Spalte: Customer Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.customer_number], Zahl)
  151. Spalte: Nominal Account Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.nominal_account_number], Zahl)
  152. Spalte: Is Balanced ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.is_balanced], Zeichenkette)
  153. Spalte: Clearing Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.clearing_number], Zahl)
  154. Spalte: Document Date ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.document_date], Datum)
  155. Spalte: Posted Value ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.posted_value], Zahl)
  156. Spalte: Debit Or Credit ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.debit_or_credit], Zeichenkette)
  157. Spalte: Posted Count ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.posted_count], Zahl)
  158. Spalte: Branch Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.branch_number], Zahl)
  159. Spalte: Customer Contra Account ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.customer_contra_account], Zahl)
  160. Spalte: Nominal Contra Account ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.nominal_contra_account], Zahl)
  161. Spalte: Contra Account Text ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.contra_account_text], Zeichenkette)
  162. Spalte: Account Form Page Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.account_form_page_number], Zahl)
  163. Spalte: Account Form Page Line ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.account_form_page_line], Zahl)
  164. Spalte: Serial Number Each Month ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.serial_number_each_month], Zahl)
  165. Spalte: Employee Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.employee_number], Zahl)
  166. Spalte: Invoice Date ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.invoice_date], Datum)
  167. Spalte: Invoice Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.invoice_number], Zeichenkette)
  168. Spalte: Dunning Level ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.dunning_level], Zeichenkette)
  169. Spalte: Last Dunning Date ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.last_dunning_date], Datum)
  170. Spalte: Journal Page ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.journal_page], Zahl)
  171. Spalte: Journal Line ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.journal_line], Zahl)
  172. Spalte: Cash Discount ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.cash_discount], Zahl)
  173. Spalte: Term Of Payment ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.term_of_payment], Zahl)
  174. Spalte: Posting Text ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.posting_text], Zeichenkette)
  175. Spalte: Vehicle Reference ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.vehicle_reference], Zeichenkette)
  176. Spalte: Vat Id Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.vat_id_number], Zeichenkette)
  177. Spalte: Account Statement Number ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.account_statement_number], Zahl)
  178. Spalte: Account Statement Page ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.account_statement_page], Zahl)
  179. Spalte: Vat Key ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.vat_key], Zeichenkette)
  180. Spalte: Days For Cash Discount ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.days_for_cash_discount], Zahl)
  181. Spalte: Day Of Actual Accounting ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.day_of_actual_accounting], Datum)
  182. Spalte: Skr51 Branch ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_branch], Zahl)
  183. Spalte: Skr51 Make ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_make], Zahl)
  184. Spalte: Skr51 Cost Center ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_cost_center], Zahl)
  185. Spalte: Skr51 Sales Channel ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_sales_channel], Zahl)
  186. Spalte: Skr51 Cost Unit ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.skr51_cost_unit], Zahl)
  187. Spalte: Previously Used Account No ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.previously_used_account_no], Zeichenkette)
  188. Spalte: Free Form Accounting Text ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.free_form_accounting_text], Zeichenkette)
  189. Spalte: Free Form Document Text ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.free_form_document_text], Zeichenkette)
  190. Spalte: Subsidiary To Company Ref ([GC_LOCOSOFT.LOCOSOFT.dbo.journal_accountings.subsidiary_to_company_ref], Zahl)
  191. Ordner: Nominal Accounts
  192. Spalte: Nominal Account Number ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.nominal_account_number], Zahl)
  193. Spalte: Account Description ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.account_description], Zeichenkette)
  194. Spalte: Is Profit Loss Account ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.is_profit_loss_account], Zeichenkette)
  195. Spalte: Vat Key ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.vat_key], Zeichenkette)
  196. Spalte: Create Date ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.create_date], Datum)
  197. Spalte: Create Employee Number ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.create_employee_number], Zahl)
  198. Spalte: Oldest Accountable Month ([GC_LOCOSOFT.LOCOSOFT.dbo.nominal_accounts.oldest_accountable_month], Datum)
  199. Ordner: Parts Rebate Groups Buy
  200. Spalte: Code ([GC_LOCOSOFT.LOCOSOFT.dbo.parts_rebate_groups_buy.code], Zahl)
  201. Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.parts_rebate_groups_buy.description], Zeichenkette)
  202. Ordner: Parts Rebate Groups Sell
  203. Spalte: Code ([GC_LOCOSOFT.LOCOSOFT.dbo.parts_rebate_groups_sell.code], Zahl)
  204. Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.parts_rebate_groups_sell.description], Zeichenkette)
  205. Ordner: Vat Keys
  206. Spalte: Vat Key ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.vat_key], Zeichenkette)
  207. Spalte: Key Validity Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.key_validity_date], Datum)
  208. Spalte: Branch ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.branch], Zahl)
  209. Spalte: Description ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.description], Zeichenkette)
  210. Spalte: Vat Rate ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.vat_rate], Zahl)
  211. Spalte: Create Date ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.create_date], Datum)
  212. Spalte: Vat Account ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.vat_account], Zahl)
  213. Spalte: Advanced Turnover Tax Pos ([GC_LOCOSOFT.LOCOSOFT.dbo.vat_keys.advanced_turnover_tax_pos], Zahl)
  214. Tabellenverbindungen:
  215. nominal_accounts - journal_accountings: Geschlossene Verbindung
  216. [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]
  217. accounts_characteristics - journal_accountings: Rechte offene Verbindung
  218. [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]
  219. 'Benutzerklasseninformationen
  220. Benutzerklasse: Ersteller
  221. Client/Server-Informationen
  222. Abfrageverarbeitung: Flexible Verarbeitung
  223. Verbindungsdauer minimieren: False
  224. Gouverneur-Informationen
  225. Neue Berichte erstellen: True
  226. Ordner hinzufügen/ändern: True
  227. Benutzerklassen hinzufügen/ändern: True
  228. SQL-Direkteingabe: True
  229. 'Über-Kreuz'-Produktabfragen: Verhindern
  230. Offene Verbindungen zulassen: Zulassen
  231. Sortieren an nicht-indizierten Spalten: Zulassen
  232. 'Select Distinct' zulassen: Zulassen
  233. Abruf der Zeilen aus der Datenbank beschränken
  234. Warnen bei: 0
  235. Stoppen bei: 0
  236. Abfrageausführungs-Zeitlimits
  237. Warnen bei: 0
  238. Stoppen bei: 0
  239. Tabellen-Limit je Bericht
  240. Warnen bei: 0
  241. Stoppen bei: 0
  242. Text-Blob-Limit: False
  243. Max. Text-Blob-Zeichen: nv