GM_PRJ_RESB_TAO(SQL Table) |
Index Back |
|---|---|
Grants F&A Work Tbl |
| # | 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 | Character(5) | VARCHAR2(5) NOT NULL | 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 | POST_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | POSTING SEQUENCE NUMBER |
| 7 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 8 | ANALYSIS_TYPE_MAP | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type Map |
| 9 | RESOURCE_ID_FROM | Character(40) | VARCHAR2(40) NOT NULL | Original Transaction ID |
| 10 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 11 | 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. |
| 12 | JOURNAL_DATE | Date(10) | DATE | Specifies the date the journal was created. |
| 13 | 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". |
| 14 | 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. |
| 15 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 16 | 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. |
| 17 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 18 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 19 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 20 | ASSOC_DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Associated Department |
| 21 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField |
| 22 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
| 23 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
| 24 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Class Field |
| 25 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
| 26 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |
| 27 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Affiliate |
| 28 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
| 29 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
| 30 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 |
| 31 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
| 32 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
| 33 | BUS_UNIT_GL_FROM | Character(5) | VARCHAR2(5) NOT NULL | From Business Unit GL |
| 34 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 35 | STATISTICS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Statistics Code |
| 36 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 37 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 38 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 39 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 40 | RES_USER1 | Character(10) | VARCHAR2(10) NOT NULL | Transaction User 1 |
| 41 | RES_USER2 | Character(10) | VARCHAR2(10) NOT NULL | Transaction User 2 |
| 42 | RES_USER3 | Character(10) | VARCHAR2(10) NOT NULL | Transaction User 3 |
| 43 | RES_USER4 | Character(10) | VARCHAR2(10) NOT NULL | Transaction User 4 |
| 44 | RES_USER5 | Character(10) | VARCHAR2(10) NOT NULL | Transaction User 5 |
| 45 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 46 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 47 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 48 | 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. |
| 49 | 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. |
| 50 | OPEN_ITEM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Open Item Status
C=Closed Item N=Not an Open Item Account O=Open Item |
| 51 | 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. |
| 52 | 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) |
| 53 | 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. |
| 54 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 55 | 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. |
| 56 | 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. |
| 57 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 58 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 59 | 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. |
| 60 | 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 |
| 61 | 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 |
| 62 | PROJ_TRANS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Project Transaction Type |
| 63 | PROJ_TRANS_CODE | Character(5) | VARCHAR2(5) NOT NULL | Project Transaction Code |
| 64 | RESOURCE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Status
A=Resource Approved U=Unapproved Resource |
| 65 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 66 | 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. |
| 67 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 68 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 69 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 70 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 71 | TIME_RPTG_CD | Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code |
| 72 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 73 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 74 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 75 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 76 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 77 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 78 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 79 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 80 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |
| 81 | 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 |
| 82 | 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 |
| 83 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 84 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 85 | REQ_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Requisition Line Number |
| 86 | REQ_SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Requisition Schedule Number |
| 87 | REQ_DISTRIB_NBR | Number(5,0) | INTEGER NOT NULL | Requisition Distrib Number |
| 88 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 89 | DUE_DATE | Date(10) | DATE | Delivery Due Date from PO |
| 90 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 91 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 92 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 93 | 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 |
| 94 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 95 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 96 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Asset Profile ID |
| 97 | COST_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Cost Type |
| 98 | BOOK | Character(10) | VARCHAR2(10) NOT NULL | Asset Book Name |
| 99 | INCENTIVE_ID | Character(10) | VARCHAR2(10) NOT NULL | Investment Incentive ID |
| 100 | MSTONE_SEQ | Number(3,0) | SMALLINT NOT NULL | Milestone Sequence |
| 101 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 102 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 103 | CONTRACT_PPD_SEQ | Number(5,0) | INTEGER NOT NULL | Prepaid Add Sequence |
| 104 | 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 |
| 105 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 106 | BILLING_DATE | Date(10) | DATE | Billing Date |
| 107 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 108 | REV_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Revenue Distribution Status
C=Created D=Distributed G=Generated I=Ignore N=Not Distributed |
| 109 | BUSINESS_UNIT_AR | Character(5) | VARCHAR2(5) NOT NULL | AR Business Unit |
| 110 | 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. |
| 111 | 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. |
| 112 | ITEM_LINE | Number(6,0) | INTEGER NOT NULL | Item Line |
| 113 | ITEM_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Item Sequence Number |
| 114 | DST_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Distribution Sequence |
| 115 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 116 | SCHED_LINE_NO | Number(7,2) | DECIMAL(6,2) NOT NULL | Sched Line NO |
| 117 | DEMAND_LINE_NO | Number(4,0) | SMALLINT NOT NULL | Demand Line No |
| 118 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 119 | PAY_END_DT | Date(10) | DATE | Pay Period End Date |
| 120 | BUSINESS_UNIT_OM | Character(5) | VARCHAR2(5) NOT NULL | Order Management Business Unit |
| 121 | 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 |
| 122 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 123 | EX_DOC_ID | Character(10) | VARCHAR2(10) NOT NULL | Documentation ID |
| 124 | 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 |
| 125 | RESOURCE_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Quantity |
| 126 | RESOURCE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 127 | BUDGET_OVER_ALLOW | Character(1) | VARCHAR2(1) NOT NULL | Budget Overrun Allowed |
| 128 | BUDGET_LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
->
SL - 15-AUG-2002
MISC_CRITERIA label has been added
<-
B=Bypass E=Error N=Not Chk'd V=Valid W=Warning |
| 129 | BUDGET_DT | Date(10) | DATE | Budget Date |
| 130 | BD_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
BD Distribution Status
D=Distributed I=Ignore N=None |
| 131 | BUSINESS_UNIT_BD | Character(5) | VARCHAR2(5) NOT NULL | Budgeting Business Unit |
| 132 | FA_STATUS | Character(1) | VARCHAR2(1) NOT NULL | F&A Status |
| 133 | BCM_APPLICABLE | Character(1) | VARCHAR2(1) NOT NULL | BCM Applicable |
| 134 | FA_ERROR_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
F&A Error Status
AD=No Offset Assoc. Dept CC=Combo Err - Cost Shared F&A CF=Combo Error- IntraUnit Rec F&A CO=Combo Error - Offset F&A CS=Combo Error - Sponsor F&A CT=Combo Error- IntraUnit Pay F&A CW=Combo Error - Waived F&A E=Error in Budget Checking I=IntraUnit Error N=Not Budget Checked RF=Funded Rate Pct Not Found RI=Institution Rate Pct Not Found RS=Sponsor Rate Pct Not Found V=Valid Budget Check W=Warning in Budget Checking |
| 135 | DST_ID | Character(10) | VARCHAR2(10) NOT NULL | Distribution Code |
| 136 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 137 | COMBO_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Combo Status
I=Invalid V=Valid |
| 138 | STATISTIC_AMOUNT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT. |
| 139 | BCM_TRAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Transaction Type
AR=Accounts Receivable Item EN=Encumbrance EX=Expended JU=Journal Unpost JV=Journal Voucher PM=AR Payment (Reference Item) PN=AR Payment (No Reference Item) PO=Purchase Order PR=Pre Encumbrance RQ=Requisition |
| 140 | FA_RATE_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | FA_RATE_PCT |
| 141 | RESOURCE_AMT_TMP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Resource Amount |
| 142 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 143 | 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). |
| 144 | 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. |
| 145 | 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. |
| 146 | MAX_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Maximum Sequence Number |
| 147 | IU_LINE_TYPE | Character(1) | VARCHAR2(1) NOT NULL | 1 - original transactions 2 - original transactions aggregated 3 - InterUnit Anchor w/o base (primary ledger lines) 4 - secondary non-translation ledger lines 5 - secondary translation ledger lines 6 - used as holding area for iu line type '3' when processing multicurrency 7 - already allocated secondary ledger lines 8 - InterUnit Anchor w/ base, already allocated primary ledger lines 9 - InterUnit Non-anchor A - IntraUnit Anchor B - IntraUnit non-anchor N - New lines U - Unbalanced x,y,z - lowercase letters to ignore for addl processing, marked as deleted |
| 148 | IU_LEGAL_ENT_BU_IU | Character(5) | VARCHAR2(5) NOT NULL | The business unit that represents the legal entity to which the GL Unit belongs. May have the same value as the GL Unit if it is its own legal entity. |
| 149 | PRIMARY_LEDGER_IU | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group. |
| 150 | TRANSL_LEDGER_IU | Character(1) | VARCHAR2(1) NOT NULL | Currency Translation Ledger |
| 151 | SETID_IU | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 152 | LEDGERS_SYNC_IU | Character(1) | VARCHAR2(1) NOT NULL | Keep Ledgers in Sync |
| 153 | SECOND_LEDGERS_IU | Character(1) | VARCHAR2(1) NOT NULL | Secondary Ledgers Exist |
| 154 | MAX_SEQUENCE | Number(9,0) | DECIMAL(9) NOT NULL |