OMEC_ORDCHG_FLD

(SQL Table)
Index Back

OMEC Order Change Fields

Contains the list of fields that are eligible to be changed within the sales order change inbound message.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: OMEC_RECFLD_VW

3 PROPAGATE_RULE Character(1) VARCHAR2(1) NOT NULL Rule definitions for propagating data from higher level records to lower level records in sales order change edi message.
D=CP Option Detail
H=CP Option Header
L=Line
S=Schedule
4 ALTERNATE_FLDNAME Character(18) VARCHAR2(18) NOT NULL Alternate field name used by OMEC for propagating field changes to different levels of an order

Prompt Table: OMEC_FLDNAME_VW

5 INVOICE_EDIT Character(1) VARCHAR2(1) NOT NULL Invoice Edit

Y/N Table Edit

Default Value: N

6 PRODKIT_EDIT Character(1) VARCHAR2(1) NOT NULL Configured Kit Edit

Y/N Table Edit

Default Value: N

7 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: N