EM_BAT_SUMMARY (SQL Table)	Index Back
Pre-Validation Summary Pre-Validation Summary

EM_BAT_SUMMARY

(SQL Table)

Pre-Validation Summary

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BATCH_SEQ_NUM Number(15,0) DECIMAL(15) NOT NULL Batch Number

2 VH_SEQ_NUM Number(15,0) DECIMAL(15) NOT NULL Data Sequence Number

3 ERROR_COUNT Number(9,0) DECIMAL(9) NOT NULL Error Count

4 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number

5 INVOICE_DT Date(10) DATE Invoice Date

6 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

7 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

8 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BATCH_SEQ_NUM	Number(15,0)	DECIMAL(15) NOT NULL	Batch Number
2	VH_SEQ_NUM	Number(15,0)	DECIMAL(15) NOT NULL	Data Sequence Number
3	ERROR_COUNT	Number(9,0)	DECIMAL(9) NOT NULL	Error Count
4	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
5	INVOICE_DT	Date(10)	DATE	Invoice Date
6	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
7	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
8	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.