Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For PartnerDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
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 within 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 if the partner is currently active. Valid values are 'A' = Active or '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 contract. |
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 when the Partner Type is Bank ('BK'). |
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 the Partner Type is Bank ('BK'). |
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 the Partner Type is Bank ('BK'). |
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 Bank ('BK'). |
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 the Partner Type is Bank ('BK'). |
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 the Partner Type is Bank ('BK'). |
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 Bank ('BK'). |
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 unique tax identification number of the partner. This will be 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, they will default on any invoice 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 (e.g. 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 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. |
AddrDesc:AddrDesc
|
*
|
0
|
unbounded
|
It's a referenced element.
For detailed description, please refer referenced
element doc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
ExtOfPartnerDesc:ExtOfPartnerDesc
|
*
|
0
|
1
|
Provide an extension hook to
customize PartnerDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|