TIN Validation Report
The TIN Validation report contains data about Legal Entity Tax Identification Number (or EIN) validation failures. Worldpay produces the report daily for Payment Facilitators.
Filename Syntax
The syntax of the report filename is:
TaxIdStatus_${organizationId}_${targetDay}
where
-
organizationIdis the ID of the parent merchant organization -
targetDayis the date to which the data applies
Report Structure
The table below provides information about the fields included in the report. The report fields are in the order presented in the table.
A data type of Signed Decimal (17,2) with a Max Size of 21 is defined as:
17 digits + decimal point + 2 digits + sign.
|
Field Name |
Data Type |
Max Size |
Description |
|---|---|---|---|
|
Legal Entity Id |
Long |
19 |
The Worldpay generated identifier for the Legal Entity. |
|
Legal Entity Name |
Alphanumeric |
60 |
The name of the Legal Entity controlling the Sub-merchants. |
|
Submerchant Qty |
Long |
19 |
The count of Submerchants under the Legal Entity. |
|
Days Submerchant Funded |
Long |
19 |
The age of the oldest Submerchant for which funding was enabled on the platform. |
|
Background Check Status |
Alphanumeric |
8 |
The current status of the Legal Entity background check. Possible values are: APPROVED, or RETRY |
|
Tax Id Failure Reason |
Alphanumeric |
17 |
The reason for the Tax Id validation failure. Possible values are: TIN_NOT_ISSUED, or TIN_NAME_MISMATCH |
|
Tax Id |
Alphanumeric |
25 |
The submitted Tax Identification number. |