PC_CMP1_AET (SQL Table)	Index Back
Compression Template State Rec State record that holds the value of the Compression Template selected on the Project Compression run control page. Defines the parameters for summarizing, date rollup, and details during the project compression process.

PC_CMP1_AET

(SQL Table)

Compression Template State Rec

State record that holds the value of the Compression Template selected on the Project Compression run control page. Defines the parameters for summarizing, date rollup, and details during the project compression process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 COMPRESS_TEMPLATE Character(15) VARCHAR2(15) NOT NULL A unique identifier for a Project Compression template.

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

4 RESOURCE_AMT_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Y/N Table Edit

6 RESOURCE_QTY_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

7 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Y/N Table Edit

8 FOREIGN_AMT_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

9 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
Y/N Table Edit

10 DATE_ROLLUP_LEVEL Character(1) VARCHAR2(1) NOT NULL Defines the summary rollup options for date summarization.
M=Monthly
Q=Quarterly
W=Weekly
Y=Yearly

11 ROLLUP_DATE_USED Character(1) VARCHAR2(1) NOT NULL Defines which date to use on summary rows: start of period date, or end of period date.
E=End of Period
S=Start of Period

12 ACCOUNTING_DT_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

13 TRANS_DT_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

14 BILLING_DATE_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

15 JOURNAL_DATE_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

16 JRNL_LN_DATE_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

17 DUE_DATE_FLG Character(1) VARCHAR2(1) NOT NULL Redetrmine due dates flag
Y/N Table Edit

18 BUDGET_DT_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

19 PAY_END_DT_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

20 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Y/N Table Edit

21 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Y/N Table Edit

22 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Y/N Table Edit

23 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
Y/N Table Edit

24 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Y/N Table Edit

25 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Y/N Table Edit

26 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
Y/N Table Edit

27 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
Y/N Table Edit

28 PROJ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Project Transaction Type
Y/N Table Edit

29 PROJ_TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Project Transaction Code
Y/N Table Edit

30 RESOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
A=Resource Approved
U=Unapproved Resource
Y/N Table Edit

31 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.
Y/N Table Edit

32 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.
Y/N Table Edit

33 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
Y/N Table Edit

34 CST_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Cost Distribution Status
C=Created
D=Distributed
G=Generated
I=Ignore
N=Not Distributed
Y/N Table Edit

35 REV_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Revenue Distribution Status
C=Created
D=Distributed
G=Generated
I=Ignore
N=Not Distributed
Y/N Table Edit

36 RES_USER1 Character(10) VARCHAR2(10) NOT NULL Transaction User 1
Y/N Table Edit

37 RES_USER2 Character(10) VARCHAR2(10) NOT NULL Transaction User 2
Y/N Table Edit

38 RES_USER3 Character(10) VARCHAR2(10) NOT NULL Transaction User 3
Y/N Table Edit

39 RES_USER4 Character(10) VARCHAR2(10) NOT NULL Transaction User 4
Y/N Table Edit

40 RES_USER5 Character(10) VARCHAR2(10) NOT NULL Transaction User 5
Y/N Table Edit

41 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Y/N Table Edit

42 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
Y/N Table Edit

43 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
Y/N Table Edit

44 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Y/N Table Edit

45 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Y/N Table Edit
Default Value: Y

46 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Y/N Table Edit
Default Value: Y

47 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Y/N Table Edit
Default Value: Y

48 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Y/N Table Edit
Default Value: Y

49 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Y/N Table Edit
Default Value: Y

50 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Y/N Table Edit
Default Value: Y

51 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Y/N Table Edit
Default Value: Y

52 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Y/N Table Edit
Default Value: Y

53 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Y/N Table Edit
Default Value: Y

54 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Y/N Table Edit
Default Value: Y

55 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Y/N Table Edit
Default Value: Y

56 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Y/N Table Edit
Default Value: Y

57 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
Y/N Table Edit

58 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Y/N Table Edit

59 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
Y/N Table Edit

60 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
Y/N Table Edit

61 VOUCHER_LINE_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

62 VCHR_DIST_LINE_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

63 PYMNT_CNT_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

64 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit
Y/N Table Edit

65 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.
Y/N Table Edit

66 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.
Y/N Table Edit

67 ITEM_LINE_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

68 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
Y/N Table Edit

69 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
Y/N Table Edit

70 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
Y/N Table Edit

71 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
Y/N Table Edit

72 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
Y/N Table Edit

73 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
Y/N Table Edit

74 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
Y/N Table Edit

75 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
Y/N Table Edit

76 PRICED_RATE_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

77 TXN_LMT_TRANS_ID Character(10) VARCHAR2(10) NOT NULL Transaction Limit Identifer
Y/N Table Edit

78 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
Y/N Table Edit

79 CONTRACT_LINE_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

80 CONTRACT_PPD_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

81 PM_REVIEWED Character(1) VARCHAR2(1) NOT NULL Reviewed
A=All
N=Not Reviewed
Y=Reviewed
Y/N Table Edit

82 CA_FEE_STATUS Character(1) VARCHAR2(1) NOT NULL Cost Plus Fee Status for Governement Contracts
1=Fee Generated
2=Bil Actual Fee
3=Bil Additional Award Fee
4=Rev Actual Fee
5=Rev Additional Award Fee
Y/N Table Edit

83 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
Y/N Table Edit

84 BUSINESS_UNIT_BD Character(5) VARCHAR2(5) NOT NULL Budgeting Business Unit
Y/N Table Edit

85 BD_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL BD Distribution Status
D=Distributed
I=Ignore
N=None
Y/N Table Edit

86 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
Y/N Table Edit

87 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
Y/N Table Edit

88 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
Y/N Table Edit

89 BUDGET_OVER_ALLOW Character(1) VARCHAR2(1) NOT NULL Budget Overrun Allowed
Y/N Table Edit

90 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
Y/N Table Edit

91 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
Y/N Table Edit

92 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Documentation ID
Y/N Table Edit

93 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
Y/N Table Edit

94 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.
Y/N Table Edit

95 JOURNAL_LINE_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

96 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.
Y/N Table Edit

97 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)
Y/N Table Edit

98 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
Y/N Table Edit

99 UNPOST_SEQ_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

100 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
Y/N Table Edit

101 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
Y/N Table Edit

102 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
Y/N Table Edit

103 BUS_UNIT_GL_FROM Character(5) VARCHAR2(5) NOT NULL From Business Unit GL
Y/N Table Edit

104 OPEN_ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Open Item Status
C=Closed Item
N=Not an Open Item Account
O=Open Item
Y/N Table Edit

105 FISCAL_YEAR_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

106 ACCTG_PERIOD_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

107 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
Y/N Table Edit

108 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
Y/N Table Edit

109 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Y/N Table Edit

110 DEMAND_LINE_NO_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

111 SCHED_LINE_NO_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

112 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
Y/N Table Edit

113 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
Y/N Table Edit

114 ORDER_INT_LINE_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

115 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
Y/N Table Edit

116 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
Y/N Table Edit

117 LINE_NBR_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

118 SCHED_NBR_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

119 DISTRIB_LN_NUM_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

120 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
Y/N Table Edit

121 REQ_LINE_NBR_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

122 REQ_SCHED_NBR_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

123 REQ_DISTRIB_NO_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

124 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
Y/N Table Edit

125 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Y/N Table Edit

126 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
Y/N Table Edit

127 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Y/N Table Edit

128 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
Y/N Table Edit

129 TIME_RPTG_CD Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
Y/N Table Edit

130 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
Y/N Table Edit

131 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
Y/N Table Edit

132 WO_TASK_ID_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

133 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material
Y/N Table Edit

