SUT_FRGHT_XRFD

(SQL Table)
Index Back

Tax Supplier Freight Prod Xref

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TAX_VENDOR Character(1) VARCHAR2(1) NOT NULL Tax Provider
A=Taxware
N=None
V=Vertex
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

3 SORT_SEQ_NUM Character(1) VARCHAR2(1) NOT NULL Sort Sequence Number

Default Value: 0

4 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: SHIP_METHOD

5 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: FREIGHT_TERMS

6 SUT_PRODUCT_CD Character(18) VARCHAR2(18) NOT NULL Product Alias
7 SUT_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Applicablility
D=Taxable - Direct Pay
E=Exempt
T=Taxable
X=Exoneration Certificate

Default Value: Y