id |
integer |
Yes |
Yes |
nextval('inventory_receipts_id_seq'::regclass) |
|
receipt_no |
bigint |
No |
No |
|
Receipt number |
whse |
character varying(6) |
No |
No |
|
Warehouse of item received |
part_no |
character varying(34) |
No |
No |
|
Part number of item received |
receive_date |
date |
No |
No |
|
Date of receipt |
vendor_no |
character varying(20) |
No |
No |
|
Vendor code item received from. Comes from vendor.vendor_no |
whse_location |
character varying(20) |
No |
No |
|
Warehouse location at thime of receipt |
qty |
numeric(15,5) |
No |
No |
|
Quantity received |
cost |
numeric(19,5) |
No |
No |
|
Cost of part numnber received |
selling |
numeric(15,5) |
No |
No |
|
Sell price at time of receipt |
receive_user |
character varying(3) |
No |
No |
|
Initials of user that posted receipt |
link_no |
character varying(10) |
No |
No |
|
The document number that posted receipt. PO number Adjustment number Transfer number |
remaining_qty |
numeric(15,5) |
No |
No |
|
Remaining unsold quantity when using FIFO or LIFO pricing. |
open_close_flag |
character varying(1) |
No |
No |
|
Set to closed when all of the quantity is consumed when using FIFO or LIFO pricing. |
ref_no |
character varying(20) |
No |
No |
|
Reference number from the PO or adjustment |
uom_inventory |
character varying(10) |
No |
No |
|
Inventory or stocking unit of measure |
uom_receive |
character varying(10) |
No |
No |
|
Receipt unit of measure |
qty_receive_uom |
numeric(15,5) |
No |
No |
|
Quantity received of the unit of measure |
_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 |
|
|
link_table |
character varying(4) |
No |
No |
|
The module that received the item PORD = Purchase Order or Adjustment BHIS = Production Order |