VIEW: PN.PN_PAYMENT_TERMS_ALL#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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