🏠 Menú principal

← Volver a tablas

---

LACLS.LACLS_CO_PARTY_JOURNALS_ERROR

Base de datos origen: PDB1

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	PERIOD_NAME	VARCHAR2(15)	NO
2	LEDGER_ID	NUMBER	NO
3	JE_HEADER_ID	NUMBER	NO
4	JE_LINE_NUM	NUMBER	NO
5	JE_CATEGORY	VARCHAR2(25)	SI
6	JE_SOURCE	VARCHAR2(25)	SI
7	DESCRIPTION	VARCHAR2(2000)	SI
8	CODE_COMBINATION_ID	NUMBER	SI
9	ACCOUNTED_DR	NUMBER	SI
10	ACCOUNTED_CR	NUMBER	SI
11	SLA_AMOUNT_DR	NUMBER	SI
12	SLA_AMOUNT_CR	NUMBER	SI
13	CREATION_DATE	DATE	SI
14	CREATED_BY	NUMBER	SI
15	LAST_UPDATE_DATE	DATE	SI
16	LAST_UPDATED_BY	NUMBER	SI
17	LAST_UPDATE_LOGIN	NUMBER	SI

Restricciones

CHECK: SYS_C0014529

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

CHECK: SYS_C0014530

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

CHECK: SYS_C0014531

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

CHECK: SYS_C0014532

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

DDL

CREATE TABLE "LACLS"."LACLS_CO_PARTY_JOURNALS_ERROR" 
   (	"PERIOD_NAME" VARCHAR2(15) NOT NULL ENABLE, 
	"LEDGER_ID" NUMBER NOT NULL ENABLE, 
	"JE_HEADER_ID" NUMBER NOT NULL ENABLE, 
	"JE_LINE_NUM" NUMBER NOT NULL ENABLE, 
	"JE_CATEGORY" VARCHAR2(25), 
	"JE_SOURCE" VARCHAR2(25), 
	"DESCRIPTION" VARCHAR2(2000), 
	"CODE_COMBINATION_ID" NUMBER, 
	"ACCOUNTED_DR" NUMBER, 
	"ACCOUNTED_CR" NUMBER, 
	"SLA_AMOUNT_DR" NUMBER, 
	"SLA_AMOUNT_CR" NUMBER, 
	"CREATION_DATE" DATE, 
	"CREATED_BY" NUMBER, 
	"LAST_UPDATE_DATE" DATE, 
	"LAST_UPDATED_BY" NUMBER, 
	"LAST_UPDATE_LOGIN" NUMBER
   ) ;

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

---

← Volver a tablas de LACLS

🏠 Volver al menú principal