STADW.ST_POLINES_HIST

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo
1	IDMAESTRODETALLE	NUMBER(18,0)	NO
2	AUCTIONHEADERCREATIONDATE	DATE	NO
3	CATEGORYCATEGORYID	NUMBER(18,0)	NO
4	CATEGORYCATEGORYNAME	VARCHAR2(2400)	SI
5	CATEGORYDESCRIPTION	VARCHAR2(240)	SI
6	FROMBLANKETDOCUMENTTYPELASTUPDATEDATE	DATE	NO
7	FROMBLANKETHEADERPRCBULASTUPDATEDATE	DATE	NO
8	FROMBLANKETHEADERSTYLELINELASTUPDATEDATE	DATE	NO
9	FROMCONTRACTDOCUMENTTYPELASTUPDATEDATE	DATE	NO
10	FROMCONTRACTHEADERPRCBULASTUPDATEDATE	DATE	NO
11	FROMCONTRACTHEADERSTYLELINELASTUPDATEDATE	DATE	NO
12	FROMLINELINENUM	NUMBER(8,0)	NO
13	HAZARDCLASSDESCRIPTION	VARCHAR2(240)	SI
14	HAZARDCLASSLASTUPDATEDATE	DATE	NO
15	HEADERBUDGETCONTROLENABLEDFLAG	VARCHAR2(1)	NO
16	ITEMINVENTORYITEMID	NUMBER(18,0)	NO
17	LINECANCELLEDBYPERSONEFFECTIVESTARTDATE	DATE	NO
18	LINECANCELLEDBYPERSONFULLNAME	VARCHAR2(2000)	SI
19	POHEADERAMOUNT	NUMBER(8,0)	SI
20	POHEADERLEDGERAMOUNT	NUMBER(8,0)	SI
21	POLINEAMOUNT	NUMBER(8,0)	SI
22	POLINELEDGERAMOUNT	NUMBER(8,0)	SI
23	POLINEID	NUMBER(18,0)	NO
24	PURCHASINGATTRIBUTEVALUETLPLASTUPDATEDATE	DATE	NO
25	PURCHASINGDOCUMENTHEADERACCEPTANCEREQUIREDFLAG	VARCHAR2(1)	SI
26	PURCHASINGDOCUMENTHEADERACKNOWLEDGED	VARCHAR2(1)	SI
27	PURCHASINGDOCUMENTHEADERAPPROVEDDATE	DATE	SI
28	PURCHASINGDOCUMENTHEADERAPPROVEDFLAG	VARCHAR2(1)	SI
29	PURCHASINGDOCUMENTHEADERBCCEMAILADDRESS	VARCHAR2(2000)	SI
30	PURCHASINGDOCUMENTHEADERBUYERMANAGEDTRANSPORTFLAG	VARCHAR2(1)	NO
31	PURCHASINGDOCUMENTHEADERCCEMAILADDRESS	VARCHAR2(2000)	SI
32	PURCHASINGDOCUMENTHEADERCLOSEDDATE	DATE	SI
33	PURCHASINGDOCUMENTHEADERCOMMENTS	VARCHAR2(240)	SI
34	PURCHASINGDOCUMENTHEADERCONFIRMINGORDERFLAG	VARCHAR2(1)	SI
35	PURCHASINGDOCUMENTHEADERCREATIONDATE	DATE	NO
36	PURCHASINGDOCUMENTHEADERDEFAULTTAXATIONCOUNTRY	VARCHAR2(2)	SI
37	PURCHASINGDOCUMENTHEADERDOCUMENTCREATIONMETHOD	VARCHAR2(30)	SI
38	PURCHASINGDOCUMENTHEADERDOCUMENTSTATUS	VARCHAR2(25)	NO
39	PURCHASINGDOCUMENTHEADEREMAILADDRESS	VARCHAR2(2000)	SI
40	PURCHASINGDOCUMENTHEADERFROZENFLAG	VARCHAR2(1)	SI
41	PURCHASINGDOCUMENTHEADERFUNDSSTATUS	VARCHAR2(25)	SI
42	PURCHASINGDOCUMENTHEADERINTERFACESOURCECODE	VARCHAR2(25)	SI
43	PURCHASINGDOCUMENTHEADERMODEOFTRANSPORT	VARCHAR2(30)	SI
44	PURCHASINGDOCUMENTHEADERNOTETORECEIVER	VARCHAR2(1000)	SI
45	PURCHASINGDOCUMENTHEADERNOTETOVENDOR	VARCHAR2(1000)	SI
46	PURCHASINGDOCUMENTHEADERORCHESTRATIONORDERFLAG	VARCHAR2(1)	SI
47	PURCHASINGDOCUMENTHEADERPOHEADERID	NUMBER(18,0)	NO
48	PURCHASINGDOCUMENTHEADERRATE	NUMBER(8,0)	SI
49	PURCHASINGDOCUMENTHEADERRATEDATE	DATE	SI
50	PURCHASINGDOCUMENTHEADERRATETYPE	VARCHAR2(30)	SI
51	PURCHASINGDOCUMENTHEADERREVISEDDATE	DATE	SI
52	PURCHASINGDOCUMENTHEADERREVISIONNUM	NUMBER(8,0)	SI
53	PURCHASINGDOCUMENTHEADERSEGMENT1	VARCHAR2(30)	NO
54	PURCHASINGDOCUMENTHEADERSERVICELEVEL	VARCHAR2(30)	SI
55	PURCHASINGDOCUMENTHEADERSUPPLIERNOTIFMETHOD	VARCHAR2(25)	SI
56	PURCHASINGDOCUMENTHEADERVENDORID	NUMBER(18,0)	SI
57	PURCHASINGDOCUMENTLINEAMOUNT	NUMBER(8,0)	SI
58	PURCHASINGDOCUMENTLINECANCELDATE	DATE	SI
59	PURCHASINGDOCUMENTLINECANCELREASON	VARCHAR2(240)	SI
60	PURCHASINGDOCUMENTLINECLOSEDREASON	VARCHAR2(240)	SI
61	PURCHASINGDOCUMENTLINECONSIGNMENTLINEFLAG	VARCHAR2(1)	NO
62	PURCHASINGDOCUMENTLINECREATIONDATE	DATE	NO
63	PURCHASINGDOCUMENTLINEFUNDSSTATUS	VARCHAR2(25)	SI
64	PURCHASINGDOCUMENTLINEITEMDESCRIPTION	VARCHAR2(240)	SI
65	PURCHASINGDOCUMENTLINEITEMID	NUMBER(18,0)	SI
66	PURCHASINGDOCUMENTLINEITEMREVISION	VARCHAR2(18)	SI
67	PURCHASINGDOCUMENTLINELASTUPDATEDBY	VARCHAR2(64)	NO
68	PURCHASINGDOCUMENTLINELINENUM	NUMBER(8,0)	NO
69	PURCHASINGDOCUMENTLINELINESTATUS	VARCHAR2(25)	SI
70	PURCHASINGDOCUMENTLINENEGOTIATEDBYPREPARERFLAG	VARCHAR2(1)	SI
71	PURCHASINGDOCUMENTLINENOTETOVENDOR	VARCHAR2(1000)	SI
72	PURCHASINGDOCUMENTLINEORDERTYPELOOKUPCODE	VARCHAR2(25)	NO
73	PURCHASINGDOCUMENTLINEPOHEADERID	NUMBER(18,0)	NO
74	PURCHASINGDOCUMENTLINEQUANTITY	NUMBER(8,0)	SI
75	PURCHASINGDOCUMENTLINESHIPPINGUOMCODE	VARCHAR2(3)	SI
76	PURCHASINGDOCUMENTLINESHIPPINGUOMQUANTITY	NUMBER(8,0)	SI
77	PURCHASINGDOCUMENTLINEUNITPRICE	NUMBER(8,0)	SI
78	PURCHASINGDOCUMENTLINEUOMCODE	VARCHAR2(3)	SI
79	PURCHASINGDOCUMENTLINEVENDORPRODUCTNUM	VARCHAR2(300)	SI
80	PURCHASINGDOCUMENTVERSIONCHANGEORDERSTATUS	VARCHAR2(25)	NO
81	PURCHASINGDOCUMENTVERSIONCOMMUNICATEDDATE	DATE	SI
82	PURCHASINGDOCUMENTVERSIONPROCESSEDDATE	DATE	SI
83	PURCHASINGDOCUMENTVERSIONSUBMITTEDDATE	DATE	SI
84	PURCHASINGHAZARDCLASS	VARCHAR2(40)	NO
85	PURCHASINGUNNUMBERDESCRIPTION	VARCHAR2(240)	NO
86	PURCHASINGUNNUMBERUNNUMBER	VARCHAR2(20)	NO
87	SECUNITOFMEASURELASTUPDATEDATE	DATE	NO
88	UNITOFMEASUREDESCRIPTION	VARCHAR2(50)	SI
89	UNITOFMEASURELASTUPDATEDATE	DATE	NO
90	UNITOFMEASUREUNITOFMEASURE1	VARCHAR2(25)	NO

