VAT_XML_CNT_DTL (SQL Table)	Index Back
Australia VAT XML Meta Data Dt This record contains details of the content that can be output for each XML tag. The record has a 1:1 relationship with VAT_XML_NDE_DTL. Rows in this scroll on the panel are handled by PeopleCode. Two new fields are used in this record:VAT_ XML_SOURCE contains translate values and specifies the source of the content.VAT_ XML_DETAIL relates to the source field, and the value of this field is used differently depending on the value of XML_SOURCE.

VAT_XML_CNT_DTL

(SQL Table)

Australia VAT XML Meta Data Dt

This record contains details of the content that can be output for each XML tag. The record has a 1:1 relationship with VAT_XML_NDE_DTL. Rows in this scroll on the panel are handled by PeopleCode. Two new fields are used in this record:VAT_ XML_SOURCE contains translate values and specifies the source of the content.VAT_ XML_DETAIL relates to the source field, and the value of this field is used differently depending on the value of XML_SOURCE.

Parent record: VAT_XML_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VAT_XML_ID Character(10) VARCHAR2(10) NOT NULL XML ID

2 EFFDT Date(10) DATE Effective Date

3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

4 VAT_XML_SOURCE Character(1) VARCHAR2(1) NOT NULL XML Source
A=From Array
C=Constant
F=Field Value
R=Runtime Value

5 VAT_XML_DETAIL Character(100) VARCHAR2(100) NOT NULL XML Detail

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VAT_XML_ID	Character(10)	VARCHAR2(10) NOT NULL	XML ID
2	EFFDT	Date(10)	DATE	Effective Date
3	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
4	VAT_XML_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	XML Source A=From Array C=Constant F=Field Value R=Runtime Value
5	VAT_XML_DETAIL	Character(100)	VARCHAR2(100) NOT NULL	XML Detail