IN_C_IT_UOM_EVW

(SQL View)
 Index Back

CRM Unit of Measure Publish

This view is Used by the Batch Publish section of the AE Program IN_ITMLOAD to publish the Item Changes/Adds to other Nodes.

SELECT A.SETID , A.INV_ITEM_ID , A.UNIT_OF_MEASURE , %subrec(IN_C_ITMUOM_ESR, A) , D.AUDIT_ACTN , D.IN_PROCESS_FLG , E.PROCESS_INSTANCE FROM PS_INV_ITEM_UOM A , PS_INV_ITM_UOM_EC D , PS_EO_EIP_CTL E , PS_MASTER_ITEM_TBL I WHERE A.SETID = D.SETID AND A.INV_ITEM_ID = D.INV_ITEM_ID AND A.UNIT_OF_MEASURE = D.UNIT_OF_MEASURE AND D.EIP_CTL_ID = E.EIP_CTL_ID AND E.EIP_DTA_STATUS = '2' AND I.SETID = A.SETID AND I.INV_ITEM_ID = A.INV_ITEM_ID AND I.ITM_STATUS_CURRENT IN ('1','2','3','4')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MST_ITM_PRPT_VW

3 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: UNITS_TBL

4 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
5 QTY_PRECISION Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal
W=Whole Nbr

Default Value: W

6 ROUND_RULE Character(1) VARCHAR2(1) NOT NULL Rounding Rule
D=Round Down
N=Natural Round
U=Round Up

Default Value: N

7 DFLT_UOM_STOCK Character(1) VARCHAR2(1) NOT NULL Default Stocking UOM

Y/N Table Edit

Default Value: N

8 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
9 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
10 PACKING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Weight
11 PACKING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Volume
12 SHIPPING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight
13 SHIPPING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Volume
14 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM

Prompt Table: UNITS_WT_VW

15 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM

Prompt Table: UNITS_VOL_VW

16 PACKING_CD Character(4) VARCHAR2(4) NOT NULL Packing Code

Prompt Table: PACK_CODE_INV

17 PACKAGING_CD Character(4) VARCHAR2(4) NOT NULL Packaging Code

Prompt Table: PACKAGNG_CD_INV

18 CONTAINER_TYPE Character(4) VARCHAR2(4) NOT NULL Container Type

Prompt Table: CNTR_TYPE_INV

19 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
20 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
21 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance