partner_type |
partner |
partner_type |
Yes |
Specifies the
type of the partner. |
partner_id |
partner |
partner_id |
Yes |
Unique
identifying number for a partner within the system. |
partner_desc |
partner |
partner_desc |
Yes |
Contain the
partner's description or name. |
currency_code |
partner |
currency_code |
Yes |
Contains a code
identifying the currency the partner uses for business
transactions. |
lang |
partner |
lang |
No |
The partner's
preferred language. This field is provided for custom purchase orders in a
specified language |
status |
partner |
status |
Yes |
Determines if
the partner is currently active. Valid values are 'A' = Active or 'I' =
Inactive. |
contact_name |
partner |
contact_name |
Yes |
Contains the
name of the partner's representative contract. |
contact_phone |
partner |
contact_phone |
Yes |
Contains the
phone number of the partner's representative contact. |
contact_fax |
partner |
contact_fax |
No |
Contains the fax
number of the partner's representative contact. |
contact_telex |
partner |
contact_telex |
No |
Contains the
telex number of the partner's representative contact. |
contact_email |
partner |
contact_email |
No |
Contains the
e-mail address of the partner's representative contact. |
mfg_id |
partner |
mfg_id |
No |
Contains the
manufacturer's tax identification number. This field is NULL when the
Partner Type is Bank ('BK'). |
principal_country_id |
partner |
principal_country_id |
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 |
partner |
line_of_credit |
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 |
partner |
outstanding_credit |
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 |
partner |
open_credit |
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 |
partner |
ytd_credit |
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 |
partner |
ytd_drawdowns |
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 |
partner |
tax_id |
No |
Contains the
unique tax identification number of the partner. This will be used for
reporting during the Customs Entry process. |
terms |
partner |
terms |
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 |
partner |
service_perf_req_ind |
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 |
partner |
invc_pay_loc |
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 |
partner |
invc_receive_loc |
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 |
partner |
import_country_id |
No |
Import country
of the Import Authority. This field is not populated for other partner
types. |
primary_ia_ind |
partner |
primary_ia_ind |
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 |
* |
* |
* |
* |