AP_TRIAL_BALANCES_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 | Precision | Comments |
|---|---|---|---|---|
| LEDGER_ID | NUMBER | 18 | Oracle internal use only | |
| INVOICE_ID | NUMBER | 18 | Oracle Payables Internal Use Only | |
| INVOICE_TYPE | VARCHAR2 | 80 | Oracle internal use only | |
| LEDGER_NAME | VARCHAR2 | 30 | Oracle internal use only | |
| LEDGER_SHORT_NAME | VARCHAR2 | 20 | Oracle internal use only | |
| LEDGER_CURRENCY_CODE | VARCHAR2 | 15 | Oracle internal use only | |
| INVOICE_NUMBER | VARCHAR2 | 50 | Oracle internal use only | |
| INVOICE_AMOUNT | NUMBER | Oracle internal use only | ||
| INVOICE_DATE | DATE | Oracle internal use only | ||
| INVOICE_DESCRIPTION | VARCHAR2 | 240 | Oracle internal use only | |
| CANCELLED_DATE | DATE | Oracle internal use only | ||
| PAYMENT_STATUS | VARCHAR2 | 30 | Oracle internal use only | |
| CODE_COMBINATION_ID | NUMBER | 18 | Oracle internal use only | |
| ACCOUNTING_DATE | DATE | Oracle internal use only | ||
| ENTERED_ORIG_AMOUNT | NUMBER | Oracle internal use only | ||
| ENTERED_REM_AMOUNT | NUMBER | Oracle internal use only | ||
| ACCOUNTED_ORIG_AMOUNT | NUMBER | Oracle internal use only | ||
| ACCOUNTED_REM_AMOUNT | NUMBER | Oracle internal use only | ||
| PARTY_ID | NUMBER | 18 | Oracle internal use only | |
| PARTY_NAME | VARCHAR2 | 360 | Oracle internal use only | |
| TRX_CURRENCY_CODE | VARCHAR2 | 15 | Oracle internal use only |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| AP_TRIAL_BALANCES_GT_N1 | Non Unique | INVOICE_ID |