PO_RECVASN_AET

(SQL Table)
Index Back

ASN Receiver Process Cache Rec

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 ABORT_FLAG Character(1) VARCHAR2(1) NOT NULL Abort Process Flag
5 AE_CNV_IN_FLD_NM Character(18) VARCHAR2(18) NOT NULL AE input convert field
6 AE_CNV_OUT_FLD_NM Character(18) VARCHAR2(18) NOT NULL AE output converion field
7 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
8 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
9 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
10 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
11 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
12 PO_SCHED_NBR Number(3,0) SMALLINT NOT NULL PO Schedule Number
13 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
14 RECORD_COUNT Number(7,0) INTEGER NOT NULL Count of Records
15 RECV_ID_LAST_USED Number(10,0) DECIMAL(10) NOT NULL Last Receiver Number
16 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
17 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
18 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number
19 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
20 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
21 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
22 TEMP_LINE_NBR Number(5,0) INTEGER NOT NULL Temporary Line Number