DC_PO_GR_LINES_HST

Name: DC_PO_GR_LINES_HST
Creator: Ryan Brents
License: https://creativecommons.org/licenses/by/4.0/

Data from DC Receiving transaction

tableFINDC

DC_PO_GR_LINES_HST — Data from DC Receiving transaction. FIN table in the standard Ross ERP 8.0 schema: 24 columns, used by 2 programs. Columns, data types, keys, foreign keys and relationships.

Open DC_PO_GR_LINES_HST in the interactive Data Dictionary →

Part of DC tables & objects · all tables, views & procedures

Columns

#	Column	Type	Description
1	GEM_DBKEY	int	GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2	DC_TRANSACTION_ID	varchar(64)	Data Collection (RF/mobile) transaction identifier for the row.
3	GRN_NUMBER	varchar(9)	Goods Received Note Number
4	GRN_LINE_NUMBER	int	Goods Received Note Line Number
5	BEST_BEFORE_DATE	datetime	Best Before End / Best Before Date
6	BIN_LOCATION	varchar(15)	Bin Location
7	CREATION_DATE	datetime	Creation Date
8	GRN_COST	numeric(20,4)	Goods Received Note Cost
9	IC_LOT_NUMBER	varchar(20)	Lot Number
10	IC_OTHER_INVENTORY_QTY	numeric(20,6)	Quantity of the Inventory UOM which is not the Nominated UOM
11	IC_OTHER_INVENTORY_UNIT	varchar(4)	Other Inventory UOM
12	IC_RETEST_DATE	datetime	Retest Date
13	IC_STATUS_CODE	varchar(8)	Inventory Status
14	IC_VENDOR_LOT_NUMBER	varchar(20)	Supplier Lot Number
15	LOT_EXPIRY_DATE	datetime
16	MH_NUMBER	int	Material Handling Number
17	ORDER_LINE_REFERENCE	varchar(8)	Order Line Reference
18	PART_CODE	varchar(15)	Product
19	PO_LINE_NUMBER	int	Purchase Order Line Number
20	QTY_RECEIVED	numeric(20,6)	Qty Received
21	QUALITY_CODE	varchar(8)	Quality Code
22	QUALITY_DOC_NBR	varchar(12)	Quality Document Number
23	UNIT_REC	varchar(4)	Unit of Measure (Receiving)
24	WAREHOUSE	varchar(2)	Warehouse Code