DW_AR_INTERFACE_HEADER_ATTR_D

This table contains the Transaction Interface header Attributes and Interface Header context columns only

Details

Module: Receivables

Key Columns

CUSTOMER_TRX_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CUSTOMER_TRX_ID NUMBER 38 0 True Transaction identifier.
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Source Record Identifier for AR_Transactions
INTERFACE_HEADER_CONTEXT VARCHAR2 32 Interface header context.
INTERFACE_HEADER_ATTRIBUTE1 VARCHAR 32 Interface header attribute 1
INTERFACE_HEADER_ATTRIBUTE2 VARCHAR 32 Interface header attribute 2
INTERFACE_HEADER_ATTRIBUTE3 VARCHAR 32 Interface header attribute 3
INTERFACE_HEADER_ATTRIBUTE4 VARCHAR 32 Interface header attribute 4
INTERFACE_HEADER_ATTRIBUTE5 VARCHAR 32 Interface header attribute 5
INTERFACE_HEADER_ATTRIBUTE6 VARCHAR 32 Interface header attribute 6
INTERFACE_HEADER_ATTRIBUTE7 VARCHAR 32 Interface header attribute 7
INTERFACE_HEADER_ATTRIBUTE8 VARCHAR 32 Interface header attribute 8
INTERFACE_HEADER_ATTRIBUTE9 VARCHAR 32 Interface header attribute 9
INTERFACE_HEADER_ATTRIBUTE10 VARCHAR 32 Interface header attribute 10
INTERFACE_HEADER_ATTRIBUTE11 VARCHAR 32 Interface header attribute 11
INTERFACE_HEADER_ATTRIBUTE12 VARCHAR 32 Interface header attribute 12
INTERFACE_HEADER_ATTRIBUTE13 VARCHAR 32 Interface header attribute 13
INTERFACE_HEADER_ATTRIBUTE14 VARCHAR 32 Interface header attribute 14
INTERFACE_HEADER_ATTRIBUTE15 VARCHAR 32 Interface header attribute 15
INTERFACE_HEADER_DATE1 DATE Interface header Date 1
INTERFACE_HEADER_DATE2 DATE Interface header Date 2
INTERFACE_HEADER_DATE3 DATE Interface header Date 3
INTERFACE_HEADER_DATE4 DATE Interface header Date 4
INTERFACE_HEADER_DATE5 DATE Interface header Date 5
INTERFACE_HEADER_NUMBER1 NUMBER Interface header Number 1
INTERFACE_HEADER_NUMBER2 NUMBER Interface header Number 2
INTERFACE_HEADER_NUMBER3 NUMBER Interface header Number 3
INTERFACE_HEADER_NUMBER4 NUMBER Interface header Number 4
INTERFACE_HEADER_NUMBER5 NUMBER Interface header Number 5
CONTRACT_HEADER_ID NUMBER 38 0 Contract_header_id derived from interface_header_attribute2