aurora_standard.chhl7zpm
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| messagetype | varchar(30) | YES | ||||
| pocketcode | varchar(30) | YES | ||||
| pyxissytem | varchar(30) | YES | ||||
| stationname | varchar(30) | YES | ||||
| drawernumber | varchar(30) | YES | ||||
| pocketdescriptor | varchar(30) | YES | ||||
| itemid | varchar(30) | YES | ||||
| itemname | varchar(30) | YES | ||||
| itemclass | varchar(30) | YES | ||||
| expectedbeginct | varchar(30) | YES | ||||
| actualbeginct | varchar(30) | YES | ||||
| transactionamount | decimal(12,2) | YES | ||||
| userid | varchar(30) | YES | ||||
| username | varchar(30) | YES | ||||
| witnessid | varchar(30) | YES | ||||
| witnessname | varchar(30) | YES | ||||
| totalcountofitems | varchar(30) | YES | ||||
| altitemid | varchar(30) | YES | ||||
| facilitycode | varchar(30) | YES | ||||
| altitemid2 | varchar(30) | YES | ||||
| nursingunit | varchar(30) | YES | ||||
| subdrawer | varchar(30) | YES | ||||
| fullcountinpocket | varchar(30) | YES | ||||
| parcountinpocket | varchar(30) | YES | ||||
| transactiontime | varchar(20) | YES | ||||
| field1 | varchar(1) | YES | ||||
| field2 | varchar(1) | YES | ||||
| visitnumber | varchar(20) | YES | ||||
| processed_date | date | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| username |
|