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_SYSTEM_PARAMETERS_ALL

Object Details

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

The AR_GTA_SYSTEM_PARAMETERS_ALL table stores setup information that will be applied in the invoice transfer program, Invoice Workbench Form and Invoice export program in GTA module. Each OU only have one row in the table.
There is no primary key for this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_GTA_SYSTEM_PARAMETERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_ID	NUMBER		Yes	Organization identifier
AUTO_BATCH_NUMBERING_FLAG	VARCHAR2	(1)	Yes	The identifier to indicate whether the batch number that is required while GTA invoice export is automatically generated or inputted by user manually. �A� for �Automatic� and �M� for �Manual�
NEXT_BATCH_NUMBER	NUMBER			A number to be used as next batch number if the value of AUTO_BATCH_NUMBER_FLAG is �A�.
VAT_TAX_TYPE_CODE	VARCHAR2	(30)	Yes	Code of VAT Tax Type that defined by Quick Code in Oracle Receivables.The tax type code representing value added tax
TRX_LINE_SPLIT_FLAG	VARCHAR2	(1)	Yes	The identifier to indicate whether splits transaction line whose line amount is less than the maximum amount limit while running transfer program, �Y� for �Yes�, otherwise �N�
GT_CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code defined in GL, this code is the same as the currency code used in Golden Tax system.
ITEM_NAME_SOURCE_FLAG	VARCHAR2	(1)		An identifier to indicate item name in GTA invoice is got from where, the alternative source is �Receivable invoice item description� or �Cross Reference defined in OM�. So the value allowed to this column is �R� for �Receivable invoice item description� or �C� for �Cross Reference�
CROSS_REFERENCE_TYPE	VARCHAR2	(25)		Cross reference type defined in OM
MASTER_ITEM_DEFAULT_FLAG	VARCHAR2	(1)		An identifier to indicate whether use master item description as item name if cross reference is not defined. �Y� for �Yes�, otherwise �N�
LATEST_REF_DEFAULT_FLAG	VARCHAR2	(1)		An identifier to indicate whether the latest one will be used as item name if there are multiple cross reference definition for a item. �Y� for �Yes�, otherwise �N�
RA_LINE_CONTEXT_CODE	VARCHAR2	(30)		Descriptive Flexfield structure name of AR transaction line
RA_MODEL_ATTRIBUTE_COLUMN	VARCHAR2	(30)		Attribute column name of DFF in AR transaction line, the value in this attribute column can be used as item model name if input any
RA_TAX_ATTRIBUTE_COLUMN	VARCHAR2	(30)		Attribute column name of DFF in AR transaction line, the value in this attribute column can be used as tax denomination if input any
INV_ITEM_CONTEXT_CODE	VARCHAR2	(30)		Descriptive flexfield structure name of OM item
INV_MODEL_ATTRIBUTE_COLUMN	VARCHAR2	(30)		Attribute column name of DFF in OM item, the value in this attribute column can be used as item model name if input any
INV_TAX_ATTRIBUTE_COLUMN	VARCHAR2	(30)		Attribute column name of DFF in OM item, the value in this attribute column can be used as tax denomination if input any
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(22)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created
CREATED_BY	NUMBER	(22)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
UNIT_PRICE_SPLIT_FLAG	VARCHAR2	(1)		Split flag for unit price exceeding amount limitation

Query Text

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


SELECT ORG_ID
,      AUTO_BATCH_NUMBERING_FLAG
,      NEXT_BATCH_NUMBER
,      VAT_TAX_TYPE_CODE
,      TRX_LINE_SPLIT_FLAG
,      GT_CURRENCY_CODE
,      ITEM_NAME_SOURCE_FLAG
,      CROSS_REFERENCE_TYPE
,      MASTER_ITEM_DEFAULT_FLAG
,      LATEST_REF_DEFAULT_FLAG
,      RA_LINE_CONTEXT_CODE
,      RA_MODEL_ATTRIBUTE_COLUMN
,      RA_TAX_ATTRIBUTE_COLUMN
,      INV_ITEM_CONTEXT_CODE
,      INV_MODEL_ATTRIBUTE_COLUMN
,      INV_TAX_ATTRIBUTE_COLUMN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      UNIT_PRICE_SPLIT_FLAG
FROM AR.AR_GTA_SYSTEM_PARAMETERS_ALL;

Dependencies

[top of page]

AR.AR_GTA_SYSTEM_PARAMETERS_ALL does not reference any database object

AR.AR_GTA_SYSTEM_PARAMETERS_ALL is referenced by following:

AR: AR_GTA_SYSTEM_PARAMETERS_ALL#