JE Italian Payables Exemption Letter Process

Description
Categories: BI Publisher
Application: European Localizations
Source: Italian Payables Exemption Letter Process
Short Name: JEITAPEX_XMLP
DB package: JE_IT_EXEM_RPT_PKG
SELECT jg_info_v1 B
					  ,jg_info_n1  amended_let_check
					  ,jg_info_v2  rec_pro_num1
					  ,jg_info_v3  rec_pro_num2
					  ,jg_info_n2   purchase_box
					  ,jg_info_n3   import_box
					  ,jg_info_n4   year
					  ,jg_info_n16   spec_operation
					  ,jg_info_n5   exempt_amt
					  ,jg_info_v5   exem_period_from
					  ,jg_info_v6   exem_period_to
					  ,jg_info_v7   goods_desc
					  ,jg_info_n6   exem_letter_id
					  --Supplier Information
					  ,jg_info_v8  custom
					  ,jg_info_v9  Supp_taxp_id
					  ,jg_info_v10  Supp_reg_num
					  ,jg_info_v11  indv_last_name
					  ,jg_info_v12  indv_first_name
					  ,jg_info_v13  vendor_name
					  ,jg_info_v14  gender
					  ---Letter checkbox information
					  ,jg_info_n7  vat_p_type
					  ,jg_info_n8  year_decl_flag
					  ,jg_info_n10  export_g_flag
					  ,jg_info_n11  intra_esg_flag
					  ,jg_info_n12  sales_sm_flag
					  ,jg_info_n13  trx_eeg_flag
					  ,jg_info_n9  ex_op_flag
					  ,jg_info_v15     eff_from_day
					  ,jg_info_v16  eff_from_month
					  ,jg_info_n14  eff_from_year
					  ,jg_info_v17  eff_to_day
					  ,jg_info_v18  eff_to_month
					  ,jg_info_n15  eff_to_year
					,jg_info_v19 effec_from
					,jg_info_v20 effec_to
					,jg_info_v23 orig_recp_proc1
					,jg_info_v24 orig_recp_proc2
					,substr(jg_info_v2,-1,1) "1"
					,substr(jg_info_v2,-2,1) "2"
					,substr(jg_info_v2,-3,1) "3"
					,substr(jg_info_v2,-4,1) "4"
					,substr(jg_info_v2,-5,1) "5"
					,substr(jg_info_v2,-6,1) "6"
					,substr(jg_info_v2,-7,1) "7"
					,substr(jg_info_v2,-8,1) "8"
					,substr(jg_info_v2,-9,1) "9"
					,substr(jg_info_v2,-10,1) "10"
					,substr(jg_info_v2,-11,1) "11"
					,substr(jg_info_v2,-12,1) "12"
					,substr(jg_info_v2,-13,1) "13"
					,substr(jg_info_v2,-14,1) "14"
					,substr(jg_info_v2,-15,1) "15"
					,substr(jg_info_v2,-16,1) "16"
					,substr(jg_info_v2,-17,1) "17"
					,substr(jg_info_v3,-1,1) "21"
					,substr(jg_info_v3,-2,1) "22"
					,substr(jg_info_v3,-3,1) "23"
					,substr(jg_info_v3,-4,1) "24"
					,substr(jg_info_v3,-5,1) "25"
					,substr(jg_info_v3,-6,1) "26"
				  FROM  jg_zz_vat_trx_gt       
				  WHERE  jg_info_v1 = 'B'
				ORDER BY jg_info_n6
Parameter Name SQL text Validation
Period_Set_Name
 
Legal Entity ID
 
Number
Province
 
Ledger ID
 
Number
Legal Representative Gender
 
LOV Oracle
Legal Representative Province Code of Birth
 
Legal Representative City of Birth
 
Legal Representative Date of Birth
 
Date
Legal Representative Surname
 
Legal Representative Name
 
Legal Representative Role Code
 
Company Fiscal Code Taxpayer ID
 
Legal Representative Taxpayer ID
 
Commitment Date
 
Date
Sign of Intermediary
 
LOV Oracle
Software House Taxpayer ID
 
Transmitter Email Address
 
Transmitter Phone Number
 
Transmitter Fiscal Code Taxpayer ID
 
Transmitter Type
 
LOV Oracle
Letter of Intent Format
 
LOV Oracle
Letter of Intent Type
 
LOV Oracle
Supplier Name
 
LOV Oracle
Period To
 
LOV Oracle
Period From
 
LOV Oracle
Reporting Identifier
 
LOV Oracle