| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 2 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 3 |
ACCT_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Revenue Recognition Plan
|
| 4 |
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
|
| 5 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 6 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
|
| 7 |
BUSINESS_UNIT_AR |
Character(5) |
VARCHAR2(5) NOT NULL |
AR Business Unit
|
| 8 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
|
| 9 |
BUSINESS_UNIT_IN |
Character(5) |
VARCHAR2(5) NOT NULL |
Inventory Unit
|
| 10 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
|
| 11 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 12 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 13 |
BUS_UNIT_GL_FROM |
Character(5) |
VARCHAR2(5) NOT NULL |
From Business Unit GL
|
| 14 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 15 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 16 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 17 |
DISC_SUR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Identifier
|
| 18 |
POST_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
POSTING SEQUENCE NUMBER
|
| 19 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 20 |
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.
|
| 21 |
BILLING_DATE |
Date(10) |
DATE |
Billing Date
|
| 22 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 23 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 24 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 25 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 26 |
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.
|
| 27 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 28 |
FOREIGN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Foreign Currency Code
|
| 29 |
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.
|
| 30 |
COMBO_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Combo Status
I=Invalid
V=Valid
|
| 31 |
AM_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
AM Distribution Status
D=Distributed
I=Ignore
M=Modified
N=Not Distributed
P=Pending
V=Reversed
|
| 32 |
BI_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Distribution Status
D=Distributed
I=Ignore
N=Not Distributed
P=Priced
U=Unbillable/Non-billable
W=Billing Worksheet
|
| 33 |
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
|
| 34 |
PC_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged
|
| 35 |
PO_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Distribution Status
0=Non-PO
1=Active
2=In-process
3=Error
4=Processed
5=Modified
|
| 36 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 37 |
JOURNAL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
|
| 38 |
JOURNAL_DATE |
Date(10) |
DATE |
Specifies the date the journal was created.
|
| 39 |
JOURNAL_LINE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
|
| 40 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 41 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 42 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 43 |
BUSINESS_UNIT_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
|
| 44 |
JRNL_LN_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
|
| 45 |
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.
|
| 46 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 47 |
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. "
|
| 48 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 49 |
AMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 50 |
DST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Code
|
| 51 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 52 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 53 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 54 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
|
| 55 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
|
| 56 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
|
| 57 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
|
| 58 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
|
| 59 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
|
| 60 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
|
| 61 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
|
| 62 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
|
| 63 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
|
| 64 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
|
| 65 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
|
| 66 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
|
| 67 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 68 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 69 |
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.
Prompt Table:
RT_TYPE_TBL
|
| 70 |
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
|
| 71 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
|
| 72 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
|
| 73 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Specifies the date that a document sequence number is assigned to a document or the date the document was created.
|
| 74 |
DOC_SEQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status
|
| 75 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 76 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 77 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 78 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 79 |
RESOURCE_QUANTITY |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Quantity
|
| 80 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 81 |
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.
|
| 82 |
DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
|
| 83 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 84 |
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
|
| 85 |
DST_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Distribution Sequence
|
| 86 |
DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 87 |
DUE_DATE |
Date(10) |
DATE |
Delivery Due Date from PO
|
| 88 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 89 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 90 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 91 |
EX_DOC_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Documentation ID
|
| 92 |
EX_DOC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies Expenses Document Type
A=Cash Advance
C=Time Report
J=Time Adjustment
M=Accrual - My Wallet
R=Accrual - Expense Report
S=Expense Report
T=Travel Authorization
|
| 93 |
INCENTIVE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Investment Incentive ID
|
| 94 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 95 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 96 |
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.
|
| 97 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 98 |
ITEM_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Item Sequence Number
|
| 99 |
JOURNAL_LINE_DATE |
Date(10) |
DATE |
Specifies the date of a journal line. This date must be the same as the journal date on the header (JOURNAL_DATE) in order for the Parent/Child relationship to remain intact.
|
| 100 |
JRNL_LINE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates the stage of processing of a journal entry.
0=OK - No Errors
1=Uncorrected Error(s)
|
| 101 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 102 |
MSTONE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Milestone Sequence
|
| 103 |
OPEN_ITEM_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Open Item Status
C=Closed Item
N=Not an Open Item Account
O=Open Item
|
| 104 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 105 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 106 |
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
|
| 107 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 108 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 109 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
|
| 110 |
PROJ_TRANS_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Transaction Code
|
| 111 |
PROJ_TRANS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Project Transaction Type
|
| 112 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 113 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
|
| 114 |
RESOURCE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 115 |
RESOURCE_ID_FROM |
Character(40) |
VARCHAR2(40) NOT NULL |
Original Transaction ID
|
| 116 |
RESOURCE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Status
A=Resource Approved
U=Unapproved Resource
|
| 117 |
RES_USER1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 1
|
| 118 |
RES_USER2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 2
|
| 119 |
RES_USER3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 3
|
| 120 |
RES_USER4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 4
|
| 121 |
RES_USER5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 5
|
| 122 |
SCHED_LINE_NO |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Sched Line NO
|
| 123 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 124 |
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.
|
| 125 |
TIME_RPTG_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Time Reporting Code
|
| 126 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 127 |
UNPOST_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
|
| 128 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 129 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 130 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 131 |
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).
|
| 132 |
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.
|
| 133 |
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.
|
| 134 |
ASSOC_DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Associated Department
|
| 135 |
FA_RATE_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
FA_RATE_PCT
|
| 136 |
FA_BASE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
F&A Base Amount
|
| 137 |
GM_REVERSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Grants Reversal Flag
|