[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_SUPPLIER_BALANCE_ITF |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_SUPPLIER_BALANCE_ITF
|
| Subobject Name: | |
| Status: | VALID |
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.
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REQUEST_ID | NUMBER | (15) | Yes | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| AS_OF_DATE | DATE | Yes | As of Date | |
| ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Organization Name |
| FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Functional Currency Code |
| SUPPLIER_NAME | VARCHAR2 | (240) | Yes | Supplier's Name |
| SUPPLIER_NUMBER | VARCHAR2 | (30) | Yes | Supplier's Number (Internal) |
| TAX_PAYER_ID | VARCHAR2 | (30) | Tax Identification Number | |
| VAT_REGISTRATION_NUMBER | VARCHAR2 | (20) | Supplier's VAT Registration | |
| SUPPLIER_SITE_CODE | VARCHAR2 | (15) | Yes | Supplier Site Code |
| ADDRESS_LINE1 | VARCHAR2 | (240) | Supplier's Address Line 1 | |
| ADDRESS_LINE2 | VARCHAR2 | (240) | Supplier's Address Line 2 | |
| ADDRESS_LINE3 | VARCHAR2 | (240) | Supplier's Address Line 3 | |
| CITY | VARCHAR2 | (25) | Supplier's City | |
| STATE | VARCHAR2 | (150) | Supplier's State | |
| ZIP | VARCHAR2 | (20) | Supplier's Zip Code | |
| PROVINCE | VARCHAR2 | (150) | Supplier's Province | |
| COUNTRY | VARCHAR2 | (25) | Supplier's Country | |
| INVOICE_TYPE | VARCHAR2 | (80) | Yes | Invoice Type |
| INVOICE_NUM | VARCHAR2 | (50) | Yes | Invoice Number |
| INVOICE_DATE | DATE | Yes | Date of the Invoice | |
| INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency of the Invoice |
| INVOICE_AMOUNT | NUMBER | Amount of the Invoice | ||
| AMOUNT_REMAINING | NUMBER | Balance on the Invoice | ||
| PAYMENT_AMOUNT | NUMBER | Amount Paid | ||
| DISCOUNT_TAKEN | NUMBER | Discount Amount Taken | ||
| DISCOUNT_AMOUNT_AVAILABLE | NUMBER | Discount Amount Available | ||
| INV_PREPAYMENT_AMOUNT | NUMBER | Prepayment Amount | ||
| PREPAY_AMOUNT_ORIGINAL | NUMBER | Original Prepayment Amount | ||
| PREPAY_AMOUNT_REMAINING | NUMBER | Prepayment Amount Remaining | ||
| PREPAY_AMOUNT_APPLIED | NUMBER | Prepayment Amount applied to an Invoice |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, AS_OF_DATE
, ORGANIZATION_NAME
, FUNCTIONAL_CURRENCY_CODE
, SUPPLIER_NAME
, SUPPLIER_NUMBER
, TAX_PAYER_ID
, VAT_REGISTRATION_NUMBER
, SUPPLIER_SITE_CODE
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, CITY
, STATE
, ZIP
, PROVINCE
, COUNTRY
, INVOICE_TYPE
, INVOICE_NUM
, INVOICE_DATE
, INVOICE_CURRENCY_CODE
, INVOICE_AMOUNT
, AMOUNT_REMAINING
, PAYMENT_AMOUNT
, DISCOUNT_TAKEN
, DISCOUNT_AMOUNT_AVAILABLE
, INV_PREPAYMENT_AMOUNT
, PREPAY_AMOUNT_ORIGINAL
, PREPAY_AMOUNT_REMAINING
, PREPAY_AMOUNT_APPLIED
FROM AP.AP_SUPPLIER_BALANCE_ITF;
AP.AP_SUPPLIER_BALANCE_ITF does not reference any database object
AP.AP_SUPPLIER_BALANCE_ITF is referenced by following:
APPS
AP_SUPPLIER_BALANCE_ITF
|
|
|
|