Venice
Sales properties
 
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.