IN_USG_UOM_AET(SQL Table) |
Index Back |
|---|---|
State table for usage desktop |
| # | 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 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 5 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 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 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 8 | QTY_PRECISION | Character(1) | VARCHAR2(1) NOT NULL |
Quantity Precision
D=Decimal W=Whole Nbr |
| 9 | ROUND_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Rounding Rule
D=Round Down N=Natural Round U=Round Up |
| 10 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 11 | QUANTITY_PRECISION | Character(1) | VARCHAR2(1) NOT NULL | QUANTITY PRECISION |
| 12 | ROUND_RULE_STCK | Character(1) | VARCHAR2(1) NOT NULL |
Rounding Rule
N=Natural Round U=Round Up |
| 13 | 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 |
| 14 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 15 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 16 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 17 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 18 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 19 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 20 | RECV_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Receipt Status
C=Closed Receipt H=Hold Receipt M=Moved to Destination N=PO Not Received O=Open P=PO Partially Received R=Fully Received X=Canceled |
| 21 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 22 | SOURCE_ID | Character(25) | VARCHAR2(25) NOT NULL | Source Key ID |
| 23 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |