This table stores the inventroy organization information
Module:
INV_ORGANIZATION_ID
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 |