be happy and make others to be happy: AR R12 Tables

AR R12 Tables

New Tables

Description of Change

AR_REC_TRX_LE_DETAILS_ALL

Added detail level table under AR_RECEIVABLES_TRX_ALL to record the relationship between a receivables activity and the sets of asset and liability tax codes by legal entity.

AR_DEFERRAL_REASONS

Revenue Deferral Reasons

AR_DEFERRED_LINES_ALL

Revenue Deferral Reasons

AR_RDR_PARAMETERS_GT

Revenue Deferral Reasons

AR_REVIEWED_LINES_GT

Revenue Deferral Reasons

Changed Tables

Table Name

Description of Change

RA_CUSTOMER_TRX_LINES_ALL

Added numerous columns to support E-Business Tax and line-level Ship To, Added Payment extension identifier.

AR_MEMO_LINES

Added tax_product_category to support E-Business Tax uptake.

AR_TRX_LINES_GT

Added numerous columns to support E-Business Tax uptake, Added parent_line_id and deferral_exclusion_flag.

AR_TRX_LINES_TMP_GT

Added numerous columns to support E-Business Tax uptake, Added parent_line_id and deferral_exclusion_flag.

AR_ARCHIVE_DETAIL

Added numerous columns to support E-Business Tax and line-level Ship To,

RA_BATCH_SOURCES_ALL

Obsoleted invalid_tax_rate_rule column.

HZ_CUST_SITE_USES

Migrated tax_code, tax_header_level_flag, tax_reference, and tax_classification to ZX_PARTY_TAX_PROFILE and ZX_REGISTRATIONS tables.

AR_CASH_RECEIPTS_ALL

Added Payment extension identifier and obsoleted, approval_code,

address_verification_code, payment_server_order_num, Renamed column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID, Added legal_entity_id column.

AR_RECEIPT_METHODS

Added Payment Channel Code and obsoleted, payment_type_code, merchant_ref, merchant_id, auto_print_program_id

RA_CUSTOMER_TRX_ALL

Added Payment extension identifier and Payment Attributes,

obsoleted payment_server_order_num, approval_code, address_verification_code, Renamed column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID, Added legal_entity_id column.

RA_INTERFACE_LINES_ALL

Added Payment extension identifier and Payment Attributes, and obsoleted payment_server_order_num, approval_code,address_verification_code, Added legal_entity_id column, Added parent_line_id and deferral_exclusion_flag.

AR_AUTOREC_EXCEPTIONS

Renamed column REMIT_BANK_ACCT_ID to REMIT_BANK_ACCT_USE_ID

AR_BATCHES_ALL

Renamed column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID

AR_BATCH_SOURCES_ALL

Renamed column DEFAULT_REMIT_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID

AR_INTERIM_CASH_RECEIPTS_ALL

Renamed column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID

AR_RECEIPT_METHOD_ACCOUNTS_ALL

Renamed column BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID

AR_TRX_HEADER_GT

Added legal_entity_id column

AR_TRX_HEADER_TMP_GT

Added legal_entity_id column

AR_LINE_CONTS_ALL

Added contingency_id as a foreign key to AR_DEFERRAL_REASONS

AR_TRX_CONTINGENCIES_GT

Added contingency_id, expiration_event_date and completed_flag.

Obsolete Tables

Table Name

AR_TA_ASGN_TO_INT_ALL

AR_TA_CASHAPP_OB_ALL

AR_TA_CR_AGEN_INF_ALL

AR_TA_CUST_HIER_CHILD

AR_TA_CUST_HIER_PARNT

AR_TA_CUST_INT_ALL

AR_TA_CUST_TRXSTR_ALL

AR_TA_DEDN_ASSGNS_ALL

AR_TA_DEDN_INT_ALL

AR_TA_DEDN_RELATE_ALL

AR_TA_LEGACY_CUST_INT

AR_TA_LEGACY_STAT_INT

AR_TA_PAYMNT_HIST_ALL

AR_TA_PROF_ASSGNT_ALL

AR_TA_PROMOTIONS_ALL

AR_TA_PROMOTIONS_INT

AR_TA_PROM_CUST_ALL

AR_TA_PROM_CUST_MAP

AR_TA_PROM_LINES_INT

AR_TA_PROM_PAYMNT_ALL

AR_TA_PROM_PAYMNT_TYP

AR_TA_PROM_PRODS_ALL

AR_TA_PROM_STATUS_MAP

AR_TA_RECON_INFO_ALL

AR_TA_RECV_TRXSET_ALL

AR_TA_REMIT_HIST_ALL

AR_TA_REMIT_PROF_ALL

AR_TA_RISK_COMENT_ALL

AR_TA_RULES_ALL

AR_TA_RULE_OUTPUT

AR_TA_RULE_SETS_ALL

AR_TA_RULE_SET_LN_ALL

AR_TA_TRX_SETS_ALL

AR_TA_TRX_SET_LN_ALL

AR_TA_TRX_TO_CREATE

AR_TA_TRX_TYP_INT_ALL

AR_TA_VERSIONS

New Views

View Name

Description of Change

AR_MEMO_LINES_VL

Added tax_product_category.

AR_SHIP_ADDRESS_V

Removed hz_loc_assignments.

RA_CUSTOMER_TRX_LINES_V

Added numerous columns

AR_DOCS_RECEIVABLES_V

AR_FUNDS_CAPTURE_ORDERS_V

ARBR_DOCS_RECEIVABLES_V

ARBR_DOCUMENT_LINES_V

ARBR_FUNDS_CAPTURE_ORDERS_V

AR_CBA_BANK_BRANCH_CONTACTS_V

AR_CBA_BANK_ACCOUNT_CONTACTS_V

AR_CBA_EFT_USER_NUMBER_V

AR_LINE_DEFERRAL_REASONS

Revenue Deferral Reasons

AR_LINE_CONTINGENCIES_V

Revenue Deferral Reasons

AR_RDR_ITEMS_V

Reasons, Validation Set for RDR setup

Changed Views

View Name

Description of Change

AR_AUTOMATIC_RECEIPTS_FORMAT_V

Added Payment extension identifier & payment channel code to view. Also modified the view to accommodate the data model changes related to payment uptake project.

AR_BOE_AUTO_RECEIPTS_V

Added Payment extension identifier to view

AR_BOE_REMIT_RECEIPTS_CBUNR_V

Added Payment extension identifier & payment channel code to view. Also modified the view to accommodate the data model changes related to payment uptake project.

AR_BOE_REMIT_RECEIPTS_NONCBR_V

Added Payment extension identifier & payment channel code to view. Also modified the view to accommodate the data model changes related to payment uptake project.

AR_BOE_REMIT_RECEIPTS_V

Modified the view to accommodate the data model changes related to payment uptake project

AR_BR_ASSIGNMENTS_V

Modified the view to accommodate the data model changes related to payment uptake project

AR_BR_MAIN_REMIT_BATCH_V

Modified the view to accommodate the data model changes related to payment uptake project

AR_CASH_RECEIPTS_V

Added Payment extension identifier and payment channel identifier to view

AR_CUSTOMER_BILLS_TRX_V

Added Payment extension identifier and payment channel identifier to view

AR_REMITTED_RECEIPTS_FORMAT_V

Added Payment extension identifier & payment channel code to view. Also modified the view to accommodate the data model changes related to payment uptake project.

RA_CUSTOMER_TRX_CM_V

Modified the view to accommodate the data model changes related to payment uptake project

Added Payment extension identifier and the payment channel identifier to view

RA_CUSTOMER_TRX_PART_CB_V

Modified the view to accommodate the data model changes related to payment uptake project

Added Payment extension identifier and the payment channel identifier to view

RA_CUSTOMER_TRX_PARTIAL_V

Modified the view to accommodate the data model changes related to payment uptake project

Added Payment extension identifier and the payment channel identifier to view

AR_AEL_GL_REC_V