SQL> desc ra_customer_trx_all; Name Null? Type ----------------------------------------- -------- ---------------------------- CUSTOMER_TRX_ID NOT NULL NUMBER(15) LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER(15) CREATION_DATE NOT NULL DATE CREATED_BY NOT NULL NUMBER(15) LAST_UPDATE_LOGIN NUMBER(15) TRX_NUMBER NOT NULL VARCHAR2(20) CUST_TRX_TYPE_ID NOT NULL NUMBER(15) TRX_DATE NOT NULL DATE SET_OF_BOOKS_ID NOT NULL NUMBER(15) BILL_TO_CONTACT_ID NUMBER(15) BATCH_ID NUMBER(15) BATCH_SOURCE_ID NUMBER(15) REASON_CODE VARCHAR2(30) SOLD_TO_CUSTOMER_ID NUMBER(15) SOLD_TO_CONTACT_ID NUMBER(15) SOLD_TO_SITE_USE_ID NUMBER(15) BILL_TO_CUSTOMER_ID NUMBER(15) BILL_TO_SITE_USE_ID NUMBER(15) SHIP_TO_CUSTOMER_ID NUMBER(15) SHIP_TO_CONTACT_ID NUMBER(15) SHIP_TO_SITE_USE_ID NUMBER(15) SHIPMENT_ID NUMBER(15) REMIT_TO_ADDRESS_ID NUMBER(15) TERM_ID NUMBER(15) TERM_DUE_DATE DATE PREVIOUS_CUSTOMER_TRX_ID NUMBER(15) PRIMARY_SALESREP_ID NUMBER(15) PRINTING_ORIGINAL_DATE DATE PRINTING_LAST_PRINTED DATE PRINTING_OPTION VARCHAR2(20) PRINTING_COUNT NUMBER(15) PRINTING_PENDING VARCHAR2(1) PURCHASE_ORDER VARCHAR2(50) PURCHASE_ORDER_REVISION VARCHAR2(50) PURCHASE_ORDER_DATE DATE CUSTOMER_REFERENCE VARCHAR2(30) CUSTOMER_REFERENCE_DATE DATE COMMENTS VARCHAR2(1760) INTERNAL_NOTES VARCHAR2(240) EXCHANGE_RATE_TYPE VARCHAR2(30) EXCHANGE_DATE DATE EXCHANGE_RATE NUMBER TERRITORY_ID NUMBER(15) INVOICE_CURRENCY_CODE VARCHAR2(15) INITIAL_CUSTOMER_TRX_ID NUMBER(15) AGREEMENT_ID NUMBER(15) END_DATE_COMMITMENT DATE START_DATE_COMMITMENT DATE LAST_PRINTED_SEQUENCE_NUM NUMBER(15) ATTRIBUTE_CATEGORY VARCHAR2(30) ATTRIBUTE1 VARCHAR2(150) ATTRIBUTE2 VARCHAR2(150) ATTRIBUTE3 VARCHAR2(150) ATTRIBUTE4 VARCHAR2(150) ATTRIBUTE5 VARCHAR2(150) ATTRIBUTE6 VARCHAR2(150) ATTRIBUTE7 VARCHAR2(150) ATTRIBUTE8 VARCHAR2(150) ATTRIBUTE9 VARCHAR2(150) ATTRIBUTE10 VARCHAR2(150) ORIG_SYSTEM_BATCH_NAME VARCHAR2(40) POST_REQUEST_ID NUMBER(15) REQUEST_ID NUMBER(15) PROGRAM_APPLICATION_ID NUMBER(15) PROGRAM_ID NUMBER(15) PROGRAM_UPDATE_DATE DATE FINANCE_CHARGES VARCHAR2(1) COMPLETE_FLAG NOT NULL VARCHAR2(1) POSTING_CONTROL_ID NUMBER(15) BILL_TO_ADDRESS_ID NUMBER(15) RA_POST_LOOP_NUMBER NUMBER(15) SHIP_TO_ADDRESS_ID NUMBER(15) CREDIT_METHOD_FOR_RULES VARCHAR2(30) CREDIT_METHOD_FOR_INSTALLMENTS VARCHAR2(30) RECEIPT_METHOD_ID NUMBER(15) ATTRIBUTE11 VARCHAR2(150) ATTRIBUTE12 VARCHAR2(150) ATTRIBUTE13 VARCHAR2(150) ATTRIBUTE14 VARCHAR2(150) ATTRIBUTE15 VARCHAR2(150) RELATED_CUSTOMER_TRX_ID NUMBER(15) INVOICING_RULE_ID NUMBER(15) SHIP_VIA VARCHAR2(30) SHIP_DATE_ACTUAL DATE WAYBILL_NUMBER VARCHAR2(50) FOB_POINT VARCHAR2(30) CUSTOMER_BANK_ACCOUNT_ID NUMBER(15) INTERFACE_HEADER_ATTRIBUTE1 VARCHAR2(30) INTERFACE_HEADER_ATTRIBUTE2 VARCHAR2(30) INTERFACE_HEADER_ATTRIBUTE3 VARCHAR2(30) INTERFACE_HEADER_ATTRIBUTE4 VARCHAR2(30) INTERFACE_HEADER_ATTRIBUTE5 VARCHAR2(30) INTERFACE_HEADER_ATTRIBUTE6 VARCHAR2(30) INTERFACE_HEADER_ATTRIBUTE7 VARCHAR2(30) INTERFACE_HEADER_ATTRIBUTE8 VARCHAR2(30) INTERFACE_HEADER_CONTEXT VARCHAR2(30) DEFAULT_USSGL_TRX_CODE_CONTEXT VARCHAR2(30) INTERFACE_HEADER_ATTRIBUTE10 VARCHAR2(30) INTERFACE_HEADER_ATTRIBUTE11 VARCHAR2(30) INTERFACE_HEADER_ATTRIBUTE12 VARCHAR2(30) INTERFACE_HEADER_ATTRIBUTE13 VARCHAR2(30) INTERFACE_HEADER_ATTRIBUTE14 VARCHAR2(30) INTERFACE_HEADER_ATTRIBUTE15 VARCHAR2(30) INTERFACE_HEADER_ATTRIBUTE9 VARCHAR2(30) DEFAULT_USSGL_TRANSACTION_CODE VARCHAR2(30) RECURRED_FROM_TRX_NUMBER VARCHAR2(20) STATUS_TRX VARCHAR2(30) DOC_SEQUENCE_ID NUMBER(15) DOC_SEQUENCE_VALUE NUMBER(15) PAYING_CUSTOMER_ID NUMBER(15) PAYING_SITE_USE_ID NUMBER(15) RELATED_BATCH_SOURCE_ID NUMBER(15) DEFAULT_TAX_EXEMPT_FLAG VARCHAR2(1) CREATED_FROM NOT NULL VARCHAR2(30) ORG_ID NUMBER(15) WH_UPDATE_DATE DATE GLOBAL_ATTRIBUTE1 VARCHAR2(150) GLOBAL_ATTRIBUTE2 VARCHAR2(150) GLOBAL_ATTRIBUTE3 VARCHAR2(150) GLOBAL_ATTRIBUTE4 VARCHAR2(150) GLOBAL_ATTRIBUTE5 VARCHAR2(150) GLOBAL_ATTRIBUTE6 VARCHAR2(150) GLOBAL_ATTRIBUTE7 VARCHAR2(150) GLOBAL_ATTRIBUTE8 VARCHAR2(150) GLOBAL_ATTRIBUTE9 VARCHAR2(150) GLOBAL_ATTRIBUTE10 VARCHAR2(150) GLOBAL_ATTRIBUTE11 VARCHAR2(150) GLOBAL_ATTRIBUTE12 VARCHAR2(150) GLOBAL_ATTRIBUTE13 VARCHAR2(150) GLOBAL_ATTRIBUTE14 VARCHAR2(150) GLOBAL_ATTRIBUTE15 VARCHAR2(150) GLOBAL_ATTRIBUTE16 VARCHAR2(150) GLOBAL_ATTRIBUTE17 VARCHAR2(150) GLOBAL_ATTRIBUTE18 VARCHAR2(150) GLOBAL_ATTRIBUTE19 VARCHAR2(150) GLOBAL_ATTRIBUTE20 VARCHAR2(150) GLOBAL_ATTRIBUTE21 VARCHAR2(150) GLOBAL_ATTRIBUTE22 VARCHAR2(150) GLOBAL_ATTRIBUTE23 VARCHAR2(150) GLOBAL_ATTRIBUTE24 VARCHAR2(150) GLOBAL_ATTRIBUTE25 VARCHAR2(150) GLOBAL_ATTRIBUTE26 VARCHAR2(150) GLOBAL_ATTRIBUTE27 VARCHAR2(150) GLOBAL_ATTRIBUTE28 VARCHAR2(150) GLOBAL_ATTRIBUTE29 VARCHAR2(150) GLOBAL_ATTRIBUTE30 VARCHAR2(150) GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30) EDI_PROCESSED_FLAG VARCHAR2(1) EDI_PROCESSED_STATUS VARCHAR2(10) MRC_EXCHANGE_RATE_TYPE VARCHAR2(2000) MRC_EXCHANGE_DATE VARCHAR2(2000) MRC_EXCHANGE_RATE VARCHAR2(2000) PAYMENT_SERVER_ORDER_NUM VARCHAR2(80) APPROVAL_CODE VARCHAR2(80) ADDRESS_VERIFICATION_CODE VARCHAR2(80) OLD_TRX_NUMBER VARCHAR2(20) BR_AMOUNT NUMBER BR_UNPAID_FLAG VARCHAR2(1) BR_ON_HOLD_FLAG VARCHAR2(1) DRAWEE_ID NUMBER(15) DRAWEE_CONTACT_ID NUMBER(15) DRAWEE_SITE_USE_ID NUMBER(15) REMITTANCE_BANK_ACCOUNT_ID NUMBER(15) OVERRIDE_REMIT_ACCOUNT_FLAG VARCHAR2(1) DRAWEE_BANK_ACCOUNT_ID NUMBER(15) SPECIAL_INSTRUCTIONS VARCHAR2(240) REMITTANCE_BATCH_ID NUMBER(15) PREPAYMENT_FLAG VARCHAR2(1) CT_REFERENCE VARCHAR2(30) CONTRACT_ID NUMBER BILL_TEMPLATE_ID NUMBER(15) REVERSED_CASH_RECEIPT_ID NUMBER(15) SQL> desc ra_customer_trx_lines_all; Name Null? Type ----------------------------------------- -------- ---------------------------- CUSTOMER_TRX_LINE_ID NOT NULL NUMBER(15) LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER(15) CREATION_DATE NOT NULL DATE CREATED_BY NOT NULL NUMBER(15) LAST_UPDATE_LOGIN NUMBER(15) CUSTOMER_TRX_ID NOT NULL NUMBER(15) LINE_NUMBER NOT NULL NUMBER SET_OF_BOOKS_ID NOT NULL NUMBER(15) REASON_CODE VARCHAR2(30) INVENTORY_ITEM_ID NUMBER(15) DESCRIPTION VARCHAR2(240) PREVIOUS_CUSTOMER_TRX_ID NUMBER(15) PREVIOUS_CUSTOMER_TRX_LINE_ID NUMBER(15) QUANTITY_ORDERED NUMBER QUANTITY_CREDITED NUMBER QUANTITY_INVOICED NUMBER UNIT_STANDARD_PRICE NUMBER UNIT_SELLING_PRICE NUMBER SALES_ORDER VARCHAR2(50) SALES_ORDER_REVISION NUMBER SALES_ORDER_LINE VARCHAR2(30) SALES_ORDER_DATE DATE ACCOUNTING_RULE_ID NUMBER(15) ACCOUNTING_RULE_DURATION NUMBER(15) LINE_TYPE NOT NULL VARCHAR2(20) ATTRIBUTE_CATEGORY VARCHAR2(30) ATTRIBUTE1 VARCHAR2(150) ATTRIBUTE2 VARCHAR2(150) ATTRIBUTE3 VARCHAR2(150) ATTRIBUTE4 VARCHAR2(150) ATTRIBUTE5 VARCHAR2(150) ATTRIBUTE6 VARCHAR2(150) ATTRIBUTE7 VARCHAR2(150) ATTRIBUTE8 VARCHAR2(150) ATTRIBUTE9 VARCHAR2(150) ATTRIBUTE10 VARCHAR2(150) REQUEST_ID NUMBER(15) PROGRAM_APPLICATION_ID NUMBER(15) PROGRAM_ID NUMBER(15) PROGRAM_UPDATE_DATE DATE RULE_START_DATE DATE INITIAL_CUSTOMER_TRX_LINE_ID NUMBER(15) INTERFACE_LINE_CONTEXT VARCHAR2(30) INTERFACE_LINE_ATTRIBUTE1 VARCHAR2(30) INTERFACE_LINE_ATTRIBUTE2 VARCHAR2(30) INTERFACE_LINE_ATTRIBUTE3 VARCHAR2(30) INTERFACE_LINE_ATTRIBUTE4 VARCHAR2(30) INTERFACE_LINE_ATTRIBUTE5 VARCHAR2(30) INTERFACE_LINE_ATTRIBUTE6 VARCHAR2(30) INTERFACE_LINE_ATTRIBUTE7 VARCHAR2(30) INTERFACE_LINE_ATTRIBUTE8 VARCHAR2(30) SALES_ORDER_SOURCE VARCHAR2(50) TAXABLE_FLAG VARCHAR2(1) EXTENDED_AMOUNT NOT NULL NUMBER REVENUE_AMOUNT NUMBER AUTORULE_COMPLETE_FLAG VARCHAR2(1) LINK_TO_CUST_TRX_LINE_ID NUMBER(15) ATTRIBUTE11 VARCHAR2(150) ATTRIBUTE12 VARCHAR2(150) ATTRIBUTE13 VARCHAR2(150) ATTRIBUTE14 VARCHAR2(150) ATTRIBUTE15 VARCHAR2(150) TAX_PRECEDENCE NUMBER TAX_RATE NUMBER ITEM_EXCEPTION_RATE_ID NUMBER(15) TAX_EXEMPTION_ID NUMBER(15) MEMO_LINE_ID NUMBER(15) AUTORULE_DURATION_PROCESSED NUMBER(15) UOM_CODE VARCHAR2(3) DEFAULT_USSGL_TRANSACTION_CODE VARCHAR2(30) DEFAULT_USSGL_TRX_CODE_CONTEXT VARCHAR2(30) INTERFACE_LINE_ATTRIBUTE10 VARCHAR2(30) INTERFACE_LINE_ATTRIBUTE11 VARCHAR2(30) INTERFACE_LINE_ATTRIBUTE12 VARCHAR2(30) INTERFACE_LINE_ATTRIBUTE13 VARCHAR2(30) INTERFACE_LINE_ATTRIBUTE14 VARCHAR2(30) INTERFACE_LINE_ATTRIBUTE15 VARCHAR2(30) INTERFACE_LINE_ATTRIBUTE9 VARCHAR2(30) VAT_TAX_ID NUMBER(15) AUTOTAX VARCHAR2(1) LAST_PERIOD_TO_CREDIT NUMBER ITEM_CONTEXT VARCHAR2(30) TAX_EXEMPT_FLAG VARCHAR2(1) TAX_EXEMPT_NUMBER VARCHAR2(80) TAX_EXEMPT_REASON_CODE VARCHAR2(30) TAX_VENDOR_RETURN_CODE VARCHAR2(30) SALES_TAX_ID NUMBER(15) LOCATION_SEGMENT_ID NUMBER(15) MOVEMENT_ID NUMBER(15) ORG_ID NUMBER(15) WH_UPDATE_DATE DATE GLOBAL_ATTRIBUTE1 VARCHAR2(150) GLOBAL_ATTRIBUTE2 VARCHAR2(150) GLOBAL_ATTRIBUTE3 VARCHAR2(150) GLOBAL_ATTRIBUTE4 VARCHAR2(150) GLOBAL_ATTRIBUTE5 VARCHAR2(150) GLOBAL_ATTRIBUTE6 VARCHAR2(150) GLOBAL_ATTRIBUTE7 VARCHAR2(150) GLOBAL_ATTRIBUTE8 VARCHAR2(150) GLOBAL_ATTRIBUTE9 VARCHAR2(150) GLOBAL_ATTRIBUTE10 VARCHAR2(150) GLOBAL_ATTRIBUTE11 VARCHAR2(150) GLOBAL_ATTRIBUTE12 VARCHAR2(150) GLOBAL_ATTRIBUTE13 VARCHAR2(150) GLOBAL_ATTRIBUTE14 VARCHAR2(150) GLOBAL_ATTRIBUTE15 VARCHAR2(150) GLOBAL_ATTRIBUTE16 VARCHAR2(150) GLOBAL_ATTRIBUTE17 VARCHAR2(150) GLOBAL_ATTRIBUTE18 VARCHAR2(150) GLOBAL_ATTRIBUTE19 VARCHAR2(150) GLOBAL_ATTRIBUTE20 VARCHAR2(150) GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30) GROSS_UNIT_SELLING_PRICE NUMBER GROSS_EXTENDED_AMOUNT NUMBER AMOUNT_INCLUDES_TAX_FLAG VARCHAR2(1) TAXABLE_AMOUNT NUMBER WAREHOUSE_ID NUMBER(15) TRANSLATED_DESCRIPTION VARCHAR2(1000) EXTENDED_ACCTD_AMOUNT NUMBER BR_REF_CUSTOMER_TRX_ID NUMBER(15) BR_REF_PAYMENT_SCHEDULE_ID NUMBER(15) BR_ADJUSTMENT_ID NUMBER(15) MRC_EXTENDED_ACCTD_AMOUNT VARCHAR2(2000) PAYMENT_SET_ID NUMBER(15) CONTRACT_LINE_ID NUMBER SOURCE_DATA_KEY1 VARCHAR2(150) SOURCE_DATA_KEY2 VARCHAR2(150) SOURCE_DATA_KEY3 VARCHAR2(150) SOURCE_DATA_KEY4 VARCHAR2(150) SOURCE_DATA_KEY5 VARCHAR2(150) INVOICED_LINE_ACCTG_LEVEL VARCHAR2(15) SQL> desc pa_projects_all; Name Null? Type ----------------------------------------- -------- ---------------------------- PROJECT_ID NOT NULL NUMBER(15) NAME NOT NULL VARCHAR2(30) SEGMENT1 NOT NULL VARCHAR2(25) LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER(15) CREATION_DATE NOT NULL DATE CREATED_BY NOT NULL NUMBER(15) LAST_UPDATE_LOGIN NOT NULL NUMBER(15) PROJECT_TYPE NOT NULL VARCHAR2(20) CARRYING_OUT_ORGANIZATION_ID NOT NULL NUMBER(15) PUBLIC_SECTOR_FLAG NOT NULL VARCHAR2(1) PROJECT_STATUS_CODE NOT NULL VARCHAR2(30) DESCRIPTION VARCHAR2(250) START_DATE DATE COMPLETION_DATE DATE CLOSED_DATE DATE DISTRIBUTION_RULE VARCHAR2(30) LABOR_INVOICE_FORMAT_ID NUMBER(15) NON_LABOR_INVOICE_FORMAT_ID NUMBER(15) RETENTION_INVOICE_FORMAT_ID NUMBER(15) RETENTION_PERCENTAGE NUMBER(17,2) BILLING_OFFSET NUMBER(15) BILLING_CYCLE NUMBER(15) LABOR_STD_BILL_RATE_SCHDL VARCHAR2(20) LABOR_BILL_RATE_ORG_ID NUMBER(15) LABOR_SCHEDULE_FIXED_DATE DATE LABOR_SCHEDULE_DISCOUNT NUMBER(7,4) NON_LABOR_STD_BILL_RATE_SCHDL VARCHAR2(30) NON_LABOR_BILL_RATE_ORG_ID NUMBER(15) NON_LABOR_SCHEDULE_FIXED_DATE DATE NON_LABOR_SCHEDULE_DISCOUNT NUMBER(7,4) LIMIT_TO_TXN_CONTROLS_FLAG VARCHAR2(1) PROJECT_LEVEL_FUNDING_FLAG VARCHAR2(1) INVOICE_COMMENT VARCHAR2(240) UNBILLED_RECEIVABLE_DR NUMBER(22,5) UNEARNED_REVENUE_CR NUMBER(22,5) REQUEST_ID NUMBER(15) PROGRAM_ID NUMBER(15) PROGRAM_APPLICATION_ID NUMBER(15) PROGRAM_UPDATE_DATE DATE SUMMARY_FLAG NOT NULL VARCHAR2(1) ENABLED_FLAG NOT NULL VARCHAR2(1) SEGMENT2 VARCHAR2(25) SEGMENT3 VARCHAR2(25) SEGMENT4 VARCHAR2(25) SEGMENT5 VARCHAR2(25) SEGMENT6 VARCHAR2(25) SEGMENT7 VARCHAR2(25) SEGMENT8 VARCHAR2(25) SEGMENT9 VARCHAR2(25) SEGMENT10 VARCHAR2(25) ATTRIBUTE_CATEGORY VARCHAR2(30) ATTRIBUTE1 VARCHAR2(150) ATTRIBUTE2 VARCHAR2(150) ATTRIBUTE3 VARCHAR2(150) ATTRIBUTE4 VARCHAR2(150) ATTRIBUTE5 VARCHAR2(150) ATTRIBUTE6 VARCHAR2(150) ATTRIBUTE7 VARCHAR2(150) ATTRIBUTE8 VARCHAR2(150) ATTRIBUTE9 VARCHAR2(150) ATTRIBUTE10 VARCHAR2(150) COST_IND_RATE_SCH_ID NUMBER(15) REV_IND_RATE_SCH_ID NUMBER(15) INV_IND_RATE_SCH_ID NUMBER(15) COST_IND_SCH_FIXED_DATE DATE REV_IND_SCH_FIXED_DATE DATE INV_IND_SCH_FIXED_DATE DATE LABOR_SCH_TYPE VARCHAR2(1) NON_LABOR_SCH_TYPE VARCHAR2(1) OVR_COST_IND_RATE_SCH_ID NUMBER(15) OVR_REV_IND_RATE_SCH_ID NUMBER(15) OVR_INV_IND_RATE_SCH_ID NUMBER(15) TEMPLATE_FLAG VARCHAR2(1) VERIFICATION_DATE DATE CREATED_FROM_PROJECT_ID NUMBER(15) TEMPLATE_START_DATE_ACTIVE DATE TEMPLATE_END_DATE_ACTIVE DATE ORG_ID NUMBER(15) PM_PRODUCT_CODE VARCHAR2(30) PM_PROJECT_REFERENCE VARCHAR2(25) ACTUAL_START_DATE DATE ACTUAL_FINISH_DATE DATE EARLY_START_DATE DATE EARLY_FINISH_DATE DATE LATE_START_DATE DATE LATE_FINISH_DATE DATE SCHEDULED_START_DATE DATE SCHEDULED_FINISH_DATE DATE BILLING_CYCLE_ID NUMBER(15) ADW_NOTIFY_FLAG VARCHAR2(1) WF_STATUS_CODE VARCHAR2(30) OUTPUT_TAX_CODE VARCHAR2(50) RETENTION_TAX_CODE VARCHAR2(50) PROJECT_CURRENCY_CODE NOT NULL VARCHAR2(15) ALLOW_CROSS_CHARGE_FLAG NOT NULL VARCHAR2(1) PROJECT_RATE_DATE DATE PROJECT_RATE_TYPE VARCHAR2(30) CC_PROCESS_LABOR_FLAG NOT NULL VARCHAR2(1) LABOR_TP_SCHEDULE_ID NUMBER LABOR_TP_FIXED_DATE DATE CC_PROCESS_NL_FLAG NOT NULL VARCHAR2(1) NL_TP_SCHEDULE_ID NUMBER NL_TP_FIXED_DATE DATE CC_TAX_TASK_ID NUMBER BILL_JOB_GROUP_ID NUMBER(15) COST_JOB_GROUP_ID NUMBER(15) ROLE_LIST_ID NUMBER(15) WORK_TYPE_ID NUMBER(15) CALENDAR_ID NUMBER(15) LOCATION_ID NUMBER(15) PROBABILITY_MEMBER_ID NUMBER(15) PROJECT_VALUE NUMBER EXPECTED_APPROVAL_DATE DATE RECORD_VERSION_NUMBER NUMBER(15) INITIAL_TEAM_TEMPLATE_ID NUMBER(15) JOB_BILL_RATE_SCHEDULE_ID NUMBER EMP_BILL_RATE_SCHEDULE_ID NUMBER COMPETENCE_MATCH_WT NUMBER AVAILABILITY_MATCH_WT NUMBER JOB_LEVEL_MATCH_WT NUMBER ENABLE_AUTOMATED_SEARCH VARCHAR2(1) SEARCH_MIN_AVAILABILITY NUMBER SEARCH_ORG_HIER_ID NUMBER(15) SEARCH_STARTING_ORG_ID NUMBER(15) SEARCH_COUNTRY_CODE VARCHAR2(2) MIN_CAND_SCORE_REQD_FOR_NOM NUMBER NON_LAB_STD_BILL_RT_SCH_ID NUMBER(15) INVPROC_CURRENCY_TYPE VARCHAR2(30) REVPROC_CURRENCY_CODE VARCHAR2(15) PROJECT_BIL_RATE_DATE_CODE VARCHAR2(30) PROJECT_BIL_RATE_TYPE VARCHAR2(30) PROJECT_BIL_RATE_DATE DATE PROJECT_BIL_EXCHANGE_RATE NUMBER PROJFUNC_CURRENCY_CODE VARCHAR2(15) PROJFUNC_BIL_RATE_DATE_CODE VARCHAR2(30) PROJFUNC_BIL_RATE_TYPE VARCHAR2(30) PROJFUNC_BIL_RATE_DATE DATE PROJFUNC_BIL_EXCHANGE_RATE NUMBER FUNDING_RATE_DATE_CODE VARCHAR2(30) FUNDING_RATE_TYPE VARCHAR2(30) FUNDING_RATE_DATE DATE FUNDING_EXCHANGE_RATE NUMBER BASELINE_FUNDING_FLAG VARCHAR2(1) PROJFUNC_COST_RATE_TYPE VARCHAR2(30) PROJFUNC_COST_RATE_DATE DATE INV_BY_BILL_TRANS_CURR_FLAG VARCHAR2(1) MULTI_CURRENCY_BILLING_FLAG VARCHAR2(1) SPLIT_COST_FROM_WORKPLAN_FLAG VARCHAR2(1) SPLIT_COST_FROM_BILL_FLAG VARCHAR2(1) ASSIGN_PRECEDES_TASK VARCHAR2(1) PRIORITY_CODE VARCHAR2(30) RETN_BILLING_INV_FORMAT_ID NUMBER(15) RETN_ACCOUNTING_FLAG VARCHAR2(1) ADV_ACTION_SET_ID NUMBER(15) START_ADV_ACTION_SET_FLAG VARCHAR2(1) REVALUATE_FUNDING_FLAG VARCHAR2(1) INCLUDE_GAINS_LOSSES_FLAG VARCHAR2(1) TARGET_START_DATE DATE TARGET_FINISH_DATE DATE BASELINE_START_DATE DATE BASELINE_FINISH_DATE DATE SCHEDULED_AS_OF_DATE DATE BASELINE_AS_OF_DATE DATE LABOR_DISC_REASON_CODE VARCHAR2(30) NON_LABOR_DISC_REASON_CODE VARCHAR2(30) SECURITY_LEVEL NUMBER ACTUAL_AS_OF_DATE DATE SCHEDULED_DURATION NUMBER BASELINE_DURATION NUMBER ACTUAL_DURATION NUMBER LONG_NAME VARCHAR2(240) BTC_COST_BASE_REV_CODE VARCHAR2(90) ASSET_ALLOCATION_METHOD VARCHAR2(30) CAPITAL_EVENT_PROCESSING VARCHAR2(30) CINT_RATE_SCH_ID NUMBER(15) CINT_ELIGIBLE_FLAG VARCHAR2(1) CINT_STOP_DATE DATE SQL> desc pa_draft_invoice_items; Name Null? Type ----------------------------------------- -------- ---------------------------- PROJECT_ID NOT NULL NUMBER(15) DRAFT_INVOICE_NUM NOT NULL NUMBER(15) LINE_NUM NOT NULL NUMBER(15) LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER(15) CREATION_DATE NOT NULL DATE CREATED_BY NOT NULL NUMBER(15) AMOUNT NOT NULL NUMBER(22,5) TEXT NOT NULL VARCHAR2(240) INVOICE_LINE_TYPE NOT NULL VARCHAR2(30) REQUEST_ID NUMBER(15) PROGRAM_APPLICATION_ID NUMBER(15) PROGRAM_ID NUMBER(15) PROGRAM_UPDATE_DATE DATE UNEARNED_REVENUE_CR NUMBER(22,5) UNBILLED_RECEIVABLE_DR NUMBER(22,5) TASK_ID NUMBER(15) EVENT_TASK_ID NUMBER(15) EVENT_NUM NUMBER(15) SHIP_TO_ADDRESS_ID NUMBER(15) TAXABLE_FLAG VARCHAR2(1) DRAFT_INV_LINE_NUM_CREDITED NUMBER(15) LAST_UPDATE_LOGIN NUMBER(15) INV_AMOUNT NUMBER OUTPUT_VAT_TAX_ID NUMBER OUTPUT_TAX_EXEMPT_FLAG VARCHAR2(1) OUTPUT_TAX_EXEMPT_REASON_CODE VARCHAR2(30) OUTPUT_TAX_EXEMPT_NUMBER VARCHAR2(80) ACCT_AMOUNT NUMBER ROUNDING_AMOUNT NUMBER UNBILLED_ROUNDING_AMOUNT_DR NUMBER UNEARNED_ROUNDING_AMOUNT_CR NUMBER TRANSLATED_TEXT VARCHAR2(240) CC_REV_CODE_COMBINATION_ID NUMBER CC_PROJECT_ID NUMBER CC_TAX_TASK_ID NUMBER PROJFUNC_CURRENCY_CODE VARCHAR2(15) PROJFUNC_BILL_AMOUNT NUMBER PROJECT_CURRENCY_CODE VARCHAR2(15) PROJECT_BILL_AMOUNT NUMBER FUNDING_CURRENCY_CODE VARCHAR2(15) FUNDING_BILL_AMOUNT NUMBER FUNDING_RATE_DATE DATE FUNDING_EXCHANGE_RATE NUMBER FUNDING_RATE_TYPE VARCHAR2(30) INVPROC_CURRENCY_CODE VARCHAR2(15) BILL_TRANS_CURRENCY_CODE VARCHAR2(15) BILL_TRANS_BILL_AMOUNT NUMBER RETN_BILLING_METHOD VARCHAR2(30) RETN_PERCENT_COMPLETE NUMBER RETN_TOTAL_RETENTION NUMBER RETN_BILLING_CYCLE_ID NUMBER(15) RETN_CLIENT_EXTENSION_FLAG VARCHAR2(1) RETN_BILLING_PERCENTAGE NUMBER RETN_BILLING_AMOUNT NUMBER RETENTION_RULE_ID NUMBER(15) RETAINED_AMOUNT NUMBER RETN_DRAFT_INVOICE_NUM NUMBER RETN_DRAFT_INVOICE_LINE_NUM NUMBER SQL> desc pa_events; Name Null? Type ----------------------------------------- -------- ---------------------------- TASK_ID NUMBER(15) EVENT_NUM NOT NULL NUMBER(15) LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER(15) CREATION_DATE NOT NULL DATE CREATED_BY NOT NULL NUMBER(15) LAST_UPDATE_LOGIN NOT NULL NUMBER(15) EVENT_TYPE NOT NULL VARCHAR2(30) DESCRIPTION NOT NULL VARCHAR2(240) BILL_AMOUNT NOT NULL NUMBER(22,5) REVENUE_AMOUNT NOT NULL NUMBER(22,5) REVENUE_DISTRIBUTED_FLAG NOT NULL VARCHAR2(1) BILL_HOLD_FLAG VARCHAR2(1) COMPLETION_DATE DATE REV_DIST_REJECTION_CODE VARCHAR2(30) REQUEST_ID NUMBER(15) PROGRAM_APPLICATION_ID NUMBER(15) PROGRAM_ID NUMBER(15) PROGRAM_UPDATE_DATE DATE ATTRIBUTE_CATEGORY VARCHAR2(30) ATTRIBUTE1 VARCHAR2(150) ATTRIBUTE2 VARCHAR2(150) ATTRIBUTE3 VARCHAR2(150) ATTRIBUTE4 VARCHAR2(150) ATTRIBUTE5 VARCHAR2(150) ATTRIBUTE6 VARCHAR2(150) ATTRIBUTE7 VARCHAR2(150) ATTRIBUTE8 VARCHAR2(150) ATTRIBUTE9 VARCHAR2(150) ATTRIBUTE10 VARCHAR2(150) PROJECT_ID NOT NULL NUMBER(15) ORGANIZATION_ID NOT NULL NUMBER(15) BILLING_ASSIGNMENT_ID NUMBER(15) EVENT_NUM_REVERSED NUMBER(15) CALLING_PLACE VARCHAR2(30) CALLING_PROCESS VARCHAR2(30) AUDIT_COST_BUDGET_TYPE_CODE VARCHAR2(30) AUDIT_REV_BUDGET_TYPE_CODE VARCHAR2(30) AUDIT_AMOUNT1 NUMBER AUDIT_AMOUNT2 NUMBER AUDIT_AMOUNT3 NUMBER AUDIT_AMOUNT4 NUMBER AUDIT_AMOUNT5 NUMBER AUDIT_AMOUNT6 NUMBER AUDIT_AMOUNT7 NUMBER AUDIT_AMOUNT8 NUMBER AUDIT_AMOUNT9 NUMBER AUDIT_AMOUNT10 NUMBER EVENT_ID NOT NULL NUMBER INVENTORY_ORG_ID NUMBER(15) INVENTORY_ITEM_ID NUMBER(15) QUANTITY_BILLED NUMBER UOM_CODE VARCHAR2(3) UNIT_PRICE NUMBER REFERENCE1 VARCHAR2(240) REFERENCE2 VARCHAR2(240) REFERENCE3 VARCHAR2(240) REFERENCE4 VARCHAR2(240) REFERENCE5 VARCHAR2(240) REFERENCE6 VARCHAR2(240) REFERENCE7 VARCHAR2(240) REFERENCE8 VARCHAR2(240) REFERENCE9 VARCHAR2(240) REFERENCE10 VARCHAR2(240) BILLED_FLAG VARCHAR2(1) BILL_TRANS_CURRENCY_CODE VARCHAR2(15) BILL_TRANS_BILL_AMOUNT NUMBER BILL_TRANS_REV_AMOUNT NUMBER PROJECT_CURRENCY_CODE VARCHAR2(15) PROJECT_RATE_TYPE VARCHAR2(30) PROJECT_RATE_DATE DATE PROJECT_EXCHANGE_RATE NUMBER PROJECT_REV_RATE_DATE DATE PROJECT_REV_EXCHANGE_RATE NUMBER PROJECT_REVENUE_AMOUNT NUMBER PROJECT_INV_RATE_DATE DATE PROJECT_INV_EXCHANGE_RATE NUMBER PROJECT_BILL_AMOUNT NUMBER PROJFUNC_CURRENCY_CODE VARCHAR2(15) PROJFUNC_RATE_TYPE VARCHAR2(30) PROJFUNC_RATE_DATE DATE PROJFUNC_EXCHANGE_RATE NUMBER PROJFUNC_REV_RATE_DATE DATE PROJFUNC_REV_EXCHANGE_RATE NUMBER PROJFUNC_REVENUE_AMOUNT NUMBER PROJFUNC_INV_RATE_DATE DATE PROJFUNC_INV_EXCHANGE_RATE NUMBER PROJFUNC_BILL_AMOUNT NUMBER FUNDING_RATE_TYPE VARCHAR2(30) FUNDING_RATE_DATE DATE FUNDING_EXCHANGE_RATE NUMBER REVPROC_CURRENCY_CODE VARCHAR2(15) REVPROC_RATE_TYPE VARCHAR2(30) REVPROC_RATE_DATE DATE REVPROC_EXCHANGE_RATE NUMBER INVPROC_CURRENCY_CODE VARCHAR2(15) INVPROC_RATE_TYPE VARCHAR2(30) INVPROC_RATE_DATE DATE INVPROC_EXCHANGE_RATE NUMBER INV_GEN_REJECTION_CODE VARCHAR2(30) ADJUSTING_REVENUE_FLAG VARCHAR2(1) ZERO_REVENUE_AMOUNT_FLAG VARCHAR2(1) NON_UPDATEABLE_FLAG VARCHAR2(1) PROJECT_FUNDING_ID NUMBER(15) REVENUE_HOLD_FLAG VARCHAR2(1) AUDIT_COST_PLAN_TYPE_ID NUMBER(15) AUDIT_REV_PLAN_TYPE_ID NUMBER(15) PM_PRODUCT_CODE VARCHAR2(30) PM_EVENT_REFERENCE VARCHAR2(25) SQL> desc tcs_cmc_olpics_det_t; Name Null? Type ----------------------------------------- -------- ---------------------------- CMC_EVENT_ID NOT NULL NUMBER QUANTITY NOT NULL NUMBER EVENT_DATE NOT NULL DATE EVENT_ID NUMBER EVENT_NUM NUMBER EVENT_FLAG VARCHAR2(1) BILLED_FLAG NOT NULL VARCHAR2(1) BILL_HOLD_FLAG NOT NULL VARCHAR2(1) REVENUE_FLAG NOT NULL VARCHAR2(1) CANCELLED_FLAG VARCHAR2(1) CREATED_BY NOT NULL NUMBER(15) CREATION_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER(15) LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATE_LOGIN NOT NULL NUMBER(15) ATTRIBUTE1 VARCHAR2(150) ATTRIBUTE2 VARCHAR2(150) ATTRIBUTE3 VARCHAR2(150) ATTRIBUTE4 VARCHAR2(150) ATTRIBUTE5 VARCHAR2(150) SQL> desc tcs_cmc_olpics_hdr_t; Name Null? Type ----------------------------------------- -------- ---------------------------- CMC_EVENT_ID NOT NULL NUMBER PROJECT_ID NOT NULL NUMBER PROJECT_NUMBER NOT NULL VARCHAR2(25) ORG_ID NOT NULL NUMBER CUSTOMER_ORDER_NO VARCHAR2(60) DC_MIR_NO VARCHAR2(100) DC_MIR_DATE DATE LINE_NUM NUMBER EVENT_TYPE NOT NULL VARCHAR2(100) SHIP_TO_ADDRESS_ID NUMBER ACCOUNTING_LOCATION NOT NULL VARCHAR2(10) ITEM_CODE VARCHAR2(100) ITEM_DESCRIPTION VARCHAR2(1000) TOTAL_QUANTITY NUMBER UNIT_SELLING_PRICE NUMBER(15,2) UNIT_COST NUMBER(15,2) TAX_CODE VARCHAR2(100) TAX_RATE NUMBER TAX_CODE_ON_DEL VARCHAR2(100) TAX_RATE_ON_DEL NUMBER WARRANTY NUMBER WARRANTY_START_DATE DATE BACK_TO_BACK_GUARANTEE VARCHAR2(1) RECOVERABLE_FLAG VARCHAR2(1) ACKNOWLEDGED_QUANTITY NUMBER LATEST_ACKNOWLEDGED_DATE DATE REJECTED_QUANTITY NUMBER LATEST_REJECTED_DATE DATE EVENT_QUANTITY NUMBER BILLED_QUANTITY NUMBER REV_REC_QUANTITY NUMBER ACTUAL_UNIT_COST_INR NUMBER(15,2) STATUS VARCHAR2(1) MIGRATION_FLAG VARCHAR2(1) WARRANTY_AMOUNT NUMBER(15,2) WARRANTY_FROM_DATE DATE WARRANTY_TO_DATE DATE ITEM_GROUP VARCHAR2(5) CREATED_BY NOT NULL NUMBER(15) CREATION_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER(15) LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATE_LOGIN NOT NULL NUMBER(15) ATTRIBUTE1 VARCHAR2(150) ATTRIBUTE2 VARCHAR2(150) ATTRIBUTE3 VARCHAR2(150) ATTRIBUTE4 VARCHAR2(150) ATTRIBUTE5 VARCHAR2(150) SQL> desc tcs_cmc_proj_bill_percent; Name Null? Type ----------------------------------------- -------- ---------------------------- PROJECT_ID NOT NULL NUMBER PROJECT_NUMBER NOT NULL VARCHAR2(25) ADVANCE_PERCENTAGE NOT NULL NUMBER(15,2) DELIVERY_PERCENTAGE NOT NULL NUMBER(15,2) INSTALLATION_PERCENTAGE NOT NULL NUMBER(15,2) ORG_ID NOT NULL NUMBER RETENTION_PERCENTAGE NOT NULL NUMBER(15,2) ACCEPTANCE_PERCENTAGE NOT NULL NUMBER(15,2) DELIVERY_SETOFF NOT NULL NUMBER(15,2) INSTALLATION_SETOFF NOT NULL NUMBER(15,2) RETENTION_SETOFF NOT NULL NUMBER(15,2) ACCEPTANCE_SETOFF NOT NULL NUMBER(15,2) SETOFF NOT NULL VARCHAR2(10) LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER(15) CREATION_DATE NOT NULL DATE CREATED_BY NOT NULL NUMBER(15) LAST_UPDATE_LOGIN NOT NULL NUMBER(15) ATTRIBUTE1 VARCHAR2(150) ATTRIBUTE2 VARCHAR2(150) ATTRIBUTE3 VARCHAR2(150) ATTRIBUTE4 VARCHAR2(150) ATTRIBUTE5 VARCHAR2(150) =========================================== INDEX_NAME INDEX_TYPE TABLE_NAME 1 RA_CUSTOMER_TRX_LINES_N1 NORMAL RA_CUSTOMER_TRX_LINES_ALL 2 RA_CUSTOMER_TRX_LINES_ALL_I1 NORMAL RA_CUSTOMER_TRX_LINES_ALL 3 TCS_RA_CUST_TRX_LINES_ALL_IDX1 NORMAL RA_CUSTOMER_TRX_LINES_ALL 4 RA_CUSTOMER_TRX_LINES_U1 NORMAL RA_CUSTOMER_TRX_LINES_ALL 5 RA_CUSTOMER_TRX_LINES_N10 NORMAL RA_CUSTOMER_TRX_LINES_ALL 6 RA_CUSTOMER_TRX_LINES_N11 NORMAL RA_CUSTOMER_TRX_LINES_ALL 7 RA_CUSTOMER_TRX_LINES_N12 NORMAL RA_CUSTOMER_TRX_LINES_ALL 8 RA_CUSTOMER_TRX_LINES_N5 NORMAL RA_CUSTOMER_TRX_LINES_ALL 9 RA_CUSTOMER_TRX_LINES_N6 NORMAL RA_CUSTOMER_TRX_LINES_ALL 10 RA_CUSTOMER_TRX_LINES_N7 NORMAL RA_CUSTOMER_TRX_LINES_ALL 11 RA_CUSTOMER_TRX_LINES_N8 NORMAL RA_CUSTOMER_TRX_LINES_ALL 12 RA_CUSTOMER_TRX_LINES_N9 NORMAL RA_CUSTOMER_TRX_LINES_ALL 13 RA_CUSTOMER_TRX_LINES_N2 NORMAL RA_CUSTOMER_TRX_LINES_ALL 14 RA_CUSTOMER_TRX_LINES_N3 NORMAL RA_CUSTOMER_TRX_LINES_ALL 15 RA_CUSTOMER_TRX_LINES_N4 NORMAL RA_CUSTOMER_TRX_LINES_ALL 16 PA_PROJECTS_N10 NORMAL PA_PROJECTS_ALL 17 PA_PROJECTS_N11 NORMAL PA_PROJECTS_ALL 18 PA_PROJECTS_N8 NORMAL PA_PROJECTS_ALL 19 PA_PROJECTS_N9 NORMAL PA_PROJECTS_ALL 20 PA_PROJECTS_U5 NORMAL PA_PROJECTS_ALL 21 PA_PROJECTS_N5 NORMAL PA_PROJECTS_ALL 22 PA_PROJECTS_U1 NORMAL PA_PROJECTS_ALL 23 PA_PROJECTS_U2 NORMAL PA_PROJECTS_ALL 24 PA_PROJECTS_U3 NORMAL PA_PROJECTS_ALL 25 PA_PROJECTS_U4 NORMAL PA_PROJECTS_ALL 26 PA_PROJECTS_N3 NORMAL PA_PROJECTS_ALL 27 PA_PROJECTS_N4 NORMAL PA_PROJECTS_ALL 28 PA_PROJECTS_N1 NORMAL PA_PROJECTS_ALL 29 PA_PROJECTS_N6 NORMAL PA_PROJECTS_ALL 30 PA_PROJECTS_N2 NORMAL PA_PROJECTS_ALL 31 PA_PROJECTS_N7 FUNCTION-BASED NORMAL PA_PROJECTS_ALL 32 PA_EVENTS_U3 NORMAL PA_EVENTS 33 PA_EVENTS_N1 NORMAL PA_EVENTS 34 PA_EVENTS_N2 NORMAL PA_EVENTS 35 PA_EVENTS_N3 NORMAL PA_EVENTS 36 PA_EVENTS_N4 NORMAL PA_EVENTS 37 PA_EVENTS_U1 NORMAL PA_EVENTS 38 PA_EVENTS_U2 NORMAL PA_EVENTS 39 PA_DRAFT_INVOICE_ITEMS_N5 NORMAL PA_DRAFT_INVOICE_ITEMS 40 PA_DRAFT_INVOICE_ITEMS_N1 NORMAL PA_DRAFT_INVOICE_ITEMS 41 PA_DRAFT_INVOICE_ITEMS_N4 NORMAL PA_DRAFT_INVOICE_ITEMS 42 PA_DRAFT_INVOICE_ITEMS_U1 NORMAL PA_DRAFT_INVOICE_ITEMS 43 PA_DRAFT_INVOICE_ITEMS_N2 NORMAL PA_DRAFT_INVOICE_ITEMS 44 PA_DRAFT_INVOICE_ITEMS_N3 NORMAL PA_DRAFT_INVOICE_ITEMS 45 TCS_CMC_OLPICS_HDR_T_N2 NORMAL TCS_CMC_OLPICS_HDR_T 46 TCS_CMC_OLPICS_HDR_T_N1 NORMAL TCS_CMC_OLPICS_HDR_T 47 TCS_CMC_OLPICS_HDR_T_U1 NORMAL TCS_CMC_OLPICS_HDR_T 48 TCS_CMC_OLPICS_DET_T_N2 NORMAL TCS_CMC_OLPICS_DET_T 49 TCS_CMC_OLPICS_DET_T_N1 NORMAL TCS_CMC_OLPICS_DET_T 50 TCS_CMC_PROJ_BILL_PERCENT_N1 NORMAL TCS_CMC_PROJ_BILL_PERCENT 51 TCS_CMC_PROJ_BILL_PERCENT_U1 NORMAL TCS_CMC_PROJ_BILL_PERCENT