RE_STGL_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	LS_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Lease Key, Unique Key
4	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
5	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
6	ACCOUNTING_PD_FROM	Number(3,0)	SMALLINT NOT NULL	Range From Accounting Period
7	ACCOUNTING_PD_TO	Number(3,0)	SMALLINT NOT NULL	Range To Accounting Period
8	GL_BU	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
9	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
10	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
11	STLINE_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Straightline Key - Number (15)
12	STLINE_SCH_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Straightline Schedule Key - Number (15)
13	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
14	WHERE_CLAUSE1	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
15	LS_NBR	Character(10)	VARCHAR2(10) NOT NULL	Lease Number, User Enterable or Generated Sequence Number
16	TXN_ROUTE_CD	Character(20)	VARCHAR2(20) NOT NULL	This field holds the Transaction routing Codes used to configure the Billing, SUT and Withholding defaults.
17	TXN_GRP	Character(1)	VARCHAR2(1) NOT NULL	Transaction Group 1=Base Rent 2=Security Deposit 3=Straightline Accounting 4=Operating Expense 5=Percent Rent 6=Miscellaneous Rent 7=Manual Fee 8=Lease Obligation 9=Lease Interest Expense A=Prior Period Lease Obligation B=Prior Period Lease Interest C=Rent Expense D=Lease Incentive
18	DESCRIPTION	Character(35)	VARCHAR2(35) NOT NULL	DESCRIPTION
19	TXN_DEST	Character(1)	VARCHAR2(1) NOT NULL	This field indicates the Destination for Transaction Billing processor is 'Billing' or 'Payables' 1=Accounts Payable 2=Billing 3=General Ledger
20	DESCR40	Character(40)	VARCHAR2(40) NOT NULL	Description