GM_PRJ_RESD_TAO (SQL Table)	Index Back
Grants F&A Work Tbl D

GM_PRJ_RESD_TAO

(SQL Table)

Grants F&A Work Tbl D

# 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 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 POST_SEQ_NUM Number(3,0) SMALLINT NOT NULL POSTING SEQUENCE NUMBER

7 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

8 RESOURCE_ID_FROM Character(40) VARCHAR2(40) NOT NULL Original Transaction ID

9 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

10 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.

11 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

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 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

15 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.

16 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

17 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

18 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

19 ASSOC_DEPTID Character(10) VARCHAR2(10) NOT NULL Associated Department

20 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

21 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

22 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

23 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

24 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

25 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

26 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

27 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

28 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

29 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

30 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

31 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

32 BUS_UNIT_GL_FROM Character(5) VARCHAR2(5) NOT NULL From Business Unit GL

33 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

34 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

35 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

36 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

37 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

38 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

39 RES_USER1 Character(10) VARCHAR2(10) NOT NULL Transaction User 1

40 RES_USER2 Character(10) VARCHAR2(10) NOT NULL Transaction User 2

41 RES_USER3 Character(10) VARCHAR2(10) NOT NULL Transaction User 3

42 RES_USER4 Character(10) VARCHAR2(10) NOT NULL Transaction User 4

43 RES_USER5 Character(10) VARCHAR2(10) NOT NULL Transaction User 5

44 TRANS_DT Date(10) DATE Transaction Date

45 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

46 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

47 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.

48 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.

49 OPEN_ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Open Item Status
C=Closed Item
N=Not an Open Item Account
O=Open Item

50 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.

51 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)

52 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.

53 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

54 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.

55 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.

56 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

57 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

58 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.

59 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

60 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

61 PROJ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Project Transaction Type

62 PROJ_TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Project Transaction Code

63 RESOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
A=Resource Approved
U=Unapproved Resource

64 DESCR Character(30) VARCHAR2(30) NOT NULL Description

65 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.

66 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

67 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

68 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

69 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

70 TIME_RPTG_CD Character(5) VARCHAR2(5) NOT NULL Time Reporting Code

71 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

72 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

73 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID

74 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

75 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

76 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

77 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

78 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

79 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments

80 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

81 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

82 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

83 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

84 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number

85 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number

86 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number

87 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

88 DUE_DATE Date(10) DATE Delivery Due Date from PO

89 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

90 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

91 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

92 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

93 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

94 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

95 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

96 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

97 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

98 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID

99 MSTONE_SEQ Number(3,0) SMALLINT NOT NULL Milestone Sequence

100 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

101 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

102 CONTRACT_PPD_SEQ Number(5,0) INTEGER NOT NULL Prepaid Add Sequence

103 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

104 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

105 BILLING_DATE Date(10) DATE Billing Date

106 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

107 REV_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Revenue Distribution Status
C=Created
D=Distributed
G=Generated
I=Ignore
N=Not Distributed

108 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit

109 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.

110 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.

111 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line

112 ITEM_SEQ_NUM Number(3,0) SMALLINT NOT NULL Item Sequence Number

113 DST_SEQ_NUM Number(6,0) INTEGER NOT NULL Distribution Sequence

114 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

115 SCHED_LINE_NO Number(7,2) DECIMAL(6,2) NOT NULL Sched Line NO

116 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

117 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

118 PAY_END_DT Date(10) DATE Pay Period End Date

119 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit

120 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

121 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

122 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Documentation ID

123 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

124 RESOURCE_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity

125 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount

126 BUDGET_OVER_ALLOW Character(1) VARCHAR2(1) NOT NULL Budget Overrun Allowed

127 BUDGET_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL -> SL - 15-AUG-2002 MISC_CRITERIA label has been added <-
B=Bypass
E=Error
N=Not Chk'd
V=Valid
W=Warning

128 BUDGET_DT Date(10) DATE Budget Date

129 BD_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL BD Distribution Status
D=Distributed
I=Ignore
N=None

