DWADW.DIM_SALESCREDIT_OM

Base de datos origen: ADW COEXITO

Descripción: Español: Almacena la información de los créditos de venta asociados a órdenes y líneas de cumplimiento. Contiene información del vendedor, tipo de crédito de venta, porcentaje de participación, cabecera y línea de la orden, así como datos de auditoría y control de actualización provenientes del sistema origen. English: Stores sales credit information associated with orders and fulfillines. It contains information about the salesperson, sales credit type, participation percentage, order header and line, as well as audit and update control data from the source system.

Columnas

#	Columna	Tipo	Nulo	Default
1	SALESCREDIT_OM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_382781”.nextval
2	SALESCREDITID	NUMBER(18,0)	NO
3	SALESCREDITCREATEDBY	VARCHAR2(64)	SI
4	SALESCREDITCREATIONDATE	TIMESTAMP(6)	SI
5	SALESCREDITFULFILLLINEID	NUMBER(18,0)	SI
6	SALESCREDITHEADERID	NUMBER(18,0)	NO
7	SALESCREDITLASTUPDATEDATE	TIMESTAMP(6)	NO
8	SALESCREDITLASTUPDATELOGIN	VARCHAR2(32)	SI
9	SALESCREDITLASTUPDATEDBY	VARCHAR2(64)	NO
10	SALESCREDITLINEID	NUMBER(18,0)	SI
11	SALESCREDITOBJECTVERSIONNUMBER	NUMBER	SI
12	SALESCREDITORIGSYSSALESCREDITREF	VARCHAR2(50)	SI
13	SALESCREDITPERCENT	NUMBER	NO
14	SALESCREDITSALESCREDITTYPEID	NUMBER(18,0)	SI
15	SALESCREDITSALESPERSONID	NUMBER(18,0)	NO
16	SALESCREDITTYPESALESCREDITTYPEID	NUMBER(18,0)	NO
17	SALESCREDITTYPEREFRESHNUMBER	NUMBER	SI
18	SALESCREDITTYPENAME	VARCHAR2(240)	NO
19	SALESCREDITTYPEENABLEDFLAG	VARCHAR2(1)	SI
20	SALESCREDITTYPEDESCRIPTION	VARCHAR2(2000)	SI
21	HEADERSUBMITTEDFLAG	VARCHAR2(1)	SI
22	HEADERHEADERID	NUMBER(18,0)	NO
23	AUDIT_ID	NUMBER	NO
24	ROW_ACTIVE	CHAR(1)	NO	‘A’
25	DIM_SALESREP_OM_ID	NUMBER	SI
26	FACT_FULFILLLINE_OM_ID	NUMBER	SI

Restricciones

CHECK: DIM_SALESCREDIT_OM_CK

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

CHECK: SYS_C00311569

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

CHECK: SYS_C00311570

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

CHECK: SYS_C00311571

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

CHECK: SYS_C00311572

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

CHECK: SYS_C00311573

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

CHECK: SYS_C00311574

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

CHECK: SYS_C00311575

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

CHECK: SYS_C00311576

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

CHECK: SYS_C00311577

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

CHECK: SYS_C00311578

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

CHECK: SYS_C00311579

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

CHECK: SYS_C00311580

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

PK: DIM_SALESCREDIT_OM_PK

Estado: ENABLED
Columnas: SALESCREDIT_OM_ID

FK: DIM_SALESCREDIT_OM_DIM_SALESREP_OM_FK

Estado: ENABLED
Columnas: DIM_SALESREP_OM_ID
Referencia: DWADW.DIM_SALESREP_OM (constraint DIM_SALESREP_OM_PK)

FK: DIM_SALESCREDIT_OM_FACT_FULFILLLINE_OM_FK

Estado: ENABLED
Columnas: FACT_FULFILLLINE_OM_ID
Referencia: DWADW.FACT_FULFILLLINE_OM (constraint ST_FULFILLLINE_OM_PK)

