| 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 |