🏠 Menú principal

← Volver a tablas

---

LACLS.LACLS_CO_PERIODS

Base de datos origen: PDB1

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	LEDGER_ID	NUMBER	NO
2	PERIOD_NAME	VARCHAR2(15)	NO
3	PERIOD_SET_NAME	VARCHAR2(15)	NO
4	EFFECTIVE_PERIOD_NUM	NUMBER	NO
5	PERIOD_STATUS	VARCHAR2(20)	SI
6	START_DATE	DATE	NO
7	END_DATE	DATE	NO
8	ADD_ATT1	VARCHAR2(150)	SI
9	ADD_ATT2	VARCHAR2(150)	SI
10	ADD_ATT3	VARCHAR2(150)	SI
11	ADD_ATT4	VARCHAR2(150)	SI
12	ADD_ATT5	VARCHAR2(150)	SI
13	ADD_ATT6	VARCHAR2(150)	SI
14	ADD_ATT7	VARCHAR2(150)	SI
15	ADD_ATT8	VARCHAR2(150)	SI
16	ADD_ATT9	VARCHAR2(150)	SI
17	ADD_ATT10	VARCHAR2(150)	SI
18	ADD_ATT11	VARCHAR2(150)	SI
19	ADD_ATT12	VARCHAR2(150)	SI
20	ADD_ATT13	VARCHAR2(150)	SI
21	ADD_ATT14	VARCHAR2(150)	SI
22	ADD_ATT15	VARCHAR2(150)	SI
23	CREATION_DATE	DATE	SI
24	CREATED_BY	VARCHAR2(64)	SI
25	LAST_UPDATE_DATE	DATE	SI
26	LAST_UPDATED_BY	VARCHAR2(64)	SI
27	LAST_UPDATE_LOGIN	VARCHAR2(32)	SI

Restricciones

CHECK: SYS_C0014590

• Estado: ENABLED
• Columnas: LEDGER_ID
• Condición: "LEDGER_ID" IS NOT NULL

CHECK: SYS_C0014591

• Estado: ENABLED
• Columnas: PERIOD_NAME
• Condición: "PERIOD_NAME" IS NOT NULL

CHECK: SYS_C0014592

• Estado: ENABLED
• Columnas: PERIOD_SET_NAME
• Condición: "PERIOD_SET_NAME" IS NOT NULL

CHECK: SYS_C0014593

• Estado: ENABLED
• Columnas: EFFECTIVE_PERIOD_NUM
• Condición: "EFFECTIVE_PERIOD_NUM" IS NOT NULL

CHECK: SYS_C0014594

• Estado: ENABLED
• Columnas: START_DATE
• Condición: "START_DATE" IS NOT NULL

CHECK: SYS_C0014595

• Estado: ENABLED
• Columnas: END_DATE
• Condición: "END_DATE" IS NOT NULL

DDL

CREATE TABLE "LACLS"."LACLS_CO_PERIODS" 
   (	"LEDGER_ID" NUMBER NOT NULL ENABLE, 
	"PERIOD_NAME" VARCHAR2(15) NOT NULL ENABLE, 
	"PERIOD_SET_NAME" VARCHAR2(15) NOT NULL ENABLE, 
	"EFFECTIVE_PERIOD_NUM" NUMBER NOT NULL ENABLE, 
	"PERIOD_STATUS" VARCHAR2(20), 
	"START_DATE" DATE NOT NULL ENABLE, 
	"END_DATE" DATE NOT NULL ENABLE, 
	"ADD_ATT1" VARCHAR2(150), 
	"ADD_ATT2" VARCHAR2(150), 
	"ADD_ATT3" VARCHAR2(150), 
	"ADD_ATT4" VARCHAR2(150), 
	"ADD_ATT5" VARCHAR2(150), 
	"ADD_ATT6" VARCHAR2(150), 
	"ADD_ATT7" VARCHAR2(150), 
	"ADD_ATT8" VARCHAR2(150), 
	"ADD_ATT9" VARCHAR2(150), 
	"ADD_ATT10" VARCHAR2(150), 
	"ADD_ATT11" VARCHAR2(150), 
	"ADD_ATT12" VARCHAR2(150), 
	"ADD_ATT13" VARCHAR2(150), 
	"ADD_ATT14" VARCHAR2(150), 
	"ADD_ATT15" VARCHAR2(150), 
	"CREATION_DATE" DATE, 
	"CREATED_BY" VARCHAR2(64), 
	"LAST_UPDATE_DATE" DATE, 
	"LAST_UPDATED_BY" VARCHAR2(64), 
	"LAST_UPDATE_LOGIN" VARCHAR2(32)
   ) ;

GRANT DELETE ON "LACLS"."LACLS_CO_PERIODS" TO "SOPORTE_COE";
  GRANT INSERT ON "LACLS"."LACLS_CO_PERIODS" TO "SOPORTE_COE";
  GRANT SELECT ON "LACLS"."LACLS_CO_PERIODS" TO "SOPORTE_COE";
  GRANT UPDATE ON "LACLS"."LACLS_CO_PERIODS" TO "SOPORTE_COE";

CREATE UNIQUE INDEX "LACLS"."LACLS_CO_PERIODS_U1" ON "LACLS"."LACLS_CO_PERIODS" ("LEDGER_ID", "PERIOD_NAME") 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_PERIODS_U2" ON "LACLS"."LACLS_CO_PERIODS" ("LEDGER_ID", "EFFECTIVE_PERIOD_NUM") 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_PERIODS_N1" ON "LACLS"."LACLS_CO_PERIODS" ("START_DATE", "END_DATE") 
  ;

---

← Volver a tablas de LACLS

🏠 Volver al menú principal