🏠 Menú principal

← Volver a tablas

---

DWADW.DIM_CUSTOMER_AR

Base de datos origen: ADW COEXITO

Descripción: Español: Catálogo maestro de clientes utilizado en cuentas por cobrar, con información fiscal, identificación, dirección y estado del cliente. English: Master customer catalog used in Accounts Receivable, containing fiscal information, identification, address, and customer status.

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	CUSTOMER_AR_ID	NUMBER	NO	“DWADW”.”ISEQ$$_306856”.nextval
2	ADDRESS1	VARCHAR2(1000)	SI
3	ADDRESS2	VARCHAR2(1000)	SI
4	ADDRESS3	VARCHAR2(1000)	SI
5	ADDRESS4	VARCHAR2(1000)	SI
6	CATEGORYCODE	VARCHAR2(50)	SI
7	CITY	VARCHAR2(1000)	SI
8	COMMENTS	VARCHAR2(1000)	SI
9	COUNTRY	VARCHAR2(1000)	SI
10	CREATEDBY	VARCHAR2(1000)	SI
11	CREATIONDATE	DATE	SI
12	FISCAL_CODE	VARCHAR2(1000)	SI
13	LAST_UPDATE	DATE	SI
14	LAST_UPDATE_DBY	VARCHAR2(1000)	SI
15	PARTY_ID	NUMBER	NO
16	PARTY_NAME	VARCHAR2(1000)	SI
17	PARTY_NUMBER	VARCHAR2(1000)	SI
18	PARTY_TYPE	VARCHAR2(1000)	SI
19	CONTACT_PERSON_ID	NUMBER	SI
20	STATE	VARCHAR2(1000)	SI
21	STATUS	VARCHAR2(50)	SI
22	AUDIT_ID	NUMBER(18,0)	NO
23	ROW_ACTIVE	CHAR(1)	NO	‘A’

Restricciones

CHECK: DIM_CUSTOMER_AR_AI_CK

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

CHECK: SYS_C00202788

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

CHECK: SYS_C00202789

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

CHECK: SYS_C00202790

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

CHECK: SYS_C00202791

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

PK: DIM_CUSTOMER_AR_PK

• Estado: ENABLED
• Columnas: CUSTOMER_AR_ID

UK: DIM_CUSTOMER_AR__UN

• Estado: ENABLED
• Columnas: PARTY_ID

DDL

CREATE TABLE "DWADW"."DIM_CUSTOMER_AR" 
   (	"CUSTOMER_AR_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, 
	"ADDRESS1" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"ADDRESS2" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"ADDRESS3" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"ADDRESS4" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"CATEGORYCODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"CITY" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"COMMENTS" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"COUNTRY" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"CREATEDBY" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"CREATIONDATE" DATE, 
	"FISCAL_CODE" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"LAST_UPDATE" DATE, 
	"LAST_UPDATE_DBY" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"PARTY_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"PARTY_NAME" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"PARTY_NUMBER" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"PARTY_TYPE" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"CONTACT_PERSON_ID" NUMBER(*,0), 
	"STATE" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"STATUS" VARCHAR2(50) 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_CUSTOMER_AR_AI_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "DIM_CUSTOMER_AR_PK" PRIMARY KEY ("CUSTOMER_AR_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_CUSTOMER_AR__UN" UNIQUE ("PARTY_ID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."DIM_CUSTOMER_AR"  IS 'Español: Catálogo maestro de clientes utilizado en cuentas por cobrar, con información fiscal, identificación, dirección y estado del cliente.
English: Master customer catalog used in Accounts Receivable, containing fiscal information, identification, address, and customer status.';

CREATE UNIQUE INDEX "DWADW"."DIM_CUSTOMER_AR_PK" ON "DWADW"."DIM_CUSTOMER_AR" ("CUSTOMER_AR_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_CUSTOMER_AR__UN" ON "DWADW"."DIM_CUSTOMER_AR" ("PARTY_ID") 
  ;
  CREATE INDEX "DWADW"."INDEX_PARTY_NAME_CUSTOMER_AR" ON "DWADW"."DIM_CUSTOMER_AR" ("PARTY_NAME") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal