| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
Prompt Table:
CA_BU_SP_NONVW
|
| 4 |
ACCT_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Revenue Recognition Plan
Default Value: NEXT
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
AP_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Rev Rec Plan Status
CAN=Cancelled
DON=Completed
NEW=Pending
PRG=In Progress
RDY=Ready
RIP=Reversal in Progress
RQD=Action Required
RVS=Reversed
Default Value: NEW
|
| 7 |
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.
Default Value: CA_CONTR_HDR.SOLD_TO_CUST_ID
Prompt Table:
CA_SOLD_TO_VW
|
| 8 |
HOLD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold
N=Hold
Y=Hold
Y/N Table Edit
Default Value: N
|
| 9 |
HOLD_DATE |
Date(10) |
DATE |
Put On Hold Date
|
| 10 |
HOLD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Hold User
|
| 11 |
HOLD_RSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Hold Reason
Prompt Table:
CA_HOLD_RSN
|
| 12 |
SYSTEM_DEFINED |
Character(2) |
VARCHAR2(2) NOT NULL |
"A flag that indicates the accounting entry line type. The valid line types are pre-populated by PeopleSoft. For example the value is ""A"" if the line represents a debit or credit to the AR account. Some examples of other values are D (Draft Receivables entry) and L (Cash Control entry). "
Y/N Table Edit
|
| 13 |
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
Default Value: 4
|
| 14 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 15 |
END_DT |
Date(10) |
DATE |
End Date
|
| 16 |
SCHEDULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule ID
Prompt Table:
SCHEDULE_TBL
|
| 17 |
CA_PER_COMPLETE |
Number(12,8) |
DECIMAL(11,8) NOT NULL |
Percent Complete
|
| 18 |
CA_ALLOC_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Amount
1=Percent
2=Amount
Default Value: 1
|
| 19 |
LAST_REV_REC_DT |
Date(10) |
DATE |
Processed On
|
| 20 |
LAST_MAINT_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the date and time a transaction was last modified
Default Value: %Datetime
|
| 21 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 22 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 23 |
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.
|
| 24 |
CONTR_LEGAL_ENTITY |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Legal Entity
|
| 25 |
PRIOR_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Prior Status
|
| 26 |
CA_PERCENT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Used on Percent Complete Revenue and Bill Plans
1=Specify
2=Project
3=Proj/Act
Default Value: 1
|
| 27 |
PLAN_CONTR_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Activate Contract
P=Leave Pending
R=Set to Ready
Y/N Table Edit
Default Value: Y
|
| 28 |
CA_TXN_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contracts Transaction Source
CRM=CRM Transaction
FPC=Projects Transaction
FRE=Lease Administration Trans.
Default Value: FPC
|
| 29 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|