UK: DIM_SALESCREDIT_OM__UN

Estado: ENABLED
Columnas: SALESCREDITID

DDL

CREATE TABLE "DWADW"."DIM_SALESCREDIT_OM" 
   (	"SALESCREDIT_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, 
	"SALESCREDITID" NUMBER(18,0) NOT NULL ENABLE, 
	"SALESCREDITCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"SALESCREDITCREATIONDATE" TIMESTAMP (6), 
	"SALESCREDITFULFILLLINEID" NUMBER(18,0), 
	"SALESCREDITHEADERID" NUMBER(18,0) NOT NULL ENABLE, 
	"SALESCREDITLASTUPDATEDATE" TIMESTAMP (6) NOT NULL ENABLE, 
	"SALESCREDITLASTUPDATELOGIN" VARCHAR2(32) COLLATE "USING_NLS_COMP", 
	"SALESCREDITLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"SALESCREDITLINEID" NUMBER(18,0), 
	"SALESCREDITOBJECTVERSIONNUMBER" NUMBER, 
	"SALESCREDITORIGSYSSALESCREDITREF" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"SALESCREDITPERCENT" NUMBER NOT NULL ENABLE, 
	"SALESCREDITSALESCREDITTYPEID" NUMBER(18,0), 
	"SALESCREDITSALESPERSONID" NUMBER(18,0) NOT NULL ENABLE, 
	"SALESCREDITTYPESALESCREDITTYPEID" NUMBER(18,0) NOT NULL ENABLE, 
	"SALESCREDITTYPEREFRESHNUMBER" NUMBER, 
	"SALESCREDITTYPENAME" VARCHAR2(240) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"SALESCREDITTYPEENABLEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"SALESCREDITTYPEDESCRIPTION" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"HEADERSUBMITTEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"HEADERHEADERID" NUMBER(18,0) NOT NULL ENABLE, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"DIM_SALESREP_OM_ID" NUMBER, 
	"FACT_FULFILLLINE_OM_ID" NUMBER, 
	 CONSTRAINT "DIM_SALESCREDIT_OM_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "DIM_SALESCREDIT_OM_PK" PRIMARY KEY ("SALESCREDIT_OM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_SALESCREDIT_OM__UN" UNIQUE ("SALESCREDITID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_SALESCREDIT_OM_DIM_SALESREP_OM_FK" FOREIGN KEY ("DIM_SALESREP_OM_ID")
	  REFERENCES "DWADW"."DIM_SALESREP_OM" ("SALESREP_OM_ID") ENABLE, 
	 CONSTRAINT "DIM_SALESCREDIT_OM_FACT_FULFILLLINE_OM_FK" FOREIGN KEY ("FACT_FULFILLLINE_OM_ID")
	  REFERENCES "DWADW"."FACT_FULFILLLINE_OM" ("FULFILLLINE_OM_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."DIM_SALESCREDIT_OM"  IS 'Español: Almacena la información de los créditos de venta asociados a órdenes y líneas de cumplimiento. Contiene información del vendedor, tipo de crédito de venta, porcentaje de participación, cabecera y línea de la orden, así como datos de auditoría y control de actualización provenientes del sistema origen.
English: Stores sales credit information associated with orders and fulfillines. It contains information about the salesperson, sales credit type, participation percentage, order header and line, as well as audit and update control data from the source system.';

CREATE UNIQUE INDEX "DWADW"."DIM_SALESCREDIT_OM_PK" ON "DWADW"."DIM_SALESCREDIT_OM" ("SALESCREDIT_OM_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_SALESCREDIT_OM__UN" ON "DWADW"."DIM_SALESCREDIT_OM" ("SALESCREDITID") 
  ;
  CREATE INDEX "DWADW"."IDX_SC_TRACKING_OM" ON "DWADW"."DIM_SALESCREDIT_OM" ("SALESCREDITFULFILLLINEID") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal