PO_CUM_SRC_TMP

(SQL Table)
Index Back

Staging Tbl for PO Batch Load

# 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
3 PO_STG_TYPE Character(1) VARCHAR2(1) NOT NULL Used in conjunction with PO_STG_ID to make a unique key on the stage tables.
O=Other
R=Requisition

Default Value: O

4 PO_STG_ID Character(10) VARCHAR2(10) NOT NULL Uniqye key to the PO Staging table
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
7 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

Prompt Table: ITM_CAT_VW

8 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
9 CURRENCY_CD_CAT Character(3) VARCHAR2(3) NOT NULL Category Currency Code
10 DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions
11 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: ITM_ITMSETID_VW

12 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
13 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
14 MERCH_AMT_CAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Category Currency Merch Amt
15 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
16 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
17 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIPTO_TBL

18 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID