id |
integer |
Yes |
Yes |
nextval('inventory_statistics_id_seq'::regclass) |
Unique identifier |
whse |
character varying(6) |
No |
No |
|
Warehouse for the item - links to inventory.whse |
part_no |
character varying(34) |
No |
No |
|
Part number for the item - links to inventory.part_no |
year_end |
date |
No |
No |
|
Fiscal year end for the sales period on this record |
period |
smallint |
No |
No |
|
Fiscal period (1-13) for this record |
qty |
numeric(15,3) |
No |
No |
|
Quantity sold this period for this period |
total_sell |
numeric(15,3) |
No |
No |
|
Total sales amount this period, for this item |
total_cost |
numeric(15,3) |
No |
No |
|
Total cost for this period, for this item |