AR_OM_HDR_VW2

(SQL View)
 Index Back

SELECT BUSINESS_UNIT ,ORDER_NO ,SOLD_TO_CUST_ID ,BILL_TO_CUST_ID ,ADDRESS_SEQ_NUM ,ADDRESS_SEQ_SHIP ,ADDRESS_SEQ_SOLD ,BCKORDR_CNCL_FLAG ,CARRIER_ID ,CARRIER_ID_EXP ,CNTCT_SEQ_NUM ,CONFIRM_PO_RECVD ,CNTRCT_ID ,CURRENCY_CD ,CURRENCY_CD_BASE ,CUSTOMER_PO ,DIRECT_INVOICING ,EXPORT ,EXPORT_LIC_REQ ,FREIGHT_TERMS ,IMPORT_LIC_REQ ,ORDER_DATE ,ORDER_GRP ,ORDER_STATUS ,PAYMENT_METHOD ,PROD_ID_SRC ,PYMNT_TERMS_CD ,QUOTE_NBR ,REQ_ARRIVAL_DTTM ,REVISION_NUMBER ,SHIP_PARTIAL_FLAG ,SHIP_PARTIAL_ORD ,SHIP_PRIOR_FLAG ,SHIP_PRIORITY_ID ,SHIP_TO_CUST_ID ,SHIP_TYPE_ID ,SOURCE_CD ,STORE_NUMBER ,SUBCUST_QUAL1 ,SUBCUST_QUAL2 ,TAX_CD ,TAX_EXEMPT_CERT ,TAX_EXEMPT_FLG FROM PS_ORD_HEADER WHERE ORDER_TYPE_CD = 'SO'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
4 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
5 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

Prompt Table: CUST_ADDRBLL_VW

6 ADDRESS_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Address - Ship To

Prompt Table: CUST_ADDRSHP_VW

7 ADDRESS_SEQ_SOLD Number(5,0) INTEGER NOT NULL Primary Address - Sold To

Prompt Table: CUST_ADDRSLD_VW

8 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
9 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
10 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID
11 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
12 CONFIRM_PO_RECVD Character(1) VARCHAR2(1) NOT NULL Confirming PO Received
N=No
Y=Yes

Y/N Table Edit

13 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
15 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
16 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
17 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing
18 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes
19 EXPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Export License Required
NO=No
YES=Yes
20 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
21 IMPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Import License Required
NO=No
YES=Yes
22 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
23 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group
24 ORDER_STATUS Character(3) VARCHAR2(3) NOT NULL Order Status
C=Closed
O=Open
P=Pending
X=Canceled
25 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report
26 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
C=Customer
P=UPC
S=System
U=Universal
27 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.
28 QUOTE_NBR Character(15) VARCHAR2(15) NOT NULL Quotation Number
29 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival
30 REVISION_NUMBER Number(3,0) SMALLINT NOT NULL Revision
31 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
N=Ship Partial No
Y=Ship Partial Yes
32 SHIP_PARTIAL_ORD Character(1) VARCHAR2(1) NOT NULL Partial Order
N=Partial Order No
Y=Partial Order Yes
33 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
N=Ship Prior No
Y=Ship Prior Yes
34 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code
35 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
36 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
37 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code
38 STORE_NUMBER Character(17) VARCHAR2(17) NOT NULL Store Number
39 SUBCUST_QUAL1 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
40 SUBCUST_QUAL2 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
41 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code
42 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate
43 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

Default Value: N