DW_MFG_ORGANIZATION_D

This table stores the manufacturing organization information

Details

Module:

Key Columns

MFG_ORGANIZATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
MFG_ORGANIZATION_ID NUMBER 38 0 True Manufacturing organization Id, Translation in DW_INTERNAL_ORG_D_TL table.    
SOURCE_RECORD_ID NUMBER 38 0   Uniquely identifies a manufacturing organization.    
MFG_ORGANIZATION_CODE VARCHAR2 32     Organization code.    
MFG_LEGAL_ENTITY_ID NUMBER 38 0   Manufacturing organization legal entity identifier    
MFG_BUSINESS_UNIT_ID NUMBER 38 0   Manufacturing organization business unit identifier    
PHONE_NUMBER VARCHAR2 256     Manufacturing organization location phone number.    
FAX_NUMBER VARCHAR2 256     Manufacturing organization location fax number.    
EMAIL_ADDRESS VARCHAR2 256     Manufacturing organization location email.    
ADDRESS_LINE_1 VARCHAR2 256     Manufacturing organization location address line 1.    
ADDRESS_LINE_2 VARCHAR2 256     Manufacturing organization location address line 2.    
CITY_CODE VARCHAR2 128     Manufacturing organization location city or town.    
POSTAL_CODE VARCHAR2 32     Manufacturing organization location postal code.    
COUNTY_CODE VARCHAR2 128     Manufacturing organization location county.    
STATE_PROV_CODE VARCHAR2 128     Manufacturing organization location state or province.    
COUNTRY_CODE VARCHAR2 64     Manufacturing organization location country.    
STATUS_CODE VARCHAR2 32     Indicates if an organization is active or inactive. DW_ACTIVE_INACTIVE_LKP_TL ACTIVE_INACTIVE_LKP_CODE
PRIMARY_LEDGER_ID NUMBER 38 0   Business unit primary ledger identifier.    

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