Diccionario de Datos

Logo

Diccionario de datos de los modelos de COÉXITO

🏠 Menú principal ← Volver a vistas materializadas

DWADW.MV_FULLFILLINE_OM_BORRAR

Base de datos origen: ADW COEXITO

Tipo de objeto: MATERIALIZED VIEW

SQL


  CREATE MATERIALIZED VIEW "DWADW"."MV_FULLFILLINE_OM_BORRAR" ("FULFILLLINE_OM_ID", "BILLTOCUSTOMERACCOUNTACCOUNTESTABLISHEDDATE", "BILLTOCUSTOMERACCOUNTLASTUPDATEDATE", "COVERAGEFLINEDETAILSFULFILLLINENUMBER", "COVERAGEFLINEDETAILSSOURCEREVISIONNUMBER", "COVEREDFLINEDETAILSFULFILLLINENUMBER", "COVEREDFLINEDETAILSSOURCEREVISIONNUMBER", "DOCUMENTREFERENCESDOCALTUSERKEY", "DOCUMENTREFERENCESDOCCONTEXTID", "DOCUMENTREFERENCESDOCLINEID", "DOCUMENTREFERENCESDOCLINEUSERKEY", "DOCUMENTREFERENCESDOCREFTYPE", "DOCUMENTREFERENCESDOCSUBLINEID", "DOCUMENTREFERENCESDOCSUBLINEUSERKEY", "DOCUMENTREFERENCESDOCUSERKEY", "FULFILLLINEACTUALCOMPLETIONDATE", "FULFILLLINEACTUALSHIPDATE", "FULFILLLINEASSETTRACKEDFLAG", "FULFILLLINEBILLTOSITEUSEID", "FULFILLLINECANCELREASONCODE", "FULFILLLINECANCELEDFLAG", "FULFILLLINECANCELEDQTY", "FULFILLLINECATEGORYCODE", "FULFILLLINECREATEDBY", "FULFILLLINECREATIONDATE", "FULFILLLINECUSTOMERPONUMBER", "FULFILLLINEESTIMATEFULFILLMENTCOST", "FULFILLLINEFULFILLFLAG", "FULFILLLINEFULFILLLINENUMBER", "FULFILLLINEFULFILLORGID", "FULFILLLINEFULFILLEDQTY", "FULFILLLINEFULFILLMENTDATE", "FULFILLLINEFULFILLMENTSPLITREFID", "FULFILLLINEHEADERID", "FULFILLLINEID", "FULFILLLINEINVENTORYINTERFACEDFLAG", "FULFILLLINEINVENTORYITEMID", "FULFILLLINEINVENTORYTRANSACTIONFLAG", "FULFILLLINEITEMSUBTYPECODE", "FULFILLLINEITEMTYPECODE", "FULFILLLINELASTUPDATEDATE", "FULFILLLINELASTUPDATEDBY", "FULFILLLINELINEID", "FULFILLLINELINETYPECODE", "FULFILLLINEONHOLD", "FULFILLLINEOPENFLAG", "FULFILLLINEORDEREDQTY", "FULFILLLINEORDEREDUOM", "FULFILLLINEPACKINGINSTRUCTIONS", "FULFILLLINEPARENTFULFILLLINEIDPK", "FULFILLLINEPARENTFULFILLLINENUMBER", "FULFILLLINEPARTIALSHIPALLOWEDFLAG", "FULFILLLINEPAYMENTTERMID", "FULFILLLINEREQUESTARRIVALDATE", "FULFILLLINEREQUESTCANCELDATE", "FULFILLLINEREQUESTSHIPDATE", "FULFILLLINERESERVABLEFLAG", "FULFILLLINERESERVEDQTY", "FULFILLLINERETURNREASONCODE", "FULFILLLINERMADELIVEREDQTY", "FULFILLLINEROOTPARENTFULFILLLINEIDPK", "FULFILLLINEROOTPARENTFULFILLLINENUMBER", "FULFILLLINESCHEDULEARRIVALDATE", "FULFILLLINESCHEDULESHIPDATE", "FULFILLLINESHIPCLASSOFSERVICE", "FULFILLLINESHIPMODEOFTRANSPORT", "FULFILLLINESHIPTOPARTYCONTACTID", "FULFILLLINESHIPTOPARTYID", "FULFILLLINESHIPTOPARTYSITEID", "FULFILLLINESHIPPABLEFLAG", "FULFILLLINESHIPPEDQTY", "FULFILLLINESHIPPINGINSTRUCTIONS", "FULFILLLINESOURCELINEID", "FULFILLLINESOURCELINENUMBER", "FULFILLLINESOURCEORDERID", "FULFILLLINESOURCEORDERNUMBER", "FULFILLLINESTATUSCODE", "FULFILLLINETAXCLASSIFICATIONCODE", "FULFILLLINETAXEXEMPTFLAG", "FULFILLLINEUNITLISTPRICE", "FULFILLLINEUNITSELLINGPRICE", "FULFILLLINEUNREFERENCEDRETURNFLAG", "HEADERCANCELREASONCODE", "HEADERCANCELEDFLAG", "HEADERCHANGEVERSIONNUMBER", "HEADERCREATEDBY", "HEADERCREATIONDATE", "HEADERCUSTOMERPONUMBER", "HEADERHEADERID", "HEADERLASTUPDATEDATE", "HEADERLASTUPDATEDBY", "HEADERLEGALENTITYID", "HEADERONHOLD", "HEADEROPENFLAG", "HEADERORDERNUMBER", "HEADERORDERTYPECODE", "HEADERORDEREDDATE", "HEADERORGID", "HEADERREQUESTSHIPDATE", "HEADERSALESPERSONID", "HEADERSOLDTOPARTYCONTACTID", "HEADERSOLDTOPARTYID", "HEADERSOURCEDOCUMENTTYPECODE", "HEADERSOURCEORDERSYSTEM", "HEADERSOURCEORGID", "HEADERSTATUSCODE", "HEADERSUBMITTEDBY", "HEADERSUBMITTEDDATE", "HEADERSUBMITTEDFLAG", "HEADERTRANSACTIONALCURRENCYCODE", "LINEACTUALSHIPDATE", "LINECANCELEDFLAG", "LINECANCELEDQTY", "LINECATEGORYCODE", "LINECREATEDBY", "LINECREATIONDATE", "LINEDISPLAYLINENUMBER", "LINEFULFILLMENTDATE", "LINEHEADERID", "LINEINVENTORYITEMID", "LINEITEMTYPECODE", "LINELASTUPDATEDATE", "LINELASTUPDATEDBY", "LINELINEID", "LINELINENUMBER", "LINEONHOLD", "LINEOPENFLAG", "LINEORDEREDQTY", "LINEORDEREDUOM", "LINESCHEDULESHIPDATE", "LINESHIPPEDQTY", "LINESOURCELINEID", "LINESOURCELINENUMBER", "LINESOURCEORDERID", "LINESOURCEORDERNUMBER", "LINESOURCESCHEDULENUMBER", "LINESTATUSCODE", "LINEUNITLISTPRICE", "LINEUNITSELLINGPRICE", "ROW_ACTIVE", "AUDIT_ID", "DIM_ITEMREF_OM_ID", "DIM_FULFILLLINESTATUS_OM_ID", "FACT_LINEEXTRACT_OM_ID", "DIM_INVORGPARAMETERS_OM_ID")
  DEFAULT COLLATION "USING_NLS_COMP"  SEGMENT CREATION IMMEDIATE
  ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 
 COLUMN STORE COMPRESS FOR QUERY HIGH ROW LEVEL LOCKING LOGGING
  BUILD DEFERRED
  USING INDEX PCTFREE 10 INITRANS 20 MAXTRANS 255 
  REFRESH FORCE ON DEMAND
  WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT
  USING ENFORCED CONSTRAINTS DISABLE ON QUERY COMPUTATION DISABLE QUERY REWRITE DISABLE CONCURRENT REFRESH
  AS SELECT "FACT_FULFILLLINE_OM"."FULFILLLINE_OM_ID" "FULFILLLINE_OM_ID","FACT_FULFILLLINE_OM"."BILLTOCUSTOMERACCOUNTACCOUNTESTABLISHEDDATE" "BILLTOCUSTOMERACCOUNTACCOUNTESTABLISHEDDATE","FACT_FULFILLLINE_OM"."BILLTOCUSTOMERACCOUNTLASTUPDATEDATE" "BILLTOCUSTOMERACCOUNTLASTUPDATEDATE","FACT_FULFILLLINE_OM"."COVERAGEFLINEDETAILSFULFILLLINENUMBER" "COVERAGEFLINEDETAILSFULFILLLINENUMBER","FACT_FULFILLLINE_OM"."COVERAGEFLINEDETAILSSOURCEREVISIONNUMBER" "COVERAGEFLINEDETAILSSOURCEREVISIONNUMBER","FACT_FULFILLLINE_OM"."COVEREDFLINEDETAILSFULFILLLINENUMBER" "COVEREDFLINEDETAILSFULFILLLINENUMBER","FACT_FULFILLLINE_OM"."COVEREDFLINEDETAILSSOURCEREVISIONNUMBER" "COVEREDFLINEDETAILSSOURCEREVISIONNUMBER","FACT_FULFILLLINE_OM"."DOCUMENTREFERENCESDOCALTUSERKEY" "DOCUMENTREFERENCESDOCALTUSERKEY","FACT_FULFILLLINE_OM"."DOCUMENTREFERENCESDOCCONTEXTID" "DOCUMENTREFERENCESDOCCONTEXTID","FACT_FULFILLLINE_OM"."DOCUMENTREFERENCESDOCLINEID" "DOCUMENTREFERENCESDOCLINEID","FACT_FULFILLLINE_OM"."DOCUMENTREFERENCESDOCLINEUSERKEY" "DOCUMENTREFERENCESDOCLINEUSERKEY","FACT_FULFILLLINE_OM"."DOCUMENTREFERENCESDOCREFTYPE" "DOCUMENTREFERENCESDOCREFTYPE","FACT_FULFILLLINE_OM"."DOCUMENTREFERENCESDOCSUBLINEID" "DOCUMENTREFERENCESDOCSUBLINEID","FACT_FULFILLLINE_OM"."DOCUMENTREFERENCESDOCSUBLINEUSERKEY" "DOCUMENTREFERENCESDOCSUBLINEUSERKEY","FACT_FULFILLLINE_OM"."DOCUMENTREFERENCESDOCUSERKEY" "DOCUMENTREFERENCESDOCUSERKEY","FACT_FULFILLLINE_OM"."FULFILLLINEACTUALCOMPLETIONDATE" "FULFILLLINEACTUALCOMPLETIONDATE","FACT_FULFILLLINE_OM"."FULFILLLINEACTUALSHIPDATE" "FULFILLLINEACTUALSHIPDATE","FACT_FULFILLLINE_OM"."FULFILLLINEASSETTRACKEDFLAG" "FULFILLLINEASSETTRACKEDFLAG","FACT_FULFILLLINE_OM"."FULFILLLINEBILLTOSITEUSEID" "FULFILLLINEBILLTOSITEUSEID","FACT_FULFILLLINE_OM"."FULFILLLINECANCELREASONCODE" "FULFILLLINECANCELREASONCODE","FACT_FULFILLLINE_OM"."FULFILLLINECANCELEDFLAG" "FULFILLLINECANCELEDFLAG","FACT_FULFILLLINE_OM"."FULFILLLINECANCELEDQTY" "FULFILLLINECANCELEDQTY","FACT_FULFILLLINE_OM"."FULFILLLINECATEGORYCODE" "FULFILLLINECATEGORYCODE","FACT_FULFILLLINE_OM"."FULFILLLINECREATEDBY" "FULFILLLINECREATEDBY","FACT_FULFILLLINE_OM"."FULFILLLINECREATIONDATE" "FULFILLLINECREATIONDATE","FACT_FULFILLLINE_OM"."FULFILLLINECUSTOMERPONUMBER" "FULFILLLINECUSTOMERPONUMBER","FACT_FULFILLLINE_OM"."FULFILLLINEESTIMATEFULFILLMENTCOST" "FULFILLLINEESTIMATEFULFILLMENTCOST","FACT_FULFILLLINE_OM"."FULFILLLINEFULFILLFLAG" "FULFILLLINEFULFILLFLAG","FACT_FULFILLLINE_OM"."FULFILLLINEFULFILLLINENUMBER" "FULFILLLINEFULFILLLINENUMBER","FACT_FULFILLLINE_OM"."FULFILLLINEFULFILLORGID" "FULFILLLINEFULFILLORGID","FACT_FULFILLLINE_OM"."FULFILLLINEFULFILLEDQTY" "FULFILLLINEFULFILLEDQTY","FACT_FULFILLLINE_OM"."FULFILLLINEFULFILLMENTDATE" "FULFILLLINEFULFILLMENTDATE","FACT_FULFILLLINE_OM"."FULFILLLINEFULFILLMENTSPLITREFID" "FULFILLLINEFULFILLMENTSPLITREFID","FACT_FULFILLLINE_OM"."FULFILLLINEHEADERID" "FULFILLLINEHEADERID","FACT_FULFILLLINE_OM"."FULFILLLINEID" "FULFILLLINEID","FACT_FULFILLLINE_OM"."FULFILLLINEINVENTORYINTERFACEDFLAG" "FULFILLLINEINVENTORYINTERFACEDFLAG","FACT_FULFILLLINE_OM"."FULFILLLINEINVENTORYITEMID" "FULFILLLINEINVENTORYITEMID","FACT_FULFILLLINE_OM"."FULFILLLINEINVENTORYTRANSACTIONFLAG" "FULFILLLINEINVENTORYTRANSACTIONFLAG","FACT_FULFILLLINE_OM"."FULFILLLINEITEMSUBTYPECODE" "FULFILLLINEITEMSUBTYPECODE","FACT_FULFILLLINE_OM"."FULFILLLINEITEMTYPECODE" "FULFILLLINEITEMTYPECODE","FACT_FULFILLLINE_OM"."FULFILLLINELASTUPDATEDATE" "FULFILLLINELASTUPDATEDATE","FACT_FULFILLLINE_OM"."FULFILLLINELASTUPDATEDBY" "FULFILLLINELASTUPDATEDBY","FACT_FULFILLLINE_OM"."FULFILLLINELINEID" "FULFILLLINELINEID","FACT_FULFILLLINE_OM"."FULFILLLINELINETYPECODE" "FULFILLLINELINETYPECODE","FACT_FULFILLLINE_OM"."FULFILLLINEONHOLD" "FULFILLLINEONHOLD","FACT_FULFILLLINE_OM"."FULFILLLINEOPENFLAG" "FULFILLLINEOPENFLAG","FACT_FULFILLLINE_OM"."FULFILLLINEORDEREDQTY" "FULFILLLINEORDEREDQTY","FACT_FULFILLLINE_OM"."FULFILLLINEORDEREDUOM" "FULFILLLINEORDEREDUOM","FACT_FULFILLLINE_OM"."FULFILLLINEPACKINGINSTRUCTIONS" "FULFILLLINEPACKINGINSTRUCTIONS","FACT_FULFILLLINE_OM"."FULFILLLINEPARENTFULFILLLINEIDPK" "FULFILLLINEPARENTFULFILLLINEIDPK","FACT_FULFILLLINE_OM"."FULFILLLINEPARENTFULFILLLINENUMBER" "FULFILLLINEPARENTFULFILLLINENUMBER","FACT_FULFILLLINE_OM"."FULFILLLINEPARTIALSHIPALLOWEDFLAG" "FULFILLLINEPARTIALSHIPALLOWEDFLAG","FACT_FULFILLLINE_OM"."FULFILLLINEPAYMENTTERMID" "FULFILLLINEPAYMENTTERMID","FACT_FULFILLLINE_OM"."FULFILLLINEREQUESTARRIVALDATE" "FULFILLLINEREQUESTARRIVALDATE","FACT_FULFILLLINE_OM"."FULFILLLINEREQUESTCANCELDATE" "FULFILLLINEREQUESTCANCELDATE","FACT_FULFILLLINE_OM"."FULFILLLINEREQUESTSHIPDATE" "FULFILLLINEREQUESTSHIPDATE","FACT_FULFILLLINE_OM"."FULFILLLINERESERVABLEFLAG" "FULFILLLINERESERVABLEFLAG","FACT_FULFILLLINE_OM"."FULFILLLINERESERVEDQTY" "FULFILLLINERESERVEDQTY","FACT_FULFILLLINE_OM"."FULFILLLINERETURNREASONCODE" "FULFILLLINERETURNREASONCODE","FACT_FULFILLLINE_OM"."FULFILLLINERMADELIVEREDQTY" "FULFILLLINERMADELIVEREDQTY","FACT_FULFILLLINE_OM"."FULFILLLINEROOTPARENTFULFILLLINEIDPK" "FULFILLLINEROOTPARENTFULFILLLINEIDPK","FACT_FULFILLLINE_OM"."FULFILLLINEROOTPARENTFULFILLLINENUMBER" "FULFILLLINEROOTPARENTFULFILLLINENUMBER","FACT_FULFILLLINE_OM"."FULFILLLINESCHEDULEARRIVALDATE" "FULFILLLINESCHEDULEARRIVALDATE","FACT_FULFILLLINE_OM"."FULFILLLINESCHEDULESHIPDATE" "FULFILLLINESCHEDULESHIPDATE","FACT_FULFILLLINE_OM"."FULFILLLINESHIPCLASSOFSERVICE" "FULFILLLINESHIPCLASSOFSERVICE","FACT_FULFILLLINE_OM"."FULFILLLINESHIPMODEOFTRANSPORT" "FULFILLLINESHIPMODEOFTRANSPORT","FACT_FULFILLLINE_OM"."FULFILLLINESHIPTOPARTYCONTACTID" "FULFILLLINESHIPTOPARTYCONTACTID","FACT_FULFILLLINE_OM"."FULFILLLINESHIPTOPARTYID" "FULFILLLINESHIPTOPARTYID","FACT_FULFILLLINE_OM"."FULFILLLINESHIPTOPARTYSITEID" "FULFILLLINESHIPTOPARTYSITEID","FACT_FULFILLLINE_OM"."FULFILLLINESHIPPABLEFLAG" "FULFILLLINESHIPPABLEFLAG","FACT_FULFILLLINE_OM"."FULFILLLINESHIPPEDQTY" "FULFILLLINESHIPPEDQTY","FACT_FULFILLLINE_OM"."FULFILLLINESHIPPINGINSTRUCTIONS" "FULFILLLINESHIPPINGINSTRUCTIONS","FACT_FULFILLLINE_OM"."FULFILLLINESOURCELINEID" "FULFILLLINESOURCELINEID","FACT_FULFILLLINE_OM"."FULFILLLINESOURCELINENUMBER" "FULFILLLINESOURCELINENUMBER","FACT_FULFILLLINE_OM"."FULFILLLINESOURCEORDERID" "FULFILLLINESOURCEORDERID","FACT_FULFILLLINE_OM"."FULFILLLINESOURCEORDERNUMBER" "FULFILLLINESOURCEORDERNUMBER","FACT_FULFILLLINE_OM"."FULFILLLINESTATUSCODE" "FULFILLLINESTATUSCODE","FACT_FULFILLLINE_OM"."FULFILLLINETAXCLASSIFICATIONCODE" "FULFILLLINETAXCLASSIFICATIONCODE","FACT_FULFILLLINE_OM"."FULFILLLINETAXEXEMPTFLAG" "FULFILLLINETAXEXEMPTFLAG","FACT_FULFILLLINE_OM"."FULFILLLINEUNITLISTPRICE" "FULFILLLINEUNITLISTPRICE","FACT_FULFILLLINE_OM"."FULFILLLINEUNITSELLINGPRICE" "FULFILLLINEUNITSELLINGPRICE","FACT_FULFILLLINE_OM"."FULFILLLINEUNREFERENCEDRETURNFLAG" "FULFILLLINEUNREFERENCEDRETURNFLAG","FACT_FULFILLLINE_OM"."HEADERCANCELREASONCODE" "HEADERCANCELREASONCODE","FACT_FULFILLLINE_OM"."HEADERCANCELEDFLAG" "HEADERCANCELEDFLAG","FACT_FULFILLLINE_OM"."HEADERCHANGEVERSIONNUMBER" "HEADERCHANGEVERSIONNUMBER","FACT_FULFILLLINE_OM"."HEADERCREATEDBY" "HEADERCREATEDBY","FACT_FULFILLLINE_OM"."HEADERCREATIONDATE" "HEADERCREATIONDATE","FACT_FULFILLLINE_OM"."HEADERCUSTOMERPONUMBER" "HEADERCUSTOMERPONUMBER","FACT_FULFILLLINE_OM"."HEADERHEADERID" "HEADERHEADERID","FACT_FULFILLLINE_OM"."HEADERLASTUPDATEDATE" "HEADERLASTUPDATEDATE","FACT_FULFILLLINE_OM"."HEADERLASTUPDATEDBY" "HEADERLASTUPDATEDBY","FACT_FULFILLLINE_OM"."HEADERLEGALENTITYID" "HEADERLEGALENTITYID","FACT_FULFILLLINE_OM"."HEADERONHOLD" "HEADERONHOLD","FACT_FULFILLLINE_OM"."HEADEROPENFLAG" "HEADEROPENFLAG","FACT_FULFILLLINE_OM"."HEADERORDERNUMBER" "HEADERORDERNUMBER","FACT_FULFILLLINE_OM"."HEADERORDERTYPECODE" "HEADERORDERTYPECODE","FACT_FULFILLLINE_OM"."HEADERORDEREDDATE" "HEADERORDEREDDATE","FACT_FULFILLLINE_OM"."HEADERORGID" "HEADERORGID","FACT_FULFILLLINE_OM"."HEADERREQUESTSHIPDATE" "HEADERREQUESTSHIPDATE","FACT_FULFILLLINE_OM"."HEADERSALESPERSONID" "HEADERSALESPERSONID","FACT_FULFILLLINE_OM"."HEADERSOLDTOPARTYCONTACTID" "HEADERSOLDTOPARTYCONTACTID","FACT_FULFILLLINE_OM"."HEADERSOLDTOPARTYID" "HEADERSOLDTOPARTYID","FACT_FULFILLLINE_OM"."HEADERSOURCEDOCUMENTTYPECODE" "HEADERSOURCEDOCUMENTTYPECODE","FACT_FULFILLLINE_OM"."HEADERSOURCEORDERSYSTEM" "HEADERSOURCEORDERSYSTEM","FACT_FULFILLLINE_OM"."HEADERSOURCEORGID" "HEADERSOURCEORGID","FACT_FULFILLLINE_OM"."HEADERSTATUSCODE" "HEADERSTATUSCODE","FACT_FULFILLLINE_OM"."HEADERSUBMITTEDBY" "HEADERSUBMITTEDBY","FACT_FULFILLLINE_OM"."HEADERSUBMITTEDDATE" "HEADERSUBMITTEDDATE","FACT_FULFILLLINE_OM"."HEADERSUBMITTEDFLAG" "HEADERSUBMITTEDFLAG","FACT_FULFILLLINE_OM"."HEADERTRANSACTIONALCURRENCYCODE" "HEADERTRANSACTIONALCURRENCYCODE","FACT_FULFILLLINE_OM"."LINEACTUALSHIPDATE" "LINEACTUALSHIPDATE","FACT_FULFILLLINE_OM"."LINECANCELEDFLAG" "LINECANCELEDFLAG","FACT_FULFILLLINE_OM"."LINECANCELEDQTY" "LINECANCELEDQTY","FACT_FULFILLLINE_OM"."LINECATEGORYCODE" "LINECATEGORYCODE","FACT_FULFILLLINE_OM"."LINECREATEDBY" "LINECREATEDBY","FACT_FULFILLLINE_OM"."LINECREATIONDATE" "LINECREATIONDATE","FACT_FULFILLLINE_OM"."LINEDISPLAYLINENUMBER" "LINEDISPLAYLINENUMBER","FACT_FULFILLLINE_OM"."LINEFULFILLMENTDATE" "LINEFULFILLMENTDATE","FACT_FULFILLLINE_OM"."LINEHEADERID" "LINEHEADERID","FACT_FULFILLLINE_OM"."LINEINVENTORYITEMID" "LINEINVENTORYITEMID","FACT_FULFILLLINE_OM"."LINEITEMTYPECODE" "LINEITEMTYPECODE","FACT_FULFILLLINE_OM"."LINELASTUPDATEDATE" "LINELASTUPDATEDATE","FACT_FULFILLLINE_OM"."LINELASTUPDATEDBY" "LINELASTUPDATEDBY","FACT_FULFILLLINE_OM"."LINELINEID" "LINELINEID","FACT_FULFILLLINE_OM"."LINELINENUMBER" "LINELINENUMBER","FACT_FULFILLLINE_OM"."LINEONHOLD" "LINEONHOLD","FACT_FULFILLLINE_OM"."LINEOPENFLAG" "LINEOPENFLAG","FACT_FULFILLLINE_OM"."LINEORDEREDQTY" "LINEORDEREDQTY","FACT_FULFILLLINE_OM"."LINEORDEREDUOM" "LINEORDEREDUOM","FACT_FULFILLLINE_OM"."LINESCHEDULESHIPDATE" "LINESCHEDULESHIPDATE","FACT_FULFILLLINE_OM"."LINESHIPPEDQTY" "LINESHIPPEDQTY","FACT_FULFILLLINE_OM"."LINESOURCELINEID" "LINESOURCELINEID","FACT_FULFILLLINE_OM"."LINESOURCELINENUMBER" "LINESOURCELINENUMBER","FACT_FULFILLLINE_OM"."LINESOURCEORDERID" "LINESOURCEORDERID","FACT_FULFILLLINE_OM"."LINESOURCEORDERNUMBER" "LINESOURCEORDERNUMBER","FACT_FULFILLLINE_OM"."LINESOURCESCHEDULENUMBER" "LINESOURCESCHEDULENUMBER","FACT_FULFILLLINE_OM"."LINESTATUSCODE" "LINESTATUSCODE","FACT_FULFILLLINE_OM"."LINEUNITLISTPRICE" "LINEUNITLISTPRICE","FACT_FULFILLLINE_OM"."LINEUNITSELLINGPRICE" "LINEUNITSELLINGPRICE","FACT_FULFILLLINE_OM"."ROW_ACTIVE" "ROW_ACTIVE","FACT_FULFILLLINE_OM"."AUDIT_ID" "AUDIT_ID","FACT_FULFILLLINE_OM"."DIM_ITEMREF_OM_ID" "DIM_ITEMREF_OM_ID","FACT_FULFILLLINE_OM"."DIM_FULFILLLINESTATUS_OM_ID" "DIM_FULFILLLINESTATUS_OM_ID","FACT_FULFILLLINE_OM"."FACT_LINEEXTRACT_OM_ID" "FACT_LINEEXTRACT_OM_ID","FACT_FULFILLLINE_OM"."DIM_INVORGPARAMETERS_OM_ID" "DIM_INVORGPARAMETERS_OM_ID" FROM "DWADW"."FACT_FULFILLLINE_OM" "FACT_FULFILLLINE_OM";

← Volver al esquema DWADW

🏠 Volver al menú principal