eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AR.AR_GTA_TRX_HEADERS_ALL

Object Details

Object Name:	AR_GTA_TRX_HEADERS_ALL
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_GTA_TRX_HEADERS_ALL
Subobject Name:
Status:	VALID

AR_GTA_TRX_HEADERS_ALL table is accessed by the View VAT Invoice form via view. AR_GTA_GT_HEADERS_V.
AR_GTA_TRX_HEADERS_ALL stores the data of VAT invoices header. It includes two parts: one is from Receivable which will transfer to Golden Tax and the other is transferred back from Golden Tax. The former is identified by SOURCE field equal �AR� and the latter by SOURCE field equal �GT�.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_GTA_TRX_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	GTA_TRX_HEADER_ID
AR_GTA_TRX_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
AR_GTA_TRX_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_DATE
AR_GTA_TRX_HEADERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID GTA_TRX_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
RA_GL_DATE	DATE		Yes	Receivable GL date
RA_GL_PERIOD	VARCHAR2	(15)	Yes	Receivable GL period
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
BILL_TO_CUSTOMER_ID	NUMBER	(15)	Yes	Customer identifier
BILL_TO_CUSTOMER_NUMBER	VARCHAR2	(30)		Customer number
BILL_TO_CUSTOMER_NAME	VARCHAR2	(360)		Customer name
SOURCE	VARCHAR2	(3)	Yes	Line type: AR or GT
ORG_ID	NUMBER	(15)	Yes	Organization identifier
RULE_HEADER_ID	NUMBER	(15)		Transfer rule identity
GTA_TRX_HEADER_ID	NUMBER	(15)	Yes	Invoice identifier
GTA_TRX_NUMBER	VARCHAR2	(30)	Yes	Invoice number, it is concated by ar transaction number-splitted number-version number
GROUP_NUMBER	NUMBER	(15)		group number when split invoice
VERSION	NUMBER	(15)	Yes	Golden Tax Adapter invoice version
LATEST_VERSION_FLAG	VARCHAR2	(1)	Yes	Indicate whether record is latest version
TRANSACTION_DATE	DATE		Yes	Invoice date
RA_TRX_ID	NUMBER	(15)		Invoice identifier in Receivable
RA_TRX_NUMBER	VARCHAR2	(20)		Number of AR transaction
DESCRIPTION	VARCHAR2	(240)		Invoice description/comments when source equal =GT
CUSTOMER_ADDRESS	VARCHAR2	(960)		customer address which will transfer to Golden Tax
CUSTOMER_PHONE	VARCHAR2	(240)		cusomter phone which will transfer to Golden Tax
CUSTOMER_ADDRESS_PHONE	VARCHAR2	(1000)		concatenation of customer address and phone which will transfer to Golden Tax
BANK_ACCOUNT_NAME	VARCHAR2	(240)		bank name which will transfer to Golden Tax
BANK_ACCOUNT_NUMBER	VARCHAR2	(240)		bank account number which will transfer to Golden Tax
BANK_ACCOUNT_NAME_NUMBER	VARCHAR2	(240)		concatenation of bank name and account number which will transfer to Golden Tax
RA_CURRENCY_CODE	VARCHAR2	(15)		currency code in Receivable transaction
CONVERSION_TYPE	VARCHAR2	(30)		conversion type for Receivable orginal currency to Golden Tax currency
CONVERSION_DATE	DATE			conversion date for Receivable orginal currency to Golden Tax currency
CONVERSION_RATE	NUMBER			conversion rate for Receivable orginal currency to Golden Tax currency
GTA_BATCH_NUMBER	VARCHAR2	(30)		batch number for easy query
GT_INVOICE_NUMBER	VARCHAR2	(30)		Invoice number in Golden Tax
GT_INVOICE_DATE	DATE			Invoice date in Golden Tax
GT_INVOICE_NET_AMOUNT	NUMBER			Invoice net amount in Golden Tax
GT_INVOICE_TAX_AMOUNT	NUMBER			Invoice tax amount in Golden Tax
STATUS	VARCHAR2	(30)	Yes	transaction status.
SALES_LIST_FLAG	VARCHAR2	(30)		enable or disable sales list in Golden Tax
CANCEL_FLAG	VARCHAR2	(30)		wether invoice be canceled in Golden Tax
GT_INVOICE_TYPE	VARCHAR2	(1)		VAT invoice type
GT_INVOICE_CLASS	VARCHAR2	(10)		VAT Invoice Class
GT_TAX_MONTH	NUMBER			Month
ISSUER_NAME	VARCHAR2	(30)		invoice issuer
REVIEWER_NAME	VARCHAR2	(30)		invoice reviewer
PAYEE_NAME	VARCHAR2	(30)		invoice payee
TAX_CODE	VARCHAR2	(30)		VAT tax code
TAX_RATE	NUMBER			VAT tax rate
GENERATOR_ID	NUMBER	(15)		Used for generation concurrent parameter invoked from Golden Tax Adapter workbench.
EXPORT_REQUEST_ID	NUMBER	(15)		Invoice export Concurrent Program id.
LEGAL_ENTITY_ID	NUMBER	(15)	Yes	Identifier of Legal Entity
FP_TAX_REGISTRATION_NUMBER	VARCHAR2	(50)	Yes	Tax registration number of First Party
TP_TAX_REGISTRATION_NUMBER	VARCHAR2	(50)		Tax registration number of Third Party
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield segment
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(22)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(22)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
REQUEST_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
INVOICE_TYPE	VARCHAR2	(1)		Invoice type selected within a Tax Limitation. �2� for Common, �0� for Special, and �1� for Recycle.
CONSOLIDATION_FLAG	VARCHAR2	(1)		Consolidation Flag, 0 indicates to consolidation invoice ;1 indicates to consolidated invoice;null indicate for normal invoice.
CONSOLIDATION_ID	NUMBER	(15)		Used for consolidation concurrent parameter invoked from Golden Tax Adapter workbench.
CONSOLIDATION_TRX_NUM	VARCHAR2	(30)		Used as consolidation invoice number of consolidated invoices
CONSOLIDATION_REQUEST_ID	NUMBER	(15)		Used for concurrency control

Query Text

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


SELECT RA_GL_DATE
,      RA_GL_PERIOD
,      SET_OF_BOOKS_ID
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_CUSTOMER_NUMBER
,      BILL_TO_CUSTOMER_NAME
,      SOURCE
,      ORG_ID
,      RULE_HEADER_ID
,      GTA_TRX_HEADER_ID
,      GTA_TRX_NUMBER
,      GROUP_NUMBER
,      VERSION
,      LATEST_VERSION_FLAG
,      TRANSACTION_DATE
,      RA_TRX_ID
,      RA_TRX_NUMBER
,      DESCRIPTION
,      CUSTOMER_ADDRESS
,      CUSTOMER_PHONE
,      CUSTOMER_ADDRESS_PHONE
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUMBER
,      BANK_ACCOUNT_NAME_NUMBER
,      RA_CURRENCY_CODE
,      CONVERSION_TYPE
,      CONVERSION_DATE
,      CONVERSION_RATE
,      GTA_BATCH_NUMBER
,      GT_INVOICE_NUMBER
,      GT_INVOICE_DATE
,      GT_INVOICE_NET_AMOUNT
,      GT_INVOICE_TAX_AMOUNT
,      STATUS
,      SALES_LIST_FLAG
,      CANCEL_FLAG
,      GT_INVOICE_TYPE
,      GT_INVOICE_CLASS
,      GT_TAX_MONTH
,      ISSUER_NAME
,      REVIEWER_NAME
,      PAYEE_NAME
,      TAX_CODE
,      TAX_RATE
,      GENERATOR_ID
,      EXPORT_REQUEST_ID
,      LEGAL_ENTITY_ID
,      FP_TAX_REGISTRATION_NUMBER
,      TP_TAX_REGISTRATION_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      INVOICE_TYPE
,      CONSOLIDATION_FLAG
,      CONSOLIDATION_ID
,      CONSOLIDATION_TRX_NUM
,      CONSOLIDATION_REQUEST_ID
FROM AR.AR_GTA_TRX_HEADERS_ALL;

Dependencies

[top of page]

AR.AR_GTA_TRX_HEADERS_ALL does not reference any database object

AR.AR_GTA_TRX_HEADERS_ALL is referenced by following:

AR: AR_GTA_TRX_HEADERS_ALL#