| id |
integer |
Yes |
Yes |
nextval('inventory_adjustments_id_seq'::regclass) |
Unique identifier |
| adjustment_no |
character varying(10) |
No |
No |
|
Adjustment number for this batch - links to inventory_adjustment_items.adjustment_no, gets written to purchase_history_items.po_number when posted. |
| adjustment_mode |
smallint |
No |
No |
|
Adjustment mode; 1 = Adjustment 3 = Transfer |
| src_whse |
character varying(6) |
No |
No |
|
Source warehouse for Inventory Transfer, same as Destination warehouse for Inventory Adjustments |
| src_location |
character varying(24) |
No |
No |
|
General Ledger Location segment of the Source warehouse for companies using Location accounting |
| dst_whse |
character varying(6) |
No |
No |
|
Destination warehouse for Inventory Transfer, same as Source warehouse for Inventory Adjustments |
| dst_location |
character varying(24) |
No |
No |
|
General Ledger Location segment of the Destination warehouse for companies using Location accounting |
| division |
character varying(3) |
No |
No |
|
Division that this Inventory Transfer is to be posted to, 000 for single division companies |
| currency |
character varying(3) |
No |
No |
|
Not used |
| date |
date |
No |
No |
|
Adjustment Date for the transaction |
| ref_no |
character varying(20) |
No |
No |
|
User entered reference number |
| markup_pct |
numeric(9,2) |
No |
No |
|
Markup percentage to be added to the transfer - defaults to the percentage set up in Company Settings, Inventory, Receiving/Transfers, Default Markup Percentage - this will get added to each line of the transfer by default |
| required_date |
date |
No |
No |
|
Date required for transfer |
| received_date |
date |
No |
No |
|
Not used |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created |
timestamp without time zone |
No |
No |
|
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 |
|
Date and time this record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |