| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| rec_line_id |
int4 |
10 |
|
|
|
|
| acs_objects.object_id
|
mis_rec_note_lines_rec_line_id_fkey |
|
| rec_id |
int4 |
10 |
|
|
|
|
|
| product_id |
int4 |
10 |
|
|
|
|
|
| description |
text |
2147483647 |
√ |
|
null |
|
|
| po_line_id |
int4 |
10 |
√ |
|
null |
|
|
| store_id |
int4 |
10 |
√ |
|
null |
|
| mis_stores.store_id
|
mis_rec_note_lines_store_id_fkey |
|
| lot_no |
varchar |
20 |
√ |
|
null |
|
|
| purc_um_id |
int4 |
10 |
√ |
|
null |
|
| mis_um.um_id
|
mis_rec_note_lines_purc_um_id_fkey |
|
| conversion_factor |
numeric |
11,4 |
√ |
|
null |
|
|
| delivered_qty |
numeric |
11,2 |
|
|
|
|
|
| product_price |
numeric |
17,5 |
√ |
|
null |
|
|
| discount |
numeric |
5,2 |
√ |
|
null |
|
|
| discount_2 |
numeric |
5,2 |
√ |
|
null |
|
|
| discount_3 |
numeric |
5,2 |
√ |
|
null |
|
|
| line_rec_text |
text |
2147483647 |
√ |
|
null |
|
|
| scope |
bpchar |
1 |
√ |
|
null |
|
|
| is_invoiced_p |
bool |
1 |
√ |
|
null |
|
|
Table contained 89 rows at Fri Feb 29 12:05 CET 2008
|
