VAT_XML_IDSEQ_NBRA=From Array
C=Constant
F=Field Value
R=Runtime Value
VAT_XML_CNT_VW(SQL View) |
Index Back |
|---|
| SELECT A.VAT_XML_ID , A.SEQ_NBR , A.VAT_XML_SOURCE , %Substring(A.VAT_XML_DETAIL,1,30) AS DESCR FROM PS_VAT_XML_CNT_DTL A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_VAT_XML_CNT_DTL A1 WHERE A.VAT_XML_ID = A1.VAT_XML_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VAT_XML_ID |
Character(10) | VARCHAR2(10) NOT NULL | XML ID |
| 2 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 3 | VAT_XML_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
XML Source
A=From Array C=Constant F=Field Value R=Runtime Value |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |