AP_CROSS_CURRENCY_RATE_GT

This table contains temporary information for Cash Requirement Report.It is introduced to avoid the twice scan of the AP_INVOICES_ALL and AP_INVOICE_PAYMENTS_ALL and help to offer the required information in the before trigger of the Cash Requirement report execution .

Details

• Schema: FUSION

• Object owner: AP

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
AP_CROSS_CURRENCY_RATE_GT_PK	PROCESS_ID, INVOICE_ID, PAYMENT_NUM

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PAYMENT_CURRENCY_CODE	VARCHAR2	15		Yes	Currency code of payment (must be same as INVOICE_CURRENCY_CODE or have a fixed rate relationship)
INVOICE_CURRENCY_CODE	VARCHAR2	15		Yes	Currency code used on the invoice.
CROSS_CURRENCY_RATE	NUMBER			Yes	Exchange rate between invoice and payment
PROCESS_ID	NUMBER		18	Yes	Unique process identifier
INVOICE_ID	NUMBER		18	Yes	Unique invoice identifier.
PARTY_NAME	VARCHAR2	360		Yes	Name of this party
INVOICE_NUM	VARCHAR2	50		Yes	Unique number for supplier invoice.
BASE_CURRENCY_CODE	VARCHAR2	15		Yes	Functional currency code associated with the ledger.
PAY_GROUP_LOOKUP_CODE	VARCHAR2	25			Groups a category of suppliers or invoices for single pay run. For example, employees, merchandise, nonmerchandise, government, domestic, and international.
DUE_DATE	DATE				Date when the invoice or installment is due for payment.
DISCOUNT_DATE	DATE				Date first discount is available
SECOND_DISCOUNT_DATE	DATE				Date second discount is available
THIRD_DISCOUNT_DATE	DATE				Date third discount is available
AMOUNT_REMAINING	NUMBER				Invoice amount remaining for payment
GROSS_AMOUNT	NUMBER				Gross amount due for a scheduled payment
DISCOUNT_AMOUNT_AVAILABLE	NUMBER				Discount amount available at first discount date
SECOND_DISC_AMT_AVAILABLE	NUMBER				Discount amount available at second discount date
THIRD_DISC_AMT_AVAILABLE	NUMBER				Discount amount available at third discount date
EXCHANGE_RATE	NUMBER				Ratio at which the principal unit of one currency is converted into another currency for an invoice.
ALWAYS_TAKE_DISC_FLAG	VARCHAR2	1			Indicates if available discount for supplier will be taken, regardless of when invoice is paid. Valid values are Y or N
ORG_ID	NUMBER		18		Indicates the identifier of the business unit associated to the row.
PAYMENT_NUM	NUMBER		18	Yes	Number used to identify a payment.
WFAPPROVAL_STATUS	VARCHAR2	50		Yes	Status of invoice in the Invoice Approval Workflow process. Valid values are from AP_WFAPPROVAL_STATUS lookup type.

Indexes

Index	Uniqueness	Columns
AP_CROSS_CURRENCY_RATE_GT_U1	Unique	PROCESS_ID, INVOICE_ID, PAYMENT_NUM