[Home] [Help]
[Dependency Information]
Object Name: | AP_PAYMENT_EXTRACT_HEADER_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ID | NUMBER | (15) | ||
PAYMENT_TRANSACTION_NUMBER | NUMBER | (15) | Yes | |
PAYMENT_TYPE | VARCHAR2 | (25) | Yes | |
PAYMENT_DOCUMENT_TYPE | VARCHAR2 | (30) | ||
PAYMENT_DOCUMENT_SEQUENCE_ID | NUMBER | |||
DOC_SEQUENCE_NAME | VARCHAR2 | (30) | ||
THIRD_PARTY_TYPE | VARCHAR2 | (1) | ||
CBA_POOLED_BANK_ACOUNT_FLAG | VARCHAR2 | (1) | ||
AC_CHECK_ID | NUMBER | (15) | Yes | |
AC_PROVINCE | VARCHAR2 | (150) | ||
AC_ACTUAL_VALUE_DATE | DATE | |||
AC_ADDRESS_LINE_1 | VARCHAR2 | (240) | ||
AC_ADDRESS_LINE_2 | VARCHAR2 | (240) | ||
AC_ADDRESS_LINE_3 | VARCHAR2 | (240) | ||
AC_ADDRESS_LINE_4 | VARCHAR2 | (240) | ||
AC_AMOUNT | NUMBER | Yes | ||
AC_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
AC_ATTRIBUTE1 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE10 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE11 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE12 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE13 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE14 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE15 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE2 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE3 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE4 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE5 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE6 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE7 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE8 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE9 | VARCHAR2 | (150) | ||
AC_CHECK_DATE | DATE | Yes | ||
AC_CHECK_VOUCHER_NUMBER | NUMBER | (16) | ||
AC_CHECKRUN_NAME | VARCHAR2 | (255) | ||
AC_CITY | VARCHAR2 | (60) | ||
AC_COUNTRY | VARCHAR2 | (60) | ||
AC_COUNTY | VARCHAR2 | (150) | ||
AC_DESCRIPTION | VARCHAR2 | (240) | ||
AC_DOC_CATEGORY_CODE | VARCHAR2 | (30) | ||
AC_DOC_SEQUENCE_VALUE | NUMBER | |||
AC_FUTURE_PAY_DUE_DATE | DATE | |||
AC_STATE | VARCHAR2 | (150) | ||
AC_VENDOR_NAME | VARCHAR2 | (240) | ||
AC_VOID_DATE | DATE | |||
AC_ZIP | VARCHAR2 | (60) | ||
CBA_ACCOUNT_CLASSIFICATION | VARCHAR2 | (30) | ||
CBA_BANK_ACCOUNT_NAME | VARCHAR2 | (100) | ||
CBA_BANK_ACCOUNT_NAME_ALT | VARCHAR2 | (320) | ||
CBA_BANK_ACCOUNT_NUM | VARCHAR2 | (30) | ||
CBA_BANK_ACCOUNT_TYPE | VARCHAR2 | (25) | ||
CBA_DESCRIPTION | VARCHAR2 | (240) | ||
CBA_IBAN_NUMBER | VARCHAR2 | (50) | ||
AC_VENDOR_ID | NUMBER | |||
AC_VENDOR_SITE_ID | NUMBER | |||
AC_ORG_ID | NUMBER | (15) | ||
AC_GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_1 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_2 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_3 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_4 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_5 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_6 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_7 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_8 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_9 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_10 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_11 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_12 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_13 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_14 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_15 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_16 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_17 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_18 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_19 | VARCHAR2 | (150) | ||
AC_GLOBAL_ATTRIBUTE_20 | VARCHAR2 | (150) | ||
AC_EXTERNAL_BANK_ACCOUNT_ID | NUMBER | (15) | ||
APH_PAYMENT_HISTORY_ID | NUMBER | (15) | Yes | |
APH_ACCOUNTING_DATE | DATE | Yes | ||
APH_TRANSACTION_TYPE | VARCHAR2 | (30) | Yes | |
APH_REV_PMT_HIST_ID | NUMBER | (15) | ||
APH_BANK_CURR_AMOUNT | NUMBER | |||
APH_AMOUNT | NUMBER | Yes | ||
APH_HISTORICAL_FLAG | VARCHAR2 | (1) | ||
CGAC_CASH_CLEARING_CCID | NUMBER | |||
CGAC_AP_ASSET_CCID | NUMBER | (15) | ||
CGAC_BANK_CHARGES_CCID | NUMBER | (15) | ||
CGAC_BANK_ERRORS_CCID | NUMBER | (15) | ||
CGAC_FUTURE_DATED_PMT_CCID | NUMBER | (15) | ||
TRANSAC_REVERSAL_FLAG | VARCHAR2 | (1) | ||
AC_PARTY_ID | NUMBER | (15) | ||
AC_PARTY_SITE_ID | NUMBER | (15) | ||
AC_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
AC_EXCHANGE_DATE | DATE | |||
AC_EXCHANGE_RATE | NUMBER | |||
AC_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
AC_LEDGER_AMOUNT | NUMBER | |||
APH_BASE_AMOUNT | NUMBER | |||
APH_ERRORS_BASE_AMOUNT | NUMBER | |||
APH_CHARGES_BASE_AMOUNT | NUMBER | |||
APH_BANK_CURRENCY_CODE | VARCHAR2 | (15) | ||
APH_BANK_TO_BASE_XRATE_TYPE | VARCHAR2 | (30) | ||
APH_BANK_TO_BASE_XRATE_DATE | DATE | |||
APH_BANK_TO_BASE_XRATE | NUMBER | |||
APH_PMT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
APH_PMT_TO_BASE_XRATE_TYPE | VARCHAR2 | (30) | ||
APH_PMT_TO_BASE_XRATE_DATE | DATE | |||
APH_PMT_TO_BASE_XRATE | NUMBER | |||
APH_INVOICE_ADJ_EVENT_ID | NUMBER | (15) | ||
POV_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
POV_ATTRIBUTE1 | VARCHAR2 | (150) | ||
POV_ATTRIBUTE10 | VARCHAR2 | (150) | ||
POV_ATTRIBUTE11 | VARCHAR2 | (150) | ||
POV_ATTRIBUTE12 | VARCHAR2 | (150) | ||
POV_ATTRIBUTE13 | VARCHAR2 | (150) | ||
POV_ATTRIBUTE14 | VARCHAR2 | (150) | ||
POV_ATTRIBUTE15 | VARCHAR2 | (150) | ||
POV_ATTRIBUTE2 | VARCHAR2 | (150) | ||
POV_ATTRIBUTE3 | VARCHAR2 | (150) | ||
POV_ATTRIBUTE4 | VARCHAR2 | (150) | ||
POV_ATTRIBUTE5 | VARCHAR2 | (150) | ||
POV_ATTRIBUTE6 | VARCHAR2 | (150) | ||
POV_ATTRIBUTE7 | VARCHAR2 | (150) | ||
POV_ATTRIBUTE8 | VARCHAR2 | (150) | ||
POV_ATTRIBUTE9 | VARCHAR2 | (150) | ||
POV_VENDOR_NAME_ALT | VARCHAR2 | (320) | ||
POV_VENDOR_ID | NUMBER | |||
POV_SEGMENT1 | VARCHAR2 | (30) | ||
POV_VENDOR_NAME | VARCHAR2 | (360) | ||
POV_SEGMENT2 | VARCHAR2 | (30) | ||
POV_SEGMENT3 | VARCHAR2 | (30) | ||
POV_SEGMENT4 | VARCHAR2 | (30) | ||
POV_SEGMENT5 | VARCHAR2 | (30) | ||
POV_MERCHANT_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | ||
POV_GLOBAL_ATTRIBUTE_1 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_2 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_3 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_4 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_5 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_6 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_7 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_8 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_9 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_10 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_11 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_12 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_13 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_14 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_15 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_16 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_17 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_18 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_19 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_20 | VARCHAR2 | (150) | ||
POV_GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
POV_NUM_1099 | VARCHAR2 | (30) | ||
PARTY_ID | NUMBER | |||
POS_ATTRIBUTE1 | VARCHAR2 | (150) | ||
POS_ATTRIBUTE10 | VARCHAR2 | (150) | ||
POS_ATTRIBUTE11 | VARCHAR2 | (150) | ||
POS_ATTRIBUTE12 | VARCHAR2 | (150) | ||
POS_ATTRIBUTE13 | VARCHAR2 | (150) | ||
POS_ATTRIBUTE14 | VARCHAR2 | (150) | ||
POS_ATTRIBUTE15 | VARCHAR2 | (150) | ||
POS_ATTRIBUTE2 | VARCHAR2 | (150) | ||
POS_ATTRIBUTE3 | VARCHAR2 | (150) | ||
POS_ATTRIBUTE4 | VARCHAR2 | (150) | ||
POS_ATTRIBUTE5 | VARCHAR2 | (150) | ||
POS_ATTRIBUTE6 | VARCHAR2 | (150) | ||
POS_ATTRIBUTE7 | VARCHAR2 | (150) | ||
POS_ATTRIBUTE8 | VARCHAR2 | (150) | ||
POS_ATTRIBUTE9 | VARCHAR2 | (150) | ||
POS_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
POS_ADDRESS_LINE1 | VARCHAR2 | (240) | ||
POS_ADDRESS_LINE2 | VARCHAR2 | (240) | ||
POS_ADDRESS_LINE3 | VARCHAR2 | (240) | ||
POS_ADDRESS_LINE4 | VARCHAR2 | (240) | ||
POS_ADDRESS_LINES_ALT | VARCHAR2 | (560) | ||
POS_CITY | VARCHAR2 | (60) | ||
POS_COUNTY | VARCHAR2 | (150) | ||
POS_COUNTRY | VARCHAR2 | (60) | ||
POS_VENDOR_SITE_CODE | VARCHAR2 | (15) | ||
POS_ZIP | VARCHAR2 | (60) | ||
POS_PROVINCE | VARCHAR2 | (150) | ||
POS_STATE | VARCHAR2 | (150) | ||
POS_VENDOR_SITE_ID | NUMBER | |||
POS_GLOBAL_ATTRIBUTE_1 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_2 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_3 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_4 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_5 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_6 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_7 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_8 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_9 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_10 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_11 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_12 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_13 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_14 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_15 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_16 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_17 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_18 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_19 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_20 | VARCHAR2 | (150) | ||
POS_GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
POS_FDP_CCID | NUMBER | |||
POS_PARTY_SITE_ID | NUMBER | |||
POS_ORG_ID | NUMBER | |||
POS_VENDOR_ID | NUMBER | |||
CGAC_GAIN_CCID | NUMBER | (15) | ||
CGAC_LOSS_CCID | NUMBER | (15) | ||
PAYMENT_PROCESSING_TYPE | VARCHAR2 | (30) | ||
PAYCARD_ACCRUED_ACCOUNT_CCID | NUMBER | (15) | ||
AC_PAYMENT_DOCUMENT_ID | NUMBER | (15) | ||
AC_PAYMENT_PROFILE_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, PAYMENT_TRANSACTION_NUMBER
, PAYMENT_TYPE
, PAYMENT_DOCUMENT_TYPE
, PAYMENT_DOCUMENT_SEQUENCE_ID
, DOC_SEQUENCE_NAME
, THIRD_PARTY_TYPE
, CBA_POOLED_BANK_ACOUNT_FLAG
, AC_CHECK_ID
, AC_PROVINCE
, AC_ACTUAL_VALUE_DATE
, AC_ADDRESS_LINE_1
, AC_ADDRESS_LINE_2
, AC_ADDRESS_LINE_3
, AC_ADDRESS_LINE_4
, AC_AMOUNT
, AC_ATTRIBUTE_CATEGORY
, AC_ATTRIBUTE1
, AC_ATTRIBUTE10
, AC_ATTRIBUTE11
, AC_ATTRIBUTE12
, AC_ATTRIBUTE13
, AC_ATTRIBUTE14
, AC_ATTRIBUTE15
, AC_ATTRIBUTE2
, AC_ATTRIBUTE3
, AC_ATTRIBUTE4
, AC_ATTRIBUTE5
, AC_ATTRIBUTE6
, AC_ATTRIBUTE7
, AC_ATTRIBUTE8
, AC_ATTRIBUTE9
, AC_CHECK_DATE
, AC_CHECK_VOUCHER_NUMBER
, AC_CHECKRUN_NAME
, AC_CITY
, AC_COUNTRY
, AC_COUNTY
, AC_DESCRIPTION
, AC_DOC_CATEGORY_CODE
, AC_DOC_SEQUENCE_VALUE
, AC_FUTURE_PAY_DUE_DATE
, AC_STATE
, AC_VENDOR_NAME
, AC_VOID_DATE
, AC_ZIP
, CBA_ACCOUNT_CLASSIFICATION
, CBA_BANK_ACCOUNT_NAME
, CBA_BANK_ACCOUNT_NAME_ALT
, CBA_BANK_ACCOUNT_NUM
, CBA_BANK_ACCOUNT_TYPE
, CBA_DESCRIPTION
, CBA_IBAN_NUMBER
, AC_VENDOR_ID
, AC_VENDOR_SITE_ID
, AC_ORG_ID
, AC_GLOBAL_ATTRIBUTE_CATEGORY
, AC_GLOBAL_ATTRIBUTE_1
, AC_GLOBAL_ATTRIBUTE_2
, AC_GLOBAL_ATTRIBUTE_3
, AC_GLOBAL_ATTRIBUTE_4
, AC_GLOBAL_ATTRIBUTE_5
, AC_GLOBAL_ATTRIBUTE_6
, AC_GLOBAL_ATTRIBUTE_7
, AC_GLOBAL_ATTRIBUTE_8
, AC_GLOBAL_ATTRIBUTE_9
, AC_GLOBAL_ATTRIBUTE_10
, AC_GLOBAL_ATTRIBUTE_11
, AC_GLOBAL_ATTRIBUTE_12
, AC_GLOBAL_ATTRIBUTE_13
, AC_GLOBAL_ATTRIBUTE_14
, AC_GLOBAL_ATTRIBUTE_15
, AC_GLOBAL_ATTRIBUTE_16
, AC_GLOBAL_ATTRIBUTE_17
, AC_GLOBAL_ATTRIBUTE_18
, AC_GLOBAL_ATTRIBUTE_19
, AC_GLOBAL_ATTRIBUTE_20
, AC_EXTERNAL_BANK_ACCOUNT_ID
, APH_PAYMENT_HISTORY_ID
, APH_ACCOUNTING_DATE
, APH_TRANSACTION_TYPE
, APH_REV_PMT_HIST_ID
, APH_BANK_CURR_AMOUNT
, APH_AMOUNT
, APH_HISTORICAL_FLAG
, CGAC_CASH_CLEARING_CCID
, CGAC_AP_ASSET_CCID
, CGAC_BANK_CHARGES_CCID
, CGAC_BANK_ERRORS_CCID
, CGAC_FUTURE_DATED_PMT_CCID
, TRANSAC_REVERSAL_FLAG
, AC_PARTY_ID
, AC_PARTY_SITE_ID
, AC_CURRENCY_CODE
, AC_EXCHANGE_DATE
, AC_EXCHANGE_RATE
, AC_EXCHANGE_RATE_TYPE
, AC_LEDGER_AMOUNT
, APH_BASE_AMOUNT
, APH_ERRORS_BASE_AMOUNT
, APH_CHARGES_BASE_AMOUNT
, APH_BANK_CURRENCY_CODE
, APH_BANK_TO_BASE_XRATE_TYPE
, APH_BANK_TO_BASE_XRATE_DATE
, APH_BANK_TO_BASE_XRATE
, APH_PMT_CURRENCY_CODE
, APH_PMT_TO_BASE_XRATE_TYPE
, APH_PMT_TO_BASE_XRATE_DATE
, APH_PMT_TO_BASE_XRATE
, APH_INVOICE_ADJ_EVENT_ID
, POV_ATTRIBUTE_CATEGORY
, POV_ATTRIBUTE1
, POV_ATTRIBUTE10
, POV_ATTRIBUTE11
, POV_ATTRIBUTE12
, POV_ATTRIBUTE13
, POV_ATTRIBUTE14
, POV_ATTRIBUTE15
, POV_ATTRIBUTE2
, POV_ATTRIBUTE3
, POV_ATTRIBUTE4
, POV_ATTRIBUTE5
, POV_ATTRIBUTE6
, POV_ATTRIBUTE7
, POV_ATTRIBUTE8
, POV_ATTRIBUTE9
, POV_VENDOR_NAME_ALT
, POV_VENDOR_ID
, POV_SEGMENT1
, POV_VENDOR_NAME
, POV_SEGMENT2
, POV_SEGMENT3
, POV_SEGMENT4
, POV_SEGMENT5
, POV_MERCHANT_TYPE_LOOKUP_CODE
, POV_GLOBAL_ATTRIBUTE_1
, POV_GLOBAL_ATTRIBUTE_2
, POV_GLOBAL_ATTRIBUTE_3
, POV_GLOBAL_ATTRIBUTE_4
, POV_GLOBAL_ATTRIBUTE_5
, POV_GLOBAL_ATTRIBUTE_6
, POV_GLOBAL_ATTRIBUTE_7
, POV_GLOBAL_ATTRIBUTE_8
, POV_GLOBAL_ATTRIBUTE_9
, POV_GLOBAL_ATTRIBUTE_10
, POV_GLOBAL_ATTRIBUTE_11
, POV_GLOBAL_ATTRIBUTE_12
, POV_GLOBAL_ATTRIBUTE_13
, POV_GLOBAL_ATTRIBUTE_14
, POV_GLOBAL_ATTRIBUTE_15
, POV_GLOBAL_ATTRIBUTE_16
, POV_GLOBAL_ATTRIBUTE_17
, POV_GLOBAL_ATTRIBUTE_18
, POV_GLOBAL_ATTRIBUTE_19
, POV_GLOBAL_ATTRIBUTE_20
, POV_GLOBAL_ATTRIBUTE_CATEGORY
, POV_NUM_1099
, PARTY_ID
, POS_ATTRIBUTE1
, POS_ATTRIBUTE10
, POS_ATTRIBUTE11
, POS_ATTRIBUTE12
, POS_ATTRIBUTE13
, POS_ATTRIBUTE14
, POS_ATTRIBUTE15
, POS_ATTRIBUTE2
, POS_ATTRIBUTE3
, POS_ATTRIBUTE4
, POS_ATTRIBUTE5
, POS_ATTRIBUTE6
, POS_ATTRIBUTE7
, POS_ATTRIBUTE8
, POS_ATTRIBUTE9
, POS_ATTRIBUTE_CATEGORY
, POS_ADDRESS_LINE1
, POS_ADDRESS_LINE2
, POS_ADDRESS_LINE3
, POS_ADDRESS_LINE4
, POS_ADDRESS_LINES_ALT
, POS_CITY
, POS_COUNTY
, POS_COUNTRY
, POS_VENDOR_SITE_CODE
, POS_ZIP
, POS_PROVINCE
, POS_STATE
, POS_VENDOR_SITE_ID
, POS_GLOBAL_ATTRIBUTE_1
, POS_GLOBAL_ATTRIBUTE_2
, POS_GLOBAL_ATTRIBUTE_3
, POS_GLOBAL_ATTRIBUTE_4
, POS_GLOBAL_ATTRIBUTE_5
, POS_GLOBAL_ATTRIBUTE_6
, POS_GLOBAL_ATTRIBUTE_7
, POS_GLOBAL_ATTRIBUTE_8
, POS_GLOBAL_ATTRIBUTE_9
, POS_GLOBAL_ATTRIBUTE_10
, POS_GLOBAL_ATTRIBUTE_11
, POS_GLOBAL_ATTRIBUTE_12
, POS_GLOBAL_ATTRIBUTE_13
, POS_GLOBAL_ATTRIBUTE_14
, POS_GLOBAL_ATTRIBUTE_15
, POS_GLOBAL_ATTRIBUTE_16
, POS_GLOBAL_ATTRIBUTE_17
, POS_GLOBAL_ATTRIBUTE_18
, POS_GLOBAL_ATTRIBUTE_19
, POS_GLOBAL_ATTRIBUTE_20
, POS_GLOBAL_ATTRIBUTE_CATEGORY
, POS_FDP_CCID
, POS_PARTY_SITE_ID
, POS_ORG_ID
, POS_VENDOR_ID
, CGAC_GAIN_CCID
, CGAC_LOSS_CCID
, PAYMENT_PROCESSING_TYPE
, PAYCARD_ACCRUED_ACCOUNT_CCID
, AC_PAYMENT_DOCUMENT_ID
, AC_PAYMENT_PROFILE_ID
FROM APPS.AP_PAYMENT_EXTRACT_HEADER_V;
|
|
|