JL Argentine Receivables Withholding Taken Flat File - draft

Description
Categories: BI Publisher
Columns: Dgi Tax Regime Code, Withholding Agent Cuit, Withholding Date, Withholding Cert Num, Withholding Amount, Cf With Taken Rec ...
Application: Latin America Localizations
Source: Argentine Receivables Withholding Taken Flat File (XML) - Not Supported: Reserved For Future Use
Short Name: JLARRWTF_XML
DB package: JL_JLARRWTF_XMLP_PKG
Select  lpad( substr(acr.GLOBAL_ATTRIBUTE6,1,3),3,'0') DGI_tax_regime_code, 
            lpad( NVL(replace(substr(cust.JGZZ_FISCAL_CODE,1,10),'-','') || NVL(SUBSTR(cust.GLOBAL_ATTRIBUTE12,1,1),NULL),' ') , 13,' ' ) withholding_agent_cuit, 
            acr.GLOBAL_ATTRIBUTE5   withholding_date , 
            lpad(substr(acr.GLOBAL_ATTRIBUTE4,1,16),16,'0')  withholding_cert_num ,
            acr.amount  withholding_amount, 
	JL_JLARRWTF_XMLP_PKG.cf_with_taken_recformula(lpad ( substr ( acr.GLOBAL_ATTRIBUTE6 , 1 , 3 ) , 3 , '0' ), lpad ( NVL ( replace ( substr ( cust.JGZZ_FISCAL_CODE , 1 , 10 ) , '-' , '' ) || NVL ( SUBSTR ( cust.GLOBAL_ATTRIBUTE12 , 1 , 1 ) , NULL ) , ' ' ) , 13 , ' ' ), acr.GLOBAL_ATTRIBUTE5, lpad ( substr ( acr.GLOBAL_ATTRIBUTE4 , 1 ,