IS_ISO_HEADERS

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

tableFINIS

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

Open IS_ISO_HEADERS 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_RUN_NUMBER	varchar(10)
5	IS_DOC_ID	varchar(20)	Interface Server document identifier (integration message key).
6	IS_INB_DOC_ID	varchar(10)
7	SYS_EDI_SENDER_ID	varchar(15)	EDI Sender Identifications
8	SYS_EDI_SENDER_ID_QUAL	varchar(4)	EDI Sender ID Qualifier
9	IS_STATUS	varchar(1)	Interface Server processing status of the record.
10	SYS_EDI_STANDARD	varchar(1)
11	SYS_EDI_VERSION	varchar(6)
12	SYS_EDI_TRANSACTION_SET	varchar(6)
13	SYS_EDI_TEST_FLAG	varchar(1)	EDI Test/Production Flag
14	ORDER_NUMBER	varchar(9)	Order Number
15	SALES_ORDER_TYPE	varchar(6)	Sales Order Type
16	CUSTOMER_REFERENCE	varchar(25)	Customer Reference
17	ORDER_DATE	datetime	Order Date
18	SYS_CURRENCY_CODE	varchar(6)	Currency Code
19	SHIPPING_TERMS_CODE	varchar(8)	Shipping Terms Code
20	PROMISED_DATE	datetime	Promised Date
21	REQUIRED_DATE	datetime	Required Date
22	SYS_EDI_ENTITY_ID_ST	varchar(20)
23	SYS_EDI_ENTITY_ID_QUAL_ST	varchar(2)
24	CUSTOMER_NAME	varchar(60)	Customer Name
25	SYS_EDI_ENTITY_ID_BT	varchar(20)
26	SYS_EDI_ENTITY_ID_QUAL_BT	varchar(2)
27	NOTE_DESCRIPTION	text	Note Description
28	CUSTOMER_CONTACT	varchar(20)	Customer Contact
29	CREDIT_TERMS_CODE	varchar(6)	Credit Terms Code
30	SYS_EDI_TERMS_TYPE	varchar(2)	EDI Terms Type Code
31	SYS_EDI_DEPT_NUMBER	varchar(20)
32	SYS_EDI_MDSE_TYPE_CODE	varchar(20)
33	SYS_EDI_VENDOR_NUMBER	varchar(25)
34	INVOICE_ADDRESS_CODE	varchar(10)	Invoice Address Code
35	IS_SHIP_TO_QUAL	varchar(2)
36	IS_SHIP_TO_ID	varchar(20)
37	DELIVERY_ADDRESS_CODE	varchar(10)	Delivery Address Code
38	SYS_FREIGHT_CONTRACT_NUMBER	varchar(12)	Contract Number
39	SYS_FREIGHT_MODE	varchar(8)	Freight Mode
40	PRICE_CODE	varchar(6)	Price Code
41	SALESPERSON_CODE	varchar(8)	Salesperson Code
42	SALES_COMMISSION_CODE	varchar(8)	Sales Commission Group
43	LOCATION	varchar(8)	Location
44	SALES_ANALYSIS_GROUP	varchar(8)	Sales Analysis Group Code
45	ORDER_DISCOUNT	numeric(20,2)	Order Discount
46	ORDER_DISCOUNT_PERCENT	numeric(10,2)	Order Discount Percentage
47	CREDIT_STATUS_CODE	varchar(6)	Credit Status Code
48	ORDER_DISCOUNT_GROUP	varchar(6)	Order Discount Group
49	LINE_VALUE_DISCOUNTED	numeric(20,2)	Line Value (after order discount)
50	FREIGHT	numeric(20,2)	Freight Value
51	MISCELLANEOUS	numeric(20,2)	Miscellaneous Charge
52	WEIGHT	numeric(20,4)	Weight of Product
53	WEIGHT_UOM	varchar(4)	Weight Unit of Measure
54	VOLUME	numeric(20,4)	Total Volume (cubic size)
55	VOLUME_UOM	varchar(4)	Volume Unit of Measure
56	NOTES	text	Notes
57	HOLD_STATUS_CODE	varchar(6)	Sales Order Hold Status Code
58	STOP_CODE	varchar(8)	Stop Code
59	SYS_CURRENCY_DATE	datetime	Currency Date
60	DELIVERY_INSTRUCTIONS	varchar(30)	Delivery Instructions
61	IS_ACTIVATION_STATUS	varchar(1)
62	USERNAME	varchar(20)	Username
63	SYSTEM_DATE	datetime	System Date Transaction Made
64	TOTAL_ORDER_QUANTITY	numeric(20,6)	Total Order Quantity
65	SOP_ORDER_TOTAL_BASE	numeric(20,2)	Total Order Value in Base Currency
66	SOP_ORDER_TOTAL_CURRENCY	numeric(20,2)	Total Order Line Value in Currency
67	LINE_DISCOUNT	numeric(20,2)	Line Discount
68	PHONE	varchar(21)	Phone Number
69	IS_MONITOR_RUN_NUMBER	varchar(10)
70	TOTAL_ORDER_VALUE	varchar(15)	Total Order Value
71	CUSTOMER_REFERENCE_2	varchar(20)	Customer Reference
72	SYS_EDI_STATUS_CODE	varchar(1)	EDI Status Code
73	CUSTOMER_NUMBER	varchar(8)	Customer Number
74	COST_CENTER	varchar(3)	Cost Center Code
75	LINE_TAX	numeric(20,2)	Line Tax
76	LINE_TAXABLE_VALUE	numeric(20,2)	Line Taxable value
77	LINE_TAX_DISCOUNTED	numeric(20,2)	Line Tax (after order discount)
78	FREIGHT_TAX_CODE	varchar(5)	Tax code associated with this freight code
79	TAX_ON_FREIGHT	numeric(20,2)	Tax on Freight
80	MISC_TAX_CODE	varchar(5)	Miscellaneous Tax Code
81	FREIGHT_CHARGED	numeric(20,2)	Freight Charged to Date
82	MISCELLANEOUS_CHARGED	numeric(20,2)	Miscellaneous Charged to Date
83	FREIGHT_TAX_CHARGED	numeric(20,2)	Freight Tax Charged
84	TOTAL_TAX	numeric(20,2)	Total Tax This Period
85	CUSTOMER_TAX_CODE	varchar(5)	Customer Tax Code
86	ORDER_CYCLE	varchar(1)	Order Cycle
87	SYS_CURRENCY_RATE	numeric(20,12)	Currency Rate
88	SYS_RATE_TYPE	varchar(6)	Currency Rate Type
89	SYS_RATE_AUTHORITY	varchar(6)	Currency Rate Authority
90	SYS_CURRENCY_RATIO_INDIC	varchar(1)	Ratio Indicator
91	SYS_CURRENCY_FIXED_FLAG	varchar(1)	Currency Rate Fixed Flag
92	SHIP_METHOD	varchar(10)	Method of Shipment
93	SYS_TRANSACTION_SOURCE	varchar(4)	Transaction Source
94	SYS_DOCUMENT_ID	varchar(20)	EDI Document ID
95	SYS_REQUESTED_DATE	datetime	Customer requested date
96	SYS_DELIVERY_DATE	datetime	Delivery Date
97	SYS_SHIPPING_DATE	datetime	Shipping Date
98	SYS_EDI_TERMS_DISC_PERCENT	varchar(6)	EDI Terms Discount Percent
99	SYS_EDI_TERMS_DISC_DAYS_DUE	varchar(3)	EDI Terms_discount Days Due
100	SYS_EDI_TERMS_NET_DAYS	varchar(3)	EDI Terms Net Days
101	LINE_DISCOUNT_GROUP	varchar(6)	Line Discount Group
102	IS_SENDER_ID	varchar(15)
103	IS_REFERENCE_ID	varchar(8)
104	IS_REFERENCE_NAME	varchar(60)
105	WAREHOUSE	varchar(2)	Warehouse Code
106	TAX_ON_MISCELLANEOUS	numeric(20,2)	Tax on Miscellaneous
107	SYS_ADDRESS_1_EDI_ST	varchar(30)
108	SYS_ADDRESS_2_EDI_ST	varchar(30)
109	SYS_CITY_EDI_ST	varchar(25)
110	SYS_COUNTRY_EDI_ST	varchar(6)
111	SYS_STATE_EDI_ST	varchar(6)
112	SYS_PROVINCE_EDI_ST	varchar(6)
113	SYS_POSTAL_CODE_EDI_ST	varchar(12)
114	SYS_ADDRESS_1_EDI_BT	varchar(30)
115	SYS_ADDRESS_2_EDI_BT	varchar(30)
116	SYS_CITY_EDI_BT	varchar(25)
117	SYS_COUNTRY_EDI_BT	varchar(6)
118	SYS_STATE_EDI_BT	varchar(6)
119	SYS_PROVINCE_EDI_BT	varchar(6)
120	SYS_POSTAL_CODE_EDI_BT	varchar(12)
121	SYS_BASE_CURRENCY	varchar(6)
122	SYS_TRADING_PARTNER_CODE	varchar(6)	Trading Partner Code
123	SYS_EDI_SCAC	varchar(4)
124	SYS_EDI_PROMO_NUMBER	varchar(20)
125	PRICING_METHOD	smallint	Pricing method, tax exclusive or inclusive
126	BROKER_CODE	varchar(10)	Broker Code
127	CUSTOMER_GROUP	varchar(8)	Customer Sales Analysis Group
128	SOP_PRINT_CONF_FLAG	varchar(1)	Print Order Acknowledgement
129	AR_DRAFT_PAYMENT_TYPE	varchar(3)
130	STATEMENT_ACCOUNT	varchar(8)	Payment Customer Number
131	SYS_CURRENCY_2_RATE	numeric(20,12)	Second Base Currency Rate
132	SYS_CURRENCY_2_RATIO_INDIC	varchar(1)	Ratio Indicator for Second Base
133	TRANSACTION_CURRENCY_DECIMALS	smallint
134	TP_PROMOTIONS_IN_USE	varchar(1)	Promotions in Use
135	SYS_ADDRESS_3_EDI_BT	varchar(40)
136	NET_WEIGHT	numeric(20,4)
137	IS_EDI_FILENAME	varchar(60)
138	EDI_LOGFILE_NAME	varchar(60)
139	ITRADE_ORDER_NUMBER	varchar(30)
140	FUEL_SURCHARGE	numeric(10,2)
141	PICKUP_ALLOWANCE	numeric(10,2)
142	SYS_EDI_ENTITY_ID_WH	varchar(20)