| p_4rc | Entête remise de caisse |
Liste des champs :
Rang |
Champ |
Libellé |
Type |
Lg/Format |
| 1 | codsoc | Code Société | LONG | - |
| 2 | p_4rccod | Code remise espece | CHAR | 6 |
| 3 | p_4rcnum | Numero remise espece | LONG | - |
| 4 | p_4rclib | Libelle remise espece | CHAR | 30 |
| 5 | p_4rclir | Lib reduit remise espece | CHAR | 10 |
| 6 | p_4rcdvp | Devide piece remise espece | CHAR | 3 |
| 7 | p_4rcmtp | Montant piece rem esp | DBLE | - |
| 8 | p_4rcmte | Montant etb rem esp | DBLE | - |
| 9 | p_4rcdat | Date remise espece | DATE | AAAAMMJJ |
| 10 | tp_echcod | Code echeancier | CHAR | 6 |
| 11 | p_4rcetb | Etablissement remise espece | CHAR | 3 |
| 12 | p_1jacod | Code journal | CHAR | 6 |
| 13 | p_ecrnum | N° technique écriture | LONG | - |
| 14 | p_1nucod | Code nature d'écriture utilisateur | CHAR | 3 |
| 15 | p_4rceta | Statut remise espece | CHAR | 1 |
| 16 | datmod | Date de la dernière mise à jour | DATE | AAAAMMJJ |
| 17 | utimod | Agent ayant effectué la dernière modif. | CHAR | 8 |
Liste des clés :
| Rang | Clé |
Libellé |
Type |
Unique |
| 1 | p_4rc_idx1 | Clé primaire p_4rc | D | O |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_4rccod (ASC) | ||||
| p_4rcnum (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 2 | p_4rc_idx2 | Cle logique recherche modele | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_4rcnum (ASC) | ||||
| p_4rccod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 3 | p_4rc_idx3 | Clé de recherche par caisse | D | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| tp_echcod (ASC) | ||||
| p_4rccod (ASC) | ||||
| p_4rcdat (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 4 | p_4rc_idx4 | RMCR p_4rc | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| tp_echcod (ASC) | ||||
| p_1jacod (ASC) | ||||
| p_4rcdat (ASC) | ||||
| p_1nucod (ASC) | ||||
| p_4rcetb (ASC) | ||||
| utimod (ASC) | ||||
| p_4rceta (ASC) | ||||