🏠 Menú principal

← Volver a tablas

---

LACLS.LACLS_CO_PARTY_BALANCES

Base de datos origen: PDB1

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	BALANCE_ID	NUMBER	NO
2	PERIOD_NAME	VARCHAR2(15)	NO
3	LEDGER_ID	NUMBER	NO
4	PARTY_ID	NUMBER	NO
5	BSV_VALUE	VARCHAR2(40)	NO
6	ACCOUNT_NUMBER	VARCHAR2(40)	NO
7	BEGIN_BALANCE	NUMBER	SI
8	ACCOUNTED_DR	NUMBER	SI
9	ACCOUNTED_CR	NUMBER	SI
10	END_BALANCE	NUMBER	SI
11	CODE_COMBINATION_ID	NUMBER	NO
12	SOURCE	VARCHAR2(20)	SI
13	THIRD_PARTY_NIT_SOURCE	VARCHAR2(40)	SI
14	CREATION_DATE	DATE	SI
15	CREATED_BY	VARCHAR2(64)	SI
16	LAST_UPDATE_DATE	DATE	SI
17	LAST_UPDATED_BY	VARCHAR2(64)	SI
18	LAST_UPDATE_LOGIN	VARCHAR2(32)	SI

Restricciones

CHECK: SYS_C0014521

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

CHECK: SYS_C0014522

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

CHECK: SYS_C0014523

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

CHECK: SYS_C0014524

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

CHECK: SYS_C0014525

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

CHECK: SYS_C0014526

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

CHECK: SYS_C0014527

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

PK: LACLS_CO_PARTY_BALANCES_PK

• Estado: ENABLED
• Columnas: BALANCE_ID

DDL

CREATE TABLE "LACLS"."LACLS_CO_PARTY_BALANCES" 
   (	"BALANCE_ID" NUMBER NOT NULL ENABLE, 
	"PERIOD_NAME" VARCHAR2(15) NOT NULL ENABLE, 
	"LEDGER_ID" NUMBER NOT NULL ENABLE, 
	"PARTY_ID" NUMBER NOT NULL ENABLE, 
	"BSV_VALUE" VARCHAR2(40) NOT NULL ENABLE, 
	"ACCOUNT_NUMBER" VARCHAR2(40) NOT NULL ENABLE, 
	"BEGIN_BALANCE" NUMBER, 
	"ACCOUNTED_DR" NUMBER, 
	"ACCOUNTED_CR" NUMBER, 
	"END_BALANCE" NUMBER, 
	"CODE_COMBINATION_ID" NUMBER NOT NULL ENABLE, 
	"SOURCE" VARCHAR2(20), 
	"THIRD_PARTY_NIT_SOURCE" VARCHAR2(40), 
	"CREATION_DATE" DATE, 
	"CREATED_BY" VARCHAR2(64), 
	"LAST_UPDATE_DATE" DATE, 
	"LAST_UPDATED_BY" VARCHAR2(64), 
	"LAST_UPDATE_LOGIN" VARCHAR2(32), 
	 CONSTRAINT "LACLS_CO_PARTY_BALANCES_PK" PRIMARY KEY ("BALANCE_ID")
  USING INDEX  ENABLE
   ) ;

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

CREATE UNIQUE INDEX "LACLS"."LACLS_CO_PARTY_BALANCES_PK" ON "LACLS"."LACLS_CO_PARTY_BALANCES" ("BALANCE_ID") 
  ;
  CREATE UNIQUE INDEX "LACLS"."LACLS_CO_PARTY_BALANCES_U0" ON "LACLS"."LACLS_CO_PARTY_BALANCES" ("PERIOD_NAME", "LEDGER_ID", "PARTY_ID", "CODE_COMBINATION_ID") 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_PARTY_BALANCES_N1" ON "LACLS"."LACLS_CO_PARTY_BALANCES" ("LEDGER_ID", "PERIOD_NAME", "BSV_VALUE", "ACCOUNT_NUMBER", "PARTY_ID") 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_PARTY_BALANCES_N2" ON "LACLS"."LACLS_CO_PARTY_BALANCES" ("LEDGER_ID", "PERIOD_NAME") 
  ;

---

← Volver a tablas de LACLS

🏠 Volver al menú principal