CCUTSTVCH_TEO3

(SQL Table)
Index Back

Requisition Line Delivery Schd

Requisition Line Schedule

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
4 REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Requisition Status
A=Approved
C=Complete
I=Initial
O=Open
P=Pending Approval
X=Canceled
5 ACCOUNTING_DT Date(10) DATE Accounting Date
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number
7 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
8 EFFDT Date(10) DATE Effective Date
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt
11 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Currency Code
12 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
14 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
15 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
16 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
17 PYMNT_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determing whether a currency exchange rate is stored
18 PYMNT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determing whether a currency exchange rate is store
19 RVL_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL Revaluation Exchange Rate Mult
20 RVL_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Revaluation Exchange Rate Div
21 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code