PO_LN_SHP_MC_WK

(SQL Table)
Index Back

PO Schedule Misc. Work Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
5 MISC_CHARGE_SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement

Prompt Table: CM_LC_COMPONENT

7 MISC_CHARGE_ORIGN Character(1) VARCHAR2(1) NOT NULL Misc Charge Origin
A=Allocated
C=Calculated
M=Entered
8 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
10 CHARGE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
13 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
14 INV_ITEM_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Weight
15 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
16 INV_ITEM_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Volume
17 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM
18 LC_COMP_FLAG Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement

Y/N Table Edit

19 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
20 LC_COMP_CALC Character(3) VARCHAR2(3) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
FL=Flat Amt
FR=Free
FRT=Freight
STX=Sales Tax
UNT=Unit Amt
UTX=Use Tax
VAL=% Value
VAT=VAT
VOL=Volume
WT=Weight
21 LC_COMP_ALLOC Character(3) VARCHAR2(3) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
MAT=Matl Value
QTY=Quantity
VOL=Volume
WT=Weight
22 LC_COMP_ON_PO Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement Indicates whether this Landed cost component is typically included on the Purchase order to the merchandise supplier

Y/N Table Edit

23 X_VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Supplier Set ID
24 X_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Third Party Supplier

Prompt Table: VENDOR_PO_VW

25 X_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Third Party Supplier Location

Prompt Table: VNDR_LOC_VW1

26 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
27 FLAT_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
28 PCT_VALUE Signed Number(9,2) DECIMAL(7,2) NOT NULL Percentage of Value
29 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
30 LC_RTV_CREDIT Character(1) VARCHAR2(1) NOT NULL Return to Vendor for Credit

Y/N Table Edit

Default Value: N

31 LC_ACCRUAL_FLAG Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement. Indicates whether this landed cost component is typically accrued upon receipt (i.e., included in inventory value) or whether it is expensed.