Transaction Tables

List of tables that hold transaction data for Golden EDI

Golden EDI Base Application

These table hold the transaction data during standard operations. Before going live with a system, ensure that these tables a cleared to avoid any issues.

Manual clearing in a live system is discouraged; use the GEDIDELETE job queue for routine cleanups to prevent issues like duplicate imports or incorrect statuses.

Table No.	Table Name	Description
70019001	GEDI Message Line	Contents of a message in the queue.
70019002	GEDI Message Queue	Queue for all incoming and outgoing messages.
70019011	GEDI Message Log	Log of processed messages, used by the duplication check.
70019020	GEDI Status Ledger Entry	Holds all document statuses as created by Golden EDI.
70019021	GEDI Ship Advice Header	The header for a shipment advice.
70019022	GEDI Ship Advice Log Unit Line	Logistic units connected to a shipment advice.
70019023	GEDI Ship Advice Unit Line	Items on a logistic units.
70019033	GEDI Data Set Values	Temporary stored for query values.

Golden EDI Extended Platform

It's advisable to clear them during testing phases or before system launch, while manual clearing during regular operations should be avoided. Single document deletions are permissible via the GUI, as configurations can be set to restrict deletions based on document statuses, thereby ensuring safe deletion practices.

For automated clearing configurations, contact our support team.

Table No.	Table Name	Description
70845581	GEDI Intermediate Header	Represents the header of an intermediate document.
70845582	GEDI Intermediate Line	Contains lines associated with a single header.