FEC_EXPORT2_AET

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause

3 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause

4 WHERE_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Where Clause

5 WHERE_CLAUSE_LONG2 Long Character(8192) CLOB Where Clause

6 FEC_APPL_ID Character(3) VARCHAR2(3) NOT NULL Reporting Application
AM=Asset Management
AP=Payables
AR=Receivables
BI=Billing
CA=Contracts
EX=Expenses
GC=Global Consolidation
GL=General Ledger
GM=Grants
GP=Global Payroll
INV=Inventory
OM=Order Management
OT=Other
PC=Project Costing
PO=Purchasing
TR=Cash Management

7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

8 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

9 FEC_ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

10 DOC_SEQ_NBR Character(12) VARCHAR2(12) NOT NULL Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.

11 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.

12 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

13 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

14 BUSINESS_UNIT_TXN Character(5) VARCHAR2(5) NOT NULL Transaction Business Unit

15 AE_N6 Number(6,0) INTEGER NOT NULL 6

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
3	WHERE_CLAUSE1	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
4	WHERE_CLAUSE2	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
5	WHERE_CLAUSE_LONG2	Long Character(8192)	CLOB	Where Clause
6	FEC_APPL_ID	Character(3)	VARCHAR2(3) NOT NULL	Reporting Application AM=Asset Management AP=Payables AR=Receivables BI=Billing CA=Contracts EX=Expenses GC=Global Consolidation GL=General Ledger GM=Grants GP=Global Payroll INV=Inventory OM=Order Management OT=Other PC=Project Costing PO=Purchasing TR=Cash Management
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
9	FEC_ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
10	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
11	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
12	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
13	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
14	BUSINESS_UNIT_TXN	Character(5)	VARCHAR2(5) NOT NULL	Transaction Business Unit
15	AE_N6	Number(6,0)	INTEGER NOT NULL	6