Oracle ERP Application Diagnostics使用

invoice异常的时候，可以先使用Application Diagnostics查询一下相关的资料，资料非常全，看起来也非常直观。

使用步骤

1）进入Responsibility Application Diagnostics

2）点击Diagnose

3）点击Select Application按钮，输入Payables

4）点击Invoice前面的+号，勾上Invoice Data前面的勾

5）点击Execute，输入Responsibility ID和Invoice Id

6）大功告成，可以submit了。

附上一个跑的结果

------------- Test Result Summary ------------- Total Tests: 1 Success Count: 1 Error count: 0 Test Names Status oracle.apps.ap.diag.APListWrapper Succeeded ----------- End Test Result Summary -----------

============= Test Result ============= Test Class Name: oracle.apps.ap.diag.APListWrapper Application Code: SQLAP Group Name: Invoice Status: Succeeded Time: 2008-05-13 16:53:39.0 Time Consumed: 14344 Test Version: 120.0.12000000.1 Tool Version: 120.25.12000000.5 Install Version: Base: none Upgrade: none Mode: 1 Index: 1 Tested Class Name Tested Class Version oracle.apps.ap.diag.APInvoiceIdByTypeLov 120.0.12000000.1 oracle.apps.ap.diag.APSearchCriteriaLov 120.0.12000000.1 oracle.apps.ap.diag.APSupplierLov 120.0.12000000.1 oracle.apps.ap.diag.APUtility 120.0.12000000.3 oracle.apps.ap.diag.YesNoLov 120.0.12000000.1 oracle.apps.gl.diag.GLLedger 120.0.12000000.1 oracle.apps.gl.diag.GLUtility 120.0.12000000.7 oracle.apps.jtf.regress.qatool.base.DBUtility 120.0.12000000.2 oracle.apps.jtf.regress.qatool.base.DiagBase 120.0.12000000.1 oracle.apps.jtf.regress.qatool.base.HRInfo 120.0.12000000.1 oracle.apps.jtf.regress.qatool.base.OSUtility 120.0.12000000.1 oracle.apps.jtf.regress.qatool.base.SessionHelper 120.0.12000000.1 oracle.apps.jtf.regress.qatool.base.TextUtility 120.0.12000000.1 oracle.apps.jtf.regress.qatool.fnd.FNDUtility 120.0.12000000.2 Input Names Input Values Responsibility ID 50478 Search Criteria Invoice Supplier Name Invoice Id 72822 Include GL Tables Y Include Related Data Y Max Rows Displayed Diagnostic Test Executed By AFSINTF_TW Dependent Class Names Report: Oracle Diagnostics Information Parameters Ledger Definition Secondary Ledgers Setup Summary Trial Balance Invoice Payment Tax Accounting Supplier Purchasing Encumbrance Prepayment Payment Document and Bank Cash Management Treasury Confirmation Currency References XML File Information Database Information     [Top] Server = twtpefsd4.intra.acer.com Version = Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi Name/SID = FIP Language = AMERICAN Character Set = AL32UTF8 Application Information     [Top] Release = 12.0.3 Application = Payables (200) with status of INSTALLED Responsibility = AI Payables Manager (50478) Security Group = Standard MultiOrg Flag = Y Oracle Diagnostics Information     [Top] Patch OD for R12 RUP3 [12.0.3] (6154018) is installed Patch Oracle Diagnostics Support Tools, R12.IZU.A.DELTA.3 (6265820) is installed Parameters     [Top] Username = AFSINTF_TW Responsibility = AI Payables Manager (50478) Search Criteria = Invoice Supplier Name = Invoice Id = 72822 Include GL Tables = Y Include Related Data = Y Max Rows Displayed = 500 Ledger Definition     [Top] Standard Information Name = Acer Incorporated (Id = 2022) Short Name = AI Description = Acer Incorporated Primary Ledger Currency = NTD Chart of Accounts = ACER Taiwan COA Structure (Id = 50308) Type = Primary Ledger Accounting Calendar Accounting Calendar = Acer_G_Calendar Period Type = 21 First Ever Opened Period = DEC-05 Number of Future Enterable Periods = 2 Subledger Accounting Options Subledger Accounting Method = Acer Taiwan Standard Accrual Use Cash Basis Accounting = N Secondary Ledgers     [Top] Secondary Ledgers Secondary Ledger Name Short Name Ledger Id Relationship Type Status

  0 rows retrieved

Setup     [Top]

• AP_SYSTEM_PARAMETERS_ALL

  LAST_UPDATE_DATE LAST_UPDATED_BY SET_OF_BOOKS_ID BASE_CURRENCY_CODE RECALC_PAY_SCHEDULE_ FLAG AUTO_CALCULATE_ INTEREST_FLAG INVOICE_CURRENCY_ CODE PAYMENT_CURRENCY_ CODE INVOICE_NET_GROSS_ FLAG BANK_ACCOUNT_ID CHECK_OVERFLOW_ LOOKUP_CODE BATCH_CONTROL_FLAG TERMS_ID ALWAYS_TAKE_DISC_ FLAG PAY_DATE_BASIS_ LOOKUP_CODE ACCTS_PAY_CODE_ COMBINATION_ID SALES_TAX_CODE_ COMBINATION_ID DISC_LOST_CODE_ COMBINATION_ID DISC_TAKEN_CODE_ COMBINATION_ID HOLD_GAIN_CODE_ COMBINATION_ID TRANS_GAIN_CODE_ COMBINATION_ID APPLY_ADVANCES_ DEFAULT ADD_DAYS_SETTLEMENT_ DATE COST_OF_MONEY DAYS_BETWEEN_CHECK_ CYCLES FEDERAL_ IDENTIFICATION_NUM LOCATION_ID CREATE_EMPLOYEE_ VENDOR_FLAG EMPLOYEE_TERMS_ID EMPLOYEE_PAY_GROUP_ LOOKUP_CODE EMPLOYEE_PAYMENT_ PRIORITY PREPAY_CODE_ COMBINATION_ID CONFIRM_DATE_AS_INV_ NUM_FLAG UPDATE_PAY_SITE_FLAG DEFAULT_EXCHANGE_ RATE_TYPE GAIN_CODE_ COMBINATION_ID LOSS_CODE_ COMBINATION_ID MAKE_RATE_MANDATORY_ FLAG MULTI_CURRENCY_FLAG GL_DATE_FROM_ RECEIPT_FLAG DISC_IS_INV_LESS_ TAX_FLAG MATCH_ON_TAX_FLAG ACCOUNTING_METHOD_ OPTION EXPENSE_POST_OPTION DISCOUNT_TAKEN_POST_ OPTION GAIN_LOSS_POST_ OPTION CASH_POST_OPTION FUTURE_PAY_POST_ OPTION DATE_FORMAT_LOOKUP_ CODE REPLACE_CHECK_FLAG ONLINE_PRINT_FLAG EFT_USER_NUMBER MAX_OUTLAY VENDOR_PAY_GROUP_ LOOKUP_CODE REQUIRE_TAX_ENTRY_ FLAG APPROVALS_OPTION POST_DATED_PAYMENTS_ FLAG SECONDARY_ ACCOUNTING_METHOD SECONDARY_SET_OF_ BOOKS_ID TAKE_VAT_BEFORE_ DISCOUNT_FLAG INTEREST_TOLERANCE_ AMOUNT INTEREST_CODE_ COMBINATION_ID TERMS_DATE_BASIS ALLOW_FUTURE_PAY_ FLAG AUTO_TAX_CALC_FLAG AUTOMATIC_OFFSETS_ FLAG LIABILITY_POST_ LOOKUP_CODE INTEREST_ACCTS_PAY_ CCID LIABILITY_POST_ OPTION DISCOUNT_ DISTRIBUTION_METHOD RATE_VAR_CODE_ COMBINATION_ID COMBINED_FILING_FLAG INCOME_TAX_REGION INCOME_TAX_REGION_ FLAG HOLD_UNMATCHED_ INVOICES_FLAG ALLOW_DIST_MATCH_ FLAG ALLOW_FINAL_MATCH_ FLAG ALLOW_FLEX_OVERRIDE_ FLAG ALLOW_PAID_INVOICE_ ADJUST USSGL_TRANSACTION_ CODE USSGL_TRX_CODE_ CONTEXT INV_DOC_CATEGORY_ OVERRIDE PAY_DOC_CATEGORY_ OVERRIDE VENDOR_AUTO_INT_ DEFAULT SUMMARY_JOURNALS_ DEFAULT RATE_VAR_GAIN_CCID RATE_VAR_LOSS_CCID TRANSFER_DESC_FLEX_ FLAG ALLOW_AWT_FLAG DEFAULT_AWT_GROUP_ID ALLOW_AWT_OVERRIDE CREATE_AWT_DISTS_ TYPE CREATE_AWT_INVOICES_ TYPE AWT_INCLUDE_ DISCOUNT_AMT AWT_INCLUDE_TAX_AMT ORG_ID RECON_ACCOUNTING_ FLAG AUTO_CREATE_FREIGHT_ FLAG FREIGHT_CODE_ COMBINATION_ID GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 ALLOW_SUPPLIER_BANK_ OVERRIDE USE_MULTIPLE_ SUPPLIER_BANKS AUTO_TAX_CALC_ OVERRIDE AMOUNT_INCLUDES_TAX_ FLAG AMOUNT_INCLUDES_TAX_ OVERRIDE VAT_CODE USE_BANK_CHARGE_FLAG BANK_CHARGE_BEARER ROUNDING_ERROR_CCID ROUNDING_ERROR_POST_ OPTION TAX_FROM_PO_FLAG TAX_FROM_VENDOR_ SITE_FLAG TAX_FROM_VENDOR_FLAG TAX_FROM_ACCOUNT_ FLAG TAX_FROM_SYSTEM_FLAG TAX_FROM_INV_HEADER_ FLAG TAX_FROM_TEMPLATE_ FLAG TAX_HIER_PO_SHIPMENT TAX_HIER_VENDOR TAX_HIER_VENDOR_SITE TAX_HIER_ACCOUNT TAX_HIER_SYSTEM TAX_HIER_INVOICE TAX_HIER_TEMPLATE ENFORCE_TAX_FROM_ ACCOUNT MRC_BASE_CURRENCY_ CODE MRC_SECONDARY_SET_ OF_BOOKS_ID MATCH_OPTION GAIN_LOSS_CALC_LEVEL WHEN_TO_ACCOUNT_PMT WHEN_TO_ACCOUNT_ GAIN_LOSS FUTURE_DATED_PMT_ ACCT_SOURCE FUTURE_DATED_PMT_ LIAB_RELIEF GL_TRANSFER_ALLOW_ OVERRIDE GL_TRANSFER_PROCESS_ DAYS GL_TRANSFER_MODE GL_TRANSFER_SUBMIT_ JOURNAL_IMP INCLUDE_REPORTING_ SOB EXPENSE_REPORT_ID PREPAYMENT_TERMS_ID CALC_USER_XRATE SORT_BY_ALTERNATE_ FIELD APPROVAL_WORKFLOW_ FLAG ALLOW_FORCE_ APPROVAL_FLAG VALIDATE_BEFORE_ APPROVAL_FLAG XML_PAYMENTS_AUTO_ CONFIRM_FLAG PRORATE_INT_INV_ ACROSS_DISTS BUILD_PREPAYMENT_ ACCOUNTS_FLAG ENABLE_1099_ON_AWT_ FLAG STOP_PREPAY_ACROSS_ BAL_FLAG AUTOMATIC_OFFSETS_ CHANGE_FLAG TOLERANCE_ID PREPAY_TAX_DIFF_CCID CE_BANK_ACCT_USE_ID APPROVAL_TIMING SERVICES_TOLERANCE_ ID RECEIPT_ACCEPTANCE_ DAYS TAX_TOLERANCE TAX_TOL_AMT_RANGE 1/10/2008 17:9:53 1166 2022 NTD N N         VOID EXCEPT LAST         2026     2028     N           Y       2027 Y Y 1000 2000 2001 Y Y S                 MMDDYY Y N       N BOTH Y           Invoice N N             N     N N N N N     N N   N 2030 2031 N Y   N PAYMENT PAYMENT N N 81 N N                                             Y N N N N   N   2003                                         ALWAYS ALWAYS SUPPLIER SITE ISSUE             10001 Y N N N N

    1 row retrieved
  
  
• See SQL
  
  

  FINANCIALS_SYSTEM_PARAMS_ALL

  LAST_UPDATE_DATE LAST_UPDATED_BY SET_OF_BOOKS_ID PAYMENT_METHOD_ LOOKUP_CODE USER_DEFINED_VENDOR_ NUM_CODE VENDOR_NUM_START_NUM SHIP_TO_LOCATION_ID BILL_TO_LOCATION_ID SHIP_VIA_LOOKUP_CODE FOB_LOOKUP_CODE TERMS_ID ALWAYS_TAKE_DISC_ FLAG PAY_DATE_BASIS_ LOOKUP_CODE INVOICE_CURRENCY_ CODE PAYMENT_CURRENCY_ CODE ACCTS_PAY_CODE_ COMBINATION_ID PREPAY_CODE_ COMBINATION_ID DISC_TAKEN_CODE_ COMBINATION_ID FUTURE_PERIOD_LIMIT RESERVE_AT_ COMPLETION_FLAG RES_ENCUMB_CODE_ COMBINATION_ID REQ_ENCUMBRANCE_FLAG REQ_ENCUMBRANCE_ TYPE_ID PURCH_ENCUMBRANCE_ FLAG PURCH_ENCUMBRANCE_ TYPE_ID INV_ENCUMBRANCE_ TYPE_ID MANUAL_VENDOR_NUM_ TYPE INVENTORY_ ORGANIZATION_ID LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY FREIGHT_TERMS_ LOOKUP_CODE RFQ_ONLY_SITE_FLAG RECEIPT_ACCEPTANCE_ DAYS BUSINESS_GROUP_ID EXPENSE_CHECK_ ADDRESS_FLAG TERMS_DATE_BASIS USE_POSITIONS_FLAG RATE_VAR_CODE_ COMBINATION_ID HOLD_UNMATCHED_ INVOICES_FLAG EXCLUSIVE_PAYMENT_ FLAG REVISION_SORT_ ORDERING VAT_REGISTRATION_NUM VAT_COUNTRY_CODE RATE_VAR_GAIN_CCID RATE_VAR_LOSS_CCID ORG_ID BANK_CHARGE_BEARER VAT_CODE MATCH_OPTION NON_RECOVERABLE_TAX_ FLAG TAX_ROUNDING_RULE PRECISION MINIMUM_ACCOUNTABLE_ UNIT DEFAULT_RECOVERY_ RATE CASH_BASIS_ENC_NR_ TAX FUTURE_DATED_ PAYMENT_CCID EXPENSE_CLEARING_ CCID MISC_CHARGE_CCID GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 RETAINAGE_CODE_ COMBINATION_ID 7/27/2007 15:29:56 1112 2022       142 142               2026 2027 2028 1 N   N   N       81 34969 7/27/2007 14:24:24 1110   N   0 H   Y           TW 2030 2031 81                   2029

    1 row retrieved
  
  
• See SQL
  
  

  HR_OPERATING_UNITS

  BUSINESS_GROUP_ID ORGANIZATION_ID NAME DATE_FROM DATE_TO SHORT_CODE SET_OF_BOOKS_ID DEFAULT_LEGAL_ CONTEXT_ID USABLE_FLAG 0 81 Acer Incorporated 1/1/1951 0:0:0   AI 2022 23273

    1 row retrieved
  
  
• See SQL
  
  

  GL_LEDGERS

  LEDGER_ID NAME SHORT_NAME DESCRIPTION LEDGER_CATEGORY_CODE ALC_LEDGER_TYPE_CODE OBJECT_TYPE_CODE LE_LEDGER_TYPE_CODE COMPLETION_STATUS_ CODE CONFIGURATION_ID CHART_OF_ACCOUNTS_ID CURRENCY_CODE PERIOD_SET_NAME ACCOUNTED_PERIOD_ TYPE FIRST_LEDGER_PERIOD_ NAME RET_EARN_CODE_ COMBINATION_ID SUSPENSE_ALLOWED_ FLAG ALLOW_INTERCOMPANY_ POST_FLAG TRACK_ROUNDING_ IMBALANCE_FLAG ENABLE_AVERAGE_ BALANCES_FLAG CUM_TRANS_CODE_ COMBINATION_ID RES_ENCUMB_CODE_ COMBINATION_ID NET_INCOME_CODE_ COMBINATION_ID ROUNDING_CODE_ COMBINATION_ID ENABLE_BUDGETARY_ CONTROL_FLAG REQUIRE_BUDGET_ JOURNALS_FLAG ENABLE_JE_APPROVAL_ FLAG ENABLE_AUTOMATIC_ TAX_FLAG CONSOLIDATION_ LEDGER_FLAG TRANSLATE_EOD_FLAG TRANSLATE_QATD_FLAG TRANSLATE_YATD_FLAG TRANSACTION_ CALENDAR_ID DAILY_TRANSLATION_ RATE_TYPE AUTOMATICALLY_ CREATED_FLAG BAL_SEG_VALUE_ OPTION_CODE BAL_SEG_COLUMN_NAME MGT_SEG_VALUE_ OPTION_CODE MGT_SEG_COLUMN_NAME BAL_SEG_VALUE_SET_ID MGT_SEG_VALUE_SET_ID IMPLICIT_ACCESS_SET_ ID CRITERIA_SET_ID FUTURE_ENTERABLE_ PERIODS_LIMIT LEDGER_ATTRIBUTES IMPLICIT_LEDGER_SET_ ID LATEST_OPENED_ PERIOD_NAME LATEST_ENCUMBRANCE_ YEAR PERIOD_AVERAGE_RATE_ TYPE PERIOD_END_RATE_TYPE BUDGET_PERIOD_AVG_ RATE_TYPE BUDGET_PERIOD_END_ RATE_TYPE SLA_ACCOUNTING_ METHOD_CODE SLA_ACCOUNTING_ METHOD_TYPE SLA_DESCRIPTION_ LANGUAGE SLA_ENTERED_CUR_BAL_ SUS_CCID SLA_SEQUENCING_FLAG SLA_BAL_BY_LEDGER_ CURR_FLAG SLA_LEDGER_CUR_BAL_ SUS_CCID ENABLE_SECONDARY_ TRACK_FLAG ENABLE_REVAL_SS_ TRACK_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN CONTEXT ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ENABLE_ RECONCILIATION_FLAG CREATE_JE_FLAG SLA_LEDGER_CASH_ BASIS_FLAG COMPLETE_FLAG 2022 Acer Incorporated AI Acer Incorporated Primary Ledger PRIMARY NONE L L   1001 50308 NTD Acer_G_Calendar 21 DEC-05 1001 N N N N         N N N N N N N N     N I SEGMENT1 A SEGMENT7 1012975 1012980 1000 2001 2 L   MAY-08 2005         ACER_TW_STANDARD_ACCRUAL C US 1000   N       1/2/2008 0:0:0 1168 7/19/2007 0:0:0 1090 70467                                 Y Y N Y

    1 row retrieved
  
  
• See SQL
  
  

  XLE_ENTITY_PROFILES

  LEGAL_ENTITY_ID PARTY_ID LEGAL_ENTITY_ IDENTIFIER NAME GEOGRAPHY_ID TRANSACTING_ENTITY_ FLAG EFFECTIVE_FROM EFFECTIVE_TO LE_INFORMATION_ CONTEXT LE_INFORMATION1 LE_INFORMATION2 LE_INFORMATION3 LE_INFORMATION4 LE_INFORMATION5 LE_INFORMATION6 LE_INFORMATION7 LE_INFORMATION8 LE_INFORMATION9 LE_INFORMATION10 LE_INFORMATION11 LE_INFORMATION12 LE_INFORMATION13 LE_INFORMATION14 LE_INFORMATION15 LE_INFORMATION16 LE_INFORMATION17 LE_INFORMATION18 LE_INFORMATION19 LE_INFORMATION20 LAST_UPDATED_BY CREATION_DATE LAST_UPDATE_LOGIN LAST_UPDATE_DATE CREATED_BY OBJECT_VERSION_ NUMBER ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ACTIVITY_CODE SUB_ACTIVITY_CODE TYPE_OF_COMPANY 23273 3041 AI001 Acer Incorporated 10218 Y     TW                                         1090 7/19/2007 11:24:2 34067 7/19/2007 11:29:41 1090 3

    1 row retrieved
  
  
• See SQL
  
  

  FND_PRODUCT_INSTALLATIONS

  APPLICATION_ID ORACLE_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN PRODUCT_VERSION STATUS INDUSTRY TABLESPACE INDEX_TABLESPACE TEMPORARY_TABLESPACE SIZING_FACTOR INSTALL_GROUP_NUM DB_STATUS PATCH_LEVEL 200 200 7/17/2007 9:31:20 1 5/14/2000 18:25:54 1 0 12.0.0 I C APPS_TS_TX_DATA APPS_TS_TX_IDX TEMP 100 1 I R12.AP.A.3

    1 row retrieved
  
  
• See SQL
  
  

  FND_PRODUCT_GROUPS

  PRODUCT_GROUP_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN PRODUCT_GROUP_NAME RELEASE_NAME PRODUCT_GROUP_TYPE ARGUMENT1 MULTI_ORG_FLAG MULTI_LINGUAL_FLAG MULTI_CURRENCY_FLAG APPLICATIONS_SYSTEM_ NAME IS_NEW_TS_MODE ARU_RELEASE_NAME 1 12/11/2007 21:32:55 1 5/14/2000 19:15:33 1 0 Default product group 12.0.3 Standard   Y N N FIP Y R12

    1 row retrieved
  
  
• See SQL
  
  

Summary     [Top]

• AP_INVOICES_ALL Key Columns

  INVOICE_ID INVOICE_NUM VENDOR_NAME INVOICE_DATE INVOICE_AMOUNT BASE_AMOUNT INVOICE_TYPE_LOOKUP_ CODE INVOICE_CURRENCY_ CODE PAYMENT_CURRENCY_ CODE LEGAL_ENTITY_ID ORG_ID 72822 IM80306310A 澶ф柟寤ｈ硣瑷婅偂浠芥湁闄愬叕鍙� 3/21/2008 0:0:0 0 0 CREDIT NTD NTD 23273 81

    1 row retrieved
  
  
• See SQL
  
  

ATTENTION - The above result contains a join to the AP_SUPPLIERS
table to retrieve the supplier name

