JL Argentine Monotributistas Billing vs. Threshold Verification

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
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 NameSQL textValidation
Report Mode
 
LOV Oracle
Company Name
 
LOV Oracle
Supplier Name
 
LOV Oracle
Taxpayer ID
 
LOV Oracle
Reporting Date
 
Date
Download
Related Blitz Reports
JL Colombian Payables Withholding Report- Not Supported: Reserved For Future Use JL Regional Fixed Assets Inflation Adjusted Asset Summary- Not Supported: Reserved For Future Use JL Argentine Payables Withholding Certificate - draft JL Argentine Payables Withholding Flat File - draft JL Colombian Payables Withholding Certificate - draft JG ECE Payables VAT Register JE Italian Annual Supplier Listing JG EMEA VAT: Summary AP Extract JE Croatian Supplier Invoice Tax
Blitz Report™