Client - Client Address Model Data Map Table
Element | Optional/ Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
---|---|---|---|---|---|---|---|---|---|---|
addressType | Optional | string | 4036 | in_address_type | S | RULESDBO | CLIENT_ADDRESS | ADDRESS_TYPE | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/addressType |
caStartDate | Optional | date | 1320 | in_start_date | S | RULESDBO | CLIENT_ADDRESS | START_DATE | DATE | EagleML/referenceTransaction/client/clientAddress/caStartDate |
caEndDate | Optional | date | 1321 | in_end_date | S | RULESDBO | CLIENT_ADDRESS | END_DATE | DATE | EagleML/referenceTransaction/client/clientAddress/caEndDate |
caCompanyName | Optional | string | 4037 | in_company_name | S | RULESDBO | CLIENT_ADDRESS | COMPANY_NAME | VARCHAR2(100) | EagleML/referenceTransaction/client/clientAddress/caCompanyName |
caJobTitle | Optional | string | 4038 | in_job_title | S | RULESDBO | CLIENT_ADDRESS | JOB_TITLE | VARCHAR2(50) | EagleML/referenceTransaction/client/clientAddress/caJobTitle |
addressLine1 | Optional | string | 4039 | in_address_line1 | S | RULESDBO | CLIENT_ADDRESS | ADDRESS_LINE1 | VARCHAR2(255) | EagleML/referenceTransaction/client/clientAddress/addressLine1 |
addressLine2 | Optional | string | 4040 | in_address_line2 | S | RULESDBO | CLIENT_ADDRESS | ADDRESS_LINE2 | VARCHAR2(255) | EagleML/referenceTransaction/client/clientAddress/addressLine2 |
addressLine3 | Optional | string | 4041 | in_address_line3 | S | RULESDBO | CLIENT_ADDRESS | ADDRESS_LINE3 | VARCHAR2(255) | EagleML/referenceTransaction/client/clientAddress/addressLine3 |
addressLine4 | Optional | string | 4042 | in_address_line4 | S | RULESDBO | CLIENT_ADDRESS | ADDRESS_LINE4 | VARCHAR2(255) | EagleML/referenceTransaction/client/clientAddress/addressLine4 |
city | Optional | string | 4043 | in_city | S | RULESDBO | CLIENT_ADDRESS | CITY | VARCHAR2(50) | EagleML/referenceTransaction/client/clientAddress/city |
state | Optional | string | 4044 | in_state | S | RULESDBO | CLIENT_ADDRESS | STATE | VARCHAR2(50) | EagleML/referenceTransaction/client/clientAddress/state |
mailCode | Optional | string | 4045 | in_mail_code | S | RULESDBO | CLIENT_ADDRESS | MAIL_CODE | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/mailCode |
country | Optional | string | 4046 | in_country | S | RULESDBO | CLIENT_ADDRESS | COUNTRY | VARCHAR2(4) | EagleML/referenceTransaction/client/clientAddress/country |
caUserChar1 | Optional | string | 5106 | in_user_char1 | S | RULESDBO | CLIENT_ADDRESS | USER_CHAR1 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/caUserChar1 |
caUserChar2 | Optional | string | 5107 | in_user_char2 | S | RULESDBO | CLIENT_ADDRESS | USER_CHAR2 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/caUserChar2 |
caUserChar3 | Optional | string | 5108 | in_user_char3 | S | RULESDBO | CLIENT_ADDRESS | USER_CHAR3 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/caUserChar3 |
caUserChar4 | Optional | string | 5109 | in_user_char4 | S | RULESDBO | CLIENT_ADDRESS | USER_CHAR4 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/caUserChar4 |
caUserChar5 | Optional | string | 5110 | in_user_char5 | S | RULESDBO | CLIENT_ADDRESS | USER_CHAR5 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/caUserChar5 |
caUserChar6 | Optional | string | 5111 | in_user_char6 | S | RULESDBO | CLIENT_ADDRESS | USER_CHAR6 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/caUserChar6 |
caUserChar7 | Optional | string | 5112 | in_user_char7 | S | RULESDBO | CLIENT_ADDRESS | USER_CHAR7 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/caUserChar7 |
caUserChar8 | Optional | string | 5113 | in_user_char8 | S | RULESDBO | CLIENT_ADDRESS | USER_CHAR8 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/caUserChar8 |
caUserChar9 | Optional | string | 5114 | in_user_char9 | S | RULESDBO | CLIENT_ADDRESS | USER_CHAR9 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/caUserChar9 |
caUserChar10 | Optional | string | 5115 | in_user_char10 | S | RULESDBO | CLIENT_ADDRESS | USER_CHAR10 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/caUserChar10 |
caUserChar11 | Optional | string | 5116 | in_user_char11 | S | RULESDBO | CLIENT_ADDRESS | USER_CHAR11 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/caUserChar11 |
caUserChar12 | Optional | string | 5117 | in_user_char12 | S | RULESDBO | CLIENT_ADDRESS | USER_CHAR12 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/caUserChar12 |
caUserChar13 | Optional | string | 5118 | in_user_char13 | S | RULESDBO | CLIENT_ADDRESS | USER_CHAR13 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/caUserChar13 |
caUserChar14 | Optional | string | 5119 | in_user_char14 | S | RULESDBO | CLIENT_ADDRESS | USER_CHAR14 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/caUserChar14 |
caUserChar15 | Optional | string | 5120 | in_user_char15 | S | RULESDBO | CLIENT_ADDRESS | USER_CHAR15 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientAddress/caUserChar15 |
caStatusFlag | Optional | string | 4374 | in_status_flag | S | RULESDBO | CLIENT_ADDRESS | STATUS_FLAG | CHAR(1) | EagleML/referenceTransaction/client/clientAddress/caStatusFlag |
region | Optional | string | 4047 | in_region | S | RULESDBO | CLIENT_ADDRESS | REGION | VARCHAR2(50) | EagleML/referenceTransaction/client/clientAddress/region |
website | Optional | string | 4048 | in_website | S | RULESDBO | CLIENT_ADDRESS | WEBSITE | VARCHAR2(200) | EagleML/referenceTransaction/client/clientAddress/website |
caInstance | Optional | integer | 3251 | in_instance | S | RULESDBO | CLIENT_ADDRESS | INSTANCE | NUMBER | EagleML/referenceTransaction/client/clientAddress/caInstance |