• 
  

  AP_INVOICE_LINES_ALL Key Columns

  LINE_NUMBER LINE_TYPE_LOOKUP_ CODE LINE_SOURCE ACCOUNTING_DATE PERIOD_NAME DEFERRED_ACCTG_FLAG ORG_ID 1 ITEM HEADER MATCH 3/21/2008 0:0:0 MAR-08 N 81 4 TAX ETAX 5/1/2008 0:0:0 MAY-08 N 81 5 ITEM HEADER MATCH 5/1/2008 0:0:0 MAY-08 N 81 6 TAX ETAX 5/1/2008 0:0:0   N 81

    4 rows retrieved
  
  
• See SQL
  
  

  AP_INVOICE_DISTRIBUTIONS_ALL Key Columns

  INVOICE_ID INVOICE_LINE_NUMBER DISTRIBUTION_LINE_ NUMBER LINE_TYPE_LOOKUP_ CODE ACCOUNTING_DATE PERIOD_NAME AMOUNT BASE_AMOUNT POSTED_FLAG DIST_CODE_ COMBINATION_ID ACCOUNTING_EVENT_ID INVOICE_ DISTRIBUTION_ID PARENT_REVERSAL_ID PO_DISTRIBUTION_ID ORG_ID 72822 1 1 ACCRUAL 3/21/2008 0:0:0 MAR-08 -2133 -2133 Y 2008 407380 436473   28515 81 72822 4 5 REC_TAX 3/21/2008 0:0:0 MAR-08 -107 -107 Y 2034 407380 436474     81 72822 4 3 REC_TAX 3/21/2008 0:0:0 MAR-08 107 107 S 2034 555468 630712 436474   81 72822 4 6 REC_TAX 3/21/2008 0:0:0 MAR-08 -107 -107 S 2034 555468 630713     81 72822 4 4 REC_TAX 3/21/2008 0:0:0 MAR-08 107 107 S 2034 555468 630714 630713   81 72822 4 1 REC_TAX 3/21/2008 0:0:0 MAR-08 -107 -107 S 2034 555468 630715     81 72822 1 4 ACCRUAL 4/1/2008 0:0:0 APR-08 2133 2133 S 2008 555493 630788 436473 28515 81 72822 4 2 REC_TAX 4/1/2008 0:0:0 APR-08 107 107 S 2034 555493 630789 630715   81 72822 5 1 ACCRUAL 5/1/2008 0:0:0 MAY-08 -2133 -2133 S 2008 555494 630790   28515 81 72822 6 1 REC_TAX 5/1/2008 0:0:0 MAY-08 -107 -107 S 2034 555494 630791     81 72822 5 2 ACCRUAL 5/1/2008 0:0:0 MAY-08 2133 2133 N 2008   634577 630790 28515 81 72822 6 2 REC_TAX 5/1/2008 0:0:0 MAY-08 107 107 N 2034   634578 630791   81

    12 rows retrieved
  
  
• See SQL
  
  

  AP_PAYMENT_SCHEDULES_ALL Key Columns

  AMOUNT_REMAINING BATCH_ID DUE_DATE GROSS_AMOUNT HOLD_FLAG INVOICE_ID PAYMENT_NUM PAYMENT_STATUS_FLAG ORG_ID 0 16338 6/30/2008 0:0:0 0 N 72822 1 N 81

    1 row retrieved
  
  
• See SQL
  
  

  AP_HOLDS_ALL Key Columns

  HELD_BY HOLD_DATE HOLD_LOOKUP_CODE HOLD_REASON INVOICE_ID RELEASE_LOOKUP_CODE RELEASE_REASON STATUS_FLAG ORG_ID 5 5/8/2008 17:6:45 DIST VARIANCE Total of invoice distribu 72822 VARIANCE CORRECTED Invoice variance correcte R 81

    1 row retrieved
  
  
• See SQL
  
  

  AP_DOCUMENTS_PAYABLE Key Columns

  PAY_PROC_TRXN_TYPE_ CODE CHECK_ID INVOICE_ID INVOICE_PAYMENT_ID INVOICE_NUMBER PAYMENT_FUNCTION PAYMENT_DATE DOCUMENT_DATE DOCUMENT_TYPE PAYMENT_CURRENCY_ CODE PAYMENT_AMOUNT PAYMENT_METHOD_CODE

    0 rows retrieved
  
  
• See SQL
  
  

  AP_INVOICE_PAYMENTS_ALL Key Columns

  CHECK_ID INVOICE_PAYMENT_ID AMOUNT PAYMENT_BASE_AMOUNT INVOICE_BASE_AMOUNT ACCOUNTING_DATE PERIOD_NAME POSTED_FLAG ACCOUNTING_EVENT_ID INVOICE_ID ORG_ID

    0 rows retrieved
  
  
• See SQL
  
  

  AP_CHECKS_ALL Key Columns

  CHECK_ID CHECK_NUMBER VENDOR_SITE_CODE AMOUNT BASE_AMOUNT CHECKRUN_ID CHECKRUN_NAME CHECK_DATE STATUS_LOOKUP_CODE VOID_DATE ORG_ID

    0 rows retrieved
  
  
• See SQL
  
  

  AP_PAYMENT_HISTORY_ALL Key Columns

  PAYMENT_HISTORY_ID CHECK_ID ACCOUNTING_DATE TRANSACTION_TYPE POSTED_FLAG ACCOUNTING_EVENT_ID REV_PMT_HIST_ID ORG_ID

    0 rows retrieved
  
  
• See SQL
  
  

  AP_SELECTED_INVOICES_ALL Key Columns

  CHECKRUN_NAME PAYMENT_NUM PAYMENT_AMOUNT OK_TO_PAY_FLAG DONT_PAY_REASON_CODE VENDOR_NAME VENDOR_SITE_CODE PAY_SELECTED_CHECK_ ID PRINT_SELECTED_ CHECK_ID ORG_ID

    0 rows retrieved
  
  
• See SQL
  
  

  AP_SELECTED_INVOICE_CHECKS_ALL Key Columns

  CHECKRUN_NAME CHECK_NUMBER CHECK_AMOUNT OK_TO_PAY_FLAG DONT_PAY_REASON_CODE STATUS_LOOKUP_CODE VENDOR_NAME VENDOR_SITE_CODE CHECK_ID SELECTED_CHECK_ID ORG_ID

    0 rows retrieved
  
  
• See SQL
  
  

Trial Balance     [Top]

• INVOICE_ID CODE_COMBINATION_ID REMAINING_AMOUNT VENDOR_ID SET_OF_BOOKS_ID ORG_ID REQUEST_ID INVOICE_AMOUNT

    0 rows retrieved
  
  
• See SQL
  
  

Invoice     [Top]
Several of the query results below have added account columns showing the account segment values. These columns were added to show the corresponding account value for tables with code combination ids.

• AP_BATCHES_ALL

  BATCH_ID BATCH_NAME BATCH_DATE LAST_UPDATE_DATE LAST_UPDATED_BY CONTROL_INVOICE_ COUNT CONTROL_INVOICE_ TOTAL ACTUAL_INVOICE_COUNT ACTUAL_INVOICE_TOTAL INVOICE_CURRENCY_ CODE PAYMENT_CURRENCY_ CODE LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY PAY_GROUP_LOOKUP_ CODE BATCH_CODE_ COMBINATION_ID TERMS_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 INVOICE_TYPE_LOOKUP_ CODE HOLD_LOOKUP_CODE HOLD_REASON DOC_CATEGORY_CODE ORG_ID GL_DATE PAYMENT_PRIORITY 16338 001-9108418-D-U-5373 3/31/2008 0:0:0 3/31/2008 9:24:59 1231             199014 3/31/2008 9:24:59 1231                                       STANDARD

    1 row retrieved
  
  
• See SQL
  
  

  AP_INVOICES_ALL

  INVOICE_ID LAST_UPDATE_DATE LAST_UPDATED_BY VENDOR_ID INVOICE_NUM SET_OF_BOOKS_ID INVOICE_CURRENCY_ CODE PAYMENT_CURRENCY_ CODE PAYMENT_CROSS_RATE INVOICE_AMOUNT VENDOR_SITE_ID AMOUNT_PAID DISCOUNT_AMOUNT_ TAKEN INVOICE_DATE SOURCE INVOICE_TYPE_LOOKUP_ CODE DESCRIPTION BATCH_ID AMOUNT_APPLICABLE_ TO_DISCOUNT TAX_AMOUNT TERMS_ID TERMS_DATE PAYMENT_METHOD_ LOOKUP_CODE PAY_GROUP_LOOKUP_ CODE ACCTS_PAY_CODE_ COMBINATION_ID PAYMENT_STATUS_FLAG CREATION_DATE CREATED_BY BASE_AMOUNT VAT_CODE LAST_UPDATE_LOGIN EXCLUSIVE_PAYMENT_ FLAG PO_HEADER_ID FREIGHT_AMOUNT GOODS_RECEIVED_DATE INVOICE_RECEIVED_ DATE VOUCHER_NUM APPROVED_AMOUNT RECURRING_PAYMENT_ID EXCHANGE_RATE EXCHANGE_RATE_TYPE EXCHANGE_DATE EARLIEST_SETTLEMENT_ DATE ORIGINAL_PREPAYMENT_ AMOUNT DOC_SEQUENCE_ID DOC_SEQUENCE_VALUE DOC_CATEGORY_CODE ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_CATEGORY APPROVAL_STATUS APPROVAL_DESCRIPTION INVOICE_ DISTRIBUTION_TOTAL POSTING_STATUS PREPAY_FLAG AUTHORIZED_BY CANCELLED_DATE CANCELLED_BY CANCELLED_AMOUNT TEMP_CANCELLED_ AMOUNT PROJECT_ACCOUNTING_ CONTEXT USSGL_TRANSACTION_ CODE USSGL_TRX_CODE_ CONTEXT PROJECT_ID TASK_ID EXPENDITURE_TYPE EXPENDITURE_ITEM_ DATE PA_QUANTITY EXPENDITURE_ ORGANIZATION_ID PA_DEFAULT_DIST_CCID VENDOR_PREPAY_AMOUNT PAYMENT_AMOUNT_TOTAL AWT_FLAG AWT_GROUP_ID REFERENCE_1 REFERENCE_2 ORG_ID PRE_WITHHOLDING_ AMOUNT GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 AUTO_TAX_CALC_FLAG PAYMENT_CROSS_RATE_ TYPE PAYMENT_CROSS_RATE_ DATE PAY_CURR_INVOICE_ AMOUNT MRC_BASE_AMOUNT MRC_EXCHANGE_RATE MRC_EXCHANGE_RATE_ TYPE MRC_EXCHANGE_DATE GL_DATE AWARD_ID PAID_ON_BEHALF_ EMPLOYEE_ID AMT_DUE_CCARD_ COMPANY AMT_DUE_EMPLOYEE APPROVAL_READY_FLAG APPROVAL_ITERATION WFAPPROVAL_STATUS REQUESTER_ID VALIDATION_REQUEST_ ID VALIDATED_TAX_AMOUNT QUICK_CREDIT CREDITED_INVOICE_ID DISTRIBUTION_SET_ID APPLICATION_ID PRODUCT_TABLE REFERENCE_KEY1 REFERENCE_KEY2 REFERENCE_KEY3 REFERENCE_KEY4 REFERENCE_KEY5 TOTAL_TAX_AMOUNT SELF_ASSESSED_TAX_ AMOUNT TAX_RELATED_INVOICE_ ID TRX_BUSINESS_ CATEGORY USER_DEFINED_FISC_ CLASS TAXATION_COUNTRY DOCUMENT_SUB_TYPE SUPPLIER_TAX_ INVOICE_NUMBER SUPPLIER_TAX_ INVOICE_DATE SUPPLIER_TAX_ EXCHANGE_RATE TAX_INVOICE_ RECORDING_DATE TAX_INVOICE_ INTERNAL_SEQ LEGAL_ENTITY_ID HISTORICAL_FLAG FORCE_REVALIDATION_ FLAG BANK_CHARGE_BEARER REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE3 UNIQUE_REMITTANCE_ IDENTIFIER URI_CHECK_DIGIT SETTLEMENT_PRIORITY PAYMENT_REASON_CODE PAYMENT_REASON_ COMMENTS PAYMENT_METHOD_CODE DELIVERY_CHANNEL_ CODE QUICK_PO_HEADER_ID NET_OF_RETAINAGE_ FLAG RELEASE_AMOUNT_NET_ OF_TAX CONTROL_AMOUNT PARTY_ID PARTY_SITE_ID PAY_PROC_TRXN_TYPE_ CODE PAYMENT_FUNCTION CUST_REGISTRATION_ CODE CUST_REGISTRATION_ NUMBER PORT_OF_ENTRY_CODE EXTERNAL_BANK_ ACCOUNT_ID VENDOR_CONTACT_ID INTERNAL_CONTACT_ EMAIL DISC_IS_INV_LESS_ TAX_FLAG EXCLUDE_FREIGHT_ FROM_DISCOUNT Accts Pay Account 72822 5/12/2008 16:49:54 1290 6217 IM80306310A 2022 NTD NTD 1 0 4589 0   3/21/2008 0:0:0 Manual Invoice Entry CREDIT XU41871475 16338 -2240   10022 3/21/2008 0:0:0   001CITI10L 2026 N 3/31/2008 9:34:35 1231 0   263250 N           -2240             52 80309663 CRM INV 澶ф柟寤ｈ硣瑷婅偂浠芥湁闄愬叕鍙� 67                           81                   -2240                                 81   JA.TW.APXINWKB.INVOICES                                             3/21/2008 0:0:0 0         5/1/2008 0:0:0         Y   NOT REQUIRED       N                   0 0       TW             23273   N BEN                 EFT     N     18443 13145           2320       N 001-2121-00-000-000-0000-0000-000-0000

    1 row retrieved
  
  
• See SQL
  
  

  AP_INVOICE_LINES

  INVOICE_ID LINE_NUMBER LINE_TYPE_LOOKUP_ CODE REQUESTER_ID DESCRIPTION LINE_SOURCE ORG_ID LINE_GROUP_NUMBER INVENTORY_ITEM_ID ITEM_DESCRIPTION SERIAL_NUMBER MANUFACTURER MODEL_NUMBER WARRANTY_NUMBER GENERATE_DISTS MATCH_TYPE DISTRIBUTION_SET_ID ACCOUNT_SEGMENT BALANCING_SEGMENT COST_CENTER_SEGMENT OVERLAY_DIST_CODE_ CONCAT DEFAULT_DIST_CCID PRORATE_ACROSS_ALL_ ITEMS ACCOUNTING_DATE PERIOD_NAME DEFERRED_ACCTG_FLAG DEF_ACCTG_START_DATE DEF_ACCTG_END_DATE DEF_ACCTG_NUMBER_OF_ PERIODS DEF_ACCTG_PERIOD_ TYPE SET_OF_BOOKS_ID AMOUNT BASE_AMOUNT ROUNDING_AMT QUANTITY_INVOICED UNIT_MEAS_LOOKUP_ CODE UNIT_PRICE WFAPPROVAL_STATUS USSGL_TRANSACTION_ CODE DISCARDED_FLAG ORIGINAL_AMOUNT ORIGINAL_BASE_AMOUNT ORIGINAL_ROUNDING_ AMT CANCELLED_FLAG INCOME_TAX_REGION TYPE_1099 STAT_AMOUNT PREPAY_INVOICE_ID PREPAY_LINE_NUMBER INVOICE_INCLUDES_ PREPAY_FLAG CORRECTED_INV_ID CORRECTED_LINE_ NUMBER PO_HEADER_ID PO_LINE_ID PO_RELEASE_ID PO_LINE_LOCATION_ID PO_DISTRIBUTION_ID RCV_TRANSACTION_ID FINAL_MATCH_FLAG ASSETS_TRACKING_FLAG ASSET_BOOK_TYPE_CODE ASSET_CATEGORY_ID PROJECT_ID TASK_ID EXPENDITURE_TYPE EXPENDITURE_ITEM_ DATE EXPENDITURE_ ORGANIZATION_ID PA_QUANTITY PA_CC_AR_INVOICE_ID PA_CC_AR_INVOICE_ LINE_NUM PA_CC_PROCESSED_CODE AWARD_ID AWT_GROUP_ID REFERENCE_1 REFERENCE_2 RECEIPT_VERIFIED_ FLAG RECEIPT_REQUIRED_ FLAG RECEIPT_MISSING_FLAG JUSTIFICATION EXPENSE_GROUP START_EXPENSE_DATE END_EXPENSE_DATE RECEIPT_CURRENCY_ CODE RECEIPT_CONVERSION_ RATE RECEIPT_CURRENCY_ AMOUNT DAILY_AMOUNT WEB_PARAMETER_ID ADJUSTMENT_REASON MERCHANT_DOCUMENT_ NUMBER MERCHANT_NAME MERCHANT_REFERENCE MERCHANT_TAX_REG_ NUMBER MERCHANT_TAXPAYER_ID COUNTRY_OF_SUPPLY CREDIT_CARD_TRX_ID COMPANY_PREPAID_ INVOICE_ID CC_REVERSAL_FLAG CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE REQUEST_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 LINE_SELECTED_FOR_ APPL_FLAG PREPAY_APPL_REQUEST_ ID APPLICATION_ID PRODUCT_TABLE REFERENCE_KEY1 REFERENCE_KEY2 REFERENCE_KEY3 REFERENCE_KEY4 REFERENCE_KEY5 PURCHASING_CATEGORY_ ID COST_FACTOR_ID CONTROL_AMOUNT ASSESSABLE_VALUE TOTAL_REC_TAX_AMOUNT TOTAL_NREC_TAX_ AMOUNT TOTAL_REC_TAX_AMT_ FUNCL_CURR TOTAL_NREC_TAX_AMT_ FUNCL_CURR INCLUDED_TAX_AMOUNT PRIMARY_INTENDED_USE TAX_ALREADY_ CALCULATED_FLAG SHIP_TO_LOCATION_ID PRODUCT_TYPE PRODUCT_CATEGORY PRODUCT_FISC_ CLASSIFICATION USER_DEFINED_FISC_ CLASS TRX_BUSINESS_ CATEGORY SUMMARY_TAX_LINE_ID TAX_REGIME_CODE TAX TAX_JURISDICTION_ CODE TAX_STATUS_CODE TAX_RATE_ID TAX_RATE_CODE TAX_RATE TAX_CODE_ID HISTORICAL_FLAG TAX_CLASSIFICATION_ CODE SOURCE_APPLICATION_ ID SOURCE_EVENT_CLASS_ CODE SOURCE_ENTITY_CODE SOURCE_TRX_ID SOURCE_LINE_ID SOURCE_TRX_LEVEL_ TYPE RETAINED_AMOUNT RETAINED_AMOUNT_ REMAINING RETAINED_INVOICE_ID RETAINED_LINE_NUMBER LINE_SELECTED_FOR_ RELEASE_FLAG LINE_OWNER_ROLE DISPUTABLE_FLAG RCV_SHIPMENT_LINE_ID 72822 1 ITEM   7121.00004.J91|婕㈡浉鍒楀嵃绯荤当 鍠鐗� HEADER MATCH 81     7121.00004.J91|婕㈡浉鍒楀嵃绯荤当 鍠鐗�         D ITEM_TO_RECEIPT             N 3/21/2008 0:0:0 MAR-08 N         2022 0 0 0 -1 Each 2133 NOT REQUIRED   Y -2133     N                 13231 28553   28213 28515 126817   N                                                                           3/31/2008 0:0:0 1231 1231 5/8/2008 0:0:0 258509         81                                                                                                 2133             Y 142 GOODS                             P035             0 0           92909 72822 4 TAX   TW_VAT - TW_VAT ETAX 81               D NOT_MATCHED             N 5/1/2008 0:0:0 MAY-08 N         2022 0 0 0       NOT REQUIRED     0 0   Y                             N                                                                             5/8/2008 0:0:0 1231 1166 5/8/2008 17:46:19 258724         81                                                                                                           0                 1089348 TW_VAT TW_VAT TW_VAT TW_VAT 10009 P035 5                   0 0             72822 5 ITEM   7121.00004.J91|婕㈡浉鍒楀嵃绯荤当 鍠鐗� HEADER MATCH 81     7121.00004.J91|婕㈡浉鍒楀嵃绯荤当 鍠鐗�         D ITEM_TO_RECEIPT             N 5/1/2008 0:0:0 MAY-08 N         2022 0 0 0 -1 Each 2133 NOT REQUIRED     -2133     Y                 13231 28553   28213 28515 126817   N                                                                           5/8/2008 0:0:0 1166 1166 5/8/2008 0:0:0 259290         81                                                                                                 2133             Y 142 GOODS                             P135             0 0           92909 72822 6 TAX   TW_VAT - TW_VAT ETAX 81               D NOT_MATCHED             N 5/1/2008 0:0:0   N         2022 0 0 0       NOT REQUIRED     -107     Y                             N                                                                             5/8/2008 17:17:11 1166 1166 5/8/2008 17:46:19 258724                                                                                                                     0                 1089378 TW_VAT TW_VAT TW_VAT TW_VAT 10073 P135 5                   0 0

    4 rows retrieved
  
  
