IN_ITM_TRAN_QTY

(SQL Table)
Index Back

Tansaction Group Usage Qty

# 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 Character(5) VARCHAR2(5) NOT NULL Business Unit
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
5 START_DT Date(10) DATE Start Date
6 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
7 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
8 END_DT Date(10) DATE End Date
9 SHIP_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipped Quantity