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