id |
integer |
Yes |
Yes |
nextval('inventory_adjustments_id_seq'::regclass) |
|
adjustment_no |
character varying(10) |
No |
No |
|
Adjustment number. Links to inventory_adjustment_items.adjustment_no |
adjustment_mode |
smallint |
No |
No |
|
Adjustment mode 1 = Adjustment 3 = Transfer |
src_whse |
character varying(6) |
No |
No |
|
Source warehouse. For adjustment this will be the same as inventory_adjustments.dst_whse. For transfers they must be different |
src_location |
character varying(24) |
No |
No |
|
Source locaton for the adjustment. This is the source from when the company is set as multi location accounting. Not to be confused with warehouse location. |
dst_whse |
character varying(6) |
No |
No |
|
Destination warehouse for a transfer |
dst_location |
character varying(24) |
No |
No |
|
Destination locaton for the adjustment. This is the destinaton from when the company is set as multi location accounting. Not to be confused with warehouse location. |
division |
character varying(3) |
No |
No |
|
Division that this trnasfer is to be posted to. If divisions are not turned on this wil always be 000 |
currency |
character varying(3) |
No |
No |
|
|
date |
date |
No |
No |
|
Date the adjustment transaction is to be posted to. |
po_number |
character varying(10) |
No |
No |
|
|
vendor_no |
character varying(20) |
No |
No |
|
|
markup_pct |
numeric(9,2) |
No |
No |
|
Markup percentage to be added to the transfer. If added to the header this will get added to each line of the transfer by default |
required_date |
date |
No |
No |
|
|
received_date |
date |
No |
No |
|
|
_dbversion |
integer |
No |
No |
|
|
_created |
timestamp without time zone |
No |
No |
|
|
_created_by |
character varying(3) |
No |
No |
|
|
_modified |
timestamp without time zone |
No |
No |
|
|
_modified_by |
character varying(3) |
No |
No |
|
|