
    	0j	                         d dl mZmZmZmZmZmZmZmZm	Z	m
Z
 d dlmZ d dlmZ d dlmZ  G d de      Z G d de      Z G d	 d
e      Zy)    )
ColumnIntegerStringDECIMALBooleanDateTimeDateTextEnum
ForeignKey)relationship)datetime)Basec            
          e Zd ZdZ eedd      Z e ed      ddd      Z e e	ddd	d
dd      d      Z
 e ed      d      Z e ed      d      Z e ed      d      Z e ed      d      Z e ed      d      Z e ed      d      Z eedd      Z e ed      dd      Z e ed      d      Z e ed      d      Z e edd      d      Z e edd      d      Z e edd      d      Z e edd      d      Z e edd      d      Z e edd      d      Z eed      Z e ed      dd      Z e e	ddd      d      Z  eed      Z! e ed       d      Z" e ed      d!      Z# eee$jJ                        Z& eee$jJ                  e$jJ                  "      Z' e(d#d$%      Z)y&)'	NfeImportnfe_importsTprimary_keyindex,   F)uniquenullabler   importedpending_linklinkedconflictignorednfe_status_enumnamedefault   r   
         2   r   r               r   @   )r   r   successerrornfe_parse_status_enumd   manual_uploadr"   onupdateNfeItemnfeback_populatesN)*__name__
__module____qualname____tablename__r   r   idr   
access_keyr   status
nfe_numberseriesmodeloperation_natureenvironmentprotocol_numberr   
issue_dateissuer_cnpjissuer_namerecipient_cnpjr   total_products_valuetotal_invoice_valuetotal_freighttotal_insurancetotal_discounttotal_otherr
   raw_xml
xml_sha256parse_statusparse_errorimported_byimport_sourcer   utcnow
created_at
updated_atr   items     </var/www/hypershopcomercio.com.br/hyper-ai/app/models/nfe.pyr   r      s   !M	T	6Br
4%tLJD^Xz9[lm  xB  CFr
T2JF2J.F6!9t,EfSkD9d3KVBZ$7O5=Je4@Ku5KF2J6N!'"a.!< Q;72q>15MWR^Q7OGBNA6NQ3KTD)Gr
4$?J$y'8OPZcdL-Kt4K6":?M(//:J(//HOOTJ59Er\   r   c                   |   e Zd ZdZ eedd      Z ee ed      dd      Z eed      Z	 e e
d      dd      Z e e
d	      d      Z e e
d
      dd      Z e e
d      d      Z e e
d      d      Z e e
d      d      Z e e
d      d      Z e e
d      d      Z e edd      d      Z e edd      d      Z e edd      d      Z e e
d      d      Z e edd      d      Z e edd      d      Z e edd      d      Z e edd      d      Z e edd      d      Z e edd      d      Z e edd      d      Z e edd      d      Z e edd      d      Z  e edd      d      Z! e edd      d      Z" e edd      d      Z# e edd      d      Z$ e edd      d      Z% e edd      d      Z& e edd      d      Z' e e
d      dd      Z( e e
d	      dd      Z) e e
d	      dd      Z* e e
d	      dd      Z+ e e,dddd      dd      Z- e e,dddd      d      Z. e e
d      d      Z/ ee0e1jd                        Z3 ee0e1jd                  e1jd                        Z4 e5dd      Z6y)r6   	nfe_itemsTr   nfe_imports.idFr)   r$   r2   r'      r%   r-   r,   r   r!   pending	suggested	confirmednfe_item_link_status_enumr   )r"   r   highmediumlownfe_link_confidence_enumr4   r   rZ   r8   N)7r:   r;   r<   r=   r   r   r>   r   nfe_idn_itemr   sku_supplierdescriptioneanncmcestcfop	cst_csosnunitr   quantity
unit_valueproduct_value	unit_tribquantity_tribunit_value_tribfreight_allocatedinsurance_allocateddiscount_allocatedother_allocated	ipi_valueipi_rate
icms_value	icms_rate	icms_basest_valuest_ratest_basetotal_item_cost_nfunit_cost_nf
linked_skulinked_mlb_idlinked_variation_idlinked_catalog_product_idr   link_statuslink_confidencelink_methodr   r   rW   rX   rY   r   r7   r[   r\   r]   r6   r6   -   s   M	T	6BGZ(89EQUVFGe,F&+DALu5K
d$
7C
d
+C&*t,D&)d+Dvay40I&*t,Dgb!nu5HA7J72q>E:MvbzD1I72q>D9MWR^d;Owr1~q9 Q;A:WR^Q7Owr1~q1Igb!na0HA2Jwr1~q1Iwr1~q1Igb!na0HWR^Q/GWR^Q/GA:'"a.!4Lsd$?J6#;TBM t4H &vc{T NikHcdnw  @D  EKT&(E@Z[fjkOt4K(//:J(//HOOTJ
{7
;Cr\   r6   c            	          e Zd ZdZ eedd      Z ee edd      dd      Z e e	d	      dd      Z
 eed
      Z e edd      d      Z e edd      d      Z e edd      d      Z e edd      d      Z e eddddd      d      Z e eddddd      d      Z e e	d      d      Z eed      Z e e	d      d      Z e e	d      d      Z eed      Z eed      Z eed      Z e e	d      d      Z e e	d      d      Z  e e	d      d      Z! e edddd      d      Z" eee#jH                  
      Z% eee#jH                  e#jH                         Z& e'd!d"#      Z(y$)%NfeReconciliationnfe_reconciliationsTr   r`   CASCADE)ondeleteFr)   r*   r!   r,   r-   r$   r%   rc   rd   r   r   reconciliation_status_enumr   
user_inputimported_erp
bank_matchsupplier_agreementreconciliation_source_enumr'   r2   rf   rg   rh   reconciliation_confidence_enumr4   r   reconciliations)backrefN))r:   r;   r<   r=   r   r   r>   r   rj   r   supplier_cnpjr   	is_activer   fiscal_value_xmlfinancial_value_realcoverage_percentfinancial_multiplierr   reconciliation_statussource_typeevidence_referencer
   notes
created_byconfirmed_byr   confirmed_atr	   payment_datedue_datefinancial_document_idbank_transaction_idaccounts_payable_id
confidencer   rW   rX   rY   r   r7   r[   r\   r]   r   r   c   s   )M	T	6BGZ(89MX]eijF6":TBMw-Igb!nu=!'"a.5Agb!nu=!'"a.5A"4[*i^z#{  GL  MlNLJ^  fB  C  NS  TKsd;4$'Esd3J&+5L(T2L$.LdT*H"6#;> t< t<VXu;[\gklJ(//:J(//HOOTJ
{,=
>Cr\   r   N)
sqlalchemyr   r   r   r   r   r   r	   r
   r   r   sqlalchemy.ormr   r   app.core.databaser   r   r6   r   r[   r\   r]   <module>r      s=    h h h '  "%: %:N4<d 4<l%? %?r\   