ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN F1E2D3C4B5A6978899887766554433EE select null action_, null status_, null message_, null modified_columns_, 'Registration' record_type, jprv.party_reg_id, jprlv.party_reg_line_id, to_number(null) reporting_association_id, jprv.operating_unit, jprv.party_class_name party_type, jprv.party_number, jprv.party_name, jprv.party_site_name, jprlv.regime_code registration_regime_code, jprlv.registration_type_name registration_type, jprlv.registration_number, jprlv.sec_registration_type_name secondary_registration_type, jprlv.secondary_registration_number, jprlv.assessable_price_list_name assessable_price_list, jprlv.default_section_name default_tds_section, jprlv.effective_from registration_start_date, jprlv.effective_to registration_end_date, to_char(null) reporting_code_regime_code, to_char(null) reporting_code_type, to_char(null) reporting_code, to_date(null) reporting_code_start_date, to_date(null) reporting_code_end_date from jai_party_regs_v jprv, jai_party_reg_lines_v jprlv where 1=1 and jprv.reg_class_code='THIRD_PARTY' and jprv.party_reg_id=jprlv.party_reg_id union all select null action_, null status_, null message_, null modified_columns_, 'Reporting Code' record_type, jprv.party_reg_id, to_number(null) party_reg_line_id, jrav.reporting_association_id, jprv.operating_unit, jprv.party_class_name party_type, jprv.party_number, jprv.party_name, jprv.party_site_name, to_char(null) registration_regime_code, to_char(null) registration_type, to_char(null) registration_number, to_char(null) secondary_registration_type, to_char(null) secondary_registration_number, to_char(null) assessable_price_list, to_char(null) default_tds_section, to_date(null) registration_start_date, to_date(null) registration_end_date, jrav.regime_code reporting_code_regime_code, jrav.reporting_type_name reporting_code_type, jrav.reporting_code, jrav.effective_from reporting_code_start_date, jrav.effective_to reporting_code_end_date from jai_party_regs_v jprv, jai_reporting_associations_v jrav where 1=1 and jprv.reg_class_code='THIRD_PARTY' and jprv.party_reg_id=jrav.entity_id and jrav.entity_code='THIRD_PARTY' order by party_type, party_number, record_type, party_reg_id, party_reg_line_id nulls last, reporting_association_id Y U A xxen_jai_upload.third_party_registration xxen_jai_upload.third_party_reg_validation( p_party_reg_id=>:$column$.party_reg_id, p_party_type=>:$column$.party_type, p_party_number=>:$column$.party_number, p_party_site_name=>:$column$.party_site_name, p_operating_unit=>:$column$.operating_unit, p_registration_regime_code=>:$column$.registration_regime_code, p_registration_type=>:$column$.registration_type, p_registration_number=>:$column$.registration_number, p_assessable_price_list=>:$column$.assessable_price_list, p_default_tds_section=>:$column$.default_tds_section, p_reporting_code_type=>:$column$.reporting_code_type, p_reporting_code=>:$column$.reporting_code, p_secondary_reg_type=>:$column$.secondary_registration_type, p_secondary_reg_number=>:$column$.secondary_registration_number, p_registration_start_date=>:$column$.registration_start_date, p_registration_end_date=>:$column$.registration_end_date, p_reporting_code_regime_code=>:$column$.reporting_code_regime_code, p_reporting_code_start_date=>:$column$.reporting_code_start_date, p_reporting_code_end_date=>:$column$.reporting_code_end_date, p_record_type=>:$column$.record_type ) US JA India Third Party Registration Upload JA India Third Party Registration Upload ========================================= Use this upload to create or update India Localization Third Party Registrations for customers and suppliers, including tax/registration identifiers such as PAN, TAN, TIN, GST, Service Tax, and other India-specific registration numbers. This upload also supports Reporting Codes linked to Third Party Registrations. NOTE: If you are creating new records for a third party, enter and upload all Registration records first, and then enter and upload the Reporting Code records. Available columns: 1.Record Type: Select either Registration or Reporting Code. This determines whether you are creating/updating a registration record or a reporting code record. 2.Operating Unit: Select the Operating Unit to retrieve the list of party sites for that OU, or leave blank if you are entering a registration without a site (null site registration). 3.Party Type: Select Supplier or Customer. The available Party Numbers depend on this selection. 4.Party Number: Enter the Supplier Number or Customer Number. You can use the list of values (LOV); entering a few starting characters/numbers helps narrow the list. 5.Party Name: Auto-populates after you enter the Party Number. You can also use the LOV to search by Supplier/Customer name; the LOV displays the Party Number as well. 6.Party Site Name: Select the Party Site based on the Operating Unit. Leave blank for a null site registration. 7.Registration Regime Code, Registration Type, Registration Number, Secondary Registration Type, Secondary Registration Number: Enter these fields to create/update a party registration. These fields are available only when Record Type = Registration. 8.Assessable Price List: Enter an Assessable Price List when the selected Regime Code is a Non-TDS Regime. Available only when Record Type = Registration. 9.Default TDS Section: Enter a Default TDS Section code when the selected Regime Code is a TDS Regime. Available only when Record Type = Registration. 10.Registration Start Date, Registration End Date: Enter the effective dates for the registration. The Start Date defaults to 01-Jul-2017 (GST implementation date in India), but you can change it as needed. 11.Reporting Code Regime Code, Reporting Code Type, Reporting Code: Enter these fields to create/update a reporting code for the registration. These fields are available only when Record Type = Reporting Code. 12.Reporting Code Start Date, Reporting Code End Date: Enter the effective dates for the reporting code. The Start Date defaults to 01-Jul-2017, but you can change it as needed. Enginatics India Localization R12 only Upload 1=1 1 10 1=1 nvl(jprv.org_id,-1)=nvl(:p_operating_unit_id,nvl(jprv.org_id,-1)) LOV custom Y select hou.organization_id id, hou.name value, null description from hr_operating_units hou where hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name US Operating Unit 2 20 1=1 jprv.party_class_code=:p_party_class LOV custom Y select jl.lookup_code id, jl.meaning value, jl.description description from ja_lookups jl where jl.lookup_type='JAI_NEW_PARTY_TYPE' and jl.lookup_code in ('SUPPLIER','CUSTOMER') and jl.enabled_flag='Y' order by jl.meaning US Party Type 3 30 1=1 jprv.party_name=:p_party_name LOV custom Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where :$flex$.p_party_class='SUPPLIER' union all select hp.party_name value, hca.account_number description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and :$flex$.p_party_class='CUSTOMER' order by 1 US Party Name 4 40 1=1 jprv.party_number=:p_party_number LOV custom Y Y select aps.segment1 value, aps.vendor_name description from ap_suppliers aps where :$flex$.p_party_class='SUPPLIER' union all select hca.account_number value, hp.party_name description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and :$flex$.p_party_class='CUSTOMER' order by 1 US Party Number 5 50 1=1 jprv.party_site_name=:p_party_site_name LOV custom Y Y select hps.party_site_number value, hz_format_pub.format_address(hps.location_id,null,null,' ',null,null,null,null) description from hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hr_operating_units hou where hca.account_number=:$flex$.p_party_number and hca.cust_account_id=hcasa.cust_account_id and hcasa.party_site_id=hps.party_site_id and hcasa.org_id=hou.organization_id(+) and (hou.name=:$flex$.p_operating_unit_id or :$flex$.p_operating_unit_id is null) and :$flex$.p_party_class='CUSTOMER' union all select pvs.vendor_site_code value, hz_format_pub.format_address(pvs.location_id,null,null,' ',null,null,null,null) description from ap_suppliers aps, po_vendor_sites_all pvs, hr_operating_units hou where aps.segment1=:$flex$.p_party_number and aps.vendor_id=pvs.vendor_id and pvs.org_id=hou.organization_id and (hou.name=:$flex$.p_operating_unit_id or :$flex$.p_operating_unit_id is null) and :$flex$.p_party_class='SUPPLIER' order by 1 US Party Site Name 6 60 1=1 upper(jprlv.regime_code) like '%'||upper(:p_regime_code)||'%' Char US Regime Code 7 70 1=1 upper(jprlv.registration_number) like '%'||upper(:p_registration_number)||'%' Char US Registration Number :$flex$.p_party_class Party Type Party Name :$flex$.p_party_class Party Type Party Number :$flex$.p_party_class Party Type Party Site Name :$flex$.p_party_number Party Number Party Site Name 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 RECORD_TYPE LOV custom varchar2 Y select 'Registration' value, 'Party Registration Lines' description from dual union all select 'Reporting Code' value, 'Reporting Associations' description from dual Y Y 6 PARTY_REG_ID Number number Y Y 7 PARTY_REG_LINE_ID Number number Y Y 8 REPORTING_ASSOCIATION_ID Number number Y Y 9 OPERATING_UNIT LOV custom varchar2 Y select hou.name value, null description from hr_operating_units hou where hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select hou.organization_id id, hou.name value from hr_operating_units hou Y 10 PARTY_TYPE LOV custom varchar2 Y select jl.meaning value, jl.description description from ja_lookups jl where jl.lookup_type='JAI_NEW_PARTY_TYPE' and jl.lookup_code in ('SUPPLIER','CUSTOMER') and jl.enabled_flag='Y' order by jl.meaning select jl.lookup_code id, jl.meaning value from ja_lookups jl where jl.lookup_type='JAI_NEW_PARTY_TYPE' and jl.enabled_flag='Y' Y Y 11 PARTY_NUMBER LOV custom varchar2 Y Y select aps.segment1 value, aps.vendor_name description from ap_suppliers aps where :$column$.party_type='Supplier' union all select hca.account_number value, hp.party_name description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and :$column$.party_type='Customer' order by 1 select aps.vendor_id id, aps.segment1 value from ap_suppliers aps where :$column$.party_type='Supplier' union all select hca.cust_account_id id, hca.account_number value from hz_cust_accounts hca where :$column$.party_type='Customer' Y Y 12 PARTY_NAME LOV custom varchar2 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where :$column$.party_type='Supplier' union all select hp.party_name value, hca.account_number description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and :$column$.party_type='Customer' order by 1 select aps.vendor_name from ap_suppliers aps where aps.segment1=:$column$.party_number and :$column$.party_type='Supplier' union all select hp.party_name from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and hca.account_number=:$column$.party_number and :$column$.party_type='Customer' Y 13 PARTY_SITE_NAME LOV custom varchar2 Y select hps.party_site_number value, hz_format_pub.format_address(hps.location_id,null,null,' ',null,null,null,null) description from hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hr_operating_units hou where hca.account_number=:$column$.party_number and hca.cust_account_id=hcasa.cust_account_id and hcasa.party_site_id=hps.party_site_id and hcasa.org_id=hou.organization_id(+) and (:$column$.operating_unit is null or hou.name=:$column$.operating_unit) and :$column$.party_type='Customer' union all select pvs.vendor_site_code value, hz_format_pub.format_address(pvs.location_id,null,null,' ',null,null,null,null) description from ap_suppliers aps, po_vendor_sites_all pvs, hr_operating_units hou where aps.segment1=:$column$.party_number and aps.vendor_id=pvs.vendor_id and pvs.org_id=hou.organization_id and (:$column$.operating_unit is null or hou.name=:$column$.operating_unit) and :$column$.party_type='Supplier' order by 1 select hcasa.cust_acct_site_id id, hps.party_site_number value from hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hr_operating_units hou where hca.account_number=:$column$.party_number and hca.cust_account_id=hcasa.cust_account_id and hcasa.party_site_id=hps.party_site_id and hcasa.org_id=hou.organization_id(+) and (:$column$.operating_unit is null or hou.name=:$column$.operating_unit) and :$column$.party_type='Customer' union all select apssa.vendor_site_id id, apssa.vendor_site_code value from ap_suppliers aps, ap_supplier_sites_all apssa, hr_operating_units hou where aps.segment1=:$column$.party_number and aps.vendor_id=apssa.vendor_id and apssa.org_id=hou.organization_id and (:$column$.operating_unit is null or hou.name=:$column$.operating_unit) and :$column$.party_type='Supplier' Y 14 REGISTRATION_REGIME_CODE LOV custom varchar2 Y select rgm.regime_code value, rgm.regime_name||' - '||decode(rgm.regime_type,'W','Withholding','T','Transaction',rgm.regime_type) description from jai_regimes rgm where :$column$.record_type='Registration' and trunc(sysdate)<=nvl(rgm.effective_to,trunc(sysdate)+1) order by rgm.regime_code select jr.regime_id id, jr.regime_code value from jai_regimes jr Y 15 REGISTRATION_TYPE LOV custom varchar2 Y select jl.meaning value, jl.description description from ja_lookups jl where :$column$.record_type='Registration' and jl.lookup_type='JAI_REGISTRATION_TYPES' and jl.enabled_flag='Y' order by jl.meaning select jl.lookup_code id, jl.meaning value from ja_lookups jl where jl.lookup_type='JAI_REGISTRATION_TYPES' and jl.enabled_flag='Y' Y 16 REGISTRATION_NUMBER Char varchar2 Y 17 SECONDARY_REGISTRATION_TYPE LOV custom varchar2 Y select jl.meaning value, jl.description description from ja_lookups jl where jl.lookup_type='JAI_REGISTRATION_TYPES' and jl.enabled_flag='Y' order by jl.meaning select jl.lookup_code id, jl.meaning value from ja_lookups jl where jl.lookup_type='JAI_REGISTRATION_TYPES' and jl.enabled_flag='Y' Y 18 SECONDARY_REGISTRATION_NUMBER Char varchar2 Y 19 ASSESSABLE_PRICE_LIST LOV custom varchar2 Y select qpl.name value, null description from qp_price_lists_v qpl where :$column$.record_type='Registration' and trunc(sysdate) between nvl(qpl.start_date_active,sysdate) and nvl(qpl.end_date_active,sysdate) order by qpl.name select qlht.list_header_id id, qlht.name value from qp_list_headers_tl qlht where qlht.language=userenv('lang') 20 DEFAULT_TDS_SECTION LOV custom varchar2 Y select jl.meaning value, jl.lookup_code description from ja_lookups jl where :$column$.record_type='Registration' and jl.lookup_type='JAI_TDS_SECTION' order by jl.meaning select jl.lookup_code id, jl.meaning value from ja_lookups jl where jl.lookup_type='JAI_TDS_SECTION' 21 REGISTRATION_START_DATE Date date case when :$column$.record_type='Registration' then date '2017-07-01' end Y 22 REGISTRATION_END_DATE Date date 23 REPORTING_CODE_REGIME_CODE LOV custom varchar2 Y select rgm.regime_code value, rgm.regime_name||' - '||decode(rgm.regime_type,'W','Withholding','T','Transaction',rgm.regime_type) description from jai_regimes rgm where :$column$.record_type='Reporting Code' and trunc(sysdate)<=nvl(rgm.effective_to,trunc(sysdate)+1) order by rgm.regime_code select jr.regime_id id, jr.regime_code value from jai_regimes jr Y 24 REPORTING_CODE_TYPE LOV custom varchar2 Y select jrt.reporting_type_name value, jl.meaning description from jai_reporting_types jrt, ja_lookups jl where :$column$.record_type='Reporting Code' and jrt.data_type=jl.lookup_code(+) and jl.lookup_type(+)='JAI_REPORTING_DATA_TYPE' and trunc(sysdate) between nvl(jrt.effective_from,sysdate-1) and nvl(jrt.effective_to,sysdate+1) and jrt.entity_code='THIRD_PARTY' order by jrt.reporting_type_name select jrt.reporting_type_id id, jrt.reporting_type_name value from jai_reporting_types jrt where jrt.entity_code='THIRD_PARTY' Y 25 REPORTING_CODE LOV custom varchar2 Y select jrc.reporting_code value, jrc.reporting_code_description description from jai_reporting_codes jrc, jai_reporting_types jrt where jrc.reporting_type_id=jrt.reporting_type_id and jrt.reporting_type_name=:$column$.reporting_code_type order by jrc.reporting_code select jrc.reporting_code_id id, jrc.reporting_code value from jai_reporting_codes jrc, jai_reporting_types jrt where jrc.reporting_type_id=jrt.reporting_type_id and jrt.reporting_type_name=:$column$.reporting_code_type Y 26 REPORTING_CODE_START_DATE Date date case when :$column$.record_type='Reporting Code' then date '2017-07-01' end Y 27 REPORTING_CODE_END_DATE Date date U 1 p_party_reg_id in/out Number PARTY_REG_ID U 2 p_party_reg_line_id in/out Number PARTY_REG_LINE_ID U 3 p_reporting_association_id in/out Number REPORTING_ASSOCIATION_ID U 4 p_operating_unit in Number OPERATING_UNIT U 5 p_party_type in Char PARTY_TYPE U 6 p_party_number in Number PARTY_NUMBER U 8 p_party_site_name in Number PARTY_SITE_NAME U 9 p_registration_regime_code in Number REGISTRATION_REGIME_CODE U 10 p_registration_type in Char REGISTRATION_TYPE U 11 p_registration_number in Char REGISTRATION_NUMBER U 13 p_secondary_reg_number in Char SECONDARY_REGISTRATION_NUMBER U 14 p_assessable_price_list in Number ASSESSABLE_PRICE_LIST U 15 p_default_tds_section in Char DEFAULT_TDS_SECTION U 16 p_registration_start_date in Date REGISTRATION_START_DATE U 17 p_registration_end_date in Date REGISTRATION_END_DATE U 18 p_reporting_code_regime_code in Number REPORTING_CODE_REGIME_CODE U 19 p_reporting_code_type in Number REPORTING_CODE_TYPE U 20 p_reporting_code in Number REPORTING_CODE U 21 p_reporting_code_start_date in Date REPORTING_CODE_START_DATE U 22 p_reporting_code_end_date in Date REPORTING_CODE_END_DATE U 23 p_record_type in Char RECORD_TYPE U 24 action_ in Char ACTION_CODE_ U 25 status_ out Char STATUS_CODE_ U 26 message_ out Char MESSAGE_ Error SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.record_type, xu.party_reg_id, xu.party_reg_line_id, to_number(null) reporting_association_id, xu.operating_unit, xu.party_type, xu.party_number, xu.party_name, xu.party_site_name, xu.registration_regime_code, xu.registration_type, xu.registration_number, xu.secondary_registration_type, xu.secondary_registration_number, xu.assessable_price_list, xu.default_tds_section, xu.registration_start_date, xu.registration_end_date, to_char(null) reporting_code_regime_code, to_char(null) reporting_code_type, to_char(null) reporting_code, to_date(null) reporting_code_start_date, to_date(null) reporting_code_end_date from xxen_ja_india_third_par_7638_u xu where xu.record_type='Registration' and xu.status_code_=xxen_upload.status_error union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.record_type, xu.party_reg_id, to_number(null) party_reg_line_id, xu.reporting_association_id, xu.operating_unit, xu.party_type, xu.party_number, xu.party_name, xu.party_site_name, to_char(null) registration_regime_code, to_char(null) registration_type, to_char(null) registration_number, to_char(null) secondary_registration_type, to_char(null) secondary_registration_number, to_char(null) assessable_price_list, to_char(null) default_tds_section, to_date(null) registration_start_date, to_date(null) registration_end_date, xu.reporting_code_regime_code, xu.reporting_code_type, xu.reporting_code, xu.reporting_code_start_date, xu.reporting_code_end_date from xxen_ja_india_third_par_7638_u xu where xu.record_type='Reporting Code' and xu.status_code_=xxen_upload.status_error Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.record_type, jprv.party_reg_id, jprlv.party_reg_line_id, to_number(null) reporting_association_id, jprv.operating_unit, jprv.party_class_name party_type, jprv.party_number, jprv.party_name, jprv.party_site_name, jprlv.regime_code registration_regime_code, jprlv.registration_type_name registration_type, jprlv.registration_number, jprlv.sec_registration_type_name secondary_registration_type, jprlv.secondary_registration_number, jprlv.assessable_price_list_name assessable_price_list, jprlv.default_section_name default_tds_section, jprlv.effective_from registration_start_date, jprlv.effective_to registration_end_date, to_char(null) reporting_code_regime_code, to_char(null) reporting_code_type, to_char(null) reporting_code, to_date(null) reporting_code_start_date, to_date(null) reporting_code_end_date from xxen_ja_india_third_par_7638_u xu, jai_party_regs_v jprv, jai_party_reg_lines_v jprlv where xu.record_type='Registration' and jprv.party_reg_id=xu.party_reg_id and jprv.reg_class_code='THIRD_PARTY' and jprlv.party_reg_id=jprv.party_reg_id and jprlv.party_reg_line_id=xu.party_reg_line_id and xu.status_code_=xxen_upload.status_success union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.record_type, jprv.party_reg_id, to_number(null) party_reg_line_id, jrav.reporting_association_id, jprv.operating_unit, jprv.party_class_name party_type, jprv.party_number, jprv.party_name, jprv.party_site_name, to_char(null) registration_regime_code, to_char(null) registration_type, to_char(null) registration_number, to_char(null) secondary_registration_type, to_char(null) secondary_registration_number, to_char(null) assessable_price_list, to_char(null) default_tds_section, to_date(null) registration_start_date, to_date(null) registration_end_date, jrav.regime_code reporting_code_regime_code, jrav.reporting_type_name reporting_code_type, jrav.reporting_code, jrav.effective_from reporting_code_start_date, jrav.effective_to reporting_code_end_date from xxen_ja_india_third_par_7638_u xu, jai_party_regs_v jprv, jai_reporting_associations_v jrav where xu.record_type='Reporting Code' and jprv.party_reg_id=xu.party_reg_id and jprv.reg_class_code='THIRD_PARTY' and jrav.entity_id=jprv.party_reg_id and jrav.entity_code='THIRD_PARTY' and jrav.reporting_type_name=xu.reporting_code_type and xu.status_code_=xxen_upload.status_success LOV query :$column$.record_type RECORD_TYPE ASSESSABLE_PRICE_LIST LOV query :$column$.record_type RECORD_TYPE DEFAULT_TDS_SECTION Default value :$column$.party_number PARTY_NUMBER PARTY_NAME Default value :$column$.party_type PARTY_TYPE PARTY_NAME LOV query :$column$.party_type PARTY_TYPE PARTY_NAME LOV query :$column$.party_type PARTY_TYPE PARTY_NUMBER LOV query :$column$.operating_unit OPERATING_UNIT PARTY_SITE_NAME LOV query :$column$.party_number PARTY_NUMBER PARTY_SITE_NAME LOV query :$column$.party_type PARTY_TYPE PARTY_SITE_NAME LOV query :$column$.record_type RECORD_TYPE REGISTRATION_REGIME_CODE Default value :$column$.record_type RECORD_TYPE REGISTRATION_START_DATE LOV query :$column$.record_type RECORD_TYPE REGISTRATION_TYPE LOV query :$column$.reporting_code_type REPORTING_CODE_TYPE REPORTING_CODE LOV query :$column$.record_type RECORD_TYPE REPORTING_CODE_REGIME_CODE Default value :$column$.record_type RECORD_TYPE REPORTING_CODE_START_DATE LOV query :$column$.record_type RECORD_TYPE REPORTING_CODE_TYPE Excel validation :$column$.assessable_price_list ASSESSABLE_PRICE_LIST Excel validation :$column$.default_tds_section DEFAULT_TDS_SECTION Value to id query :$column$.operating_unit OPERATING_UNIT p_party_site_name Excel validation :$column$.operating_unit OPERATING_UNIT Value to id query :$column$.party_number PARTY_NUMBER p_party_site_name Excel validation :$column$.party_number PARTY_NUMBER Excel validation :$column$.party_reg_id PARTY_REG_ID Excel validation :$column$.party_site_name PARTY_SITE_NAME Value to id query :$column$.party_type PARTY_TYPE p_party_number Value to id query :$column$.party_type PARTY_TYPE p_party_site_name Excel validation :$column$.party_type PARTY_TYPE Excel validation :$column$.record_type RECORD_TYPE Excel validation :$column$.registration_end_date REGISTRATION_END_DATE Excel validation :$column$.registration_number REGISTRATION_NUMBER Excel validation :$column$.registration_regime_code REGISTRATION_REGIME_CODE Excel validation :$column$.registration_start_date REGISTRATION_START_DATE Excel validation :$column$.registration_type REGISTRATION_TYPE Excel validation :$column$.reporting_code REPORTING_CODE Excel validation :$column$.reporting_code_end_date REPORTING_CODE_END_DATE Excel validation :$column$.reporting_code_regime_code REPORTING_CODE_REGIME_CODE Excel validation :$column$.reporting_code_start_date REPORTING_CODE_START_DATE Value to id query :$column$.reporting_code_type REPORTING_CODE_TYPE p_reporting_code Excel validation :$column$.reporting_code_type REPORTING_CODE_TYPE Excel validation :$column$.secondary_registration_number SECONDARY_REGISTRATION_NUMBER Excel validation :$column$.secondary_registration_type SECONDARY_REGISTRATION_TYPE