DWADW.FACT_MARGINDETAILSEXTRACT_OM

Base de datos origen: ADW COEXITO

Descripción: Español: Tabla de hechos de costos, ingresos y margen asociados a ventas. Contiene costos reconocidos, ingresos, margen bruto, artículos, organizaciones, facturas y órdenes relacionadas, y permite analizar rentabilidad y margen por producto y transacción. English: Fact table of costs, revenue, and margin associated with sales. It contains recognized costs, revenue, gross margin, items, organizations, invoices, and related orders and supports profitability and margin analysis by product and transaction.

Columnas

#	Columna	Tipo	Nulo	Default
1	MARGINDETAILSEXTRACT_OM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_378195”.nextval
2	MARGINDETAILID	NUMBER(18,0)	NO
3	MARGINDETAILSPEORECOGNIZEDCOGSAMOUNT	NUMBER	SI
4	MARGINDETAILSPEOGLDATE	DATE	SI
5	MARGINDETAILSPEOCURRENCYCODE	VARCHAR2(30)	SI
6	MARGINDETAILSPEOCOGSACCOUNTID	NUMBER(18,0)	SI
7	MARGINDETAILSPEOCOSTBOOKID	NUMBER(18,0)	SI
8	MARGINDETAILSPEOCOSTORGID	NUMBER(18,0)	SI
9	MARGINDETAILSPEOPROFITCENTERBUID	NUMBER(18,0)	SI
10	MARGINDETAILSPEOINVENTORYITEMID	NUMBER(18,0)	SI
11	MARGINDETAILSPEOINVENTORYORGID	NUMBER(18,0)	SI
12	MARGINDETAILSPEOITEMORGANIZATIONID	NUMBER(18,0)	SI
13	MARGINDETAILSPEOCUSTOMERID	NUMBER(18,0)	SI
14	MARGINDETAILSPEODOCLINEID	NUMBER(18,0)	SI
15	MARGINDETAILSPEODOOORDERNUMBER	VARCHAR2(240)	SI
16	MARGINDETAILSPEODOOORDERTYPE	VARCHAR2(50)	SI
17	MARGINDETAILSPEOORDERTYPECODE	VARCHAR2(30)	SI
18	MARGINDETAILSPEOINVOICEID	NUMBER(18,0)	SI
19	MARGINDETAILSPEOINVOICELINEID	NUMBER(18,0)	SI
20	MARGINDETAILSPEOINVOICENUMBER	NUMBER(18,0)	SI
21	MARGINDETAILSPEOINVOICESOURCE	VARCHAR2(30)	SI
22	MARGINDETAILSPEOSHIPMENTNUMBER	VARCHAR2(240)	SI
23	MARGINDETAILSPEOSHIPMENTTYPE	VARCHAR2(50)	SI
24	MARGINDETAILSPEORECOGNIZEDGROSSMARGIN	NUMBER	SI
25	MARGINDETAILSPEORECOGNIZEDREV	NUMBER	SI
26	MARGINDETAILSPEOCREATIONDATE	TIMESTAMP(6)	SI
27	MARGINDETAILSPEOCREATEDBY	VARCHAR2(64)	SI
28	MARGINDETAILSPEOLASTUPDATEDATE	TIMESTAMP(6)	NO
29	MARGINDETAILSPEOLASTUPDATEDBY	VARCHAR2(64)	SI
30	ROW_ACTIVE	CHAR(1)	NO	‘A’
31	AUDIT_ID	NUMBER	NO
32	FACT_LINEEXTRACT_OM_ID	NUMBER	SI

Restricciones

CHECK: FACT_MARGINDETAILSEXTRACT_OM_CK

Estado: ENABLED
Columnas: ROW_ACTIVE
Condición: row_active IN ('A','I')

CHECK: SYS_C00304960

Estado: ENABLED
Columnas: MARGINDETAILSEXTRACT_OM_ID
Condición: "MARGINDETAILSEXTRACT_OM_ID" IS NOT NULL

CHECK: SYS_C00304961

Estado: ENABLED
Columnas: MARGINDETAILID
Condición: "MARGINDETAILID" IS NOT NULL

CHECK: SYS_C00304962

Estado: ENABLED
Columnas: MARGINDETAILSPEOLASTUPDATEDATE
Condición: "MARGINDETAILSPEOLASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C00304963

Estado: ENABLED
Columnas: ROW_ACTIVE
Condición: "ROW_ACTIVE" IS NOT NULL

CHECK: SYS_C00304964

Estado: ENABLED
Columnas: AUDIT_ID
Condición: "AUDIT_ID" IS NOT NULL

PK: FACT_MARGINDETAILSEXTRACT_OM_PK

Estado: ENABLED
Columnas: MARGINDETAILSEXTRACT_OM_ID

FK: FACT_MARGINDETAILSEXTRACT_OM_FACT_LINEEXTRACT_OM_FK

Estado: ENABLED
Columnas: FACT_LINEEXTRACT_OM_ID
Referencia: DWADW.FACT_LINEEXTRACT_OM (constraint FACT_LINEEXTRACT_OM_PK)

UK: FACT_MARGINDETAILSEXTRACT_OM__UN

Estado: ENABLED
Columnas: MARGINDETAILID

DDL

CREATE TABLE "DWADW"."FACT_MARGINDETAILSEXTRACT_OM" 
   (	"MARGINDETAILSEXTRACT_OM_ID" NUMBER GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, 
	"MARGINDETAILID" NUMBER(18,0) NOT NULL ENABLE, 
	"MARGINDETAILSPEORECOGNIZEDCOGSAMOUNT" NUMBER, 
	"MARGINDETAILSPEOGLDATE" DATE, 
	"MARGINDETAILSPEOCURRENCYCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"MARGINDETAILSPEOCOGSACCOUNTID" NUMBER(18,0), 
	"MARGINDETAILSPEOCOSTBOOKID" NUMBER(18,0), 
	"MARGINDETAILSPEOCOSTORGID" NUMBER(18,0), 
	"MARGINDETAILSPEOPROFITCENTERBUID" NUMBER(18,0), 
	"MARGINDETAILSPEOINVENTORYITEMID" NUMBER(18,0), 
	"MARGINDETAILSPEOINVENTORYORGID" NUMBER(18,0), 
	"MARGINDETAILSPEOITEMORGANIZATIONID" NUMBER(18,0), 
	"MARGINDETAILSPEOCUSTOMERID" NUMBER(18,0), 
	"MARGINDETAILSPEODOCLINEID" NUMBER(18,0), 
	"MARGINDETAILSPEODOOORDERNUMBER" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"MARGINDETAILSPEODOOORDERTYPE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"MARGINDETAILSPEOORDERTYPECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"MARGINDETAILSPEOINVOICEID" NUMBER(18,0), 
	"MARGINDETAILSPEOINVOICELINEID" NUMBER(18,0), 
	"MARGINDETAILSPEOINVOICENUMBER" NUMBER(18,0), 
	"MARGINDETAILSPEOINVOICESOURCE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"MARGINDETAILSPEOSHIPMENTNUMBER" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"MARGINDETAILSPEOSHIPMENTTYPE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"MARGINDETAILSPEORECOGNIZEDGROSSMARGIN" NUMBER, 
	"MARGINDETAILSPEORECOGNIZEDREV" NUMBER, 
	"MARGINDETAILSPEOCREATIONDATE" TIMESTAMP (6), 
	"MARGINDETAILSPEOCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"MARGINDETAILSPEOLASTUPDATEDATE" TIMESTAMP (6) NOT NULL ENABLE, 
	"MARGINDETAILSPEOLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"FACT_LINEEXTRACT_OM_ID" NUMBER, 
	 CONSTRAINT "FACT_MARGINDETAILSEXTRACT_OM_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_MARGINDETAILSEXTRACT_OM_PK" PRIMARY KEY ("MARGINDETAILSEXTRACT_OM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_MARGINDETAILSEXTRACT_OM__UN" UNIQUE ("MARGINDETAILID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_MARGINDETAILSEXTRACT_OM_FACT_LINEEXTRACT_OM_FK" FOREIGN KEY ("FACT_LINEEXTRACT_OM_ID")
	  REFERENCES "DWADW"."FACT_LINEEXTRACT_OM" ("LINEEXTRACT_OM_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."FACT_MARGINDETAILSEXTRACT_OM"  IS 'Español: Tabla de hechos de costos, ingresos y margen asociados a ventas. Contiene costos reconocidos, ingresos, margen bruto, artículos, organizaciones, facturas y órdenes relacionadas, y permite analizar rentabilidad y margen por producto y transacción.
English: Fact table of costs, revenue, and margin associated with sales. It contains recognized costs, revenue, gross margin, items, organizations, invoices, and related orders and supports profitability and margin analysis by product and transaction.';

CREATE INDEX "DWADW"."MARGIN_TRACKING_OM_IDX" ON "DWADW"."FACT_MARGINDETAILSEXTRACT_OM" ("MARGINDETAILSPEODOOORDERNUMBER", "MARGINDETAILSPEOINVENTORYITEMID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_MARGINDETAILSEXTRACT_OM_PK" ON "DWADW"."FACT_MARGINDETAILSEXTRACT_OM" ("MARGINDETAILSEXTRACT_OM_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_MARGINDETAILSEXTRACT_OM__UN" ON "DWADW"."FACT_MARGINDETAILSEXTRACT_OM" ("MARGINDETAILID") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal