Sunday, May 18, 2014

AR Invoice Mandatory Columns

select *
  from all_objects
 where object_type = 'TABLE'
   and object_name like 'RA_%'
   and owner = 'AR';
 
 
Base Tables:
================

select * from RA_CUSTOMER_TRX_ALL where trunc(creation_date) = trunc(sysdate);

select * from RA_CUSTOMER_TRX_LINES_ALL where trunc(creation_date) = trunc(sysdate);



Interface Tables:
=================


select * from RA_INTERFACE_LINES_ALL where trunc(creation_date) = trunc(sysdate);


select * from RA_INTERFACE_DISTRIBUTIONS_ALL where trunc(creation_date) = trunc(sysdate);


Error Table:
==============
RA_INTERFACE_ERRORS_ALL

Mandatory Columns:
====================

select COLUMN_NAME
  from all_tab_cols
 where table_name = 'RA_CUSTOMER_TRX_ALL'
   and nullable = 'N';
 
COMPLETE_FLAG
CREATED_FROM
CUSTOMER_TRX_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
TRX_NUMBER
CUST_TRX_TYPE_ID
TRX_DATE
SET_OF_BOOKS_ID

select COLUMN_NAME
  from all_tab_cols
 where table_name = 'RA_CUSTOMER_TRX_LINES_ALL'
   and nullable = 'N';
 
CUSTOMER_TRX_LINE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
CUSTOMER_TRX_ID
LINE_NUMBER
SET_OF_BOOKS_ID
LINE_TYPE
EXTENDED_AMOUNT

select COLUMN_NAME
  from all_tab_cols
 where table_name = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
   and nullable = 'N';
 
CUST_TRX_LINE_GL_DIST_ID
CODE_COMBINATION_ID
SET_OF_BOOKS_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
POSTING_CONTROL_ID
ACCOUNT_CLASS
CUSTOMER_TRX_ID
ACCOUNT_SET_FLAG


interface mandatory columns:
==============================

select COLUMN_NAME
  from all_tab_cols
 where table_name = 'RA_INTERFACE_LINES_ALL'
   and nullable = 'N';
 
BATCH_SOURCE_NAME
LINE_TYPE
DESCRIPTION
CURRENCY_CODE
CONVERSION_TYPE


select COLUMN_NAME
  from all_tab_cols
 where table_name = 'RA_INTERFACE_DISTRIBUTIONS_ALL'
   and nullable = 'N';
 
ACCOUNT_CLASS

No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...