PO_ITM_STG_HDR

(SQL Table)
Index Back

# 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 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
6 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
7 PO_STG_ID Character(10) VARCHAR2(10) NOT NULL Uniqye key to the PO Staging table
8 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
9 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
10 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
13 DECIMAL_POS_BSE Number(2,0) SMALLINT NOT NULL Base Cur Decimal Positions
14 DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions
15 PO_BUILD_CD Character(1) VARCHAR2(1) NOT NULL PO Build Code
16 PO_DT Date(10) DATE Date
17 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
18 RATE_DATE Date(10) DATE Exchange Rate Date
19 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
20 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
21 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.