PC_POADJUST_AET

(SQL Table)
 Index Back

Projects Standard AE Cache

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
3 BUPRJACT_OPTN Character(1) VARCHAR2(1) NOT NULL BU/Proj/Act Option
A=Business Unit/Project/Activity
B=Business Unit
E=All
P=Business Unit/Project
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: Y

5 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Default Value: Y

6 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Default Value: Y

7 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID
8 FROM_DATE Date(10) DATE From Date
9 THRU_DATE Date(10) DATE Through Date
10 DATE_TYPE Character(1) VARCHAR2(1) NOT NULL From and To Date Type
A=Accounting Date
J=Journal Date
P=Posted Date
T=Transaction Date

Default Value: A

11 DATE_RANGE_OPTN Character(1) VARCHAR2(1) NOT NULL Date Option
A=Accounting Date
E=All
T=Transaction Date
12 PC_CCA_SW Character(1) VARCHAR2(1) NOT NULL Purchase Order Adjustments
13 PC_PO_REV_SW Character(1) VARCHAR2(1) NOT NULL Purchase Order Reversals
14 PC_REQ_REV_SW Character(1) VARCHAR2(1) NOT NULL Requisition Reversals
15 AN_TYPE_PO_CCA Character(3) VARCHAR2(3) NOT NULL Purchasing Closure
16 AN_TYPE_PO_CRV Character(3) VARCHAR2(3) NOT NULL Purchasing Reversals
17 AN_TYPE_PO_RRV Character(3) VARCHAR2(3) NOT NULL Requisition Reversals
18 RRV_OPTN Character(1) VARCHAR2(1) NOT NULL Requisition Reversal
A=COM Amount
Q=REQ Rate
X=REQ Total
19 CRV_OPTN Character(1) VARCHAR2(1) NOT NULL Purchase Order Reversal
A=ACT Amount
Q=COM Rate
20 RUN_DT Date(10) DATE Run Date
21 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
22 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
23 AN_TYPE_AP Character(3) VARCHAR2(3) NOT NULL Payables
24 AN_TYPE_EX Character(3) VARCHAR2(3) NOT NULL Expenses
25 AN_TYPE_TT_EX Character(3) VARCHAR2(3) NOT NULL Mobile Time / Expense
26 AN_TYPE_IN Character(3) VARCHAR2(3) NOT NULL Inventory
27 AN_TYPE_OM Character(3) VARCHAR2(3) NOT NULL Order Management
28 AN_TYPE_PO_PO Character(3) VARCHAR2(3) NOT NULL Purchase Orders
29 AN_TYPE_PO_REV Character(3) VARCHAR2(3) NOT NULL Purchasing Reversals
30 AN_TYPE_PO_REQ Character(3) VARCHAR2(3) NOT NULL Requisitions
31 AN_TYPE_REQ_REV Character(3) VARCHAR2(3) NOT NULL Requisition Reversals
32 AN_TYPE_TL Character(3) VARCHAR2(3) NOT NULL Time / Labor Actuals
33 AN_TYPE_TL_EST Character(3) VARCHAR2(3) NOT NULL Time / Labor Estimates
34 AN_TYPE_TL_BI Character(3) VARCHAR2(3) NOT NULL Time / Labor Billing Estimate
35 GM_CSR_AP Character(3) VARCHAR2(3) NOT NULL Cost Sharing Payables
36 GM_CSR_IN Character(3) VARCHAR2(3) NOT NULL Cost Sharing Inventory
37 GM_CSR_PO_PO Character(3) VARCHAR2(3) NOT NULL Cost Sharing PO - Purchase Ord
38 GM_CSR_PO_CRV Character(3) VARCHAR2(3) NOT NULL Cost Sharing PO - COM Reversal
39 GM_CSR_PO_REQ Character(3) VARCHAR2(3) NOT NULL Cost Sharing PO - Requisition
40 GM_CSR_PO_RRV Character(3) VARCHAR2(3) NOT NULL Cost Sharing PO - REQ Reversal
41 GM_CSR_PO_CCA Character(3) VARCHAR2(3) NOT NULL Cost Sharing PO - Close Adj
42 FROM_DT Date(10) DATE From Date
43 TO_DT Date(10) DATE To Date
44 AE_EXISTS Character(1) VARCHAR2(1) NOT NULL Exists
45 WORK_CNT Number(10,0) DECIMAL(10) NOT NULL Count of Anything
46 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
47 WHERE_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Where Clause
48 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause
49 AE_WHERE Character(254) VARCHAR2(254) NOT NULL AE Generic Where Clause
50 AE_WHERE_1 Character(50) VARCHAR2(50) NOT NULL AE_WHERE_1
51 AE_WHERE_2 Character(50) VARCHAR2(50) NOT NULL AE_WHERE_2
52 AE_WHERE_3 Character(50) VARCHAR2(50) NOT NULL AE_WHERE_3
53 AE_WHERE_4 Character(50) VARCHAR2(50) NOT NULL AE_WHERE_4
54 AE_WHERE_5 Character(50) VARCHAR2(50) NOT NULL AE_WHERE_5
55 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
56 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
57 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
58 AN_TYPE_ORIG Character(75) VARCHAR2(75) NOT NULL Analysis Type for Orig
59 AN_TYPE_TRANS Character(254) VARCHAR2(254) NOT NULL Analysis Type for Trans
60 REV_OPTN Character(1) VARCHAR2(1) NOT NULL Reversal Option
A=Amount
Q=Quantity
X=Reverse All
61 DUP_TBL Character(16) VARCHAR2(16) NOT NULL Sub-select to prevent dups
62 RUN_TYPE Character(3) VARCHAR2(3) NOT NULL Interface Processing Options
DA=Depreciate All
DC=Delete Conversion Data
DD=Delete Data
DF=Delete Fin
DT=Delete Transactions
FFC=Flexible Formula Calculator
GS=Generate Scan Scope
GT=Generate Trans
LC=Load Conversion Data
LD=Load Data
LF=Load Fin Table from Conversion
LT=Load Transactions
MC=Mass Change
N=None
PM=Purge Mass Changes
PP=Purge Mass Change Preview
RM=Run Match
UA=UnDepreciate All
XD=Extract Data
63 BUILD_TBL Character(16) VARCHAR2(16) NOT NULL Join table in BUILD section
64 PC_FEED_SW Character(1) VARCHAR2(1) NOT NULL Main or Feeder App
65 MULTICURRENCY Character(1) VARCHAR2(1) NOT NULL Multi-Currency
66 REV_ALIAS Character(3) VARCHAR2(3) NOT NULL Reversal Date Alias
67 AN_TYPE_VIN Character(3) VARCHAR2(3) NOT NULL Non-Recoverable VAT
68 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
69 LAST_RESOURCE_ID Number(20,0) DECIMAL(20) NOT NULL Last Transaction ID
70 ROW_COUNT Number(8,0) INTEGER NOT NULL Number to Purge
71 SOURCE_TABLE_NAME Character(30) VARCHAR2(30) NOT NULL Source Table Name
72 WHERE_FIELD1 Character(50) VARCHAR2(50) NOT NULL SQL Where field
73 YES Character(1) VARCHAR2(1) NOT NULL