Restricciones

CHECK: SYS_C0036524

Estado: ENABLED
Columnas: IDMAESTRODETALLE
Condición: "IDMAESTRODETALLE" IS NOT NULL

CHECK: SYS_C0036525

Estado: ENABLED
Columnas: AUCTIONHEADERCREATIONDATE
Condición: "AUCTIONHEADERCREATIONDATE" IS NOT NULL

CHECK: SYS_C0036526

Estado: ENABLED
Columnas: CATEGORYCATEGORYID
Condición: "CATEGORYCATEGORYID" IS NOT NULL

CHECK: SYS_C0036527

Estado: ENABLED
Columnas: FROMBLANKETDOCUMENTTYPELASTUPDATEDATE
Condición: "FROMBLANKETDOCUMENTTYPELASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C0036528

Estado: ENABLED
Columnas: FROMBLANKETHEADERPRCBULASTUPDATEDATE
Condición: "FROMBLANKETHEADERPRCBULASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C0036529

Estado: ENABLED
Columnas: FROMBLANKETHEADERSTYLELINELASTUPDATEDATE
Condición: "FROMBLANKETHEADERSTYLELINELASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C0036530

Estado: ENABLED
Columnas: FROMCONTRACTDOCUMENTTYPELASTUPDATEDATE
Condición: "FROMCONTRACTDOCUMENTTYPELASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C0036531

