| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 5 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 6 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 7 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 8 |
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
|
| 9 |
CA_TXN_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contracts Transaction Source
CRM=CRM Transaction
FPC=Projects Transaction
FRE=Lease Administration Trans.
|
| 10 |
CA_TXN_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Transaction ID
|
| 11 |
TRANS_TYPE_BI |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Type
AE=Accounting Entry
AHDR=Adjustment Header
DDS=Deferred Discount/Surcharge
DS=Discount/Surcharge
EXSD=Indian Excise/Sales Tax Detail
LINE=Chargeable Line
NOTE=Note/Comment
TAX=Sales/Use Tax Detail
|
| 12 |
TRANS_TYPE_BI_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Transaction Type Seq
010=Invalid Transaction Type
020=Too many charge lines
030=No charge line for activity
040=Invalid Business Unit
050=Invalid bill-to customer
060=Invalid Billing Address
070=Invalid bill-to contact
080=No Bill Source provided
090=Invalid Bill Source
100=Invalid Bill Type
110=Invalid Bill Cycle
120=Invalid Payment Term
130=Invalid Tax Code
140=Invalid Unit of measure
200=Invalid Standard Note Code
210=No Note Code or Text exists
300=Both Amount & Percentage are 0
|
| 13 |
PROCESS_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Process all Contracts Txn
|
| 14 |
PROCESS_PC |
Character(1) |
VARCHAR2(1) NOT NULL |
Process All Project Txjn
|
| 15 |
PROCESS_TXN |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Interface Txn
|
| 16 |
DONE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Done Flag
|