SALES_ORDER_TEST_LINE_DETAILS

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

SALES ORDER TEST LINES DETAILS ADDED FOR EDI PROCESSING

tableFINSALES

SALES_ORDER_TEST_LINE_DETAILS — SALES ORDER TEST LINES DETAILS ADDED FOR EDI PROCESSING. FIN table in the standard Ross ERP 8.0 schema: 28 columns, used by 5 programs. Columns, data types, keys, foreign keys and relationships.

Open SALES_ORDER_TEST_LINE_DETAILS in the interactive Data Dictionary →

Part of SALES 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	COMPANY_CODE	varchar(10)	Company Code
3	DIVISION	varchar(2)	Division
4	ORDER_NUMBER	varchar(9)	Order Number
5	ORDER_LINE_NUMBER	int	Order Line Number
6	SEQUENCE	smallint	Sequence Number
7	ORDER_LINE_REF	varchar(10)	Order Line Reference
8	ACKNOWLEDGE_DATE	datetime	Acknowledged Date
9	ORDER_QUANTITY	numeric(20,6)	Order Quantity
10	TEMP_ORDER_QUANTITY	numeric(20,6)
11	ORDER_HORIZON	varchar(1)	Order Horizon
12	ORDER_DATE	datetime	Order Date
13	STATUS_FLAG	varchar(1)	Status Flag
14	QTY_PICKED	numeric(20,6)	Quantity Picked
15	QTY_IN_DESPATCH	numeric(20,6)	Quantity in Shipping
16	QTY_INVOICED	numeric(20,6)	Quantity Invoiced
17	QTY_DESPATCHED	numeric(20,6)	Quantity Shipped
18	QTY_RESERVED	numeric(20,6)	Quantity Reserved To Sales Orders
19	ORDER_LINE_STATUS	varchar(1)	Order Line Status
20	TEMP_QTY_RESERVED	numeric(20,6)
21	QUANTITY_PROMISED	numeric(20,6)	Quantity Promised
22	IC_LOT_NUMBER	varchar(20)	Lot Number
23	TEMP_REQUIRED_DATE	datetime
24	ORDER_QUANTITY_PROCESSED	computed
25	ORDER_QUANTITY_COMMITTED	computed
26	ORDER_QUANTITY_OUTSTANDING	computed
27	ORDER_QUANTITY_UNRESERVED	computed
28	GEM_ARCHIVE_FLAG	varchar(20)	System flag indicating whether the row has been archived by the GEMBASE archive process.