Field | Type | Default | Description |
---|---|---|---|
category_id | int (11) | NOT NULL | PRIMARY KEY - Auto increment field to hold unique ID |
journal_main_id | int (11) | 0 | Refers to the id in table journal_main for a transaction |
sku | varchar (15) | NOT NULL | The sku that was not in stock for a sales transaction |
qty | float | 0 | Qty of the sku owed calculation of cost of goods sold |
post_date | date | 0000-00-00 | The post date of the transaction. This value is used for sorting when determining the cost method (FIFO, LIFO, average) to sequence properly |