| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
TAS_GWA |
Character(26) |
VARCHAR2(26) NOT NULL |
TAS GWA
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 4 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 5 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 6 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 7 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 8 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 9 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPER_UNIT_TBL
|
| 10 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_TBL
|
| 11 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_TBL
|
| 12 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASS_CF_TBL
|
| 13 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_TBL
|
| 14 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_TBL
|
| 15 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 16 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 17 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 18 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CHARTFIELD1_TBL
|
| 19 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CHARTFIELD2_TBL
|
| 20 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CHARTFIELD3_TBL
|
| 21 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 22 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 23 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
|
| 24 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 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 |
GTAS_BEGIN_END |
Character(1) |
VARCHAR2(1) NOT NULL |
Beginning/Ending Bal Indicator
B=Beginning Balances
E=Ending Balances
|
| 27 |
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.
|
| 28 |
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.
|
| 29 |
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.
|
| 30 |
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.
|
| 31 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 32 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 33 |
REPORT_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Report Identifier
|
| 34 |
PERIOD_FROM |
Number(3,0) |
SMALLINT NOT NULL |
From Period
|
| 35 |
PERIOD_TO |
Number(3,0) |
SMALLINT NOT NULL |
To Period
|
| 36 |
TREE_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
FACTS Tree Group
|
| 37 |
JOURNAL_ID_R |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal ID to Replace
|
| 38 |
SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.
|
| 39 |
SHOW_DESCR |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Description on Report
|
| 40 |
JOURNAL_DATE |
Date(10) |
DATE |
Specifies the date the journal was created.
|
| 41 |
JRNL_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates the processing status of a journal entry.
D=Deleted
E=Journal Has Errors
I=Posting Incomplete
M=Valid SJE Model -- Do Not Post
N=No Status - Needs to be Edited
P=Posted to Ledger(s)
T=Journal Entry Incomplete
U=Unposted
V=Valid Journal - Edits Complete
X=Cancelled
Z=Upgrade Journal - Can't Unpost
|
| 42 |
POSTED_DATE |
Date(10) |
DATE |
Specifies the date that a journal entry is posted. This field is maintained by the posting program of PeopleSoft General Ledger.
|
| 43 |
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.
|
| 44 |
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".
|
| 45 |
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
|
| 46 |
MONETARY_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
|
| 47 |
BUDGET_PERIOD |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Period
|
| 48 |
GTAS_ACCOUNT |
Character(6) |
VARCHAR2(6) NOT NULL |
GTAS Account
|
| 49 |
SEQUENCENO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence Number
|
| 50 |
DEBIT_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Debit Amount
|
| 51 |
CREDIT_AMOUNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Credit Amount
|
| 52 |
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. "
|
| 53 |
CUSTODIAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Custodial
|
| 54 |
BUDG_PROP |
Character(1) |
VARCHAR2(1) NOT NULL |
Budgetary/Proprietary
|
| 55 |
ANTICIPATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Anticipated
|
| 56 |
FED_NONFED |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal NonFederal Code
|
| 57 |
TRAD_PARTNER |
Character(3) |
VARCHAR2(3) NOT NULL |
Trading Partner Agency Code
|
| 58 |
TRAD_MAIN_ACCOUNT |
Character(4) |
VARCHAR2(4) NOT NULL |
Trading Partner Main Account
|
| 59 |
MAIN_ACCOUNT |
Character(4) |
VARCHAR2(4) NOT NULL |
Main Account TAS
|
| 60 |
GTAS_COHORT_YR |
Character(4) |
VARCHAR2(4) NOT NULL |
Credit Cohort Year
|
| 61 |
GTAS_PROG_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
GTAS Program Report Catg Code
|
| 62 |
EXCHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Exchange Non Exchange Code
|
| 63 |
GTAS_AUTH_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Authority Type
|
| 64 |
GTAS_APPOR_CAT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Apportionment Category Code
|
| 65 |
GTAS_CAT_B_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
GTAS Category B Program Code
|
| 66 |
YEAR_BUDGET_AUTH |
Character(4) |
VARCHAR2(4) NOT NULL |
Year of Budget Authority
|
| 67 |
AVAIL_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Availability Time Indicator
|
| 68 |
BEA_CATEGORY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
BEA Category Indicator
|
| 69 |
GTAS_BORROW_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Borrowing Source
|
| 70 |
PY_ADJUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Prior Year Adjustment Code
|
| 71 |
GTAS_REIMBURSE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Reimbursable Ind
|
| 72 |
GTAS_BUDG_IMPACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Deny
|
| 73 |
PROG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Deny
|
| 74 |
GTAS_DEBIT_CREDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Debit / Credit Indicator
|
| 75 |
REDUCTION_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Reduction Type Code
|
| 76 |
FED_DEFC |
Character(3) |
VARCHAR2(3) NOT NULL |
Disaster Emergency Fund Code
|
| 77 |
FED_BOC |
Character(4) |
VARCHAR2(4) NOT NULL |
GTAS Budget Object Class
|
| 78 |
VALUE1 |
Character(1) |
VARCHAR2(1) NOT NULL |
VALUE1
|
| 79 |
VALUE2 |
Character(1) |
VARCHAR2(1) NOT NULL |
VALUE2
|
| 80 |
VALUE3 |
Character(1) |
VARCHAR2(1) NOT NULL |
VALUE3
|
| 81 |
CF_NAME1 |
Character(18) |
VARCHAR2(18) NOT NULL |
ChartField Name 1
|
| 82 |
CF_NAME2 |
Character(18) |
VARCHAR2(18) NOT NULL |
ChartField Name 2
|
| 83 |
CF_NAME3 |
Character(18) |
VARCHAR2(18) NOT NULL |
ChartField Name 3
|
| 84 |
CF_NAME4 |
Character(18) |
VARCHAR2(18) NOT NULL |
ChartField Name 4
|
| 85 |
CF_NAME5 |
Character(18) |
VARCHAR2(18) NOT NULL |
ChartField Name 5
|
| 86 |
CF_NAME6 |
Character(18) |
VARCHAR2(18) NOT NULL |
ChartField Name 6
|
| 87 |
CF_NAME7 |
Character(18) |
VARCHAR2(18) NOT NULL |
ChartField Name 7
|
| 88 |
CF_NAME8 |
Character(18) |
VARCHAR2(18) NOT NULL |
ChartField Name 8
|
| 89 |
CF_NAME9 |
Character(18) |
VARCHAR2(18) NOT NULL |
ChartField Name 9
|
| 90 |
CF_NAME10 |
Character(18) |
VARCHAR2(18) NOT NULL |
ChartField Name 10
|
| 91 |
CF_NAME11 |
Character(18) |
VARCHAR2(18) NOT NULL |
ChartField Name 11
|
| 92 |
CF_NAME12 |
Character(18) |
VARCHAR2(18) NOT NULL |
ChartField Name 12
|
| 93 |
CF_NEW_FLD_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
New Fieldname
|
| 94 |
BNDV |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable
|
| 95 |
BNDV2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 2
|
| 96 |
BNDV3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 3
|
| 97 |
BNDV4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 4
|
| 98 |
BNDV5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 5
|
| 99 |
BNDV6 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 6
|
| 100 |
BNDV7 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 7
|
| 101 |
BNDV8 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 8
|
| 102 |
BNDV9 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 9
|
| 103 |
BNDV10 |
Character(10) |
VARCHAR2(10) NOT NULL |
Bind Variable 10
|
| 104 |
FIELDVAL1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Value 1
|
| 105 |
FIELDVAL2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Value 2
|
| 106 |
FIELDVAL3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Value 3
|
| 107 |
KEYNAME1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Keyname
|
| 108 |
KEYNAME2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Keyname
|
| 109 |
KEYNAME3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Keyname3
|
| 110 |
KEYNAME4 |
Character(20) |
VARCHAR2(20) NOT NULL |
Keyname4
|
| 111 |
KEYNAME5 |
Character(20) |
VARCHAR2(20) NOT NULL |
Keyname5
|
| 112 |
KEYNAME6 |
Character(20) |
VARCHAR2(20) NOT NULL |
Keyname6
|
| 113 |
KEYNAME7 |
Character(20) |
VARCHAR2(20) NOT NULL |
Keyname7
|
| 114 |
KEYNAME8 |
Character(20) |
VARCHAR2(20) NOT NULL |
Keyname8
|
| 115 |
KEYNAME9 |
Character(20) |
VARCHAR2(20) NOT NULL |
Keyname9
|
| 116 |
KEYNAME10 |
Character(20) |
VARCHAR2(20) NOT NULL |
Keyname10
|
| 117 |
KEYNAME11 |
Character(20) |
VARCHAR2(20) NOT NULL |
Keyname11
|
| 118 |
KEYNAME12 |
Character(20) |
VARCHAR2(20) NOT NULL |
Keyname12
|
| 119 |
KEYNAME13 |
Character(20) |
VARCHAR2(20) NOT NULL |
Keyname13
|
| 120 |
KEYNAME14 |
Character(20) |
VARCHAR2(20) NOT NULL |
Keyname14
|
| 121 |
KEYNAME15 |
Character(20) |
VARCHAR2(20) NOT NULL |
Keyname15
|
| 122 |
KEY_01 |
Character(15) |
VARCHAR2(15) NOT NULL |
Key Value 01
|
| 123 |
KEY_02 |
Character(15) |
VARCHAR2(15) NOT NULL |
Key Value 02
|
| 124 |
KEY_03 |
Character(15) |
VARCHAR2(15) NOT NULL |
Key Value 03
|
| 125 |
KEY_04 |
Character(15) |
VARCHAR2(15) NOT NULL |
Key Value 04
|
| 126 |
KEY_05 |
Character(15) |
VARCHAR2(15) NOT NULL |
Key Value 05
|
| 127 |
KEY_06 |
Character(15) |
VARCHAR2(15) NOT NULL |
Key Value 06
|
| 128 |
KEY_07 |
Character(15) |
VARCHAR2(15) NOT NULL |
Key Value 07
|
| 129 |
KEY_08 |
Character(15) |
VARCHAR2(15) NOT NULL |
Key Value 08
|
| 130 |
KEY_09 |
Character(15) |
VARCHAR2(15) NOT NULL |
Key Value 09
|
| 131 |
KEY_10 |
Character(15) |
VARCHAR2(15) NOT NULL |
Key Value 10
|
| 132 |
KEY_11 |
Character(15) |
VARCHAR2(15) NOT NULL |
Key Value 11
|
| 133 |
KEY_12 |
Character(15) |
VARCHAR2(15) NOT NULL |
Key Value 12
|
| 134 |
KEY_13 |
Character(15) |
VARCHAR2(15) NOT NULL |
Key Value 13
|
| 135 |
KEY_14 |
Character(15) |
VARCHAR2(15) NOT NULL |
Key Value 14
|
| 136 |
KEY_15 |
Character(15) |
VARCHAR2(15) NOT NULL |
Key Value 15
|