ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B9847D20A0E4742FE0538931640A6379 AP Supplier Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US 8E2FF36EDF1479D2E0530100007F1FF2 AP Supplier Number Y select aps.segment1 value, aps.vendor_name description from ap_suppliers aps where :$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id) order by aps.segment1, aps.vendor_id US 8E2FF36EDF0279D2E0530100007F1FF2 AP Supplier Site Y select distinct assa.vendor_site_code value, assa.address_line1||', '||assa.city||', '||nvl(ftv.territory_short_name,assa.country) description from hr_all_organization_units_vl haouv, ap_suppliers aps, ap_supplier_sites_all assa, fnd_territories_vl ftv where (:$flex$.ap_supplier is null or xxen_util.contains(:$flex$.ap_supplier,aps.vendor_name)='Y') and (:$flex$.ap_supplier_number is null or xxen_util.contains(:$flex$.ap_supplier_number,aps.segment1)='Y') and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and haouv.organization_id=assa.org_id and aps.vendor_id=assa.vendor_id and assa.country=ftv.territory_code(+) order by assa.vendor_site_code US 98567A11CE2765ADE0530100007F6157 AP Supplier Type Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='VENDOR TYPE' and flvv.view_application_id=201 and flvv.security_group_id=0 order by flvv.lookup_code US 8E2FF36EDE8379D2E0530100007F1FF2 Country Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and 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 Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 49A8B1A803C008ACE0530100007FEB91 select haouv.name operating_unit, aps.vendor_name supplier, aps.segment1 supplier_number, aps.vendor_name_alt alternate_supplier, hp.known_as trading_partner, &dff_columns xxen_util.meaning(aps.vendor_type_lookup_code,'VENDOR TYPE',201) type, aps.type_1099 income_tax_type, decode(aps.organization_type_lookup_code,'INDIVIDUAL',aps.individual_1099,aps.num_1099) taxpayer_id, (select territory_short_name from fnd_territories_vl ftv where ftv.territory_code = zptp0.country_code) dflt_rep_country_name, zptp0.rep_registration_number dflt_rep_registrn_number, zptp0.registration_type_code dflt_rep_registrn_type, aps.vat_registration_num tax_registration_number, aps.tax_reporting_name, xxen_util.yes(aps.federal_reportable_flag) federal_reportable, xxen_util.yes(aps.state_reportable_flag) state_reportable, xxen_util.yes(aps.allow_awt_flag) allow_withholding_tax, (select aag.name from ap_awt_groups aag where aps.awt_group_id=aag.group_id) inv_withholding_tax_group, (select aag.name from ap_awt_groups aag where aps.pay_awt_group_id=aag.group_id) pay_withholding_tax_group, aps0.vendor_name parent_supplier_name, aps0.segment1 parent_supplier_number, aps.customer_num, aps.vat_code, xxen_util.yes(aps.small_business_flag) small_business, xxen_util.yes(aps.hold_flag) hold_flag, aps.purchasing_hold_reason, aps.end_date_active supplier_inactive_date, aps.min_order_amount, aps.price_tolerance, assa.vendor_site_code site_code, (select trunc(max(aia.invoice_date)) from ap_invoices_all aia where aia.vendor_site_id=assa.vendor_site_id) last_invoice_date, hps.party_site_name address_name, assa.vendor_site_code_alt alternate_site_name, xxen_util.yes(assa.primary_pay_site_flag) primary_pay_site, xxen_util.yes(assa.purchasing_site_flag) purchasing_site, xxen_util.yes(assa.rfq_only_site_flag) rfq_only, xxen_util.yes(assa.pay_site_flag) pay_site, xxen_util.yes(assa.pcard_site_flag) procurement_card, xxen_util.yes(assa.hold_unmatched_invoices_flag) matching_required, xxen_util.yes(assa.hold_future_payments_flag) hold_future_payments, xxen_util.yes(assa.hold_all_payments_flag) hold_all_payments, assa.inactive_date site_inactive_date, assa.freight_terms_lookup_code freight_terms, assa.fob_lookup_code free_on_board_code, assa.address_line1, assa.address_line2, assa.address_line3, assa.address_line4, assa.city, assa.state, assa.zip, assa.county, assa.province, nvl(ftv.territory_short_name,assa.country) country, assa.area_code, assa.phone, assa.fax_area_code, assa.fax, assa.supplier_notif_method, assa.email_address, nvl(assa.terms_date_basis,aps.terms_date_basis) terms_date_basis, nvl(assa.pay_group_lookup_code,aps.pay_group_lookup_code) pay_group, xxen_util.meaning(nvl(assa.pay_date_basis_lookup_code,aps.pay_date_basis_lookup_code),'PAY DATE BASIS',201) pay_date_basis, atv0.name payment_terms, (select territory_short_name from fnd_territories_vl ftv where ftv.territory_code = zptp1.country_code) site_dflt_rep_country_name, zptp1.rep_registration_number site_dflt_rep_registrn_number, zptp1.registration_type_code site_dflt_rep_registrn_type, xxen_util.meaning(assa.auto_tax_calc_override,'YES_NO',0) auto_tax_calculation_override, xxen_util.meaning(assa.auto_tax_calc_flag,'YES_NO',0) auto_tax_calculation, xxen_util.meaning(assa.allow_awt_flag,'YES_NO',0) site_allow_withholding_tax, (select aag.name from ap_awt_groups aag where aag.group_id = assa.awt_group_id) site_inv_withholding_tax_group, (select aag.name from ap_awt_groups aag where aag.group_id = assa.pay_awt_group_id) site_pay_withholding_tax_group, (select distinct listagg(xxen_util.meaning(ieppm.payment_method_code,'PAYMENT METHOD',200,'Y'),', ') within group (order by ieppm.primary_flag desc, ieppm.payment_method_code) over () payment_method from iby_ext_party_pmt_mthds ieppm where iepa0.ext_payee_id=ieppm.ext_pmt_party_id) payment_method, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where assa.accts_pay_code_combination_id=gcck.code_combination_id) liability_account, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where assa.prepay_code_combination_id=gcck.code_combination_id) prepayment_account, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where assa.future_dated_payment_ccid=gcck.code_combination_id) bills_payable_account, &supplier_bank_account atv1.name site_payment_terms, (select distinct listagg(xxen_util.meaning(ieppm.payment_method_code,'PAYMENT METHOD',200,'Y'),', ') within group (order by ieppm.primary_flag desc, ieppm.payment_method_code) over () payment_method from iby_ext_party_pmt_mthds ieppm where iepa1.ext_payee_id=ieppm.ext_pmt_party_id) site_payment_method, &site_bank_account &contacts_columns xxen_util.client_time(aps.creation_date) supplier_creation_date, xxen_util.user_name(aps.created_by) supplier_created_by, xxen_util.client_time(aps.last_update_date) supplier_last_update_date, xxen_util.user_name(aps.last_updated_by) supplier_last_updated_by, xxen_util.client_time(assa.creation_date) site_creation_date, xxen_util.user_name(assa.created_by) site_created_by, xxen_util.client_time(assa.last_update_date) site_last_update_date, xxen_util.user_name(assa.last_updated_by) site_last_updated_by, aps.vendor_id, assa.vendor_site_id from hr_all_organization_units_vl haouv, ap_suppliers aps, (select assa.* from ap_supplier_sites_all assa where 2=2) assa, fnd_territories_vl ftv, (select pvc.* from po_vendor_contacts pvc where '&show_contacts'='Y' and 3=3) pvc, ap_suppliers aps0, ap_terms_vl atv0, ap_terms_vl atv1, (select iepa.* from iby_external_payees_all iepa where '&show_bank_accounts'='Y' and iepa.payment_function='PAYABLES_DISB' and iepa.party_site_id is null and iepa.supplier_site_id is null and iepa.org_id is null) iepa0, (select iepa.* from iby_external_payees_all iepa where '&show_bank_accounts'='Y' and iepa.payment_function='PAYABLES_DISB' and iepa.party_site_id is not null) iepa1, (select ipiua.* from iby_pmt_instr_uses_all ipiua where 4=4 and ipiua.payment_function='PAYABLES_DISB') ipiua0, (select ipiua.* from iby_pmt_instr_uses_all ipiua where 4=4 and ipiua.payment_function='PAYABLES_DISB') ipiua1, iby_ext_bank_accounts ieba0, iby_ext_bank_accounts ieba1, ce_bank_branches_v cbbv0, ce_bank_branches_v cbbv1, hz_parties hp, hz_party_sites hps, zx_party_tax_profile zptp0, zx_party_tax_profile zptp1 where 1=1 and aps.vendor_id=assa.vendor_id(+) and assa.org_id=haouv.organization_id(+) and assa.country=ftv.territory_code(+) and assa.vendor_site_id=pvc.vendor_site_id(+) and aps.parent_vendor_id=aps0.vendor_id(+) and aps.terms_id=atv0.term_id(+) and assa.terms_id=atv1.term_id(+) and aps.party_id=iepa0.payee_party_id(+) and assa.party_site_id=iepa1.party_site_id(+) and assa.org_id=iepa1.org_id(+) and assa.vendor_site_id=iepa1.supplier_site_id(+) and iepa0.ext_payee_id=ipiua0.ext_pmt_party_id(+) and iepa1.ext_payee_id=ipiua1.ext_pmt_party_id(+) and decode(ipiua0.instrument_type,'BANKACCOUNT',ipiua0.instrument_id)=ieba0.ext_bank_account_id(+) and decode(ipiua1.instrument_type,'BANKACCOUNT',ipiua1.instrument_id)=ieba1.ext_bank_account_id(+) and ieba0.branch_id=cbbv0.branch_party_id(+) and ieba1.branch_id=cbbv1.branch_party_id(+) and aps.party_id=hp.party_id(+) and assa.party_site_id=hps.party_site_id(+) and aps.party_id = zptp0.party_id (+) and 'THIRD_PARTY' = zptp0.party_type_code (+) and assa.party_site_id = zptp1.party_id (+) and 'THIRD_PARTY_SITE' = zptp1.party_type_code (+) order by haouv.name, aps.vendor_name, assa.vendor_site_code Y AR AP Suppliers موردي نقاط الوصول (بائعو نقاط البيع) بما في ذلك مواقع الموردين ومعلومات الاتصال والحساب المصرفي على مستوى البائع والموقع D AP Suppliers AP suppliers (po vendors) including supplier sites and contact information E AP Suppliers Proveedores de AP (vendedores de po), incluidos los sitios de los proveedores, la información de contacto y la cuenta bancaria a nivel de proveedor y de sitio F AP Suppliers Fournisseurs AP (po vendors), y compris les sites des fournisseurs, les coordonnées et les informations bancaires au niveau du fournisseur et du site I AP Suppliers Fornitori AP (po venditori) compresi i siti dei fornitori, il contatto e le informazioni sul conto bancario a livello di fornitore e di sito JA AP Suppliers APサプライヤー（POベンダー）は、サプライヤーのサイト、連絡先、ベンダーとサイトレベルの銀行口座情報を含む KO AP Suppliers 공급 업체 지점, 공급 업체 및 지점 레벨의 연락처 및 은행 계좌 정보를 포함한 AP 공급 업체 (PO 공급 업체) PTB AP Suppliers Fornecedores AP (po vendors) incluindo locais de fornecedores, informações de contato e de conta bancária em nível de fornecedor e local RU AP Suppliers AP-поставщики (po поставщики), включая сайты поставщиков, контактную информацию и информацию о банковском счете на уровне поставщика и сайта. S AP Suppliers AP-leverantörer (po-leverantörer) inklusive leverantörssidor, kontakt- och bankkontouppgifter på leverantörs- och webbplatsnivå TR AP Suppliers Tedarikçi siteleri, satıcı ve site düzeyinde iletişim ve banka hesabı bilgileri dahil olmak üzere AP tedarikçileri (satıcılar) US AP Suppliers AP suppliers (po vendors) including supplier sites, contact and bank account information on vendor and site level ZHS AP Suppliers 认可的供应商(po供应商)，包括供应商网站、供应商和网站一级的联系和银行账户信息。 Enginatics R12 only &contacts_columns &dff_columns &show_bank_accounts &show_contacts &site_bank_account &supplier_bank_account 1=1 2=2 3=3 4=4 1 10 1=1 haouv.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and 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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y F Unité d'exploitation US Operating Unit 2 20 1=1 aps.vendor_name=:supplier_name LOV AP Supplier B9847D20A0E4742FE0538931640A6379 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id F Fournisseur US Supplier 3 30 1=1 aps.segment1=:supplier_number LOV AP Supplier Number 8E2FF36EDF1479D2E0530100007F1FF2 Y select aps.segment1 value, aps.vendor_name description from ap_suppliers aps where :$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id) order by aps.segment1, aps.vendor_id F Numéro de fournisseur US Supplier Number 4 40 1=1 lower(aps.vendor_name) like lower(:vendor_name)||'%' Char F Le fournisseur commence par US Supplier starts with 5 50 1=1 aps.creation_date>=:creation_date_from Date US Creation Date From 6 60 1=1 aps.creation_date<:creation_date_to+1 Date last_day(:$flex$.creation_date_from) US Creation Date To 7 70 1=1 assa.vendor_site_code=:vendor_site_code LOV AP Supplier Site 8E2FF36EDF0279D2E0530100007F1FF2 Y select distinct assa.vendor_site_code value, assa.address_line1||', '||assa.city||', '||nvl(ftv.territory_short_name,assa.country) description from hr_all_organization_units_vl haouv, ap_suppliers aps, ap_supplier_sites_all assa, fnd_territories_vl ftv where (:$flex$.ap_supplier is null or xxen_util.contains(:$flex$.ap_supplier,aps.vendor_name)='Y') and (:$flex$.ap_supplier_number is null or xxen_util.contains(:$flex$.ap_supplier_number,aps.segment1)='Y') and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and haouv.organization_id=assa.org_id and aps.vendor_id=assa.vendor_id and assa.country=ftv.territory_code(+) order by assa.vendor_site_code F Site du fournisseur US Supplier Site 8 80 1=1 aps.vendor_type_lookup_code=xxen_util.lookup_code(:vendor_type,'VENDOR TYPE',201) LOV AP Supplier Type 98567A11CE2765ADE0530100007F6157 Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='VENDOR TYPE' and flvv.view_application_id=201 and flvv.security_group_id=0 order by flvv.lookup_code F Type de fournisseur US Supplier Type 9 90 1=1 ftv.territory_short_name=:country LOV Country 8E2FF36EDE8379D2E0530100007F1FF2 Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name F Pays US Country 10 100 &show_contacts Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher les contacts US Show Contacts 11 &contacts_columns pvc.prefix, pvc.first_name contact_first_name, pvc.middle_name contact_middle_name, pvc.last_name contact_last_name, pvc.title contact_title, pvc.area_code contact_area_code, pvc.phone contact_phone, pvc.email_address contact_email, pvc.inactive_date contact_inactive_date, F Afficher les contacts US Show Contacts 12 110 &show_bank_accounts Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show Bank Accounts 13 &site_bank_account iepa1.remit_advice_email site_remit_advice_email, ipiua1.order_of_preference site_priority, case when ipiua1.instrument_payment_use_id is not null and iepa1.supplier_site_id is not null then xxen_util.meaning('SITE','POS_SBD_BYR_USAGE_LIST',0) when ipiua1.instrument_payment_use_id is not null and iepa1.org_id is not null then xxen_util.meaning('ADDRESS_OU','POS_SBD_BYR_USAGE_LIST',0) when ipiua1.instrument_payment_use_id is not null and iepa1.party_site_id is not null then xxen_util.meaning('ADDRESS','POS_SBD_BYR_USAGE_LIST',0) else null end site_bank_assignment_level, ipiua1.end_date site_bank_acct_inactive_date, cbbv1.bank_name site_bank_name, cbbv1.bank_number site_bank_number, cbbv1.country site_bank_country, cbbv1.eft_swift_code site_swift_code, cbbv1.bank_branch_name site_bank_branch, cbbv1.branch_number site_branch_number, cbbv1.bank_branch_type site_branch_type, ieba1.masked_iban site_iban, ieba1.masked_bank_account_num site_bank_account, ieba1.currency_code site_currency_code, US Show Bank Accounts 14 &supplier_bank_account iepa0.remit_advice_email, ipiua0.order_of_preference priority, xxen_util.meaning('SUPPLIER','POS_SBD_BYR_USAGE_LIST',0) bank_assignment_level, ipiua0.end_date bank_account_inactive_date, cbbv0.bank_name, cbbv0.bank_number, cbbv0.country bank_country, cbbv0.eft_swift_code swift_code, cbbv0.bank_branch_name bank_branch, cbbv0.branch_number, cbbv0.bank_branch_type branch_type, ieba0.masked_iban iban, ieba0.masked_bank_account_num bank_account, ieba0.currency_code, US Show Bank Accounts 15 120 1=1 sysdate between nvl(aps.start_date_active,sysdate) and nvl(aps.end_date_active,sysdate) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Active Suppliers Only 16 130 2=2 nvl(assa.inactive_date,sysdate)>=sysdate LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Active Sites Only 17 140 3=3 nvl(pvc.inactive_date,sysdate)>=sysdate LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.show_contacts='Y' Y US Active Contacts Only 18 150 4=4 sysdate between ipiua.start_date and nvl(ipiua.end_date,sysdate) LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.show_bank_accounts='Y' Y US Active Bank Accounts Only 19 160 &dff_columns select xxen_util.dff_columns(p_table_name=>'po_vendors',p_table_alias=>'aps',p_column_name_prefix=>'Supplier: ',p_display_mode=>:dff_display) from dual union all select xxen_util.dff_columns(p_table_name=>'ap_supplier_sites_all',p_column_name_prefix=>'Site: ',p_display_mode=>:dff_display) from dual LOV custom Y select 'V' id, 'Value' value, 'Value only' description from dual union all select 'C' id, 'Value: Description' value, 'Concatenated value and description' description from dual union all select 'S' id, 'Value, Description' value, 'Value and description in separate columns' description from dual fnd_profile.value('XXEN_REPORT_DFF_DISPLAY') US DFF Display :$flex$.ap_supplier Supplier Supplier Site :$flex$.ap_supplier_number Supplier Number Supplier Site :$flex$.creation_date_from Creation Date From Y Creation Date To :$flex$.operating_unit Operating Unit Supplier :$flex$.operating_unit Operating Unit Supplier Number :$flex$.operating_unit Operating Unit Supplier Site :$flex$.show_bank_accounts Show Bank Accounts Active Bank Accounts Only :$flex$.show_contacts Show Contacts Active Contacts Only 494DE7F4FBD8A6441201A5C5DEC55B71 ANHNTT01 ERIC.CLEGG 35 ADDRESS_LINE1 36 ADDRESS_LINE2 37 ADDRESS_LINE3 38 ADDRESS_LINE4 27 ADDRESS_NAME 14 ALLOW_WITHHOLDING_TAX 4 ALTERNATE_SUPPLIER 45 AREA_CODE 72 BANK_ACCOUNT 68 BANK_BRANCH 66 BANK_COUNTRY 64 BANK_NAME 65 BANK_NUMBER 61 BILLS_PAYABLE_ACCOUNT 69 BRANCH_NUMBER 70 BRANCH_TYPE 39 CITY 44 COUNTRY 42 COUNTY 73 CURRENCY_CODE 19 CUSTOMER_NUM 50 EMAIL_ADDRESS -23.0024 END_DATE_ACTIVE 48 FAX 47 FAX_AREA_CODE 12 FEDERAL_REPORTABLE 34 FREE_ON_BOARD_CODE 33 FREIGHT_TERMS 22 HOLD_FLAG 71 IBAN 8 INCOME_TAX_TYPE 15 INV_WITHHOLDING_TAX_GROUP 59 LIABILITY_ACCOUNT 24 MIN_ORDER_AMOUNT 1 OPERATING_UNIT 17 PARENT_SUPPLIER_NAME 18 PARENT_SUPPLIER_NUMBER 58 PAYMENT_METHOD 54 PAYMENT_TERMS 53 PAY_DATE_BASIS 52 PAY_GROUP 31 PAY_SITE 16 PAY_WITHHOLDING_TAX_GROUP 46 PHONE 60 PREPAYMENT_ACCOUNT 25 PRICE_TOLERANCE 28 PRIMARY_PAY_SITE 63 PRIORITY 32 PROCUREMENT_CARD 43 PROVINCE 23 PURCHASING_HOLD_REASON 29 PURCHASING_SITE 62 REMIT_ADVICE_EMAIL 30 RFQ_ONLY 55 SITE_ALLOW_WITHHOLDING_TAX 86 SITE_BANK_ACCOUNT 82 SITE_BANK_BRANCH 80 SITE_BANK_COUNTRY 78 SITE_BANK_NAME 79 SITE_BANK_NUMBER 83 SITE_BRANCH_NUMBER 84 SITE_BRANCH_TYPE 26 SITE_CODE 93 SITE_CREATED_BY 92 SITE_CREATION_DATE 87 SITE_CURRENCY_CODE 85 SITE_IBAN 56 SITE_INV_WITHHOLDING_TAX_GROUP 95 SITE_LAST_UPDATED_BY 94 SITE_LAST_UPDATE_DATE 75 SITE_PAYMENT_METHOD 74 SITE_PAYMENT_TERMS 57 SITE_PAY_WITHHOLDING_TAX_GROUP 77 SITE_PRIORITY 76 SITE_REMIT_ADVICE_EMAIL 81 SITE_SWIFT_CODE 21 SMALL_BUSINESS 40 STATE 13 STATE_REPORTABLE 2 SUPPLIER 89 SUPPLIER_CREATED_BY 88 SUPPLIER_CREATION_DATE 91 SUPPLIER_LAST_UPDATED_BY 90 SUPPLIER_LAST_UPDATE_DATE 49 SUPPLIER_NOTIF_METHOD 3 SUPPLIER_NUMBER 67 SWIFT_CODE 6 Supplier: Supplier Home Page 9 TAXPAYER_ID 10 TAX_REGISTRATION_NUMBER 11 TAX_REPORTING_NAME 51 TERMS_DATE_BASIS 5 TRADING_PARTNER 7 TYPE 20 VAT_CODE 96 VENDOR_ID 97 VENDOR_SITE_ID 41 ZIP ADDRESS_LINE1 COLUMN 8 ADDRESS_NAME COLUMN 6 OPERATING_UNIT COLUMN 1 SITE_CODE COLUMN 7 SUPPLIER COLUMN 3 SUPPLIER_NUMBER COLUMN 2 TAX_REGISTRATION_NUMBER COLUMN 5 TYPE COLUMN 4 S Site HAI.LE 494DE7F4FBD8A6441201A5C5DEC55B71