A_IC_QUALITY_DOC_LINE_DETAILS

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

Archived Quality Document Line Details

tableFINIC

A_IC_QUALITY_DOC_LINE_DETAILS — Archived Quality Document Line Details. FIN table in the standard Ross ERP 8.0 schema: 23 columns, used by 6 programs. Columns, data types, keys, foreign keys and relationships.

Open A_IC_QUALITY_DOC_LINE_DETAILS in the interactive Data Dictionary →

Part of IC 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	ARCHIVE_ID	varchar(1)	Prefix Fields for Archive Tables
3	COMPANY_CODE	varchar(10)	Company Code
4	QUALITY_DOC_NBR	varchar(12)	Quality Document Number
5	QUALITY_DOC_LINE_NBR	int	Quality Document Line Number
6	SOURCE_MODULE	varchar(2)	Source Module Reference
7	IC_STATUS_CODE	varchar(8)	Inventory Status
8	SYSTEM_DATE	datetime	System Date Transaction Made
9	USERNAME	varchar(20)	Username
10	IC_QUALITY_ADJ_TYPE	varchar(1)	Quality Document Adjustment Type
11	IC_PACK_OR_CAP_QTY	numeric(20,6)	Package or capacity quantity
12	IC_NOT_CAP_QTY	numeric(20,6)	Non-capacity unit movement quantity
13	IC_CAP_IF_PACKED_QTY	numeric(20,6)	Capacity Unit if Pack Product Movement Quantity
14	UNIT_COST	numeric(20,6)	Unit Cost
15	ARCHIVE_DATE	datetime	Archive Date
16	ARCHIVE_USERNAME	varchar(20)	Username recorded when the row was moved to the archive.
17	NEW_WAREHOUSE	varchar(2)
18	NEW_QUALITY_DOC_NBR	varchar(12)
19	NEW_QUALITY_DOC_LINE_NBR	int
20	NEW_LOT_NUMBER	varchar(20)
21	DOCUMENT_LINE_NUMBER	int
22	DOCUMENT_REF	varchar(15)
23	GEM_ARCHIVE_FLAG	varchar(20)	System flag indicating whether the row has been archived by the GEMBASE archive process.