PO_HDR_VW_AM

(SQL View)
 Index Back

Purchase Order Header View


select a.BUSINESS_UNIT, a.PO_ID, a.PO_TYPE, a.PO_STATUS, a.HOLD_STATUS, a.RECV_STATUS, a.DISP_ACTION, a.DISP_METHOD, a.CHANGE_STATUS, a.PO_DT, a.PO_REF, a.VENDOR_SETID, a.VENDOR_ID, a.VNDR_LOC, a.PYMNT_TERMS_CD, a.BUYER_ID, a.ORIGIN, a.CHNG_ORD_SEQ, a.CHNG_ORD_BATCH, a.ADDRESS_SEQ_NUM, a.CNTCT_SEQ_NUM, a.SALES_CNTCT_SEQ_N, a.BILL_LOCATION, a.TAX_EXEMPT, a.TAX_EXEMPT_ID, a.CURRENCY_CD, a.RT_TYPE, a.MATCH_ACTION, a.MATCH_CNTRL_ID, a.MATCH_STATUS_PO, a.MATCH_PROCESS_FLG, a.PROCESS_INSTANCE, a.APPL_JRNL_ID_ENC, a.POST_DOC, a.DST_CNTRL_ID, a.ACCOUNTING_DT, a.BUSINESS_UNIT_GL, a.IN_PROCESS_FLG, a.ACTIVITY_DATE, a.PO_POST_STATUS, a.NEXT_MOD_SEQ_NBR, a.OPRID_MODIFIED_BY, a.CURRENCY_CD_BASE, a.RATE_DATE, a.RATE_MULT, a.RATE_DIV, %subrec(kk_tran_sbr,a) from PS_PO_HDR_FS a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

Default Value: NEXT

3 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
GEN=General
KAN=Kanban
4 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
5 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing

Y/N Table Edit

Default Value: N

6 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled

Default Value: N

7 DISP_ACTION Character(1) VARCHAR2(1) NOT NULL Allow Dispatch When Appr

Y/N Table Edit

Default Value: Y

8 DISP_METHOD Character(3) VARCHAR2(3) NOT NULL Dispatch Method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
9 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
C=Changed
U=Unchanged

Default Value: U

10 PO_DT Date(10) DATE Date

Default Value: %date

11 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
12 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
13 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
14 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
15 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
16 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
17 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
18 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
19 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
20 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
21 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
22 SALES_CNTCT_SEQ_N Number(3,0) SMALLINT NOT NULL Salesperson
23 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location
24 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

Default Value: N

25 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID
26 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
27 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.
28 MATCH_ACTION Character(1) VARCHAR2(1) NOT NULL Match Action
N=No Match
Y=Standard

Y/N Table Edit

29 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
30 MATCH_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Match Status
M=Matched
N=Not Required
P=Partially Matched
T=To Match
31 MATCH_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Match In Process
I=In Process
N=No

Default Value: N

32 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
33 APPL_JRNL_ID_ENC Character(10) VARCHAR2(10) NOT NULL Encumbrance
34 POST_DOC Character(1) VARCHAR2(1) NOT NULL Post Document
35 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
36 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
37 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
38 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
39 ACTIVITY_DATE Date(10) DATE Last Activity
40 PO_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Post Status
D=Distributed
N=None
41 NEXT_MOD_SEQ_NBR Number(3,0) SMALLINT NOT NULL Next Modification Number
42 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
43 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

Prompt Table: CURRENCY_CD_TBL

44 RATE_DATE Date(10) DATE Exchange Rate Date
45 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
46 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
47 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

Default Value: V

48 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
49 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
50 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
51 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime