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