134 RES_LN_NBR_FLG Character(1) VARCHAR2(1) NOT NULL A yes/no flag that identifies whether the field is to be included in Project Compression details.
Y/N Table Edit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	COMPRESS_TEMPLATE	Character(15)	VARCHAR2(15) NOT NULL	A unique identifier for a Project Compression template.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	RESOURCE_AMT_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Y/N Table Edit
6	RESOURCE_QTY_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
7	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Y/N Table Edit
8	FOREIGN_AMT_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
9	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code Y/N Table Edit
10	DATE_ROLLUP_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Defines the summary rollup options for date summarization. M=Monthly Q=Quarterly W=Weekly Y=Yearly
11	ROLLUP_DATE_USED	Character(1)	VARCHAR2(1) NOT NULL	Defines which date to use on summary rows: start of period date, or end of period date. E=End of Period S=Start of Period
12	ACCOUNTING_DT_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
13	TRANS_DT_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
14	BILLING_DATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
15	JOURNAL_DATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
16	JRNL_LN_DATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
17	DUE_DATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Redetrmine due dates flag Y/N Table Edit
18	BUDGET_DT_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
19	PAY_END_DT_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
20	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Y/N Table Edit
21	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Y/N Table Edit
22	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Y/N Table Edit
23	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Y/N Table Edit
24	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Y/N Table Edit
25	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Y/N Table Edit
26	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Y/N Table Edit
27	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Y/N Table Edit
28	PROJ_TRANS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Project Transaction Type Y/N Table Edit
29	PROJ_TRANS_CODE	Character(5)	VARCHAR2(5) NOT NULL	Project Transaction Code Y/N Table Edit
30	RESOURCE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Transaction Status A=Resource Approved U=Unapproved Resource Y/N Table Edit
31	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. Y/N Table Edit
32	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. Y/N Table Edit
33	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 Y/N Table Edit
34	CST_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Cost Distribution Status C=Created D=Distributed G=Generated I=Ignore N=Not Distributed Y/N Table Edit
35	REV_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Revenue Distribution Status C=Created D=Distributed G=Generated I=Ignore N=Not Distributed Y/N Table Edit
36	RES_USER1	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 1 Y/N Table Edit
37	RES_USER2	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 2 Y/N Table Edit
38	RES_USER3	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 3 Y/N Table Edit
39	RES_USER4	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 4 Y/N Table Edit
40	RES_USER5	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 5 Y/N Table Edit
41	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Y/N Table Edit
42	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Y/N Table Edit
43	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Y/N Table Edit
44	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Y/N Table Edit
45	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Y/N Table Edit Default Value: Y
46	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Y/N Table Edit Default Value: Y
47	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Y/N Table Edit Default Value: Y
48	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Y/N Table Edit Default Value: Y
49	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Y/N Table Edit Default Value: Y
50	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Y/N Table Edit Default Value: Y
51	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Y/N Table Edit Default Value: Y
52	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Y/N Table Edit Default Value: Y
53	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Y/N Table Edit Default Value: Y
54	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Y/N Table Edit Default Value: Y
55	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Y/N Table Edit Default Value: Y
56	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Y/N Table Edit Default Value: Y
57	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit Y/N Table Edit
58	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Y/N Table Edit
59	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template Y/N Table Edit
60	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID Y/N Table Edit
61	VOUCHER_LINE_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
62	VCHR_DIST_LINE_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
63	PYMNT_CNT_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
64	BUSINESS_UNIT_AR	Character(5)	VARCHAR2(5) NOT NULL	AR Business Unit Y/N Table Edit
65	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. Y/N Table Edit
66	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. Y/N Table Edit
67	ITEM_LINE_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
68	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit Y/N Table Edit
69	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification Y/N Table Edit
70	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID Y/N Table Edit
71	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name Y/N Table Edit
72	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type Y/N Table Edit
73	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 Y/N Table Edit
74	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit Y/N Table Edit
75	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice Y/N Table Edit
76	PRICED_RATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
77	TXN_LMT_TRANS_ID	Character(10)	VARCHAR2(10) NOT NULL	Transaction Limit Identifer Y/N Table Edit
78	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Y/N Table Edit
79	CONTRACT_LINE_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
80	CONTRACT_PPD_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
81	PM_REVIEWED	Character(1)	VARCHAR2(1) NOT NULL	Reviewed A=All N=Not Reviewed Y=Reviewed Y/N Table Edit
82	CA_FEE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Cost Plus Fee Status for Governement Contracts 1=Fee Generated 2=Bil Actual Fee 3=Bil Additional Award Fee 4=Rev Actual Fee 5=Rev Additional Award Fee Y/N Table Edit
83	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 Y/N Table Edit
84	BUSINESS_UNIT_BD	Character(5)	VARCHAR2(5) NOT NULL	Budgeting Business Unit Y/N Table Edit
85	BD_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	BD Distribution Status D=Distributed I=Ignore N=None Y/N Table Edit
86	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid Y/N Table Edit
87	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 Y/N Table Edit
88	KK_TRAN_OVER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control source transaction override flag N=No Y=Yes Y/N Table Edit
89	BUDGET_OVER_ALLOW	Character(1)	VARCHAR2(1) NOT NULL	Budget Overrun Allowed Y/N Table Edit
90	KK_AMOUNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Amount Type 0=Budget 1=Actuals and Recognized 2=Encumbrance 3=Pre-Encumbrance 4=Collected Revenue 5=Planned 7=Actuals, Recognize and Collect 9=Dynamic Y/N Table Edit
91	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 Y/N Table Edit
92	EX_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Documentation ID Y/N Table Edit
93	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID Y/N Table Edit
94	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. Y/N Table Edit
95	JOURNAL_LINE_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
96	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. Y/N Table Edit
97	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) Y/N Table Edit
98	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 Y/N Table Edit
99	UNPOST_SEQ_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
100	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code Y/N Table Edit
101	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group Y/N Table Edit
102	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger Y/N Table Edit
103	BUS_UNIT_GL_FROM	Character(5)	VARCHAR2(5) NOT NULL	From Business Unit GL Y/N Table Edit
104	OPEN_ITEM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Open Item Status C=Closed Item N=Not an Open Item Account O=Open Item Y/N Table Edit
105	FISCAL_YEAR_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
106	ACCTG_PERIOD_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
107	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 Y/N Table Edit
108	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit Y/N Table Edit
109	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Y/N Table Edit
110	DEMAND_LINE_NO_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
111	SCHED_LINE_NO_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
112	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit Y/N Table Edit
113	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 Y/N Table Edit
114	ORDER_INT_LINE_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
115	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit Y/N Table Edit
116	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Y/N Table Edit
117	LINE_NBR_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
118	SCHED_NBR_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
119	DISTRIB_LN_NUM_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
120	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID Y/N Table Edit
121	REQ_LINE_NBR_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
122	REQ_SCHED_NBR_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
123	REQ_DISTRIB_NO_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
124	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 Y/N Table Edit
125	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Y/N Table Edit
126	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Y/N Table Edit
127	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Y/N Table Edit
128	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated) Y/N Table Edit
129	TIME_RPTG_CD	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code Y/N Table Edit
130	BUSINESS_UNIT_WO	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Work Order Y/N Table Edit
131	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification Y/N Table Edit
132	WO_TASK_ID_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit
133	RSRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Work Order Management Resource Types 1=Labor 2=Tools 3=Material Y/N Table Edit
134	RES_LN_NBR_FLG	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that identifies whether the field is to be included in Project Compression details. Y/N Table Edit