Skip to content

Instantly share code, notes, and snippets.

@sebge2emasphere
Created April 25, 2018 07:35
Show Gist options
  • Save sebge2emasphere/c5c1abaf890293150d51240d102122e8 to your computer and use it in GitHub Desktop.
Save sebge2emasphere/c5c1abaf890293150d51240d102122e8 to your computer and use it in GitHub Desktop.
{
"id": "4ff8694b-7ab6-497c-ba28-c70ef0b0f4f5",
"tenant": "2f7bcd6f-7f68-4c12-a672-8da906e63e74",
"reference": "Souscripteur",
"internalReference": "souscripteur",
"label": "Souscripteur",
"displayedText": "Souscripteur",
"description": "Fichier excel souscripteurs ",
"status": "EDITING",
"entryDefinition": {
"key": {
"components": [
{
"reference": "id",
"internalReference": "a",
"label": "ID",
"description": "",
"displayedText": "ID",
"type": "TEXT",
"index": 0,
"properties": {},
"keyComponent": true,
"visibleByEndUser": true
}
]
},
"data": [
{
"reference": "souscription / transcription / tiers",
"internalReference": "b",
"label": "Type transaction",
"displayedText": "Type transaction",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 1,
"properties": {},
"keyComponent": false
},
{
"reference": "souscripteur / remboursement/ non-remboursable/ cvl / ls",
"internalReference": "c",
"label": "Type de souscripteur",
"displayedText": "Type de souscripteur",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 2,
"properties": {},
"keyComponent": false
},
{
"reference": "statut du souscripteur",
"internalReference": "d",
"label": "Statut Souscripteur",
"displayedText": "Statut Souscripteur",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 3,
"properties": {},
"keyComponent": false
},
{
"reference": "décédé",
"internalReference": "e",
"label": "Décédé",
"displayedText": "Décédé",
"description": "",
"type": "BOOLEAN",
"visibleByEndUser": true,
"index": 4,
"properties": {},
"keyComponent": false
},
{
"reference": "acompte payé (eur)",
"internalReference": "g",
"label": "Acompte payé (EUR)",
"displayedText": "Acompte payé (EUR)",
"description": "",
"type": "NUMBER",
"visibleByEndUser": true,
"index": 5,
"properties": {},
"keyComponent": false
},
{
"reference": "année de souscription",
"internalReference": "h",
"label": "Année de souscription",
"displayedText": "Année de souscription",
"description": "",
"type": "YEAR",
"visibleByEndUser": true,
"index": 6,
"properties": {},
"keyComponent": false
},
{
"reference": "mois de souscription",
"internalReference": "j",
"label": "Mois de souscription",
"displayedText": "Mois de souscription",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 7,
"properties": {},
"keyComponent": false
},
{
"reference": "date de souscription",
"internalReference": "k",
"label": "Date de souscription",
"displayedText": "Date de souscription",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 8,
"properties": {},
"keyComponent": false
},
{
"reference": "statut",
"internalReference": "l",
"label": "Statut",
"displayedText": "Statut",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 9,
"properties": {},
"keyComponent": false
},
{
"reference": "nom",
"internalReference": "o",
"label": "Nom",
"displayedText": "Nom",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 10,
"properties": {},
"keyComponent": false
},
{
"reference": "prénom",
"internalReference": "p",
"label": "Prénom",
"displayedText": "Prénom",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 11,
"properties": {},
"keyComponent": false
},
{
"reference": "date de naissance",
"internalReference": "q",
"label": "Date de naissance",
"displayedText": "Date de naissance",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 12,
"properties": {},
"keyComponent": false
},
{
"reference": "âge",
"internalReference": "s",
"label": "Âge",
"displayedText": "Âge",
"description": "",
"type": "NUMBER",
"visibleByEndUser": true,
"index": 13,
"properties": {},
"keyComponent": false
},
{
"reference": "matricule",
"internalReference": "u",
"label": "Matricule",
"displayedText": "Matricule",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 14,
"properties": {},
"keyComponent": false
},
{
"reference": "sexe",
"internalReference": "v",
"label": "Sexe",
"displayedText": "Sexe",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 15,
"properties": {},
"keyComponent": false
},
{
"reference": "montants souscription (luf)",
"internalReference": "x",
"label": "Montant Souscription (LUF)",
"displayedText": "Montant Souscription (LUF)",
"description": "",
"type": "NUMBER",
"visibleByEndUser": true,
"index": 16,
"properties": {},
"keyComponent": false
},
{
"reference": "droits de souscriptions ou transcriptions (eur)compte 758210",
"internalReference": "y",
"label": "Droits de Souscriptions ou Transcription",
"displayedText": "Droits de Souscriptions ou Transcription",
"description": "",
"type": "NUMBER",
"visibleByEndUser": true,
"index": 17,
"properties": {},
"keyComponent": false
},
{
"reference": "date de paiement de l'acompte",
"internalReference": "z",
"label": "Date de paiement de l'acompte",
"displayedText": "Date de paiement de l'acompte",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 18,
"properties": {},
"keyComponent": false
},
{
"reference": "solde payé (eur)",
"internalReference": "ba",
"label": "Solde Payé (EUR)",
"displayedText": "Solde Payé (EUR)",
"description": "",
"type": "NUMBER",
"visibleByEndUser": true,
"index": 19,
"properties": {},
"keyComponent": false
},
{
"reference": "date de paiement du solde",
"internalReference": "bb",
"label": "Date de paiement du solde",
"displayedText": "Date de paiement du solde",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 20,
"properties": {},
"keyComponent": false
},
{
"reference": "provision souscription non acquise (eur)\ncomptes 685110 et 158000",
"internalReference": "bc",
"label": "Provision souscription non acquise (EUR)",
"displayedText": "Provision souscription non acquise (EUR)",
"description": "",
"type": "NUMBER",
"visibleByEndUser": true,
"index": 21,
"properties": {},
"keyComponent": false
},
{
"reference": "année d'entrée - long séjour",
"internalReference": "bd",
"label": "Année d'entrée - Long Séjour",
"displayedText": "Année d'entrée - Long Séjour",
"description": "",
"type": "YEAR",
"visibleByEndUser": true,
"index": 22,
"properties": {},
"keyComponent": false
},
{
"reference": "date d'entrée - long séjour",
"internalReference": "be",
"label": "Date d'entrée - Long séjour",
"displayedText": "Date d'entrée - Long séjour",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 23,
"properties": {},
"keyComponent": false
},
{
"reference": "date retour à domicile - long séjour",
"internalReference": "bf",
"label": "Date retour à domicile - Long Séjour",
"displayedText": "Date retour à domicile - Long Séjour",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 24,
"properties": {},
"keyComponent": false
},
{
"reference": "date de décès - long séjour",
"internalReference": "bg",
"label": "Date de décès - Long séjour",
"displayedText": "Date de décès - Long séjour",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 25,
"properties": {},
"keyComponent": false
},
{
"reference": "reprise pour provision souscripteurs entrés (eur) si entrée - long séjourcomptes 785110 et 158000",
"internalReference": "bh",
"label": "Reprise pour provision souscripteurs entré si entrée - long séjour",
"displayedText": "Reprise pour provision souscripteurs entré si entrée - long séjour",
"description": "",
"type": "NUMBER",
"visibleByEndUser": true,
"index": 26,
"properties": {},
"keyComponent": false
},
{
"reference": "date décès",
"internalReference": "bi",
"label": "Date décès",
"displayedText": "Date décès",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 27,
"properties": {},
"keyComponent": false
},
{
"reference": "date choix autre maison",
"internalReference": "bj",
"label": "Date choix autres maisons",
"displayedText": "Date choix autres maisons",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 28,
"properties": {},
"keyComponent": false
},
{
"reference": "nom de maison",
"internalReference": "bk",
"label": "Nom de maison",
"displayedText": "Nom de maison",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 29,
"properties": {},
"keyComponent": false
},
{
"reference": "dépendance",
"internalReference": "bm",
"label": "Dépendance",
"displayedText": "Dépendance",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 30,
"properties": {},
"keyComponent": false
},
{
"reference": "limite d'âge dépassée",
"internalReference": "bl",
"label": "Limite d'âge dépassée",
"displayedText": "Limite d'âge dépassée",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 31,
"properties": {},
"keyComponent": false
},
{
"reference": "date de déménagement\nà l'étranger",
"internalReference": "bn",
"label": "Date de déménagement à l'étranger",
"displayedText": "Date de déménagement à l'étranger",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 32,
"properties": {},
"keyComponent": false
},
{
"reference": "annulé",
"internalReference": "bo",
"label": "Annulé",
"displayedText": "Annulé",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 33,
"properties": {},
"keyComponent": false
},
{
"reference": "reprise pour provision souscripteurs entrés (eur) si décès ou changement\ncomptes 785110 et 158000",
"internalReference": "bp",
"label": "Reprise pour provisions souscripteurs entré si décès",
"displayedText": "Reprise pour provisions souscripteurs entré si décès",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 34,
"properties": {},
"keyComponent": false
},
{
"reference": "montant remboursé provision (eur)\ncompte 658100",
"internalReference": "bq",
"label": "Montant remboursé provision",
"displayedText": "Montant remboursé provision",
"description": "",
"type": "NUMBER",
"visibleByEndUser": true,
"index": 35,
"properties": {},
"keyComponent": false
},
{
"reference": "jour du remboursement",
"internalReference": "br",
"label": "Jour du remboursement",
"displayedText": "Jour du remboursement",
"description": "",
"type": "NUMBER",
"visibleByEndUser": true,
"index": 36,
"properties": {},
"keyComponent": false
},
{
"reference": "mois du remboursement",
"internalReference": "bs",
"label": "Mois du remboursement",
"displayedText": "Mois du remboursement",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 37,
"properties": {},
"keyComponent": false
},
{
"reference": "année de remboursement",
"internalReference": "bt",
"label": "Année de remboursement",
"displayedText": "Année de remboursement",
"description": "",
"type": "YEAR",
"visibleByEndUser": true,
"index": 38,
"properties": {},
"keyComponent": false
},
{
"reference": "année d'entrée - convalescence",
"internalReference": "bu",
"label": "Année d'entrée - convalescence",
"displayedText": "Année d'entrée - convalescence",
"description": "",
"type": "YEAR",
"visibleByEndUser": true,
"index": 39,
"properties": {},
"keyComponent": false
},
{
"reference": "date d'entrée - convalescence",
"internalReference": "bv",
"label": "Date d'entrée - convalescence",
"displayedText": "Date d'entrée - convalescence",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 40,
"properties": {},
"keyComponent": false
},
{
"reference": "date de décès - convalescence",
"internalReference": "bw",
"label": "Date de décès - convalescence",
"displayedText": "Date de décès - convalescence",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 41,
"properties": {},
"keyComponent": false
},
{
"reference": "nombre de jours - convalescence",
"internalReference": "bx",
"label": "Nombre de jours - convalescence",
"displayedText": "Nombre de jours - convalescence",
"description": "",
"type": "NUMBER",
"visibleByEndUser": true,
"index": 42,
"properties": {},
"keyComponent": false
},
{
"reference": "reprise pour provision souscripteur entrés (eur) si entrée\ncomptes 785110 et 158000",
"internalReference": "bz",
"label": "Reprise pour provision souscripteur entré ",
"displayedText": "Reprise pour provision souscripteur entré ",
"description": "",
"type": "NUMBER",
"visibleByEndUser": true,
"index": 43,
"properties": {},
"keyComponent": false
},
{
"reference": "année de remboursement - convalescence",
"internalReference": "ca",
"label": "Année de remboursement - convalescence",
"displayedText": "Année de remboursement - convalescence",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 44,
"properties": {},
"keyComponent": false
},
{
"reference": "mois de remboursement - convalescence",
"internalReference": "cb",
"label": "Mois de remboursement - Convalescence",
"displayedText": "Mois de remboursement - Convalescence",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 45,
"properties": {},
"keyComponent": false
},
{
"reference": "solde provision souscription non acquise (eur)\ncompte 158000",
"internalReference": "cc",
"label": "Solde provision souscription non acquise",
"displayedText": "Solde provision souscription non acquise",
"description": "",
"type": "NUMBER",
"visibleByEndUser": true,
"index": 46,
"properties": {},
"keyComponent": false
},
{
"reference": "nom - tiers",
"internalReference": "cd",
"label": "Nom - Tiers",
"displayedText": "Nom - Tiers",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 47,
"properties": {},
"keyComponent": false
},
{
"reference": "prénom - tiers",
"internalReference": "ce",
"label": "Prénom - Tiers",
"displayedText": "Prénom - Tiers",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 48,
"properties": {},
"keyComponent": false
},
{
"reference": "date de naissance - tiers",
"internalReference": "cf",
"label": "Date de naissance - Tiers",
"displayedText": "Date de naissance - Tiers",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 49,
"properties": {},
"keyComponent": false
},
{
"reference": "matricule - tiers",
"internalReference": "cg",
"label": "Matricule - Tiers",
"displayedText": "Matricule - Tiers",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 50,
"properties": {},
"keyComponent": false
},
{
"reference": "sexe - tiers",
"internalReference": "ch",
"label": "Sexe - Tiers",
"displayedText": "Sexe - Tiers",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 51,
"properties": {},
"keyComponent": false
},
{
"reference": "date de souscription - transcriptions",
"internalReference": "ci",
"label": "Date de souscription - Transcriptions",
"displayedText": "Date de souscription - Transcriptions",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 52,
"properties": {},
"keyComponent": false
},
{
"reference": "nom - transcriptions",
"internalReference": "cj",
"label": "Nom - Transcriptions",
"displayedText": "Nom - Transcriptions",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 53,
"properties": {},
"keyComponent": false
},
{
"reference": "prénom - transcriptions",
"internalReference": "ck",
"label": "Prénom - Transcriptions",
"displayedText": "Prénom - Transcriptions",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 54,
"properties": {},
"keyComponent": false
},
{
"reference": "date de naissance - transcriptions",
"internalReference": "cl",
"label": "Date de naissance - Transcriptions",
"displayedText": "Date de naissance - Transcriptions",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 55,
"properties": {},
"keyComponent": false
},
{
"reference": "nationalité - transcriptions",
"internalReference": "cn",
"label": "Nationalité - Transcriptions",
"displayedText": "Nationalité - Transcriptions",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 56,
"properties": {},
"keyComponent": false
},
{
"reference": "matricule - transcriptions",
"internalReference": "cm",
"label": "Matricule - Transcriptions",
"displayedText": "Matricule - Transcriptions",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 57,
"properties": {},
"keyComponent": false
},
{
"reference": "sexe - transcriptions",
"internalReference": "co",
"label": "Sexe - Transcriptions",
"displayedText": "Sexe - Transcriptions",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 58,
"properties": {},
"keyComponent": false
},
{
"reference": "montants souscription (luf) - transcriptions",
"internalReference": "cq",
"label": "Montants Souscriptions (LUF) - Transcriptions",
"displayedText": "Montants Souscriptions (LUF) - Transcriptions",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 59,
"properties": {},
"keyComponent": false
},
{
"reference": "montant souscription (eur) - transcriptions\ncompte 758210",
"internalReference": "cp",
"label": "Montant Souscription - Transcription",
"displayedText": "Montant Souscription - Transcription",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 60,
"properties": {},
"keyComponent": false
},
{
"reference": "acompte payé (eur) - transcriptions",
"internalReference": "cr",
"label": "Acompte payé - Transcription",
"displayedText": "Acompte payé - Transcription",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 61,
"properties": {},
"keyComponent": false
},
{
"reference": "date de paiement de l'acompte - transcriptions",
"internalReference": "cs",
"label": "Date de paiement de l'acompte - Transcriptions",
"displayedText": "Date de paiement de l'acompte - Transcriptions",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 62,
"properties": {},
"keyComponent": false
},
{
"reference": "solde payé (eur) - transcriptions",
"internalReference": "ct",
"label": "Solde Payé - Transcriptions",
"displayedText": "Solde Payé - Transcriptions",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 63,
"properties": {},
"keyComponent": false
},
{
"reference": "date de paiement du solde - transcriptions",
"internalReference": "cu",
"label": "Date de paiement du solde - Transcriptions",
"displayedText": "Date de paiement du solde - Transcriptions",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 64,
"properties": {},
"keyComponent": false
},
{
"reference": "provision souscription non acquise (eur) - transcriptions\ncomptes 685110 et 158000",
"internalReference": "cv",
"label": "Provision souscription non acquise - Transcriptions",
"displayedText": "Provision souscription non acquise - Transcriptions",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 65,
"properties": {},
"keyComponent": false
},
{
"reference": "date de souscription - transcription tier",
"internalReference": "cw",
"label": "Date de souscription - Transcription tiers",
"displayedText": "Date de souscription - Transcription tiers",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 66,
"properties": {},
"keyComponent": false
},
{
"reference": "nom - transcription tier",
"internalReference": "cx",
"label": "Nom - transcription tiers",
"displayedText": "Nom - transcription tiers",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 67,
"properties": {},
"keyComponent": false
},
{
"reference": "prénom - transcription tier",
"internalReference": "cy",
"label": "Prénom - Transcription tiers",
"displayedText": "Prénom - Transcription tiers",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 68,
"properties": {},
"keyComponent": false
},
{
"reference": "date de naissance - transcription tier",
"internalReference": "cz",
"label": "Date de naissance - Transcription tiers",
"displayedText": "Date de naissance - Transcription tiers",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 69,
"properties": {},
"keyComponent": false
},
{
"reference": "nationalité - transcription tier",
"internalReference": "da",
"label": "Nationalité - Transcription tiers",
"displayedText": "Nationalité - Transcription tiers",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 70,
"properties": {},
"keyComponent": false
},
{
"reference": "matricule - transcription tier",
"internalReference": "db",
"label": "Matricule - Transcription tiers",
"displayedText": "Matricule - Transcription tiers",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 71,
"properties": {},
"keyComponent": false
},
{
"reference": "sexe - transcription tier",
"internalReference": "dc",
"label": "Sexe - Transcritptions tiers",
"displayedText": "Sexe - Transcritptions tiers",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 72,
"properties": {},
"keyComponent": false
},
{
"reference": "montants souscription (luf) - transcription tier",
"internalReference": "dd",
"label": "Montants souscription (LUF) - Transcription tiers",
"displayedText": "Montants souscription (LUF) - Transcription tiers",
"description": "",
"type": "NUMBER",
"visibleByEndUser": true,
"index": 73,
"properties": {},
"keyComponent": false
},
{
"reference": "montant souscription (eur) - transcription tier\ncompte 758210",
"internalReference": "de",
"label": "Montant souscription (EUR) - Transcription tiers",
"displayedText": "Montant souscription (EUR) - Transcription tiers",
"description": "",
"type": "NUMBER",
"visibleByEndUser": true,
"index": 74,
"properties": {},
"keyComponent": false
},
{
"reference": "acompte payé (eur) - transcription tier",
"internalReference": "df",
"label": "Acompte payé (EUR) - Transcription tiers",
"displayedText": "Acompte payé (EUR) - Transcription tiers",
"description": "",
"type": "NUMBER",
"visibleByEndUser": true,
"index": 75,
"properties": {},
"keyComponent": false
},
{
"reference": "date de paiement de l'acompte - transcription tier",
"internalReference": "dg",
"label": "Date de paiement de l'acompte - Transcription tiers",
"displayedText": "Date de paiement de l'acompte - Transcription tiers",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 76,
"properties": {},
"keyComponent": false
},
{
"reference": "solde payé (eur) - transcription tier",
"internalReference": "dh",
"label": "Solde payé (EUR) - Transcription tiers",
"displayedText": "Solde payé (EUR) - Transcription tiers",
"description": "",
"type": "NUMBER",
"visibleByEndUser": true,
"index": 77,
"properties": {},
"keyComponent": false
},
{
"reference": "date de paiement du solde - transcription tier",
"internalReference": "di",
"label": "Date de paiement du solde - Transcription tiers",
"displayedText": "Date de paiement du solde - Transcription tiers",
"description": "",
"type": "DATE",
"visibleByEndUser": true,
"index": 78,
"properties": {},
"keyComponent": false
},
{
"reference": "provision souscription non acquise (eur) - transcription tier\ncomptes 685110 et 158000",
"internalReference": "dj",
"label": "Provision souscription non acquise (EUR) - Transcription tiers",
"displayedText": "Provision souscription non acquise (EUR) - Transcription tiers",
"description": "",
"type": "TEXT",
"visibleByEndUser": true,
"index": 79,
"properties": {},
"keyComponent": false
}
],
"properties": {}
},
"properties": {}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment