trading_partner_extract_x12
Configuration for extracting X12 EDI files.
Primary Key:Checks:trading_partner_extract_x12_check-(NOT (send_999_response AND send_997_response))
trading_partner_id=>trading_partner.trading_partner_id
trading_partner_extract_x12_trading_partner_id_idx-trading_partner_idtrading_partner_extract_x12_uq(Unique) -edi_receiver_id_filter,edi_receiver_qualifier_filter,edi_sender_id_filter,edi_sender_qualifier_filter,edi_sender_name_filter,edi_file_usage_indicator_filter,edi_claim_plan_id_filter,edi_claim_form_type_filter,edi_claim_bill_type_filter,folder_path_filter,filename_filter
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
trading_partner_extract_x12_id | bigint | No | Yes | Snowflake ID of the configuration for X12 data loading. |
trading_partner_id | bigint | No | Yes | Link to the associated trading partner record. |
edi_receiver_id_filter | text | No | Yes | - |
edi_receiver_qualifier_filter | text | No | Yes | - |
edi_sender_id_filter | text | No | Yes | - |
edi_sender_qualifier_filter | text | No | Yes | - |
edi_sender_name_filter | text | No | Yes | - |
edi_file_usage_indicator_filter | text | No | Yes | - |
edi_claim_plan_id_filter | text | No | Yes | - |
edi_claim_form_type_filter | text | No | Yes | - |
edi_claim_bill_type_filter | text | No | Yes | - |
folder_path_filter | text | No | Yes | - |
filename_filter | text | No | Yes | - |
file_suffix | text | No | No | - |
send_999_response | boolean | No | No | - |
send_997_response | boolean | No | No | - |
send_email_errors | boolean | No | No | - |
send_email_errors_to | text[] | Yes | No | - |