AP_OPEN_ITEMS_REVAL_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| BALANCING_SEGMENT | VARCHAR2 | 25 | Oracle internal use only | |
| ACCOUNT_SEGMENT | VARCHAR2 | 25 | Oracle internal use only | |
| CODE_COMBINATION_ID | NUMBER | Yes | Oracle internal use only | |
| ACCOUNT | VARCHAR2 | 311 | Oracle internal use only | |
| VENDOR_ID | NUMBER | Oracle internal use only | ||
| PARTY_NAME | VARCHAR2 | 360 | Oracle internal use only | |
| VENDOR_NUMBER | VARCHAR2 | 30 | Oracle internal use only | |
| VENDOR_SITE_ID | NUMBER | Oracle internal use only | ||
| VENDOR_SITE_CODE | VARCHAR2 | 240 | Oracle internal use only | |
| PARTY_ID | NUMBER | Oracle internal use only | ||
| PARTY_SITE_ID | NUMBER | Oracle internal use only | ||
| TXN_ID | NUMBER | Yes | Oracle internal use only | |
| TXN_NUMBER | VARCHAR2 | 50 | Yes | Oracle internal use only |
| TXN_TYPE_LOOKUP_CODE | VARCHAR2 | 80 | Yes | Oracle internal use only |
| TXN_DATE | DATE | Oracle internal use only | ||
| TXN_AMOUNT | NUMBER | Oracle internal use only | ||
| TXN_BASE_AMOUNT | NUMBER | Oracle internal use only | ||
| TXN_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Oracle internal use only |
| TXN_CURR_MIN_ACCT_UNIT | NUMBER | Oracle internal use only | ||
| TXN_CURR_PRECISION | NUMBER | Oracle internal use only | ||
| TXN_BASE_EXCHANGE_RATE | NUMBER | Oracle internal use only | ||
| PAYMENT_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Oracle internal use only |
| PAYMENT_CROSS_RATE | NUMBER | Oracle internal use only | ||
| PAYMENT_CURR_PRECISION | NUMBER | Oracle internal use only | ||
| PMT_CURR_MIN_ACCT_UNIT | NUMBER | Oracle internal use only | ||
| PAYMENT_STATUS_FLAG | VARCHAR2 | 1 | Oracle internal use only | |
| ENTERED_AMOUNT | NUMBER | Oracle internal use only | ||
| ACCOUNTED_AMOUNT | NUMBER | Oracle internal use only | ||
| DUE_DATE | DATE | Oracle internal use only |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| AP_OPEN_ITEMS_REVAL_GT_N1 | Non Unique | TXN_NUMBER |
| AP_OPEN_ITEMS_REVAL_GT_N2 | Non Unique | VENDOR_ID, VENDOR_SITE_ID |
| AP_OPEN_ITEMS_REVAL_GT_N3 | Non Unique | PARTY_ID, PARTY_SITE_ID |
| AP_OPEN_ITEMS_REVAL_GT_N4 | Non Unique | TXN_ID, CODE_COMBINATION_ID |