[Home] [Help]
[Dependency Information]
Object Name: | AP_PAYMENT_EXTRACT_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() ![]() |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ID | NUMBER | (15) | Yes | |
APHD_PAY_DIST_LOOKUP_CODE | VARCHAR2 | (30) | Yes | |
LINE_NUMBER | NUMBER | (15) | Yes | |
DIST_ACCOUNT_REVERSAL_OPTION | VARCHAR2 | (1) | ||
APHD_REV_PAY_HIST_DIST_ID | NUMBER | (15) | ||
THIRD_PARTY_TYPE | CHAR | (1) | ||
AI_INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
APHD_REVERSAL_FLAG | VARCHAR2 | (1) | ||
APHD_AMOUNT | NUMBER | Yes | ||
APHD_BANK_CURR_AMOUNT | NUMBER | |||
APHD_HISTORICAL_FLAG | VARCHAR2 | (1) | ||
APHD_INVOICE_DIST_BASE_AMT | NUMBER | |||
APHD_PAYMENT_HIST_DIST_ID | NUMBER | (15) | Yes | |
APHD_INVOICE_DISTRIBUTION_ID | NUMBER | (15) | Yes | |
APHD_PAYMENT_HISTORY_ID | NUMBER | (15) | Yes | |
APHD_INVOICE_PAYMENT_ID | NUMBER | (15) | Yes | |
INV_PMT_BASE_AMT_DIFF | NUMBER | |||
PMT_MAT_BASE_AMT_DIFF | NUMBER | |||
MAT_CLR_BASE_AMT_DIFF | NUMBER | |||
PMT_CLR_BASE_AMT_DIFF | NUMBER | |||
INV_CLR_BASE_AMT_DIFF | NUMBER | |||
AIP_ACCOUNTING_DATE | DATE | Yes | ||
AIP_AMOUNT | NUMBER | Yes | ||
AIP_INVOICE_ID | NUMBER | (15) | Yes | |
AIP_INVOICE_PAYMENT_ID | NUMBER | (15) | Yes | |
AIP_PAYMENT_NUM | NUMBER | (15) | Yes | |
AIP_PERIOD_NAME | VARCHAR2 | (15) | Yes | |
AIP_ACCTS_PAY_CCID | NUMBER | (15) | ||
AIP_ASSET_CCID | NUMBER | (15) | ||
AIP_ATTRIBUTE1 | VARCHAR2 | (150) | ||
AIP_ATTRIBUTE10 | VARCHAR2 | (150) | ||
AIP_ATTRIBUTE11 | VARCHAR2 | (150) | ||
AIP_ATTRIBUTE12 | VARCHAR2 | (150) | ||
AIP_ATTRIBUTE13 | VARCHAR2 | (150) | ||
AIP_ATTRIBUTE14 | VARCHAR2 | (150) | ||
AIP_ATTRIBUTE15 | VARCHAR2 | (150) | ||
AIP_ATTRIBUTE2 | VARCHAR2 | (150) | ||
AIP_ATTRIBUTE3 | VARCHAR2 | (150) | ||
AIP_ATTRIBUTE4 | VARCHAR2 | (150) | ||
AIP_ATTRIBUTE5 | VARCHAR2 | (150) | ||
AIP_ATTRIBUTE6 | VARCHAR2 | (150) | ||
AIP_ATTRIBUTE7 | VARCHAR2 | (150) | ||
AIP_ATTRIBUTE8 | VARCHAR2 | (150) | ||
AIP_ATTRIBUTE9 | VARCHAR2 | (150) | ||
AIP_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
AIP_INVOICE_PAYMENT_TYPE | VARCHAR2 | (25) | ||
AIP_GLOBAL_ATTRIBUTE_CAT | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | ||
AIP_GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | ||
AIP_EXTERNAL_BANK_ACCOUNT_ID | NUMBER | (15) | ||
AIP_ACCOUNTING_EVENT_ID | NUMBER | (15) | ||
AIP_REVERSAL_FLAG | VARCHAR2 | (1) | ||
AIP_REVERSAL_INV_PMT_ID | NUMBER | (15) | ||
AID_DIST_CCID | NUMBER | (15) | Yes | |
AID_AMOUNT | NUMBER | |||
AID_AWT_FLAG | VARCHAR2 | (1) | ||
AID_LINE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Yes | |
AID_DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | Yes | |
AWTG_NAME | VARCHAR2 | (25) | ||
AID_AWARD_ID | NUMBER | (15) | ||
AID_RATE_VAR_CCID | NUMBER | (15) | ||
AID_INVOICE_DIST_ID | NUMBER | (15) | Yes | |
AID_INCOME_TAX_REGION | VARCHAR2 | (10) | ||
AWT_AT_PMT_TIME | VARCHAR2 | (1) | ||
AID_MERCHANT_DOCUMENT_NUMBER | VARCHAR2 | (80) | ||
AID_MERCHANT_REFERENCE | VARCHAR2 | (240) | ||
AID_MERCHANT_TAXPAYER_ID | VARCHAR2 | (80) | ||
AID_MERCHANT_TAX_REG_NUMBER | VARCHAR2 | (80) | ||
AI_INVOICE_AMOUNT | NUMBER | |||
AI_ACCTS_PAY_CCID | NUMBER | (15) | ||
DISTRIBUTION_LINK_TYPE | CHAR | (11) | ||
PO_DISTRIBUTION_ID | NUMBER | (15) | ||
AWT_RELATED_DIST_ACCOUNT | NUMBER | (15) | ||
AI_INVOICE_DATE | DATE | |||
AI_INVOICE_TYPE_PAID | VARCHAR2 | (25) | ||
INV_DISCOUNT_AMOUNT_TAKEN | NUMBER | |||
LEDGER_ID | NUMBER | (15) | Yes | |
INV_EXCHANGE_DATE | DATE | |||
INV_EXCHANGE_RATE | NUMBER | |||
INV_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
APHD_INVOICE_DIST_AMOUNT | NUMBER | |||
APHD_CLEARING_BASE_AMT | NUMBER | |||
APHD_INVOICE_BASE_AMT | NUMBER | |||
APHD_MATURED_BASE_AMOUNT | NUMBER | |||
APHD_PAYMENT_BASE_AMT | NUMBER | |||
INV_PMT_GAIN_LOSS_INDICATOR | CHAR | (4) | ||
INV_CLR_GAIN_LOSS_INDICATOR | CHAR | (4) | ||
PMT_MAT_GAIN_LOSS_INDICATOR | CHAR | (4) | ||
MAT_CLR_GAIN_LOSS_INDICATOR | CHAR | (4) | ||
PMT_CLR_GAIN_LOSS_INDICATOR | CHAR | (4) | ||
APHD_ROUNDING_AMT | NUMBER | |||
APHD_PMT_BASE_NO_ROUND | NUMBER | |||
APHD_CLEAR_BASE_AMT_NO_ROUND | NUMBER | |||
APHD_MAT_BASE_AMT_NO_ROUND | NUMBER | |||
BUS_FLOW_AP_APP_ID | NUMBER | |||
BUS_FLOW_INV_DIST_TYPE | CHAR | (11) | ||
BUS_FLOW_INV_ENTITY_CODE | CHAR | (11) | ||
BUS_FLOW_INV_DIST_ID | NUMBER | |||
BUS_FLOW_INV_ID | NUMBER | (15) | Yes | |
BUS_FLOW_PO_APP_ID | NUMBER | |||
BUS_FLOW_PO_DIST_TYPE | CHAR | (7) | ||
BUS_FLOW_PO_ENTITY_CODE | CHAR | (14) | ||
BUS_FLOW_PAYMENT_DIST_TYPE | CHAR | (11) | ||
BUS_FLOW_PAYMENT_ENTITY_CODE | CHAR | (11) | ||
BUS_FLOW_PAYMENT_DIST_ID | NUMBER | |||
BUS_FLOW_PAYMENT_ID | NUMBER | (15) | Yes | |
AID_PROJECT_ID | NUMBER | (15) | ||
AID_TASK_ID | NUMBER | (15) | ||
AID_EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
AID_EXPENDITURE_ORG_ID | NUMBER | (15) | ||
BF_RETAINED_INV_ID_PMT | NUMBER | (15) | ||
BF_RETAINED_INV_DIST_ID_PMT | NUMBER | (15) | ||
BF_RETAINED_INV_ID_CLR | NUMBER | (15) | ||
BF_RETAINED_INV_DIST_ID_CLR | NUMBER | (15) | ||
AID_RET_RELATED_DIST_CCID | NUMBER | |||
AID_AWT_RELATED_ID | NUMBER | (15) | ||
APHD_QUANTITY_VARIANCE | NUMBER | |||
APHD_INV_BASE_QTY_VARIANCE | NUMBER | |||
APHD_AMOUNT_VARIANCE | NUMBER | |||
APHD_INV_BASE_AMT_VARIANCE | NUMBER | |||
AID_DETAIL_TAX_DIST_ID | NUMBER | |||
AID_ENCUMBERED_FLAG | VARCHAR2 | (1) | ||
POD_PO_DISTRIBUTION_ID | NUMBER | |||
POD_ENCUMBERED_FLAG | VARCHAR2 | (1) | ||
POD_ENCUMBERED_AMOUNT | NUMBER | |||
POD_GL_ENCUMBERED_DATE | DATE | |||
POD_GL_ENCUMBERED_PERIOD_NAME | VARCHAR2 | (15) | ||
POD_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
POD_ATTRIBUTE1 | VARCHAR2 | (150) | ||
POD_ATTRIBUTE2 | VARCHAR2 | (150) | ||
POD_ATTRIBUTE3 | VARCHAR2 | (150) | ||
POD_ATTRIBUTE4 | VARCHAR2 | (150) | ||
POD_ATTRIBUTE5 | VARCHAR2 | (150) | ||
POD_ATTRIBUTE6 | VARCHAR2 | (150) | ||
POD_ATTRIBUTE7 | VARCHAR2 | (150) | ||
POD_ATTRIBUTE8 | VARCHAR2 | (150) | ||
POD_ATTRIBUTE9 | VARCHAR2 | (150) | ||
POD_ATTRIBUTE10 | VARCHAR2 | (150) | ||
POD_ATTRIBUTE11 | VARCHAR2 | (150) | ||
POD_ATTRIBUTE12 | VARCHAR2 | (150) | ||
POD_ATTRIBUTE13 | VARCHAR2 | (150) | ||
POD_ATTRIBUTE14 | VARCHAR2 | (150) | ||
POD_ATTRIBUTE15 | VARCHAR2 | (150) | ||
POD_DISTRIBUTION_NUM | NUMBER | |||
POD_ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | (1) | ||
POD_CCID | NUMBER | |||
PO_VARIANCE_ACCOUNT | NUMBER | |||
RELATED_INV_DIST_DEST_TYPE | VARCHAR2 | (25) | ||
POD_PO_HEADER_ID | NUMBER | |||
POD_PO_LINE_ID | NUMBER | |||
POD_LINE_LOCATION_ID | NUMBER | |||
BUS_FLOW_PAYMENT_MAT_DIST_ID | NUMBER | |||
OVERRIDE_ACCTD_AMT_FLAG | CHAR | (1) | ||
AI_PAYMENT_STATUS_FLAG | VARCHAR2 | (1) | ||
ENCUMBRANCE_AMOUNT | NUMBER | |||
AWT_RELATED_DIST_TYPE | VARCHAR2 | (12) | ||
AWT_RELATED_LINE_TYPE_LOOKUP | VARCHAR2 | (25) | ||
ENCUMBRANCE_PMT_BASE_AMOUNT | NUMBER | |||
CASH_PMT_BASE_AMOUNT | NUMBER | |||
AWT_RELATED_ENC_FLAG | VARCHAR2 | (1) | ||
AID_DESC_PAY | VARCHAR2 | (240) | ||
UPG_AP_ENCUM_OPTION | VARCHAR2 | (4000) | ||
UPG_CR_ENC_TYPE_ID | NUMBER | (15) | Yes | |
UPG_ENC_CR_CCID | NUMBER | (15) | Yes | |
UPG_ENC_CR_BASE_AMT | NUMBER | |||
UPG_ENC_CR_AMT | NUMBER | |||
UPG_DR_ENC_TYPE_ID | NUMBER | (15) | Yes | |
UPG_ENC_DR_CCID | NUMBER | (15) | Yes | |
UPG_ENC_DR_BASE_AMT | NUMBER | |||
UPG_ENC_DR_AMT | NUMBER | |||
UPG_ENC_DR_ACCT_CLASS | VARCHAR2 | (0) | ||
UPG_ENC_CR_ACCT_CLASS | VARCHAR2 | (0) |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, APHD_PAY_DIST_LOOKUP_CODE
, LINE_NUMBER
, DIST_ACCOUNT_REVERSAL_OPTION
, APHD_REV_PAY_HIST_DIST_ID
, THIRD_PARTY_TYPE
, AI_INVOICE_CURRENCY_CODE
, APHD_REVERSAL_FLAG
, APHD_AMOUNT
, APHD_BANK_CURR_AMOUNT
, APHD_HISTORICAL_FLAG
, APHD_INVOICE_DIST_BASE_AMT
, APHD_PAYMENT_HIST_DIST_ID
, APHD_INVOICE_DISTRIBUTION_ID
, APHD_PAYMENT_HISTORY_ID
, APHD_INVOICE_PAYMENT_ID
, INV_PMT_BASE_AMT_DIFF
, PMT_MAT_BASE_AMT_DIFF
, MAT_CLR_BASE_AMT_DIFF
, PMT_CLR_BASE_AMT_DIFF
, INV_CLR_BASE_AMT_DIFF
, AIP_ACCOUNTING_DATE
, AIP_AMOUNT
, AIP_INVOICE_ID
, AIP_INVOICE_PAYMENT_ID
, AIP_PAYMENT_NUM
, AIP_PERIOD_NAME
, AIP_ACCTS_PAY_CCID
, AIP_ASSET_CCID
, AIP_ATTRIBUTE1
, AIP_ATTRIBUTE10
, AIP_ATTRIBUTE11
, AIP_ATTRIBUTE12
, AIP_ATTRIBUTE13
, AIP_ATTRIBUTE14
, AIP_ATTRIBUTE15
, AIP_ATTRIBUTE2
, AIP_ATTRIBUTE3
, AIP_ATTRIBUTE4
, AIP_ATTRIBUTE5
, AIP_ATTRIBUTE6
, AIP_ATTRIBUTE7
, AIP_ATTRIBUTE8
, AIP_ATTRIBUTE9
, AIP_ATTRIBUTE_CATEGORY
, AIP_INVOICE_PAYMENT_TYPE
, AIP_GLOBAL_ATTRIBUTE_CAT
, AIP_GLOBAL_ATTRIBUTE1
, AIP_GLOBAL_ATTRIBUTE2
, AIP_GLOBAL_ATTRIBUTE3
, AIP_GLOBAL_ATTRIBUTE4
, AIP_GLOBAL_ATTRIBUTE5
, AIP_GLOBAL_ATTRIBUTE6
, AIP_GLOBAL_ATTRIBUTE7
, AIP_GLOBAL_ATTRIBUTE8
, AIP_GLOBAL_ATTRIBUTE9
, AIP_GLOBAL_ATTRIBUTE10
, AIP_GLOBAL_ATTRIBUTE11
, AIP_GLOBAL_ATTRIBUTE12
, AIP_GLOBAL_ATTRIBUTE13
, AIP_GLOBAL_ATTRIBUTE14
, AIP_GLOBAL_ATTRIBUTE15
, AIP_GLOBAL_ATTRIBUTE16
, AIP_GLOBAL_ATTRIBUTE17
, AIP_GLOBAL_ATTRIBUTE18
, AIP_GLOBAL_ATTRIBUTE19
, AIP_GLOBAL_ATTRIBUTE20
, AIP_EXTERNAL_BANK_ACCOUNT_ID
, AIP_ACCOUNTING_EVENT_ID
, AIP_REVERSAL_FLAG
, AIP_REVERSAL_INV_PMT_ID
, AID_DIST_CCID
, AID_AMOUNT
, AID_AWT_FLAG
, AID_LINE_TYPE_LOOKUP_CODE
, AID_DISTRIBUTION_LINE_NUMBER
, AWTG_NAME
, AID_AWARD_ID
, AID_RATE_VAR_CCID
, AID_INVOICE_DIST_ID
, AID_INCOME_TAX_REGION
, AWT_AT_PMT_TIME
, AID_MERCHANT_DOCUMENT_NUMBER
, AID_MERCHANT_REFERENCE
, AID_MERCHANT_TAXPAYER_ID
, AID_MERCHANT_TAX_REG_NUMBER
, AI_INVOICE_AMOUNT
, AI_ACCTS_PAY_CCID
, DISTRIBUTION_LINK_TYPE
, PO_DISTRIBUTION_ID
, AWT_RELATED_DIST_ACCOUNT
, AI_INVOICE_DATE
, AI_INVOICE_TYPE_PAID
, INV_DISCOUNT_AMOUNT_TAKEN
, LEDGER_ID
, INV_EXCHANGE_DATE
, INV_EXCHANGE_RATE
, INV_EXCHANGE_RATE_TYPE
, APHD_INVOICE_DIST_AMOUNT
, APHD_CLEARING_BASE_AMT
, APHD_INVOICE_BASE_AMT
, APHD_MATURED_BASE_AMOUNT
, APHD_PAYMENT_BASE_AMT
, INV_PMT_GAIN_LOSS_INDICATOR
, INV_CLR_GAIN_LOSS_INDICATOR
, PMT_MAT_GAIN_LOSS_INDICATOR
, MAT_CLR_GAIN_LOSS_INDICATOR
, PMT_CLR_GAIN_LOSS_INDICATOR
, APHD_ROUNDING_AMT
, APHD_PMT_BASE_NO_ROUND
, APHD_CLEAR_BASE_AMT_NO_ROUND
, APHD_MAT_BASE_AMT_NO_ROUND
, BUS_FLOW_AP_APP_ID
, BUS_FLOW_INV_DIST_TYPE
, BUS_FLOW_INV_ENTITY_CODE
, BUS_FLOW_INV_DIST_ID
, BUS_FLOW_INV_ID
, BUS_FLOW_PO_APP_ID
, BUS_FLOW_PO_DIST_TYPE
, BUS_FLOW_PO_ENTITY_CODE
, BUS_FLOW_PAYMENT_DIST_TYPE
, BUS_FLOW_PAYMENT_ENTITY_CODE
, BUS_FLOW_PAYMENT_DIST_ID
, BUS_FLOW_PAYMENT_ID
, AID_PROJECT_ID
, AID_TASK_ID
, AID_EXPENDITURE_TYPE
, AID_EXPENDITURE_ORG_ID
, BF_RETAINED_INV_ID_PMT
, BF_RETAINED_INV_DIST_ID_PMT
, BF_RETAINED_INV_ID_CLR
, BF_RETAINED_INV_DIST_ID_CLR
, AID_RET_RELATED_DIST_CCID
, AID_AWT_RELATED_ID
, APHD_QUANTITY_VARIANCE
, APHD_INV_BASE_QTY_VARIANCE
, APHD_AMOUNT_VARIANCE
, APHD_INV_BASE_AMT_VARIANCE
, AID_DETAIL_TAX_DIST_ID
, AID_ENCUMBERED_FLAG
, POD_PO_DISTRIBUTION_ID
, POD_ENCUMBERED_FLAG
, POD_ENCUMBERED_AMOUNT
, POD_GL_ENCUMBERED_DATE
, POD_GL_ENCUMBERED_PERIOD_NAME
, POD_ATTRIBUTE_CATEGORY
, POD_ATTRIBUTE1
, POD_ATTRIBUTE2
, POD_ATTRIBUTE3
, POD_ATTRIBUTE4
, POD_ATTRIBUTE5
, POD_ATTRIBUTE6
, POD_ATTRIBUTE7
, POD_ATTRIBUTE8
, POD_ATTRIBUTE9
, POD_ATTRIBUTE10
, POD_ATTRIBUTE11
, POD_ATTRIBUTE12
, POD_ATTRIBUTE13
, POD_ATTRIBUTE14
, POD_ATTRIBUTE15
, POD_DISTRIBUTION_NUM
, POD_ACCRUE_ON_RECEIPT_FLAG
, POD_CCID
, PO_VARIANCE_ACCOUNT
, RELATED_INV_DIST_DEST_TYPE
, POD_PO_HEADER_ID
, POD_PO_LINE_ID
, POD_LINE_LOCATION_ID
, BUS_FLOW_PAYMENT_MAT_DIST_ID
, OVERRIDE_ACCTD_AMT_FLAG
, AI_PAYMENT_STATUS_FLAG
, ENCUMBRANCE_AMOUNT
, AWT_RELATED_DIST_TYPE
, AWT_RELATED_LINE_TYPE_LOOKUP
, ENCUMBRANCE_PMT_BASE_AMOUNT
, CASH_PMT_BASE_AMOUNT
, AWT_RELATED_ENC_FLAG
, AID_DESC_PAY
, UPG_AP_ENCUM_OPTION
, UPG_CR_ENC_TYPE_ID
, UPG_ENC_CR_CCID
, UPG_ENC_CR_BASE_AMT
, UPG_ENC_CR_AMT
, UPG_DR_ENC_TYPE_ID
, UPG_ENC_DR_CCID
, UPG_ENC_DR_BASE_AMT
, UPG_ENC_DR_AMT
, UPG_ENC_DR_ACCT_CLASS
, UPG_ENC_CR_ACCT_CLASS
FROM APPS.AP_PAYMENT_EXTRACT_DETAILS_V;
|
|
|