VAT_XML_NDE_DTL (SQL Table)	Index Back
AUS VAT XML Meta Node Detail This record is the main tree definition record in the level 2 scroll. It contains the field SEQ_NBR as the key for the scroll. The field VAT_XML_TAG is a new field and is the "tag" that will be used in the output file.

VAT_XML_NDE_DTL

(SQL Table)

AUS VAT XML Meta Node Detail

This record is the main tree definition record in the level 2 scroll. It contains the field SEQ_NBR as the key for the scroll. The field VAT_XML_TAG is a new field and is the "tag" that will be used in the output file.

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 LEVEL_NUM Number(3,0) SMALLINT NOT NULL Level

5 VAT_XML_TAG Character(30) VARCHAR2(30) NOT NULL XML Tag

6 PARENT_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Parent Sequence Number

#	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	LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Level
5	VAT_XML_TAG	Character(30)	VARCHAR2(30) NOT NULL	XML Tag
6	PARENT_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Parent Sequence Number