Format 1002

You use format 1002 to report on source withholdings made. The records for this format use a specific fiscal ID and the DIAN document type that you set up in the DIAN General Setup program for transactions with foreign suppliers or minimal amounts. When you run the DIAN Generate concept by Account ID program for format 1002, the system reads data in the F0911, F76C9F01, As-Of Account Payable (F0411A), Tax Detail - Work File (F76CUI02), Company Additional Information (F7400010), and DIAN MM Minor and Foreign Setup (F76C0F05) tables; and populates the DIAN Formats to Account ID (F76C9F02) temporary table.

The records for format 1002 include:

• Name of each supplier for whom amounts have been withheld.

  The system uses the alpha name or mailing name from the address book record for a supplier that is a legal entity and the values for name and surname that you set up in the 01/W0 UDC table for suppliers who are natural persons, depending on the values in the DIAN General Setup program (P76C0F00).

• Fiscal ID of each supplier.

• Withholding amount.

• Withholding concept.

• Payment amount.

• Department code.

  The system extracts this data for Colombian suppliers only.

• Municipal code.

  The system extracts this data for Colombian suppliers only.

• Supplier county.

  The system uses the value in the F0116.ALCTR field to obtain the reporting code that is associated with the country code from the DIAN Country Code (76C/CC) UDC table.

  It the F0116.ALCTR field is blank, the system obtains the country code from the address book record of the supplier. If no value exists for the country code in the address book records, the system prints an error message on the PDF report and does not write data for the record to the output tables.