Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: PA.PA_CUST_RDL_AR

Object Details
Object Name: PA_CUST_RDL_AR
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_CUST_RDL_AR
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_CUST_RDL_AR_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPURGE_PROJECT_ID
Columns
Name Datatype Length Mandatory Comments
PURGE_BATCH_ID NUMBER (15) Yes
PURGE_RELEASE VARCHAR2 (50) Yes
PURGE_PROJECT_ID NUMBER (15) Yes
ORG_ID NUMBER (15)
EXPENDITURE_ITEM_ID NUMBER (15)
LINE_NUM NUMBER (15)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
PROJECT_ID NUMBER (15)
DRAFT_REVENUE_NUM NUMBER (15)
DRAFT_REVENUE_ITEM_LINE_NUM NUMBER (15)
AMOUNT NUMBER (22)
CODE_COMBINATION_ID NUMBER (15)
BILL_AMOUNT NUMBER (22)
FUNCTION_CODE VARCHAR2 (15)
FUNCTION_TRANSACTION_CODE VARCHAR2 (30)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

BATCH_NAME VARCHAR2 (30)
ADDITIONAL_REVENUE_FLAG VARCHAR2 (1)
INVOICE_ELIGIBLE_FLAG VARCHAR2 (1)
DRAFT_INVOICE_NUM NUMBER (15)
DRAFT_INVOICE_ITEM_LINE_NUM NUMBER (15)
REVERSED_FLAG VARCHAR2 (1)
LINE_NUM_REVERSED NUMBER (15)
REV_IND_COMPILED_SET_ID NUMBER (15)
INV_IND_COMPILED_SET_ID NUMBER (15)
RAW_COST NUMBER (22)
OUTPUT_VAT_TAX_ID NUMBER (15)
OUTPUT_TAX_EXEMPT_FLAG VARCHAR2 (1)
OUTPUT_TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
OUTPUT_TAX_EXEMPT_NUMBER VARCHAR2 (80)
PRC_GENERATED_FLAG VARCHAR2 (1)
BILL_TRANS_CURRENCY_CODE VARCHAR2 (15)
BILL_TRANS_AMOUNT NUMBER

BILL_TRANS_BILL_AMOUNT NUMBER

BILL_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

PROJECT_CURRENCY_CODE VARCHAR2 (15)
PROJECT_REVENUE_AMOUNT NUMBER

PROJECT_REV_RATE_TYPE VARCHAR2 (30)
PROJECT_REV_RATE_DATE DATE

PROJECT_REV_EXCHANGE_RATE NUMBER

PROJECT_BILL_AMOUNT NUMBER

PROJECT_INV_RATE_TYPE VARCHAR2 (30)
PROJECT_INV_RATE_DATE DATE

PROJECT_INV_EXCHANGE_RATE NUMBER

PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
PROJFUNC_REVENUE_AMOUNT NUMBER

PROJFUNC_REV_RATE_TYPE VARCHAR2 (30)
PROJFUNC_REV_RATE_DATE DATE

PROJFUNC_REV_EXCHANGE_RATE NUMBER

PROJFUNC_BILL_AMOUNT NUMBER

PROJFUNC_INV_RATE_TYPE VARCHAR2 (30)
PROJFUNC_INV_RATE_DATE DATE

PROJFUNC_INV_EXCHANGE_RATE NUMBER

FUNDING_CURRENCY_CODE VARCHAR2 (15)
FUNDING_REVENUE_AMOUNT NUMBER

FUNDING_REV_RATE_TYPE VARCHAR2 (30)
FUNDING_REV_RATE_DATE DATE

FUNDING_REV_EXCHANGE_RATE NUMBER

FUNDING_BILL_AMOUNT NUMBER

FUNDING_INV_RATE_TYPE VARCHAR2 (30)
FUNDING_INV_RATE_DATE DATE

FUNDING_INV_EXCHANGE_RATE NUMBER

LABOR_MULTIPLIER NUMBER

DISCOUNT_PERCENTAGE NUMBER

AMOUNT_CALCULATION_CODE VARCHAR2 (15)
BILL_MARKUP_PERCENTAGE NUMBER

RATE_SOURCE_ID NUMBER (15)
INV_GEN_REJECTION_CODE VARCHAR2 (30)
RETN_DRAFT_INVOICE_NUM NUMBER

RETN_DRAFT_INVOICE_LINE_NUM NUMBER

