PO_ROLLOPEN_DTL

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ASOFDATE Date(10) DATE As of Date
3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
7 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
8 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
9 LINE_NBR_TO Number(5,0) INTEGER NOT NULL Line number To
10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
11 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
12 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
13 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity
14 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
15 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
16 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
17 QTY_RECEIVED Number(16,4) DECIMAL(15,4) NOT NULL Received Qty
18 QTY_ROLLED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Rolled
19 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
20 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
21 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
22 PO_ENCUM_NET Signed Number(28,3) DECIMAL(26,3) NOT NULL Outstanding PO Encumbrance
23 PO_ENCUM_NET_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Outstanding PO Encumbrance Bse
24 AMT_ROLLED Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Rolled
25 AMT_ROLLED_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Rolled Base
26 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
27 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
28 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
29 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
30 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

42 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
43 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
44 BUDGET_DT Date(10) DATE Budget Date
45 BUDGET_DT_TO Date(10) DATE Budget Date
46 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.
47 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
48 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
49 REPLEN_OPT Character(2) VARCHAR2(2) NOT NULL Replenish Code
01=Standard
02=Stockless
50 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
51 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
52 ROLL_ERR_FLG Character(1) VARCHAR2(1) NOT NULL Rollover Error Flag
53 ROLL_ERROR Character(3) VARCHAR2(3) NOT NULL Rollover Error Code
IPO=Invalid Budget Status - PO
IVC=Invalid Budget Status - VCHR
N=None
PR=InvBudStat PO & Rec part vchrd
PV=Invalid Bud Stat PO & Voucher
PVR=InvBudStat PO&VC, Rec part vch
R=Rolled
RV=One receipt is partially vchrd
VR=InvBudStat VC & Rec part vchrd
54 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
55 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
56 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance