AR_TRX_HEADER_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_IDNUMBER18Oracle internal use only. CUSTOMER_TRX_IDNUMBER18Oracle internal use only. TRX_NUMBERVARCHAR220Oracle internal use only. TRX_DATEDATEOracle internal use only. TRX_CURRENCYVARCHAR230Oracle internal use only. REFERENCE_NUMBERVARCHAR230Oracle internal use only. TRX_CLASSVARCHAR230Oracle internal use only. BATCH_SOURCE_IDNUMBER18Oracle internal use only. BATCH_IDNUMBER18Oracle internal use only. REASON_CODEVARCHAR230Oracle internal use only. SET_OF_BOOKS_IDNUMBER18Oracle internal use only. GL_DATEDATEOracle internal use only. POSTING_CONTROL_IDNUMBER18Oracle internal use only. COMPLETE_FLAGVARCHAR21Oracle internal use only. CUST_TRX_TYPE_IDNUMBER18Oracle internal use only. CUST_TRX_TYPE_NAMEVARCHAR220Oracle internal use only. BILL_TO_CUSTOMER_IDNUMBER18Oracle internal use only. BILL_TO_ACCOUNT_NUMBERVARCHAR230Oracle internal use only. BILL_TO_CUSTOMER_NAMEVARCHAR2260Oracle internal use only. BILL_TO_LOCATION_IDNUMBER18Oracle internal use only. BILL_TO_CONTACT_IDNUMBER18Oracle internal use only. BILL_TO_ADDRESS_IDNUMBER18Oracle internal use only. SHIP_TO_ADDRESS_IDNUMBER18Oracle internal use only. BILL_TO_SITE_USE_IDNUMBER18Oracle internal use only. SHIP_TO_CUSTOMER_IDNUMBER18Oracle internal use only. SHIP_TO_ACCOUNT_NUMBERVARCHAR230Oracle internal use only. SHIP_TO_CUSTOMER_NAMEVARCHAR2260Oracle internal use only. SHIP_TO_LOCATION_IDNUMBER18Oracle internal use only. SHIP_TO_CONTACT_IDNUMBER18Oracle internal use only. SHIP_TO_SITE_USE_IDNUMBER18Oracle internal use only. SOLD_TO_CUSTOMER_IDNUMBER18Oracle internal use only. SOLD_TO_SITE_USE_IDNUMBER18Oracle internal use only. SOLD_TO_CONTACT_IDNUMBER18Oracle internal use only. TERM_IDNUMBER18Oracle internal use only. TERM_DUE_DATEDATEOracle internal use only. PRIMARY_SALESREP_IDNUMBER18Oracle internal use only. PRIMARY_SALESREP_NAMEVARCHAR2240Oracle internal use only. EXCHANGE_RATE_TYPEVARCHAR230Oracle internal use only. EXCHANGE_DATEDATEOracle internal use only. EXCHANGE_RATENUMBEROracle internal use only. TERRITORY_IDNUMBER18Oracle internal use only. REMIT_TO_ADDRESS_IDNUMBER18Oracle internal use only. INVOICING_RULE_IDNUMBER18Oracle internal use only. ORG_IDNUMBER18YesIndicates the identifier of the business unit associated to the row. 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. CREATED_BYVARCHAR264YesWho column: indicates the user who created the row. CREATION_DATETIMESTAMPYesWho column: indicates the date and time of the creation of the row. LAST_UPDATED_BYVARCHAR264YesWho column: indicates the user who last updated the row. LAST_UPDATE_DATETIMESTAMPYesWho column: indicates the date and time of the last update of the row. LAST_UPDATE_LOGINVARCHAR232Who column: indicates the session login associated to the user who last updated the row. PROGRAM_APPLICATION_IDNUMBER18Oracle internal use only. PROGRAM_IDNUMBER18Oracle internal use only. PROGRAM_UPDATE_DATEDATEOracle internal use only. SHIPMENT_IDNUMBER18Oracle internal use only. PREVIOUS_CUSTOMER_TRX_IDNUMBER18Oracle internal use only. PRINTING_ORIGINAL_DATEDATEOracle internal use only. PRINTING_LAST_PRINTEDDATEOracle internal use only. PRINTING_OPTIONVARCHAR220Oracle internal use only. PRINTING_COUNTNUMBEROracle internal use only. PRINTING_PENDINGVARCHAR21Oracle internal use only. PURCHASE_ORDERVARCHAR250Oracle internal use only. PURCHASE_ORDER_REVISIONVARCHAR250Oracle internal use only. PURCHASE_ORDER_DATEDATEOracle internal use only. CUSTOMER_REFERENCEVARCHAR230Oracle internal use only. CUSTOMER_REFERENCE_DATEDATEOracle internal use only. COMMENTSVARCHAR21760Oracle internal use only. INTERNAL_NOTESVARCHAR2240Oracle internal use only. INITIAL_CUSTOMER_TRX_IDNUMBER18Oracle internal use only. AGREEMENT_IDNUMBER18Oracle internal use only. END_DATE_COMMITMENTDATEOracle internal use only. START_DATE_COMMITMENTDATEOracle internal use only. ORIG_SYSTEM_BATCH_NAMEVARCHAR240Oracle internal use only. POST_REQUEST_IDNUMBER18Oracle internal use only. REQUEST_IDNUMBER18Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. FINANCE_CHARGESVARCHAR21Oracle internal use only. RA_POST_LOOP_NUMBERNUMBEROracle internal use only. CREDIT_METHOD_FOR_RULESVARCHAR230Oracle internal use only. CREDIT_METHOD_FOR_INSTALLMENTSVARCHAR230Oracle internal use only. RECEIPT_METHOD_IDNUMBER18Oracle internal use only. RELATED_CUSTOMER_TRX_IDNUMBER18Oracle 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_IDNUMBER18Oracle internal use only. DEFAULT_USSGL_TRX_CODE_CONTEXTVARCHAR230Oracle internal use only. DEFAULT_USSGL_TRANSACTION_CODEVARCHAR230Oracle internal use only. RECURRED_FROM_TRX_NUMBERVARCHAR220Oracle internal use only. STATUS_TRXVARCHAR230Oracle internal use only. DOC_SEQUENCE_IDNUMBER18Oracle internal use only. DOC_SEQUENCE_VALUENUMBER18Oracle internal use only. PAYING_CUSTOMER_IDNUMBER18Oracle internal use only. PAYING_SITE_USE_IDNUMBER18Oracle internal use only. DEFAULT_TAX_EXEMPT_FLAGVARCHAR21Oracle internal use only. CREATED_FROMVARCHAR230Oracle internal use only. EDI_PROCESSED_FLAGVARCHAR21Not currently used. EDI_PROCESSED_STATUSVARCHAR210Not currently used. MRC_EXCHANGE_RATE_TYPEVARCHAR22000Oracle internal use only. MRC_EXCHANGE_DATEVARCHAR22000Oracle internal use only. MRC_EXCHANGE_RATEVARCHAR22000Oracle internal use only. PAYMENT_SERVER_ORDER_NUMVARCHAR280Oracle internal use only. APPROVAL_CODEVARCHAR280Oracle internal use only. ADDRESS_VERIFICATION_CODEVARCHAR280Oracle internal use only. OLD_TRX_NUMBERVARCHAR220Oracle internal use only. BR_AMOUNTNUMBEROracle internal use only. BR_UNPAID_FLAGVARCHAR21Oracle internal use only. BR_ON_HOLD_FLAGVARCHAR21Oracle internal use only. DRAWEE_IDNUMBER18Oracle internal use only. DRAWEE_CONTACT_IDNUMBER18Oracle internal use only. DRAWEE_SITE_USE_IDNUMBER18Oracle internal use only. REMITTANCE_BANK_ACCOUNT_IDNUMBER18Oracle internal use only. OVERRIDE_REMIT_ACCOUNT_FLAGVARCHAR21Oracle internal use only. DRAWEE_BANK_ACCOUNT_IDNUMBER18Oracle internal use only. SPECIAL_INSTRUCTIONSVARCHAR2240Oracle internal use only. REMITTANCE_BATCH_IDNUMBER18Oracle internal use only. PREPAYMENT_FLAGVARCHAR21Oracle internal use only. CT_REFERENCEVARCHAR230Oracle internal use only. CONTRACT_IDNUMBER18Not currently used. BILL_TEMPLATE_IDNUMBER18Oracle internal use only. ALLOW_FREIGHT_FLAGVARCHAR21Oracle internal use only. TAX_CALCULATION_FLAGVARCHAR21Oracle internal use only. AUTO_BATCH_NUMBERING_FLAGVARCHAR21Oracle internal use only. AUTO_TRX_NUMBERING_FLAGVARCHAR21Oracle internal use only. ALLOW_OVERAPPLICATION_FLAGVARCHAR21Oracle internal use only. CREATION_SIGNVARCHAR230Oracle internal use only. NATURAL_APPLICATION_ONLY_FLAGVARCHAR21Oracle internal use only. ACCOUNTING_AFFECT_FLAGVARCHAR21Oracle internal use only. COPY_DOC_NUMBER_FLAGVARCHAR21Oracle internal use only. PAYMENT_TRXN_EXTENSION_IDNUMBER18Oracle internal use only. LEGAL_ENTITY_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. REMIT_TO_ADDRESS_SEQ_IDNUMBER18Oracle internal use only. CLASSVARCHAR220Oracle internal use only. DEFAULTED_GL_DATE_FLAGVARCHAR21Oracle internal use only.

Indexes

Index	Uniqueness	Columns
AR_TRX_HEADER_GT_N1	Non Unique	TRX_NUMBER, BATCH_SOURCE_ID
AR_TRX_HEADER_GT_U1	Unique	TRX_HEADER_ID