# DW_NS_vendor_D

This table contains information on vendor entity.

## Details

Module:

## Key Columns

id

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
id | NUMBER | 38 | 0 | True |  |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. This is source record id column. |  |
accountnumber | VARCHAR2 | 256 |  |  | Account Number |  |
altemail | VARCHAR2 | 256 |  |  | Alt. Email |  |
altname | VARCHAR2 | 999 |  |  | Vendor |  |
altphone | VARCHAR2 | 128 |  |  | Alt. Phone |  |
category | NUMBER | 38 | 0 |  | Category | DW_NS_vendorCategory_D | id
comments | VARCHAR2 | 999 |  |  | Comments |  |
companyname | VARCHAR2 | 256 |  |  | Company Name |  |
contact | NUMBER | 38 | 0 |  | Contact | DW_NS_Contact_D | id
creditlimit | NUMBER |  |  |  | Credit Limit |  |
currency | NUMBER | 38 | 0 |  | Currency | DW_NS_currency_D | id
datecreated | TIMESTAMP |  |  |  | Date Created |  |
defaultbankaccount | NUMBER | 38 | 0 |  | Default Bank Account | DW_NS_account_D | id
defaultbillingaddress | NUMBER | 38 | 0 |  | Default Billing Address | DW_NS_EntityAddress_D | nkey
defaultshippingaddress | NUMBER | 38 | 0 |  | Default Shipping Address | DW_NS_EntityAddress_D | nkey
email | VARCHAR2 | 512 |  |  | Email |  |
emailpreference | VARCHAR2 | 16 |  |  | Email Preference | DW_NS_EmailPreferenceType_D | id
emailtransactions | VARCHAR2 | 16 |  |  | Email Transactions |  |
entityid | VARCHAR2 | 256 |  |  | Entity ID |  |
entitytitle | VARCHAR2 | 512 |  |  | Vendor ID |  |
expenseaccount | NUMBER | 38 | 0 |  | Default Expense Account | DW_NS_account_D | id
fax | VARCHAR2 | 128 |  |  | Fax |  |
faxtransactions | VARCHAR2 | 16 |  |  | Fax Transactions |  |
firstname | VARCHAR2 | 64 |  |  | First Name |  |
giveaccess | VARCHAR2 | 16 |  |  | Login Access |  |
homephone | VARCHAR2 | 128 |  |  | Home Phone |  |
incoterm | NUMBER | 38 | 0 |  | Incoterm | DW_NS_IncoTerm_D | id
isinactive | VARCHAR2 | 16 |  |  | Inactive |  |
isjobresourcevend | VARCHAR2 | 16 |  |  | Job Resource |  |
isperson | VARCHAR2 | 16 |  |  | Is Individual |  |
lastmodifieddate | TIMESTAMP |  |  |  | Last Modified |  |
lastname | VARCHAR2 | 64 |  |  | Last Name |  |
legalname | VARCHAR2 | 256 |  |  | Legal Name |  |
middlename | VARCHAR2 | 64 |  |  | Middle Name |  |
mobilephone | VARCHAR2 | 128 |  |  | Mobile Phone |  |
payablesaccount | NUMBER | 38 | 0 |  | [Missing Label:payablesAccount] | DW_NS_account_D | id
phone | VARCHAR2 | 128 |  |  | Phone |  |
purchaseorderamount | NUMBER |  |  |  | Vendor Bill - Purchase Order Amount Tolerance |  |
purchaseorderquantity | NUMBER |  |  |  | Vendor Bill - Purchase Order Quantity Tolerance |  |
purchaseorderquantitydiff | NUMBER |  |  |  | Vendor Bill - Purchase Order Quantity Difference |  |
receiptamount | NUMBER |  |  |  | Vendor Bill - Item Receipt Amount Tolerance |  |
receiptquantity | NUMBER |  |  |  | Vendor Bill - Item Receipt Quantity Tolerance |  |
receiptquantitydiff | NUMBER |  |  |  | Vendor Bill - Item Receipt Quantity Difference |  |
salutation | VARCHAR2 | 32 |  |  | Mr./Ms... |  |
terms | NUMBER | 38 | 0 |  | Terms | DW_NS_term_D | id
title | VARCHAR2 | 256 |  |  | Vendor title |  |
timeapprover | NUMBER | 38 | 0 |  | Time Approver | DW_NS_employee_D | id
url | VARCHAR2 | 256 |  |  | URL |  |
workcalendar | NUMBER | 38 | 0 |  | Work Calendar | DW_NS_workCalendar_D | id
representingsubsidiary | NUMBER | 38 | 0 |  | Represents Subsidiary | DW_NS_subsidiary_D | id
isautogeneratedrepresentingentity | VARCHAR2 | 16 |  |  | Is Autogenerated Representing Entity |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.