AP_PERIOD_CLOSE_EXCPS_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
Columns
| Name |
|---|
|
INVOICE_IDNUMBER18Oracle internal use only INVOICE_DISTRIBUTION_IDNUMBER18Oracle internal use only INVOICE_LINE_NUMBERNUMBER18Oracle internal use only ACCOUNTING_DATEDATEOracle internal use only ORG_IDNUMBER18YesIndicates the identifier of the business unit associated to the row. INVOICE_NUMVARCHAR250Oracle internal use only INVOICE_CURRENCY_CODEVARCHAR230Oracle internal use only PARTY_IDNUMBER18Oracle internal use only DOC_SEQUENCE_VALUENUMBER18Oracle internal use only VOUCHER_NUMVARCHAR250Oracle internal use only INVOICE_DATEDATEOracle internal use only INVOICE_AMOUNTNUMBEROracle internal use only CANCELLED_DATEDATEOracle internal use only MATCH_STATUS_FLAGVARCHAR21Oracle internal use only PAYMENT_HISTORY_IDNUMBER18Oracle internal use only INVOICE_PAYMENT_IDNUMBER18Oracle internal use only ACCOUNTING_EVENT_IDNUMBER18Oracle internal use only CHECK_IDNUMBER18Oracle internal use only PAYMENT_AMOUNTNUMBEROracle internal use only RECON_ACCOUNTING_FLAGVARCHAR21Oracle internal use only TRANSACTION_TYPEVARCHAR230Oracle internal use only LEGAL_ENTITY_IDNUMBER18Oracle internal use only PO_DISTRIBUTION_IDNUMBER18Oracle internal use only DETAIL_TAX_DIST_IDNUMBEROracle internal use only AMOUNTNUMBEROracle internal use only CHECK_NUMBERNUMBER18Oracle internal use only CHECK_AMOUNTNUMBEROracle internal use only CHECK_DATEDATEOracle internal use only EXCHANGE_RATENUMBEROracle internal use only VENDOR_NAMEVARCHAR2240Oracle internal use only BANK_ACCOUNT_NAMEVARCHAR280Oracle internal use only CURRENCY_CODEVARCHAR215Oracle internal use only STATUS_LOOKUP_CODEVARCHAR225Oracle internal use only SOURCE_TYPEVARCHAR230Oracle internal use only SOURCE_TABLE_NAMEVARCHAR230Oracle internal use only PROCESS_STATUS_FLAGVARCHAR21Oracle internal use only EVENT_TYPE_CODEVARCHAR230Oracle internal use only ENTITY_CODEVARCHAR230Oracle internal use only INVOICE_TYPE_LOOKUP_CODEVARCHAR225Oracle internal use only |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| AP_PERIOD_CLOSE_EXCPS_GT_N1 | Non Unique | SOURCE_TYPE, SOURCE_TABLE_NAME |
| AP_PERIOD_CLOSE_EXCPS_GT_N2 | Non Unique | ACCOUNTING_EVENT_ID |
| AP_PERIOD_CLOSE_EXCPS_GT_N3 | Non Unique | INVOICE_DISTRIBUTION_ID, SOURCE_TYPE, SOURCE_TABLE_NAME |
| AP_PERIOD_CLOSE_EXCPS_GT_N4 | Non Unique | INVOICE_ID, INVOICE_LINE_NUMBER |