[Home] [Help] [Dependency Information]
Object Name: | IGI_RPI_STANDING_CHARGES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGI.IGI_RPI_STANDING_CHARGES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHARGE_REFERENCE | VARCHAR2 | (50) | Yes | User-specified standing charge reference |
STATUS | VARCHAR2 | (25) | Yes | Standing charge status lookup code |
TERM_ID | NUMBER | |||
STANDING_CHARGE_DATE | DATE | |||
TRANSACTION_TYPE_NAME | VARCHAR2 | (20) | ||
TERM_ID_NAME | VARCHAR2 | (15) | Yes | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
BATCH_SOURCE_NAME | VARCHAR2 | (50) | Yes | |
SALESPERSON | VARCHAR2 | (240) | ||
BILL_TO_CUSTOMER | VARCHAR2 | (50) | ||
BILL_TO_NUMBER | VARCHAR2 | (30) | Yes | |
BILL_ADDRESS1 | VARCHAR2 | (240) | Yes | |
BILL_ADDRESS2 | VARCHAR2 | (240) | ||
BILL_ADDRESS3 | VARCHAR2 | (240) | ||
BILL_CONTACT | VARCHAR2 | (102) | ||
SHIP_TO_CUSTOMER | VARCHAR2 | (50) | ||
SHIP_TO_NUMBER | VARCHAR2 | (30) | ||
SHIP_ADDRESS1 | VARCHAR2 | (240) | ||
SHIP_ADDRESS2 | VARCHAR2 | (240) | ||
SHIP_ADDRESS3 | VARCHAR2 | (240) | ||
SHIP_CONTACT | VARCHAR2 | (102) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
COMMENTS | VARCHAR2 | (240) | ||
START_DATE | DATE | Yes | ||
END_DATE | DATE | |||
PERIOD_NAME | VARCHAR2 | (25) | Yes | |
ADVANCE_ARREARS_IND | VARCHAR2 | (7) | ||
NEXT_DUE_DATE | DATE | Yes | ||
REMINDER_DAYS | NUMBER | |||
REVIEW_DATE | DATE | |||
SUPPRESS_INV_PRINT | VARCHAR2 | (1) | ||
RECEIPT_METHOD_NAME | VARCHAR2 | (30) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
CUST_TRX_TYPE_ID | NUMBER | (15) | Yes | |
GENERATE_SEQUENCE | NUMBER | (15) | ||
STANDING_CHARGE_ID | NUMBER | (15) | Yes | |
SALESREP_ID | NUMBER | (15) | Yes | |
BATCH_SOURCE_ID | NUMBER | (15) | Yes | |
BILL_TO_CUSTOMER_ID | NUMBER | (15) | Yes | |
SHIP_TO_CUSTOMER_ID | NUMBER | (15) | ||
BILL_TO_ADDRESS_ID | NUMBER | (15) | ||
SHIP_TO_ADDRESS_ID | NUMBER | (15) | ||
BILL_TO_CONTACT_ID | NUMBER | (15) | ||
SHIP_TO_CONTACT_ID | NUMBER | (15) | ||
RECEIPT_METHOD_ID | NUMBER | (15) | ||
BANK_ACCOUNT_ID | NUMBER | (15) | ||
BILL_TO_SITE_USE_ID | NUMBER | (15) | Yes | |
SHIP_TO_SITE_USE_ID | NUMBER | (15) | ||
CUSTOMER_ID | NUMBER | (15) | Yes | |
PREVIOUS_DUE_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
ROW_ID | ROWID | (10) | ||
COMPONENT | VARCHAR2 | (25) | Yes | |
DEFAULT_INVOICING_RULE | VARCHAR2 | (30) | ||
ORG_ID | NUMBER | |||
LEGAL_ENTITY_ID | NUMBER | |||
LEGAL_ENTITY_NAME | VARCHAR2 | (240) | Yes | |
OPERATING_UNIT | VARCHAR2 | (240) | Yes | |
PAYMENT_TRXN_EXTENSION_ID | NUMBER | Payment Extension Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT CHARGE_REFERENCE
, STATUS
, TERM_ID
, STANDING_CHARGE_DATE
, TRANSACTION_TYPE_NAME
, TERM_ID_NAME
, CURRENCY_CODE
, BATCH_SOURCE_NAME
, SALESPERSON
, BILL_TO_CUSTOMER
, BILL_TO_NUMBER
, BILL_ADDRESS1
, BILL_ADDRESS2
, BILL_ADDRESS3
, BILL_CONTACT
, SHIP_TO_CUSTOMER
, SHIP_TO_NUMBER
, SHIP_ADDRESS1
, SHIP_ADDRESS2
, SHIP_ADDRESS3
, SHIP_CONTACT
, DESCRIPTION
, COMMENTS
, START_DATE
, END_DATE
, PERIOD_NAME
, ADVANCE_ARREARS_IND
, NEXT_DUE_DATE
, REMINDER_DAYS
, REVIEW_DATE
, SUPPRESS_INV_PRINT
, RECEIPT_METHOD_NAME
, SET_OF_BOOKS_ID
, CUST_TRX_TYPE_ID
, GENERATE_SEQUENCE
, STANDING_CHARGE_ID
, SALESREP_ID
, BATCH_SOURCE_ID
, BILL_TO_CUSTOMER_ID
, SHIP_TO_CUSTOMER_ID
, BILL_TO_ADDRESS_ID
, SHIP_TO_ADDRESS_ID
, BILL_TO_CONTACT_ID
, SHIP_TO_CONTACT_ID
, RECEIPT_METHOD_ID
, BANK_ACCOUNT_ID
, BILL_TO_SITE_USE_ID
, SHIP_TO_SITE_USE_ID
, CUSTOMER_ID
, PREVIOUS_DUE_DATE
, LAST_UPDATE_DATE
, CREATION_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
, ROW_ID
, COMPONENT
, DEFAULT_INVOICING_RULE
, ORG_ID
, LEGAL_ENTITY_ID
, LEGAL_ENTITY_NAME
, OPERATING_UNIT
, PAYMENT_TRXN_EXTENSION_ID
FROM APPS.IGI_RPI_STANDING_CHARGES_V;
APPS.IGI_RPI_STANDING_CHARGES_V is not referenced by any database object
|
|
|