SHIPTO_VNDR_LOC

(SQL Table)
Index Back

Shipto Supplier Priority

Shipto Supplier Priority

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIP_SHIPSET_VW

3 APPLY_ALL_VENDOR Character(1) VARCHAR2(1) NOT NULL Apply All Vendor

Y/N Table Edit

Default Value: N

4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_VW1

6 ORDER_SETID Character(5) VARCHAR2(5) NOT NULL Order Supplier SetID

Prompt Table: SP_SETID_NONVW

7 ORDER_VENDOR Character(10) VARCHAR2(10) NOT NULL Order Supplier ID

Prompt Table: VNDR_ORDR_VW

8 ORDER_LOC Character(10) VARCHAR2(10) NOT NULL Order Location

Prompt Table: VNDR_LOC_ORD_VW

9 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