GS1_UPN_ATT2_EC

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
5 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
6 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
7 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type
8 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number
9 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
10 GS1_PRIMARY_IDNTYP Character(20) VARCHAR2(20) NOT NULL Primary Identifier Type
11 GS1_BASE_UNIT Character(1) VARCHAR2(1) NOT NULL Base Unit

Y/N Table Edit

Default Value: N

12 GS1_GTIN_CHLD_QUOM Character(2) VARCHAR2(2) NOT NULL GTIN Children Quantity UOM
13 GS1_NET_CONT_U_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Net Content Unit Quantity
14 GS1_NET_UNIT_Q_UOM Character(2) VARCHAR2(2) NOT NULL Net Unit Quantity UOM
15 GS1_PARENT_GTIN Character(14) VARCHAR2(14) NOT NULL Parent GTIN
16 GS1_CONSUMER_UNIT Character(1) VARCHAR2(1) NOT NULL Consumer Unit

Y/N Table Edit

Default Value: N

17 GS1_CHILD_GTIN Character(14) VARCHAR2(14) NOT NULL Child GTIN
18 GS1_GTIN_CHILD_QTY Number(6,0) INTEGER NOT NULL GTIN Children Quantity
19 GS1_INVOICE_UNIT Character(1) VARCHAR2(1) NOT NULL Invoice Unit

Y/N Table Edit

Default Value: N

20 GS1_SHIPPING_UNIT Character(1) VARCHAR2(1) NOT NULL Shipping Unit

Y/N Table Edit

Default Value: N

21 GS1_VARIABLE_MEASU Character(1) VARCHAR2(1) NOT NULL Variable Measure

Y/N Table Edit

Default Value: N

22 GS1_ORDERABLE Character(1) VARCHAR2(1) NOT NULL Orderable

Y/N Table Edit

Default Value: N

23 GS1_BAR_CODE_TYPE Character(60) VARCHAR2(60) NOT NULL Bar Code Type
24 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

Default Value: A

25 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag