Venice
StockDocDet properties
 
The available properties for this interface are:
 
Name Get Set Type English description Dutch description French description
pArtNum BSTR Article number Artikelnummer Numéro d'article
pArtNumStock BSTR Number stock article Nummer voorraadartikel Numéro d'article stock
pBook BSTR Book Dagboek Journal
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
pDocDate DATE (date) Document date Documentdatum Date document
pDocNum LONG Document number Documentnummer Numéro document
pDocType BYTE Document type Documenttype Type document
pMinStockUnit DOUBLE Minimum stock unit Kleinste eenheid voorraad Unité minimale stock
pPurchasePrice DOUBLE Purchase price Aankoopprijs Prix d'achat
pPurchaseValue DOUBLE Purchase value-VAT Aankoopwaarde-BTW Valeur d'achat-TVA
pPurchPriceCurCode BSTR Currency code purchase price Muntcode aankoopprijs Code de la devise prix d'achat
pPurchUnit DOUBLE Purchase unit Aankoopeenheid Unité d'achat
pQuantity DOUBLE Quantity Hoeveelheid Quantité
pRemark BSTR Remark Opmerking Remarque
pSalesPrice DOUBLE Sales price Verkoopprijs Prix de vente
pSalesUnit DOUBLE Sales unit Verkoopeenheid Unité de vente
pSerialNumbers BYTE Serial numbers Serienummers Numéros de série
pStock BYTE Stock Voorraad bijhouden Tenir à jour stock
pSysNum LONG System number Systeemnummer Numéro de système
pText1 BSTR Text field 1 Tekstveld 1 Champ de texte 1
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 numerique 1
             
vAccYear SHORT Financial year Boekjaar Exercice
vDocTypeDsc BSTR Document type descr. Documenttype omschr. Type document descr.
vLine LONG Line number Lijnnummer Numéro de ligne
vSerialNumbersDsc BSTR Serial numbers descr. Serienummers omschr. Numéros de série descr.
vStockDsc BSTR StockDsc Voorraad bijhouden omschr. Descr. tenir à jour stock
 
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 'STD - Stock document detail (Stc_d.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.