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 This column is for Oracle Internal use only. 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.