Connector-TXT 5.1 for Recepción de Pagos (Payment´s receipt) complement
File
The end of line (EOL), new line or linebreak can be any one used in common operative systems: CR, LF or CR+LF.
Field separation
The default character used to separate each field is "pipe" (|, ASCII 124), if you need another character, it needs to be specified in your implementation´s configuration. However we suggest not to choose simple characters like comma "," or semicolon ";" because this may interfere with the field's data extraction if the data contains such characters.
File structure
The first line of the file does not contain the definition of the columns. The file can have as many lines as needed and can include as many invoices as required.
The file does not need to have been previously sorted by any column, and does not require that the information representing an invoice be sequential.
The described fields are separated and extracted in that order, however the control panel allows you to reorder the sequence in which the connector obtains them in case the report is exported in a different order or even if it has extra columns (so that these are ignored).
Txt 5.1. Recepción de Pagos (Payment´s receipt) complement
Example txt 5.1. Recepción de Pagos (Payment´s receipt) complement
1019|PA|Empresa SA de CV|XEXX010101000|true|09112017 00:00:00|601||09112017 00:00:00|500|02||MXN|03|A4325219-7B19-48F9-9BE3-E40B4E281A7F|530|A|200|PPD|MXN||1|500|300|USA||BANK OF TOKYO|0951623847|EKU9003173C9|0847951632|EKU9003173C9|||||cliente@email.com|MEX|10:00:00|
1019|PA|Empresa SA de CV|XEXX010101000|true|09112017 00:00:00|601||09112017 00:00:00|300|03||MXN|03|0E206A71-C3DD-46B4-8FA8-E19BE3ED2AC6|850|A|100|PPD|MXN||1|300|200|USA||BANK OF TOKYO|0951623847|EKU9003173C9|0847951632|EKU9003173C9|||||cliente@email.com|MEX|10:00:00|
Resultado XML CFDI Con Complemento Recepción de Pagos
Data dictionary
Recepción de Pagos (Payment´s receipt) complementComplement for the Digital Tax Receipt on the Internet (CFDI) to record information on the receipt of payments. The issuer of this complement for receipt of payments must be the person required by law to issue receipts for the acts or activities they carry out, for the income they receive or for the tax withholdings they make. |
| Type | Fields | Description |
|---|---|---|
| "Complemento" fields | Mandatory id | |
| R | FOLIO | Folio number of the electronic invoice (or other CFDI). Example: 525 |
| O | SERIE | Name of the series on which the voucher must be created. Example: SJ |
| R | RAZON_SOCIAL | Business name of the recipient. Example: GENERAL PUBLIC |
| R | RFC | Receiver RFC. Example: XAXX010101000 |
| R | STATUS | Status of electronic invoice (or other CFDI) (1=Active; 0=Canceled TRUE=Active; FALSE=Canceled) |
| R | FECHA | Date of issue of the electronic invoice (or other CFDI). |
| R | REGIMEN | Tax regime key of the issuing taxpayer to whom the tax effect of this receipt will apply. |
| O | UUID_FACTURAS_RELACIONADAS | Fiscal folio (UUID) of a CFDI related to this receipt, for example: If the related CFDI is a transfer receipt used to record the movement of the merchandise. If this receipt is used as a credit note or debit note of the related receipt. If this receipt is a refund on the related receipt. If this replaces a cancelled invoice. |
| R | FECHA_PAGO | Express the date and time when the beneficiary receives the payment. It is expressed in the form yyyy-mm-ddThh:mm:ss |
| R | MONTO | Express the amount of payment. |
| C | NUM_OPERACION | State the check number, authorization number, reference number, tracking code in the case of SPEI, capture line or some similar reference number that identifies the operation that covers the payment made. |
| C | TIPO_CAMBIO_PAGO | Express the currency exchange rate on the date the payment was made. The value must reflect the number of Mexican pesos equivalent to one unit of the currency indicated in the MonedaP attribute. It is required when the MonedaP attribute is different from MXN. |
| R | MONEDA_PAGO | Identify the currency key used to make the payment. |
| R | FORMA_PAGO | Express the key for the way in which payment is made. |
| R | ID_DOCUMENTO_DR | Express the identifier of the document related to the payment. This data can be a Tax Folio of the Electronic Invoice or the transaction number of a digital document. |
| O | FOLIO_DR | Specify the receipt folio for internal control of the taxpayer. |
| O | SERIE_DR | Specify the series of the receipt for internal control of the taxpayer. |
| C | IMPORTE_PAGADO | Express the amount paid for the related document. It is mandatory when there is more than one related document or when there is a related document and the TipoCambioDR has a value. |
| R | METODO_PAGO_DR | State the payment method key that was recorded in the related document. |
| R | MONEDA_DR | The currency key used in the amounts of the related document is identified. When national currency is used or the related document does not specify the currency, MXN is recorded. The amounts recorded in the attributes "ImpSaldoAnt", "ImpPagado" and "ImpSaldoInsoluto" of this node must correspond to this currency. In accordance with the ISO 4217 specification. |
| C | TIPO_CAMBIO_DR | Express the exchange rate according to the currency recorded in the related document. Required when the currency of the related document is different from the payment currency. The number of units of the currency indicated in the related document that equal one unit of the payment currency must be recorded. For example: The related document is recorded in USD The payment is made for 100 EUR. This attribute is recorded as 1.114700 USD/EUR. The amount paid is equal to 100 EUR * 1.114700 USD/EUR = 111.47 USD. |
| C | NUM_PARCIALIDAD_DR | Enter the number of installments corresponding to the payment. It is required when MetodoDePagoDR contains: "Pago en parcialidades o diferido" or "Pago inicial y parcialidades". |
| C | IMPORTE_SALDO_ANTERIOR | Express the amount of the previous balance of the related document or the amount of the outstanding balance of the previous installment. It is required when MetodoDePagoDR contains: "Pago en parcialidades o diferido" or "Pago inicial y parcialidades" In the case that it is the first installment, this field must contain the total amount of the related document. |
| C | IMPORTE_SALDO_INSOLUTO | Express the difference between the previous balance amount and the payment amount. It is required when MetodoDePagoDR contains: "Pago en parcialidades o diferido" or "Pago inicial y parcialidades". |
| c | RESIDENCIA_FISCAL_CLIENTE | To record the country of residence key for tax purposes of the receipt recipient, when the recipient is a foreigner, and which complies with the ISO 3166-1 alpha-3 specification. It is required when including the foreign trade complement or registering the NumRegIdTrib attribute. |
| c | NUM_REG_ID_TRIB_CLIENTE | To express the recipient's tax identification number when he or she is resident abroad. It is required when including the foreign trade supplement. |
| C | NOMBRE_BANCO_ORDENANTE | State the name of the ordering bank, which is required if it is a foreign bank. Consider the mandatory rules published on the SAT website for this attribute according to the catCFDI:c_FormaPago catalog. |
| C | NO_CUENTA_ORDENANTE | Enter the account number from which the payment was made. Consider the mandatory rules published on the SAT website for this attribute according to the catalog catCFDI:c_FormaPago. |
| C | RFC_EMISOR_CUENTA_ORDENANTE | Conditional attribute to express the RFC key of the issuing entity of the source account, that is, the operator, the bank, the financial institution, the electronic wallet issuer, etc., if it is a foreigner, enter XEXX010101000, consider the mandatory rules published on the SAT page for this attribute according to the catCFDI:c_FormaPago catalog. |
| C | NO_CUENTA_BENEFICIARIO | Enter the account number where the payment was received. Consider the mandatory rules published on the SAT website for this attribute according to the catCFDI:c_FormaPago catalog. |
| C | RFC_EMISOR_CUENTA_BENEFICIARIO | Express the RFC key of the operating entity of the destination account, that is, the operator, the bank, the financial institution, the electronic wallet issuer, etc. Consider the mandatory rules published on the SAT page for this attribute according to the catCFDI:c_FormaPago catalog. |
| C | TIPO_PAGO | Identify the key for the type of payment chain generated by the entity receiving the payment. Consider the mandatory rules published on the SAT website for this attribute according to the catCFDI:c_FormaPago catalog. |
| C | CADENA_PAGO | Express the original chain of the payment voucher generated by the entity issuing the beneficiary account. It is required if the TipoCadPago attribute contains information. |
| C | CERTIFICADO_PAGO | Conditional attribute used to incorporate the certificate that supports the payment, as a text string in base 64 format. It is required if the TipoCadPago attribute contains information. |
| C | SELLO_PAGO | The digital stamp associated with the payment must be integrated. The entity issuing the payment receipt enters an original string and the digital stamp in a section of said receipt. This digital stamp is the one that must be registered in this field. It must be expressed as a text string in base 64 format. It is required if the TipoCadPago attribute contains information. |
| O | EMAIL_CLIENTE | Recipient's email address |
| LUGAR_EXPEDICION | Postal code of the place where the receipt is issued (head office or branch address). |