VIEW: AP.AP_PRODUCT_SETUP#

Source

View Text - Preformatted

select RECORD_NUMBER RECORD_NUMBER, SUPPLIER_NUMBERING_METHOD SUPPLIER_NUMBERING_METHOD, SUPPLIER_NUM_TYPE SUPPLIER_NUM_TYPE, NEXT_AUTO_SUPPLIER_NUM NEXT_AUTO_SUPPLIER_NUM, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE, SUPPLIER_PAY_GROUP_LOOKUP_CODE SUPPLIER_PAY_GROUP_LOOKUP_CODE, TERMS_DATE_BASIS TERMS_DATE_BASIS, PAY_DATE_BASIS_LOOKUP_CODE PAY_DATE_BASIS_LOOKUP_CODE, TERMS_ID TERMS_ID, PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE, ALWAYS_TAKE_DISC_FLAG ALWAYS_TAKE_DISC_FLAG, AUTO_CALCULATE_INTEREST_FLAG AUTO_CALCULATE_INTEREST_FLAG, MATCH_OPTION MATCH_OPTION, HOLD_UNMATCHED_INVOICES_FLAG HOLD_UNMATCHED_INVOICES_FLAG, USE_BANK_CHARGE_FLAG USE_BANK_CHARGE_FLAG, BANK_CHARGE_BEARER BANK_CHARGE_BEARER, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "AP"."AP_PRODUCT_SETUP"

View Text - HTML Formatted

SELECT RECORD_NUMBER RECORD_NUMBER
, SUPPLIER_NUMBERING_METHOD SUPPLIER_NUMBERING_METHOD
, SUPPLIER_NUM_TYPE SUPPLIER_NUM_TYPE
, NEXT_AUTO_SUPPLIER_NUM NEXT_AUTO_SUPPLIER_NUM
, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, SUPPLIER_PAY_GROUP_LOOKUP_CODE SUPPLIER_PAY_GROUP_LOOKUP_CODE
, TERMS_DATE_BASIS TERMS_DATE_BASIS
, PAY_DATE_BASIS_LOOKUP_CODE PAY_DATE_BASIS_LOOKUP_CODE
, TERMS_ID TERMS_ID
, PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE
, ALWAYS_TAKE_DISC_FLAG ALWAYS_TAKE_DISC_FLAG
, AUTO_CALCULATE_INTEREST_FLAG AUTO_CALCULATE_INTEREST_FLAG
, MATCH_OPTION MATCH_OPTION
, HOLD_UNMATCHED_INVOICES_FLAG HOLD_UNMATCHED_INVOICES_FLAG
, USE_BANK_CHARGE_FLAG USE_BANK_CHARGE_FLAG
, BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "AP"."AP_PRODUCT_SETUP"