The Application Interface

Data Base Name is EXAMPLE

extra collections are f g h i

RD SET_REC
company x(30)
cstreet x(30)
cstreet2 x(15)
ccity x(15)
cstate x(2)

RD CUS_REC
cust# x(6)
name x(20)
street x(15)
street2 x(15)
city x(12)
state x(2)
zip x(5)
age n(3)
dob date
hair_color x(10)
handed x(6)
discount n(1.2)
year x(4)
month x(2)
status x(2)
county x(13)

RD INV_REC
item# x(6)
description x(20)
type x(1)
mbcode x(1)
quan_on_hand n(4)
unit_cost n(4.2)
order_quan n(4)
reordr_point n(3)
cdescr doc

RD SAL_REC
store# x(3)
cust# x(6)
pdate date "yyyymmdd"
item# x(6)
descr x(20)
quan_bot n(3)
price n(4.2)
stotal n(6.2)

RD VEN_REC
vend# x(4)
vname x(15)
street x(15)
city x(15)
state x(2)
zip x(5)
vtype x(15)
contact x(15)
acode x(5)
pfx x(3)
nmbr x(4)

RD ORD_REC
order# x(6)
vend# x(4)
order_dt date "yyyymmdd"
promised_dt date "yyyymmdd"
delivery_dt date "mm/dd/yyyy"
next_dt date "mm/dd/yyyy"
ostatus x(2)

RD LIN_REC
order# x(6)
item# x(6)
vend# x(4)
desc x(18)
quan_ordered n(6)
unit_cost n(4.2)
otype x(4)
file_dt date "mm/dd/yyyy"
pflag x(1)
seq x(6)
lstatus x(1)

RD PAR_REC
part# x(6)
pname x(24)
quan_on_hand n(4)
unit_cost n(8.2)
mb_code x(4)
order_quan n(4)
multiplier n(6)

RD ASS_REC
ass# x(6)
part# x(6)
quan_reqd n(3)
level n(2)
equan n(4)
tree x(6)

RD STA_REC
state x(2)
stname x(13)

RD CAT_REC
type x(1)
category x(13)

RD HIS_REC
item# x(6)
description x(20)
unit_cost n(4.2)
category x(13)
mbcode x(1)
year x(4)
month x(2)
sold n(5)
totals n(7.2)

RD LET_REC
lid x(4)
letter memo
dletter doc

RD ARCHIVES
arch# x(3)
archdate x(8)
archtime x(8)
dsk# x(2)
ndisks x(2)
dcap x(4)
fnm x(12)
rc1 x(6)
rc2 x(6)
dgn x(12)

RD XXX
item# x(6)
desc x(20)
type x(1)
mbcode x(1)
quan_on_hand n(4)
unit_cost n(4.2)
quan_ordered n(4)
reordr_point n(3)

RD INFO_FIELDS
filler x(6)
tname x(12)
pad x(55)

for the Example Data Base