[Home] [Help] [Dependency Information]
Object Name: | AR_TRANSACTIONS_S_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AR.AR_TRANSACTIONS_S_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRX_ATTR1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TRX_ATTR10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TRX_ATTR11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TRX_ATTR12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TRX_ATTR13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TRX_ATTR14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TRX_ATTR15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TRX_ATTR2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TRX_ATTR3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TRX_ATTR4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TRX_ATTR5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TRX_ATTR6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TRX_ATTR7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TRX_ATTR8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TRX_ATTR9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TRX_ATTR_CAT | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
TRX_CREDIT_METHOD_FOR_INSTALL | VARCHAR2 | (30) | Rule to use when crediting the payment schedules of split term transactions | |
TRX_CREDIT_METHOD_FOR_RULES | VARCHAR2 | (30) | Rule to use when crediting invoice account assignments for invoices that use invoicing and accounting rules | |
TRX_CUSTOMER_TRX_ID | NUMBER | (15) | Yes | Invoice identifier |
TRX_DOC_SEQUENCE_ID | NUMBER | (15) | Identifies the document sequence | |
TRX_DOC_SEQUENCE_VALUE | NUMBER | (15) | The value of the document sequence | |
TRX_DOC_SEQUENCE_CATEGORY | VARCHAR2 | (20) | ||
TRX_FOB_POINT | VARCHAR2 | (30) | ||
TRX_GLOBAL_ATTR1 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR10 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR11 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR12 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR13 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR14 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR15 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR16 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR17 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR18 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR19 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR2 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR20 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR3 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR4 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR5 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR6 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR7 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR8 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR9 | VARCHAR2 | (150) | ||
TRX_GLOBAL_ATTR_CAT | VARCHAR2 | (30) | ||
TRX_INTERFACE_HEADER_ATTR1 | VARCHAR2 | (150) | ||
TRX_INTERFACE_HEADER_ATTR10 | VARCHAR2 | (150) | ||
TRX_INTERFACE_HEADER_ATTR11 | VARCHAR2 | (150) | ||
TRX_INTERFACE_HEADER_ATTR12 | VARCHAR2 | (150) | ||
TRX_INTERFACE_HEADER_ATTR13 | VARCHAR2 | (150) | ||
TRX_INTERFACE_HEADER_ATTR14 | VARCHAR2 | (150) | ||
TRX_INTERFACE_HEADER_ATTR15 | VARCHAR2 | (150) | ||
TRX_INTERFACE_HEADER_ATTR2 | VARCHAR2 | (150) | ||
TRX_INTERFACE_HEADER_ATTR3 | VARCHAR2 | (150) | ||
TRX_INTERFACE_HEADER_ATTR4 | VARCHAR2 | (150) | ||
TRX_INTERFACE_HEADER_ATTR5 | VARCHAR2 | (150) | ||
TRX_INTERFACE_HEADER_ATTR6 | VARCHAR2 | (150) | ||
TRX_INTERFACE_HEADER_ATTR7 | VARCHAR2 | (150) | ||
TRX_INTERFACE_HEADER_ATTR8 | VARCHAR2 | (150) | ||
TRX_INTERFACE_HEADER_ATTR9 | VARCHAR2 | (150) | ||
TRX_INTERFACE_HEADER_CT | VARCHAR2 | (30) | ||
TRX_INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | ||
TRX_INVOICING_RULE_ID | NUMBER | (15) | ||
TRX_PRINTING_OPTION | VARCHAR2 | (20) | ||
TRX_PURCHASE_ORDER | VARCHAR2 | (50) | ||
TRX_PURCHASE_ORDER_DATE | DATE | |||
TRX_PURCHASE_ORDER_REVISION | VARCHAR2 | (50) | ||
TRX_REASON_CODE | VARCHAR2 | (30) | ||
TRX_SHIP_DATE_ACTUAL | DATE | |||
TRX_STATUS_TRX | VARCHAR2 | (30) | ||
TRX_TERM_DUE_DATE | DATE | |||
TRX_DATE | DATE | Yes | ||
TRX_NUMBER | VARCHAR2 | (20) | Yes | |
TRX_WAYBILL_NUMBER | VARCHAR2 | (50) | ||
TRX_TYPE_CUST_TRX_TYPE_ID | NUMBER | (15) | ||
TRX_TYPE_DESCRIPTION | VARCHAR2 | (80) | ||
TRX_TYPE_DRAWEE_ISSUED_FLAG | VARCHAR2 | (1) | ||
TRX_TYPE_GLOBAL_ATTR1 | VARCHAR2 | (150) | ||
TRX_TYPE_GLOBAL_ATTR10 | VARCHAR2 | (150) | ||
TRX_TYPE_GLOBAL_ATTR2 | VARCHAR2 | (150) | ||
TRX_TYPE_GLOBAL_ATTR3 | VARCHAR2 | (150) | ||
TRX_TYPE_GLOBAL_ATTR4 | VARCHAR2 | (150) | ||
TRX_TYPE_GLOBAL_ATTR5 | VARCHAR2 | (150) | ||
TRX_TYPE_GLOBAL_ATTR6 | VARCHAR2 | (150) | ||
TRX_TYPE_GLOBAL_ATTR7 | VARCHAR2 | (150) | ||
TRX_TYPE_GLOBAL_ATTR_CAT | VARCHAR2 | (30) | ||
TRX_TYPE_DEP_OFFSET_CCID | NUMBER | (15) | ||
TRX_TYPE_CLEARING_CCID | NUMBER | (15) | ||
TRX_TYPE_FACTOR_CCID | NUMBER | (15) | ||
TRX_TYPE_FREIGHT_CCID | NUMBER | (15) | ||
TRX_TYPE_REC_CCID | NUMBER | (15) | ||
TRX_TYPE_REMITTANCE_CCID | NUMBER | (15) | ||
TRX_TYPE_REV_CCID | NUMBER | (15) | ||
TRX_TYPE_TAX_CCID | NUMBER | (15) | ||
TRX_TYPE_UNBILLED_CCID | NUMBER | (15) | ||
TRX_TYPE_UNEARNED_CCID | NUMBER | (15) | ||
TRX_TYPE_UNPAID_REC_CCID | NUMBER | (15) | ||
TRX_TYPE_MAG_FORMAT_CODE | VARCHAR2 | (30) | ||
TRX_TYPE_NAME | VARCHAR2 | (20) | ||
TRX_TYPE_POST_TO_GL | VARCHAR2 | (1) | ||
TRX_TYPE_CLASS | VARCHAR2 | (20) | ||
TER_DESCRIPTION | VARCHAR2 | (240) | ||
TER_NAME | VARCHAR2 | (40) | ||
TER_SEGMENT1 | VARCHAR2 | (25) | ||
TER_SEGMENT10 | VARCHAR2 | (25) | ||
TER_SEGMENT11 | VARCHAR2 | (25) | ||
TER_SEGMENT12 | VARCHAR2 | (25) | ||
TER_SEGMENT13 | VARCHAR2 | (25) | ||
TER_SEGMENT14 | VARCHAR2 | (25) | ||
TER_SEGMENT15 | VARCHAR2 | (25) | ||
TER_SEGMENT16 | VARCHAR2 | (25) | ||
TER_SEGMENT17 | VARCHAR2 | (25) | ||
TER_SEGMENT18 | VARCHAR2 | (25) | ||
TER_SEGMENT19 | VARCHAR2 | (25) | ||
TER_SEGMENT2 | VARCHAR2 | (25) | ||
TER_SEGMENT20 | VARCHAR2 | (25) | ||
TER_SEGMENT3 | VARCHAR2 | (25) | ||
TER_SEGMENT4 | VARCHAR2 | (25) | ||
TER_SEGMENT5 | VARCHAR2 | (25) | ||
TER_SEGMENT6 | VARCHAR2 | (25) | ||
TER_SEGMENT7 | VARCHAR2 | (25) | ||
TER_SEGMENT8 | VARCHAR2 | (25) | ||
TER_SEGMENT9 | VARCHAR2 | (25) | ||
TER_SUMMARY_FLAG | VARCHAR2 | (1) | ||
TER_TERRITORY_ID | NUMBER | (15) | ||
EVENT_ID | NUMBER | (15) | ||
LINE_NUMBER | NUMBER | (15) | ||
LEDGER_ID | NUMBER | (15) | ||
XLA_PARTY_TYPE | CHAR | (1) | ||
TRX_OPER_UNIT | NUMBER | (15) | ||
TRX_RECEIVABLE_CCID | NUMBER | |||
TRX_XLA_APPLIED_TO_APP_ID | NUMBER | |||
TRX_ENTITY_CODE | VARCHAR2 | (16) | ||
TRX_LEGAL_ENTITY_ID | NUMBER | (15) | ||
TRX_RECEIPT_METHOD_ID | NUMBER | (15) | ||
TRX_RECEIPT_METHOD_NAME | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT TRX_ATTR1
, TRX_ATTR10
, TRX_ATTR11
, TRX_ATTR12
, TRX_ATTR13
, TRX_ATTR14
, TRX_ATTR15
, TRX_ATTR2
, TRX_ATTR3
, TRX_ATTR4
, TRX_ATTR5
, TRX_ATTR6
, TRX_ATTR7
, TRX_ATTR8
, TRX_ATTR9
, TRX_ATTR_CAT
, TRX_CREDIT_METHOD_FOR_INSTALL
, TRX_CREDIT_METHOD_FOR_RULES
, TRX_CUSTOMER_TRX_ID
, TRX_DOC_SEQUENCE_ID
, TRX_DOC_SEQUENCE_VALUE
, TRX_DOC_SEQUENCE_CATEGORY
, TRX_FOB_POINT
, TRX_GLOBAL_ATTR1
, TRX_GLOBAL_ATTR10
, TRX_GLOBAL_ATTR11
, TRX_GLOBAL_ATTR12
, TRX_GLOBAL_ATTR13
, TRX_GLOBAL_ATTR14
, TRX_GLOBAL_ATTR15
, TRX_GLOBAL_ATTR16
, TRX_GLOBAL_ATTR17
, TRX_GLOBAL_ATTR18
, TRX_GLOBAL_ATTR19
, TRX_GLOBAL_ATTR2
, TRX_GLOBAL_ATTR20
, TRX_GLOBAL_ATTR3
, TRX_GLOBAL_ATTR4
, TRX_GLOBAL_ATTR5
, TRX_GLOBAL_ATTR6
, TRX_GLOBAL_ATTR7
, TRX_GLOBAL_ATTR8
, TRX_GLOBAL_ATTR9
, TRX_GLOBAL_ATTR_CAT
, TRX_INTERFACE_HEADER_ATTR1
, TRX_INTERFACE_HEADER_ATTR10
, TRX_INTERFACE_HEADER_ATTR11
, TRX_INTERFACE_HEADER_ATTR12
, TRX_INTERFACE_HEADER_ATTR13
, TRX_INTERFACE_HEADER_ATTR14
, TRX_INTERFACE_HEADER_ATTR15
, TRX_INTERFACE_HEADER_ATTR2
, TRX_INTERFACE_HEADER_ATTR3
, TRX_INTERFACE_HEADER_ATTR4
, TRX_INTERFACE_HEADER_ATTR5
, TRX_INTERFACE_HEADER_ATTR6
, TRX_INTERFACE_HEADER_ATTR7
, TRX_INTERFACE_HEADER_ATTR8
, TRX_INTERFACE_HEADER_ATTR9
, TRX_INTERFACE_HEADER_CT
, TRX_INVOICE_CURRENCY_CODE
, TRX_INVOICING_RULE_ID
, TRX_PRINTING_OPTION
, TRX_PURCHASE_ORDER
, TRX_PURCHASE_ORDER_DATE
, TRX_PURCHASE_ORDER_REVISION
, TRX_REASON_CODE
, TRX_SHIP_DATE_ACTUAL
, TRX_STATUS_TRX
, TRX_TERM_DUE_DATE
, TRX_DATE
, TRX_NUMBER
, TRX_WAYBILL_NUMBER
, TRX_TYPE_CUST_TRX_TYPE_ID
, TRX_TYPE_DESCRIPTION
, TRX_TYPE_DRAWEE_ISSUED_FLAG
, TRX_TYPE_GLOBAL_ATTR1
, TRX_TYPE_GLOBAL_ATTR10
, TRX_TYPE_GLOBAL_ATTR2
, TRX_TYPE_GLOBAL_ATTR3
, TRX_TYPE_GLOBAL_ATTR4
, TRX_TYPE_GLOBAL_ATTR5
, TRX_TYPE_GLOBAL_ATTR6
, TRX_TYPE_GLOBAL_ATTR7
, TRX_TYPE_GLOBAL_ATTR_CAT
, TRX_TYPE_DEP_OFFSET_CCID
, TRX_TYPE_CLEARING_CCID
, TRX_TYPE_FACTOR_CCID
, TRX_TYPE_FREIGHT_CCID
, TRX_TYPE_REC_CCID
, TRX_TYPE_REMITTANCE_CCID
, TRX_TYPE_REV_CCID
, TRX_TYPE_TAX_CCID
, TRX_TYPE_UNBILLED_CCID
, TRX_TYPE_UNEARNED_CCID
, TRX_TYPE_UNPAID_REC_CCID
, TRX_TYPE_MAG_FORMAT_CODE
, TRX_TYPE_NAME
, TRX_TYPE_POST_TO_GL
, TRX_TYPE_CLASS
, TER_DESCRIPTION
, TER_NAME
, TER_SEGMENT1
, TER_SEGMENT10
, TER_SEGMENT11
, TER_SEGMENT12
, TER_SEGMENT13
, TER_SEGMENT14
, TER_SEGMENT15
, TER_SEGMENT16
, TER_SEGMENT17
, TER_SEGMENT18
, TER_SEGMENT19
, TER_SEGMENT2
, TER_SEGMENT20
, TER_SEGMENT3
, TER_SEGMENT4
, TER_SEGMENT5
, TER_SEGMENT6
, TER_SEGMENT7
, TER_SEGMENT8
, TER_SEGMENT9
, TER_SUMMARY_FLAG
, TER_TERRITORY_ID
, EVENT_ID
, LINE_NUMBER
, LEDGER_ID
, XLA_PARTY_TYPE
, TRX_OPER_UNIT
, TRX_RECEIVABLE_CCID
, TRX_XLA_APPLIED_TO_APP_ID
, TRX_ENTITY_CODE
, TRX_LEGAL_ENTITY_ID
, TRX_RECEIPT_METHOD_ID
, TRX_RECEIPT_METHOD_NAME
FROM APPS.AR_TRANSACTIONS_S_V;
|
|
|