XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for Store_Addr in BDI-RMS application. |
BDI-RMS's Table Name |
BDI-RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
BDI-RMS's Column Length |
Is Column Required in BDI-RMS's API? |
BDI-RMS's API Description |
store_id |
number10 |
1 |
1 |
Contains the unique ID of the store. Data will always be present in this field. |
STORE |
KEY_VALUE_1 |
VARCHAR2 |
20 |
Yes |
Contains the unique ID of the store. Data will always be present in this field. |
addr |
number11 |
1 |
1 |
This column contains a unique number used to distinguish between different addresses. |
ADDR |
ADDR_KEY |
NUMBER |
11 |
Yes |
This column contains a unique number used to distinguish between different addresses. |
addr_type |
varchar22 |
1 |
1 |
Contains the code used to identify the address type. Common examples include 01 (Business), 02 (Postal), 03 (Returns), 04 (Order), 05 (Invoice) and 06 (Remittance). Data will always be present in this field. |
ADDR |
ADDR_TYPE |
VARCHAR2 |
2 |
Yes |
Contains the code used to identify the address type. Common examples include 01 (Business), 02 (Postal), 03 (Returns), 04 (Order), 05 (Invoice) and 06 (Remittance). Data will always be present in this field. |
addr_type_desc |
varchar220 |
1 |
1 |
Contains the code used to identify the address type. Common Common examples include Business, Postal, Returns, Order, Invoice and Remittance. Description data is only sent in the primary integration language of the system. |
ADD_TYPE_TL |
TYPE_DESC |
VARCHAR2 |
40 |
Yes |
Contains the code used to identify the address type. Common Common examples include Business, Postal, Returns, Order, Invoice and Remittance. Description data is only sent in the primary integration language of the system. |
primary_addr_ind |
varchar21 |
1 |
1 |
Indicates whether the address is the primary address for the address type. Valid values are Y and N. |
ADDR |
PRIMARY_ADDR_IND |
VARCHAR2 |
1 |
Yes |
Indicates whether the address is the primary address for the address type. Valid values are Y and N. |
add_1 |
varchar2240 |
1 |
1 |
Contains the first line of the address. This information is required. |
ADDR |
ADD_1 |
VARCHAR2 |
240 |
Yes |
Contains the first line of the address. This information is required. |
add_2 |
varchar2240 |
0 |
1 |
This column contains the second line of the address. |
ADDR |
ADD_2 |
VARCHAR2 |
240 |
No |
This column contains the second line of the address. |
add_3 |
varchar2240 |
0 |
1 |
This column contains the third line of the address. |
ADDR |
ADD_3 |
VARCHAR2 |
240 |
Yes |
This column contains the third line of the address. |
city |
varchar2120 |
1 |
1 |
Contains the name of the city that is associated with the address. This information is required. |
ADDR |
CITY |
VARCHAR2 |
120 |
Yes |
Contains the name of the city that is associated with the address. This information is required. |
county |
varchar2250 |
0 |
1 |
This column holds the county name for the location. |
ADDR |
COUNTY |
VARCHAR2 |
250 |
No |
This column holds the county name for the location. |
state |
varchar23 |
0 |
1 |
This column contains the state abbreviation for the address. |
ADDR |
STATE |
VARCHAR2 |
3 |
No |
This column contains the state abbreviation for the address. |
country |
varchar23 |
1 |
1 |
Contains the ISO 3166-1 country code associated with the address. This information is required. |
ADDR |
COUNTRY_ID |
VARCHAR2 |
3 |
Yes |
Contains the ISO 3166-1 country code associated with the address. This information is required. |
post_code |
varchar230 |
0 |
1 |
This column contains the zip code for the address. |
ADDR |
POST |
VARCHAR2 |
30 |
No |
This column contains the zip code for the address. |
jurisdiction_code |
varchar210 |
0 |
1 |
This column contains the name of the contact for the supplier at this address. |
ADDR |
JURISDICTION_CODE |
VARCHAR2 |
10 |
No |
Identifies the jurisdiction code for the country-state relationship. |
contact_name |
varchar2120 |
0 |
1 |
This column contains the name of the contact for the supplier at this address. |
ADDR |
CONTACT_NAME |
VARCHAR2 |
120 |
No |
This column contains the name of the contact for the store at this address. |
contact_phone |
varchar220 |
0 |
1 |
This column contains the phone number of the contact person at this address. |
ADDR |
CONTACT_PHONE |
VARCHAR2 |
20 |
No |
This column contains the phone number of the contact person at this address. |
contact_fax |
varchar220 |
0 |
1 |
This column contains the fax number of the contact person at this address. |
ADDR |
CONTACT_FAX |
VARCHAR2 |
20 |
No |
This column contains the fax number of the contact person at this address. |
contact_email |
varchar2100 |
0 |
1 |
This column contains the email address of the partner or suppliers representative contact. |
ADDR |
CONTACT_EMAIL |
VARCHAR2 |
100 |
No |
This column contains the email address of the partner or suppliers representative contact. |