[Home] [Help] [Dependency Information]
Object Name: | CN_POSTING_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POSTING_DETAIL_ID | NUMBER | (15) | Yes | Primary key |
POSTING_BATCH | VARCHAR2 | (240) | Yes | Posting batch name |
POSTING_TYPE | VARCHAR2 | (4000) | Posting type | |
PAYEE_SALESREP_ID | NUMBER | (15) | Identifier to salesrep payee | |
PAYEE_SALESREP | VARCHAR2 | (360) | salesperson payee name | |
CREDITED_SALESREP_ID | NUMBER | (15) | Unique Identifier for credited salesperson | |
CREDITED_SALESREP | VARCHAR2 | (360) | Credited salesperson name | |
SALES_ROLE | VARCHAR2 | (60) | Yes | Sales role |
CREDIT_TYPE | VARCHAR2 | (80) | Yes | Credit type |
PAY_PERIOD_ID | VARCHAR2 | (30) | Unique Identifier for pay period | |
PERIOD_NAME | VARCHAR2 | (30) | Yes | Pay period name |
TRANSACTION_TYPE | VARCHAR2 | (4000) | Transaction type | |
INCENTIVE_TYPE | VARCHAR2 | (4000) | Incentive type: Commission, Bonus or Manual | |
PROCESSED_DATE | DATE | Processed date | ||
AMOUNT | NUMBER | Amount of commission earned | ||
PAYMENT_AMOUNT | NUMBER | Amount of commission to pay | ||
HOLD_FLAG | VARCHAR2 | (4000) | Hold payment flag | |
PAID_FLAG | VARCHAR2 | (4000) | Paid flag | |
COMP_PLAN | VARCHAR2 | (30) | Compensation plan name | |
PLAN_ELEMENT | VARCHAR2 | (80) | Plan element name | |
PAYRUN | VARCHAR2 | (80) | Payrun name | |
EXPENSE_CCID | NUMBER | Code combination identifier for gl expense account | ||
LIABILITY_CCID | NUMBER | Code combination identifier for gl liability account. | ||
COMMISSION_HEADER_ID | NUMBER | (15) | Foreign key to CN_COMMISSION_HEADERS | |
COMMISSION_LINE_ID | NUMBER | (15) | Foreign Key to CN_COMMISSION_LINES | |
LOADING_STATUS | VARCHAR2 | (4000) | Loading status | |
LOADED_DATE | DATE | Loaded date | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT POSTING_DETAIL_ID
, POSTING_BATCH
, POSTING_TYPE
, PAYEE_SALESREP_ID
, PAYEE_SALESREP
, CREDITED_SALESREP_ID
, CREDITED_SALESREP
, SALES_ROLE
, CREDIT_TYPE
, PAY_PERIOD_ID
, PERIOD_NAME
, TRANSACTION_TYPE
, INCENTIVE_TYPE
, PROCESSED_DATE
, AMOUNT
, PAYMENT_AMOUNT
, HOLD_FLAG
, PAID_FLAG
, COMP_PLAN
, PLAN_ELEMENT
, PAYRUN
, EXPENSE_CCID
, LIABILITY_CCID
, COMMISSION_HEADER_ID
, COMMISSION_LINE_ID
, LOADING_STATUS
, LOADED_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM APPS.CN_POSTING_DETAILS_V;
APPS.CN_POSTING_DETAILS_V is not referenced by any database object
|
|
|