| p_7tx | Coût unitaire périodique |
Liste des champs :
Rang |
Champ |
Libellé |
Type |
Lg/Format |
| 1 | codsoc | Code Société | LONG | - |
| 2 | tp_7tctyp | type de coût | CHAR | 6 |
| 3 | p_plncod | Code plan | CHAR | 3 |
| 4 | p_7txref | Référence élément | CHAR | 12 |
| 5 | datdeb | Date de début de période | DATE | AAAAMMJJ |
| 6 | p_7txtaux | Coût unitaire | DBLE | - |
| 7 | p_7txcoef | Coeff ou taux ou Qtité globale | DBLE | - |
| 8 | p_7txmon | Montant coût unitaire | DBLE | - |
| 9 | p_7txqte | Quantité coût unitaire | DBLE | - |
| 10 | datmod | Date de la dernière mise à jour | DATE | AAAAMMJJ |
| 11 | utimod | Agent ayant effectué la dernière modif. | CHAR | 8 |
Liste des clés :
| Rang | Clé |
Libellé |
Type |
Unique |
| 1 | p_7tx_idx1 | Clé principale p_7tx | D | O |
Clause Order By |
||||
| codsoc (ASC) | ||||
| tp_7tctyp (ASC) | ||||
| p_plncod (ASC) | ||||
| p_7txref (ASC) | ||||
| datdeb (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 2 | p_7tx_idx2 | Clé 2 p_7tx | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| tp_7tctyp (ASC) | ||||
| datdeb (ASC) | ||||
| p_7txref (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 3 | p_7tx_idx3 | Clé 3 p_7tx | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| tp_7tctyp (ASC) | ||||
| datdeb (ASC) | ||||
| p_plncod (ASC) | ||||
| p_7txref (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 4 | p_7tx_idx4 | Clé 4 p_7tx | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| tp_7tctyp (ASC) | ||||
| p_plncod (ASC) | ||||
| p_7txref (ASC) | ||||
| datdeb (DESC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 5 | p_7tx_idx5 | Clé 5 p_7tx | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| tp_7tctyp (ASC) | ||||
| p_plncod (ASC) | ||||
| p_7txref (ASC) | ||||
| datdeb (ASC) | ||||