PC Direct 1996 May/PCDMAY.ISO/software/clarion/cw15/tutor02.z/TUTORIAL.DCT

Clarion Topspeed Data File | 1995-09-29 | 24.3 KB | 505 lines

CustNo
Customer Number
Customer No:
Customer Number
ORD:CustNo
"ITEM:CustNo
CusITEM:CustNo
h@n05
?ITEM:CustNo:Prompt
Customer Number
ITEM:CustNo
Customer No:
D?ITEM:CustNo:Prompt
Customer No:
ByNumber
By Customer Account Number
ByName
By Customer Name
ByCode
By Product Code
ByDesc
By Product Description
1ByCode
By State Code
AsEntered
Line Number within Order Number
NOPOPULATE
ByState
By State Name
ORDER(Normal)
ByCustomer
By Order Number within Customer Number
NOPOPULATE
ByProduct
Order Number within Product Code
NOPOPULATE
This data dictionary is well suited for demonstrating the
%Application Wizard
Customer
,TUTORIAL.TPS\!CUSTOMER
Customer Information File
Customer File
TOPSPEED
Record
Items
,TUTORIAL.TPS\!ITEMS
Line Item File
Many Items to an Order
TOPSPEED
Record
NOPOPULATE
Orders
,TUTORIAL.TPS\!ORDERS
Order Information File
Customer Order Information
TOPSPEED
Record
"NOPOPULATE
Product
,TUTORIAL.TPS\!PRODUCT
Product Information File
Price and Quantity Info
TOPSPEED
Record
State
,TUTORIAL.TPS\!STATE
State Code File
State File
TOPSPEED
Record
CustNo
Customer Account number
Customer Number:
Customer account number
FCUST:CustNo
CUST:CustNo
?CUST:CustNo:Prompt
ntNCUST:CustNo
`@n05
cco?CUST:CustNo:Prompt
Customer account number
Customer Number:
Customer Number:
Customer Name
Customer:
Customer Name
9?CUST:Name:Prompt
CUST:Name
co@s30
CUST:Name
=Customer Name
beCustomer:
 account number
Address
Customer Address
Address:
Address
Customer Address Line 1
9?CUST:Address:Prompt
meCUST:Address
S:Address:
ECUST:Address
er@s30
beCustomer Address Line 1
ess Line 1:
2Customer City
City:
Customer City
2?CUST:City:Prompt
ptCUST:City
S:City:
S:@s20
QCUST:City
ddrCustomer City
omer City
Address Line 2
State
Customer State
State:
Customer State
5?CUST:State:Prompt
tCUST:State
:State:
GCUST:State
State:
rState:
rCustomer State
%G?CUST:State:Prompt
xCUST:State
Customer State
L?CUST:State:Prompt
{CUST:State
Customer State
>?CUST:State:Prompt
{State:
CUST:State
Customer State
Customer Zip Code
Zip Code:
Customer Zip Code
-CUST:Zip
ProCUST:Zip
tatCustomer Zip Code
taZip Code:
ip?CUST:Zip:Prompt
ess Line 2
Phone
Telephone Number
@P(###) ###-#
Telephone:
Phone
Telephone Number
I?CUST:Phone:Prompt
oCUST:Phone
TCUST:Phone
:Telephone:
@P(###) ###-#
Telephone Number
r@P(###) ###-#
Reference
QSpecial Order Info
Special Order Info
Reference:
Reference
CUST:Contact
9?ORD:Reference:Prompt
Reference:
ORD:Reference
@ORD:Reference
berCustomer Acc
Shipped
Checkbox Field
Checkbox Field
Order Has Been Shipped:
Shipped
ORD:Shipped
TORD:Shipped
Order Has Been Shipped
Order Has Been Shipped
Carrier
Mail|UPS|Other
Shipping Instructions
Radio Button - How Shipped
Carrier:
Carrier
Shipping Instructions
'Mail'
FEDEX
OTHER
ORD:Carrier
Ship type
{x?ORD:Carrier:Radio1
?ORD:Carrier:Radio3
?ORD:Carrier:Radio4
ORD:Carrier
?ORD:Carrier:Radio2
.MAIL
hipFEDEX
Shipping Instructions
OTHER
ORD:Carrier
Shipping Instructions
Ship type
?ORD:Carrier:Radio1
?ORD:Carrier:Radio2
?ORD:Carrier:Radio3
?ORD:Carrier:Radio4
rOTHER
ORD:Carrier
Shipping Instructions
Carrier
?ORD:Carrier:Radio1
?ORD:Carrier:Radio2
?ORD:Carrier:Radio3
rOTHER
ORD:Carrier
Shipping Instructions
Carrier
?ORD:Carrier:Radio1
?ORD:Carrier:Radio2
?ORD:Carrier:Radio3
rOther
ADORD:Carrier
Shipping Instructions
Carrier
?ORD:Carrier:Radio1
?ORD:Carrier:Radio2
?ORD:Carrier:Radio3
ProdCode
Product Code
Product Code:
Product Code
:?PROD:ProdCode:Prompt
PROD:ProdCode
ro@n05
%PROD:ProdCode
Product Code
(Product Code:
?PROD:ProdCode:Prompt
Product Code:
PROD:ProdCode
Description
LProduct Description
Description
Description
Pproduct Description
9PROD:Description
Description
esc@s50
ePROD:Description
Pproduct Description
?PROD:Description:Prompt
:Description
Price
9Unit Price
@n10.2
Unit price
Unit price
Unit Price
E?PROD:Price:Prompt
Unit price
:PROD:Price
@n10.2
*PROD:Price
@n10.2
Unit Price
StateCode
State Code
State Code:
State Code
ESTATE:StateCode
State Code:
State Code
3STATE:StateCode
?STATE:StateCode:Prompt
StateName
State Name
State Name:
State Name
State Name
>ST:StateName
State Name:
State Name
e@s20
5ST:StateName
?ST:StateName:Prompt
LineNo
Line Number
Line No:
Line No
Line Number
"ITEM:LineNo
M:@n04
!@n04
?ITEM:LineNo:Prompt
<Line Number
ITEM:LineNo
Line No:
?ITEM:LineNo:Prompt
Line No:
ITEM:LineNo
Price
Price per Unit
@n10.2
Unit Price:
Price
Price per Unit
PROD:Price
)ITEM:Price
M@n10.2
ITEM:Price
P@n10.2
?ITEM:Price:Prompt
tPrice per Unit
:Price
tUnit Price:
Contact
Contact Person
Contact First Name
Contact Person:
Contact
Contact Person
ECUST:Contact
ProCUST:Contact
Contact
s15Contact Person
e?CUST:Contact:Prompt
#)#Contact Person:
OrderNo
;Order Number
Order Number
Order No
Order Number
!ITEM:OrderNo
Order Number
:Order
m@n06
Order Number
@?ITEM:OrderNo:Prompt
ITEM:OrderNo
?ITEM:OrderNo:Prompt
Order Number
ITEM:OrderNo
ProdCode
    7Product Code
Product Code:
Item Number
A?ITEM:ProdCode:Prompt
ITEM:ProdCode
ro@n05
LITEM:ProdCode
n_6Item Number
Product Code:
%\?ITEM:ProdCode:Prompt
Product Code:
ITEM:ProdCode
Item Number
2\?ITEM:ProdCode:Prompt
Product Code:
    ITEM:ProdCode
Item Number
I?ITEM:ProdCode:Prompt
Product Code:
ITEM:ProdCode
Item Number
Quantity
    :Quantity Ordered
Quantity:
Quantity Ordered
A?ITEM:Quantity:Prompt
deQuantity:
ITEM:Quantity
06@n6
@ITEM:Quantity
Quantity Ordered
?ITEM:Quantity:Prompt
Quantity:
ITEM:Quantity
Quantity Ordered
Total
RExtended Total Amount
Extended Item Total
@n10.2
Extended Total:
Total
Total
NOPOPULATE
E?ITEM:Total:Prompt
ITEM:Total
Total
@n10.2
=ITEM:Total
@n10.2
tExtended Total:
ount Amount
OrderNo
<Order Number
Order Number:
Order No
Order Number
B?ORD:OrderNo:Prompt
Order Number:
ORD:OrderNo
@ORD:OrderNo
Order Number
?ORD:OrderNo:Prompt
Order Number:
ORD:OrderNo
CustNo
SCustomer Account Number
Cust No:
Customer Account Number
CUST:CustNo
J?ORD:CustNo:Prompt
tCust No:
merORD:CustNo
t@n06
cco@n06
mbe@n06
LORD:CustNo
rCust No:
Customer Account Number
?ORD:CustNo:Prompt
ORD:CustNo
ShipTo
>Ship To Name
Ship To:
Ship to
Ship To Name
CUST:Name
TAB('Ship To')
-?ORD:ShipTo:Prompt
ORD:ShipTo
!ORD:ShipTo
Ship To Name
    Ship To:
ShipAddress
IShip To Address
Address:
Address
Ship To Address 1
CUST:Address
TAB('Ship To')
9?ORD:ShipAddress:Prompt
Address:
pORD:ShipAddress
ORD:ShipAddress
Ship To Address 1
ShipCity
8Ship To City
City:
Ship To City
CUST:City
TAB('Ship To')
9?ORD:ShipCity:Prompt
ipCity:
itORD:ShipCity
ORD:ShipCity
o @s22
Ship To City
ShipState
9Ship To State
State:
Ship To State
CUST:State
TAB('Ship To')
:?ORD:ShipState:Prompt
ipState:
aORD:ShipState
at@s2
<ORD:ShipState
ty@s2
Ship To State
%X?ORD:ShipState:Prompt
State:
ORD:ShipState
Ship To State
`?ORD:ShipState:Prompt
    State:
xORD:ShipState
Ship To State
ShipZip
BShip To Zip Code
Zip Code:
Ship To Zip Code
CUST:Zip
TAB('Ship To')
6?ORD:ShipZip:Prompt
Zip Code:
taORD:ShipZip
*ORD:ShipZip
tyShip To Zip Code
OrderDate
?Date Ordered
Order date:
Order date
Order Date
TODAY()
:?ORD:OrderDate:Prompt
Order date:
ORD:OrderDate
IORD:OrderDate
Order Date
berCustomer Account Number