| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
CANCEL_DTTM |
DateTime(26) |
TIMESTAMP |
Dttm demand line was canceled
|
| 3 |
ORIG_SCHED_DTTM |
DateTime(26) |
TIMESTAMP |
Original Schedule Date/Time
|
| 4 |
PICK_DTTM |
DateTime(26) |
TIMESTAMP |
Picked Date/Time
|
| 5 |
PICK_CONFIRM_DTTM |
DateTime(26) |
TIMESTAMP |
Pick Confirm Date/Time
|
| 6 |
DATE_LAST_MAINT |
Date(10) |
DATE |
Date Last Maintained
|
| 7 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 8 |
IN_ZERO_PICKED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Picked
|
| 9 |
IN_KIT_PROTECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Kit protected flag
|
| 10 |
INTERUNIT_INSERT |
Character(1) |
VARCHAR2(1) NOT NULL |
Interunit Insert
|
| 11 |
TAX_EXEMPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
|
| 12 |
EXP_RETURN_DATE |
Date(10) |
DATE |
Return Date
|
| 13 |
ORIG_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
User ID
|
| 14 |
PICKLIST_PRINTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Picklist Printed
|
| 15 |
CONFIRMED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirm
|
| 16 |
SHIPPED_MESSAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Shipped Message
|
| 17 |
QTY_VERIFY_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Verify Qty
|
| 18 |
SHIP_PRIOR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship Prior to Sched Date
|
| 19 |
BCKORDER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Backorder Flag
N=No
Y=Yes
|
| 20 |
BACKORDER_CREATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Backorder Created Flag
|
| 21 |
DISTRIB_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
GL Distribution
|
| 22 |
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
|
| 23 |
RESERVED_DTTM |
DateTime(26) |
TIMESTAMP |
Reserved Date/Time
|
| 24 |
FROZEN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Frozen Flag
B=Both
N=No
Y=Yes
|
| 25 |
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
|
| 26 |
HARD_ALLOC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hard Allocate
|
| 27 |
LOT_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Lot Allocation
|
| 28 |
LAST_PROCESS_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 29 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 30 |
EDI_DT_TIME |
DateTime(26) |
TIMESTAMP |
EDI DATE TIME STAMP
|
| 31 |
CARTON_PRINTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Carton Print Flag
|
| 32 |
SHIPPING_PRINTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Shipping Container Print Flag
|
| 33 |
SHIP_SHORT_WF_DONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship Short WF Notification
|
| 34 |
BUDGET_DT |
Date(10) |
DATE |
Budget Date
|
| 35 |
REPLACEMENT_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods
|
| 36 |
IST_RETURN_FLG_IUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat InterUnit Returns
|
| 37 |
IST_TXN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Transaction Flag
N=No
Y=Yes
|
| 38 |
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
|
| 39 |
FRT_CHRG_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Charge Override
|
| 40 |
SINGLE_SHIP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Ship Flag
N=No
Y=Yes
|
| 41 |
SHIP_DTTM |
DateTime(26) |
TIMESTAMP |
Ship Date/Time
|
| 42 |
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
|
| 43 |
FORM_DISTRIB_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Used for Sales Tax Forms tracking
D=Distributed
I=Ignore
N=Not Distributed
U=Undefined
|
| 44 |
TMS_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
TMS Process Flag
|
| 45 |
OM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Management Extract Flag
|
| 46 |
PSSH_NONOWN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Non Own Flag
|
| 47 |
DEPLETED_DTTM |
DateTime(26) |
TIMESTAMP |
Dttm Demand Line was Depleted
|
| 48 |
PEG_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
|
| 49 |
SUP_PEG_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Unpegged
|
| 50 |
IN_PROCESS_DATE |
Date(10) |
DATE |
Process Date
|
| 51 |
OMB_PROCESS_DATE |
Date(10) |
DATE |
Process Date
|
| 52 |
FSS_ACTIVITY_DT |
Date(10) |
DATE |
EGS 03/02/06: Created
|
| 53 |
SDN_PUBLISH_DATE |
Date(10) |
DATE |
Publish date given on the loaded Financial Sanction list.
|