🏠 Menú principal

← Volver a tablas

---

LACLS.LACLS_CO_REPORT_BALANCES_GT

Base de datos origen: PDB1

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	BALANCE_ID	NUMBER	NO
2	PERIOD_NAME	VARCHAR2(15)	SI
3	EFFECTIVE_PERIOD_NUM	NUMBER	SI
4	LEDGER_ID	NUMBER	SI
5	CHART_OF_ACCOUNTS_ID	NUMBER(18,0)	SI
6	PARTY_ID	NUMBER	SI
7	BSV_VALUE	VARCHAR2(40)	SI
8	ACCOUNT_NUMBER	VARCHAR2(40)	SI
9	ACCOUNT_CONCATENATED	VARCHAR2(4000)	SI
10	BEGIN_BALANCE	NUMBER	SI
11	ACCOUNTED_DR	NUMBER	SI
12	ACCOUNTED_CR	NUMBER	SI
13	END_BALANCE	NUMBER	SI
14	CODE_COMBINATION_ID	NUMBER	SI
15	SOURCE	VARCHAR2(20)	SI
16	THIRD_PARTY_NIT_SOURCE	VARCHAR2(40)	SI

Restricciones

CHECK: SYS_C0014622

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

DDL

CREATE GLOBAL TEMPORARY TABLE "LACLS"."LACLS_CO_REPORT_BALANCES_GT" 
   (	"BALANCE_ID" NUMBER NOT NULL ENABLE, 
	"PERIOD_NAME" VARCHAR2(15), 
	"EFFECTIVE_PERIOD_NUM" NUMBER, 
	"LEDGER_ID" NUMBER, 
	"CHART_OF_ACCOUNTS_ID" NUMBER(18,0), 
	"PARTY_ID" NUMBER, 
	"BSV_VALUE" VARCHAR2(40), 
	"ACCOUNT_NUMBER" VARCHAR2(40), 
	"ACCOUNT_CONCATENATED" VARCHAR2(4000), 
	"BEGIN_BALANCE" NUMBER, 
	"ACCOUNTED_DR" NUMBER, 
	"ACCOUNTED_CR" NUMBER, 
	"END_BALANCE" NUMBER, 
	"CODE_COMBINATION_ID" NUMBER, 
	"SOURCE" VARCHAR2(20), 
	"THIRD_PARTY_NIT_SOURCE" VARCHAR2(40)
   ) ON COMMIT PRESERVE ROWS ;

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

CREATE UNIQUE INDEX "LACLS"."LACLS_CO_REPORT_BALANCES_GT_N0" ON "LACLS"."LACLS_CO_REPORT_BALANCES_GT" ("BALANCE_ID", "LEDGER_ID", "PERIOD_NAME", "PARTY_ID", "CODE_COMBINATION_ID") ;
  CREATE INDEX "LACLS"."LACLS_CO_REPORT_BALANCES_GT_N1" ON "LACLS"."LACLS_CO_REPORT_BALANCES_GT" ("LEDGER_ID", "PERIOD_NAME", "BSV_VALUE", "ACCOUNT_NUMBER", "PARTY_ID") ;
  CREATE INDEX "LACLS"."LACLS_CO_REPORT_BALANCES_GT_N2" ON "LACLS"."LACLS_CO_REPORT_BALANCES_GT" ("LEDGER_ID", "PERIOD_NAME") ;

---

← Volver a tablas de LACLS

🏠 Volver al menú principal