PC_ALLOC_CALC(SQL Table) |
Index Back |
|---|---|
Allocation Calculations - Proj |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PROCESS_STEP | Character(10) | VARCHAR2(10) NOT NULL | Process Step |
| 3 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: PROJ_ACTIVITY.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
| 5 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: PROJ_ACTIVITY.PROJECT_ID Prompt Table: PROJ_SCRTY_SRCH |
| 6 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Default Value: PROJ_ACTIVITY.ACTIVITY_ID Prompt Table: PROJ_ACT_SRCH |
| 7 | RESOURCE_ID | Character(40) | VARCHAR2(40) NOT NULL | Transaction ID |
| 8 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: PC_INT_TMPL_GL |
| 9 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 10 | 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. |
| 11 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL |
Account
Prompt Table: GL_ACCT_BUGL_VW |
| 12 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table: ALTACCT_BUGL_VW |
| 13 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPTID_BUGL_VW |
| 14 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW |
| 15 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table: PRODUCT_BUGL_VW |
| 16 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: FUND_BUGL_VW |
| 17 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL |
Class Field
Prompt Table: CLASSCF_BUGL_VW |
| 18 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW |
| 19 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table: BUD_REF_BUGL_VW |
| 20 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table: AFFILIATE_VW |
| 21 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01 |
| 22 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02 |
| 23 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table: CF1_BUGL_VW |
| 24 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW |
| 25 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW |
| 26 | BUS_UNIT_GL_FROM | Character(5) | VARCHAR2(5) NOT NULL |
From Business Unit GL
Prompt Table: PC_INT_TMPL_GL |
| 27 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: PC_INT_TMPL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |
| 28 | STATISTICS_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Statistics Code
Prompt Table: STAT_BUGL_VW |
| 29 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 30 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table: PROJ_AN_GRP_VW |
| 31 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Source Type
Prompt Table: PROJ_RES_TYPE |
| 32 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Category
Prompt Table: %EDITTABLE |
| 33 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table: %EDITTABLE2 |
| 34 | TRANS_DT | Date(10) | DATE |
Transaction Date
Default Value: %date |
| 35 | ACCOUNTING_DT | Date(10) | DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %date |
| 36 | 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. |
| 37 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 38 | 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. |
| 39 | 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. |
| 40 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 41 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 42 | 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 Default Value: N |
| 43 | 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 Default Value: I |
| 44 | PROJ_TRANS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Project Transaction Type
Prompt Table: PROJ_TRANS_TYPE |
| 45 | PROJ_TRANS_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Project Transaction Code
Prompt Table: PROJ_TRANS_CODE |
| 46 | RESOURCE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Status
A=Resource Approved U=Unapproved Resource Default Value: A |
| 47 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 48 | 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. |
| 49 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL |
| 50 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL |
AP Business Unit
Default Value: PC_INT_TMPL.BUSINESS_UNIT_AP Prompt Table: SP_BU_AP_NONVW |
| 51 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: PROJ_VENDOR_VW |
| 52 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL |
Voucher ID
Prompt Table: PC_AP_VCHR_VW |
| 53 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 54 | 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 |
| 55 | 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 Default Value: 0 |
| 56 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL |
PO Business Unit
Default Value: PC_INT_TMPL.BUSINESS_UNIT_PO Prompt Table: SP_BU_PM_NONVW |
| 57 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 58 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Purchase Order
Prompt Table: PC_PO_HDR_VW |
| 59 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 60 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 61 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 62 | 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 |
| 63 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Default Value: PC_INT_TMPL.BUSINESS_UNIT_AM Prompt Table: SP_BU_AM_NONVW |
| 64 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table: PROJ_ASSET_VW |
| 65 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Asset Profile ID
Prompt Table: PROFILE_PCAM_VW |
| 66 | 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 Default Value: I |
| 67 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 68 | BUSINESS_UNIT_AR | Character(5) | VARCHAR2(5) NOT NULL |
AR Business Unit
Prompt Table: SP_BUARED_NONVW |
| 69 | 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.
Prompt Table: PROJ_CUST_VW |
| 70 | 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.
Prompt Table: ITEM_OPEN_PC_VW |
| 71 | ITEM_LINE | Number(6,0) | INTEGER NOT NULL | Item Line |
| 72 | ITEM_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Item Sequence Number |
| 73 | DST_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Distribution Sequence |
| 74 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL |
Inventory Unit
Default Value: PC_INT_TMPL.BUSINESS_UNIT_IN Prompt Table: SP_BUIN_NONVW |
| 75 | SCHED_LINE_NO | Number(7,2) | DECIMAL(6,2) NOT NULL | Sched Line NO |
| 76 | DEMAND_LINE_NO | Number(4,0) | SMALLINT NOT NULL | Demand Line No |
| 77 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: PROJ_ITEM_VW |
| 78 | BUSINESS_UNIT_OM | Character(5) | VARCHAR2(5) NOT NULL |
Order Management Business Unit
Prompt Table: SP_BUPCOM_NONVW |
| 79 | 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 |
| 80 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 81 | RESOURCE_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Quantity |
| 82 | RESOURCE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 83 | ALLOC_POOL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Allocations Pool Amount |
| 84 | ALLOC_POOL_PBA | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Allocations Pool PBA Amount |
| 85 | ALLOC_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Alloc Basis Amt |
| 86 | ALLOC_BASIS_TOT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Alloc Basis Total |
| 87 | ALLOC_TARG_OFF_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Alloc Target/Offset Amount |
| 88 | ALLOC_TARG_OFF_PBA | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Alloc Target/Offset PBA Amt |
| 89 | LOGICAL_RECORD | Character(1) | VARCHAR2(1) NOT NULL |
Allocations Logical Record
O=Offset T=Target |