OBP24_FLX_PI_ADDRESSES_B
Description
Synonyms
SDSNZP05_BANK..CBP_OBP_FLX_PI_ADDRESSES_B
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | PARTY_ID | CHARACTER VARYING(40) | 40 |
| 2 | LANGUAGE_ID | CHARACTER VARYING(30) | 30 |
| 3 | ADDRESS_TYPE | CHARACTER VARYING(10) | 10 |
| 4 | EFFECTIVE_DATE | TIMESTAMP | 8 |
| 5 | ACCOMODATION_TYPE | CHARACTER VARYING(30) | 30 |
| 6 | ADDRESS_LINE1_TXT | CHARACTER VARYING(120) | 120 |
| 7 | ADDRESS_LINE2_TXT | CHARACTER VARYING(120) | 120 |
| 8 | ADDRESS_LINE3_TXT | CHARACTER VARYING(120) | 120 |
| 9 | ADDRESS_LINE4_TXT | CHARACTER VARYING(120) | 120 |
| 10 | ADDRESS_LINE5_TXT | CHARACTER VARYING(120) | 120 |
| 11 | ADDRESS_LINE6_TXT | CHARACTER VARYING(120) | 120 |
| 12 | ADDRESS_LINE7_TXT | CHARACTER VARYING(120) | 120 |
| 13 | ADDRESS_LINE8_TXT | CHARACTER VARYING(120) | 120 |
| 14 | CITY_ID | CHARACTER VARYING(50) | 50 |
| 15 | STATE_ID | CHARACTER VARYING(30) | 30 |
| 16 | COUNTRY_ID | CHARACTER VARYING(2) | 2 |
| 17 | ZIP_CODE | CHARACTER VARYING(30) | 30 |
| 18 | LANDLORD_FULL_NAME | CHARACTER VARYING(480) | 480 |
| 19 | LANDLORD_ADDRESS_LINE1_TXT | CHARACTER VARYING(120) | 120 |
| 20 | LANDLORD_ADDRESS_LINE2_TXT | CHARACTER VARYING(120) | 120 |
| 21 | LANDLORD_ADDRESS_LINE3_TXT | CHARACTER VARYING(120) | 120 |
| 22 | LANDLORD_ADDRESS_LINE4_TXT | CHARACTER VARYING(120) | 120 |
| 23 | LANDLORD_ADDRESS_LINE5_TXT | CHARACTER VARYING(120) | 120 |
| 24 | LANDLORD_ADDRESS_LINE6_TXT | CHARACTER VARYING(120) | 120 |
| 25 | LANDLORD_ADDRESS_LINE7_TXT | CHARACTER VARYING(120) | 120 |
| 26 | LANDLORD_ADDRESS_LINE8_TXT | CHARACTER VARYING(120) | 120 |
| 27 | LANDLORD_PHONE_NUMBER | CHARACTER VARYING(45) | 45 |
| 28 | LANDLOARD_EMAIL_ID | CHARACTER VARYING(120) | 120 |
| 29 | LANDLORD_CITY_ID | CHARACTER VARYING(50) | 50 |
| 30 | LANDLORD_STATE_ID | CHARACTER VARYING(30) | 30 |
| 31 | LANDLORD_COUNTRY_ID | CHARACTER VARYING(30) | 30 |
| 32 | LANDLORD_ZIP_CODE | CHARACTER VARYING(30) | 30 |
| 33 | LIVING_SINCE | TIMESTAMP | 8 |
| 34 | CONTACT_PERSON_NAME | CHARACTER VARYING(480) | 480 |
| 35 | CONTACT_PERSON_DESIG | CHARACTER VARYING(120) | 120 |
| 36 | CONTACT_PERSON_EMAIL | CHARACTER VARYING(360) | 360 |
| 37 | CONTACT_PERSON_MOBILENO | CHARACTER VARYING(45) | 45 |
| 38 | CONTACT_PERSON_LANDLINENO | CHARACTER VARYING(50) | 50 |
| 39 | CREATED_BY | CHARACTER VARYING(254) | 254 |
| 40 | CREATION_DATE | TIMESTAMP | 8 |
| 41 | LAST_UPDATED_BY | CHARACTER VARYING(254) | 254 |
| 42 | LAST_UPDATE_DATE | TIMESTAMP | 8 |
| 43 | OBJECT_VERSION_NUMBER | INTEGER | 4 |
| 44 | OBJECT_STATUS_FLAG | CHARACTER(1) | 1 |
| 45 | STOP_MAIL | CHARACTER(1) | 1 |
| 46 | STOP_MAIL_REASON | CHARACTER VARYING(20) | 20 |
| 47 | NICK_NAME | CHARACTER VARYING(120) | 120 |
| 48 | SEASONAL_START_DATE | TIMESTAMP | 8 |
| 49 | SEASONAL_END_DATE | TIMESTAMP | 8 |
| 50 | HOLD_MAIL | CHARACTER(1) | 1 |
| 51 | HOLD_START_DATE | TIMESTAMP | 8 |
| 52 | HOLD_END_DATE | TIMESTAMP | 8 |
| 53 | DETERMINANT_VALUE | CHARACTER VARYING(60) | 60 |
| 54 | ADDRESS_LINE9_TXT | CHARACTER VARYING(120) | 120 |
| 55 | ADDRESS_LINE10_TXT | CHARACTER VARYING(120) | 120 |
| 56 | ADDRESS_LINE11_TXT | CHARACTER VARYING(120) | 120 |
| 57 | ADDRESS_LINE12_TXT | CHARACTER VARYING(120) | 120 |
| 58 | LANDLORD_ADDRESS_LINE9_TXT | CHARACTER VARYING(120) | 120 |
| 59 | LANDLORD_ADDRESS_LINE10_TXT | CHARACTER VARYING(120) | 120 |
| 60 | LANDLORD_ADDRESS_LINE11_TXT | CHARACTER VARYING(120) | 120 |
| 61 | LANDLORD_ADDRESS_LINE12_TXT | CHARACTER VARYING(120) | 120 |
| 62 | ADDRESS_STATUS | CHARACTER VARYING(30) | 30 |
| 63 | END_DATE | TIMESTAMP | 8 |
| 64 | DOMAIN_OBJECT_EXTN | CHARACTER VARYING(100) | 100 |
| 65 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 66 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 67 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 68 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |