PRT_PAYMENT

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 SUBCOY SMALLINT 2
3 STATE SMALLINT 2
4 BRANCH SMALLINT 2
5 ENCRPAYNO INTEGER 4
6 PAYMENTNO INTEGER 4
7 PAYTYPE CHARACTER(1) 1
8 CLIENT INTEGER 4
9 CHEQUENO INTEGER 4
10 MANCHQ CHARACTER(1) 1
11 MANDATE INTEGER 4
12 POSTNREF1 INTEGER 4
13 POSTNREF2 INTEGER 4
14 POSTALREF INTEGER 4
15 AMOUNT NUMERIC(13,2) 19
16 AUTHCOMP CHARACTER(1) 1
17 AUTHDATE INTEGER 4
18 CANCELPAY CHARACTER(1) 1
19 BULKIND CHARACTER(1) 1
20 HOLDDATE INTEGER 4
21 SOLECHQ CHARACTER(1) 1
22 CHQRUN INTEGER 4
23 TRANDATE INTEGER 4
24 TRANTIME INTEGER 4
25 LOCKDATE INTEGER 4
26 LOCKTIME INTEGER 4
27 GSTITC NUMERIC(11,2) 19
28 CLTACCVSN SMALLINT 2
29 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
30 RECORD_TYPE CHARACTER VARYING(16) 16
31 COMMIT_TIMESTAMP TIMESTAMP 8
32 EXTRACT_TIMESTAMP TIMESTAMP 8
33 CDC_ID BIGINT 8
34 COMPANY_CDC SMALLINT 2
35 TRANDATE_CDC DATE 4
36 DW_TIMESTAMP TIMESTAMP 8
37 CHEQUENME CHARACTER(40) 40
38 PAYMNTOF CHARACTER(40) 40
39 AUTHORBY1 CHARACTER(8) 8
40 AUTHORBY2 CHARACTER(8) 8
41 REASONCHQ CHARACTER(3) 3
42 USERID CHARACTER(8) 8
43 LOCKUSER CHARACTER(8) 8
44 CREDITNO CHARACTER(20) 20
45 CARDEXPRY SMALLINT 2
46 BSBNO CHARACTER(6) 6
47 DEBITACCT CHARACTER(9) 9