Dolibarr ERP CRM Wiki

Table llx pos cash fence: Difference between revisions

VisualWikitext
(Created page with "Category:Table SQL {{ListOfTables}} = Content/Contenu/Contenido = {{flag en}} List of rejecteds standing orders {{flag fr}} Liste des bons de prélèvement rejetés {{...")
Tag: 2017 source edit
 
mNo edit summary
Tag: 2017 source edit
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
{{ListOfTables}}
{{ListOfTables}}


= Content/Contenu/Contenido =
=Content/Contenu/Contenido=


{{flag en}} List of rejecteds standing orders
{{flag en}} List of cash controls


{{flag fr}} Liste des bons de prélèvement rejetés
{{flag fr}} Liste des contrôles/clotures de caisse


{{flag sp}} Lista domiciliaciones rechazadas
{{flag sp}} Lista de cheques/cierres de caja


= Structure =
=Structure=
== Table ==
==Table==
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
{| class="dolbox" align="left" width="100%" border="0" cellpadding="1" cellspacing="0"
  |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>
  |style="background-color: #e9e9ef"| <b>Null</b>
  | style="background-color: #e9e9ef" |<b>Null</b>
  |style="background-color: #e9e9ef"| <b>Key</b>
  | style="background-color: #e9e9ef" |<b>Key</b>
  |style="background-color: #e9e9ef"| <b>Default</b>
  | style="background-color: #e9e9ef" |<b>Default</b>
  |style="background-color: #e9e9ef"| <b>Extra</b>
  | style="background-color: #e9e9ef" |<b>Extra</b>
  |style="background-color: #e9e9ef"| <b>Description</b>
  | style="background-color: #e9e9ef" |<b>Description</b>
|-  
|-  
| rowid  
|rowid
| int(11)  
|int(11)
| NO
|NO
| PRI
|PRI
|  
|
| auto_increment  
|auto_increment
| technical index
|technical index
|-
|-
| fk_prelevement_lignes
|entity
| int(11)
|int(11)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| ID of standig order line ([[Table llx_prelevement_lignes|llx_prelevement_lignes]]->rowid)
|ID of entity
|-
|-
| date_rejet
|ref
| datetime
|
| YES
|
|  
|
| NULL
|
|  
|
| date of reject
|
|-
|-
| motif
|label
| int(11)
|
| YES
|
|  
|
| NULL
|
|  
|
| ID of reject cause
|
|-
|-
| date_creation
|opening
| datetime
|
| YES
|
|  
|
| NULL
|
|  
|
| date of creation
|
|-
|-
| fk_user_creation
|cash
| int(11)  
|double(24,8)
| YES
|
|  
|
| NULL
|
|  
|
| ID of creator user ([[Table llx_user|llx_user]]->rowid)
|
|-
|-
| note
|card
| text
|double(24,8)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| comentary
|date of reject
|-
|-
| afacturer
|cheque
| tinyint(4)
|double(24,8)
| YES
|
|  
|
| 0
|
|  
|
| amount to billing
|
|-
|status
|int(11)
|YES
|
|0
|
|Status
|-
|date_creation
|datetime
|YES
|
|NULL
|
|date of creation
|-
|date_valid
|int(11)
|YES
|
|NULL
|
|date of validation of cash control
|-
|day_close
|integer
|YES
|
|NULL
|
|
|-
|month_close
|integer
|YES
|
|0
|
|
|-  
|-  
| fk_facture
|year_close
| int(11)  
|integer
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| ID of invoice ([[Table llx_facture|llx_facture]]->rowid)
|
|-
|posmodule
|varchar(30)
|
|
|
|
|Will contains 'takepos'  if this is a closing of a period of sales done with module Takepos
|-
|posnumber
|varchar(30)
|
|
|
|
|ID of terminal
|-
|fk_user_create
|integer
|
|
|
|
|ID of user ([[Table llx facture|llx_user]]->rowid)
|-
|fk_user_valid
|integer
|
|
|
|
|ID of user ([[Table llx facture|llx_user]]->rowid)
|}&nbsp;
|}&nbsp;
== Keys ==
==Keys==
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
{| class="dolbox" align="left" width="100%" border="0" cellpadding="1" cellspacing="0"
  |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>
  |style="background-color: #e9e9ef"| <b>Fields</b>
  | style="background-color: #e9e9ef" |<b>Fields</b>
|-  
|-  
| PRIMARY
|PRIMARY
| PRIMARY
|PRIMARY
| rowid
|rowid
|}&nbsp;
|}&nbsp;

Latest revision as of 02:51, 4 November 2025


En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


Content/Contenu/Contenido

  List of cash controls

  Liste des contrôles/clotures de caisse

  Lista de cheques/cierres de caja

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
entity int(11) YES NULL ID of entity
ref
label
opening
cash double(24,8)
card double(24,8) YES NULL date of reject
cheque double(24,8)
status int(11) YES 0 Status
date_creation datetime YES NULL date of creation
date_valid int(11) YES NULL date of validation of cash control
day_close integer YES NULL
month_close integer YES 0
year_close integer YES NULL
posmodule varchar(30) Will contains 'takepos' if this is a closing of a period of sales done with module Takepos
posnumber varchar(30) ID of terminal
fk_user_create integer ID of user (llx_user->rowid)
fk_user_valid integer ID of user (llx_user->rowid)

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid

 

Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_pos_cash_fence&oldid=64685"