🏠 Menú principal

← Volver a tablas

---

STADW.ST_SALESCREDIT_OM_HIST

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	SALESCREDITID	NUMBER(18,0)	NO
2	SALESCREDITCREATEDBY	VARCHAR2(64)	SI
3	SALESCREDITCREATIONDATE	TIMESTAMP(6)	SI
4	SALESCREDITFULFILLLINEID	NUMBER(18,0)	SI
5	SALESCREDITHEADERID	NUMBER(18,0)	NO
6	SALESCREDITLASTUPDATEDATE	TIMESTAMP(6)	NO
7	SALESCREDITLASTUPDATELOGIN	VARCHAR2(32)	SI
8	SALESCREDITLASTUPDATEDBY	VARCHAR2(64)	NO
9	SALESCREDITLINEID	NUMBER(18,0)	SI
10	SALESCREDITOBJECTVERSIONNUMBER	NUMBER	SI
11	SALESCREDITORIGSYSSALESCREDITREF	VARCHAR2(50)	SI
12	SALESCREDITPERCENT	NUMBER	NO
13	SALESCREDITSALESCREDITTYPEID	NUMBER(18,0)	SI
14	SALESCREDITSALESPERSONID	NUMBER(18,0)	NO
15	SALESCREDITTYPESALESCREDITTYPEID	NUMBER(18,0)	NO
16	SALESCREDITTYPEREFRESHNUMBER	NUMBER	SI
17	SALESCREDITTYPENAME	VARCHAR2(240)	NO
18	SALESCREDITTYPEENABLEDFLAG	VARCHAR2(1)	NO
19	SALESCREDITTYPEDESCRIPTION	VARCHAR2(2000)	SI
20	HEADERSUBMITTEDFLAG	VARCHAR2(1)	SI
21	HEADERHEADERID	NUMBER(18,0)	NO
22	IDMAESTROCARGUE	NUMBER	NO

Restricciones

CHECK: SYS_C00289823

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

CHECK: SYS_C00289824

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

CHECK: SYS_C00289825

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

CHECK: SYS_C00289826

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

CHECK: SYS_C00289827

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

CHECK: SYS_C00289828

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

CHECK: SYS_C00289829

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

CHECK: SYS_C00289830

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

CHECK: SYS_C00289831

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

CHECK: SYS_C00289832

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

CHECK: SYS_C00289833

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

DDL

CREATE TABLE "STADW"."ST_SALESCREDIT_OM_HIST" 
   (	"SALESCREDITID" NUMBER(18,0) NOT NULL ENABLE, 
	"SALESCREDITCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"SALESCREDITCREATIONDATE" TIMESTAMP (6), 
	"SALESCREDITFULFILLLINEID" NUMBER(18,0), 
	"SALESCREDITHEADERID" NUMBER(18,0) NOT NULL ENABLE, 
	"SALESCREDITLASTUPDATEDATE" TIMESTAMP (6) NOT NULL ENABLE, 
	"SALESCREDITLASTUPDATELOGIN" VARCHAR2(32) COLLATE "USING_NLS_COMP", 
	"SALESCREDITLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"SALESCREDITLINEID" NUMBER(18,0), 
	"SALESCREDITOBJECTVERSIONNUMBER" NUMBER, 
	"SALESCREDITORIGSYSSALESCREDITREF" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"SALESCREDITPERCENT" NUMBER NOT NULL ENABLE, 
	"SALESCREDITSALESCREDITTYPEID" NUMBER(18,0), 
	"SALESCREDITSALESPERSONID" NUMBER(18,0) NOT NULL ENABLE, 
	"SALESCREDITTYPESALESCREDITTYPEID" NUMBER(18,0) NOT NULL ENABLE, 
	"SALESCREDITTYPEREFRESHNUMBER" NUMBER, 
	"SALESCREDITTYPENAME" VARCHAR2(240) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"SALESCREDITTYPEENABLEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"SALESCREDITTYPEDESCRIPTION" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"HEADERSUBMITTEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"HEADERHEADERID" NUMBER(18,0) NOT NULL ENABLE, 
	"IDMAESTROCARGUE" NUMBER NOT NULL ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

---

← Volver a tablas de STADW

🏠 Volver al menú principal