| id |
int(11)
|
|
|
|
| folio |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| id_empresa |
int(11)
|
|
|
|
| uuid |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| serie |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| folio_fiscal |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| fecha_emision |
date
|
|
|
|
| fecha_envio |
date
|
|
|
|
| fecha_confirmacion_recepcion |
date
|
|
|
|
| fecha_programada_pago |
date
|
|
|
|
| fecha_vencimiento |
date
|
|
|
|
| fecha_pago |
date
|
|
|
|
| subtotal |
decimal(12,2)
|
|
|
|
| iva |
decimal(12,2)
|
|
|
|
| total |
decimal(12,2)
|
|
|
|
| saldo_pendiente |
decimal(12,2)
|
|
|
|
| rfc_receptor |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| razon_social_receptor |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| uso_cfdi |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| metodo_pago |
varchar(5)
|
utf8mb4_general_ci
|
|
|
| forma_pago |
varchar(5)
|
utf8mb4_general_ci
|
|
|
| estatus |
enum('emitida', 'enviada', 'confirmada', 'programada', 'vencida', 'pagada', 'cancelada')
|
utf8mb4_general_ci
|
|
|
| archivo_xml |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| archivo_pdf |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| observaciones |
text
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| created_by |
int(11)
|
|
|
|
| updated_at |
datetime
|
|
|
|
| updated_by |
int(11)
|
|
|
|
| enabled |
tinyint(1)
|
|
|
|
