[Home] [Help] [Dependency Information]
Object Name: | FV_PROMPT_PAY_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | FV |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (15) | ||
PAY_INVOICE_ID | NUMBER | (15) | ||
PAY_PAYMENT_NUMBER | NUMBER | (15) | ||
PAY_DUE_DATE | DATE | |||
DISCOUNT_AMOUNT_AVAILABLE | NUMBER | |||
INVOICE_PAYMENT_ID | NUMBER | (15) | ||
DISCOUNT_TAKEN | NUMBER | |||
CHECK_DATE | DATE | |||
INVOICE_AMOUNT | NUMBER | |||
INVOICE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, PAY_INVOICE_ID
, PAY_PAYMENT_NUMBER
, PAY_DUE_DATE
, DISCOUNT_AMOUNT_AVAILABLE
, INVOICE_PAYMENT_ID
, DISCOUNT_TAKEN
, CHECK_DATE
, INVOICE_AMOUNT
, INVOICE_TYPE_LOOKUP_CODE
FROM FV.FV_PROMPT_PAY_TEMP#;
|
|
|