DW_NS_vendor_D
This table contains information on vendor entity.
Details
Module:
Key Columns
id
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 | |
| VARCHAR2 | 512 | ||||||
| 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 |