• See SQL
  
  

  AP_INVOICE_DISTRIBUTIONS_ALL

  ACCOUNTING_DATE ACCRUAL_POSTED_FLAG ASSETS_ADDITION_FLAG ASSETS_TRACKING_FLAG CASH_POSTED_FLAG DISTRIBUTION_LINE_ NUMBER DIST_CODE_ COMBINATION_ID INVOICE_ID INVOICE_LINE_NUMBER LAST_UPDATED_BY LAST_UPDATE_DATE LINE_TYPE_LOOKUP_ CODE PERIOD_NAME SET_OF_BOOKS_ID ACCTS_PAY_CODE_ COMBINATION_ID AMOUNT BASE_AMOUNT BASE_INVOICE_PRICE_ VARIANCE BATCH_ID CREATED_BY CREATION_DATE DESCRIPTION EXCHANGE_RATE_ VARIANCE FINAL_MATCH_FLAG INCOME_TAX_REGION INVOICE_PRICE_ VARIANCE LAST_UPDATE_LOGIN MATCH_STATUS_FLAG POSTED_FLAG PO_DISTRIBUTION_ID PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE QUANTITY_INVOICED RATE_VAR_CODE_ COMBINATION_ID REQUEST_ID REVERSAL_FLAG TYPE_1099 UNIT_PRICE AMOUNT_ENCUMBERED BASE_AMOUNT_ ENCUMBERED ENCUMBERED_FLAG EXCHANGE_DATE EXCHANGE_RATE EXCHANGE_RATE_TYPE PRICE_ADJUSTMENT_ FLAG PRICE_VAR_CODE_ COMBINATION_ID QUANTITY_ UNENCUMBERED STAT_AMOUNT AMOUNT_TO_POST ATTRIBUTE1 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE_CATEGORY BASE_AMOUNT_TO_POST CASH_JE_BATCH_ID EXPENDITURE_ITEM_ DATE EXPENDITURE_ ORGANIZATION_ID EXPENDITURE_TYPE JE_BATCH_ID PARENT_INVOICE_ID PA_ADDITION_FLAG PA_QUANTITY POSTED_AMOUNT POSTED_BASE_AMOUNT PREPAY_AMOUNT_ REMAINING PROJECT_ACCOUNTING_ CONTEXT PROJECT_ID TASK_ID USSGL_TRANSACTION_ CODE USSGL_TRX_CODE_ CONTEXT EARLIEST_SETTLEMENT_ DATE REQ_DISTRIBUTION_ID QUANTITY_VARIANCE BASE_QUANTITY_ VARIANCE PACKET_ID AWT_FLAG AWT_GROUP_ID AWT_TAX_RATE_ID AWT_GROSS_AMOUNT AWT_INVOICE_ID AWT_ORIGIN_GROUP_ID REFERENCE_1 REFERENCE_2 ORG_ID OTHER_INVOICE_ID AWT_INVOICE_PAYMENT_ ID GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 LINE_GROUP_NUMBER RECEIPT_VERIFIED_ FLAG RECEIPT_REQUIRED_ FLAG RECEIPT_MISSING_FLAG JUSTIFICATION EXPENSE_GROUP START_EXPENSE_DATE END_EXPENSE_DATE RECEIPT_CURRENCY_ CODE RECEIPT_CONVERSION_ RATE RECEIPT_CURRENCY_ AMOUNT DAILY_AMOUNT WEB_PARAMETER_ID ADJUSTMENT_REASON AWARD_ID MRC_ACCRUAL_POSTED_ FLAG MRC_CASH_POSTED_FLAG MRC_DIST_CODE_ COMBINATION_ID MRC_AMOUNT MRC_BASE_AMOUNT MRC_BASE_INV_PRICE_ VARIANCE MRC_EXCHANGE_RATE_ VARIANCE MRC_POSTED_FLAG MRC_PROGRAM_ APPLICATION_ID MRC_PROGRAM_ID MRC_PROGRAM_UPDATE_ DATE MRC_RATE_VAR_CCID MRC_REQUEST_ID MRC_EXCHANGE_DATE MRC_EXCHANGE_RATE MRC_EXCHANGE_RATE_ TYPE MRC_AMOUNT_TO_POST MRC_BASE_AMOUNT_TO_ POST MRC_CASH_JE_BATCH_ID MRC_JE_BATCH_ID MRC_POSTED_AMOUNT MRC_POSTED_BASE_ AMOUNT MRC_RECEIPT_ CONVERSION_RATE CREDIT_CARD_TRX_ID DIST_MATCH_TYPE RCV_TRANSACTION_ID INVOICE_ DISTRIBUTION_ID PARENT_REVERSAL_ID TAX_RECOVERABLE_FLAG PA_CC_AR_INVOICE_ID PA_CC_AR_INVOICE_ LINE_NUM PA_CC_PROCESSED_CODE MERCHANT_DOCUMENT_ NUMBER MERCHANT_NAME MERCHANT_REFERENCE MERCHANT_TAX_REG_ NUMBER MERCHANT_TAXPAYER_ID COUNTRY_OF_SUPPLY MATCHED_UOM_LOOKUP_ CODE GMS_BURDENABLE_RAW_ COST ACCOUNTING_EVENT_ID PREPAY_DISTRIBUTION_ ID UPGRADE_POSTED_AMT UPGRADE_BASE_POSTED_ AMT INVENTORY_TRANSFER_ STATUS COMPANY_PREPAID_ INVOICE_ID CC_REVERSAL_FLAG AWT_WITHHELD_AMT INVOICE_INCLUDES_ PREPAY_FLAG PRICE_CORRECT_INV_ID PRICE_CORRECT_QTY PA_CMT_XFACE_FLAG CANCELLATION_FLAG CORRECTED_INVOICE_ DIST_ID ROUNDING_AMT CHARGE_APPLICABLE_ TO_DIST_ID CORRECTED_QUANTITY RELATED_ID ASSET_BOOK_TYPE_CODE ASSET_CATEGORY_ID DISTRIBUTION_CLASS FINAL_PAYMENT_ ROUNDING FINAL_APPLICATION_ ROUNDING AMOUNT_AT_PREPAY_ XRATE CASH_BASIS_FINAL_ APP_ROUNDING AMOUNT_AT_PREPAY_ PAY_XRATE INTENDED_USE DETAIL_TAX_DIST_ID REC_NREC_RATE RECOVERY_RATE_ID RECOVERY_RATE_NAME RECOVERY_TYPE_CODE RECOVERY_RATE_CODE WITHHOLDING_TAX_ CODE_ID TAX_ALREADY_ DISTRIBUTED_FLAG SUMMARY_TAX_LINE_ID TAXABLE_AMOUNT TAXABLE_BASE_AMOUNT EXTRA_PO_ERV PREPAY_TAX_DIFF_ AMOUNT TAX_CODE_ID VAT_CODE AMOUNT_INCLUDES_TAX_ FLAG TAX_CALCULATED_FLAG TAX_RECOVERY_RATE TAX_RECOVERY_ OVERRIDE_FLAG TAX_CODE_OVERRIDE_ FLAG TOTAL_DIST_AMOUNT TOTAL_DIST_BASE_ AMOUNT PREPAY_TAX_PARENT_ID CANCELLED_FLAG OLD_DISTRIBUTION_ID OLD_DIST_LINE_NUMBER AMOUNT_VARIANCE BASE_AMOUNT_VARIANCE HISTORICAL_FLAG RCV_CHARGE_ADDITION_ FLAG AWT_RELATED_ID RELATED_RETAINAGE_ DIST_ID RETAINED_AMOUNT_ REMAINING BC_EVENT_ID RETAINED_INVOICE_ DIST_ID FINAL_RELEASE_ ROUNDING FULLY_PAID_ACCTD_ FLAG ROOT_DISTRIBUTION_ID XINV_PARENT_ REVERSAL_ID RECURRING_PAYMENT_ID RELEASE_INV_DIST_ DERIVED_FROM Accts Pay Account Dist Account 3/21/2008 0:0:0 Y U N N 1 2008 72822 1 1231 3/31/2008 9:35:2 ACCRUAL MAR-08 2022   -2133 -2133   16338 1231 3/31/2008 9:34:49 7121.00004.J91|婕㈡浉鍒楀嵃绯荤当 鍠鐗�         199014 A Y 28515       -1     N   2133     N                                                               E -1                                           81                                                                                                                             ITEM_TO_PO 126817 436473                       Each   407380       N               N               PERMANENT                           Y                         -2133 -2133               N                         001-2129-91-000-000-0000-0000-000-0000 5/1/2008 0:0:0 N U N N 1 2034 72822 6 1166 5/9/2008 9:27:15 REC_TAX MAY-08 2022   -107 -107   16338 1166 5/8/2008 17:17:11 TW_VAT - TW_VAT         258724 T S               N         N                                                               E                             N               81                                                                                                                             NOT_MATCHED   630791   Y                       555494       N               N     630790         PERMANENT             2891567 100 10002 TW_VAT_100 STANDARD       1089378 -2133 -2133     10073             -107 -107               N                         001-1152-00-000-000-0000-0000-000-0000 3/21/2008 0:0:0 N U N N 1 2034 72822 4 1166 5/9/2008 9:27:15 REC_TAX MAR-08 2022   -107 -107   16338 1231 5/8/2008 17:1:34 TW_VAT - TW_VAT         258724 T S               N         N                                                               E                             N               81                                                                                                                             NOT_MATCHED   630715   Y                       555468       N               N     436473         PERMANENT             2891459 100 10002 TW_VAT_100 STANDARD       1089348 -2133 -2133     10009             -107 -107               N                         001-1152-00-000-000-0000-0000-000-0000 5/1/2008 0:0:0 N U N N 1 2008 72822 5 5 5/8/2008 17:47:20 ACCRUAL MAY-08 2022   -2133 -2133   16338 1166 5/8/2008 17:21:13 7121.00004.J91|婕㈡浉鍒楀嵃绯荤当 鍠鐗�         259884 A S 28515       -1     N   2133     R                                                               E -1                                           81                                                                                                                             ITEM_TO_PO 126817 630790                       Each   555494       N               N               PERMANENT                           Y                         -2133 -2133               N                         001-2129-91-000-000-0000-0000-000-0000 5/1/2008 0:0:0 N U N N 2 2008 72822 5 5 5/8/2008 17:47:20 ACCRUAL MAY-08 2022   2133 2133   16338 1166 5/8/2008 17:47:19 7121.00004.J91|婕㈡浉鍒楀嵃绯荤当 鍠鐗�         259884 A N 28515       1     N   2133     R                                                               E 1                                           81                                                                                                                             ITEM_TO_PO 126817 634577 630790                     Each                           Y               PERMANENT                                                     2133 2133               N                         001-2129-91-000-000-0000-0000-000-0000 5/1/2008 0:0:0 N U N N 2 2034 72822 6 1166 5/9/2008 9:27:15 REC_TAX MAY-08 2022   107 107     1166 5/8/2008 17:47:19 TW_VAT - TW_VAT         1166 T N               N         N                                                               E                             N               81                                                                                                                             NOT_MATCHED   634578 630791 Y                               N               Y     634577         PERMANENT             2894347 100 10002   STANDARD       1089378         10073             107 107               N                         001-1152-00-000-000-0000-0000-000-0000 4/1/2008 0:0:0 N U N N 2 2034 72822 4 1166 5/9/2008 9:27:15 REC_TAX APR-08 2022   107 107     1166 5/8/2008 17:18:47 TW_VAT - TW_VAT         258724 T S               N         N                                                               E                             N               81                                                                                                                             NOT_MATCHED   630789 630715 Y                       555493       N                     630788         PERMANENT             2891564 100 10002 TW_VAT_100 STANDARD       1089348 2133 2133     10009             107 107               N                         001-1152-00-000-000-0000-0000-000-0000 3/21/2008 0:0:0 N U Y N 3 2034 72822 4 1166 5/8/2008 17:39:26 REC_TAX MAR-08 2022   107 107   16338 1231 5/8/2008 17:1:34 TW_VAT - TW_VAT         258724 A S               N         R                                                               E                             N               81                                                                                                                             NOT_MATCHED   630712 436474 Y                       555468       N               N     436473         PERMANENT             2891448 100 10002 TW_VAT_100 STANDARD       1089348 2133 2133     10009             107 107               N                         001-1152-00-000-000-0000-0000-000-0000 3/21/2008 0:0:0 N U Y N 4 2034 72822 4 1166 5/8/2008 17:39:26 REC_TAX MAR-08 2022   107 107   16338 1231 5/8/2008 17:1:34 TW_VAT - TW_VAT         258724 A S               N         R                                                               E                             N               81                                                                                                                             NOT_MATCHED   630714 630713 Y                       555468       N               N     436473         PERMANENT             2891458 100 10002 TW_VAT_100 STANDARD       1089348 2133 2133     10073             107 107               N                         001-1152-00-000-000-0000-0000-000-0000 4/1/2008 0:0:0 N U N N 4 2008 72822 1 1166 5/9/2008 9:27:15 ACCRUAL APR-08 2022   2133 2133   16338 1166 5/8/2008 17:18:47 7121.00004.J91|婕㈡浉鍒楀嵃绯荤当 鍠鐗�         259884 T S 28515       1     N   2133     N                                                               E 1                                           81                                                                                                                             ITEM_TO_PO 126817 630788 436473                     Each   555493                                       PERMANENT                           Y                         2133 2133               N                         001-2129-91-000-000-0000-0000-000-0000 3/21/2008 0:0:0 Y U N N 5 2034 72822 4 1166 5/8/2008 17:39:26 REC_TAX MAR-08 2022   -107 -107   16338 1231 3/31/2008 9:25:21 TW_VAT - TW_VAT         258724 A Y               N         N                                                               E                             N               81                                                                                                                             NOT_MATCHED   436474   Y                       407380       N               N     436473         PERMANENT             2702739 100 10002 TW_VAT_100 STANDARD       1089348 -2133 -2133     10009             -107 -107               N                         001-1152-00-000-000-0000-0000-000-0000 3/21/2008 0:0:0 N U N N 6 2034 72822 4 1166 5/9/2008 9:27:15 REC_TAX MAR-08 2022   -107 -107   16338 1231 5/8/2008 17:1:34 TW_VAT - TW_VAT         258724 T S               N         N                                                               E                             N               81                                                                                                                             NOT_MATCHED   630713   Y                       555468       N               N     436473         PERMANENT             2891449 100 10002 TW_VAT_100 STANDARD       1089348 -2133 -2133     10073             -107 -107               N                         001-1152-00-000-000-0000-0000-000-0000

    12 rows retrieved
  
  
• See SQL
  
  

  ZX_LINES

  TAX_LINE_ID INTERNAL_ ORGANIZATION_ID APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE EVENT_TYPE_CODE TRX_ID TRX_LINE_ID TRX_LEVEL_TYPE TRX_LINE_NUMBER DOC_EVENT_STATUS TAX_EVENT_CLASS_CODE TAX_EVENT_TYPE_CODE TAX_LINE_NUMBER CONTENT_OWNER_ID TAX_REGIME_ID TAX_REGIME_CODE TAX_ID TAX TAX_STATUS_ID TAX_STATUS_CODE TAX_RATE_ID TAX_RATE_CODE TAX_RATE TAX_APPORTIONMENT_ LINE_NUMBER TRX_ID_LEVEL2 TRX_ID_LEVEL3 TRX_ID_LEVEL4 TRX_ID_LEVEL5 TRX_ID_LEVEL6 TRX_USER_KEY_LEVEL1 TRX_USER_KEY_LEVEL2 TRX_USER_KEY_LEVEL3 TRX_USER_KEY_LEVEL4 TRX_USER_KEY_LEVEL5 TRX_USER_KEY_LEVEL6 MRC_TAX_LINE_FLAG LEDGER_ID ESTABLISHMENT_ID LEGAL_ENTITY_ID LEGAL_ENTITY_TAX_ REG_NUMBER HQ_ESTB_REG_NUMBER HQ_ESTB_PARTY_TAX_ PROF_ID CURRENCY_CONVERSION_ DATE CURRENCY_CONVERSION_ TYPE CURRENCY_CONVERSION_ RATE TAX_CURRENCY_ CONVERSION_DATE TAX_CURRENCY_ CONVERSION_TYPE TAX_CURRENCY_ CONVERSION_RATE TRX_CURRENCY_CODE MINIMUM_ACCOUNTABLE_ UNIT PRECISION TRX_NUMBER TRX_DATE UNIT_PRICE LINE_AMT TRX_LINE_QUANTITY TAX_BASE_MODIFIER_ RATE REF_DOC_APPLICATION_ ID REF_DOC_ENTITY_CODE REF_DOC_EVENT_CLASS_ CODE REF_DOC_TRX_ID REF_DOC_LINE_ID REF_DOC_LINE_ QUANTITY OTHER_DOC_LINE_AMT OTHER_DOC_LINE_TAX_ AMT OTHER_DOC_LINE_ TAXABLE_AMT UNROUNDED_TAXABLE_ AMT UNROUNDED_TAX_AMT RELATED_DOC_ APPLICATION_ID RELATED_DOC_ENTITY_ CODE RELATED_DOC_EVENT_ CLASS_CODE RELATED_DOC_TRX_ID RELATED_DOC_NUMBER RELATED_DOC_DATE APPLIED_FROM_ APPLICATION_ID APPLIED_FROM_EVENT_ CLASS_CODE APPLIED_FROM_ENTITY_ CODE APPLIED_FROM_TRX_ID APPLIED_FROM_LINE_ID APPLIED_FROM_TRX_ NUMBER ADJUSTED_DOC_ APPLICATION_ID ADJUSTED_DOC_ENTITY_ CODE ADJUSTED_DOC_EVENT_ CLASS_CODE ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_LINE_ID ADJUSTED_DOC_NUMBER ADJUSTED_DOC_DATE APPLIED_TO_ APPLICATION_ID APPLIED_TO_EVENT_ CLASS_CODE APPLIED_TO_ENTITY_ CODE APPLIED_TO_TRX_ID APPLIED_TO_LINE_ID SUMMARY_TAX_LINE_ID OFFSET_LINK_TO_TAX_ LINE_ID OFFSET_FLAG PROCESS_FOR_ RECOVERY_FLAG TAX_JURISDICTION_ID TAX_JURISDICTION_ CODE PLACE_OF_SUPPLY PLACE_OF_SUPPLY_ TYPE_CODE PLACE_OF_SUPPLY_ RESULT_ID TAX_DATE_RULE_ID TAX_DATE TAX_DETERMINE_DATE TAX_POINT_DATE TRX_LINE_DATE TAX_TYPE_CODE TAX_CODE TAX_REGISTRATION_ID TAX_REGISTRATION_ NUMBER REGISTRATION_PARTY_ TYPE ROUNDING_LEVEL_CODE ROUNDING_RULE_CODE ROUNDING_LVL_PARTY_ TAX_PROF_ID ROUNDING_LVL_PARTY_ TYPE COMPOUNDING_TAX_FLAG ORIG_TAX_STATUS_ID ORIG_TAX_STATUS_CODE ORIG_TAX_RATE_ID ORIG_TAX_RATE_CODE ORIG_TAX_RATE ORIG_TAX_ JURISDICTION_ID ORIG_TAX_ JURISDICTION_CODE ORIG_TAX_AMT_ INCLUDED_FLAG ORIG_SELF_ASSESSED_ FLAG TAX_CURRENCY_CODE TAX_AMT TAX_AMT_TAX_CURR TAX_AMT_FUNCL_CURR TAXABLE_AMT TAXABLE_AMT_TAX_CURR TAXABLE_AMT_FUNCL_ CURR ORIG_TAXABLE_AMT ORIG_TAXABLE_AMT_ TAX_CURR CAL_TAX_AMT CAL_TAX_AMT_TAX_CURR CAL_TAX_AMT_FUNCL_ CURR ORIG_TAX_AMT ORIG_TAX_AMT_TAX_ CURR REC_TAX_AMT REC_TAX_AMT_TAX_CURR REC_TAX_AMT_FUNCL_ CURR NREC_TAX_AMT NREC_TAX_AMT_TAX_ CURR NREC_TAX_AMT_FUNCL_ CURR TAX_EXEMPTION_ID TAX_RATE_BEFORE_ EXEMPTION TAX_RATE_NAME_ BEFORE_EXEMPTION EXEMPT_RATE_MODIFIER EXEMPT_CERTIFICATE_ NUMBER EXEMPT_REASON EXEMPT_REASON_CODE TAX_EXCEPTION_ID TAX_RATE_BEFORE_ EXCEPTION TAX_RATE_NAME_ BEFORE_EXCEPTION EXCEPTION_RATE TAX_APPORTIONMENT_ FLAG HISTORICAL_FLAG TAXABLE_BASIS_ FORMULA TAX_CALCULATION_ FORMULA CANCEL_FLAG PURGE_FLAG DELETE_FLAG TAX_AMT_INCLUDED_ FLAG SELF_ASSESSED_FLAG OVERRIDDEN_FLAG MANUALLY_ENTERED_ FLAG REPORTING_ONLY_FLAG FREEZE_UNTIL_ OVERRIDDEN_FLAG COPIED_FROM_OTHER_ DOC_FLAG RECALC_REQUIRED_FLAG SETTLEMENT_FLAG ITEM_DIST_CHANGED_ FLAG ASSOCIATED_CHILD_ FROZEN_FLAG TAX_ONLY_LINE_FLAG COMPOUNDING_DEP_TAX_ FLAG LAST_MANUAL_ENTRY TAX_PROVIDER_ID RECORD_TYPE_CODE REPORTING_PERIOD_ID LEGAL_MESSAGE_APPL_2 LEGAL_MESSAGE_STATUS LEGAL_MESSAGE_RATE LEGAL_MESSAGE_BASIS LEGAL_MESSAGE_CALC LEGAL_MESSAGE_ THRESHOLD LEGAL_MESSAGE_POS LEGAL_MESSAGE_TRN LEGAL_MESSAGE_EXMPT LEGAL_MESSAGE_EXCPT TAX_REGIME_TEMPLATE_ ID TAX_APPLICABILITY_ RESULT_ID DIRECT_RATE_RESULT_ ID STATUS_RESULT_ID RATE_RESULT_ID BASIS_RESULT_ID THRESH_RESULT_ID CALC_RESULT_ID TAX_REG_NUM_DET_ RESULT_ID EVAL_EXMPT_RESULT_ID EVAL_EXCPT_RESULT_ID ENFORCE_FROM_ NATURAL_ACCT_FLAG TAX_HOLD_CODE TAX_HOLD_RELEASED_ CODE PRD_TOTAL_TAX_AMT PRD_TOTAL_TAX_AMT_ TAX_CURR PRD_TOTAL_TAX_AMT_ FUNCL_CURR INTERNAL_ORG_ LOCATION_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 NUMERIC1 NUMERIC2 NUMERIC3 NUMERIC4 NUMERIC5 NUMERIC6 NUMERIC7 NUMERIC8 NUMERIC9 NUMERIC10 CHAR1 CHAR2 CHAR3 CHAR4 CHAR5 CHAR6 CHAR7 CHAR8 CHAR9 CHAR10 DATE1 DATE2 DATE3 DATE4 DATE5 DATE6 DATE7 DATE8 DATE9 DATE10 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LEGAL_JUSTIFICATION_ TEXT1 LEGAL_JUSTIFICATION_ TEXT2 LEGAL_JUSTIFICATION_ TEXT3 REPORTING_CURRENCY_ CODE LINE_ASSESSABLE_ VALUE TRX_LINE_INDEX OFFSET_TAX_RATE_CODE PRORATION_CODE OTHER_DOC_SOURCE CTRL_TOTAL_LINE_TX_ AMT TAX_RATE_TYPE COMPOUNDING_TAX_ MISS_FLAG MRC_LINK_TO_TAX_ LINE_ID REF_DOC_TRX_LEVEL_ TYPE RELATED_DOC_TRX_ LEVEL_TYPE APPLIED_FROM_TRX_ LEVEL_TYPE ADJUSTED_DOC_TRX_ LEVEL_TYPE APPLIED_TO_TRX_ LEVEL_TYPE SYNC_WITH_PRVDR_FLAG APPLIED_TO_TRX_ NUMBER INTERFACE_ENTITY_ CODE INTERFACE_TAX_LINE_ ID TAXING_JURIS_ GEOGRAPHY_ID ADJUSTED_DOC_TAX_ LINE_ID OBJECT_VERSION_ NUMBER GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 REVERSED_TAX_LINE_ID MULTIPLE_ JURISDICTIONS_FLAG LEGAL_REPORTING_ STATUS ACCOUNT_SOURCE_TAX_ RATE_ID 10524482 81 200 AP_INVOICES STANDARD INVOICES STANDARD UPDATED 72822 1 LINE 1 UPDATED PURCHASE_TRANSACTION UPDATE 1 809720 8562 TW_VAT 203334 TW_VAT 7142 TW_VAT 10009 P035 5 1                       N 2022   23273     808722       3/21/2008 0:0:0   1 NTD 1 0 IM80306310 3/21/2008 0:0:0 2133 -2133 -1 1 201 PURCHASE_ORDER PO_PA 13231 28213 1       0 0                                       707 RCPT_REC_INSP RCV_ACCOUNTING_EVENTS 126817 28213 1089348   N N 1013024 TW_VAT   BILL_FROM     3/21/2008 0:0:0 3/21/2008 0:0:0 3/21/2008 0:0:0 3/21/2008 0:0:0 VAT         HEADER NEAREST     N                   NTD 0 0 0 0 0 0 -2133 -2133 0 0 0 -107 -107 0 0 0 0 0 0                       N N STANDARD_TB STANDARD_TC Y N N N N N N N N N N   N Y N N     ETAX_CREATED                           219262                 N           142                                                                                                                             1166 5/8/2008 17:13:19 1166 5/8/2008 17:13:19 259290         2133           PERCENTAGE               N           1                   10669677 81 200 AP_INVOICES STANDARD INVOICES STANDARD UPDATED 72822 5 LINE 5 UPDATED PURCHASE_TRANSACTION UPDATE 1 809720 8562 TW_VAT 203334 TW_VAT 7142 TW_VAT 10073 P135 5 1                       N 2022   23273     808722       3/21/2008 0:0:0   1 NTD 1 0 IM80306310A 3/21/2008 0:0:0 2133 0 -1 1 201 PURCHASE_ORDER PO_PA 13231 28213 1       0 0                                       707 RCPT_REC_INSP RCV_ACCOUNTING_EVENTS 126817 28213 1089378   N Y 1013024 TW_VAT   BILL_FROM     3/21/2008 0:0:0 3/21/2008 0:0:0 3/21/2008 0:0:0 3/21/2008 0:0:0 VAT         HEADER NEAREST     N                   NTD 0 0 0 0 0 0         0                                       N N STANDARD_TB STANDARD_TC Y N N N N N N N N N N   N Y N N     ETAX_CREATED                           221299                 N           142                                                                                                                             1166 5/8/2008 17:47:19 1166 5/8/2008 17:47:19 258724         2133           PERCENTAGE N   SHIPMENT         N           1             N

    2 rows retrieved
  
  
• See SQL
  
  

  AP_PAYMENT_SCHEDULES_ALL

  INVOICE_ID LAST_UPDATED_BY LAST_UPDATE_DATE PAYMENT_CROSS_RATE PAYMENT_NUM AMOUNT_REMAINING CREATED_BY CREATION_DATE DISCOUNT_DATE DUE_DATE FUTURE_PAY_DUE_DATE GROSS_AMOUNT HOLD_FLAG LAST_UPDATE_LOGIN PAYMENT_METHOD_ LOOKUP_CODE PAYMENT_PRIORITY PAYMENT_STATUS_FLAG SECOND_DISCOUNT_DATE THIRD_DISCOUNT_DATE BATCH_ID DISCOUNT_AMOUNT_ AVAILABLE SECOND_DISC_AMT_ AVAILABLE THIRD_DISC_AMT_ AVAILABLE ATTRIBUTE1 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE_CATEGORY DISCOUNT_AMOUNT_ REMAINING ORG_ID GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 EXTERNAL_BANK_ ACCOUNT_ID INV_CURR_GROSS_ AMOUNT CHECKRUN_ID DBI_EVENTS_COMPLETE_ FLAG IBY_HOLD_REASON PAYMENT_METHOD_CODE REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE3 72822 1166 5/9/2008 9:27:14 1 1 0 1231 3/31/2008 9:34:35   6/30/2008 0:0:0   0 N     99 N     16338                                       0 81                                           2320 0   N   EFT

    1 row retrieved
  
  
• See SQL
  
  

  AP_HOLDS_ALL

  INVOICE_ID LINE_LOCATION_ID HOLD_LOOKUP_CODE LAST_UPDATE_DATE LAST_UPDATED_BY HELD_BY HOLD_DATE HOLD_REASON RELEASE_LOOKUP_CODE RELEASE_REASON STATUS_FLAG LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ORG_ID RESPONSIBILITY_ID RCV_TRANSACTION_ID HOLD_DETAILS LINE_NUMBER HOLD_ID WF_STATUS 72822   DIST VARIANCE 5/8/2008 17:6:45 5 5 5/8/2008 17:6:45 Total of invoice distributions does not equal invoice amount VARIANCE CORRECTED Invoice variance corrected R   5/8/2008 17:6:45 5                                 81         229008

    1 row retrieved
  
  
• See SQL
  
  

  AP_HOLD_CODES

  HOLD_LOOKUP_CODE HOLD_TYPE DESCRIPTION LAST_UPDATE_DATE LAST_UPDATED_BY USER_RELEASEABLE_ FLAG USER_UPDATEABLE_FLAG INACTIVE_DATE POSTABLE_FLAG LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY EXTERNAL_DESCRIPTION HOLD_INSTRUCTION WAIT_BEFORE_NOTIFY_ DAYS REMINDER_DAYS INITIATE_WORKFLOW_ FLAG DIST VARIANCE VARIANCE HOLD REASON Total of invoice distributions does not equal invoice amount 10/26/2002 0:44:6 1 N N   N 0 1/19/1999 11:25:28 1

    1 row retrieved
  
  
• See SQL
  
  

  AP_TERMS

  ROW_ID TERM_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ENABLED_FLAG DUE_CUTOFF_DAY TYPE START_DATE_ACTIVE END_DATE_ACTIVE RANK ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 NAME DESCRIPTION AAAIS5AAUAAACxOAAW 10022 7/26/2007 16:25:9 1111 7/26/2007 16:25:9 1111 34772 Y   STD 1/1/1951 0:0:0                                     EM90 End of month 90days

    1 row retrieved
  
  
• See SQL
  
  

  AP_TERMS_LINES

  TERM_ID SEQUENCE_NUM LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN DUE_PERCENT DUE_AMOUNT DUE_DAYS DUE_DAY_OF_MONTH DUE_MONTHS_FORWARD DISCOUNT_PERCENT DISCOUNT_DAYS DISCOUNT_DAY_OF_ MONTH DISCOUNT_MONTHS_ FORWARD DISCOUNT_PERCENT_2 DISCOUNT_DAYS_2 DISCOUNT_DAY_OF_ MONTH_2 DISCOUNT_MONTHS_ FORWARD_2 DISCOUNT_PERCENT_3 DISCOUNT_DAYS_3 DISCOUNT_DAY_OF_ MONTH_3 DISCOUNT_MONTHS_ FORWARD_3 ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 FIXED_DATE CALENDAR 10022 1 7/26/2007 16:25:9 1111 7/26/2007 16:25:9 1111 34772 100     31 3

    1 row retrieved
  
  
• See SQL
  
  

  AP_INVOICE_PREPAYS_ALL

  PREPAY_ID INVOICE_ID LAST_UPDATE_DATE LAST_UPDATED_BY PREPAYMENT_AMOUNT_ APPLIED LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY DATE_REPORTED ORG_ID

    0 rows retrieved
  
  
• See SQL
  
  

  AP_CHRG_ALLOCATIONS_ALL

  CHARGE_ALLOCATION_ID CHARGE_DIST_ID ITEM_DIST_ID ALLOCATED_AMOUNT ALLOCATED_BASE_ AMOUNT LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY PROGRAM_ID PROGRAM_APPLICATION_ ID REQUEST_ID ORG_ID PROGRAM_UPDATE_DATE

    0 rows retrieved
  
  
• See SQL
  
  

  AP_INV_APRVL_HIST_ALL

  APPROVAL_HISTORY_ID INVOICE_ID ITERATION RESPONSE APPROVER_ID APPROVER_NAME AMOUNT_APPROVED APPROVER_COMMENTS CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN ORG_ID NOTIFICATION_ORDER ORIG_SYSTEM ITEM_CLASS ITEM_ID LINE_NUMBER HOLD_ID HISTORY_TYPE

    0 rows retrieved
  
  
• See SQL
  
  

  AP_ALLOCATION_RULES

  INVOICE_ID CHRG_INVOICE_LINE_ NUMBER RULE_TYPE RULE_GENERATION_TYPE STATUS CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE REQUEST_ID 72822 2 AMOUNT SYSTEM PENDING 3/31/2008 9:35:2 1231 1231 3/31/2008 9:35:2 199014 -1 -1 3/31/2008 9:35:2 -1 72822 3 AMOUNT SYSTEM PENDING 5/8/2008 17:6:45 1231 1231 5/8/2008 17:6:45 258509 -1 -1 5/8/2008 17:6:45 -1 72822 4 AMOUNT SYSTEM EXECUTED 5/8/2008 17:21:37 1166 1166 5/8/2008 17:21:37 259290 -1 -1 5/8/2008 17:21:37 -1 72822 6 AMOUNT SYSTEM EXECUTED 5/8/2008 17:21:37 1166 1166 5/8/2008 17:21:37 259290 -1 -1 5/8/2008 17:21:37 -1

    4 rows retrieved
  
  
• See SQL
  
  

  AP_ALLOCATION_RULE_LINES

  INVOICE_ID CHRG_INVOICE_LINE_ NUMBER TO_INVOICE_LINE_ NUMBER PERCENTAGE AMOUNT CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE REQUEST_ID 72822 4 1   0 5/8/2008 17:21:37 1166 1166 5/8/2008 17:21:37 259290 -1 -1 5/8/2008 17:21:37 -1 72822 6 5   -107 5/8/2008 17:21:37 1166 1166 5/8/2008 17:21:37 259290 -1 -1 5/8/2008 17:21:37 -1

    2 rows retrieved
  
  
• See SQL
  
  

  AP_SELF_ASSESSED_TAX_DIST_ALL

  INVOICE_ DISTRIBUTION_ID ORG_ID ACCOUNTING_DATE ACCRUAL_POSTED_FLAG ASSETS_ADDITION_FLAG ASSETS_TRACKING_FLAG CASH_POSTED_FLAG DISTRIBUTION_LINE_ NUMBER DIST_CODE_ COMBINATION_ID INVOICE_ID LAST_UPDATED_BY LAST_UPDATE_DATE LINE_TYPE_LOOKUP_ CODE PERIOD_NAME SET_OF_BOOKS_ID SELF_ASSESSED_FLAG AMOUNT BASE_AMOUNT BATCH_ID CREATED_BY CREATION_DATE DESCRIPTION FINAL_MATCH_FLAG INCOME_TAX_REGION LAST_UPDATE_LOGIN MATCH_STATUS_FLAG POSTED_FLAG PO_DISTRIBUTION_ID PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE QUANTITY_INVOICED REQUEST_ID REVERSAL_FLAG TYPE_1099 UNIT_PRICE ENCUMBERED_FLAG STAT_AMOUNT EXPENDITURE_ITEM_ DATE EXPENDITURE_ ORGANIZATION_ID EXPENDITURE_TYPE PARENT_INVOICE_ID PA_ADDITION_FLAG PA_QUANTITY PREPAY_AMOUNT_ REMAINING PROJECT_ID TASK_ID USSGL_TRANSACTION_ CODE USSGL_TRX_CODE_ CONTEXT QUANTITY_VARIANCE BASE_QUANTITY_ VARIANCE PACKET_ID AWT_FLAG AWT_GROUP_ID AWT_TAX_RATE_ID AWT_GROSS_AMOUNT AWT_INVOICE_ID AWT_ORIGIN_GROUP_ID REFERENCE_1 REFERENCE_2 AWT_INVOICE_PAYMENT_ ID RECEIPT_VERIFIED_ FLAG RECEIPT_REQUIRED_ FLAG RECEIPT_MISSING_FLAG JUSTIFICATION EXPENSE_GROUP START_EXPENSE_DATE END_EXPENSE_DATE RECEIPT_CURRENCY_ CODE RECEIPT_CONVERSION_ RATE RECEIPT_CURRENCY_ AMOUNT DAILY_AMOUNT WEB_PARAMETER_ID ADJUSTMENT_REASON AWARD_ID DIST_MATCH_TYPE RCV_TRANSACTION_ID PARENT_REVERSAL_ID TAX_RECOVERABLE_FLAG TAX_CODE_ID MERCHANT_DOCUMENT_ NUMBER MERCHANT_NAME MERCHANT_REFERENCE MERCHANT_TAX_REG_ NUMBER MERCHANT_TAXPAYER_ID COUNTRY_OF_SUPPLY MATCHED_UOM_LOOKUP_ CODE GMS_BURDENABLE_RAW_ COST ACCOUNTING_EVENT_ID PREPAY_DISTRIBUTION_ ID CREDIT_CARD_TRX_ID UPGRADE_POSTED_AMT UPGRADE_BASE_POSTED_ AMT INVENTORY_TRANSFER_ STATUS COMPANY_PREPAID_ INVOICE_ID CC_REVERSAL_FLAG AWT_WITHHELD_AMT PA_CMT_XFACE_FLAG CANCELLATION_FLAG INVOICE_LINE_NUMBER ROUNDING_AMT CHARGE_APPLICABLE_ TO_DIST_ID CORRECTED_INVOICE_ DIST_ID CORRECTED_QUANTITY RELATED_ID ASSET_BOOK_TYPE_CODE ASSET_CATEGORY_ID DISTRIBUTION_CLASS INTENDED_USE DETAIL_TAX_DIST_ID REC_NREC_RATE RECOVERY_RATE_ID RECOVERY_RATE_NAME RECOVERY_TYPE_CODE WITHHOLDING_TAX_ CODE_ID TAX_ALREADY_ DISTRIBUTED_FLAG SUMMARY_TAX_LINE_ID TAXABLE_AMOUNT TAXABLE_BASE_AMOUNT PREPAY_TAX_DIFF_ AMOUNT EXTRA_PO_ERV SELF_ASSESSED_TAX_ LIAB_CCID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 PROJECT_ACCOUNTING_ CONTEXT RCV_CHARGE_ADDITION_ FLAG BC_EVENT_ID AMOUNT_VARIANCE BASE_AMOUNT_VARIANCE

    0 rows retrieved
  
  
• See SQL
  
  

  AP_INVOICE_RELATIONSHIPS

  RELATED_INVOICE_ID ORIGINAL_INVOICE_ID ORIGINAL_PAYMENT_NUM CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CHECKRUN_NAME

    0 rows retrieved
  
  
• See SQL
  
  

Payment     [Top]
Several of the query results below have added account columns showing the account segment values. These columns were added to show the corresponding account value for tables with code combination ids.

• AP_DOCUMENTS_PAYABLE

  PAY_PROC_TRXN_TYPE_ CODE CALLING_APP_ID CALLING_APP_DOC_ UNIQUE_REF1 CALLING_APP_DOC_ UNIQUE_REF2 CALLING_APP_DOC_ UNIQUE_REF3 CALLING_APP_DOC_ UNIQUE_REF4 CALLING_APP_DOC_ UNIQUE_REF5 CALLING_APP_DOC_REF_ NUMBER CALL_APP_PAY_ SERVICE_REQ_CODE PAYMENT_FUNCTION PAYMENT_DATE DOCUMENT_DATE DOCUMENT_TYPE DOCUMENT_CURRENCY_ CODE DOCUMENT_AMOUNT PAYMENT_CURRENCY_ CODE PAYMENT_AMOUNT PAYMENT_METHOD_CODE EXCLUSIVE_PAYMENT_ FLAG PAYEE_PARTY_ID PARTY_SITE_ID SUPPLIER_SITE_ID BENEFICIARY_PARTY LEGAL_ENTITY_ID ORG_ID ORG_TYPE ALLOW_REMOVING_ DOCUMENT_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_ NUMBER ANTICIPATED_VALUE_ DATE PO_NUMBER DOCUMENT_DESCRIPTION DOCUMENT_CURRENCY_ TAX_AMOUNT DOCUMENT_CURR_ CHARGE_AMOUNT AMOUNT_WITHHELD PAYMENT_CURR_ DISCOUNT_TAKEN DISCOUNT_DATE PAYMENT_DUE_DATE PAYMENT_PROFILE_ID INTERNAL_BANK_ ACCOUNT_ID EXTERNAL_BANK_ ACCOUNT_ID BANK_CHARGE_BEARER INTEREST_RATE PAYMENT_GROUPING_ NUMBER PAYMENT_REASON_CODE PAYMENT_REASON_ COMMENTS SETTLEMENT_PRIORITY REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE3 UNIQUE_REMITTANCE_ IDENTIFIER URI_CHECK_DIGIT DELIVERY_CHANNEL_ CODE PAYMENT_FORMAT_CODE DOCUMENT_SEQUENCE_ID DOCUMENT_SEQUENCE_ VALUE DOCUMENT_CATEGORY_ CODE BANK_ASSIGNED_REF_ CODE REMIT_TO_LOCATION_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ADDRESS_SOURCE EMPLOYEE_ADDRESS_ CODE EMPLOYEE_PAYMENT_ FLAG EMPLOYEE_PERSON_ID EMPLOYEE_ADDRESS_ID

    0 rows retrieved
  
  
• See SQL
  
  

  AP_INVOICE_PAYMENTS_ALL

  ACCOUNTING_EVENT_ID ACCOUNTING_DATE ACCRUAL_POSTED_FLAG AMOUNT CASH_POSTED_FLAG CHECK_ID INVOICE_ID INVOICE_PAYMENT_ID LAST_UPDATED_BY LAST_UPDATE_DATE PAYMENT_NUM PERIOD_NAME POSTED_FLAG SET_OF_BOOKS_ID ACCTS_PAY_CODE_ COMBINATION_ID ASSET_CODE_ COMBINATION_ID CREATED_BY CREATION_DATE LAST_UPDATE_LOGIN BANK_ACCOUNT_NUM BANK_ACCOUNT_TYPE BANK_NUM DISCOUNT_LOST DISCOUNT_TAKEN EXCHANGE_DATE EXCHANGE_RATE EXCHANGE_RATE_TYPE GAIN_CODE_ COMBINATION_ID INVOICE_BASE_AMOUNT LOSS_CODE_ COMBINATION_ID PAYMENT_BASE_AMOUNT ATTRIBUTE1 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE_CATEGORY CASH_JE_BATCH_ID FUTURE_PAY_CODE_ COMBINATION_ID FUTURE_PAY_POSTED_ FLAG JE_BATCH_ID ELECTRONIC_TRANSFER_ ID ASSETS_ADDITION_FLAG INVOICE_PAYMENT_TYPE OTHER_INVOICE_ID ORG_ID GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 EXTERNAL_BANK_ ACCOUNT_ID MRC_EXCHANGE_DATE MRC_EXCHANGE_RATE MRC_EXCHANGE_RATE_ TYPE MRC_GAIN_CODE_ COMBINATION_ID MRC_INVOICE_BASE_ AMOUNT MRC_LOSS_CODE_ COMBINATION_ID MRC_PAYMENT_BASE_ AMOUNT REVERSAL_FLAG REVERSAL_INV_PMT_ID IBAN_NUMBER INVOICING_PARTY_ID INVOICING_PARTY_ SITE_ID INVOICING_VENDOR_ SITE_ID Accts Pay Account

    0 rows retrieved
  
  
• See SQL
  
  

  AP_CHECKS_ALL

  AMOUNT BANK_ACCOUNT_ID BANK_ACCOUNT_NAME CHECK_DATE CHECK_ID CHECK_NUMBER CURRENCY_CODE LAST_UPDATED_BY LAST_UPDATE_DATE PAYMENT_METHOD_ LOOKUP_CODE PAYMENT_TYPE_FLAG ADDRESS_LINE1 ADDRESS_LINE2 ADDRESS_LINE3 CHECKRUN_NAME CHECK_FORMAT_ID CHECK_STOCK_ID CITY COUNTRY CREATED_BY CREATION_DATE LAST_UPDATE_LOGIN STATUS_LOOKUP_CODE VENDOR_NAME VENDOR_SITE_CODE ZIP BANK_ACCOUNT_NUM BANK_ACCOUNT_TYPE BANK_NUM CHECK_VOUCHER_NUM CLEARED_AMOUNT CLEARED_DATE DOC_CATEGORY_CODE DOC_SEQUENCE_ID DOC_SEQUENCE_VALUE PROVINCE RELEASED_AT RELEASED_BY STATE STOPPED_AT STOPPED_BY VOID_DATE ATTRIBUTE1 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE_CATEGORY FUTURE_PAY_DUE_DATE TREASURY_PAY_DATE TREASURY_PAY_NUMBER USSGL_TRANSACTION_ CODE USSGL_TRX_CODE_ CONTEXT WITHHOLDING_STATUS_ LOOKUP_CODE RECONCILIATION_ BATCH_ID CLEARED_BASE_AMOUNT CLEARED_EXCHANGE_ RATE CLEARED_EXCHANGE_ DATE CLEARED_EXCHANGE_ RATE_TYPE ADDRESS_LINE4 COUNTY ADDRESS_STYLE ORG_ID VENDOR_ID VENDOR_SITE_ID EXCHANGE_RATE EXCHANGE_DATE EXCHANGE_RATE_TYPE BASE_AMOUNT CHECKRUN_ID REQUEST_ID CLEARED_ERROR_AMOUNT CLEARED_CHARGES_ AMOUNT CLEARED_ERROR_BASE_ AMOUNT CLEARED_CHARGES_ BASE_AMOUNT POSITIVE_PAY_STATUS_ CODE GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 TRANSFER_PRIORITY EXTERNAL_BANK_ ACCOUNT_ID STAMP_DUTY_AMT STAMP_DUTY_BASE_AMT MRC_CLEARED_BASE_ AMOUNT MRC_CLEARED_ EXCHANGE_RATE MRC_CLEARED_ EXCHANGE_DATE MRC_CLEARED_ EXCHANGE_RATE_TYPE MRC_EXCHANGE_RATE MRC_EXCHANGE_DATE MRC_EXCHANGE_RATE_ TYPE MRC_BASE_AMOUNT MRC_CLEARED_ERROR_ BASE_AMOUNT MRC_CLEARED_CHARGES_ BASE_AMT MRC_STAMP_DUTY_BASE_ AMT MATURITY_EXCHANGE_ DATE MATURITY_EXCHANGE_ RATE_TYPE MATURITY_EXCHANGE_ RATE DESCRIPTION ACTUAL_VALUE_DATE ANTICIPATED_VALUE_ DATE RELEASED_DATE STOPPED_DATE MRC_MATURITY_EXG_ DATE MRC_MATURITY_EXG_ RATE MRC_MATURITY_EXG_ RATE_TYPE IBAN_NUMBER CE_BANK_ACCT_USE_ID PAYMENT_METHOD_CODE PARTY_ID PARTY_SITE_ID PAYMENT_PROFILE_ID SETTLEMENT_PRIORITY BANK_CHARGE_BEARER LEGAL_ENTITY_ID PAYMENT_DOCUMENT_ID COMPLETED_PMTS_ GROUP_ID PAYMENT_ID PAYMENT_INSTRUCTION_ ID VOID_CHECK_NUMBER VOID_CHECK_ID

    0 rows retrieved
  
  
• See SQL
  
  

  AP_PAYMENT_DISTRIBUTIONS_ALL

  INVOICE_PAYMENT_ID PAYMENT_LINE_NUMBER LINE_TYPE_LOOKUP_ CODE DIST_CODE_ COMBINATION_ID ACCTS_PAY_CODE_ COMBINATION_ID AMOUNT BASE_AMOUNT INVOICE_DISTR_LINE_ NUMBER UNBUILT_FLEX UNBUILT_FLEX_REASON LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE ORG_ID INV_CURR_AMOUNT INV_CURR_BASE_AMOUNT

    0 rows retrieved
  
  
• See SQL
  
  

  AP_PAYMENT_HISTORY_ALL

  PAYMENT_HISTORY_ID CHECK_ID ACCOUNTING_DATE TRANSACTION_TYPE POSTED_FLAG MATCHED_FLAG ACCOUNTING_EVENT_ID ORG_ID CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PROGRAM_UPDATE_DATE PROGRAM_APPLICATION_ ID PROGRAM_ID REQUEST_ID REV_PMT_HIST_ID TRX_BANK_AMOUNT ERRORS_BANK_AMOUNT CHARGES_BANK_AMOUNT TRX_PMT_AMOUNT ERRORS_PMT_AMOUNT CHARGES_PMT_AMOUNT TRX_BASE_AMOUNT ERRORS_BASE_AMOUNT CHARGES_BASE_AMOUNT BANK_CURRENCY_CODE BANK_TO_BASE_XRATE_ TYPE BANK_TO_BASE_XRATE_ DATE BANK_TO_BASE_XRATE PMT_CURRENCY_CODE PMT_TO_BASE_XRATE_ TYPE PMT_TO_BASE_XRATE_ DATE PMT_TO_BASE_XRATE MRC_PMT_TO_BASE_ XRATE_TYPE MRC_PMT_TO_BASE_ XRATE_DATE MRC_PMT_TO_BASE_ XRATE MRC_BANK_TO_BASE_ XRATE_TYPE MRC_BANK_TO_BASE_ XRATE_DATE MRC_BANK_TO_BASE_ XRATE MRC_TRX_BASE_AMOUNT MRC_ERRORS_BASE_ AMOUNT MRC_CHARGES_BASE_ AMOUNT RELATED_EVENT_ID HISTORICAL_FLAG INVOICE_ADJUSTMENT_ EVENT_ID GAIN_LOSS_INDICATOR

    0 rows retrieved
  
  
• See SQL
  
  

  AP_PAYMENT_HIST_DISTS

  PAYMENT_HIST_DIST_ID ACCOUNTING_EVENT_ID PAY_DIST_LOOKUP_CODE INVOICE_ DISTRIBUTION_ID AMOUNT PAYMENT_HISTORY_ID INVOICE_PAYMENT_ID BANK_CURR_AMOUNT CLEARED_BASE_AMOUNT HISTORICAL_FLAG INVOICE_DIST_AMOUNT INVOICE_DIST_BASE_ AMOUNT INVOICE_ADJUSTMENT_ EVENT_ID MATURED_BASE_AMOUNT PAID_BASE_AMOUNT ROUNDING_AMT REVERSAL_FLAG REVERSED_PAY_HIST_ DIST_ID CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_LOGIN_ID PROGRAM_UPDATE_DATE REQUEST_ID AWT_RELATED_ID RELEASE_INV_DIST_ DERIVED_FROM PA_ADDITION_FLAG AMOUNT_VARIANCE INVOICE_BASE_AMT_ VARIANCE QUANTITY_VARIANCE INVOICE_BASE_QTY_ VARIANCE

    0 rows retrieved
  
  
• See SQL
  
  

  AP_INV_SELECTION_CRITERIA_ALL

  CHECKRUN_NAME CHECK_DATE LAST_UPDATE_DATE LAST_UPDATED_BY BANK_ACCOUNT_NAME PERIOD_NAME PAY_THRU_DATE VENDOR_PAY_GROUP HI_PAYMENT_PRIORITY LOW_PAYMENT_PRIORITY MAX_PAYMENT_AMOUNT MIN_CHECK_AMOUNT MAX_OUTLAY PAY_ONLY_WHEN_DUE_ FLAG STATUS CHECK_STOCK_ID CURRENCY_CODE EXCHANGE_RATE EXCHANGE_RATE_TYPE EXCHANGE_DATE DOCUMENT_ORDER_ LOOKUP_CODE AUDIT_REQUIRED_FLAG INTERVAL LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY VOLUME_SERIAL_NUMBER ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 USSGL_TRANSACTION_ CODE USSGL_TRX_CODE_ CONTEXT ZERO_AMOUNTS_ALLOWED START_PRINT_DOCUMENT END_PRINT_DOCUMENT FIRST_VOUCHER_NUMBER FIRST_AVAILABLE_ DOCUMENT PAYMENT_METHOD_ LOOKUP_CODE ZERO_INVOICES_ ALLOWED ORG_ID CHECKRUN_ID BATCH_IDENTIFIER BANK_ACCOUNT_ID TEMPLATE_FLAG TRANSFER_PRIORITY BATCH_RUN_NAME BATCH_SET_ID BATCH_SET_LINE_ID FUTURE_DATED_ PAYMENT_FLAG ANTICIPATED_VALUE_ DATE INVOICE_BATCH_ID VENDOR_ID PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE REQUEST_ID TEMPLATE_ID PAY_FROM_DATE VENDOR_TYPE_LOOKUP_ CODE PAYMENT_PROFILE_ID INV_EXCHANGE_RATE_ TYPE PAYABLES_REVIEW_ SETTINGS CALC_AWT_INT_FLAG PAYMENTS_REVIEW_ SETTINGS DOCUMENT_REJECTION_ LEVEL_CODE PAYMENT_REJECTION_ LEVEL_CODE CREATE_INSTRS_FLAG PAY_GROUP_OPTION CURRENCY_GROUP_ OPTION LE_GROUP_OPTION OU_GROUP_OPTION PAYMENT_METHOD_CODE BANK_CHARGE_BEARER SETTLEMENT_PRIORITY RESUBMIT_FLAG NEXT_VOUCHER_NUMBER PARTY_ID PAYMENT_DOCUMENT_ID CE_BANK_ACCT_USE_ID

    0 rows retrieved
  
  
• See SQL
  
  

  AP_SELECTED_INVOICES_ALL

  CHECKRUN_NAME INVOICE_ID PAYMENT_NUM LAST_UPDATE_DATE LAST_UPDATED_BY SET_OF_BOOKS_ID LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY VENDOR_ID VENDOR_SITE_ID VENDOR_NUM VENDOR_NAME VENDOR_SITE_CODE CUSTOMER_NUM ADDRESS_LINE1 ADDRESS_LINE2 ADDRESS_LINE3 CITY STATE ZIP PROVINCE COUNTRY WITHHOLDING_STATUS_ LOOKUP_CODE ATTENTION_AR_FLAG INVOICE_NUM INVOICE_DATE VOUCHER_NUM INVOICE_AMOUNT AMOUNT_PAID DISCOUNT_AMOUNT_ TAKEN AP_CCID DUE_DATE DISCOUNT_DATE INVOICE_DESCRIPTION PAYMENT_PRIORITY AMOUNT_REMAINING DISCOUNT_AMOUNT_ REMAINING PAYMENT_AMOUNT DISCOUNT_AMOUNT SEQUENCE_NUM OK_TO_PAY_FLAG DONT_PAY_REASON_CODE ALWAYS_TAKE_ DISCOUNT_FLAG AMOUNT_MODIFIED_FLAG CHECK_NUMBER INVOICE_EXCHANGE_ RATE PAYMENT_CROSS_RATE BANK_ACCOUNT_TYPE ORIGINAL_INVOICE_ID ORIGINAL_PAYMENT_NUM ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 BANK_ACCOUNT_NUM BANK_NUM FUTURE_PAY_DUE_DATE EXCLUSIVE_PAYMENT_ FLAG PROPOSED_PAYMENT_ AMOUNT PAY_SELECTED_CHECK_ ID PRINT_SELECTED_ CHECK_ID ORG_ID WITHHOLDING_AMOUNT INVOICE_PAYMENT_ID DONT_PAY_DESCRIPTION GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 TRANSFER_PRIORITY EXTERNAL_BANK_ ACCOUNT_ID ADDRESS_LINE4 IBAN_NUMBER CHECKRUN_ID LEGAL_ENTITY_ID PAYMENT_CURRENCY_ CODE PAYMENT_GROUPING_ NUMBER PAYMENT_EXCHANGE_ RATE PAYMENT_EXCHANGE_ RATE_TYPE PAYMENT_EXCHANGE_ DATE

    0 rows retrieved
  
  
• See SQL
  
  

  AP_SELECTED_INVOICE_CHECKS_ALL

  CHECKRUN_NAME CHECK_NUMBER VENDOR_ID VENDOR_SITE_ID PRINT_SEQUENCE_NUM CHECK_AMOUNT VENDOR_AMOUNT LAST_UPDATE_DATE LAST_UPDATED_BY OK_TO_PAY_FLAG DONT_PAY_REASON_CODE STATUS_LOOKUP_CODE VENDOR_NUM VENDOR_NAME VENDOR_SITE_CODE CUSTOMER_NUM ADDRESS_LINE1 ADDRESS_LINE2 ADDRESS_LINE3 CITY STATE ZIP PROVINCE COUNTRY WITHHOLDING_STATUS_ LOOKUP_CODE VOID_FLAG CHECK_ID CURRENCY_CODE DISCOUNT_AMOUNT BANK_ACCOUNT_NUM BANK_NUM BANK_ACCOUNT_TYPE CHECK_VOUCHER_NUM LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY FUTURE_PAY_DUE_DATE DUE_DATE PAYMENT_DATE SELECTED_CHECK_ID ATTENTION_AR_FLAG ORG_ID TRANSFER_PRIORITY EXTERNAL_BANK_ ACCOUNT_ID ADDRESS_LINE4 IBAN_NUMBER

    0 rows retrieved
  
  
• See SQL
  
  

  IBY_DOCS_PAYABLE_ALL

  PAY_PROC_TRXN_TYPE_ CODE CALLING_APP_ID CALLING_APP_DOC_REF_ NUMBER DOCUMENT_PAYABLE_ID PAYMENT_FUNCTION PAYMENT_DATE DOCUMENT_DATE DOCUMENT_TYPE DOCUMENT_STATUS DOCUMENT_CURRENCY_ CODE DOCUMENT_AMOUNT PAYMENT_CURRENCY_ CODE PAYMENT_AMOUNT PAYMENT_SERVICE_ REQUEST_ID PAYMENT_METHOD_CODE EXCLUSIVE_PAYMENT_ FLAG STRAIGHT_THROUGH_ FLAG EXT_PAYEE_ID PAYEE_PARTY_ID LEGAL_ENTITY_ID ORG_ID ALLOW_REMOVING_ DOCUMENT_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE OBJECT_VERSION_ NUMBER CALLING_APP_DOC_ UNIQUE_REF1 CALLING_APP_DOC_ UNIQUE_REF2 CALLING_APP_DOC_ UNIQUE_REF3 CALLING_APP_DOC_ UNIQUE_REF4 CALLING_APP_DOC_ UNIQUE_REF5 LAST_UPDATE_LOGIN PARTY_SITE_ID SUPPLIER_SITE_ID BENEFICIARY_PARTY ORG_TYPE ANTICIPATED_VALUE_ DATE PO_NUMBER DOCUMENT_DESCRIPTION DOCUMENT_CURRENCY_ TAX_AMOUNT DOCUMENT_CURR_ CHARGE_AMOUNT AMOUNT_WITHHELD PAYMENT_CURR_ DISCOUNT_TAKEN DISCOUNT_DATE PAYMENT_DUE_DATE PAYMENT_PROFILE_ID PAYMENT_ID FORMATTING_PAYMENT_ ID INTERNAL_BANK_ ACCOUNT_ID EXTERNAL_BANK_ ACCOUNT_ID BANK_CHARGE_BEARER INTEREST_RATE PAYMENT_GROUPING_ NUMBER PAYMENT_REASON_CODE PAYMENT_REASON_ COMMENTS SETTLEMENT_PRIORITY REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE3 UNIQUE_REMITTANCE_ IDENTIFIER URI_CHECK_DIGIT DELIVERY_CHANNEL_ CODE PAYMENT_FORMAT_CODE DOCUMENT_SEQUENCE_ID DOCUMENT_SEQUENCE_ VALUE DOCUMENT_CATEGORY_ CODE BANK_ASSIGNED_REF_ CODE REMIT_TO_LOCATION_ID COMPLETED_PMTS_ GROUP_ID REJECTED_DOCS_GROUP_ ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ADDRESS_SOURCE EMPLOYEE_ADDRESS_ CODE EMPLOYEE_PERSON_ID EMPLOYEE_PAYMENT_ FLAG EMPLOYEE_ADDRESS_ID

    0 rows retrieved
  
  
• See SQL
  
  

  IBY_PAYMENTS_ALL

  PAYMENT_ID PAYMENT_METHOD_CODE PAYMENT_SERVICE_ REQUEST_ID PROCESS_TYPE PAYMENT_STATUS PAYMENTS_COMPLETE_ FLAG PAYMENT_FUNCTION PAYMENT_AMOUNT PAYMENT_CURRENCY_ CODE BILL_PAYABLE_FLAG EXCLUSIVE_PAYMENT_ FLAG SEPARATE_REMIT_ ADVICE_REQ_FLAG INTERNAL_BANK_ ACCOUNT_ID ORG_ID ORG_TYPE LEGAL_ENTITY_ID DECLARE_PAYMENT_FLAG DELIVERY_CHANNEL_ CODE EXT_PAYEE_ID PAYMENT_INSTRUCTION_ ID PAYMENT_PROFILE_ID PREGROUPED_PAYMENT_ FLAG STOP_CONFIRMED_FLAG STOP_RELEASED_FLAG STOP_REQUEST_PLACED_ FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE OBJECT_VERSION_ NUMBER PAYEE_PARTY_ID PARTY_SITE_ID SUPPLIER_SITE_ID PAYMENT_REASON_CODE PAYMENT_REASON_ COMMENTS PAYMENT_DATE ANTICIPATED_VALUE_ DATE DECLARATION_AMOUNT DECLARATION_ CURRENCY_CODE DISCOUNT_AMOUNT_ TAKEN PAYMENT_DETAILS BANK_CHARGE_BEARER BANK_CHARGE_AMOUNT SETTLEMENT_PRIORITY REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE3 PAYMENT_REFERENCE_ NUMBER PAPER_DOCUMENT_ NUMBER BANK_ASSIGNED_REF_ CODE EXTERNAL_BANK_ ACCOUNT_ID UNIQUE_REMITTANCE_ IDENTIFIER URI_CHECK_DIGIT BANK_INSTRUCTION1_ CODE BANK_INSTRUCTION2_ CODE BANK_INSTRUCTION_ DETAILS PAYMENT_TEXT_ MESSAGE1 PAYMENT_TEXT_ MESSAGE2 PAYMENT_TEXT_ MESSAGE3 MATURITY_DATE PAYMENT_DUE_DATE DOCUMENT_CATEGORY_ CODE DOCUMENT_SEQUENCE_ID DOCUMENT_SEQUENCE_ VALUE BENEFICIARY_PARTY STOP_CONFIRMED_BY STOP_CONFIRM_DATE STOP_CONFIRM_REASON STOP_CONFIRM_ REFERENCE STOP_RELEASED_BY STOP_RELEASE_DATE STOP_RELEASE_REASON STOP_RELEASE_ REFERENCE STOP_REQUEST_DATE STOP_REQUEST_PLACED_ BY STOP_REQUEST_REASON STOP_REQUEST_ REFERENCE VOIDED_BY VOID_DATE VOID_REASON REMIT_TO_LOCATION_ID COMPLETED_PMTS_ GROUP_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 EXT_BRANCH_NUMBER EXT_BANK_NUMBER EXT_BANK_ACCOUNT_ NAME EXT_BANK_ACCOUNT_ NUMBER EXT_BANK_ACCOUNT_ TYPE EXT_BANK_ACCOUNT_ IBAN_NUMBER PAYEE_NAME PAYEE_ADDRESS1 PAYEE_ADDRESS2 PAYEE_ADDRESS3 PAYEE_ADDRESS4 PAYEE_CITY PAYEE_POSTAL_CODE PAYEE_STATE PAYEE_PROVINCE PAYEE_COUNTY PAYEE_COUNTRY REMIT_ADVICE_ DELIVERY_METHOD REMIT_ADVICE_EMAIL REMIT_ADVICE_FAX PAYMENT_PROFILE_SYS_ NAME PAYMENT_PROFILE_ ACCT_NAME PAYMENT_PROCESS_ REQUEST_NAME SOURCE_PRODUCT PAYMENT_REASON_ FORMAT_VALUE DECLARATION_EXCH_ RATE_TYPE DECLARATION_FORMAT DELIVERY_CHANNEL_ FORMAT_VALUE BANK_INSTRUCTION1_ FORMAT_VALUE BANK_INSTRUCTION2_ FORMAT_VALUE SRA_DELIVERY_METHOD INT_BANK_NAME INT_BANK_NUMBER INT_EFT_SWIFT_CODE INT_BANK_BRANCH_NAME INT_BANK_BRANCH_ NUMBER INT_BANK_ACCOUNT_ NAME INT_BANK_ACCOUNT_ NUMBER INT_BANK_ACCOUNT_ IBAN EXT_BANK_NAME EXT_EFT_SWIFT_CODE EXT_BANK_BRANCH_NAME ORG_NAME PAYER_LEGAL_ENTITY_ NAME PAYER_LE_ REGISTRATION_NUM PAYER_TAX_ REGISTRATION_NUM PAYEE_PARTY_NAME PAYEE_LE_ REGISTRATION_NUM PAYEE_TAX_ REGISTRATION_NUM PAYER_PARTY_SITE_ NAME PAYEE_ADDRESS_CONCAT BENEFICIARY_NAME PAYER_PARTY_NUMBER PAYEE_PARTY_NUMBER PAYEE_ALTERNATE_NAME PAYEE_SITE_ ALTERNATE_NAME PAYEE_SUPPLIER_ NUMBER PAYEE_FIRST_PARTY_ REFERENCE INT_BANK_BRANCH_RFC_ IDENTIFIER INT_BANK_ACCT_ AGENCY_LOC_CODE PAYER_ABBREVIATED_ AGENCY_CODE PAYER_FEDERAL_US_ EMPLOYER_ID EXT_BANK_ACCT_OWNER_ PARTY_ID EXT_BANK_ACCT_PMT_ FACTOR_FLAG ADDRESS_SOURCE EMPLOYEE_ADDRESS_ CODE EMPLOYEE_PERSON_ID EMPLOYEE_PAYMENT_ FLAG EMPLOYEE_ADDRESS_ID REQUEST_ID EXT_BANK_BRANCH_ PARTY_ID EXT_BANK_ALT_NAME EXT_BANK_BRANCH_ALT_ NAME EXT_BANK_ACCOUNT_ ALT_NAME EXT_BANK_ACCOUNT_ NUM_ELEC EXT_BANK_BRANCH_ LOCATION_ID EXT_BANK_ACCT_OWNER_ PARTY_NAME INT_BANK_BRANCH_ PARTY_ID INT_BANK_ALT_NAME INT_BANK_BRANCH_ALT_ NAME INT_BANK_ACCOUNT_ ALT_NAME INT_BANK_ACCOUNT_ NUM_ELEC INT_BANK_BRANCH_ LOCATION_ID INT_BANK_BRANCH_EFT_ USER_NUM PAYER_PARTY_ID PAYER_LOCATION_ID PAYER_PARTY_ATTR_ CATEGORY PAYER_LE_ATTR_ CATEGORY PAYEE_PARTY_ATTR_ CATEGORY PAYEE_SUPPLIER_ATTR_ CATEGORY PAYEE_SPPLR_SITE_ ATTR_CATEGORY PAYEE_SUPPLIER_SITE_ NAME PAYEE_SUPPLIER_SITE_ ALT_NAME PAYEE_SUPPLIER_ID

    0 rows retrieved
  
  
• See SQL
  
  

  IBY_PAY_INSTRUCTIONS_ALL

  PAYMENT_INSTRUCTION_ ID PAYMENT_PROFILE_ID PROCESS_TYPE PAYMENT_INSTRUCTION_ STATUS PAYMENTS_COMPLETE_ CODE GENERATE_SEP_REMIT_ ADVICE_FLAG REMITTANCE_ADVICE_ CREATED_FLAG REGULATORY_REPORT_ CREATED_FLAG BILL_PAYABLE_FLAG LEGAL_ENTITY_ID PAYMENT_COUNT POSITIVE_PAY_FILE_ CREATED_FLAG PRINT_INSTRUCTION_ IMMED_FLAG TRANSMIT_INSTR_ IMMED_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_ NUMBER INTERNAL_BANK_ ACCOUNT_ID PAY_ADMIN_ASSIGNED_ REF_CODE TRANSMISSION_DATE ACKNOWLEDGEMENT_DATE COMMENTS BANK_ASSIGNED_REF_ CODE ORG_ID ORG_TYPE PAYMENT_DATE PAYMENT_CURRENCY_ CODE PAYMENT_SERVICE_ REQUEST_ID PAYMENT_FUNCTION PAYMENT_REASON_CODE RFC_IDENTIFIER PAYMENT_REASON_ COMMENTS PAYMENT_DOCUMENT_ID PRINTER_NAME ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REFERENCE_FORMAT_ CODE REQUEST_ID

    0 rows retrieved
  
  
• See SQL
  
  

  AP_RECON_DISTRIBUTIONS_ALL

  CHECK_ID CODE_COMBINATION_ID AMOUNT BASE_AMOUNT LINE_TYPE_LOOKUP_ CODE POSTED_FLAG ACCRUAL_POSTED_FLAG CASH_POSTED_FLAG ACCOUNTING_DATE PERIOD_NAME LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY PROGRAM_UPDATE_DATE PROGRAM_APPLICATION_ ID PROGRAM_ID REQUEST_ID REVERSAL_FLAG ORG_ID R115_UPG

    0 rows retrieved
  
  
• See SQL
  
  

Tax     [Top]

• AP_AWT_TEMP_DISTRIBUTIONS_ALL

  INVOICE_ID PAYMENT_NUM GROUP_ID TAX_NAME TAX_CODE_ COMBINATION_ID GROSS_AMOUNT WITHHOLDING_AMOUNT BASE_WITHHOLDING_ AMOUNT ACCOUNTING_DATE PERIOD_NAME CHECKRUN_NAME TAX_RATE_ID ORG_ID INVOICE_PAYMENT_ID GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 AWT_RELATED_ID CHECKRUN_ID

    0 rows retrieved
  
  
• See SQL
  
  

Accounting     [Top]

• XLA_EVENTS (Invoice)

  EVENT_ID APPLICATION_ID EVENT_TYPE_CODE EVENT_DATE ENTITY_ID EVENT_STATUS_CODE PROCESS_STATUS_CODE REFERENCE_NUM_1 REFERENCE_NUM_2 REFERENCE_NUM_3 REFERENCE_NUM_4 REFERENCE_CHAR_1 REFERENCE_CHAR_2 REFERENCE_CHAR_3 REFERENCE_CHAR_4 REFERENCE_DATE_1 REFERENCE_DATE_2 REFERENCE_DATE_3 REFERENCE_DATE_4 EVENT_NUMBER ON_HOLD_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PROGRAM_UPDATE_DATE PROGRAM_APPLICATION_ ID PROGRAM_ID REQUEST_ID UPG_BATCH_ID UPG_SOURCE_ APPLICATION_ID UPG_VALID_FLAG TRANSACTION_DATE BUDGETARY_CONTROL_ FLAG MERGE_EVENT_SET_ID 407380 200 CREDIT MEMO VALIDATED 3/21/2008 0:0:0 360977 P P                         1 N 3/31/2008 9:35:2 1231 3/31/2008 12:5:10 1225 203257 3/31/2008 9:35:2 -1 -1 454499       3/21/2008 0:0:0 N   555468 200 CREDIT MEMO VALIDATED 3/21/2008 0:0:0 360977 I U                         2 N 5/8/2008 17:6:45 1231 5/8/2008 17:7:33 1231 258509 5/8/2008 17:7:33 -1 -1 -1       3/21/2008 0:0:0 N   555493 200 CREDIT MEMO VALIDATED 4/1/2008 0:0:0 360977 I U                         3 N 5/8/2008 17:36:54 1166 5/8/2008 17:36:54 1166 259290 5/8/2008 17:36:54 -1 -1 -1       3/21/2008 0:0:0 N   555494 200 CREDIT MEMO VALIDATED 5/1/2008 0:0:0 360977 I U                         4 N 5/8/2008 17:36:54 1166 5/8/2008 17:36:54 1166 259290 5/8/2008 17:36:54 -1 -1 -1       3/21/2008 0:0:0 N

    4 rows retrieved
  
  
• See SQL
  
  

  XLA_AE_HEADERS (Invoice)

  AE_HEADER_ID APPLICATION_ID LEDGER_ID ENTITY_ID EVENT_ID EVENT_TYPE_CODE ACCOUNTING_DATE GL_TRANSFER_STATUS_ CODE GL_TRANSFER_DATE JE_CATEGORY_NAME ACCOUNTING_ENTRY_ STATUS_CODE ACCOUNTING_ENTRY_ TYPE_CODE AMB_CONTEXT_CODE PRODUCT_RULE_TYPE_ CODE PRODUCT_RULE_CODE PRODUCT_RULE_VERSION DESCRIPTION DOC_SEQUENCE_ID DOC_SEQUENCE_VALUE ACCOUNTING_BATCH_ID COMPLETION_ACCT_SEQ_ VERSION_ID CLOSE_ACCT_SEQ_ VERSION_ID COMPLETION_ACCT_SEQ_ VALUE CLOSE_ACCT_SEQ_VALUE BUDGET_VERSION_ID FUNDS_STATUS_CODE ENCUMBRANCE_TYPE_ID BALANCE_TYPE_CODE REFERENCE_DATE COMPLETED_DATE PERIOD_NAME PACKET_ID COMPLETION_ACCT_SEQ_ ASSIGN_ID CLOSE_ACCT_SEQ_ ASSIGN_ID DOC_CATEGORY_CODE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GROUP_ID DOC_SEQUENCE_ VERSION_ID DOC_SEQUENCE_ASSIGN_ ID CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PROGRAM_UPDATE_DATE PROGRAM_APPLICATION_ ID PROGRAM_ID REQUEST_ID UPG_BATCH_ID UPG_SOURCE_ APPLICATION_ID UPG_VALID_FLAG ZERO_AMOUNT_FLAG PARENT_AE_HEADER_ID PARENT_AE_LINE_NUM ACCRUAL_REVERSAL_ FLAG MERGE_EVENT_ID 1720576 200 2022 360977 407380 CREDIT MEMO VALIDATED 3/21/2008 0:0:0 Y 3/31/2008 12:14:57 Purchase Invoices F STANDARD DEFAULT C ACER ACCRUAL   ~Credit Memo Validated , Invoice Number: IM80306310 , Date: 21-MAR-08 , Document Sequence Category: CRM INV , Document Sequence Name: AI_AP_INV_0803 , Invoice Voucher Number: 80309663 , Invoice Description: XU41871475 ~ 52 80309663 7281   1061   80182713       A   3/31/2008 12:5:7 MAR-08     556 CRM INV                                 6528     3/31/2008 0:0:0 1225 3/31/2008 0:0:0 1225 203257 3/31/2008 0:0:0 602 48092 454500       N     N

    1 row retrieved
  
  

ATTENTION - The above data contains leading or trailing spaces. Values with spaces are shown between tilde (~). Search for tilde (~) in this report to find the values with spaces.

• See SQL
  
  

  XLA_AE_LINES (Invoice)

  AE_HEADER_ID AE_LINE_NUM APPLICATION_ID CODE_COMBINATION_ID GL_TRANSFER_MODE_ CODE GL_SL_LINK_ID ACCOUNTING_CLASS_ CODE PARTY_ID PARTY_SITE_ID PARTY_TYPE_CODE ENTERED_DR ENTERED_CR ACCOUNTED_DR ACCOUNTED_CR DESCRIPTION STATISTICAL_AMOUNT CURRENCY_CODE CURRENCY_CONVERSION_ DATE CURRENCY_CONVERSION_ RATE CURRENCY_CONVERSION_ TYPE USSGL_TRANSACTION_ CODE JGZZ_RECON_REF CONTROL_BALANCE_FLAG ANALYTICAL_BALANCE_ FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GL_SL_LINK_TABLE DISPLAYED_LINE_ NUMBER CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PROGRAM_UPDATE_DATE PROGRAM_APPLICATION_ ID PROGRAM_ID REQUEST_ID UPG_BATCH_ID UPG_TAX_REFERENCE_ ID1 UPG_TAX_REFERENCE_ ID2 UPG_TAX_REFERENCE_ ID3 UNROUNDED_ACCOUNTED_ DR UNROUNDED_ACCOUNTED_ CR GAIN_OR_LOSS_FLAG UNROUNDED_ENTERED_DR UNROUNDED_ENTERED_CR SUBSTITUTED_CCID BUSINESS_CLASS_CODE MPA_ACCRUAL_ENTRY_ FLAG ENCUMBRANCE_TYPE_ID FUNDS_STATUS_CODE MERGE_CODE_ COMBINATION_ID MERGE_PARTY_ID MERGE_PARTY_SITE_ID ACCOUNTING_DATE LEDGER_ID SOURCE_TABLE SOURCE_ID ACCOUNT_OVERLAY_ SOURCE_ID 1720576 1 200 2008 S 4948374 ACCRUAL 6217 4589 S   2133   2133 ~7121.00004.J91|婕㈡浉鍒楀嵃绯荤当 鍠鐗� ~   NTD                                               XLAJEL 3 3/31/2008 0:0:0 1225 3/31/2008 0:0:0 1225 203257 3/31/2008 0:0:0 602 48092 454500           2133 N   2133     N           3/21/2008 0:0:0 2022       1720576 2 200 2026 S 4948372 LIABILITY 6217 4589 S 2133   2133   ~7121.00004.J91|婕㈡浉鍒楀嵃绯荤当 鍠鐗� ~   NTD                                               XLAJEL 1 3/31/2008 0:0:0 1225 3/31/2008 0:0:0 1225 203257 3/31/2008 0:0:0 602 48092 454500         2133   N 2133     AP_LIAB N           3/21/2008 0:0:0 2022       1720576 3 200 2026 S 4948373 LIABILITY 6217 4589 S 107   107   ~TW_VAT - TW_VAT ~   NTD                                               XLAJEL 2 3/31/2008 0:0:0 1225 3/31/2008 0:0:0 1225 203257 3/31/2008 0:0:0 602 48092 454500         107   N 107     AP_LIAB N           3/21/2008 0:0:0 2022       1720576 4 200 2034 S 4948375 RTAX 6217 4589 S   107   107 ~TW_VAT - TW_VAT ~   NTD                                               XLAJEL 4 3/31/2008 0:0:0 1225 3/31/2008 0:0:0 1225 203257 3/31/2008 0:0:0 602 48092 454500           107 N   107   AP_DEF_REC_TAX N           3/21/2008 0:0:0 2022

    4 rows retrieved
  
  

ATTENTION - The above data contains leading or trailing spaces. Values with spaces are shown between tilde (~). Search for tilde (~) in this report to find the values with spaces.

• See SQL
  
  

  XLA_DISTRIBUTION_LINKS (Invoice)

  APPLICATION_ID EVENT_ID AE_HEADER_ID AE_LINE_NUM SOURCE_DISTRIBUTION_ TYPE SOURCE_DISTRIBUTION_ ID_CHAR_1 SOURCE_DISTRIBUTION_ ID_CHAR_2 SOURCE_DISTRIBUTION_ ID_CHAR_3 SOURCE_DISTRIBUTION_ ID_CHAR_4 SOURCE_DISTRIBUTION_ ID_CHAR_5 SOURCE_DISTRIBUTION_ ID_NUM_1 SOURCE_DISTRIBUTION_ ID_NUM_2 SOURCE_DISTRIBUTION_ ID_NUM_3 SOURCE_DISTRIBUTION_ ID_NUM_4 SOURCE_DISTRIBUTION_ ID_NUM_5 TAX_LINE_REF_ID TAX_SUMMARY_LINE_ REF_ID TAX_REC_NREC_DIST_ REF_ID STATISTICAL_AMOUNT REF_AE_HEADER_ID REF_TEMP_LINE_NUM ACCOUNTING_LINE_CODE ACCOUNTING_LINE_ TYPE_CODE MERGE_DUPLICATE_CODE TEMP_LINE_NUM REF_EVENT_ID LINE_DEFINITION_ OWNER_CODE LINE_DEFINITION_CODE EVENT_CLASS_CODE EVENT_TYPE_CODE UPG_BATCH_ID CALCULATE_ACCTD_ AMTS_FLAG CALCULATE_G_L_AMTS_ FLAG ROUNDING_CLASS_CODE DOCUMENT_ROUNDING_ LEVEL UNROUNDED_ENTERED_DR UNROUNDED_ENTERED_CR DOC_ROUNDING_ ENTERED_AMT DOC_ROUNDING_ACCTD_ AMT UNROUNDED_ACCOUNTED_ CR UNROUNDED_ACCOUNTED_ DR APPLIED_TO_ APPLICATION_ID APPLIED_TO_ENTITY_ CODE APPLIED_TO_ENTITY_ID APPLIED_TO_SOURCE_ ID_NUM_1 APPLIED_TO_SOURCE_ ID_NUM_2 APPLIED_TO_SOURCE_ ID_NUM_3 APPLIED_TO_SOURCE_ ID_NUM_4 APPLIED_TO_SOURCE_ ID_CHAR_1 APPLIED_TO_SOURCE_ ID_CHAR_2 APPLIED_TO_SOURCE_ ID_CHAR_3 APPLIED_TO_SOURCE_ ID_CHAR_4 APPLIED_TO_ DISTRIBUTION_TYPE APPLIED_TO_DIST_ID_ NUM_1 APPLIED_TO_DIST_ID_ NUM_2 APPLIED_TO_DIST_ID_ NUM_3 APPLIED_TO_DIST_ID_ NUM_4 APPLIED_TO_DIST_ID_ NUM_5 APPLIED_TO_DIST_ID_ CHAR_1 APPLIED_TO_DIST_ID_ CHAR_2 APPLIED_TO_DIST_ID_ CHAR_3 APPLIED_TO_DIST_ID_ CHAR_4 APPLIED_TO_DIST_ID_ CHAR_5 ALLOC_TO_ APPLICATION_ID ALLOC_TO_ENTITY_CODE ALLOC_TO_SOURCE_ID_ NUM_1 ALLOC_TO_SOURCE_ID_ NUM_2 ALLOC_TO_SOURCE_ID_ NUM_3 ALLOC_TO_SOURCE_ID_ NUM_4 ALLOC_TO_SOURCE_ID_ CHAR_1 ALLOC_TO_SOURCE_ID_ CHAR_2 ALLOC_TO_SOURCE_ID_ CHAR_3 ALLOC_TO_SOURCE_ID_ CHAR_4 ALLOC_TO_ DISTRIBUTION_TYPE ALLOC_TO_DIST_ID_ NUM_1 ALLOC_TO_DIST_ID_ NUM_2 ALLOC_TO_DIST_ID_ NUM_3 ALLOC_TO_DIST_ID_ NUM_4 ALLOC_TO_DIST_ID_ NUM_5 ALLOC_TO_DIST_ID_ CHAR_1 ALLOC_TO_DIST_ID_ CHAR_2 ALLOC_TO_DIST_ID_ CHAR_3 ALLOC_TO_DIST_ID_ CHAR_4 ALLOC_TO_DIST_ID_ CHAR_5 GAIN_OR_LOSS_REF 200 407380 1720576 1 AP_INV_DIST           436473                 1720576   AP_ACCRUAL_CM S A 93   C ACER_ACCRUAL_CREDIT MEMOS_ALL CREDIT MEMOS CREDIT MEMOS_ALL   N N ACCRUAL     2133     2133   201 PURCHASE_ORDER   13231               PO_DISTRIBUTIONS_ALL 28515                   200 AP_INVOICES 72822               AP_INV_DIST 436473                   #line#436473 200 407380 1720576 2 AP_INV_DIST           436473                 1720576   AP_LIAB_CM S A 94   C ACER_ACCRUAL_CREDIT MEMOS_ALL CREDIT MEMOS CREDIT MEMOS_ALL   N N LIABILITY   2133         2133 200 AP_INVOICES   72822               AP_INV_DIST 436473                   200 AP_INVOICES 72822               AP_INV_DIST 436473                   #line#436473 200 407380 1720576 3 AP_INV_DIST           436474         10524482 1019857 2702739   1720576   AP_LIAB_CM S A 95   C ACER_ACCRUAL_CREDIT MEMOS_ALL CREDIT MEMOS CREDIT MEMOS_ALL   N N LIABILITY   107         107 200 AP_INVOICES   72822               AP_INV_DIST 436474                   200 AP_INVOICES 72822               AP_INV_DIST 436473                   #line#436474 200 407380 1720576 4 AP_INV_DIST           436474         10524482 1019857 2702739   1720576   AP_RECOV_TAX_CM S A 96   C ACER_ACCRUAL_CREDIT MEMOS_ALL CREDIT MEMOS CREDIT MEMOS_ALL   N N RTAX     107     107   200 AP_INVOICES   72822               AP_INV_DIST 436474                   200 AP_INVOICES 72822               AP_INV_DIST 436473                   #line#436474

    4 rows retrieved
  
  
• See SQL
  
  

  XLA_EVENTS (Payment)

  EVENT_ID APPLICATION_ID EVENT_TYPE_CODE EVENT_DATE ENTITY_ID EVENT_STATUS_CODE PROCESS_STATUS_CODE REFERENCE_NUM_1 REFERENCE_NUM_2 REFERENCE_NUM_3 REFERENCE_NUM_4 REFERENCE_CHAR_1 REFERENCE_CHAR_2 REFERENCE_CHAR_3 REFERENCE_CHAR_4 REFERENCE_DATE_1 REFERENCE_DATE_2 REFERENCE_DATE_3 REFERENCE_DATE_4 EVENT_NUMBER ON_HOLD_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PROGRAM_UPDATE_DATE PROGRAM_APPLICATION_ ID PROGRAM_ID REQUEST_ID UPG_BATCH_ID UPG_SOURCE_ APPLICATION_ID UPG_VALID_FLAG TRANSACTION_DATE BUDGETARY_CONTROL_ FLAG MERGE_EVENT_SET_ID

    0 rows retrieved
  
  
• See SQL
  
  

  XLA_AE_HEADERS (Payment)

  AE_HEADER_ID APPLICATION_ID LEDGER_ID ENTITY_ID EVENT_ID EVENT_TYPE_CODE ACCOUNTING_DATE GL_TRANSFER_STATUS_ CODE GL_TRANSFER_DATE JE_CATEGORY_NAME ACCOUNTING_ENTRY_ STATUS_CODE ACCOUNTING_ENTRY_ TYPE_CODE AMB_CONTEXT_CODE PRODUCT_RULE_TYPE_ CODE PRODUCT_RULE_CODE PRODUCT_RULE_VERSION DESCRIPTION DOC_SEQUENCE_ID DOC_SEQUENCE_VALUE ACCOUNTING_BATCH_ID COMPLETION_ACCT_SEQ_ VERSION_ID CLOSE_ACCT_SEQ_ VERSION_ID COMPLETION_ACCT_SEQ_ VALUE CLOSE_ACCT_SEQ_VALUE BUDGET_VERSION_ID FUNDS_STATUS_CODE ENCUMBRANCE_TYPE_ID BALANCE_TYPE_CODE REFERENCE_DATE COMPLETED_DATE PERIOD_NAME PACKET_ID COMPLETION_ACCT_SEQ_ ASSIGN_ID CLOSE_ACCT_SEQ_ ASSIGN_ID DOC_CATEGORY_CODE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GROUP_ID DOC_SEQUENCE_ VERSION_ID DOC_SEQUENCE_ASSIGN_ ID CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PROGRAM_UPDATE_DATE PROGRAM_APPLICATION_ ID PROGRAM_ID REQUEST_ID UPG_BATCH_ID UPG_SOURCE_ APPLICATION_ID UPG_VALID_FLAG ZERO_AMOUNT_FLAG PARENT_AE_HEADER_ID PARENT_AE_LINE_NUM ACCRUAL_REVERSAL_ FLAG MERGE_EVENT_ID

    0 rows retrieved
  
  
• See SQL
  
  

  XLA_AE_LINES (Payment)

  AE_HEADER_ID AE_LINE_NUM APPLICATION_ID CODE_COMBINATION_ID GL_TRANSFER_MODE_ CODE GL_SL_LINK_ID ACCOUNTING_CLASS_ CODE PARTY_ID PARTY_SITE_ID PARTY_TYPE_CODE ENTERED_DR ENTERED_CR ACCOUNTED_DR ACCOUNTED_CR DESCRIPTION STATISTICAL_AMOUNT CURRENCY_CODE CURRENCY_CONVERSION_ DATE CURRENCY_CONVERSION_ RATE CURRENCY_CONVERSION_ TYPE USSGL_TRANSACTION_ CODE JGZZ_RECON_REF CONTROL_BALANCE_FLAG ANALYTICAL_BALANCE_ FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GL_SL_LINK_TABLE DISPLAYED_LINE_ NUMBER CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PROGRAM_UPDATE_DATE PROGRAM_APPLICATION_ ID PROGRAM_ID REQUEST_ID UPG_BATCH_ID UPG_TAX_REFERENCE_ ID1 UPG_TAX_REFERENCE_ ID2 UPG_TAX_REFERENCE_ ID3 UNROUNDED_ACCOUNTED_ DR UNROUNDED_ACCOUNTED_ CR GAIN_OR_LOSS_FLAG UNROUNDED_ENTERED_DR UNROUNDED_ENTERED_CR SUBSTITUTED_CCID BUSINESS_CLASS_CODE MPA_ACCRUAL_ENTRY_ FLAG ENCUMBRANCE_TYPE_ID FUNDS_STATUS_CODE MERGE_CODE_ COMBINATION_ID MERGE_PARTY_ID MERGE_PARTY_SITE_ID ACCOUNTING_DATE LEDGER_ID SOURCE_TABLE SOURCE_ID ACCOUNT_OVERLAY_ SOURCE_ID

    0 rows retrieved
  
  
• See SQL
  
  

  XLA_DISTRIBUTION_LINKS (Payment)

  APPLICATION_ID EVENT_ID AE_HEADER_ID AE_LINE_NUM SOURCE_DISTRIBUTION_ TYPE SOURCE_DISTRIBUTION_ ID_CHAR_1 SOURCE_DISTRIBUTION_ ID_CHAR_2 SOURCE_DISTRIBUTION_ ID_CHAR_3 SOURCE_DISTRIBUTION_ ID_CHAR_4 SOURCE_DISTRIBUTION_ ID_CHAR_5 SOURCE_DISTRIBUTION_ ID_NUM_1 SOURCE_DISTRIBUTION_ ID_NUM_2 SOURCE_DISTRIBUTION_ ID_NUM_3 SOURCE_DISTRIBUTION_ ID_NUM_4 SOURCE_DISTRIBUTION_ ID_NUM_5 TAX_LINE_REF_ID TAX_SUMMARY_LINE_ REF_ID TAX_REC_NREC_DIST_ REF_ID STATISTICAL_AMOUNT REF_AE_HEADER_ID REF_TEMP_LINE_NUM ACCOUNTING_LINE_CODE ACCOUNTING_LINE_ TYPE_CODE MERGE_DUPLICATE_CODE TEMP_LINE_NUM REF_EVENT_ID LINE_DEFINITION_ OWNER_CODE LINE_DEFINITION_CODE EVENT_CLASS_CODE EVENT_TYPE_CODE UPG_BATCH_ID CALCULATE_ACCTD_ AMTS_FLAG CALCULATE_G_L_AMTS_ FLAG ROUNDING_CLASS_CODE DOCUMENT_ROUNDING_ LEVEL UNROUNDED_ENTERED_DR UNROUNDED_ENTERED_CR DOC_ROUNDING_ ENTERED_AMT DOC_ROUNDING_ACCTD_ AMT UNROUNDED_ACCOUNTED_ CR UNROUNDED_ACCOUNTED_ DR APPLIED_TO_ APPLICATION_ID APPLIED_TO_ENTITY_ CODE APPLIED_TO_ENTITY_ID APPLIED_TO_SOURCE_ ID_NUM_1 APPLIED_TO_SOURCE_ ID_NUM_2 APPLIED_TO_SOURCE_ ID_NUM_3 APPLIED_TO_SOURCE_ ID_NUM_4 APPLIED_TO_SOURCE_ ID_CHAR_1 APPLIED_TO_SOURCE_ ID_CHAR_2 APPLIED_TO_SOURCE_ ID_CHAR_3 APPLIED_TO_SOURCE_ ID_CHAR_4 APPLIED_TO_ DISTRIBUTION_TYPE APPLIED_TO_DIST_ID_ NUM_1 APPLIED_TO_DIST_ID_ NUM_2 APPLIED_TO_DIST_ID_ NUM_3 APPLIED_TO_DIST_ID_ NUM_4 APPLIED_TO_DIST_ID_ NUM_5 APPLIED_TO_DIST_ID_ CHAR_1 APPLIED_TO_DIST_ID_ CHAR_2 APPLIED_TO_DIST_ID_ CHAR_3 APPLIED_TO_DIST_ID_ CHAR_4 APPLIED_TO_DIST_ID_ CHAR_5 ALLOC_TO_ APPLICATION_ID ALLOC_TO_ENTITY_CODE ALLOC_TO_SOURCE_ID_ NUM_1 ALLOC_TO_SOURCE_ID_ NUM_2 ALLOC_TO_SOURCE_ID_ NUM_3 ALLOC_TO_SOURCE_ID_ NUM_4 ALLOC_TO_SOURCE_ID_ CHAR_1 ALLOC_TO_SOURCE_ID_ CHAR_2 ALLOC_TO_SOURCE_ID_ CHAR_3 ALLOC_TO_SOURCE_ID_ CHAR_4 ALLOC_TO_ DISTRIBUTION_TYPE ALLOC_TO_DIST_ID_ NUM_1 ALLOC_TO_DIST_ID_ NUM_2 ALLOC_TO_DIST_ID_ NUM_3 ALLOC_TO_DIST_ID_ NUM_4 ALLOC_TO_DIST_ID_ NUM_5 ALLOC_TO_DIST_ID_ CHAR_1 ALLOC_TO_DIST_ID_ CHAR_2 ALLOC_TO_DIST_ID_ CHAR_3 ALLOC_TO_DIST_ID_ CHAR_4 ALLOC_TO_DIST_ID_ CHAR_5 GAIN_OR_LOSS_REF

    0 rows retrieved
  
  
• See SQL
  
  

Supplier     [Top]

• AP_SUPPLIERS

  VENDOR_ID LAST_UPDATE_DATE LAST_UPDATED_BY VENDOR_NAME VENDOR_NAME_ALT SEGMENT1 SUMMARY_FLAG ENABLED_FLAG SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY EMPLOYEE_ID VENDOR_TYPE_LOOKUP_ CODE CUSTOMER_NUM ONE_TIME_FLAG PARENT_VENDOR_ID MIN_ORDER_AMOUNT SHIP_TO_LOCATION_ID BILL_TO_LOCATION_ID SHIP_VIA_LOOKUP_CODE FREIGHT_TERMS_ LOOKUP_CODE FOB_LOOKUP_CODE TERMS_ID SET_OF_BOOKS_ID CREDIT_STATUS_ LOOKUP_CODE CREDIT_LIMIT ALWAYS_TAKE_DISC_ FLAG PAY_DATE_BASIS_ LOOKUP_CODE PAY_GROUP_LOOKUP_ CODE PAYMENT_PRIORITY INVOICE_CURRENCY_ CODE PAYMENT_CURRENCY_ CODE INVOICE_AMOUNT_LIMIT EXCHANGE_DATE_ LOOKUP_CODE HOLD_ALL_PAYMENTS_ FLAG HOLD_FUTURE_ PAYMENTS_FLAG HOLD_REASON DISTRIBUTION_SET_ID ACCTS_PAY_CODE_ COMBINATION_ID DISC_LOST_CODE_ COMBINATION_ID DISC_TAKEN_CODE_ COMBINATION_ID EXPENSE_CODE_ COMBINATION_ID PREPAY_CODE_ COMBINATION_ID NUM_1099 TYPE_1099 WITHHOLDING_STATUS_ LOOKUP_CODE WITHHOLDING_START_ DATE ORGANIZATION_TYPE_ LOOKUP_CODE VAT_CODE START_DATE_ACTIVE END_DATE_ACTIVE MINORITY_GROUP_ LOOKUP_CODE PAYMENT_METHOD_ LOOKUP_CODE BANK_ACCOUNT_NAME BANK_ACCOUNT_NUM BANK_NUM BANK_ACCOUNT_TYPE WOMEN_OWNED_FLAG SMALL_BUSINESS_FLAG STANDARD_INDUSTRY_ CLASS HOLD_FLAG PURCHASING_HOLD_ REASON HOLD_BY HOLD_DATE TERMS_DATE_BASIS PRICE_TOLERANCE INSPECTION_REQUIRED_ FLAG RECEIPT_REQUIRED_ FLAG QTY_RCV_TOLERANCE QTY_RCV_EXCEPTION_ CODE ENFORCE_SHIP_TO_ LOCATION_CODE DAYS_EARLY_RECEIPT_ ALLOWED DAYS_LATE_RECEIPT_ ALLOWED RECEIPT_DAYS_ EXCEPTION_CODE RECEIVING_ROUTING_ID ALLOW_SUBSTITUTE_ RECEIPTS_FLAG ALLOW_UNORDERED_ RECEIPTS_FLAG HOLD_UNMATCHED_ INVOICES_FLAG EXCLUSIVE_PAYMENT_ FLAG AP_TAX_ROUNDING_RULE AUTO_TAX_CALC_FLAG AUTO_TAX_CALC_ OVERRIDE AMOUNT_INCLUDES_TAX_ FLAG TAX_VERIFICATION_ DATE NAME_CONTROL STATE_REPORTABLE_ FLAG FEDERAL_REPORTABLE_ FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REQUEST_ID PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE OFFSET_VAT_CODE VAT_REGISTRATION_NUM AUTO_CALCULATE_ INTEREST_FLAG VALIDATION_NUMBER EXCLUDE_FREIGHT_ FROM_DISCOUNT TAX_REPORTING_NAME CHECK_DIGITS BANK_NUMBER ALLOW_AWT_FLAG AWT_GROUP_ID GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE_ CATEGORY EDI_TRANSACTION_ HANDLING EDI_PAYMENT_METHOD EDI_PAYMENT_FORMAT EDI_REMITTANCE_ METHOD EDI_REMITTANCE_ INSTRUCTION BANK_CHARGE_BEARER BANK_BRANCH_TYPE MATCH_OPTION FUTURE_DATED_ PAYMENT_CCID CREATE_DEBIT_MEMO_ FLAG OFFSET_TAX_FLAG PARTY_ID PARENT_PARTY_ID NI_NUMBER TCA_SYNC_NUM_1099 TCA_SYNC_VENDOR_NAME TCA_SYNC_VAT_REG_NUM INDIVIDUAL_1099 UNIQUE_TAX_ REFERENCE_NUM PARTNERSHIP_UTR PARTNERSHIP_NAME CIS_ENABLED_FLAG FIRST_NAME SECOND_NAME LAST_NAME SALUTATION TRADING_NAME WORK_REFERENCE COMPANY_ REGISTRATION_NUMBER NATIONAL_INSURANCE_ NUMBER VERIFICATION_NUMBER VERIFICATION_ REQUEST_ID MATCH_STATUS_FLAG CIS_VERIFICATION_ DATE 6217 12/24/2007 19:46:53 1163 澶ф柟寤ｈ硣瑷婅偂浠芥湁闄愬叕鍙� 澶ф柟 60003577 N Y         -1 12/24/2007 19:46:53 1163   OTHER-PUR   N               10022       N DUE   99 NTD NTD     N N                           12/24/2007 19:46:53               N N   N       Invoice                         N                 N                                           86604556 N   N                                                                   R       18443       澶ф柟寤ｈ硣瑷婅偂浠芥湁闄愬叕鍙� 86604556

    1 row retrieved
  
  
• See SQL
  
  

  AP_SUPPLIER_SITES_ALL

  VENDOR_SITE_ID LAST_UPDATE_DATE LAST_UPDATED_BY VENDOR_ID VENDOR_SITE_CODE VENDOR_SITE_CODE_ALT LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY PURCHASING_SITE_FLAG RFQ_ONLY_SITE_FLAG PAY_SITE_FLAG ATTENTION_AR_FLAG ADDRESS_LINE1 ADDRESS_LINES_ALT ADDRESS_LINE2 ADDRESS_LINE3 CITY STATE ZIP PROVINCE COUNTRY AREA_CODE PHONE CUSTOMER_NUM SHIP_TO_LOCATION_ID BILL_TO_LOCATION_ID SHIP_VIA_LOOKUP_CODE FREIGHT_TERMS_ LOOKUP_CODE FOB_LOOKUP_CODE INACTIVE_DATE FAX FAX_AREA_CODE TELEX PAYMENT_METHOD_ LOOKUP_CODE BANK_ACCOUNT_NAME BANK_ACCOUNT_NUM BANK_NUM BANK_ACCOUNT_TYPE TERMS_DATE_BASIS CURRENT_CATALOG_NUM VAT_CODE DISTRIBUTION_SET_ID ACCTS_PAY_CODE_ COMBINATION_ID PREPAY_CODE_ COMBINATION_ID PAY_GROUP_LOOKUP_ CODE PAYMENT_PRIORITY TERMS_ID INVOICE_AMOUNT_LIMIT PAY_DATE_BASIS_ LOOKUP_CODE ALWAYS_TAKE_DISC_ FLAG INVOICE_CURRENCY_ CODE PAYMENT_CURRENCY_ CODE HOLD_ALL_PAYMENTS_ FLAG HOLD_FUTURE_ PAYMENTS_FLAG HOLD_REASON HOLD_UNMATCHED_ INVOICES_FLAG AP_TAX_ROUNDING_RULE AUTO_TAX_CALC_FLAG AUTO_TAX_CALC_ OVERRIDE AMOUNT_INCLUDES_TAX_ FLAG EXCLUSIVE_PAYMENT_ FLAG TAX_REPORTING_SITE_ FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REQUEST_ID PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE VALIDATION_NUMBER EXCLUDE_FREIGHT_ FROM_DISCOUNT VAT_REGISTRATION_NUM OFFSET_VAT_CODE ORG_ID CHECK_DIGITS BANK_NUMBER ADDRESS_LINE4 COUNTY ADDRESS_STYLE LANGUAGE ALLOW_AWT_FLAG AWT_GROUP_ID GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE_ CATEGORY EDI_TRANSACTION_ HANDLING EDI_ID_NUMBER EDI_PAYMENT_METHOD EDI_PAYMENT_FORMAT EDI_REMITTANCE_ METHOD BANK_CHARGE_BEARER EDI_REMITTANCE_ INSTRUCTION BANK_BRANCH_TYPE PAY_ON_CODE DEFAULT_PAY_SITE_ID PAY_ON_RECEIPT_ SUMMARY_CODE TP_HEADER_ID ECE_TP_LOCATION_CODE PCARD_SITE_FLAG MATCH_OPTION COUNTRY_OF_ORIGIN_ CODE FUTURE_DATED_ PAYMENT_CCID CREATE_DEBIT_MEMO_ FLAG OFFSET_TAX_FLAG SUPPLIER_NOTIF_ METHOD EMAIL_ADDRESS REMITTANCE_EMAIL PRIMARY_PAY_SITE_ FLAG SHIPPING_CONTROL SELLING_COMPANY_ IDENTIFIER GAPLESS_INV_NUM_FLAG DUNS_NUMBER TOLERANCE_ID LOCATION_ID PARTY_SITE_ID SERVICES_TOLERANCE_ ID RETAINAGE_RATE TCA_SYNC_STATE TCA_SYNC_PROVINCE TCA_SYNC_COUNTY TCA_SYNC_CITY TCA_SYNC_ZIP TCA_SYNC_COUNTRY 4589 12/24/2007 19:58:15 1163 6217 TW1 澶ф柟寤ｈ硣瑷婅偂浠芥湁闄愬叕鍙� -1 12/24/2007 19:58:15 1163 Y N Y N 鍙板寳绺ｆ案鍜屽競鐠版渤瑗胯矾   浜屾209宸�19铏�2 1妯撲箣3     234   TW   32338489   142 142         02-32338475 02             Invoice   P035   2026 2027 001CITI10L 99 10022   DUE N NTD NTD N N   N           N TW   86604556 67     9108418 A,D,S   J91           86604556         0 N     81             Y                                                       I               N R TW 2029 N                     5183 13145             234 TW

    1 row retrieved
  
  
• See SQL
  
  

Purchasing     [Top]

• PO_HEADERS_ALL

  PO_HEADER_ID AGENT_ID TYPE_LOOKUP_CODE LAST_UPDATE_DATE LAST_UPDATED_BY SEGMENT1 SUMMARY_FLAG ENABLED_FLAG SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 START_DATE_ACTIVE END_DATE_ACTIVE LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY VENDOR_ID VENDOR_SITE_ID VENDOR_CONTACT_ID SHIP_TO_LOCATION_ID BILL_TO_LOCATION_ID TERMS_ID SHIP_VIA_LOOKUP_CODE FOB_LOOKUP_CODE FREIGHT_TERMS_ LOOKUP_CODE STATUS_LOOKUP_CODE CURRENCY_CODE RATE_TYPE RATE_DATE RATE FROM_HEADER_ID FROM_TYPE_LOOKUP_ CODE START_DATE END_DATE BLANKET_TOTAL_AMOUNT AUTHORIZATION_STATUS REVISION_NUM REVISED_DATE APPROVED_FLAG APPROVED_DATE AMOUNT_LIMIT MIN_RELEASE_AMOUNT NOTE_TO_AUTHORIZER NOTE_TO_VENDOR NOTE_TO_RECEIVER PRINT_COUNT PRINTED_DATE VENDOR_ORDER_NUM CONFIRMING_ORDER_ FLAG COMMENTS REPLY_DATE REPLY_METHOD_LOOKUP_ CODE RFQ_CLOSE_DATE QUOTE_TYPE_LOOKUP_ CODE QUOTATION_CLASS_CODE QUOTE_WARNING_DELAY_ UNIT QUOTE_WARNING_DELAY QUOTE_VENDOR_QUOTE_ NUMBER ACCEPTANCE_REQUIRED_ FLAG ACCEPTANCE_DUE_DATE CLOSED_DATE USER_HOLD_FLAG APPROVAL_REQUIRED_ FLAG CANCEL_FLAG FIRM_STATUS_LOOKUP_ CODE FIRM_DATE FROZEN_FLAG SUPPLY_AGREEMENT_ FLAG EDI_PROCESSED_FLAG EDI_PROCESSED_STATUS ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 CLOSED_CODE USSGL_TRANSACTION_ CODE GOVERNMENT_CONTEXT REQUEST_ID PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE ORG_ID GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 INTERFACE_SOURCE_ CODE REFERENCE_NUM WF_ITEM_TYPE WF_ITEM_KEY MRC_RATE_TYPE MRC_RATE_DATE MRC_RATE PCARD_ID PRICE_UPDATE_ TOLERANCE PAY_ON_CODE XML_FLAG XML_SEND_DATE XML_CHANGE_SEND_DATE GLOBAL_AGREEMENT_ FLAG CONSIGNED_ CONSUMPTION_FLAG CBC_ACCOUNTING_DATE CONSUME_REQ_DEMAND_ FLAG CHANGE_REQUESTED_BY SHIPPING_CONTROL CONTERMS_EXIST_FLAG CONTERMS_ARTICLES_ UPD_DATE CONTERMS_DELIV_UPD_ DATE ENCUMBRANCE_ REQUIRED_FLAG PENDING_SIGNATURE_ FLAG CHANGE_SUMMARY DOCUMENT_CREATION_ METHOD SUBMIT_DATE SUPPLIER_NOTIF_ METHOD FAX EMAIL_ADDRESS RETRO_PRICE_COMM_ UPDATES_FLAG RETRO_PRICE_APPLY_ UPDATES_FLAG UPDATE_SOURCING_ RULES_FLAG AUTO_SOURCING_FLAG CREATED_LANGUAGE CPA_REFERENCE LOCK_OWNER_ROLE LOCK_OWNER_USER_ID SUPPLIER_AUTH_ ENABLED_FLAG CAT_ADMIN_AUTH_ ENABLED_FLAG STYLE_ID TAX_ATTRIBUTE_ UPDATE_CODE LAST_UPDATED_PROGRAM 13231 61 STANDARD 3/19/2008 15:29:41 1290 PTM8020946 N Y             1290 3/19/2008 15:20:55 1290 6217 4589 3876 142 142 10022         NTD                 APPROVED 0   Y 3/19/2008 15:29:41           0     N                   N         N     N       81           DM               ACER-PO-IMPORT-5783   OPEN     443493 201 42585 3/19/2008 15:24:30 81                                                                                             PDOI                             1

    1 row retrieved
  
  
• See SQL
  
  

  PO_DISTRIBUTIONS_ALL

  PO_DISTRIBUTION_ID LAST_UPDATE_DATE LAST_UPDATED_BY PO_HEADER_ID PO_LINE_ID LINE_LOCATION_ID SET_OF_BOOKS_ID CODE_COMBINATION_ID QUANTITY_ORDERED LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY PO_RELEASE_ID QUANTITY_DELIVERED QUANTITY_BILLED QUANTITY_CANCELLED REQ_HEADER_ REFERENCE_NUM REQ_LINE_REFERENCE_ NUM REQ_DISTRIBUTION_ID DELIVER_TO_LOCATION_ ID DELIVER_TO_PERSON_ID RATE_DATE RATE AMOUNT_BILLED ACCRUED_FLAG ENCUMBERED_FLAG ENCUMBERED_AMOUNT UNENCUMBERED_ QUANTITY UNENCUMBERED_AMOUNT FAILED_FUNDS_LOOKUP_ CODE GL_ENCUMBERED_DATE GL_ENCUMBERED_ PERIOD_NAME GL_CANCELLED_DATE DESTINATION_TYPE_ CODE DESTINATION_ ORGANIZATION_ID DESTINATION_ SUBINVENTORY ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 WIP_ENTITY_ID WIP_OPERATION_SEQ_ NUM WIP_RESOURCE_SEQ_NUM WIP_REPETITIVE_ SCHEDULE_ID WIP_LINE_ID BOM_RESOURCE_ID BUDGET_ACCOUNT_ID ACCRUAL_ACCOUNT_ID VARIANCE_ACCOUNT_ID PREVENT_ENCUMBRANCE_ FLAG USSGL_TRANSACTION_ CODE GOVERNMENT_CONTEXT DESTINATION_CONTEXT DISTRIBUTION_NUM SOURCE_DISTRIBUTION_ ID REQUEST_ID PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE PROJECT_ID TASK_ID EXPENDITURE_TYPE PROJECT_ACCOUNTING_ CONTEXT EXPENDITURE_ ORGANIZATION_ID GL_CLOSED_DATE ACCRUE_ON_RECEIPT_ FLAG EXPENDITURE_ITEM_ DATE ORG_ID KANBAN_CARD_ID AWARD_ID MRC_RATE_DATE MRC_RATE MRC_ENCUMBERED_ AMOUNT MRC_UNENCUMBERED_ AMOUNT END_ITEM_UNIT_NUMBER TAX_RECOVERY_ OVERRIDE_FLAG RECOVERABLE_TAX NONRECOVERABLE_TAX RECOVERY_RATE OKE_CONTRACT_LINE_ID OKE_CONTRACT_ DELIVERABLE_ID AMOUNT_ORDERED AMOUNT_DELIVERED AMOUNT_CANCELLED DISTRIBUTION_TYPE AMOUNT_TO_ENCUMBER INVOICE_ADJUSTMENT_ FLAG DEST_CHARGE_ACCOUNT_ ID DEST_VARIANCE_ ACCOUNT_ID QUANTITY_FINANCED AMOUNT_FINANCED QUANTITY_RECOUPED AMOUNT_RECOUPED RETAINAGE_WITHHELD_ AMOUNT RETAINAGE_RELEASED_ AMOUNT WF_ITEM_KEY INVOICED_VAL_IN_NTFN TAX_ATTRIBUTE_ UPDATE_CODE INTERFACE_ DISTRIBUTION_REF 28515 3/28/2008 15:2:52 1290 13231 28553 28213 2022 29500 1 200749 3/19/2008 15:20:55 1290   0 0 0               0   N               EXPENSE 81   81                         222019 ACER-PO-IMPORT-5783                 2008 29500 N     EXPENSE 1   452434 201 32766 3/28/2008 15:2:52             Y   81                                 STANDARD

    1 row retrieved
  
  
• See SQL
  
  

  PO_LINES_ALL

  PO_LINE_ID LAST_UPDATE_DATE LAST_UPDATED_BY PO_HEADER_ID LINE_TYPE_ID LINE_NUM LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY ITEM_ID ITEM_REVISION CATEGORY_ID ITEM_DESCRIPTION UNIT_MEAS_LOOKUP_ CODE QUANTITY_COMMITTED COMMITTED_AMOUNT ALLOW_PRICE_ OVERRIDE_FLAG NOT_TO_EXCEED_PRICE LIST_PRICE_PER_UNIT UNIT_PRICE QUANTITY UN_NUMBER_ID HAZARD_CLASS_ID NOTE_TO_VENDOR FROM_HEADER_ID FROM_LINE_ID MIN_ORDER_QUANTITY MAX_ORDER_QUANTITY QTY_RCV_TOLERANCE OVER_TOLERANCE_ ERROR_FLAG MARKET_PRICE UNORDERED_FLAG CLOSED_FLAG USER_HOLD_FLAG CANCEL_FLAG CANCELLED_BY CANCEL_DATE CANCEL_REASON FIRM_STATUS_LOOKUP_ CODE FIRM_DATE VENDOR_PRODUCT_NUM CONTRACT_NUM TAXABLE_FLAG TAX_NAME TYPE_1099 CAPITAL_EXPENSE_FLAG NEGOTIATED_BY_ PREPARER_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 REFERENCE_NUM ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 MIN_RELEASE_AMOUNT PRICE_TYPE_LOOKUP_ CODE CLOSED_CODE PRICE_BREAK_LOOKUP_ CODE USSGL_TRANSACTION_ CODE GOVERNMENT_CONTEXT REQUEST_ID PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE CLOSED_DATE CLOSED_REASON CLOSED_BY TRANSACTION_REASON_ CODE ORG_ID QC_GRADE BASE_UOM BASE_QTY SECONDARY_UOM SECONDARY_QTY GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 LINE_REFERENCE_NUM PROJECT_ID TASK_ID EXPIRATION_DATE TAX_CODE_ID OKE_CONTRACT_HEADER_ ID OKE_CONTRACT_ VERSION_ID SECONDARY_QUANTITY SECONDARY_UNIT_OF_ MEASURE PREFERRED_GRADE AUCTION_HEADER_ID AUCTION_DISPLAY_ NUMBER AUCTION_LINE_NUMBER BID_NUMBER BID_LINE_NUMBER RETROACTIVE_DATE FROM_LINE_LOCATION_ ID SUPPLIER_REF_NUMBER CONTRACT_ID START_DATE AMOUNT JOB_ID CONTRACTOR_FIRST_ NAME CONTRACTOR_LAST_NAME ORDER_TYPE_LOOKUP_ CODE PURCHASE_BASIS MATCHING_BASIS SVC_AMOUNT_NOTIF_ SENT SVC_COMPLETION_ NOTIF_SENT BASE_UNIT_PRICE MANUAL_PRICE_CHANGE_ FLAG RETAINAGE_RATE MAX_RETAINAGE_AMOUNT PROGRESS_PAYMENT_ RATE RECOUPMENT_RATE CATALOG_NAME SUPPLIER_PART_AUXID IP_CATEGORY_ID TAX_ATTRIBUTE_ UPDATE_CODE LAST_UPDATED_PROGRAM 28553 3/19/2008 15:20:55 1290 13231 1 1000 186504 3/19/2008 15:20:55 1290     2123 7121.00004.J91|婕㈡浉鍒楀嵃绯荤当 鍠鐗� Each 1   N   2133 2133 1                     N     N                     N N 81 0000 C000   7SF   婕㈡浉鍒楀嵃-鍠               222019 ACER-PO-IMPORT-5783 PTM8020946|1|RM8030033L|1   COST FEE OPEN       443493 201 42585 3/19/2008 15:24:33         81                                                                                                     QUANTITY GOODS QUANTITY     2133

    1 row retrieved
  
  
• See SQL
  
  

  PO_LINE_LOCATIONS_ALL

  LINE_LOCATION_ID LAST_UPDATE_DATE LAST_UPDATED_BY PO_HEADER_ID PO_LINE_ID LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY QUANTITY QUANTITY_RECEIVED QUANTITY_ACCEPTED QUANTITY_REJECTED QUANTITY_BILLED QUANTITY_CANCELLED UNIT_MEAS_LOOKUP_ CODE PO_RELEASE_ID SHIP_TO_LOCATION_ID SHIP_VIA_LOOKUP_CODE NEED_BY_DATE PROMISED_DATE LAST_ACCEPT_DATE PRICE_OVERRIDE ENCUMBERED_FLAG ENCUMBERED_DATE UNENCUMBERED_ QUANTITY FOB_LOOKUP_CODE FREIGHT_TERMS_ LOOKUP_CODE TAXABLE_FLAG TAX_NAME ESTIMATED_TAX_AMOUNT FROM_HEADER_ID FROM_LINE_ID FROM_LINE_LOCATION_ ID START_DATE END_DATE LEAD_TIME LEAD_TIME_UNIT PRICE_DISCOUNT TERMS_ID APPROVED_FLAG APPROVED_DATE CLOSED_FLAG CANCEL_FLAG CANCELLED_BY CANCEL_DATE CANCEL_REASON FIRM_STATUS_LOOKUP_ CODE FIRM_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 UNIT_OF_MEASURE_ CLASS ENCUMBER_NOW ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 INSPECTION_REQUIRED_ FLAG RECEIPT_REQUIRED_ FLAG QTY_RCV_TOLERANCE QTY_RCV_EXCEPTION_ CODE ENFORCE_SHIP_TO_ LOCATION_CODE ALLOW_SUBSTITUTE_ RECEIPTS_FLAG DAYS_EARLY_RECEIPT_ ALLOWED DAYS_LATE_RECEIPT_ ALLOWED RECEIPT_DAYS_ EXCEPTION_CODE INVOICE_CLOSE_ TOLERANCE RECEIVE_CLOSE_ TOLERANCE SHIP_TO_ ORGANIZATION_ID SHIPMENT_NUM SOURCE_SHIPMENT_ID SHIPMENT_TYPE CLOSED_CODE REQUEST_ID PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE USSGL_TRANSACTION_ CODE GOVERNMENT_CONTEXT RECEIVING_ROUTING_ID ACCRUE_ON_RECEIPT_ FLAG CLOSED_REASON CLOSED_DATE CLOSED_BY ORG_ID QUANTITY_SHIPPED GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 COUNTRY_OF_ORIGIN_ CODE TAX_USER_OVERRIDE_ FLAG MATCH_OPTION TAX_CODE_ID CALCULATE_TAX_FLAG CHANGE_PROMISED_ DATE_REASON NOTE_TO_RECEIVER SECONDARY_QUANTITY SECONDARY_UNIT_OF_ MEASURE PREFERRED_GRADE SECONDARY_QUANTITY_ RECEIVED SECONDARY_QUANTITY_ ACCEPTED SECONDARY_QUANTITY_ REJECTED SECONDARY_QUANTITY_ CANCELLED VMI_FLAG CONSIGNED_FLAG RETROACTIVE_DATE SUPPLIER_ORDER_LINE_ NUMBER AMOUNT AMOUNT_RECEIVED AMOUNT_BILLED AMOUNT_CANCELLED AMOUNT_REJECTED AMOUNT_ACCEPTED DROP_SHIP_FLAG SALES_ORDER_UPDATE_ DATE TRANSACTION_FLOW_ HEADER_ID FINAL_MATCH_FLAG MANUAL_PRICE_CHANGE_ FLAG SHIPMENT_CLOSED_DATE CLOSED_FOR_ RECEIVING_DATE CLOSED_FOR_INVOICE_ DATE SECONDARY_QUANTITY_ SHIPPED VALUE_BASIS MATCHING_BASIS PAYMENT_TYPE DESCRIPTION WORK_APPROVER_ID BID_PAYMENT_ID QUANTITY_FINANCED AMOUNT_FINANCED QUANTITY_RECOUPED AMOUNT_RECOUPED RETAINAGE_WITHHELD_ AMOUNT RETAINAGE_RELEASED_ AMOUNT AMOUNT_SHIPPED OUTSOURCED_ASSEMBLY TAX_ATTRIBUTE_ UPDATE_CODE ORIGINAL_SHIPMENT_ID 28213 5/9/2008 9:27:14 1166 13231 28553 259884 3/19/2008 15:20:55 1290 1 0 0 0 0 0 Each   142         2133           N                     10022 Y 3/19/2008 15:29:41               81                             222019 ACER-PO-IMPORT-5783   N Y 0 WARNING WARNING N 10 10 NONE 0 0 81 1   STANDARD OPEN 452434 201 32766 3/28/2008 15:2:52     3 Y       81 0                                               R                                 0 0 0                     0 QUANTITY QUANTITY         0 0     0 0   2

    1 row retrieved
  
  
• See SQL
  
  

Encumbrance     [Top]

• GL_BC_PACKETS

  PACKET_ID LEDGER_ID JE_SOURCE_NAME JE_CATEGORY_NAME CODE_COMBINATION_ID ACTUAL_FLAG PERIOD_NAME PERIOD_YEAR PERIOD_NUM QUARTER_NUM CURRENCY_CODE STATUS_CODE LAST_UPDATE_DATE LAST_UPDATED_BY BUDGET_VERSION_ID ENCUMBRANCE_TYPE_ID TEMPLATE_ID ENTERED_DR ENTERED_CR ACCOUNTED_DR ACCOUNTED_CR USSGL_TRANSACTION_ CODE ORIGINATING_ROWID ACCOUNT_SEGMENT_ VALUE AUTOMATIC_ ENCUMBRANCE_FLAG FUNDING_BUDGET_ VERSION_ID FUNDS_CHECK_LEVEL_ CODE AMOUNT_TYPE BOUNDARY_CODE TOLERANCE_PERCENTAGE TOLERANCE_AMOUNT OVERRIDE_AMOUNT DR_CR_CODE ACCOUNT_TYPE ACCOUNT_CATEGORY_ CODE EFFECT_ON_FUNDS_CODE RESULT_CODE BUDGET_POSTED_ BALANCE ACTUAL_POSTED_ BALANCE ENCUMBRANCE_POSTED_ BALANCE BUDGET_APPROVED_ BALANCE ACTUAL_APPROVED_ BALANCE ENCUMBRANCE_ APPROVED_BALANCE BUDGET_PENDING_ BALANCE ACTUAL_PENDING_ BALANCE ENCUMBRANCE_PENDING_ BALANCE REFERENCE1 REFERENCE2 REFERENCE3 REFERENCE4 REFERENCE5 JE_BATCH_NAME JE_BATCH_ID JE_HEADER_ID JE_LINE_NUM JE_LINE_DESCRIPTION REFERENCE6 REFERENCE7 REFERENCE8 REFERENCE9 REFERENCE10 REFERENCE11 REFERENCE12 REFERENCE13 REFERENCE14 REFERENCE15 REQUEST_ID USSGL_PARENT_ID USSGL_LINK_TO_ PARENT_ID EVENT_ID AE_HEADER_ID AE_LINE_NUM BC_DATE SOURCE_DISTRIBUTION_ TYPE SOURCE_DISTRIBUTION_ ID_CHAR_1 SOURCE_DISTRIBUTION_ ID_CHAR_2 SOURCE_DISTRIBUTION_ ID_CHAR_3 SOURCE_DISTRIBUTION_ ID_CHAR_4 SOURCE_DISTRIBUTION_ ID_CHAR_5 SOURCE_DISTRIBUTION_ ID_NUM_1 SOURCE_DISTRIBUTION_ ID_NUM_2 SOURCE_DISTRIBUTION_ ID_NUM_3 SOURCE_DISTRIBUTION_ ID_NUM_4 SOURCE_DISTRIBUTION_ ID_NUM_5 SESSION_ID SERIAL_ID APPLICATION_ID ENTITY_ID GROUP_ID

    0 rows retrieved
  
  
• See SQL
  
  

Prepayment     [Top]

• AP_PREPAY_APP_DISTS

  PREPAY_APP_DIST_ID PREPAY_DIST_LOOKUP_ CODE INVOICE_ DISTRIBUTION_ID PREPAY_APP_ DISTRIBUTION_ID ACCOUNTING_EVENT_ID PREPAY_HISTORY_ID PREPAY_EXCHANGE_DATE PREPAY_PAY_EXCHANGE_ DATE PREPAY_CLR_EXCHANGE_ DATE PREPAY_EXCHANGE_RATE PREPAY_PAY_EXCHANGE_ RATE PREPAY_CLR_EXCHANGE_ RATE PREPAY_EXCHANGE_ RATE_TYPE PREPAY_PAY_EXCHANGE_ RATE_TYPE PREPAY_CLR_EXCHANGE_ RATE_TYPE REVERSED_PREPAY_APP_ DIST_ID AMOUNT BASE_AMT_AT_PREPAY_ XRATE BASE_AMT_AT_PREPAY_ PAY_XRATE BASE_AMOUNT BASE_AMT_AT_PREPAY_ CLR_XRATE ROUNDING_AMT ROUND_AMT_AT_PREPAY_ XRATE ROUND_AMT_AT_PREPAY_ PAY_XRATE ROUND_AMT_AT_PREPAY_ CLR_XRATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE REQUEST_ID AWT_RELATED_ID RELEASE_INV_DIST_ DERIVED_FROM PA_ADDITION_FLAG BC_EVENT_ID AMOUNT_VARIANCE INVOICE_BASE_AMT_ VARIANCE QUANTITY_VARIANCE INVOICE_BASE_QTY_ VARIANCE

    0 rows retrieved
  
  
• See SQL
  
  

Payment Document and Bank     [Top]

• AP_BANK_BRANCHES

  BANK_BRANCH_ID LAST_UPDATE_DATE LAST_UPDATED_BY BANK_NAME BANK_BRANCH_NAME DESCRIPTION ADDRESS_LINE1 ADDRESS_LINE2 ADDRESS_LINE3 CITY STATE ZIP PROVINCE COUNTRY AREA_CODE PHONE CONTACT_FIRST_NAME CONTACT_MIDDLE_NAME CONTACT_LAST_NAME CONTACT_PREFIX CONTACT_TITLE BANK_NUM LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY INSTITUTION_TYPE CLEARING_HOUSE_ID TRANSMISSION_ PROGRAM_ID PRINTING_PROGRAM_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REQUEST_ID PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE ADDRESS_STYLE BANK_NUMBER ADDRESS_LINE4 COUNTY EFT_USER_NUMBER EFT_SWIFT_CODE END_DATE EDI_ID_NUMBER BANK_BRANCH_TYPE GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 BANK_NAME_ALT BANK_BRANCH_NAME_ALT ADDRESS_LINES_ALT ACTIVE_DATE TP_HEADER_ID ECE_TP_LOCATION_CODE PAYROLL_BANK_ ACCOUNT_ID RFC_IDENTIFIER BANK_ADMIN_EMAIL

    0 rows retrieved
  
  
• See SQL
  
  

  AP_BANK_ACCOUNTS_ALL

  BANK_ACCOUNT_ID BANK_ACCOUNT_NAME LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY BANK_ACCOUNT_NUM BANK_BRANCH_ID SET_OF_BOOKS_ID CURRENCY_CODE DESCRIPTION CONTACT_FIRST_NAME CONTACT_MIDDLE_NAME CONTACT_LAST_NAME CONTACT_PREFIX CONTACT_TITLE CONTACT_AREA_CODE CONTACT_PHONE MAX_CHECK_AMOUNT MIN_CHECK_AMOUNT ONE_SIGNATURE_MAX_ FLAG INACTIVE_DATE AVG_FLOAT_DAYS ASSET_CODE_ COMBINATION_ID GAIN_CODE_ COMBINATION_ID LOSS_CODE_ COMBINATION_ID BANK_ACCOUNT_TYPE VALIDATION_NUMBER MAX_OUTLAY MULTI_CURRENCY_FLAG ACCOUNT_TYPE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 POOLED_FLAG ZERO_AMOUNTS_ALLOWED REQUEST_ID PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE RECEIPT_MULTI_ CURRENCY_FLAG CHECK_DIGITS ORG_ID CASH_CLEARING_CCID BANK_CHARGES_CCID BANK_ERRORS_CCID EARNED_CCID UNEARNED_CCID ON_ACCOUNT_CCID UNAPPLIED_CCID UNIDENTIFIED_CCID FACTOR_CCID RECEIPT_CLEARING_ CCID REMITTANCE_CCID SHORT_TERM_DEPOSIT_ CCID GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 BANK_ACCOUNT_NAME_ ALT ACCOUNT_HOLDER_NAME ACCOUNT_HOLDER_NAME_ ALT EFT_REQUESTER_ID EFT_USER_NUMBER PAYROLL_BANK_ ACCOUNT_ID FUTURE_DATED_ PAYMENT_CCID EDISC_RECEIVABLES_ TRX_ID UNEDISC_RECEIVABLES_ TRX_ID BR_REMITTANCE_CCID BR_FACTOR_CCID BR_STD_RECEIVABLES_ TRX_ID ALLOW_MULTI_ ASSIGNMENTS_FLAG AGENCY_LOCATION_CODE IBAN_NUMBER Asset Account Cash Clearing Account

    0 rows retrieved
  
  
• See SQL
  
  

  AP_CHECK_STOCKS_ALL

  CHECK_STOCK_ID LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY NAME BANK_ACCOUNT_ID DISBURSEMENT_TYPE_ LOOKUP_CODE CHECK_FORMAT_ID LAST_DOCUMENT_NUM LAST_AVAILABLE_ DOCUMENT_NUM NUM_SETUP_CHECKS AUTO_MEDIUM_ID CHECK_RECON_GROUP_ID SEQUENTIAL_FLAG INACTIVE_DATE FUTURE_PAY_CODE_ COMBINATION_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 DOC_CATEGORY_CODE ORG_ID BANK_CHARGES_CCID BANK_ERRORS_CCID CLEARING_DAYS FUTURE_DATED_ PAYMENTS_FLAG CASH_CLEARING_CCID TRANSMISSION_CODE

    0 rows retrieved
  
  
• See SQL
  
  

  AP_CHECK_FORMATS

  CHECK_FORMAT_ID LAST_UPDATE_DATE LAST_UPDATED_BY NAME TYPE STUB_FIRST_FLAG CHECK_LENGTH STUB_LENGTH INVOICES_PER_STUB OVERFLOW_RULE PRE_NUMBERED_FLAG CHECK_NUM_ROW_LINE DATE_ROW_LINE AMOUNT_ROW_LINE AMOUNT_WORDS_ROW_ LINE VENDOR_NUM_ROW_LINE VENDOR_NAME_ROW_LINE VENDOR_ADDRESS_ROW_ LINE STUB_CHECK_NUM_ROW_ LINE STUB_VENDOR_NAME_ ROW_LINE STUB_VENDOR_NUM_ROW_ LINE STUB_FIRST_INVOICE_ ROW_LINE PAYMENT_METHOD_ LOOKUP_CODE CURRENCY_CODE CREATE_PAYMENTS_ PROGRAM_ID CONFIRM_PAYMENTS_ PROGRAM_ID SEPARATE_REMITTANCE_ ADVICE REMITTANCE_ADVICE_ PROGRAM_ID LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY EFT_TYPE MULTI_CURRENCY_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ZERO_AMOUNTS_ONLY BUILD_PAYMENTS_ PROGRAM_ID FORMAT_PAYMENTS_ PROGRAM_ID PRINT_CHECK_STUB GROUP_BY_DUE_DATE GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 BANK_FILE_CHARACTER_ SET TRANSMISSIONS_FLAG

    0 rows retrieved
  
  
• See SQL
  
  

  AP_PAYMENT_PROGRAMS

  PROGRAM_ID PROGRAM_NAME PROGRAM_TYPE FRIENDLY_NAME LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN TRANSMISSIONS_ ENABLED

    0 rows retrieved
  
  
• See SQL
  
  

Cash Management     [Top]

• CE_STATEMENT_RECONCILS_ALL

  STATEMENT_LINE_ID REFERENCE_TYPE REFERENCE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE JE_HEADER_ID ORG_ID REFERENCE_STATUS STATUS_FLAG ACTION_FLAG CURRENT_RECORD_FLAG AUTO_RECONCILED_FLAG AMOUNT REQUEST_ID PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE LEGAL_ENTITY_ID

    0 rows retrieved
  
  
• See SQL
  
  

  CE_STATEMENT_HEADERS_ALL

  STATEMENT_HEADER_ID BANK_ACCOUNT_ID STATEMENT_NUMBER STATEMENT_DATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE AUTO_LOADED_FLAG GL_DATE CONTROL_BEGIN_ BALANCE CONTROL_TOTAL_DR CONTROL_TOTAL_CR CONTROL_END_BALANCE CONTROL_DR_LINE_ COUNT CONTROL_CR_LINE_ COUNT CURRENCY_CODE LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 STATEMENT_COMPLETE_ FLAG ORG_ID DOC_SEQUENCE_ID DOC_SEQUENCE_VALUE CHECK_DIGITS CASHFLOW_BALANCE INT_CALC_BALANCE ONE_DAY_FLOAT TWO_DAY_FLOAT GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20

    0 rows retrieved
  
  
• See SQL
  
  

  CE_STATEMENT_LINES_ALL

  STATEMENT_LINE_ID STATEMENT_HEADER_ID LINE_NUMBER TRX_DATE TRX_TYPE AMOUNT STATUS CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE TRX_CODE_ID EFFECTIVE_DATE BANK_TRX_NUMBER TRX_TEXT CUSTOMER_TEXT INVOICE_TEXT BANK_ACCOUNT_TEXT CURRENCY_CODE EXCHANGE_RATE_TYPE EXCHANGE_RATE EXCHANGE_RATE_DATE ORIGINAL_AMOUNT CHARGES_AMOUNT LAST_UPDATE_LOGIN RECONCILE_TO_ STATEMENT_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 CE_STATEMENT_LINES JE_STATUS_FLAG ACCOUNTING_DATE GL_ACCOUNT_CCID REFERENCE_TXT TRX_CODE CASHFLOW_ID GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20

    0 rows retrieved
  
  
• See SQL
  
  

Treasury Confirmation     [Top]

• FV_TREASURY_CONFIRMATIONS_ALL

  TREASURY_ CONFIRMATION_ID CHECKRUN_NAME TREASURY_DOC_DATE ACCEPTANCE_DATE BEGIN_DOC_NUM END_DOC_NUM TREASURY_AMOUNT PAYMENT_BATCH_AMOUNT LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY SET_OF_BOOKS_ID INVOICE_PAYMENT_ID CONFIRMATION_STATUS_ FLAG GL_PERIOD DIT_CASH_TRAN_CODE ORG_ID ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_CATEGORY RANGE_TYPE PAYMENT_INSTRUCTION_ ID EVENT_ID

    0 rows retrieved
  
  
• See SQL
  
  

Currency     [Top]

• FND_CURRENCIES

  CURRENCY_CODE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ENABLED_FLAG CURRENCY_FLAG DESCRIPTION ISSUING_TERRITORY_ CODE PRECISION EXTENDED_PRECISION SYMBOL START_DATE_ACTIVE END_DATE_ACTIVE MINIMUM_ACCOUNTABLE_ UNIT CONTEXT ISO_FLAG ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 DERIVE_EFFECTIVE DERIVE_TYPE DERIVE_FACTOR NTD 7/17/2007 16:50:30 1090 7/17/2007 16:48:31 1090 33922 Y Y   TW 0 5           N

    1 row retrieved
  
  
• See SQL
  
  

References     [Top]

• None at present
  

XML File Information     [Top]

• XML Engine Version = 3.2
  
• File Name = APListXml.xml (File Version = 120.0.12000000.3, File Location = ap/diag, Date = 2007/09/19)
  

If you are experiencing any issues regarding this diagnostic test, please use Metalink to log an iTAR (Service Request) for product "Support Diagnostics Project" (ID=1332).
If you have any question related to support diagnostic tools (installation, execution, usage or availability), you can ask us using the Support Diagnostics Project forum on Metalink.
We would also appreciate your feedback regarding the usefulness of this test, however, there will be no replies to feedback emails.

---

============ End Test Result ============