VENDOR_LOC_TEO3(SQL Table) |
Index Back |
|---|---|
Supplier Location |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 3 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 5 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 8 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: RT_TYPE_TBL |
| 9 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table: FREIGHT_TERMS |
| 10 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table: SHIP_METHOD |
| 11 | DISP_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Dispatch Method
EDX=Electronic Document Exchange EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print |
| 12 | 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.
Prompt Table: PYMT_TR_EFF_VW |
| 13 | MATCH_OPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Newly added for R-JMACIA-NQ66A
D=Default from Higher Level S=Specified Default Value: D |
| 14 | MATCH_CNTRL_ID | Character(10) | VARCHAR2(10) NOT NULL |
Match Rule
Prompt Table: MTCH_CNTRL_VW1 |
| 15 | MATCH_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Requires Matching
Y/N Table Edit Default Value: N |
| 16 | ERS_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
ERS Action
N=No Y=Yes Default Value: N |
| 17 | ERS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Eval Rcpt Settlement
Y/N Table Edit Default Value: N |
| 18 | VCHR_APPRVL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Voucher Approval Flag
D=Default from Higher Level P=Pre-Approved S=Virtual Approver W=Approval Framework Default Value: D |
| 19 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table: BUSPROCNAME_VW |
| 20 | APPR_RULE_SET | Character(30) | VARCHAR2(30) NOT NULL |
Approval Rule Set
Prompt Table: APPR_RULE_HDR |
| 21 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL |
Buyer
Prompt Table: BUYER_TBL_FS |
| 22 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Remit SetID
Prompt Table: SETID_TBL |
| 23 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL |
Remit Vendor
Prompt Table: VNDR_RETURN_VW |
| 24 | REMIT_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Remit to Location
Prompt Table: VNDR_REM_LOC_VW |
| 25 | REMIT_ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Remitting Location
Default Value: 1 Prompt Table: VNDR_REMADDR_VW |
| 26 | ADDR_SEQ_NUM_ORDR | Number(5,0) | INTEGER NOT NULL |
Ordering Location
Default Value: 1 Prompt Table: VNDR_ORDADDR_VW |
| 27 | PRICE_SETID | Character(5) | VARCHAR2(5) NOT NULL | Price From Vendor SetID |
| 28 | PRICE_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Price Vendor ID |
| 29 | PRICE_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Price from Location
Prompt Table: VNDR_LOC_VW |
| 30 | RETURN_VENDOR | Character(10) | VARCHAR2(10) NOT NULL |
Return to Vendor
Prompt Table: VNDR_RETURN_VW |
| 31 | RET_ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Return to Address
Default Value: 1 Prompt Table: VNDR_RETADDR_VW |
| 32 | DST_CNTRL_ID | Character(10) | VARCHAR2(10) NOT NULL |
Accounting Template
Prompt Table: DST_CNTRL_TBL |
| 33 | PREFERRED_LANGUAGE | Character(3) | VARCHAR2(3) NOT NULL |
Preferred Language
ARA=Arabic CFR=Canadian French CZE=Czech DAN=Danish DUT=Dutch E=English ENG=English ESP=Spanish F=French FIN=Finnish FRA=French GER=German HUN=Hungarian INE=International English ITA=Italian JPN=Japanese KOR=Korean NOR=Norwegian POL=Polish POR=Portuguese RUS=Russian SVE=Swedish THA=Thai UKE=UK English ZHS=Simplified Chinese ZHT=Traditional Chinese |
| 34 | RFQ_DISP_MTHD | Character(3) | VARCHAR2(3) NOT NULL |
RFQ Dispatch Method
EDX=Electronic Document Exchange EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print |
| 35 | CNTRCT_DISP_MTHD | Character(3) | VARCHAR2(3) NOT NULL |
Contract Dispatch Method
EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print |
| 36 | PRIMARY_VENDOR | Character(10) | VARCHAR2(10) NOT NULL |
Primary Supplier
Prompt Table: VNDR_RETURN_VW |
| 37 | PRIM_ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Invoicing Location
Default Value: 1 Prompt Table: VNDR_INVADDR_VW |
| 38 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table: SHIPTO_VW |
| 39 | SUT_BASE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Sales/Use Tax Destination
Prompt Table: SHIPTO_TBL |
| 40 | SALETX_TOL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Tolerance Amount |
| 41 | SALETX_TOL_CUR_CD | Character(3) | VARCHAR2(3) NOT NULL |
Sales Tax Tolerance Curr Code
Prompt Table: CURRENCY_CD_TBL |
| 42 | SALETX_TOL_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Sales Tax Tolerance Percent |
| 43 | SALETX_TOL_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Sales Tax Tolerance Rate Type
Prompt Table: RT_TYPE_TBL |
| 44 | SALETX_CD_ERS | Character(8) | VARCHAR2(8) NOT NULL |
ERS Sales Tax Cd
Prompt Table: TAX_USE_VW |
| 45 | SALES_USE_TX_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Sales/Use Tax Code
N=Non Taxable S=Sales Tax U=Use Tax Default Value: N |
| 46 | AUTO_ASN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Advanced Shipment Notification
Y/N Table Edit Default Value: N |
| 47 | SALETX_TOL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Sales Tax Tolerance Flag
D=Default from Higher Level S=Specify at this Level Default Value: D |
| 48 | SHIP_LOC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Ship To/End Location Flag
D=Default from Higher Level S=Specify at this Level Default Value: D |
| 49 | WTHD_CD | Character(5) | VARCHAR2(5) NOT NULL |
Withholding Code
Prompt Table: WTHD_CD_VNDR_VW |
| 50 | WTHD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Withholding Applicable Flag
B=Global and 1099 G=Global T=1099 Y/N Table Edit Default Value: N |
| 51 | DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table: DOC_TYPE_TBL |
| 52 | DOC_TYPE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Document Type Flag
D=Default from Higher Level S=Specify at This level Default Value: D |
| 53 | RTV_DISPATCH_METH | Character(3) | VARCHAR2(3) NOT NULL |
RTV Dispatch Method
EDX=Electronic Document Exchange EML=Electronic Mail FAX=Fax Transmission PHN=Phone PRN=Print |
| 54 | RTV_NOTIFY_METH | Character(3) | VARCHAR2(3) NOT NULL |
RTV Notification Method
EML=Electronic Mail PHN=Phone Default Value: PHN |
| 55 | RTV_DEBIT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Return To Vendor Debit Memo Option
D=Default N=No Y=Yes Default Value: D |
| 56 | VNDR_SBI_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow SBI
Y/N Table Edit Default Value: N |
| 57 | SBI_APPROVAL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
SBI Approval Option
A=Approved U=Unapproved Default Value: A |
| 58 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL |
Account
Prompt Table: %EDIT_ACCOUNT |
| 59 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table: %EDIT_ALTACCT |
| 60 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPTID_BUGL_VW |
| 61 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW |
| 62 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table: PRODUCT_BUGL_VW |
| 63 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: FUND_BUGL_VW |
| 64 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL |
Class Field
Prompt Table: CLASSCF_BUGL_VW |
| 65 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW |
| 66 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table: BUD_REF_BUGL_VW |
| 67 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table: AFFILIATE_VW |
| 68 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01 |
| 69 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02 |
| 70 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table: CF1_BUGL_VW |
| 71 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW |
| 72 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW |
| 73 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 74 | CONSIGNED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Consigned Flag
Y/N Table Edit Default Value: N |
| 75 | VCHR_CONSIGN_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Consigned Voucher Option
A=Automatic Creation M=Manual Creation S=Stage Pending Voucher |
| 76 | BANK_ACCT_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Bank Account Sequence Number |
| 77 | ACCT_TEMPL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Accounting Template
D=Default from Higher Level S=Specify at this Level Default Value: D |
| 78 | PAY_TRM_BSE_DT_DFT | Character(1) | VARCHAR2(1) NOT NULL |
Payment Terms Basis Date Type
A=Accounting Date C=Constructive Doc Receipt Date D=Default from Higher Level I=Invoice Date R=Receipt Date S=Ship Date U=User Specified Date Default Value: D |
| 79 | RECV_ONLY_MTCH_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Receipt Only Match
Y/N Table Edit Default Value: N |
| 80 | VCHR_MTCH_ADJ_DFLT | Character(1) | VARCHAR2(1) NOT NULL |
Match Adjustments
A=Automatic D=Default N=None S=Stage to Pending File Default Value: D |
| 81 | ERS_INV_DT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
ERS Invoice Date Option
F=Frt Terms R=Recv Date |
| 82 | ERS_INV_DT_DFLT | Character(1) | VARCHAR2(1) NOT NULL |
ERS Invoice Date
D=Default from Higher Level F=Freight Terms R=Receipt Date Default Value: D |
| 83 | ERS_TAX_TYPE_DFLT | Character(1) | VARCHAR2(1) NOT NULL |
ERS Tax Type
B=Sales Tax D=Default from Higher Level N=No Taxes U=Use Tax V=Value Added Tax Default Value: D |
| 84 | ERS_TAX_CD_OPT | Character(1) | VARCHAR2(1) NOT NULL |
ERS Sale Tax Code Override
D=Default from Ship To S=Specify Default Value: D |
| 85 | LAST_SBI_NUM | Number(10,0) | DECIMAL(10) NOT NULL |
Last SBI Number Used
Default Value: 0 |
| 86 | SBI_DOC_DFLT | Character(1) | VARCHAR2(1) NOT NULL |
SBI Numbering Option
D=Default from Higher Level G=Group Vouchers (Auto-Num) I=Individual Voucher (Auto-Num) P=Individual Vchr-Invoice Number Default Value: D |
| 87 | SBI_PRINT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
SBI Printing Options, Default = 'B'
B=Print Report and Files F=Print SBI File Only R=Print Report Only Default Value: B |
| 88 | VCHR_TAX_ADJ_DFT | Character(1) | VARCHAR2(1) NOT NULL |
Sales and Use Tax Adjustments
A=Automatic D=Default N=None S=Stage to Pending File Default Value: D |
| 89 | RTV_VCHR_ADJ_DFLT | Character(1) | VARCHAR2(1) NOT NULL |
RTV Adjustment Option
A=Automatic Adjustment D=Default N=None S=Stage to Pending File Default Value: D |
| 90 | VAT_SUSPENSION_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Use VAT Suspension
Y/N Table Edit Default Value: N |
| 91 | VAT_ROUND_RULE | Character(1) | VARCHAR2(1) NOT NULL |
" Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down N=Natural Round U=Round Up |
| 92 | REPL_DISP_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
repl_disp_method
EDX=Electronic Document Exchange EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print Default Value: PRN |
| 93 | VNDR_UPN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Vendor Universal Product Number Ready Flag
Y/N Table Edit Default Value: N |
| 94 | COMMENTS_2000 | Long Character | CLOB | Comment Text |
| 95 | DISP_CO_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Dispatch Change Orders
N=No Y=Yes |
| 96 | DATE_CALC_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
Date Calculation Basis
A=Agricultural Commodities D=Dairy M=Meat O=Poultry P=Prompt Pay Basis 7 Days Q=Prompt Pay Basis 14 Days |
| 97 | PAY_SCHEDULE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Pay Schedule Type
MAN=Manual OTH=Other Non Transportation TRN=Transportation |
| 98 | FEDERAL_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Federal Vendor Information
Y/N Table Edit |
| 99 | TRADING_PARTNER | Character(6) | VARCHAR2(6) NOT NULL | Trading Partner Code |
| 100 | ALC | Character(8) | VARCHAR2(8) NOT NULL |
Agency Location Code
Prompt Table: AGENCY_LOC_CD |
| 101 | WORKFLOW_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Used to determine workflow defaulting.
D=Default S=Specify Default Value: D |
| 102 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 103 | VAT_SVC_PERFRM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Where VAT Services Physically Performed Flag
1=Ship To Location 2=Ship From Location 3=Buyer's Location 4=Supplier's Location |
| 104 | ULTIMATE_USE_CD | Character(8) | VARCHAR2(8) NOT NULL |
Ultimate Use Code
Prompt Table: SUT_USE_CD |
| 105 | ADDR_SEQ_NUM_SHFR | Number(5,0) | INTEGER NOT NULL |
Ship From Address
Default Value: 1 Prompt Table: VNDR_SHFADDR_VW |
| 106 | POA_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Field to store whether a not a Purchase Order Ack is required. (stored at PO BU and Vendor Loc level)
D=Default to PO BU Settings N=POA NOT Required Y=POA Required Default Value: D |
| 107 | ACK_ALERT_DISP | Number(3,0) | SMALLINT NOT NULL |
Stores # of days after a PO dispatch that a POA should be recieved. Used in POA Alerts
Default Value: 999 |
| 108 | ACK_ALERT_SHIP | Number(3,0) | SMALLINT NOT NULL |
Stores # of days prior to shipment that a POA should be recieved. Used in POA Alerts
Default Value: 999 |
| 109 | POA_CO_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
field to store if a poa is required after a change order.
Y/N Table Edit Default Value: N |
| 110 | POA_TOL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
poa tolerances default
D=Use Tolerances at BU Level S=Tolerances Specified here Default Value: D |
| 111 | POA_SCHED_EARLY | Number(3,0) | SMALLINT NOT NULL |
POA tolerance field for days schedule change can be moved before original schedule date
Default Value: 999 |
| 112 | POA_SCHED_LATE | Number(3,0) | SMALLINT NOT NULL |
POA tolerance field for days schedule change can be moved after original schedule date
Default Value: 999 |
| 113 | POA_QTY_OVER | Number(3,0) | SMALLINT NOT NULL |
POA tolerance field for %qty change can be over
Default Value: 999 |
| 114 | POA_QTY_UNDER | Number(3,0) | SMALLINT NOT NULL |
POA tolerance field for %qty change can be under
Default Value: 999 |
| 115 | POA_PRICE_OVER | Number(3,0) | SMALLINT NOT NULL |
POA tolerance field for %price change can be over
Default Value: 999 |
| 116 | POA_PRICE_UNDER | Number(3,0) | SMALLINT NOT NULL |
POA tolerance field for %price change can be under
Default Value: 999 |
| 117 | CC_ACCEPT_CC | Character(1) | VARCHAR2(1) NOT NULL |
Accept Procurement Card
Y/N Table Edit Default Value: N |
| 118 | CC_DISP_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
ProCard Dispatch Option
A=Default B=Include Masked Card Info C=Contact Buyer D=Contact Cardholder E=Charge to Card on File F=No Reference Default Value: A |
| 119 | CC_ALLOW_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Override Vendor Card
Y/N Table Edit Default Value: N |
| 120 | CC_SECURITY_ID | Number(10,0) | DECIMAL(10) NOT NULL | Procurement Card Number |
| 121 | CC_USE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use Procurement Card
Y/N Table Edit Default Value: N |
| 122 | MATCH_DELAY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
To indicate whether Match Delay Days is specified at this level or to be defaulted from higher level in the AP defaulting hierarchy.
D=Default from Higher Level S=Specified at This Level Default Value: D |
| 123 | MATCH_DELAY_DAYS | Number(3,0) | SMALLINT NOT NULL | Match Delay Days |
| 124 | DISBURSING_OFFICE | Character(5) | VARCHAR2(5) NOT NULL | Field used by Payables |
| 125 | GEN_1099_RPT | Character(1) | VARCHAR2(1) NOT NULL | Generate 1099 Report |
| 126 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 127 | 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 |
| 128 | SPEEDCHART_KEY | Character(10) | VARCHAR2(10) NOT NULL | SpeedChart Key |