RETAINED_AMOUNT NUMBER

RETENTION_RULE_ID NUMBER (15)
RATE_DISC_REASON_CODE VARCHAR2 (30)
reason code for discount,discount override or rate override
OUTPUT_TAX_CLASSIFICATION_CODE VARCHAR2 (50)
eTax change
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PURGE_BATCH_ID
,      PURGE_RELEASE
,      PURGE_PROJECT_ID
,      ORG_ID
,      EXPENDITURE_ITEM_ID
,      LINE_NUM
,      CREATION_DATE
,      CREATED_BY
,      PROJECT_ID
,      DRAFT_REVENUE_NUM
,      DRAFT_REVENUE_ITEM_LINE_NUM
,      AMOUNT
,      CODE_COMBINATION_ID
,      BILL_AMOUNT
,      FUNCTION_CODE
,      FUNCTION_TRANSACTION_CODE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      BATCH_NAME
,      ADDITIONAL_REVENUE_FLAG
,      INVOICE_ELIGIBLE_FLAG
,      DRAFT_INVOICE_NUM
,      DRAFT_INVOICE_ITEM_LINE_NUM
,      REVERSED_FLAG
,      LINE_NUM_REVERSED
,      REV_IND_COMPILED_SET_ID
,      INV_IND_COMPILED_SET_ID
,      RAW_COST
,      OUTPUT_VAT_TAX_ID
,      OUTPUT_TAX_EXEMPT_FLAG
,      OUTPUT_TAX_EXEMPT_REASON_CODE
,      OUTPUT_TAX_EXEMPT_NUMBER
,      PRC_GENERATED_FLAG
,      BILL_TRANS_CURRENCY_CODE
,      BILL_TRANS_AMOUNT
,      BILL_TRANS_BILL_AMOUNT
,      BILL_RATE
,      REVPROC_CURRENCY_CODE
,      REVPROC_RATE_TYPE
,      REVPROC_RATE_DATE
,      REVPROC_EXCHANGE_RATE
,      INVPROC_CURRENCY_CODE
,      INVPROC_RATE_TYPE
,      INVPROC_RATE_DATE
,      INVPROC_EXCHANGE_RATE
,      PROJECT_CURRENCY_CODE
,      PROJECT_REVENUE_AMOUNT
,      PROJECT_REV_RATE_TYPE
,      PROJECT_REV_RATE_DATE
,      PROJECT_REV_EXCHANGE_RATE
,      PROJECT_BILL_AMOUNT
,      PROJECT_INV_RATE_TYPE
,      PROJECT_INV_RATE_DATE
,      PROJECT_INV_EXCHANGE_RATE
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_REVENUE_AMOUNT
,      PROJFUNC_REV_RATE_TYPE
,      PROJFUNC_REV_RATE_DATE
,      PROJFUNC_REV_EXCHANGE_RATE
,      PROJFUNC_BILL_AMOUNT
,      PROJFUNC_INV_RATE_TYPE
,      PROJFUNC_INV_RATE_DATE
,      PROJFUNC_INV_EXCHANGE_RATE
,      FUNDING_CURRENCY_CODE
,      FUNDING_REVENUE_AMOUNT
,      FUNDING_REV_RATE_TYPE
,      FUNDING_REV_RATE_DATE
,      FUNDING_REV_EXCHANGE_RATE
,      FUNDING_BILL_AMOUNT
,      FUNDING_INV_RATE_TYPE
,      FUNDING_INV_RATE_DATE
,      FUNDING_INV_EXCHANGE_RATE
,      LABOR_MULTIPLIER
,      DISCOUNT_PERCENTAGE
,      AMOUNT_CALCULATION_CODE
,      BILL_MARKUP_PERCENTAGE
,      RATE_SOURCE_ID
,      INV_GEN_REJECTION_CODE
,      RETN_DRAFT_INVOICE_NUM
,      RETN_DRAFT_INVOICE_LINE_NUM
,      RETAINED_AMOUNT
,      RETENTION_RULE_ID
,      RATE_DISC_REASON_CODE
,      OUTPUT_TAX_CLASSIFICATION_CODE
FROM PA.PA_CUST_RDL_AR;

Dependencies

[top of page]

PA.PA_CUST_RDL_AR does not reference any database object

PA.PA_CUST_RDL_AR is referenced by following:

SchemaPA
ViewPA_CUST_RDL_AR#