PO_PREPOST_WK3

(SQL Table)
Index Back

PO Pre-Post Work 3

# 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_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
6 ADJ_TYPE Character(4) VARCHAR2(4) NOT NULL Adjustment Type
BAS=Base
CNT=Contract
FRT=Freight
OTH=Other
TAX=Tax
TBL=Table
7 ADJ_AMT Signed Number(17,5) DECIMAL(15,5) NOT NULL Adjustment Amount
8 PO_SCHED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL PO Schedule Merchandise Amt
9 PO_FRT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL PO Freight Amount
10 PO_FRT_ALLOC Signed Number(28,3) DECIMAL(26,3) NOT NULL PO Freight Allocated
11 PO_FRT_RND Signed Number(9,2) DECIMAL(7,2) NOT NULL PO Freight Rounding Amount
12 PO_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL PO Tax Amount
13 PO_TAX_ALLOC Signed Number(28,3) DECIMAL(26,3) NOT NULL PO Tax Allocated
14 PO_TAX_RND Signed Number(9,2) DECIMAL(7,2) NOT NULL PO Tax Rounding Amount