56
edits
Changes
Jump to navigation
Jump to search
Line 32:
Line 32: − + − + − + + + + + + + + + Line 73:
Line 81: + + + + + + + + + + + + + + + + Line 92:
Line 116: − + Line 100:
Line 124: − + Line 106:
Line 130: + + + + + + + + + + + + + + + + − + Line 117:
Line 157: − + Line 125:
Line 165: − + Line 133:
Line 173: − + Line 141:
Line 181: − + Line 163:
Line 203: + + + + + + + + Line 171:
Line 219: + + + + + + + + Line 178:
Line 234: − + + + + + + + + + Line 186:
Line 250: − + + + + + + + + + Line 196:
Line 268: − + Line 202:
Line 274: − + Line 212:
Line 284: + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Line 227:
Line 379: − + + + + +
no edit summary
| technical index
| technical index
|-
|-
| facnumber
| ref
| varchar(50)
| varchar(180)
| NO
| NO
| UNI
|
|
|
|
|
| invoice number
| invoice number
|-
| ref_supplier
| varchar(180)
| NO
|
|
|
| invoice number from supplier
{{FieldEntity}}
{{FieldEntity}}
{{FieldRefExt}}
{{FieldRefExt}}
|
|
| date of invoice
| date of invoice
|-
| date_pointoftax
| date
| YES
|
| NULL
|
| date point of tax (for GB)
|-
| date_valid
| date
| YES
|
| NULL
|
| date validation
{{FieldTms}}
{{FieldTms}}
|-
|-
|-
|-
| amount
| amount
| double(16,8)
| double(24,8)
| NO
| NO
|
|
|-
|-
| remise
| remise
| double(16,8)
| double(24,8)
| YES
| YES
|
|
|
|
| discount
| discount
|-
| close_code
| varchar(16)
|
|
|
|
| Code motif clôture sans paiement complet
|-
| close_note
| varchar(128)
|
|
|
|
| Commentaire clôture sans paiement complet
|-
|-
| tva
| tva
| double(16,8)
| double(24,8)
| YES
| YES
|
|
|-
|-
| total
| total
| double(16,8)
| double(24,8)
| YES
| YES
|
|
|-
|-
| total_ht
| total_ht
| double(16,8)
| double(24,8)
| YES
| YES
|
|
|-
|-
| total_tva
| total_tva
| double(16,8)
| double(24,8)
| YES
| YES
|
|
|-
|-
| total_ttc
| total_ttc
| double(16,8)
| double(24,8)
| YES
| YES
|
|
|
|
| ID of user author of invoice ([[Table llx_user|llx_user]]->rowid)
| ID of user author of invoice ([[Table llx_user|llx_user]]->rowid)
|-
| fk_user_modif
| int(11)
| YES
| MUL
| NULL
|
| ID of user making last change of invoice ([[Table llx_user|llx_user]]->rowid)
|-
|-
| fk_user_valid
| fk_user_valid
|
|
| ID of user validator of invoice ([[Table llx_user|llx_user]]->rowid)
| ID of user validator of invoice ([[Table llx_user|llx_user]]->rowid)
|-
| fk_facture_source
| int(11)
| YES
| MUL
| NULL
|
| ID of the invoice source in case of credit note ([[Table llx_facture_fourn|llx_facture_fourn]]->rowid)
|-
|-
| fk_projet
| fk_projet
| NULL
| NULL
|
|
| ID of related proyect ([[Table llx_projet|llx_projet]]->rowid)
| ID of related project ([[Table llx_projet|llx_projet]]->rowid)
|-
| fk_account
| int(11)
| YES
| MUL
| NULL
|
| ID of bank account ([[Table llx_bank_account|llx_bank_account]]->rowid)
|-
|-
| fk_cond_reglement
| fk_cond_reglement
| 1
| 1
|
|
| Id of payment condition ([[Table llx_cond_reglement|llx_cond_reglement]]->rowid)
| Id of payment condition ([[Table llx_c_payment_term|llx__c_payment_term]]->rowid)
|-
| fk_cond_reglement
| int(11)
| YES
| MUL
| NULL
|
| ID of payment mode ([[Table llx_c_paiement|llx_c_paiement]]->rowid)
|-
|-
| date_lim_reglement
| date_lim_reglement
| date limit for payment
| date limit for payment
|-
|-
| note
| note_private
| text
| text
| YES
| YES
| NULL
| NULL
|
|
| commentary
| private commentary
|-
|-
| note_public
| note_public
| public commentary
| public commentary
|-
|-
| location_incoterms
| varchar(255)
|
|
|
|
| for incoterms
|-
| model_pdf
| varchar(255)
|
|
|
|
|
|-
| last_main_doc
| varchar(255)
|
|
|
|
| relative filepath+filename of last main generated document
{{FieldImportKey}}
{{FieldImportKey}}
|-
| extraparams
| varchar(255)
|
|
|
|
| for stock other parameters with json format
|-
| fk_multicurrency
| int(11)
| YES
|
| NULL
|
| ID of currency
|-
| multicurrency_code
| varchar(255)
|
|
|
|
|
|-
| multicurrency_tx
| double(24,8)
| YES
|
| 1
|
|
|-
| multicurrency_total_ht
| double(24,8)
| YES
|
| 0.00000000
|
|
|-
| multicurrency_total_tva
| double(24,8)
| YES
|
| 0.00000000
|
|
|-
| multicurrency_total_ttc
| double(24,8)
| YES
|
| 0.00000000
|
|
|-
|}
|}
| uk_facture_fourn_ref
| uk_facture_fourn_ref
| UNIQUE
| UNIQUE
| facnumber,fk_soc,entity
| ref,entity
|-
| uk_facture_fourn_ref_supplier
| UNIQUE
| ref_supplier,fk_soc,entity
|-
|-
| idx_facture_fourn_date_lim_reglement
| idx_facture_fourn_date_lim_reglement