OBP24_FLX_LZ_AU_TDS_TAX_ELIGIBILITY

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TRANSACTION_REFERENCE_NO CHARACTER VARYING(40) 40
2 IS_TAX_ON_PRINCIPLE CHARACTER(1) 1
3 PARTIES_INVOLVED CHARACTER VARYING(1000) 1000
4 CHILD_EXEMPTION_CODE_COUNT DOUBLE PRECISION 8
5 FOREIGN_EXEMPTION_CODE_COUNT DOUBLE PRECISION 8
6 OTHER_EXEMPTION_CODE_COUNT DOUBLE PRECISION 8
7 NO_EXEMPTION_CODE_COUNT DOUBLE PRECISION 8
8 TOTAL_TAXABLE_INCOME DOUBLE PRECISION 8
9 WITHHOLDING_TAX_TYPE CHARACTER VARYING(100) 100
10 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
11 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
12 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
13 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8