| id |
integer |
Yes |
Yes |
nextval('inventory_requisitions_id_seq'::regclass) |
Unique identifier |
| requisition_no |
character varying(10) |
No |
No |
|
Requisition number |
| status |
character varying(1) |
No |
No |
|
Status of this record; O = Ordered on Purchase Order or Production Order R = Received on Purchase Order or Built on Production Order U = Unordered (not processed) |
| whse |
character varying(6) |
No |
No |
|
Warehouse of Requisition item - links to inventory.whse |
| part_no |
character varying(34) |
No |
No |
|
Part number of Requisition item - links to inventory.part_no |
| description |
character varying(80) |
No |
No |
|
Description of item. Editable description written to the Purchase Order line created |
| unit_cost |
numeric(15,5) |
No |
No |
|
Unit cost to use on Purchase Order - user editable |
| user_cost |
boolean |
No |
No |
|
User Cost Flag to indicate if user edited the cost; FALSE = No TRUE = Yes |
| ref_no |
character varying(20) |
No |
No |
|
Reference number from Sales Order and is editable |
| reqd_date |
date |
No |
No |
|
Required date that will be written to purchase order |
| reqd_qty |
numeric(15,5) |
No |
No |
|
Quantity required |
| received_qty |
numeric(15,5) |
No |
No |
|
Quantity received to date |
| uom |
character varying(10) |
No |
No |
|
Unit of measure to order for this item |
| src_type |
character varying(4) |
No |
No |
|
Source type; INV = Inventory SORD = Sales Order BORD = Production Order |
| src_no |
character varying(40) |
No |
No |
|
Source Production Order number or Sales Order number |
| src_guid |
character varying(32) |
No |
No |
|
Link to sales_ order_items.guid or production_order_items.guid from Requisition |
| src_cust_no |
character varying(20) |
No |
No |
|
Customer number from sales order |
| targ_type |
character varying(4) |
No |
No |
|
Target type; BORD = Production Order PORD = Purchase Order |
| targ_vend_no |
character varying(20) |
No |
No |
|
Target vendor that will be used to create Purchase Order |
| targ_no |
character varying(40) |
No |
No |
|
Purchase Order number or Production Order number that this requistion line created or updated |
| targ_guid |
character varying(32) |
No |
No |
|
Link to purchase_ order_items.guid or production_order_items.guid created by this record |
| ship_to |
character varying(20) |
No |
No |
|
Customer shiptoID that this item was ordered for |
| _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 |