IN_BAL_LN_TMP

(SQL Table)
Index Back

Temp LN table for Balance MSG

11/99 Created.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
8 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
9 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
10 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
11 QTY_ONHAND Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity On Hand
12 QTY_OWNED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Owned
13 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
14 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag