1. Tables and Views for Financials
  2. AP_PREPAY_DEF_TAX_EXTRACT_V

AP_PREPAY_DEF_TAX_EXTRACT_V

Details

  • Schema: FUSION

  • Object owner: AP

  • Object type: VIEW

Columns

Name

REC_NREC_PP_TAX_DIST_ID

SUMMARY_TAX_PP_LINE_ID

TAX_PP_LINE_ID

TRX_PP_LINE_DIST_ID

RECOVERABLE_PP_FLAG

DEF_REC_PP_SET_OPTION_CODE

TAX_PP_ACCOUNT_CCID

ORG_PP_ID

LEDGER_PP_ID

Query

SQL_Statement

SELECT REC_NREC_TAX_DIST_ID REC_NREC_PP_TAX_DIST_ID,

SUMMARY_TAX_LINE_ID SUMMARY_TAX_PP_LINE_ID,

TAX_LINE_ID TAX_PP_LINE_ID,

TRX_LINE_DIST_ID TRX_PP_LINE_DIST_ID,

RECOVERABLE_FLAG RECOVERABLE_PP_FLAG,

TAX_POINT_BASIS DEF_REC_PP_SET_OPTION_CODE,

TAX_ACCOUNT_CCID TAX_PP_ACCOUNT_CCID,

ORG_ID ORG_PP_ID,

LEDGER_ID LEDGER_PP_ID

FROM ZX_AP_DEF_TAX_EXTRACT_V