🏠 Menú principal

← Volver a tablas

---

STADW.ST_POLINES

Base de datos origen: ADW COEXITO

Columnas

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

Restricciones

CHECK: SYS_C0035591

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

CHECK: SYS_C0035592

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

CHECK: SYS_C0035593

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

CHECK: SYS_C0035594

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

CHECK: SYS_C0035595

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

CHECK: SYS_C0035596

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

CHECK: SYS_C0035597

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

CHECK: SYS_C0035598

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

CHECK: SYS_C0035599

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

CHECK: SYS_C0035600

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

CHECK: SYS_C0035601

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

CHECK: SYS_C0035602

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

CHECK: SYS_C0035603

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

CHECK: SYS_C0035604

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

CHECK: SYS_C0035605

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

CHECK: SYS_C0035606

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

CHECK: SYS_C0035607

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

CHECK: SYS_C0035608

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

CHECK: SYS_C0035609

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

CHECK: SYS_C0035610

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

CHECK: SYS_C0035611

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

CHECK: SYS_C0035612

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

CHECK: SYS_C0035613

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

CHECK: SYS_C0035614

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

CHECK: SYS_C0035615

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

CHECK: SYS_C0035616

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

CHECK: SYS_C0035617

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

CHECK: SYS_C0035618

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

CHECK: SYS_C0035619

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

CHECK: SYS_C0035620

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

CHECK: SYS_C0035621

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

CHECK: SYS_C0035622

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

CHECK: SYS_C0035623

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

CHECK: SYS_C0035624

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

CHECK: SYS_C0035625

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

PK: SYS_C0035626

• Estado: ENABLED
• Columnas: ID

DDL

-- Error obteniendo DDL completo: ORA-01745: invalid host/bind variable name

---

← Volver a tablas de STADW

🏠 Volver al menú principal