IS_OOA_HEADERS

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

tableFINIS

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

Open IS_OOA_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_DOC_ID	varchar(20)	Interface Server document identifier (integration message key).
5	IS_STATUS	varchar(1)	Interface Server processing status of the record.
6	IS_ACTIVATION_STATUS	varchar(1)
7	IS_MONITOR_RUN_NUMBER	varchar(10)
8	SYS_EDI_STATUS_CODE	varchar(1)	EDI Status Code
9	ORDER_NUMBER	varchar(9)	Order Number
10	ORDER_DATE	datetime	Order Date
11	PROMISED_DATE	datetime	Promised Date
12	CUSTOMER_CONTACT	varchar(20)	Customer Contact
13	CUSTOMER_REFERENCE	varchar(25)	Customer Reference
14	CUSTOMER_REFERENCE_2	varchar(20)	Customer Reference
15	SYSTEM_DATE	datetime	System Date Transaction Made
16	USERNAME	varchar(20)	Username
17	SYS_EDI_SENDER_ID	varchar(15)	EDI Sender Identifications
18	SYS_EDI_SENDER_ID_QUAL	varchar(4)	EDI Sender ID Qualifier
19	CUSTOMER_NUMBER	varchar(8)	Customer Number
20	DELIVERY_ADDRESS_CODE	varchar(10)	Delivery Address Code
21	SYS_TRADING_PARTNER_CODE	varchar(6)	Trading Partner Code
22	SYS_EDI_STANDARD	varchar(1)
23	SYS_EDI_VERSION	varchar(6)
24	SYS_EDI_TRANSACTION_SET	varchar(6)
25	SYS_EDI_TEST_FLAG	varchar(1)	EDI Test/Production Flag
26	SYS_EDI_TRANS_SET_PURPOSE_CODE	varchar(2)
27	SYS_EDI_ENTITY_ID_ST	varchar(20)
28	SYS_EDI_ENTITY_ID_QUAL_ST	varchar(2)
29	CUSTOMER_NOTES	text	Customer Notes
30	SOP_DESTINATION_WAREHOUSE	varchar(2)
31	SYS_ADDRESS_1_EDI_ST	varchar(30)
32	SYS_ADDRESS_2_EDI_ST	varchar(30)
33	SYS_ADDRESS_3_EDI_ST	varchar(40)
34	SYS_ADDRESS_4_EDI_ST	varchar(40)
35	SYS_CITY_EDI_ST	varchar(25)
36	SYS_STATE_EDI_ST	varchar(6)
37	SYS_POSTAL_CODE_EDI_ST	varchar(12)
38	SYS_EDI_DELIVERY_ADDR_NAME	varchar(30)
39	SYS_COUNTRY_EDI_ST	varchar(6)
40	SOP_SHIPPING_TERMS_CODE	varchar(8)
41	SALES_ORDER_TYPE	varchar(6)	Sales Order Type
42	IS_ACKNOWLEDGEMENT_TYPE	varchar(2)
43	EDI_LOGFILE_NAME	varchar(60)
44	SYS_DELIVERY_DATE	datetime	Delivery Date
45	SYS_SHIPPING_DATE	datetime	Shipping Date
46	CORP_OFFICE_NAME	varchar(30)	Office Name
47	SYS_ADDRESS_1	varchar(40)	Address Line 1
48	SYS_ADDRESS_2	varchar(40)	Address Line 2
49	SYS_CITY	varchar(25)	City
50	SYS_STATE	varchar(6)	State Code
51	SYS_POSTAL_CODE	varchar(12)	Postal Code
52	TOTAL_LINES	int
53	TOTAL_CASES	numeric(20,6)
54	TOTAL_WEIGHT	numeric(20,6)
55	TOTAL_ORDER_VALUE	varchar(15)	Total Order Value
56	INVOICE_ADDRESS_CODE	varchar(10)	Invoice Address Code
57	SYS_ADDRESS_1_EDI_BT	varchar(30)
58	SYS_ADDRESS_2_EDI_BT	varchar(30)
59	SYS_CITY_EDI_BT	varchar(25)
60	SYS_STATE_EDI_BT	varchar(6)
61	SYS_POSTAL_CODE_EDI_BT	varchar(12)
62	SYS_COUNTRY_EDI_BT	varchar(6)
63	SYS_EDI_ENTITY_ID_BT	varchar(20)
64	CUSTOMER_NAME	varchar(60)	Customer Name
65	ITRADE_ORDER_NUMBER	varchar(30)
66	SYS_EDI_DEPT_NUMBER	varchar(20)
67	SYS_EDI_VENDOR_NUMBER	varchar(25)
68	FUEL_SURCHARGE	numeric(10,2)
69	PICKUP_ALLOWANCE	numeric(10,2)