DW_AP_PAYMENTS_EN

This table contains details of Payables payment and check Information.

Details

Module: Payables

Key Columns

CHECK_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CHECK_ID NUMBER 38 0 True      
SOURCE_RECORD_ID VARCHAR2 128     Source record identifier.    
SUBLEDGER_LINKAGE_HDR_ENTITY_ID VARCHAR2 128          
ACTUAL_VALUE_DATE DATE            
ADDRESS_LINE1 VARCHAR2 256          
ADDRESS_LINE2 VARCHAR2 256          
ADDRESS_LINE3 VARCHAR2 256          
ADDRESS_LINE4 VARCHAR2 256          
ADDRESS_STYLE VARCHAR2 32          
AMOUNT NUMBER            
ANTICIPATED_VALUE_DATE DATE            
BANK_ACCOUNT_NAME VARCHAR2 128          
BANK_ACCOUNT_NUM VARCHAR2 32          
BANK_ACCOUNT_TYPE VARCHAR2 32          
BANK_CHARGE_BEARER VARCHAR2 32          
BANK_NUM VARCHAR2 32          
BASE_AMOUNT NUMBER            
CEBANK_ACCT_USE_ID NUMBER 38 0        
CHECK_DATE DATE            
CHECK_FORMAT_ID NUMBER 38 0        
CHECK_NUMBER NUMBER 38 0        
CHECK_STOCK_ID NUMBER 38 0        
CHECK_VOUCHER_NUM NUMBER 38 0        
CHECK_RUN_ID NUMBER 38 0        
CHECK_RUN_NAME VARCHAR2 256          
CITY VARCHAR2 64          
CLEARED_AMOUNT NUMBER            
CLEARED_BASE_AMOUNT NUMBER            
CLEARED_CHARGES_AMOUNT NUMBER            
CLEARED_CHARGES_BASE_AMOUNT NUMBER            
CLEARED_DATE DATE            
CLEARED_ERROR_AMOUNT NUMBER            
CLEARED_ERROR_BASE_AMOUNT NUMBER            
CLEARED_EXCHANGE_DATE DATE            
CLEARED_EXCHANGE_RATE NUMBER            
CLEARED_EXCHANGE_RATE_TYPE VARCHAR2 32          
COMPLETED_PMTS_GROUP_ID NUMBER 38 0        
COUNTRY VARCHAR2 64          
COUNTY VARCHAR2 256          
CREATED_BY VARCHAR2 64          
CREATION_DATE TIMESTAMP            
CURRENCY_CODE VARCHAR2 16          
DESCRIPTION VARCHAR2 256          
DOC_CATEGORY_CODE VARCHAR2 32          
DOC_SEQUENCE_ID NUMBER 38 0        
DOC_SEQUENCE_VALUE NUMBER            
EMPLOYEE_ADDRESS_CODE VARCHAR2 16          
EXCHANGE_DATE DATE            
EXCHANGE_RATE NUMBER            
EXCHANGE_RATETYPE VARCHAR2 32          
EXTERNAL_BANK_ACCOUNT_ID NUMBER 38 0        
FUTURE_PAY_DUE_DATE DATE            
IBAN_NUMBER VARCHAR2 64          
LAST_UPDATE_DATE TIMESTAMP            
LAST_UPDATE_LOGIN VARCHAR2 32          
LAST_UPDATED_BY VARCHAR2 64          
LEGAL_ENTITY_ID NUMBER 38 0        
LOGICAL_GROUP_REFERENCE VARCHAR2 32          
MATURITY_EXCHANGE_DATE DATE            
MATURITY_EXCHANGE_RATE NUMBER            
MATURITY_EXCHANGE_RATE_TYPE VARCHAR2 32          
OBJECT_VERSION_NUMBER NUMBER 38 0        
ORG_ID NUMBER 38 0        
PARTY_ID NUMBER 38 0        
PARTY_SITEID NUMBER 38 0        
PAYMENT_DOCUMENT_ID NUMBER 38 0        
PAYMENT_ID NUMBER 38 0        
PAYMENT_INSTRUCTION_ID NUMBER 38 0        
PAYMENT_METHOD_CODE VARCHAR2 32          
PAYMENT_METHOD_LOOKUP_CODE VARCHAR2 32          
PAYMENT_PROFILE_ID NUMBER 38 0        
PAYMENT_TYPE_FLAG VARCHAR2 32          
POSITIVE_PAY_STATUS_CODE VARCHAR2 32          
PROVINCE VARCHAR2 256          
RECON_FLAG VARCHAR2 16          
RECON_CILIATION_BATCH_ID NUMBER 38 0        
RELATIONSHIP_ID NUMBER 38 0        
RELEASED_BY NUMBER 38 0        
RELEASED_DATE DATE            
REMIT_TO_ADDRESS_ID NUMBER 38 0        
REMIT_TO_ADDRESS_NAME VARCHAR2 256          
REMIT_TO_SUPPLIER_ID NUMBER 38 0        
REMIT_TO_SUPPLIER_NAME VARCHAR2 256          
REQUEST_ID NUMBER 38 0        
SETTLEMENT_PRIORITY VARCHAR2 32          
STAMP_DUTY_AMT NUMBER            
STAMP_DUTY_BASE_AMT NUMBER            
STATE VARCHAR2 256          
STATUS_LOOKUPCODE VARCHAR2 32          
STOPPED_BY NUMBER 38 0        
STOPPED_DATE DATE            
TRANSFER_PRIORITY VARCHAR2 32          
TREASURY_PAY_DATE DATE            
TREASURY_PAY_NUMBER NUMBER 38 0        
USSGLTRANSACTION_CODE VARCHAR2 32          
USSGLTRXCODECON_TEXT VARCHAR2 32          
VENDOR_ID NUMBER 38 0        
VENDOR_NAME VARCHAR2 256          
VENDOR_SITE_CODE VARCHAR2 16          
VENDOR_SITE_ID NUMBER 38 0        
VOID_DATE DATE            
XCURR_RATE_TYPE VARCHAR2 32          
ZIP VARCHAR2 64