XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for FulfilOrdCustDesc in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
customer_no |
varchar214 |
0 |
1 |
Indicates the number that uniquely identifies the customer in OMS. |
ordcust |
customer_no |
varchar2 |
14 |
No |
Indicates the number that uniquely identifies the customer in OMS. |
deliver_first_name |
varchar2120 |
0 |
1 |
Contains the first name for the delivery address on the order. |
ordcust |
deliver_first_name |
varchar2 |
120 |
No |
Contains the first name for the delivery address on the order. |
deliver_phonetic_first |
varchar2120 |
0 |
1 |
Contains the phonetic first name for the delivery address on the order. |
ordcust |
deliver_phonetic_first |
varchar2 |
120 |
No |
Contains the phonetic first name for the delivery address on the order. |
deliver_last_name |
varchar2120 |
0 |
1 |
Contains the last name for the delivery address on the order. |
ordcust |
deliver_last_name |
varchar2 |
120 |
No |
Contains the last name for the delivery address on the order. |
deliver_phonetic_last |
varchar2120 |
0 |
1 |
Contains the phonetic last name for the delivery address on the order. |
ordcust |
deliver_phonetic_last |
varchar2 |
120 |
No |
Contains the phonetic last name for the delivery address on the order. |
deliver_preferred_name |
varchar2120 |
0 |
1 |
Contains the preferred name for the delivery address on the order. |
ordcust |
deliver_preferred_name |
varchar2 |
120 |
No |
Contains the preferred name for the delivery address on the order. |
deliver_company_name |
varchar2120 |
0 |
1 |
Contains the company name for the delivery address on the order. |
ordcust |
deliver_company_name |
varchar2 |
120 |
No |
Contains the company name for the delivery address on the order. |
deliver_add1 |
varchar2240 |
0 |
1 |
First line of the delivery address for the customer. |
ordcust |
deliver_add1 |
varchar2 |
240 |
No |
First line of the delivery address for the customer. |
deliver_add2 |
varchar2240 |
0 |
1 |
Second line of the delivery address for the customer. |
ordcust |
deliver_add2 |
varchar2 |
240 |
No |
Second line of the delivery address for the customer. |
deliver_add3 |
varchar2240 |
0 |
1 |
Third line of the delivery address for the customer. |
ordcust |
deliver_add3 |
varchar2 |
240 |
No |
Third line of the delivery address for the customer. |
deliver_county |
varchar2250 |
0 |
1 |
County portion of the delivery address. |
ordcust |
deliver_county |
varchar2 |
250 |
No |
County portion of the delivery address. |
deliver_city |
varchar2120 |
0 |
1 |
City portion of the delivery address. |
ordcust |
deliver_city |
varchar2 |
120 |
No |
City portion of the delivery address. |
deliver_state |
varchar23 |
0 |
1 |
State portion of the delivery address. |
ordcust |
deliver_state |
varchar2 |
3 |
No |
State portion of the delivery address. |
deliver_country_id |
varchar23 |
0 |
1 |
Country portion of the delivery address. |
ordcust |
deliver_country_id |
varchar2 |
3 |
No |
Country portion of the delivery address. |
deliver_post |
varchar230 |
0 |
1 |
Postal code portion of the delivery address. |
ordcust |
deliver_post |
varchar2 |
30 |
No |
Postal code portion of the delivery address. |
deliver_jurisdiction |
varchar210 |
0 |
1 |
Identifies the jurisdiction code for the delivery country-state relationship. |
ordcust |
deliver_jurisdiction |
varchar2 |
10 |
No |
Identifies the jurisdiction code for the delivery country-state relationship. |
deliver_phone |
varchar220 |
0 |
1 |
Contains the delivery phone number. |
ordcust |
deliver_phone |
varchar2 |
20 |
No |
Contains the delivery phone number. |
deliver_email |
varchar2120 |
0 |
1 |
Contains the delivery email. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
bill_first_name |
varchar2120 |
0 |
1 |
Contains the first name for the billing address on the order. |
ordcust |
bill_first_name |
varchar2 |
120 |
No |
Contains the first name for the billing address on the order. |
bill_phonetic_first |
varchar2120 |
0 |
1 |
Contains the phonetic first name for the billing address on the order. |
ordcust |
bill_phonetic_first |
varchar2 |
120 |
No |
Contains the phonetic first name for the billing address on the order. |
bill_last_name |
varchar2120 |
0 |
1 |
Contains the last name for the billing address on the order. |
ordcust |
bill_last_name |
varchar2 |
120 |
No |
Contains the last name for the billing address on the order. |
bill_phonetic_last |
varchar2120 |
0 |
1 |
Contains the phonetic last name for the billing address on the order. |
ordcust |
bill_phonetic_last |
varchar2 |
120 |
No |
Contains the phonetic last name for the billing address on the order. |
bill_preferred_name |
varchar2120 |
0 |
1 |
Contains the preferred name for the billing address on the order. |
ordcust |
bill_preferred_name |
varchar2 |
120 |
No |
Contains the preferred name for the billing address on the order. |
bill_company_name |
varchar2120 |
0 |
1 |
Contains the company name for the billing address on the order. |
ordcust |
bill_company_name |
varchar2 |
120 |
No |
Contains the company name for the billing address on the order. |
bill_add1 |
varchar2240 |
0 |
1 |
First line of the billing address for the customer. |
ordcust |
bill_add1 |
varchar2 |
240 |
No |
First line of the billing address for the customer. |
bill_add2 |
varchar2240 |
0 |
1 |
Second line of the billing address for the customer. |
ordcust |
bill_add2 |
varchar2 |
240 |
No |
Second line of the billing address for the customer. |
bill_add3 |
varchar2240 |
0 |
1 |
Third line of the billing address for the customer. |
ordcust |
bill_add3 |
varchar2 |
240 |
No |
Third line of the billing address for the customer. |
bill_county |
varchar2250 |
0 |
1 |
County portion of the billing address. |
ordcust |
bill_county |
varchar2 |
250 |
No |
County portion of the billing address. |
bill_city |
varchar2120 |
0 |
1 |
City portion of the billing address. |
ordcust |
bill_city |
varchar2 |
120 |
No |
City portion of the billing address. |
bill_state |
varchar23 |
0 |
1 |
State portion of the billing address. |
ordcust |
bill_state |
varchar2 |
3 |
No |
State portion of the billing address. |
bill_country_id |
varchar23 |
0 |
1 |
Country portion of the billing address. |
ordcust |
bill_country_id |
varchar2 |
3 |
No |
Country portion of the billing address. |
bill_post |
varchar230 |
0 |
1 |
Postal code portion of the billing address. |
ordcust |
bill_post |
varchar2 |
30 |
No |
Postal code portion of the billing address. |
bill_jurisdiction |
varchar210 |
0 |
1 |
Identifies the jurisdiction code for the billing country-state relationship. |
ordcust |
bill_jurisdiction |
varchar2 |
10 |
No |
Identifies the jurisdiction code for the billing country-state relationship. |
bill_phone |
varchar220 |
0 |
1 |
Contains the billing phone number. |
ordcust |
bill_phone |
varchar2 |
20 |
No |
Contains the billing phone number. |
bill_email |
varchar2120 |
0 |
1 |
Contains the billing email. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
LocOfFulfilOrdCustDesc:LocOfFulfilOrdCustDesc
|
*
|
0
|
1
|
References a collection of localization extension.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|