| rowid |
int(11)
|
|
|
|
| tms |
timestamp
|
|
|
|
| ref |
varchar(30)
|
utf8_unicode_ci
|
|
|
| entity |
int(11)
|
|
|
|
| fk_soc |
int(11)
|
|
|
|
| fk_projet |
int(11)
|
|
|
|
| ref_ext |
varchar(255)
|
utf8_unicode_ci
|
|
|
| ref_customer |
varchar(255)
|
utf8_unicode_ci
|
|
|
| date_creation |
datetime
|
|
|
|
| fk_user_author |
int(11)
|
|
|
|
| fk_user_modif |
int(11)
|
|
|
|
| date_valid |
datetime
|
|
|
|
| fk_user_valid |
int(11)
|
|
|
|
| date_delivery |
datetime
|
|
|
|
| date_expedition |
datetime
|
|
|
|
| fk_address |
int(11)
|
|
|
|
| fk_shipping_method |
int(11)
|
|
|
|
| tracking_number |
varchar(50)
|
utf8_unicode_ci
|
|
|
| fk_statut |
smallint(6)
|
|
|
|
| billed |
smallint(6)
|
|
|
|
| height |
float
|
|
|
|
| width |
float
|
|
|
|
| size_units |
int(11)
|
|
|
|
| size |
float
|
|
|
|
| weight_units |
int(11)
|
|
|
|
| weight |
float
|
|
|
|
| signed_status |
smallint(6)
|
|
|
|
| online_sign_ip |
varchar(48)
|
utf8_unicode_ci
|
|
|
| online_sign_name |
varchar(64)
|
utf8_unicode_ci
|
|
|
| note_private |
text
|
utf8_unicode_ci
|
|
|
| note_public |
text
|
utf8_unicode_ci
|
|
|
| model_pdf |
varchar(255)
|
utf8_unicode_ci
|
|
|
| last_main_doc |
varchar(255)
|
utf8_unicode_ci
|
|
|
| fk_incoterms |
int(11)
|
|
|
|
| location_incoterms |
varchar(255)
|
utf8_unicode_ci
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
| extraparams |
varchar(255)
|
utf8_unicode_ci
|
|
|
