Table llx bordereau cheque - Revision history

Eldy: /* Structure */

2011-07-19T09:47:02Z

Structure

← Older revision		Revision as of 09:47, 19 July 2011
Line 16:		Line 16:
	= Structure =		= Structure =
	== Table ==		== Table ==
	~~'''Version 1.2 2009/10/23'''~~		{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
	{\| align="left" width="100%" border="0~~" rules="all~~" cellpadding="1" cellspacing="0" ~~style~~="~~margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5~~"
	\|style="background-color: #e9e9ef"\| <b>Field</b>		\|style="background-color: #e9e9ef"\| <b>Field</b>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\|style="background-color: #e9e9ef"\| <b>Type</b>
Line 116:		Line 115:

	== Keys ==		== Keys ==
	~~'''Version 1.1 2009/10/07'''~~		{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
	{\| align="left" width="100%" border="0~~" rules="all~~" cellpadding="1" cellspacing="0" ~~style~~="~~margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5~~"
	\|style="background-color: #e9e9ef"\| <b>Key</b>		\|style="background-color: #e9e9ef"\| <b>Key</b>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\|style="background-color: #e9e9ef"\| <b>Type</b>

Simnandez: /* Table */

2009-10-24T10:10:35Z

Table

← Older revision		Revision as of 10:10, 24 October 2009
Line 107:		Line 107:
	\|-		\|-
	\| statut		\| statut
	\| smallint~~(6)~~		\| smallint
	\| NO		\| NO
	\|		\|

Simnandez: /* Table */

2009-10-24T09:51:25Z

Table

← Older revision		Revision as of 09:51, 24 October 2009
Line 16:		Line 16:
	= Structure =		= Structure =
	== Table ==		== Table ==
	'''Version 1.1 2009/10/07'''		'''Version 1.2 2009/10/23'''
	{\| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"		{\| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
	\|style="background-color: #e9e9ef"\| <b>Field</b>		\|style="background-color: #e9e9ef"\| <b>Field</b>
Line 107:		Line 107:
	\|-		\|-
	\| statut		\| statut
	\| smallint(1)		\| smallint(6)
	\| NO		\| NO
	\|		\|
Line 114:		Line 114:
	\| Status of the checks receipts		\| Status of the checks receipts
	\|}		\|}

	== Keys ==		== Keys ==
	'''Version 1.1 2009/10/07'''		'''Version 1.1 2009/10/07'''

Simnandez: /* Structure */

2009-10-16T08:14:30Z

Structure

@@ Line 15: / Line 15: @@
 = Structure =
-'''Version 1.7 2009/05/07'''
+== Table ==
 {|  align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0"  style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
   |style="background-color: #e9e9ef"| <b>Field</b>
@@ Line 112: / Line 113: @@
+|
 | Status of the checks receipts
 |}&nbsp;

Simnandez: /* Structure */

2009-10-05T14:14:26Z

Structure

← Older revision		Revision as of 14:14, 5 October 2009
Line 112:		Line 112:
	\|		\|
	\| Status of the checks receipts		\| Status of the checks receipts
	\|}		\|}

Simnandez: /* Structure */

2009-10-01T13:13:35Z

Structure

← Older revision		Revision as of 13:13, 1 October 2009
Line 15:		Line 15:

	= Structure =		= Structure =
			'''Version 1.7 2009/05/07'''
	{\| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"		{\| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
	\|style="background-color: #e9e9ef"\| <b>Field</b>		\|style="background-color: #e9e9ef"\| <b>Field</b>
Line 26:		Line 27:
	\| rowid		\| rowid
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\| PRI		\| PRI
	\| NULL		\| NULL
Line 34:		Line 35:
	\|datec		\|datec
	\|datetime		\|datetime
	\|		\|NO
	\|		\|
	\|		\|
Line 50:		Line 51:
	\| number		\| number
	\| varchar(16)		\| varchar(16)
	\| ~~ ~~		\| NO
	\|		\| UNI
	\|		\|
	\|		\|
Line 58:		Line 59:
	\| entity		\| entity
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\|		\| UNI
	\| 1		\| 1
	\|		\|
Line 66:		Line 67:
	\| amount		\| amount
	\| double(24,8)		\| double(24,8)
	\| ~~ ~~		\| NO
	\|		\|
	\|		\|
Line 74:		Line 75:
	\| nbcheque		\| nbcheque
	\| smallint(6)		\| smallint(6)
	\| ~~ ~~		\| NO
	\|		\|
	\|		\|
Line 106:		Line 107:
	\| statut		\| statut
	\| smallint(1)		\| smallint(1)
	\|		\| NO
	\|		\|
	\| 0		\| 0

Simnandez: /* Contenu */

2009-05-23T16:05:31Z

Contenu

← Older revision		Revision as of 16:05, 23 May 2009
Line 6:		Line 6:
	{{ListOfTables}}		{{ListOfTables}}

	= Contenu =		= Content/Contenu/Contenido =

	{{flag en}} Contains the cheques receipts.		{{flag en}} Contains the cheques receipts.

Simnandez: /* Structure */

2009-05-22T15:17:19Z

Structure

← Older revision		Revision as of 15:17, 22 May 2009
Line 101:		Line 101:
	\| NULL		\| NULL
	\|		\|
	\| ~~Note~~		\| comments
	\|-		\|-
	\| statut		\| statut

Simnandez: /* Structure */

2009-05-22T14:45:13Z

Structure

← Older revision		Revision as of 14:45, 22 May 2009
Line 83:		Line 83:
	\| YES		\| YES
	\|		\|
	\| ~~NUKK~~		\| NULL
	\|		\|
	\| ID of Bank ([[Bank_account_(Table_SQL)\|llx_bank_account]]->rowid)		\| ID of Bank ([[Bank_account_(Table_SQL)\|llx_bank_account]]->rowid)

Simnandez: Created page with 'Category:Table SQL Category:Bank Category:Banque Category:Banco {{ListOfTables}} = Contenu = {{flag en}} Contains the cheques receipts. {{flag fr}} Contient le...'

2009-05-22T14:42:45Z

Created page with 'Category:Table SQL Category:Bank Category:Banque Category:Banco {{ListOfTables}} = Contenu = {{flag en}} Contains the cheques receipts. {{flag fr}} Contient le...'

New page

[[Category:Table SQL]]
[[Category:Bank]]
[[Category:Banque]]
[[Category:Banco]]

{{ListOfTables}}

= Contenu =
{{flag en}} Contains the cheques receipts.

{{flag fr}} Contient les bordereaux de remise de chèques.

{{flag sp}} Contiene las remesas bancarias.

= Structure =
{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
|style="background-color: #e9e9ef"| Field
|style="background-color: #e9e9ef"| Type
|style="background-color: #e9e9ef"| Null
|style="background-color: #e9e9ef"| Key
|style="background-color: #e9e9ef"| Default
|style="background-color: #e9e9ef"| Extra
|style="background-color: #e9e9ef"| Description
|-
| rowid
| int(11)
|  
| PRI
| NULL
| auto_increment
| technical index
|-
|datec
|datetime
|
| 
|
| 
|date of checks receipts creation
|-
| date_bordereau
| date
| YES
|
| NULL
|
| date of checks receipts typing
|-
| number
| varchar(16)
|  
|
|
|
| number
|-
| entity
| int(11)
|  
|
| 1
|
| multi company id
|-
| amount
| double(24,8)
|  
|
|
|
| amount of cheks receipts
|-
| nbcheque
| smallint(6)
|  
|
|
|
| number of cheks of the cheks receipts
|-
| fk_bank_account
| int(11)
| YES
|
| NUKK
|
| ID of Bank ([[Bank_account_(Table_SQL)|llx_bank_account]]->rowid)
|-
| fk_user_author
| int(11)
| YES
|
| NULL
|
| ID user author ([[Table llx_user|llx_user]]->rowid)
|-
| note
| text
| YES
|
| NULL
|
| Note
|-
| statut
| smallint(1)
|
|
| 0
|
| Status of the checks receipts
|}