trading_partner_submission
Filename, submit time, and other information about data submitted via EDI, CSV or some other format
Primary Key:Foreign Keys:trading_partner_id=>trading_partner.trading_partner_id
trading_partner_submission_trading_partner_id_idx-trading_partner_idtrading_partner_submission_uq(Unique) -trading_partner_id,file_name
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
trading_partner_submission_id | bigint | No | Yes | - |
trading_partner_id | bigint | No | Yes | - |
reference_number | text | No | No | A unique reference number sent by the trading partner in the filename |
submit_time | timestamp without time zone | No | No | Time file was submitted by trading partner. Date is parsed from filename |
receive_time | timestamp without time zone | No | No | Time that the submission was received by the system |
file_name | text | No | Yes | The name of the file that was submitted. Filenames for each trading partner must be unique |