🏠 Menú principal

← Volver a tablas

---

LACLS.LACLS_CO_MM_BALANCES

Base de datos origen: PDB1

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	BAL_LINE_ID	NUMBER	SI
2	HEADER_ID	NUMBER	SI
3	REPORTED_YEAR	NUMBER	SI
4	COMPANY_ID	NUMBER	SI
5	COMPANY_CODE	VARCHAR2(10)	SI
6	CREATED_BY	NUMBER	NO
7	CREATION_DATE	DATE	NO
8	LAST_UPDATED_BY	NUMBER	NO
9	LAST_UPDATE_DATE	DATE	NO
10	LAST_UPDATE_LOGIN	NUMBER	SI
11	FORMAT_CODE	VARCHAR2(30)	SI
12	CONCEPT_ID	NUMBER	SI
13	DOCUMENT_TYPE	VARCHAR2(30)	SI
14	NIT_CODE	VARCHAR2(30)	SI
15	NIT_VD	VARCHAR2(5)	SI
16	LAST_NAME1	VARCHAR2(100)	SI
17	LAST_NAME2	VARCHAR2(100)	SI
18	FIRST_NAME	VARCHAR2(100)	SI
19	SECOND_NAME	VARCHAR2(100)	SI
20	PARTY_NAME	VARCHAR2(200)	SI
21	ADDRESS	VARCHAR2(200)	SI
22	DEPT_CODE	VARCHAR2(10)	SI
23	CITY_CODE	VARCHAR2(10)	SI
24	COUNTRY_CODE	VARCHAR2(10)	SI
25	FIRST_VALUE	NUMBER	SI
26	SECOND_VALUE	NUMBER	SI
27	THIRD_VALUE	NUMBER	SI
28	ORIGIN_SYSTEM	VARCHAR2(10)	SI
29	FIRST_VALUE_OLD	NUMBER	SI
30	SECOND_VALUE_OLD	NUMBER	SI
31	THIRD_VALUE_OLD	NUMBER	SI
32	REPORTED_VALUE_1	NUMBER	SI
33	REPORTED_VALUE_2	NUMBER	SI
34	REPORTED_VALUE_3	NUMBER	SI
35	REPORTED_VALUE_4	NUMBER	SI
36	REPORTED_VALUE_5	NUMBER	SI
37	REPORTED_VALUE_6	NUMBER	SI
38	REPORTED_VALUE_7	NUMBER	SI
39	REPORTED_VALUE_8	NUMBER	SI
40	REPORTED_VALUE_9	NUMBER	SI
41	FORMAT_ID	NUMBER	SI

Restricciones

CHECK: SYS_C0014562

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

CHECK: SYS_C0014563

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

CHECK: SYS_C0014564

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

CHECK: SYS_C0014565

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

DDL

CREATE TABLE "LACLS"."LACLS_CO_MM_BALANCES" 
   (	"BAL_LINE_ID" NUMBER, 
	"HEADER_ID" NUMBER, 
	"REPORTED_YEAR" NUMBER, 
	"COMPANY_ID" NUMBER, 
	"COMPANY_CODE" VARCHAR2(10), 
	"CREATED_BY" NUMBER NOT NULL ENABLE, 
	"CREATION_DATE" DATE NOT NULL ENABLE, 
	"LAST_UPDATED_BY" NUMBER NOT NULL ENABLE, 
	"LAST_UPDATE_DATE" DATE NOT NULL ENABLE, 
	"LAST_UPDATE_LOGIN" NUMBER, 
	"FORMAT_CODE" VARCHAR2(30), 
	"CONCEPT_ID" NUMBER, 
	"DOCUMENT_TYPE" VARCHAR2(30), 
	"NIT_CODE" VARCHAR2(30), 
	"NIT_VD" VARCHAR2(5), 
	"LAST_NAME1" VARCHAR2(100), 
	"LAST_NAME2" VARCHAR2(100), 
	"FIRST_NAME" VARCHAR2(100), 
	"SECOND_NAME" VARCHAR2(100), 
	"PARTY_NAME" VARCHAR2(200), 
	"ADDRESS" VARCHAR2(200), 
	"DEPT_CODE" VARCHAR2(10), 
	"CITY_CODE" VARCHAR2(10), 
	"COUNTRY_CODE" VARCHAR2(10), 
	"FIRST_VALUE" NUMBER, 
	"SECOND_VALUE" NUMBER, 
	"THIRD_VALUE" NUMBER, 
	"ORIGIN_SYSTEM" VARCHAR2(10), 
	"FIRST_VALUE_OLD" NUMBER, 
	"SECOND_VALUE_OLD" NUMBER, 
	"THIRD_VALUE_OLD" NUMBER, 
	"REPORTED_VALUE_1" NUMBER, 
	"REPORTED_VALUE_2" NUMBER, 
	"REPORTED_VALUE_3" NUMBER, 
	"REPORTED_VALUE_4" NUMBER, 
	"REPORTED_VALUE_5" NUMBER, 
	"REPORTED_VALUE_6" NUMBER, 
	"REPORTED_VALUE_7" NUMBER, 
	"REPORTED_VALUE_8" NUMBER, 
	"REPORTED_VALUE_9" NUMBER, 
	"FORMAT_ID" NUMBER
   ) ;

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

CREATE UNIQUE INDEX "LACLS"."LACLS_CO_MM_BALANCES_U1" ON "LACLS"."LACLS_CO_MM_BALANCES" ("BAL_LINE_ID") 
  ;

---

← Volver a tablas de LACLS

🏠 Volver al menú principal