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: TableAR.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RA_CUST_TRX_TYPES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_TRX_TYPE_ID
ColumnORG_ID
ColumnZD_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:

SchemaAR
ViewRA_CUST_TRX_TYPES_ALL#