PROCESS_INSTANCEBUSINESS_UNITORDER_NODELIVERY_IDMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
OM_ORD_UOM_TAO(SQL Table) |
Index Back |
|---|---|
Ordering UOM to standard UOMThis is used to get the ordering unit of measure and get the conversion rate for the order UOM to standard UOM. Then calculate the total quantity per BU, Order no., Ship ID. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | ORDER_NO |
Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 4 | DELIVERY_ID |
Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 5 | SETID_INV_ITEM | Character(5) | VARCHAR2(5) NOT NULL | Inv Items SETID |
| 6 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 7 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 8 | TOT_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Quantity |