Sales properties (Interface: Sales)
The available properties for this interface are:   Name Get Set Type English description Dutch description French description pAccYear SHORT Financial year Boekjaar Exercice pAprValueDocC DOUBLE Acquisition value document currency Aanschafwaarde documentmunt Valeur d'acquisition devise de document pBaseCoPartDocC DOUBLE Base copartner document currency Maatstaf medec. documentmunt Base taxable cocontr. devise de document pBaseExportDocC DOUBLE Base export document currency Maatstaf uitvoer documentmunt Base taxable export. devise de document pBaseFinDiscountDocC DOUBLE Base cash discount document currency Maatstaf fin. korting documentmunt Base taxable réd. fin. devise de document pBaseForeignVatDocC DOUBLE Base foreign VAT Maatstaf buitenl. BTW documentmunt Base taxable TVA étrangère devise de document pBaseIcAssmDistDocC DOUBLE Base IC assembly/distance document currency Maatstaf IC montage/afstand documentmunt Base taxable montage/distance IC devise de document pBaseIcGoodsDocC DOUBLE Base IC goods document currency Maatstaf IC-goederen documentmunt Base taxable march. IC devise de document pBaseIcServicesDocC DOUBLE Base IC services document currency Maatstaf IC-diensten documentmunt Base taxable services IC devise de document pBaseNotSubmitDocC DOUBLE Base not submitted document currency Maatstaf niet-onderworpen documentmunt Base taxable non-soumis devise de document pBaseVat1DocC DOUBLE Base VAT 1 document currency Maatstaf BTW-tarief 1 documentmunt Base taxable TVA 1 devise de document pBaseVat2DocC DOUBLE Base VAT 2 document currency Maatstaf BTW-tarief 2 documentmunt Base taxable TVA 2 devise de document pBaseVat3DocC DOUBLE Base VAT 3 document currency Maatstaf BTW-tarief 3 documentmunt Base taxable TVA 3 devise de document pBaseVat4DocC DOUBLE Base VAT 4 document currency Maatstaf BTW-tarief 4 documentmunt Base taxable TVA 4 devise de document pBaseVat5DocC DOUBLE Base VAT 5 document currency Maatstaf BTW-tarief 5 documentmunt Base taxable TVA 5 devise de document pBaseVat6DocC DOUBLE Base VAT 6 document currency Maatstaf BTW-tarief 6 documentmunt Base taxable TVA 6 devise de document pBook BSTR Book Dagboek Journal pBookDate DATE (date) Entry date Boekingsdatum Date d'enregistrement pClass BSTR Classification Klassement Classement pCreDate DATE (date) Addition: date Toevoeging: datum Addition: date pCreTime DATE (time) Addition: time Toevoeging: tijdstip Addition: temps pCreUsr BSTR Addition: by Toevoeging: door Addition: par pCstAccount BSTR Customer: account Klant: rekening Client: compte pCstNum LONG Customer: number Klant: nummer Client: numéro pCstSubNum LONG Customer: subnumber Klant: subnummer Client: sous-numéro pCurrency BSTR Currency Munt Devise pDocDate DATE (date) Document date Documentdatum Date document pDocNum LONG Document number Documentnummer Numéro document pDocType BYTE Document type Documenttype Type document pEntries SHORT Number of entries Aantal boekingen Nombre d'écritures pExpDate DATE (date) Expiry date Vervaldatum Date d'échéance pFinDiscount DOUBLE Cash discount Fin. korting Réduction fin. pFlagMatAssets BYTE Code material assets Code vaste activa Code immob. corp. pImagePath BSTR Image path Pad afbeelding Chemin image pInfo BSTR Information Informatie Information pInvoiceId BSTR Identification goods document Identificatie goederendocument Identification document de march. pIsAbc VARIANT_BOOL ABC document ABC-document Document ABC pIsProtected VARIANT_BOOL Protected Beveiligd Protégé pIsTicked VARIANT_BOOL Payed Betaald Payé pLawyerState BYTE Lawyer state Status raadsman Etat conseiller pMandateId BSTR Mandate identification Mandaatreferte Référence de mandat pMargin VARIANT_BOOL Margin Margeregeling Marge pMinDocUnit DOUBLE Smallest unit Kleinste eenheid Unité minimale pNumDecDocument BYTE Decimals document Decimalen document Décimales document pOpenDocC DOUBLE Unpaid amount document currency Open bedrag documentmunt Montant non réglé devise de document pOpenDosC DOUBLE Unpaid amount dossier currency Open bedrag dossiermunt Montant non réglé devise de dossier pRate DOUBLE Rate Koers Cours pReferenceCst BSTR Customer reference Referentie klant Référence client pRemark BSTR Remark Opmerking Remarque pRemDate DATE (date) Date last reminder Datum laatste rappel Date dernier rappel pReminder VARIANT_BOOL Send reminders Rappels versturen Envoyer des rappels pRemLevel BYTE Reminder level Rappelgraad Degré de rappel pRepresentative BSTR Representative Vertegenwoordiger Représentant pStatCode BSTR Statistics code Statistiekcode Code statistique pSyncProtected VARIANT_BOOL Synchronization: protected Synchronisatie: beveiligd Synchronisation: protégé pSyncReference BSTR Synchronization: reference Synchronisatie: referentie Synchronisation: référence pSyncStatus BYTE Synchronization: status Synchronisatie: status Synchronisation: état pSysNum LONG System number Systeemnummer Numéro de système pText1 BSTR Text field 1 Tekstveld 1 Champ de texte 1 pText2 BSTR Text field 2 Tekstveld 2 Champ de texte 2 pText3 BSTR Text field 3 Tekstveld 3 Champ de texte 3 pText4 BSTR Text field 4 Tekstveld 4 Champ de texte 4 pTotalDocC DOUBLE Amount document currency Totaal documentmunt Montant devise de document pTotalDosC DOUBLE Amount dossier currency Totaal dossiermunt Montant devise de dossier pTsmNumber BSTR TSM number OGM-nummer Numéro VCS pUpdDate DATE (date) Modification: date Wijziging: datum Modification: date pUpdTime DATE (time) Modification: time Wijziging: tijdstip Modification: temps pUpdUsr BSTR Modification: by Wijziging: door Modification: par pValue1 DOUBLE Numerical field 1 Numeriek veld 1 Champ numérique 1 pValue2 DOUBLE Numerical field 2 Numeriek veld 2 Champ numérique 2 pValue3 DOUBLE Numerical field 3 Numeriek veld 3 Champ numérique 3 pValue4 DOUBLE Numerical field 4 Numeriek veld 4 Champ numérique 4 pVatCode BYTE VAT code BTW-code Code de TVA pVatDedNormDocC DOUBLE VAT deduct. document currency BTW aftrekb. documentmunt TVA déduct. devise de document pVatDueNormDocC DOUBLE VAT due document currency BTW verschuld. documentmunt TVA due devise de document pVatError VARIANT_BOOL VAT error BTW-fout Faute TVA pVatRate1 DOUBLE VAT rate 1 BTW-tarief 1 Taux de TVA 1 pVatRate2 DOUBLE VAT rate 2 BTW-tarief 2 Taux de TVA 2 pVatRate3 DOUBLE VAT rate 3 BTW-tarief 3 Taux de TVA 3 pVatRate4 DOUBLE VAT rate 4 BTW-tarief 4 Taux de TVA 4 pVatRate5 DOUBLE VAT rate 5 BTW-tarief 5 Taux de TVA 5 pVatRate6 DOUBLE VAT rate 6 BTW-tarief 6 Taux de TVA 6               vDocTypeCode CHAR Document type code Documenttype code Type document code vDocTypeDsc BSTR Document type descr. Documenttype omschr. Type document descr. vDosCurrency BSTR Dossier currency Dossiermunt Devise de dossier vFlagMatAssetsDsc BSTR Code material assets descr. Code vaste activa omschr. Code immob. corp. descr. vFormatTsmNumber BSTR Formatted TSM number OGM-nummer met opmaak Numéro VCS formaté vLawyerStateDsc BSTR Lawyer state descr. Status raadsman omschr. Etat conseiller descr. vVatCodeDsc BSTR VAT code descr. BTW-code omschr. Code de TVA descr.   Remarks Properties starting with the character 'p' are the 'real', physical fields of this interface, the ones starting with 'v' are 'virtual' fields. The value of p-fields is written to disk, while the value of v-fields is calculated at run time. The get accessor of these properties returns a VARIANT. The set accessor of these properties needs a VARIANT as input. More detailed information on these properties (type, length,...) can be found in the 'ODBC File Description'-module of your Venice installation. See file 'ASL - Sale (Asals.btr)'. The property names that are underlined represent BYTE fields that can have several values. Click on the link to see more information on the possible choices. Calculation fields are added dynamically and cannot be used as properties. They should be used as described in 'How to use calculation fields?'. You should consult the module parameters to get the necessary info on these calculation fields.
Exact C-Logic Development Kit