# 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. |  |
accountnumber | VARCHAR2 | 256 |  |  |  |  |
altemail | VARCHAR2 | 256 |  |  |  |  |
altname | VARCHAR2 | 999 |  |  |  |  |
altphone | VARCHAR2 | 128 |  |  |  |  |
category | NUMBER | 38 | 0 |  |  | DW_NS_vendorCategory_D | id
comments | VARCHAR2 | 999 |  |  |  |  |
companyname | VARCHAR2 | 256 |  |  |  |  |
contact | NUMBER | 38 | 0 |  |  | DW_NS_Contact_D | id
creditlimit | NUMBER |  |  |  |  |  |
currency | NUMBER | 38 | 0 |  |  | DW_NS_currency_D | id
datecreated | TIMESTAMP |  |  |  |  |  |
defaultbankaccount | NUMBER | 38 | 0 |  |  | DW_NS_account_D | id
defaultbillingaddress | NUMBER | 38 | 0 |  |  | DW_NS_EntityAddress_D | nkey
defaultshippingaddress | NUMBER | 38 | 0 |  |  | DW_NS_EntityAddress_D | nkey
email | VARCHAR2 | 512 |  |  |  |  |
emailpreference | VARCHAR2 | 16 |  |  |  | DW_NS_EmailPreferenceType_D | id
emailtransactions | VARCHAR2 | 16 |  |  |  |  |
entityid | VARCHAR2 | 256 |  |  |  |  |
entitytitle | VARCHAR2 | 512 |  |  |  |  |
expenseaccount | NUMBER | 38 | 0 |  |  | DW_NS_account_D | id
fax | VARCHAR2 | 128 |  |  |  |  |
faxtransactions | VARCHAR2 | 16 |  |  |  |  |
firstname | VARCHAR2 | 64 |  |  |  |  |
giveaccess | VARCHAR2 | 16 |  |  |  |  |
homephone | VARCHAR2 | 128 |  |  |  |  |
incoterm | NUMBER | 38 | 0 |  |  | DW_NS_IncoTerm_D | id
isinactive | VARCHAR2 | 16 |  |  |  |  |
isjobresourcevend | VARCHAR2 | 16 |  |  |  |  |
isperson | VARCHAR2 | 16 |  |  |  |  |
lastmodifieddate | TIMESTAMP |  |  |  |  |  |
lastname | VARCHAR2 | 64 |  |  |  |  |
legalname | VARCHAR2 | 256 |  |  |  |  |
middlename | VARCHAR2 | 64 |  |  |  |  |
mobilephone | VARCHAR2 | 128 |  |  |  |  |
payablesaccount | NUMBER | 38 | 0 |  |  | DW_NS_account_D | id
phone | VARCHAR2 | 128 |  |  |  |  |
purchaseorderamount | NUMBER |  |  |  |  |  |
purchaseorderquantity | NUMBER |  |  |  |  |  |
purchaseorderquantitydiff | NUMBER |  |  |  |  |  |
receiptamount | NUMBER |  |  |  |  |  |
receiptquantity | NUMBER |  |  |  |  |  |
receiptquantitydiff | NUMBER |  |  |  |  |  |
salutation | VARCHAR2 | 32 |  |  |  |  |
terms | NUMBER | 38 | 0 |  |  | DW_NS_term_D | id
title | VARCHAR2 | 256 |  |  |  |  |
timeapprover | NUMBER | 38 | 0 |  |  | DW_NS_employee_D | id
url | VARCHAR2 | 256 |  |  |  |  |
workcalendar | NUMBER | 38 | 0 |  |  | DW_NS_workCalendar_D | id
representingsubsidiary | NUMBER | 38 | 0 |  |  | DW_NS_subsidiary_D | id
isautogeneratedrepresentingentity | VARCHAR2 | 16 |  |  |  |  |

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