PROJ_BI_WRK_VW (SQL View)	Index Back
Project Bill Adj Vw

PROJ_BI_WRK_VW

(SQL View)

Project Bill Adj Vw

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.RESOURCE_ID , A.RESOURCE_ID_FROM , A.BUSINESS_UNIT_GL , A.JOURNAL_ID , A.JOURNAL_DATE , A.UNPOST_SEQ , A.JOURNAL_LINE , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CF16_AN_SBR, A) , A.BUS_UNIT_GL_FROM , A.CURRENCY_CD , A.STATISTICS_CODE , A.LEDGER_GROUP , A.ANALYSIS_TYPE , A.RESOURCE_TYPE , A.RESOURCE_CATEGORY , A.RESOURCE_SUB_CAT , A.RES_USER1 , A.RES_USER2 , A.RES_USER3 , A.RES_USER4 , A.RES_USER5 , A.TRANS_DT , A.ACCOUNTING_DT , A.OPRID , A.DTTM_STAMP , A.JRNL_LN_REF , A.OPEN_ITEM_STATUS , A.LINE_DESCR , A.JRNL_LINE_STATUS , A.JOURNAL_LINE_DATE , A.FOREIGN_CURRENCY , A.RT_TYPE , A.FOREIGN_AMOUNT , A.PROCESS_INSTANCE , A.PC_DISTRIB_STATUS , A.GL_DISTRIB_STATUS , A.PROJ_TRANS_TYPE , A.PROJ_TRANS_CODE , A.RESOURCE_STATUS , A.DESCR , A.SYSTEM_SOURCE , A.UNIT_OF_MEASURE , A.EMPLID , A.EMPL_RCD , A.SEQ_NBR , A.COMPANY , A.BUSINESS_UNIT_AP , A.VENDOR_ID , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.APPL_JRNL_ID , A.PYMNT_CNT , A.DST_ACCT_TYPE , A.PO_DISTRIB_STATUS , A.BUSINESS_UNIT_PO , A.REQ_ID , A.REQ_LINE_NBR , A.REQ_SCHED_NBR , A.REQ_DISTRIB_NBR , A.PO_ID , A.DUE_DATE , A.LINE_NBR , A.SCHED_NBR , A.DISTRIB_LINE_NUM , A.AM_DISTRIB_STATUS , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.PROFILE_ID , A.COST_TYPE , A.BOOK , A.CONTRACT_NUM , A.CONTRACT_LINE_NUM , A.CONTRACT_PPD_SEQ , A.BI_DISTRIB_STATUS , A.BUSINESS_UNIT_BI , A.REV_DISTRIB_STATUS , A.BUSINESS_UNIT_AR , A.CUST_ID , A.ITEM , A.ITEM_LINE , A.ITEM_SEQ_NUM , A.DST_SEQ_NUM , A.BUSINESS_UNIT_IN , A.SCHED_LINE_NO , A.DEMAND_LINE_NO , A.INV_ITEM_ID , A.PAY_END_DT , A.BUSINESS_UNIT_OM , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.RESOURCE_QUANTITY , A.RESOURCE_AMOUNT , A.BUDGET_HDR_STATUS , A.KK_AMOUNT_TYPE , A.KK_TRAN_OVER_FLAG , A.KK_TRAN_OVER_OPRID , A.KK_TRAN_OVER_DTTM , A.BUDGET_OVER_ALLOW , A.BUDGET_LINE_STATUS , A.BUDGET_DT , A.LEDGER , A.BD_DISTRIB_STATUS , A.BUSINESS_UNIT_BD , A.FA_STATUS , A.TIME_SHEET_ID , A.SHEET_ID , A.DT_TIMESTAMP , A.VCHR_DIST_LINE_NUM , A.PM_REVIEWED , A.PRICED_RATE ,A.ACTIVITY_ID_DETAIL ,A.CST_DISTRIB_STATUS ,A.TXN_LMT_TRANS_ID ,A.EVENT_NUM ,A.CA_FEE_STATUS ,%subrec(WM_WO_SBR, A) ,A.COMPRESS_ID ,A.AMOUNT_IN_EXCESS ,A.RECLAIMED_FROM_OL , A.FND_DIST_STATUS , A.SEQ_TRANS_ID , A.DIST_TRANS_ID , A.ADJ_LINE_TYPE , A.FEEDER_SUM_ID , A.PRICE_SUM_ID , A.DEPOSIT_BU , A.DEPOSIT_ID , A.PAYMENT_SEQ_NUM FROM PS_PROJ_RESOURCE A

