| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TEST_CASE |
Character(30) |
VARCHAR2(30) NOT NULL |
BTF Test Case
|
| 2 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 3 |
EXCHNG_TO_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
To Currency
Default Value: USD
Prompt Table:
CURRENCY_CD_TBL
|
| 4 |
EXCHNG_TO_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
CUR_RT_TYPE_TBL
|
| 5 |
INSTALLATION_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Valid values for this field are 'CRM' and 'FDM'
|
| 6 |
AM |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset Management
Y/N Table Edit
Default Value: Y
|
| 7 |
AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Payables
Y/N Table Edit
Default Value: Y
|
| 8 |
AR |
Character(1) |
VARCHAR2(1) NOT NULL |
Receivables
Y/N Table Edit
Default Value: Y
|
| 9 |
AUC |
Character(1) |
VARCHAR2(1) NOT NULL |
Strategic Sourcing
Y/N Table Edit
Default Value: N
|
| 10 |
BI |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing
Y/N Table Edit
Default Value: Y
|
| 11 |
CA |
Character(1) |
VARCHAR2(1) NOT NULL |
Contracts
Y/N Table Edit
Default Value: Y
|
| 12 |
CAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Billing Processor
Y/N Table Edit
Default Value: N
|
| 13 |
CCM |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to identify Catalog Management on each product line's installation record.
Y/N Table Edit
Default Value: N
|
| 14 |
CFG |
Character(1) |
VARCHAR2(1) NOT NULL |
Configurator
Y/N Table Edit
Default Value: N
|
| 15 |
CP |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Configuration Field
Y/N Table Edit
Default Value: N
|
| 16 |
DEAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Deal Management
Y/N Table Edit
Default Value: N
|
| 17 |
DP |
Character(1) |
VARCHAR2(1) NOT NULL |
Demantra
Y/N Table Edit
Default Value: Y
|
| 18 |
EB |
Character(1) |
VARCHAR2(1) NOT NULL |
eBill Payment
Y/N Table Edit
Default Value: Y
|
| 19 |
EG |
Character(1) |
VARCHAR2(1) NOT NULL |
Engineering
Y/N Table Edit
Default Value: Y
|
| 20 |
ES |
Character(1) |
VARCHAR2(1) NOT NULL |
eSupplier Connection
Y/N Table Edit
Default Value: N
|
| 21 |
EX |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses
Y/N Table Edit
Default Value: Y
|
| 22 |
FO |
Character(1) |
VARCHAR2(1) NOT NULL |
Staffing Front Office
Y/N Table Edit
Default Value: N
|
| 23 |
FO_PBM |
Character(1) |
VARCHAR2(1) NOT NULL |
For PBM addition to Installation table checkbox field
Y/N Table Edit
Default Value: N
|
| 24 |
FP |
Character(1) |
VARCHAR2(1) NOT NULL |
Flow Production
10/07/03 PWF Change back to Flow Production from Lean Production System
Y/N Table Edit
Default Value: N
|
| 25 |
GL |
Character(1) |
VARCHAR2(1) NOT NULL |
General Ledger
Y/N Table Edit
Default Value: Y
|
| 26 |
GM |
Character(1) |
VARCHAR2(1) NOT NULL |
Grants
Y/N Table Edit
Default Value: N
|
| 27 |
GVC |
Character(1) |
VARCHAR2(1) NOT NULL |
Government Contracts
Y/N Table Edit
Default Value: N
|
| 28 |
HR |
Character(1) |
VARCHAR2(1) NOT NULL |
Human Capital Management
Y/N Table Edit
Default Value: N
|
| 29 |
INV |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory
Y/N Table Edit
Default Value: Y
|
| 30 |
IP |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory Planning
Y/N Table Edit
Default Value: N
|
| 31 |
ITAM |
Character(1) |
VARCHAR2(1) NOT NULL |
IT Asset Management
Y/N Table Edit
Default Value: N
|
| 32 |
ITK |
Character(1) |
VARCHAR2(1) NOT NULL |
Implementation Toolkit
Y/N Table Edit
Default Value: N
|
| 33 |
MG |
Character(1) |
VARCHAR2(1) NOT NULL |
Manufacturing
Y/N Table Edit
Default Value: Y
|
| 34 |
MPA |
Character(1) |
VARCHAR2(1) NOT NULL |
eSettlements
Y/N Table Edit
Default Value: N
|
| 35 |
OM |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Management
Y/N Table Edit
Default Value: Y
|
| 36 |
PC |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Costing
Y/N Table Edit
Default Value: Y
|
| 37 |
PGM |
Character(1) |
VARCHAR2(1) NOT NULL |
Product field for Program Management
Y/N Table Edit
Default Value: N
|
| 38 |
PM |
Character(1) |
VARCHAR2(1) NOT NULL |
Proposal Management
Y/N Table Edit
Default Value: N
|
| 39 |
PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchasing
Y/N Table Edit
Default Value: Y
|
| 40 |
PV |
Character(1) |
VARCHAR2(1) NOT NULL |
eProcurement
Y/N Table Edit
Default Value: N
|
| 41 |
QS |
Character(1) |
VARCHAR2(1) NOT NULL |
Quality
Y/N Table Edit
Default Value: Y
|
| 42 |
RE |
Character(1) |
VARCHAR2(1) NOT NULL |
Real Estate Management
Y/N Table Edit
Default Value: N
|
| 43 |
RISK |
Character(1) |
VARCHAR2(1) NOT NULL |
Risk Management
Y/N Table Edit
Default Value: N
|
| 44 |
RS |
Character(1) |
VARCHAR2(1) NOT NULL |
Resource Management
Y/N Table Edit
Default Value: Y
|
| 45 |
FPA |
Character(1) |
VARCHAR2(1) NOT NULL |
SRP product code for Real Time Bottom Line, In Memory Financial Position Analyzer.
Y/N Table Edit
Default Value: N
|
| 46 |
FAA |
Character(1) |
VARCHAR2(1) NOT NULL |
SRP product code for Real Time Bottom Line, In Memory Financial Allocations Analyzer.
Y/N Table Edit
Default Value: N
|
| 47 |
ADBA |
Character(1) |
VARCHAR2(1) NOT NULL |
SRP product code for Real Time Bottom Line, In Memory Average Daily Balance Analyzer.
Y/N Table Edit
Default Value: N
|
| 48 |
FCA |
Character(1) |
VARCHAR2(1) NOT NULL |
SRP product code for Real Time Bottom Line, In Memory Financial Close Analyzer.
Y/N Table Edit
Default Value: N
|
| 49 |
SCMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplier Contract Management
Y/N Table Edit
Default Value: N
|
| 50 |
SP |
Character(1) |
VARCHAR2(1) NOT NULL |
Services Procurement
Y/N Table Edit
Default Value: N
|
| 51 |
SPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Supply Planning Basic
Y/N Table Edit
Default Value: Y
|
| 52 |
TD |
Character(1) |
VARCHAR2(1) NOT NULL |
Promotions Management
Y/N Table Edit
Default Value: N
|
| 53 |
TR |
Character(1) |
VARCHAR2(1) NOT NULL |
Treasury
Y/N Table Edit
Default Value: N
|
| 54 |
TPM |
Character(1) |
VARCHAR2(1) NOT NULL |
Trading Partnet Management
Y/N Table Edit
Default Value: N
|
| 55 |
WO |
Character(1) |
VARCHAR2(1) NOT NULL |
Maintenance Management
Y/N Table Edit
Default Value: N
|
| 56 |
WR |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplier Replenishment
Y/N Table Edit
Default Value: N
|
| 57 |
CCU |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Conversion Utility
Y/N Table Edit
Default Value: N
|
| 58 |
PPALM |
Character(1) |
VARCHAR2(1) NOT NULL |
ALM Portal Pack
Y/N Table Edit
Default Value: N
|
| 59 |
PPESA |
Character(1) |
VARCHAR2(1) NOT NULL |
ESA Portal Pack
Y/N Table Edit
Default Value: N
|
| 60 |
PPFIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Financials Portal Pack
Y/N Table Edit
Default Value: N
|
| 61 |
PPSCM |
Character(1) |
VARCHAR2(1) NOT NULL |
Supply Chain Portal Pack
Y/N Table Edit
Default Value: N
|
| 62 |
DMI |
Character(1) |
VARCHAR2(1) NOT NULL |
Mobile Inventory
Y/N Table Edit
Default Value: N
|
| 63 |
PRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Product field for Project Discovery
Y/N Table Edit
Default Value: N
|
| 64 |
ADDRESS_VENDOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Address Supplier
N=None
U=USA Unzipped
Default Value: N
|
| 65 |
TAX_VENDOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Provider
A=Taxware
N=None
V=Vertex
Default Value: N
|
| 66 |
JETFORMS |
Character(1) |
VARCHAR2(1) NOT NULL |
JetForms Installed
Y/N Table Edit
Default Value: N
|
| 67 |
DC_INSTALLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Management
Y/N Table Edit
Default Value: N
|
| 68 |
MULTIBOOK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Multibook entries in Subsystem
Y/N Table Edit
Default Value: N
|
| 69 |
ALTACCT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Alternate Account
Y/N Table Edit
Default Value: N
|
| 70 |
COMMITMENT_CNTL_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on AP
Y/N Table Edit
Default Value: N
|
| 71 |
COMMITMENT_CNTL_AR |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on AR
Y/N Table Edit
Default Value: N
|
| 72 |
COMMITMENT_CNTL_BI |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on BI
Y/N Table Edit
Default Value: N
|
| 73 |
COMMITMENT_CNTL_EX |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on EX
Y/N Table Edit
Default Value: N
|
| 74 |
COMMITMENT_CNTL_GL |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on GL
Y/N Table Edit
Default Value: N
|
| 75 |
COMMITMENT_CNTL_GM |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on GM
Y/N Table Edit
Default Value: N
|
| 76 |
COMMITMENT_CNTL_IN |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on IN
Y/N Table Edit
Default Value: N
|
| 77 |
COMMITMENT_CNTL_PC |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on PC
Y/N Table Edit
Default Value: N
|
| 78 |
COMMITMENT_CNTL_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on PO
Y/N Table Edit
Default Value: N
|
| 79 |
COMMITMENT_PROCARD |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on Procurement Card
Y/N Table Edit
Default Value: N
|
| 80 |
BUDG_DT_DFLT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Budget Date
A=Accounting Date Default
P=Predecessor Doc Date Default
Default Value: A
|
| 81 |
RVSL_DT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Reversal Date Option
C=Current Date
P=Prior Date
Default Value: C
|
| 82 |
PROC_PART_GL |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Partition for GL
Y/N Table Edit
Default Value: N
|
| 83 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 84 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|