🏠 Menú principal

← Volver a tablas

---

DWADW.DIM_SUPPLIER_AP

Base de datos origen: ADW COEXITO

Descripción: Español: Catálogo maestro de proveedores utilizado para gestionar facturas, pagos y procesos de cuentas por pagar, incluyendo información fiscal, vendor_id y datos comerciales. English: Master supplier catalog used to manage invoices, payments, and Accounts Payable processes, including fiscal information, vendor_id, and commercial data.

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	SUPPLIER_AP_ID	NUMBER	NO	“DWADW”.”ISEQ$$_306887”.nextval
2	START_DATE	DATE	SI
3	PARTY_NAME	VARCHAR2(2000)	SI
4	PARTY_NUMBER	VARCHAR2(2000)	SI
5	COUNTRY_CODE	VARCHAR2(50)	SI
6	CLASSIFICATION_CODE	VARCHAR2(50)	SI
7	INV_DIST_AMOUNT	NUMBER	SI
8	RELATION_SHIP	VARCHAR2(50)	SI
9	CREATED_BY	VARCHAR2(100)	SI
10	CREATION_DATE	DATE	SI
11	CREATION_DATE_ONLY	DATE	SI
12	CREATION_SOURCE	VARCHAR2(100)	SI
13	REPORTABLE_FLAG	VARCHAR2(2)	SI
14	INV_DIST_HIERARCHY_AMOUNT	NUMBER	SI
15	DIST_VENDOR_ID	NUMBER	SI
16	LAST_UPDATE	DATE	SI
17	LAST_UPDATE_BY	VARCHAR2(50)	SI
18	ORG_LOOKUP_CODE	VARCHAR2(50)	SI
19	PARTY_ID	NUMBER	SI
20	SUPPLIER_SEGMENT1	VARCHAR2(50)	SI
21	SUPPLIER_PAYER_COUNTRY	VARCHAR2(10)	SI
22	SUPPLIER_LOOKUP_CODE	VARCHAR2(50)	SI
23	VENDORID	NUMBER	NO
24	FISCAL_CODE	VARCHAR2(100)	SI
25	TAXPAYER_ID	VARCHAR2(100)	SI
26	AUDIT_ID	NUMBER(18,0)	NO
27	ROW_ACTIVE	CHAR(1)	NO	‘A’

Restricciones

CHECK: DIM_SUPPLIER_AP_AI_CK

• Estado: ENABLED
• Columnas: ROW_ACTIVE
• Condición: row_active IN ('A','I')

CHECK: SYS_C00202851

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

CHECK: SYS_C00202852

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

CHECK: SYS_C00202853

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

CHECK: SYS_C00202854

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

PK: DIM_SUPPLIER_AP_PK

• Estado: ENABLED
• Columnas: SUPPLIER_AP_ID

UK: DIM_SUPPLIER_AP_VENDOR_UN

• Estado: ENABLED
• Columnas: VENDORID

DDL

CREATE TABLE "DWADW"."DIM_SUPPLIER_AP" 
   (	"SUPPLIER_AP_ID" NUMBER GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, 
	"START_DATE" DATE, 
	"PARTY_NAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"PARTY_NUMBER" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"COUNTRY_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"CLASSIFICATION_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"INV_DIST_AMOUNT" NUMBER(*,0), 
	"RELATION_SHIP" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"CREATED_BY" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"CREATION_DATE" DATE, 
	"CREATION_DATE_ONLY" DATE, 
	"CREATION_SOURCE" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"REPORTABLE_FLAG" VARCHAR2(2) COLLATE "USING_NLS_COMP", 
	"INV_DIST_HIERARCHY_AMOUNT" NUMBER(*,0), 
	"DIST_VENDOR_ID" NUMBER(*,0), 
	"LAST_UPDATE" DATE, 
	"LAST_UPDATE_BY" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"ORG_LOOKUP_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"PARTY_ID" NUMBER(*,0), 
	"SUPPLIER_SEGMENT1" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"SUPPLIER_PAYER_COUNTRY" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"SUPPLIER_LOOKUP_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"VENDORID" NUMBER(*,0) NOT NULL ENABLE, 
	"FISCAL_CODE" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"TAXPAYER_ID" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"AUDIT_ID" NUMBER(18,0) NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	 CONSTRAINT "DIM_SUPPLIER_AP_AI_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "DIM_SUPPLIER_AP_PK" PRIMARY KEY ("SUPPLIER_AP_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_SUPPLIER_AP_VENDOR_UN" UNIQUE ("VENDORID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."DIM_SUPPLIER_AP"  IS 'Español: Catálogo maestro de proveedores utilizado para gestionar facturas, pagos y procesos de cuentas por pagar, incluyendo información fiscal, vendor_id y datos comerciales.
English: Master supplier catalog used to manage invoices, payments, and Accounts Payable processes, including fiscal information, vendor_id, and commercial data.';

CREATE INDEX "DWADW"."DIM_SUPPLIER_AP_PARTY_NAME_IDX" ON "DWADW"."DIM_SUPPLIER_AP" ("PARTY_NAME") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_SUPPLIER_AP_PK" ON "DWADW"."DIM_SUPPLIER_AP" ("SUPPLIER_AP_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_SUPPLIER_AP_VENDOR_UN" ON "DWADW"."DIM_SUPPLIER_AP" ("VENDORID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal