ABC Tables Navigation
C
I
L
O
R
S
_
|
|
|
** Table is not used. [111] |
LABEL:
DESCRIPTION: Item file |
|
| |
key |
Name |
Label |
Datatype |
Format |
Extent |
Mnd. |
Default |
View-As |
 |
|
Item |
|
|
|
|
|
|
  |
PK n/m |
Item-num |
|
integer |
99999 |
0 |
no |
0 |
? |
  |
|
Allocated |
|
integer |
->>>>9 |
0 |
no |
0 |
? |
  |
|
Cat-Description |
Cat-Description |
character |
x(200) |
0 |
no |
|
VIEW-AS EDITOR SIZE 41 BY 5 SCROLLBAR-VERTICAL |
  |
|
Cat-Page |
|
integer |
>>9 |
0 |
no |
0 |
? |
  |
|
Item-Name |
|
character |
x(15) |
0 |
no |
|
? |
  |
|
On-hand |
|
integer |
->>>>9 |
0 |
no |
0 |
? |
  |
|
On-Order |
|
integer |
->>>>9 |
0 |
no |
0 |
? |
  |
|
Price |
|
decimal |
->,>>>,>>9.99 |
0 |
no |
0 |
? |
  |
|
Re-Order |
|
integer |
->>>>9 |
0 |
no |
0 |
? |
  |
|
Cat-Description |
Active ** Index is not used. [112] |
   |
Cat-Description |
Ascending |
  |
|
Item-Name |
Active ** Index is not used. [112] |
   |
Item-Name |
Ascending |
  |
PK |
Item-Num |
Unique Active ** Index is not used. [112] |
   |
Item-num |
Ascending |
|
|
LABEL:
DESCRIPTION: Order line information |
|
| |
key |
Name |
Label |
Datatype |
Format |
Extent |
Mnd. |
Default |
View-As |
 |
|
Order-Line |
|
|
|
|
|
|
  |
PK n/m |
Line-num |
|
integer |
>>9 |
0 |
no |
0 |
? |
  |
PK n/m FK |
Order-num |
|
integer |
>>>>9 |
0 |
no |
0 |
? |
  |
|
Backorder |
Back Order |
logical |
yes/no |
0 |
no |
no |
? |
  |
|
Discount |
|
integer |
>>9% |
0 |
no |
0 |
? |
  |
|
Extended-Price |
|
decimal |
->>,>>9.99 |
0 |
no |
0 |
? |
  |
FK |
Item-num |
|
integer |
99999 |
0 |
no |
0 |
? |
  |
|
Price |
|
decimal |
->,>>>,>>9.99 |
0 |
no |
0 |
? |
  |
|
Qty |
|
integer |
->>>>9 |
0 |
no |
0 |
? |
  |
|
item-num |
Active ** Index is not used. [112] |
   |
Item-num |
Ascending |
  |
PK |
order-line |
Unique Active |
   |
Order-num |
Ascending |
   |
Line-num |
Ascending |
|
** Table is not used. [111] |
LABEL:
DESCRIPTION: |
|
| |
key |
Name |
Label |
Datatype |
Format |
Extent |
Mnd. |
Default |
View-As |
 |
|
Ref-Call |
|
|
|
|
|
|
  |
PK n/m AK |
Call-Num |
|
character |
X(6) |
0 |
no |
|
? |
  |
|
Call-Date |
|
date |
99/99/99 |
0 |
no |
? |
? |
  |
n/m AK FK |
Cust-Num |
|
integer |
>>>>9 |
0 |
no |
0 |
? |
  |
n/m AK |
Parent |
|
character |
X(6) |
0 |
no |
|
? |
  |
FK |
Sales-Rep |
|
character |
x(4) |
0 |
no |
|
? |
  |
|
Txt |
|
character |
X(300) |
0 |
no |
|
VIEW-AS EDITOR
SCROLLBAR-HORIZONTAL SCROLLBAR-VERTICAL
SIZE 60 BY 5
|
  |
PK |
Call-Num |
Unique Active ** Index is not used. [112] |
   |
Call-Num |
Ascending |
  |
AK |
Cust-Num |
Unique Active ** Index is not used. [112] |
   |
Cust-Num |
Ascending |
   |
Call-Num |
Ascending |
  |
AK |
Sibling |
Unique Active ** Index is not used. [112] |
   |
Parent |
Ascending |
   |
Call-Num |
Ascending Abbreviate |
  |
|
Txt |
Active ** Index is not used. [112] |
   |
Txt |
Ascending |
|
|
LABEL:
DESCRIPTION: Sales representative information |
|
| |
key |
Name |
Label |
Datatype |
Format |
Extent |
Mnd. |
Default |
View-As |
 |
|
Salesrep |
|
|
|
|
|
|
  |
PK n/m |
Sales-Rep |
|
character |
x(4) |
0 |
no |
|
? |
  |
|
Month-Quota |
|
integer |
->,>>>,>>9 |
12 |
no |
0 |
? |
  |
|
Region |
|
character |
x(8) |
0 |
no |
|
? |
  |
|
Rep-Name |
|
character |
x(30) |
0 |
no |
|
? |
  |
PK |
Sales-Rep |
Unique Active |
   |
Sales-Rep |
Ascending |
|
** Table is not used. [111] |
LABEL:
DESCRIPTION: Table of state abbreviation with sales regions |
|
| |
key |
Name |
Label |
Datatype |
Format |
Extent |
Mnd. |
Default |
View-As |
 |
|
State |
|
|
|
|
|
|
  |
PK n/m |
State |
|
character |
!! |
0 |
no |
|
? |
  |
|
Region |
|
character |
x(8) |
0 |
no |
|
? |
  |
|
State-Name |
|
character |
x(15) |
0 |
no |
|
? |
  |
PK |
State |
Unique Active ** Index is not used. [112] |
   |
State |
Ascending |
| |