[Home] [Help] [Dependency Information]
Object Name: | AP_INV_SELECTION_CRITERIA_ALL# |
---|---|
Object Type: | VIEW |
Owner: | AP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHECKRUN_NAME | VARCHAR2 | (255) | Yes | |
CHECK_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
BANK_ACCOUNT_NAME | VARCHAR2 | (80) | ||
PERIOD_NAME | VARCHAR2 | (15) | ||
PAY_THRU_DATE | DATE | |||
VENDOR_PAY_GROUP | VARCHAR2 | (25) | ||
HI_PAYMENT_PRIORITY | NUMBER | (2) | ||
LOW_PAYMENT_PRIORITY | NUMBER | (2) | ||
MAX_PAYMENT_AMOUNT | NUMBER | |||
MIN_CHECK_AMOUNT | NUMBER | |||
MAX_OUTLAY | NUMBER | |||
PAY_ONLY_WHEN_DUE_FLAG | VARCHAR2 | (1) | ||
STATUS | VARCHAR2 | (25) | ||
CHECK_STOCK_ID | NUMBER | (15) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
EXCHANGE_RATE | NUMBER | |||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
EXCHANGE_DATE | DATE | |||
DOCUMENT_ORDER_LOOKUP_CODE | VARCHAR2 | (25) | ||
AUDIT_REQUIRED_FLAG | VARCHAR2 | (1) | ||
INTERVAL | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
VOLUME_SERIAL_NUMBER | VARCHAR2 | (6) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
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) | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
USSGL_TRX_CODE_CONTEXT | VARCHAR2 | (30) | ||
ZERO_AMOUNTS_ALLOWED | VARCHAR2 | (1) | ||
START_PRINT_DOCUMENT | NUMBER | (15) | ||
END_PRINT_DOCUMENT | NUMBER | (15) | ||
FIRST_VOUCHER_NUMBER | NUMBER | (15) | ||
FIRST_AVAILABLE_DOCUMENT | NUMBER | (15) | ||
PAYMENT_METHOD_LOOKUP_CODE | VARCHAR2 | (25) | ||
ZERO_INVOICES_ALLOWED | VARCHAR2 | (1) | ||
ORG_ID | NUMBER | (15) | ||
CHECKRUN_ID | NUMBER | (15) | Yes | |
BATCH_IDENTIFIER | VARCHAR2 | (30) | ||
BANK_ACCOUNT_ID | NUMBER | (15) | ||
TEMPLATE_FLAG | VARCHAR2 | (1) | ||
TRANSFER_PRIORITY | VARCHAR2 | (25) | ||
BATCH_RUN_NAME | VARCHAR2 | (30) | ||
BATCH_SET_ID | NUMBER | (15) | ||
BATCH_SET_LINE_ID | NUMBER | (15) | ||
FUTURE_DATED_PAYMENT_FLAG | VARCHAR2 | (30) | ||
ANTICIPATED_VALUE_DATE | DATE | |||
INVOICE_BATCH_ID | NUMBER | (15) | ||
VENDOR_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
REQUEST_ID | NUMBER | (15) | ||
TEMPLATE_ID | NUMBER | (15) | ||
PAY_FROM_DATE | DATE | |||
VENDOR_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | ||
PAYMENT_PROFILE_ID | NUMBER | (15) | ||
INV_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
PAYABLES_REVIEW_SETTINGS | VARCHAR2 | (1) | ||
CALC_AWT_INT_FLAG | VARCHAR2 | (1) | ||
PAYMENTS_REVIEW_SETTINGS | VARCHAR2 | (1) | ||
DOCUMENT_REJECTION_LEVEL_CODE | VARCHAR2 | (30) | ||
PAYMENT_REJECTION_LEVEL_CODE | VARCHAR2 | (30) | ||
CREATE_INSTRS_FLAG | VARCHAR2 | (1) | ||
PAY_GROUP_OPTION | VARCHAR2 | (10) | ||
CURRENCY_GROUP_OPTION | VARCHAR2 | (10) | ||
LE_GROUP_OPTION | VARCHAR2 | (10) | ||
OU_GROUP_OPTION | VARCHAR2 | (10) | ||
PAYMENT_METHOD_CODE | VARCHAR2 | (30) | ||
BANK_CHARGE_BEARER | VARCHAR2 | (30) | ||
SETTLEMENT_PRIORITY | VARCHAR2 | (30) | ||
RESUBMIT_FLAG | VARCHAR2 | (1) | ||
NEXT_VOUCHER_NUMBER | NUMBER | (15) | ||
PARTY_ID | NUMBER | (15) | ||
PAYMENT_DOCUMENT_ID | NUMBER | (15) | ||
CE_BANK_ACCT_USE_ID | NUMBER | (15) | ||
INV_AWT_EXISTS_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT CHECKRUN_NAME
, CHECK_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, BANK_ACCOUNT_NAME
, PERIOD_NAME
, PAY_THRU_DATE
, VENDOR_PAY_GROUP
, HI_PAYMENT_PRIORITY
, LOW_PAYMENT_PRIORITY
, MAX_PAYMENT_AMOUNT
, MIN_CHECK_AMOUNT
, MAX_OUTLAY
, PAY_ONLY_WHEN_DUE_FLAG
, STATUS
, CHECK_STOCK_ID
, CURRENCY_CODE
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, EXCHANGE_DATE
, DOCUMENT_ORDER_LOOKUP_CODE
, AUDIT_REQUIRED_FLAG
, INTERVAL
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, VOLUME_SERIAL_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, USSGL_TRANSACTION_CODE
, USSGL_TRX_CODE_CONTEXT
, ZERO_AMOUNTS_ALLOWED
, START_PRINT_DOCUMENT
, END_PRINT_DOCUMENT
, FIRST_VOUCHER_NUMBER
, FIRST_AVAILABLE_DOCUMENT
, PAYMENT_METHOD_LOOKUP_CODE
, ZERO_INVOICES_ALLOWED
, ORG_ID
, CHECKRUN_ID
, BATCH_IDENTIFIER
, BANK_ACCOUNT_ID
, TEMPLATE_FLAG
, TRANSFER_PRIORITY
, BATCH_RUN_NAME
, BATCH_SET_ID
, BATCH_SET_LINE_ID
, FUTURE_DATED_PAYMENT_FLAG
, ANTICIPATED_VALUE_DATE
, INVOICE_BATCH_ID
, VENDOR_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, TEMPLATE_ID
, PAY_FROM_DATE
, VENDOR_TYPE_LOOKUP_CODE
, PAYMENT_PROFILE_ID
, INV_EXCHANGE_RATE_TYPE
, PAYABLES_REVIEW_SETTINGS
, CALC_AWT_INT_FLAG
, PAYMENTS_REVIEW_SETTINGS
, DOCUMENT_REJECTION_LEVEL_CODE
, PAYMENT_REJECTION_LEVEL_CODE
, CREATE_INSTRS_FLAG
, PAY_GROUP_OPTION
, CURRENCY_GROUP_OPTION
, LE_GROUP_OPTION
, OU_GROUP_OPTION
, PAYMENT_METHOD_CODE
, BANK_CHARGE_BEARER
, SETTLEMENT_PRIORITY
, RESUBMIT_FLAG
, NEXT_VOUCHER_NUMBER
, PARTY_ID
, PAYMENT_DOCUMENT_ID
, CE_BANK_ACCT_USE_ID
, INV_AWT_EXISTS_FLAG
FROM AP.AP_INV_SELECTION_CRITERIA_ALL#;
|
|
|