| RECEIPT_ID |
number |
20 |
|
|
|
|
|
| TRACKING_NO |
varchar2 |
40 |
√ |
|
null |
|
|
| COMMENTS |
varchar2 |
200 |
√ |
|
null |
|
|
| ACCEPT_RECEIPT |
char |
1 |
|
|
|
|
|
| RECEIPT_TYPE |
number |
2 |
|
|
|
|
|
| STATUS |
number |
2 |
√ |
|
null |
|
|
| RECV_LOCATION_ID |
number |
22 |
|
|
|
|
|
| USER_ID |
number |
22 |
|
|
|
|
| USERS.USER_ID
|
SYS_C00913779 R |
|
| RETURN_TIME |
date |
7 |
|
|
|
|
|
| LAST_MODIFIED_DT |
date |
7 |
|
|
|
|
|
| NOTE_ID |
number |
20 |
√ |
|
null |
|
| NOTE.NOTE_ID
|
SYS_C00913780 R |
|
| CARRIER_VENDOR_SYSTEM_ID |
number |
22 |
√ |
|
null |
|
| VENDOR.VENDOR_SYSTEM_ID
|
SYS_C00914249 R |
|
| VENDOR_SYSTEM_ID |
number |
22 |
√ |
|
null |
|
| VENDOR.VENDOR_SYSTEM_ID
|
SYS_C00914250 R |
|
| DOCUMENT_PRINTER_ID |
number |
8 |
√ |
|
null |
|
|
| LABEL_PRINTER_ID |
number |
8 |
√ |
|
null |
|
|