IN_RUN_VMIBILL

(SQL Table)
Index Back

Inventory VMI Billing Only

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 FROM_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL From Business Unit

Prompt Table: SP_BUVM_NONVW

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

Prompt Table: SP_BUVM_NONVW

7 ALL_BU_SW Character(1) VARCHAR2(1) NOT NULL All Business Units
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: OM_BU_NONVW

9 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

10 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: VMI_CUSTSLD3_VW
Set Control Field: BUSINESS_UNIT

11 TO_SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: VMI_CUSTSLD3_VW
Set Control Field: BUSINESS_UNIT

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

Prompt Table: VMI_CUSTSHP4_VW
Set Control Field: BUSINESS_UNIT

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

Prompt Table: VMI_CUSTSHP4_VW
Set Control Field: BUSINESS_UNIT

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

Prompt Table: BU_ITM_INV2_VW

15 TO_ITEM_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 SCC (Internet Architecture): Add label ITEM_ID

Prompt Table: BU_ITM_INV2_VW

16 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

17 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
18 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.
19 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
20 SELECT_CUST Character(1) VARCHAR2(1) NOT NULL Select Customer
H=Select Ship to Cust range
O=Select Sold to Cust range