SOfferDet properties

The available properties for this interface are:

Name	Get	Set	Type	English description	Dutch description	French description
pAmountSup1VatExDocC			DOUBLE	Supplement 1: amount-VAT document currency	Supplement 1: bedrag-BTW documentmunt	Supplément 1: montant-TVA devise document
pAmountSup1VatInDocC			DOUBLE	Supplement 1: amount+VAT document currency	Supplement 1: bedrag+BTW documentmunt	Supplément 1: montant+TVA devise document
pAmountSup2VatExDocC			DOUBLE	Supplement 2: amount-VAT document currency	Supplement 2: bedrag-BTW documentmunt	Supplément 2: montant-TVA devise document
pAmountSup2VatInDocC			DOUBLE	Supplement 2: amount+VAT document currency	Supplement 2: bedrag+BTW documentmunt	Supplément 2: montant+TVA devise document
pAmountSup3VatExDocC			DOUBLE	Supplement 3: amount-VAT document currency	Supplement 3: bedrag-BTW documentmunt	Supplément 3: montant-TVA devise document
pAmountSup3VatInDocC			DOUBLE	Supplement 3: amount+VAT document currency	Supplement 3: bedrag+BTW documentmunt	Supplément 3: montant+TVA devise document
pAmountSup4VatExDocC			DOUBLE	Supplement 4: amount-VAT document currency	Supplement 4: bedrag-BTW documentmunt	Supplément 4: montant-TVA devise document
pAmountSup4VatInDocC			DOUBLE	Supplement 4: amount+VAT document currency	Supplement 4: bedrag+BTW documentmunt	Supplément 4: montant+TVA devise document
pAnaCentre			BSTR	Analyt. centre: proposal/account	Analyt. plaats: voorstel/rekening	Centre analyt.: proposition/compte
pAnaUnit			BSTR	Analyt. unit: proposal/account	Analyt. drager: voorstel/rekening	Produit analyt.: proposition/compte
pArtDsc			BSTR	Article description	Artikelomschrijving	Description de l'article
pArtNum			BSTR	Article number	Artikelnummer	Numéro d'article
pBook			BSTR	Book	Dagboek	Journal
pComDiscount			DOUBLE	Commercial discount	Handelskorting	Réduction commerciale
pComDiscountExcise			VARIANT_BOOL	Comm. discount on excise	Handelskorting op accijns	Réduction comm. sur accise
pComDiscountOn			VARIANT_BOOL	Apply comm. discount	Handelskorting toepassen	Réduction comm. appliquer
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
pCurrency			BSTR	Currency	Munt	Devise
pDate1			DATE (date)	Date 1	Datum 1	Date 1
pDate2			DATE (date)	Date 2	Datum 2	Date 2
pDiscount1			DOUBLE	Discount 1	Korting 1	Réduction 1
pDiscount2			DOUBLE	Discount 2	Korting 2	Réduction 2
pDocDate			DATE (date)	Document date	Documentdatum	Date document
pDocNum			LONG	Document number	Documentnummer	Numéro document
pEmptiesDocC			DOUBLE	Empties document currency	Leeggoed documentmunt	Emballages consignés devise de document
pExciseDocC			DOUBLE	Excise document currency	Accijns documentmunt	Accise devise de document
pFinDiscountOn			VARIANT_BOOL	Apply cash discount	Fin. korting toepassen	Réduction fin. appliquer
pIcCode			BYTE	IC code	IC-code	Code IC
pNumDecLineAmount			BYTE	Decimals line amount	Decimalen lijntotaal	Décimales total de ligne
pNumDecPrice			BYTE	Decimals price	Decimalen prijs	Décimales prix
pPriceDocC			DOUBLE	Price document currency	Prijs documentmunt	Prix devise de document
pPrintLine			BYTE	Print line	Lijn afdrukken	Imprimer ligne
pPurchaseValueDocC			DOUBLE	Purchase value-VAT document currency	Aankoopwaarde-BTW documentmunt	Valeur d'achat-TVA devise de document
pQuantity			DOUBLE	Quantity	Hoeveelheid	Quantité
pQuantityIndex			BYTE	Quantity index	Index hoeveelheid	Index quantité
pQuantityX			DOUBLE	QuantityX	QuantityX	QuantityX
pRate			DOUBLE	Rate	Koers	Cours
pRemark			BSTR	Remark	Opmerking	Remarque
pSalesUnit			DOUBLE	Sales unit	Verkoopeenheid	Unité de vente
pSupplCode1			BSTR	Supplement 1: code	Supplement 1: code	Supplément 1: code
pSupplCode2			BSTR	Supplement 2: code	Supplement 2: code	Supplément 2: code
pSupplCode3			BSTR	Supplement 3: code	Supplement 3: code	Supplément 3: code
pSupplCode4			BSTR	Supplement 4: code	Supplement 4: code	Supplément 4: code
pSupplNumber1			DOUBLE	Supplement 1: number	Supplement 1: aantal	Supplément 1: nombre
pSupplNumber2			DOUBLE	Supplement 2: number	Supplement 2: aantal	Supplément 2: nombre
pSupplNumber3			DOUBLE	Supplement 3: number	Supplement 3: aantal	Supplément 3: nombre
pSupplNumber4			DOUBLE	Supplement 4: number	Supplement 4: aantal	Supplément 4: nombre
pSysNum			LONG	System number	Systeemnummer	Numéro de système
pText1			BSTR	Text field 1	Tekstveld 1	Champ de texte 1
pTrnDetail			VARIANT_BOOL	Copy detail line	Detaillijn overnemen	Copier ligne de détail
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
pVatCode			BYTE	VAT code	BTW-code	Code de TVA
pVatIncluded			VARIANT_BOOL	Price including VAT	Prijs inclusief BTW	Prix TVA incluse
pVatRate			DOUBLE	VAT rate	BTW-tarief	Taux de TVA
pWayLineAmount			BYTE	Way of calculation line amount	Berekeningswijze lijntotaal	Méthode de calcul total de ligne
pWeight			DOUBLE	Weight	Gewicht	Poids

