🏠 Menú principal

← Volver a tablas

---

LACLS.LACLS_CO_GL_HEADERS

Base de datos origen: PDB1

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	JE_HEADER_ID	NUMBER(18,0)	NO
2	LEDGER_ID	NUMBER(18,0)	NO
3	JE_CATEGORY	VARCHAR2(25)	NO
4	JE_SOURCE	VARCHAR2(25)	NO
5	PERIOD_NAME	VARCHAR2(15)	NO
6	NAME	VARCHAR2(100)	SI
7	CURRENCY_CODE	VARCHAR2(15)	SI
8	STATUS	VARCHAR2(20)	SI
9	DEFAULT_EFFECTIVE_DATE	DATE	NO
10	BALANCING_SEGMENT_VALUE	VARCHAR2(25)	SI
11	JE_BATCH_ID	NUMBER(18,0)	SI
12	POSTED_DATE	DATE	SI
13	RUNNING_TOTAL_DR	NUMBER	SI
14	RUNNING_TOTAL_CR	NUMBER	SI
15	RUNNING_TOTAL_ACCOUNTED_DR	NUMBER	SI
16	RUNNING_TOTAL_ACCOUNTED_CR	NUMBER	SI
17	CURRENCY_CONVERSION_RATE	NUMBER	SI
18	DOC_SEQUENCE_VALUE	NUMBER	SI
19	PARENT_JE_HEADER_ID	NUMBER(18,0)	SI
20	REVERSED_JE_HEADER_ID	NUMBER(18,0)	SI
21	JE_FROM_SLA_FLAG	VARCHAR2(1)	SI
22	ADD_ATT1	VARCHAR2(150)	SI
23	ADD_ATT2	VARCHAR2(150)	SI
24	ADD_ATT3	VARCHAR2(150)	SI
25	ADD_ATT4	VARCHAR2(150)	SI
26	ADD_ATT5	VARCHAR2(150)	SI
27	ADD_ATT6	VARCHAR2(150)	SI
28	ADD_ATT7	VARCHAR2(150)	SI
29	ADD_ATT8	VARCHAR2(150)	SI
30	ADD_ATT9	VARCHAR2(150)	SI
31	ADD_ATT10	VARCHAR2(150)	SI
32	ADD_ATT11	VARCHAR2(150)	SI
33	ADD_ATT12	VARCHAR2(150)	SI
34	ADD_ATT13	VARCHAR2(150)	SI
35	ADD_ATT14	VARCHAR2(150)	SI
36	ADD_ATT15	VARCHAR2(150)	SI
37	CREATION_DATE	DATE	SI
38	CREATED_BY	VARCHAR2(64)	SI
39	LAST_UPDATE_DATE	DATE	SI
40	LAST_UPDATED_BY	VARCHAR2(64)	SI
41	LAST_UPDATE_LOGIN	VARCHAR2(32)	SI
42	ACCOUNTING_ENTRY_TYPE_CODE	VARCHAR2(30)	SI

Restricciones

CHECK: SYS_C0014552

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

CHECK: SYS_C0014553

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

CHECK: SYS_C0014554

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

CHECK: SYS_C0014555

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

CHECK: SYS_C0014556

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

CHECK: SYS_C0014557

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

DDL

CREATE TABLE "LACLS"."LACLS_CO_GL_HEADERS" 
   (	"JE_HEADER_ID" NUMBER(18,0) NOT NULL ENABLE, 
	"LEDGER_ID" NUMBER(18,0) NOT NULL ENABLE, 
	"JE_CATEGORY" VARCHAR2(25) NOT NULL ENABLE, 
	"JE_SOURCE" VARCHAR2(25) NOT NULL ENABLE, 
	"PERIOD_NAME" VARCHAR2(15) NOT NULL ENABLE, 
	"NAME" VARCHAR2(100), 
	"CURRENCY_CODE" VARCHAR2(15), 
	"STATUS" VARCHAR2(20), 
	"DEFAULT_EFFECTIVE_DATE" DATE NOT NULL ENABLE, 
	"BALANCING_SEGMENT_VALUE" VARCHAR2(25), 
	"JE_BATCH_ID" NUMBER(18,0), 
	"POSTED_DATE" DATE, 
	"RUNNING_TOTAL_DR" NUMBER, 
	"RUNNING_TOTAL_CR" NUMBER, 
	"RUNNING_TOTAL_ACCOUNTED_DR" NUMBER, 
	"RUNNING_TOTAL_ACCOUNTED_CR" NUMBER, 
	"CURRENCY_CONVERSION_RATE" NUMBER, 
	"DOC_SEQUENCE_VALUE" NUMBER, 
	"PARENT_JE_HEADER_ID" NUMBER(18,0), 
	"REVERSED_JE_HEADER_ID" NUMBER(18,0), 
	"JE_FROM_SLA_FLAG" VARCHAR2(1), 
	"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), 
	"ACCOUNTING_ENTRY_TYPE_CODE" VARCHAR2(30)
   ) ;

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

CREATE UNIQUE INDEX "LACLS"."LACLS_CO_GL_HEADERS_U1" ON "LACLS"."LACLS_CO_GL_HEADERS" ("JE_HEADER_ID") 
  ;
  CREATE UNIQUE INDEX "LACLS"."LACLS_CO_GL_HEADERS_U2" ON "LACLS"."LACLS_CO_GL_HEADERS" ("LEDGER_ID", "JE_HEADER_ID", "PERIOD_NAME") 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_GL_HEADERS_N1" ON "LACLS"."LACLS_CO_GL_HEADERS" ("JE_BATCH_ID") 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_GL_HEADERS_N2" ON "LACLS"."LACLS_CO_GL_HEADERS" ("LEDGER_ID", "PERIOD_NAME", "JE_SOURCE", "JE_CATEGORY") 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_GL_HEADERS_N3" ON "LACLS"."LACLS_CO_GL_HEADERS" ("LEDGER_ID", "PERIOD_NAME", "STATUS") 
  ;
  CREATE INDEX "LACLS"."ILACLS_CO_GL_HEADERS_N4" ON "LACLS"."LACLS_CO_GL_HEADERS" ("PERIOD_NAME", "LEDGER_ID", "REVERSED_JE_HEADER_ID", "JE_HEADER_ID") 
  ;
  CREATE INDEX "LACLS"."IDX_LACLS_GL_HDR" ON "LACLS"."LACLS_CO_GL_HEADERS" ("LEDGER_ID", "PERIOD_NAME", "STATUS", "JE_SOURCE") 
  ;

---

← Volver a tablas de LACLS

🏠 Volver al menú principal