| # |
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 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|
| 7 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 8 |
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
|
| 9 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
|
| 10 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 11 |
FOREIGN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Foreign Currency Code
|
| 12 |
BILL_BY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill By Identifier
|
| 13 |
ADDR_SEQ_NUM_BILL |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 14 |
PROJECT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
|
| 15 |
PROJECT_MANAGER |
Character(11) |
VARCHAR2(11) NOT NULL |
Project Manager
|
| 16 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 17 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 18 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 19 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 20 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 21 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 22 |
CONTRACT_PPD_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Prepaid Add Sequence
|
| 23 |
CONTRACT_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Type
|
| 24 |
CONTRACT_DT |
Date(10) |
DATE |
Contract Date
|
| 25 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
|
| 26 |
DATE_RANGE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Option
A=Accounting Date
E=All
T=Transaction Date
|
| 27 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 28 |
THRU_DATE |
Date(10) |
DATE |
Through Date
|
| 29 |
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
|
| 30 |
EVENT_DT |
Date(10) |
DATE |
The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting
|
| 31 |
ANALYSIS_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Analysis Group
|
| 32 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 33 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 34 |
COUNT_1 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 35 |
COUNT1 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 36 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 37 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 38 |
SQL_TABLES |
Character(254) |
VARCHAR2(254) NOT NULL |
SQL Tables
|
| 39 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 40 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 41 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 42 |
RATE_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Rate Option
ABI=Activity Bill Rate
ACO=Activity Cost Rate
AML=Mark Up/Down Labor
AMN=Mark Up/Down Non-labor
AMT=Quantity Rate
CRB=Custom Bill Rate
CRC=Custom Cost Rate
EBI=Employee Bill Rate
ECO=Employee Cost Rate
FIX=Fixed Amount
JBI=Job Code Bill Rate
JCO=Job Code Cost Rate
MUP=Markup Rate
NON=Bill at Cost
RBI=Project Role Bill Rate
RCO=Project Role Cost Rate
TBI=MM Tools Usage Bill Rate
TCO=MM Tools Usage Cost Rate
WBI=Work Order Labor Bill Rate
WCO=Work Order Labor Cost Rate
|
| 43 |
BILL_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Plan ID
|
| 44 |
XREF_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Cross Reference Sequence No.
|
| 45 |
BPLAN_LN_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bill Plan Line Number
|
| 46 |
EVENT_OCCURRENCE |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
|
| 47 |
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
|
| 48 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
|
| 49 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
|
| 50 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
|
| 51 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
Contracts Business Unit
|
| 52 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist
|
| 53 |
DISCOUNT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Discount ID
|
| 54 |
RETAINAGE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Retainage ID
|
| 55 |
LIMIT_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Credit Card Limit Amount
|
| 56 |
RETAINAGE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Reduce by retainage first
|
| 57 |
RETAINAGE_OPT2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply retainage upon release
|
| 58 |
LAST_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Last Interface ID
|
| 59 |
REMAINING_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Remaining Amount
|
| 60 |
BILLED_TO_DATE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Billed To Date
|
| 61 |
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
|
| 62 |
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
|
| 63 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 64 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 65 |
LAST_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Last Line Number
|
| 66 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 67 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 68 |
SUBCUST_QUAL1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
|
| 69 |
SUBCUST_QUAL2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
|
| 70 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 71 |
DIRECT_INVOICING |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Invoicing
|
| 72 |
BILL_CUR_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Currency
D=Contract Currency
M=Transaction Currency
|
| 73 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
|
| 74 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
|
| 75 |
BILL_INQUIRY_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Bill Inquiry Phone
|
| 76 |
INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Form
|
| 77 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 78 |
SHIP_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Ship To Address Sequence Num
|
| 79 |
TAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code
|
| 80 |
TAX_EXEMPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
|
| 81 |
TAX_EXEMPT_CERT |
Character(30) |
VARCHAR2(30) NOT NULL |
Exemption Certificate
|
| 82 |
IDENTIFIER |
Character(18) |
VARCHAR2(18) NOT NULL |
Identifier
|
| 83 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 84 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 85 |
SOLD_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sold To Address Sequence Num
|
| 86 |
DISC_SUR_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount/Surcharge
D=Discount
I=Installment Surcharge
S=Surcharge
|
| 87 |
DISCOUNT_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Discount Percentage
|
| 88 |
DISC_SUR_LVL |
Number(2,0) |
SMALLINT NOT NULL |
Discount/Surcharge Level
|
| 89 |
PRE_APPROVAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre Approval Flag
|
| 90 |
DST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Code
|
| 91 |
DST_ID_DSC |
Character(10) |
VARCHAR2(10) NOT NULL |
Discount Id from BI_DISC_SUR for discounts in CA_DETAIL
|
| 92 |
DST_ID_RET |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Id for Retainage found on CA_DETAIL
|
| 93 |
NET_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The resulting net amount related to settlement cash flows subject to counterparty netting agreements.
|
| 94 |
ACCT_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Revenue Recognition Plan
|
| 95 |
EVENT_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Event Number
|
| 96 |
RETAINAGE_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Retainage Percentage
|
| 97 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 98 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 99 |
RESOURCE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 100 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 101 |
GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 102 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 103 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 104 |
DISC_SUR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Identifier
|
| 105 |
COUNTER2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 2
|
| 106 |
COUNTER3 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 3
|
| 107 |
COUNTER4 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 4
|
| 108 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 109 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 110 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 111 |
BILLING_AUTHORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Authority
|
| 112 |
LOC_REFERENCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Letter of Credit ID
|
| 113 |
LOC_DOC_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Letter of Credit Document ID
|
| 114 |
MIN_AMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Min Amt Tolerance
|
| 115 |
STAFF_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay/Bill Management Installed
|
| 116 |
FIELDNAME_CUREFFDT |
Character(18) |
VARCHAR2(18) NOT NULL |
Currency Effective Date
|
| 117 |
CURR_TRANS_DATE |
Character(3) |
VARCHAR2(3) NOT NULL |
Date Type
ACT=Accounting Date
TRN=Transaction Date
|
| 118 |
CA_BILL_GROUP |
Character(2) |
VARCHAR2(2) NOT NULL |
Contract Bill Processing Group
AI=As Incurred
FF=Fixed Fee + Value Based
RB=Recurring Billing
|
| 119 |
RECNAME_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name
|
| 120 |
RECNAME_1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Record 1 Name
|
| 121 |
CHG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Change Package Identifier. This is sequenced from 1 to N for each contract.
|
| 122 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 123 |
XREF_COUNT |
Number(5,0) |
INTEGER NOT NULL |
Xref Counter
|
| 124 |
MS_STREAM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Milestones
Default Value: N
|
| 125 |
PCT_STREAM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Project Progress
Default Value: N
|
| 126 |
RUNDTTM |
DateTime(26) |
TIMESTAMP |
Run Date/Time
|
| 127 |
BP_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Plan Status
CAN=Cancelled
DON=Completed
PND=Pending
PRG=In Progress
RCL=Recycled
RDY=Ready
RIP=Reversal In Progress
RQD=Action Required
RRP=Recycled
RVS=Reversed
|
| 128 |
BILL_THRU_DATE |
Date(10) |
DATE |
Billed Thru Date
|
| 129 |
ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number to Purge
|
| 130 |
LAST_RESOURCE_ID |
Number(20,0) |
DECIMAL(20) NOT NULL |
Last Transaction ID
|
| 131 |
RATE_AMT |
Number(30,6) |
DECIMAL(29,6) NOT NULL |
Rate Amount for Rates.
|
| 132 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 133 |
NOTE_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Note Type
|
| 134 |
RECNAME_18 |
Character(18) |
VARCHAR2(18) NOT NULL |
used in table CFOBJECT_TMP for App Engine FS_CFUPDATE.ViewSrch to look for view/table dependencies.
|
| 135 |
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
|
| 136 |
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.
|
| 137 |
PROCESS_INSTANCE2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 138 |
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
|
| 139 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 140 |
CA_PGP_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Progress Payment Sequence
|
| 141 |
GVC_INSTALLED |
Character(1) |
VARCHAR2(1) NOT NULL |
GVC installed flag
|
| 142 |
COUNTER6 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 6
|
| 143 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 144 |
CURTEMPINSTANCE |
Number(4,0) |
SMALLINT NOT NULL |
Temp Table Instance
|
| 145 |
PVN_GEN_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
PVN Generation Level field used to store the Level on which a Public Voucher needs to be generated for a contract
C=Contract Number
CL=Contract Number/Contract Line
CP=Contract Number/Project
|
| 146 |
ACCT_ENTRY_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Account Entry Type
|
| 147 |
MAST_CONTR_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Master Contract #
|