RECV_DIST_TMP

(SQL Table)
Index Back

Temp ASN Receiver Dist

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
5 PO_SCHED_NBR Number(3,0) SMALLINT NOT NULL PO Schedule Number
6 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
7 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
8 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
9 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
10 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
11 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
12 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
13 FINANCIAL_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Capitalized Asset
N=Non Cap
Y=Capitalize
14 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID