| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 4 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
Default Value: 1
|
| 5 |
ACCT_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Revenue Recognition Plan
Prompt Table:
CA_ACCTPLAN
|
| 6 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
|
| 7 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
Prompt Table:
%EDITTABLE
|
| 8 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 9 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 10 |
FOREIGN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Foreign Currency Code
|
| 11 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 12 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_CA_NONVW
|
| 13 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table:
CUST_SLD_VW
|
| 14 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
Prompt Table:
BI_BILL_TO_VW
|
| 15 |
BILL_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Plan ID
Prompt Table:
CA_BILL_PLAN
|
| 16 |
BILL_PLAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Billing Method
01=As Incurred
02=Installment
03=Recurring
04=Milestone
05=Percent Complete
06=Immediate
07=Value Based
|
| 17 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 18 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
Prompt Table:
SP_BU_BI_NONVW
|
| 19 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table:
BI_SPECIALST_VW
Set Control Field: BUSINESS_UNIT_BI
|
| 20 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
Prompt Table:
BI_CYCLE
|
| 21 |
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
Default Value: E
|
| 22 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 23 |
PROJECT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
Prompt Table:
PROJ_TYPE_TBL
Set Control Field: BUSINESS_UNIT_PC
|
| 24 |
PROJECT_MANAGER |
Character(11) |
VARCHAR2(11) NOT NULL |
Project Manager
Prompt Table:
CA_ALL_PMGR_VW
|
| 25 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
SP_CAPRJ2_NONVW
|
| 26 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
CA_ACT_NONVW
|
| 27 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 28 |
ALL_RDY_CHGS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process all Ready amendments
A=Process all ready amendments
V=Process one contract only
Default Value: A
|
| 29 |
CHG_DATE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Option
B=Between two READY dates
F=From a specified date forward
N=No Date Range
T=Through to a specified date
Default Value: T
|
| 30 |
DATE_RANGE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Option
A=Accounting Date
E=All
T=Transaction Date
Default Value: E
|
| 31 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 32 |
THRU_DATE |
Date(10) |
DATE |
Through Date
|
| 33 |
EVENT_DT |
Date(10) |
DATE |
The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting
Default Value: %DATE
|
| 34 |
ACCOUNTING_DT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Date Option
P=Processing Date
U=User Define
|
| 35 |
MILESTONE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Milestone_ID identifies the milestones that can be referenced from multiple functional areas.
Prompt Table:
CA_MILES_VW
|
| 36 |
COMPLETION_DATE |
Date(10) |
DATE |
Completion Date
|
| 37 |
REV_RECOG_METHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
Revenue Recognition Method
1=As Incurred
2=Apportionment
3=Percent Complete
4=Milestone
5=Billing Manages Revenue
|
| 38 |
PURGE_AFTER_X_DAYS |
Number(2,0) |
SMALLINT NOT NULL |
Purge All Older Than (in Days)
|
| 39 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
Default Value: %DATE
|
| 40 |
CONTRACT_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Type
Prompt Table:
CA_TYPE_VW
|
| 41 |
CA_RQST_SRC |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Classification
FED=Federal Reimbursable Agreement
GEN=Generic Application
GOV=Government
INT=Internal
OND=CRM Field Services On Demand
STD=Standard
|
| 42 |
MIN_AMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Min Amt Tolerance
Y/N Table Edit
Default Value: N
|
| 43 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 44 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 45 |
LOC_REFERENCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Letter of Credit ID
Prompt Table:
GM_SPNSR_LC2_VW
Set Control Field: BUSINESS_UNIT
|
| 46 |
BILLING_AUTHORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Authority
Prompt Table:
BI_AUTH_EF_VW
Set Control Field: BUSINESS_UNIT_BI
|
| 47 |
ADD_DT |
Date(10) |
DATE |
Customer Added On
|
| 48 |
BILL_THRU_DATE |
Date(10) |
DATE |
Billed Thru Date
Default Value: %DATE
|
| 49 |
CA_BILL_GROUP |
Character(2) |
VARCHAR2(2) NOT NULL |
Contract Bill Processing Group
AI=As Incurred
FF=Fixed Fee + Value Based
RB=Recurring Billing
|
| 50 |
MS_STREAM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Milestones
Y/N Table Edit
Default Value: N
|
| 51 |
PCT_STREAM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Project Progress
Y/N Table Edit
Default Value: N
|
| 52 |
DEF_STREAM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Contract Liability
Y/N Table Edit
Default Value: N
|
| 53 |
GL_STREAM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Journal Entries
Y/N Table Edit
Default Value: N
|
| 54 |
REV_PROC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Revenue Plans
Y/N Table Edit
|
| 55 |
BILL_PROC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Bill Plans
Y/N Table Edit
|
| 56 |
RENEWAL_TIMING |
Number(3,0) |
SMALLINT NOT NULL |
Renewal Timing
|
| 57 |
CA_BP_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Billing Plan Template
Y/N Table Edit
Default Value: N
|
| 58 |
CA_AP_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Revenue Plan Template
Y/N Table Edit
Default Value: N
|
| 59 |
CA_BP_DTL_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Billing Plan Detail Template
Y/N Table Edit
Default Value: N
|
| 60 |
CA_BP_TMPL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Plan Template
Prompt Table:
CA_BP_TMPL_R_VW
|
| 61 |
CA_AP_TMPL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Revenue Plan Template
Prompt Table:
CA_AP_TMPL_R_VW
|
| 62 |
BP_DTL_TMPL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Plan Detail Template ID
Prompt Table:
CA_BP_DTL_TMPL
|
| 63 |
BILL_STREAM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Streamline Processing Billing Option
Y/N Table Edit
Default Value: N
|
| 64 |
CA_GENERIC_CALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate to CA_BI_INTFC that this is coming from Renewals. Can be used more generically in the future.
Y/N Table Edit
Default Value: N
|
| 65 |
CONTRACT_ADMIN |
Character(40) |
VARCHAR2(40) NOT NULL |
Contract Administrator defined on CABU.
Prompt Table:
MEMBER_VW
|
| 66 |
RECALC_LMT_TOTALS |
Character(1) |
VARCHAR2(1) NOT NULL |
Recalculate Limit Totals Only
Y/N Table Edit
Default Value: N
|
| 67 |
RATE_DEF_BIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Definition to track billing rates.
|
| 68 |
RATE_DEF_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Definition to track revenue rates.
|
| 69 |
CA_FEE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Cost Plus Fee Type
01=None
02=Fixed Fee
03=Award Fee
04=Incentive Fee
05=Other Fee
|
| 70 |
RNW_PKG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
PSIRS-KK
Prompt Table:
CA_RNW_PKG_R_VW
|
| 71 |
ASOF_DT |
Date(10) |
DATE |
As of Date
Default Value: %date
|
| 72 |
CA_PGP_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Progress Payment Sequence
|
| 73 |
REVENUE_PROFILE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Revenue Profile
Prompt Table:
CA_REVPROF_VW
|
| 74 |
MAST_CONTR_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Master Contract #
Prompt Table:
CA_MASTER_VW
|
| 75 |
LOC_DOC_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Letter of Credit Document ID
Prompt Table:
CA_LOC_DOCID_VW
|
| 76 |
EVENT_DT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Date Options
S=Current Date
U=Specify Date
|
| 77 |
INVOICE_DT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Date Options
S=Current Date
U=Specify Date
|
| 78 |
FROM_DATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
From Date Options
S=Current Date
U=Specify Date
|
| 79 |
THRU_DATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Through Date Options
S=Current Date
U=Specify Date
|
| 80 |
BIL_THRU_DATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Through Date Options
S=Current Date
U=Specify Date
|