DBA Data[Home] [Help] [Dependency Information]


TABLE: AR.AR_TRX_HEADER_GT

Object Details
Object Name: AR_TRX_HEADER_GT
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_TRX_HEADER_GT
Subobject Name:
Status: VALID

Temporary Table Details

AR.AR_TRX_HEADER_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
AR_TRX_HEADER_GT_U1 NORMAL UNIQUE Tablespace ColumnTRX_HEADER_ID
AR_TRX_HEADER_GT_N1 NORMAL NONUNIQUE Tablespace ColumnTRX_NUMBER
ColumnBATCH_SOURCE_ID
Columns
Name Datatype Length Mandatory Comments
TRX_HEADER_ID NUMBER (15)
CUSTOMER_TRX_ID NUMBER (15)
TRX_NUMBER VARCHAR2 (20)
TRX_DATE DATE

TRX_CURRENCY VARCHAR2 (30)
REFERENCE_NUMBER VARCHAR2 (30)
TRX_CLASS VARCHAR2 (30)
BATCH_SOURCE_ID NUMBER (15)
BATCH_ID NUMBER (15)
REASON_CODE VARCHAR2 (30)
SET_OF_BOOKS_ID NUMBER (15)
GL_DATE DATE

POSTING_CONTROL_ID NUMBER (15)
COMPLETE_FLAG VARCHAR2 (1)
CUST_TRX_TYPE_ID NUMBER (15)
CUST_TRX_TYPE_NAME VARCHAR2 (20)
BILL_TO_CUSTOMER_ID NUMBER (15)
BILL_TO_ACCOUNT_NUMBER VARCHAR2 (30)
BILL_TO_CUSTOMER_NAME VARCHAR2 (260)
BILL_TO_LOCATION_ID NUMBER (15)
BILL_TO_CONTACT_ID NUMBER (15)
BILL_TO_ADDRESS_ID NUMBER (15)
SHIP_TO_ADDRESS_ID NUMBER (15)
BILL_TO_SITE_USE_ID NUMBER (15)
SHIP_TO_CUSTOMER_ID NUMBER (15)
SHIP_TO_ACCOUNT_NUMBER VARCHAR2 (30)
SHIP_TO_CUSTOMER_NAME VARCHAR2 (260)
SHIP_TO_LOCATION_ID NUMBER (15)
SHIP_TO_CONTACT_ID NUMBER (15)
SHIP_TO_SITE_USE_ID NUMBER (15)
SOLD_TO_CUSTOMER_ID NUMBER (15)
SOLD_TO_SITE_USE_ID NUMBER (15)
SOLD_TO_CONTACT_ID NUMBER (15)
TERM_ID NUMBER (15)
TERM_DUE_DATE DATE

PRIMARY_SALESREP_ID NUMBER (15)
PRIMARY_SALESREP_NAME VARCHAR2 (240)
EXCHANGE_RATE_TYPE VARCHAR2 (30)
EXCHANGE_DATE DATE

EXCHANGE_RATE NUMBER

TERRITORY_ID NUMBER (15)
REMIT_TO_ADDRESS_ID NUMBER (15)
INVOICING_RULE_ID NUMBER (15)
ORG_ID NUMBER (15)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
GLOBAL_ATTRIBUTE21 VARCHAR2 (150)
GLOBAL_ATTRIBUTE22 VARCHAR2 (150)
GLOBAL_ATTRIBUTE23 VARCHAR2 (150)
GLOBAL_ATTRIBUTE24 VARCHAR2 (150)
GLOBAL_ATTRIBUTE25 VARCHAR2 (150)
GLOBAL_ATTRIBUTE26 VARCHAR2 (150)
GLOBAL_ATTRIBUTE27 VARCHAR2 (150)
GLOBAL_ATTRIBUTE28 VARCHAR2 (150)
GLOBAL_ATTRIBUTE29 VARCHAR2 (150)
GLOBAL_ATTRIBUTE30 VARCHAR2 (150)
INTERFACE_HEADER_CONTEXT VARCHAR2 (30)
INTERFACE_HEADER_ATTRIBUTE1 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE2 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE3 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE4 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE5 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE6 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE7 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE8 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE9 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE10 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE11 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE12 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE13 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE14 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE15 VARCHAR2 (150)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

SHIPMENT_ID NUMBER (15)
PREVIOUS_CUSTOMER_TRX_ID NUMBER (15)
PRINTING_ORIGINAL_DATE DATE

PRINTING_LAST_PRINTED DATE

PRINTING_OPTION VARCHAR2 (20)
PRINTING_COUNT NUMBER

PRINTING_PENDING VARCHAR2 (1)
PURCHASE_ORDER VARCHAR2 (50)
PURCHASE_ORDER_REVISION VARCHAR2 (50)
PURCHASE_ORDER_DATE DATE

CUSTOMER_REFERENCE VARCHAR2 (30)
CUSTOMER_REFERENCE_DATE DATE

COMMENTS VARCHAR2 (1760)
INTERNAL_NOTES VARCHAR2 (240)
INITIAL_CUSTOMER_TRX_ID NUMBER (15)
AGREEMENT_ID NUMBER (15)
END_DATE_COMMITMENT DATE

START_DATE_COMMITMENT DATE

ORIG_SYSTEM_BATCH_NAME VARCHAR2 (40)
POST_REQUEST_ID NUMBER (15)
REQUEST_ID NUMBER (15)
FINANCE_CHARGES VARCHAR2 (1)
RA_POST_LOOP_NUMBER NUMBER

CREDIT_METHOD_FOR_RULES VARCHAR2 (30)
CREDIT_METHOD_FOR_INSTALLMENTS VARCHAR2 (30)
RECEIPT_METHOD_ID NUMBER (15)
RELATED_CUSTOMER_TRX_ID NUMBER (15)
SHIP_VIA VARCHAR2 (30)
SHIP_DATE_ACTUAL DATE

WAYBILL_NUMBER VARCHAR2 (50)
FOB_POINT VARCHAR2 (30)
CUSTOMER_BANK_ACCOUNT_ID NUMBER (15)
DEFAULT_USSGL_TRX_CODE_CONTEXT VARCHAR2 (30)
DEFAULT_USSGL_TRANSACTION_CODE VARCHAR2 (30)
RECURRED_FROM_TRX_NUMBER VARCHAR2 (20)
STATUS_TRX VARCHAR2 (30)
DOC_SEQUENCE_ID NUMBER (15)
DOC_SEQUENCE_VALUE NUMBER (15)
PAYING_CUSTOMER_ID NUMBER (15)
PAYING_SITE_USE_ID NUMBER (15)
DEFAULT_TAX_EXEMPT_FLAG VARCHAR2 (1)
CREATED_FROM VARCHAR2 (30)
EDI_PROCESSED_FLAG VARCHAR2 (1)
EDI_PROCESSED_STATUS VARCHAR2 (10)
MRC_EXCHANGE_RATE_TYPE VARCHAR2 (2000)
MRC_EXCHANGE_DATE VARCHAR2 (2000)
MRC_EXCHANGE_RATE VARCHAR2 (2000)
PAYMENT_SERVER_ORDER_NUM VARCHAR2 (80)
APPROVAL_CODE VARCHAR2 (80)
ADDRESS_VERIFICATION_CODE VARCHAR2 (80)
OLD_TRX_NUMBER VARCHAR2 (20)
BR_AMOUNT NUMBER (15)
BR_UNPAID_FLAG VARCHAR2 (1)
BR_ON_HOLD_FLAG VARCHAR2 (1)
DRAWEE_ID NUMBER (15)
DRAWEE_CONTACT_ID NUMBER (15)
DRAWEE_SITE_USE_ID NUMBER (15)
REMITTANCE_BANK_ACCOUNT_ID NUMBER (15)
OVERRIDE_REMIT_ACCOUNT_FLAG VARCHAR2 (1)
DRAWEE_BANK_ACCOUNT_ID NUMBER (15)
SPECIAL_INSTRUCTIONS VARCHAR2 (240)
REMITTANCE_BATCH_ID NUMBER (15)
PREPAYMENT_FLAG VARCHAR2 (1)
CT_REFERENCE VARCHAR2 (30)
CONTRACT_ID NUMBER (15)
BILL_TEMPLATE_ID NUMBER (15)
ALLOW_FREIGHT_FLAG VARCHAR2 (1)
TAX_CALCULATION_FLAG VARCHAR2 (1)
AUTO_BATCH_NUMBERING_FLAG VARCHAR2 (1)
AUTO_TRX_NUMBERING_FLAG VARCHAR2 (1)
ALLOW_OVERAPPLICATION_FLAG VARCHAR2 (1)
CREATION_SIGN VARCHAR2 (30)
NATURAL_APPLICATION_ONLY_FLAG VARCHAR2 (1)
ACCOUNTING_AFFECT_FLAG VARCHAR2 (1)
COPY_DOC_NUMBER_FLAG VARCHAR2 (1)
PAYMENT_TRXN_EXTENSION_ID NUMBER (15)
LEGAL_ENTITY_ID NUMBER (15)
BILLING_DATE DATE

INTEREST_HEADER_ID NUMBER (15)
LATE_CHARGES_ASSESSED VARCHAR2 (1)
DEFAULTED_GL_DATE_FLAG VARCHAR2 (1)
TAXED_UPSTREAM_FLAG VARCHAR2 (1)
DOCUMENT_SUB_TYPE VARCHAR2 (240)
DEFAULT_TAXATION_COUNTRY VARCHAR2 (2)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRX_HEADER_ID
,      CUSTOMER_TRX_ID
,      TRX_NUMBER
,      TRX_DATE
,      TRX_CURRENCY
,      REFERENCE_NUMBER
,      TRX_CLASS
,      BATCH_SOURCE_ID
,      BATCH_ID
,      REASON_CODE
,      SET_OF_BOOKS_ID
,      GL_DATE
,      POSTING_CONTROL_ID
,      COMPLETE_FLAG
,      CUST_TRX_TYPE_ID
,      CUST_TRX_TYPE_NAME
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_ACCOUNT_NUMBER
,      BILL_TO_CUSTOMER_NAME
,      BILL_TO_LOCATION_ID
,      BILL_TO_CONTACT_ID
,      BILL_TO_ADDRESS_ID
,      SHIP_TO_ADDRESS_ID
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_CUSTOMER_ID
,      SHIP_TO_ACCOUNT_NUMBER
,      SHIP_TO_CUSTOMER_NAME
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_CONTACT_ID
,      SHIP_TO_SITE_USE_ID
,      SOLD_TO_CUSTOMER_ID
,      SOLD_TO_SITE_USE_ID
,      SOLD_TO_CONTACT_ID
,      TERM_ID
,      TERM_DUE_DATE
,      PRIMARY_SALESREP_ID
,      PRIMARY_SALESREP_NAME
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      TERRITORY_ID
,      REMIT_TO_ADDRESS_ID
,      INVOICING_RULE_ID
,      ORG_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE21
,      GLOBAL_ATTRIBUTE22
,      GLOBAL_ATTRIBUTE23
,      GLOBAL_ATTRIBUTE24
,      GLOBAL_ATTRIBUTE25
,      GLOBAL_ATTRIBUTE26
,      GLOBAL_ATTRIBUTE27
,      GLOBAL_ATTRIBUTE28
,      GLOBAL_ATTRIBUTE29
,      GLOBAL_ATTRIBUTE30
,      INTERFACE_HEADER_CONTEXT
,      INTERFACE_HEADER_ATTRIBUTE1
,      INTERFACE_HEADER_ATTRIBUTE2
,      INTERFACE_HEADER_ATTRIBUTE3
,      INTERFACE_HEADER_ATTRIBUTE4
,      INTERFACE_HEADER_ATTRIBUTE5
,      INTERFACE_HEADER_ATTRIBUTE6
,      INTERFACE_HEADER_ATTRIBUTE7
,      INTERFACE_HEADER_ATTRIBUTE8
,      INTERFACE_HEADER_ATTRIBUTE9
,      INTERFACE_HEADER_ATTRIBUTE10
,      INTERFACE_HEADER_ATTRIBUTE11
,      INTERFACE_HEADER_ATTRIBUTE12
,      INTERFACE_HEADER_ATTRIBUTE13
,      INTERFACE_HEADER_ATTRIBUTE14
,      INTERFACE_HEADER_ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SHIPMENT_ID
,      PREVIOUS_CUSTOMER_TRX_ID
,      PRINTING_ORIGINAL_DATE
,      PRINTING_LAST_PRINTED
,      PRINTING_OPTION
,      PRINTING_COUNT
,      PRINTING_PENDING
,      PURCHASE_ORDER
,      PURCHASE_ORDER_REVISION
,      PURCHASE_ORDER_DATE
,      CUSTOMER_REFERENCE
,      CUSTOMER_REFERENCE_DATE
,      COMMENTS
,      INTERNAL_NOTES
,      INITIAL_CUSTOMER_TRX_ID
,      AGREEMENT_ID
,      END_DATE_COMMITMENT
,      START_DATE_COMMITMENT
,      ORIG_SYSTEM_BATCH_NAME
,      POST_REQUEST_ID
,      REQUEST_ID
,      FINANCE_CHARGES
,      RA_POST_LOOP_NUMBER
,      CREDIT_METHOD_FOR_RULES
,      CREDIT_METHOD_FOR_INSTALLMENTS
,      RECEIPT_METHOD_ID
,      RELATED_CUSTOMER_TRX_ID
,      SHIP_VIA
,      SHIP_DATE_ACTUAL
,      WAYBILL_NUMBER
,      FOB_POINT
,      CUSTOMER_BANK_ACCOUNT_ID
,      DEFAULT_USSGL_TRX_CODE_CONTEXT
,      DEFAULT_USSGL_TRANSACTION_CODE
,      RECURRED_FROM_TRX_NUMBER
,      STATUS_TRX
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      PAYING_CUSTOMER_ID
,      PAYING_SITE_USE_ID
,      DEFAULT_TAX_EXEMPT_FLAG
,      CREATED_FROM
,      EDI_PROCESSED_FLAG
,      EDI_PROCESSED_STATUS
,      MRC_EXCHANGE_RATE_TYPE
,      MRC_EXCHANGE_DATE
,      MRC_EXCHANGE_RATE
,      PAYMENT_SERVER_ORDER_NUM
,      APPROVAL_CODE
,      ADDRESS_VERIFICATION_CODE
,      OLD_TRX_NUMBER
,      BR_AMOUNT
,      BR_UNPAID_FLAG
,      BR_ON_HOLD_FLAG
,      DRAWEE_ID
,      DRAWEE_CONTACT_ID
,      DRAWEE_SITE_USE_ID
,      REMITTANCE_BANK_ACCOUNT_ID
,      OVERRIDE_REMIT_ACCOUNT_FLAG
,      DRAWEE_BANK_ACCOUNT_ID
,      SPECIAL_INSTRUCTIONS
,      REMITTANCE_BATCH_ID
,      PREPAYMENT_FLAG
,      CT_REFERENCE
,      CONTRACT_ID
,      BILL_TEMPLATE_ID
,      ALLOW_FREIGHT_FLAG
,      TAX_CALCULATION_FLAG
,      AUTO_BATCH_NUMBERING_FLAG
,      AUTO_TRX_NUMBERING_FLAG
,      ALLOW_OVERAPPLICATION_FLAG
,      CREATION_SIGN
,      NATURAL_APPLICATION_ONLY_FLAG
,      ACCOUNTING_AFFECT_FLAG
,      COPY_DOC_NUMBER_FLAG
,      PAYMENT_TRXN_EXTENSION_ID
,      LEGAL_ENTITY_ID
,      BILLING_DATE
,      INTEREST_HEADER_ID
,      LATE_CHARGES_ASSESSED
,      DEFAULTED_GL_DATE_FLAG
,      TAXED_UPSTREAM_FLAG
,      DOCUMENT_SUB_TYPE
,      DEFAULT_TAXATION_COUNTRY
FROM AR.AR_TRX_HEADER_GT;

Dependencies

[top of page]

AR.AR_TRX_HEADER_GT does not reference any database object

AR.AR_TRX_HEADER_GT is referenced by following:

SchemaAPPS
SynonymAR_TRX_HEADER_GT