AR_CUST_TRX_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| TRX_ATTR1 | VARCHAR2 | 150 | De scriptive Flexfield: segment of the user descriptive flexfield 1. | |
| TRX_ATTR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield 10. | |
| TRX_ATTR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield 11. | |
| TRX_ATTR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield 12. | |
| TRX_ATTR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield 13. | |
| TRX_ATTR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield 14. | |
| TRX_ATTR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield 15. | |
| TRX_ATTR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield 2. | |
| TRX_ATTR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield 3. | |
| TRX_ATTR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield 4. | |
| TRX_ATTR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield 5. | |
| TRX_ATTR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield 6. | |
| TRX_ATTR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield 7. | |
| TRX_ATTR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield 8. | |
| TRX_ATTR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield 9. | |
| TRX_ATTR_CAT | VARCHAR2 | 30 | Structure definition of the user descriptive flexfield. | |
| TRX_CREDIT_METHOD_FOR_INSTALL | VARCHAR2 | 30 | Credit method for invoices with multiple installments. | |
| TRX_CREDIT_METHOD_FOR_RULES | VARCHAR2 | 30 | Credit method for invoices with rules. | |
| TRX_CUSTOMER_TRX_ID | NUMBER | 18 | Unique identifier of the customer transaction. | |
| TRX_DOC_SEQUENCE_ID | NUMBER | 18 | Unique identifier of the document sequence assigned to the customer transaction. | |
| TRX_DOC_SEQUENCE_VALUE | NUMBER | 18 | Document number assigned to the customer transaction. | |
| TRX_DOC_SEQUENCE_CATEGORY | VARCHAR2 | 80 | Document category assigned to the customer transaction. | |
| TRX_FOB_POINT | VARCHAR2 | 30 | Name of the free on board point for the transaction. | |
| TRX_GLOBAL_ATTR1 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 1. | |
| TRX_GLOBAL_ATTR10 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 10. | |
| TRX_GLOBAL_ATTR11 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 11. | |
| TRX_GLOBAL_ATTR12 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 12. | |
| TRX_GLOBAL_ATTR13 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 13. | |
| TRX_GLOBAL_ATTR14 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 14. | |
| TRX_GLOBAL_ATTR15 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 15. | |
| TRX_GLOBAL_ATTR16 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 16. | |
| TRX_GLOBAL_ATTR17 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 17. | |
| TRX_GLOBAL_ATTR18 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 18. | |
| TRX_GLOBAL_ATTR19 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 19. | |
| TRX_GLOBAL_ATTR2 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 2. | |
| TRX_GLOBAL_ATTR20 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 20. | |
| TRX_GLOBAL_ATTR3 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 3. | |
| TRX_GLOBAL_ATTR4 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 4. | |
| TRX_GLOBAL_ATTR5 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 5. | |
| TRX_GLOBAL_ATTR6 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 6. | |
| TRX_GLOBAL_ATTR7 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 7. | |
| TRX_GLOBAL_ATTR8 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 8. | |
| TRX_GLOBAL_ATTR9 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield 9. | |
| TRX_GLOBAL_ATTR_CAT | VARCHAR2 | 30 | Structure definition of the global descriptive flexfield. | |
| TRX_INTERFACE_HEADER_ATTR1 | VARCHAR2 | 30 | Header attribute: Interface header attribute 1. | |
| TRX_INTERFACE_HEADER_ATTR10 | VARCHAR2 | 30 | Header attribute: Interface header attribute 10. | |
| TRX_INTERFACE_HEADER_ATTR11 | VARCHAR2 | 30 | Header attribute: Interface header attribute 11. | |
| TRX_INTERFACE_HEADER_ATTR12 | VARCHAR2 | 30 | Header attribute: Interface header attribute 12. | |
| TRX_INTERFACE_HEADER_ATTR13 | VARCHAR2 | 30 | Header attribute: Interface header attribute 13. | |
| TRX_INTERFACE_HEADER_ATTR14 | VARCHAR2 | 30 | Header attribute: Interface header attribute 14. | |
| TRX_INTERFACE_HEADER_ATTR15 | VARCHAR2 | 30 | Header attribute: Interface header attribute 15. | |
| TRX_INTERFACE_HEADER_ATTR2 | VARCHAR2 | 30 | Header attribute: Interface header attribute 2. | |
| TRX_INTERFACE_HEADER_ATTR3 | VARCHAR2 | 30 | Header attribute: Interface header attribute 3. | |
| TRX_INTERFACE_HEADER_ATTR4 | VARCHAR2 | 30 | Header attribute: Interface header attribute 4. | |
| TRX_INTERFACE_HEADER_ATTR5 | VARCHAR2 | 30 | Header attribute: Interface header attribute 5. | |
| TRX_INTERFACE_HEADER_ATTR6 | VARCHAR2 | 30 | Header attribute: Interface header attribute 6. | |
| TRX_INTERFACE_HEADER_ATTR7 | VARCHAR2 | 30 | Header attribute: Interface header attribute 7. | |
| TRX_INTERFACE_HEADER_ATTR8 | VARCHAR2 | 30 | Header attribute: Interface header attribute 8. | |
| TRX_INTERFACE_HEADER_ATTR9 | VARCHAR2 | 30 | Header attribute: Interface header attribute 9. | |
| TRX_INTERFACE_HEADER_CT | VARCHAR2 | 30 | Header attribute: Interface header context. | |
| TRX_INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | Currency code on the customer transaction. | |
| TRX_INVOICING_RULE_ID | NUMBER | 18 | Unique identifier of the invoicing rule on the customer transaction. | |
| TRX_PRINTING_OPTION | VARCHAR2 | 20 | Indicates whether the customer transaction is available to print. | |
| TRX_PURCHASE_ORDER | VARCHAR2 | 50 | Purchase order number on the customer transaction. | |
| TRX_PURCHASE_ORDER_DATE | DATE | Purchase order date on the customer transaction. | ||
| TRX_PURCHASE_ORDER_REVISION | VARCHAR2 | 50 | Purchase order revision on the customer transaction. | |
| TRX_REASON_CODE | VARCHAR2 | 30 | Intended to be used for future purpose. | |
| TRX_SHIP_DATE_ACTUAL | DATE | Actual shipment date on the customer transaction. | ||
| TRX_STATUS_TRX | VARCHAR2 | 30 | Status of the customer transaction. Valid values are Complete and Incomplete. | |
| TRX_TERM_DUE_DATE | DATE | Payment terms due date on the customer transaction. | ||
| TRX_DATE | DATE | Date the customer transaction was created. | ||
| TRX_NUMBER | VARCHAR2 | 20 | Number assigned to the customer transaction. | |
| TRX_WAYBILL_NUMBER | VARCHAR2 | 50 | Waybill number on the customer transaction. | |
| TRX_TYPE_CUST_TRX_TYPE_ID | NUMBER | 18 | Unique identifier of the transaction type assigned to the customer transaction. | |
| TRX_TYPE_DESCRIPTION | VARCHAR2 | 80 | Description of the transaction type assigned to the customer transaction. | |
| TRX_TYPE_DRAWEE_ISSUED_FLAG | VARCHAR2 | 1 | Indicates whether the drawee issues the bill receivable. | |
| TRX_TYPE_GLOBAL_ATTR1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield 1. | |
| TRX_TYPE_GLOBAL_ATTR10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield 10. | |
| TRX_TYPE_GLOBAL_ATTR2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield 2. | |
| TRX_TYPE_GLOBAL_ATTR3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield 3. | |
| TRX_TYPE_GLOBAL_ATTR4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield 4. | |
| TRX_TYPE_GLOBAL_ATTR5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield 5. | |
| TRX_TYPE_GLOBAL_ATTR6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield 6. | |
| TRX_TYPE_GLOBAL_ATTR7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield 7. | |
| TRX_TYPE_GLOBAL_ATTR_CAT | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |
| TRX_TYPE_MAG_FORMAT_CODE | VARCHAR2 | 30 | Code used to distinguish between accepted bills receivable, promissory notes, and unsigned bills receivable. | |
| TRX_TYPE_NAME | VARCHAR2 | 20 | Name of the transaction type assigned to the customer transaction. | |
| TRX_TYPE_POST_TO_GL | VARCHAR2 | 1 | Indicates whether the Post to General Ledger option is enabled on the transaction type. | |
| TRX_TYPE_CLASS | VARCHAR2 | 20 | Transaction class of the customer transaction. Valid values are: INV, CM, DM, CB. | |
| XLA_PARTY_TYPE | CHAR | 1 | Intended for Oracle internal use only. | |
| TRX_OPER_UNIT | NUMBER | 18 | Name of the business unit of the customer transaction. | |
| TRX_XLA_APPLIED_TO_APP_ID | NUMBER | Receivables code combination identifier. | ||
| TRX_LEGAL_ENTITY_ID | NUMBER | 18 | Unique identifier of the legal entity assigned to the customer transaction. | |
| TRX_RECEIPT_METHOD_ID | NUMBER | 18 | Unique identifier of the receipt method assigned to the customer transaction. | |
| TRX_RECEIPT_METHOD_NAME | VARCHAR2 | 30 | Name of the receipt method assigned to the customer transaction. | |
| CB_TRX_NUMBER | VARCHAR2 | 20 | Number assigned to the transaction batch. | |
| CB_TRX_DATE | DATE | Date the transaction batch was created. | ||
| CB_BATCH_SOURCE_NAME | VARCHAR2 | 50 | Name of the transaction source assigned to the transaction batch. | |
| TRX_REV_REC_APPLICATION | VARCHAR2 | 30 | Indicates the application is used for revenue recognition. | |
| TRX_REV_CONTRACT_CLEARING_CCID | NUMBER | Revenue contract code combination identifier. | ||
| TRX_DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Code for the document type used to match receipts to the customer transaction. | |
| TRX_CREATION_DATE | DATE | Who column: indicates the date and time of the creation of the row. | ||
| TRX_CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | |
| TRX_LAST_UPDATE_DATE | DATE | Who column: indicates the date and time of the last update of the row. | ||
| TRX_LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | |
| MULTIFUND_UPGRADED_TRX_FLAG | VARCHAR2 | 1 | Intended to be used for future purpose. | |
| TRX_CT_REFERENCE | VARCHAR2 | 30 | Derived Reference Field is derived from Interface Header attribute based on the batch source. | |
| TRX_SUB_CLASS_CODE | VARCHAR2 | 30 | Indicates the transaction subclass assigned to this transaction type. Valid values are derived from the lookup type ORA_AR_TRX_SUB_CLASS. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| AR_CUST_TRX_GT_U1 | Unique | TRX_CUSTOMER_TRX_ID |