RECV_ASN_DTL

(SQL Table)
Index Back

Staged ASN Receiver Detail

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 ASN_ID Character(3) VARCHAR2(3) NOT NULL ASN Primary Key
3 ASN_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL ASR Key sequence number
4 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
5 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
6 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
7 PO_SCHED_NBR Number(3,0) SMALLINT NOT NULL PO Schedule Number
8 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
9 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
10 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID