AR_TRX_HEADER_TMP_GT

This is a temporary table which is used internally by Oracle.

Details

• Schema: FUSION

• Object owner: AR

• Object type: TABLE

Columns

Name

TRX_HEADER_IDNUMBEROracle internal use only. TRX_NUMBERVARCHAR230Oracle internal use only. TRX_DATEDATEOracle internal use only. TRX_CURRENCYVARCHAR230Oracle internal use only. REFERENCE_NUMBERVARCHAR230Oracle internal use only. TRX_CLASSVARCHAR220Oracle internal use only. CUST_TRX_TYPE_IDNUMBEROracle internal use only. GL_DATEDATEOracle internal use only. BILL_TO_CUSTOMER_IDNUMBEROracle internal use only. BILL_TO_ACCOUNT_NUMBERVARCHAR230Oracle internal use only. BILL_TO_CUSTOMER_NAMEVARCHAR2260Oracle internal use only. BILL_TO_CONTACT_IDNUMBEROracle internal use only. BILL_TO_ADDRESS_IDNUMBEROracle internal use only. BILL_TO_SITE_USE_IDNUMBEROracle internal use only. SHIP_TO_CUSTOMER_IDNUMBEROracle internal use only. SHIP_TO_ACCOUNT_NUMBERVARCHAR230Oracle internal use only. SHIP_TO_CUSTOMER_NAMEVARCHAR2260Oracle internal use only. SHIP_TO_CONTACT_IDNUMBEROracle internal use only. SHIP_TO_ADDRESS_IDNUMBEROracle internal use only. SHIP_TO_SITE_USE_IDNUMBEROracle internal use only. SOLD_TO_CUSTOMER_IDNUMBEROracle internal use only. TERM_IDNUMBEROracle internal use only. PRIMARY_SALESREP_IDNUMBEROracle internal use only. PRIMARY_SALESREP_NAMEVARCHAR2240Oracle internal use only. EXCHANGE_RATE_TYPEVARCHAR260Oracle internal use only. EXCHANGE_DATEDATEOracle internal use only. EXCHANGE_RATENUMBEROracle internal use only. TERRITORY_IDNUMBEROracle internal use only. REMIT_TO_ADDRESS_SEQ_IDNUMBEROracle internal use only. INVOICING_RULE_IDNUMBEROracle internal use only. PRINTING_OPTIONVARCHAR220Oracle internal use only. PURCHASE_ORDERVARCHAR250Oracle internal use only. PURCHASE_ORDER_REVISIONVARCHAR250Oracle internal use only. PURCHASE_ORDER_DATEDATEOracle internal use only. COMMENTSVARCHAR21760Oracle internal use only. INTERNAL_NOTESVARCHAR2240Oracle internal use only. FINANCE_CHARGESVARCHAR21Oracle internal use only. RECEIPT_METHOD_IDNUMBEROracle internal use only. RELATED_CUSTOMER_TRX_IDNUMBEROracle internal use only. AGREEMENT_IDNUMBEROracle internal use only. SHIP_VIAVARCHAR230Oracle internal use only. SHIP_DATE_ACTUALDATEOracle internal use only. WAYBILL_NUMBERVARCHAR250Oracle internal use only. FOB_POINTVARCHAR230Oracle internal use only. CUSTOMER_BANK_ACCOUNT_IDNUMBEROracle internal use only. DEFAULT_USSGL_TRANSACTION_CODEVARCHAR230Oracle internal use only. STATUS_TRXVARCHAR230Oracle internal use only. PAYING_CUSTOMER_IDNUMBEROracle internal use only. PAYING_SITE_USE_IDNUMBEROracle internal use only. DEFAULT_TAX_EXEMPT_FLAGVARCHAR21Oracle internal use only. DOC_SEQUENCE_VALUENUMBER18Oracle internal use only. ATTRIBUTE_CATEGORYVARCHAR230Descriptive Flexfield: structure definition of the user descriptive flexfield. ATTRIBUTE1VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE2VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE3VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE4VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE5VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE6VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE7VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE8VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE9VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE10VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE11VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE12VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE13VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE14VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE15VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. GLOBAL_ATTRIBUTE_CATEGORYVARCHAR230Global Descriptive Flexfield: structure definition of the global descriptive flexfield. GLOBAL_ATTRIBUTE1VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE2VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE3VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE4VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE5VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE6VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE7VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE8VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE9VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE10VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE11VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE12VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE13VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE14VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE15VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE16VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE17VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE18VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE19VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE20VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE21VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE22VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE23VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE24VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE25VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE26VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE27VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE28VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE29VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. GLOBAL_ATTRIBUTE30VARCHAR2150Global Descriptive Flexfield: segment of the global descriptive flexfield. INTERFACE_HEADER_CONTEXTVARCHAR230Oracle internal use only. INTERFACE_HEADER_ATTRIBUTE1VARCHAR2150Oracle internal use only. INTERFACE_HEADER_ATTRIBUTE2VARCHAR2150Oracle internal use only. INTERFACE_HEADER_ATTRIBUTE3VARCHAR2150Oracle internal use only. INTERFACE_HEADER_ATTRIBUTE4VARCHAR2150Oracle internal use only. INTERFACE_HEADER_ATTRIBUTE5VARCHAR2150Oracle internal use only. INTERFACE_HEADER_ATTRIBUTE6VARCHAR2150Oracle internal use only. INTERFACE_HEADER_ATTRIBUTE7VARCHAR2150Oracle internal use only. INTERFACE_HEADER_ATTRIBUTE8VARCHAR2150Oracle internal use only. INTERFACE_HEADER_ATTRIBUTE9VARCHAR2150Oracle internal use only. INTERFACE_HEADER_ATTRIBUTE10VARCHAR2150Oracle internal use only. INTERFACE_HEADER_ATTRIBUTE11VARCHAR2150Oracle internal use only. INTERFACE_HEADER_ATTRIBUTE12VARCHAR2150Oracle internal use only. INTERFACE_HEADER_ATTRIBUTE13VARCHAR2150Oracle internal use only. INTERFACE_HEADER_ATTRIBUTE14VARCHAR2150Oracle internal use only. INTERFACE_HEADER_ATTRIBUTE15VARCHAR2150Oracle internal use only. ORG_IDNUMBER18YesIndicates the identifier of the business unit associated to the row. LEGAL_ENTITY_IDNUMBER18Oracle internal use only. PAYMENT_TRXN_EXTENSION_IDNUMBER18Oracle internal use only. BILLING_DATEDATEOracle internal use only. INTEREST_HEADER_IDNUMBER18Oracle internal use only. LATE_CHARGES_ASSESSEDVARCHAR21Oracle internal use only. BATCH_SOURCE_SEQ_IDNUMBER18Oracle internal use only. CUST_TRX_TYPE_SEQ_IDNUMBER18Oracle internal use only. PRIMARY_RESOURCE_SALESREP_IDNUMBER18Oracle internal use only.