SAC_PO_ERP_HD_V

(SQL View)
 Index Back

Hdr 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.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.CHNG_ORD_SEQ ,A.BILL_LOCATION ,A.TAX_EXEMPT ,A.TAX_EXEMPT_ID ,A.CURRENCY_CD ,A.OPRID_ENTERED_BY ,A.ENTERED_DT , A.OPRID_MODIFIED_BY , A.LAST_DTTM_UPDATE ,A.ACCOUNTING_DT ,A.BUSINESS_UNIT_GL ,A.VAT_ENTITY ,A.BACKORDER_STATUS ,A.PHONE ,A.FAX ,A.NAME1 ,A.ADDRESS1 ,A.ADDRESS2 ,A.CITY ,A.STATE ,A.POSTAL ,A.COUNTRY ,A.EMAILID ,B.DESCR ,B.COUNTRY ,B.ADDRESS1 ,B.ADDRESS2 ,B.ADDRESS3 ,B.ADDRESS4 ,B.CITY ,B.STATE ,B.POSTAL ,B.COUNTRY_CODE ,B.PHONE ,B.EXTENSION ,B.FAX ,C.DESCR ,C.COUNTRY ,C.ADDRESS1 ,C.ADDRESS2 ,C.ADDRESS3 ,C.ADDRESS4 ,C.CITY ,C.STATE ,C.POSTAL ,C.COUNTRY_CODE ,C.PHONE ,C.EXTENSION ,C.FAX ,A.RATE_DATE ,A.RATE_MULT ,A.RATE_DIV FROM PS_SAC_PO_HDR_VW A , PS_SAC_PO_BILTO_VW B , PS_SAC_PO_BUDAT_VW C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PO_ID = C.PO_ID

# 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

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

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

Default Value: U

9 PO_DT Date(10) DATE NOT NULL Date

Default Value: %date

10 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
11 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
12 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
13 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
14 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.
15 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
16 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
17 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location

Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION

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

Default Value: BUS_UNIT_TBL_PM.TAX_EXEMPT

19 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID
20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_TBL_PM.CURRENCY_CD

21 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
22 ENTERED_DT Date(10) DATE Entered on
23 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.
24 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.
25 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
26 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL

27 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.
28 BACKORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Back Order Status
1=Not Backordered
2=Backordered
3=Backordered Received

Default Value: 1

29 VENDOR_PHONE Character(24) VARCHAR2(24) NOT NULL Buyer Phone
30 VENDOR_FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
31 NAME1_VNDR Character(40) VARCHAR2(40) NOT NULL Vendor Name
32 ADDRESS1_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 1
33 ADDRESS2_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 2
34 CITY_VNDR Character(30) VARCHAR2(30) NOT NULL Vendor City
35 STATE_VNDR Character(6) VARCHAR2(6) NOT NULL Vendor State
36 POSTAL_VNDR Character(12) VARCHAR2(12) NOT NULL Vendor Postal Code
37 COUNTRY_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Country
38 EMAILID_VNDR Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
39 BU_DESCR Character(30) VARCHAR2(30) NOT NULL Business unit description.
40 COUNTRY_BU Character(3) VARCHAR2(3) NOT NULL Business Unit Country
41 ADDRESS1_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 1
42 ADDRESS2_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 2
43 ADDRESS3_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 3
44 ADDRESS4_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 4
45 CITY_BU Character(30) VARCHAR2(30) NOT NULL Business Unit City
46 STATE_BU Character(6) VARCHAR2(6) NOT NULL Business Unit State
47 POSTAL_BU Character(12) VARCHAR2(12) NOT NULL Business Unit Postal Code
48 BU_COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
49 BU_PHONE Character(24) VARCHAR2(24) NOT NULL Buyer Phone
50 BU_EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
51 BU_FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
52 BILLTO_DESCR Character(30) VARCHAR2(30) NOT NULL Bill to descr
53 COUNTRY_BILLTO Character(3) VARCHAR2(3) NOT NULL Bill To Country
54 ADDRESS1_BILL Character(55) VARCHAR2(55) NOT NULL Bill to Address Line 1
55 ADDRESS2_BILL Character(55) VARCHAR2(55) NOT NULL Bill to Address Line 2
56 ADDRESS3_BILL Character(55) VARCHAR2(55) NOT NULL Bill to Address Line 3
57 ADDRESS4_BILL Character(55) VARCHAR2(55) NOT NULL Bill to Address Line 4
58 CITY_BILLTO Character(30) VARCHAR2(30) NOT NULL Bill To City
59 STATE_BILLTO Character(6) VARCHAR2(6) NOT NULL Bill To State
60 POSTAL_BILLTO Character(12) VARCHAR2(12) NOT NULL Bill To Postal
61 BILL_COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
62 BILLTO_PHONE Character(24) VARCHAR2(24) NOT NULL Buyer Phone
63 BILLTO_EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
64 BILLTO_FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
65 RATE_DATE Date(10) DATE Exchange Rate Date
66 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
67 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor