R12: FAQ for Table.

Q. What Are The Tables That Replaced RA_CUSTOMERS, RA_ADDRESSES_ALL and RA_SITE_USES ?
A. Following tables on the left are replaced with the tables on the right
RA_CUSTOMERS => HZ_CUST_ACCOUNTS
RA_ADDRESSES_ALL => HZ_LOCATIONS
RA_SITE_USES_ALL => HZ_CUST_SITE_USES_ALL


Q. What Are The Tables That Replaced AP_BANK_ACCOUNTS_ALL, AP_BANK_ACCOUNT_USES_ALL and AP_CHECK_STOCKS_ALL ?
A. Now Bank functionality moved to Cash Management.
Following tables on the left are replaced with the tables on the right
AP_BANK_ACCOUNTS_ALL => CE_BANK_ACCOUNTS
AP_BANK_ACCOUNT_USES_ALL => CE_BANK_ACCT_USES_ALL
AP_CHECK_STOCKS_ALL => CE_PAYMENT_DOCUMENTS

Q. Which are all the columns Obsoleted in RA_INTERFACE_LINES_ALL?
A. The following columns of the AutoInvoice interface table RA_INTERFACE_LINES_ALL have become obsolete in R12:

    CUSTOMER_BANK_ACCOUNT_ID
    CUSTOMER_BANK_ACCOUNT_NAME
    PAYMENT_SERVER_ORDER_NUM
    APPROVAL_CODE

Instead of these fields, Autoinvoice requires you to populate the PAYMENT_TRXN_EXTENSION_ID. You can obtain this by calling the IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension before populating the Autoinvoice tables.