Documentación CyberPlanet 6.5


Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 16 Next »

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.

FieldTypeComment
TicketNoINT(11)Ticket number, auto-incremental.
CashNoINT(11)Box number on which the ticket was issued
CashierVARCHAR(20)Cashier’s Name

CategoryINT

INT(11)id Category
CategorySTRVARCHAR(100)Category
QuantityINT(11)Quantity
DetailsVARCHAR(103)Details
unit_priceDECIMAL(22,8)Unit price
DiscountDECIMAL(19,4)discount amount
totalDECIMAL(18,4)Total receivable
DateTime_consumedDATETIMEDate and time of consumption
DateTime_ticketDATETIMEDate and time of ticket issuance
durationTIMEDuration, in the case of meetings
pcSMALLINT(6)Number of PCs of consumption
PosNoINT(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.

FieldTypeComment
TicketNoINT(11)Ticket vinculado a la nota de crédito
CashNoINT(11)número de caja
CashierVARCHAR(20)Operador que realiza la NC
DetailsVARCHAR(640)Comentarios agregados a la NC
numberINT(11)Número de nota de crédito
totalDECIMAL(18,4)Importe de la NC
DateTimeDATETIMEFecha 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.

  • No labels