Printing the IGV Purchase Ledger (R76P4500)
The IGV Purchase Ledger report layout is in the format prescribed by Peruvian legal reporting requirements. When you run the R76P4500 program, the system generates the IGV Purchase Ledger report in PDF, CSV (R76P4504 report), and text file formats. The system prints two flat files, one each for resident and non-resident.
The following table lists the column names and descriptions for resident and non-resident records when the output type processing option is left blank. This is an example of the PDF report layout.
Column Name |
Explanation |
---|---|
Correlative Number |
Next number you set up by processing option. |
Payment Date |
Retrieved from the F0411 table (field DIVJ). |
Due Date |
Retrieved from the F0411 table (field DDJ). |
Type |
Retrieved from UDC table 76P/DT. |
Serial Number |
In the case of domestic vouchers, it is retrieved from F0411 table (serial number from field VINV). In the case of import voucher, the system uses the custom code retrieved from F76P411T (category code defined by PO). |
DUA/DSI |
DUA/DSI issue year. Defined by processing option. |
Number |
Vendor invoice number without serial number, retrieved from F0411. |
Vendor information |
This section includes vendor's document type (from UDC table 76H/DA), document number, and name. Retrieved from F76P101T table. |
Op Grav Base Amount |
Retrieved from P76P030, column 1. |
Op Grav IGV |
Retrieved from P76H020, column 6. |
Op Grav y no Grav Base Amount |
Retrieved from P76P030, column 1. |
Op Grav y no Grav IGV |
Retrieved from P76H020, column 7. |
Op no Grav Base Amount |
Retrieved from P76P030, column 1. |
Op no Grav IGV |
Retrieved from P76H020, column 8. |
Value Adq no G |
Retrieved from P76H020, column 2. |
ISC |
Retrieved from P76H020, column 5. |
Other |
Retrieved from P76H020, column 9. |
Total |
Retrieved from the F0411 table (AG field). |
Payment receipt |
Retrieved from the F0411 table (VINV field), only in the case of transactions related with services. You specify this transaction type in UDC table 76P/OT (special handling code 1). |
Deduction number |
Retrieved from the F76P480 table (P76SPDN field). |
Deduction date |
Retrieved from the F76P480 table (P76SPDD field). |
Exchange Rate |
Retrieved from the F0411 table (CRR field). |
Date |
Original document date, retrieved from F0411 (for credit or debit notes). |
Type |
Original document type, retrieved from F0411 (for credit or debit notes). |
Number |
Original document number, retrieved from F0411 (for credit or debit notes). |
The following table describes the PDF report layout generated for the resident records when the Output Type processing option is set to 1.
Column Name |
Explanation |
---|---|
Document Type |
Retrieved from the F0411 table (field DCT). |
Document Number |
Retrieved from the F0411 table (field DOC). |
Period |
From Date you set up in the processing option. |
CUO Record Key |
Unique Key generated using the combination of Document Number and Document Type in Correlative Number. |
Type Document |
Correlative Number generated using Next number set in processing option or Document Type and Document Number depending up on Processing option. |
Invoice Date |
Retrieved from the F0411 table (field DIVJ). |
Due Date |
Retrieved from the F0411 table (field DDJ). |
Record Type |
Retrieved from UDC table 76P/DT. |
DUA Series |
In the case of domestic vouchers, it is retrieved from F0411 table (serial number from field VINV). In the case of import voucher, the system uses the custom code retrieved from F76P411T (category code defined by PO). |
DUA/DSI Year |
DUA/DSI issue year. Defined by processing option. |
Payment Number |
Vendor invoice number without serial number, retrieved from F0411. |
Originator Id |
Vendor's document type (from UDC table 76H/DA) retrieved from F76P101T table. |
RUC Number |
Supplier TaxID retrieved from the F0101 table (field TAX). |
Mailing Name |
Supplier TaxID retrieved from the F0101 table (field ALPH). |
Export Write Amount Basis |
Retrieved from P76P030, column 1. |
Export Write Tax Basis |
Retrieved from P76H020, column 6. |
Export Non Write Amount Basis |
Retrieved from P76P030, column 1. |
Export Non Write Tax Basis |
Retrieved from P76H020, column 7. |
Export Credit Amount Basis |
Retrieved from P76P030, column 1. |
Export Credit Tax Amount |
Retrieved from P76H020, column 8. |
Acquired Amount |
Retrieved from P76H020, column 2. |
Deducted Amount Basis |
Retrieved from P76H020, column 5. |
Other Amounts |
Retrieved from P76H020, column 9. |
Acquired Paid Amount Total |
Retrieved from the F0411 table (AG field). |
The following table describes the PDF report layout generated for the non-resident records when the Output Type processing option is set to 2.
Column Name |
Explanation |
---|---|
Document Type |
Retrieved from the F0411 table (field DCT). |
Document Number |
Retrieved from the F0411 table (field DOC). |
Period |
From Date you set up in the processing option. |
CUO Record Key |
Unique Key generated using the combination of Document Number and Document Type in Correlative Number. |
Type Document |
Correlative Number generated using Next number set in processing option or Document Type and Document Number depending up on Processing option. |
Invoice Date |
Retrieved from the F0411 table (field DIVJ). |
Payment Type |
Retrieved from UDC table 76P/DT. |
Payment Series |
In the case of domestic vouchers, it is retrieved from F0411 table (serial number from field VINV). In the case of import voucher, the system uses the custom code retrieved from F76P411T (category code defined by PO). |
Payment Number |
Vendor invoice number without serial number, retrieved from F0411. |
Acquired Amount |
Retrieved from the F0411 table (AG field). |
Acquired Amount Total |
Retrieved from the F0411 table (AG field). |
DUA/DSI Year |
DUA/DSI issue year. Defined by processing option. |
Currency Code |
Retrieved from the F0411 table (field CRCD). |
Exchange Rate |
Retrieved from the F0411 table (field CRR). |
Supplier Country Code |
Retrieved from UDC Table 76P/CT. |
Supplier Mailing Name |
Supplier Name retrieved from the F0101 table (field ALPH). |
Supplier ID Number |
Supplier TaxID retrieved from the F0101 table (field TAX). |
Payor ID Number |
Supplier TaxID retrieved from the F0101 table (field TAX). |
Alternate Mailing Name |
Supplier Name retrieved from the F0101 table (field ALPH). |
The following table describes the format of the text file generated by the R76P4500 report for residents:
Number |
Length |
Description |
Type |
---|---|---|---|
1 |
8 |
Financial period (in the YYYYMM00 format). |
Numeric |
2 |
up to 40 |
Serial number of the month or Single Operation Code (CUO). CUO is the unique key or primary key accounting software that uniquely identifies the key or accounting entry. |
Text |
3 |
2 to 10 |
Correlative number of accounting entries identified in Field 2 when CUO is used. The first character should be A, M, or C. |
Alphanumeric |
4 |
10 |
Date of issue of the payment receipt or document. |
DD/MM/YYYY |
5 |
10 |
Expiration Date or Payment Date. |
DD/MM/YYYY |
6 |
2 |
Type of pay stub or document. |
Numeric |
7 |
Up to 20 |
Series proof of payment or document. |
Alphanumeric |
8 |
4 |
Year of issuance of the DUA or DSI. |
Numeric |
9 |
Up to 20 |
Number of proof of payment or document. |
Alphanumeric |
10 |
Up to 20 |
Blank |
Numeric |
11 |
1 |
This field is not populated in the report if the Select Output Type Processing option under the Report tab is set to blank. |
Alphanumeric |
12 |
Up to 15 |
Supplier RUC number or identity document number, as appropriate. |
Alphanumeric |
13 |
Up to 100 |
Supplier/vendor name. |
Text |
14 |
12 integers and up to 2 decimals, without commas of thousands |
Taxable amount of taxable inputs entitling tax credit and/or export credit balance, intended exclusively for taxable transactions and/or export. |
Numeric |
15 |
12 integers and up to 2 decimals, without commas of thousands |
Amount of General Sales Tax and/or Municipal Promotion Tax. |
Numeric |
16 |
12 integers and up to 2 decimals, without commas of thousands |
Taxable amount of taxable inputs entitling tax credit and/or export credit balance, aimed at taxable and/or export operations and untaxed operations. |
Numeric |
17 |
12 integers and up to 2 decimals, without commas of thousands |
Amount of General Sales Tax and/or Municipal Promotion Tax. |
Numeric |
18 |
12 integers and up to 2 decimals, without commas of thousands |
Taxable amount of taxable inputs that are not entitled to tax credit and/or export credit balance, not to be intended for taxable transactions and/or export. |
Numeric |
19 |
12 integers and up to 2 decimals, without commas of thousands |
Amount of General Sales Tax and/or Municipal Promotion Tax. |
Numeric |
20 |
12 integers and up to 2 decimals, without commas of thousands |
Value of acquisitions untaxed. |
Numeric |
21 |
12 integers and up to 2 decimals, without commas of thousands |
Amount of Excise Tax in cases where the subject can use it as a deduction. |
Numeric |
22 |
12 integers and up to 2 decimals, without commas of thousands |
Other items, taxes, and charges that are not part of the tax base. |
Numeric |
23 |
12 integers and up to 2 decimals, without commas of thousands |
Total amount of purchases registered as proof of payment. |
Numeric |
24 |
3 |
This field is not populated in the report. |
Alphanumeric |
25 |
1 and 3 decimal integer |
Exchange. |
Numeric |
26 |
10 |
Date of issue of the payment receipt. |
DD/MM/YYYY |
27 |
2 |
Proof of payment type. |
Numeric |
28 |
Up to 20 |
Serial number of the payment receipt. |
Alphanumeric |
29 |
3 |
This field is not populated in the report. |
Alphanumeric |
30 |
Up to 20 |
Number of proof of payment. |
Alphanumeric |
31 |
10 |
Date of the Certificate of Deposit Decrease. |
DD/MM/YYYY |
32 |
Up to 24 |
Number of the Certificate of Deposit Decrease. |
Alphanumeric |
33 |
1 |
This field is not populated in the report. |
Numeric |
34 |
1 |
This field is not populated in the report. |
Text |
35 |
12 |
This field is not populated in the report. |
Text |
36-39 |
1 |
These fields are not populated in the report. |
Alphanumeric |
40 |
1 |
Indicator of Payment Receipts Canceled with Payment Methods. |
Numeric |
41 |
1 |
State identifies an opportunity annotation or indication if it corresponds to a setting. |
Numeric |
42 |
Up to 200 |
Free use fields. |
Text |
The following table describes the format of the text file generated by the R76P4500 report for non-residents:
Number |
Length |
Description |
Type |
---|---|---|---|
1 |
8 |
Financial period (in the YYYYMM00 format). |
Numeric |
2 |
up to 40 |
Serial number of the month or Single Operation Code (CUO). CUO is the unique key or primary key accounting software that uniquely identifies the key or accounting entry. |
Text |
3 |
2 to 10 |
Correlative number of accounting entries identified in Field 2 when the Single Operation Code (CUO) is used. The first character should be A, M, or C. |
Alphanumeric |
4 |
10 |
Date of issue of the payment receipt or document. |
DD/MM/YYYY |
5 |
2 |
Pay stub or document type. |
Alphanumeric |
6 |
Up to 20 |
This field is not populated in the report if the Select Output Type Processing option under the Report tab is set to blank. |
Alphanumeric |
7 |
Up to 20 |
Payment voucher number. |
Alphanumeric |
8 |
12 integers and up to 2 decimals, without commas of thousands |
These fields are not populated in the report if the Select Output Type Processing option under the Report tab is set to blank. |
Numeric |
9 |
12 integers and up to 2 decimals, without commas of thousands |
These fields are not populated in the report. |
Numeric |
10 |
12 integers and up to 2 decimals, without commas of thousands |
This field is not populated in the report if the Select Output Type Processing option under the Report tab is set to blank. |
Numeric |
11 |
2 |
This field is not populated in the report. |
Numeric |
12 |
Up to 20 |
This field is not populated in the report. |
Alphanumeric |
13 |
4 |
This field is not populated in the report if the Select Output Type Processing option under the Report tab is set to blank. |
Numeric |
14 |
Up to 20 |
This field is not populated in the report. |
Alphanumeric |
15 |
12 integers and up to 2 decimals, without commas of thousands |
This field is not populated in the report. |
Numeric |
16 |
3 |
Code Currency (Table 4). |
Alphanumeric |
17 |
1 and 3-decimal integer |
This field is not populated in the report if the Select Output Type Processing option under the Report tab is set to blank. |
|
18 |
4 |
Country of residence of the non-resident subject. |
Alphanumeric |
19 |
Up to 100 |
Supplier/vendor name. |
Text |
20 |
Up to 100 |
This field is not populated in the report. |
Text |
21 |
Up to 15 |
Identification number of the non-resident subject. |
Text |
22 |
Up to 15 |
This field is not populated in the report if the Select Output Type Processing option under the Report tab is set to blank. |
Text |
23 |
Up to 100 |
This field is not populated in the report if the Select Output Type Processing option under the Report tab is set to blank. |
Text |
24 |
4 |
This field is not populated in the report. |
Alphanumeric |
25 |
2 |
This field is not populated in the report. |
Alphanumeric |
26-30 |
12 integers and up to 2 decimals, without commas of thousands |
These fields are not populated in the report. |
Numeric |
31 |
2 |
Agreements to avoid double taxation. |
Numeric |
32 |
1 |
This field is not populated in the report. |
Numeric |
33 |
2 |
Type of income. |
Numeric |
34-35 |
1 |
These fields are not populated in the report. |
Numeric |
36 |
1 |
State identifies an opportunity annotation or indication if it corresponds to a setting. |
Numeric |
37 |
Up to 200 |
Free use fields. |
Text |