AP_USF_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
5	AE_APPSTATUS	Number(1,0)	SMALLINT NOT NULL	AE Application Warning Status
6	FILE_NAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
7	FILE_PATH_NAME	Character(254)	VARCHAR2(254) NOT NULL	File Path
8	FILE_LAYOUT_ID	Character(10)	VARCHAR2(10) NOT NULL	File Layout ID
9	INCREMENTAL_SW	Character(1)	VARCHAR2(1) NOT NULL	Identifies whether a same day statement is an incremental statement or not. N=No Y=Yes
10	MENUNAME	Character(30)	VARCHAR2(30) NOT NULL	Menu Name (see PSMENUDEFN).
11	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
12	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
13	COUNT_1	Number(3,0)	SMALLINT NOT NULL	Count Work Field
14	COUNT_2	Number(3,0)	SMALLINT NOT NULL	Count Work Field
15	COUNT_3	Number(3,0)	SMALLINT NOT NULL	Count Work Field
16	SEQUENCENO	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number
17	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
18	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes
19	SAM_ENABLE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Enable SAM Y/N Table Edit Default Value: N
20	SAM_VEND_FLG	Character(1)	VARCHAR2(1) NOT NULL	Suppliers Y/N Table Edit Default Value: N
21	SAM_CUST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Customers Y/N Table Edit Default Value: N
22	DUNS_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	DUNS Number
23	USF_DUNS_PLUS4	Character(4)	VARCHAR2(4) NOT NULL	DUNS Suffix
24	USF_ORDER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Disable Ordering for Expired
25	USF_UPDT_VCH	Character(1)	VARCHAR2(1) NOT NULL	Update CCR Vouchers On Hold
26	USF_FILE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	File Status E=Error I=In Process L=Loaded M=Loaded with Error
27	USF_NAICS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Use delivered NAICS code functionality flag
28	SQLTEXT	Long Character(14000)	CLOB	SQL Statement Text
29	SQL_SELECT_001	Character(254)	VARCHAR2(254) NOT NULL
30	FILE_CREATE_DT	Date(10)	DATE	File Creation Date
31	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
32	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
33	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least
34	USF_TAXPAYER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Use USF_TAXPAYER_NAME to update Alternate Withholding Name
35	USF_UEID	Character(12)	VARCHAR2(12) NOT NULL	Unique Entity Identifier
36	USF_EFT_IND	Character(4)	VARCHAR2(4) NOT NULL	Entity EFT Indicator