Affärssystem: Databas för LEXICON

Sökväg i meny: Revision 2005-02-21
Beskrivning av databas för i Affärssystemet SystemQ

Dataset/Tabeller

Items/Datafält

ACTION X10
BASE-FOLDER X64
CLIENT-NO X4
COMMENTS X64
COMPANY-NO X6
DATE-TIME X12
DEL-PROJ X8
DESCRIPTION X64
GROUP-NAME 20X32
GROUP-ITEM-1 20X16
GROUP-ITEM-2 20X16
GROUP-NO X4
FILE X128
FIRST X12
FOLDER X128
ID L
ID-NO I
IN-FOLDER X64
KEYWORDS X64
LATEST X12
LINK L
NEXT X6
NEXT-ID L
NO I
OWNER X6
PASSWORD X10
P-CODE X6
PROJEKTNR X8
STATUS X6
TYPE X6
VALUE-1 X32
VALUE-2 X32
# WORK-FLOW 10X20

Dataset/Tabeller

SETUP
NO (0)
NEXT-ID
GROUP-NAME (1) FORETAG
(2) PERSON
(3) LEVFAKT
(4) KUNDFAKT
(5) ORDER
(6) ORDER-RAD
(7) INKOP
(8) INKOP-RAD
(9) ARTIKEL
GROUP-ITEM-1
GROUP-ITEM-2
GROUP-INDEX
CLIENT-NO (1)
GROUP
CLIENT-NO (GROUP-INDEX) BAS(10).FORETAG.NR
GROUP-NO
IN-FOLDER \\systemq\SystemQ\FRTG1\Inkommande
FOLDER \\systemq\SystemQ\FRTG1\Levfakt
WORK-FLOW
DOCUMENT
ID (1)
FOLDER
FILE ROOT-FOLDERS(SETUP.ROOT-FOLDER-NO(GROUP.ROOT-FOLDER-NO))&"/"&FOLDER&"/FILE"
PASSWORD
OWNER
TYPE
DESCRIPTION
KEYWORDS
GROUP-NO
ID-NO
VALUE-1 Avdelning Document.Value$=Foretagsnr$&VAL$(Loknr)
VALUE-2
COMPANY-NO
LINK
CLIENT-NO
DATE-TIME
PROJEKTNR
DEL-PROJ
INDEX GROUP-INDEX
LINK-INDEX
DOCUMENT-FLOW
ID (DOCUMENT)
P-CODE
ACTION
STATUS
FIRST
LATEST
DATE-TIME
COMMENTS
NEXT
Affärssystem SystemQ Handbok
Affärssystem 		Copyright ©1979-2005
Qwert Systems AB
26 års kunskaper 		Support
Affärssystem 		Support
Affärssystem