id |
integer |
Yes |
Yes |
nextval('inventory_counts_id_seq'::regclass) |
Unique identifier |
count_no |
character varying(10) |
Yes |
No |
|
Batch number for this Inventory Count |
start_date |
date |
No |
No |
|
Start date for count |
finish_date |
date |
No |
No |
|
Finish date for count |
total_unit_variance |
numeric(15,5) |
No |
No |
|
Total variance quantity for this batch |
total_gain_loss |
numeric(15,5) |
No |
No |
|
The total amount of loss (negative) or gain for this batch |
location |
character varying(24) |
No |
No |
|
General Ledger Location segment of the warehouse for companies using Location accounting |
posted |
boolean |
Yes |
No |
false |
Batch posted flag; FALSE = No TRUE = Yes |
trans_no |
character varying(10) |
No |
No |
|
General Ledger transaction number for posting |
notes |
text |
No |
No |
|
User added notes for this batch |
_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 |