Oracle receivables:
New Tables
• 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
• AR_DEFERRED_LINES_ALL
• AR_RDR_PARAMETERS_GT
• AR_REVIEWED_LINES_GT
Changed Tables
• 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.
• RA_BATCH_SOURCES_ALL Obsoleted invalid_tax_rate_rule column.
• HZ_CUST_SITE_USES
• 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_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.
New Tables
• 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
• AR_DEFERRED_LINES_ALL
• AR_RDR_PARAMETERS_GT
• AR_REVIEWED_LINES_GT
Changed Tables
• 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.
• RA_BATCH_SOURCES_ALL Obsoleted invalid_tax_rate_rule column.
• HZ_CUST_SITE_USES
• 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_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.
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.