[Home] [Help]
[Dependency Information]
Object Name: | IGI_STP_PACKAGES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
IGI_STP_PACKAGES_V is a multiple-organizations view that displays information on single third party netting batch transactions.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | Organization ID | ||
ROW_ID | ROWID | (10) | Row ID | |
BATCH_ID | NUMBER | Batch ID | ||
PACKAGE_ID | NUMBER | Package ID | ||
PACKAGE_NUM | NUMBER | Package number | ||
CUSTOMER_NAME | VARCHAR2 | (50) | Customer name | |
STP_ID | NUMBER | Single third party ID | ||
SITE_CODE | VARCHAR2 | (40) | Site code | |
APPLICATION | VARCHAR2 | (2) | Application, Payables (AP) or Receivables (AR) | |
APPLICATION_NAME | VARCHAR2 | (240) | Application name | |
ACCOUNTING_DATE | DATE | Accounting date | ||
TRX_NUMBER | VARCHAR2 | (20) | Transaction number | |
RELATED_TRX_NUMBER | VARCHAR2 | (20) | Related transaction number | |
REFERENCE | VARCHAR2 | (20) | Reference | |
NETTING_TRX_TYPE | VARCHAR2 | (80) | Netting transaction type | |
DOCUMENT_TRX_TYPE | CHAR | (30) | Document transaction type | |
AMOUNT | NUMBER | Amount | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Conversion type for converting foreign currency transactions | |
EXCHANGE_RATE | NUMBER | Exchange rate for converting foreign currency into functional currency | ||
EXCHANGE_DATE | DATE | The exchange rate date | ||
USER_RATE_TYPE | VARCHAR2 | (30) | User rate type | |
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, ROW_ID
, BATCH_ID
, PACKAGE_ID
, PACKAGE_NUM
, CUSTOMER_NAME
, STP_ID
, SITE_CODE
, APPLICATION
, APPLICATION_NAME
, ACCOUNTING_DATE
, TRX_NUMBER
, RELATED_TRX_NUMBER
, REFERENCE
, NETTING_TRX_TYPE
, DOCUMENT_TRX_TYPE
, AMOUNT
, CURRENCY_CODE
, EXCHANGE_RATE_TYPE
, EXCHANGE_RATE
, EXCHANGE_DATE
, USER_RATE_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGI_STP_PACKAGES_V;
APPS.IGI_STP_PACKAGES_V is not referenced by any database object
|
|
|