| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 3 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 4 |
ASSTN_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Association Name
|
| 5 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 6 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 7 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 8 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 9 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
|
| 10 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
|
| 11 |
RECV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Receipt Line
|
| 12 |
RECV_SHIP_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Receiver Shipping Sequence
|
| 13 |
QTY_VCHR |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Vouchered
|
| 14 |
QTY_VCHR_CNVT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Voucher Qty Converted
|
| 15 |
QTY_VCHR_CNVTR |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Voucher Qty Converted-Recv
|
| 16 |
UNIT_PRICE_CNVT_B |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Unit Price converted base
|
| 17 |
UNIT_PRICE_CNVTR_B |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Unit Price converted base-Recv
|
| 18 |
BUSINESS_UNIT_RTV |
Character(5) |
VARCHAR2(5) NOT NULL |
RTV Business Unit
|
| 19 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 20 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 21 |
QTY_RECV_APPLIED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Receiver line ship quantity applied to voucher line in PO unit of measure
|
| 22 |
MERCH_AMT_RECVAPPL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Receiver line ship merchandise amt applied to voucher line in PO currency
|
| 23 |
MERCH_AMT_VCHR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Voucher Merchandise Amount
|
| 24 |
MERCH_AMT_VCHR_B |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Voucher Merch Amt Converted
|
| 25 |
MERCH_AMT_VCHRR_B |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merch Amount Voucher base-Recv
|
| 26 |
MERCH_AMT_RECV |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amount Received
|
| 27 |
MERCH_AMT_PO |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amount PO
|
| 28 |
QTY_PO |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Purchase Order Quantity
|
| 29 |
QTY_SH_ACCPT_VUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Accept QTY in Supplier UOM
|
| 30 |
PROCEED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Proceed
|
| 31 |
AP_RULE_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Action
D=Debit Memo
E=Exception
M=Match
O=Override
|
| 32 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 33 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
|
| 34 |
FROZEN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Frozen Flag
B=Both
N=No
Y=Yes
|
| 35 |
ORIG_PROM_DT |
Date(10) |
DATE |
Original Promise Date
|
| 36 |
ORIGIN_PO |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 37 |
ORIGIN_RECV |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 38 |
PO_DT |
Date(10) |
DATE |
Date
|
| 39 |
PO_TYPE_PO |
Character(4) |
VARCHAR2(4) NOT NULL |
PO Type
|
| 40 |
PO_TYPE_RECV |
Character(4) |
VARCHAR2(4) NOT NULL |
PO Type
|
| 41 |
QTY_MATCHED_PO |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Quantity Matched PO
|
| 42 |
QTY_MATCHED_RECV |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Quantity Matched RECV
|
| 43 |
AMT_MATCHED_PO |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amt Matched PO
|
| 44 |
AMT_MATCHED_RECV |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amt Matched Recv
|
| 45 |
UNIT_PRICE_CNVT |
Number(16,5) |
DECIMAL(15,5) NOT NULL |
Unit Price Converted
|
| 46 |
UNIT_PRICE_CNVTR |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Unit Price Converted-Recv
|
| 47 |
ALGTHM_BEHAVIOR |
Character(4) |
VARCHAR2(4) NOT NULL |
Rule
CAIF=Select All
EQSM=Equal Sum
EXCT=Equal
MTVQ=Sum Up To
SLON=Select If One
USER=User Criteria
|
| 48 |
AMT_ONLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Amount Only
N=No
Y=Yes
|
| 49 |
MATCH_STATUS_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Status
M=Matched
N=Not Required
P=Partially Matched
T=To Match
|
| 50 |
MATCH_LINE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Line Status
E=Match Error
M=Matched
N=Not Matched
|
| 51 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
|
| 52 |
USER_LINE_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 1
|
| 53 |
CUSTOM_C100_B1 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 1
|
| 54 |
CUSTOM_C100_B2 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 2
|
| 55 |
CUSTOM_C100_B3 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 3
|
| 56 |
CUSTOM_C100_B4 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 4
|
| 57 |
CUSTOM_DATE_B |
Date(10) |
DATE |
Custom Date
|
| 58 |
CUSTOM_C1_B |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 2
|
| 59 |
USER_SCHED_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 1
|
| 60 |
CUSTOM_C100_C1 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 1
|
| 61 |
CUSTOM_C100_C2 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 2
|
| 62 |
CUSTOM_C100_C3 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 3
|
| 63 |
CUSTOM_DATE_C1 |
Date(10) |
DATE |
Custom Date 1
|
| 64 |
CUSTOM_DATE_C2 |
Date(10) |
DATE |
Custom Date 2
|
| 65 |
CUSTOM_C1_C |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 2
|
| 66 |
RECEIPT_DT |
Date(10) |
DATE |
Received Date
|
| 67 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
|
| 68 |
MATCH_STATUS_RECV |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Status
M=Matched
N=Not Matched
P=Partially Matched
T=To Match
V=Vouchered
|
| 69 |
MATCH_LINE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Line Option
E=ERS
F=Full Match
N=Don't Match
|
| 70 |
PO_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
|
| 71 |
VCHR_SRC |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Source
|
| 72 |
CONVERSION_RATE |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Conversion Rate
|
| 73 |
UOM_VCHR |
Character(3) |
VARCHAR2(3) NOT NULL |
Unit Of Measure Voucher
|
| 74 |
UOM_PO |
Character(3) |
VARCHAR2(3) NOT NULL |
Unit Of Measure PO
|
| 75 |
UOM_RECV |
Character(3) |
VARCHAR2(3) NOT NULL |
Unit Of Measure
|
| 76 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 77 |
RATE_MULT_TOL |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 78 |
RATE_DIV_TOL |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 79 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 80 |
RT_TYPE_PO |
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.
|
| 81 |
RT_TYPE_VCHR |
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.
|
| 82 |
CURRENCY_CD_PO |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code Purchase Order
|
| 83 |
CURRENCY_CD_RECV |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 84 |
CURRENCY_CD_VCHR |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code Voucher
|
| 85 |
DBMEMO_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Debit Memo
|
| 86 |
DMEMO_CAT_PRICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Debit Memo Category Price
Q=Quantity
U=Unit Price
Y/N Table Edit
|
| 87 |
DMEMO_CAT_QTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Debit Memo Category Quantity
Q=Quantity
U=Unit Price
Y/N Table Edit
|
| 88 |
DISTRIB_MTHD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribute by
A=Amount
Q=Quantity
|
| 89 |
INSPECT_DT |
Date(10) |
DATE |
Inspection Date
|
| 90 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 91 |
INVOICED_QTY_CNVT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Invoiced quantity, PO UOM
|
| 92 |
INVOICED_AMT_B |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoiced Amount base
|
| 93 |
KK_PROCESS_PRIOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Prior Document
|
| 94 |
MATCH_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Match Rule
|
| 95 |
PACKSLIP_NO |
Character(22) |
VARCHAR2(22) NOT NULL |
Packing Slip Number
|
| 96 |
MERCH_AMT_EXTND |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Extened Merchandise Amount
|
| 97 |
MERCH_AMT_EXTND_B |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Extended Merchandise Amt base
|
| 98 |
MERCH_AMT_EXTND_PO |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt Extended PO
|
| 99 |
EXT_PRC_TOL |
Number(14,5) |
DECIMAL(13,5) NOT NULL |
Ext Price Tolerance
|
| 100 |
EXT_PRC_TOL_L |
Number(14,5) |
DECIMAL(13,5) NOT NULL |
Ext Price Tolerance - Under
|
| 101 |
PCT_EXT_PRC_TOL |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Ext Price Tolerance
|
| 102 |
PCT_EXT_PRC_TOL_L |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Ext Price Tolerance - Under
|
| 103 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
|
| 104 |
PYMNT_TERMS_CD_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Payment Terms
|
| 105 |
QTY_ENTERED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Entered
|
| 106 |
PO_RECEIPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Receipt Flag - identifies if the receipt is related to a purchase order
|
| 107 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 108 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 109 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 110 |
VNDR_SETID_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
Supplier setid PO
|
| 111 |
VENDOR_PO |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier ID PO
|
| 112 |
VNDR_LOC_PO |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier Location PO
|
| 113 |
VNDR_SETID_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Supplier Setid Receiver
|
| 114 |
VOUCHER_STYLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
|
| 115 |
VENDOR_RECV |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier ID Receiver
|
| 116 |
VNDR_LOC_RECV |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier Location Receiver
|
| 117 |
INSPECT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Inspection Status
C=Complete
I=Incomplete
|
| 118 |
INSPECT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Inspection Required
N=No
Y=Yes
|
| 119 |
ITM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Item SetID
|
| 120 |
ITM_SETID_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
Item setid PO
|
| 121 |
ITM_SETID_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Item Setid Receiver
|
| 122 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 123 |
INV_ITEM_ID_PO |
Character(18) |
VARCHAR2(18) NOT NULL |
Item Number PO
|
| 124 |
INV_ITEM_ID_RECV |
Character(18) |
VARCHAR2(18) NOT NULL |
Item Number
|
| 125 |
PRICE_PO |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Purchase Order Price
|
| 126 |
PRICE_PO_RECV |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Non-PO Price
|
| 127 |
RECV_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Receive Source
1=On-line
2=ASN
3=Data Cllct
4=Mobile
|
| 128 |
RJCT_OVER_TOL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reject Qty Over Tolerance
|
| 129 |
ZERO_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Denominator Indicator
|
| 130 |
ZERO_PRICE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Price Indicator
|
| 131 |
TOTAL_RECV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Received Amount
|
| 132 |
TOTAL_RECV_AMT_PO |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Received Amount PO
|
| 133 |
TOTAL_RECV_ENT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Total Received Quantity Ent
|
| 134 |
TOTAL_RECV_ENT_PO |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Total Received Quantity Ent
|
| 135 |
TOTAL_RECV_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Total Received Quantity
|
| 136 |
TOTAL_RECV_QTY_PO |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Total Received Quantity PO
|
| 137 |
PRICE_CAN_CHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Can Be Changed on Order
N=No
Y=Yes
|
| 138 |
PRICE_CAN_CHANGE_R |
Character(1) |
VARCHAR2(1) NOT NULL |
Price can change
|
| 139 |
PCT_UNIT_PRC_TOL |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Unit Price Tolerance
|
| 140 |
PCT_UNIT_PRC_TOL_L |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Unit Price Tolerance - Under
|
| 141 |
UNIT_PRC_TOL |
Number(14,5) |
DECIMAL(13,5) NOT NULL |
Unit Price Tolerance
|
| 142 |
UNIT_PRC_TOL_L |
Number(14,5) |
DECIMAL(13,5) NOT NULL |
Unit Price Tolerance - Under
|
| 143 |
UNIT_PRICE_VCHR |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Unit Price
|
| 144 |
RECV_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Receiving Required
N=Optional
X=Do Not
Y=Required
|
| 145 |
QTY_RECV_TOL_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Qty Rcvd Tolerance %
|
| 146 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
|
| 147 |
CATEGORY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category ID
|
| 148 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 149 |
USER_VCHR_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Character Field
|
| 150 |
USER_VCHR_CHAR2 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Character Field 2
|
| 151 |
USER_VCHR_DEC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
User Amount Field
|
| 152 |
USER_VCHR_DATE |
Date(10) |
DATE |
User Date
|
| 153 |
USER_VCHR_NUM1 |
Number(3,0) |
SMALLINT NOT NULL |
User Number field
|
| 154 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 155 |
LTD_RECV |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Value: N
|
| 156 |
PACKSLIP_NO_RECV |
Character(22) |
VARCHAR2(22) NOT NULL |
Packing Slip Number
|