BUSINESS_UNITPrompt Table: SP_BUIN_NONVW
IN_FRT_SHP_RSLT(SQL View) |
Index Back |
|---|---|
External Freight Results |
| SELECT ' ' , ' ' , 0 , ' ' , ' ' ,0 , ' ' ,' ' ,' ' FROM PS_IN_DEMAND WHERE IN_FULFILL_STATE >= '50' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUIN_NONVW |
| 2 | DELIVERY_ID | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 3 | FREIGHT_AMT_TOT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 4 | PRO_NUMBER | Character(40) | VARCHAR2(40) NOT NULL | Pro Number |
| 5 | ESTIMATE | Character(1) | VARCHAR2(1) NOT NULL | Freight Estimate |
| 6 | SHIPPING_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Weight |
| 7 | SERVICE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Service Name |
| 8 | ERROR_CODE | Character(10) | VARCHAR2(10) NOT NULL | Error Code |
| 9 | ERROR_MESSAGE | Character(254) | VARCHAR2(254) NOT NULL | For Standard Journal (SJE) |