Estado: ENABLED
Columnas: FROMCONTRACTHEADERPRCBULASTUPDATEDATE
Condición: "FROMCONTRACTHEADERPRCBULASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C0036532

Estado: ENABLED
Columnas: FROMCONTRACTHEADERSTYLELINELASTUPDATEDATE
Condición: "FROMCONTRACTHEADERSTYLELINELASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C0036533

Estado: ENABLED
Columnas: FROMLINELINENUM
Condición: "FROMLINELINENUM" IS NOT NULL

CHECK: SYS_C0036534

Estado: ENABLED
Columnas: HAZARDCLASSLASTUPDATEDATE
Condición: "HAZARDCLASSLASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C0036535

Estado: ENABLED
Columnas: HEADERBUDGETCONTROLENABLEDFLAG
Condición: "HEADERBUDGETCONTROLENABLEDFLAG" IS NOT NULL

CHECK: SYS_C0036536

Estado: ENABLED
Columnas: ITEMINVENTORYITEMID
Condición: "ITEMINVENTORYITEMID" IS NOT NULL

CHECK: SYS_C0036537

Estado: ENABLED
Columnas: LINECANCELLEDBYPERSONEFFECTIVESTARTDATE
Condición: "LINECANCELLEDBYPERSONEFFECTIVESTARTDATE" IS NOT NULL

CHECK: SYS_C0036538

Estado: ENABLED
Columnas: POLINEID
Condición: "POLINEID" IS NOT NULL

CHECK: SYS_C0036539

