描述:预扣/预提税率
Primary Key: AP_AWT_TAX_RATES_PK
- TAX_RATE_ID
Foreign Keys from this table:
Foreign Key Column | Foreign Table |
---|---|
AP_AWT_TAX_RATES_ALL.VENDOR_ID | PO_VENDORS |
AP_AWT_TAX_RATES_ALL.VENDOR_ID AP_AWT_TAX_RATES_ALL.INVOICE_NUM | AP_INVOICES_ALL |
AP_AWT_TAX_RATES_ALL.VENDOR_SITE_ID | PO_VENDOR_SITES_ALL |
Foreign Keys to this table:
Foreign Key Column | Foreign Table |
---|---|
AP_AWT_TEMP_DISTRIBUTIONS_ALL.TAX_RATE_ID | AP_AWT_TAX_RATES_ALL |
AP_INVOICE_DISTRIBUTIONS_ALL.AWT_TAX_RATE_ID | AP_AWT_TAX_RATES_ALL |
AP_AWT_TAX_RATES_ALL |
Comments:
AP_AWT_TAX_RATES_ALL包含预扣税类型的税率。Oracle Payables预先定义了预扣税的标准税率和罚款税率类型。此外,证书率类型分配给特定的供应商站点,而例外率类型分配给特定的发票。START_AMOUNT和END_AMOUNT列仅在父预扣税使用金额范围时使用。