| id |
integer |
Yes |
Yes |
nextval('inventory_adjustment_items_id_seq'::regclass) |
Unique identifier |
| adjustment_no |
character varying(10) |
No |
No |
|
Adjustment number for this batch - links to inventory_adjustments.adjustment_no |
| sequence |
integer |
No |
No |
|
Sequential line number for the adjustment batch |
| whse |
character varying(6) |
No |
No |
|
Warehouse of the item being adjusted - links to inventory.whse |
| part_no |
character varying(34) |
No |
No |
|
Part number of the item being adjusted - links to inventory.part_no |
| uom_inventory |
character varying(10) |
No |
No |
|
The stocking unit of measure of the item |
| uom_receive |
character varying(10) |
No |
No |
|
The unit of measure being used for this adjustment |
| qty |
numeric(15,5) |
No |
No |
|
Quantity being adjusted |
| qty_uom_inventory |
numeric(15,5) |
No |
No |
|
The amount that will be changed in inventory.onhand_qty using the inventory unit of measure |
| user_cost_flag |
boolean |
No |
No |
|
User override cost flag; FALSE = No TRUE = Yes |
| cost |
numeric(15,5) |
No |
No |
|
Item cost to use for the adjustment using the receive unit of measure |
| duty_by_pct |
boolean |
No |
No |
|
Not used |
| duty_pct |
numeric(5,2) |
No |
No |
|
Not used |
| duty_amt |
numeric(15,5) |
No |
No |
|
Not used |
| freight_by_pct |
boolean |
No |
No |
|
Future use |
| freight_pct |
numeric(5,2) |
No |
No |
|
Future use |
| freight_amt |
numeric(15,5) |
No |
No |
|
Future use |
| gl_account |
character varying(24) |
No |
No |
|
General Ledger Account that adjustment wil post to, defaults to Company Settings, Inventory, Receiving/Transfers, Default Adjustment Account |
| sell01 |
numeric(15,5) |
No |
No |
|
Selling Price 01 for this item. It is editable and will update the sell price in inventory_umos.sell_prices[1] when this Adjustment is posted. |
| user_sell01_flag |
boolean |
No |
No |
|
User override sell price flag; FALSE = No TRUE = Yes |
| guid |
character varying(32) |
No |
No |
|
Unique identifier for this record - links to other tables like inventory_serial_transactions.guid |
| whse_location |
character varying(20) |
No |
No |
|
Physical location the item is stored in the warehouse. This field is editable by user and will update table inventory_uoms.whse_location when posted |
| pack_size |
numeric(9,3) |
No |
No |
|
Pack size for this item, field is editable by user and will update inventory.pack_size when this Adjustment is posted |
| transfer_pct |
numeric(9,2) |
No |
No |
|
Used by Inventory Transfer to increase the value of the item in the receiving warehouse. - Defaults to the percentage set on the header of the Inventory Transfer - Posts to General Ledger account set up in Company Settings, Inventory, Receiving/Transfers, Transfer Markup Account |
| _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 |