PRT_CLTACCT

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 CLIENT INTEGER 4
3 VERSION SMALLINT 2
4 PAYMETHOD CHARACTER(1) 1
5 BSBNO CHARACTER(6) 6
6 BANKACCT CHARACTER(9) 9
7 CREDCARD CHARACTER(16) 16
8 ACCTNAME CHARACTER(35) 35
9 REMITDLV CHARACTER(1) 1
10 HOLDFLAG CHARACTER(1) 1
11 HOLDRSN CHARACTER(4) 4
12 TRANDATE INTEGER 4
13 TRANTIME INTEGER 4
14 USERID CHARACTER(8) 8
15 AUTHREQ CHARACTER(1) 1
16 LSTCRDDTE INTEGER 4
17 FAXNO CHARACTER(10) 10
18 ACCSTATUS CHARACTER(1) 1
19 REASONCDE CHARACTER(2) 2
20 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
21 RECORD_TYPE CHARACTER VARYING(16) 16
22 COMMIT_TIMESTAMP TIMESTAMP 8
23 EXTRACT_TIMESTAMP TIMESTAMP 8