| # |
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 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
CA_PRODUCTID_VW
|
| 5 |
PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Product Group
Prompt Table:
CA_PRODGP_VW
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_CA_NONVW
|
| 7 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
Prompt Table:
%EDITTABLE
|
| 8 |
END_DT |
Date(10) |
DATE |
End Date
|
| 9 |
SALES_TO_INCL |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales to Include
B=Both
O=Other Sales
S=Standalone Sales
Default Value: B
|
| 10 |
REVENUE_PROFILE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Revenue Profile
Prompt Table:
CA_REVPROF_VW
|
| 11 |
REGION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table:
CA_REGIONCD1_VW
|
| 12 |
CONTRACT_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Type
Prompt Table:
CA_TYPE_VW
|
| 13 |
CONTRACT_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Role
Prompt Table:
CA_CNTRROLE_VW
|
| 14 |
CONTR_LEGAL_ENTITY |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Legal Entity
Prompt Table:
CA_LGL_ENT_VW
|
| 15 |
MAST_CONTR_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Master Contract #
Prompt Table:
CA_MASTER_VW
|
| 16 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table:
CUST_SLD_VW
|
| 17 |
CA_RUN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Control Option
L=Load Data
P=Purge Data
Default Value: L
|
| 18 |
CA_PURGE_DT |
Date(10) |
DATE |
Purge Before
|
| 19 |
CA_INCL_REV_IMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Revenue Impact Analysis
Y/N Table Edit
Default Value: N
|
| 20 |
REV_TRANS_IMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Revenue Transition Impact
1=Materially Impacted
2=Not Materially Impacted
3=Not Yet Determined
4=Post Transition
|
| 21 |
REV_TRANS_STS |
Character(1) |
VARCHAR2(1) NOT NULL |
Revenue Transition Status
1=Not Initiated
2=In Preliminary Review
3=Review Complete
4=Contract Updated
5=Post Transition
|