Venice
Spplm properties
 
The available properties for this interface are:
 
Name Get Set Type English description Dutch description French description
pAccountPrc BSTR Purchase: ledger account Aankopen: grootboekrekening Achats: compte de grand-livre
pAccountSls BSTR Sales: ledger account Verkopen: grootboekrekening Ventes: compte de grand-livre
pApplyComDiscount VARIANT_BOOL Apply comm. discount Toepassen handelskorting Appliquer réduction comm.
pApplyFinDiscount VARIANT_BOOL Apply cash discount Toepassen fin. korting Appliquer réduction fin.
pApplyVat BYTE Apply VAT Toepassen BTW Appliquer TVA
pBase BYTE Base Basis Base
pChargePrc BYTE Purchase: charge Aankopen: aanrekenen Achats: compter
pChargeSls BYTE Sales: charge Verkopen: aanrekenen Ventes: compter
pCode BSTR Code Code Code
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
pDeclarationSls BYTE Sales: declare Verkopen: aangeven Ventes: déclarer
pDscLng1 BSTR Description language 1 Omschrijving taal 1 Description langue 1
pDscLng2 BSTR Description language 2 Omschrijving taal 2 Description langue 2
pDscLng3 BSTR Description language 3 Omschrijving taal 3 Description langue 3
pDscLng4 BSTR Description language 4 Omschrijving taal 4 Description langue 4
pDscLng5 BSTR Description language 5 Omschrijving taal 5 Description langue 5
pDscLng6 BSTR Description language 6 Omschrijving taal 6 Description langue 6
pFactor DOUBLE Factor Factor Facteur
pFromDate DATE (date) From date Vanaf datum Depuis date
pImagePath BSTR Image path Pad afbeelding Chemin image
pInfo BSTR Information Informatie Information
pInvoiceTypesPrc BSTR Purchase: layout types Aankopen: lay-outtypes Achats: types de mise en page
pInvoiceTypesSls BSTR Sales: layout types Verkopen: lay-outtypes Ventes: type de mise en page
pPrintCode BSTR Print code Afdrukcode Code d'impression
pPrintDetailPrc VARIANT_BOOL Purchase: print in detail Aankopen: afdrukken in detail Achats: imprimer en détail
pPrintDetailSls VARIANT_BOOL Sales: print in detail Verkopen: afdrukken in detail Ventes: imprimer en détail
pRecuperation VARIANT_BOOL Recycling Recuperatie Récuperation
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
pTransferBasePrc VARIANT_BOOL Purchase: transfer base Aankopen: basis doorboeken Achats: transférer base
pTransferBaseSls VARIANT_BOOL Sales: transfer base Verkopen: basis doorboeken Ventes: transférer base
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
             
vApplyVatDsc BSTR Apply VAT descr. Toepassen BTW omschr. Appliquer TVA descr.
vBaseDsc BSTR Base descr. Basis omschr. Base descr.
vChargePrcDsc BSTR Purchase: charge descr. Aankopen: aanrekenen omschr. Achats: compter descr.
vChargeSlsDsc BSTR Sales: charge descr. Verkopen: aanrekenen omschr. Ventes: compter descr.
vDeclarationSlsDsc BSTR Sales: declare descr. Verkopen: aangeven omschr. Ventes: déclarer descr.
vDscLngCxt BSTR Description language context Omschrijving taal context Description langue contexte
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 'SPL - Supplement (Spplm.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.