Parent record: PROJ_ACTIVITY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: PROJ_ACTIVITY.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Default Value: PROJ_ACTIVITY.PROJECT_ID
Prompt Table: PROJ_SCRTY_SRCH

3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Default Value: PROJ_ACTIVITY.ACTIVITY_ID
Prompt Table: PROJ_ACT_SRCH

4 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID

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

6 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Prompt Table: PC_INT_TMPL_GL

7 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.
Prompt Table: PC_GL_JRNL_VW

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

9 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".

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

11 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

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

13 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
Prompt Table: GL_ACCT_BUGL_VW

14 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
Prompt Table: ALT_BUGL_VW

15 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPTID_BUGL_VW

16 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW

17 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_BUGL_VW

18 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_BUGL_VW

19 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASSCF_BUGL_VW

20 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW

21 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_BUGL_VW

22 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

23 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

24 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

25 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CF1_BUGL_VW

26 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW

27 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW

28 BUS_UNIT_GL_FROM Character(5) VARCHAR2(5) NOT NULL From Business Unit GL
Prompt Table: PC_INT_TMPL_GL

29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: PC_INT_TMPL.CURRENCY_CD
Prompt Table: CURRENCY_CD_TBL

30 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
Prompt Table: STAT_BUGL_VW

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

32 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
Prompt Table: PROJ_AN_GRP_VW

33 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Prompt Table: PROJ_RES_TYPE

34 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
Prompt Table: %EDITTABLE

35 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
Prompt Table: %EDITTABLE2

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

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

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

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

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

41 TRANS_DT Date(10) DATE Transaction Date
Default Value: %date

42 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %date

43 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW

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

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

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

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

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

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

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

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

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

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

54 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
Default Value: I

55 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
Default Value: I

56 PROJ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Project Transaction Type
Prompt Table: PROJ_TRANS_TYPE

57 PROJ_TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Project Transaction Code
Prompt Table: PROJ_TRANS_CODE

58 RESOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
A=Resource Approved
U=Unapproved Resource
Default Value: A

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

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

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

62 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PROJ_TEAM_VW

63 EMPL_RCD_NUM Number(3,0) SMALLINT NOT NULL Project Employee Job Record #

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

65 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Default Value: PC_INT_TMPL.BUSINESS_UNIT_HR

66 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
Default Value: PC_INT_TMPL.BUSINESS_UNIT_AP
Prompt Table: SP_BU_AP_NONVW

67 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: PROJ_VENDOR_VW

68 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
Prompt Table: PC_AP_VCHR_VW

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

70 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
Prompt Table: JRNLGEN_APPL_ID

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

72 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

73 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
Default Value: 0

74 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
Default Value: PC_INT_TMPL.BUSINESS_UNIT_PO
Prompt Table: SP_BU_PM_NONVW

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

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

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

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

79 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
Prompt Table: PC_PO_HDR_VW

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

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

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

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

84 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

85 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
Default Value: PC_INT_TMPL.BUSINESS_UNIT_AM
Prompt Table: SP_BU_AM_NONVW

86 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
Prompt Table: PROJ_ASSET_VW

87 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
Prompt Table: PROFILE_PCAM_VW

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

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

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

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

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

93 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
Default Value: N

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

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

96 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit
Prompt Table: SP_BUARED_NONVW

97 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.
Prompt Table: PROJ_CUST_VW

98 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.
Prompt Table: ITEM_OPEN_PC_VW

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

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

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

102 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
Default Value: PC_INT_TMPL.BUSINESS_UNIT_IN
Prompt Table: SP_BUIN_NONVW

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

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

105 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: PROJ_ITEM_VW

106 PAY_END_DT Date(10) DATE Pay Period End Date

107 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
Prompt Table: SP_BUPCOM_NONVW

108 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

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

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

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

112 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

113 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

114 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes

115 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator

116 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime

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

118 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

119 BUDGET_DT Date(10) DATE Budget Date

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

121 BD_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL BD Distribution Status
D=Distributed
I=Ignore
N=None
Default Value: N

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

123 FA_STATUS Character(1) VARCHAR2(1) NOT NULL F&A Status
Default Value: N

124 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)

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

126 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

127 VCHR_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line Number

128 PM_REVIEWED Character(1) VARCHAR2(1) NOT NULL Reviewed
A=All
N=Not Reviewed
Y=Reviewed

129 PRICED_RATE Signed Number(28,3) DECIMAL(26,3) NOT NULL Rate used by Pricing engine to calculate amount on transactions for billing. Rate is quantity related.

130 ACTIVITY_ID_DETAIL Character(15) VARCHAR2(15) NOT NULL This field identifies the detail Activity ID used for charging time reports in Expenses. This field is only used if the project charging level is set to summarize activity charges to level 1, 2, or 3 of the wbs. ACTIVITY_ID_DETAIL stores the detail activity used in time report charging, whereas the ACTIVITY_ID stores the parent activity at the appropriate charging level.

131 CST_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Cost Distribution Status
C=Created
D=Distributed
G=Generated
I=Ignore
N=Not Distributed

132 TXN_LMT_TRANS_ID Character(10) VARCHAR2(10) NOT NULL Transaction Limit Identifer

133 EVENT_NUM Number(3,0) SMALLINT NOT NULL Event Number

134 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

135 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
Prompt Table: SP_BU_WM_NONVW

136 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
Prompt Table: %EDIT_WO_ID

137 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
Prompt Table: %EDIT_WO_TASK

138 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material

139 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.
Prompt Table: %EDIT_RES_LINE

140 COMPRESS_ID Number(10,0) DECIMAL(10) NOT NULL A unique identifier for a single run instance of the Project Compression Utility (PC_COMPRESS)

141 AMOUNT_IN_EXCESS Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether the amount is in excess.

142 RECLAIMED_FROM_OL Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether the amount was reclaimed from over the limit.

143 FND_DIST_STATUS Character(1) VARCHAR2(1) NOT NULL Funds Distribution Status
1=No Matching Sequence
2=Insufficient Threshold Amount
3=Insufficient Distribute Amount
A=Active
B=Funds Burden
C=Complete
D=Distributed
G=Generated
H=Related BAJ Row
I=Ignore
N=Not Disitrbuted

144 SEQ_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Sequence Transaction ID

145 DIST_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Distribution Transaction ID

146 ADJ_LINE_TYPE Character(3) VARCHAR2(3) NOT NULL Adjustment Line Type
ACR=Adjustment Credit Line
ADJ=Adjustment
ARB=Adjustment Rebill Line
REG=Regular bill line (not adjust)

147 FEEDER_SUM_ID Number(16,0) DECIMAL(16) NOT NULL Feeder Summarization ID relates the summed Project Transactions row to its corresponding detail transactions.

148 PRICE_SUM_ID Number(16,0) DECIMAL(16) NOT NULL Price Summarization ID relates the summed Project Transactions row in PC_PRICE_SUM to its corresponding detail transactions in PROJ_RESOURCE.

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

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

151 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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: PROJ_ACTIVITY.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Default Value: PROJ_ACTIVITY.PROJECT_ID Prompt Table: PROJ_SCRTY_SRCH
3	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Default Value: PROJ_ACTIVITY.ACTIVITY_ID Prompt Table: PROJ_ACT_SRCH
4	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
5	RESOURCE_ID_FROM	Character(40)	VARCHAR2(40) NOT NULL	Original Transaction ID
6	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: PC_INT_TMPL_GL
7	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. Prompt Table: PC_GL_JRNL_VW
8	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
9	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".
10	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.
11	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
12	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.
13	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: GL_ACCT_BUGL_VW
14	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: ALT_BUGL_VW
15	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_BUGL_VW
16	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
17	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
18	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
19	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
20	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
21	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
22	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
23	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
24	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
25	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
26	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
27	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
28	BUS_UNIT_GL_FROM	Character(5)	VARCHAR2(5) NOT NULL	From Business Unit GL Prompt Table: PC_INT_TMPL_GL
29	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: PC_INT_TMPL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
30	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code Prompt Table: STAT_BUGL_VW
31	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
32	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: PROJ_AN_GRP_VW
33	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RES_TYPE
34	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDITTABLE
35	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDITTABLE2
36	RES_USER1	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 1
37	RES_USER2	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 2
38	RES_USER3	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 3
39	RES_USER4	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 4
40	RES_USER5	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 5
41	TRANS_DT	Date(10)	DATE	Transaction Date Default Value: %date
42	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple Default Value: %date
43	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPRID_VW
44	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.
45	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.
46	OPEN_ITEM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Open Item Status C=Closed Item N=Not an Open Item Account O=Open Item
47	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.
48	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)
49	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.
50	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
51	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.
52	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.
53	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
54	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 Default Value: I
55	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 Default Value: I
56	PROJ_TRANS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Project Transaction Type Prompt Table: PROJ_TRANS_TYPE
57	PROJ_TRANS_CODE	Character(5)	VARCHAR2(5) NOT NULL	Project Transaction Code Prompt Table: PROJ_TRANS_CODE
58	RESOURCE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Transaction Status A=Resource Approved U=Unapproved Resource Default Value: A
59	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
60	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.
61	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL
62	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PROJ_TEAM_VW
63	EMPL_RCD_NUM	Number(3,0)	SMALLINT NOT NULL	Project Employee Job Record #
64	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
65	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Default Value: PC_INT_TMPL.BUSINESS_UNIT_HR
66	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit Default Value: PC_INT_TMPL.BUSINESS_UNIT_AP Prompt Table: SP_BU_AP_NONVW
67	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: PROJ_VENDOR_VW
68	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID Prompt Table: PC_AP_VCHR_VW
69	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
70	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template Prompt Table: JRNLGEN_APPL_ID
71	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
72	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
73	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 Default Value: 0
74	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit Default Value: PC_INT_TMPL.BUSINESS_UNIT_PO Prompt Table: SP_BU_PM_NONVW
75	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
76	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
77	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
78	REQ_DISTRIB_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Distrib Number
79	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Prompt Table: PC_PO_HDR_VW
80	DUE_DATE	Date(10)	DATE	Delivery Due Date from PO
81	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
82	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
83	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
84	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
85	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit Default Value: PC_INT_TMPL.BUSINESS_UNIT_AM Prompt Table: SP_BU_AM_NONVW
86	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification Prompt Table: PROJ_ASSET_VW
87	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID Prompt Table: PROFILE_PCAM_VW
88	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type
89	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
90	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
91	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
92	CONTRACT_PPD_SEQ	Number(5,0)	INTEGER NOT NULL	Prepaid Add Sequence
93	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 Default Value: N
94	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
95	REV_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Revenue Distribution Status C=Created D=Distributed G=Generated I=Ignore N=Not Distributed
96	BUSINESS_UNIT_AR	Character(5)	VARCHAR2(5) NOT NULL	AR Business Unit Prompt Table: SP_BUARED_NONVW
97	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. Prompt Table: PROJ_CUST_VW
98	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. Prompt Table: ITEM_OPEN_PC_VW
99	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
100	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
101	DST_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Distribution Sequence
102	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit Default Value: PC_INT_TMPL.BUSINESS_UNIT_IN Prompt Table: SP_BUIN_NONVW
103	SCHED_LINE_NO	Number(7,2)	DECIMAL(6,2) NOT NULL	Sched Line NO
104	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
105	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: PROJ_ITEM_VW
106	PAY_END_DT	Date(10)	DATE	Pay Period End Date
107	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit Prompt Table: SP_BUPCOM_NONVW
108	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
109	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
110	RESOURCE_QUANTITY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Quantity
111	RESOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
112	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
113	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
114	KK_TRAN_OVER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control source transaction override flag N=No Y=Yes
115	KK_TRAN_OVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Commitment Control source transaction override operator
116	KK_TRAN_OVER_DTTM	DateTime(26)	TIMESTAMP	Commitment Control source transaction override datetime
117	BUDGET_OVER_ALLOW	Character(1)	VARCHAR2(1) NOT NULL	Budget Overrun Allowed
118	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
119	BUDGET_DT	Date(10)	DATE	Budget Date
120	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
121	BD_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	BD Distribution Status D=Distributed I=Ignore N=None Default Value: N
122	BUSINESS_UNIT_BD	Character(5)	VARCHAR2(5) NOT NULL	Budgeting Business Unit
123	FA_STATUS	Character(1)	VARCHAR2(1) NOT NULL	F&A Status Default Value: N
124	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated)
125	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
126	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
127	VCHR_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line Number
128	PM_REVIEWED	Character(1)	VARCHAR2(1) NOT NULL	Reviewed A=All N=Not Reviewed Y=Reviewed
129	PRICED_RATE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Rate used by Pricing engine to calculate amount on transactions for billing. Rate is quantity related.
130	ACTIVITY_ID_DETAIL	Character(15)	VARCHAR2(15) NOT NULL	This field identifies the detail Activity ID used for charging time reports in Expenses. This field is only used if the project charging level is set to summarize activity charges to level 1, 2, or 3 of the wbs. ACTIVITY_ID_DETAIL stores the detail activity used in time report charging, whereas the ACTIVITY_ID stores the parent activity at the appropriate charging level.
131	CST_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Cost Distribution Status C=Created D=Distributed G=Generated I=Ignore N=Not Distributed
132	TXN_LMT_TRANS_ID	Character(10)	VARCHAR2(10) NOT NULL	Transaction Limit Identifer
133	EVENT_NUM	Number(3,0)	SMALLINT NOT NULL	Event Number
134	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
135	BUSINESS_UNIT_WO	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Work Order Prompt Table: SP_BU_WM_NONVW
136	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification Prompt Table: %EDIT_WO_ID
137	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number Prompt Table: %EDIT_WO_TASK
138	RSRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Work Order Management Resource Types 1=Labor 2=Tools 3=Material
139	RES_LN_NBR	Number(5,0)	INTEGER NOT NULL	Resource Line No. Prompt Table: %EDIT_RES_LINE
140	COMPRESS_ID	Number(10,0)	DECIMAL(10) NOT NULL	A unique identifier for a single run instance of the Project Compression Utility (PC_COMPRESS)
141	AMOUNT_IN_EXCESS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether the amount is in excess.
142	RECLAIMED_FROM_OL	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether the amount was reclaimed from over the limit.
143	FND_DIST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Funds Distribution Status 1=No Matching Sequence 2=Insufficient Threshold Amount 3=Insufficient Distribute Amount A=Active B=Funds Burden C=Complete D=Distributed G=Generated H=Related BAJ Row I=Ignore N=Not Disitrbuted
144	SEQ_TRANS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Transaction ID
145	DIST_TRANS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Distribution Transaction ID
146	ADJ_LINE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Adjustment Line Type ACR=Adjustment Credit Line ADJ=Adjustment ARB=Adjustment Rebill Line REG=Regular bill line (not adjust)
147	FEEDER_SUM_ID	Number(16,0)	DECIMAL(16) NOT NULL	Feeder Summarization ID relates the summed Project Transactions row to its corresponding detail transactions.
148	PRICE_SUM_ID	Number(16,0)	DECIMAL(16) NOT NULL	Price Summarization ID relates the summed Project Transactions row in PC_PRICE_SUM to its corresponding detail transactions in PROJ_RESOURCE.
149	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
150	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.
151	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.