PO_PRINT_SH_WS

(SQL Table)
Index Back

PO Print Ship Working Scroll

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
2 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.
3 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
4 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
5 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
6 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
7 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
8 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
9 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
10 CANCEL_STATUS Character(1) VARCHAR2(1) NOT NULL Cancel Status
A=Active
C=Closed
D=Denied
H=Hold
O=Open
P=Pending Approval
X=Canceled
11 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
12 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
13 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
14 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
15 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer