| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 2 |
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
|
| 3 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
Prompt Table:
SP_BU_FS_NONVW
|
| 4 |
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
|
| 5 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 6 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 7 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
BU_ITM_INV_VW2
|
| 8 |
DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
|
| 9 |
AUTO_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Number Type
|
| 10 |
IN_FULFILL_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Inventory Fulfillment State
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Confirmed
60=Shipped
70=Depleted
90=Canceled
|
| 11 |
IN_PRIOR_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Inventory Fulfillment State at the time the demand line was cancelled
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Picking Confirmed
60=Shipped
70=Depleted
90=Canceled
|
| 12 |
DEMAND_DATE |
Date(10) |
DATE |
Demand Date
|
| 13 |
REQUEST_DATE |
Date(10) |
DATE |
Requested
|
| 14 |
CANCEL_DTTM |
DateTime(26) |
TIMESTAMP |
Dttm demand line was canceled
|
| 15 |
FULFILLMENT_DTTM |
DateTime(26) |
TIMESTAMP |
Fulfillment Datetime
|
| 16 |
SCHED_DTTM |
DateTime(26) |
TIMESTAMP |
08/16/01 JNW (CN#PL900-1.0): Added
|
| 17 |
ORIG_SCHED_DTTM |
DateTime(26) |
TIMESTAMP |
Original Schedule Date/Time
|
| 18 |
PICK_DTTM |
DateTime(26) |
TIMESTAMP |
Picked Date/Time
|
| 19 |
PICK_CONFIRM_DTTM |
DateTime(26) |
TIMESTAMP |
Pick Confirm Date/Time
|
| 20 |
ORIG_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Original Business Unit
|
| 21 |
DESTIN_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Destination Unit
|
| 22 |
TRANSFER_YIELD |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Transfer Yield
|
| 23 |
DATE_LAST_MAINT |
Date(10) |
DATE |
Date Last Maintained
|
| 24 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 25 |
LOAD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Load ID
Prompt Table:
LOAD_INV
|
| 26 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table:
CARRIER_ID
|
| 27 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
SHIP_METHOD
|
| 28 |
SHIP_EARLY_DTTM |
DateTime(26) |
TIMESTAMP |
Earliest Ship Date/Time
|
| 29 |
SHIP_LATE_DTTM |
DateTime(26) |
TIMESTAMP |
Latest Ship Date/Time
|
| 30 |
SCHED_ARRV_DTTM |
DateTime(26) |
TIMESTAMP |
Schedule Arrival Dt/Tm
|
| 31 |
STOCK_DTTM |
DateTime(26) |
TIMESTAMP |
Stock Date/Time
|
| 32 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table:
FREIGHT_TERMS
|
| 33 |
PRIORITY_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 34 |
DISTRIB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Distrib. Type
Prompt Table:
CM_DISTR_TYPE
|
| 35 |
PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID
|
| 36 |
PICKLIST_LINE_NO |
Number(7,0) |
INTEGER NOT NULL |
Pick List Sorting Line Number
|
| 37 |
IN_ZERO_PICKED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Picked
Default Value: N
|
| 38 |
RELEASE_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
08/2004 rcw: Order Release Instance
|
| 39 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
|
| 40 |
REQ_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Requisition Line Number
|
| 41 |
REQ_SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Requisition Schedule Number
|
| 42 |
REQ_DISTRIB_NBR |
Number(5,0) |
INTEGER NOT NULL |
Requisition Distrib Number
|
| 43 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 44 |
PARENT_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Parent Product Id
|
| 45 |
KIT_LINE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Kit Line Number
|
| 46 |
QTY_PER |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Quantity
|
| 47 |
QTY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Per
ASY=Assembly
ORD=Order
|
| 48 |
OPTIONAL_SHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
OK to Ship Without
|
| 49 |
DP_KIT_PARENT_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Demand Planning Kit Parent Qty
|
| 50 |
DP_KIT_PARENT_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
DP Kit Parent Unit of Measure
|
| 51 |
CHARGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Charged Out
Y/N Table Edit
Default Value: N
|
| 52 |
IN_KIT_PROTECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Kit protected flag
Y/N Table Edit
Default Value: N
|
| 53 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
|
| 54 |
FERC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
FERC Code
Prompt Table:
FERC_CD_TBL
|
| 55 |
INTERUNIT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
InterUnit Order ID
|
| 56 |
INTERUNIT_LINE |
Number(5,0) |
INTEGER NOT NULL |
InterUnit Order Line
|
| 57 |
INTERUNIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 58 |
INTERUNIT_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit Status
C=Cancelled
I=In-Transit
O=Open
P=Picked
R=Received
Default Value: O
|
| 59 |
INTERUNIT_INSERT |
Character(1) |
VARCHAR2(1) NOT NULL |
Interunit Insert
Y/N Table Edit
Default Value: N
|
| 60 |
INV_ITEM_ALIAS |
Character(18) |
VARCHAR2(18) NOT NULL |
Item Alias
|
| 61 |
PRICE_MARKUP_PCT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Price Markup %
|
| 62 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_SBU_VW
|
| 63 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
|
| 64 |
CUST_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Name
|
| 65 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 66 |
SHIP_CUST_NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Ship To Name
|
| 67 |
SHIP_CUST_NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Ship To Name 2
|
| 68 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 69 |
CNTCT_SEQ_SHIP |
Number(5,0) |
INTEGER NOT NULL |
Primary Contact - Ship To
|
| 70 |
ADDR_OVRD_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule
|
| 71 |
TAX_EXEMPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit
Default Value: Y
|
| 72 |
EXP_RETURN_DATE |
Date(10) |
DATE |
Return Date
|
| 73 |
ORIG_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
User ID
|
| 74 |
TRANSFER_COST |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Transfer Price
|
| 75 |
PACKAGING_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Packaging Code
Prompt Table:
PACKAGNG_CD_INV
|
| 76 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 77 |
QTY_REQUESTED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Requested
|
| 78 |
QTY_REQUESTED_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Requested Base
|
| 79 |
QTY_PROMISED_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Promised Base
|
| 80 |
QTY_ALLOCATED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Allocated quantity
|
| 81 |
QTY_ALLOC_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity allocation
|
| 82 |
QTY_BACKORDER |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Backorder Qty
|
| 83 |
QTY_BACKORDER_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Backorder Base Qty
|
| 84 |
QTY_PICKED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Picked
|
| 85 |
QTY_PICK_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Pick Base
|
| 86 |
QTY_PICK_OVRIDE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Field used to override the net requested quantity when printing the pick play for non-soft reservation items.
|
| 87 |
QTY_PICK_OVR_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Field used to override the net requested quantity in standard uom when printing the pick play for non-soft reservation items.
|
| 88 |
QTY_PACK_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Base Quantity Packed
|
| 89 |
QTY_SHIPPED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Shipped
|
| 90 |
QTY_SHIP_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Ship Base
|
| 91 |
QTY_SHIPPED_CONV |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Shipped
|
| 92 |
LAST_QTY_SHIP |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Last Shipped
|
| 93 |
LAST_QTY_SHIP_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Used to save the last value of quantity shipped from the Shipping Issues Panel in Standard UOM at the DEMAND_PHYS_INV and SHIP_INF_INV level. Default to the quantity picked from the Express Issues Panel or for cases where auto ship equals 'Y'.
|
| 94 |
FULFILL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
OK to Pick
Y/N Table Edit
Default Value: N
|
| 95 |
PICKLIST_PRINTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Picklist Printed
Y/N Table Edit
Default Value: N
|
| 96 |
CONFIRMED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirm
Y/N Table Edit
Default Value: N
|
| 97 |
SHIPPED_MESSAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Shipped Message
Y/N Table Edit
Default Value: N
|
| 98 |
QTY_VERIFY_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Verify Qty
Y/N Table Edit
Default Value: N
|
| 99 |
APPROVED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approved
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 100 |
SHIP_PRIOR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship Prior to Sched Date
Y/N Table Edit
Default Value: N
|
| 101 |
BCKORDR_CNCL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
Y/N Table Edit
Default Value: N
|
| 102 |
BCKORDER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Backorder Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 103 |
BACKORDER_CREATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Backorder Created Flag
Y/N Table Edit
Default Value: N
|
| 104 |
CUSTODIAN |
Character(30) |
VARCHAR2(30) NOT NULL |
Custodian
|
| 105 |
CHARGE_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Charge Code
|
| 106 |
DESTIN_GL_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Destination GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 107 |
DISTRIB_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
GL Distribution
Y/N Table Edit
Default Value: N
|
| 108 |
COSTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost status of the transaction. Contains two values: 'N' cost have not been calculated for the transaction and 'Y' cost have been calculated for the transaction
E=Error; Cannot process
N=Transaction is Not Costed
P=Qualified for Purging
X=Transaction Won't be Costed
Y=Transaction is Costed
Default Value: N
|
| 109 |
PARTIAL_QTY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Qtys Can Ship
Y/N Table Edit
Default Value: N
|
| 110 |
PARTIAL_ORDER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Orders Can Ship
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 111 |
IN_LINE_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Backorder Rule
Prompt Table:
IN_RULE_B_VW
|
| 112 |
IN_LINE_RESV_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation Rule
Prompt Table:
IN_RULE_R_VW
|
| 113 |
IN_LN_RESV_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation - Backorder
Prompt Table:
IN_RULE_R_VW
|
| 114 |
IN_ORDER_RESV_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Reservation Rule
Prompt Table:
IN_RULE_O_VW
|
| 115 |
RESERVE_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Reservation Status
10=Pending
11=Unreserved
12=Shortage, Rules Not Met
15=Reserved, Rules Not Met
21=Shortage, Line Rule Met
22=Reserved, Line Rule Met
31=Shortage, All Rules Met
32=Reserved, All Rules Met
40=Reserve Run
99=Invalid
Default Value: 11
|
| 116 |
RESERVED_DTTM |
DateTime(26) |
TIMESTAMP |
Reserved Date/Time
|
| 117 |
FROZEN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Frozen Flag
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 118 |
UNIT_MEASURE_SHIP |
Character(3) |
VARCHAR2(3) NOT NULL |
Shipment Unit of Measure
Prompt Table:
INV_SHIP_UOM_VW
|
| 119 |
UNIT_MEASURE_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table:
UNITS_TBL
|
| 120 |
UNIT_MEASURE_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table:
UNITS_TBL
|
| 121 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table:
INV_ORDR_UOM_VW
|
| 122 |
SHIP_UOM_CONV_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
UOM Conversion Flag-Ship Panel
1=Enter Qty in Ordering UOM
2=Enter Qty in Shipping UOM
Default Value: 1
|
| 123 |
HARD_ALLOC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hard Allocate
Y/N Table Edit
Default Value: N
|
| 124 |
LOT_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Lot Allocation
Y/N Table Edit
Default Value: N
|
| 125 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
|
| 126 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
|
| 127 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
|
| 128 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
|
| 129 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
|
| 130 |
LAST_PROCESS_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 131 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 132 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
|
| 133 |
DIRECT_INVOICING |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Invoicing
Y/N Table Edit
Default Value: N
|
| 134 |
EDI_DT_TIME |
DateTime(26) |
TIMESTAMP |
EDI DATE TIME STAMP
|
| 135 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 136 |
RTV_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Return To Vendor ID
|
| 137 |
RTV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Return To Vendor Line
|
| 138 |
RTV_DISTRIB_NUM |
Number(5,0) |
INTEGER NOT NULL |
RTV Distribution Number
|
| 139 |
PRICE_PO |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Purchase Order Price
|
| 140 |
HOLD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold
N=Hold
Y=Hold
Y/N Table Edit
Default Value: N
|
| 141 |
HOLD_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Hold Code
Prompt Table:
HOLD_CD
|
| 142 |
CARTON_PRINTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Carton Print Flag
Y/N Table Edit
Default Value: N
|
| 143 |
SHIPPING_PRINTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Shipping Container Print Flag
Y/N Table Edit
Default Value: N
|
| 144 |
SHIP_SHORT_WF_DONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship Short WF Notification
Y/N Table Edit
Default Value: N
|
| 145 |
CURRENCY_CD_DEST |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code Dest
|
| 146 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
|
| 147 |
TRANSFER_COST_DEST |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Transfer Price Dest
|
| 148 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
|
| 149 |
VAT_APPLICABILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
|
| 150 |
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.
Prompt Table:
ROUTE_INV_VW
|
| 151 |
ROUTE_STOP_NBR |
Number(5,0) |
INTEGER NOT NULL |
An identifier used to sequence customer addresses/location for a given route.
|
| 152 |
PICK_RELEASE_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Release ID
|
| 153 |
BUDGET_DT |
Date(10) |
DATE |
Budget Date
|
| 154 |
EXPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Analytic Instance
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 155 |
REPLACEMENT_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods
Default Value: NA
|
| 156 |
IST_RETURN_FLG_IUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat InterUnit Returns
Y/N Table Edit
Default Value: N
|
| 157 |
IST_TXN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Transaction Flag
N=No
Y=Yes
Default Value: N
|
| 158 |
IST_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Distribution Status
A=Awaiting Arrival Processing
D=Distributed
I=Ignored
M=Archival Entry
N=Not Distributed
R=Reversal Entry
S=Awaiting Dispatch Processing
U=Undefined
Default Value: I
|
| 159 |
ORIG_INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Used to identify the original item ordered, in case an item substitution has taken place.
|
| 160 |
ORIG_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Original Unit of Measure
|
| 161 |
ALLOW_SUB_ITEM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate whether item substitutions are allowed on the order schedule.
Y/N Table Edit
Default Value: N
|
| 162 |
FRT_CHRG_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Charge Override
Default Value: N
|
| 163 |
FRT_CHRG_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
|
| 164 |
FRT_RULE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Rule Code
|
| 165 |
SHIP_ID_EST |
Character(10) |
VARCHAR2(10) NOT NULL |
Estimated Ship ID
|
| 166 |
NET_UNIT_PRICE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Net Unit Price
|
| 167 |
ALLOW_OVERPICK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate whether or not overpicking is allowed for a customer or business unit.
Y/N Table Edit
Default Value: N
|
| 168 |
MAX_PICK_TOLERANCE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Used to indicate the allowable percentage of overshipment for a customer or business unit.
|
| 169 |
SINGLE_SHIP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Ship Flag
N=No
Y=Yes
Default Value: N
|
| 170 |
PUB_PROCESS_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 171 |
DELIVERY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Delivery ID
|
| 172 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
Prompt Table:
SHIP_HDR_INV
|
| 173 |
SHIP_LINE_NO |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Ship Line No
|
| 174 |
SHIP_DTTM |
DateTime(26) |
TIMESTAMP |
Ship Date/Time
|
| 175 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
|
| 176 |
PRO_NUMBER |
Character(40) |
VARCHAR2(40) NOT NULL |
Pro Number
|
| 177 |
IN_DEFER_DEPLETION |
Character(1) |
VARCHAR2(1) NOT NULL |
Defer Depletions
Y/N Table Edit
|
| 178 |
EXT_REF_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
External Reference Number
|
| 179 |
EXT_REF_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
External Reference Line Number
|
| 180 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table:
REASON_SHIP_VW
|
| 181 |
TRANSFER_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Holds information regarding when the transfer price is calculated.
0=Calculate Cost at Depletions
1=Transfer at Zero Cost
Default Value: 0
|
| 182 |
FORM_DISTRIB_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Used for Sales Tax Forms tracking
D=Distributed
I=Ignore
N=Not Distributed
U=Undefined
Default Value: U
|
| 183 |
TMS_EXT_REF_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
TMS Reference ID
|
| 184 |
TMS_EXT_REF_LN_NBR |
Number(7,0) |
INTEGER NOT NULL |
TMS Line Number
|
| 185 |
TMS_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
TMS Process Flag
Default Value: N
|
| 186 |
TMS_LOAD_STP_NBR |
Number(5,0) |
INTEGER NOT NULL |
Load Stop Number
|
| 187 |
UPDATE_RESTRCT_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a translate field that indicates the restriction level and is checked by online processes when the row is being updated by a background process.
|
| 188 |
SHIP_PROCESS_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a translate field that indicates the restriction level and is checked by online processes when the row is being updated by a background process.
0=Front End Shipping
1=Background Shipping
2=On-Line Shipping
|
| 189 |
OM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Management Extract Flag
Y/N Table Edit
Default Value: N
|
| 190 |
PSSH_NONOWN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Non Own Flag
Y/N Table Edit
Default Value: N
|
| 191 |
DEPLETE_INV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Deplete Inventory Flag
Default Value: Y
|
| 192 |
DEPLETED_DTTM |
DateTime(26) |
TIMESTAMP |
Dttm Demand Line was Depleted
|
| 193 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
|
| 194 |
RECV_SHIP_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Receiver Shipping Sequence
|
| 195 |
POST_SHIP_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Cancel Instance
|
| 196 |
VMI_DESTIN_SHIPTO |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 197 |
VMI_OM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
OM Business Unit Related to VMI
|
| 198 |
VMI_ORDER_LINK |
Character(28) |
VARCHAR2(28) NOT NULL |
VMI Order Link
|
| 199 |
PRIORITY_SHIP_FROM |
Character(5) |
VARCHAR2(5) NOT NULL |
PRIORITY SHIP FROM BUSINESS UNIT
|
| 200 |
PEG_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
Default Value: 40
|
| 201 |
SUP_PEG_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Unpegged
Default Value: 40
|
| 202 |
CLAIM_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Claim ID
|
| 203 |
LINE_FIELD_C1_A |
Character(1) |
VARCHAR2(1) NOT NULL |
User Defined C1 A
|
| 204 |
LINE_FIELD_C1_B |
Character(1) |
VARCHAR2(1) NOT NULL |
User Defined C1 B
|
| 205 |
LINE_FIELD_C1_C |
Character(1) |
VARCHAR2(1) NOT NULL |
User Defined C1 C
|
| 206 |
LINE_FIELD_C1_D |
Character(1) |
VARCHAR2(1) NOT NULL |
User Defined C1 D
|
| 207 |
LINE_FIELD_C2 |
Character(2) |
VARCHAR2(2) NOT NULL |
User Defined C2
|
| 208 |
LINE_FIELD_C4 |
Character(4) |
VARCHAR2(4) NOT NULL |
User Defined C4
|
| 209 |
LINE_FIELD_C6 |
Character(6) |
VARCHAR2(6) NOT NULL |
User Defined C6
|
| 210 |
LINE_FIELD_C8 |
Character(8) |
VARCHAR2(8) NOT NULL |
User Defined C8
|
| 211 |
LINE_FIELD_C10_A |
Character(10) |
VARCHAR2(10) NOT NULL |
User Defined C10 A
|
| 212 |
LINE_FIELD_C10_B |
Character(10) |
VARCHAR2(10) NOT NULL |
User Defined C10 B
|
| 213 |
LINE_FIELD_C10_C |
Character(10) |
VARCHAR2(10) NOT NULL |
User Defined C10 C
|
| 214 |
LINE_FIELD_C10_D |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Fld C10 D
|
| 215 |
LINE_FIELD_C30_A |
Character(30) |
VARCHAR2(30) NOT NULL |
User Defined C30 A
|
| 216 |
LINE_FIELD_C30_B |
Character(30) |
VARCHAR2(30) NOT NULL |
User Defined C30 B
|
| 217 |
LINE_FIELD_C30_C |
Character(30) |
VARCHAR2(30) NOT NULL |
User Defined C30 C
|
| 218 |
LINE_FIELD_C30_D |
Character(30) |
VARCHAR2(30) NOT NULL |
User Defined C30 D
|
| 219 |
LINE_FIELD_DTTM_A |
DateTime(26) |
TIMESTAMP |
User Defined DTTM A
|
| 220 |
LINE_FIELD_DTTM_B |
DateTime(26) |
TIMESTAMP |
User Defined DTTM B
|
| 221 |
LINE_FIELD_DTTM_C |
DateTime(26) |
TIMESTAMP |
User Defined DTTM C
|
| 222 |
LINE_FIELD_DTTM_D |
DateTime(26) |
TIMESTAMP |
User Defined DTTM D
|
| 223 |
LINE_FIELD_N11_A |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
User Defined N11.4 A
|
| 224 |
LINE_FIELD_N11_B |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
User Defined N11.4 B
|
| 225 |
LINE_FIELD_N11_C |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
User Defined N11.4 C
|
| 226 |
LINE_FIELD_N11_D |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
User Defined N11.4 D
|
| 227 |
LINE_FIELD_N15_A |
Number(15,0) |
DECIMAL(15) NOT NULL |
User Defined N15.0 A
|
| 228 |
LINE_FIELD_N15_B |
Number(15,0) |
DECIMAL(15) NOT NULL |
User Defined N15.0 B
|
| 229 |
LINE_FIELD_N15_C |
Number(15,0) |
DECIMAL(15) NOT NULL |
User Defined N15.0 C
|
| 230 |
LINE_FIELD_N15_D |
Number(15,0) |
DECIMAL(15) NOT NULL |
User Defined N15.0 D
|
| 231 |
SPEEDTYPE_KEY |
Character(10) |
VARCHAR2(10) NOT NULL |
SpeedType Key
|
| 232 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
%EDIT_ACCOUNT
|
| 233 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table:
%EDIT_ALTACCT
|
| 234 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 235 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 236 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 237 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 238 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 239 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 240 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 241 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 242 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 243 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 244 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 245 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 246 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPTID_BUGL_VW
|
| 247 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
%EDIT_BU_PC
|
| 248 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
%EDIT_PROJECT
|
| 249 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDIT_ACTIVITY
|
| 250 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC
|
| 251 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC
|
| 252 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC
|
| 253 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC
|
| 254 |
COMBO_VALID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
ChartField Combinatn Valid Flg
?=Validation in Progress
V=Valid ChartField Combination
X=Invalid ChartField Combo
|
| 255 |
IN_PROCESS_DATE |
Date(10) |
DATE |
Process Date
Default Value: %date
|
| 256 |
OMB_PROCESS_DATE |
Date(10) |
DATE |
Process Date
|
| 257 |
FSS_ACTIVITY_DT |
Date(10) |
DATE |
EGS 03/02/06: Created
|
| 258 |
SDN_PUBLISH_DATE |
Date(10) |
DATE |
Publish date given on the loaded Financial Sanction list.
|
| 259 |
DELIV_UNIT_VOL |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Delivery Unit Volume
|
| 260 |
DELIV_UNIT_WT |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Delivery Unit Weight
|
| 261 |
DELIV_UOM_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Delivery Volume UOM
|
| 262 |
DELIV_UOM_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Delivery Weight UOM
|
| 263 |
DELIV_UOM_SHIP_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Ship UOM for volume conversion
|
| 264 |
DELIV_UOM_SHIP_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Ship UOM for weight conversion
|
| 265 |
DELIV_UNIT_VOL_CNV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Unit volume conversion rate
|
| 266 |
DELIV_UNIT_WT_CNV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Unit weight conversion rate
|
| 267 |
DELIV_USE_UOM_SHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
Use UNIT_MEASURE_SHIP
Y/N Table Edit
Default Value: N
|
| 268 |
PREF_CARRIER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Preferred Carrier flag
N=No Preferred Carrier
Y=Preferred Carrier
Default Value: N
|
| 269 |
TARGET_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Target Invoice
|
| 270 |
IN_TPRC_OVRD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Transfer Prices flag
Y/N Table Edit
Default Value: N
|
| 271 |
IN_ADDL_FEE_DEST |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Additional Fee Dest
|
| 272 |
IN_ADDL_FEE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Additional Fee
|