Available fields for sales orders

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

Public Class [ORDKOP]
 '''<summary>Amount cash discount, MONEY, </summary>
 Public Const [BEDRBETKORT] As String = "BEDRBETKORT"
 '''<summary>Amount CASH DISCOUNT incl. vat, MONEY, not accessible</summary>
 Public Const [BEDRBETKORTINCL] As String = "BEDRBETKORTINCL"
 '''<summary>Amount excl VAT in EU, MONEY, not accessible</summary>
 Public Const [BEDRBINEU] As String = "BEDRBINEU"
 '''<summary>Amount excl VAT outside EU, MONEY, not accessible</summary>
 Public Const [BEDRBUIEU] As String = "BEDRBUIEU"
 '''<summary>Billed excl VAT, MONEY, not accessible</summary>
 Public Const [BEDRFACT] As String = "BEDRFACT"
 '''<summary>Amount excl BTW geen, MONEY, not accessible</summary>
 Public Const [BEDRGEEN] As String = "BEDRGEEN"
 '''<summary>Amount for G-rekening, MONEY</summary>
 Public Const [BEDRGREK] As String = "BEDRGREK"
 '''<summary>Amount excl VAT hoog, MONEY, not accessible</summary>
 Public Const [BEDRHOOG] As String = "BEDRHOOG"
 '''<summary>Amount incl VAT in EU, MONEY, not accessible</summary>
 Public Const [BEDRINCLBINEU] As String = "BEDRINCLBINEU"
 '''<summary>Amount incl VAT outside EU, ONEY, not accessible</summary>
 Public Const [BEDRINCLBUIEU] As String = "BEDRINCLBUIEU"
 '''<summary>Billed incl VAT, MONEY, not accessible</summary>
 Public Const [BEDRINCLFACT] As String = "BEDRINCLFACT"
 '''<summary>Amount incl VAT none, MONEY, not accessible</summary>
 Public Const [BEDRINCLGEEN] As String = "BEDRINCLGEEN"
 '''<summary>Amount incl VAT high, MONEY, not accessible</summary>
 Public Const [BEDRINCLHOOG] As String = "BEDRINCLHOOG"
 '''<summary>Amount incl VAT low, MONEY, not accessible</summary>
 Public Const [BEDRINCLLAAG] As String = "BEDRINCLLAAG"
 '''<summary>Outstanding incl VAT, MONEY, not accessible</summary>
 Public Const [BEDRINCLOPEN] As String = "BEDRINCLOPEN"
 '''<summary>Total incl VAT, MONEY, not accessible</summary>
 Public Const [BEDRINCLTOT] As String = "BEDRINCLTOT"
 '''<summary>Amount incl VAT Reversed Charges, MONEY, not accessible</summary>
 Public Const [BEDRINCLVERLEGD] As String = "BEDRINCLVERLEGD"
 '''<summary>Amount credit squeeze, MONEY, not accessible</summary>
 Public Const [BEDRKB] As String = "BEDRKB"
 '''<summary>Amount credit squeeze incl. VAT, MONEY, not accessible</summary>
 Public Const [BEDRKBINCL] As String = "BEDRKBINCL"
 '''<summary>Cost value, MONEY, not accessible</summary>
 Public Const [BEDRKOSTPR] As String = "BEDRKOSTPR"
 '''<summary>Amount excl VAT low, MONEY, not accessible</summary>
 Public Const [BEDRLAAG] As String = "BEDRLAAG"
 '''<summary>Outstanding excl VAT, MONEY, not accessible</summary>
 Public Const [BEDROPEN] As String = "BEDROPEN"
 '''<summary>Order costs, MONEY</summary>
 Public Const [BEDRORDKST] As String = "BEDRORDKST"
 '''<summary>Order costs billed incl. VAT, MONEY, not accessible</summary>
 Public Const [BEDRORDKSTFACTIN] As String = "BEDRORDKSTFACTIN"
 '''<summary>Order costs billed, MONEY, not accessible</summary>
 Public Const [BEDRORDKSTGEFACT] As String = "BEDRORDKSTGEFACT"
 '''<summary>Order costs gewijzigd, CHAR, lengte: 1, not accessible</summary>
 Public Const [BEDRORDKSTGEWIJZ] As String = "BEDRORDKSTGEWIJZ"
 '''<summary>Order costs incl. VAT, MONEY</summary>
 Public Const [BEDRORDKSTINCL] As String = "BEDRORDKSTINCL"
 '''<summary>Total excl VAT, MONEY, not accessible</summary>
 Public Const [BEDRTOT] As String = "BEDRTOT"
 '''<summary>Amount excl VAT reversed charges, MONEY, not accessible</summary>
 Public Const [BEDRVERLEGD] As String = "BEDRVERLEGD"
 '''<summary>Freight costs, MONEY</summary>
 Public Const [BEDRVRACHTKST] As String = "BEDRVRACHTKST"
 '''<summary> Freight costs changed, CHAR, lengte: 1, not accessible</summary>
 Public Const [BEDRVRACHTKSTWZ] As String = "BEDRVRACHTKSTWZ"
 '''<summary>Freight costs billed incl. VAT, MONEY, not accessible</summary>
 Public Const [BEDRVRKSTFACTINC] As String = "BEDRVRKSTFACTINC"
 '''<summary>Freight costs billed, MONEY, not accessible</summary>
 Public Const [BEDRVRKSTGEFACT] As String = "BEDRVRKSTGEFACT"
 '''<summary>Feight costs incl. VAT, MONEY</summary>
 Public Const [BEDRVRKSTINCL] As String = "BEDRVRKSTINCL"
 '''<summary>Payer, NUMERIC, lengte: 8, verplicht</summary>
 Public Const [BETALER] As String = "BETALER"
 '''<summary>Payment code, CHAR, lengte: 1</summary>
 Public Const [BETCODE] As String = "BETCODE"
 '''<summary>Terms of payment, NUMERIC, lengte: 3, verplicht</summary>
 Public Const [BETCOND] As String = "BETCOND"
 '''<summary>Block, BOOLEAN</summary>
 Public Const [BLOK] As String = "BLOK"
 '''<summary>VAT-liable, CHAR, lengte: 1, not accessible</summary>
 Public Const [BTWPL] As String = "BTWPL"
 '''<summary>Order date, DATE, verplicht</summary>
 Public Const [DAT] As String = "DAT"
 '''<summary>Delivery~date, DATE</summary>
 Public Const [DATLEV] As String = "DATLEV"
 '''<summary>Delivery date changed, CHAR, lengte: 1</summary>
 Public Const [DATLEVGEWIJZ] As String = "DATLEVGEWIJZ"
 '''<summary>Latest delivery date, DATE</summary>
 Public Const [DATLEVUITERST] As String = "DATLEVUITERST"
 '''<summary>Date order confirmation printed, DATE, not accessible</summary>
 Public Const [DATORDBEV] As String = "DATORDBEV"
 '''<summary>Pickdate, DATE</summary>
 Public Const [DATPICK] As String = "DATPICK"
 '''<summary>Blocked to date, DATE, not accessible</summary>
 Public Const [DATVAST] As String = "DATVAST"
 '''<summary>Date/time last process, DATETIME, not accessible</summary>
 Public Const [DATVRWRK] As String = "DATVRWRK"
 '''<summary>Debtor, NUMERIC, lengte: 8, verplicht</summary>
 Public Const [DEB] As String = "DEB"
 '''<summary>External order number, NUMERIC, lengte: 9</summary>
 Public Const [EXTORDNR] As String = "EXTORDNR"
 '''<summary>Wait for confirmation accord, CHAR, lengte: 1</summary>
 Public Const [GEBRORDBEV] As String = "GEBRORDBEV"
 '''<summary>Fully billed, CHAR, lengte: 1</summary>
 Public Const [GEFACT] As String = "GEFACT"
 '''<summary>Direct debit, CHAR, lengte: 1, not accessible</summary>
 Public Const [INCASSO] As String = "INCASSO"
 '''<summary>Prices include VAT, CHAR, lengte: 1</summary>
 Public Const [ISINCL] As String = "ISINCL"
 '''<summary>Cost unit, NUMERIC, lengte: 8</summary>
 Public Const [KDR] As String = "KDR"
 '''<summary>Feature, CHAR, lengte: 25</summary>
 Public Const [KENM] As String = "KENM"
 '''<summary>Cost center, NUMERIC, lengte: 8</summary>
 Public Const [KPL] As String = "KPL"
 '''<summary>Delivery condition, CHAR, lengte: 20, verplicht</summary>
 Public Const [LEVCOND] As String = "LEVCOND"
 '''<summary>Storage, NUMERIC, lengte: 8</summary>
 Public Const [MAG] As String = "MAG"
 '''<summary>Direct debit mandate, CHAR, lengte: 35</summary>
 Public Const [MDT] As String = "MDT"
 '''<summary>Blocked by, CHAR, lengte: 20, not accessible</summary>
 Public Const [MEDEWVAST] As String = "MEDEWVAST"
'''<summary>Order~number, datatype: NUMERIC, lengte: 9, primary key, verplicht</summary>
 Public Const [NR] As String = "NR"
 '''<summary>Number in the ride, NUMERIC, lengte: 8</summary>
 Public Const [NRRIT] As String = "NRRIT"
 '''<summary>Order method, CHAR, lengte: 20, verplicht</summary>
 Public Const [OPDRWZ] As String = "OPDRWZ"
 '''<summary>Remark, CHAR, lengte: 250</summary>
 Public Const [OPM] As String = "OPM"
 '''<summary>Order delivery complete, CHAR, lengte: 1</summary>
 Public Const [ORDERCOMPLEET] As String = "ORDERCOMPLEET"
 '''<summary>Order type, CHAR, lengte: 20, verplicht</summary>
(Note that there is aspecial order type for 'spitsfactuur')
 Public Const [ORDSRT] As String = "ORDSRT"
 '''<summary>Payment discount%, NUMERIC, lengte: 6</summary>
 Public Const [PERCBETKORT] As String = "PERCBETKORT"
 '''<summary>Percentage for G-account, NUMERIC, lengte: 6</summary>
 Public Const [PERCGREK] As String = "PERCGREK"
 '''<summary>Credit squeez%, NUMERIC, lengte: 6</summary>
 Public Const [PERCKB] As String = "PERCKB"
 '''<summary>Percentage wage component, NUMERIC, lengte: 6</summary>
 Public Const [PERCLOON] As String = "PERCLOON"
 '''<summary>Price list, CHAR, lengte: 20, verplicht</summary>
 Public Const [PRSLST] As String = "PRSLST"
 '''<summary>Ride, NUMERIC, lengte: 8</summary>
 Public Const [RIT] As String = "RIT"
 '''<summary>Selection code, CHAR, lengte: 20</summary>
 Public Const [SELCD] As String = "SELCD"
 '''<summary>Language, CHAR, lengte: 3, verplicht</summary>
 Public Const [TAAL] As String = "TAAL"
 '''<summary>There are line for invoicing, CHAR, lengte: 1</summary>
 Public Const [TEFACT] As String = "TEFACT"
 '''<summary>Currency, CHAR, lengte: 3, verplicht</summary>
 Public Const [VAL] As String = "VAL"
 '''<summary>Sales person, CHAR, lengte: 20</summary>
 Public Const [VERKOPER] As String = "VERKOPER"
  '''<summary>Experation days, NUMERIC, lengte: 3, not accessible</summary>
 Public Const [VERVDGN] As String = "VERVDGN"
 '''<summary>Address, CHAR, lengte: 50</summary>
 Public Const [VERZADRES] As String = "VERZADRES"
 '''<summary>Extended address, MEMO, lengte: 1024</summary>
 Public Const [VERZADRESSERING] As String = "VERZADRESSERING"
 '''<summary>Delivery address contact relation , NUMERIC, lengte: 8</summary>
 Public Const [VERZCNTREL] As String = "VERZCNTREL"
 '''<summary>Delevery address contact searchkey, CHAR, lengte: 20</summary>
 Public Const [VERZCNTZKSL] As String = "VERZCNTZKSL"
 '''<summary>Delevery address debtor, NUMERIC, lengte: 8</summary>
 Public Const [VERZDEB] As String = "VERZDEB"
 '''<summary>E-mailaddress, CHAR, lengte: 64</summary>
 Public Const [VERZEMAIL] As String = "VERZEMAIL"
 '''<summary>House~number, NUMERIC, lengte: 5</summary>
 Public Const [VERZHNR] As String = "VERZHNR"
 '''<summary>Housenumber extension, CHAR, lengte: 6</summary>
 Public Const [VERZHNRTV] As String = "VERZHNRTV"
 '''<summary>Country, CHAR, lengte: 3</summary>
 Public Const [VERZLAND] As String = "VERZLAND"
 '''<summary>Name, CHAR, lengte: 50</summary>
 Public Const [VERZNAAM] As String = "VERZNAAM"
 '''<summary>Name to the attention of, CHAR, lengte: 50</summary>
 Public Const [VERZNAAM2] As String = "VERZNAAM2"
 '''<summary>Woonplaats, CHAR, lengte: 24</summary>
 Public Const [VERZPLAATS] As String = "VERZPLAATS"
 '''<summary>Zip code, CHAR, lengte: 8</summary>
 Public Const [VERZPOSTCD] As String = "VERZPOSTCD"
 '''<summary>Street, CHAR, lengte: 37</summary>
 Public Const [VERZSTRAAT] As String = "VERZSTRAAT"
 '''<summary>Phone, CHAR, lengte: 15</summary>
 Public Const [VERZTEL] As String = "VERZTEL"
 '''<summary>Shipping methode, CHAR, lengte: 20, verplicht</summary>
 Public Const [VERZWZ] As String = "VERZWZ"
 '''<summary>Delivery address, CHAR, lengte: 20</summary>
 Public Const [VERZZKSL] As String = "VERZZKSL"
 '''<summary>Volume (m³), NUMERIC, lengte: 14, not accessible</summary>
 Public Const [VOLUME] As String = "VOLUME"
End Class

Order type “Spitsfactuur”

For “spitsfactuur” a special order type, field GEBRVOOR (Use for) in master table ORDSRT  is set to ‘S’. This order type is created as soon as you start “Spitsfactuur” for the first time in iMUIS Online. This order type is named “spitsfactuur” and can only be used in “Spitsfactuur”. Sales orders created with this order type can only be added in “Spitsfactuur”.

Thereby the order type is used to set some defaults to the sales orders. Default fields are for example:

• Delivery condition
• Shipping
• Payment method
• Order method