Content
CyberPlanet has the possibility to access the billing information in the database in real time. For this a group of Views configured on the MySql server are available.
Connection to MySql base
User: admin_reportes
Port: 51897
Password:
- CyberPlanet 6.5.0.110 or preview:
The password is that of the user "admin" of CyberPlanet. - CyberPlanet 6.5.0.112 or later:
The password is configured in PC Menu Server, Configuration, Security, Administration/Operators, "Remote Access to Views"
Data access
View: view_tickets
Returns the tickets issued.
| Field | Type | Comment |
|---|---|---|
| TicketNo | INT(11) | Ticket number, auto-incremental. |
| CashNo | INT(11) | Box number on which the ticket was issued |
| Cashier | VARCHAR(20) | Cashier’s Name |
CategoryINT | INT(11) | id Category |
| CategorySTR | VARCHAR(100) | Category |
| Quantity | INT(11) | Quantity |
| Details | VARCHAR(103) | Details |
| unit_price | DECIMAL(22,8) | Unit price |
| Discount | DECIMAL(19,4) | discount amount |
| total | DECIMAL(18,4) | Total receivable |
| DateTime_consumed | DATETIME | Date and time of consumption |
| DateTime_ticket | DATETIME | Date and time of ticket issuance |
| duration | TIME | Duration, in the case of meetings |
| pc | SMALLINT(6) | Number of PCs of consumption |
| PosNo | INT(11) | POS number. "0" is PC Server. |
A ticket can contain multiple records, so it must be grouped by 'TicketNo' field to know the total of each ticket.
Examples:
1) Tickets with your cash amount 1
SELECT ticketNo , SUM(T.total) AS Importe from view_tickets T WHERE T.CashNo=1 GROUP BY ticketno
Table of categories of tickets
View: view_notascredito
Returns the credit notes issued.
| Field | Type | Comment |
|---|---|---|
| TicketNo | INT(11) | Ticket vinculado a la nota de crédito |
| CashNo | INT(11) | número de caja |
| Cashier | VARCHAR(20) | Operador que realiza la NC |
| Details | VARCHAR(640) | Comentarios agregados a la NC |
| number | INT(11) | Número de nota de crédito |
| total | DECIMAL(18,4) | Importe de la NC |
| DateTime | DATETIME | Fecha y hora de emisión. |
Las notas de crédito están siempre asociadas a un ticket.
Ej: Todas las notas de crédito de la caja 1
SELECT * FROM view_notascredito WHERE cashNo = 1
Situaciones a tener en cuenta
- Los tickets filtrados por fecha pueden no ser los mismos que filtrados por número de caja:
Ej: Si una caja se cierra al dia siguiente de su apertura. Ej2: Si hay más de una caja (turno) en un mismo día. - Las vistas están disponibles solo en bases Mysql instaladas en PC servidor de CyberPlanet (base Local).
- Los Ingresos o Egresos adicionales que pueden formar parte de un turno no son accesibles desde la integración.
CyberPlanet has the possibility to access the billing information in the database in real time. A group of Views configured on the MySql server is available for this.
Overview
Content Tools