DB | Areas | X-idx | Tables | Sequences <- pur-cal-appdeal pur-cal-userlnk -> HtmlDict 11

qbfdecn.pur-cal-appoint

Purchasing Web Calendar Appointment

Table details

Area ProdData
Dumpname cal-appoint
Label Purchasing Web Calendar Appointment
Val.exp ?
Val.msg

Fields

Order Field Name x Label Datatype Format Initial Mand Description
90 appoint-comp X Appoint Company character x(15)
80 appoint-desc X Appoint Description character x(15)
10 appoint-id X Appointment ID integer >>>>>>9 0
100 appoint-loc X Appoint Location character x(15)
150 appoint-outcome X Appoint Outcome character x(30)
110 appoint-person X Appoint Person character x(15)
130 cell-no X Cell No character x(15)
160 compl-date X Compl Date date 99/99/9999 ?
30 date-from X Date From date 99/99/9999 ?
50 date-to X Date To date 99/99/9999 ?
140 email X Email character x(24)
70 stat-cde X Status Code character !
120 tel-no X Tel No character x(20)
40 time-from X Time From integer 99999 0
60 time-to X Time To integer 99999 0
170 upd-date X Updated date 99/99/9999 ?
180 upd-time X At integer 99999 0
190 upd-user-id X By character x(12)
20 user-id X User ID character x(12)

Indexes

Index name Flags Fields Datatype
appoint-idx P U appoint-id (+) integer
comp-idx appoint-comp (+) character
    date-from (+) date
status-idx stat-cde (+) character
user-idx user-id (+) character
    date-from (+) date
    date-to (+) date
+ = Ascending - = Descending P = Primary U = Unique I = Inactive W = Wordindex

Related tables

Parent tables
inv-combocom   inv-comboitem   sys-acchist  
Child tables
pur-cal-appaud   pur-cal-appdeal  
generated 24-6-2026 08:27