[Home] [Help] [Dependency Information]
Object Name: | AR_IL_CASH_RECEIPTS_GT |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.AR_IL_CASH_RECEIPTS_GT |
Subobject Name: | |
Status: | VALID |
This is a global temporary table, used for israeli receipt printing program.
APPS.AR_IL_CASH_RECEIPTS_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CASH_RECEIPT_ID | NUMBER | (15) | Cash Receipt Id | |
RECEIPT_NUMBER | VARCHAR2 | (30) | ||
RECEIPT_DATE | DATE | Receipt Date | ||
RECEIPT_STATUS | VARCHAR2 | (30) | Receipt Status | |
DOCUMENT_NUMBER | NUMBER | (15) | Document Number | |
RECEIPT_AMOUNT | NUMBER | Receipt Amount | ||
CURRENCY | VARCHAR2 | (15) | Currency | |
CREDIT_CARD_NO | VARCHAR2 | (150) | Credit Card Number | |
CREDIT_CARD_TYPE | VARCHAR2 | (150) | Credit Card Type | |
MATURITY_DATE | DATE | Maturity Date | ||
METHOD_NAME | VARCHAR2 | (30) | Method Name | |
BANK_ACCOUNT | VARCHAR2 | (30) | ||
BANK_NAME | VARCHAR2 | (360) | Bank Name | |
BANK_BRANCH_NAME | VARCHAR2 | (360) | Bank Branch Name | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
CUSTOMER_NUMBER | VARCHAR2 | (30) | Customer Number | |
TAX_REGISTRATION_NUMBER | VARCHAR2 | (50) | Tax Registration Number | |
CUST_ACCOUNT_ID | NUMBER | (15) | Customer Account Id | |
CUST_ACCT_SITE_ID | NUMBER | (15) | Customer Account Site Id | |
ADDRESS_LINE1 | VARCHAR2 | (600) | Customer Address Line1 | |
ADDRESS_LINE2 | VARCHAR2 | (240) | Customer Address Line2 | |
USER_NAME | VARCHAR2 | (150) | User Name | |
ATTRIBUTE1 | VARCHAR2 | (150) | Attribute1 | |
ATTRIBUTE2 | VARCHAR2 | (150) | Attribute2 | |
CITY | VARCHAR2 | (150) | City | |
POSTAL_CODE | VARCHAR2 | (150) | Postal Code | |
COPY_OR_ORIGINAL | VARCHAR2 | (150) | Copy or Original |
Cut, paste (and edit) the following text to query this object:
SELECT CASH_RECEIPT_ID
, RECEIPT_NUMBER
, RECEIPT_DATE
, RECEIPT_STATUS
, DOCUMENT_NUMBER
, RECEIPT_AMOUNT
, CURRENCY
, CREDIT_CARD_NO
, CREDIT_CARD_TYPE
, MATURITY_DATE
, METHOD_NAME
, BANK_ACCOUNT
, BANK_NAME
, BANK_BRANCH_NAME
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, TAX_REGISTRATION_NUMBER
, CUST_ACCOUNT_ID
, CUST_ACCT_SITE_ID
, ADDRESS_LINE1
, ADDRESS_LINE2
, USER_NAME
, ATTRIBUTE1
, ATTRIBUTE2
, CITY
, POSTAL_CODE
, COPY_OR_ORIGINAL
FROM APPS.AR_IL_CASH_RECEIPTS_GT;
APPS.AR_IL_CASH_RECEIPTS_GT does not reference any database object
APPS.AR_IL_CASH_RECEIPTS_GT is referenced by following:
|
|
|