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

VIEW: PN.PN_PAYMENT_TERMS_ALL#

Object Details
Object Name: PN_PAYMENT_TERMS_ALL#
Object Type: VIEW
Owner: PN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PAYMENT_TERM_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

PAYMENT_PURPOSE_CODE VARCHAR2 (30) Yes
PAYMENT_TERM_TYPE_CODE VARCHAR2 (30) Yes
FREQUENCY_CODE VARCHAR2 (30) Yes
LEASE_ID NUMBER
Yes
LEASE_CHANGE_ID NUMBER
Yes
START_DATE DATE
Yes
END_DATE DATE
Yes
CODE_COMBINATION_ID NUMBER

VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

TARGET_DATE DATE

ACTUAL_AMOUNT NUMBER

ESTIMATED_AMOUNT NUMBER

SET_OF_BOOKS_ID NUMBER
Yes
CURRENCY_CODE VARCHAR2 (15) Yes
RATE NUMBER

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)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ORG_ID NUMBER (15)
CUSTOMER_ID NUMBER

CUSTOMER_SITE_USE_ID NUMBER

NORMALIZE VARCHAR2 (1)
LOCATION_ID NUMBER (15)
SCHEDULE_DAY NUMBER (15)
CUST_SHIP_SITE_ID NUMBER (15)
AP_AR_TERM_ID NUMBER (15)
CUST_TRX_TYPE_ID NUMBER (15)
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
ORGANIZATION_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_ITEM_DATE DATE

TAX_GROUP_ID NUMBER (15)
TAX_CODE_ID NUMBER (15)
TAX_INCLUDED VARCHAR2 (1)
DISTRIBUTION_SET_ID NUMBER (15)
INV_RULE_ID NUMBER (15)
ACCOUNT_RULE_ID NUMBER (15)
SALESREP_ID NUMBER (15)
APPROVED_BY NUMBER (15)
STATUS VARCHAR2 (30)
INDEX_PERIOD_ID NUMBER

INDEX_TERM_INDICATOR VARCHAR2 (30)
PO_HEADER_ID VARCHAR2 (30)
CUST_PO_NUMBER VARCHAR2 (50)
RECEIPT_METHOD_ID NUMBER (15)
PROJECT_ATTRIBUTE_CATEGORY VARCHAR2 (30)
PROJECT_ATTRIBUTE1 VARCHAR2 (150)
PROJECT_ATTRIBUTE2 VARCHAR2 (150)
PROJECT_ATTRIBUTE3 VARCHAR2 (150)
PROJECT_ATTRIBUTE4 VARCHAR2 (150)
PROJECT_ATTRIBUTE5 VARCHAR2 (150)
PROJECT_ATTRIBUTE6 VARCHAR2 (150)
PROJECT_ATTRIBUTE7 VARCHAR2 (150)
PROJECT_ATTRIBUTE8 VARCHAR2 (150)
PROJECT_ATTRIBUTE9 VARCHAR2 (150)
PROJECT_ATTRIBUTE10 VARCHAR2 (150)
PROJECT_ATTRIBUTE11 VARCHAR2 (150)
PROJECT_ATTRIBUTE12 VARCHAR2 (150)
PROJECT_ATTRIBUTE13 VARCHAR2 (150)
PROJECT_ATTRIBUTE14 VARCHAR2 (150)
PROJECT_ATTRIBUTE15 VARCHAR2 (150)
VAR_RENT_INV_ID NUMBER (38)
VAR_RENT_TYPE VARCHAR2 (20)
CHANGED_FLAG VARCHAR2 (20)
NORM_START_DATE DATE

TERM_TEMPLATE_ID NUMBER (15)
EVENT_TYPE_CODE VARCHAR2 (30)
LEASE_STATUS VARCHAR2 (30)
NORM_END_DATE DATE

RECOVERABLE_FLAG VARCHAR2 (1)
PERIOD_BILLREC_ID NUMBER (15)
AMOUNT_TYPE VARCHAR2 (30)
REC_AGR_LINE_ID NUMBER (15)
GROUPING_RULE_ID NUMBER (15)
AREA_TYPE_CODE VARCHAR2 (30)
AREA NUMBER

