IN_FRT_PCK_RSLT

(SQL View)
Index Back

SELECT ' ' ,' ' , ' ' , ' ' , ' ' , %DateNull ,0 FROM PS_IN_DEMAND WHERE IN_FULFILL_STATE >='50'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTENT_DESCR Character(254) VARCHAR2(254) NOT NULL Report Description
2 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 FRT_REF_NO Character(30) VARCHAR2(30) NOT NULL Freight Reference Number
5 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
6 ARRIVAL_DATE Date(10) DATE Arrival Date
7 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount