IN_EXTFRT_AET(SQL Table) |
Index Back |
|---|---|
Inbound Ext Freight State RecDefault State Record for applying inbound external freight to deliveries |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | ADDTL_ADJUST_AMT | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Adjustment Amount |
| 3 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 4 | APPLICATION_ID | Character(2) | VARCHAR2(2) NOT NULL |
Application ID
AP=Accounts Payable AR=Accounts Receivable EX=Expenses |
| 5 | BCT_FRT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
BCTP Detail Status
0=Open 1=Error 2=Complete 3=Cancel 4=Reprocess |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | BUSINESS_UNIT_LAST | Character(5) | VARCHAR2(5) NOT NULL | Last Business_Unit |
| 8 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
| 9 | CHARGE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Shipping Charge Type
F=Freight M=Misc Chrgs N=Non-stock |
| 10 | CONTAINER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Containers Exist
Default Value: N |
| 11 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL |
Counter
Default Value: 1 |
| 12 | DELIVERY_ID | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 13 | DELIVERY_ID_LAST | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 14 | DEMAND_LINE_NO | Number(4,0) | SMALLINT NOT NULL | Demand Line No |
| 15 | DEMAND_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order |
| 16 | DMD_DLV_LOAD_SRC | Character(2) | VARCHAR2(2) NOT NULL |
Demand
00=Dummy Demand 10=Demand from Run Control 90=Demand not in Run Control |
| 17 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 18 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 19 | EIP_CTL_ID_LAST | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 20 | FLAG1 | Character(1) | VARCHAR2(1) NOT NULL | Flag1 |
| 21 | FLAG2 | Character(1) | VARCHAR2(1) NOT NULL | Flag2 |
| 22 | FLAG3 | Character(1) | VARCHAR2(1) NOT NULL | Flag3 |
| 23 | FREIGHT_APP | Character(2) | VARCHAR2(2) NOT NULL |
Identifier with regards to which product calculated freight for a delivery
IN=Inventory OM=Order Management |
| 24 | FREIGHT_CHARGE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 25 | FREIGHT_CHARGE_BSE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge (base) |
| 26 | FREIGHT_CHARGE_CNV | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge (base) |
| 27 | FRT_CHRG_PRO_IBU | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Prorated freight charge |
| 28 | FRT_ROLLUP_IND_RUN | Character(1) | VARCHAR2(1) NOT NULL |
Indicates to batch run how the freight will be rolled up.
1=Delivery Freight 2=Rollup Packages/Containers 3=Default from Delivery Default Value: 3 |
| 29 | FRT_SRVC_DEFN | Character(50) | VARCHAR2(50) NOT NULL | Freight Service Definition |
| 30 | IN_FRT_P_BILFRT | Character(1) | VARCHAR2(1) NOT NULL |
Commit Billable Freight
Default Value: N |
| 31 | IN_FRT_P_CMPFRT | Character(1) | VARCHAR2(1) NOT NULL |
Freight Complete
Default Value: N |
| 32 | IN_PACKAGE_CNT | Number(20,0) | DECIMAL(20) NOT NULL | Package ID |
| 33 | IN_PACKAGE_ID | Character(20) | VARCHAR2(20) NOT NULL | Package ID |
| 34 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: BU_ITM_INV_VW2 |
| 35 | RECNAME_EDIT | Character(15) | VARCHAR2(15) NOT NULL | Edit Table for Record |
| 36 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 37 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 38 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 39 | MESSAGE_PARM | Character(254) | VARCHAR2(254) NOT NULL | Message Parameter Text |
| 40 | MESSAGE_PARM2 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 2 |
| 41 | MESSAGE_PARM3 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 3 |
| 42 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 43 | 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 |
| 44 | OVERRIDE_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Override Weight |
| 45 | OVERRIDE_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Override Volume |
| 46 | RATE_DATE | Date(10) | DATE | Exchange Rate Date |
| 47 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 48 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 49 | RECNAME_ADDR | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 50 | RECNAME_DEL | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 51 | RECNAME_DMD | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 52 | RECNAME_DRV | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 53 | RECNAME_FRT | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 54 | RECNAME_NOD | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 55 | RECNAME_OMH | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 56 | RECNAME_OML | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 57 | RECNAME_OMS | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 58 | RECNAME_ORD | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 59 | RECNAME_PFT | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 60 | RECNAME_PKG | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 61 | RECNAME_WTV | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 62 | ROUTE_CD | Character(6) | VARCHAR2(6) NOT NULL | A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles. |
| 63 | ROUTE_STOP_NBR | Number(5,0) | INTEGER NOT NULL | An identifier used to sequence customer addresses/location for a given route. |
| 64 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 65 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 66 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 67 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 68 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Source Bus Unit
Prompt Table: SP_BU_FS_NONVW |
| 69 | SHIP_CNTR_ID | Character(20) | VARCHAR2(20) NOT NULL | Shipping Container ID |
| 70 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
| 71 | SHIPPING_QTY | Number(17,4) | DECIMAL(16,4) NOT NULL | Shipping Quantity |
| 72 | SHIPPING_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Volume |
| 73 | SHIPPING_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Weight |
| 74 | TOT_AMT_DEL | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 75 | TOT_AMT_DEL_CNT | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 76 | TOT_AMT_DEL_PKG | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 77 | TOT_AMT_ORD | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 78 | TOT_AMT_ORD_CNT | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 79 | TOT_AMT_ORD_DEL | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 80 | TOT_BSE_DEL | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 81 | TOT_BSE_ORD | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 82 | TOT_PRC_DEL | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 83 | TOT_PRC_ORD | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 84 | TOT_QTY_DEL | Number(17,4) | DECIMAL(16,4) NOT NULL | Shipping Quantity |
| 85 | TOT_QTY_DEL_CNT | Number(17,4) | DECIMAL(16,4) NOT NULL | Shipping Quantity |
| 86 | TOT_QTY_DEL_PKG | Number(17,4) | DECIMAL(16,4) NOT NULL | Shipping Quantity |
| 87 | TOT_QTY_ORD | Number(17,4) | DECIMAL(16,4) NOT NULL | Shipping Quantity |
| 88 | TOT_QTY_ORD_CNT | Number(17,4) | DECIMAL(16,4) NOT NULL | Shipping Quantity |
| 89 | TOT_QTY_ORD_PKG | Number(17,4) | DECIMAL(16,4) NOT NULL | Shipping Quantity |
| 90 | TOT_VOL_DEL | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |
| 91 | TOT_VOL_DEL_CNT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |
| 92 | TOT_VOL_DEL_PKG | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |
| 93 | TOT_VOL_ORD | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |
| 94 | TOT_VOL_ORD_CNT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |
| 95 | TOT_VOL_ORD_PKG | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |
| 96 | TOT_WT_DEL | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 97 | TOT_WT_DEL_CNT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 98 | TOT_WT_DEL_PKG | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 99 | TOT_WT_ORD | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 100 | TOT_WT_ORD_CNT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 101 | TOT_WT_ORD_PKG | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 102 | TOTAL_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |
| 103 | TOTAL_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 104 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL | Volume UOM |
| 105 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
| 106 | UOM_VOLUME | Character(3) | VARCHAR2(3) NOT NULL | Volume UOM |
| 107 | UOM_WEIGHT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
| 108 | TSE_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | TSE Field Name |
| 109 | BEG_SEQ | Character(3) | VARCHAR2(3) NOT NULL | Beginning Sequence |
| 110 | BILL_ONLY | Character(1) | VARCHAR2(1) NOT NULL | Indicates a sales order is to be billed only, and not fulfilled through Inventory. |
| 111 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 112 | CHANGE_STATE | Character(2) | VARCHAR2(2) NOT NULL | Allow Changes Thru |
| 113 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 114 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 115 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 116 | DEL_VALIDATE_OPT | Character(2) | VARCHAR2(2) NOT NULL |
Delivery validation option
10=Validate Only 20=Validate/Assign to New 30=Validate/Auto Assign Open 40=Validate/Auto Assign All 50=Reassign/Consolidate 60=Do Not Validate |
| 117 | DEL_PKG_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Delivery Contains Packages |
| 118 | DELIV_UOM_QTY | Character(3) | VARCHAR2(3) NOT NULL | Delivery Order Qty UOM |
| 119 | DELIVERY_ID2 | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 120 | EXT_NET_PRC_BASE | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Extended Net Price (base) |
| 121 | EXTENDED_NET_PRICE | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Ext Net Amount |
| 122 | FLAG4 | Character(1) | VARCHAR2(1) NOT NULL | Flag4 |
| 123 | FRT_TYPE_CODE | Character(10) | VARCHAR2(10) NOT NULL | Freight Type Code |
| 124 | GROSS_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Weight |
| 125 | IN_BEST_WAY_BTN | Character(2) | VARCHAR2(2) NOT NULL |
Best Way Freight Option
10=Least Cost 20=By Commit Date |
| 126 | IN_FRT_OPTION | Character(2) | VARCHAR2(2) NOT NULL |
Freight Options
10=Shop For Rates 20=Best Way 30=Use Specified Carrier 40=Carrier with Best Way |
| 127 | IN_FRT_P_MANFRT | Character(1) | VARCHAR2(1) NOT NULL |
External Manifest
Default Value: N |
| 128 | IN_FRT_USAGE | Character(2) | VARCHAR2(2) NOT NULL |
Indicator of internal or external freight
10=Internal 20=External 30=None 40=Both |
| 129 | LAST_AUTO_NBR | Number(18,0) | DECIMAL(18) NOT NULL | Last Auto-Assigned Number |
| 130 | LOAD_ITEMS | Character(1) | VARCHAR2(1) NOT NULL |
Load Item tao tables
Default Value: N |
| 131 | LOCK_ACQUIRED | Character(1) | VARCHAR2(1) NOT NULL | Lock Acquired |
| 132 | MAX_FULFILL_STATE | Character(2) | VARCHAR2(2) NOT NULL | Inventory Fulfillment State |
| 133 | MAX_LENGTH | Number(2,0) | SMALLINT NOT NULL | Maximum Length of Auto Number |
| 134 | MIN_FULFILL_STATE | Character(2) | VARCHAR2(2) NOT NULL | Inventory Fulfillment State |
| 135 | NET_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Net Weight |
| 136 | NBR_DEMAND_LINES | Number(4,0) | SMALLINT NOT NULL | Number of Demand Lines |
| 137 | ORDER_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Order Volume |
| 138 | ORDER_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Order Weight |
| 139 | PACKAGE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Packages Exist
Default Value: N |
| 140 | PACKING_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Packing Volume |
| 141 | PACKING_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Packing Weight |
| 142 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 143 | PROCESS_INSTANCE2 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 144 | PROC_FREIGHT | Character(2) | VARCHAR2(2) NOT NULL |
Process Freight Charges
MN=Manual NO=None OL=Online Default Value: NO |
| 145 | QTY_TOTAL | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Quantity Total |
| 146 | RESEND_FRT_RQST | Character(1) | VARCHAR2(1) NOT NULL |
02/02/09 EGS: Created
Default Value: N |
| 147 | RUN_FREIGHT | Character(1) | VARCHAR2(1) NOT NULL | Perform Freight |
| 148 | SCHED_SHIP_DATE | Date(10) | DATE | Scheduled Ship Date |
| 149 | SEARCH_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Source
Default Value: N |
| 150 | SELECTTYPE | Number(1,0) | SMALLINT NOT NULL | Selection Type |
| 151 | SQL_TEXT_LONG | Long Character(4000) | CLOB | Dynamic SQL string |
| 152 | TOT_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Quantity |
| 153 | UNIT_MEASURE_SHIP | Character(3) | VARCHAR2(3) NOT NULL | Shipment Unit of Measure |