Intégration d'écritures comptables
L'action pour l'intégration d’écritures comptables : integration_ecriture
Balise | Niveau | Contenu | Obligatoire | Remarques |
|---|---|---|---|---|
entity | 1 | Nom de la table | OUI | Nom de la table sur laquelle ajouter une fichier joint. Valeurs possibles : voir plus bas |
key : {“nomChampCle1”:”valeurCle1”,”nomChampCle2”:valeurCle4”} | 1 | Champs permettant de trouver la clé primaire de l’enregistrement sur lequel associer le fichier joint | OUI | Le nombre et le type de champs Clé dépend de la table. |
filename | 1 | Nom du fichier à joindre | OUI | Si le nom existe déjà, il sera suffixé d'u |
entity | 1 | Nom de la table | OUI | Nom de la table sur laquelle ajouter une fichier joint. Valeurs possibles : voir plus bas |
Un mapping existe entre les noms de champs du dictionnaire les les noms de balise à utiliser
Table C8
Nom de balise | Nom de champ | Version | Remarque |
|---|---|---|---|
FOLDER | Dos | 10.7 | Dossier achat-vente |
ESTABLISHMENT | Etb | Dossier comptable | |
ACCOUNT | Cpt | ||
ENTRYDATE | Ecrdt | ||
DESCRIPTION | Lib | ||
CONFIDENTIALITY | Conf | ||
JOURNAL | Jnl | ||
ENTRYNO | Ecr | ||
ASSOCIATEDENTRYNO | EcrA | ||
ORIGINALENTRYNO | Ecrl | ||
VALIDATEDENTRYNO | EcrValNo | ||
CONTRAACCOUNT | Cp | ||
PAYMENTMODE | Reg | ||
LETTERINGCODE | Lett | ||
CHECKINGCODE | Point | ||
EXISTENCEBATCHCODE | LotCod | ||
BATCHNO | Lot | ||
ACCOUNTINGDOCUMENTPREFIX | PrefPiece | ||
ACCOUNTINGDOCUMENT | Piece | ||
DUEDATE | EchDt | ||
CHEQUENO | ChqNo | ||
CURRENCY | Dev | ||
PAYMENTTYPE | RegTyp | ||
THIRDPARTYDOCUMENTNO | PinoTiers | ||
CHECKINGTICKET | TicketPoint | ||
COLLECTIVEACCOUNT | CptCol | ||
NATUREOFPAYMENT | NatPai | ||
AMOUNT | Mt | ||
FOREIGNCURRENCYTAMOUNT | MtDev | ||
SECONDARYCURRENCY | MtBis | ||
AMOUNT2 | Mt2 | ||
FLOW | Sens | DEBIT=1, CREDIT=2 | |
LETTERINGDATE | LettDt | ||
CHECKINGDATE | PointDt | ||
NATUREOFAMOUNT2 | Mt2Nat | ||
ESTIMATEDBANKTRANSACTIONDATE | BqeDt | ||
VALUEDATE | ValDt | ||
BANKTRANSACTIONDATE | OpeDt | ||
EXCHANGERATE | DevP | ||
CHECHINGAMOUNT | PointMt | ||
DOCUMENTDATE | PieceDt | ||
ENTRYVALIDATIONDATE | ValidDt | ||
CALCULATIONMETHOD | Formule | ||
DATAHUBNO | DHBNo | ||
ANALYTICALKEY | CleRep | ||
ASSOCIETEDLIGNENO | EcrLgLiee | ||
DISCOUNTINDICATOR | EscompteFl | ||
ACCOUNTINGCPTDOCUMENT | FullpieceCpt | ||
ACCOUNTSTATEMENTCODE | ReleveCd | ||
ACCOUNTSTATEMENTNO | ReleveNo | ||
DAS2CODE | CodeDas2 | ||
RULECODE | RegleCod | ||
DAYOFF | ArreteDt | ||
UNCOLLECTIBLEVATFLAG | RecTvaFl | ||
PURCHASEANDSALEFOLDER | DosG3 | ||
THIRDPARTYTYPE | TiersType | ||
FINALSTATEMENT | CUSTOMER=1, VENDOR=2 | ||
THIRDPARTYCODE | Tiers | ||
PURCHASEANDSALETHIRDPARTY | TiersG3 | ||
THIRDPARTYPAYER | TiersPayer | ||
THIRDPARTYGROUP | TiersGrp | ||
RELAUNCHTHIRDPARTY | RelTiers |
Table CP
Nom de balise | Nom de champ | Version | Remarque |
|---|---|---|---|
FOLDER | Dos | 10.7 | |
ESTABLISHMENT | Etb | ||
ENTRYNO | Ecr | ||
LIGNENO | MaskLg | ||
ACCOUNT | Cpt | ||
ACCOUNTINGDOCUMENTPREFIX | PrefPiece | ||
ACCOUNTINGDOCUMENT | Piece | ||
DUEDATE | EchDt | ||
LETTERINGCODE | Lett | ||
ENTRYTYPE | EcrTyp | ||
PAYMENTMODE | Reg | ||
CURRENCY | Dev | ||
AMOUNT | Mt | ||
FLOW | Sens | DEBIT=1, CREDIT=2 | |
LETTERINGDATE | LettDt | ||
FOREIGNCURRENCYTAMOUNT | MtDev | ||
SECONDARYCURRENCY | MtBis | ||
DISCOUNTINDICATOR | EscompteFl | ||
SETTLEMENTSTATUS | EtatReg | ||
PAIDENTRY | RegleFl | ||
TRANSACTIONWORK | TransacWrk | ||
ACCOUNTSTATEMENTCODE | ReleveCd | ||
ACCOUNTSTATEMENTNO | ReleveNo | ||
GROUPENTRY | RegrEcrM | ||
DEFAULTPURCHASEBANK | Bqca | ||
PRIORITY | Priorite | ||
ACCOUNTSTATEMENTDATE | ReleveDt | ||
PAYAUTHORIZATIONSIGNATORY | BapInter | ||
PAYAUTHORIZATIONMANAGEMENTOFMETHOD | BapCod | ||
LETTREDENTRY | FullPieceLt | ||
BICCODE | Bic | ||
CONTRACTCODE | MndtCod | ||
IBAN | Iban | ||
INTERNATIONALDISCOUNTTYPE | RemVirIntCod | ||
DEBITDISCOUNTTYPE | DebVirIntCod | ||
DOMICILIATION | RibDo | ||
UNCOLLECTIBLEVATFLAG | RecTvaFl | ||
PAYAUTHORIZATIONRETURNDATE | BapDt | ||
DAILLYCESSION | CesCod | ||
BANKACCOUNT | Bqc | ||
CESSIONDATE | CesDt | ||
PURCHASEANDSALEFOLDER | DosG3 | ||
THIRDPARTYTYPE | TiersType | ||
FINALSTATEMENT | CUSTOMER=1, VENDOR=2 | ||
THIRDPARTYCODE | Tiers | ||
PURCHASEANDSALETHIRDPARTY | TiersG3 | ||
ORIGINALSETTLEMENTSTATUS | EtatRegIni | ||
ORIGINALAMOUNT | MtIni | ||
ORIGINALFOREIGNCURRENCYTAMOUNT | MtDevIni | ||
DAS2CODE | CodeDas2 | ||
RULECODE | RegleCod | ||
DAYOFF | ArreteDt | ||
UNCOLLECTIBLEVATFLAG | RecTvaFl | ||
PURCHASEANDSALEFOLDER | DosG3 | ||
THIRDPARTYTYPE | TiersType | ||
#VALEUR! | #VALEUR! | ||
#VALEUR! | #VALEUR! | ||
THIRDPARTYCODE | Tiers | ||
PURCHASEANDSALETHIRDPARTY | TiersG3 | ||
THIRDPARTYPAYER | TiersPayer | ||
THIRDPARTYGROUP | TiersGrp | ||
RELAUNCHTHIRDPARTY | RelTiers |
Table CTAX
Nom de balise | Nom de champ | Version | Remarque |
|---|---|---|---|
FOLDER | Dos | 10.7 | |
ESTABLISHMENT | Etb | ||
ENTRYNO | Ecr | ||
THIRDPARTYVAT | TvaTie | ||
ITEMVAT | tvaArt | ||
ACCOUNTINGDOCUMENTPREFIX | PrefPiece | ||
ACCOUNTINGDOCUMENT | Piece | ||
PAYABILITYDATE | ExDt | ||
AMOUNTEXTAXES | MtHt | ||
VATAMOUNT | MtTva | ||
VATONDEBITORCREDIT | TvaTyp | ||
FLOW | Sens | DEBIT=1, CREDIT=2 | |
VATREVERSECHARGEINDICATOR | FITvaAL | ||
TAXATIONLIABILITYCOEFFICIENT | CoeAss | ||
TAXATIONCOEFFICIENT | CoeTax | ||
ADMISSIONCOEFFICIENT | CoeAdm | ||
DATEOFEFFECT | EffetDt | ||
AMOUNTEXTAXESTOVENTILATE | MtHtVtl | ||
VATAMOUNTTOVENTILATE | MtTvaVtl | ||
AMOUNTEXTAXESREMAINING | MtHtRes | ||
REMAININGVATAMOUNT | MtTvaRes | ||
VATFIXEDASSETS | ImmoFl |
Table CX
Nom de balise | Nom de champ | Version | Remarque |
|---|---|---|---|
FOLDER | Dos | 10.7 | |
ESTABLISHMENT | Etb | ||
ENTRYNO | Ecr | ||
LIGNENO | MaskLg | ||
AXISTABLE | AxeTb | ||
AXIS | Axe | AXIS1=Axe(1) à AXIS4=axe(4) | |
ACCOUNT | Cpt | ||
JOURNAL | Jnl | ||
ENTRYTYPE | EcrTyp | ||
ENTRYDATE | Ecrdt | ||
CURRENCY | Dev | ||
AMOUNT | Mt | ||
FLOW | Sens | DEBIT=1, CREDIT=2 | |
FOREIGNCURRENCYTAMOUNT | MtDev | ||
SECONDARYCURRENCY | MtBis | ||
TRANSACTION | Transac | ||
LEVEL | Niv | ||
LEVELOFTHEKEY | NivCle | ||
ANALYTICALDUMPKEY | DvAncleCod |
Nom de balise | Nom de champ | Version | Remarque |
|---|---|---|---|
FOLDER | Dos | 10.7 | Dossier achat-vente |
ESTABLISHMENT | Etb | Dossier comptable |
(Ici des exemples prêts à copier. Exemple = que la zone data, complet= tout)
Exemple
'data':
{
'entity':'ENT',
'key':{'TICOD':'C', 'PICOD':'2', 'PREFPINO':'', 'PINO':'10000029'},
'filename':'commande10000029.pdf',
'filedata':'JVBERi0xLjQKJeLjz9MKMSAwIG9iago8PAovUGFnZXMgMi'
}
Exemple complet flux XML
{
"action":"WEB_SERVICE_INFINITY",
"access_token":"{{TOKEN}}",
"param":"
{
'action': {'swinfinity': 'associer_fichier'},
'data':
{
'entity':'ENT',
'key':{'TICOD':'C', 'PICOD':'2', 'PREFPINO':'', 'PINO':'10000029'},
'filename':'commande10000029.pdf',
'filedata':'JVBERi0xLjQKJ'
}
}"
}
Format de la réponse :
Balise | Contenu |
|---|---|
error | 0 = pas n’anomalie autre valeur = anomalie |
result | Détail du résultat, notamment le message d’erreur le cas échéant |
Exemple de réponse
{
"error": 0,
"result": "{\"label\": \"infinity\",\"codeScript\": \"associer_fichier\",\"result\":{\"common\":{\"resultcode\": \"0\",\"errormessage\": \"\"},}}",
"txterr": "",
"infos": ""
}