| id |
integer |
Yes |
Yes |
nextval('inventory_count_details_id_seq'::regclass) |
Unique identifier |
| sequence |
integer |
Yes |
No |
|
Sequencial record number |
| count_id |
integer |
Yes |
No |
|
Link to the counter header table - links to inventory_counts.id |
| inventory_id |
integer |
Yes |
No |
|
The inventory.id of this item - links to inventory.id |
| serial_id |
integer |
No |
No |
|
The serial number record for this item - links to inventory_serial_numbers.id |
| parent_id |
integer |
No |
No |
|
The id of the parent record for all of the counts belonging to a single part number |
| guid |
character varying(32) |
No |
No |
|
A unigue record identifier for linking to other tables like inventory_serial_transactions, inventory_receipts |
| count_time |
timestamp without time zone |
No |
No |
|
Date and time that this count record was recorded |
| uom |
character varying(10) |
No |
No |
|
Unit of measure recorded with this count record, may be different then inventory.uom_inventory |
| whse_location |
character varying(20) |
No |
No |
|
Physical location in the warehouse where part number was counted |
| expected_qty |
numeric(15,5) |
No |
No |
|
The onhand quantity that was expected to exist, inventory.onhand_qty when the Invoice Count was created (Frozen) |
| committed_qty |
numeric(15,5) |
No |
No |
|
The committed quantity that was in inventory.committed_qty when the Inventory Count was created (Frozen) |
| counted_qty |
numeric(15,5) |
No |
No |
|
The count quanitity for this record |
| inventory_qty |
numeric(15,5) |
No |
No |
|
The count quantity for this record in the inventory unit of measure |
| cost |
numeric(15,5) |
No |
No |
|
The average cost of this item |
| unit_variance |
numeric(15,5) |
No |
No |
|
The variance quantity for this item |
| gain_loss |
numeric(15,5) |
No |
No |
|
The amount of loss (negative) or gain for this item |
| notes |
text |
No |
No |
|
User added notes for this record |
| count_user |
character varying(3) |
No |
No |
|
The initials of the user that recorded the count for this record |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time this record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |