🏠 Menú principal

← Volver a tablas

---

LACLS.LACLS_CO_PARTY_JOURNALS

Base de datos origen: PDB1

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	JOURNAL_ID	NUMBER	NO
2	PERIOD_NAME	VARCHAR2(15)	NO
3	LEDGER_ID	NUMBER	NO
4	PARTY_ID	NUMBER	NO
5	JE_SOURCE	VARCHAR2(25)	NO
6	JE_CATEGORY	VARCHAR2(25)	NO
7	SOURCE_ID	NUMBER	SI
8	BSV_VALUE	VARCHAR2(40)	NO
9	ACCOUNT_NUMBER	VARCHAR2(40)	NO
10	CODE_COMBINATION_ID	NUMBER	SI
11	ACCOUNTING_DATE	DATE	NO
12	LINE_DESCRIPTION	VARCHAR2(240)	SI
13	ACCOUNTED_DR	NUMBER	SI
14	ACCOUNTED_CR	NUMBER	SI
15	LINE_TYPE_LOOKUP_CODE	VARCHAR2(50)	SI
16	GROSS_AMOUNT	NUMBER	SI
17	GL_SL_LINK_ID	NUMBER	SI
18	JE_HEADER_ID	NUMBER	SI
19	JE_LINE_NUM	NUMBER	SI
20	ADD_ATT1	VARCHAR2(150)	SI
21	ADD_ATT2	VARCHAR2(150)	SI
22	ADD_ATT3	VARCHAR2(150)	SI
23	ADD_ATT4	VARCHAR2(150)	SI
24	ADD_ATT5	VARCHAR2(150)	SI
25	ADD_ATT6	VARCHAR2(150)	SI
26	ADD_ATT7	VARCHAR2(150)	SI
27	ADD_ATT8	VARCHAR2(150)	SI
28	ADD_ATT9	VARCHAR2(150)	SI
29	ADD_ATT10	VARCHAR2(150)	SI
30	ADD_ATT11	VARCHAR2(150)	SI
31	ADD_ATT12	VARCHAR2(150)	SI
32	ADD_ATT13	VARCHAR2(150)	SI
33	ADD_ATT14	VARCHAR2(150)	SI
34	ADD_ATT15	VARCHAR2(150)	SI
35	CREATION_DATE	DATE	SI
36	CREATED_BY	VARCHAR2(64)	SI
37	LAST_UPDATE_DATE	DATE	SI
38	LAST_UPDATED_BY	VARCHAR2(64)	SI
39	LAST_UPDATE_LOGIN	VARCHAR2(32)	SI

Restricciones

CHECK: SYS_C0014512

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

CHECK: SYS_C0014513

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

CHECK: SYS_C0014514

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

CHECK: SYS_C0014515

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

CHECK: SYS_C0014516

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

CHECK: SYS_C0014517

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

CHECK: SYS_C0014518

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

CHECK: SYS_C0014519

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

CHECK: SYS_C0014520

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

DDL

CREATE TABLE "LACLS"."LACLS_CO_PARTY_JOURNALS" 
   (	"JOURNAL_ID" NUMBER NOT NULL ENABLE, 
	"PERIOD_NAME" VARCHAR2(15) NOT NULL ENABLE, 
	"LEDGER_ID" NUMBER NOT NULL ENABLE, 
	"PARTY_ID" NUMBER NOT NULL ENABLE, 
	"JE_SOURCE" VARCHAR2(25) NOT NULL ENABLE, 
	"JE_CATEGORY" VARCHAR2(25) NOT NULL ENABLE, 
	"SOURCE_ID" NUMBER, 
	"BSV_VALUE" VARCHAR2(40) NOT NULL ENABLE, 
	"ACCOUNT_NUMBER" VARCHAR2(40) NOT NULL ENABLE, 
	"CODE_COMBINATION_ID" NUMBER, 
	"ACCOUNTING_DATE" DATE NOT NULL ENABLE, 
	"LINE_DESCRIPTION" VARCHAR2(240), 
	"ACCOUNTED_DR" NUMBER, 
	"ACCOUNTED_CR" NUMBER, 
	"LINE_TYPE_LOOKUP_CODE" VARCHAR2(50), 
	"GROSS_AMOUNT" NUMBER, 
	"GL_SL_LINK_ID" NUMBER, 
	"JE_HEADER_ID" NUMBER, 
	"JE_LINE_NUM" NUMBER, 
	"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)
   ) ;

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

CREATE INDEX "LACLS"."LACLS_CO_PARTY_JOURNALS_N0" ON "LACLS"."LACLS_CO_PARTY_JOURNALS" ("JOURNAL_ID") 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_PARTY_JOURNALS_N1" ON "LACLS"."LACLS_CO_PARTY_JOURNALS" ("LEDGER_ID", "PERIOD_NAME", "BSV_VALUE", "ACCOUNT_NUMBER", "PARTY_ID") 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_PARTY_JOURNALS_N2" ON "LACLS"."LACLS_CO_PARTY_JOURNALS" ("LEDGER_ID", "PERIOD_NAME") 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_PARTY_JOURNALS_N4" ON "LACLS"."LACLS_CO_PARTY_JOURNALS" ("LEDGER_ID", "GL_SL_LINK_ID") 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_PARTY_JOURNALS_N6" ON "LACLS"."LACLS_CO_PARTY_JOURNALS" ("LEDGER_ID", "PERIOD_NAME", "JE_HEADER_ID", "JE_LINE_NUM") 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_PARTY_JOURNALS_N9" ON "LACLS"."LACLS_CO_PARTY_JOURNALS" (NVL("ACCOUNTED_CR",0)-NVL("ACCOUNTED_DR",0)) 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_PARTY_JOURNALS_N7" ON "LACLS"."LACLS_CO_PARTY_JOURNALS" ("JE_HEADER_ID", "PARTY_ID") 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_PARTY_JOURNALS_N10" ON "LACLS"."LACLS_CO_PARTY_JOURNALS" ("JE_HEADER_ID") 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_PARTY_JOURNALS_N8" ON "LACLS"."LACLS_CO_PARTY_JOURNALS" ("PERIOD_NAME", "LEDGER_ID", "CODE_COMBINATION_ID") 
  ;

---

← Volver a tablas de LACLS

🏠 Volver al menú principal