IN_VMIBILL_AET

(SQL Table)
Index Back

Inventory VMI Billing Only

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
5 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 FROM_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL From Business Unit

Prompt Table: SP_BUVM_NONVW

8 TO_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit selection field

Prompt Table: SP_BUVM_NONVW

9 ALL_BU_SW Character(1) VARCHAR2(1) NOT NULL All Business Units
10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
11 ALL_BU Character(1) VARCHAR2(1) NOT NULL All Business Units
N=Specific Business Unit
Y=All Business Units

Y/N Table Edit

Default Value: N

12 SELECT_CUST Character(1) VARCHAR2(1) NOT NULL Select Customer
H=Select Ship to Cust range
O=Select Sold to Cust range
13 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: VMI_CUSTSLD2_VW

14 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
15 SETID_CUST_ID Character(30) VARCHAR2(30) NOT NULL Concatenated SETID, seperator and CUST_ID
16 TO_SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: VMI_CUSTSLD2_VW

17 SL_SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer selection

Prompt Table: VMI_CUSTSHP2_VW

18 TO_SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: VMI_CUSTSHP2_VW

19 FR_ITEM_ID Character(18) VARCHAR2(18) NOT NULL From Item ID

Prompt Table: IN_VMI_ITEMS_VW

20 SETID1 Character(5) VARCHAR2(5) NOT NULL SetID Value
21 TO_ITEM_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 SCC (Internet Architecture): Add label ITEM_ID

Prompt Table: IN_VMI_ITEMS_VW

22 PROCESS_INSTANCE2 Number(10,0) DECIMAL(10) NOT NULL Process Instance
23 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
24 DTTM_STAMP_SEC 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.
25 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
26 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
27 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
28 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
29 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause
30 WHERE_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Where Clause
31 WHERE_CLAUSE3 Character(254) VARCHAR2(254) NOT NULL Where Clause
32 WHERE_OPER Character(12) VARCHAR2(12) NOT NULL Operator
33 VMI_OM_BU Character(5) VARCHAR2(5) NOT NULL OM Business Unit Related to VMI
34 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause
35 VMI_ORDER_CONSOL Character(1) VARCHAR2(1) NOT NULL Replenishment Consolidation
1=Sold To Customer
2=Ship To Customer
3=None
36 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
37 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
38 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
39 DUMMY_FIELD Character(1) VARCHAR2(1) NOT NULL Dummy Field for Hiding Groups
40 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
41 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
42 CURRENT_ROW Number(10,0) DECIMAL(10) NOT NULL Current Row
43 LONGNAME1 Character(30) VARCHAR2(30) NOT NULL Field Long Name
44 LONGNAME2 Character(30) VARCHAR2(30) NOT NULL Field Long Name
45 TRANSACTION_DATE Date(10) DATE Transaction Date