OMEC_ORDCHG_FLD(SQL Table) |
Index Back |
---|---|
OMEC Order Change FieldsContains 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 |