OBJECTOWNERIDSETID_BU_DRIVENB=Business Unit Driven
S=Setid Driven
Default Value: B
RECNAMEPrompt Table: IN_RECNAME_VW
ITEM_FIELDNAMEDefault Value: INV_ITEM_ID
Prompt Table: RECFIELD_VW
QTY_FIELDNAMEPrompt Table: RECFIELD_VW
UOM_FIELDNAMEIN_PRCSN_RECS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OBJECTOWNERID |
Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 2 | SETID_BU_DRIVEN |
Character(1) | VARCHAR2(1) NOT NULL |
Setid or BU Driven
B=Business Unit Driven S=Setid Driven Default Value: B |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: IN_RECNAME_VW |
| 4 | ITEM_FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID Fieldname
Default Value: INV_ITEM_ID Prompt Table: RECFIELD_VW |
| 5 | QTY_FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Quantity Field Name
Prompt Table: RECFIELD_VW |
| 6 | UOM_FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Unit of Measure Field Name |