| # |
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
|
| 2 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 3 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table:
SP_BU_AM_NONVW
|
| 4 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table:
%EDITTABLE
|
| 5 |
BU_PSGL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Using PS/GL
Y/N Table Edit
Default Value: INSTALLATION.GL
|
| 6 |
PRCS_OPTION_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Processing Option ID
Prompt Table:
BUS_UNIT_OPT_PM
|
| 7 |
REQ_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisitions
Y/N Table Edit
Default Value: Y
|
| 8 |
REQ_ID_LAST_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Requisition Number
|
| 9 |
PO_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Orders
Y/N Table Edit
Default Value: Y
|
| 10 |
PO_ID_LAST_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last PO Number
|
| 11 |
RECV_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Receivers
Y/N Table Edit
Default Value: Y
|
| 12 |
RECV_ID_LAST_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Receiver Number
|
| 13 |
ADJ_RECV_DATE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Receipt Date Adjustment
|
| 14 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 15 |
RT_TYPE |
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.
Prompt Table:
RT_TYPE_TBL
|
| 16 |
PO_ITM_VNDR_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Item Vendor Security Option
1=No Edit Required
2=Edit Required When Use Item ID
3=Edit Required Must Use Item ID
Default Value: 1
|
| 17 |
RFQ_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Request For Quotes
Y/N Table Edit
Default Value: Y
|
| 18 |
RFQ_ID_LAST_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last RFQ Number
|
| 19 |
POST_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Option
Y/N Table Edit
Default Value: N
|
| 20 |
POST_DT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Date Indicator
A=Use Accounting Date
C=Use Current Date
P=Post All Transactions
S=Use Specific Date
Default Value: P
|
| 21 |
POST_THRU_DT |
Date(10) |
DATE |
Post Thru Date
Default Value: %date
|
| 22 |
CLOSE_DELAY_DAYS |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Close Processing Delay Days
|
| 23 |
RCPT_CLOSE_DAYS |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Receipt Close Delay Days
|
| 24 |
CANCEL_DELAY_DAYS |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Cancel Days
|
| 25 |
CATEGORY_CD |
Character(18) |
VARCHAR2(18) NOT NULL |
Category Code
Prompt Table:
ITM_CAT_VW
|
| 26 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 27 |
BILL_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Location
Prompt Table:
LOCATION_TBL
|
| 28 |
DB_NUMBER |
Character(9) |
VARCHAR2(9) NOT NULL |
DUNS Number
|
| 29 |
CHNG_TMPLT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Change Template
Default Value: STANDARD
Prompt Table:
CHNG_TMPLT_TBL
|
| 30 |
FINANCIAL_ASSET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Capitalized Asset
N=Non Cap
Y=Capitalize
Default Value: Y
|
| 31 |
BUSPROCNAME_PO |
Character(30) |
VARCHAR2(30) NOT NULL |
PO Approval Business Process
Prompt Table:
BUSPROCNAME_VW
|
| 32 |
PO_AMT_APPR_NEEDED |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Amount Approval Needed
Y/N Table Edit
Default Value: N
|
| 33 |
APPR_RULE_PO_AMT |
Character(30) |
VARCHAR2(30) NOT NULL |
PO Amount Approval Rule Set
Prompt Table:
PO_APPR_RULE_VW
|
| 34 |
PO_CF_APPR_NEEDED |
Character(1) |
VARCHAR2(1) NOT NULL |
PO ChartField Approval Needed
Y/N Table Edit
Default Value: N
|
| 35 |
APPR_RULE_PO_CF |
Character(30) |
VARCHAR2(30) NOT NULL |
PO ChartField Approval RuleSet
Prompt Table:
PO_APPR_RULE_VW
|
| 36 |
TAX_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit
Default Value: N
|
| 37 |
TAX_EXEMPT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Tax Exempt ID
|
| 38 |
ACCRUE_USE_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrue Use Tax
Y/N Table Edit
Default Value: N
|
| 39 |
ORIGIN_AP |
Character(3) |
VARCHAR2(3) NOT NULL |
AP Origin ID
Prompt Table:
ORIGIN_AP
|
| 40 |
BUSPROCNAME_REQ |
Character(30) |
VARCHAR2(30) NOT NULL |
Req Approval Business Process
Prompt Table:
BUSPROCNAME_VW
|
| 41 |
REQ_AMT_APPR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Req Amount Approval Needed
Y/N Table Edit
Default Value: N
|
| 42 |
APPR_RULE_REQ_AMT |
Character(30) |
VARCHAR2(30) NOT NULL |
Req Amount Approval Rule
Prompt Table:
REQ_APPR_RUL_VW
|
| 43 |
REQ_CF_APPR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Req ChartField Approval Needed
Y/N Table Edit
Default Value: N
|
| 44 |
APPR_RULE_REQ_CF |
Character(30) |
VARCHAR2(30) NOT NULL |
Req ChartField Approval Rule
Prompt Table:
REQ_APPR_RUL_VW
|
| 45 |
ALLOW_MC_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Multicurrency PO
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 46 |
ALLOW_MC_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Multicurrency Reqs
Y/N Table Edit
Default Value: N
|
| 47 |
PCT_UNIT_PRC_TOL |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Unit Price Tolerance
|
| 48 |
RTV_ID_LAST_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last RTV Number
|
| 49 |
RTV_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Return To Vendors
Y/N Table Edit
Default Value: Y
|
| 50 |
MATCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Requires Matching
Y/N Table Edit
Default Value: N
|
| 51 |
MATCH_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Match Rule
Prompt Table:
MTCH_CNTRL_VW1
|
| 52 |
ITEM_BU_ATTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Business Item Attributes
Y/N Table Edit
Default Value: N
|
| 53 |
STD_COMMENT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Comment Type
Prompt Table:
STD_COMM_TYP_PO
Set Control Field: BUSINESS_UNIT
|
| 54 |
STD_COMMENT_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Standard Comment ID
Prompt Table:
STD_COMM_TBL_PO
Set Control Field: BUSINESS_UNIT
|
| 55 |
PO_IMAGE_PATH |
Character(100) |
VARCHAR2(100) NOT NULL |
PO Dispatch Image Location
|
| 56 |
PO_IMAGE_SIG_PATH |
Character(100) |
VARCHAR2(100) NOT NULL |
PO Dispatch Signature Location
|
| 57 |
PRINT_IMAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Image on Purchase Order
Y/N Table Edit
|
| 58 |
PRINT_IMAGE_SIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Signature on PO
Y/N Table Edit
|
| 59 |
RECEIPT_ACCR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Accrual Flag
Y/N Table Edit
|
| 60 |
SEPARATE_INSPECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate Inspection
Y/N Table Edit
Default Value: Y
|
| 61 |
RTV_ADJ_FEES |
Character(1) |
VARCHAR2(1) NOT NULL |
RTV Adjust Fees
Y/N Table Edit
Default Value: N
|
| 62 |
RTV_ADJ_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
RTV Adjust Source
Y/N Table Edit
Default Value: N
|
| 63 |
TMP_PO_LAST_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last PO Number
Default Value: 1
|
| 64 |
RTV_REOPEN_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
RTV Reopen PO Flag
Y/N Table Edit
Default Value: N
|
| 65 |
PCT_UNIT_PRC_TOL_L |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Unit Price Tolerance - Under
|
| 66 |
RECVLOAD_CASCADE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Receipt Load Cascade
Y/N Table Edit
Default Value: N
|
| 67 |
RECEIPT_ALLOC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
F-KDHIL-R87H8 060304 MLM: Added Specify Allocation Type translate value to allow manual allocations for receiving related enhancements.
1=First In First Out
2=Prorate
3=Specify
4=Split Distributions
Default Value: 1
|
| 68 |
NONPO_ACCR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrue Non/PO Receipts
Y/N Table Edit
Default Value: N
|
| 69 |
VAT_APORT_CNTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Apportionment Control
D=Distribution GL Business Unit
G=Transaction GL Business Unit
T=Transaction Business Unit
Default Value: T
|
| 70 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_POVW1
|
| 71 |
DELETE_PO_ALLOWED |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow PO Deletion
Y/N Table Edit
Default Value: N
|
| 72 |
DELETE_REQ_ALLOWED |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Requisition Deletion
Y/N Table Edit
Default Value: N
|
| 73 |
PO_ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
PO Entry Event
Prompt Table:
%EDITTABLE2
|
| 74 |
REQ_ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
REQ Entry Event
Prompt Table:
%EDIT_EE_EVENT
|
| 75 |
CC_ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
PROCARD Entry Event
Prompt Table:
%EDITTABLE3
|
| 76 |
REQ_CHNG_ORD_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Req Change Order Option
A=Approved Requisitions
B=Valid Budget Check
N=No Change Tracking
S=Sourced
Default Value: N
Prompt Table:
%EDIT_CO_OPTION
|
| 77 |
CHNG_TMPLT_ID_REQ |
Character(10) |
VARCHAR2(10) NOT NULL |
Change Template
Prompt Table:
CHNG_TMPLT_TBL
|
| 78 |
PO_POA_AUTOAPPROVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically POA Approve
Default Value: Y
|
| 79 |
AUTOAPPROVE_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
AutoApprove Change Requests
Y/N Table Edit
|
| 80 |
BUSINESS_UNIT_SS |
Character(5) |
VARCHAR2(5) NOT NULL |
Strategic Sourcing BU
Prompt Table:
SP_BU_A1_NONVW
|
| 81 |
ALLOW_CURR_UR |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Curr UOM Conv Rate
Y/N Table Edit
Default Value: N
|
| 82 |
LIQUIDATE_BY_QTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Liquidate by Quantity flag will contain Yes/No value
Y/N Table Edit
Default Value: N
|
| 83 |
LIQUIDATE_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Liquidate by
A=Amount
Q=Quantity
Default Value: A
|
| 84 |
TAX_VENDOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Provider
A=Taxware
N=None
V=Vertex
|
| 85 |
TAX_COMPANY |
Character(5) |
VARCHAR2(5) NOT NULL |
Company for Tax Suppliers
|
| 86 |
TAX_DIVISION |
Character(5) |
VARCHAR2(5) NOT NULL |
Division for Tax Suppliers
|
| 87 |
TAX_VNDR_FRGHT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Freight Product Code
Y/N Table Edit
Default Value: N
|
| 88 |
CALC_ADJ_ON_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate VAT On Req
Y/N Table Edit
Default Value: N
|
| 89 |
RFQ_REQUIRED_LIMIT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Line Amount Threshold
|
| 90 |
RFQ_REQUIRED_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
RFQ Required Rule
Prompt Table:
RFQ_RQUIRE_RULE
|
| 91 |
PO_PRICE_EDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Price Edit
E=Error
N=None
W=Warning
Default Value: W
|
| 92 |
PO_CNT_RECON |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Close Contract Option
E=Error
N=None
W=Warning
Default Value: N
|
| 93 |
CHNG_MAP_TMPLT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Change Template ID
Default Value: EDX
Prompt Table:
CHNG_MAP_TMPLT
|
| 94 |
TAX_DEPARTMENT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department used by Tax Vendors
|
| 95 |
RECV_DT_RATE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Exchange Rate by Receipt Date or PO Date
P=PO Date
R=Receipt Date
Default Value: P
|
| 96 |
RTV_INV_ADJ_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
RTV INV Destroy Option
1=Manual
2=Express
9=Default to Business Unit
|
| 97 |
RTV_INV_SHIP_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
RTV Inv Ship Option
1=Manual
2=Express
3=Fulfillment
9=Default to Business Unit
|
| 98 |
RTV_DISPATCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
RTV Dispatch Option
1=Manual
2=Dispatch When Shipped
3=Dispatched
9=Default to Business Unit
|
| 99 |
NOTIFY_INV_MGR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Notify INV MGR
Default Value: N
|
| 100 |
PO_WF_APPR_RQED |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Workflow Approval Required
Y/N Table Edit
Default Value: N
|
| 101 |
APPR_ON_DECR_RQED |
Character(1) |
VARCHAR2(1) NOT NULL |
Reapprove Required On Decrease
Y/N Table Edit
Default Value: N
|
| 102 |
DFLT_CNTRCT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Contract on PO
Y/N Table Edit
Default Value: N
|
| 103 |
TMPLDEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Template ID (see PSXPTMPLDEFN).
Prompt Table:
PO_XMLP_TMPL_VW
|
| 104 |
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:
UNITS_TBL
|
| 105 |
REQ_APPR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisitoin Approvals Required
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 106 |
REQ_RESUBMIT_DECR |
Character(1) |
VARCHAR2(1) NOT NULL |
Resubmit Requisition
Y/N Table Edit
Default Value: N
|
| 107 |
RESUBMIT_LINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Resubmit Line for Approval
Y/N Table Edit
Default Value: N
|
| 108 |
PO_AF_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Framework Used
Y/N Table Edit
Default Value: N
|
| 109 |
REQ_AF_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Framework Used
Y/N Table Edit
Default Value: N
|
| 110 |
DFLT_CNTRCT_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Contract On Req
Default Value: N
|
| 111 |
MIN_DLV_SIG_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Delivery Signature Required
I=Default to Installation value
N=No
Y=Yes
Default Value: I
|
| 112 |
AII_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
05/09/11 EGS: Created
Prompt Table:
IN_AII_GROUP
|
| 113 |
SPLIT_PO_BY_SHIPTO |
Character(1) |
VARCHAR2(1) NOT NULL |
Split PO by Ship To
B=Default from Higher Level
N=Do Not Split PO by Ship To
Y=Split PO by Ship To
Y/N Table Edit
Default Value: N
|
| 114 |
BU_ITEM_SUB |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Item Substitution
Y/N Table Edit
Default Value: N
|
| 115 |
PO_REQ_M |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisition Selection and PO
Y/N Table Edit
Default Value: N
|
| 116 |
REQ_ITMSUB_M |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisition
Y/N Table Edit
Default Value: N
|
| 117 |
REQ_ITMSUB_A |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisition
Y/N Table Edit
Default Value: N
|
| 118 |
REQ_SELITMS_A |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisition Selection
Y/N Table Edit
Default Value: N
|
| 119 |
PO_SRC_A |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Sourcing and Purchase Order
Y/N Table Edit
Default Value: N
|
| 120 |
DISPLAY_GLN |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow GLN Display
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 121 |
ERROR_MIN_MAX_QTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Error on Min/Max Quantity
N=No
Y=Yes
Default Value: N
|
| 122 |
PO_BEG_SEQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Beginning Sequence
Prompt Table:
PO_AN_VW
|
| 123 |
REQ_BEG_SEQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Beginning Sequence
Prompt Table:
REQ_AN_VW
|
| 124 |
RECV_BEG_SEQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Beginning Sequence
Prompt Table:
RECV_AN_VW
|
| 125 |
RFQ_BEG_SEQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Beginning Sequence
|
| 126 |
RTV_BEG_SEQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Beginning Sequence
Prompt Table:
RTV_AN_VW
|
| 127 |
PO_RULE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
PO Close Short Rule ID
Prompt Table:
PO_CLS_SHT_ID
|
| 128 |
CLS_SHORT_OR |
Character(1) |
VARCHAR2(1) NOT NULL |
Close Short Set Override
Y/N Table Edit
Default Value: N
|
| 129 |
CONS_REQ_CNTRCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Req Consolidation
Default Value: N
|
| 130 |
SRC_INVTY_CNTRCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Source to Inventory
Default Value: N
|
| 131 |
ACCRUE_FEDERAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrue Federal Inventory Rcpt
Y/N Table Edit
Default Value: N
|
| 132 |
PCARD_RQED_LIMIT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Threshold Amount
|
| 133 |
PCARD_REC_RQED |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Required
Y/N Table Edit
|