AR_IL_CASH_RECEIPTS_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| CASH_RECEIPT_ID | NUMBER | 18 | Oracle internal use only | |
| RECEIPT_NUMBER | VARCHAR2 | 30 | Oracle internal use only | |
| RECEIPT_DATE | DATE | Oracle internal use only | ||
| RECEIPT_STATUS | VARCHAR2 | 30 | Oracle internal use only | |
| DOCUMENT_NUMBER | NUMBER | 18 | Oracle internal use only | |
| RECEIPT_AMOUNT | NUMBER | Oracle internal use only | ||
| CURRENCY | VARCHAR2 | 15 | Oracle internal use only | |
| MATURITY_DATE | DATE | Oracle internal use only | ||
| METHOD_NAME | VARCHAR2 | 30 | Oracle internal use only | |
| BANK_ACCOUNT | VARCHAR2 | 100 | Oracle internal use only | |
| BANK_NAME | VARCHAR2 | 360 | Oracle internal use only | |
| BANK_BRANCH_NAME | VARCHAR2 | 360 | Oracle internal use only | |
| CUSTOMER_NAME | VARCHAR2 | 360 | Oracle internal use only | |
| CUSTOMER_NUMBER | VARCHAR2 | 30 | Oracle internal use only | |
| TAX_REGISTRATION_NUMBER | VARCHAR2 | 50 | Oracle internal use only | |
| CUST_ACCOUNT_ID | NUMBER | 18 | Oracle internal use only | |
| CUST_ACCT_SITE_ID | NUMBER | 18 | Oracle internal use only | |
| ADDRESS_LINE1 | VARCHAR2 | 240 | Oracle internal use only | |
| ADDRESS_LINE2 | VARCHAR2 | 240 | Oracle internal use only | |
| USER_NAME | VARCHAR2 | 150 | Oracle internal use only | |
| CITY | VARCHAR2 | 60 | Oracle internal use only | |
| POSTAL_CODE | VARCHAR2 | 10 | Oracle internal use only | |
| COPY_OR_ORIGINAL | VARCHAR2 | 15 | Oracle internal use only | |
| IL_INFO_V1 | VARCHAR2 | 150 | Oracle internal use only | |
| IL_INFO_V2 | VARCHAR2 | 150 | Oracle internal use only | |
| IL_INFO_V3 | VARCHAR2 | 150 | Oracle internal use only | |
| IL_INFO_V4 | VARCHAR2 | 150 | Oracle internal use only | |
| IL_INFO_V5 | VARCHAR2 | 150 | Oracle internal use only | |
| IL_INFO_V6 | VARCHAR2 | 150 | Oracle internal use only | |
| IL_INFO_V7 | VARCHAR2 | 240 | Oracle internal use only | |
| IL_INFO_V8 | VARCHAR2 | 240 | Oracle internal use only | |
| IL_INFO_V9 | VARCHAR2 | 240 | Oracle internal use only | |
| IL_INFO_V10 | VARCHAR2 | 240 | Oracle internal use only | |
| IL_INFO_D1 | DATE | Oracle internal use only | ||
| IL_INFO_D2 | DATE | Oracle internal use only | ||
| IL_INFO_N1 | NUMBER | Oracle internal use only | ||
| IL_INFO_N2 | NUMBER | Oracle internal use only | ||
| IL_INFO_N3 | NUMBER | Oracle internal use only | ||
| IL_INFO_N4 | NUMBER | Oracle internal use only | ||
| IL_INFO_N5 | NUMBER | Oracle internal use only |