JE Italian Payables Exemption Letter Process
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Process and Print Exemption Letters
Application: European Localizations
Source: Italian Payables Exemption Letter Process
Short Name: JEITAPEX_XMLP
DB package: JE_IT_EXEM_RPT_PKG
Description: Process and Print Exemption Letters
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 | |
|---|---|---|---|
| Reporting Identifier | LOV Oracle | ||
| Period From | LOV Oracle | ||
| Period To | LOV Oracle | ||
| Supplier Name | LOV Oracle | ||
| Letter of Intent Type | LOV Oracle | ||
| Letter of Intent Format | LOV Oracle | ||
| Transmitter Type | LOV Oracle | ||
| Transmitter Fiscal Code Taxpayer ID | Char | ||
| Transmitter Phone Number | Char | ||
| Transmitter Email Address | Char | ||
| Software House Taxpayer ID | Char | ||
| Sign of Intermediary | LOV Oracle | ||
| Commitment Date | Date | ||
| Legal Representative Taxpayer ID | Char | ||
| Company Fiscal Code Taxpayer ID | Char | ||
| Legal Representative Role Code | Char | ||
| Legal Representative Name | Char | ||
| Legal Representative Surname | Char | ||
| Legal Representative Date of Birth | Date | ||
| Legal Representative City of Birth | Char | ||
| Legal Representative Province Code of Birth | Char | ||
| Legal Representative Gender | LOV Oracle |