A_POP_EDI_IPI_EXCEPTIONS

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

Archived POP EDI Inbound Purchase Invoices Exceptions

tableFINPOP

A_POP_EDI_IPI_EXCEPTIONS — Archived POP EDI Inbound Purchase Invoices Exceptions. FIN table in the standard Ross ERP 8.0 schema: 22 columns, used by 3 programs. Columns, data types, keys, foreign keys and relationships.

Open A_POP_EDI_IPI_EXCEPTIONS in the interactive Data Dictionary →

Part of POP tables & objects · all tables, views & procedures

Columns

#	Column	Type	Key	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)	PK	Prefix Fields for Archive Tables
3	COMPANY_CODE	varchar(10)	PK	Company Code
4	DIVISION	varchar(2)	PK	Division
5	SYS_DOCUMENT_ID	varchar(20)	PK	EDI Document ID
6	SYS_EDI_SENDER_ID	varchar(15)	PK	EDI Sender Identifications
7	PURCHASE_INVOICE_LINE	int	PK	Invoice Line Number
8	SYS_EVENT_CODE	varchar(10)	PK	Event Code
9	SYS_EVENT_MESSAGE	varchar(60)		EDI Event Message
10	SYS_EXCEPTION_STATUS_CODE	varchar(1)		Exception Status Code
11	SYSTEM_DTIME	datetime		System Date/Time
12	USERNAME	varchar(20)		Username
13	SYS_EXCEPTION_RESOLVED_DTIME	datetime
14	SYS_EXCEPTION_RESOLVED_USERNAME	varchar(20)
15	PURCHASE_INVOICE_NUMBER	int		Purchase Invoice Number
16	SYS_RUN_CONTROL_NUMBER	varchar(8)		Run Control Number
17	VENDOR_NUMBER	varchar(12)		Supplier Number (or ID)
18	INVOICE_DATE	datetime		Invoice Date
19	SYS_EDI_UPDATE_OPTION	varchar(1)		EDI update option for event
20	ARCHIVE_DATE	datetime		Archive Date
21	ARCHIVE_USERNAME	varchar(20)		Username recorded when the row was moved to the archive.
22	GEM_ARCHIVE_FLAG	varchar(20)		System flag indicating whether the row has been archived by the GEMBASE archive process.