CCU_TST_VCH_TBL

(SQL Table)
Index Back

Requisition Line Delivery Schd

Requisition Line Schedule

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