PC_AM_BK_PCL_VW (SQL View)	Index Back
Project Costing to AM View

PC_AM_BK_PCL_VW

(SQL View)

Project Costing to AM View

SELECT A.INTFC_LINE_NUM ,F.GROUP_ASSET_ID ,A.PARENT_ID ,A.PARENT_DESCR ,F.CATEGORY ,A.QUANTITY ,A.LOCATION ,B.ANALYSIS_GROUP ,A.ASSET_OPTION ,A.GROUP_ASSET_FLAG ,A.IN_SERVICE_DT ,A.RETIREMENT_DT ,A.RETIRE_CONVENTION ,A.DISPOSAL_CODE ,A.RETIREMENT_TYPE ,A.RETIREMENT_STATUS ,0 ,0 ,0 ,0 ,A.TRADE_IN_ASSET_ID ,A.TRADE_IN_DTTM_STMP ,A.TRADE_IN_AMT ,A.GAIN_LOSS ,0 ,0 ,0 ,0 ,%Substring(' ', 1, 1) ,0 ,0 ,0 ,0 ,0 ,0 ,%Substring(' ', 1, 1) ,0 ,0 ,A.TAGGABLE_SW ,A.TAG_NUMBER ,A.ASSET_STATUS ,A.REPLACE_SW ,A.REPLACE_ASSET_ID ,A.ACQUISITION_CD ,A.CUSTODIAN ,A.INTFC_ID ,A.DEFAULT_PROFILE_SW ,F.BK_CAP_THRSHLD_ID ,A.INTFC_STATUS ,A.INTFC_TYPE ,A.LOAD_STATUS ,A.TRANS_CODE ,A.OPEN_TRANS_ID ,A.APPROVAL_SW ,A.BOOK_EFFDT ,A.LOCATION_EFFDT ,A.DESCRSHORT ,A.MANUFACTURER ,A.MODEL ,A.SERIAL_ID ,A.ASSET_ALLOC_QTY ,A.ASSET_ALLOC_AMT ,C.ANALYSIS_TYPE ,C.BOOK ,C.COST_TYPE ,A.DEPTID ,F.CRITERIA_ID , B.BUSINESS_UNIT , B.PROJECT_ID , B.ACTIVITY_ID , C.RESOURCE_ID , C.RESOURCE_ID_FROM , C.BUSINESS_UNIT_GL , C.JOURNAL_ID , C.JOURNAL_DATE , C.UNPOST_SEQ , C.JOURNAL_LINE , C.FISCAL_YEAR , C.ACCOUNTING_PERIOD , C.ACCOUNT , C.ALTACCT , C.DEPTID ,%subrec(CF16_AN_SBR, C) , C.BUS_UNIT_GL_FROM , F.CURRENCY_CD , C.STATISTICS_CODE , C.LEDGER_GROUP , B.ANALYSIS_TYPE , C.RESOURCE_TYPE , C.RESOURCE_CATEGORY , C.RESOURCE_SUB_CAT , C.RES_USER1 , C.RES_USER2 , C.RES_USER3 , C.RES_USER4 , C.RES_USER5 , A.TRANS_DT , A.ACCOUNTING_DT , C.OPRID , C.DTTM_STAMP , C.JRNL_LN_REF , C.OPEN_ITEM_STATUS , C.LINE_DESCR , C.JRNL_LINE_STATUS , C.JOURNAL_LINE_DATE , C.FOREIGN_CURRENCY , C.RT_TYPE , %Round(%DecMult(C.FOREIGN_AMOUNT, D.SIGNED_VALUE), 3) , C.RATE_MULT , C.RATE_DIV , C.CUR_EFFDT , C.PROCESS_INSTANCE , C.PC_DISTRIB_STATUS , C.GL_DISTRIB_STATUS , C.PROJ_TRANS_TYPE , C.PROJ_TRANS_CODE , C.RESOURCE_STATUS , A.DESCR , A.SYSTEM_SOURCE , C.UNIT_OF_MEASURE , C.EMPLID , C.EMPL_RCD , C.SEQ_NBR , C.TIME_RPTG_CD , C.JOBCODE , C.COMPANY , C.BUSINESS_UNIT_AP , C.VENDOR_ID , C.VOUCHER_ID , C.VOUCHER_LINE_NUM , C.APPL_JRNL_ID , C.PYMNT_CNT , C.DST_ACCT_TYPE , C.PO_DISTRIB_STATUS , C.BUSINESS_UNIT_PO , C.REQ_ID , C.REQ_LINE_NBR , C.REQ_SCHED_NBR , C.REQ_DISTRIB_NBR , C.PO_ID , C.DUE_DATE , C.LINE_NBR , C.SCHED_NBR , C.DISTRIB_LINE_NUM , C.AM_DISTRIB_STATUS , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.PROFILE_ID , A.COST_TYPE , F.BOOK , C.INCENTIVE_ID , C.MSTONE_SEQ , C.CONTRACT_NUM , C.CONTRACT_LINE_NUM , C.CONTRACT_PPD_SEQ , C.BI_DISTRIB_STATUS , C.BUSINESS_UNIT_BI , C.BILLING_DATE , C.INVOICE , C.REV_DISTRIB_STATUS , C.BUSINESS_UNIT_AR , C.CUST_ID , C.ITEM , C.ITEM_LINE , C.ITEM_SEQ_NUM , C.DST_SEQ_NUM , C.BUSINESS_UNIT_IN , C.SCHED_LINE_NO , C.DEMAND_LINE_NO , C.INV_ITEM_ID , C.PAY_END_DT , C.BUSINESS_UNIT_OM , C.ORDER_NO , C.ORDER_INT_LINE_NO , C.EX_DOC_ID , C.EX_DOC_TYPE , %Round(A.QUANTITY, 2) , %Round(%DecMult(C.RESOURCE_AMOUNT, D.SIGNED_VALUE), 3) , C.BUDGET_HDR_STATUS , C.KK_AMOUNT_TYPE , C.KK_TRAN_OVER_FLAG , C.KK_TRAN_OVER_OPRID , C.KK_TRAN_OVER_DTTM , C.BUDGET_OVER_ALLOW , C.BUDGET_LINE_STATUS , C.BUDGET_DT , C.LEDGER , C.BD_DISTRIB_STATUS , C.BUSINESS_UNIT_BD , C.FA_STATUS , C.TIME_SHEET_ID , C.SHEET_ID , C.DT_TIMESTAMP , C.VCHR_DIST_LINE_NUM , C.PM_REVIEWED , C.PRICED_RATE , C.ACTIVITY_ID_DETAIL , C.CST_DISTRIB_STATUS , C.TXN_LMT_TRANS_ID , C.EVENT_NUM , C.CA_FEE_STATUS ,%subrec(WM_WO_SBR, C) , C.COMPRESS_ID , C.AMOUNT_IN_EXCESS , C.RECLAIMED_FROM_OL , C.FND_DIST_STATUS , C.SEQ_TRANS_ID , C.DIST_TRANS_ID , C.ADJ_LINE_TYPE , C.FEEDER_SUM_ID , C.PRICE_SUM_ID , C.DEPOSIT_BU , C.DEPOSIT_ID , C.PAYMENT_SEQ_NUM ,%subrec(PC_AM_BOOK_SBR, F) FROM PS_PC_AM_DEFN A , PS_PC_AM_PROJ_DEFN B , PS_PROJ_RESOURCE C , PS_PROJ_AN_GRP_MAP D , PS_PC_AM_AST_BK_VW F WHERE A.BUSINESS_UNIT_AM = B.BUSINESS_UNIT_AM AND A.ASSET_ID = B.ASSET_ID AND A.DEFAULT_PROFILE_SW = 'N' AND A.AM_DISTRIB_STATUS <> 'I' AND B.ASSET_ID NOT IN ( SELECT ASSET_ID FROM PS_PROJ_AM WHERE B.BUSINESS_UNIT = PS_PROJ_AM.BUSINESS_UNIT AND B.PROJECT_ID = PS_PROJ_AM.PROJECT_ID AND B.ACTIVITY_ID = PS_PROJ_AM.ACTIVITY_ID AND B.ANALYSIS_TYPE <> ' ' AND B.BUSINESS_UNIT_AM = PS_PROJ_AM.BUSINESS_UNIT_AM AND PS_PROJ_AM.ASST_REVIEW_STATUS IN ('N','A','R','H')) AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PROJECT_ID = C.PROJECT_ID AND B.ACTIVITY_ID = C.ACTIVITY_ID AND B.ANALYSIS_TYPE <> ' ' AND A.BUSINESS_UNIT_AM = C.BUSINESS_UNIT_AM AND A.PROFILE_ID = C.PROFILE_ID AND B.ANALYSIS_GROUP = D.ANALYSIS_GROUP AND D.ANALYSIS_TYPE = C.ANALYSIS_TYPE AND D.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = B.BUSINESS_UNIT AND RECNAME = 'PROJ_AN_GRP_MAP') AND B.BUSINESS_UNIT_AM = F.BUSINESS_UNIT_AM AND B.ASSET_ID = F.ASSET_ID AND B.BUSINESS_UNIT = F.BUSINESS_UNIT AND B.PROJECT_ID = F.PROJECT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number

