1. Tables and Views for Financials
  2. AP_ZX_DEF_TAX_EXTRACT_V

AP_ZX_DEF_TAX_EXTRACT_V

Details

  • Schema: FUSION

  • Object owner: AP

  • Object type: VIEW

Columns

Name

AID_REC_NREC_TAX_DIST_ID

AID_SUMMARY_TAX_LINE_ID

AID_TAX_LINE_ID

AID_TRX_LINE_DIST_ID

AID_RECOVERABLE_FLAG

AID_DEF_REC_SETTLE_OPTION_CODE

AID_TAX_ACCOUNT_CCID

AID_ORG_ID

AID_LEDGER_ID

Query

SQL_Statement

SELECT REC_NREC_TAX_DIST_ID AID_REC_NREC_TAX_DIST_ID,

SUMMARY_TAX_LINE_ID AID_SUMMARY_TAX_LINE_ID,

TAX_LINE_ID AID_TAX_LINE_ID,

TRX_LINE_DIST_ID AID_TRX_LINE_DIST_ID,

RECOVERABLE_FLAG AID_RECOVERABLE_FLAG,

TAX_POINT_BASIS AID_DEF_REC_SETTLE_OPTION_CODE,

TAX_ACCOUNT_CCID AID_TAX_ACCOUNT_CCID,

ORG_ID AID_ORG_ID,

LEDGER_ID AID_LEDGER_ID

FROM ZX_AP_DEF_TAX_EXTRACT_V