Wednesday, 12 July 2017

Tax Tables for GST in Oracle Apps r12


Table Name Description
JAI_REGIMES (JAI_REGIMES_V) Regime Details
JAI_TAX_ROUNDING (JAI_TAX_ROUNDING_V) Rounding off Details
for the Regime
JAI_TAX_TYPES (JAI_TAX_TYPES_V) Tax Type Details
JAI_TAX_RATES (JAI_TAX_RATES_V) Tax Rate Details (Header)
JAI_TAX_RATE_DETAILS (JAI_TAX_RATE_DETAILS_V) Tax Rate Details (Line)
JAI_TAX_ACCOUNTS
(JAI_TAX_ACCOUNTS_V)
Accounts (Liability, Recovery,
Expense,
Rounding, Expense)
attached to Tax  Type
JAI_TAX_CATEGORIES (JAI_TAX_CATEGORIES_V) Tax Categories Details (Header)
JAI_TAX_CATEGORY_LINES (JAI_TAX_CATEGORY_LINES_V) Tax Categories Details (Line)
JAI_TAX_RULES (JAI_TAX_RULES_V) Tax Rules Details (Header)
JAI_TAX_RULE_LINES
(JAI_TAX_RULE_LINES_V)
Tax Rules Details (Line)
JAI_TAX_CONFIGURATIONS
(JAI_TAX_CONFIGURATIONS_V)
Tax Common Configuration Details like:
Create Pre Validated TDS Invoice
or Credit Memo flag
Create Pre Approved TDS Invoice
or Credit Memo flag
JAI_TAX_DEFAULTING_BASIS (JAI_TAX_DEFAULTING_BASIS_V) Tax (Transaction or Withholding)
defaulting details.
REGIME_TYPE values
 (T - Transaction Tax)
 (W- Withholding Tax)
JAI_PARTY_REGS (JAI_PARTY_REGS_V) Party Registration Details (Header)
JAI_PARTY_REG_LINES  (JAI_PARTY_REG_LINES_V) Party Registration Details (Line):
Primary Registration Name
Primary Registration Number
Secondary Registration Name
Secondary Registration Number
JAI_AP_TDS_THHOLD_HDRS Withholding Tax Threshold values:
Regime
Vendor Type
Section 
JAI_AP_TDS_THHOLD_TYPE_SLABS  Threshhold types
JAI_AP_TDS_THHOLD_TAXES  Taxes
JAI_TAX_LINES_ALL Transaction Tax Details
Like PO, Receipt, AP

1 comment: