| # |
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 |
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
|
| 3 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 4 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 5 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
MST_ITM_PRPT_VW
|
| 6 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 7 |
DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
Default Value: 1
|
| 8 |
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
|
| 9 |
SHIP_FROM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Ship from INV BU
|
| 10 |
AUTO_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Number Type
|
| 11 |
DEMAND_DATE |
Date(10) |
DATE |
Demand Date
|
| 12 |
REQUEST_DATE |
Date(10) |
DATE |
Requested
|
| 13 |
CANCEL_DATE |
Date(10) |
DATE |
Cancel Date
|
| 14 |
SCHED_DATE |
Date(10) |
DATE |
Schedule Date
|
| 15 |
SCHED_TIME |
Time(15) |
TIMESTAMP |
Schedule Time
|
| 16 |
ORIG_SCHED_DATE |
Date(10) |
DATE |
Orig Sched Date
|
| 17 |
ORIG_SCHED_TIME |
Time(15) |
TIMESTAMP |
Original Schedule Time
|
| 18 |
SHIP_DATE |
Date(10) |
DATE |
Item Shipping Date
|
| 19 |
SHIP_TIME |
Time(15) |
TIMESTAMP |
Ship Time
|
| 20 |
SCHED_ARRV_DTTM |
DateTime(26) |
TIMESTAMP |
Schedule Arrival Dt/Tm
|
| 21 |
PICK_DATE |
Date(10) |
DATE |
Picked Date
|
| 22 |
PICK_CONFIRM_DTTM |
DateTime(26) |
TIMESTAMP |
Pick Confirm Date/Time
|
| 23 |
ORIG_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Original Business Unit
|
| 24 |
DESTIN_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Destination Unit
|
| 25 |
DATE_LAST_MAINT |
Date(10) |
DATE |
Date Last Maintained
|
| 26 |
LOAD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Load ID
Prompt Table:
LOAD_INV
|
| 27 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table:
CARRIER_ID
|
| 28 |
CARRIER_ID_EXP |
Character(10) |
VARCHAR2(10) NOT NULL |
Export Carrier ID
|
| 29 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
SHIP_METHOD
|
| 30 |
SHIP_TYPE_ID_EXP |
Character(10) |
VARCHAR2(10) NOT NULL |
Export Shipping Method
|
| 31 |
SHIP_EARLY_DATE |
Date(10) |
DATE |
Earliest Ship Date
|
| 32 |
SHIP_EARLY_TIME |
Time(15) |
TIMESTAMP |
Earliest Ship Time
|
| 33 |
SHIP_LATE_DATE |
Date(10) |
DATE |
Latest Ship Date
|
| 34 |
SHIP_LATE_TIME |
Time(15) |
TIMESTAMP |
Latest Ship Time
|
| 35 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table:
FREIGHT_TERMS
|
| 36 |
FREIGHT_TERMS_EXP |
Character(10) |
VARCHAR2(10) NOT NULL |
Export Freight Terms Code
|
| 37 |
PRIORITY_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 38 |
DISTRIB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Distrib. Type
Prompt Table:
CM_DISTR_TYPE
|
| 39 |
PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID
|
| 40 |
PICKLIST_LINE_NO |
Number(7,0) |
INTEGER NOT NULL |
Pick List Sorting Line Number
|
| 41 |
PROJECT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Assign To Project
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 42 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 43 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 44 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 45 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 46 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Default Value: INSTALLATION_PC.AN_TYPE_IN
|
| 47 |
COMBO_VALID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
ChartField Combinatn Valid Flg
?=Validation in Progress
V=Valid ChartField Combination
X=Invalid ChartField Combo
|
| 48 |
SPEEDTYPE_KEY |
Character(10) |
VARCHAR2(10) NOT NULL |
SpeedType Key
|
| 49 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
|
| 50 |
REQ_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Requisition Line Number
|
| 51 |
REQ_SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Requisition Schedule Number
|
| 52 |
REQ_DISTRIB_NBR |
Number(5,0) |
INTEGER NOT NULL |
Requisition Distrib Number
|
| 53 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 54 |
PARENT_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Parent Product Id
|
| 55 |
KIT_LINE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Kit Line Number
|
| 56 |
CHARGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Charged Out
Default Value: N
|
| 57 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
|
| 58 |
DESTIN_GL_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Destination GL Business Unit
|
| 59 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
GL_ACCT_BUGL_VW
|
| 60 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 61 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPTID_BUGL_VW
|
| 62 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 63 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 64 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 65 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 66 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 67 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 68 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 69 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 70 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 71 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 72 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 73 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 74 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 75 |
FERC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
FERC Code
Prompt Table:
FERC_CD_TBL
|
| 76 |
INTERUNIT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
InterUnit Order ID
|
| 77 |
INTERUNIT_LINE |
Number(5,0) |
INTEGER NOT NULL |
InterUnit Order Line
|
| 78 |
INTERUNIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 79 |
INTERUNIT_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit Status
C=Cancelled
I=In-Transit
O=Open
P=Picked
R=Received
Default Value: O
|
| 80 |
INV_ITEM_ALIAS |
Character(18) |
VARCHAR2(18) NOT NULL |
Item Alias
|
| 81 |
PRICE_MARKUP_PCT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Price Markup %
|
| 82 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_SBU_VW
|
| 83 |
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.
|
| 84 |
CUST_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Name
|
| 85 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 86 |
SHIP_CUST_NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Ship To Name
|
| 87 |
SHIP_CUST_NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Ship To Name 2
|
| 88 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 89 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 90 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 91 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 92 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 93 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 94 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 95 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 96 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 97 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 98 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 99 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 100 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 101 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 102 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 103 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 104 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 105 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 106 |
TAX_EXEMPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit
|
| 107 |
EXP_RETURN_DATE |
Date(10) |
DATE |
Return Date
|
| 108 |
EXPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Analytic Instance
N=No
Y=Yes
|
| 109 |
TRANSFER_COST |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Transfer Price
|
| 110 |
PACKAGING_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Packaging Code
Prompt Table:
PACKAGNG_CD_INV
|
| 111 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 112 |
QTY_REQUESTED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Requested
|
| 113 |
QTY_ALLOCATED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Allocated quantity
|
| 114 |
QTY_ALLOC_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity allocation
|
| 115 |
QTY_PICKED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Picked
|
| 116 |
QTY_SHIPPED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Shipped
|
| 117 |
QTY_SHIPPED_CONV |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Shipped
|
| 118 |
QTY_PICK_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Pick Base
|
| 119 |
QTY_SHIP_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Ship Base
|
| 120 |
QTY_BACKORDER |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Backorder Qty
|
| 121 |
CANCEL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel PO
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 122 |
FULFILL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
OK to Pick
Y/N Table Edit
Default Value: N
|
| 123 |
RESERVED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reserved Flag
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 124 |
CONFIRMED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirm
|
| 125 |
HARD_ALLOC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hard Allocate
|
| 126 |
LOT_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Lot Allocation
Y/N Table Edit
Default Value: N
|
| 127 |
SHIPPED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Shipped
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 128 |
SHIPPED_MESSAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Shipped Message
Y/N Table Edit
Default Value: N
|
| 129 |
QTY_VERIFY_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Verify Qty
Y/N Table Edit
Default Value: N
|
| 130 |
APPROVED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approved
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 131 |
SHIP_PRIORITY_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Shipping Priority Code
|
| 132 |
SHIP_PRIORITY_EXP |
Character(6) |
VARCHAR2(6) NOT NULL |
Export Shipping Priority
|
| 133 |
SHIP_PRIOR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship Prior to Sched Date
Y/N Table Edit
Default Value: N
|
| 134 |
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
|
| 135 |
BCKORDER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Backorder Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 136 |
CUSTODIAN |
Character(30) |
VARCHAR2(30) NOT NULL |
Custodian
|
| 137 |
CHARGE_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Charge Code
|
| 138 |
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
|
| 139 |
PARTIAL_QTY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Qtys Can Ship
Y/N Table Edit
Default Value: N
|
| 140 |
PARTIAL_ORDER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Orders Can Ship
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 141 |
AUTO_PICK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Items for Auto-Pick
|
| 142 |
AUTO_SHIP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Items for Auto-Ship
|
| 143 |
NET_CHANGE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Planning Net Change
Y/N Table Edit
Default Value: N
|
| 144 |
NET_CHANGE_EP |
Character(1) |
VARCHAR2(1) NOT NULL |
Enterprise Planning Net Change
Default Value: N
|
| 145 |
FROZEN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Frozen Flag
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 146 |
OM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Management Extract Flag
Y/N Table Edit
Default Value: N
|
| 147 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
Prompt Table:
SHIP_HDR_INV
|
| 148 |
SHIP_LINE_NO |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Ship Line No
|
| 149 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 150 |
UNIT_MEASURE_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table:
UNITS_TBL
|
| 151 |
UNIT_MEASURE_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table:
UNITS_TBL
|
| 152 |
UNIT_MEASURE_SHIP |
Character(3) |
VARCHAR2(3) NOT NULL |
Shipment Unit of Measure
Prompt Table:
INV_SHIP_UOM_VW
|
| 153 |
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
|
| 154 |
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
|
| 155 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
|
| 156 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
|
| 157 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
|
| 158 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
|
| 159 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
|
| 160 |
PLANNED_LOSS |
Number(7,4) |
DECIMAL(6,4) NOT NULL |
Planned Loss
|
| 161 |
PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
|
| 162 |
POST_SHIP_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Cancel Instance
|
| 163 |
PSSH_RUN_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Status
1=Not Processed
2=In Process
3=Process Complete
Default Value: 1
|
| 164 |
PSSH_COMPLETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Ship Complete
Y/N Table Edit
Default Value: N
|
| 165 |
PSSH_NONOWN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Non Own Flag
Y/N Table Edit
Default Value: N
|
| 166 |
INTERUNIT_INSERT |
Character(1) |
VARCHAR2(1) NOT NULL |
Interunit Insert
Y/N Table Edit
Default Value: N
|
| 167 |
DEPLETE_INV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Deplete Inventory Flag
Default Value: Y
|
| 168 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 169 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 170 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
|
| 171 |
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
Default Value: N
|
| 172 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
|
| 173 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
|
| 174 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 175 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 176 |
DIRECT_INVOICING |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Invoicing
Y/N Table Edit
Default Value: N
|
| 177 |
PRO_NUMBER |
Character(40) |
VARCHAR2(40) NOT NULL |
Pro Number
|
| 178 |
EDI_DT_TIME |
DateTime(26) |
TIMESTAMP |
EDI DATE TIME STAMP
|
| 179 |
BACKORDER_CREATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Backorder Created Flag
Y/N Table Edit
Default Value: N
|
| 180 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 181 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 182 |
PO_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Purchase Order Line Number
|
| 183 |
PO_SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
PO Schedule Number
|
| 184 |
RTV_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Return To Vendor ID
|
| 185 |
RTV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Return To Vendor Line
|
| 186 |
RTV_DISTRIB_NUM |
Number(5,0) |
INTEGER NOT NULL |
RTV Distribution Number
|
| 187 |
PRICE_PO |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Purchase Order Price
|
| 188 |
HOLD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold
N=Hold
Y=Hold
Y/N Table Edit
Default Value: N
|
| 189 |
HOLD_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Hold Code
Prompt Table:
HOLD_CD
|
| 190 |
CARTON_PRINTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Carton Print Flag
Y/N Table Edit
Default Value: N
|
| 191 |
SHIPPING_PRINTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Shipping Container Print Flag
Y/N Table Edit
Default Value: N
|
| 192 |
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
|
| 193 |
SHIP_SHORT_WF_DONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship Short WF Notification
Default Value: N
|
| 194 |
PRODUCT_KIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Kit
|
| 195 |
INVENTORY_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory Item
N=No
Y=Yes
|
| 196 |
UNIT_MEASURE_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Unit of Measure
|
| 197 |
QTY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Per
ASY=Assembly
ORD=Order
|
| 198 |
QTY_PER |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Quantity
|
| 199 |
QTY_SCHEDULED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Scheduled
|
| 200 |
COST_ELEMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Element
|
| 201 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
|
| 202 |
UNIT_COST |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Unit Cost
|
| 203 |
DELETE_TRANS |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Mass Transactions
Y/N Table Edit
|
| 204 |
DELETE_REASON |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Reason
|
| 205 |
DROP_SHIP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Drop Ship
N=No
Y=Yes
|
| 206 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 207 |
EXTENSION |
Character(6) |
VARCHAR2(6) NOT NULL |
Phone Extension
|
| 208 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Int'l Prefix
|
| 209 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
|
| 210 |
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
|
| 211 |
NON_OWN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No
Y=Yes
|
| 212 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|