2 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID

3 PARENT_ID Character(12) VARCHAR2(12) NOT NULL Parent ID

4 PARENT_DESCR Character(30) VARCHAR2(30) NOT NULL Parent Asset Description

5 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category

6 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
Default Value: 1

7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

8 ANALYSIS_GROUP Character(5) VARCHAR2(5) NOT NULL Analysis Group
Prompt Table: SP_AN_GRP_NONVW

9 ASSET_OPTION Character(3) VARCHAR2(3) NOT NULL Asset Creation Option
ADD=Auto Assign New Asset ID
ADJ=Adjust Existing Asset
MAN=Manually Assign Asset ID

10 GROUP_ASSET_FLAG Character(1) VARCHAR2(1) NOT NULL Group Asset Flag
G=Group Asset
M=Group Member
N=None

11 IN_SERVICE_DT Date(10) DATE In Service Date

12 RETIREMENT_DT Date(10) DATE Projected Retirement Date

13 RETIRE_CONVENTION Character(2) VARCHAR2(2) NOT NULL Retirement Convention

14 DISPOSAL_CODE Character(1) VARCHAR2(1) NOT NULL Retirement Type
A=Abandonment
C=Cannibalize for Other Assets
D=Disappeared Assets
E=Expensed
F=Disposal Due to Theft
I=Returned to Inventory
L=Like Kind Exchange
M=Missing Asset
N=Donated to External Group
O=ARO Settlement
R=Scrapped Assets
S=Retirement by Sale
T=Traded In for another Asset
V=Auto-Retire Fully Depr Assets
Y=Casualty Loss
Default Value: S

15 RETIREMENT_TYPE Character(1) VARCHAR2(1) NOT NULL Retirement Type
E=Extraordinary
O=Ordinary Retirement
Default Value: O

16 RETIREMENT_STATUS Character(1) VARCHAR2(1) NOT NULL Retirement Status
C=Depreciation Calculated
N=New Retirement
P=Posted to General Ledger
R=Reinstated Retirement
U=No Retirements Exist
Default Value: U

17 RETIRE_QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Retirement Quantity

18 RETIREMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Retirement Amount

19 PROCEEDS Signed Number(28,3) DECIMAL(26,3) NOT NULL Retirement Proceeds

20 REMOVAL_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Removal Cost

21 TRADE_IN_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Trade In Asset
Prompt Table: ASSET

22 TRADE_IN_DTTM_STMP DateTime(26) TIMESTAMP Trade In DateTime Stamp

23 TRADE_IN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Trade In Amount

24 GAIN_LOSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Retirement Gain/Loss

25 CASH Signed Number(28,3) DECIMAL(26,3) NOT NULL Cash Received/Paid

26 TRADE_IN_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Trade In value

27 NON_LIKE_KIND Signed Number(28,3) DECIMAL(26,3) NOT NULL FMV Non Like Kind Property

28 LIABILITY_ASSUMED Signed Number(28,3) DECIMAL(26,3) NOT NULL Liabilities Assumed

