Reporting View Target: PURCHASE_ORDER_TAX

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PURCHASE_ORDER_TAX_RATE

Description Contains current tax rates and amounts for each purchase order item. This includes who the tax should be paid to.
Key & Frequency One row per purchase order per item per priority per tax rate.
Recommended Search Columns PURCHASE_ORDER, ITEM, PRIORITY, TAX_RATE

Target Column Business Definition Database Data Type Source Name Source Column

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

ITEM System generated item number that defines this commodity within the purchase order. NUMBER
FPRPOTX

FPRPOTX_ITEM

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

PAY_TAX_TO Indicates who should be paid taxes, always the vendor, vendor if they collect taxes or taxing authority. VARCHAR2(63)
FPRPOTX

FPRPOTX_PAY_TAX_TO

PRIORITY Number used to establish the order in which taxes are to be compounded for a taxed commodity. NUMBER
FPRPOTX

FPRPOTX_PRIORITY_NUM

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

PURCHASE_ORDER User-defined or system assigned one-up purchase order number issued to this vendor. VARCHAR2(63)
FPRPOTX

FPRPOTX_POHD_CODE

TAXABLE_AMOUNT Amount that is multiplied by the tax rate to give tax amount. NUMBER
FPRPOTX

FPRPOTX_TAXABLE_AMT

TAX_AMOUNT Amount of tax computed or entered for a document tax rate. NUMBER
FPRPOTX

FPRPOTX_TAX_AMT

TAX_RATE Code representing the tax rate. VARCHAR2(63)
FPRPOTX

FPRPOTX_TRAT_CODE

TAX_RATE_DESC Tax rate description or title. VARCHAR2(255)
FTVTRAT

FTVTRAT_DESC

Ver: 8.5

Description	Contains current tax rates and amounts for each purchase order item. This includes who the tax should be paid to.
Key & Frequency	One row per purchase order per item per priority per tax rate.
Recommended Search Columns	PURCHASE_ORDER, ITEM, PRIORITY, TAX_RATE

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ITEM	System generated item number that defines this commodity within the purchase order.	NUMBER	FPRPOTX	FPRPOTX_ITEM
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PAY_TAX_TO	Indicates who should be paid taxes, always the vendor, vendor if they collect taxes or taxing authority.	VARCHAR2(63)	FPRPOTX	FPRPOTX_PAY_TAX_TO
PRIORITY	Number used to establish the order in which taxes are to be compounded for a taxed commodity.	NUMBER	FPRPOTX	FPRPOTX_PRIORITY_NUM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PURCHASE_ORDER	User-defined or system assigned one-up purchase order number issued to this vendor.	VARCHAR2(63)	FPRPOTX	FPRPOTX_POHD_CODE
TAXABLE_AMOUNT	Amount that is multiplied by the tax rate to give tax amount.	NUMBER	FPRPOTX	FPRPOTX_TAXABLE_AMT
TAX_AMOUNT	Amount of tax computed or entered for a document tax rate.	NUMBER	FPRPOTX	FPRPOTX_TAX_AMT
TAX_RATE	Code representing the tax rate.	VARCHAR2(63)	FPRPOTX	FPRPOTX_TRAT_CODE
TAX_RATE_DESC	Tax rate description or title.	VARCHAR2(255)	FTVTRAT	FTVTRAT_DESC