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 |