IN_DEL_LBR_AET(SQL Table) |
Index Back |
|---|---|
IN Delivery State RecordDefault State Record for Delivery Library Processing |
| # | 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 | AMOUNT_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
10/29/08 EGS: Created
1=Override 2=Increment |
| 5 | APPLICATION_ID | Character(2) | VARCHAR2(2) NOT NULL |
Application ID
AP=Accounts Payable AR=Accounts Receivable EX=Expenses |
| 6 | 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. " |
| 7 | BEG_SEQ | Character(3) | VARCHAR2(3) NOT NULL | Beginning Sequence |
| 8 | BILLING_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Billing Status
A=Available B=In Billing C=Contract I=Invoiced N=Not Avail P=In Process S=Staged |
| 9 | BILL_ONLY | Character(1) | VARCHAR2(1) NOT NULL | Indicates a sales order is to be billed only, and not fulfilled through Inventory. |
| 10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 11 | BUSINESS_UNIT_LAST | Character(5) | VARCHAR2(5) NOT NULL | Last Business_Unit |
| 12 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
| 13 | CHANGE_STATE | Character(2) | VARCHAR2(2) NOT NULL | Allow Changes Thru |
| 14 | CHARGE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Shipping Charge Type
F=Freight M=Misc Chrgs N=Non-stock |
| 15 | CONTAINER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Containers Exist
Default Value: N |
| 16 | CONTAINER_LOADED | Character(1) | VARCHAR2(1) NOT NULL |
Containers Previously Loaded
Default Value: N |
| 17 | CONTAINER_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Picking from Containers
Default Value: N |
| 18 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 19 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL |
Counter
Default Value: 1 |
| 20 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 21 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 22 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 23 | 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 |
| 24 | DEL_PKG_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Delivery Contains Packages |
| 25 | DELIV_UOM_QTY | Character(3) | VARCHAR2(3) NOT NULL | Delivery Order Qty UOM |
| 26 | DELIV_WORK_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Delivery Working Quantity |
| 27 | DELIVERY_ID | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 28 | DELIVERY_ID_LAST | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 29 | DELIVERY_ID2 | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 30 | DELIVERY_ID_OVRD | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 31 | DEMAND_LINE_NO | Number(4,0) | SMALLINT NOT NULL | Demand Line No |
| 32 | 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 |
| 33 | 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 |
| 34 | EXT_NET_PRC_BASE | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Extended Net Price (base) |
| 35 | EXTENDED_NET_PRICE | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Ext Net Amount |
| 36 | FLAG1 | Character(1) | VARCHAR2(1) NOT NULL | Flag1 |
| 37 | FLAG2 | Character(1) | VARCHAR2(1) NOT NULL | Flag2 |
| 38 | FLAG3 | Character(1) | VARCHAR2(1) NOT NULL | Flag3 |
| 39 | FLAG4 | Character(1) | VARCHAR2(1) NOT NULL | Flag4 |
| 40 | FREIGHT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 41 | FREIGHT_AMT_OVRD | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 42 | FREIGHT_APP | Character(2) | VARCHAR2(2) NOT NULL |
Identifier with regards to which product calculated freight for a delivery
IN=Inventory OM=Order Management |
| 43 | FREIGHT_CHARGE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 44 | FREIGHT_CHARGE_BSE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge (base) |
| 45 | FREIGHT_CHARGE_CNV | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge (base) |
| 46 | FREIGHT_CHG_BL | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 47 | FREIGHT_CHG_BL_BSE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 48 | FREIGHT_CHG_DO | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 49 | FREIGHT_CHG_DO_BSE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 50 | FREIGHT_CHG_SC | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 51 | FREIGHT_CHG_SC_BSE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 52 | FREIGHT_TAX_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Freight Tax Amount |
| 53 | FREIGHT_TAX_DO_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Freight Tax Amount |
| 54 | FREIGHT_TAX_SC_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Freight Tax Amount |
| 55 | FREIGHT_TAX_BASE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Freight Tax Amount Base |
| 56 | FREIGHT_TAX_DO_BSE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Freight Tax Amount Base |
| 57 | FREIGHT_TAX_SC_BSE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Freight Tax Amount Base |
| 58 | FREIGHT_TAX_PCT | Number(7,4) | DECIMAL(6,4) NOT NULL | Freight Tax Percent |
| 59 | FRT_CHRG_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Freight Charge Override
Default Value: N |
| 60 | FRT_CHRG_PRO_IBU | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Prorated freight charge |
| 61 | 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 |
| 62 | FRT_TYPE_CODE | Character(10) | VARCHAR2(10) NOT NULL | Freight Type Code |
| 63 | GROSS_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Weight |
| 64 | IN_BEST_WAY_BTN | Character(2) | VARCHAR2(2) NOT NULL |
Best Way Freight Option
10=Least Cost 20=By Commit Date |
| 65 | 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 |
| 66 | IN_FRT_P_BILFRT | Character(1) | VARCHAR2(1) NOT NULL |
Commit Billable Freight
Default Value: N |
| 67 | IN_FRT_P_CMPFRT | Character(1) | VARCHAR2(1) NOT NULL |
Freight Complete
Default Value: N |
| 68 | IN_FRT_P_MANFRT | Character(1) | VARCHAR2(1) NOT NULL |
External Manifest
Default Value: N |
| 69 | IN_FRT_USAGE | Character(2) | VARCHAR2(2) NOT NULL |
Indicator of internal or external freight
10=Internal 20=External 30=None 40=Both |
| 70 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: BU_ITM_INV_VW2 |
| 71 | LAST_AUTO_NBR | Number(18,0) | DECIMAL(18) NOT NULL | Last Auto-Assigned Number |
| 72 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 73 | LOAD_ITEMS | Character(1) | VARCHAR2(1) NOT NULL |
Load Item tao tables
Default Value: N |
| 74 | LOCK_ACQUIRED | Character(1) | VARCHAR2(1) NOT NULL | Lock Acquired |
| 75 | MAX_FULFILL_STATE | Character(2) | VARCHAR2(2) NOT NULL | Inventory Fulfillment State |
| 76 | MAX_LENGTH | Number(2,0) | SMALLINT NOT NULL | Maximum Length of Auto Number |
| 77 | MIN_FULFILL_STATE | Character(2) | VARCHAR2(2) NOT NULL | Inventory Fulfillment State |
| 78 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 79 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 80 | MESSAGE_PARM | Character(254) | VARCHAR2(254) NOT NULL | Message Parameter Text |
| 81 | MSGNUM | Number(5,0) | INTEGER NOT NULL | Message Number |
| 82 | MSGPARM1 | Character(30) | VARCHAR2(30) NOT NULL | Message Parm 1 |
| 83 | MSGPARM2 | Character(30) | VARCHAR2(30) NOT NULL | Message Parm 2 |
| 84 | MSGPARM3 | Character(30) | VARCHAR2(30) NOT NULL | Message Parm 3 |
| 85 | MSGPARM4 | Character(30) | VARCHAR2(30) NOT NULL | Message Parm 4 |
| 86 | MSGPARM5 | Character(30) | VARCHAR2(30) NOT NULL | Message Parm 5 |
| 87 | MSGSET | Number(5,0) | INTEGER NOT NULL | Message Set Number |
| 88 | NET_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Net Weight |
| 89 | NBR_DEMAND_LINES | Number(4,0) | SMALLINT NOT NULL | Number of Demand Lines |
| 90 | ORDERING_QTY | Signed Number(18,4) | DECIMAL(16,4) NOT NULL | Ordering Quantity |
| 91 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 92 | 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 |
| 93 | ORDER_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Order Volume |
| 94 | ORDER_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Order Weight |
| 95 | PACKAGE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Packages Exist
Default Value: N |
| 96 | PACKING_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Packing Volume |
| 97 | PACKING_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Packing Weight |
| 98 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 99 | PROCESS_INSTANCE2 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 100 | PROC_FREIGHT | Character(2) | VARCHAR2(2) NOT NULL |
Process Freight Charges
MN=Manual NO=None OL=Online Default Value: NO |
| 101 | QTY_TOTAL | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Quantity Total |
| 102 | RATE_DATE | Date(10) | DATE | Exchange Rate Date |
| 103 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 104 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 105 | RECNAME_ADDR | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 106 | RECNAME_DEL | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 107 | RECNAME_DMD | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 108 | RECNAME_DRV | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 109 | RECNAME_FRT | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 110 | RECNAME_NOD | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 111 | RECNAME_OMH | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 112 | RECNAME_OML | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 113 | RECNAME_OMS | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 114 | RECNAME_ORD | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 115 | RECNAME_PFT | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 116 | RECNAME_PKG | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 117 | RECNAME_WTV | Character(15) | VARCHAR2(15) NOT NULL | Recname |
| 118 | RESEND_FRT_RQST | Character(1) | VARCHAR2(1) NOT NULL |
02/02/09 EGS: Created
Default Value: N |
| 119 | RESEND_FRT_RECV | Character(1) | VARCHAR2(1) NOT NULL |
02/02/09 EGS: Created
Default Value: N |
| 120 | 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. |
| 121 | RUN_FREIGHT | Character(1) | VARCHAR2(1) NOT NULL | Perform Freight |
| 122 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 123 | SCHED_SHIP_DATE | Date(10) | DATE | Scheduled Ship Date |
| 124 | SEARCH_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Source
Default Value: N |
| 125 | SELECTTYPE | Number(1,0) | SMALLINT NOT NULL | Selection Type |
| 126 | SETID_SOURCE_CD | Character(5) | VARCHAR2(5) NOT NULL | Source Code SetId |
| 127 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 128 | SHIP_CNTR_ID | Character(20) | VARCHAR2(20) NOT NULL | Shipping Container ID |
| 129 | SHIP_CNTR_ID_OVRD | Character(20) | VARCHAR2(20) NOT NULL | Shipping Container ID |
| 130 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shipping ID |
| 131 | SHIPPING_QTY | Number(17,4) | DECIMAL(16,4) NOT NULL | Shipping Quantity |
| 132 | SHIPPING_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Volume |
| 133 | SHIPPING_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Weight |
| 134 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Source Bus Unit
Prompt Table: SP_BU_FS_NONVW |
| 135 | SQL_TEXT_LONG | Long Character(4000) | CLOB | Dynamic SQL string |
| 136 | SRC_CD_EXCLUSIONS | Character(1) | VARCHAR2(1) NOT NULL |
Exclusions
A=Price Adjustments F=Freight T=Tax V=VAT |
| 137 | TOT_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Quantity |
| 138 | TOT_AMT_DEL | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 139 | TOT_AMT_DEL_CNT | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 140 | TOT_AMT_DEL_PKG | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 141 | TOT_AMT_ORD | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 142 | TOT_AMT_ORD_CNT | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 143 | TOT_AMT_ORD_DEL | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 144 | TOT_BSE_DEL | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 145 | TOT_BSE_ORD | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 146 | TOT_PRC_DEL | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 147 | TOT_PRC_ORD | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Amount |
| 148 | TOT_QTY_DEL | Number(17,4) | DECIMAL(16,4) NOT NULL | Shipping Quantity |
| 149 | TOT_QTY_DEL_CNT | Number(17,4) | DECIMAL(16,4) NOT NULL | Shipping Quantity |
| 150 | TOT_QTY_DEL_PKG | Number(17,4) | DECIMAL(16,4) NOT NULL | Shipping Quantity |
| 151 | TOT_QTY_ORD | Number(17,4) | DECIMAL(16,4) NOT NULL | Shipping Quantity |
| 152 | TOT_QTY_ORD_CNT | Number(17,4) | DECIMAL(16,4) NOT NULL | Shipping Quantity |
| 153 | TOT_QTY_ORD_PKG | Number(17,4) | DECIMAL(16,4) NOT NULL | Shipping Quantity |
| 154 | TOT_VOL_DEL | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |
| 155 | TOT_VOL_DEL_CNT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |
| 156 | TOT_VOL_DEL_PKG | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |
| 157 | TOT_VOL_ORD | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |
| 158 | TOT_VOL_ORD_CNT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |
| 159 | TOT_VOL_ORD_PKG | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |
| 160 | TOT_WT_DEL | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 161 | TOT_WT_DEL_CNT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 162 | TOT_WT_DEL_PKG | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 163 | TOT_WT_ORD | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 164 | TOT_WT_ORD_CNT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 165 | TOT_WT_ORD_PKG | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 166 | TOTAL_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |
| 167 | TOTAL_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 168 | UNIT_MEASURE_SHIP | Character(3) | VARCHAR2(3) NOT NULL | Shipment Unit of Measure |
| 169 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL | Volume UOM |
| 170 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
| 171 | UOM_VOLUME | Character(3) | VARCHAR2(3) NOT NULL | Volume UOM |
| 172 | UOM_WEIGHT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
| 173 | COUNTER_PREV | Number(10,0) | DECIMAL(10) NOT NULL | Previous value of counter |