PO_RQLD_TMP_BU1

(SQL Table)
Index Back

# 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 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.
4 LOADER_BU Character(5) VARCHAR2(5) NOT NULL Requesting Loader Bus Unit
5 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
6 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

8 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
9 ACCOUNTING_DT_IND Character(1) VARCHAR2(1) NOT NULL Accounting Date Indicator
C=Use Current Date
D=Business Unit Default
P=Use Payment Date
S=Use Specific Date
10 ALLOW_MC_REQ Character(1) VARCHAR2(1) NOT NULL Allow Multicurrency Reqs
11 APPL_JRNL_ID_ENC Character(10) VARCHAR2(10) NOT NULL Encumbrance
12 APPR_ACTION Character(1) VARCHAR2(1) NOT NULL Approval Action
A=Approve
D=Deny
R=Recycle
13 APPROVAL_DT Date(10) DATE Date of Approval
14 APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
A=Approved
D=Denied
E=Sent Back for Revision
H=On Hold
I=Initial
M=Resubmitted
P=In Process
R=Rerouted
S=Submitted
15 AUTO_LOAD Character(1) VARCHAR2(1) NOT NULL Auto Load Indicator
16 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
17 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
18 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
19 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
20 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
21 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
22 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
23 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
24 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
25 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
26 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
27 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
28 CHARTFIELD_STATUS Character(1) VARCHAR2(1) NOT NULL Chartfield Status
R=Recycled
V=Valid
29 CONSOLIDATE_FLG Character(1) VARCHAR2(1) NOT NULL Consolidate with other Reqs
N=No
Y=Yes
30 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
31 CURRENCY_CD_BUGL Character(3) VARCHAR2(3) NOT NULL GL Business Unit Currency
32 DECIMAL_POS_BSE Number(2,0) SMALLINT NOT NULL Base Cur Decimal Positions
33 DECIMAL_POS_BUGL Number(1,0) SMALLINT NOT NULL Decimal Positions for GL BU
34 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
35 FINANCIAL_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Capitalized Asset
N=Non Cap
Y=Capitalize
36 INVENTORY_SRC_FLG Character(1) VARCHAR2(1) NOT NULL Inventory Source Flag
37 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
38 ITEM_BU_ATTR Character(1) VARCHAR2(1) NOT NULL Allow Business Item Attributes
39 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
40 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By
41 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
42 PRICE_CAN_CHANGE Character(1) VARCHAR2(1) NOT NULL Price Can Be Changed on Order
N=No
Y=Yes
43 PCT_UNIT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance
44 PCT_UNIT_PRC_TOL_L Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance - Under
45 REQ_AMT_APPR_REQD Character(1) VARCHAR2(1) NOT NULL Req Amount Approval Needed
46 REQ_CF_APPR_REQD Character(1) VARCHAR2(1) NOT NULL Req ChartField Approval Needed
47 REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Req status
A=Approved
C=Complete
D=Denied
I=Initial
LA=Line Approved
O=Open
P=Pending Approval
V=Preview
X=Canceled
48 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
49 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.
50 RT_TYPE_BUGL Character(5) VARCHAR2(5) NOT NULL Rate Type for GL Business Unit
51 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
52 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
53 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
54 UNIT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance
55 UNIT_PRC_TOL_L Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance - Under
56 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
57 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

58 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

59 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

60 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

61 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

62 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

63 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

64 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

65 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

66 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

67 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

68 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

69 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJID_BUGL_VW

70 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event