IS_OSN_HEADERS

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

tableFINIS

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

Open IS_OSN_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	SYSTEM_DATE	datetime	System Date Transaction Made
5	SYS_EDI_SENDER_ID	varchar(15)	EDI Sender Identifications
6	IS_DOC_ID	varchar(20)	Interface Server document identifier (integration message key).
7	DESPATCH_NOTE	int	Shipping Note
8	IS_MONITOR_RUN_NUMBER	varchar(10)
9	IS_STATUS	varchar(1)	Interface Server processing status of the record.
10	SYS_TRADING_PARTNER_CODE	varchar(6)	Trading Partner Code
11	WAREHOUSE	varchar(2)	Warehouse Code
12	TM_CONTAINER_NUMBER	varchar(15)	Container Number
13	VENDOR_NAME	varchar(60)	Supplier Name
14	VENDOR_NUMBER	varchar(12)	Supplier Number (or ID)
15	DESPATCH_DATE	datetime	Ship Date
16	QTY_DESPATCHED	numeric(20,6)	Quantity Shipped
17	COMPANY_NAME	varchar(40)	Company Name
18	COMPANY_ADDRESS_1	varchar(40)
19	COMPANY_ADDRESS_2	varchar(40)
20	COMPANY_CITY	varchar(25)
21	COMPANY_STATE	varchar(6)
22	COMPANY_ZIP	varchar(12)
23	WH_ADDRESS_1	varchar(40)
24	WH_ADDRESS_2	varchar(40)
25	WH_CITY	varchar(25)
26	WH_STATE	varchar(6)
27	WH_ZIP	varchar(12)
28	ORDER_NUMBER	varchar(9)	Order Number
29	CUSTOMER_NUMBER	varchar(8)	Customer Number
30	DELIVERY_ADDRESS_CODE	varchar(10)	Delivery Address Code
31	CUSTOMER_REFERENCE	varchar(25)	Customer Reference
32	ORDER_DATE	datetime	Order Date
33	CUSTOMER_ADDRESS_1	varchar(40)
34	CUSTOMER_ADDRESS_2	varchar(40)
35	CUSTOMER_CITY	varchar(25)
36	CUSTOMER_STATE	varchar(6)
37	CUSTOMER_ZIP	varchar(12)
38	CUSTOMER_COUNTRY	varchar(6)
39	IS_ACTIVATION_STATUS	varchar(1)
40	CUSTOMER_NAME	varchar(60)	Customer Name
41	SYS_EDI_STATUS_CODE	varchar(1)	EDI Status Code
42	SYS_EDI_TEST_FLAG	varchar(1)	EDI Test/Production Flag
43	VENDOR_REFERENCE	varchar(25)	Supplier Reference
44	PRO_NUMBER	varchar(15)
45	SYS_START_TIME	varchar(4)	Start Time To Restrict Monitor Processing
46	SYS_TIME_STAMP	datetime	Date/Time Stamp
47	TM_ORDER_NUMBER	varchar(9)	Transport Order Number
48	PACKAGED_UNITS	numeric(20,6)
49	WEIGHT	numeric(20,4)	Weight of Product
50	WEIGHT_UOM	varchar(4)	Weight Unit of Measure
51	VOLUME	numeric(20,4)	Total Volume (cubic size)
52	VOLUME_UOM	varchar(4)	Volume Unit of Measure
53	SYS_EDI_SENDER_ID_QUAL	varchar(4)	EDI Sender ID Qualifier
54	SYS_EDI_STANDARD	varchar(1)
55	SYS_EDI_VERSION	varchar(6)
56	SYS_EDI_TRANSACTION_SET	varchar(6)
57	IS_HIERARCHIAL_CODE_1	varchar(12)
58	IS_HIERARCHIAL_CODE_2	varchar(12)
59	CARRIER	varchar(12)	Carrier
60	CARRIER_SCAC_CODE	varchar(25)
61	CARRIER_NAME	varchar(60)	Carrier name
62	CARRIER_TRANS_TYPE	varchar(2)
63	CARRIER_ORDER_STATUS	varchar(2)
64	TM_CONTAINER_SEAL	varchar(10)	Seal Number
65	SYS_REQUESTED_DATE	datetime	Customer requested date
66	SYS_DELIVERY_DATE	datetime	Delivery Date
67	SYS_SHIPPING_DATE	datetime	Shipping Date
68	TM_FREIGHT_TRANS_TYPE	varchar(2)
69	SYS_EDI_DEPT_NUMBER	varchar(20)
70	SYS_EDI_MDSE_TYPE_CODE	varchar(20)
71	HASH_QUANTITY	numeric(20,6)
72	HASH_LINES	smallint
73	DESPATCH_NUMBER	int	Ship Run Number
74	IS_EDI_SCAC_CODE	varchar(4)
75	IS_OSN_EQUIPMENT_ID	varchar(10)
76	IS_PRO_NUMBER	varchar(30)
77	IS_SEAL_NUMBER	varchar(10)
78	IS_EDI_SHIPMENT_STATUS	varchar(2)
79	IS_EDI_TRANSPORT_TYPE	varchar(2)
80	IS_OSN_DATE	datetime
81	MASTER_BOL_NUMBER	varchar(30)
82	BOL_NUMBER	varchar(30)	Bill-Of-Lading Number
83	IS_EDI_CARRIER_SELECTED_BY	varchar(2)
84	SYS_EDI_ENTITY_ID_ST	varchar(20)
85	SYS_EDI_ENTITY_ID	varchar(20)	EDI Entity ID
86	SYS_EDI_DEFAULT_INVOICE_ADDR	varchar(10)	EDI Invoice/Shipping Address
87	DATA_CAPTURE_IN_USE	varchar(1)	Data Capture System In Use
88	FIRST_SSCC_NUMBER	varchar(30)
89	SYS_EDI_ENTITY_ID_WH	varchar(20)
90	TRANSPORT_METHOD	varchar(6)
91	DELIVERY_DATE	varchar(20)
92	SHIPPING_DATE	varchar(20)
93	REQUESTED_DATE	varchar(20)