Field Mappings
Search Filters
| Filter | Record | Mapping |
|---|---|---|
| Placement Date |
1001/2001 or Notes Records (14xx, 24xx) |
Earliest of 1001/2001 Date_Forwarded or first note date (14xx, 24xx) |
| Suit Date |
Notes Records (14xx, 24xx) |
Date of most recent note with suit filed pcode/vxcode |
| Judgment Date - Judgments Report | 2201 | jdg_date |
| Judgment Date - Advanced Search |
Notes Records (14xx, 24xx) |
Date of most recent note with judgment pcode/vxcode |
| Post Judgment Date |
Notes Records (14xx, 24xx) |
Date of most recent note with post-judgment pcode/vxcode |
| Receiver Id / Sender Id | 1001/2001 | forwarder_id / agent_id |
| Latest Status |
Notes Records (14xx, 24xx) |
Waterfall of the following key events based on the existence of pcodes/vxcodes (CL -> PJ -> JG -> SV -> SF -> SNR -> DC -> DS -> ACK -> NACK) Finds accounts currently in this status. |
| vExchange Code |
Notes Records (14xx, 24xx) |
code |
| Consumer Name | 1101/2101 | First_name, last_name |
| States | 1101/2101 | state |
| Key Events | N/A | Finds accounts that have ever been in the selected status(es). For example, if an account went from NACK to ACK to CL, it would appear in the results if any of those statuses were selected. |
| Archive Toggle | N/A | By client request |
| Portfolio ID | 1001/2001 | Value sent in portfolio_id field. Typically used to associate accounts with an internal portfolio identifier. |
| Creditor ID | 1001/2001 | Value sent in cred_name field. Typically used to associate accounts with an internal portfolio identifier. |
Visibility of Sender Id, Receiver Id, and Portfolio Id depend on the Data Aggregation dropdown selection: Default or Portfolio
| Filter Fields | Field Type |
|---|---|
| Sender Id |
Text (visible in Default view but not Portfolio view) |
| Receiver Id |
Text (visible in Default view but not Portfolio view) |
| Portfolio Id |
Text (visible in Portfolio view but not Default view) |
| Year | Number |
| State | Text |
| Total Count | Number |
| Total Value | Number (currency) |
| Not Acknowledged Count | Number |
| Acknowledged Count | Number |
| Demand Letter Sent Count | Number |
| Debtor Contacted Count | Number |
| Suit Not Recommended Count | Number |
| Suit Filed Count | Number |
| Suit Served Count | Number |
| Judgment Count | Number |
| Post Judgment Count | Number |
| Closed Count | Number |
| Law Firm | Yes / No |
| Agency | Yes / No |
Export Files
| Export File | Record | Field Name |
|---|---|---|
| Agent Fileno | 2001 | sender_int_file |
| Archive Status | All Note Records(14xx/24xx) with valid archive code | Account is considered archived after receiving a valid close code in a Note record |
| Charge Off Amount | 2002 | charge_off_amt |
| Charge Off Date | 2002 | charge_off_date |
| Claim Type | 1101/2101 | claim_type |
| Closed Date | Most recent note with Closed Date pcode/vxcode | date_closed |
| Closing Code | Most recent note with Closing Code pcode/vxcode - code column | closed_code |
| Creditor Fileno | 2001 | cred_fileno |
| Creditor Name | 2002 | name |
| Current Balance | 2341 | net_claim_bal OR, if that is NULL, tot_prin_amount |
| Date Acknowledged | first_ack (first key event from all notes records) | date_acknowledged |
| Date Forwarded | 2001 | date_forwarded |
| Debtor City | 1101/2101 | city |
| Debtor Contacted Date | Most recent note with Debtor Contacted Date pcode/vxcode | date_debtor_contacted |
| Debtor First Name | 1101/2101 | First_name |
| Debtor Last Name | 1101/2101 | Last_name |
| Debtor Postal Code | 1101/2101 | postal_code |
| Debtor State | 1101/2101 | state |
| Debtor Street | 1101/2101 | street |
| Debtor Street2 | 1101/2101 | street2 |
| Debtor ZIP Code | 1101/2101 | debtor_zip |
| Demand Sent Date | Most recent note with Demand Sent Date pcode/vxcode | date_demand_sent |
| First Payment Amount | first payment gross_pmt_amt from 2303 | first_payment_amount |
| First Payment Amt | 2302/2303/2304 | gross_pmt from first payment |
| First Payment Date | 2302/2303/2304 | posting_date from first payment |
| Judgment Date | 1201/2201 or Most recent note with judgment filed pcode/vxcode | jdg_date |
| Post Judgment Date | Note Records(14xx/24xx) | Date of most recent note with post-judgment pcode/vxcode |
| Last Event | most recent key event note from all notes records | claim_last_event_code |
| Last Payment Amount | 1001/2001/2303 |
gross_pmt_amt from the most recent 2303. If there is no 2303, amount_last_pmt from 1001 or 2001 if amount_last_pmt is not NULL or negative. |
| Last Payment Date | 1001/2001/2303 |
fnds_release_dt from the most recent 2303. If there is no 2303, date_last_pmt from 1001 or 2001 if amount_last_pmt is not NULL or negative. |
| Last Reopen Date | Most recent note with Reopen pcode/vxcode | date_reopened |
| Original Claim Amount | 2001 | orig_prin |
| Original Creditor Name | 2002 | orig_cred_name |
| Original Interest | 2001 | orig_int |
| Original Principal Amount | 1001/2001 | orig_prin |
| Placement Balance | 1001/2001 | If there is a 1001, use 1001.orig_tot if it’s not 0, otherwise use orig_prin+orig_int+orig_otherIf there is no 1001, apply the same logic to the 2001 record. |
| Placement Date | 1001/2001 |
date_forwarded (If date_forwarded is empty, use date_est) |
| Portfolio ID | 2001 | portfolio_id |
| Post Judgment Date | All Note Records(14xx/24xx) | The Record Date of the most recent Note with a PJ event associated with it. |
| Receiver Id | 1001/2001 | agent_id |
| Receiver Name | VT Internal Records (Analytics or vPortal) | name |
| Sender Fileno | 1001/2001 | sender_int_file |
| Sender Id | 1001/2001 | forwarder_id |
| Sender Name | VT Internal Records (Analytics or vPortal) | name |
| Status | 2201 for suit and judgment statuses 1xxx/2xxx Note records (x401, x401, x405, x407, x410) |
The status is the first milestone in the list below that corresponds to a vExchange code in a x401, x402, x405, x407, or x410 record. (The codes are listed in reverse chronological order for the normal suit process, from finish to start): CL (closed - but not if it's been re-opened after it was closed.) If it has been re-opened after being closed, the status is one of the items from the list below. • PJ (post judgment) • JG (judgment) • SV (served) • SF (suit filed) • SNR (suit not recommended) • DC (consumer contacted) • DS (demand sent) • ACK (acknowledged) If none of the above status codes are present: • NACK (not acknowledged) Please see the latest vExchange documentation for a mapping of vExchange codes to key events. |
| Suit Date | 1201/2201 or most recent note with suit filed pcode/vxcode | suit_date |
| Suit Not Recommended Date | Most recent note with Suit Not Recommended Date pcode/vxcode | date_suit_not_recommended |
| Summons Served Date | Most recent note with Summons Served Date pcode/vxcode | date_summons_served |
| Last Archived Date | 1405 or Analytics | The most recent date that the account was archived, either via a Sender 1405 or the Analytics website. |
Exported fields vary based on the selected record type. For example, selecting 1001 or 2001 records will export placement fields while selecting a 2405 will export note fields. Please refer to vExchange documentation on specific record layouts.
| Field | Record | Field Name |
|---|---|---|
| Agent Fileno | 2001 | sender_int_file |
| Category |
The type of Gate rule that failed: Affidavit, Compliance, Financial, or Operational. |
|
| Comment | 14xx/24xx Note Records | comment |
| Court Cost | Recoverable costs awarded by the Court as of Effective_Date. | |
| Creditor Fileno | 2001 | cred_fileno |
| Customer Firstname | 1101 | first_name |
| Customer Lastname | 1101 | last_name |
| Description | Reason for the Rejection or Exception. | |
| DP Ref # | 2303/2304 |
Direct Payment reference number from the dp_ref_no field of 2303 and 2304 records. |
| First Rejection Date | Date the record first rejected. | |
| Gate Type | Universal or Custom | |
| Payment Amount | Payment amount showing in Financials reports. | |
| Placement Date | 1001/2001 |
Date the account was placed with the Receiver. The date_forwarded field. |
| Portfolio Id | 2001 | portfolio_id |
| Receiver Id | 1001/2001 | agent_id |
| Receiver Name |
VT Internal Records (Analytics or vPortal) |
name |
| Record | vExchange record number | |
| Record Date | Date the record was created | |
| Ref # | 2303/2304 |
Remittance reference number from the ref_number field of 2303 and 2304 records. |
| Remediation Date | Date the record was remediated. | |
| Remediation Status | Remediated, Sender Bulk Remediated, Remediated False Positive, and Sender Manual Remediation | |
| Remediation Type |
Auto: the rejection will automatically clear the following day without action by the firm. Alerts firms to potential problems. Manual: Only the Sender can mark the rejection as remediated. Usually happens after Sender and Receiver discuss and agree the issue is resolved. System: The firm must send updated data to resolve the issue. See the Gate Logic Report for details on how to resolve different rejections. |
|
| Rule |
The Rule ID number of the Gate rule that failed. See the Gate Logic Report for details on how to fix the problem. |
|
| Rule Message | Text to help explain the cause of the rejection. | |
| Sender Fileno | 1001/2001 | sender_int_file |
| Sender Id | 1001/2001 | forwarder_id |
| Sender Name |
VT Internal Records (Analytics or vPortal) |
name |
| State | 1101 | state |
| Status |
2201 - Suit & Judgment statuses 1xxx/2xxx - Note Records (x401, x402, x405, x 407, x410) |
The status is the first milestone in the list below that corresponds to a vExchange code in a x401, x402, x405, x407, or x410 record. |
| Not Acknowledged | ||
| Acknowledged | ||
| Demand Letter Sent | ||
| Consumer Contacted | ||
| Suit Not Recommended | ||
| Suit Filed | ||
| Suit Served | ||
| Judgment | ||
| Post Judgment | ||
| Trans Ref No | 2303/2304 | The unique ID/reference number for a financial transaction.The trans_ref_no field. |
| Type | Rejection or Exception | |
| vX Code | 1xxx/2xxx Note Records | code |
Account Details
| Top Section | Record | Field Name |
|---|---|---|
| Sender Fileno | 1001/2001 | sender_int_file |
| Creditor Fileno | 1001/2001 | cred_fileno |
| Agent Fileno | 1001/2001 | agent_fileno |
| Sender Id | 1001/2001 | forwarder_id |
| Receiver Id | 1001/2001 | agent_id |
| Claim Type | 1001/2001 | claim_type |
| Placed Date | 1001/2001 |
date_forwarded (If date_forwarded is empty, use date_est) |
| Placement Balance | 1001/2001 |
If there is a 1001, use 1001.orig_tot if it’s not 0; otherwise use orig_prin+orig_int+orig_other. If there is no 1001, apply the same logic to the 2001 record. |
| Current Balance | 1001/2001/2341 |
tot_prin_amt or net_claim_bal from the most recent 2341. If there is no 2341, show the Placement Balance. |
| Last Payment Date | 1001/2001/2303 |
fnds_release_dt from the most recent 2303. If there is no 2303, date_last_pmt from 1001 or 2001 if amount_last_pmt is not NULL or negative. |
| Last Payment Amount | 1001/2001/2303 |
gross_pmt_amt from the most recent 2303. If there is no 2303, amount_last_pmt from 1001 or 2001 if amount_last_pmt is not NULL or negative. |
| Status |
2201 for suit and judgment statuses 1xxx/2xxx Note records (x401, x401, x405, x407, or x410) |
The status is the first milestone in the list below that corresponds to a vExchange code in a x401, x402, x405 x407, or x410 record. The codes are listed in reverse chronological order for the normal suit process, from finish to start. • CL (closed - but not if its been re-opened after it was closed). If it has been re-opened after being closed, the re-opened date will be displayed and the status is from the list below: • PJ (post judgment) • JG (judgment) • SV (served) • SF (suit filed) • SNR (suit not recommended) • DC (consumer contacted) • DS (demand sent) • ACK (acknowledged) If none of the above status codes are present: • NACK (not acknowledged) Please see the latest vExchange documentation for a mapping of vExchange codes to key events. |
____________________________________________________________________________
DEBTORS PANEL
| All Phone Numbers | Record | Field Name |
| Phone Source | 1102/2102 | phone_source |
| Phone Number | 1102/2102 | phone_number |
| Phone Index | 1102/2102 | phone_index |
| Phone Priority | 1102/2102 | phone_priority |
| Phone Type | 1102/2102 | phone_type |
| Bank Info | Record | Field Name |
| Bank | 1115/2115 | name |
| Postal Code | 1115/2115 | postal_code |
| State | 1115/2115 | state |
| City | 1115/2115 | city |
| Street | 1115/2115 | street |
| Employer Info | Record | Field Name |
| Employer | 1110/2110 | name |
| Postal Code | 1110/2110 | postal_code |
| State | 1110/2110 | state |
| City | 1110/2110 | city |
| Street | 1110/2110 | street |
| Employee Info | Record | Field Name |
| Employee Name | 1111/2111 | name |
| Position | 1111/2111 | position |
| Tenure | 1111/2111 | tenure |
| Verified Date | 1111/2111 | verified_date |
____________________________________________________________________________
NOTES PANEL
| Notes Panel | Record | Field Name |
| Transmission Date | 1xxx/2xxx
Note record |
date_est |
| Note Date | 1xxx/2xxx
Note record |
date |
| Comment | 1xxx/2xxx
Note record |
comment or description |
| Code | 1xxx/2xxx
Note record |
code |
| Firm | 1xxx/2xxx
Note record |
“Forwarder or “Receiver” based on which party sent the Note |
| Record Status | – | Indicates whether this record failed a Gate, including whether it was received while the account was archived. |
____________________________________________________________________________
CALLS PANEL
| Calls Panel | Record | Field Name |
| Direction | 2401 | direction |
| Phone Number | 2401 | phone_number |
| Consumer Number | 2401 | cnsmr_number |
| Contact Name | 2401 | contact_name |
| Contact Type | 2401 | contact_type |
| Date | 2401 | date |
| Time | 2401 | start_time |
____________________________________________________________________________
LEGAL PANEL
| Arbitration Info Panel | Record | Field Name |
| Transmission Date | 1206/2206 | date_est |
| Consumer | 1206/2206 | cnsmr_number |
| Arbitration Firm | 1206/2206 | company |
| Hearing Date | 1206/2206 | hearing_date |
| Arbitrator | 1206/2206 | first_name |
| 1206/2206 | last_name | |
| Hearing Location | 1206/2206 | hearing_state |
| Case Number | 1206/2206 | case_number |
| Filing Date | 1206/2206 | filed_date |
| Award Date | 1206/2206 | award_date |
| Total Award | 1206/2206 | award_amount |
| Principal Award | 1206/2206 | award_principal |
| Record Date | 1206/2206 | date_upd |
| Attorney & Filing Info Panel | Record | Field Name |
| Transmission Date | 1209/2209 | date_est |
| Consumer | 1209/2209 | cnsmr_number |
| Attorney ID | 1209/2209 | court_atty_id |
| Firm Name | 1209/2209 | firm_name |
| Firm Address | 1209/2209 | firm_street |
| Firm Address2 | 1209/2209 | firm_street2 |
| Firm City, State, Zip | 1209/2209 | firm_city |
| 1209/2209 | firm_state | |
| 1209/2209 | firm_pcd | |
| Firm Phone Number | 1209/2209 | firm_phone |
| Motion Description | 1209/2209 | motion_desc |
| Motion Date | 1209/2209 | motion_date |
| Affidavit From | 1209/2209 | first_name |
| 1209/2209 | middle_name | |
| 1209/2209 | last_name | |
| Affidavit Fee | 1209/2209 | fee |
| Record Date | 1209/2209 | date_upd |
| Court Info Panel | Record | Field Name |
| Transmission Date | 1209/2209 | date_est |
| Consumer | 1209/2209 | cnsmr_number |
| Court ID Number | 1209/2209 | court_id_number |
| Address | 1209/2209 | court_street |
| Address2 | 1209/2209 | court_street2 |
| City, State, Zip | 1209/2209 | court_city |
| 1209/2209 | court_state | |
| 1209/2209 | court_pcd | |
| County | 1209/2209 | court_county |
| Country | 1209/2209 | court_country |
| Phone number | 1209/2209 | court_phone_no |
| Judge’s Name | 1209/2209 | jdg_first_name |
| 1209/2209 | jdg_middle_name | |
| 1209/2209 | jdg_last_name | |
| Record Date | 1209/2209 | date_upd |
| Debtor Attorney Panel | Record | Field Name |
| Transmission Date | 1120/2120 | date_est |
| Consumer | 1120/2120 | cnsmr_number |
| Attorney’s Name | 1120/2120 | name |
| Attorney’s Firm | 1120/2120 | firm_name |
| Attorney’s Address | 1120/2120 | street |
| 1120/2120 | city | |
| 1120/2120 | state | |
| 1120/2120 | postal_code | |
| Fax | 1120/2120 | fax_number |
| Phone | 1120/2120 | phone_number |
| Record Date | 1120/2120 | date_upd |
| Forwarded Account Info Panel | Record | Field Name |
| Transmission Date | 2299 | date_est |
| Agent Id | 2299 | id |
| Name & Address | 2299 | firm_name |
| 2299 | firm_name2 | |
| 2299 | postal_code | |
| 2299 | state | |
| 2299 | country | |
| 2299 | city | |
| 2299 | street | |
| 2299 | street2 | |
| Contact Name | 2299 | name |
| Phones | 2299 | phone_number |
| Fax | 2299 | fax_number |
| File Number | 2299 | agent_fileno |
| Date Placed | 2299 | placed_date |
| Date Forwarded | 2299 | placed_date |
| Record Date | 2299 | date_upd |
| Judgement Panel | Record | Field Name |
| Transmission Date | 1201/2201 | date_est |
| Consumer | 1201/2201 | cnsmr_number |
| Judgment recorded date | 1201/2201 | jdg_recorded_dt |
| Judgment date | 1201/2201 | jdg_date |
| Judgment amount | 1201/2201 | jdg_amount |
| Judgment number | 1201/2201 | jdg_number |
| Pre-judgment interest | 1201/2201 | pre_jdg_int |
| Judgment cost | 1201/2201 | jdg_cost |
| Judgment principal | 1201/2201 | jdg_prin |
| Judgment balance | 1201/2201 | jdg_bal |
| Judgment adjustment | 1201/2201 | jdg_adjust |
| Interest flag | 1201/2201 | int_flag |
| Statutory atty fee flag | 1201/2201 | stat_flag |
| Judgment expiration date | 1201/2201 | jdg_expires_dt |
| Judgment Granted | 1201/2201 | jdg_granted |
| Judgment Granted For | 1201/2201 | jdg_granted_for |
| Rate pre-judgment | 1201/2201 | pre_jdg_rate |
| Rate post-judgment | 1201/2201 | jdg_int_rate |
| Record Date | 1201/2201 | date_upd |
| Liens Info Panel | Record | Field Name |
| Transmission Date | 1125/2125 | date_est |
| Consumer | 1125/2125 | cnsmr_number |
| Lien Date | 1125/2125 | lien_date |
| Record Date | 1125/2125 | date_upd |
| Plaintiff Defendant Info Panel | Record | Field Name |
| Transmission Date | 1202/2202 | date_est |
| Consumer | 1202/2202 | cnsmr_number |
| Plaintiffs | 1202/2202 | plaintiff |
| 1202/2202 | plaintiff2 | |
| 1202/2202 | plaintiff3 | |
| 1202/2202 | plaintiff4 | |
| 1202/2202 | plaintiff5 | |
| 1202/2202 | plaintiff6 | |
| 1202/2202 | plaintiff7 | |
| Defendants | 1202/2202 | def |
| 1202/2202 | def2 | |
| 1202/2202 | def3 | |
| 1202/2202 | def4 | |
| 1202/2202 | def5 | |
| 1202/2202 | def6 | |
| 1202/2202 | def7 | |
| 1202/2202 | def8 | |
| 1202/2202 | def9 | |
| Record Date | 1202/2202 | date_upd |
| Service Info Panel | Record | Field Name |
| Transmission Date | 1203/2203 | date_est |
| Consumer | 1203/2203 | cnsmr_number |
| Service Date | 1203/2203 | date |
| Service Type | 1203/2203 | type |
| BOP Comment | 1203/2203 | bop_comment |
| Record Date | 1203/2203 | date_upd |
| SOL – New SOL Info Panel | Record | Field Name |
| Transmission Date | 2001 | sol_end_date |
| SOL Date | 2001 | sol_end_date |
| SOL – Placed SOL Info Panel | Record | Field Name |
| Transmission Date | 1001 | sol_end_date |
| SOL Date | 1001 | sol_end_date |
| Suit Dates Info Panel | Record | Field Name |
| Transmission Date | 1210/2210 | date_est |
| Consumer | 1210/2210 | cnsmr_number |
| Answer Due Date | 1210/2210 | answer_due_dt |
| Answer Field Date | 1210/2210 | answer_filed_dt |
| Default Requested Date | 1210/2210 | default_date |
| Hearing Date | 1210/2210 | hearing_date |
| Trial Date | 1210/2210 | trial_date |
| Garn Date | 1210/2210 | tax_garn_award |
| Record Date | 1210/2210 | date_upd |
| Suit Info Panel | Record | Field Name |
| Transmission Date | 1201/2201 | date_est |
| Consumer | 1201/2201 | cnsmr_number |
| Suit issued date | 1201/2201 | suit_issued_dt |
| Suit date | 1201/2201 | suit_date |
| Suit amount | 1201/2201 | suit_amount |
| Docket number | 1201/2201 | docket_number |
| Contract fee | 1201/2201 | suit_cntrct_fee |
| Statutory attorney fee | 1201/2201 | stat_fee |
| Suit reason | 1201/2201 | suit_reason |
| Court name | 1201/2201 | court_name |
| Court designation | 1201/2201 | court_designate |
| Court type | 1201/2201 | court_type |
| Country | 1201/2201 | sheriff_country |
| State | 1201/2201 | legal_state |
| County | 1201/2201 | legal_county |
| Record Date | 1201/2201 | date_upd |
____________________________________________________________________________
FINANCIAL PANEL
| Promise to Pay | Record | Field Name |
| Transmission Date | 1403/2403 | date_est |
| Plan Date | 1403/2403 | trans_date |
| Account Balance | 1403/2403 | bal_due |
| First Date | 1403/2403 | sched_start_dt |
| First Amount | 1403/2403 | first_amount |
| Last Date | 1403/2403 | sched_end_dt |
| Last Amount | 1403/2403 | last_amount |
| Payment Amount | 1403/2403 | regular_amount |
| # of Payments | 1403/2403 | tot_number |
| Frequency | 1403/2403 | frequency |
| Status | 1403/2403 | sched_status
|
| Consumer | 1403/2403 | cnsmr_number |
| Record Date | 1403/2403 | date_upd |
| Record | 1403/2403 | 2403 |
| Stipulation | Record | Field Name |
| Date Stip Forw to Debtor | 1201/2201 | stip_mailed_dt |
| Date Stip Rec from Debtor | 1201/2201 | stip_rcvd_dt |
| Date Stip Filed with Court | 1201/2201 | stip_filed_dt |
| Total Amount Agreed to in Stip | 1201/2201 | stip_tot_amt |
| Direct Payments | Record | Field Name |
| Date | 1301 | date |
| DP Reference # | 1301 | ref_number |
| Description | 1301 | comment |
| Amt Paid | 1301 | cash |
| Merchandise Amt | 1301 | merch_ret |
| Amt Paid/No Fee Due | 1301 | no_fee |
| Entity Paid | 1301 | entity_paid |
| Posted | Record | Field Name |
| Remit # | 2302 | ref_number |
| Trans # | 2302 | trans_ref_no |
| DP Reference # | 2302 | dp_ref_no |
| Ret Code | 2302 | agnt_int_fin_cd |
| Pay Date | 2302 | fnds_release_dt |
| Post Date | 2302 | posting_date |
| Remit Date | 2302 | date |
| Gross Pay | 2302 | gross_pmt_amt |
| Fees | 2302 | ttl_fee_earned |
| Cost Ret. | 2302 | cost_returned |
| Cost Exp. | 2302 | ta_cost_disb |
| Balance Adjustment | 2302 | ta_adjustment |
| Description | 2302 | desciption |
| Record Status | – | Indicates whether this record failed a Gate, including whether it was received while the account was archived. |
| Historical Remittance | Record | Field Name |
| Remit # | 2303 | ref_number |
| Trans # | 2303 | trans_ref_no |
| DP Reference # | 2303 | dp_ref_no |
| Ret Code | 2303 | agnt_int_fin_cd |
| Pay Date | 2303 | fnds_release_dt |
| Post Date | 2303 | posting_date |
| Remit Date | 2303 | date |
| Gross Pay | 2303 | gross_pmt_amt |
| Fees | 2303 | ttl_fee_earned |
| Cost Ret. | 2303 | cost_returned |
| Cost Exp. | 2303 | ta_cost_disb |
| Balance Adjustment | 2303 | ta_adjustment |
| Description | 2303 | desciption |
| Record Status | – | Indicates whether this record failed a Gate, including whether it was received while the account was archived. |
| Live Remittance | Record | Field Name |
| Remit # | 2304 | ref_number |
| Trans # | 2304 | trans_ref_no |
| DP Reference # | 2304 | dp_ref_no |
| Ret Code | 2304 | agnt_int_fin_cd |
| Pay Date | 2304 | fnds_release_dt |
| Post Date | 2304 | posting_date |
| Remit Date | 2304 | date |
| Gross Pay | 2304 | gross_pmt_amt |
| Fees | 2304 | ttl_fee_earned |
| Cost Ret. | 2304 | cost_returned |
| Cost Exp. | 2304 | ta_cost_disb |
| Balance Adjustment | 2304 | ta_adjustment |
| Description | 2304 | desciption |
| Record Status | – | Indicates whether this record failed a Gate, including whether it was received while the account was archived. |
| Balance Update | Record | Field Name |
| Transmission Date | 2341 | date_est |
| Total Balance | 2341 | tot_bal_due |
| Record Date | 2341 | date_est |
____________________________________________________________________________
DISPUTES PANEL
| Disputes | Record | Field Name |
| Sender File # | 1411/2411 | sender_int_file |
| Creditor File # | 1411/2411 | cred_fileno |
| Agent Id | 1411/2411 | agent_id |
| Case Number | 1411/2411 | reference_no |
| Comment | 1411/2411 | comment |
| Resolved Date | 1411/2411 | returned_date |
____________________________________________________________________________
ACCOUNT NUMBERS PANEL
Accounts with matching “comp_fileno” fields
| Account Numbers | Record | Field Name |
| Other File # | 1070/2070 | account_number |
| Description | 1070/2070 | account_id |
| Linked Accounts | Record | Field Name |
| Sender File # | 1001/2001 | sender_int_file |
| Creditor File # | 1001/2001 | cred_fileno |
| Agent File # | 1001/2001 | agent_id |
