This table contains details of Payment history distributions.
Module: Payables
PAYMENT_HIST_DIST_ID
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 |