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     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    

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