| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| CHARGE_DTL_ID |
number |
22 |
|
|
|
|
|
| CHARGE_ID |
number |
22 |
|
|
|
|
|
| ITEM_ID |
number |
22 |
|
|
|
|
| ITEM.ITEM_ID
|
SYS_C00914787 R |
|
| SUPPLY_LOCATION_ID |
number |
22 |
√ |
|
null |
|
|
| QTY |
number |
13 |
|
|
|
|
|
| ORIGINAL_QTY |
number |
13 |
|
|
|
|
|
| UOM |
varchar2 |
4 |
|
|
|
|
|
| PATIENT_PRICE |
number |
13,2 |
√ |
|
null |
|
|
| COST |
number |
13,5 |
√ |
|
null |
|
|
| SERIAL_NBR |
varchar2 |
16 |
√ |
|
null |
|
|
| LOT_NBR |
varchar2 |
10 |
√ |
|
null |
|
|
| SUBLOT |
varchar2 |
6 |
√ |
|
null |
|
|
| BIN |
varchar2 |
7 |
√ |
|
null |
|
|
| UPLOAD_MSG |
varchar2 |
150 |
√ |
|
null |
|
|
| UPLOAD_STATUS |
number |
1 |
√ |
|
null |
|
|
| CREATE_DATE |
date |
7 |
|
|
|
|
|
| LAST_UPDATE_DATE |
date |
7 |
√ |
|
null |
|
|
| REPLENISHMENT_TYPE |
char |
1 |
|
|
'0' |
|
|
| SPLIT_GROUP_NO |
number |
22 |
√ |
|
0 |
|
|
Analyzed at Wed May 18 12:10 CDT 2011
|
