FCT_BTTPS_SUBMISSION_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_BTTPS_SUBMISSION

Columns
# Name Data Type Length
1 RECORD_LENGTH CHARACTER VARYING(4) 4
2 INTERMEDIARY_RECORD_IDENTIFIER CHARACTER VARYING(13) 13
3 REPORTING_PARTY_RECORD_IDENTIFIER CHARACTER VARYING(4) 4
4 REPORT_SPEC_VERSION CHARACTER VARYING(10) 10
5 ABN CHARACTER VARYING(11) 11
6 CREATE_DATE_TIME CHARACTER VARYING(218) 218
7 FILE_REFERENCE CHARACTER VARYING(7) 7
8 NAME CHARACTER VARYING(22) 22
9 CONTACT_NAME CHARACTER VARYING(12) 12
10 CONTACT_PH_AREA_CODE CHARACTER VARYING(2) 2
11 CONTACT_PHONE_NUMBER CHARACTER VARYING(8) 8
12 STREET_ADDR_LINE_1 CHARACTER VARYING(26) 26
13 STREET_ADDR_LINE_2 CHARACTER VARYING(1) 1
14 STREET_SUBURB_TOWN_LOCALITY CHARACTER VARYING(8) 8
15 STREET_STATE_OR_TERRITORY CHARACTER VARYING(3) 3
16 STREET_ADDRESS_POSTCODE CHARACTER VARYING(4) 4
17 STREET_ADDRESS_COUNTRY CHARACTER VARYING(1) 1
18 CONTACT_EMAIL CHARACTER VARYING(27) 27
19 REPORT_START_DATE CHARACTER VARYING(200) 200
20 REPORT_END_DATE CHARACTER VARYING(200) 200
21 BRANCH_NUMBER CHARACTER VARYING(3) 3
22 REGISTERED_NAME CHARACTER VARYING(22) 22
23 TRADING_NAME CHARACTER VARYING(1) 1
24 POSTAL_ADDR_LINE_1 CHARACTER VARYING(12) 12
25 POSTAL_ADDR_LINE_2 CHARACTER VARYING(1) 1
26 POSTAL_SUBURB_TOWN_LOCALITY CHARACTER VARYING(8) 8
27 POSTAL_STATE_OR_TERRITORY CHARACTER VARYING(3) 3
28 POSTAL_ADDRESS_POSTCODE CHARACTER VARYING(4) 4
29 POSTAL_ADDRESS_COUNTRY CHARACTER VARYING(1) 1
30 SOFTWARE_PRODUCT_TYPE CHARACTER VARYING(64) 64
31 BD_RECLENGTH CHARACTER VARYING(4) 4
32 BD_RECIDENT CHARACTER VARYING(4) 4
33 BD_CRN CHARACTER VARYING(23) 23
34 BD_COMMENCE_DT CHARACTER VARYING(200) 200
35 BD_SURNAME CHARACTER VARYING(80) 80
36 BD_FIRST_NAME CHARACTER VARYING(80) 80
37 BD_SECOND_NAME CHARACTER VARYING(80) 80
38 BD_BIRTH_DATE CHARACTER VARYING(200) 200
39 BD_ABN_NBR CHARACTER VARYING(200) 200
40 BD_ACN CHARACTER VARYING(200) 200
41 BD_REGISTERED_NAME CHARACTER VARYING(81) 81
42 BD_TRADING_NAME CHARACTER VARYING(50) 50
43 BD_STREET_ADDRESS_1 CHARACTER VARYING(150) 150
44 BD_STREET_ADDRESS_2 CHARACTER VARYING(150) 150
45 BD_STREET_ADDRESS_CITY CHARACTER VARYING(64) 64
46 BD_STREET_ADDRESS_STATE CHARACTER VARYING(10) 10
47 BD_STREET_ADDRESS_PCODE CHARACTER VARYING(25) 25
48 BD_STREET_ADDRESS_CNTRY_CD CHARACTER VARYING(3) 3
49 BD_POSTAL_ADDRESS_1 CHARACTER VARYING(150) 150
50 BD_POSTAL_ADDRESS_2 CHARACTER VARYING(150) 150
51 BD_POSTAL_ADDRESS_CITY CHARACTER VARYING(64) 64
52 BD_POSTAL_ADDRESS_STATE CHARACTER VARYING(15) 15
53 BD_POSTAL_ADDRESS_PCODE CHARACTER VARYING(10) 10
54 BD_POSTAL_ADDRESS_CNTRY_CD CHARACTER VARYING(2) 2
55 BD_CONTACT_NAME CHARACTER(25) 25
56 BD_CONTACT_PH_AREA_CODE CHARACTER VARYING(2) 2
57 BD_CONTACT_PH_NBR CHARACTER VARYING(8) 8
58 BD_EMAIL_ADDR CHARACTER VARYING(250) 250
59 BD_GRP_LVL_ID CHARACTER VARYING(1) 1
60 BD_BUS_CATEGORY_DESC CHARACTER VARYING(40) 40
61 BD_LODGEMENT_TYPE CHARACTER VARYING(1) 1
62 FILLER CHARACTER VARYING(1) 1
63 TRAN_SUMM_REC_LENGTH CHARACTER VARYING(4) 4
64 TRAN_SUMM_REC_IDENT CHARACTER VARYING(4) 4
65 TRAN_SUMM_CRN CHARACTER VARYING(23) 23
66 TRAN_SUMM_PAYMENT_SYSTEM CHARACTER VARYING(26) 26
67 TRAN_SUMM_PAYMENT_SYSTEM_ACCT_NBR CHARACTER VARYING(23) 23
68 TRAN_SUMM_SETTLEMENT_BANK_ACCOUNT_NAME CHARACTER VARYING(160) 160
69 TRAN_SUMM_SETTLEMENT_BSB_NBR CHARACTER VARYING(10) 10
70 TRAN_SUMM_SETTLEMENT_ACCT_NBR CHARACTER VARYING(23) 23
71 TRANSACTION_PERIOD_ST_DATE CHARACTER VARYING(200) 200
72 TRANSACTION_PERIOD_END_DATE CHARACTER VARYING(200) 200
73 TRANSACTION_CURRENCY CHARACTER VARYING(20) 20
74 GROSS_PAYMENT_AMOUNT NUMERIC(36,0) 19
75 GROSS_PAYMENT_COUNT NUMERIC(38,0) 19
76 REFUND_PAYMENT_AMOUNT NUMERIC(36,0) 19
77 REFUND_PAYMENT_COUNT NUMERIC(38,0) 19
78 CASH_ONLY_AMOUNT NUMERIC(36,0) 19
79 CASH_ONLY_COUNT NUMERIC(38,0) 19
80 CASH_OUT_COMPONENT NUMERIC(38,0) 19
81 TRANS_SUMMARY_FILLER CHARACTER VARYING(1) 1
82 SUBMISSION_CREATE_DATE DATE 4
83 SUBMISSION_NBR BIGINT 8