TERM_ALTERED_FLAG VARCHAR2 (1)
SOURCE_CODE VARCHAR2 (30)
TERM_COMMENTS VARCHAR2 (2000)
LEGAL_ENTITY_ID NUMBER (15)
TAX_CLASSIFICATION_CODE VARCHAR2 (30)
INDEX_NORM_FLAG VARCHAR2 (1)
PARENT_TERM_ID NUMBER

INCLUDE_IN_VAR_RENT VARCHAR2 (30)
UPDATE_NBP_FLAG VARCHAR2 (1)
RECUR_BB_CALC_DATE DATE

OPEX_TYPE VARCHAR2 (30)
OPEX_AGR_ID NUMBER

OPEX_RECON_ID NUMBER

Query Text

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


SELECT PAYMENT_TERM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PAYMENT_PURPOSE_CODE
,      PAYMENT_TERM_TYPE_CODE
,      FREQUENCY_CODE
,      LEASE_ID
,      LEASE_CHANGE_ID
,      START_DATE
,      END_DATE
,      CODE_COMBINATION_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      TARGET_DATE
,      ACTUAL_AMOUNT
,      ESTIMATED_AMOUNT
,      SET_OF_BOOKS_ID
,      CURRENCY_CODE
,      RATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      NORMALIZE
,      LOCATION_ID
,      SCHEDULE_DAY
,      CUST_SHIP_SITE_ID
,      AP_AR_TERM_ID
,      CUST_TRX_TYPE_ID
,      PROJECT_ID
,      TASK_ID
,      ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      TAX_GROUP_ID
,      TAX_CODE_ID
,      TAX_INCLUDED
,      DISTRIBUTION_SET_ID
,      INV_RULE_ID
,      ACCOUNT_RULE_ID
,      SALESREP_ID
,      APPROVED_BY
,      STATUS
,      INDEX_PERIOD_ID
,      INDEX_TERM_INDICATOR
,      PO_HEADER_ID
,      CUST_PO_NUMBER
,      RECEIPT_METHOD_ID
,      PROJECT_ATTRIBUTE_CATEGORY
,      PROJECT_ATTRIBUTE1
,      PROJECT_ATTRIBUTE2
,      PROJECT_ATTRIBUTE3
,      PROJECT_ATTRIBUTE4
,      PROJECT_ATTRIBUTE5
,      PROJECT_ATTRIBUTE6
,      PROJECT_ATTRIBUTE7
,      PROJECT_ATTRIBUTE8
,      PROJECT_ATTRIBUTE9
,      PROJECT_ATTRIBUTE10
,      PROJECT_ATTRIBUTE11
,      PROJECT_ATTRIBUTE12
,      PROJECT_ATTRIBUTE13
,      PROJECT_ATTRIBUTE14
,      PROJECT_ATTRIBUTE15
,      VAR_RENT_INV_ID
,      VAR_RENT_TYPE
,      CHANGED_FLAG
,      NORM_START_DATE
,      TERM_TEMPLATE_ID
,      EVENT_TYPE_CODE
,      LEASE_STATUS
,      NORM_END_DATE
,      RECOVERABLE_FLAG
,      PERIOD_BILLREC_ID
,      AMOUNT_TYPE
,      REC_AGR_LINE_ID
,      GROUPING_RULE_ID
,      AREA_TYPE_CODE
,      AREA
,      TERM_ALTERED_FLAG
,      SOURCE_CODE
,      TERM_COMMENTS
,      LEGAL_ENTITY_ID
,      TAX_CLASSIFICATION_CODE
,      INDEX_NORM_FLAG
,      PARENT_TERM_ID
,      INCLUDE_IN_VAR_RENT
,      UPDATE_NBP_FLAG
,      RECUR_BB_CALC_DATE
,      OPEX_TYPE
,      OPEX_AGR_ID
,      OPEX_RECON_ID
FROM PN.PN_PAYMENT_TERMS_ALL#;

Dependencies

[top of page]

PN.PN_PAYMENT_TERMS_ALL# references the following:

SchemaPN
TablePN_PAYMENT_TERMS_ALL
PN.PN_PAYMENT_TERMS_ALL# is referenced by following:

SchemaAPPS
SynonymPN_PAYMENT_TERMS
SynonymPN_PAYMENT_TERMS_ALL