XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for PartnerDesc 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 |
partner_type |
varchar26 |
1 |
1 |
Specifies the type of the
partner. |
partner |
partner_type |
null |
null |
Yes |
Specifies the type of the partner. |
partner_id |
varchar210 |
1 |
1 |
Unique identifying number for
a partner within the system. |
partner |
partner_id |
null |
null |
Yes |
Unique identifying number for a partner in the system. |
partner_desc |
varchar2240 |
1 |
1 |
Contain the partner's
description or name. |
partner |
partner_desc |
null |
null |
Yes |
Contain the partner's description or name. |
currency_code |
varchar23 |
1 |
1 |
Contains a code identifying
the currency the partner uses for business
transactions. |
partner |
currency_code |
null |
null |
Yes |
Contains a code identifying the currency the partner uses for business transactions. |
lang |
number6 |
0 |
1 |
The partner's preferred
language. This field is provided for custom
purchase orders in a specified language |
partner |
lang |
null |
null |
No |
The partner's preferred language. This field is provided for custom purchase orders in a specified language. |
status |
varchar21 |
1 |
1 |
Determines if the partner is
currently active. Valid values are 'A' = Active or
'I' = Inactive. |
partner |
status |
null |
null |
Yes |
Determines whether the partner is active. Valid values are A (active) and I (inactive). |
contact_name |
varchar2120 |
0 |
1 |
Contains the name of the
partner's representative contract. |
partner |
contact_name |
varchar2 |
120 |
Yes |
Contains the name of the partner's representative contact. |
contact_phone |
varchar220 |
0 |
1 |
Contains the phone number of
the partner's representative contact. |
partner |
contact_phone |
varchar2 |
20 |
Yes |
Contains the phone number of the partner's representative contact. |
contact_fax |
varchar220 |
0 |
1 |
Contains the fax number of
the partner's representative contact. |
partner |
contact_fax |
varchar2 |
20 |
No |
Contains the fax number of the partner's representative contact. |
contact_telex |
varchar220 |
0 |
1 |
Contains the telex number of
the partner's representative contact. |
partner |
contact_telex |
varchar2 |
20 |
No |
Contains the telex number of the partner's representative contact. |
contact_email |
varchar2100 |
0 |
1 |
Contains the e-mail address
of the partner's representative contact. |
partner |
contact_email |
varchar2 |
100 |
No |
Contains the e-mail address of the partner's representative contact. |
mfg_id |
varchar218 |
0 |
1 |
Contains the manufacturer's
tax identification number. This field is NULL when
the Partner Type is Bank ('BK'). |
partner |
mfg_id |
null |
null |
No |
Contains the manufacturer's tax identification number. This field is NULL whenPartner Type is BK (bank). |
principal_country_id |
varchar23 |
0 |
1 |
Contains the country id to
which the partner is assigned. This field is NULL
when the Partner Type is Bank ('BK'). |
partner |
principal_country_id |
null |
null |
No |
Contains the country ID to which the partner is assigned. This field is NULL when Partner Type is BK (bank). |
line_of_credit |
number20_4 |
0 |
1 |
Contains the line of credit
the company has at the Bank in the Partner's
currency. This field is not NULL when the Partner
Type is Bank ('BK'). |
partner |
line_of_credit |
null |
null |
No |
Contains the line of credit the company has at the bank in the partner's currency. This field is not NULL when Partner Type is BK (bank). |
outstanding_credit |
number20_4 |
0 |
1 |
Contains the total amount of
credit that the company has used or has charged
against in the Partner's currency. This field is
not NULL when the Partner Type is Bank ('BK'). |
partner |
outstanding_credit |
null |
null |
No |
Contains the total amount of credit that the company has used or has charged against in the partner's currency. This field is not NULL when the Partner Type is BK (bank). |
open_credit |
number20_4 |
0 |
1 |
Contains the total amount
that the company can still charge against in the
Partner's currency. This field is not NULL when the
Partner Type is Bank ('BK'). |
partner |
open_credit |
null |
null |
No |
Contains the total amount that the company can still charge against in the partner's currency. This field is not NULL when Partner Type is BK (bank). |
ytd_credit |
number20_4 |
0 |
1 |
Contains the total amount of
credit the company has used this year to date in
the Partner's currency. This field is not NULL when
the Partner Type is Bank ('BK'). |
partner |
ytd_credit |
null |
null |
No |
Contains the total amount of credit the company has used this year to date in the partner's currency. This field is not NULL when Partner Type is BK (bank). |
ytd_drawdowns |
number20_4 |
0 |
1 |
Contains the year to date
payments the bank has made on behalf of the company
in the Partner's currency. This field is not NULL
when the Partner Type is Bank ('BK'). |
partner |
ytd_drawdowns |
null |
null |
No |
Contains the year to date payments the bank has made on behalf of the company in the partner's currency. This field is not NULL when the Partner Type is BK (bank). |
tax_id |
varchar218 |
0 |
1 |
Contains the unique tax
identification number of the partner. This will be
used for reporting during the Customs Entry
process. |
partner |
tax_id |
null |
null |
No |
Contains the partner's unique tax identification number. This field is used for reporting during the Customs Entry process. |
terms |
varchar215 |
1 |
1 |
Payment terms for the
partner. These terms specify when payment is due
and if any discounts exist for early payment. If
populated, they will default on any invoice entered
for this partner. |
partner |
terms |
null |
null |
Yes |
Payment terms for the partner. These terms specify when payment is due and if any discounts exist for early payment. If populated, this value defaults on invoices entered for this partner. |
service_perf_req_ind |
varchar21 |
1 |
1 |
Indicates if the partner's
services (e.g. shelf stocking) must be confirmed as
performed before paying an invoice from that
partner. Valid values are 'Y' and 'N'. |
partner |
service_perf_req_ind |
null |
null |
Yes |
Indicates if the partner's services (such as shelf stocking) must be confirmed as "performed" before paying an invoice from that partner. Valid values are Y and N. |
invc_pay_loc |
varchar26 |
0 |
1 |
Indicates where invoices from
this supplier are paid - at the store or centrally
through corporate accounting. Valid values are 'S'
(paid at the store) and 'C' (paid centrally). |
partner |
invc_pay_loc |
varchar2 |
6 |
No |
Indicates where invoices from this supplier are paid, at the store or centrally through corporate accounting. Valid values are S (paid at the store) and C (paid centrally). |
invc_receive_loc |
varchar26 |
0 |
1 |
Indicates where invoices from
this supplier are received - at the store or
centrally through corporate accounting. Valid
values are 'S' (received at the store) and 'C'
(received centrally). |
partner |
invc_receive_loc |
varchar2 |
6 |
No |
Indicates where invoices from this supplier are received, at the store or centrally through corporate accounting. Valid values are S (received at the store) and C (received centrally). |
import_country_id |
varchar23 |
0 |
1 |
Import country of the Import
Authority. This field is not populated for other
partner types. |
partner |
import_country_id |
null |
null |
No |
Import country of the Import Authority. This field is not populated for other partner types. |
primary_ia_ind |
varchar21 |
1 |
1 |
Indicates if an Import
Authority is the primary Import Authority for an
import country. This field will always be 'N' for
other partner types. There must be one and only one
primary Import Authority for each country
associated with an Import Authority on the partner
table. |
partner |
primary_ia_ind |
null |
null |
Yes |
Indicates if the import authority is the primary import authority for an import country. This field always is N for other partner types. There must be one and only one primary import authority for each country associated with an import authority in the partner table. |
PartnerOUDesc:PartnerOUDesc
|
*
|
0
|
unbounded
|
It's a referenced element. For detailed description, please refer referenced element doc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
AddrDesc:AddrDesc
|
*
|
0
|
unbounded
|
It's a referenced element.
For detailed description, please refer referenced
element doc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|