Supplier Conversion

[satyaram.satya]

Hi All,

Anyone please tell me the mandatory/minimum columns for supplier conversion, below are the interface tables for supplier interface.

AP_SUPPLIERS_INT
AP_SUPPLIER_SITES_INT
AP_SUP_SITE_CONTACT_INT

Thank you,
Regards,
Satyaram.

[djef_lat@hotmail.com]

Satyaram,

These will be a good example for you I think:

Regards,

Djef

insert into ap_suppliers_int
( vendor_name
, invoice_currency_code
, payment_currency_code
, num_1099
, vendor_interface_id
, TERMS_NAME
, status
, payment_method_lookup_code
, pay_group_lookup_code
)
values
( vendor_t(rec).vendor_name
, vendor_t(rec).currency_code
, vendor_t(rec).currency_code
, vendor_t(rec).num_1099
, AP_SUPPLIERS_INT_S.nextval
, '30'
, 'NEW'
, vendor_t(rec).vendor_number
, l_payment_method
, vendor_t(rec).pay_group_lookup_code
);

insert into ap_supplier_sites_int
( address_line1
, address_line2
, address_line3
, address_line4
, zip
, city
, vendor_site_code
, country
, state
, county
, purchasing_site_flag
, pay_site_flag
, org_id
, primary_pay_site_flag
, status
, vendor_site_interface_id
, vendor_interface_id
, payment_method_lookup_code
, pay_group_lookup_code
)
values
( l_streetname
, l_housenr
, l_housenr_add
, vendor_t(rec).address4
, vendor_t(rec).postal_code
, vendor_t(rec).city
, l_vendor_site_code
, vendor_t(rec).country
, vendor_t(rec).state
, vendor_t(rec).city
, 'Y'
, 'Y'
, g_org_id
, 'Y'
, 'NEW'
, ap_supplier_sites_int_s.NEXTVAL
, AP_SUPPLIERS_INT_S.CURRVAL
,l_payment_method
, vendor_t(rec).pay_group_lookup_code
);

insert into iby_temp_ext_bank_accts
( bank_account_num
, country_code
, iban
, bic
, TEMP_EXT_BANK_ACCT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, OBJECT_VERSION_NUMBER
, CALLING_APP_UNIQUE_REF1
, CALLING_APP_UNIQUE_REF2
, foreign_payment_use_flag
, bank_id
, bank_name
, branch_id
, branch_name
)
values
( vendor_t(rec).bank_account
, vendor_t(rec).bank_account_country_code
, vendor_t(rec).iban
, vendor_t(rec).bic
, IBY_TEMP_EXT_BANK_ACCTS_S.nextval
, g_sysdate
, g_user_id
, g_sysdate
, g_user_id
, 1
, AP_SUPPLIERS_INT_S.CURRVAL
, ap_supplier_sites_int_s.CURRVAL
, 'Y'
, l_bank_id
, l_bank_name
, l_branch_id
, l_branch_name
);

[satyaram.satya]

Hi Djef,

I have inserted the data in the columns as given by you, but the status in the table AP_SUPPLIER_SITES_INT shows me REJECTED and when I check the table AP_SUPPLIER_INT_REJECTIONS I couldn't find any records.

Please help me in this issue.

Thank you,
Regards,
Satyaram