DW_AR_INTERFACE_LINE_ATTR_D

This table contains the Transaction line Interface Line Attributes and Interface Line context columns only

Details

Module: Receivables

Key Columns

CUSTOMER_TRX_LINE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CUSTOMER_TRX_LINE_ID NUMBER 38 0 True Customer Transaction Line Id    
SOURCE_RECORD_ID VARCHAR2 256     This column is for Oracle Internal use only. Source record identifier. Value is same as receipt application distribution line identifier.    
CUSTOMER_TRX_ID NUMBER 38 0   Transaction identifier    
INTERFACE_LINE_CONTEXT VARCHAR2 32     Interface line context    
INTERFACE_LINE_ATTRIBUTE1 VARCHAR2 32     Interface line Attribute 1    
INTERFACE_LINE_ATTRIBUTE2 VARCHAR2 32     Interface line Attribute 2    
INTERFACE_LINE_ATTRIBUTE3 VARCHAR2 32     Interface line Attribute 3    
INTERFACE_LINE_ATTRIBUTE4 VARCHAR2 32     Interface line Attribute 4    
INTERFACE_LINE_ATTRIBUTE5 VARCHAR2 32     Interface line Attribute 5    
INTERFACE_LINE_ATTRIBUTE6 VARCHAR2 32     Interface line Attribute 6    
INTERFACE_LINE_ATTRIBUTE7 VARCHAR2 32     Interface line Attribute 7    
INTERFACE_LINE_ATTRIBUTE8 VARCHAR2 32     Interface line Attribute 8    
INTERFACE_LINE_ATTRIBUTE9 VARCHAR2 32     Interface line Attribute 9    
INTERFACE_LINE_ATTRIBUTE10 VARCHAR2 32     Interface line Attribute 10    
INTERFACE_LINE_ATTRIBUTE11 VARCHAR2 32     Interface line Attribute 11    
INTERFACE_LINE_ATTRIBUTE12 VARCHAR2 32     Interface line Attribute 12    
INTERFACE_LINE_ATTRIBUTE13 VARCHAR2 32     Interface line Attribute 13    
INTERFACE_LINE_ATTRIBUTE14 VARCHAR2 32     Interface line Attribute 14    
INTERFACE_LINE_ATTRIBUTE15 VARCHAR2 32     Interface line Attribute 15    
CONTRACT_LINE_ID NUMBER 38 0   Contract_line_id derived from interface_line_attribute9    
PROJECT_ID NUMBER 38 0   Project_id derived from interface_line_attribute10    
TASK_ID NUMBER 38 0   Task_id derived from interface_line_attribute11    

Copyright © 2019, 2024, Oracle and/or its affiliates.