vAccYear			SHORT	Financial year	Boekjaar	Exercice
vAmountSup1VatExDosC			DOUBLE	Supplement 1: amount-VAT dossier currency	Supplement 1: bedrag-BTW dossiermunt	Supplément 1: montant-TVA devise de dossier
vAmountSup1VatInDosC			DOUBLE	Supplement 1: amount+VAT dossier currency	Supplement 1: bedrag+BTW dossiermunt	Supplément 1: montant+TVA devise de dossier
vAmountSup2VatExDosC			DOUBLE	Supplement 2: amount-VAT dossier currency	Supplement 2: bedrag-BTW dossiermunt	Supplément 2: montant-TVA devise de dossier
vAmountSup2VatInDosC			DOUBLE	Supplement 2: amount+VAT dossier currency	Supplement 2: bedrag+BTW dossiermunt	Supplément 2: montant+TVA devise de dossier
vAmountSup3VatExDosC			DOUBLE	Supplement 3: amount-VAT dossier currency	Supplement 3: bedrag-BTW dossiermunt	Supplément 3: montant-TVA devise de dossier
vAmountSup3VatInDosC			DOUBLE	Supplement 3: amount+VAT dossier currency	Supplement 3: bedrag+BTW dossiermunt	Supplément 3: montant+TVA devise de dossier
vAmountSup4VatExDosC			DOUBLE	Supplement 4: amount-VAT dossier currency	Supplement 4: bedrag-BTW dossiermunt	Supplément 4: montant-TVA devise de dossier
vAmountSup4VatInDosC			DOUBLE	Supplement 4: amount+VAT dossier currency	Supplement 4: bedrag+BTW dossiermunt	Supplément 4: montant+TVA devise de dossier
vDocAmountVatExDosC			DOUBLE	Line amount-VAT-discounts-commercial discount dossier currency	Lijntotaal-BTW-kortingen-handelskorting dossiermunt	Total de ligne-TVA-réductions-réduction comm. devise de dossier
vDocAmountVatInDosC			DOUBLE	Line amount+VAT-discounts-commercial discount dossier currency	Lijntotaal+BTW-kortingen-handelskorting dossiermunt	Total de ligne+TVA-réductions-réduction comm. devise de dossier
vDocPriceVatExDosC			DOUBLE	Price-VAT-discounts-commercial discount dossier currency	Prijs-BTW-kortingen-handelskorting dossiermunt	Prix-TVA-réductions-réduction comm. devise de dossier
vDocPriceVatInDosC			DOUBLE	Price+VAT-discounts-commercial discount dossier currency	Prijs+BTW-kortingen-handelskorting dossiermunt	Prix+TVA-réductions-réduction comm. devise de dossier
vDosCurrency			BSTR	Dossier currency	Dossiermunt	Devise de dossier
vLine			SHORT	Line number	Lijnnummer	Numéro de ligne
vLneAmountDocC			DOUBLE	Line amount-discounts document currency	Lijntotaal-kortingen documentmunt	Total de ligne-réductions devise de document
vLneAmountVatExDosC			DOUBLE	Line amount-VAT-discounts dossier currency	Lijntotaal-BTW-kortingen dossiermunt	Total de ligne-TVA-réductions devise de dossier
vLneAmountVatInDosC			DOUBLE	Line amount+VAT-discounts dossier currency	Lijntotaal+BTW-kortingen dossiermunt	Total de ligne+TVA-réductions devise de dossier
vLnePriceVatExDosC			DOUBLE	Price-VAT-discounts dossier currency	Prijs-BTW-kortingen dossiermunt	Prix-TVA-réductions devise de dossier
vLnePriceVatInDosC			DOUBLE	Price+VAT-discounts dossier currency	Prijs+BTW-kortingen dossiermunt	Prix+TVA-réductions devise de dossier
vPriceVatExDosC			DOUBLE	Price-VAT dossier currency	Prijs-BTW dossiermunt	Prix-TVA devise de dossier
vPrintLineDsc			BSTR	Print line description	Lijn afdrukken omschrijving	Imprimer ligne description
vProfitAmountDocC			DOUBLE	Profit amount document currency	Winst bedrag documentmunt	Bénéfice montant devise de document
vProfitAmountDosC			DOUBLE	Profit amount dossier currency	Winst bedrag dossiermunt	Bénéfice montant devise de dossier
vProfitPercPurch			DOUBLE	Profit percentage on purchase value	Winst percentage op aankoopwaarde	Bénéfice pourcentage sur valeur d'achat
vProfitPercSales			DOUBLE	Profit percentage on sales value	Winst percentage op verkoopwaarde	Bénéfice pourcentage sur valeur de vente
vPurchaseValueDosC			DOUBLE	Purchase value-VAT dossier currency	Aankoopwaarde-BTW dossiermunt	Valeur d'achat-TVA devise de dossier
vTotPurchValueDosC			DOUBLE	Purchase value line dossier currency	Aankoopwaarde lijn dossiermunt	Valeur d'achat ligne devise de dossier

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 'SOD - Offer detail (Iso_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.