Table llx pos cash fence: Difference between revisions

Jump to navigation Jump to search

Table llx pos cash fence (view source)

Revision as of 02:48, 4 November 2025

35 bytes added ,  1 year ago
m
no edit summary
VisualWikitext
m (Eldy moved page Table llx pos cashfence to Table llx pos cash fence without leaving a redirect)
mNo edit summary
Line 2: Line 2:
{{ListOfTables}}
{{ListOfTables}}


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


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


{{flag fr}} Liste des bons de prélèvement rejetés
{{flag fr}}
Liste des bons de prélèvement rejetés


{{flag sp}} Lista domiciliaciones rechazadas
{{flag sp}}
Lista domiciliaciones rechazadas


= 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
|
|
|
|
|Will contains 'takepos'  if this is a closing of a period of sales done with module Takepos
|-
|posnumber
|
|
|
|
|
|ID of terminal
|-
|
|
|
|
|
|
|
|}&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;
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/64683"

Navigation menu