PO_HDR_AW_VW

(SQL View)
 Index Back

PO Header Approval View

Purchase Order Header Approval View.

SELECT A.BUSINESS_UNIT , A.PO_ID , A.CHNG_ORD_BATCH , 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.PRICE_SETID , A.PRICE_VENDOR , A.PRICE_LOC , A.PYMNT_TERMS_CD , A.BUYER_ID , A.ORIGIN , A.CHNG_ORD_SEQ , 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.OPRID_ENTERED_BY , A.ENTERED_DT , A.OPRID_APPROVED_BY , A.APPROVAL_DT , %subrec(LAST_UPDATE_SBR,A) , A.ACCOUNTING_DT , A.BUSINESS_UNIT_GL , A.IN_PROCESS_FLG , A.ACTIVITY_DATE , A.PO_POST_STATUS , A.NEXT_MOD_SEQ_NBR , A.ERS_ACTION , A.ACCRUE_USE_TAX , A.CURRENCY_CD_BASE , A.RATE_DATE , A.RATE_MULT , A.RATE_DIV , A.VAT_ENTITY , %subrec(KK_TRAN_SBR,A) , A.LC_ID , A.BUDGET_HDR_STS_NP , A.PREPAID_PO_FLG , A.PREPAID_AMT , A.PREPAID_AUTH_STAT , A.PREPAID_STATUS_PO , A.PAY_TRM_BSE_DT_OPT , A.TERMS_BASIS_DT , A.BACKORDER_STATUS , A.DOC_TOL_HDR_STATUS , A.MID_ROLL_STATUS , %subrec(PUR_USR_HDR_SBR, A) , A.BUDGET_CHECK , A.CC_SECURITY_ID , A.CC_USE_FLAG , A.CC_DISP_OPTION , A.CONTACT_NAME , A.CONTACT_PHONE , A.TEXT254_CC2 , A.POA_STATUS , A.POA_REQS FROM PS_PO_HDR A WHERE A.PO_STATUS <> 'X'

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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_PM_NONVW

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

Default Value: NEXT

3 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
4 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
GEN=General
KAN=Kanban

Default Value: GEN

5 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

Default Value: I

6 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing

Y/N Table Edit

Default Value: N

7 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

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

Y/N Table Edit

Default Value: Y

9 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
10 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
C=Changed
U=Unchanged

Default Value: U

11 PO_DT Date(10) DATE NOT NULL Date

Default Value: %date

12 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
13 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
14 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PO_VW

15 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VNDR_LOC_ORD_VW

16 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID
17 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID
18 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from Location
19 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.

Prompt Table: PYMT_TR_EFF_VW

20 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: %EDIT_BUYER

21 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

Prompt Table: ORIGIN_PO

22 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
23 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

Default Value: VENDOR.ADDR_SEQ_NUM_ORDR

Prompt Table: VENDOR_ADDR_VW

24 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

Prompt Table: VENDOR_CNTCT_VW

25 SALES_CNTCT_SEQ_N Number(3,0) SMALLINT NOT NULL Salesperson

Prompt Table: VENDOR_CNTCT_VW

26 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location

Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION

Prompt Table: LOCATION_TBL

27 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

Default Value: BUS_UNIT_TBL_PM.TAX_EXEMPT

28 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID
29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

30 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.
31 MATCH_ACTION Character(1) VARCHAR2(1) NOT NULL Match Action
N=No Match
Y=Standard

Default Value: N

32 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule

Prompt Table: %EDITTABLE2

33 MATCH_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Match Status
M=Matched
N=Not Required
P=Partially Matched
T=To Match

Default Value: N

34 MATCH_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Match In Process
I=In Process
N=No

Default Value: N

35 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
36 APPL_JRNL_ID_ENC Character(10) VARCHAR2(10) NOT NULL Encumbrance
37 POST_DOC Character(1) VARCHAR2(1) NOT NULL Post Document

Y/N Table Edit

Default Value: N

38 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template

Default Value: BUS_UNIT_OPT_PM.DST_CNTRL_ID

Prompt Table: DST_CNTRL_VW

39 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
40 ENTERED_DT Date(10) DATE Entered on
41 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By
42 APPROVAL_DT Date(10) DATE Date of Approval
43 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.
44 LAST_DTTM_UPDATE 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.
45 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
46 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL

