ITM_CAP_GRP_RNG

(SQL Table)
Index Back

Capacity by group/item

08/01/02 SCC CN#WV880-1.0: Supplier Collaboration

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 SCHED_GROUP_CD Character(6) VARCHAR2(6) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Prompt Table: SP_SETID_NONVW

4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VNDR_VNDSET_VW

5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VNDR_LOC_VW1

6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: ITM_VENDOR_VW

7 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Prompt Table: SETID_INVBU_VW

8 FROM_DT Date(10) DATE From Date
9 TO_DT Date(10) DATE To Date
10 QTY_MAX Number(16,4) DECIMAL(15,4) NOT NULL Maximum Quantity