POP_GS1_RECEIVING_LINES

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

tableFINPOP

POP_GS1_RECEIVING_LINES — FIN table in the standard Ross ERP 8.0 schema: 28 columns, used by 8 programs. Columns, data types, keys, foreign keys and relationships.

Open POP_GS1_RECEIVING_LINES in the interactive Data Dictionary →

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

Columns

#	Column	Type	Key	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	COMPANY_CODE	varchar(10)	PK	Company Code
3	DIVISION	varchar(2)	PK	Division
4	GRN_RUN_NUMBER	varchar(9)	PK	GRN Run Number
5	PALLET_ID	varchar(30)	PK
6	LINE_NUMBER	smallint	PK	Line Number
7	GRN_NUMBER	varchar(9)		Goods Received Note Number
8	GRN_LINE_NUMBER	int		Goods Received Note Line Number
9	PO_NUMBER	varchar(10)		Purchase Order Number
10	PO_LINE_NUMBER	int		Purchase Order Line Number
11	GS1_LABEL	varchar(100)
12	PART_CODE	varchar(15)		Product
13	PART_DESC_1	varchar(60)		Product Description
14	EAN_NUMBER	varchar(15)		GTIN
15	DC_CASE_SERIAL_NUMBER	varchar(30)
16	IC_PACK_OR_CAP_QTY	numeric(20,6)		Package or capacity quantity
17	IC_PACK_OR_CAP_UNIT	varchar(4)		Packaged or capacity unit of measure
18	IC_NOT_CAP_QTY	numeric(20,6)		Non-capacity unit movement quantity
19	IC_NOT_CAP_UNIT	varchar(4)		Not Capacity Unit of Measure
20	IC_CAP_IF_PACKED_QTY	numeric(20,6)		Capacity Unit if Pack Product Movement Quantity
21	IC_CAP_IF_PACKED_UNIT	varchar(4)		Capacity Unit if packaged product
22	IC_VENDOR_LOT_NUMBER	varchar(20)		Supplier Lot Number
23	IC_LOT_NUMBER	varchar(20)		Lot Number
24	MANUFACTURING_DATE	datetime		Manufactured Date
25	IC_STATUS_CODE	varchar(8)		Inventory Status
26	USERNAME	varchar(20)		Username
27	SYSTEM_DATE	datetime		System Date Transaction Made
28	GEM_ARCHIVE_FLAG	varchar(20)		System flag indicating whether the row has been archived by the GEMBASE archive process.