Table llx entrepot: Difference between revisions

Line 35: Line 35:
| NULL  
| NULL  
|
|
|
| creation date
|-
|-
| tms  
| tms  
Line 43: Line 43:
| CURRENT_TIMESTAMP  
| CURRENT_TIMESTAMP  
|
|
|
| last update date
|-
|-
| label  
| label  
Line 51: Line 51:
|
|
|
|
|
| label of warehouse
|-
| entity
| int(11)
|  
|
| 1
|
| multi company id
|-
|-
| description  
| description  
Line 59: Line 67:
| NULL
| NULL
|
|
|
| description of warehouse
|-
|-
| lieu  
| lieu  
Line 67: Line 75:
| NULL  
| NULL  
|  
|  
|
| brief explanation of warehouse situation
|-
|-
| address  
| address  
Line 75: Line 83:
| NULL  
| NULL  
|
|
|
| address of warehouse
|-
|-
| cp  
| cp  
Line 83: Line 91:
| NULL  
| NULL  
|
|
|
| postal code of warehouse
|-
|-
| ville  
| ville  
Line 91: Line 99:
| NULL  
| NULL  
|
|
|
| city of warehouse
|-
|-
| fk_pays  
| fk_pays  
Line 99: Line 107:
| 0
| 0
|
|
|
| country of warehouse
|-
|-
| statut  
| statut  
Line 107: Line 115:
| 1  
| 1  
|
|
|
| is the warehouse open (1=open, 0=closed)?
|-
| valo_pmp
| float(12,4)
| YES
|
|
|
| sotck warehouse valorisation PMP
|-
|-
| fk_user_author  
| fk_user_author  
Line 115: Line 131:
| NULL  
| NULL  
|  
|  
|
| ID of creator user ([[Table llx_user|llx_user]]->rowid)
|}
|}