IS_ISO_LINES

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

tableFINIS

IS_ISO_LINES — FIN table in the standard Ross ERP 8.0 schema: 143 columns. Columns, data types, keys, foreign keys and relationships.

Open IS_ISO_LINES in the interactive Data Dictionary →

Part of IS 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	IS_DOC_ID	varchar(20)	Interface Server document identifier (integration message key).
5	IS_LINE_NUMBER	varchar(4)
6	IS_STATUS	varchar(1)	Interface Server processing status of the record.
7	ORDER_NUMBER	varchar(9)	Order Number
8	ORDER_LINE_TYPE	varchar(1)	Order Line Type
9	IS_INB_DOC_ID	varchar(10)
10	ORDER_DATE	datetime	Order Date
11	REQUIRED_DATE	datetime	Required Date
12	EDI_UNIT_OF_MEASURE	varchar(2)
13	SALES_PRICE	numeric(20,4)	Standard Sales Price
14	PART_CODE	varchar(15)	Product
15	CUSTOMERS_PART_CODE	varchar(20)	Customer Product
16	SYS_EDI_PRODUCT_ID	varchar(40)	Industry Product ID
17	DETAIL_DESCRIPTION	text	Detailed Description
18	SYS_EDI_PACK	varchar(6)
19	SYS_EDI_SIZE	varchar(8)
20	SYS_EDI_INNER_PACK	varchar(6)
21	PRODUCT_GROUP	varchar(6)	Product Group
22	WAREHOUSE	varchar(2)	Warehouse Code
23	IC_LOT_NUMBER	varchar(20)	Lot Number
24	ORDER_QUANTITY	numeric(20,6)	Order Quantity
25	SYS_EDI_UNIT_CODE	varchar(2)	EDI Unit Code
26	UNIT_SALES	varchar(4)	Unit of Measure (Sales)
27	UNIT_PRICE	varchar(4)	Unit of Measure (Pricing)
28	IC_PACK_UNIT	varchar(4)	Packaged Unit Of Measure
29	SOP_NOMINATED_UNIT	varchar(4)	Inventory unit which Sales unit converts to
30	SOP_NOMINATED_PRICE_UNIT	varchar(4)	Inventory unit which Sales Pricing unit converts to
31	LINE_DISCOUNT	numeric(20,2)	Line Discount
32	LINE_DISCOUNT_PERCENT	numeric(10,2)	Line Discount Percentage
33	DELIVERY_ADDRESS_CODE	varchar(10)	Delivery Address Code
34	CONTRACT_NUMBER	varchar(15)	Contract Number
35	SALESPERSON_CODE	varchar(8)	Salesperson Code
36	SALES_COMMISSION_CODE	varchar(8)	Sales Commission Group
37	LOCATION	varchar(8)	Location
38	SALES_ANALYSIS_GROUP	varchar(8)	Sales Analysis Group Code
39	WEIGHT	numeric(20,4)	Weight of Product
40	WEIGHT_UOM	varchar(4)	Weight Unit of Measure
41	VOLUME	numeric(20,4)	Total Volume (cubic size)
42	VOLUME_UOM	varchar(4)	Volume Unit of Measure
43	CUSTOMER_NUMBER	varchar(8)	Customer Number
44	SOP_ORDER_TOTAL_CURRENCY	numeric(20,2)	Total Order Line Value in Currency
45	SOP_ORDER_TOTAL_BASE	numeric(20,2)	Total Order Value in Base Currency
46	CREDIT_TERMS_CODE	varchar(6)	Credit Terms Code
47	SYS_CURRENCY_CODE	varchar(6)	Currency Code
48	SYS_CURRENCY_DATE	datetime	Currency Date
49	USERNAME	varchar(20)	Username
50	SYSTEM_DATE	datetime	System Date Transaction Made
51	SYS_EDI_TERMS_TYPE	varchar(2)	EDI Terms Type Code
52	SYS_EDI_TERMS_BASIS_DATE	varchar(2)	EDI Terms Basis Date Code
53	SYS_EDI_TERMS_DISC_PERCENT	varchar(6)	EDI Terms Discount Percent
54	SYS_EDI_TERMS_DISC_DUE_DATE	varchar(6)	EDI Terms Discount Due Date
55	SYS_EDI_TERMS_NET_DUE_DATE	varchar(6)	EDI Terms Net Due Date
56	SYS_EDI_TERMS_NET_DAYS	varchar(3)	EDI Terms Net Days
57	SYS_EDI_DEFERRED_DUE_DATE	varchar(6)	EDI Deferred Due Date
58	SYS_EDI_DEFERRED_AMOUNT_DUE	varchar(10)	EDI Deferred Amount Due
59	SYS_EDI_PERCENT_INVOICE	varchar(5)	EDI Percent of Invoice Payable
60	SYS_EDI_TERMS_DAY_OF_MONTH	varchar(2)	EDI Terms Day of Month
61	SYS_EDI_PAYMENT_METHOD_CODE	varchar(1)	EDI Payment Method Code
62	SYS_EDI_TERMS_PERCENT	varchar(10)	EDI Terms Percent
63	SYS_EDI_TERMS_DISC_DAYS_DUE	varchar(3)	EDI Terms_discount Days Due
64	SYS_EDI_TERMS_DISC_AMOUNT	varchar(10)	EDI Terms Discount Amount
65	SHIPPING_TERMS_CODE	varchar(8)	Shipping Terms Code
66	SYS_FREIGHT_CONTRACT_NUMBER	varchar(12)	Contract Number
67	SYS_FREIGHT_MODE	varchar(8)	Freight Mode
68	ORDER_LINE_NUMBER	int	Order Line Number
69	SEQUENCE	smallint	Sequence Number
70	PROMISED_DATE	datetime	Promised Date
71	UNIT_COST	numeric(20,6)	Unit Cost
72	LINE_TAX	numeric(20,2)	Line Tax
73	CUSTOMER_TAX_CODE	varchar(5)	Customer Tax Code
74	PRODUCT_TAX_CODE	varchar(5)	Product Tax Code
75	COST_CENTER	varchar(3)	Cost Center Code
76	ORDER_CYCLE	varchar(1)	Order Cycle
77	SYS_RATE_TYPE	varchar(6)	Currency Rate Type
78	SYS_RATE_AUTHORITY	varchar(6)	Currency Rate Authority
79	SYS_CURRENCY_RATIO_INDIC	varchar(1)	Ratio Indicator
80	SYS_CURRENCY_FIXED_FLAG	varchar(1)	Currency Rate Fixed Flag
81	DELIVERY_INSTRUCTIONS	varchar(30)	Delivery Instructions
82	SHIP_METHOD	varchar(10)	Method of Shipment
83	SOP_FRT_DORC_INDICATOR	smallint	Freight Debit or Credit
84	FREIGHT	numeric(20,2)	Freight Value
85	SYS_EDI_PRICE	varchar(17)	EDI Price
86	SYS_CURRENCY_RATE	numeric(20,12)	Currency Rate
87	SYS_EDI_ORDER_QUANTITY	numeric(20,6)
88	IS_LINE_SEQUENCE	varchar(8)
89	SYS_BASE_CURRENCY	varchar(6)
90	PRICE_ORDER_QUANTITY	numeric(20,6)
91	EDI_LINE_NUMBER	smallint
92	TP_PROMOTION_CODE_1	varchar(10)	Promotion Code
93	DISCOUNT_1	numeric(20,2)	Discount Allowed
94	TP_PROMOTION_CODE_2	varchar(10)	Promotion Code
95	TP_PROMOTION_CODE_3	varchar(10)	Promotion Code
96	TP_PROMOTION_CODE_4	varchar(10)	Promotion Code
97	TP_PROMOTION_CODE_5	varchar(10)	Promotion Code
98	DISCOUNT_2	numeric(20,2)	Discount Allowed
99	DISCOUNT_3	numeric(20,2)	Discount Allowed
100	DISCOUNT_4	numeric(20,2)	Discount Allowed
101	DISCOUNT_5	numeric(20,2)	Discount Allowed
102	TP_DISCOUNT_TYPE_1	varchar(2)	Discount return type
103	TP_DISCOUNT_TYPE_2	varchar(2)	Discount return type
104	TP_DISCOUNT_TYPE_3	varchar(2)	Discount return type
105	TP_DISCOUNT_TYPE_4	varchar(2)	Discount return type
106	TP_DISCOUNT_TYPE_5	varchar(2)	Discount return type
107	UNIT_OF_MEASURE_1	varchar(2)	Unit of Measure
108	UNIT_OF_MEASURE_2	varchar(2)	Unit of Measure
109	UNIT_OF_MEASURE_3	varchar(2)	Unit of Measure
110	UNIT_OF_MEASURE_4	varchar(2)	Unit of Measure
111	UNIT_OF_MEASURE_5	varchar(2)	Unit of Measure
112	CDC_TP_PROM_CODE_1	varchar(10)
113	CDC_TP_PROM_CODE_2	varchar(10)
114	CDC_TP_PROM_CODE_3	varchar(10)
115	CDC_TP_PROM_CODE_4	varchar(10)
116	CDC_TP_PROM_CODE_5	varchar(10)
117	CDC_DISCOUNT_1	numeric(20,2)
118	CDC_DISCOUNT_2	numeric(20,2)
119	CDC_DISCOUNT_3	numeric(20,2)
120	CDC_DISCOUNT_4	numeric(20,2)
121	CDC_DISCOUNT_5	numeric(20,2)
122	LINE_DISCOUNT_1	numeric(20,2)	Line Discount
123	LINE_DISCOUNT_2	numeric(20,2)	Line Discount
124	LINE_DISCOUNT_3	numeric(20,2)	Line Discount
125	LINE_DISCOUNT_4	numeric(20,2)	Line Discount
126	LINE_DISCOUNT_5	numeric(20,2)	Line Discount
127	ORDER_LINE_REFERENCE	varchar(8)	Order Line Reference
128	SYS_SHIPPING_DATE	datetime	Shipping Date
129	ORDER_HORIZON	varchar(1)	Order Horizon
130	FINAL_ADDRESS_CODE	varchar(10)	Invoice Address Code
131	SYS_DELIVERY_DATE	datetime	Delivery Date
132	PRICE_RECORD_NUMBER	int
133	VERSION_NUMBER	int
134	NON_NOMI_UOM	varchar(4)
135	NOMI_ORDER_QTY	numeric(20,6)
136	PACK_ORDER_QTY	numeric(20,6)
137	NOMI_PRICE_ORDER_QTY	numeric(20,6)
138	NON_NOMI_ORDER_QTY	numeric(20,6)
139	BREAK_DISCOUNT	numeric(20,4)	Break Discount
140	BROKER_CODE	varchar(10)	Broker Code
141	SYS_EDI_PRICE_CONVERTED	varchar(17)
142	FUEL_SURCHARGE	numeric(10,2)
143	PICKUP_ALLOWANCE	numeric(10,2)