XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrFordCust in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
customer_id |
varchar214 |
1 |
1 |
Customer identifier |
FUL_ORD |
CUSTOMER_ID |
VARCHAR2 |
14 |
No |
Customer identifier for this fulfillment order. |
delivery_first_name |
varchar2120 |
0 |
1 |
First name of delivery contact |
ADDRESS |
FIRST_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's first name |
delivery_phonetic_first_name |
varchar2120 |
0 |
1 |
Phonetic first name of delivery contact |
ADDRESS |
PHONETIC_FIRST_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's phonetic first name |
delivery_last_name |
varchar2120 |
0 |
1 |
Last name of delivery contact |
ADDRESS |
LAST_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's last name |
delivery_phonetic_last_name |
varchar2120 |
0 |
1 |
Phonetic last name of delivery contact |
ADDRESS |
PHONETIC_LAST_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's phonetic last name |
delivery_preferred_name |
varchar2120 |
0 |
1 |
Preferred name of delivery contact |
ADDRESS |
CONTACT_NAME |
VARCHAR2 |
120 |
No |
supplier name for address type |
delivery_company_name |
varchar2120 |
0 |
1 |
Company name of delivery contact |
ADDRESS |
COMPANY_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's company name |
delivery_address1 |
varchar2240 |
0 |
1 |
First address line of delivery contact |
ADDRESS |
ADDRESS_LINE_1 |
VARCHAR2 |
240 |
No |
FIRST ADDRESS |
delivery_address2 |
varchar2240 |
0 |
1 |
Second address line of delivery contact |
ADDRESS |
ADDRESS_LINE_2 |
VARCHAR2 |
240 |
No |
SECOND ADDRESS |
delivery_address3 |
varchar2240 |
0 |
1 |
Third address line of delivery contact |
ADDRESS |
ADDRESS_LINE_3 |
VARCHAR2 |
240 |
No |
THIRD ADDRESS |
delivery_county |
varchar2120 |
0 |
1 |
County of delivery contact |
ADDRESS |
COUNTY |
VARCHAR2 |
250 |
No |
Holds the county of the contact |
delivery_city |
varchar2120 |
0 |
1 |
City of delivery contact |
ADDRESS |
CITY |
VARCHAR2 |
120 |
No |
supplier city id for address type |
delivery_state |
varchar23 |
0 |
1 |
State of delivery contact |
ADDRESS |
STATE |
VARCHAR2 |
3 |
No |
supplier state for address type |
delivery_postal_code |
varchar230 |
0 |
1 |
Postal code of delivery contact |
ADDRESS |
POSTAL_CODE |
VARCHAR2 |
30 |
No |
supplier post info depending on address type |
delivery_country |
varchar23 |
0 |
1 |
Country of delivery contact |
ADDRESS |
COUNTRY_ID |
VARCHAR2 |
3 |
No |
supplier country id depending on address type |
delivery_phone |
varchar220 |
0 |
1 |
Phone number of delivery contact |
ADDRESS |
CONTACT_PHONE |
VARCHAR2 |
20 |
No |
supplier phone for address type |
billing_first_name |
varchar2120 |
0 |
1 |
First name of billing contact |
ADDRESS |
FIRST_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's first name |
billing_phonetic_first_name |
varchar2120 |
0 |
1 |
Phonetic first name of billing contact |
ADDRESS |
PHONETIC_FIRST_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's phonetic first name |
billing_last_name |
varchar2120 |
0 |
1 |
Last name of billing contact |
ADDRESS |
LAST_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's last name |
billing_phonetic_last_name |
varchar2120 |
0 |
1 |
Phonetic last name of billing contact |
ADDRESS |
PHONETIC_LAST_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's phonetic last name |
billing_preferred_name |
varchar2120 |
0 |
1 |
Preferred name of billing contact |
ADDRESS |
CONTACT_NAME |
VARCHAR2 |
120 |
No |
supplier name for address type |
billing_company_name |
varchar2120 |
0 |
1 |
Company name of billing contact |
ADDRESS |
COMPANY_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's company name |
billing_address1 |
varchar2240 |
0 |
1 |
First address line of billing contact |
ADDRESS |
ADDRESS_LINE_1 |
varchar2 |
240 |
No |
first address |
billing_address2 |
varchar2240 |
0 |
1 |
Second address line of billing contact |
ADDRESS |
ADDRESS_LINE_2 |
varchar2 |
240 |
No |
second address |
billing_address3 |
varchar2240 |
0 |
1 |
Third address line of billing contact |
ADDRESS |
ADDRESS_LINE_3 |
VARCHAR2 |
240 |
No |
third address |
billing_county |
varchar2120 |
0 |
1 |
County of billing contact |
ADDRESS |
COUNTY |
VARCHAR2 |
250 |
No |
Holds the county of the contact |
billing_city |
varchar2120 |
0 |
1 |
City of billing contact |
ADDRESS |
CITY |
VARCHAR2 |
120 |
No |
supplier city id for address type |
billing_state |
varchar23 |
0 |
1 |
State of billing contact |
ADDRESS |
STATE |
VARCHAR2 |
3 |
No |
supplier state for address type |
billing_postal_code |
varchar230 |
0 |
1 |
Postal code of billing contact |
ADDRESS |
POSTAL_CODE |
VARCHAR2 |
30 |
No |
supplier post info depending on address type |
billing_country |
varchar23 |
0 |
1 |
Country of billing contact |
ADDRESS |
COUNTRY_ID |
VARCHAR2 |
3 |
No |
supplier country id depending on address type |
billing_phone |
varchar220 |
0 |
1 |
Phone number of billing contact |
ADDRESS |
CONTACT_PHONE |
VARCHAR2 |
20 |
No |
supplier phone for address type |