🏠 Menú principal

← Volver a tablas

---

DWADW.DW_ARLINES

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	TRXLINEID	NUMBER	NO
2	LINECUSTOMERTRXID	NUMBER	NO
3	SOLDTOCUSTACCOUNTID	NUMBER	NO
4	SOLDTOCUSTACCTPARTYID	NUMBER	NO
5	SOLDTOPARTYSITEPARTYSITEID	NUMBER	SI
6	LINE_DESCRIPTION	VARCHAR2(2000)	SI
7	GROSS_UNIT_SELLING_PRICE	NUMBER	SI
8	LINE_NUMBER	NUMBER	SI
9	LINE_TYPE	VARCHAR2(80)	SI
10	PRODUCT_TYPE	VARCHAR2(80)	SI
11	QUANTITY_CREDITED	NUMBER	SI
12	QUANTITY_INVOICED	NUMBER	SI
13	QUANTITY_ORDERED	NUMBER	SI
14	REVENUE_AMOUNT	NUMBER	SI
15	TRX_NUMBER_DATE	DATE	SI
16	SALES_ORDER	VARCHAR2(30)	SI
17	SALES_ORDER_DATE	DATE	SI
18	SALES_ORDER_LINE	NUMBER	SI
19	UNIT_STANDARD_PRICE	NUMBER	SI
20	UOM_CODE	VARCHAR2(30)	SI
21	LINEINVENTORYITEMID	NUMBER	SI
22	LINEWAREHOUSEID	NUMBER	SI
23	CUSTTRXLINEGLDISTID	NUMBER	SI
24	CODECOMBINATIONID	NUMBER	SI
25	EXCHANGE_RATE	NUMBER	SI
26	INVOICE_CURRENCY_CODE	VARCHAR2(30)	SI
27	EXCHANGE_DATE	DATE	SI
28	DISTRIBUTION_GL_DATE	DATE	SI
29	DISTRIBUTION_ORIGINAL_GL_DATE	DATE	SI
30	ACCOUNTED_AMOUNT	NUMBER	SI

Restricciones

CHECK: SYS_C0024698

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

CHECK: SYS_C0024699

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

CHECK: SYS_C0024700

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

CHECK: SYS_C0024701

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

PK: SYS_C0024702

• Estado: ENABLED
• Columnas: LINECUSTOMERTRXID

DDL

CREATE TABLE "DWADW"."DW_ARLINES" 
   (	"TRXLINEID" NUMBER(*,0) NOT NULL ENABLE, 
	"LINECUSTOMERTRXID" NUMBER(*,0) NOT NULL ENABLE, 
	"SOLDTOCUSTACCOUNTID" NUMBER(*,0) NOT NULL ENABLE, 
	"SOLDTOCUSTACCTPARTYID" NUMBER(*,0) NOT NULL ENABLE, 
	"SOLDTOPARTYSITEPARTYSITEID" NUMBER(*,0), 
	"LINE_DESCRIPTION" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"GROSS_UNIT_SELLING_PRICE" NUMBER(*,0), 
	"LINE_NUMBER" NUMBER(*,0), 
	"LINE_TYPE" VARCHAR2(80) COLLATE "USING_NLS_COMP", 
	"PRODUCT_TYPE" VARCHAR2(80) COLLATE "USING_NLS_COMP", 
	"QUANTITY_CREDITED" NUMBER(*,0), 
	"QUANTITY_INVOICED" NUMBER(*,0), 
	"QUANTITY_ORDERED" NUMBER(*,0), 
	"REVENUE_AMOUNT" NUMBER(*,0), 
	"TRX_NUMBER_DATE" DATE, 
	"SALES_ORDER" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"SALES_ORDER_DATE" DATE, 
	"SALES_ORDER_LINE" NUMBER(*,0), 
	"UNIT_STANDARD_PRICE" NUMBER(*,0), 
	"UOM_CODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"LINEINVENTORYITEMID" NUMBER(*,0), 
	"LINEWAREHOUSEID" NUMBER(*,0), 
	"CUSTTRXLINEGLDISTID" NUMBER(*,0), 
	"CODECOMBINATIONID" NUMBER(*,0), 
	"EXCHANGE_RATE" NUMBER(*,0), 
	"INVOICE_CURRENCY_CODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"EXCHANGE_DATE" DATE, 
	"DISTRIBUTION_GL_DATE" DATE, 
	"DISTRIBUTION_ORIGINAL_GL_DATE" DATE, 
	"ACCOUNTED_AMOUNT" NUMBER(*,0), 
	 PRIMARY KEY ("LINECUSTOMERTRXID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

GRANT INDEX ON "DWADW"."DW_ARLINES" TO "BICC";
  GRANT REFERENCES ON "DWADW"."DW_ARLINES" TO "BICC";
  GRANT ON COMMIT REFRESH ON "DWADW"."DW_ARLINES" TO "BICC";
  GRANT QUERY REWRITE ON "DWADW"."DW_ARLINES" TO "BICC";
  GRANT FLASHBACK ON "DWADW"."DW_ARLINES" TO "BICC";
  GRANT DELETE ON "DWADW"."DW_ARLINES" TO "BICC";
  GRANT INSERT ON "DWADW"."DW_ARLINES" TO "BICC";
  GRANT SELECT ON "DWADW"."DW_ARLINES" TO "BICC";
  GRANT UPDATE ON "DWADW"."DW_ARLINES" TO "BICC";
  GRANT ALTER ON "DWADW"."DW_ARLINES" TO "BICC";
  GRANT SELECT ON "DWADW"."DW_ARLINES" TO "POWER_BI";
  GRANT DELETE ON "DWADW"."DW_ARLINES" TO "MANAGE_DW_ST";
  GRANT INSERT ON "DWADW"."DW_ARLINES" TO "MANAGE_DW_ST";
  GRANT SELECT ON "DWADW"."DW_ARLINES" TO "MANAGE_DW_ST";
  GRANT UPDATE ON "DWADW"."DW_ARLINES" TO "MANAGE_DW_ST";
  GRANT ALTER ON "DWADW"."DW_ARLINES" TO "MANAGE_DW_ST";
  GRANT READ ON "DWADW"."DW_ARLINES" TO "MANAGE_DW_ST";
  GRANT DEBUG ON "DWADW"."DW_ARLINES" TO "MANAGE_DW_ST";
  GRANT READ ON "DWADW"."DW_ARLINES" TO "BICC";
  GRANT DEBUG ON "DWADW"."DW_ARLINES" TO "BICC";

CREATE UNIQUE INDEX "DWADW"."SYS_C0024702" ON "DWADW"."DW_ARLINES" ("LINECUSTOMERTRXID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal