AP_SUPPLIER_BALANCE_ITF

This is an interface table that stores all the records for the submission of the AP Supplier Open Balance Letter report, as per the parameters specified by the user during the report submission. AP_SUPPLIER_BALANCE_ITF is a denormalized table used for storing the Organization Name, Address, Supplier and Supplier Site level information. Each row in this table stores invoice amount, payment amount, discount taken, discount available, original prepayment amount, prepayment amount applied to an invoice, prepayment amount remaining and the prepayment amount applied. Using this information, the supplier open balance letter calculates the supplier open balance and publishes it in the form of a letter.

Details

• Schema: FUSION

• Object owner: AP

• Object type: TABLE

• Tablespace: SUMMARY

Columns

Name	Datatype	Length	Precision	Not-null	Comments
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
AS_OF_DATE	DATE			Yes	Date until when open transactions are included for the report.
ORGANIZATION_NAME	VARCHAR2	240		Yes	Operating unit selected for generating the report.
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	15		Yes	Functional currency code of the invoice.
SUPPLIER_NAME	VARCHAR2	240		Yes	Supplier name entered on the invoice.
SUPPLIER_NUMBER	VARCHAR2	30		Yes	Supplier number on the invoice.
TAX_PAYER_ID	VARCHAR2	30			Tax identification number of supplier on the invoice.
VAT_REGISTRATION_NUMBER	VARCHAR2	20			VAT registration number of supplier on the invoice.
SUPPLIER_SITE_CODE	VARCHAR2	15		Yes	Supplier site code on the invoice selected for the report.
ADDRESS_LINE1	VARCHAR2	240			First line of supplier site street address.
ADDRESS_LINE2	VARCHAR2	240			Second line of supplier site street address.
ADDRESS_LINE3	VARCHAR2	240			Third line of supplier site street address.
CITY	VARCHAR2	60			City of the supplier site on the invoice.
STATE	VARCHAR2	150			State of the supplier site on the invoice.
ZIP	VARCHAR2	60			Postal Code of supplier site on the invoice.
PROVINCE	VARCHAR2	150			Province of supplier on the invoice.
COUNTRY	VARCHAR2	60			Country of supplier site on the invoice.
INVOICE_TYPE	VARCHAR2	80		Yes	Invoice type of the invoice selected for the report.
INVOICE_NUM	VARCHAR2	50		Yes	Invoice number of the invoice selected for the report.
INVOICE_DATE	DATE			Yes	Date of the invoice selected for the report.
INVOICE_CURRENCY_CODE	VARCHAR2	15		Yes	Currency of the invoice selected for the report.
INVOICE_AMOUNT	NUMBER				Total amount of the invoice in invoice currency.
AMOUNT_REMAINING	NUMBER				Balance amount payable on the invoice.
PAYMENT_AMOUNT	NUMBER				Amount paid on the invoice selected for the report.
DISCOUNT_TAKEN	NUMBER				Discount amount taken during payment of invoice.
DISCOUNT_AMOUNT_AVAILABLE	NUMBER				Discount amount available on the invoice.
INV_PREPAYMENT_AMOUNT	NUMBER				Prepayment amount on the invoice.
PREPAY_AMOUNT_ORIGINAL	NUMBER				Original prepayment amount on the invoice.
PREPAY_AMOUNT_REMAINING	NUMBER				Prepayment amount remaining on the invoice.
PREPAY_AMOUNT_APPLIED	NUMBER				Prepayment Amount applied to an Invoice
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.