PROCESS_INSTANCEBUSINESS_UNITORDER_NOTRFT_SET_IDOM_TRFT_CLC_TAO(SQL Table) |
Index Back |
|---|---|
Sales order entry freight viewUsed to calculate sales order freight charges. |
| # | 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 | TRFT_SET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Rule Cd |
| 5 | TOT_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Quantity |
| 6 | TOT_NET | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Net Price |
| 7 | TOTAL_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 8 | TOTAL_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |