Partner

Specifies the type of partner. Valid values are Bank BK, Agent AG, Freight Forwarder FF, Importer IM, Broker BR, Factory FA, Applicant AP, Consolidator CO, and Consignee CN, Supplier hierarchy level 1 S1, Supplier hierarchy level 2 S2, Supplier hierarchy level 3 S3.

Unique identifying number for a partner within the system. The user determines this number when a new partner is first added to the system.

Contains the partners description or name.

Contains a code identifying the currency the partner uses for business transactions.

This field contains the partners preferred language.

Determines whether the partner is currently active. Valid values include: A for an active partner or I for an inactive partner. The status of a partner will be checked when an order is being created to make certain the partner is active.

Contains the name of the partners representative contract.

Contains the phone number of the partners representative contact.

Contains the fax number of the partners representative contact.

Contains the telex number of the partners representative contact.

Contains the e-mail address of the partners representative contact.

Contains the manufacturers tax identification number. This field is NULL when the Partner Type is Bank (BK).

Contains the country id to which the partner is assigned. This field is required when the Partner Type is Bank (BK) or Import Authority (IA).

Contains the line of credit the company has at the Bank in the Partners currency. This field is not NULL when the Partner Type is Bank (BK).

Contains the total amount of credit that the company has used or has charged against in the Partners currency. This field is not NULL when the Partner Type is Bank (BK).

Contains the total amount that the company can still charge against in the Partners currency. This field is not NULL when the Partner Type is Bank (BK).

Contains the total amount of credit the company has used this year to date in the Partners currency. This field is not NULL when the Partner Type is Bank (BK).

Contains the year to date payments the bank has made on behalf of the company in the Partners currency. This field is not NULL when the Partner Type is Bank (BK).

Contains the unique tax identification number of the partner. This will be used for reporting during the Customs Entry process.

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.

Indicates if the expense vendors services (e.g. snowplowing, window washing) must be confirmed as performed before paying an invoice from that expense vendor. Valid values are Y (all service non- merchandise lines on an invoice from this expense vendor must be confirmed before the invoice can be paid) and N (services do not need to be confirmed or partner is not an expense vendor).

Indicates where invoices from this expense vendor are paid - at the store or centrally through corporate accounting. Valid values are S (paid at the store) and C (paid centrally). This field will only be populated for expense vendors, and should only be S if using ReSA to accept payment at the store.

Indicates where invoices from this expense vendor are received - at the store or centrally through corporate accounting. Valid values are S (received at the store) and C (received centrally). This field should only be populated when using invoice matching.

Import country of the Import Authority. This field is not populated for other partner types.

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.

Contains any comments associated with the Partner.

ID of the transfer entity with which an external finisher (partner_type = E) is associated. Valid values are found on the TSF_ENTITY table. A transfer entity is a group of locations that share legal requirements around product management. If SYSTEM_OPTIONS.INTERCOMPANY_TRANSFER_IND = Y, then each external finisher will be required to have an associated TSF_ENTITY_ID. If SYSTEM_OPTIONS.INTERCOMPANY_TRANSFER_IND = N, then transfer entity functionality is not used and PARTNER.TSF_ENTITY_ID will not be required.

VAT (value added tax) region with which a partner is associated. Valid values will be found on the VAT_REGION table. If SYSTEM_OPTIONS.DEFAULT_TAX_TYPE is SVAT or GTS, then each partner will be required to have an associated VAT_REGION. For other default_tax_type, then VAT functionality is not used and PARTNER.VAT_REGION will not be required.

Org Unit Id Oracle Retail target column ORG_UNIT_ID on PARTNER.

This wil hold the secondary name of the partner.

This will indicate whether the system will update the stock for the external finisher when the 1st leg of the transfer is shipped. Valid values are Yes or No

User who created the record. Oracle Retail target column CREATE_ID on PARTNER.

Date time when record was inserted.

User who last updated the record.

Date time when record was last updated.

This column holds the ID for the partner used in the external financial system.

This column holds the ID for the parent partner used in the external financial system.

This column holds the name of the parent partner used in the external financial system.