Ì i 2
ss.inventory.data.main (main)
[inv,inv.item]
:SSI[inv,itm]
Field Name Len Dat Typ J DPM Offset/Local/VAL
inv 10 FREE L SS.INV.DICT inv
inv.item 10 FREE L itm
inv.in.stock 6 INT R :SSI[inv,itm]|0
inv.on.order 6 INT R :SSI[inv,itm]|1
inv.type 10 FREE L SS.INV.TYPE VAL=@SS.INV.ITEM.inv.type
supplier 10 FREE L MIS.MFR
temp.in.stock 6 FREE L VAL=@inv.in.stock[t.inv,inv.item]
temp.on.order 6 FREE L VAL=@inv.on.order[t.inv,inv.item]
temp.reason 40 FREE L
Ì € i 2
ss.inv.audit (audit)
[inv,inv.item, inv.audit.urn]
:SSI[inv,itm]AUD[inva]
Field Name Len Dat Typ J DPM Offset/Local/VAL
inv.audit.urn 4 URN L inva
inv.audit.date 8 DATE L :SSI[inv,itm]AUD[inva]|0
inv.audit.in.stock.dif 6 FREE L :SSI[inv,itm]AUD[inva]|6
inv.audit.old.in.stock 6 FREE L :SSI[inv,itm]AUD[inva]|4
inv.audit.old.on.order 6 FREE L :SSI[inv,itm]AUD[inva]|5
inv.audit.on.order.dif 6 FREE L :SSI[inv,itm]AUD[inva]|7
inv.audit.reason 40 FREE L :SSI[inv,itm]AUD[inva]|3
inv.audit.time 4 HHMM L :SSI[inv,itm]AUD[inva]|1
inv.audit.user 10 FREE L MIS.USER :SSI[inv,itm]AUD[inva]|2
Ì i 2
ss.inv.requisitions (reqs)
[req]
:SSIR[req]
Field Name Len Dat Typ J DPM Offset/Local/VAL
req 10 URN L req
entered.by 10 FREE L MIS.USER :SSIR[req]|9
entered.date 8 DATE L :SSIR[req]|10
entered.time 4 HHMM L :SSIR[req]|11
number.of.copies 2 PINT R
req.cost.center 6 FREE L :SSIR[req]|4
req.hospital.number 11 FREE L :SSIR[req]|2
req.inv 10 FREE L SS.INV.DICT :SSIR[req]|0
req.status 10 FREE L :SSIR[req]|3
req.supplier 10 FREE L MIS.MFR :SSIR[req]|1
req.tp 6 FREE L :SSIR[req]|5
requested.by 10 FREE L MIS.USER :SSIR[req]|6
requested.date 8 DATE L :SSIR[req]|7
requested.time 4 HHMM L :SSIR[req]|8
Ì € i 2
ss.inv.reqs.comment.text (comments.text)
[req, comment.text.line]
:SSIR[req]CX[ctl]
Field Name Len Dat Typ J DPM Offset/Local/VAL
comment.text.line 1 URN L ctl
comment.edit 1 YN L :SSIR[req]CX[ctl]|1
comment.text 70 FREE L :SSIR[req]CX[ctl]
comment.text.exists 0 YN L VAL=IF{+@t.comments.text[req,""] "EXIST"_@Set.attr(@Z.
VAL=color.labels1)_(" ":7)_@Set.attr(@Z.color.data1);"
VAL=DO NOT EXIST"}
Ì € i 2
SS.INV.reqs.ordered (reqs.ordered)
[req, ordered.urn]
:SSIR[req]ORD[ord]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ordered.urn 2 URN L ord
ordered.item 10 FREE L :SSIR[req]ORD[ord]|0
ordered.name 30 FREE L :SSIR[req]ORD[ord]|3
ordered.quantity 6 INT R :SSIR[req]ORD[ord]|1
ordered.type 1 FREE L :SSIR[req]ORD[ord]|2
Ì € i 2
ss.inv.reqs.received (reqs.received)
[req, received.urn]
:SSIR[req]REC[rec]
Field Name Len Dat Typ J DPM Offset/Local/VAL
received.urn 2 INT R rec
received.item 10 FREE L :SSIR[req]REC[rec]|0
received.name 30 FREE L :SSIR[req]REC[rec]|3
received.ordered 6 INT R :SSIR[req]REC[rec]|1
received.quantity 6 FREE L :SSIR[req]REC[rec]|6
received.quantity.total 6 INT R :SSIR[req]REC[rec]|5
received.to.follow 6 INT R :SSIR[req]REC[rec]|7
received.to.follow.flag 1 FREE L :SSIR[req]REC[rec]|8
received.type 1 FREE L :SSIR[req]REC[rec]|2
Ì € i 2
ss.inv.reqs.received.audit (reqs.received.audit)
[req, req.audit.urn]
:SSIR[req]AUD[recA]
Field Name Len Dat Typ J DPM Offset/Local/VAL
req.audit.urn 2 URN L recA
req.audit.date 8 DATE L :SSIR[req]AUD[recA]|0
req.audit.time 4 HHMM L :SSIR[req]AUD[recA]|1
req.audit.user 10 FREE L MIS.USER :SSIR[req]AUD[recA]|2
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
SS.INV.hospital.number.x [req.hospital.number,req]
hospital.number.x :SSIH[hnum,req]
|
|
| | | | | |