This table stores the manufacturing organization information
Module:
MFG_ORGANIZATION_ID
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, 2023, Oracle and/or its affiliates.