JL Argentine Monotributistas Billing vs. Threshold Verification

➜ Back to Library
Description
Categories: BI Publisher
Columns: Supplier Name, Taxpayer Id, Sim Reg Cont Type, Threshold, Invoice Num, Invoice Date, Invoice Status, Dgi Type, Invoice Amt, Inv Amt Exc Tax ...
Application: Latin America Localizations
Source: Argentine Monotributistas Billing vs. Threshold Verification Report
Short Name: JLARMTBT_XMLP
DB package: JL_ZZ_AP_MONOTRIB_AWT_PKG 
				SELECT 	A.JL_INFO_V1		            SUPPLIER_NAME, 
						A.JL_INFO_V2			        TAXPAYER_ID, 
						A.JL_INFO_V3			        SIM_REG_CONT_TYPE, 
						A.JL_INFO_N6			        THRESHOLD, 
						A.JL_INFO_V6			        INVOICE_NUM,
						TO_CHAR(A.JL_INFO_D1,'DD-MON-YYYY')				    INVOICE_DATE,
						A.JL_INFO_V7					INVOICE_STATUS,
						A.JL_INFO_V8					DGI_TYPE,
						A.JL_INFO_N4		            INVOICE_AMT,
						A.JL_INFO_N5			        INV_AMT_EXC_TAX,
						A.JL_INFO_V9				    THRESHOLD_MET
						FROM JL_ZZ_INFO_T  A
						WHERE A.JL_INFO_V9 = 'N'
						  AND A.JL_INFO_V4 = 'N'
						  AND A.JL_INFO_V5 = 'N'
						  AND :P_REPORT_MODE = '02'
						  AND NOT EXISTS (SELECT 1 FROM JL_ZZ_INFO_T B WHERE A.JL_INFO_N1 = B.JL_INFO_N1 AND B.JL_INFO_V9 = 'Y')
						ORDER BY A.JL_INFO_V1,A.JL_INFO_D1,A.JL_INFO_N3
Parameter Name SQL text Validation
Report Mode 
 
 LOV Oracle
Company Name 
 
 LOV Oracle
Supplier Name 
 
 LOV Oracle
Taxpayer ID 
 
 LOV Oracle
Reporting Date 
 
 Date
Set of Books ID 
 
Organization ID 
 
Download
Related Blitz Reports
JL Colombian Payables Withholding Certificate - draft JL Regional Fixed Assets Inflation Adjusted Asset Summary - draft JL Argentine Payables Withholding Flat File - draft JL Argentine Payables Withholding Certificate - draft JL Colombian Payables Withholding - draft JE Portuguese Suppliers Recapitulative JE Croatian Supplier Invoice Tax JG EMEA VAT: Turnover AP Non TRL Extract JE Portuguese Customers Recapitulative
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: