RE_STLINE_GL_LS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STLINE_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Straightline Key - Number (15)
2	STLINE_SCH_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Straightline Schedule Key - Number (15)
3	DEBIT_CREDIT	Character(2)	VARCHAR2(2) NOT NULL	Debit / Credit Indicator CR=Credit DR=Debit
4	DISTRIBUTION_ID	Number(5,0)	INTEGER NOT NULL	Distribution ID
5	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
6	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
7	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
8	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.
9	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
10	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
11	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
12	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
13	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	GL_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal
16	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
17	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
18	JOURNAL_LINE	Number(9,0)	DECIMAL(9) NOT NULL	Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
19	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
20	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
21	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
22	JRNL_LN_REF	Character(10)	VARCHAR2(10) NOT NULL	Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
23	LINE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.
24	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
25	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
26	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
27	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
28	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
29	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
30	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
31	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
32	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
33	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
34	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
35	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
36	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
37	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
38	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
39	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
40	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
41	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
42	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
43	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
44	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
45	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
46	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
47	LS_NBR	Character(10)	VARCHAR2(10) NOT NULL	Lease Number, User Enterable or Generated Sequence Number
48	LEASE_NAME	Character(60)	VARCHAR2(60) NOT NULL	Lease Name
49	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