Beschikbare velden tabel Artikel/crediteur informatie (ARTCRE) (Voorkeurscrediteuren)
Velden van het type BOOLEAN kunnen de waardes J of N hebben.
Public Class [ARTCRE] '''<summary>Artikel, datatype: CHAR, lengte: 20, primary key, verplicht</summary> Public Const [ART] As String = "ART" '''<summary>Bestelnummer, datatype: CHAR, lengte: 20</summary> Public Const [BESTEL] As String = "BESTEL" '''<summary>Blokkeren, datatype: BOOLEAN</summary> Public Const [BLOK] As String = "BLOK" '''<summary>Catalogusnummer, datatype: CHAR, lengte: 20</summary> Public Const [CAT] As String = "CAT" '''<summary>Crediteur, datatype: NUMERIC, lengte: 8, primary key, verplicht</summary> Public Const [CRE] As String = "CRE" '''<summary>Inkoopeenheid, datatype: CHAR, lengte: 20</summary> Public Const [EENHINK] As String = "EENHINK" '''<summary>Levertijd in, datatype: CHAR, lengte: 1</summary> Public Const [LEVSRT] As String = "LEVSRT" '''<summary>Levertijd, datatype: NUMERIC, lengte: 3</summary> Public Const [LEVTIJD] As String = "LEVTIJD" '''<summary>Minimum bestelhoeveelheid, datatype: NUMERIC, lengte: 14</summary> Public Const [MINBESTEL] As String = "MINBESTEL" '''<summary>Omschrijving, datatype: CHAR, lengte: 40</summary> Public Const [OMSCHR] As String = "OMSCHR" '''<summary>Externe opmerking, datatype: MEMO, lengte: 1024</summary> Public Const [OPMEXT] As String = "OPMEXT" '''<summary>OPMINTVELD, datatype: MEMO, lengte: 1024</summary> Public Const [OPMINT] As String = "OPMINT" '''<summary>Voorkeurcrediteur, datatype: CHAR, lengte: 1</summary> Public Const [VOORKCRE] As String = "VOORKCRE" End Class