29 FULLY_DEPR_SW Character(1) VARCHAR2(1) NOT NULL Retire As Fully Depreciated SW
F=Fully Depr with Future Expense
N=Calculate Gain/Loss
Y=Fully Depr no Future Expense

30 TXN_PROCEEDS Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Proceeds

31 TXN_REMOVAL_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Removal Cost

32 TXN_CASH Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Cash

33 TXN_TRADE_IN_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Trade-In Value

34 TXN_NON_LIKE_KIND Signed Number(28,3) DECIMAL(26,3) NOT NULL FMV Non Like-Kind

35 TXN_LIAB_ASSUMED Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Liability Assumed

36 TXN_CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Transaction Currency Display

37 RATE_MULT_2 Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

38 RATE_DIV_2 Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

39 TAGGABLE_SW Character(1) VARCHAR2(1) NOT NULL Taggable Asset
N=Non Taggable Asset
Y=Taggable Asset

40 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number

41 ASSET_STATUS Character(1) VARCHAR2(1) NOT NULL Asset Status
A=Received (Not in Service)
B=Budgeted
C=Commitment
D=Disposed
I=In Service
M=Suspended
R=Requisitioned
T=Transferred
W=Work In Progress

42 REPLACE_SW Character(1) VARCHAR2(1) NOT NULL Replacement Asset

43 REPLACE_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Replaced Asset ID

44 ACQUISITION_CD Character(1) VARCHAR2(1) NOT NULL Acquisition Code
C=Constructed
D=Donated
I=Trade In
K=Like Exchange
L=Leased
P=Purchased
T=Transferred
Default Value: C

45 CUSTODIAN Character(30) VARCHAR2(30) NOT NULL Custodian

46 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID

47 DEFAULT_PROFILE_SW Character(1) VARCHAR2(1) NOT NULL Default Books from Profile

48 BK_CAP_THRSHLD_ID Character(10) VARCHAR2(10) NOT NULL Threshold ID

49 INTFC_STATUS Character(3) VARCHAR2(3) NOT NULL Interface Status
CON=Consolidated
DON=Mass Changes Generated
ERR=Error
NEW=Mass Changes Not Generated
REP=Replaced by Other Records (AP)
UNI=Unitized

50 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type

51 LOAD_STATUS Character(3) VARCHAR2(3) NOT NULL /* -> JMZ. PSOFT. 11-OCT-2002 */ New Status were added : HLD and INP for Asset Management. /* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated
DON=Loaded
ERR=Errored
EXC=Excluded
HLD=On Hold
INP=In Process
NEW=Pending
PGI=PO Grp Incomplete
REP=Replaced
UNI=Unitized

52 TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Transaction Code

53 OPEN_TRANS_ID Number(10,0) DECIMAL(10) NOT NULL Open Transaction ID

54 APPROVAL_SW Character(1) VARCHAR2(1) NOT NULL Auto Approval Status
Y/N Table Edit
Default Value: Y

55 BOOK_EFFDT Date(10) DATE Book Effective Date

56 LOCATION_EFFDT Date(10) DATE Location Effective Date

57 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

58 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name

59 MODEL Character(30) VARCHAR2(30) NOT NULL Model

60 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

61 ASSET_ALLOC_QTY Signed Number(17,2) DECIMAL(15,2) NOT NULL Asset Allocation Basis Qty

62 ASSET_ALLOC_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Asset Allocation Basis Amt

63 AN_TYPE_PROJ_RES Character(3) VARCHAR2(3) NOT NULL Analysis Type on Proj_Res

64 BOOK_PROJ_RES Character(10) VARCHAR2(10) NOT NULL Book on Proj_Resource

65 COST_TYPE_PROJ_RES Character(1) VARCHAR2(1) NOT NULL Cost Type via Projects

66 DEPTID_PC_AM_DEFN Character(10) VARCHAR2(10) NOT NULL Deptid via PC_AM_DEFN table

67 CRITERIA_ID Character(10) VARCHAR2(10) NOT NULL Selection Criteria ID

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

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

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

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

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

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

74 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

75 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
Default Value: %date

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

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

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

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

80 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
Prompt Table: %EDIT_ACCOUNT

81 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
Prompt Table: %EDIT_ALTACCT
Set Control Field: ALTACCT_SETID

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

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

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

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

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

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

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

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

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

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

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

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

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

95 BUS_UNIT_GL_FROM Character(5) VARCHAR2(5) NOT NULL From Business Unit GL
Default Value: PC_INT_TMPL_GL.BUSINESS_UNIT_GL
Prompt Table: PC_INT_TMPL_GL

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

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

98 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
Prompt Table: BU_LED_GRP_VW2

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

117 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
Default Value: OPR_DEF_TBL_PC.CURRENCY_CD
Prompt Table: FRGN_CURR_VW

118 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.
Default Value: BUS_UNIT_TBL_PC.RT_TYPE
Prompt Table: RT_TYPE_TBL

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

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

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

122 CUR_EFFDT Date(10) DATE Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
Default Value: %DATE

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

124 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: N

125 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

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

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

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

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

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

131 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

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

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

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

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

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

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

138 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
Prompt Table: SP_BU_AP_NONVW

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

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

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

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

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

144 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

145 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

146 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

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

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

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

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

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

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

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

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

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

156 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

157 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

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

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

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

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

162 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID
Prompt Table: PC_PROJ_GNT_VW

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

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

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

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

167 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: I

168 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
Prompt Table: SP_BU_BI_NONVW

169 BILLING_DATE Date(10) DATE Billing Date

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

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

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

173 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

174 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

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

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

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

178 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
Prompt Table: SP_BUIN_NONVW

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

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

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

182 PAY_END_DT Date(10) DATE Pay Period End Date

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

184 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

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

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

187 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

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

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

190 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

191 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

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

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

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

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

196 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

197 BUDGET_DT Date(10) DATE Budget Date

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

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

200 BUSINESS_UNIT_BD Character(5) VARCHAR2(5) NOT NULL Budgeting Business Unit
Prompt Table: SP_BUPCBD_NONVW

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

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

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

204 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

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

206 PM_REVIEWED Character(1) VARCHAR2(1) NOT NULL Reviewed
A=All
N=Not Reviewed
Y=Reviewed
Default Value: Y

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

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

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

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

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

212 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

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

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

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

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

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

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

219 AMOUNT_IN_EXCESS Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether the amount is in excess.
Y/N Table Edit

220 RECLAIMED_FROM_OL Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether the amount was reclaimed from over the limit.
Y/N Table Edit

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

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

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

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

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

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

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

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

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

230 DEPR_STATUS Character(1) VARCHAR2(1) NOT NULL Depreciation Status
D=Depreciable
N=Non Depreciable

231 REGULATION Character(1) VARCHAR2(1) NOT NULL Depreciation Regulation
A=Accelerated Cost Recovery Sys
D=Asset Depreciation Range
F=Conventional/Facts& Circumstan
G=Guideline
M=Modified Accel Cost Recovery

232 RECOVERY_LIFE Number(4,1) DECIMAL(3,1) NOT NULL Recovery Life

233 RECOVERY_SUBTYPE Character(2) VARCHAR2(2) NOT NULL Recovery SubType
LI=Low-Income Housing
PU=Public Utility Property

234 CONVENTION Character(2) VARCHAR2(2) NOT NULL Book Depreciation Convention or Cost Convention
Prompt Table: CONV_SETID_VW

235 METHOD Character(2) VARCHAR2(2) NOT NULL Method
DL=DB w/SL By Limit%
DX=Declining Balance w/SL
F1=France Derogatory Balance
FL=Flat Rate %
G1=Germany Staffel Method
J1=Japan- Tangible/Declining Bal
J2=Japan- Tangible/Strt Line
J3=Japan- Intangible/Strt Line
J4=Japan - Lease Depreciation
J5=Japan-Changes DB to SL
J6=Japan - Changes DB to SL 250
J7=Japan-Tangible/Strt Line Rev
J8=Japan - Changes DB to SL 200
J9=JPN - Changes 200/250 DB to SL
JE=Japan - Extended/Strt Line
MN=Manual Depreciation
PC=Declining Balance
SC=Depreciation Schedule
SL=Straight Line
SP=Straight Line Percent
SY=Sum of the Years
UD=User Defined Method
UP=Units of Production

236 CALCULATION_TYPE Character(1) VARCHAR2(1) NOT NULL Calculation Type
L=Life-to-Date
R=Remaining Value

237 DEPR_PERCENT Number(10,8) DECIMAL(9,8) NOT NULL Depreciation Percent

238 DB_PERCENT Number(16,14) DECIMAL(15,14) NOT NULL Declining Balance Percent

239 DEPR_SCHED_CD Character(10) VARCHAR2(10) NOT NULL Schedule Code
Prompt Table: DEPR_SCHED_TBL

240 DEPR_LIMIT_CD Character(10) VARCHAR2(10) NOT NULL Depreciation Limit Code
Prompt Table: DEPR_LIM_TBL

241 LIFE Number(4,0) SMALLINT NOT NULL Useful Life

242 TAX_CLASS_AM Character(6) VARCHAR2(6) NOT NULL Guideline Tax Class
Prompt Table: TAX_CLASS_AM

243 PROPERTY_CD Character(1) VARCHAR2(1) NOT NULL Property Code
1=1245 Property
2=1250 Property

244 PROPERTY_TYPE Character(1) VARCHAR2(1) NOT NULL Property Type
P=Personal
R=Non-Residential Real
S=Residential Real

245 SALVAGE_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Salvage Value

246 SALVAGE_PCT Number(16,14) DECIMAL(15,14) NOT NULL Salvage Percentage

247 LIFE_END_DT Date(10) DATE Useful Life End Date

248 DEPR_LOW_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Depr Low Limit Amount

249 COST_BASIS_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Basis Limit

250 DEPR_AVG_OPTION Character(1) VARCHAR2(1) NOT NULL Depreciation Averaging Option
M=Monthly Averaging
N=No Averaging
Y=Yearly Averaging

251 UOP_ID Character(10) VARCHAR2(10) NOT NULL Units of Production ID
Prompt Table: UOP_TBL

252 INCLUDE_CAP_GAINS Character(1) VARCHAR2(1) NOT NULL CGT Applicable
Y/N Table Edit

253 UD_METHOD_ID Character(5) VARCHAR2(5) NOT NULL Method ID
Prompt Table: UD_METHOD

254 ACCOUNTING_MTHD Character(3) VARCHAR2(3) NOT NULL Accounting Method
ALL=Allowance
EXP=Expense
RES=Reserve

255 AM_BK_UD_CHAR1 Character(10) VARCHAR2(10) NOT NULL User Defined Char Field1

256 AM_BK_UD_CHAR2 Character(10) VARCHAR2(10) NOT NULL User Defined Char Field2

257 AM_BK_UD_DATE1 Date(10) DATE User Defined Date Field1

258 AM_BK_UD_NUM1 Number(19,3) DECIMAL(18,3) NOT NULL User Defined Number Field1

259 AM_BK_UD_NUM2 Number(19,3) DECIMAL(18,3) NOT NULL User Defined Number Field2

260 FUTURE_DEPR_YEARS Number(3,0) SMALLINT NOT NULL No of Future Depreciation Year

261 INCREASE_RATE Signed Number(11,6) DECIMAL(9,6) NOT NULL Increased Rate

262 DEPR_BONUS_PCT Number(6,2) DECIMAL(5,2) NOT NULL Depreciation Bonus Percent

263 DEPR_BONUS_SW Character(3) VARCHAR2(3) NOT NULL Resolution Date Description -------------- ------- ------------------ 753343 03/13/08 New depreciation bonus:Stimulus Act is added.
0=None
1=Section 101 - Federal
2=New York Liberty Zone
3=Section 101 - Local
4=Gulf Opportunity Zone
5=Stimulus Act
6=American Recovery&Reinvestment

264 ADJUST_CONVENTION Character(2) VARCHAR2(2) NOT NULL Adjustment Convention