POBUTBL_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for BUS_UNIT_TBL_PM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 4 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 5 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 6 | BU_PSGL_SW | Character(1) | VARCHAR2(1) NOT NULL | Using PS/GL |
| 7 | PRCS_OPTION_ID | Character(5) | VARCHAR2(5) NOT NULL | Processing Option ID |
| 8 | REQ_NUM_OPTION | Character(1) | VARCHAR2(1) NOT NULL | Requisitions |
| 9 | REQ_ID_LAST_USED | Number(10,0) | DECIMAL(10) NOT NULL | Last Requisition Number |
| 10 | PO_NUM_OPTION | Character(1) | VARCHAR2(1) NOT NULL | Purchase Orders |
| 11 | PO_ID_LAST_USED | Number(10,0) | DECIMAL(10) NOT NULL | Last PO Number |
| 12 | RECV_NUM_OPTION | Character(1) | VARCHAR2(1) NOT NULL | Receivers |
| 13 | RECV_ID_LAST_USED | Number(10,0) | DECIMAL(10) NOT NULL | Last Receiver Number |
| 14 | ADJ_RECV_DATE_NBR | Number(3,0) | SMALLINT NOT NULL | Receipt Date Adjustment |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 16 | 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. |
| 17 | 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 |
| 18 | RFQ_NUM_OPTION | Character(1) | VARCHAR2(1) NOT NULL | Request For Quotes |
| 19 | RFQ_ID_LAST_USED | Number(10,0) | DECIMAL(10) NOT NULL | Last RFQ Number |
| 20 | POST_OPTION | Character(1) | VARCHAR2(1) NOT NULL | Posting Option |
| 21 | 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 |
| 22 | POST_THRU_DT | Date(10) | DATE | Post Thru Date |
| 23 | CLOSE_DELAY_DAYS | Signed Number(6,0) | DECIMAL(5) NOT NULL | Close Processing Delay Days |
| 24 | RCPT_CLOSE_DAYS | Signed Number(6,0) | DECIMAL(5) NOT NULL | Receipt Close Delay Days |
| 25 | CANCEL_DELAY_DAYS | Signed Number(6,0) | DECIMAL(5) NOT NULL | Cancel Days |
| 26 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 27 | BILL_LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Billing Location |
| 28 | DB_NUMBER | Character(9) | VARCHAR2(9) NOT NULL | DUNS Number |
| 29 | CHNG_TMPLT_ID | Character(10) | VARCHAR2(10) NOT NULL | Change Template |
| 30 | FINANCIAL_ASSET_SW | Character(1) | VARCHAR2(1) NOT NULL |
Capitalized Asset
N=Non Cap Y=Capitalize |
| 31 | BUSPROCNAME_PO | Character(30) | VARCHAR2(30) NOT NULL | PO Approval Business Process |
| 32 | PO_AMT_APPR_NEEDED | Character(1) | VARCHAR2(1) NOT NULL | PO Amount Approval Needed |
| 33 | APPR_RULE_PO_AMT | Character(30) | VARCHAR2(30) NOT NULL | PO Amount Approval Rule Set |
| 34 | PO_CF_APPR_NEEDED | Character(1) | VARCHAR2(1) NOT NULL | PO ChartField Approval Needed |
| 35 | APPR_RULE_PO_CF | Character(30) | VARCHAR2(30) NOT NULL | PO ChartField Approval RuleSet |
| 36 | TAX_EXEMPT | Character(1) | VARCHAR2(1) NOT NULL | Tax Exempt Flag |
| 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 |
| 39 | ORIGIN_AP | Character(3) | VARCHAR2(3) NOT NULL | AP Origin ID |
| 40 | BUSPROCNAME_REQ | Character(30) | VARCHAR2(30) NOT NULL | Req Approval Business Process |
| 41 | REQ_AMT_APPR_REQD | Character(1) | VARCHAR2(1) NOT NULL | Req Amount Approval Needed |
| 42 | APPR_RULE_REQ_AMT | Character(30) | VARCHAR2(30) NOT NULL | Req Amount Approval Rule |
| 43 | REQ_CF_APPR_REQD | Character(1) | VARCHAR2(1) NOT NULL | Req ChartField Approval Needed |
| 44 | APPR_RULE_REQ_CF | Character(30) | VARCHAR2(30) NOT NULL | Req ChartField Approval Rule |
| 45 | ALLOW_MC_PO | Character(1) | VARCHAR2(1) NOT NULL |
Allow Multicurrency PO
N=No Y=Yes |
| 46 | ALLOW_MC_REQ | Character(1) | VARCHAR2(1) NOT NULL | Allow Multicurrency Reqs |
| 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 |
| 50 | MATCH_OPT | Character(1) | VARCHAR2(1) NOT NULL | Requires Matching |
| 51 | MATCH_CNTRL_ID | Character(10) | VARCHAR2(10) NOT NULL | Match Rule |
| 52 | ITEM_BU_ATTR | Character(1) | VARCHAR2(1) NOT NULL | Allow Business Item Attributes |
| 53 | STD_COMMENT_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Standard Comment Type |
| 54 | STD_COMMENT_ID | Character(4) | VARCHAR2(4) NOT NULL | Standard Comment ID |
| 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 |
| 58 | PRINT_IMAGE_SIG | Character(1) | VARCHAR2(1) NOT NULL | Print Signature on PO |
| 59 | RECEIPT_ACCR_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Receipt Accrual Flag |
| 60 | SEPARATE_INSPECT | Character(1) | VARCHAR2(1) NOT NULL | Separate Inspection |
| 61 | RTV_ADJ_FEES | Character(1) | VARCHAR2(1) NOT NULL | RTV Adjust Fees |
| 62 | RTV_ADJ_SOURCE | Character(1) | VARCHAR2(1) NOT NULL | RTV Adjust Source |
| 63 | TMP_PO_LAST_USED | Number(10,0) | DECIMAL(10) NOT NULL | Last PO Number |
| 64 | RTV_REOPEN_PO | Character(1) | VARCHAR2(1) NOT NULL | RTV Reopen PO Flag |
| 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 |
| 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 |
| 68 | NONPO_ACCR_FLAG | Character(1) | VARCHAR2(1) NOT NULL | ACCRUE NON/PO RECEIPTS |
| 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 |
| 70 | DELETE_PO_ALLOWED | Character(1) | VARCHAR2(1) NOT NULL | Allow PO Deletion |
| 71 | DELETE_REQ_ALLOWED | Character(1) | VARCHAR2(1) NOT NULL | Allow Requisition Deletion |
| 72 | PO_ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL | PO Entry Event |
| 73 | REQ_ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL | REQ Entry Event |
| 74 | CC_ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL | PROCARD Entry Event |
| 75 | 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 |
| 76 | CHNG_TMPLT_ID_REQ | Character(10) | VARCHAR2(10) NOT NULL | Change Template |
| 77 | PO_POA_AUTOAPPROVE | Character(1) | VARCHAR2(1) NOT NULL | Automatically POA Approve |
| 78 | AUTOAPPROVE_CHNG | Character(1) | VARCHAR2(1) NOT NULL |
AutoApprove Change Requests
Y/N Table Edit |
| 79 | BUSINESS_UNIT_SS | Character(5) | VARCHAR2(5) NOT NULL |
Strategic Sourcing BU
Prompt Table: SP_BU_A1_NONVW |
| 80 | ALLOW_CURR_UR | Character(1) | VARCHAR2(1) NOT NULL |
Allow Curr UOM Conv Rate
Y/N Table Edit Default Value: N |
| 81 | 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 |
| 82 | LIQUIDATE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Liquidate by
A=Amount Q=Quantity Default Value: A |
| 83 | TAX_VENDOR | Character(1) | VARCHAR2(1) NOT NULL |
Tax Provider
A=Taxware N=None V=Vertex |
| 84 | TAX_COMPANY | Character(5) | VARCHAR2(5) NOT NULL | Company for Tax Suppliers |
| 85 | TAX_DIVISION | Character(5) | VARCHAR2(5) NOT NULL | Division for Tax Suppliers |
| 86 | TAX_VNDR_FRGHT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Use Freight Product Code
Y/N Table Edit Default Value: N |
| 87 | CALC_ADJ_ON_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Calculate VAT On Req
Y/N Table Edit Default Value: N |
| 88 | RFQ_REQUIRED_LIMIT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Line Amount Threshold |
| 89 | RFQ_REQUIRED_RULE | Character(10) | VARCHAR2(10) NOT NULL |
RFQ Required Rule
Prompt Table: RFQ_RQUIRE_RULE |
| 90 | PO_PRICE_EDIT | Character(1) | VARCHAR2(1) NOT NULL |
PO Price Edit
E=Error N=None W=Warning Default Value: W |
| 91 | CHNG_MAP_TMPLT_ID | Character(10) | VARCHAR2(10) NOT NULL |
Change Template ID
Default Value: EDX Prompt Table: CHNG_MAP_TMPLT |
| 92 | TAX_DEPARTMENT | Character(5) | VARCHAR2(5) NOT NULL | Department used by Tax Vendors |
| 93 | RECV_DT_RATE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Exchange Rate by Receipt Date or PO Date
P=PO Date R=Receipt Date |
| 94 | RTV_INV_ADJ_OPT | Character(1) | VARCHAR2(1) NOT NULL |
RTV INV Destroy Option
1=Manual 2=Express 9=Default to Business Unit |
| 95 | 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 |
| 96 | 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 |
| 97 | NOTIFY_INV_MGR_FLG | Character(1) | VARCHAR2(1) NOT NULL | Notify INV MGR |
| 98 | PO_WF_APPR_RQED | Character(1) | VARCHAR2(1) NOT NULL | PO Workflow Approval Required |
| 99 | APPR_ON_DECR_RQED | Character(1) | VARCHAR2(1) NOT NULL | Reapprove Required On Decrease |
| 100 | DFLT_CNTRCT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Default Contract on PO
Y/N Table Edit Default Value: N |
| 101 | TMPLDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Template ID (see PSXPTMPLDEFN). |
| 102 | REQ_APPR_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Requisitoin Approvals Required
N=No Y=Yes Y/N Table Edit Default Value: N |
| 103 | REQ_RESUBMIT_DECR | Character(1) | VARCHAR2(1) NOT NULL |
Resubmit Requisition
Y/N Table Edit Default Value: N |
| 104 | RESUBMIT_LINE | Character(1) | VARCHAR2(1) NOT NULL |
Resubmit Line for Approval
Y/N Table Edit Default Value: N |
| 105 | PO_AF_USED | Character(1) | VARCHAR2(1) NOT NULL |
Approval Framework Used
Y/N Table Edit Default Value: N |
| 106 | REQ_AF_USED | Character(1) | VARCHAR2(1) NOT NULL | Approval Framework Used |
| 107 | DFLT_CNTRCT_REQ | Character(1) | VARCHAR2(1) NOT NULL | Default Contract On Req |
| 108 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 109 | 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 |
| 110 | DISPLAY_GLN | Character(1) | VARCHAR2(1) NOT NULL |
Allow GLN Display
N=No Y=Yes |
| 111 | BU_ITEM_SUB | Character(1) | VARCHAR2(1) NOT NULL |
Enable Item Substitution
Y/N Table Edit |
| 112 | PO_REQ_M | Character(1) | VARCHAR2(1) NOT NULL |
Requisition Selection and PO
Y/N Table Edit |
| 113 | REQ_ITMSUB_M | Character(1) | VARCHAR2(1) NOT NULL |
Requisition
Y/N Table Edit |
| 114 | REQ_ITMSUB_A | Character(1) | VARCHAR2(1) NOT NULL |
Requisition
Y/N Table Edit |
| 115 | REQ_SELITMS_A | Character(1) | VARCHAR2(1) NOT NULL |
Requisition Selection
Y/N Table Edit |
| 116 | PO_SRC_A | Character(1) | VARCHAR2(1) NOT NULL |
PO Sourcing and Purchase Order
Y/N Table Edit |
| 117 | CATEGORY_CD | Character(18) | VARCHAR2(18) NOT NULL | Category Code |
| 118 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 119 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 120 | MIN_DLV_SIG_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Delivery Signature Required
I=Default to Installation value N=No Y=Yes |
| 121 | ERROR_MIN_MAX_QTY | Character(1) | VARCHAR2(1) NOT NULL |
Error on Min/Max Quantity
N=No Y=Yes |
| 122 | PO_RULE_ID | Character(10) | VARCHAR2(10) NOT NULL | PO Close Short Rule ID |
| 123 | CLS_SHORT_OR | Character(1) | VARCHAR2(1) NOT NULL | Close Short Set Override |
| 124 | CONS_REQ_CNTRCT | Character(1) | VARCHAR2(1) NOT NULL | Allow Req Consolidation |
| 125 | SRC_INVTY_CNTRCT | Character(1) | VARCHAR2(1) NOT NULL | Allow Source to Inventory |
| 126 | ACCRUE_FEDERAL | Character(1) | VARCHAR2(1) NOT NULL |
Accrue Federal Inventory Rcpt
Y/N Table Edit Default Value: N |
| 127 | PCARD_REC_RQED | Character(1) | VARCHAR2(1) NOT NULL | Receipt Required |
| 128 | PCARD_RQED_LIMIT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Threshold Amount |