47 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

Y/N Table Edit

Default Value: N

48 ACTIVITY_DATE Date(10) DATE Last Activity
49 PO_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Post Status
D=Distributed
N=None

Default Value: N

50 NEXT_MOD_SEQ_NBR Number(3,0) SMALLINT NOT NULL Next Modification Number
51 ERS_ACTION Character(1) VARCHAR2(1) NOT NULL ERS Action
N=No
Y=Yes

Default Value: N

52 ACCRUE_USE_TAX Character(1) VARCHAR2(1) NOT NULL Accrue Use Tax

Y/N Table Edit

Default Value: BUS_UNIT_TBL_PM.ACCRUE_USE_TAX

53 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

Prompt Table: CURRENCY_CD_TBL

54 RATE_DATE Date(10) DATE Exchange Rate Date
55 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
56 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
57 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
58 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

59 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
60 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
61 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
62 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
63 LC_ID Character(12) VARCHAR2(12) NOT NULL Treasury Letter of Credit Number Assigned by the System

Prompt Table: LC_HDR_PO_VW
Set Control Field: BUSINESS_UNIT_GL

64 BUDGET_HDR_STS_NP Character(1) VARCHAR2(1) NOT NULL Budget Ch'k Hdr Sts NonProrate
E=Error in Budget Check
N=Not Budget Checked
P=Provisionally Valid
V=Valid Budget Check
65 PREPAID_PO_FLG Character(1) VARCHAR2(1) NOT NULL Prepaid PO Flag

Y/N Table Edit

Default Value: N

66 PREPAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Prepaid Amount
67 PREPAID_AUTH_STAT Character(1) VARCHAR2(1) NOT NULL Prepaid Authorization Status
A=Authorized
N=Not Approved
P=Pending Authorization

Default Value: N

68 PREPAID_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Prepaid PO Status
N=Not Processed
P=Processing
V=Vouchered

Default Value: N

69 PAY_TRM_BSE_DT_OPT Character(1) VARCHAR2(1) NOT NULL Payment Terms Basis Date Type
A=Acct Date
C=Doc Date
I=Inv Date
R=Recpt Date
S=Ship Date
U=User Date
70 TERMS_BASIS_DT Date(10) DATE Payment Terms Basis Date
71 BACKORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Back Order Status
1=Not Backordered
2=Backordered
3=Backordered Received

Default Value: 1

72 DOC_TOL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Document Heade Document Tolerance Status
E=Error
N=Not Checked
R=Reset
V=Valid

Default Value: V

73 MID_ROLL_STATUS Character(1) VARCHAR2(1) NOT NULL Mid Roll Status
74 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
75 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
76 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
77 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
78 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
79 CUSTOM_DATE_A Date(10) DATE Custom Date
80 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2
81 BUDGET_CHECK Character(1) VARCHAR2(1) NOT NULL Budget Checked
N=No
Y=Yes

Y/N Table Edit

Default Value: N

82 CC_SECURITY_ID Number(10,0) DECIMAL(10) NOT NULL Procurement Card Number
83 CC_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Use Procurement Card

Y/N Table Edit

Default Value: N

84 CC_DISP_OPTION Character(1) VARCHAR2(1) NOT NULL ProCard Dispatch Option
A=Default
B=Include Masked Card Info
C=Contact Buyer
D=Contact Cardholder
E=Charge to Card on File
F=No Reference

Default Value: A

85 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
86 CONTACT_PHONE Character(24) VARCHAR2(24) NOT NULL Recepient Phone
87 TEXT254_CC2 Character(254) VARCHAR2(254) NOT NULL Payment Instructions
88 POA_STATUS Character(2) VARCHAR2(2) NOT NULL po ack status field that will be on po_hdr.
AC=Acknowledged with changes
AK=Acknowledged
BA=Approved, Changes Pending
IN=Initial Dispatch Acknowledged
NR=Not Required
SR=Responded, Awaits Review
WD=Awaiting PO Dispatch
WR=Awaiting Acknowledgement
89 POA_REQS Character(1) VARCHAR2(1) NOT NULL CEL. New field to store POA requirements on the PO Hdr
A=All dispatches
I=Initial dispatch only
N=Not required

Default Value: N