DWADW.FACT_SALESINVOICECUSTOMERTRXLINE_OM

Base de datos origen: ADW COEXITO

Descripción: Español: Tabla de hechos de líneas de facturación de clientes. Contiene artículos, cantidades, precios, importes, clientes, organizaciones y referencias de órdenes y facturas, y permite analizar el detalle de las ventas facturadas. English: Customer billing line fact table. It contains items, quantities, prices, amounts, customers, organizations, and order and invoice references and supports detailed analysis of billed sales.

Columnas

#	Columna	Tipo	Nulo	Default
1	SALESINVOICECUSTOMERTRXLINE_OM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_378199”.nextval
2	CUSTOMERTRXLINEID	NUMBER(18,0)	NO
3	TRANSACTIONLINECUSTOMERTRXID	NUMBER(18,0)	NO
4	TRANSACTIONLINEINVENTORYITEMID	NUMBER(18,0)	SI
5	TRANSACTIONLINEORGID	NUMBER(18,0)	NO
6	TRANSACTIONLINEWAREHOUSEID	NUMBER(18,0)	SI
7	TRANSACTIONLINELINENUMBER	NUMBER	SI
8	TRANSACTIONLINESALESORDER	VARCHAR2(50)	SI
9	TRANSACTIONLINESALESORDERLINE	VARCHAR2(30)	SI
10	TRANSACTIONLINESOURCEDOCUMENTLINEID	NUMBER(18,0)	SI
11	TRANSACTIONLINEDESCRIPTION	VARCHAR2(240)	SI
12	TRANSACTIONLINEQUANTITYORDERED	NUMBER	SI
13	TRANSACTIONLINEQUANTITYINVOICED	NUMBER	SI
14	TRANSACTIONLINEQUANTITYCREDITED	NUMBER	SI
15	TRANSACTIONLINEUNITSTANDARDPRICE	NUMBER	SI
16	TRANSACTIONLINEUNITSELLINGPRICE	NUMBER	SI
17	TRANSACTIONLINEEXTENDEDAMOUNT	NUMBER	SI
18	TRANSACTIONHEADERCUSTOMERTRXID	NUMBER(18,0)	NO
19	TRANSACTIONHEADERTRXNUMBER	VARCHAR2(20)	NO
20	TRANSACTIONHEADERTRXDATE	DATE	NO
21	TRANSACTIONHEADERBILLTOCUSTOMERID	NUMBER(18,0)	SI
22	TRANSACTIONHEADERSOLDTOCUSTOMERID	NUMBER(18,0)	SI
23	TRANSACTIONHEADERSOLDTOPARTYID	NUMBER(18,0)	SI
24	TRANSACTIONHEADERSHIPTOCUSTOMERID	NUMBER(18,0)	SI
25	TRANSACTIONHEADERSHIPTOPARTYID	NUMBER(18,0)	SI
26	TRANSACTIONHEADERLEGALENTITYID	NUMBER(18,0)	SI
27	TRANSACTIONHEADERPRIMARYRESOURCESALESREPID	NUMBER(18,0)	SI
28	BUSINESSUNITBUSINESSUNITID	NUMBER(18,0)	NO
29	BUSINESSUNITNAME	VARCHAR2(240)	SI
30	TRANSACTIONLINECREATIONDATE	TIMESTAMP(6)	NO
31	TRANSACTIONLINELASTUPDATEDATE	TIMESTAMP(6)	NO
32	TRANSACTIONLINECREATEDBY	VARCHAR2(64)	NO
33	TRANSACTIONLINELASTUPDATEDBY	VARCHAR2(64)	NO
34	AUDIT_ID	NUMBER	NO
35	ROW_ACTIVE	CHAR(1)	NO	‘A’
36	DIM_TRANSACTIONHEADER_OM_ID	NUMBER	SI

Restricciones

CHECK: FACT_SALESINVOICECUSTOMERTRXLINE_OM_CK

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

CHECK: SYS_C00304968

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

CHECK: SYS_C00304969

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

CHECK: SYS_C00304970

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

CHECK: SYS_C00304971

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

CHECK: SYS_C00304972

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

CHECK: SYS_C00304973

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

CHECK: SYS_C00304974

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

CHECK: SYS_C00304975

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

CHECK: SYS_C00304976

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

CHECK: SYS_C00304977

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

CHECK: SYS_C00304978

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

CHECK: SYS_C00304979

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

CHECK: SYS_C00304980

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

CHECK: SYS_C00304981

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

PK: FACT_SALESINVOICECUSTOMERTRXLINE_OM_PK

Estado: ENABLED
Columnas: SALESINVOICECUSTOMERTRXLINE_OM_ID

FK: FACT_SALESINVOICECUSTOMERTRXLINE_OM_DIM_TRANSACTIONHEADER_OM_FK

Estado: ENABLED
Columnas: DIM_TRANSACTIONHEADER_OM_ID
Referencia: DWADW.DIM_TRANSACTIONHEADER_OM (constraint DIM_TRANSACTIONHEADER_OM_PK)

UK: FACT_SALESINVOICECUSTOMERTRXLINE_OM__UN

Estado: ENABLED
Columnas: CUSTOMERTRXLINEID

DDL

CREATE TABLE "DWADW"."FACT_SALESINVOICECUSTOMERTRXLINE_OM" 
   (	"SALESINVOICECUSTOMERTRXLINE_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, 
	"CUSTOMERTRXLINEID" NUMBER(18,0) NOT NULL ENABLE, 
	"TRANSACTIONLINECUSTOMERTRXID" NUMBER(18,0) NOT NULL ENABLE, 
	"TRANSACTIONLINEINVENTORYITEMID" NUMBER(18,0), 
	"TRANSACTIONLINEORGID" NUMBER(18,0) NOT NULL ENABLE, 
	"TRANSACTIONLINEWAREHOUSEID" NUMBER(18,0), 
	"TRANSACTIONLINELINENUMBER" NUMBER, 
	"TRANSACTIONLINESALESORDER" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONLINESALESORDERLINE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONLINESOURCEDOCUMENTLINEID" NUMBER(18,0), 
	"TRANSACTIONLINEDESCRIPTION" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONLINEQUANTITYORDERED" NUMBER, 
	"TRANSACTIONLINEQUANTITYINVOICED" NUMBER, 
	"TRANSACTIONLINEQUANTITYCREDITED" NUMBER, 
	"TRANSACTIONLINEUNITSTANDARDPRICE" NUMBER, 
	"TRANSACTIONLINEUNITSELLINGPRICE" NUMBER, 
	"TRANSACTIONLINEEXTENDEDAMOUNT" NUMBER, 
	"TRANSACTIONHEADERCUSTOMERTRXID" NUMBER(18,0) NOT NULL ENABLE, 
	"TRANSACTIONHEADERTRXNUMBER" VARCHAR2(20) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"TRANSACTIONHEADERTRXDATE" DATE NOT NULL ENABLE, 
	"TRANSACTIONHEADERBILLTOCUSTOMERID" NUMBER(18,0), 
	"TRANSACTIONHEADERSOLDTOCUSTOMERID" NUMBER(18,0), 
	"TRANSACTIONHEADERSOLDTOPARTYID" NUMBER(18,0), 
	"TRANSACTIONHEADERSHIPTOCUSTOMERID" NUMBER(18,0), 
	"TRANSACTIONHEADERSHIPTOPARTYID" NUMBER(18,0), 
	"TRANSACTIONHEADERLEGALENTITYID" NUMBER(18,0), 
	"TRANSACTIONHEADERPRIMARYRESOURCESALESREPID" NUMBER(18,0), 
	"BUSINESSUNITBUSINESSUNITID" NUMBER(18,0) NOT NULL ENABLE, 
	"BUSINESSUNITNAME" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONLINECREATIONDATE" TIMESTAMP (6) NOT NULL ENABLE, 
	"TRANSACTIONLINELASTUPDATEDATE" TIMESTAMP (6) NOT NULL ENABLE, 
	"TRANSACTIONLINECREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"TRANSACTIONLINELASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"DIM_TRANSACTIONHEADER_OM_ID" NUMBER, 
	 CONSTRAINT "FACT_SALESINVOICECUSTOMERTRXLINE_OM_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_SALESINVOICECUSTOMERTRXLINE_OM_PK" PRIMARY KEY ("SALESINVOICECUSTOMERTRXLINE_OM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_SALESINVOICECUSTOMERTRXLINE_OM__UN" UNIQUE ("CUSTOMERTRXLINEID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_SALESINVOICECUSTOMERTRXLINE_OM_DIM_TRANSACTIONHEADER_OM_FK" FOREIGN KEY ("DIM_TRANSACTIONHEADER_OM_ID")
	  REFERENCES "DWADW"."DIM_TRANSACTIONHEADER_OM" ("TRANSACTIONHEADER_OM_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."FACT_SALESINVOICECUSTOMERTRXLINE_OM"  IS 'Español: Tabla de hechos de líneas de facturación de clientes. Contiene artículos, cantidades, precios, importes, clientes, organizaciones y referencias de órdenes y facturas, y permite analizar el detalle de las ventas facturadas.
English: Customer billing line fact table. It contains items, quantities, prices, amounts, customers, organizations, and order and invoice references and supports detailed analysis of billed sales.';

CREATE UNIQUE INDEX "DWADW"."FACT_SALESINVOICECUSTOMERTRXLINE_OM_PK" ON "DWADW"."FACT_SALESINVOICECUSTOMERTRXLINE_OM" ("SALESINVOICECUSTOMERTRXLINE_OM_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_SALESINVOICECUSTOMERTRXLINE_OM__UN" ON "DWADW"."FACT_SALESINVOICECUSTOMERTRXLINE_OM" ("CUSTOMERTRXLINEID") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal