Fields available for ORDRG (Sales orders lines)

Fields available for ORDRG (Sales orders lines)

Available fields for sales orders

Fields from type BOOLEAN can have values:  J (=Yes) or N (=No) .

Public Class [ORDRG]
'''<summary>Quantity, NUMERIC, Length: 14</summary>
 Public Const [AANT] As String = "AANT"
 '''<summary>Billed quantity, NUMERIC, Length: 14, not accessible</summary>
 Public Const [AANTGEFACT] As String = "AANTGEFACT"
 '''<summary>Delivered quantity, NUMERIC, Length: 14, not accessible</summary>
 Public Const [AANTGELEV] As String = "AANTGELEV"
 '''<summary>Deliver quantity, NUMERIC, Length: 14</summary>
 Public Const [AANTTELEV] As String = "AANTTELEV"
 '''<summary>Print on invioce, CHAR, Length: 1</summary>
 Public Const [AFDRFACT] As String = "AFDRFACT"
 '''<summary>Print on order confirmation , CHAR, Length: 1</summary>
 Public Const [AFDRORDBEV] As String = "AFDRORDBEV"
 '''<summary>Print on pick list/pickbon, CHAR, Length: 1</summary>
 Public Const [AFDRPICK] As String = "AFDRPICK"
 '''<summary>Print on package list, CHAR, Length: 1</summary>
 Public Const [AFDRVERZ] As String = "AFDRVERZ"
 '''<summary>Product, CHAR, Length: 20, verplicht</summary>
 Public Const [ART] As String = "ART"
 '''<summary>Product group, NUMERIC, Length: 3, not accessible</summary>
 Public Const [ARTGRP] As String = "ARTGRP"
 '''<summary>Amount, MONEY, not accessible</summary>
 Public Const [BEDR] As String = "BEDR"
 '''<summary>Amount incl., MONEY, not accessible</summary>
 Public Const [BEDRINCL] As String = "BEDRINCL"
 '''<summary>Payer (debtor), NUM, Length: 8, not accessible, verplicht</summary>
 Public Const [BETALER] As String = "BETALER"
 '''<summary>Block, BOOLEAN</summary>
 Public Const [BLOK] As String = "BLOK"
 '''<summary>VAT type, CHAR, Length: 1, not accessible</summary>
 Public Const [BTWSRT] As String = "BTWSRT"
 '''<summary>Colli, NUMERIC, Length: 8</summary>
 Public Const [COLLI] As String = "COLLI"
 '''<summary>Order date, DATE</summary>
 Public Const [DAT] As String = "DAT"
 '''<summary>Invoice date, DATETIME, not accessible</summary>
 Public Const [DATFACT] As String = "DATFACT"
 '''<summary>Delivery~date, DATE</summary>
 Public Const [DATLEV] As String = "DATLEV"
 '''<summary>Delivery date changed, CHAR, Length: 1</summary>
 Public Const [DATLEVGEWIJZ] As String = "DATLEVGEWIJZ"
 '''<summary>Date order confirmation printed, DATETIME, not accessible</summary>
 Public Const [DATORDBEV] As String = "DATORDBEV"
 '''<summary>Debtor, NUMERIC, Length: 8, not accessible, verplicht</summary>
 Public Const [DEB] As String = "DEB"
 '''<summary>Sales unit, CHAR, Length: 20</summary>
 Public Const [EENH] As String = "EENH"
 '''<summary>Sales price unit, NUMERIC, Length: 4, not accessible</summary>
 Public Const [EENHPRS] As String = "EENHPRS"
 '''<summary>Packaging material-product, NUMERIC, Length: 6, not accessible</summary>
 Public Const [EMBALLAGERG] As String = "EMBALLAGERG"
 '''<summary>External order~number, NUMERIC, Length: 9</summary>
 Public Const [EXTORDNR] As String = "EXTORDNR"
 '''<summary>On invoice, NUMERIC, Length: 9, not accessible</summary>
 Public Const [FACT] As String = "FACT"
 '''<summary>Wait for order confirmation, CHAR, Length: 1, not accessible</summary>
 Public Const [GEBRORDBEV] As String = "GEBRORDBEV"
 '''<summary>Contents, NUMERIC, Length: 9</summary>
 Public Const [INHOUD] As String = "INHOUD"
 '''<summary>Is textline, CHAR, Length: 1, not accessible</summary>
 Public Const [ISTEKSTRG] As String = "ISTEKSTRG"
 '''<summary>Cost unit, NUMERIC, Length: 8</summary>
 Public Const [KDR] As String = "KDR"
 '''<summary>Cost value on entry , MONEY, not accessible</summary>
 Public Const [KOSTPR] As String = "KOSTPR"
 '''<summary>Cost center, NUMERIC, Length: 8</summary>
 Public Const [KPL] As String = "KPL"
 '''<summary>Delevery correction, CHAR, Length: 1, not accessible</summary>
 Public Const [LEVERCORR] As String = "LEVERCORR"
 '''<summary>Storage, NUMERIC, Length: 8, verplicht</summary>
 Public Const [MAG] As String = "MAG"
 '''<summary>Description, CHAR, Length: 40</summary>
 Public Const [OMSCHR] As String = "OMSCHR"
 '''<summary>External remarks, MEMO, Length: 1024</summary>
 Public Const [OPMEXT] As String = "OPMEXT"
 '''<summary>Internal remarks, MEMO, Length: 1024</summary>
 Public Const [OPMINT] As String = "OPMINT"
 '''<summary>Order, NUMERIC, Length: 9, primary key, verplicht</summary>
 Public Const [ORDNR] As String = "ORDNR"
 '''<summary>Discount%, NUMERIC, Length: 6</summary>
 Public Const [PERCKORT] As String = "PERCKORT"
 '''<summary>Discount% changed, CHAR, Length: 1, not accessible</summary>
 Public Const [PERCKORTGEWIJZ] As String = "PERCKORTGEWIJZ"
 '''<summary>Discount over discount%, NUMERIC, Length: 6</summary>
 Public Const [PERCKORTKORT] As String = "PERCKORTKORT"
 '''<summary>Discount over discount% changed, CHAR, Length: 1, not accessible</summary>
 Public Const [PERCKORTKORTWIJZ] As String = "PERCKORTKORTWIJZ"
 '''<summary>Price, MONEY</summary>
 Public Const [PRS] As String = "PRS"
 '''<summary>Price changed, CHAR, Length: 1</summary>
 Public Const [PRSGEWIJZ] As String = "PRSGEWIJZ"
 '''<summary>Price including VAT, MONEY</summary>
 Public Const [PRSINCL] As String = "PRSINCL"
 '''<summary>Rayon, NUMERIC, Length: 8</summary>
 Public Const [RAYON] As String = "RAYON"
 '''<summary>Line, NUMERIC, Length: 6, primary key, verplicht</summary>
 Public Const [RG] As String = "RG"
 '''<summary>Line combination details, NUMERIC, Length: 6, not accessible</summary>
 Public Const [SAMENRG] As String = "SAMENRG"
 '''<summary>State, CHAR, Length: 1, not accessible</summary>
 Public Const [STATUS] As String = "STATUS"
 '''<summary>Currency, CHAR, Length: 3, not accessible</summary>
 Public Const [VAL] As String = "VAL"
 '''<summary>Sales person, CHAR, Length: 20</summary>
 Public Const [VERKOPER] As String = "VERKOPER"
 '''<summary>Volume (m³), NUMERIC, Length: 14</summary>
 Public Const [VOLUME] As String = "VOLUME"
End Class