Estado: ENABLED
Columnas: PURCHASINGATTRIBUTEVALUETLPLASTUPDATEDATE
Condición: "PURCHASINGATTRIBUTEVALUETLPLASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C0036540

Estado: ENABLED
Columnas: PURCHASINGDOCUMENTHEADERBUYERMANAGEDTRANSPORTFLAG
Condición: "PURCHASINGDOCUMENTHEADERBUYERMANAGEDTRANSPORTFLAG" IS NOT NULL

CHECK: SYS_C0036541

Estado: ENABLED
Columnas: PURCHASINGDOCUMENTHEADERCREATIONDATE
Condición: "PURCHASINGDOCUMENTHEADERCREATIONDATE" IS NOT NULL

CHECK: SYS_C0036542

Estado: ENABLED
Columnas: PURCHASINGDOCUMENTHEADERDOCUMENTSTATUS
Condición: "PURCHASINGDOCUMENTHEADERDOCUMENTSTATUS" IS NOT NULL

CHECK: SYS_C0036543

Estado: ENABLED
Columnas: PURCHASINGDOCUMENTHEADERPOHEADERID
Condición: "PURCHASINGDOCUMENTHEADERPOHEADERID" IS NOT NULL

CHECK: SYS_C0036544

Estado: ENABLED
Columnas: PURCHASINGDOCUMENTHEADERSEGMENT1
Condición: "PURCHASINGDOCUMENTHEADERSEGMENT1" IS NOT NULL

CHECK: SYS_C0036545

Estado: ENABLED
Columnas: PURCHASINGDOCUMENTLINECONSIGNMENTLINEFLAG
Condición: "PURCHASINGDOCUMENTLINECONSIGNMENTLINEFLAG" IS NOT NULL

CHECK: SYS_C0036546

Estado: ENABLED
Columnas: PURCHASINGDOCUMENTLINECREATIONDATE
Condición: "PURCHASINGDOCUMENTLINECREATIONDATE" IS NOT NULL

CHECK: SYS_C0036547

Estado: ENABLED
Columnas: PURCHASINGDOCUMENTLINELASTUPDATEDBY
Condición: "PURCHASINGDOCUMENTLINELASTUPDATEDBY" IS NOT NULL

CHECK: SYS_C0036548

Estado: ENABLED
Columnas: PURCHASINGDOCUMENTLINELINENUM
Condición: "PURCHASINGDOCUMENTLINELINENUM" IS NOT NULL

CHECK: SYS_C0036549

Estado: ENABLED
Columnas: PURCHASINGDOCUMENTLINEORDERTYPELOOKUPCODE
Condición: "PURCHASINGDOCUMENTLINEORDERTYPELOOKUPCODE" IS NOT NULL

CHECK: SYS_C0036550

Estado: ENABLED
Columnas: PURCHASINGDOCUMENTLINEPOHEADERID
Condición: "PURCHASINGDOCUMENTLINEPOHEADERID" IS NOT NULL

CHECK: SYS_C0036551

Estado: ENABLED
Columnas: PURCHASINGDOCUMENTVERSIONCHANGEORDERSTATUS
Condición: "PURCHASINGDOCUMENTVERSIONCHANGEORDERSTATUS" IS NOT NULL

CHECK: SYS_C0036552

Estado: ENABLED
Columnas: PURCHASINGHAZARDCLASS
Condición: "PURCHASINGHAZARDCLASS" IS NOT NULL

CHECK: SYS_C0036553

Estado: ENABLED
Columnas: PURCHASINGUNNUMBERDESCRIPTION
Condición: "PURCHASINGUNNUMBERDESCRIPTION" IS NOT NULL

CHECK: SYS_C0036554

Estado: ENABLED
Columnas: PURCHASINGUNNUMBERUNNUMBER
Condición: "PURCHASINGUNNUMBERUNNUMBER" IS NOT NULL

CHECK: SYS_C0036555

Estado: ENABLED
Columnas: SECUNITOFMEASURELASTUPDATEDATE
Condición: "SECUNITOFMEASURELASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C0036556

Estado: ENABLED
Columnas: UNITOFMEASURELASTUPDATEDATE
Condición: "UNITOFMEASURELASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C0036557

Estado: ENABLED
Columnas: UNITOFMEASUREUNITOFMEASURE1
Condición: "UNITOFMEASUREUNITOFMEASURE1" IS NOT NULL

DDL

CREATE TABLE "STADW"."ST_POLINES_HIST" 
   (	"IDMAESTRODETALLE" NUMBER(18,0) NOT NULL ENABLE, 
	"AUCTIONHEADERCREATIONDATE" DATE NOT NULL ENABLE, 
	"CATEGORYCATEGORYID" NUMBER(18,0) NOT NULL ENABLE, 
	"CATEGORYCATEGORYNAME" VARCHAR2(2400) COLLATE "USING_NLS_COMP", 
	"CATEGORYDESCRIPTION" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"FROMBLANKETDOCUMENTTYPELASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"FROMBLANKETHEADERPRCBULASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"FROMBLANKETHEADERSTYLELINELASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"FROMCONTRACTDOCUMENTTYPELASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"FROMCONTRACTHEADERPRCBULASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"FROMCONTRACTHEADERSTYLELINELASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"FROMLINELINENUM" NUMBER(8,0) NOT NULL ENABLE, 
	"HAZARDCLASSDESCRIPTION" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"HAZARDCLASSLASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"HEADERBUDGETCONTROLENABLEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ITEMINVENTORYITEMID" NUMBER(18,0) NOT NULL ENABLE, 
	"LINECANCELLEDBYPERSONEFFECTIVESTARTDATE" DATE NOT NULL ENABLE, 
	"LINECANCELLEDBYPERSONFULLNAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"POHEADERAMOUNT" NUMBER(8,0), 
	"POHEADERLEDGERAMOUNT" NUMBER(8,0), 
	"POLINEAMOUNT" NUMBER(8,0), 
	"POLINELEDGERAMOUNT" NUMBER(8,0), 
	"POLINEID" NUMBER(18,0) NOT NULL ENABLE, 
	"PURCHASINGATTRIBUTEVALUETLPLASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"PURCHASINGDOCUMENTHEADERACCEPTANCEREQUIREDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERACKNOWLEDGED" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERAPPROVEDDATE" DATE, 
	"PURCHASINGDOCUMENTHEADERAPPROVEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERBCCEMAILADDRESS" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERBUYERMANAGEDTRANSPORTFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"PURCHASINGDOCUMENTHEADERCCEMAILADDRESS" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERCLOSEDDATE" DATE, 
	"PURCHASINGDOCUMENTHEADERCOMMENTS" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERCONFIRMINGORDERFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERCREATIONDATE" DATE NOT NULL ENABLE, 
	"PURCHASINGDOCUMENTHEADERDEFAULTTAXATIONCOUNTRY" VARCHAR2(2) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERDOCUMENTCREATIONMETHOD" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERDOCUMENTSTATUS" VARCHAR2(25) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"PURCHASINGDOCUMENTHEADEREMAILADDRESS" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERFROZENFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERFUNDSSTATUS" VARCHAR2(25) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERINTERFACESOURCECODE" VARCHAR2(25) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERMODEOFTRANSPORT" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERNOTETORECEIVER" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERNOTETOVENDOR" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERORCHESTRATIONORDERFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERPOHEADERID" NUMBER(18,0) NOT NULL ENABLE, 
	"PURCHASINGDOCUMENTHEADERRATE" NUMBER(8,0), 
	"PURCHASINGDOCUMENTHEADERRATEDATE" DATE, 
	"PURCHASINGDOCUMENTHEADERRATETYPE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERREVISEDDATE" DATE, 
	"PURCHASINGDOCUMENTHEADERREVISIONNUM" NUMBER(8,0), 
	"PURCHASINGDOCUMENTHEADERSEGMENT1" VARCHAR2(30) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"PURCHASINGDOCUMENTHEADERSERVICELEVEL" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERSUPPLIERNOTIFMETHOD" VARCHAR2(25) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERVENDORID" NUMBER(18,0), 
	"PURCHASINGDOCUMENTLINEAMOUNT" NUMBER(8,0), 
	"PURCHASINGDOCUMENTLINECANCELDATE" DATE, 
	"PURCHASINGDOCUMENTLINECANCELREASON" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTLINECLOSEDREASON" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTLINECONSIGNMENTLINEFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"PURCHASINGDOCUMENTLINECREATIONDATE" DATE NOT NULL ENABLE, 
	"PURCHASINGDOCUMENTLINEFUNDSSTATUS" VARCHAR2(25) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTLINEITEMDESCRIPTION" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTLINEITEMID" NUMBER(18,0), 
	"PURCHASINGDOCUMENTLINEITEMREVISION" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTLINELASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"PURCHASINGDOCUMENTLINELINENUM" NUMBER(8,0) NOT NULL ENABLE, 
	"PURCHASINGDOCUMENTLINELINESTATUS" VARCHAR2(25) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTLINENEGOTIATEDBYPREPARERFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTLINENOTETOVENDOR" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTLINEORDERTYPELOOKUPCODE" VARCHAR2(25) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"PURCHASINGDOCUMENTLINEPOHEADERID" NUMBER(18,0) NOT NULL ENABLE, 
	"PURCHASINGDOCUMENTLINEQUANTITY" NUMBER(8,0), 
	"PURCHASINGDOCUMENTLINESHIPPINGUOMCODE" VARCHAR2(3) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTLINESHIPPINGUOMQUANTITY" NUMBER(8,0), 
	"PURCHASINGDOCUMENTLINEUNITPRICE" NUMBER(8,0), 
	"PURCHASINGDOCUMENTLINEUOMCODE" VARCHAR2(3) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTLINEVENDORPRODUCTNUM" VARCHAR2(300) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTVERSIONCHANGEORDERSTATUS" VARCHAR2(25) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"PURCHASINGDOCUMENTVERSIONCOMMUNICATEDDATE" DATE, 
	"PURCHASINGDOCUMENTVERSIONPROCESSEDDATE" DATE, 
	"PURCHASINGDOCUMENTVERSIONSUBMITTEDDATE" DATE, 
	"PURCHASINGHAZARDCLASS" VARCHAR2(40) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"PURCHASINGUNNUMBERDESCRIPTION" VARCHAR2(240) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"PURCHASINGUNNUMBERUNNUMBER" VARCHAR2(20) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"SECUNITOFMEASURELASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"UNITOFMEASUREDESCRIPTION" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"UNITOFMEASURELASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"UNITOFMEASUREUNITOFMEASURE1" VARCHAR2(25) COLLATE "USING_NLS_COMP" NOT NULL ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

GRANT ALTER ON "STADW"."ST_POLINES_HIST" TO "BICC";
  GRANT DELETE ON "STADW"."ST_POLINES_HIST" TO "BICC";
  GRANT INDEX ON "STADW"."ST_POLINES_HIST" TO "BICC";
  GRANT INSERT ON "STADW"."ST_POLINES_HIST" TO "BICC";
  GRANT SELECT ON "STADW"."ST_POLINES_HIST" TO "BICC";
  GRANT UPDATE ON "STADW"."ST_POLINES_HIST" TO "BICC";
  GRANT REFERENCES ON "STADW"."ST_POLINES_HIST" TO "BICC";
  GRANT READ ON "STADW"."ST_POLINES_HIST" TO "BICC";
  GRANT ON COMMIT REFRESH ON "STADW"."ST_POLINES_HIST" TO "BICC";
  GRANT QUERY REWRITE ON "STADW"."ST_POLINES_HIST" TO "BICC";
  GRANT DEBUG ON "STADW"."ST_POLINES_HIST" TO "BICC";
  GRANT FLASHBACK ON "STADW"."ST_POLINES_HIST" TO "BICC";
  GRANT ASSERTION REFERENCES ON "STADW"."ST_POLINES_HIST" TO "BICC";

← Volver a tablas de STADW

🏠 Volver al menú principal