VIEW: PA.PA_TXN_INTERFACE_AUDIT_AR#

Source

View Text - Preformatted

select PURGE_BATCH_ID PURGE_BATCH_ID, PURGE_RELEASE PURGE_RELEASE, PURGE_PROJECT_ID PURGE_PROJECT_ID, ATTRIBUTE10 ATTRIBUTE10, RAW_COST_RATE RAW_COST_RATE, INTERFACE_ID INTERFACE_ID, UNMATCHED_NEGATIVE_TXN_FLAG UNMATCHED_NEGATIVE_TXN_FLAG, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID, ORG_ID ORG_ID, DR_CODE_COMBINATION_ID DR_CODE_COMBINATION_ID, CR_CODE_COMBINATION_ID CR_CODE_COMBINATION_ID, CDL_SYSTEM_REFERENCE1 CDL_SYSTEM_REFERENCE1, CDL_SYSTEM_REFERENCE2 CDL_SYSTEM_REFERENCE2, CDL_SYSTEM_REFERENCE3 CDL_SYSTEM_REFERENCE3, GL_DATE GL_DATE, BURDENED_COST BURDENED_COST, BURDENED_COST_RATE BURDENED_COST_RATE, SYSTEM_LINKAGE SYSTEM_LINKAGE, TXN_INTERFACE_ID TXN_INTERFACE_ID, BEFORE_AFTER_FLAG BEFORE_AFTER_FLAG, UPDATED_BY UPDATED_BY, UPDATE_DATE UPDATE_DATE, USER_TRANSACTION_SOURCE USER_TRANSACTION_SOURCE, TRANSACTION_SOURCE TRANSACTION_SOURCE, BATCH_NAME BATCH_NAME, EXPENDITURE_ENDING_DATE EXPENDITURE_ENDING_DATE, EMPLOYEE_NUMBER EMPLOYEE_NUMBER, ORGANIZATION_NAME ORGANIZATION_NAME, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, PROJECT_NUMBER PROJECT_NUMBER, TASK_NUMBER TASK_NUMBER, EXPENDITURE_TYPE EXPENDITURE_TYPE, NON_LABOR_RESOURCE NON_LABOR_RESOURCE, NON_LABOR_RESOURCE_ORG_NAME NON_LABOR_RESOURCE_ORG_NAME, QUANTITY QUANTITY, RAW_COST RAW_COST, EXPENDITURE_COMMENT EXPENDITURE_COMMENT, TRANSACTION_STATUS_CODE TRANSACTION_STATUS_CODE, TRANSACTION_REJECTION_CODE TRANSACTION_REJECTION_CODE, EXPENDITURE_ID EXPENDITURE_ID, ORIG_TRANSACTION_REFERENCE ORIG_TRANSACTION_REFERENCE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, RECEIPT_CURRENCY_AMOUNT RECEIPT_CURRENCY_AMOUNT, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE, RECEIPT_EXCHANGE_RATE RECEIPT_EXCHANGE_RATE, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE, DENOM_RAW_COST DENOM_RAW_COST, DENOM_BURDENED_COST DENOM_BURDENED_COST, ACCT_RATE_TYPE ACCT_RATE_TYPE, ACCT_RATE_DATE ACCT_RATE_DATE, ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE, ACCT_RAW_COST ACCT_RAW_COST, ACCT_BURDENED_COST ACCT_BURDENED_COST, ACCT_EXCHANGE_ROUNDING_LIMIT ACCT_EXCHANGE_ROUNDING_LIMIT, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, PROJECT_RATE_TYPE PROJECT_RATE_TYPE, PROJECT_RATE_DATE PROJECT_RATE_DATE, PROJECT_EXCHANGE_RATE PROJECT_EXCHANGE_RATE, ORIG_EXP_TXN_REFERENCE1 ORIG_EXP_TXN_REFERENCE1, ORIG_EXP_TXN_REFERENCE2 ORIG_EXP_TXN_REFERENCE2, ORIG_EXP_TXN_REFERENCE3 ORIG_EXP_TXN_REFERENCE3, ORIG_USER_EXP_TXN_REFERENCE ORIG_USER_EXP_TXN_REFERENCE, OVERRIDE_TO_ORGANIZATION_NAME OVERRIDE_TO_ORGANIZATION_NAME, REVERSED_ORIG_TXN_REFERENCE REVERSED_ORIG_TXN_REFERENCE, VENDOR_NUMBER VENDOR_NUMBER, BILLABLE_FLAG BILLABLE_FLAG, PERSON_BUSINESS_GROUP_NAME PERSON_BUSINESS_GROUP_NAME, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE, PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE, PROJECT_RAW_COST PROJECT_RAW_COST, PROJECT_BURDENED_COST PROJECT_BURDENED_COST, ASSIGNMENT_NAME ASSIGNMENT_NAME, WORK_TYPE_NAME WORK_TYPE_NAME, CDL_SYSTEM_REFERENCE4 CDL_SYSTEM_REFERENCE4, ACCRUAL_FLAG ACCRUAL_FLAG, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PERSON_ID PERSON_ID, ORGANIZATION_ID ORGANIZATION_ID, NON_LABOR_RESOURCE_ORG_ID NON_LABOR_RESOURCE_ORG_ID, VENDOR_ID VENDOR_ID, OVERRIDE_TO_ORGANIZATION_ID OVERRIDE_TO_ORGANIZATION_ID, ASSIGNMENT_ID ASSIGNMENT_ID, WORK_TYPE_ID WORK_TYPE_ID, PERSON_BUSINESS_GROUP_ID PERSON_BUSINESS_GROUP_ID, PO_NUMBER PO_NUMBER, PO_HEADER_ID PO_HEADER_ID, PO_LINE_NUM PO_LINE_NUM, PO_LINE_ID PO_LINE_ID, PERSON_TYPE PERSON_TYPE, PO_PRICE_TYPE PO_PRICE_TYPE, UNIT_OF_MEASURE UNIT_OF_MEASURE, WIP_RESOURCE_ID WIP_RESOURCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, CDL_SYSTEM_REFERENCE5 CDL_SYSTEM_REFERENCE5, FC_DOCUMENT_TYPE FC_DOCUMENT_TYPE, ADJUSTED_EXPENDITURE_ITEM_ID ADJUSTED_EXPENDITURE_ITEM_ID, ADJUSTED_TXN_INTERFACE_ID ADJUSTED_TXN_INTERFACE_ID, DOCUMENT_TYPE DOCUMENT_TYPE, DOCUMENT_DISTRIBUTION_TYPE DOCUMENT_DISTRIBUTION_TYPE, SI_ASSETS_ADDITION_FLAG SI_ASSETS_ADDITION_FLAG, NET_ZERO_ADJUSTMENT_FLAG NET_ZERO_ADJUSTMENT_FLAG, SC_XFER_CODE SC_XFER_CODE, JOB_ID JOB_ID, JOB_NAME JOB_NAME, LOCATION_ID LOCATION_ID, LOCATION_CODE LOCATION_CODE, PAY_ELEMENT_TYPE_ID PAY_ELEMENT_TYPE_ID, CBS_ELEMENT_ID CBS_ELEMENT_ID, CBS_ELEMENT_NAME CBS_ELEMENT_NAME from "PA"."PA_TXN_INTERFACE_AUDIT_AR"

View Text - HTML Formatted

SELECT PURGE_BATCH_ID PURGE_BATCH_ID
, PURGE_RELEASE PURGE_RELEASE
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, ATTRIBUTE10 ATTRIBUTE10
, RAW_COST_RATE RAW_COST_RATE
, INTERFACE_ID INTERFACE_ID
, UNMATCHED_NEGATIVE_TXN_FLAG UNMATCHED_NEGATIVE_TXN_FLAG
, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, ORG_ID ORG_ID
, DR_CODE_COMBINATION_ID DR_CODE_COMBINATION_ID
, CR_CODE_COMBINATION_ID CR_CODE_COMBINATION_ID
, CDL_SYSTEM_REFERENCE1 CDL_SYSTEM_REFERENCE1
, CDL_SYSTEM_REFERENCE2 CDL_SYSTEM_REFERENCE2
, CDL_SYSTEM_REFERENCE3 CDL_SYSTEM_REFERENCE3
, GL_DATE GL_DATE
, BURDENED_COST BURDENED_COST
, BURDENED_COST_RATE BURDENED_COST_RATE
, SYSTEM_LINKAGE SYSTEM_LINKAGE
, TXN_INTERFACE_ID TXN_INTERFACE_ID
, BEFORE_AFTER_FLAG BEFORE_AFTER_FLAG
, UPDATED_BY UPDATED_BY
, UPDATE_DATE UPDATE_DATE
, USER_TRANSACTION_SOURCE USER_TRANSACTION_SOURCE
, TRANSACTION_SOURCE TRANSACTION_SOURCE
, BATCH_NAME BATCH_NAME
, EXPENDITURE_ENDING_DATE EXPENDITURE_ENDING_DATE
, EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, ORGANIZATION_NAME ORGANIZATION_NAME
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, PROJECT_NUMBER PROJECT_NUMBER
, TASK_NUMBER TASK_NUMBER
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, NON_LABOR_RESOURCE NON_LABOR_RESOURCE
, NON_LABOR_RESOURCE_ORG_NAME NON_LABOR_RESOURCE_ORG_NAME
, QUANTITY QUANTITY
, RAW_COST RAW_COST
, EXPENDITURE_COMMENT EXPENDITURE_COMMENT
, TRANSACTION_STATUS_CODE TRANSACTION_STATUS_CODE
, TRANSACTION_REJECTION_CODE TRANSACTION_REJECTION_CODE
, EXPENDITURE_ID EXPENDITURE_ID
, ORIG_TRANSACTION_REFERENCE ORIG_TRANSACTION_REFERENCE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, RECEIPT_CURRENCY_AMOUNT RECEIPT_CURRENCY_AMOUNT
, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE
, RECEIPT_EXCHANGE_RATE RECEIPT_EXCHANGE_RATE
, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE
, DENOM_RAW_COST DENOM_RAW_COST
, DENOM_BURDENED_COST DENOM_BURDENED_COST
, ACCT_RATE_TYPE ACCT_RATE_TYPE
, ACCT_RATE_DATE ACCT_RATE_DATE
, ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE
, ACCT_RAW_COST ACCT_RAW_COST
, ACCT_BURDENED_COST ACCT_BURDENED_COST
, ACCT_EXCHANGE_ROUNDING_LIMIT ACCT_EXCHANGE_ROUNDING_LIMIT
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PROJECT_RATE_TYPE PROJECT_RATE_TYPE
, PROJECT_RATE_DATE PROJECT_RATE_DATE
, PROJECT_EXCHANGE_RATE PROJECT_EXCHANGE_RATE
, ORIG_EXP_TXN_REFERENCE1 ORIG_EXP_TXN_REFERENCE1
, ORIG_EXP_TXN_REFERENCE2 ORIG_EXP_TXN_REFERENCE2
, ORIG_EXP_TXN_REFERENCE3 ORIG_EXP_TXN_REFERENCE3
, ORIG_USER_EXP_TXN_REFERENCE ORIG_USER_EXP_TXN_REFERENCE
, OVERRIDE_TO_ORGANIZATION_NAME OVERRIDE_TO_ORGANIZATION_NAME
, REVERSED_ORIG_TXN_REFERENCE REVERSED_ORIG_TXN_REFERENCE
, VENDOR_NUMBER VENDOR_NUMBER
, BILLABLE_FLAG BILLABLE_FLAG
, PERSON_BUSINESS_GROUP_NAME PERSON_BUSINESS_GROUP_NAME
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE
, PROJECT_RAW_COST PROJECT_RAW_COST
, PROJECT_BURDENED_COST PROJECT_BURDENED_COST
, ASSIGNMENT_NAME ASSIGNMENT_NAME
, WORK_TYPE_NAME WORK_TYPE_NAME
, CDL_SYSTEM_REFERENCE4 CDL_SYSTEM_REFERENCE4
, ACCRUAL_FLAG ACCRUAL_FLAG
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PERSON_ID PERSON_ID
, ORGANIZATION_ID ORGANIZATION_ID
, NON_LABOR_RESOURCE_ORG_ID NON_LABOR_RESOURCE_ORG_ID
, VENDOR_ID VENDOR_ID
, OVERRIDE_TO_ORGANIZATION_ID OVERRIDE_TO_ORGANIZATION_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, WORK_TYPE_ID WORK_TYPE_ID
, PERSON_BUSINESS_GROUP_ID PERSON_BUSINESS_GROUP_ID
, PO_NUMBER PO_NUMBER
, PO_HEADER_ID PO_HEADER_ID
, PO_LINE_NUM PO_LINE_NUM
, PO_LINE_ID PO_LINE_ID
, PERSON_TYPE PERSON_TYPE
, PO_PRICE_TYPE PO_PRICE_TYPE
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, WIP_RESOURCE_ID WIP_RESOURCE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CDL_SYSTEM_REFERENCE5 CDL_SYSTEM_REFERENCE5
, FC_DOCUMENT_TYPE FC_DOCUMENT_TYPE
, ADJUSTED_EXPENDITURE_ITEM_ID ADJUSTED_EXPENDITURE_ITEM_ID
, ADJUSTED_TXN_INTERFACE_ID ADJUSTED_TXN_INTERFACE_ID
, DOCUMENT_TYPE DOCUMENT_TYPE
, DOCUMENT_DISTRIBUTION_TYPE DOCUMENT_DISTRIBUTION_TYPE
, SI_ASSETS_ADDITION_FLAG SI_ASSETS_ADDITION_FLAG
, NET_ZERO_ADJUSTMENT_FLAG NET_ZERO_ADJUSTMENT_FLAG
, SC_XFER_CODE SC_XFER_CODE
, JOB_ID JOB_ID
, JOB_NAME JOB_NAME
, LOCATION_ID LOCATION_ID
, LOCATION_CODE LOCATION_CODE
, PAY_ELEMENT_TYPE_ID PAY_ELEMENT_TYPE_ID
, CBS_ELEMENT_ID CBS_ELEMENT_ID
, CBS_ELEMENT_NAME CBS_ELEMENT_NAME
FROM "PA"."PA_TXN_INTERFACE_AUDIT_AR"