PC_COMPRESS_TPL (SQL Table)	Index Back
Compression Template Defines the parameters for summarizing, date rollup, and details during the project compression process.

PC_COMPRESS_TPL

(SQL Table)

Compression Template

Defines the parameters for summarizing, date rollup, and details during the project compression process.

Related Language Record: PC_COMPRESS_TLG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 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
Default Value: Y

4 DEFAULT_LBL Character(1) VARCHAR2(1) NOT NULL Default
Y/N Table Edit
Default Value: N

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

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
Default Value: Y

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
Default Value: Y

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
Default Value: M

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
Default Value: S

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
Default Value: Y

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
Default Value: Y

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
Default Value: Y

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

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

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

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

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 Number(6,0) INTEGER NOT NULL Item Line

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

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

70 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

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

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

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

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

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

76 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

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

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

79 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

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

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

82 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

83 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

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

85 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

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

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

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

89 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

90 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

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

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

93 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

94 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

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

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

97 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

98 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

99 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

100 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

101 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

102 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

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

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

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

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

107 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

108 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

109 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

110 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

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

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

113 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

114 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

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

116 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

117 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

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

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

120 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

121 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

122 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

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

124 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

125 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

126 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

127 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

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

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

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

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

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

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

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

135 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

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

137 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

138 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.

139 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.

140 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPRESS_TEMPLATE	Character(15)	VARCHAR2(15) NOT NULL	A unique identifier for a Project Compression template.
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	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 Default Value: Y
4	DEFAULT_LBL	Character(1)	VARCHAR2(1) NOT NULL	Default Y/N Table Edit Default Value: N
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Y/N Table Edit Default Value: Y
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 Default Value: Y
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 Default Value: Y
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 Default Value: M
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 Default Value: S
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 Default Value: Y
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 Default Value: Y
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 Default Value: Y
21	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Y/N Table Edit Default Value: Y
22	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Y/N Table Edit Default Value: Y
23	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Y/N Table Edit Default Value: Y
24	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Y/N Table Edit Default Value: Y
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	Number(6,0)	INTEGER NOT NULL	Item Line
68	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
69	DST_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Distribution Sequence
70	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
71	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit Y/N Table Edit
72	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification Y/N Table Edit
73	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID Y/N Table Edit
74	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name Y/N Table Edit
75	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type Y/N Table Edit
76	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
77	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit Y/N Table Edit
78	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice Y/N Table Edit
79	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
80	TXN_LMT_TRANS_ID	Character(10)	VARCHAR2(10) NOT NULL	Transaction Limit Identifer Y/N Table Edit
81	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Y/N Table Edit
82	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
83	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
84	PM_REVIEWED	Character(1)	VARCHAR2(1) NOT NULL	Reviewed A=All N=Not Reviewed Y=Reviewed Y/N Table Edit
85	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
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 Y/N Table Edit
87	BUSINESS_UNIT_BD	Character(5)	VARCHAR2(5) NOT NULL	Budgeting Business Unit Y/N Table Edit
88	BD_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	BD Distribution Status D=Distributed I=Ignore N=None Y/N Table Edit
89	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
90	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
91	KK_TRAN_OVER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control source transaction override flag N=No Y=Yes Y/N Table Edit
92	BUDGET_OVER_ALLOW	Character(1)	VARCHAR2(1) NOT NULL	Budget Overrun Allowed Y/N Table Edit
93	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
94	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
95	EX_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Documentation ID Y/N Table Edit
96	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID Y/N Table Edit
97	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
98	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
99	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
100	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
101	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
102	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
103	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code Y/N Table Edit
104	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group Y/N Table Edit
105	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger Y/N Table Edit
106	BUS_UNIT_GL_FROM	Character(5)	VARCHAR2(5) NOT NULL	From Business Unit GL Y/N Table Edit
107	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
108	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
109	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
110	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
111	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit Y/N Table Edit
112	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Y/N Table Edit
113	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
114	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
115	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit Y/N Table Edit
116	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
117	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
118	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit Y/N Table Edit
119	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Y/N Table Edit
120	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
121	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
122	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
123	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID Y/N Table Edit
124	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
125	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
126	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
127	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
128	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Y/N Table Edit
129	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Y/N Table Edit
130	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Y/N Table Edit
131	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated) Y/N Table Edit
132	TIME_RPTG_CD	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code Y/N Table Edit
133	BUSINESS_UNIT_WO	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Work Order Y/N Table Edit
134	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification Y/N Table Edit
135	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
136	RSRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Work Order Management Resource Types 1=Labor 2=Tools 3=Material Y/N Table Edit
137	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
138	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
139	DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
140	PAYMENT_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.