OEB_AP_PAYMENT_HIST_DISTS

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PAYMENT_HIST_DIST_ID BIGINT 8
2 ACCOUNTING_EVENT_ID BIGINT 8
3 PAY_DIST_LOOKUP_CODE CHARACTER VARYING(30) 30
4 INVOICE_DISTRIBUTION_ID BIGINT 8
5 AMOUNT NUMERIC(18,2) 19
6 PAYMENT_HISTORY_ID BIGINT 8
7 INVOICE_PAYMENT_ID BIGINT 8
8 BANK_CURR_AMOUNT NUMERIC(18,2) 19
9 CLEARED_BASE_AMOUNT NUMERIC(18,2) 19
10 HISTORICAL_FLAG CHARACTER VARYING(1) 1
11 INVOICE_DIST_AMOUNT NUMERIC(18,2) 19
12 INVOICE_DIST_BASE_AMOUNT NUMERIC(18,2) 19
13 INVOICE_ADJUSTMENT_EVENT_ID BIGINT 8
14 MATURED_BASE_AMOUNT NUMERIC(18,2) 19
15 PAID_BASE_AMOUNT NUMERIC(18,2) 19
16 ROUNDING_AMT NUMERIC(18,2) 19
17 REVERSAL_FLAG CHARACTER VARYING(1) 1
18 REVERSED_PAY_HIST_DIST_ID BIGINT 8
19 CREATED_BY BIGINT 8
20 CREATION_DATE TIMESTAMP 8
21 LAST_UPDATE_DATE TIMESTAMP 8
22 LAST_UPDATED_BY BIGINT 8
23 LAST_UPDATE_LOGIN BIGINT 8
24 PROGRAM_APPLICATION_ID BIGINT 8
25 PROGRAM_ID BIGINT 8
26 PROGRAM_LOGIN_ID BIGINT 8
27 PROGRAM_UPDATE_DATE TIMESTAMP 8
28 REQUEST_ID BIGINT 8
29 AWT_RELATED_ID BIGINT 8
30 RELEASE_INV_DIST_DERIVED_FROM BIGINT 8
31 PA_ADDITION_FLAG CHARACTER VARYING(1) 1
32 AMOUNT_VARIANCE NUMERIC(18,2) 19
33 INVOICE_BASE_AMT_VARIANCE NUMERIC(18,2) 19
34 QUANTITY_VARIANCE NUMERIC(18,2) 19
35 INVOICE_BASE_QTY_VARIANCE NUMERIC(18,2) 19
36 GAIN_LOSS_INDICATOR CHARACTER VARYING(1) 1
37 CDC_SOURCE_SYSTEM_CODE CHARACTER(4) 4
38 CDC_RECORD_TYPE CHARACTER(16) 16
39 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
40 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8