130 BUSINESS_UNIT_BD Character(5) VARCHAR2(5) NOT NULL Budgeting Business Unit

131 FA_STATUS Character(1) VARCHAR2(1) NOT NULL F&A Status

132 BCM_APPLICABLE Character(1) VARCHAR2(1) NOT NULL BCM Applicable

133 FA_ERROR_STATUS Character(2) VARCHAR2(2) NOT NULL F&A Error Status
AD=No Offset Assoc. Dept
CC=Combo Err - Cost Shared F&A
CF=Combo Error- IntraUnit Rec F&A
CO=Combo Error - Offset F&A
CS=Combo Error - Sponsor F&A
CT=Combo Error- IntraUnit Pay F&A
CW=Combo Error - Waived F&A
E=Error in Budget Checking
I=IntraUnit Error
N=Not Budget Checked
RF=Funded Rate Pct Not Found
RI=Institution Rate Pct Not Found
RS=Sponsor Rate Pct Not Found
V=Valid Budget Check
W=Warning in Budget Checking

134 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code

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

136 COMBO_STATUS Character(1) VARCHAR2(1) NOT NULL Combo Status
I=Invalid
V=Valid

137 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.

138 BCM_TRAN_TYPE Character(2) VARCHAR2(2) NOT NULL Transaction Type
AR=Accounts Receivable Item
EN=Encumbrance
EX=Expended
JU=Journal Unpost
JV=Journal Voucher
PM=AR Payment (Reference Item)
PN=AR Payment (No Reference Item)
PO=Purchase Order
PR=Pre Encumbrance
RQ=Requisition

139 FA_RATE_PCT Number(6,2) DECIMAL(5,2) NOT NULL FA_RATE_PCT

140 RESOURCE_AMT_TMP Signed Number(28,3) DECIMAL(26,3) NOT NULL Resource Amount

141 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

142 IU_ANCHOR_FLG Character(1) VARCHAR2(1) NOT NULL Y/N flag used to specify which transaction line is the Inter/IntraUnit anchor flag (the line that contains the anchor Business Unit and ChartFields).

143 IU_SYS_TRAN_CD Character(8) VARCHAR2(8) NOT NULL System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.

144 IU_TRAN_CD Character(8) VARCHAR2(8) NOT NULL Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.

145 FLDNUMVAL1 Number(20,0) DECIMAL(20) NOT NULL Fld Num1

