XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for FulfilOrdCustDesc 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_no |
varchar214 |
0 |
1 |
Indicates the number that uniquely identifies the customer in OMS. |
FUL_ORD |
CUSTOMER_ID |
VARCHAR2 |
14 |
No |
Customer identifier for this fulfillment order. |
deliver_first_name |
varchar2120 |
0 |
1 |
Contains the first name for the delivery address on the order. |
ADDRESS |
FIRST_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's first name |
deliver_phonetic_first |
varchar2120 |
0 |
1 |
Contains the phonetic first name for the delivery address on the order. |
ADDRESS |
PHONETIC_FIRST_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's phonetic first name |
deliver_last_name |
varchar2120 |
0 |
1 |
Contains the last name for the delivery address on the order. |
ADDRESS |
LAST_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's last name |
deliver_phonetic_last |
varchar2120 |
0 |
1 |
Contains the phonetic last name for the delivery address on the order. |
ADDRESS |
PHONETIC_LAST_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's phonetic last name |
deliver_preferred_name |
varchar2120 |
0 |
1 |
Contains the preferred name for the delivery address on the order. |
ADDRESS |
CONTACT_NAME |
VARCHAR2 |
120 |
No |
supplier name for address type |
deliver_company_name |
varchar2120 |
0 |
1 |
Contains the company name for the delivery address on the order. |
ADDRESS |
COMPANY_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's company name |
deliver_add1 |
varchar2240 |
0 |
1 |
First line of the delivery address for the customer. |
ADDRESS |
ADDRESS_LINE_1 |
VARCHAR2 |
240 |
No |
first address |
deliver_add2 |
varchar2240 |
0 |
1 |
Second line of the delivery address for the customer. |
ADDRESS |
ADDRESS_LINE_2 |
VARCHAR2 |
240 |
No |
second address |
deliver_add3 |
varchar2240 |
0 |
1 |
Third line of the delivery address for the customer. |
ADDRESS |
ADDRESS_LINE_3 |
VARCHAR2 |
240 |
No |
third address |
deliver_county |
varchar2250 |
0 |
1 |
County portion of the delivery address. |
ADDRESS |
COUNTY |
VARCHAR2 |
250 |
No |
Holds the county of the contact |
deliver_city |
varchar2120 |
0 |
1 |
City portion of the delivery address. |
ADDRESS |
CITY |
VARCHAR2 |
120 |
No |
supplier city id for address type |
deliver_state |
varchar23 |
0 |
1 |
State portion of the delivery address. |
ADDRESS |
STATE |
VARCHAR2 |
3 |
No |
supplier state for address type |
deliver_country_id |
varchar23 |
0 |
1 |
Country portion of the delivery address. |
ADDRESS |
COUNTRY_ID |
VARCHAR2 |
3 |
No |
supplier country id depending on address type |
deliver_post |
varchar230 |
0 |
1 |
Postal code portion of the delivery address. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
deliver_jurisdiction |
varchar210 |
0 |
1 |
Identifies the jurisdiction code for the delivery country-state relationship. |
|
|
|
|
Yes |
not used in SIM |
deliver_phone |
varchar220 |
0 |
1 |
Contains the delivery phone number. |
ADDRESS |
CONTACT_PHONE |
VARCHAR2 |
20 |
No |
supplier phone for address type |
deliver_email |
varchar2120 |
0 |
1 |
Contains the delivery email. |
NA |
NA |
NA |
NA |
NA |
NA |
bill_first_name |
varchar2120 |
0 |
1 |
Contains the first name for the billing address on the order. |
ADDRESS |
FIRST_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's first name |
bill_phonetic_first |
varchar2120 |
0 |
1 |
Contains the phonetic first name for the billing address on the order. |
ADDRESS |
PHONETIC_FIRST_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's phonetic first name |
bill_last_name |
varchar2120 |
0 |
1 |
Contains the last name for the billing address on the order. |
ADDRESS |
LAST_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's last name |
bill_phonetic_last |
varchar2120 |
0 |
1 |
Contains the phonetic last name for the billing address on the order. |
ADDRESS |
PHONETIC_LAST_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's phonetic first name |
bill_preferred_name |
varchar2120 |
0 |
1 |
Contains the preferred name for the billing address on the order. |
ADDRESS |
CONTACT_NAME |
VARCHAR2 |
120 |
No |
supplier name for address type |
bill_company_name |
varchar2120 |
0 |
1 |
Contains the company name for the billing address on the order. |
ADDRESS |
COMPANY_NAME |
VARCHAR2 |
120 |
No |
Holds the contact's company name |
bill_add1 |
varchar2240 |
0 |
1 |
First line of the billing address for the customer. |
ADDRESS |
ADDRESS_LINE_1 |
VARCHAR2 |
240 |
No |
first address |
bill_add2 |
varchar2240 |
0 |
1 |
Second line of the billing address for the customer. |
ADDRESS |
ADDRESS_LINE_2 |
VARCHAR2 |
240 |
No |
second address |
bill_add3 |
varchar2240 |
0 |
1 |
Third line of the billing address for the customer. |
ADDRESS |
ADDRESS_LINE_3 |
VARCHAR2 |
240 |
No |
third address |
bill_county |
varchar2250 |
0 |
1 |
County portion of the billing address. |
ADDRESS |
COUNTY |
VARCHAR2 |
250 |
No |
Holds the county of the contact |
bill_city |
varchar2120 |
0 |
1 |
City portion of the billing address. |
ADDRESS |
CITY |
VARCHAR2 |
120 |
No |
supplier city id for address type |
bill_state |
varchar23 |
0 |
1 |
State portion of the billing address. |
ADDRESS |
STATE |
VARCHAR2 |
3 |
No |
supplier state for address type |
bill_country_id |
varchar23 |
0 |
1 |
Country portion of the billing address. |
ADDRESS |
COUNTRY_ID |
VARCHAR2 |
3 |
No |
supplier country id depending on address typ |
bill_post |
varchar230 |
0 |
1 |
Postal code portion of the billing address. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
bill_jurisdiction |
varchar210 |
0 |
1 |
Identifies the jurisdiction code for the billing country-state relationship. |
|
|
|
|
Yes |
not used in SIM |
bill_phone |
varchar220 |
0 |
1 |
Contains the billing phone number. |
ADDRESS |
CONTACT_PHONE |
VARCHAR2 |
20 |
No |
supplier phone for address type |
bill_email |
varchar2120 |
0 |
1 |
Contains the billing email. |
NA |
NA |
NA |
NA |
NA |
NA |
LocOfFulfilOrdCustDesc:LocOfFulfilOrdCustDesc
|
*
|
0
|
1
|
References a collection of localization extension.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|