DW_INV_ORGANIZATION_D

This table stores the inventroy organization information

Details

Module:

Key Columns

INV_ORGANIZATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INV_ORGANIZATION_ID NUMBER 38 0 True Inventroy organization Id, Translation in DW_INTERNAL_ORG_D_TL table.    
SOURCE_RECORD_ID NUMBER 38 0   Uniquely identifies a inventroy organization.    
INV_ORGANIZATION_CODE VARCHAR2 32     Organization code.    
INV_LEGAL_ENTITY_ID NUMBER 38 0   Inventory organization legal entity identifier    
INV_BUSINESS_UNIT_ID NUMBER 38 0   Inventory organization business unit identifier    
INV_SUPPLIER_ID NUMBER 38 0   Inventory organization supplier identifier    
INV_SUPPLIER_SITE_ID NUMBER 38 0   Inventory organization supplier site identifier    
INV_MASTER_ORGANIZATION_ID NUMBER 38 0   Inventory organization master organization identifier    
LOCATION_ID NUMBER 38 0   Inventory organization location identifier.    
PHONE_NUMBER VARCHAR2 256     Inventory organization location phone number.    
FAX_NUMBER VARCHAR2 256     Inventory organization location fax number.    
EMAIL_ADDRESS VARCHAR2 256     Inventory organization location email.    
ADDRESS_LINE_1 VARCHAR2 256     Inventory organization location address line 1.    
ADDRESS_LINE_2 VARCHAR2 256     Inventory organization location address line 2.    
CITY_CODE VARCHAR2 128     Inventory organization location city or town.    
POSTAL_CODE VARCHAR2 32     Inventory organization location postal code.    
COUNTY_CODE VARCHAR2 128     Inventory organization location county.    
STATE_PROV_CODE VARCHAR2 128     Inventory organization location state or province.    
COUNTRY_CODE VARCHAR2 64     Inventory organization location country.    
STATUS_CODE VARCHAR2 32     Indicates if an organization is active or inactive. DW_ACTIVE_INACTIVE_LKP_TL ACTIVE_INACTIVE_LKP_CODE
INV_INVENTORY_FLAG VARCHAR2 16     Indicates the usge of Organization. DW_INV_ORG_USAGE_LKP_TL INV_ORG_USAGE_CODE
INV_PROFIT_CENTER_BUSINESS_UNIT_ID NUMBER 38 0   Business unit that serves as the profit center.This may or may not be the same as the Management Business Unit.    
PRIMARY_LEDGER_ID NUMBER 38 0   Business unit primary ledger identifier.