🏠 Menú principal

← Volver a tablas

---

LACLS.LACLS_CO_MM_LINES

Base de datos origen: PDB1

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	LINE_ID	NUMBER	NO
2	HEADER_ID	NUMBER	NO
3	FORMAT_ID	NUMBER	NO
4	CONCEPT_ID	NUMBER	NO
5	LEDGER_ID	NUMBER	SI
6	PERIOD_NAME	VARCHAR2(15)	NO
7	PARTY_ID	NUMBER	NO
8	CODE_COMBINATION_ID	NUMBER	SI
9	ORIGIN	VARCHAR2(10)	SI
10	SOURCE_ID	NUMBER	SI
11	CODE_COMBINATION_ID_RELATED	NUMBER	SI
12	ATTRIBUTE_CATEGORY	VARCHAR2(150)	SI
13	REPORTED_FLAG	VARCHAR2(1)	SI	‘Y’
14	LINE_TYPE_LOOKUP_CODE	VARCHAR2(50)	SI
15	TAX_TYPE	VARCHAR2(50)	SI
16	TAX_NAME	VARCHAR2(50)	SI
17	ACCOUNT_NUMBER_RELATED	VARCHAR2(40)	SI
18	CATEGORY	VARCHAR2(40)	SI
19	ACCOUNT_NUMBER	VARCHAR2(40)	SI
20	THIRD_PARTY_REPORT	VARCHAR2(30)	SI
21	REPORTED_VALUE_1	NUMBER	NO
22	REPORTED_VALUE_2	NUMBER	SI
23	REPORTED_VALUE_3	NUMBER	SI
24	REPORTED_VALUE_4	NUMBER	SI
25	REPORTED_VALUE_5	NUMBER	SI
26	REPORTED_VALUE_6	NUMBER	SI
27	REPORTED_VALUE_7	NUMBER	SI
28	REPORTED_VALUE_8	NUMBER	SI
29	REPORTED_VALUE_9	NUMBER	SI
30	REPORTED_VALUE_10	NUMBER	SI
31	REPORTED_VALUE_11	NUMBER	SI
32	REPORTED_VALUE_12	NUMBER	SI
33	REPORTED_VALUE_13	NUMBER	SI
34	REPORTED_VALUE_14	NUMBER	SI
35	REPORTED_VALUE_15	NUMBER	SI
36	REPORTED_VALUE_16	NUMBER	SI
37	REPORTED_VALUE_17	NUMBER	SI
38	REPORTED_VALUE_18	NUMBER	SI
39	REPORTED_VALUE_19	NUMBER	SI
40	REPORTED_VALUE_20	NUMBER	SI
41	CREATION_DATE	DATE	SI
42	CREATED_BY	VARCHAR2(64)	SI
43	LAST_UPDATE_DATE	DATE	SI
44	LAST_UPDATED_BY	VARCHAR2(64)	SI
45	LAST_UPDATE_LOGIN	VARCHAR2(32)	SI

Restricciones

CHECK: SYS_C0014606

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

CHECK: SYS_C0014607

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

CHECK: SYS_C0014608

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

CHECK: SYS_C0014609

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

CHECK: SYS_C0014610

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

CHECK: SYS_C0014611

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

CHECK: SYS_C0014612

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

DDL

CREATE TABLE "LACLS"."LACLS_CO_MM_LINES" 
   (	"LINE_ID" NUMBER NOT NULL ENABLE, 
	"HEADER_ID" NUMBER NOT NULL ENABLE, 
	"FORMAT_ID" NUMBER NOT NULL ENABLE, 
	"CONCEPT_ID" NUMBER NOT NULL ENABLE, 
	"LEDGER_ID" NUMBER, 
	"PERIOD_NAME" VARCHAR2(15) NOT NULL ENABLE, 
	"PARTY_ID" NUMBER NOT NULL ENABLE, 
	"CODE_COMBINATION_ID" NUMBER, 
	"ORIGIN" VARCHAR2(10), 
	"SOURCE_ID" NUMBER, 
	"CODE_COMBINATION_ID_RELATED" NUMBER, 
	"ATTRIBUTE_CATEGORY" VARCHAR2(150), 
	"REPORTED_FLAG" VARCHAR2(1) DEFAULT 'Y', 
	"LINE_TYPE_LOOKUP_CODE" VARCHAR2(50), 
	"TAX_TYPE" VARCHAR2(50), 
	"TAX_NAME" VARCHAR2(50), 
	"ACCOUNT_NUMBER_RELATED" VARCHAR2(40), 
	"CATEGORY" VARCHAR2(40), 
	"ACCOUNT_NUMBER" VARCHAR2(40), 
	"THIRD_PARTY_REPORT" VARCHAR2(30), 
	"REPORTED_VALUE_1" NUMBER NOT NULL ENABLE, 
	"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, 
	"REPORTED_VALUE_10" NUMBER, 
	"REPORTED_VALUE_11" NUMBER, 
	"REPORTED_VALUE_12" NUMBER, 
	"REPORTED_VALUE_13" NUMBER, 
	"REPORTED_VALUE_14" NUMBER, 
	"REPORTED_VALUE_15" NUMBER, 
	"REPORTED_VALUE_16" NUMBER, 
	"REPORTED_VALUE_17" NUMBER, 
	"REPORTED_VALUE_18" NUMBER, 
	"REPORTED_VALUE_19" NUMBER, 
	"REPORTED_VALUE_20" NUMBER, 
	"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_MM_LINES" TO "SOPORTE_COE";
  GRANT INSERT ON "LACLS"."LACLS_CO_MM_LINES" TO "SOPORTE_COE";
  GRANT SELECT ON "LACLS"."LACLS_CO_MM_LINES" TO "SOPORTE_COE";
  GRANT UPDATE ON "LACLS"."LACLS_CO_MM_LINES" TO "SOPORTE_COE";

CREATE UNIQUE INDEX "LACLS"."LACLS_CO_MM_LINES_U1" ON "LACLS"."LACLS_CO_MM_LINES" ("LINE_ID") 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_MM_LINES_N1" ON "LACLS"."LACLS_CO_MM_LINES" ("FORMAT_ID", "PARTY_ID", "CONCEPT_ID") 
  ;

---

← Volver a tablas de LACLS

🏠 Volver al menú principal