A_SOP_EDI_INBOUND_RJT_HEADER

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

Archived SOP EDI Inbound Rejection Header

tableFINSOP

A_SOP_EDI_INBOUND_RJT_HEADER — Archived SOP EDI Inbound Rejection Header. FIN table in the standard Ross ERP 8.0 schema: 51 columns, used by 3 programs. Columns, data types, keys, foreign keys and relationships.

Open A_SOP_EDI_INBOUND_RJT_HEADER in the interactive Data Dictionary →

Part of SOP 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	ARCHIVE_ID	varchar(1)	Prefix Fields for Archive Tables
3	COMPANY_CODE	varchar(10)	Company Code
4	DIVISION	varchar(2)	Division
5	SYS_DOCUMENT_ID	varchar(20)	EDI Document ID
6	SYS_DOCUMENT_STATUS_CODE	varchar(1)	EDI Document Status Code
7	SYS_EDI_SENDER_ID	varchar(15)	EDI Sender Identifications
8	SYS_EDI_INTERCHANGE_CTRL_NBR	varchar(9)	Interchange Control Number
9	SYS_EDI_SENDER_TEST_FLAG	varchar(1)	EDI Sender Test Flag
10	SYS_EDI_GROUP_CTRL_NBR	varchar(9)	EDI Group Control Number
11	SYS_EDI_TRANSACTION_CTRL_NBR	varchar(9)	EDI Transaction Ctrl Nbr
12	CUSTOMER_REFERENCE	varchar(25)	Customer Reference
13	SYS_EDI_CUR_ENTITY_ID_CODE	varchar(2)	EDI Currency Entity Code
14	SYS_EDI_CURRENCY_CODE	varchar(3)	EDI Currency Code
15	SYS_EDI_CUR_EXCHANGE_RATE	varchar(6)	EDI Currency Exchange Rate
16	CUSTOMER_CONTACT	varchar(20)	Customer Contact
17	SYS_EDI_CUST_BT_ID_CODE_QUAL	varchar(2)	EDI Bill-to Code Qual
18	SYS_EDI_CUST_BT_ENTITY_ID_CODE	varchar(2)	EDI Bill-to entity ID
19	SYS_EDI_CUST_BT_ID_CODE	varchar(20)	EDI Bill-to Code
20	SYS_EDI_CUST_ST_ENTITY_ID_CODE	varchar(2)	EDI Ship-to Entity Code
21	SYS_EDI_CUST_ST_ID_CODE_QUAL	varchar(2)	EDI Ship-to Code Qual
22	SYS_EDI_CUST_ST_ID_CODE	varchar(20)	EDI Ship-to Code
23	NUMBER_OF_LINES	varchar(6)	Number of lines
24	SOP_ORDER_TOTAL_CURRENCY	numeric(20,2)	Total Order Line Value in Currency
25	SYSTEM_DATE	datetime	System Date Transaction Made
26	ORDER_NUMBER	varchar(9)	Order Number
27	CUSTOMER_NUMBER	varchar(8)	Customer Number
28	SYS_CURRENCY_CODE	varchar(6)	Currency Code
29	DELIVERY_ADDRESS_CODE	varchar(10)	Delivery Address Code
30	INVOICE_ADDRESS_CODE	varchar(10)	Invoice Address Code
31	CREDIT_TERMS_CODE	varchar(6)	Credit Terms Code
32	SYS_EDI_TERMS_TYPE	varchar(2)	EDI Terms Type Code
33	SYS_EDI_TERMS_BASIS_DATE	varchar(2)	EDI Terms Basis Date Code
34	SYS_EDI_TERMS_DISC_PERCENT	varchar(6)	EDI Terms Discount Percent
35	SYS_EDI_TERMS_DISC_DUE_DATE	varchar(6)	EDI Terms Discount Due Date
36	SYS_EDI_TERMS_DISC_DAYS_DUE	varchar(3)	EDI Terms_discount Days Due
37	SYS_EDI_TERMS_NET_DUE_DATE	varchar(6)	EDI Terms Net Due Date
38	SYS_EDI_TERMS_DISC_AMOUNT	varchar(10)	EDI Terms Discount Amount
39	SYS_EDI_DEFERRED_DUE_DATE	varchar(6)	EDI Deferred Due Date
40	SYS_EDI_DEFERRED_AMOUNT_DUE	varchar(10)	EDI Deferred Amount Due
41	SYS_EDI_PERCENT_INVOICE	varchar(5)	EDI Percent of Invoice Payable
42	SYS_EDI_TERMS_DAY_OF_MONTH	varchar(2)	EDI Terms Day of Month
43	SYS_EDI_PAYMENT_METHOD_CODE	varchar(1)	EDI Payment Method Code
44	SYS_EDI_TERMS_PERCENT	varchar(10)	EDI Terms Percent
45	SYS_EDI_TERMS_NET_DAYS	varchar(3)	EDI Terms Net Days
46	ORDER_DISCOUNT	numeric(20,2)	Order Discount
47	ORDER_DISCOUNT_PERCENT	numeric(10,2)	Order Discount Percentage
48	ARCHIVE_DATE	datetime	Archive Date
49	ARCHIVE_USERNAME	varchar(20)	Username recorded when the row was moved to the archive.
50	GEM_ARCHIVE_FLAG	varchar(20)	System flag indicating whether the row has been archived by the GEMBASE archive process.
51	SYS_EDI_ORDER_DATE	datetime	EDI Order Date