🏠 Menú principal

← Volver a tablas

---

LACLS.LACLS_CO_PARTY_PARAMS

Base de datos origen: PDB1

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	PARTY_PARAMS_ID	NUMBER	NO
2	NAME_FLOW	VARCHAR2(240)	NO
3	LEDGER_ID	NUMBER	NO
4	PERIOD_NAME	VARCHAR2(15)	SI
5	START_DATE	DATE	NO
6	END_DATE	DATE	SI
7	ENABLED_FLAG	VARCHAR2(1)	NO
8	CREATION_DATE	DATE	NO
9	CREATED_BY	VARCHAR2(65)	NO
10	LAST_UPDATE_DATE	DATE	NO
11	LAST_UPDATED_BY	VARCHAR2(65)	NO
12	PERIOD_NAME_FROM	VARCHAR2(15)	SI
13	PERIOD_NAME_TO	VARCHAR2(15)	SI

Restricciones

CHECK: SYS_C0014576

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

CHECK: SYS_C0014577

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

CHECK: SYS_C0014578

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

CHECK: SYS_C0014579

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

CHECK: SYS_C0014580

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

CHECK: SYS_C0014581

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

CHECK: SYS_C0014582

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

CHECK: SYS_C0014583

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

CHECK: SYS_C0014584

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

PK: LACLS_CO_PARTY_PARAMS_PK

• Estado: ENABLED
• Columnas: PARTY_PARAMS_ID

DDL

CREATE TABLE "LACLS"."LACLS_CO_PARTY_PARAMS" 
   (	"PARTY_PARAMS_ID" NUMBER NOT NULL ENABLE, 
	"NAME_FLOW" VARCHAR2(240) NOT NULL ENABLE, 
	"LEDGER_ID" NUMBER NOT NULL ENABLE, 
	"PERIOD_NAME" VARCHAR2(15), 
	"START_DATE" DATE NOT NULL ENABLE, 
	"END_DATE" DATE, 
	"ENABLED_FLAG" VARCHAR2(1) NOT NULL ENABLE, 
	"CREATION_DATE" DATE NOT NULL ENABLE, 
	"CREATED_BY" VARCHAR2(65) NOT NULL ENABLE, 
	"LAST_UPDATE_DATE" DATE NOT NULL ENABLE, 
	"LAST_UPDATED_BY" VARCHAR2(65) NOT NULL ENABLE, 
	"PERIOD_NAME_FROM" VARCHAR2(15), 
	"PERIOD_NAME_TO" VARCHAR2(15), 
	 CONSTRAINT "LACLS_CO_PARTY_PARAMS_PK" PRIMARY KEY ("PARTY_PARAMS_ID")
  USING INDEX  ENABLE
   ) ;

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

CREATE UNIQUE INDEX "LACLS"."LACLS_CO_PARTY_PARAMS_PK" ON "LACLS"."LACLS_CO_PARTY_PARAMS" ("PARTY_PARAMS_ID") 
  ;

---

← Volver a tablas de LACLS

🏠 Volver al menú principal