| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
ASN_DEFAULT_KEY |
Character(1) |
VARCHAR2(1) NOT NULL |
ASR Default Key
|
| 3 |
ASN_LOT_NBR |
Number(9,0) |
DECIMAL(9) NOT NULL |
ASN Lot/Serial Sequence Number
Default Value: 1
|
| 4 |
ASN_LOT_RESET |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset ASN Lot Number
Default Value: N
|
| 5 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
Default Value: NEXT
|
| 6 |
ASSET_INV_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset and Inventory Balance
C=Asset & Inventory Balanced
I=Asset & Inventory UnBalanced
Default Value: C
|
| 7 |
CONTAINER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Container ID
|
| 8 |
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
|
| 9 |
COUNTRY_IST_ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Intrastat Country of Origin
|
| 10 |
COUNTRY_SHIP_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country from which the invoice contents were shipped (for VAT processing only).
|
| 11 |
CUSTODIAN |
Character(30) |
VARCHAR2(30) NOT NULL |
Custodian
|
| 12 |
DELIVERED_DT |
Date(10) |
DATE |
Delivered Date
|
| 13 |
DELIVERED_TM |
Time(15) |
TIMESTAMP |
Delivered Time
|
| 14 |
DELIVERED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Delivered Flag
Default Value: N
|
| 15 |
DEFAULT_DATE |
Date(10) |
DATE |
Default Date
|
| 16 |
DELIVERED_TO |
Character(30) |
VARCHAR2(30) NOT NULL |
Delivered To
|
| 17 |
DELIVERED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Deliverer
|
| 18 |
DELIVERY_FEEDBACK |
Character(240) |
VARCHAR2(240) NOT NULL |
Delivery Feedback
|
| 19 |
DFLT_PACKSLIP_NO |
Character(22) |
VARCHAR2(22) NOT NULL |
Default Packing Slip value
|
| 20 |
DISTRIB_MTHD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribute by
A=Amount
Q=Quantity
Default Value: Q
|
| 21 |
DISTRIB_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Sequence
Default Value: 1
|
| 22 |
ERS_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Action
N=No
Y=Yes
Default Value: N
|
| 23 |
ERS_INV_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Invoice Status
I=Invoiced
N=Not Invoiced
P=Partially Invoiced
|
| 24 |
ERS_OVERRIDE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Override Option
N=Reject Match Errors
O=Override Match Exceptions
|
| 25 |
HOLD_ASSET |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Assets
Default Value: N
|
| 26 |
HOLD_INVENTORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Inventory
Default Value: N
|
| 27 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In process flag
Default Value: N
|
| 28 |
INSPECT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Inspection Status
C=Complete
I=Incomplete
Default Value: C
|
| 29 |
INTFC_ASSET |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Assets
Default Value: Y
|
| 30 |
INTFC_INVENTORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Inventory
Default Value: Y
|
| 31 |
INTFC_MG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Manufacturing
Default Value: Y
|
| 32 |
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
|
| 33 |
LOT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Lot ID
|
| 34 |
LOT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Lot Assigned Status
C=Complete
I=Incomplete
Default Value: I
|
| 35 |
MANUFACTURER |
Character(60) |
VARCHAR2(60) NOT NULL |
Manufacturer Name
|
| 36 |
MATCH_LINE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Line Level Match Flag
Y/N Table Edit
Default Value: Y
|
| 37 |
MATCH_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Match In Process
I=In Process
N=No
Default Value: N
|
| 38 |
MATCH_STATUS_RECV |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Status
M=Matched
N=Not Matched
P=Partially Matched
T=To Match
V=Vouchered
Default Value: N
|
| 39 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 40 |
MODEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Model
|
| 41 |
MOV_DS_ACCPT_SUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Interfaced Qty
|
| 42 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 43 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 44 |
PACKSLIP_NO |
Character(22) |
VARCHAR2(22) NOT NULL |
Packing Slip Number
|
| 45 |
PO_RECEIPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Receipt Flag - identifies if the receipt is related to a purchase order
Default Value: Y
|
| 46 |
PORT_OF_UNLOADING |
Character(10) |
VARCHAR2(10) NOT NULL |
Port Of Unloading
|
| 47 |
POST_STATUS_RECV |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Status Recv
|
| 48 |
PRE_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Pre-Interface ID
|
| 49 |
PRE_INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Pre-Interface Line Number
|
| 50 |
QTY_DS_ACCPT_SUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Distributed Quantity
|
| 51 |
QTY_DS_ACCPT_VUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Distributed Qty in Supp UOM
|
| 52 |
QTY_LN_ACCPT_SUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Std Accepted Qty
|
| 53 |
QTY_LN_ACCPT_VUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Supp Accepted Qty
|
| 54 |
QTY_LN_ASSET_SUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Quantity to be Asset Tracked
|
| 55 |
QTY_LN_INSPD_SUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Std Inspected Qty
|
| 56 |
QTY_LN_INSPD_VUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Vdnr Inspected Qty
|
| 57 |
QTY_LN_INV_SUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Line Inv Qty
|
| 58 |
QTY_LN_PKSLP_VUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Paperwork Quantity
|
| 59 |
QTY_LN_RECVD_SUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Receipt Qty
|
| 60 |
QTY_LN_RECVD_VUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Receipt Qty
|
| 61 |
QTY_LN_REJCT_SUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Std Rejected Qty
|
| 62 |
QTY_LN_REJCT_VUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Supp Rejected Qty
|
| 63 |
QTY_MOVED_ASSET |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Qty Asset Moved
|
| 64 |
QTY_MOVED_INV |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Received Base
|
| 65 |
QTY_SH_ACCPT_SUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Accepted Quantity
|
| 66 |
QTY_SH_ACCPT_VUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Accept QTY in Supplier UOM
|
| 67 |
QTY_SH_INSPD_SUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Inspected Quantity
|
| 68 |
QTY_SH_INSPD_VUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Inspected Qty in Supplier UOM
|
| 69 |
QTY_SH_RECVD_SUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Receipt Quantity
|
| 70 |
QTY_SH_RECVD_VUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Receipt QTY in Supplier UOM
|
| 71 |
QTY_SH_REJCT_SUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Rejected Quantity
|
| 72 |
QTY_SH_REJCT_VUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Reject QTY in Supplier UOM
|
| 73 |
QUANTITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Interface
|
| 74 |
RECEIPT_DT |
Date(10) |
DATE |
Received Date
|
| 75 |
RECV_AM_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Interface Status
C=Closed
H=Hold
M=Moved
O=Open
R=Received
X=Cancelled
Default Value: O
|
| 76 |
RECV_DS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Status
C=Closed
H=Hold
M=Moved
O=Open
R=Received
X=Cancelled
Default Value: O
|
| 77 |
RECV_LN_MATCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Match Status
F=Matched
N=No Match
P=Partial
Default Value: N
|
| 78 |
RECV_LN_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Receiver Line Status
C=Closed Item
H=Hold Item
I=In Inspection
M=Moved to Destination
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled
Default Value: O
|
| 79 |
RECV_SHIP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Schedule Status
C=Closed
H=Hold
O=Open
R=Received
X=Canceled
Default Value: O
|
| 80 |
RECV_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled
Default Value: O
|
| 81 |
REPLACEMENT_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods
|
| 82 |
REJECT_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Action On Rejection
C=Return for Credit
R=Return For Replacement
|
| 83 |
REJECT_REASON |
Character(10) |
VARCHAR2(10) NOT NULL |
Reject Reason Code
DAM=Damaged Goods
FAL=Failed Inspection
INC=Incomplete Shipment
LAT=Late Shipment
RLY=Early Shipment
WRG=Wrong Goods or Service
Prompt Table:
REJECT_REASONS
|
| 84 |
RMA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
RMA Number
|
| 85 |
RMA_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
RMA Line Number
|
| 86 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
|
| 87 |
SERIAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Serial Status
C=Complete
I=Incomplete
Default Value: I
|
| 88 |
SHIP_DATE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship Date Status
1=Passes Date Check
2=Early Shipment
3=Late Shipment
|
| 89 |
SHIP_QTY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Quantity Status
1=Passes Quantity Check
2=Over Shipment
3=Under Shipment
|
| 90 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
|
| 91 |
STORAGE_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Code
|
| 92 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
|
| 93 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
|
| 94 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
|
| 95 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
|
| 96 |
TAG_NUMBER |
Character(12) |
VARCHAR2(12) NOT NULL |
Tag Number
|
| 97 |
USER_RECV_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 1
|
| 98 |
CUSTOM_C100_E1 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 1
|
| 99 |
CUSTOM_C100_E2 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 2
|
| 100 |
CUSTOM_C100_E3 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 3
|
| 101 |
CUSTOM_C100_E4 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 4
|
| 102 |
CUSTOM_DATE_E |
Date(10) |
DATE |
Custom Date
|
| 103 |
CUSTOM_C1_E |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 2
|