1. Localizations for Argentina Implementation Guide
  2. Flat File for Reporting Profit Withholdings for Foreign Beneficiaries

Flat File for Reporting Profit Withholdings for Foreign Beneficiaries

You run the F2003 Profit Withholding to External Beneficiaries report (R76A4005) to generate a flat file to report profit withholdings for foreign beneficiaries.

The following table describes the fields that are included in the flat file:

Record Name

Description

Position

Form

The AFIP legal form code.

01-04

Version

The version of the AFIP legal form code.

05-08

Traceability Code

The traceability code. The system retrieves this information from the next number set up for system 76A, line 6. The system uses this field to link the JD Edwards EnterpriseOne withholding document with the certificate number generated by SIRE.

9-18

Agent Tax ID

The withholding agent's tax ID as set up in the Address Book Master.

19-29

Tax

The legal tax code for the withholdings.

30-32

Concept

The AFIP legal concept code. The system retrieves this value from the ARG-Profit Legal Concept UDC table (76/L3).

33-35

Payer Tax ID

The name, address, and fiscal ID (CUIT) of the payer.

36-46

Withholding Date

The date that the tax was withheld. This value is retrieved from the Invoice Date field in the Accounts Payable Ledger table (F0411).

47-56

Document Type

The legal document type for the withholdings. The system retrieves this value from the Legal Document Type UDC table (76A/DV).

57-58

Document Date

The document date based on the document type:

  • If the document type is Invoice (1), this is the invoice date of the voucher that originated the withholding.

  • If the document type is Credit Note (3) or Debit Note (4), this is the invoice date of the adjustments.

  • If the document type is Payment Order (6), this is the payment date.

59-68

Document Number

The document number based on the document type:

  • If the document type is Invoice (1), this is the invoice number (PV) of the voucher that originated the withholdings (format 99999-99999999) (Release 9.2 Update).

  • If the document type is Credit Note (3) or Debit Note (4), this is the invoice number of the adjustments (format 99999-99999999) (Release 9.2 Update).

  • If the document type is Payment Order (6), this is the payment order number (string format with 12 positions).

The system retrieves this value from the Payment Order Number - Argentina field (AOP) of the A/P Payment Detail Tag Table - ARG - 04 table (F760414A).

69-84

Amount

The base amount for the withholdings. The system retrieves this value from the Remark field in the Accounts Payable Matching Document Detail table (F0414).

85-98

Filler

Filler description.

99-112

Original Document Number

The original document number. This is the document number associated with the original withholdings certificate, if you enter a rectification for the withholdings.

113-137

Original Document Date

The original withholding date. This is the date associated with the original withholdings certificate, if you enter a rectification for the withholdings.

138-147

Original Amount

The original withholdings amount. This is the withholdings amount on the original withholdings certificate, if you enter a rectification.

148-161

Credit/Debit Note Reason

The reason for the credit or debit note. If you define a credit or debit note reason in the String Data tab of the Work With Supplier Ledger Additional Information form, the system displays that information. Otherwise, the system displays the value of the Credit or Debit Note processing option for the F2003 Profit Withholding to External Beneficiaries program (R76A4005). If both of these values are blank, the system generates an error.

162-191

No Withholding

The value in this field indicates whether profit withholdings exist or not. The system retrieves this value from the Additional Profit Withholding table (F76A0403).

192

No Withholding Reason

The reason for not reporting profit withholdings. The system retrieves this value from the Additional Profit Withholding table (F76A0403).

193-222

Apply CDI

The value in this field indicates whether CDI is applicable to the profit withholdings or not. The system retrieves this value from the Additional Profit Withholding table (F76A0403).

223

CDI Code

A legal code to identify the rate with CDI if CDI is applicable to the profit withholdings. The system retrieves this value from the Additional Profit Withholding table (F76A0403).

224-226

Grossing Up

The system verifies whether the voucher that is being paid includes a tax area that has been defined in Profit Gross Up UDC table (76A/AC). If the tax area is defined in the UDC table, the system displays 1 in this field to indicate that the withholding is grossed up. Otherwise, the system displays 0.

227

NIF Key

The supplier's NIF (Numero de Identificacion Fiscal) information. The system retrieves this information from the Supplier NIF Information processing option setting for the F2003 Profit Withholding to External Beneficiaries report (R76A4005). The system first retrieves the Supplier Tax ID field and then the Additional Tax ID field in the supplier's address book record. If both of these values are blank, the system displays the legend "No Disponible'' (Not Available) in the report.

228-277

Supplier Name

The name of the supplier. The system retrieves this value from the supplier's address book record.

278-337

Supplier Address

The address of the supplier. The system retrieves this value from the supplier's address book record.

338-397

Supplier Country

The supplier's SIRE country code. The system retrieves this value from the SIRE Countries UDC table (76A/PS).

398-400

Person/Corporation

The type of supplier. The system retrieves this value from the Person/Corporation Code field in the supplier's address book record.

401

Supplier Nationality/Constitution Country

The supplier's nationality. The system retrieves this value from the SIRE Countries UDC table (76A/PS) based on the Who's Who Category Code processing option set up for the TXT File - Profit to External Beneficiaries Withholding (R76A4005) report. If the category code has a blank value, the system displays the same value that is displayed for the Supplier Country field.

402-404

Supplier Nationality/Constitution Date

The supplier's date of birth. The system retrieves this value from the address book record of the supplier based on the Who's Who Type Code processing option set up for the TXT File - Profit to External Beneficiaries Withholding (R76A4005) report.

405-414

When the system generates the flat file for profit withholdings for foreign beneficiaries:

  • The system processes only non voided documents for the period.

  • The system processes only the posted transactions.

  • The system processes records for all payments processed for foreign suppliers (the country code is not blank and has a value other than AR).