IS_OSI_HEADERS

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

tableFINIS

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

Open IS_OSI_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	CUSTOMER_NAME	varchar(60)	Customer Name
4	CUSTOMER_NUMBER	varchar(8)	Customer Number
5	DIVISION	varchar(2)	Division
6	IS_DOC_ID	varchar(20)	Interface Server document identifier (integration message key).
7	IS_STATUS	varchar(1)	Interface Server processing status of the record.
8	IS_ACTIVATION_STATUS	varchar(1)
9	IS_MONITOR_RUN_NUMBER	varchar(10)
10	SYS_TRADING_PARTNER_CODE	varchar(6)	Trading Partner Code
11	SYS_EDI_STATUS_CODE	varchar(1)	EDI Status Code
12	SYS_EDI_SENDER_ID	varchar(15)	EDI Sender Identifications
13	SYS_EDI_SENDER_ID_QUAL	varchar(4)	EDI Sender ID Qualifier
14	INVOICE_DATE	datetime	Invoice Date
15	ORDER_DATE	datetime	Order Date
16	CUSTOMER_REFERENCE	varchar(25)	Customer Reference
17	SYS_CURRENCY_CODE	varchar(6)	Currency Code
18	SYS_EDI_VENDOR_NUMBER	varchar(25)
19	ORDER_NUMBER	varchar(9)	Order Number
20	SYS_EDI_PRO_NUMBER	varchar(25)
21	SYS_EDI_DEPT_NUMBER	varchar(20)
22	SYS_EDI_MDSE_TYPE_CODE	varchar(20)
23	SYS_EDI_ENTITY_ID_ST	varchar(20)
24	SYS_EDI_ENTITY_ID_QUAL_ST	varchar(2)
25	SYS_EDI_ENTITY_ID_BT	varchar(20)
26	SYS_EDI_ENTITY_ID_QUAL_BT	varchar(2)
27	SYS_EDI_TERMS_TYPE	varchar(2)	EDI Terms Type Code
28	SYS_EDI_TERMS_BASIS_DATE	varchar(2)	EDI Terms Basis Date Code
29	SYS_EDI_TERMS_DISC_PERCENT	varchar(6)	EDI Terms Discount Percent
30	SYS_EDI_TERMS_NET_DAYS	varchar(3)	EDI Terms Net Days
31	SYS_EDI_TERMS_DISC_AMOUNT	varchar(10)	EDI Terms Discount Amount
32	SYS_EDI_TERMS_DAY_OF_MONTH	varchar(2)	EDI Terms Day of Month
33	CODE_DESCRIPTION	varchar(30)	Code Description
34	PROMISED_DATE	datetime	Promised Date
35	REQUIRED_DATE	datetime	Required Date
36	SHIPPING_TERMS_CODE	varchar(8)	Shipping Terms Code
37	DESPATCH_DATE	datetime	Ship Date
38	INVOICE_ADDRESS_CODE	varchar(10)	Invoice Address Code
39	DELIVERY_ADDRESS_CODE	varchar(10)	Delivery Address Code
40	CREDIT_TERMS_CODE	varchar(6)	Credit Terms Code
41	WEIGHT	numeric(20,4)	Weight of Product
42	WEIGHT_UOM	varchar(4)	Weight Unit of Measure
43	VOLUME	numeric(20,4)	Total Volume (cubic size)
44	VOLUME_UOM	varchar(4)	Volume Unit of Measure
45	SYSTEM_DATE	datetime	System Date Transaction Made
46	USERNAME	varchar(20)	Username
47	SOP_INVOICE_TOTAL_CURRENCY	numeric(20,2)	Total Invoice Line Value in Currency
48	SOP_INVOICE_TOTAL_BASE	numeric(20,2)	Total Invoice Value in Base Currency
49	DESPATCH_NOTE	int	Shipping Note
50	TOTAL_INVOICE_VALUE	numeric(20,2)
51	EDI_UNIT_OF_MEASURE	varchar(2)
52	INVOICE_NUMBER	int	Invoice Number
53	INVOICE_QUANTITY	numeric(20,6)	Invoice Quantity
54	CASH_DISCOUNT	numeric(20,2)	Cash Discount Taken
55	LINE_VALUE_DISCOUNTED	numeric(20,2)	Line Value (after order discount)
56	SYS_EDI_STANDARD	varchar(1)
57	SYS_EDI_VERSION	varchar(6)
58	SYS_EDI_TRANSACTION_SET	varchar(6)
59	SYS_EDI_TEST_FLAG	varchar(1)	EDI Test/Production Flag
60	SYS_ADDRESS_1_EDI_ST	varchar(30)
61	SYS_ADDRESS_2_EDI_ST	varchar(30)
62	SYS_CITY_EDI_ST	varchar(25)
63	SYS_COUNTRY_EDI_ST	varchar(6)
64	SYS_STATE_EDI_ST	varchar(6)
65	SYS_PROVINCE_EDI_ST	varchar(6)
66	SYS_POSTAL_CODE_EDI_ST	varchar(12)
67	SYS_ADDRESS_1_EDI_BT	varchar(30)
68	SYS_ADDRESS_2_EDI_BT	varchar(30)
69	SYS_CITY_EDI_BT	varchar(25)
70	SYS_COUNTRY_EDI_BT	varchar(6)
71	SYS_STATE_EDI_BT	varchar(6)
72	SYS_PROVINCE_EDI_BT	varchar(6)
73	SYS_POSTAL_CODE_EDI_BT	varchar(12)
74	IS_EDI_TERMS_DISC_DUE_DATE	datetime
75	SYS_EDI_TERMS_DISC_DAYS_DUE	varchar(3)	EDI Terms_discount Days Due
76	SYS_EDI_DELIVERY_ADDR_NAME	varchar(30)
77	DISCOUNT_DATE	datetime	Cash Discount Date
78	CUSTOMER_GROUP	varchar(8)	Customer Sales Analysis Group
79	SOP_PRINT_CONF_FLAG	varchar(1)	Print Order Acknowledgement
80	AR_DRAFT_PAYMENT_TYPE	varchar(3)
81	STATEMENT_ACCOUNT	varchar(8)	Payment Customer Number
82	SYS_CURRENCY_2_RATE	numeric(20,12)	Second Base Currency Rate
83	SYS_CURRENCY_2_RATIO_INDIC	varchar(1)	Ratio Indicator for Second Base
84	TRANSACTION_CURRENCY_DECIMALS	smallint
85	TP_PROMOTIONS_IN_USE	varchar(1)	Promotions in Use
86	DUE_DATE	datetime	Due Date
87	DISCOUNT_RECEIVED	numeric(10,2)	Discount Usually Received-Percentage
88	DAYS_ALLOWED	smallint	Days Allowed for Discount
89	VAL_EDI_TERMS_DISC_BASIS	numeric(20,2)
90	VAL_EDI_NET_INVOICE_AMOUNT	numeric(20,2)
91	VAL_EDI_LOT_RANGE	varchar(250)
92	MP_SHIPPING_CUSTOMER	varchar(8)	Shipping Customer
93	SOP_SHIPPING_TERMS_CODE	varchar(8)
94	SYS_ADDRESS_3_EDI_BT	varchar(40)
95	NET_WEIGHT	numeric(20,4)
96	BROKER_CODE	varchar(10)	Broker Code
97	SALES_ORDER_TYPE	varchar(6)	Sales Order Type
98	EDI_LOGFILE_NAME	varchar(60)
99	CORP_OFFICE_NAME	varchar(30)	Office Name
100	SYS_ADDRESS_1	varchar(40)	Address Line 1
101	SYS_ADDRESS_2	varchar(40)	Address Line 2
102	SYS_CITY	varchar(25)	City
103	SYS_STATE	varchar(6)	State Code
104	SYS_POSTAL_CODE	varchar(12)	Postal Code
105	SYS_EDI_ENTITY_ID	varchar(20)	EDI Entity ID
106	EDI_VENDOR_NUMBER	varchar(25)
107	FREIGHT	numeric(20,2)	Freight Value
108	TRANSPORT_METHOD	varchar(6)
109	IS_EDI_SCAC_CODE	varchar(4)
110	IS_EDI_SCAC_CODE_DESCRIPTION	varchar(30)
111	FUEL_SURCHARGE	numeric(10,2)
112	PICKUP_ALLOWANCE	numeric(10,2)
113	ITRADE_ORDER_NUMBER	varchar(30)
114	TOTAL_LINES	int
115	TOTAL_TAX	numeric(20,2)	Total Tax This Period