trading_partner_submission

Filename, submit time, and other information about data submitted via EDI, CSV or some other format

Primary Key:

• trading_partner_submission_id

Foreign Keys:

• trading_partner_id => trading_partner.trading_partner_id

Indexes:

• trading_partner_submission_trading_partner_id_idx - trading_partner_id
• trading_partner_submission_uq (Unique) - trading_partner_id, file_name

Column	Data Type	Nullable	Indexed	Description
trading_partner_submission_id	bigint	No	Yes	Snowflake ID for trading partner submission record. Generated through expression:
trading_partner_id	bigint	No	Yes	Link to the trading partner. Generated through expression:
reference_number	text	No	No	A unique reference number sent by the trading partner in the filename Generated through expression:
submit_time	timestamp without time zone	No	No	Time file was submitted by trading partner. Date is parsed from filename Generated through expression:
receive_time	timestamp without time zone	No	No	Time that the submission was received by the system Generated through expression:
file_name	text	No	Yes	The name of the file that was submitted. Filenames for each trading partner must be unique Generated through expression: