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 |