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

VIEW: APPS.AR_GTA_TRX_HEADERS_V

Object Details
Object Name: AR_GTA_TRX_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_GTA_TRX_HEADERS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
GL_DATE DATE
Yes Receivable GL date
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
TRANSACTION_NUM 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
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)
Invoice Type
GT_INVOICE_CLASS VARCHAR2 (10)
Invoice Class
GT_TAX_MONTH NUMBER

Tax 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.
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (22) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (22) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_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_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
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
TOTAL_VAT_INVOICE_AMOUNT NUMBER

Invoice net amount in Golden Tax + Invoice tax amount in Golden Tax
AMOUNT NUMBER

Amount
ORIGINAL_CURRENCY_AMOUNT NUMBER

Original Currency Amount
OPERATING_UNIT VARCHAR2 (240) Yes Translated name of the organization
TRANSFER_RULE VARCHAR2 (30)
Transfer Rule Name
RA_TRX_CLASS VARCHAR2 (20)
Transaction class, such as INV, CM, DM, GUAR, DEP, or CB
RA_TRX_TYPE VARCHAR2 (20)
Transaction type name
RA_TRX_BATCH VARCHAR2 (50)
Batch name
RA_TRX_NUM VARCHAR2 (20)
Number of AR transaction
RA_TRX_SOURCE VARCHAR2 (50)
Batch source name
DOCUMENT_SEQUENCE_NUM NUMBER (15)
Document Sequence Number
COMPLETE_FLAG VARCHAR2 (1)
Complete Flag
PRIMARY_SALESREP_ID NUMBER (15)
Primary Salesrep Identifier
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
INVOICE_TYPE VARCHAR2 (1)
Invoice type selected within a Tax Limitation. �2� for Common, �0� for Special, and �1� for Recycle.
CONSOLIDATION_ID NUMBER (15)
Used for consolidation concurrent parameter invoked from Golden Tax Adapter workbench.
CONSOLIDATION_FLAG VARCHAR2 (1)
Consolidation Flag, 0 indicates to consolidation invoice ;1 indicates to consolidated invoice;null indicate for normal invoice.
CONSOLIDATION_TRX_NUMBER 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 ROW_ID
,      GL_DATE
,      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
,      TRANSACTION_NUM
,      GROUP_NUMBER
,      VERSION
,      LATEST_VERSION_FLAG
,      TRANSACTION_DATE
,      RA_TRX_ID
,      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
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TOTAL_VAT_INVOICE_AMOUNT
,      AMOUNT
,      ORIGINAL_CURRENCY_AMOUNT
,      OPERATING_UNIT
,      TRANSFER_RULE
,      RA_TRX_CLASS
,      RA_TRX_TYPE
,      RA_TRX_BATCH
,      RA_TRX_NUM
,      RA_TRX_SOURCE
,      DOCUMENT_SEQUENCE_NUM
,      COMPLETE_FLAG
,      PRIMARY_SALESREP_ID
,      LEGAL_ENTITY_ID
,      FP_TAX_REGISTRATION_NUMBER
,      TP_TAX_REGISTRATION_NUMBER
,      INVOICE_TYPE
,      CONSOLIDATION_ID
,      CONSOLIDATION_FLAG
,      CONSOLIDATION_TRX_NUMBER
,      CONSOLIDATION_REQUEST_ID
FROM APPS.AR_GTA_TRX_HEADERS_V;

Dependencies

[top of page]

APPS.AR_GTA_TRX_HEADERS_V references the following:

SchemaAPPS
SynonymAR_GTA_RULE_HEADERS_ALL
SynonymAR_GTA_TRX_HEADERS_ALL
PL/SQL PackageAR_GTA_TRX_UTIL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymRA_BATCHES_ALL
SynonymRA_BATCH_SOURCES_ALL
SynonymRA_CUSTOMER_TRX_ALL
SynonymRA_CUST_TRX_TYPES_ALL
APPS.AR_GTA_TRX_HEADERS_V is referenced by following:

SchemaAPPS
Package BodyAR_GTA_CONSOLIDATE_PROC - show dependent code