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.RA_CUST_TRX_TYPES_ALL

Object Details

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

The RA_CUST_TRX_TYPES_ALL table stores information about each transaction type that is used for invoices, commitments, bills receivable, and credit memos. Each row includes AutoAccounting information as well as standard defaults for the invoices that result.
.
The POST_TO_GL column stores Y or N to indicate if this transaction can post to your General Ledger.
.
The ACCOUNTING_AFFECT_FLAG column stores Y or N to indicate if this transaction can update your open receivables balances. If the ACCOUNTING_AFFECT_FLAG column is Y, you can see this transaction in your agings.
.
The TYPE column contains:
{{"bul:1"}}INV - Invoice
{{"bul:1"}}CM - Credit Memo
{{"bul:1"}}DM - Debit Memo
{{"bul:1"}}DEP - Deposit
{{"bul:1"}}GUAR - Guarantee
{{"bodytext"}}If AutoAccounting is based on transaction type, the GL_ID_REV, GL_ID_FREIGHT, and GL_ID_REC columns store the default revenue, freight, and receivables accounts. The STATUS and CREDIT_MEMO_TYPE_ID columns are required even though they are null allowed.
.
The primary key for this table is CUST_TRX_TYPE_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RA_CUST_TRX_TYPES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUST_TRX_TYPE_ID ORG_ID ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
CUST_TRX_TYPE_ID	NUMBER	(15)	Yes	Transaction type identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	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	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
POST_TO_GL	VARCHAR2	(1)	Yes	Indicates if transactions should be posted to the General Ledger. Y for yes, N otherwise.
ACCOUNTING_AFFECT_FLAG	VARCHAR2	(1)	Yes	Indicates if transactions affect open receivable balances. Y for yes, N otherwise.
CREDIT_MEMO_TYPE_ID	NUMBER	(15)		Transaction type identifier of subsequent credit memos
STATUS	VARCHAR2	(30)		Transaction type status flag. Lookup code for CODE_STATUS.
NAME	VARCHAR2	(20)		Transaction type name
DESCRIPTION	VARCHAR2	(80)		Transaction type description
TYPE	VARCHAR2	(20)		Transaction class, such as INV, CM, DM, GUAR, DEP, or CB
DEFAULT_TERM	NUMBER	(15)		Term to default for invoices of this type
DEFAULT_PRINTING_OPTION	VARCHAR2	(20)	Yes	Printing option to default for invoices of this type
DEFAULT_STATUS	VARCHAR2	(30)	Yes	Status to default for invoices of this type
GL_ID_REV	NUMBER	(15)		Revenue account identifier
GL_ID_FREIGHT	NUMBER	(15)		Freight account identifier
GL_ID_REC	NUMBER	(15)		Receivables account identifier
SUBSEQUENT_TRX_TYPE_ID	NUMBER	(15)		Invoice type for invoices related to a commitment of this type
SET_OF_BOOKS_ID	NUMBER	(15)		Set of Books identifier
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
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
ALLOW_FREIGHT_FLAG	VARCHAR2	(1)	Yes	Indicates if freight is allowed with the transaction. Y for yes, N otherwise.
ALLOW_OVERAPPLICATION_FLAG	VARCHAR2	(1)	Yes	Indicates if applications can exceed the transaction amount. Y for yes, N otherwise.
CREATION_SIGN	VARCHAR2	(30)	Yes	Determines allowable signs for transactions
END_DATE	DATE			Transaction type end date
GL_ID_CLEARING	NUMBER	(15)		Clearing Account identifier
GL_ID_TAX	NUMBER	(15)		Tax account identifier
GL_ID_UNBILLED	NUMBER	(15)		Unbilled account identifier
GL_ID_UNEARNED	NUMBER	(15)		Unearned account identifier
START_DATE	DATE		Yes	Transaction type start date
TAX_CALCULATION_FLAG	VARCHAR2	(1)	Yes	Indicates if tax is allowed on transactions. Y for yes, N otherwise.
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
NATURAL_APPLICATION_ONLY_FLAG	VARCHAR2	(1)	Yes	Indicates if you want to restrict the direction in which items with this transaction type can be updated by applications entered against them. Y for yes, N otherwise.
ORG_ID	NUMBER	(15)		Organization identifier
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Reserved for country-specific functionality
RULE_SET_ID	NUMBER			Application rule set ID for this transaction type
SIGNED_FLAG	VARCHAR2	(1)		Indicates if the drawee needs to accept the bills receivable. Y if acceptance is required, N otherwise.
DRAWEE_ISSUED_FLAG	VARCHAR2	(1)		Indicates whether or not the drawee issues the bills receivable. If issued by the drawee, the value is Y, otherwise N.
MAGNETIC_FORMAT_CODE	VARCHAR2	(30)		Code used to distinguish between accepted bills receivable, promissory notes, and unsigned bills receivable.
FORMAT_PROGRAM_ID	NUMBER	(15)		Identifier of the program that will be used to format bills receivable.
GL_ID_UNPAID_REC	NUMBER	(15)		Identifier of the accounting flexfield for the unpaid account
GL_ID_REMITTANCE	NUMBER	(15)		Identifier of the accounting flexfield for the remittance account
GL_ID_FACTOR	NUMBER	(15)		Identifier of the accounting flexfield for the factoring account
ALLOCATE_TAX_FREIGHT	VARCHAR2	(1)		Determines if Receivables will permit the allocation of tax and freight against this type of deposit.
LEGAL_ENTITY_ID	NUMBER	(15)		Default legal entity assigned to transactions using this transaction type
EXCLUDE_FROM_LATE_CHARGES	VARCHAR2	(30)		Control if late charge can be assessed
ADJ_POST_TO_GL	VARCHAR2	(1)		Indicates if the adjustment needs to be posted[trasaction postable status is "N"]
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT CUST_TRX_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      POST_TO_GL
,      ACCOUNTING_AFFECT_FLAG
,      CREDIT_MEMO_TYPE_ID
,      STATUS
,      NAME
,      DESCRIPTION
,      TYPE
,      DEFAULT_TERM
,      DEFAULT_PRINTING_OPTION
,      DEFAULT_STATUS
,      GL_ID_REV
,      GL_ID_FREIGHT
,      GL_ID_REC
,      SUBSEQUENT_TRX_TYPE_ID
,      SET_OF_BOOKS_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ALLOW_FREIGHT_FLAG
,      ALLOW_OVERAPPLICATION_FLAG
,      CREATION_SIGN
,      END_DATE
,      GL_ID_CLEARING
,      GL_ID_TAX
,      GL_ID_UNBILLED
,      GL_ID_UNEARNED
,      START_DATE
,      TAX_CALCULATION_FLAG
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      NATURAL_APPLICATION_ONLY_FLAG
,      ORG_ID
,      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_ATTRIBUTE_CATEGORY
,      RULE_SET_ID
,      SIGNED_FLAG
,      DRAWEE_ISSUED_FLAG
,      MAGNETIC_FORMAT_CODE
,      FORMAT_PROGRAM_ID
,      GL_ID_UNPAID_REC
,      GL_ID_REMITTANCE
,      GL_ID_FACTOR
,      ALLOCATE_TAX_FREIGHT
,      LEGAL_ENTITY_ID
,      EXCLUDE_FROM_LATE_CHARGES
,      ADJ_POST_TO_GL
,      ZD_EDITION_NAME
FROM AR.RA_CUST_TRX_TYPES_ALL;

Dependencies

[top of page]

AR.RA_CUST_TRX_TYPES_ALL does not reference any database object

AR.RA_CUST_TRX_TYPES_ALL is referenced by following:

AR: RA_CUST_TRX_TYPES_ALL#