29,219
edits
Changes
Jump to navigation
Jump to search
→Table
Line 33:
Line 33:
| YES
−| UNI
−|
−|
−| order number
−|-
−| entity
−| int(11)
| UNI
−| 1
|-
−| ref_supplier
−| varchar(30)
−| YES
|
−| supplier order number
| technical index
| technical index
|-
|-
−| tms
+| ref
−| timestamp
+| varchar(30)
−| NO
+| YES
+| UNI
+|
+|
+| order number
+{{FieldEntity}}
+{{FieldRefExt}}
+|-
+| ref_supplier
+| varchar(30)
+| YES
|
|
−| CURRENT_TIMESTAMP
+| NULL
|
|
−| last update date
+| supplier order number
|-
|-
| fk_soc
| fk_soc
Line 57:
Line 67:
| ID of proyect ([[Table llx_projet|llx_projet]]->rowid)
| ID of proyect ([[Table llx_projet|llx_projet]]->rowid)
|-
|-
−| ref
+| tms
−| varchar(30)
+| timestamp
−| NO
| NO
−|
|
−| multi company id
+| CURRENT_TIMESTAMP
−|
|
−| NULL
+| last update date
−|-
|-
| date_creation
| date_creation