AR_REV_ADJ_TEMP_ALL
Temporary Table to hold the Data while doing Revenue Adjustment Transactions
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
AR_REV_ADJ_TEMP_ALL_PK |
CUSTOMER_TRX_ID, REQUEST_IDENTIFIER, ADJUSTMENT_TYPE, FROM_CUST_TRX_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CUSTOMER_TRX_ID | NUMBER | 18 | Yes | Transaction identifier. | |
| TRX_NUMBER | VARCHAR2 | 20 | Transaction number. | ||
| BATCH_SOURCE_NAME | VARCHAR2 | 50 | Transaction batch source name. | ||
| ADJUSTMENT_TYPE | VARCHAR2 | 15 | Yes | Revenue adjustment type. | |
| FROM_SALESREP_ID | NUMBER | 18 | From sales person identifier. | ||
| FROM_SALESREP_NUMBER | VARCHAR2 | 30 | The from sales person number. | ||
| TO_SALESREP_ID | NUMBER | 18 | To sales person identifier. | ||
| TO_SALESREP_NUMBER | VARCHAR2 | 30 | The to sales person number. | ||
| FROM_SALESGROUP_ID | NUMBER | From sales group identifier. | |||
| TO_SALESGROUP_ID | NUMBER | To sales group identifier. | |||
| SALES_CREDIT_TYPE | VARCHAR2 | 15 | Sales credit type to be adjusted. | ||
| AMOUNT_MODE | VARCHAR2 | 15 | Indicates type of amount that is adjusted. | ||
| AMOUNT | NUMBER | Revenue adjustment amount. | |||
| PERCENT | NUMBER | Revenue adjustment percent. | |||
| LINE_SELECTION_MODE | VARCHAR2 | 15 | Indicates criterion that is used to select lines. | ||
| FROM_CATEGORY_ID | NUMBER | 18 | From inventory item category identifier. | ||
| FROM_CATEGORY_SEGMENT1 | VARCHAR2 | 40 | From inventory category segment 1. | ||
| FROM_CATEGORY_SEGMENT2 | VARCHAR2 | 40 | From inventory category segment 2. | ||
| FROM_CATEGORY_SEGMENT3 | VARCHAR2 | 40 | From inventory category segment 3. | ||
| FROM_CATEGORY_SEGMENT4 | VARCHAR2 | 40 | From inventory category segment 4. | ||
| FROM_CATEGORY_SEGMENT5 | VARCHAR2 | 40 | From inventory category segment 5. | ||
| FROM_CATEGORY_SEGMENT6 | VARCHAR2 | 40 | From inventory category segment 6. | ||
| FROM_CATEGORY_SEGMENT7 | VARCHAR2 | 40 | From inventory category segment 7. | ||
| FROM_CATEGORY_SEGMENT8 | VARCHAR2 | 40 | From inventory category segment 8. | ||
| FROM_CATEGORY_SEGMENT9 | VARCHAR2 | 40 | From inventory category segment 9. | ||
| FROM_CATEGORY_SEGMENT10 | VARCHAR2 | 40 | From inventory category segment 10. | ||
| FROM_CATEGORY_SEGMENT11 | VARCHAR2 | 40 | From inventory category segment 11. | ||
| FROM_CATEGORY_SEGMENT12 | VARCHAR2 | 40 | From inventory category segment 12. | ||
| FROM_CATEGORY_SEGMENT13 | VARCHAR2 | 40 | From inventory category segment 13. | ||
| FROM_CATEGORY_SEGMENT14 | VARCHAR2 | 40 | From inventory category segment 14. | ||
| FROM_CATEGORY_SEGMENT15 | VARCHAR2 | 40 | From inventory category segment 15. | ||
| FROM_CATEGORY_SEGMENT16 | VARCHAR2 | 40 | From inventory category segment 16. | ||
| FROM_CATEGORY_SEGMENT17 | VARCHAR2 | 40 | From inventory category segment 17. | ||
| FROM_CATEGORY_SEGMENT18 | VARCHAR2 | 40 | From inventory category segment 18. | ||
| FROM_CATEGORY_SEGMENT19 | VARCHAR2 | 40 | From inventory category segment 19. | ||
| FROM_CATEGORY_SEGMENT20 | VARCHAR2 | 40 | From inventory category segment 20. | ||
| TO_CATEGORY_ID | NUMBER | 18 | To inventory item category identifier. | ||
| TO_CATEGORY_SEGMENT1 | VARCHAR2 | 40 | To inventory category segment 1. | ||
| TO_CATEGORY_SEGMENT2 | VARCHAR2 | 40 | To inventory category segment 2. | ||
| TO_CATEGORY_SEGMENT3 | VARCHAR2 | 40 | To inventory category segment 3. | ||
| TO_CATEGORY_SEGMENT4 | VARCHAR2 | 40 | To inventory category segment 4. | ||
| TO_CATEGORY_SEGMENT5 | VARCHAR2 | 40 | To inventory category segment 5. | ||
| TO_CATEGORY_SEGMENT6 | VARCHAR2 | 40 | To inventory category segment 6. | ||
| TO_CATEGORY_SEGMENT7 | VARCHAR2 | 40 | To inventory category segment 7. | ||
| TO_CATEGORY_SEGMENT8 | VARCHAR2 | 40 | To inventory category segment 8. | ||
| TO_CATEGORY_SEGMENT9 | VARCHAR2 | 40 | To inventory category segment 9. | ||
| TO_CATEGORY_SEGMENT10 | VARCHAR2 | 40 | To inventory category segment 10. | ||
| TO_CATEGORY_SEGMENT11 | VARCHAR2 | 40 | To inventory category segment 11. | ||
| TO_CATEGORY_SEGMENT12 | VARCHAR2 | 40 | To inventory category segment 12. | ||
| TO_CATEGORY_SEGMENT13 | VARCHAR2 | 40 | To inventory category segment 13. | ||
| TO_CATEGORY_SEGMENT14 | VARCHAR2 | 40 | To inventory category segment 14. | ||
| TO_CATEGORY_SEGMENT15 | VARCHAR2 | 40 | To inventory category segment 15. | ||
| TO_CATEGORY_SEGMENT16 | VARCHAR2 | 40 | To inventory category segment 16. | ||
| TO_CATEGORY_SEGMENT17 | VARCHAR2 | 40 | To inventory category segment 17. | ||
| TO_CATEGORY_SEGMENT18 | VARCHAR2 | 40 | To inventory category segment 18. | ||
| TO_CATEGORY_SEGMENT19 | VARCHAR2 | 40 | To inventory category segment 19. | ||
| TO_CATEGORY_SEGMENT20 | VARCHAR2 | 40 | To inventory category segment 20. | ||
| FROM_INVENTORY_ITEM_ID | NUMBER | 18 | From inventory item identifier. | ||
| FROM_ITEM_SEGMENT1 | VARCHAR2 | 40 | From inventory item segment 1. | ||
| FROM_ITEM_SEGMENT2 | VARCHAR2 | 40 | From inventory item segment 2. | ||
| FROM_ITEM_SEGMENT3 | VARCHAR2 | 40 | From inventory item segment 3. | ||
| FROM_ITEM_SEGMENT4 | VARCHAR2 | 40 | From inventory item segment 4. | ||
| FROM_ITEM_SEGMENT5 | VARCHAR2 | 40 | From inventory item segment 5. | ||
| FROM_ITEM_SEGMENT6 | VARCHAR2 | 40 | From inventory item segment 6. | ||
| FROM_ITEM_SEGMENT7 | VARCHAR2 | 40 | From inventory item segment 7. | ||
| FROM_ITEM_SEGMENT8 | VARCHAR2 | 40 | From inventory item segment 8. | ||
| FROM_ITEM_SEGMENT9 | VARCHAR2 | 40 | From inventory item segment 9. | ||
| FROM_ITEM_SEGMENT10 | VARCHAR2 | 40 | From inventory item segment 10. | ||
| FROM_ITEM_SEGMENT11 | VARCHAR2 | 40 | From inventory item segment 11. | ||
| FROM_ITEM_SEGMENT12 | VARCHAR2 | 40 | From inventory item segment 12. | ||
| FROM_ITEM_SEGMENT13 | VARCHAR2 | 40 | From inventory item segment 13. | ||
| FROM_ITEM_SEGMENT14 | VARCHAR2 | 40 | From inventory item segment 14. | ||
| FROM_ITEM_SEGMENT15 | VARCHAR2 | 40 | From inventory item segment 15. | ||
| FROM_ITEM_SEGMENT16 | VARCHAR2 | 40 | From inventory item segment 16. | ||
| FROM_ITEM_SEGMENT17 | VARCHAR2 | 40 | From inventory item segment 17. | ||
| FROM_ITEM_SEGMENT18 | VARCHAR2 | 40 | From inventory item segment 18. | ||
| FROM_ITEM_SEGMENT19 | VARCHAR2 | 40 | From inventory item segment 19. | ||
| FROM_ITEM_SEGMENT20 | VARCHAR2 | 40 | From inventory item segment 20. | ||
| TO_INVENTORY_ITEM_ID | NUMBER | 18 | To inventory item identifier. | ||
| TO_ITEM_SEGMENT1 | VARCHAR2 | 40 | To inventory item segment 1. | ||
| TO_ITEM_SEGMENT2 | VARCHAR2 | 40 | To inventory item segment 2. | ||
| TO_ITEM_SEGMENT3 | VARCHAR2 | 40 | To inventory item segment 3. | ||
| TO_ITEM_SEGMENT4 | VARCHAR2 | 40 | To inventory item segment 4. | ||
| TO_ITEM_SEGMENT5 | VARCHAR2 | 40 | To inventory item segment 5. | ||
| TO_ITEM_SEGMENT6 | VARCHAR2 | 40 | To inventory item segment 6. | ||
| TO_ITEM_SEGMENT7 | VARCHAR2 | 40 | To inventory item segment 7. | ||
| TO_ITEM_SEGMENT8 | VARCHAR2 | 40 | To inventory item segment 8. | ||
| TO_ITEM_SEGMENT9 | VARCHAR2 | 40 | To inventory item segment 9. | ||
| TO_ITEM_SEGMENT10 | VARCHAR2 | 40 | To inventory item segment 10. | ||
| TO_ITEM_SEGMENT11 | VARCHAR2 | 40 | To inventory item segment 11. | ||
| TO_ITEM_SEGMENT12 | VARCHAR2 | 40 | To inventory item segment 12. | ||
| TO_ITEM_SEGMENT13 | VARCHAR2 | 40 | To inventory item segment 13. | ||
| TO_ITEM_SEGMENT14 | VARCHAR2 | 40 | To inventory item segment 14. | ||
| TO_ITEM_SEGMENT15 | VARCHAR2 | 40 | To inventory item segment 15. | ||
| TO_ITEM_SEGMENT16 | VARCHAR2 | 40 | To inventory item segment 16. | ||
| TO_ITEM_SEGMENT17 | VARCHAR2 | 40 | To inventory item segment 17. | ||
| TO_ITEM_SEGMENT18 | VARCHAR2 | 40 | To inventory item segment 18. | ||
| TO_ITEM_SEGMENT19 | VARCHAR2 | 40 | To inventory item segment 19. | ||
| TO_ITEM_SEGMENT20 | VARCHAR2 | 40 | To inventory item segment 20. | ||
| FROM_CUST_TRX_LINE_ID | NUMBER | 18 | Yes | From transaction line identifier. | |
| FROM_LINE_NUMBER | NUMBER | 18 | From line number. | ||
| TO_CUST_TRX_LINE_ID | NUMBER | 18 | To transaction line identifier. | ||
| TO_LINE_NUMBER | NUMBER | 18 | To line number. | ||
| GL_DATE | DATE | Revenue adjustment accounting date. | |||
| REASON_CODE | VARCHAR2 | 15 | Revenue adjustment reason code. | ||
| COMMENTS | VARCHAR2 | 2000 | Adjustment action related comments. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| SOURCE | VARCHAR2 | 30 | Not currently used. | ||
| SESSION_ID | NUMBER | Session identifier. | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| FROM_RESOURCE_SALESREP_ID | NUMBER | 18 | From sales person identifier. | ||
| TO_RESOURCE_SALESREP_ID | NUMBER | 18 | To sales person identifier. | ||
| REQUEST_IDENTIFIER | NUMBER | Yes | Request identifier. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_REV_ADJ_TEMP_ALL_U1 | Unique | Default | CUSTOMER_TRX_ID, REQUEST_IDENTIFIER, ADJUSTMENT_TYPE, FROM_CUST_TRX_LINE_ID |
| AR_REV_ADJ_TEMP_N1 | Non Unique | Default | REQUEST_IDENTIFIER |