| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 3 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 4 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 5 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 6 |
LINE_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 7 |
DEBIT_CREDIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Debit / Credit Indicator
CR=Credit
DR=Debit
|
| 8 |
DST_USE |
Character(3) |
VARCHAR2(3) NOT NULL |
Added the following inactive translates for Contracts 8.4:
AP Accounts Payable Liability
AS Fixed Asset
CA Contra Asset
CG Cost of Goods Sold
CL Contra Liability
EX Expense
IN Inventory
WP Work In Progress
|
| 9 |
INTER_ORG_LEVEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Inter-Organization Level
DFLT=Default
LVL1=Level 1
LVL2=Level 2
LVL3=Level 3
LVL4=Level 4
LVL5=Level 5
|
| 10 |
CONVERSION_RATE |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Conversion Rate
|
| 11 |
ORG_TO_BOOK |
Character(1) |
VARCHAR2(1) NOT NULL |
Organization to Book
C=Business Unit GL
O=Override
P=Project
R=Resource
S=From Business Unit GL
|
| 12 |
COMBO_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Combo Status
I=Invalid
V=Valid
|
| 13 |
PROJECT_FLAG |
Character(3) |
VARCHAR2(3) NOT NULL |
Flag for Accounting Rules page. Specifies whether or not the Project ID value flows thru from PROJ_RESOURCE or flows thru with no value.
NON=None
SRC=Source
|
| 14 |
IU_ANCHOR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N flag used to specify which transaction line is the Inter/IntraUnit anchor flag (the line that contains the anchor Business Unit and ChartFields).
|
| 15 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 16 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 17 |
CONTRACT_PPD_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Prepaid Add Sequence
|
| 18 |
ACCT_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Revenue Recognition Plan
|
| 19 |
EVENT_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Event Number
|
| 20 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 21 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 22 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 23 |
DELETE_ME |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Record
Y/N Table Edit
Default Value: N
|
| 24 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 25 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
|
| 26 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 27 |
BUSINESS_UNIT_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
|
| 28 |
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
|
| 29 |
GL_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal
|
| 30 |
CUR_EFFDT |
Date(10) |
DATE |
Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
|
| 31 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 32 |
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. "
|
| 33 |
FOREIGN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Foreign Currency Code
|
| 34 |
FOREIGN_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
|
| 35 |
RESOURCE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 36 |
PROJECT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
|
| 37 |
AMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 38 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 39 |
DST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Code
|
| 40 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 41 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 42 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 43 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 44 |
RESOURCE_ID_FROM |
Character(40) |
VARCHAR2(40) NOT NULL |
Original Transaction ID
|
| 45 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 46 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 47 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 48 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
|
| 49 |
STATISTICS_ACCOUNT |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a general ledger account is used to track statistical amounts rather than monetary amounts. Statistical amounts represent information such as square footage, head count, or number of units. A unit of measure (UNIT_OF_MEASURE) must be specified with a statistical account.
|
| 50 |
PROJ_TRANS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Project Transaction Type
|
| 51 |
PROJ_TRANS_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Transaction Code
|
| 52 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 53 |
MOVEMENT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign.
N=Natural
R=Reversal
Default Value: N
|
| 54 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 55 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 56 |
BUSINESS_UNIT_GL2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Contract GL Business Unit
|
| 57 |
RESOURCE_QUANTITY |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Quantity
|
| 58 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 59 |
DST_ACCT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
07/20/04 st: added RCN for Advance Reconciliation
02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement
11/11/99 llr: Added ADVP for Payables Advance Payment
|
| 60 |
DST_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Distribution Sequence
|
| 61 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 62 |
POST_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
POSTING SEQUENCE NUMBER
|
| 63 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
|
| 64 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 65 |
LINE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.
|
| 66 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 67 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 68 |
ACTIVE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Template Status
A=Active
I=Inactive
|
| 69 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 70 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 71 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 72 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 73 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 74 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 75 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 76 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 77 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 78 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 79 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 80 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 81 |
IU_SYS_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
|
| 82 |
IU_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
|
| 83 |
CRIT_SEQ |
Number(8,0) |
INTEGER NOT NULL |
Criteria Sequence
|
| 84 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 85 |
BUSINESS_UNIT_WO |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit Work Order
Prompt Table:
SP_BU_WM_NONVW
|
| 86 |
WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Order Identification
Prompt Table:
%EDIT_WO_ID
|
| 87 |
WO_TASK_ID |
Number(5,0) |
INTEGER NOT NULL |
Task Number
Prompt Table:
%EDIT_WO_TASK
|
| 88 |
RSRC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Management Resource Types
1=Labor
2=Tools
3=Material
|
| 89 |
RES_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Resource Line No.
Prompt Table:
%EDIT_RES_LINE
|
| 90 |
BUSINESS_UNIT_AR |
Character(5) |
VARCHAR2(5) NOT NULL |
AR Business Unit
|
| 91 |
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.
|
| 92 |
ITEM |
Character(30) |
VARCHAR2(30) NOT NULL |
Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
|
| 93 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 94 |
ITEM_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Item Sequence Number
|
| 95 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 96 |
ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a customer order number that appears as a reference on a receivables pending item.
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 97 |
RESOURCE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Status
A=Resource Approved
U=Unapproved Resource
|
| 98 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 99 |
RES_USER1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 1
|
| 100 |
RES_USER2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 2
|
| 101 |
RES_USER3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 3
|
| 102 |
RES_USER4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 4
|
| 103 |
RES_USER5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 5
|
| 104 |
PRJ_LEVEL1_CF_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
Level 1 Chartfield
|
| 105 |
PRJ_LEVEL2_CF_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
Level 2 Chartfield
|
| 106 |
PRJ_LEVEL3_CF_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
Level 3 Chartfield
|
| 107 |
PRJ_LEVEL4_CF_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
Level 4 Chartfield
|
| 108 |
PRJ_LEVEL5_CF_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
Level 5 Chartfield
|