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 baseUser: 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 accessView: 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_notascreditoReturns the credit notes issued. | Field | Type | Comment |
|---|
| TicketNo | INT(11) | Ticket |
vinculado a la nota de crédito| linked to credit note | | CashNo | INT(11) |
número de caja| box number | | Cashier | VARCHAR(20) |
Operador que realiza la | Operator performing the NC | | Details | VARCHAR(640) |
Comentarios agregados a la | Comments added to the NC | | number | INT(11) |
Número de nota de crédito| Credit note number | | total | DECIMAL(18,4) |
Importe de la NC| Amount of the CN | | DateTime | DATETIME |
Fecha y hora de emisión Las notas de crédito están siempre asociadas a un Credit notes are always associated with a ticket. Ej: Todas las notas de crédito de la caja Example: All credit notes in box 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.
Situations to consider- Tickets filtered by date may not be the same as tickets filtered by box number:
Example: If a box closes the day after it opens. Ex 2: If there is more than one box (turn) on the same day. - Views are available only on Mysql databases installed on CyberPlanet server PC (Local base).
- Additional Income or Expenses that may be part of a shift are not accessible since integration.
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. |