Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AF_PURCHASE_ORDER_TAX_RATE

Description Source composite view contains cumulative tax rate information for purchase orders.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

 
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined.    

NA

NA

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

FPRPOTX

FPRPOTX_ITEM

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
PAY_TAX_TO Indicates who should be paid taxes, always the vendor, vendor if they collect taxes or taxing authority.    

FPRPOTX

FPRPOTX_PAY_TAX_TO

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

FPRPOTX

FPRPOTX_PRIORITY_NUM

 
PURCHASE_ORDER User-defined or system assigned one-up purchase order number issued to this vendor.    

FPRPOTX

FPRPOTX_POHD_CODE

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

FPRPOTX

FPRPOTX_TAXABLE_AMT

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

FPRPOTX

FPRPOTX_TAX_AMT

 
TAX_RATE Code representing the tax rate.    

FPRPOTX

FPRPOTX_TRAT_CODE

 
TAX_RATE_DESC Tax rate description or title.    

FTVTRAT

FTVTRAT_DESC

 
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 


Ver: 8.3