Module Digirisk: Difference between revisions

Module Digirisk (view source)

973 bytes added , 5 years ago

93

edits

@@ Line 21: / Line 21: @@
 =Tables SQL=
-www.wiki.dolibarr.org/
+== Table ==
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+ |style="background-color: #e9e9ef"| <b>Field</b>
+ |style="background-color: #e9e9ef"| <b>Type</b>
+ |style="background-color: #e9e9ef"| <b>Null</b>
+ |style="background-color: #e9e9ef"| <b>Key</b>
+ |style="background-color: #e9e9ef"| <b>Default</b>
+ |style="background-color: #e9e9ef"| <b>Extra</b>
+ |style="background-color: #e9e9ef"| <b>Description</b>
+|-
+| rowid
+| int(11)
+| NO
+| PRI
+| NULL
+| auto_increment
+| technical index
+|-
+| fk_pcg_version
+| varchar(12)
+| NO
+| MUL
+|
+|
+| ID of pgc ([[Table llx_accountingsystem|llx_accountingsystem]]->pcg_version)
+|-
+| pcg_type
+| varchar(20)
+| NO
+|
+|
+|
+| type of pgc
+|-
+| pcg_subtype
+| varchar(20)
+| NO
+|
+|
+|
+| subtype of pgc
+|-
+| label
+| varchar(128)
+| NO
+|
+|
+|
+| label of account
+|-
+| account_number
+| varchar(20)
+| NO
+|
+|
+|
+| account number
+|-
+| account_parent
+| varchar(20)
+| YES
+|
+| NULL
+|
+| account parent
+|}&nbsp;
 =Installation=