PROJ_DIST_TEO3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
4	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
5	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
6	RESOURCE_ID_FROM	Character(40)	VARCHAR2(40) NOT NULL	Original Transaction ID
7	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
8	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.
9	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
10	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
11	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.
12	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
13	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.
14	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
15	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
16	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
17	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
18	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
19	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
20	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
21	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
22	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
23	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
24	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
25	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
26	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
27	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
28	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
29	BUS_UNIT_GL_FROM	Character(5)	VARCHAR2(5) NOT NULL	From Business Unit GL
30	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
31	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
32	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
33	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
34	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
35	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
36	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
37	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
38	TRANS_DT	Date(10)	DATE	Transaction Date
39	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
40	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.
41	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.
42	OPEN_ITEM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Open Item Status C=Closed Item N=Not an Open Item Account O=Open Item
43	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.
44	JRNL_LINE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates the stage of processing of a journal entry. 0=OK - No Errors 1=Uncorrected Error(s)
45	JOURNAL_LINE_DATE	Date(10)	DATE	Specifies the date of a journal line. This date must be the same as the journal date on the header (JOURNAL_DATE) in order for the Parent/Child relationship to remain intact.
46	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
47	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
48	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.
49	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
50	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
51	CUR_EFFDT	Date(10)	DATE	Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
52	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
53	PC_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PC Distribution Status B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged
54	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
55	PROJ_TRANS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Project Transaction Type
56	PROJ_TRANS_CODE	Character(5)	VARCHAR2(5) NOT NULL	Project Transaction Code
57	RESOURCE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Transaction Status A=Resource Approved U=Unapproved Resource
58	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
59	SYSTEM_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
60	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
61	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
62	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
63	TIME_RPTG_CD	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code
64	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
65	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
66	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
67	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
68	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
69	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
70	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
71	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
72	PO_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PO Distribution Status 0=Non-PO 1=Active 2=In-process 3=Error 4=Processed 5=Modified
73	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
74	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
75	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
76	DUE_DATE	Date(10)	DATE	Delivery Due Date from PO
77	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
78	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
79	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
80	AM_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	AM Distribution Status D=Distributed I=Ignore M=Modified N=Not Distributed P=Pending V=Reversed
81	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
82	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
83	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
84	INCENTIVE_ID	Character(10)	VARCHAR2(10) NOT NULL	Investment Incentive ID
85	MSTONE_SEQ	Number(3,0)	SMALLINT NOT NULL	Milestone Sequence
86	BI_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Billing Distribution Status D=Distributed I=Ignore N=Not Distributed P=Priced U=Unbillable/Non-billable W=Billing Worksheet
87	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
88	BILLING_DATE	Date(10)	DATE	Billing Date
89	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
90	BUSINESS_UNIT_AR	Character(5)	VARCHAR2(5) NOT NULL	AR Business Unit
91	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
92	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
93	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
94	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
95	DST_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Distribution Sequence
96	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
97	SCHED_LINE_NO	Number(7,2)	DECIMAL(6,2) NOT NULL	Sched Line NO
98	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
99	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
100	PAY_END_DT	Date(10)	DATE	Pay Period End Date
101	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
102	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
103	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
104	EX_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Documentation ID
105	EX_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies Expenses Document Type A=Cash Advance C=Time Report J=Time Adjustment M=Accrual - My Wallet R=Accrual - Expense Report S=Expense Report T=Travel Authorization
106	RESOURCE_QUANTITY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Quantity
107	RESOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
108	RES_USER1	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 1
109	RES_USER2	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 2
110	RES_USER3	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 3
111	RES_USER4	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 4
112	RES_USER5	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 5
113	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
114	COMBO_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Combo Status I=Invalid V=Valid
115	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code