#	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	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	POST_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	POSTING SEQUENCE NUMBER
7	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
8	RESOURCE_ID_FROM	Character(40)	VARCHAR2(40) NOT NULL	Original Transaction ID
9	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
10	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.
11	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
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	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
15	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.
16	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
17	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
18	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
19	ASSOC_DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Associated Department
20	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
21	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
22	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
23	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
24	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
25	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
26	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
27	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
28	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
29	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
30	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
31	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
32	BUS_UNIT_GL_FROM	Character(5)	VARCHAR2(5) NOT NULL	From Business Unit GL
33	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
34	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
35	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
36	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
37	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
38	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
39	RES_USER1	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 1
40	RES_USER2	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 2
41	RES_USER3	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 3
42	RES_USER4	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 4
43	RES_USER5	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 5
44	TRANS_DT	Date(10)	DATE	Transaction Date
45	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
46	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
47	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.
48	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.
49	OPEN_ITEM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Open Item Status C=Closed Item N=Not an Open Item Account O=Open Item
50	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.
51	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)
52	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.
53	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
54	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.
55	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.
56	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
57	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
58	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.
59	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
60	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
61	PROJ_TRANS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Project Transaction Type
62	PROJ_TRANS_CODE	Character(5)	VARCHAR2(5) NOT NULL	Project Transaction Code
63	RESOURCE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Transaction Status A=Resource Approved U=Unapproved Resource
64	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
65	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.
66	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
67	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
68	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
69	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
70	TIME_RPTG_CD	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code
71	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
72	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
73	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
74	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
75	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
76	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
77	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
78	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
79	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
80	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
81	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
82	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
83	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
84	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
85	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
86	REQ_DISTRIB_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Distrib Number
87	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
88	DUE_DATE	Date(10)	DATE	Delivery Due Date from PO
89	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
90	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
91	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
92	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
93	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
94	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
95	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
96	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type
97	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
98	INCENTIVE_ID	Character(10)	VARCHAR2(10) NOT NULL	Investment Incentive ID
99	MSTONE_SEQ	Number(3,0)	SMALLINT NOT NULL	Milestone Sequence
100	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
101	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
102	CONTRACT_PPD_SEQ	Number(5,0)	INTEGER NOT NULL	Prepaid Add Sequence
103	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
104	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
105	BILLING_DATE	Date(10)	DATE	Billing Date
106	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
107	REV_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Revenue Distribution Status C=Created D=Distributed G=Generated I=Ignore N=Not Distributed
108	BUSINESS_UNIT_AR	Character(5)	VARCHAR2(5) NOT NULL	AR Business Unit
109	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.
110	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.
111	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
112	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
113	DST_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Distribution Sequence
114	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
115	SCHED_LINE_NO	Number(7,2)	DECIMAL(6,2) NOT NULL	Sched Line NO
116	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
117	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
118	PAY_END_DT	Date(10)	DATE	Pay Period End Date
119	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
120	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
121	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
122	EX_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Documentation ID
123	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
124	RESOURCE_QUANTITY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Quantity
125	RESOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
126	BUDGET_OVER_ALLOW	Character(1)	VARCHAR2(1) NOT NULL	Budget Overrun Allowed
127	BUDGET_LINE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	-> SL - 15-AUG-2002 MISC_CRITERIA label has been added <- B=Bypass E=Error N=Not Chk'd V=Valid W=Warning
128	BUDGET_DT	Date(10)	DATE	Budget Date
129	BD_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	BD Distribution Status D=Distributed I=Ignore N=None
130	BUSINESS_UNIT_BD	Character(5)	VARCHAR2(5) NOT NULL	Budgeting Business Unit
131	FA_STATUS	Character(1)	VARCHAR2(1) NOT NULL	F&A Status
132	BCM_APPLICABLE	Character(1)	VARCHAR2(1) NOT NULL	BCM Applicable
133	FA_ERROR_STATUS	Character(2)	VARCHAR2(2) NOT NULL	F&A Error Status AD=No Offset Assoc. Dept CC=Combo Err - Cost Shared F&A CF=Combo Error- IntraUnit Rec F&A CO=Combo Error - Offset F&A CS=Combo Error - Sponsor F&A CT=Combo Error- IntraUnit Pay F&A CW=Combo Error - Waived F&A E=Error in Budget Checking I=IntraUnit Error N=Not Budget Checked RF=Funded Rate Pct Not Found RI=Institution Rate Pct Not Found RS=Sponsor Rate Pct Not Found V=Valid Budget Check W=Warning in Budget Checking
134	DST_ID	Character(10)	VARCHAR2(10) NOT NULL	Distribution Code
135	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
136	COMBO_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Combo Status I=Invalid V=Valid
137	STATISTIC_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
138	BCM_TRAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Transaction Type AR=Accounts Receivable Item EN=Encumbrance EX=Expended JU=Journal Unpost JV=Journal Voucher PM=AR Payment (Reference Item) PN=AR Payment (No Reference Item) PO=Purchase Order PR=Pre Encumbrance RQ=Requisition
139	FA_RATE_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	FA_RATE_PCT
140	RESOURCE_AMT_TMP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Resource Amount
141	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
142	IU_ANCHOR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag used to specify which transaction line is the Inter/IntraUnit anchor flag (the line that contains the anchor Business Unit and ChartFields).
143	IU_SYS_TRAN_CD	Character(8)	VARCHAR2(8) NOT NULL	System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
144	IU_TRAN_CD	Character(8)	VARCHAR2(8) NOT NULL	Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
145	FLDNUMVAL1	Number(20,0)	DECIMAL(20) NOT NULL	Fld Num1