[Home] [Help] [Dependency Information]
Object Name: | PN_PAYMENT_TERMS_EFC# |
---|---|
Object Type: | VIEW |
Owner: | PN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYMENT_TERM_ID | NUMBER | Yes | ||
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 | Yes | ||
ACTUAL_AMOUNT | NUMBER | |||
ESTIMATED_AMOUNT | NUMBER | |||
SET_OF_BOOKS_ID | NUMBER | Yes | ||
CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
RATE | NUMBER | Yes | ||
NORMALIZE | VARCHAR2 | (1) | ||
VENDOR_ID | NUMBER | |||
VENDOR_SITE_ID | NUMBER | |||
CUSTOMER_ID | NUMBER | |||
CUSTOMER_SITE_USE_ID | NUMBER | |||
ORG_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_TERM_ID
, PAYMENT_PURPOSE_CODE
, PAYMENT_TERM_TYPE_CODE
, FREQUENCY_CODE
, LEASE_ID
, LEASE_CHANGE_ID
, START_DATE
, END_DATE
, CODE_COMBINATION_ID
, ACTUAL_AMOUNT
, ESTIMATED_AMOUNT
, SET_OF_BOOKS_ID
, CURRENCY_CODE
, RATE
, NORMALIZE
, VENDOR_ID
, VENDOR_SITE_ID
, CUSTOMER_ID
, CUSTOMER_SITE_USE_ID
, ORG_ID
FROM PN.PN_PAYMENT_TERMS_EFC#;
|
|
|