Important Tables and colums in GL,AP,AR,PO and HRMS

Important Tables and colums in GL,AP,AR,PO and HRMS

Gl_CODE_CONMBINATIONS,-CODE_COMBINATION_ID.
-CART_OF _ACCOUNTS_ID.
-DETAIL_POSTING_ALLOWED_FLAG.
-ACCOUNT_TYPE.
-TEMPLATE_ID.
SEGMENT1,SEGMENT2,GL_BALANCES
-SET_OF_BOOKS_ID,
-CURRENCY_CODE,
-CODE_COMBINATION_ID,
-ACTUAL_FLAG,
-PERIOD_NET_DR
-PERIOD_NET_CRGL_LOOKUPS-LOOKUP_TYPE,
-LOOKUP_CODE,
-MEANING,
-DESCRIPTION,
-ENABLED FLAG,
-START_DATE_ACTIVE,
-END_DATE_ACTIVE,
-description ACCT_TYPE,
GL_SETS_OF_BOOKS
-SET_OF_BOOKS_ID,
-CURRENCY_CODE,
-CHART_OF_ACCOUNTS_ID,
-NAME,
-PERIOD_SET_NAME,
-DESCRIPTION,
GL_PERIOD_SETS
-PERIOD_SET_NAME,
-DESCRIPTION,
-ATTRIBUTES1
-PERIOD_SET_ID.AP_PAYMENT_SCHEDULES-INVOICE_ID,
-PAYMENT_CROSS_RATE,
-PAYMENT_NUM,
-AMOUNT_REMAINING,
-DUE_DATE,
-FUTURE_PAY_DUE_DATE,
-GROSS_AMOUNT,
-PAYMENT_METHOD,
-PAYMENT_PRIORITY,
-PAYMENT_STATUS
AP_INVOICE_ALL
-INVOICE_ID,
-VENDOR_ID,
-INVOICE_NUM,
-SET_OF_BOOKS_ID,
-INVOICE_CURRENCY_CODE,
-PAYMENT_CURRENCY_CODE,
-INVOICE_AMOUNT
-VEODOR_SITE_ID,
-AMOUNT_PAID.
PO_VENDORS
-VENDOR_ID,
-VENDOR_NAME,
-SEGMENT1,
-SUMMARY_FLAG,
-ENABLED_FLAG,
-EMPLOYEE_ID,
-VENDOR_TYPE_LOOKUP_CODE,
-SHIP_LOCATION_ID.
PO_VENDOR_SITES
-ADDRESS_STYLE,
-LANGUAGE,
-PROVINCE,
-COUNTRY,
-AREA_CODE,
-PHONE,
-SHIP_TO_LOCATION,
-BILL_TO_LOCATION,
-PAYMENT_METHOD,
-BANK_ACCT_METHOD,
-BANK_ACCT_NAME,
-BANK_ACCT_NUMBERAP_LOOKUP_CODES-LOOKUP_TYPE,
-LOOKUP_CODE,
-DISABLED_FIELD,
-DESCRIPTION
-ENABLED_FLAG,
AP_DOC_SEQUENCE_AUDIT
-DOC_SEQUENCE_ID,
-DOC_SEQUENCE_ASSIGNMENT_ID,
-DOC_SEQUENCE_VALUE,
-CAREATION_DATE,
-CREATED_BY
FND_DOC_SEQUENCE_ASSIGNMENTS
-DOC_SEQUENCE_ASSIGNMENT_ID,
-CAREATED_BY,
-APPLICATION_ID,
-DOC_SEQUENCE_ID,
-CATEGORY_CODE,
-SET_OF_BOOKS_ID
-METHOD_CODE,FND_COLUMNS-APPLICATION_ID,
-TABLE_ID,
-COLUMN_ID,
-COLUMN_NAME,
-USER_COLUMN_NAME,
-COLUMN_SEQUENCE,
-WIDTH,
-NULL_ALLOWED_FLAG,
-TRANSFLATE_FLAG,
FLEXFILED_USAGE_CODE,
-DESCRIPTION.
RA_CUSTOMERS
-ROW_ID
-CUSTOMER_ID,
-PARTY_ID,
-PARTY_NUMBER,
PARTY_TYPE,
CUSTOMER_NAME,
-CUSTOMER_NUMBER
-ORIG_SYSTEM_NUMBER.
-STATUS,
-CUSTOMER_TYPE,
RA_ADRESS_ALL
-ROW_ID,
-PARTY_SITE_ID,
-PARTY_ID
-PARTY_LOCATION_ID,
KEY_ACCOUNT_FLAG,
-PROGRAM_UPDATE_DATE,
-TERRITORY _ID,
-ADDRESS_KEY,
RA_SITE_USES_ALL
-SITE_USE_ID,
-SITE_USE_CODE,
-ADDRESS_ID,
PRIMARY_KEY,
-STATUS,
-LOCATION,
-CONTACT_ID,
-BILL_TO_SITE_USE_ID,
-ORIG_SYSTEM_REFERENCE,
-WAREHOUSE_ID,
-ORDER_TYPE_ID,AR_PAYMENT_SCHEDULES-PAYMENT_SCHEDULE_ID,
-DUE_DATE,
-AMOUNT_DUE_ORIGINAL,
AMOUNT_REMAINING,
-NUMBER_OF_DUE_DATES,
-STATUS,
-INVOICE_CURRENCY_CODE,
CUST_TRX_TYPE_ID,
-CUSTOMER_ID,
-CUSTOMER_TRX_ID
AR_CASH _RECEIPTS_V
-ROW_ID,
-CASH_RECEIPT_ID,
-AMOUNT,
-FUNCTIONAL_AMOUNT,
-NET_AMOUNT,
-CURRENCY_CODE,
-RECEIPT_NUMBER,
-RECEIPT_DATE,
-TYPE.
RA_CUSTOMER_TRX_PARTIAL_V
-ROW_ID,
-CUSTOMER_TRX_ID,
-TRX_NUMBER,
-OLD_TRX_NUMBER,
-TRX_DATE,
-TERM_DUE_DATE,
-INITIAL_CUSTOMER_TRX_ID,
-BATCH_ID,
-TERM_ID
RA_CUSTOMER_TRX_LINES_V
-ROW_ID,
-CUSTOMER_TRX_LINE_ID,
-CUSTOMER_TRX_ID,
-DESCRIPTION.
RA_PAYMENTS_SCHEDULES_ALL
-PAYMENT_SCHEDULE_ID,
-DUE_DATE,
-AMOUNT_DUE_ORIGINAL,
-AMOUNT_DUE_REMAINING,
-NUMBEr_OF_DUE_DATES,
-STATUS,
-INVOICE_CURRENCY_CODE,
-CLASS,
-TERMD_ID.
RA_CUSTOMER_TRX_ALL
-CUSTOMER_TRX_ID,
-TRX_NUMBER,
-CUSTOMER_TRX_TYPE_ID,
-TRX_DATE,
-SET_OF_BOOKS_ID,
-BILL_TO_CONTACT_ID,
-BATCH_ID,
-SHIP_TO_CUSTOMER_ID,
-SHIP_TO_SITE_USE_ID.
AR_CUSTOMER_PROFILES
-CUSTOMER_PROFILE_ID,
-CUSTOMER_ID,
-STATUS,
COLLECTOR_ID,
-CREDIT_CHECKING
-TOLERANCE,
-CUSTOMER_PROFILE_CLASS_ID,
-SITE_USE_ID,
-CREDIT_RATING
HRMS TABLES BY SCREEN WISE.
================================PEOPLE(SCREEN)
-ENTER AND MAINTAINPER_PEOPLE_V
PER_ADDRESS_V --------ADDRESSES OF EMPLOYEES
PER_IMAGES -------STORES EMPLOYEE PHOTOS
PER_ASSIGNMENTS_V ------STORES_ASSIGNMENTS
PER_PAY_PROPOSALS_V2 –STOES SALARIES
PAY_PAYWISE_ELEMENT_ENTRIES---ENTRIES
PER_SPEICAL_INFO_TYPES_VS ---SPECIAL INFORMWORKSTRUCTURES
LOCATIONS
-HR_LOCATIONS_VORGANIZATION-HR_ORGANIZATION_UNITS_V
HIERARCHY
-PER_ORGANIZATION_STRUCTURES_VJOBS-PER_JOBS_VL
CAREER PATHS
-PER_CAREER_PATHSPAYROLLS
DESCRIPTION-PAY_PAYROLLS_V2PAYMENT METHOD-PAY_ORG_PAYMENT_METHODS_V
GL MAPPING SEGMENT
-PAY_PAYWSPGL_PAYROLLS
PER_PEOPLE_V
Person_id,employee_number,full_name,nationality,
Business_group_id,marital_status,original_date_of_hire,sex,
Current_employee_flag,effective_start_date,effective_end_date,title.PER_ALL_ASSIGNMENTS_FAssignment_id,Person_id,Job_id,Grade_id,Organoization_id
Business_group_id,Location_id,Supervisor_id,Position_id,
Recruiter_id,Primary_Flag,Effective_start_date,Effective_end_date,,
Payroll_id.
PER_JOBS HR_ALL_POSITIONS_F
Job_id,Business_group_id Psotion_id,Business_grouip_id,
Job_definition_id,Name, Position_defintion_id,Name,
status,Date_from Status,Date_from
PER_GRADES
Postion_id,
Business_grouip_id,
Position_defintion_id,
Name,satus,Date_from
PER_JOB_DEFINITIONS
Job_definition_idPER_GRADE_DEFINITIONSSummary_flag, Grade_definition_id,
Segment1, Summary_flag,
Segment2, Segment1
Enabled_flag Segment2
Enablled_Flag
PER_ADDRESSES_V
(It stores all the address and contact details of every Employee.The primary column is Row_id)
Columns: row_id,address_id,business_group_id,person_id,Priamry_flag,style,address_line1,
address_line2,address_type,postal_code
PER_IMAGESLIt stores the photo images of Employee by maintaining link to the per_people_f table .Images are stored in the in the format of BLOB)
Columns: Row_id,special_information_types,business_group_id,id_flex_num,Name,Enabled_Flag etc.PAY_PAYWSMEE_ELEMENT_ENTRIES(It Stores the elements)
Columns: Element_entry_id,Assignment_id,Effective_start_date,Effective_end_date,
Element_link_id,Original_entry_id ETC,PAY_PAYROLLS_F:(Stores payroll type)Columns: Payroll_id, _id,Effective_start_date,Effective_end_date,default_payment_method_id,
Business_group_id,period_type,payroll_name,gl_set_books_id.
PER_TIME_PERIODS_V(Stores the period of payroll)
Columns: row_id,time_period,payroll_id.
HR_LOCATIONS
Location_id,Location_code,business_group_id,description_style,Address_line1,Address_line2
Town_or_City,Country,ship_to_location_id.
HR_ALL_ORGANIZATION_UNITS
Organization_id,Business_group_id,Location_id,Date_from,Name,type,Internal_External_flagHR_ALL_POSITIONS_FPosition_id,Effective_start_date,Effective_end_date,business_group_id,Job_id,Location_id,
Organization_id,Date_Effecticve,Name,Permanent_Temporary_Flag,Position_type.PER_PERSON_ANALYSES(It stores special information types SIT)
Analysis_criteria_idHR_LOCATIONSLOCATION_ID,Location_code,Business_group_id,Description_style,Address_line1,
Address_line2,Town_or_city,Country,Ship_to_Location_id.
HR_ALL_ORGANIZATIONS_UNITS
Organization_id,Business_group_id,Location_id,Date_from,Name,Type,
Internal_Eternal_Flag
HR_ALL_PEOPLE_F
Position_f,Effective_start_date,Effective_end_dateBusiness_group_id,Job_id,Location_id,Organization_id,Date_Effective,Name,Permanent_temporary_flag,Position_type. PER_ALL_PEOPLE_F
Person_id