FCT_APS_BOND_TRANSACTION_DETAILS
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | TRANSACTIONID | INTEGER | 4 |
| 2 | BONDID | INTEGER | 4 |
| 3 | BONDNUMBER | CHARACTER VARYING(20) | 20 |
| 4 | BONDSTATUSCODE | CHARACTER VARYING(20) | 20 |
| 5 | CREATEDDATE | CHARACTER VARYING(200) | 200 |
| 6 | CREATEDUSERID | CHARACTER VARYING(10) | 10 |
| 7 | APPROVEDDATE | CHARACTER VARYING(200) | 200 |
| 8 | APPROVEDUSERID | CHARACTER VARYING(10) | 10 |
| 9 | BONDSTARTDATE | CHARACTER VARYING(200) | 200 |
| 10 | BONDENDDATE | CHARACTER VARYING(200) | 200 |
| 11 | MODIFIEDDATE | CHARACTER VARYING(200) | 200 |
| 12 | MODIFIEDBYUSERID | CHARACTER VARYING(10) | 10 |
| 13 | CLIENTID | CHARACTER VARYING(10) | 10 |
| 14 | BONDTYPE | CHARACTER VARYING(40) | 40 |
| 15 | CANCELTYPE | CHARACTER VARYING(20) | 20 |
| 16 | LAPSEDDATE | CHARACTER VARYING(200) | 200 |
| 17 | LAPSEDBYUSERID | CHARACTER VARYING(10) | 10 |
| 18 | PREMIUMRATE | NUMERIC(3,2) | 19 |
| 19 | PREMIUMGROSSAMT | NUMERIC(20,2) | 19 |
| 20 | PREMIUMADMINOTHERCHARGEAMT | NUMERIC(20,2) | 19 |
| 21 | PREMIUMADMINOTHERCHARGEGSTAMT | NUMERIC(20,2) | 19 |
| 22 | PREMIUMBROKERAGEAMT | NUMERIC(20,2) | 19 |
| 23 | PREMIUMBROKERAGEGSTAMT | NUMERIC(20,2) | 19 |
| 24 | PREMIUMNETAMT | NUMERIC(20,2) | 19 |
| 25 | BOND_ISSUING_CURRENCY | CHARACTER VARYING(5) | 5 |
| 26 | BOND_COUNTRY_OF_ISSUE | CHARACTER VARYING(5) | 5 |
| 27 | CLIENT_NAME | CHARACTER VARYING(150) | 150 |
| 28 | CLIENT_ADDRESS_STREET | CHARACTER VARYING(50) | 50 |
| 29 | CLIENT_ADDRESS_SUBRURB | CHARACTER VARYING(40) | 40 |
| 30 | CLIENT_ADDRESS_STATE | CHARACTER VARYING(10) | 10 |
| 31 | CLIENT_ADDRESS_POSTCODE | CHARACTER VARYING(6) | 6 |
| 32 | PROTECT_POLICYNUMBER | CHARACTER VARYING(20) | 20 |
| 33 | PROTECT_OS_DEBTOR_AMT | NUMERIC(38,2) | 19 |