VCHR_DIST_ASSET

(SQL Table)
Index Back

Voucher Distribution Asset Dtl

Voucher Distribution Asset Details

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
5 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
6 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
7 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
8 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
9 RECV_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Receiver Distrib Line
10 DISTRIB_SEQ_NUM Number(5,0) INTEGER NOT NULL Distribution Sequence
11 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
12 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID