DW_AP_PAYMENT_HIST_DISTS_EN

This table contains details of Payment history distributions.

Details

Module: Payables

Key Columns

PAYMENT_HIST_DIST_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PAYMENT_HIST_DIST_ID NUMBER 38 0 True      
SOURCE_RECORD_ID VARCHAR2 128     Source record identifier    
SUBLEDGER_LINKAGE_DST_ENTITY_ID VARCHAR2 128          
REVERSED_PAY_HIST_DIST_ID NUMBER 38 0        
INVOICE_DIST_AMOUNT NUMBER            
INVOICE_DIST_BASE_AMOUNT NUMBER            
PAY_DIST_LOOKUP_CODE VARCHAR2 32          
AMOUNT NUMBER            
PAID_BASE_AMOUNT NUMBER            
ACCOUNTING_EVENT_ID NUMBER 38 0        
INVOICE_DISTRIBUTION_ID NUMBER 38 0        
O_POSTED_FLAG VARCHAR2 16          
O_TRANSACTION_TYPE VARCHAR2 64          
C_CHECK_ID NUMBER 38 0        
C_CHECK_NUMBER NUMBER 38 0        
C_CHECK_DATE DATE            
C_CLEARED_DATE DATE            
C_PAYMENT_METHOD_CODE VARCHAR2 32          
C_STATUS_LOOKUP_CODE VARCHAR2 32          
C_CREATED_BY VARCHAR2 64          
C_LAST_UPDATED_BY VARCHAR2 64          
C_CE_BANK_ACCT_USE_ID NUMBER 38 0        
C_REMIT_TO_SUPPLIER_ID NUMBER 38 0        
C_VOID_DATE DATE            
P_INVOICE_PAYMENT_ID NUMBER 38 0        
P_ORG_ID NUMBER 38 0        
P_ACCOUNTING_DATE DATE            
P_EXCHANGE_RATE NUMBER            
P_DISCOUNT_TAKEN NUMBER            
P_DISCOUNT_TAKEN_INV_CURR NUMBER            
P_CREATED_BY VARCHAR2 64          
P_LAST_UPDATED_BY VARCHAR2 64          
P_PAYMENT_NUM NUMBER 38 0        
P_DISCOUNT_LOST NUMBER            
P_REMIT_TO_SUPPLIER_ID NUMBER 38 0        
P_DISCOUNT_LOST_INV_CURR NUMBER            
H_INVOICE_ID NUMBER 38 0        
H_INVOICE_NUM VARCHAR2 64          
H_DESCRIPTION VARCHAR2 256          
H_PAYMENT_REASON_COMMENTS VARCHAR2 256          
H_PARTY_ID NUMBER 38 0        
H_VENDOR_SITE_ID NUMBER 38 0        
H_REMIT_TO_SUPPLIER_ID NUMBER 38 0        
H_ORG_ID NUMBER 38 0        
H_SET_OF_BOOKS_ID NUMBER 38 0        
H_LEGAL_ENTITY_ID NUMBER 38 0        
H_ACCTS_PAY_CODE_COMBINATION_ID NUMBER 38 0        
H_INVOICE_DATE DATE            
H_INVOICE_RECEIVED_DATE DATE            
H_TERMS_ID NUMBER 38 0        
H_INVOICE_TYPE_LOOKUP_CODE VARCHAR2 32          
H_SOURCE VARCHAR2 32          
H_CANCELLED_DATE DATE            
H_INVOICE_CURRENCY_CODE VARCHAR2 16          
H_PAYMENT_CURRENCY_CODE VARCHAR2 16          
H_CREATION_DATE TIMESTAMP            
H_CREATED_BY VARCHAR2 64          
H_LAST_UPDATE_DATE TIMESTAMP            
H_GL_DATE DATE            
H_WFAPPROVAL_STATUS VARCHAR2 64          
H_PAYMENT_STATUS_FLAG VARCHAR2 16          
H_DOC_SEQUENCE_VALUE NUMBER 38 0        
H_BATCH_ID NUMBER 38 0   Unique invoice group identifier.    
H_EXCHANGE_RATE NUMBER       Ratio at which the principal unit of one currency is converted into another currency for an invoice.    
H_LAST_UPDATED_BY VARCHAR2 64     Who column: indicates the user who last updated the row.    
H_APPROVAL_STATUS VARCHAR2 32     Status of manual authorization invoice approval (used for reference purposes only).    
H_PO_HEADER_ID NUMBER 38 0   PO Header identifier.    
E_PMT_HIST_DIST_ID NUMBER 38 0   Equalized column added to avoid transformation in Joins in the payments fact