IN_VBTRXN_AET

#	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 Prompt Table: SP_BUIN_NONVW
3	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: BU_ITM_INV_VW
4	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
5	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
6	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
7	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
8	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
9	TRANSACTION_GROUP	Character(3)	VARCHAR2(3) NOT NULL	11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
10	TRANSACTION_DATE	Date(10)	DATE	Transaction Date
11	QTY_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity
12	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
13	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
14	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
15	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
16	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
17	TRANSACTION_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Transaction Source
18	CONVERSION_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate
19	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
20	EIP_TRANS_SRC	Character(30)	VARCHAR2(30) NOT NULL	08/02/99 NAS: Created the field for MES but it will be owned by Entreprise, they just don't know it yet :-)
21	TRANSACTION_CODE	Character(4)	VARCHAR2(4) NOT NULL	Transaction Code
22	BCT_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Indicates the source where the transaction was created 1=Msg Agent 2=Page 3=Batch 4=Auto Gen 5=Message
23	JOB_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
24	PROCESS_INSTANCE2	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
25	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least Y/N Table Edit Default Value: N
26	SHIP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shipping ID
27	CONSIGNED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Consigned Flag Default Value: N
28	SETID_CUST_ID	Character(30)	VARCHAR2(30) NOT NULL	Concatenated SETID, seperator and CUST_ID
29	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
30	VMI_INVOICE_FLG	Character(1)	VARCHAR2(1) NOT NULL	VMI Invoice Flag I=Invoiced Y=Available To Invoice
31	VMI_BILLING_ORDER	Character(10)	VARCHAR2(10) NOT NULL	VMI Billing Order No.
32	SETID1	Character(5)	VARCHAR2(5) NOT NULL	SetID Value
33	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
34	VMI_ORDER_CONSOL	Character(1)	VARCHAR2(1) NOT NULL	Replenishment Consolidation 1=Sold To Customer 2=Ship To Customer 3=None
35	DEFAULT_PO	Character(25)	VARCHAR2(25) NOT NULL	Customer PO Number
36	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
37	VMI_OM_BU	Character(5)	VARCHAR2(5) NOT NULL	OM Business Unit Related to VMI