Oracle Diagnostics Information	Ledger Definition	Secondary Ledgers
Setup	Summary	Invoice
Payment	Withholding Tax	Accounting
Trial Balance	General Ledger	Supplier
Purchasing	Encumbrance	Prepayment
R11i Payment Document and Bank Details	R12 Payment Document and Bank Details	Cash Management
Expense Report Details	Treasury Confirmation	Currency
References	XML File Information

Database Information    [Top]

• Server = ct11bzdb107
  
• Version = Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
  
• Name/SID = GROA071
  
• Language = AMERICAN
  
• Character Set = AL32UTF8
  

Application Information    [Top]

• Release = 12.1.3
  
• Application = Payables (200) with status of INSTALLED
  
• Responsibility = Payables Manager (20639)
  
• Security Group = Standard
  
• MultiOrg Flag = Y
  

Oracle Diagnostics Information    [Top]

• Patch OD for R12.1.3 (8919495) is installed
  
• Patch Oracle E-Business Suite Diagnostics, R12.IZU.B.DELTA.3 (9239092) is installed
  

Search Criteria = Invoice
Supplier Name = BEST EVER INDUSTRIES LIMITED
Invoice Id = 14001380
Include GL Tables = Yes
Include Related Data = Yes
Max Rows Displayed = 500
Ledger Definition    [Top]

Standard Information
• Name = US_USD_P (Id = 2052)
  
• Short Name = US_USD_P (AMER)
  
• Description = United States USD Ledger
  
• Currency = USD
  
• Chart of Accounts = MSIGL_CORP_ACCT_FLEX (Id = 50348)
  
• Type = Primary Ledger
  
Accounting Calendar
• Accounting Calendar = MSI CALENDAR
  
• Period Type = 21
  
• First Ever Opened Period = DEC-08
  
• Number of Future Enterable Periods = 2
  
Subledger Accounting Options
• Subledger Accounting Method = Motorola Solutions 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 ALLOW_INV_THIRD_ PARTY_OVRD ALLOW_PYMT_THIRD_ PARTY_OVRD WITHHOLDING_DATE_ BASIS INVRATE_FOR_PREPAY_ TAX 09-Aug-2012 1235 2052 USD N N USD USD     VOID EXCEPT LAST   10000   DISCOUNT 3027     4009     Y 0         Y 10020 EMPLOYEE 99 3005 Y N Corporate 2020 2020 Y Y S Y               MMDDYY Y N     STANDARD N BATCH Y           Invoice N N N           N     N Y N N Y     N N   N 2020 2020 N N     NEVER NEVER N N 102 Y N                                             Y N N N N   N   2020                                         ALWAYS ALWAYS BANK ACCOUNT ISSUE           10045 10022   N Y N N             11000     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 01-Jun-2012 1921 2052         2475 FOLLOW ROUTING GUIDE FCA           3027 3005 4009 2 N   N   N       121 228386 29-Sep-2011 1217 COLLECT/3RD PARTY BILLING N   0 H   Y           US 2020 2020 102                     3016

    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 102 US_100140 09-Sep-2011   US_100140 2052 23351

    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 COMMITMENT_BUDGET_ FLAG NET_CLOSING_BAL_FLAG AUTOMATE_SEC_JRNL_ REV_FLAG 2052 US_USD_P US_USD_P (AMER) United States USD Ledger PRIMARY NONE L L   1052 50348 USD MSI CALENDAR 21 DEC-08 2000 Y Y Y N 2001     4028 N N N N N N N N     N I SEGMENT1 A   1014887   1020 2001 2 L   MAR-13 2008 Corporate 1000     MSI_STANDARD_ACCRUAL C US 4028   N       23-Oct-2012 1152 31-Aug-2011 1153 6878318                                 N Y N Y   N N

    1 row retrieved
  
  
• See SQL
  
  

  XLA_LEDGER_OPTIONS

  APPLICATION_ID LEDGER_ID TRANSFER_TO_GL_MODE_ CODE ACCT_REVERSAL_ OPTION_CODE CAPTURE_EVENT_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN ENABLED_FLAG ROUNDING_RULE_CODE MERGE_ACCT_OPTION_ CODE EFFECTIVE_PERIOD_NUM 200 2052 A SIDE Y 31-Aug-2011 1153 09-May-2012 1153 205016 Y NEAREST NONE 20130003

    1 row retrieved
  
  
• See SQL
  
  

  XLA_LAUNCH_OPTIONS

  APPLICATION_ID LEDGER_ID ACCOUNTING_MODE_CODE ACCOUNTING_MODE_ OVERRIDE_FLAG SUMMARY_REPORT_FLAG SUMMARY_REPORT_ OVERRIDE_FLAG SUBMIT_TRANSFER_TO_ GL_FLAG SUBMIT_TRANSFER_ OVERRIDE_FLAG SUBMIT_GL_POST_FLAG SUBMIT_GL_POST_ OVERRIDE_FLAG ERROR_LIMIT PROCESSES CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PROCESSING_UNIT_SIZE 200 2052 F Y N Y Y Y N N   1 31-Aug-2011 1153 09-May-2012 1153 205016 1000

    1 row retrieved
  
  
• See SQL
  
  

  XLA_SUBLEDGERS

  APPLICATION_ID JE_SOURCE_NAME VALUATION_METHOD_ FLAG DRILLDOWN_PROCEDURE_ NAME SECURITY_FUNCTION_ NAME APPLICATION_TYPE_ CODE CONTROL_ACCOUNT_ ENABLED_FLAG DEFAULT_PARTY_TYPE_ CODE ALC_ENABLED_FLAG CONTROL_ACCOUNT_ SOURCE_CODE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CONTROL_ACCOUNT_ TYPE_CODE 200 Payables N AP_DRILLDOWN_PUB_PKG.DRILLDOWN XLA_SECURITY_POLICY_PKG.MO_POLICY S     Y   11-Nov-2005 120 11-Nov-2005 120 0 SUPPLIER

    1 row retrieved
  
  
• See SQL
  
  

  GL_LEDGER_CONFIG_DETAILS

  CONFIGURATION_ID OBJECT_TYPE_CODE OBJECT_ID OBJECT_NAME SETUP_STEP_CODE NEXT_ACTION_CODE STATUS_CODE CREATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE 1052 PRIMARY 2052 US_USD_P ACCTG_SEQUENCE NONE NOT_STARTED 1153 59868 31-Aug-2011 1153 31-Aug-2011 1052 PRIMARY 2052 US_USD_P ALC_SETUP CONFIRM_SETUP CONFIRMED 1153 59868 31-Aug-2011 1153 31-Aug-2011 1052 PRIMARY 2052 US_USD_P BSV_ASSIGNMENTS NONE CONFIRMED 1153 87983 28-Oct-2011 1153 31-Aug-2011 1052 PRIMARY 2052 US_USD_P INTER_ASSG NONE CONFIRMED 1153 5072138 02-Oct-2012 1151 31-Aug-2011 1052 PRIMARY 2052 US_USD_P INTRA_BAL NONE CONFIRMED 59868 5072138 02-Oct-2012 1151 31-Aug-2011 1052 PRIMARY 2052 US_USD_P NONE   CONFIRMED 1153 6878318 23-Oct-2012 1152 31-Aug-2011 1052 PRIMARY 2052 US_USD_P OU_SETUP NONE CONFIRMED 1153 59868 31-Aug-2011 1153 31-Aug-2011 1052 PRIMARY 2052 US_USD_P SLAM_SETUP REVIEW_DEFAULTS CONFIRMED 1153 154107 09-May-2012 1153 31-Aug-2011 1052 LEGAL_ENTITY 23338 Motorola Solutions, Inc. NONE NONE CONFIRMED 1153 59868 31-Aug-2011 1153 31-Aug-2011 1052 LEGAL_ENTITY 23351 Symbol Technologies, Inc. NONE NONE CONFIRMED 1151 62968 09-Sep-2011 1151 09-Sep-2011 1052 LEGAL_ENTITY 24283 Symbol Technologies, Inc., IDC Branch NONE NONE CONFIRMED 1151 69457 23-Sep-2011 1151 23-Sep-2011 1052 LEGAL_ENTITY 24284 Motorola Solutions, Inc. Buy/Sell Operation NONE NONE CONFIRMED 1151 69499 23-Sep-2011 1151 23-Sep-2011 1052 LEGAL_ENTITY 26407 Motorola Solutions, Inc., Bahrain Branch NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26412 Telxon Corporation NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26413 Metanetics Corporation NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26414 RTG Holdings, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26415 Covigo, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26416 AirDefense, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26417 Motorola Solutions USFGMD, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26418 Motorola Card, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26419 Iridium U.S., L.P. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26421 Invisix, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26422 Network Ventures I, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26423 @pos.com, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26424 The Retail Technology Group, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26425 Symbol Technologies International, Inc. (DE) NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26426 Telxon System Services, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26427 Symbol Technologies Finance, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26428 Symbol FSC, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26429 Bermuda Holdings 2005, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26430 Wireless Valley Communications, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26431 CRISNet, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26432 MeshNetworks, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26434 Motorola Solutions Credit Company LLC NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26435 Motorola Funding Corporation NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26436 Motorola Solutions Receivables Company LLC NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26437 Vertex Standard USA, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26438 Motorola Solutions Mexico Holdings, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26439 Software Corporation of America, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26440 Motorola Solutions International Capital LLC NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26445 Winphoria Networks Holdings, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 26446 NextNet Wireless, Inc. NONE NONE CONFIRMED 1153 87983 28-Oct-2011 1153 28-Oct-2011 1052 LEGAL_ENTITY 35288 PRINTRAK NONE NONE CONFIRMED 1151 146662 18-Jan-2012 1151 18-Jan-2012 1052 LEGAL_ENTITY 35289 GOOD SOFTWARE NONE NONE CONFIRMED 1151 146662 18-Jan-2012 1151 18-Jan-2012 1052 LEGAL_ENTITY 36292 Cambium Networks Inc. 100044 NONE NONE CONFIRMED 1151 155858 30-Jan-2012 1151 30-Jan-2012 1052 LEGAL_ENTITY 36294 Nokia Siemens Networks US LLC NONE NONE CONFIRMED 1151 155858 30-Jan-2012 1151 30-Jan-2012 1052 LEGAL_ENTITY 36339 Nokia Siemens Networks US LLC 984121 NONE NONE CONFIRMED 1151 155858 30-Jan-2012 1151 30-Jan-2012 1052 LEGAL_ENTITY 39299 Rhomobile, Inc NONE NONE CONFIRMED 1153 164042 10-Feb-2012 1153 10-Feb-2012 1052 LEGAL_ENTITY 39300 MOTOROLA DESIGNER SEMI IP NONE NONE CONFIRMED 1153 164042 10-Feb-2012 1153 10-Feb-2012 1052 LEGAL_ENTITY 39301 SONSHIRE INDUSTRIES, INC NONE NONE CONFIRMED 1153 164042 10-Feb-2012 1153 10-Feb-2012 1052 LEGAL_ENTITY 39302 US- FORCE COMPUTERS NONE NONE CONFIRMED 1153 164042 10-Feb-2012 1153 10-Feb-2012 1052 LEGAL_ENTITY 39303 MOTOROLA US ORTHOGON NONE NONE CONFIRMED 1153 164042 10-Feb-2012 1153 10-Feb-2012 1052 LEGAL_ENTITY 39304 MFSC NONE NONE CONFIRMED 1153 164042 10-Feb-2012 1153 10-Feb-2012 1052 LEGAL_ENTITY 39305 CTX NONE NONE CONFIRMED 1153 164042 10-Feb-2012 1153 10-Feb-2012 1052 LEGAL_ENTITY 41291 Winphoria Networks Holdings, Inc. NONE NONE CONFIRMED 1153 164973 15-Feb-2012 1153 15-Feb-2012 1052 LEGAL_ENTITY 41292 Motorola Receivables Corporation NONE NONE CONFIRMED 1153 164973 15-Feb-2012 1153 15-Feb-2012

    56 rows retrieved
  
  
• See SQL
  
  

  GL_LEDGER_RELATIONSHIPS

  RELATIONSHIP_ID SOURCE_LEDGER_ID TARGET_LEDGER_ID SLA_LEDGER_ID PRIMARY_LEDGER_ID TARGET_CURRENCY_CODE TARGET_LEDGER_NAME TARGET_LEDGER_SHORT_ NAME TARGET_LEDGER_ CATEGORY_CODE RELATIONSHIP_TYPE_ CODE RELATIONSHIP_ ENABLED_FLAG INHERIT_CREATION_ USER_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN GL_JE_CONVERSION_ SET_ID SL_COA_MAPPING_ID AUTOMATIC_POST_FLAG ALC_DEFAULT_CONV_ RATE_TYPE ALC_NO_RATE_ACTION_ CODE ALC_MAX_DAYS_ROLL_ RATE ALC_INHERIT_ CONVERSION_TYPE ALC_INIT_CONV_ OPTION_CODE ALC_INIT_PERIOD ALC_INIT_DATE ALC_INITIALIZING_ RATE_DATE ALC_INITIALIZING_ RATE_TYPE ALC_PERIOD_AVERAGE_ RATE_TYPE ALC_PERIOD_END_RATE_ TYPE APPLICATION_ID ORG_ID DISABLE_CONVERSION_ DATE STATUS_CODE HIST_CONV_STATUS_ CODE 1020 2052 2052 2052 2052 USD US_USD_P US_USD_P (AMER) PRIMARY NONE Y Y 31-Aug-2011 1153 31-Aug-2011 1153 59868                             101 -99

    1 row retrieved
  
  
• See SQL
  
  

  GL_LEGAL_ENTITIES_BSVS

  LEGAL_ENTITY_ID FLEX_VALUE_SET_ID FLEX_SEGMENT_VALUE START_DATE END_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY 35289 1014887 107600     18-Jan-2012 1151 146662 18-Jan-2012 1151 35288 1014887 106000     18-Jan-2012 1151 146662 18-Jan-2012 1151 39299 1014887 100149     10-Feb-2012 1153 164042 10-Feb-2012 1153 39300 1014887 101300     10-Feb-2012 1153 164042 10-Feb-2012 1153 39301 1014887 106145     10-Feb-2012 1153 164042 10-Feb-2012 1153 39302 1014887 106300     10-Feb-2012 1153 164042 10-Feb-2012 1153 39303 1014887 106400     10-Feb-2012 1153 164042 10-Feb-2012 1153 39304 1014887 107000     10-Feb-2012 1153 164042 10-Feb-2012 1153 39305 1014887 250000     10-Feb-2012 1153 164042 10-Feb-2012 1153 23351 1014887 100140 01-Dec-2008   01-Oct-2012 1152 5023959 09-Sep-2011 1151 36292 1014887 100044     30-Jan-2012 1151 155858 30-Jan-2012 1151 36294 1014887 100121     30-Jan-2012 1151 155858 30-Jan-2012 1151 36339 1014887 984121     30-Jan-2012 1151 155858 30-Jan-2012 1151 41291 1014887 101700     15-Feb-2012 1153 164973 15-Feb-2012 1153 41292 1014887 108200     15-Feb-2012 1153 164973 15-Feb-2012 1153 24283 1014887 100145     30-Aug-2012 1151 2336089 23-Sep-2011 1151 26412 1014887 100141     28-Oct-2011 1153 87983 28-Oct-2011 1153 26413 1014887 100142     28-Oct-2011 1153 87983 28-Oct-2011 1153 26414 1014887 100144     28-Oct-2011 1153 87983 28-Oct-2011 1153 26415 1014887 100146     28-Oct-2011 1153 87983 28-Oct-2011 1153 26416 1014887 100148     28-Oct-2011 1153 87983 28-Oct-2011 1153 26417 1014887 100900     28-Oct-2011 1153 87983 28-Oct-2011 1153 26445 1014887 101900     28-Oct-2011 1153 87983 28-Oct-2011 1153 26418 1014887 103000     28-Oct-2011 1153 87983 28-Oct-2011 1153 26419 1014887 104700     28-Oct-2011 1153 87983 28-Oct-2011 1153 26421 1014887 105000     28-Oct-2011 1153 87983 28-Oct-2011 1153 26422 1014887 106100     28-Oct-2011 1153 87983 28-Oct-2011 1153 26423 1014887 106140     28-Oct-2011 1153 87983 28-Oct-2011 1153 26424 1014887 106141     28-Oct-2011 1153 87983 28-Oct-2011 1153 26425 1014887 106143     28-Oct-2011 1153 87983 28-Oct-2011 1153 26426 1014887 106144     28-Oct-2011 1153 87983 28-Oct-2011 1153 26427 1014887 106147     28-Oct-2011 1153 87983 28-Oct-2011 1153 26428 1014887 106149     28-Oct-2011 1153 87983 28-Oct-2011 1153 26429 1014887 106200     28-Oct-2011 1153 87983 28-Oct-2011 1153 26430 1014887 106500     28-Oct-2011 1153 87983 28-Oct-2011 1153 26431 1014887 106600     28-Oct-2011 1153 87983 28-Oct-2011 1153 26432 1014887 106700     28-Oct-2011 1153 87983 28-Oct-2011 1153 26446 1014887 107200     28-Oct-2011 1153 87983 28-Oct-2011 1153 26434 1014887 108000     01-Oct-2012 1152 5023959 28-Oct-2011 1153 26435 1014887 108100     28-Oct-2011 1153 87983 28-Oct-2011 1153 26436 1014887 108210     28-Oct-2011 1153 87983 28-Oct-2011 1153 26437 1014887 108500     02-Oct-2012 1151 5072138 28-Oct-2011 1153 26438 1014887 108600     28-Oct-2011 1153 87983 28-Oct-2011 1153 26439 1014887 109000     28-Oct-2011 1153 87983 28-Oct-2011 1153 26440 1014887 230000     28-Oct-2011 1153 87983 28-Oct-2011 1153 26407 1014887 984000 01-Dec-2008   01-Oct-2012 1152 5023959 28-Oct-2011 1153 23338 1014887 100000 01-Dec-2008   31-Aug-2011 1153 59868 31-Aug-2011 1153 24284 1014887 100001 01-Dec-2008   01-Oct-2012 1152 5023959 23-Sep-2011 1151

    48 rows retrieved
  
  
• See SQL
  
  

  GL_LEDGER_NORM_SEG_VALS

  LEDGER_ID SEGMENT_TYPE_CODE SEGMENT_VALUE SEGMENT_VALUE_TYPE_ CODE RECORD_ID LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY START_DATE END_DATE STATUS_CODE REQUEST_ID LEGAL_ENTITY_ID SLA_SEQUENCING_FLAG CONTEXT ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 2052 B 100000 S 1018 31-Aug-2011 1153 59868 31-Aug-2011 1153 01-Dec-2008       23338                                   2052 B 100001 S 1021 01-Oct-2012 1152 5023959 23-Sep-2011 1151 01-Dec-2008       24284                                   2052 B 100044 S 1422 30-Jan-2012 1151 155858 30-Jan-2012 1151         36292                                   2052 B 100121 S 1423 30-Jan-2012 1151 155858 30-Jan-2012 1151         36294                                   2052 B 100140 S 1019 01-Oct-2012 1152 5023959 09-Sep-2011 1151 01-Dec-2008       23351                                   2052 B 100141 S 1222 28-Oct-2011 1153 87983 28-Oct-2011 1153         26412                                   2052 B 100142 S 1223 28-Oct-2011 1153 87983 28-Oct-2011 1153         26413                                   2052 B 100144 S 1224 28-Oct-2011 1153 87983 28-Oct-2011 1153         26414                                   2052 B 100145 S 1020 30-Aug-2012 1151 2336089 23-Sep-2011 1151         24283                                   2052 B 100146 S 1225 28-Oct-2011 1153 87983 28-Oct-2011 1153         26415                                   2052 B 100148 S 1226 28-Oct-2011 1153 87983 28-Oct-2011 1153         26416                                   2052 B 100149 S 1574 10-Feb-2012 1153 164042 10-Feb-2012 1153         39299                                   2052 B 100900 S 1227 28-Oct-2011 1153 87983 28-Oct-2011 1153         26417                                   2052 B 101300 S 1575 10-Feb-2012 1153 164042 10-Feb-2012 1153         39300                                   2052 B 101700 S 1600 15-Feb-2012 1153 164973 15-Feb-2012 1153         41291                                   2052 B 101900 S 1228 28-Oct-2011 1153 87983 28-Oct-2011 1153         26445                                   2052 B 103000 S 1229 28-Oct-2011 1153 87983 28-Oct-2011 1153         26418                                   2052 B 104700 S 1230 28-Oct-2011 1153 87983 28-Oct-2011 1153         26419                                   2052 B 105000 S 1231 28-Oct-2011 1153 87983 28-Oct-2011 1153         26421                                   2052 B 106000 S 1394 18-Jan-2012 1151 146662 18-Jan-2012 1151         35288                                   2052 B 106100 S 1232 28-Oct-2011 1153 87983 28-Oct-2011 1153         26422                                   2052 B 106140 S 1233 28-Oct-2011 1153 87983 28-Oct-2011 1153         26423                                   2052 B 106141 S 1234 28-Oct-2011 1153 87983 28-Oct-2011 1153         26424                                   2052 B 106143 S 1235 28-Oct-2011 1153 87983 28-Oct-2011 1153         26425                                   2052 B 106144 S 1236 28-Oct-2011 1153 87983 28-Oct-2011 1153         26426                                   2052 B 106145 S 1576 10-Feb-2012 1153 164042 10-Feb-2012 1153         39301                                   2052 B 106147 S 1237 28-Oct-2011 1153 87983 28-Oct-2011 1153         26427                                   2052 B 106149 S 1238 28-Oct-2011 1153 87983 28-Oct-2011 1153         26428                                   2052 B 106200 S 1239 28-Oct-2011 1153 87983 28-Oct-2011 1153         26429                                   2052 B 106300 S 1577 10-Feb-2012 1153 164042 10-Feb-2012 1153         39302                                   2052 B 106400 S 1578 10-Feb-2012 1153 164042 10-Feb-2012 1153         39303                                   2052 B 106500 S 1240 28-Oct-2011 1153 87983 28-Oct-2011 1153         26430                                   2052 B 106600 S 1241 28-Oct-2011 1153 87983 28-Oct-2011 1153         26431                                   2052 B 106700 S 1242 28-Oct-2011 1153 87983 28-Oct-2011 1153         26432                                   2052 B 107000 S 1579 10-Feb-2012 1153 164042 10-Feb-2012 1153         39304                                   2052 B 107200 S 1243 28-Oct-2011 1153 87983 28-Oct-2011 1153         26446                                   2052 B 107600 S 1393 18-Jan-2012 1151 146662 18-Jan-2012 1151         35289                                   2052 B 108000 S 1244 01-Oct-2012 1152 5023959 28-Oct-2011 1153         26434                                   2052 B 108100 S 1245 28-Oct-2011 1153 87983 28-Oct-2011 1153         26435                                   2052 B 108200 S 1601 15-Feb-2012 1153 164973 15-Feb-2012 1153         41292                                   2052 B 108210 S 1246 28-Oct-2011 1153 87983 28-Oct-2011 1153         26436                                   2052 B 108500 S 1247 02-Oct-2012 1151 5072138 28-Oct-2011 1153         26437                                   2052 B 108600 S 1248 28-Oct-2011 1153 87983 28-Oct-2011 1153         26438                                   2052 B 109000 S 1249 28-Oct-2011 1153 87983 28-Oct-2011 1153         26439                                   2052 B 230000 S 1250 28-Oct-2011 1153 87983 28-Oct-2011 1153         26440                                   2052 B 250000 S 1580 10-Feb-2012 1153 164042 10-Feb-2012 1153         39305                                   2052 B 984000 S 1263 01-Oct-2012 1152 5023959 28-Oct-2011 1153 01-Dec-2008       26407                                   2052 B 984121 S 1465 30-Jan-2012 1151 155858 30-Jan-2012 1151         36339

    48 rows 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 26417 9179 100900 USFGMD US Motorola Solutions USFGMD, Inc. 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 26432 9207 106700 MESHNET US MeshNetworks, Inc. 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 26435 9211 108100 FUNDING US Motorola Funding Corporation 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 26415 9175 100146 COVIGO US Covigo, Inc. 1 Y     US           US04                             1151 19-Oct-2011 83392 21-Oct-2011 1153 3                                                 26428 9199 106149 SYMBOL FSC US Symbol FSC, Inc. 1 Y     US           VI01                             1151 19-Oct-2011 83392 21-Oct-2011 1153 3                                                 36294 12711283 100121 NSN Nokia Siemens Networks US LLC 1 Y     US                                         1151 30-Jan-2012 155858 30-Jan-2012 1151 1                                                 39300 12713278 101300 US MOTOROLA DESIGNER SEMI IP 1 Y     US                                         1153 03-Feb-2012 159604 03-Feb-2012 1153 1                                                 39305 12713288 250000 CTX CTX 1 Y     US                                         1153 03-Feb-2012 159604 03-Feb-2012 1153 1                                                 23351 4050 100140 SYMBOL US Symbol Technologies, Inc. 1 Y     US           US01, US05, US50, US96                             1151 09-Sep-2011 83392 21-Oct-2011 1151 3                                                 26412 9169 100141 TELXON Telxon Corporation 1 Y     US           US02                             1151 19-Oct-2011 83392 21-Oct-2011 1153 3                                                 26416 9177 100148 AIRDEFENSE US AirDefense, Inc. 1 Y     US           AD01                             1151 19-Oct-2011 83392 21-Oct-2011 1153 3                                                 26419 9183 104700 IRIDIUM US Iridium U.S., L.P. 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 26425 9193 106143 SYMBOL INT US Symbol Technologies International, Inc. (DE) 1 Y     US           ST01                             1151 19-Oct-2011 83392 21-Oct-2011 1153 3                                                 26439 9219 109000 SCAI US Software Corporation of America, Inc. 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 35289 12711221 107600 GOOD GOOD SOFTWARE 1 Y     US                                         1151 18-Jan-2012 146662 18-Jan-2012 1151 1                                                 41291 12715261 101700 US Winphoria Networks Holdings, Inc. 1 Y     US                                         1153 15-Feb-2012 164973 15-Feb-2012 1153 1                                                 23338 4047 100000 MSI US Motorola Solutions, Inc. 1 Y     US                                         1151 31-Aug-2011 83392 21-Oct-2011 1153 7                                                 24283 5046 100145 IDC US Symbol Technologies, Inc., IDC Branch 10074 Y     GB           IDC1                             1151 23-Sep-2011 83392 21-Oct-2011 1151 3                                                 26407 9157 984000 BAHRAIN US Motorola Solutions, Inc., Bahrain Branch 10022 Y                                               1153 17-Oct-2011 81414 17-Oct-2011 1153 1                                                 26413 9171 100142 METANETICS US Metanetics Corporation 1 Y     US           US03                             1151 19-Oct-2011 83392 21-Oct-2011 1153 3                                                 26430 9203 106500 WVCI US Wireless Valley Communications, Inc. 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 26446 9231 107200 NEXNET US NextNet Wireless, Inc. 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 35288 12711219 106000 PRINTRAK PRINTRAK 1 Y     US                                         1151 18-Jan-2012 146662 18-Jan-2012 1151 1                                                 36339 12711373 984121 NSN Nokia Siemens Networks US LLC 984121 1 Y     US                                         1151 30-Jan-2012 155858 30-Jan-2012 1151 1                                                 39302 12713282 106300 FORCE US- FORCE COMPUTERS 1 Y     US                                         1153 03-Feb-2012 159604 03-Feb-2012 1153 1                                                 26418 9181 103000 MCI US Motorola Card, Inc. 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 26438 9217 108600 MEXICO HOLDINGS US Motorola Solutions Mexico Holdings, Inc. 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 26445 9227 101900 US Winphoria Networks Holdings, Inc. 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 36292 12711274 100044 CAMBIUM Cambium Networks Inc. 100044 10074 Y     GB                                         1151 30-Jan-2012 155858 30-Jan-2012 1151 1                                                 39299 12713276 100149 RHOMOBILE Rhomobile, Inc 1 Y     US                                         1153 03-Feb-2012 159604 03-Feb-2012 1153 1                                                 26426 9195 106144 TELXON SVC US Telxon System Services, Inc. 1 Y     US           TS01                             1151 19-Oct-2011 83392 21-Oct-2011 1153 3                                                 26437 9215 108500 VERTEX US Vertex Standard USA, Inc. 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 24284 5049 100001 US Motorola Solutions, Inc. Buy/Sell Operation 1 Y     US                                         1151 23-Sep-2011 69499 23-Sep-2011 1151 1                                                 26422 9187 106100 NETWORK VENTURE US Network Ventures I, Inc. 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 26423 9189 106140 POS US @pos.com, Inc. 1 Y     US           US97                             1151 19-Oct-2011 83392 21-Oct-2011 1153 3                                                 26424 9191 106141 RTG US The Retail Technology Group, Inc. 1 Y     US           RT01                             1151 19-Oct-2011 83392 21-Oct-2011 1153 3                                                 26436 9213 108210 RECV CORP US Motorola Solutions Receivables Company LLC 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 39303 12713284 106400 ORTHOGON MOTOROLA US ORTHOGON 1 Y     US                                         1153 03-Feb-2012 159604 03-Feb-2012 1153 1                                                 39304 12713286 107000 MFSC MFSC 1 Y     US                                         1153 03-Feb-2012 159604 03-Feb-2012 1153 1                                                 41292 12715263 108200 US Motorola Receivables Corporation 1 Y     US                                         1153 15-Feb-2012 164973 15-Feb-2012 1153 1                                                 26414 9173 100144 RTG US RTG Holdings, Inc. 1 Y     US           RTT1                             1151 19-Oct-2011 83392 21-Oct-2011 1153 3                                                 26421 9185 105000 INVISIX Invisix, Inc. 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 26427 9197 106147 SYMBOL FIN US Symbol Technologies Finance, Inc. 1 Y     US           UST2                             1151 19-Oct-2011 83392 21-Oct-2011 1153 3                                                 26429 9201 106200 BERMUDA US Bermuda Holdings 2005, Inc. 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 26431 9205 106600 CRISNET US CRISNet, Inc. 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 26434 9209 108000 MSCC US Motorola Solutions Credit Company LLC 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 26440 9221 230000 MSICLLC US Motorola Solutions International Capital LLC 1 Y     US                                         1153 19-Oct-2011 82255 19-Oct-2011 1153 1                                                 39301 12713280 106145 SONSHIRE SONSHIRE INDUSTRIES, INC 1 Y     US                                         1153 03-Feb-2012 159604 03-Feb-2012 1153 1

    48 rows 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 04-Oct-2011 1112 14-May-2000 1 0 12.0.0 I C APPS_TS_TX_DATA APPS_TS_TX_IDX TEMP 100 1 I R12.AP.B.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-Jul-2011 1 14-May-2000 1 0 Default product group 12.1.3 Standard   Y N N groa071 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 14001380 5 BEST EVER INDUSTRIES LIMI 12-Mar-2013 2706.55   STANDARD USD USD 23351 102

  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 AMOUNT SUMMARY_TAX_LINE_ID DEFERRED_ACCTG_FLAG ORG_ID 1 ITEM HEADER MATCH 12-Mar-2013 MAR-13 2849   N 102

  1 row 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 MATCH_STATUS_FLAG ENCUMBERED_FLAG HISTORICAL_FLAG DIST_CODE_ COMBINATION_ID ACCOUNTING_EVENT_ID BC_EVENT_ID INVOICE_ DISTRIBUTION_ID PARENT_REVERSAL_ID PO_DISTRIBUTION_ID SUMMARY_TAX_LINE_ID DETAIL_TAX_DIST_ID ORG_ID 14001380 1 1 ACCRUAL 12-Mar-2013 MAR-13 2849 2849 N T N   2601 7925190   4611210   94532     102

    1 row 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 2706.55 86003 11-May-2013 2706.55 N 14001380 1 N 102

    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 13-Mar-2013 QTY REC Quantity billed exceeds q 14001380 MATCHED Passed matching condition R 102 5 13-Mar-2013 LINE VARIANCE Total of Invoice Lines do 14001380     S 102

    2 rows 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
  
  

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 86003 1 12-Mar-2013 12-Mar-2013 26204             7594880 12-Mar-2013 26204                                       STANDARD       102

  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 PAY_AWT_GROUP_ID ORIGINAL_INVOICE_ AMOUNT DISPUTE_REASON REMIT_TO_SUPPLIER_ NAME REMIT_TO_SUPPLIER_ID REMIT_TO_SUPPLIER_ SITE REMIT_TO_SUPPLIER_ SITE_ID RELATIONSHIP_ID Accts Pay Account 14001380 13-Mar-2013 26204 72951 5 2052 USD USD 1 2706.55 185899     12-Mar-2013 Manual Invoice Entry STANDARD   86003 2706.55   10021 12-Mar-2013   STANDARD 3027 N 13-Mar-2013 26204     7614398 N           2706.55                                                 STANDARD                                                     102                                                 12-Mar-2013 2706.55         12-Mar-2013         Y 0 REQUIRED       N                             US             23351   N                   CHECK           14419770 16481741                 Y N                 100140-310001-00000-00-0000-000000-000-000000-000000

    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 AIL_INVOICE_ID AIL_DISTRIBUTION_ LINE_NUMBER AIL_INVOICE_ID2 AIL_DISTRIBUTION_ LINE_NUMBER2 AIL_INVOICE_ID3 AIL_DISTRIBUTION_ LINE_NUMBER3 AIL_INVOICE_ID4 PAY_AWT_GROUP_ID 14001380 1 ITEM   IMGR:PICO,WVGA,2D FOCUS,CLASS 2 HEADER MATCH 102   65027 IMGR:PICO,WVGA,2D FOCUS,CLASS 2         D ITEM_TO_PO             N 12-Mar-2013 MAR-13 N         2052 2849     100 EACH 28.49 REQUIRED   N       N                 122008 59038   94527 94532   N N US_USD_CORP         12-Mar-2013                                                               13-Mar-2013 26204 26204 13-Mar-2013 7614398                                                                                                                         Y 221 GOODS                             VENDCHRGDRATECODE

    1 row 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 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 INVOICE_LINE_NUMBER 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 PAY_AWT_GROUP_ID Accts Pay Account Dist Account 12-Mar-2013 N U Y N 1 2601 14001380 26204 13-Mar-2013 ACCRUAL MAR-13 2052   2849 2849   86003 26204 13-Mar-2013 IMGR:PICO,WVGA,2D FOCUS,CLASS 2   N     -1 T N 94532 200 20821 13-Mar-2013 100   11688841 N   28.49     N                                                               E 100                                           102                                                                                                                             ITEM_TO_PO   4611210                       EACH   7925190       N               N 1           US_USD_CORP   PERMANENT                                                     2849 2849               N                           100140-310012-00000-00-0000-000000-000-000000-000000

    1 row 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

    0 rows retrieved
  
  
• See SQL
  
  

  ZX_LINES_SUMMARY

  SUMMARY_TAX_LINE_ID INTERNAL_ ORGANIZATION_ID APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE TRX_ID TRX_NUMBER APPLIED_FROM_ APPLICATION_ID APPLIED_FROM_EVENT_ CLASS_CODE APPLIED_FROM_ENTITY_ CODE APPLIED_FROM_TRX_ID ADJUSTED_DOC_ APPLICATION_ID ADJUSTED_DOC_ENTITY_ CODE ADJUSTED_DOC_EVENT_ CLASS_CODE ADJUSTED_DOC_TRX_ID SUMMARY_TAX_LINE_ NUMBER CONTENT_OWNER_ID TAX_REGIME_CODE TAX TAX_STATUS_CODE TAX_RATE_ID TAX_RATE_CODE TAX_RATE TAX_AMT TAX_AMT_TAX_CURR TAX_AMT_FUNCL_CURR TAX_JURISDICTION_ CODE TOTAL_REC_TAX_AMT TOTAL_REC_TAX_AMT_ FUNCL_CURR TOTAL_NREC_TAX_AMT TOTAL_NREC_TAX_AMT_ FUNCL_CURR LEDGER_ID LEGAL_ENTITY_ID ESTABLISHMENT_ID CURRENCY_CONVERSION_ DATE CURRENCY_CONVERSION_ TYPE CURRENCY_CONVERSION_ RATE SUMMARIZATION_ TEMPLATE_ID TAXABLE_BASIS_ FORMULA TAX_CALCULATION_ FORMULA HISTORICAL_FLAG CANCEL_FLAG DELETE_FLAG TAX_AMT_INCLUDED_ FLAG COMPOUNDING_TAX_FLAG SELF_ASSESSED_FLAG OVERRIDDEN_FLAG REPORTING_ONLY_FLAG ASSOCIATED_CHILD_ FROZEN_FLAG COPIED_FROM_OTHER_ DOC_FLAG MANUALLY_ENTERED_ FLAG LAST_MANUAL_ENTRY RECORD_TYPE_CODE TAX_PROVIDER_ID TAX_ONLY_LINE_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 APPLIED_FROM_LINE_ID APP_FROM_LIN_TRX_ USER_KEY1 APP_FROM_LIN_TRX_ USER_KEY2 APP_FROM_LIN_TRX_ USER_KEY3 APP_FROM_LIN_TRX_ USER_KEY4 APP_FROM_LIN_TRX_ USER_KEY5 APP_FROM_LIN_TRX_ USER_KEY6 ADJ_DOC_HDR_TRX_ USER_KEY1 ADJ_DOC_HDR_TRX_ USER_KEY2 ADJ_DOC_HDR_TRX_ USER_KEY3 ADJ_DOC_HDR_TRX_ USER_KEY4 ADJ_DOC_HDR_TRX_ USER_KEY5 ADJ_DOC_HDR_TRX_ USER_KEY6 APPLIED_TO_ APPLICATION_ID APPLIED_TO_EVENT_ CLASS_CODE APPLIED_TO_ENTITY_ CODE APPLIED_TO_TRX_ID APP_TO_HDR_TRX_USER_ KEY1 APP_TO_HDR_TRX_USER_ KEY2 APP_TO_HDR_TRX_USER_ KEY3 APP_TO_HDR_TRX_USER_ KEY4 APP_TO_HDR_TRX_USER_ KEY5 APP_TO_HDR_TRX_USER_ KEY6 APPLIED_TO_LINE_ID APP_TO_LIN_TRX_USER_ KEY1 APP_TO_LIN_TRX_USER_ KEY2 APP_TO_LIN_TRX_USER_ KEY3 APP_TO_LIN_TRX_USER_ KEY4 APP_TO_LIN_TRX_USER_ KEY5 APP_TO_LIN_TRX_USER_ KEY6 TAX_EXEMPTION_ID TAX_RATE_BEFORE_ EXEMPTION TAX_RATE_NAME_ BEFORE_EXEMPTION EXEMPT_RATE_MODIFIER EXEMPT_CERTIFICATE_ NUMBER EXEMPT_REASON EXEMPT_REASON_CODE TAX_RATE_BEFORE_ EXCEPTION TAX_RATE_NAME_ BEFORE_EXCEPTION TAX_EXCEPTION_ID EXCEPTION_RATE TOTAL_REC_TAX_AMT_ TAX_CURR TOTAL_NREC_TAX_AMT_ TAX_CURR MRC_TAX_LINE_FLAG 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 APPLIED_FROM_TRX_ LEVEL_TYPE ADJUSTED_DOC_TRX_ LEVEL_TYPE APPLIED_TO_TRX_ LEVEL_TYPE TRX_LEVEL_TYPE ADJUST_TAX_AMT_FLAG OBJECT_VERSION_ NUMBER

    0 rows retrieved
  
  
• See SQL
  
  

  ZX_REC_NREC_DIST

  REC_NREC_TAX_DIST_ID APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE EVENT_TYPE_CODE TAX_EVENT_CLASS_CODE TAX_EVENT_TYPE_CODE TRX_ID TRX_LINE_ID TRX_LINE_NUMBER TAX_LINE_ID TAX_LINE_NUMBER TRX_LINE_DIST_ID ITEM_DIST_NUMBER CONTENT_OWNER_ID REC_NREC_TAX_DIST_ NUMBER TAX_REGIME_ID TAX_REGIME_CODE TAX_ID TAX TAX_STATUS_ID TAX_STATUS_CODE TAX_RATE_ID TAX_RATE_CODE TAX_RATE INCLUSIVE_FLAG RECOVERY_TYPE_ID RECOVERY_TYPE_CODE RECOVERY_RATE_ID RECOVERY_RATE_CODE REC_NREC_RATE REC_TYPE_RULE_FLAG NEW_REC_RATE_CODE_ FLAG RECOVERABLE_FLAG REVERSE_FLAG HISTORICAL_FLAG REVERSED_TAX_DIST_ID REC_NREC_TAX_AMT REC_NREC_TAX_AMT_ TAX_CURR REC_NREC_TAX_AMT_ FUNCL_CURR INTENDED_USE PROJECT_ID TASK_ID AWARD_ID EXPENDITURE_TYPE EXPENDITURE_ ORGANIZATION_ID EXPENDITURE_ITEM_ DATE REC_RATE_DET_RULE_ FLAG LEDGER_ID SUMMARY_TAX_LINE_ID RECORD_TYPE_CODE CURRENCY_CONVERSION_ DATE CURRENCY_CONVERSION_ TYPE CURRENCY_CONVERSION_ RATE TAX_CURRENCY_ CONVERSION_DATE TAX_CURRENCY_ CONVERSION_TYPE TAX_CURRENCY_ CONVERSION_RATE TRX_CURRENCY_CODE TAX_CURRENCY_CODE TRX_LINE_DIST_AMT TRX_LINE_DIST_TAX_ AMT ORIG_REC_NREC_RATE ORIG_REC_RATE_CODE ORIG_REC_NREC_TAX_ AMT ORIG_REC_NREC_TAX_ AMT_TAX_CURR UNROUNDED_REC_NREC_ TAX_AMT APPLICABILITY_ RESULT_ID REC_RATE_RESULT_ID BACKWARD_ COMPATIBILITY_FLAG OVERRIDDEN_FLAG SELF_ASSESSED_FLAG FREEZE_FLAG POSTING_FLAG 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 GL_DATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE REF_DOC_APPLICATION_ ID REF_DOC_ENTITY_CODE REF_DOC_EVENT_CLASS_ CODE REF_DOC_TRX_ID REF_DOC_LINE_ID REF_DOC_DIST_ID MINIMUM_ACCOUNTABLE_ UNIT PRECISION ROUNDING_RULE_CODE TAXABLE_AMT TAXABLE_AMT_TAX_CURR TAXABLE_AMT_FUNCL_ CURR TAX_ONLY_LINE_FLAG UNROUNDED_TAXABLE_ AMT LEGAL_ENTITY_ID ACCOUNT_CCID ACCOUNT_STRING PRD_TAX_AMT PRD_TAX_AMT_TAX_CURR PRD_TAX_AMT_FUNCL_ CURR PRD_TOTAL_TAX_AMT PRD_TOTAL_TAX_AMT_ TAX_CURR PRD_TOTAL_TAX_AMT_ FUNCL_CURR APPLIED_FROM_TAX_ DIST_ID ADJUSTED_DOC_TAX_ DIST_ID FUNC_CURR_ROUNDING_ ADJUSTMENT GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 LAST_MANUAL_ENTRY TAX_APPORTIONMENT_ LINE_NUMBER REF_DOC_TAX_DIST_ID MRC_TAX_DIST_FLAG MRC_LINK_TO_TAX_ DIST_ID TAX_APPORTIONMENT_ FLAG RATE_TAX_FACTOR REF_DOC_PER_UNIT_ NREC_TAX_AMT PER_UNIT_NREC_TAX_ AMT TRX_LINE_DIST_QTY REF_DOC_TRX_LINE_ DIST_QTY PRICE_DIFF QTY_DIFF PER_TRX_CURR_UNIT_ NR_AMT REF_PER_TRX_CURR_ UNIT_NR_AMT REF_DOC_CURR_CONV_ RATE UNIT_PRICE REF_DOC_UNIT_PRICE APPLIED_TO_DOC_CURR_ CONV_RATE TRX_NUMBER TRX_LEVEL_TYPE REF_DOC_TRX_LEVEL_ TYPE OBJECT_VERSION_ NUMBER ORIG_AP_CHRG_DIST_ NUM ORIG_AP_CHRG_DIST_ID ORIG_AP_TAX_DIST_NUM ORIG_AP_TAX_DIST_ID INTERNAL_ ORGANIZATION_ID TAX_JURISDICTION_ID DEF_REC_SETTLEMENT_ OPTION_CODE ACCOUNT_SOURCE_TAX_ RATE_ID ORIG_GL_DATE

    0 rows retrieved
  
  
• See SQL
  
  

  ZX_LINES_DET_FACTORS

  INTERNAL_ ORGANIZATION_ID APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE EVENT_CLASS_MAPPING_ ID EVENT_TYPE_CODE DOC_EVENT_STATUS LINE_LEVEL_ACTION TRX_ID TRX_LINE_ID TRX_LEVEL_TYPE HDR_TRX_USER_KEY1 HDR_TRX_USER_KEY2 HDR_TRX_USER_KEY3 HDR_TRX_USER_KEY4 HDR_TRX_USER_KEY5 HDR_TRX_USER_KEY6 LINE_TRX_USER_KEY1 LINE_TRX_USER_KEY2 LINE_TRX_USER_KEY3 LINE_TRX_USER_KEY4 LINE_TRX_USER_KEY5 LINE_TRX_USER_KEY6 TRX_DATE TRX_DOC_REVISION LEDGER_ID TRX_CURRENCY_CODE CURRENCY_CONVERSION_ DATE CURRENCY_CONVERSION_ RATE CURRENCY_CONVERSION_ TYPE MINIMUM_ACCOUNTABLE_ UNIT PRECISION LEGAL_ENTITY_ID ESTABLISHMENT_ID RECEIVABLES_TRX_ TYPE_ID DEFAULT_TAXATION_ COUNTRY TRX_NUMBER TRX_LINE_NUMBER TRX_LINE_DESCRIPTION TRX_DESCRIPTION TRX_COMMUNICATED_ DATE BATCH_SOURCE_ID BATCH_SOURCE_NAME DOC_SEQ_ID DOC_SEQ_NAME DOC_SEQ_VALUE TRX_DUE_DATE TRX_TYPE_DESCRIPTION DOCUMENT_SUB_TYPE SUPPLIER_TAX_ INVOICE_NUMBER SUPPLIER_TAX_ INVOICE_DATE SUPPLIER_EXCHANGE_ RATE TAX_INVOICE_DATE TAX_INVOICE_NUMBER FIRST_PTY_ORG_ID TAX_EVENT_CLASS_CODE TAX_EVENT_TYPE_CODE RDNG_SHIP_TO_PTY_TX_ PROF_ID RDNG_SHIP_FROM_PTY_ TX_PROF_ID RDNG_BILL_TO_PTY_TX_ PROF_ID RDNG_BILL_FROM_PTY_ TX_PROF_ID RDNG_SHIP_TO_PTY_TX_ P_ST_ID RDNG_SHIP_FROM_PTY_ TX_P_ST_ID RDNG_BILL_TO_PTY_TX_ P_ST_ID RDNG_BILL_FROM_PTY_ TX_P_ST_ID LINE_INTENDED_USE TRX_LINE_TYPE TRX_SHIPPING_DATE TRX_RECEIPT_DATE TRX_SIC_CODE FOB_POINT TRX_WAYBILL_NUMBER PRODUCT_ID PRODUCT_FISC_ CLASSIFICATION PRODUCT_ORG_ID UOM_CODE PRODUCT_TYPE PRODUCT_CODE PRODUCT_CATEGORY PRODUCT_DESCRIPTION USER_DEFINED_FISC_ CLASS LINE_AMT TRX_LINE_QUANTITY CASH_DISCOUNT VOLUME_DISCOUNT TRADING_DISCOUNT TRANSFER_CHARGE TRANSPORTATION_ CHARGE INSURANCE_CHARGE OTHER_CHARGE ASSESSABLE_VALUE ASSET_FLAG ASSET_NUMBER ASSET_ACCUM_ DEPRECIATION ASSET_TYPE ASSET_COST RELATED_DOC_ APPLICATION_ID RELATED_DOC_ENTITY_ CODE RELATED_DOC_EVENT_ CLASS_CODE RELATED_DOC_TRX_ID REL_DOC_HDR_TRX_ USER_KEY1 REL_DOC_HDR_TRX_ USER_KEY2 REL_DOC_HDR_TRX_ USER_KEY3 REL_DOC_HDR_TRX_ USER_KEY4 REL_DOC_HDR_TRX_ USER_KEY5 REL_DOC_HDR_TRX_ USER_KEY6 RELATED_DOC_NUMBER RELATED_DOC_DATE APPLIED_FROM_ APPLICATION_ID APPLIED_FROM_ENTITY_ CODE APPLIED_FROM_EVENT_ CLASS_CODE APPLIED_FROM_TRX_ID APP_FROM_HDR_TRX_ USER_KEY1 APP_FROM_HDR_TRX_ USER_KEY2 APP_FROM_HDR_TRX_ USER_KEY3 APP_FROM_HDR_TRX_ USER_KEY4 APP_FROM_HDR_TRX_ USER_KEY5 APP_FROM_HDR_TRX_ USER_KEY6 APPLIED_FROM_LINE_ID APP_FROM_LIN_TRX_ USER_KEY1 APP_FROM_LIN_TRX_ USER_KEY2 APP_FROM_LIN_TRX_ USER_KEY3 APP_FROM_LIN_TRX_ USER_KEY4 APP_FROM_LIN_TRX_ USER_KEY5 APP_FROM_LIN_TRX_ USER_KEY6 ADJUSTED_DOC_ APPLICATION_ID ADJUSTED_DOC_ENTITY_ CODE ADJUSTED_DOC_EVENT_ CLASS_CODE ADJUSTED_DOC_TRX_ID ADJ_DOC_HDR_TRX_ USER_KEY1 ADJ_DOC_HDR_TRX_ USER_KEY2 ADJ_DOC_HDR_TRX_ USER_KEY3 ADJ_DOC_HDR_TRX_ USER_KEY4 ADJ_DOC_HDR_TRX_ USER_KEY5 ADJ_DOC_HDR_TRX_ USER_KEY6 ADJUSTED_DOC_LINE_ID ADJ_DOC_LIN_TRX_ USER_KEY1 ADJ_DOC_LIN_TRX_ USER_KEY2 ADJ_DOC_LIN_TRX_ USER_KEY3 ADJ_DOC_LIN_TRX_ USER_KEY4 ADJ_DOC_LIN_TRX_ USER_KEY5 ADJ_DOC_LIN_TRX_ USER_KEY6 ADJUSTED_DOC_NUMBER ADJUSTED_DOC_DATE APPLIED_TO_ APPLICATION_ID APPLIED_TO_ENTITY_ CODE APPLIED_TO_EVENT_ CLASS_CODE APPLIED_TO_TRX_ID APP_TO_HDR_TRX_USER_ KEY1 APP_TO_HDR_TRX_USER_ KEY2 APP_TO_HDR_TRX_USER_ KEY3 APP_TO_HDR_TRX_USER_ KEY4 APP_TO_HDR_TRX_USER_ KEY5 APP_TO_HDR_TRX_USER_ KEY6 APPLIED_TO_TRX_LINE_ ID APP_TO_LIN_TRX_USER_ KEY1 APP_TO_LIN_TRX_USER_ KEY2 APP_TO_LIN_TRX_USER_ KEY3 APP_TO_LIN_TRX_USER_ KEY4 APP_TO_LIN_TRX_USER_ KEY5 APP_TO_LIN_TRX_USER_ KEY6 TRX_BUSINESS_ CATEGORY EXEMPT_CERTIFICATE_ NUMBER EXEMPT_REASON HISTORICAL_FLAG TRX_LINE_GL_DATE LINE_AMT_INCLUDES_ TAX_FLAG ACCOUNT_CCID ACCOUNT_STRING MERCHANT_PARTY_TAX_ PROF_ID HQ_ESTB_PARTY_TAX_ PROF_ID 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 MERCHANT_PARTY_NAME MERCHANT_PARTY_ DOCUMENT_NUMBER MERCHANT_PARTY_ REFERENCE MERCHANT_PARTY_ TAXPAYER_ID MERCHANT_PARTY_TAX_ REG_NUMBER MERCHANT_PARTY_ID MERCHANT_PARTY_ COUNTRY SHIP_TO_LOCATION_ID SHIP_FROM_LOCATION_ ID POA_LOCATION_ID POO_LOCATION_ID BILL_TO_LOCATION_ID BILL_FROM_LOCATION_ ID PAYING_LOCATION_ID OWN_HQ_LOCATION_ID TRADING_HQ_LOCATION_ ID POC_LOCATION_ID POI_LOCATION_ID POD_LOCATION_ID TITLE_TRANSFER_ LOCATION_ID SHIP_TO_PARTY_TAX_ PROF_ID SHIP_FROM_PARTY_TAX_ PROF_ID POA_PARTY_TAX_PROF_ ID POO_PARTY_TAX_PROF_ ID PAYING_PARTY_TAX_ PROF_ID OWN_HQ_PARTY_TAX_ PROF_ID TRADING_HQ_PARTY_ TAX_PROF_ID POI_PARTY_TAX_PROF_ ID POD_PARTY_TAX_PROF_ ID BILL_TO_PARTY_TAX_ PROF_ID BILL_FROM_PARTY_TAX_ PROF_ID TITLE_TRANS_PARTY_ TAX_PROF_ID SHIP_TO_SITE_TAX_ PROF_ID SHIP_FROM_SITE_TAX_ PROF_ID POA_SITE_TAX_PROF_ID POO_SITE_TAX_PROF_ID PAYING_SITE_TAX_ PROF_ID OWN_HQ_SITE_TAX_ PROF_ID TRADING_HQ_SITE_TAX_ PROF_ID POI_SITE_TAX_PROF_ID POD_SITE_TAX_PROF_ID BILL_TO_SITE_TAX_ PROF_ID BILL_FROM_SITE_TAX_ PROF_ID TITLE_TRANS_SITE_ TAX_PROF_ID CTRL_HDR_TX_APPL_ FLAG CTRL_TOTAL_LINE_TX_ AMT CTRL_TOTAL_HDR_TX_ AMT REF_DOC_APPLICATION_ ID REF_DOC_ENTITY_CODE REF_DOC_EVENT_CLASS_ CODE REF_DOC_TRX_ID REF_DOC_HDR_TRX_ USER_KEY1 REF_DOC_HDR_TRX_ USER_KEY2 REF_DOC_HDR_TRX_ USER_KEY3 REF_DOC_HDR_TRX_ USER_KEY4 REF_DOC_HDR_TRX_ USER_KEY5 REF_DOC_HDR_TRX_ USER_KEY6 REF_DOC_LINE_ID REF_DOC_LIN_TRX_ USER_KEY1 REF_DOC_LIN_TRX_ USER_KEY2 REF_DOC_LIN_TRX_ USER_KEY3 REF_DOC_LIN_TRX_ USER_KEY4 REF_DOC_LIN_TRX_ USER_KEY5 REF_DOC_LIN_TRX_ USER_KEY6 REF_DOC_LINE_ QUANTITY LINE_CLASS TRX_LINE_DATE INPUT_TAX_ CLASSIFICATION_CODE OUTPUT_TAX_ CLASSIFICATION_CODE INTERNAL_ORG_ LOCATION_ID CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PORT_OF_ENTRY_CODE TAX_REPORTING_FLAG TAX_AMT_INCLUDED_ FLAG COMPOUNDING_TAX_FLAG TRX_ID_LEVEL5 TRX_ID_LEVEL2 TRX_ID_LEVEL3 TRX_ID_LEVEL4 EVENT_ID THRESHOLD_INDICATOR_ FLAG PROVNL_TAX_ DETERMINATION_DATE UNIT_PRICE SHIP_TO_CUST_ACCT_ SITE_USE_ID BILL_TO_CUST_ACCT_ SITE_USE_ID TRX_BATCH_ID APPLIED_TO_TRX_ NUMBER START_EXPENSE_DATE SOURCE_APPLICATION_ ID SOURCE_ENTITY_CODE SOURCE_EVENT_CLASS_ CODE SOURCE_TRX_ID SOURCE_LINE_ID SOURCE_TRX_LEVEL_ TYPE RECORD_TYPE_CODE REF_DOC_TRX_LEVEL_ TYPE APPLIED_TO_TRX_ LEVEL_TYPE APPLIED_FROM_TRX_ LEVEL_TYPE ADJUSTED_DOC_TRX_ LEVEL_TYPE INCLUSIVE_TAX_ OVERRIDE_FLAG TAX_PROCESSING_ COMPLETED_FLAG OBJECT_VERSION_ NUMBER APPLICATION_DOC_ STATUS USER_UPD_DET_ FACTORS_FLAG SOURCE_TAX_LINE_ID REVERSED_APPLN_ID REVERSED_ENTITY_CODE REVERSED_EVNT_CLS_ CODE REVERSED_TRX_ID REVERSED_TRX_LEVEL_ TYPE REVERSED_TRX_LINE_ID TAX_CALCULATION_ DONE_FLAG APPLIED_FROM_TRX_ NUMBER PARTNER_MIGRATED_ FLAG SHIP_THIRD_PTY_ACCT_ SITE_ID BILL_THIRD_PTY_ACCT_ SITE_ID SHIP_THIRD_PTY_ACCT_ ID BILL_THIRD_PTY_ACCT_ ID EXEMPTION_CONTROL_ FLAG EXEMPT_REASON_CODE INTERFACE_ENTITY_ CODE INTERFACE_LINE_ID DEFAULTING_ ATTRIBUTE1 DEFAULTING_ ATTRIBUTE2 DEFAULTING_ ATTRIBUTE3 DEFAULTING_ ATTRIBUTE4 DEFAULTING_ ATTRIBUTE5 DEFAULTING_ ATTRIBUTE6 DEFAULTING_ ATTRIBUTE7 DEFAULTING_ ATTRIBUTE8 DEFAULTING_ ATTRIBUTE9 DEFAULTING_ ATTRIBUTE10 TRX_ID_LEVEL6 HISTORICAL_TAX_CODE_ ID ICX_SESSION_ID TRX_LINE_CURRENCY_ CODE TRX_LINE_CURRENCY_ CONV_RATE TRX_LINE_CURRENCY_ CONV_DATE TRX_LINE_PRECISION TRX_LINE_MAU TRX_LINE_CURRENCY_ CONV_TYPE GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE_ CATEGORY TOTAL_INC_TAX_AMT 102 200 AP_INVOICES STANDARD INVOICES 1 STANDARD DISTRIBUTE VALIDATED UPDATE 14001380 1 LINE                         12-Mar-2013   2052 USD       0.01 2 23351 1453924   US 5 1 IMGR:PICO,WVGA,2D FOCUS,CLASS 2                               811744 PURCHASE_TRANSACTION VALIDATE   2393572   2393572   2444009   2444009   ITEM       FCA   65027   121 EA GOODS SE-4500DL-I000R   IMGR:PICO,WVGA,2D FOCUS,CLASS 2   2849 100               2849                                                                                                                                                   N 12-Mar-2013 N 3082     810733                                                                           221 541295     164 541295                 2393572                 2393572     2444009                 2444009   N     201 PURCHASE_ORDER PO_PA 122008             94527             920 STANDARD INVOICES 12-Mar-2013 VENDCHRGDRATECODE   154 13-Mar-2013 26204 13-Mar-2013 26204 7614988   Y             3438757     28.49                       ETAX_CREATED SHIPMENT         Y 2                         185899 185899 72951 72951                                   USD     2 0.01       0

    1 row 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 REMIT_TO_SUPPLIER_ NAME REMIT_TO_SUPPLIER_ID REMIT_TO_SUPPLIER_ SITE REMIT_TO_SUPPLIER_ SITE_ID RELATIONSHIP_ID 14001380 26204 13-Mar-2013 1 1 2706.55 26204 13-Mar-2013   11-May-2013   2706.55 N     99 N     86003                                       0 102                                             2706.55   N   CHECK

    1 row retrieved
  
  
• See SQL
  
  

  AP_RECURRING_PAYMENTS_ALL

  RECURRING_PAYMENT_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY VENDOR_ID RECURRING_PAY_NUM VENDOR_SITE_ID REC_PAY_PERIOD_TYPE NUM_OF_PERIODS FIRST_PERIOD FIRST_PERIOD_NUM AUTHORIZED_TOTAL CONTROL_AMOUNT DISTRIBUTION_SET_ID TERMS_ID SET_OF_BOOKS_ID AMOUNT_APPLICABLE_ TO_DISCOUNT PAYMENT_METHOD_ LOOKUP_CODE REM_PERIODS ACCOUNTING_DATE RELEASED_AMOUNT BATCH_ID ACCTS_PAY_CODE_ COMBINATION_ID INVOICE_CURRENCY_ CODE PAYMENT_CURRENCY_ CODE INVOICE_BASE_RATE PAY_GROUP_LOOKUP_ CODE TAX_AMOUNT PAYMENT_INVOICE_ CROSS_RATE EXCHANGE_RATE NEXT_PERIOD NEXT_PAYMENT INCREMENT_PERCENT NUM_OF_PERIODS_REM SPECIAL_PAYMENT_ AMOUNT1 SPECIAL_PERIOD_NAME1 SPECIAL_PAYMENT_ AMOUNT2 SPECIAL_PERIOD_NAME2 DESCRIPTION PAID_FLAG1 PAID_FLAG2 HOLD_LOOKUP_CODE HOLD_REASON APPROVED_BY EXPIRY_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 EXCHANGE_RATE_TYPE PAYMENT_CROSS_RATE EXCHANGE_DATE LAST_UPDATE_LOGIN TAX_NAME EXCLUSIVE_PAYMENT_ FLAG AWT_GROUP_ID ORG_ID PO_HEADER_ID PO_LINE_ID LINE_LOCATION_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 APPROVAL_REQUIRED_ FLAG USSGL_TRANSACTION_ CODE FIRST_AMOUNT LEGAL_ENTITY_ID TAXATION_COUNTRY TAX_CONTROL_AMOUNT PRIMARY_INTENDED_USE PRODUCT_FISC_ CLASSIFICATION USER_DEFINED_FISC_ CLASS TRX_BUSINESS_ CATEGORY REQUESTER_ID ITEM_DESCRIPTION MANUFACTURER MODEL_NUMBER PO_RELEASE_ID REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE3 PAYMENT_REASON_CODE PAYMENT_METHOD_CODE BANK_CHARGE_BEARER SETTLEMENT_PRIORITY PAYMENT_REASON_ COMMENTS DELIVERY_CHANNEL_ CODE PAY_AWT_GROUP_ID REMIT_TO_SUPPLIER_ NAME REMIT_TO_SUPPLIER_ID REMIT_TO_SUPPLIER_ SITE REMIT_TO_SUPPLIER_ SITE_ID RELATIONSHIP_ID PRODUCT_TYPE PRODUCT_CATEGORY

    0 rows 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 14001380 94527 QTY REC 13-Mar-2013 5 5 13-Mar-2013 Quantity billed exceeds quantity received MATCHED Passed matching condition R   13-Mar-2013 5                                 102         87804   14001380   LINE VARIANCE 13-Mar-2013 5 5 13-Mar-2013 Total of Invoice Lines does not equal Invoice Amount     S   13-Mar-2013 5                                 102         87803

    2 rows 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 LINE VARIANCE LINE HOLD REASON Total of Invoice Lines does not equal Invoice Amount 10-Nov-2012 1 N N   N 0 26-Apr-2005 0           QTY REC MATCHING HOLD REASON Quantity billed exceeds quantity received 10-Nov-2012 1 Y Y   Y 0 19-Jan-1999 1

    2 rows 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 AAAhUpAAVAAAAD+AAM 10021 28-Oct-2011 1220 29-Sep-2011 1216 87589 Y   STD 22-Jul-1999                                     NET 60 Due in 60 Days

    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 DISCOUNT_AMOUNT DISCOUNT_CRITERIA DISCOUNT_AMOUNT_2 DISCOUNT_CRITERIA_2 DISCOUNT_AMOUNT_3 DISCOUNT_CRITERIA_3 10021 1 29-Sep-2011 1216 29-Sep-2011 1216 72683 100   60

    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

    0 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

    0 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 EXT_REMIT_PAYEE_ID REMIT_PAYEE_PARTY_ID REMIT_PARTY_SITE_ID REMIT_SUPPLIER_SITE_ ID REMIT_BENEFICIARY_ PARTY RELATIONSHIP_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
  
  

  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 REMIT_TO_SUPPLIER_ NAME REMIT_TO_SUPPLIER_ID REMIT_TO_SUPPLIER_ SITE REMIT_TO_SUPPLIER_ 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 REMIT_TO_SUPPLIER_ NAME REMIT_TO_SUPPLIER_ID REMIT_TO_SUPPLIER_ SITE REMIT_TO_SUPPLIER_ SITE_ID RELATIONSHIP_ID PAYCARD_ AUTHORIZATION_NUMBER PAYCARD_REFERENCE_ID ACKNOWLEDGED_FLAG

    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 GAIN_LOSS_INDICATOR

    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 INV_AWT_EXISTS_FLAG

    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 REMIT_TO_SUPPLIER_ NAME REMIT_TO_SUPPLIER_ID REMIT_TO_SUPPLIER_ SITE REMIT_TO_SUPPLIER_ SITE_ID

    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 EXT_INV_PAYEE_ID INV_PAYEE_PARTY_ID INV_PARTY_SITE_ID INV_SUPPLIER_SITE_ID INV_BENEFICIARY_ PARTY RELATIONSHIP_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
  
  

  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 LOGICAL_GROUP_ REFERENCE POSITIVE_PAY_FILE_ CREATED_FLAG EXT_INV_PAYEE_ID INV_PAYEE_PARTY_ID INV_PARTY_SITE_ID INV_SUPPLIER_SITE_ID INV_BENEFICIARY_ PARTY INV_PAYEE_NAME INV_PAYEE_ADDRESS1 INV_PAYEE_ADDRESS2 INV_PAYEE_ADDRESS3 INV_PAYEE_ADDRESS4 INV_PAYEE_CITY INV_PAYEE_POSTAL_ CODE INV_PAYEE_STATE INV_PAYEE_PROVINCE INV_PAYEE_COUNTY INV_PAYEE_COUNTRY INV_PAYEE_PARTY_NAME INV_PAYEE_LE_REG_NUM INV_PAYEE_TAX_REG_ NUM INV_PAYEE_ADDRESS_ CONCAT INV_BENEFICIARY_NAME INV_PAYEE_PARTY_ NUMBER INV_PAYEE_ALTERNATE_ NAME INV_PAYEE_SITE_ALT_ NAME INV_PAYEE_SUPPLIER_ NUMBER INV_PAYEE_FIRST_ PARTY_REF EXT_BNK_ACCT_OWNR_ INV_PRTY_ID EXT_BNK_BRANCH_INV_ PRTY_ID EXT_BNK_ACCT_OWNR_ INV_PRTY_NME INV_PAYEE_PARTY_ ATTR_CAT INV_PAYEE_SUPPLIER_ ATTR_CAT INV_PAYEE_SPPLR_ SITE_ATTR_CAT INV_PAYEE_SUPPLIER_ SITE_NAME INV_PAYEE_SPPLR_ SITE_ALT_NAME INV_PAYEE_SUPPLIER_ ID PAYEE_ADDRESSEE PAYEE_PARTY_SITE_ NAME INV_PAYEE_PARTY_ SITE_NAME ACKNOWLEDGED_FLAG

    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 PAYMENT_METHOD_CODE CARD_ISSUER_FILE_ SEQ_NO

    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
  
  

Withholding Tax    [Top]

AP_AWT_TAX_RATES

TAX_RATE_ID TAX_NAME TAX_RATE RATE_TYPE START_DATE END_DATE START_AMOUNT END_AMOUNT LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY VENDOR_ID VENDOR_SITE_ID INVOICE_NUM CERTIFICATE_NUMBER CERTIFICATE_TYPE COMMENTS PRIORITY ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 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

  0 rows retrieved


• See SQL
  
  

  AP_TAX_CODES_ALL

  NAME TAX_ID LAST_UPDATE_DATE LAST_UPDATED_BY TAX_TYPE SET_OF_BOOKS_ID DESCRIPTION TAX_RATE TAX_CODE_ COMBINATION_ID INACTIVE_DATE LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 AWT_VENDOR_ID AWT_VENDOR_SITE_ID AWT_PERIOD_TYPE AWT_PERIOD_LIMIT RANGE_AMOUNT_BASIS RANGE_PERIOD_BASIS ORG_ID VAT_TRANSACTION_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_ATTRIBUTE20 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 WEB_ENABLED_FLAG TAX_RECOVERY_RULE_ID TAX_RECOVERY_RATE START_DATE ENABLED_FLAG AWT_RATE_TYPE OFFSET_TAX_CODE_ID SUPPRESS_ZERO_ AMOUNT_FLAG

    0 rows retrieved
  
  
• See SQL
  
  

  AP_AWT_GROUPS

  GROUP_ID NAME DESCRIPTION INACTIVE_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY

    0 rows retrieved
  
  
• See SQL
  
  

  AP_AWT_GROUP_TAXES_ALL

  GROUP_ID TAX_NAME RANK LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY ORG_ID

    0 rows retrieved
  
  
• See SQL
  
  

  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 7925190 200 INVOICE VALIDATED 12-Mar-2013 4031433 I U                         1 N 13-Mar-2013 26204 13-Mar-2013 26204 -1 13-Mar-2013 200 20821 11688808       12-Mar-2013 N

  1 row 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 NEED_BAL_FLAG

    0 rows retrieved
  
  
• 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 Account

    0 rows retrieved
  
  
• 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

    0 rows retrieved
  
  
• See SQL
  
  

  XLA_TRANSACTION_ENTITIES (Invoice)

  ENTITY_ID APPLICATION_ID LEGAL_ENTITY_ID ENTITY_CODE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN SOURCE_ID_INT_1 SOURCE_ID_CHAR_1 SECURITY_ID_INT_1 SECURITY_ID_INT_2 SECURITY_ID_INT_3 SECURITY_ID_CHAR_1 SECURITY_ID_CHAR_2 SECURITY_ID_CHAR_3 SOURCE_ID_INT_2 SOURCE_ID_CHAR_2 SOURCE_ID_INT_3 SOURCE_ID_CHAR_3 SOURCE_ID_INT_4 SOURCE_ID_CHAR_4 TRANSACTION_NUMBER LEDGER_ID VALUATION_METHOD SOURCE_APPLICATION_ ID UPG_BATCH_ID UPG_SOURCE_ APPLICATION_ID UPG_VALID_FLAG 4031433 200 23351 AP_INVOICES 13-Mar-2013 26204 13-Mar-2013 26204 -1 14001380   102                       5 2052   200

    1 row retrieved
  
  
• See SQL
  
  

  XLA_ACCOUNTING_ERRORS (Invoice)

  EVENT_ID ACCOUNTING_ERROR_ID ENTITY_ID LEDGER_ID ACCOUNTING_BATCH_ID ENCODED_MSG AE_HEADER_ID AE_LINE_NUM MESSAGE_NUMBER ERROR_SOURCE_CODE APPLICATION_ID CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PROGRAM_UPDATE_DATE PROGRAM_APPLICATION_ ID PROGRAM_ID REQUEST_ID

    0 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 NEED_BAL_FLAG

    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 Account

    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
  
  

  XLA_TRANSACTION_ENTITIES (Payment)

  ENTITY_ID APPLICATION_ID LEGAL_ENTITY_ID ENTITY_CODE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN SOURCE_ID_INT_1 SOURCE_ID_CHAR_1 SECURITY_ID_INT_1 SECURITY_ID_INT_2 SECURITY_ID_INT_3 SECURITY_ID_CHAR_1 SECURITY_ID_CHAR_2 SECURITY_ID_CHAR_3 SOURCE_ID_INT_2 SOURCE_ID_CHAR_2 SOURCE_ID_INT_3 SOURCE_ID_CHAR_3 SOURCE_ID_INT_4 SOURCE_ID_CHAR_4 TRANSACTION_NUMBER LEDGER_ID VALUATION_METHOD SOURCE_APPLICATION_ ID UPG_BATCH_ID UPG_SOURCE_ APPLICATION_ID UPG_VALID_FLAG

    0 rows retrieved
  
  
• See SQL
  
  

  XLA_ACCOUNTING_ERRORS (Payment)

  EVENT_ID ACCOUNTING_ERROR_ID ENTITY_ID LEDGER_ID ACCOUNTING_BATCH_ID ENCODED_MSG AE_HEADER_ID AE_LINE_NUM MESSAGE_NUMBER ERROR_SOURCE_CODE APPLICATION_ID CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PROGRAM_UPDATE_DATE PROGRAM_APPLICATION_ ID PROGRAM_ID REQUEST_ID

    0 rows retrieved
  
  
• See SQL
  
  

Trial Balance    [Top]

AP_LIABILITY_BALANCE

AE_LINE_ID AE_HEADER_ID INVOICE_ID CODE_COMBINATION_ID VENDOR_ID SET_OF_BOOKS_ID ORG_ID ACCOUNTING_DATE ACCOUNTED_DR ACCOUNTED_CR AE_INVOICE_AMOUNT CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PROGRAM_UPDATE_DATE PROGRAM_APPLICATION_ ID PROGRAM_ID REQUEST_ID JOURNAL_SEQUENCE_ID SLE_HEADER_ID SLE_LINE_NUM VENDOR_SITE_ID

  0 rows retrieved


• See SQL
  
  

  XLA_TRIAL_BALANCES

  DEFINITION_CODE LEDGER_ID RECORD_TYPE_CODE SOURCE_ENTITY_ID SOURCE_APPLICATION_ ID APPLIED_TO_ENTITY_ID APPLIED_TO_ APPLICATION_ID EVENT_CLASS_CODE GL_DATE TRX_CURRENCY_CODE ENTERED_ROUNDED_DR ENTERED_ROUNDED_CR ENTERED_UNROUNDED_DR ENTERED_UNROUNDED_CR ACCTD_ROUNDED_DR ACCTD_ROUNDED_CR ACCTD_UNROUNDED_DR ACCTD_UNROUNDED_CR CODE_COMBINATION_ID BALANCING_SEGMENT_ VALUE NATURAL_ACCOUNT_ SEGMENT_VALUE COST_CENTER_SEGMENT_ VALUE INTERCOMPANY_ SEGMENT_VALUE MANAGEMENT_SEGMENT_ VALUE PARTY_ID PARTY_SITE_ID PARTY_TYPE_CODE AE_HEADER_ID GENERATED_BY_CODE SOURCE_VALUATION_ METHOD APPLIED_VALUATION_ METHOD CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE

    0 rows retrieved
  
  
• See SQL
  
  

General Ledger    [Top]

GL_JE_BATCHES (Invoice)

JE_BATCH_ID LAST_UPDATE_DATE LAST_UPDATED_BY SET_OF_BOOKS_ID_11I NAME STATUS STATUS_VERIFIED ACTUAL_FLAG DEFAULT_EFFECTIVE_ DATE AVERAGE_JOURNAL_FLAG BUDGETARY_CONTROL_ STATUS APPROVAL_STATUS_CODE CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN STATUS_RESET_FLAG DEFAULT_PERIOD_NAME UNIQUE_DATE EARLIEST_POSTABLE_ DATE POSTED_DATE DATE_CREATED DESCRIPTION CONTROL_TOTAL RUNNING_TOTAL_DR RUNNING_TOTAL_CR RUNNING_TOTAL_ ACCOUNTED_DR RUNNING_TOTAL_ ACCOUNTED_CR PARENT_JE_BATCH_ID ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 CONTEXT UNRESERVATION_ PACKET_ID PACKET_ID USSGL_TRANSACTION_ CODE CONTEXT2 POSTING_RUN_ID REQUEST_ID ORG_ID POSTED_BY CHART_OF_ACCOUNTS_ID PERIOD_SET_NAME ACCOUNTED_PERIOD_ TYPE GROUP_ID APPROVER_EMPLOYEE_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
  
  

  GL_JE_HEADERS (Invoice)

  JE_HEADER_ID LAST_UPDATE_DATE LAST_UPDATED_BY LEDGER_ID JE_CATEGORY JE_SOURCE PERIOD_NAME NAME CURRENCY_CODE STATUS DATE_CREATED ACCRUAL_REV_FLAG MULTI_BAL_SEG_FLAG ACTUAL_FLAG DEFAULT_EFFECTIVE_ DATE TAX_STATUS_CODE CONVERSION_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ENCUMBRANCE_TYPE_ID BUDGET_VERSION_ID BALANCED_JE_FLAG BALANCING_SEGMENT_ VALUE JE_BATCH_ID FROM_RECURRING_ HEADER_ID UNIQUE_DATE EARLIEST_POSTABLE_ DATE POSTED_DATE ACCRUAL_REV_ EFFECTIVE_DATE ACCRUAL_REV_PERIOD_ NAME ACCRUAL_REV_STATUS ACCRUAL_REV_JE_ HEADER_ID ACCRUAL_REV_CHANGE_ SIGN_FLAG DESCRIPTION CONTROL_TOTAL RUNNING_TOTAL_DR RUNNING_TOTAL_CR RUNNING_TOTAL_ ACCOUNTED_DR RUNNING_TOTAL_ ACCOUNTED_CR CURRENCY_CONVERSION_ RATE CURRENCY_CONVERSION_ TYPE CURRENCY_CONVERSION_ DATE EXTERNAL_REFERENCE PARENT_JE_HEADER_ID REVERSED_JE_HEADER_ ID ORIGINATING_BAL_SEG_ VALUE INTERCOMPANY_MODE DR_BAL_SEG_VALUE CR_BAL_SEG_VALUE ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 CONTEXT GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 USSGL_TRANSACTION_ CODE CONTEXT2 DOC_SEQUENCE_ID DOC_SEQUENCE_VALUE JGZZ_RECON_CONTEXT JGZZ_RECON_REF REFERENCE_DATE LOCAL_DOC_SEQUENCE_ ID LOCAL_DOC_SEQUENCE_ VALUE DISPLAY_ALC_JOURNAL_ FLAG JE_FROM_SLA_FLAG POSTING_ACCT_SEQ_ VERSION_ID POSTING_ACCT_SEQ_ ASSIGN_ID POSTING_ACCT_SEQ_ VALUE CLOSE_ACCT_SEQ_ VERSION_ID CLOSE_ACCT_SEQ_ ASSIGN_ID CLOSE_ACCT_SEQ_VALUE

    0 rows retrieved
  
  
• See SQL
  
  

  GL_JE_LINES (Invoice)

  JE_HEADER_ID JE_LINE_NUM LAST_UPDATE_DATE LAST_UPDATED_BY LEDGER_ID CODE_COMBINATION_ID PERIOD_NAME EFFECTIVE_DATE STATUS CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ENTERED_DR ENTERED_CR ACCOUNTED_DR ACCOUNTED_CR DESCRIPTION LINE_TYPE_CODE REFERENCE_1 REFERENCE_2 REFERENCE_3 REFERENCE_4 REFERENCE_5 ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 CONTEXT CONTEXT2 INVOICE_DATE TAX_CODE INVOICE_IDENTIFIER INVOICE_AMOUNT NO1 STAT_AMOUNT IGNORE_RATE_FLAG CONTEXT3 USSGL_TRANSACTION_ CODE SUBLEDGER_DOC_ SEQUENCE_ID CONTEXT4 SUBLEDGER_DOC_ SEQUENCE_VALUE REFERENCE_6 REFERENCE_7 GL_SL_LINK_ID GL_SL_LINK_TABLE REFERENCE_8 REFERENCE_9 REFERENCE_10 GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 JGZZ_RECON_STATUS_ 11I JGZZ_RECON_DATE_11I JGZZ_RECON_ID_11I JGZZ_RECON_REF_11I JGZZ_RECON_CONTEXT_ 11I TAXABLE_LINE_FLAG TAX_TYPE_CODE TAX_CODE_ID TAX_ROUNDING_RULE_ CODE AMOUNT_INCLUDES_TAX_ FLAG TAX_DOCUMENT_ IDENTIFIER TAX_DOCUMENT_DATE TAX_CUSTOMER_NAME TAX_CUSTOMER_ REFERENCE TAX_REGISTRATION_ NUMBER TAX_LINE_FLAG TAX_GROUP_ID CO_THIRD_PARTY CO_PROCESSED_FLAG

    0 rows retrieved
  
  
• See SQL
  
  

  GL_IMPORT_REFERENCES (Invoice)

  JE_BATCH_ID JE_HEADER_ID JE_LINE_NUM LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN REFERENCE_1 REFERENCE_2 REFERENCE_3 REFERENCE_4 REFERENCE_5 REFERENCE_6 REFERENCE_7 REFERENCE_8 REFERENCE_9 REFERENCE_10 SUBLEDGER_DOC_ SEQUENCE_ID SUBLEDGER_DOC_ SEQUENCE_VALUE GL_SL_LINK_ID GL_SL_LINK_TABLE

    0 rows retrieved
  
  
• See SQL
  
  

  GL_JE_BATCHES (Payment)

  JE_BATCH_ID LAST_UPDATE_DATE LAST_UPDATED_BY SET_OF_BOOKS_ID_11I NAME STATUS STATUS_VERIFIED ACTUAL_FLAG DEFAULT_EFFECTIVE_ DATE AVERAGE_JOURNAL_FLAG BUDGETARY_CONTROL_ STATUS APPROVAL_STATUS_CODE CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN STATUS_RESET_FLAG DEFAULT_PERIOD_NAME UNIQUE_DATE EARLIEST_POSTABLE_ DATE POSTED_DATE DATE_CREATED DESCRIPTION CONTROL_TOTAL RUNNING_TOTAL_DR RUNNING_TOTAL_CR RUNNING_TOTAL_ ACCOUNTED_DR RUNNING_TOTAL_ ACCOUNTED_CR PARENT_JE_BATCH_ID ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 CONTEXT UNRESERVATION_ PACKET_ID PACKET_ID USSGL_TRANSACTION_ CODE CONTEXT2 POSTING_RUN_ID REQUEST_ID ORG_ID POSTED_BY CHART_OF_ACCOUNTS_ID PERIOD_SET_NAME ACCOUNTED_PERIOD_ TYPE GROUP_ID APPROVER_EMPLOYEE_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
  
  

  GL_JE_HEADERS (Payment)

  JE_HEADER_ID LAST_UPDATE_DATE LAST_UPDATED_BY LEDGER_ID JE_CATEGORY JE_SOURCE PERIOD_NAME NAME CURRENCY_CODE STATUS DATE_CREATED ACCRUAL_REV_FLAG MULTI_BAL_SEG_FLAG ACTUAL_FLAG DEFAULT_EFFECTIVE_ DATE TAX_STATUS_CODE CONVERSION_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ENCUMBRANCE_TYPE_ID BUDGET_VERSION_ID BALANCED_JE_FLAG BALANCING_SEGMENT_ VALUE JE_BATCH_ID FROM_RECURRING_ HEADER_ID UNIQUE_DATE EARLIEST_POSTABLE_ DATE POSTED_DATE ACCRUAL_REV_ EFFECTIVE_DATE ACCRUAL_REV_PERIOD_ NAME ACCRUAL_REV_STATUS ACCRUAL_REV_JE_ HEADER_ID ACCRUAL_REV_CHANGE_ SIGN_FLAG DESCRIPTION CONTROL_TOTAL RUNNING_TOTAL_DR RUNNING_TOTAL_CR RUNNING_TOTAL_ ACCOUNTED_DR RUNNING_TOTAL_ ACCOUNTED_CR CURRENCY_CONVERSION_ RATE CURRENCY_CONVERSION_ TYPE CURRENCY_CONVERSION_ DATE EXTERNAL_REFERENCE PARENT_JE_HEADER_ID REVERSED_JE_HEADER_ ID ORIGINATING_BAL_SEG_ VALUE INTERCOMPANY_MODE DR_BAL_SEG_VALUE CR_BAL_SEG_VALUE ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 CONTEXT GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 USSGL_TRANSACTION_ CODE CONTEXT2 DOC_SEQUENCE_ID DOC_SEQUENCE_VALUE JGZZ_RECON_CONTEXT JGZZ_RECON_REF REFERENCE_DATE LOCAL_DOC_SEQUENCE_ ID LOCAL_DOC_SEQUENCE_ VALUE DISPLAY_ALC_JOURNAL_ FLAG JE_FROM_SLA_FLAG POSTING_ACCT_SEQ_ VERSION_ID POSTING_ACCT_SEQ_ ASSIGN_ID POSTING_ACCT_SEQ_ VALUE CLOSE_ACCT_SEQ_ VERSION_ID CLOSE_ACCT_SEQ_ ASSIGN_ID CLOSE_ACCT_SEQ_VALUE

    0 rows retrieved
  
  
• See SQL
  
  

  GL_JE_LINES (Payment)

  JE_HEADER_ID JE_LINE_NUM LAST_UPDATE_DATE LAST_UPDATED_BY LEDGER_ID CODE_COMBINATION_ID PERIOD_NAME EFFECTIVE_DATE STATUS CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ENTERED_DR ENTERED_CR ACCOUNTED_DR ACCOUNTED_CR DESCRIPTION LINE_TYPE_CODE REFERENCE_1 REFERENCE_2 REFERENCE_3 REFERENCE_4 REFERENCE_5 ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 CONTEXT CONTEXT2 INVOICE_DATE TAX_CODE INVOICE_IDENTIFIER INVOICE_AMOUNT NO1 STAT_AMOUNT IGNORE_RATE_FLAG CONTEXT3 USSGL_TRANSACTION_ CODE SUBLEDGER_DOC_ SEQUENCE_ID CONTEXT4 SUBLEDGER_DOC_ SEQUENCE_VALUE REFERENCE_6 REFERENCE_7 GL_SL_LINK_ID GL_SL_LINK_TABLE REFERENCE_8 REFERENCE_9 REFERENCE_10 GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 JGZZ_RECON_STATUS_ 11I JGZZ_RECON_DATE_11I JGZZ_RECON_ID_11I JGZZ_RECON_REF_11I JGZZ_RECON_CONTEXT_ 11I TAXABLE_LINE_FLAG TAX_TYPE_CODE TAX_CODE_ID TAX_ROUNDING_RULE_ CODE AMOUNT_INCLUDES_TAX_ FLAG TAX_DOCUMENT_ IDENTIFIER TAX_DOCUMENT_DATE TAX_CUSTOMER_NAME TAX_CUSTOMER_ REFERENCE TAX_REGISTRATION_ NUMBER TAX_LINE_FLAG TAX_GROUP_ID CO_THIRD_PARTY CO_PROCESSED_FLAG

    0 rows retrieved
  
  
• See SQL
  
  

  GL_IMPORT_REFERENCES (Payment)

  JE_BATCH_ID JE_HEADER_ID JE_LINE_NUM LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN REFERENCE_1 REFERENCE_2 REFERENCE_3 REFERENCE_4 REFERENCE_5 REFERENCE_6 REFERENCE_7 REFERENCE_8 REFERENCE_9 REFERENCE_10 SUBLEDGER_DOC_ SEQUENCE_ID SUBLEDGER_DOC_ SEQUENCE_VALUE GL_SL_LINK_ID GL_SL_LINK_TABLE

    0 rows retrieved
  
  
• See SQL
  
  

  GL_PERIOD_STATUSES

  APPLICATION_ID SET_OF_BOOKS_ID PERIOD_NAME LAST_UPDATE_DATE LAST_UPDATED_BY CLOSING_STATUS START_DATE END_DATE YEAR_START_DATE QUARTER_NUM QUARTER_START_DATE PERIOD_TYPE PERIOD_YEAR EFFECTIVE_PERIOD_NUM PERIOD_NUM ADJUSTMENT_PERIOD_ FLAG CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ELIMINATION_ CONFIRMED_FLAG ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 CONTEXT CHRONOLOGICAL_SEQ_ STATUS_CODE LEDGER_ID MIGRATION_STATUS_ CODE TRACK_BC_YTD_FLAG 200 2052 MAR-13 04-Mar-2013 18124 O 23-Feb-2013 30-Mar-2013 01-Jan-2013 1 01-Jan-2013 21 2013 20130003 3 N 31-Aug-2011 1153 7576520                 2052 N   101 2052 MAR-13 01-Mar-2013 1151 O 23-Feb-2013 30-Mar-2013 01-Jan-2013 1 01-Jan-2013 21 2013 20130003 3 N 31-Aug-2011 1153 59868                 2052 N

    2 rows retrieved
  
  
• See SQL
  
  

  GL_CODE_COMBINATIONS

  CODE_COMBINATION_ID LAST_UPDATE_DATE LAST_UPDATED_BY CHART_OF_ACCOUNTS_ID DETAIL_POSTING_ ALLOWED_FLAG DETAIL_BUDGETING_ ALLOWED_FLAG ACCOUNT_TYPE ENABLED_FLAG SUMMARY_FLAG SEGMENT1 SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 SEGMENT6 SEGMENT7 SEGMENT8 SEGMENT9 SEGMENT10 SEGMENT11 SEGMENT12 SEGMENT13 SEGMENT14 SEGMENT15 SEGMENT16 SEGMENT17 SEGMENT18 SEGMENT19 SEGMENT20 SEGMENT21 SEGMENT22 SEGMENT23 SEGMENT24 SEGMENT25 SEGMENT26 SEGMENT27 SEGMENT28 SEGMENT29 SEGMENT30 DESCRIPTION TEMPLATE_ID ALLOCATION_CREATE_ FLAG START_DATE_ACTIVE END_DATE_ACTIVE ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 CONTEXT SEGMENT_ATTRIBUTE1 SEGMENT_ATTRIBUTE2 SEGMENT_ATTRIBUTE3 SEGMENT_ATTRIBUTE4 SEGMENT_ATTRIBUTE5 SEGMENT_ATTRIBUTE6 SEGMENT_ATTRIBUTE7 SEGMENT_ATTRIBUTE8 SEGMENT_ATTRIBUTE9 SEGMENT_ATTRIBUTE10 SEGMENT_ATTRIBUTE11 SEGMENT_ATTRIBUTE12 SEGMENT_ATTRIBUTE13 SEGMENT_ATTRIBUTE14 SEGMENT_ATTRIBUTE15 SEGMENT_ATTRIBUTE16 SEGMENT_ATTRIBUTE17 SEGMENT_ATTRIBUTE18 SEGMENT_ATTRIBUTE19 SEGMENT_ATTRIBUTE20 SEGMENT_ATTRIBUTE21 SEGMENT_ATTRIBUTE22 SEGMENT_ATTRIBUTE23 SEGMENT_ATTRIBUTE24 SEGMENT_ATTRIBUTE25 SEGMENT_ATTRIBUTE26 SEGMENT_ATTRIBUTE27 SEGMENT_ATTRIBUTE28 SEGMENT_ATTRIBUTE29 SEGMENT_ATTRIBUTE30 SEGMENT_ATTRIBUTE31 SEGMENT_ATTRIBUTE32 SEGMENT_ATTRIBUTE33 SEGMENT_ATTRIBUTE34 SEGMENT_ATTRIBUTE35 SEGMENT_ATTRIBUTE36 SEGMENT_ATTRIBUTE37 SEGMENT_ATTRIBUTE38 SEGMENT_ATTRIBUTE39 SEGMENT_ATTRIBUTE40 SEGMENT_ATTRIBUTE41 SEGMENT_ATTRIBUTE42 REFERENCE1 REFERENCE2 REFERENCE3 REFERENCE4 REFERENCE5 JGZZ_RECON_FLAG JGZZ_RECON_CONTEXT PRESERVE_FLAG REFRESH_FLAG IGI_BALANCED_BUDGET_ FLAG COMPANY_COST_CENTER_ ORG_ID REVALUATION_ID LEDGER_SEGMENT LEDGER_TYPE_CODE ALTERNATE_CODE_ COMBINATION_ID 3082 27-Sep-2011 1151 50348 Y Y A Y N 100140 148100 00000 00 0000 000000 000 000000 000000                                                                                                                                                                   N     N       N

    1 row 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 PAY_AWT_GROUP_ID CIS_PARENT_VENDOR_ID BUS_CLASS_LAST_ CERTIFIED_DATE BUS_CLASS_LAST_ CERTIFIED_BY 72951 12-Mar-2013 26204 BEST EVER INDUSTRIES LIMITED   1117369 N Y         7594880 27-Jul-2012 19921   VENDOR   N               10021       N DISCOUNT   99         N N                       CORPORATION   20-Mar-2012               N N   N       Invoice   N Y               N N N               N N   O   Y   Y           N                   332071 N   N       Y                                                           P   N   14419770       BEST EVER INDUSTRIES LIMITED 332071

  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 PAY_AWT_GROUP_ID CAGE_CODE LEGAL_BUSINESS_NAME DOING_BUS_AS_NAME DIVISION_NAME SMALL_BUSINESS_CODE CCR_COMMENTS DEBARMENT_START_DATE DEBARMENT_END_DATE 185899 12-Mar-2013 26204 72951 001   7594880 01-Aug-2012 1296 Y N Y N 1216# LANHUA ROAD   JIN CHENG ECONOMIC & TECHNOLOGY JIN CHENG SHAXI 048000   CN       2450 2475 FOLLOW ROUTING GUIDE COLLECT/3RD PARTY BILLING FCA                   Invoice       3027 3005 STANDARD 99 10000   DISCOUNT N USD USD N N   N           N           46053-02       1980-01-01                     0 N     102     DEVELOPMENT ZONE   POSTAL_ADDR_DEF   N                                                       I               N P US   Y     li-li.li@foxconn.com   Y     N   13000 541295 16481741     SHAXI     JIN CHENG 048000 CN

    1 row retrieved
  
  
• See SQL
  
  

  HZ_PARTIES

  PARTY_ID PARTY_NUMBER PARTY_NAME PARTY_TYPE VALIDATED_FLAG LAST_UPDATED_BY CREATION_DATE LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APPLICATION_ ID CREATED_BY LAST_UPDATE_DATE PROGRAM_ID PROGRAM_UPDATE_DATE WH_UPDATE_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE3 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 ORIG_SYSTEM_ REFERENCE SIC_CODE HQ_BRANCH_IND CUSTOMER_KEY TAX_REFERENCE JGZZ_FISCAL_CODE DUNS_NUMBER TAX_NAME PERSON_PRE_NAME_ ADJUNCT PERSON_FIRST_NAME PERSON_MIDDLE_NAME PERSON_LAST_NAME PERSON_NAME_SUFFIX PERSON_TITLE PERSON_ACADEMIC_ TITLE PERSON_PREVIOUS_ LAST_NAME KNOWN_AS PERSON_IDEN_TYPE PERSON_IDENTIFIER GROUP_TYPE COUNTRY ADDRESS1 ADDRESS2 ADDRESS3 ADDRESS4 CITY POSTAL_CODE STATE PROVINCE STATUS COUNTY SIC_CODE_TYPE TOTAL_NUM_OF_ORDERS TOTAL_ORDERED_AMOUNT LAST_ORDERED_DATE URL EMAIL_ADDRESS DO_NOT_MAIL_FLAG ANALYSIS_FY FISCAL_YEAREND_MONTH EMPLOYEES_TOTAL CURR_FY_POTENTIAL_ REVENUE NEXT_FY_POTENTIAL_ REVENUE YEAR_ESTABLISHED GSA_INDICATOR_FLAG MISSION_STATEMENT ORGANIZATION_NAME_ PHONETIC PERSON_FIRST_NAME_ PHONETIC PERSON_LAST_NAME_ PHONETIC LANGUAGE_NAME CATEGORY_CODE REFERENCE_USE_FLAG THIRD_PARTY_FLAG COMPETITOR_FLAG SALUTATION KNOWN_AS2 KNOWN_AS3 KNOWN_AS4 KNOWN_AS5 DUNS_NUMBER_C OBJECT_VERSION_ NUMBER CREATED_BY_MODULE APPLICATION_ID PRIMARY_PHONE_ CONTACT_PT_ID PRIMARY_PHONE_ PURPOSE PRIMARY_PHONE_LINE_ TYPE PRIMARY_PHONE_ COUNTRY_CODE PRIMARY_PHONE_AREA_ CODE PRIMARY_PHONE_NUMBER PRIMARY_PHONE_ EXTENSION CERTIFICATION_LEVEL CERT_REASON_CODE PREFERRED_CONTACT_ METHOD HOME_COUNTRY PERSON_BO_VERSION ORG_BO_VERSION PERSON_CUST_BO_ VERSION ORG_CUST_BO_VERSION 14419770 1121698969 BEST EVER INDUSTRIES LIMITED ORGANIZATION N 2238 26-Jul-2012 6894777     19921 24-Oct-2012                                                                                                   VENDOR-1117369     BSTEVRINDLTD 332071                               CN 1216# LANHUA ROAD JIN CHENG ECONOMIC & TECHNOLOGY DEVELOPMENT ZONE JIN CHENG 048000 SHAXI   A                             N                               3 HZ_IMPORT 200                         1

    1 row retrieved
  
  
• See SQL
  
  

  HZ_PARTY_SITES

  PARTY_SITE_ID PARTY_ID LOCATION_ID LAST_UPDATE_DATE PARTY_SITE_NUMBER LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE WH_UPDATE_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 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 ORIG_SYSTEM_ REFERENCE START_DATE_ACTIVE END_DATE_ACTIVE REGION MAILSTOP CUSTOMER_KEY_OSM PHONE_KEY_OSM CONTACT_KEY_OSM IDENTIFYING_ADDRESS_ FLAG LANGUAGE STATUS PARTY_SITE_NAME ADDRESSEE OBJECT_VERSION_ NUMBER CREATED_BY_MODULE APPLICATION_ID ACTUAL_CONTENT_ SOURCE GLOBAL_LOCATION_ NUMBER DUNS_NUMBER_C 16481741 14419770 541295 26-Jul-2012 1070533817 19921 26-Jul-2012 19921 702686 2405392 222 44161 26-Jul-2012                                                                                       VENDOR-ADDRESS-1117369-001               Y   A 001   1 HZ_IMPORT 200 USER_ENTERED

    1 row retrieved
  
  
• See SQL
  
  

  IBY_EXTERNAL_PAYEES_ALL

  EXT_PAYEE_ID PAYEE_PARTY_ID PAYMENT_FUNCTION EXCLUSIVE_PAYMENT_ FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_ NUMBER PARTY_SITE_ID SUPPLIER_SITE_ID ORG_ID ORG_TYPE DEFAULT_PAYMENT_ METHOD_CODE ECE_TP_LOCATION_CODE BANK_CHARGE_BEARER BANK_INSTRUCTION1_ CODE BANK_INSTRUCTION2_ CODE BANK_INSTRUCTION_ DETAILS PAYMENT_REASON_CODE PAYMENT_REASON_ COMMENTS INACTIVE_DATE PAYMENT_TEXT_ MESSAGE1 PAYMENT_TEXT_ MESSAGE2 PAYMENT_TEXT_ MESSAGE3 DELIVERY_CHANNEL_ CODE PAYMENT_FORMAT_CODE SETTLEMENT_PRIORITY REMIT_ADVICE_ DELIVERY_METHOD REMIT_ADVICE_EMAIL REMIT_ADVICE_FAX 134237 14419770 PAYABLES_DISB N 19921 27-Jul-2012 19921 27-Jul-2012 19921 2 16481741 150610 88 OPERATING_UNIT WIRE                             EMAIL li-li.liXXfoxconn.com

    1 row retrieved
  
  
• See SQL
  
  

  IBY_ACCOUNT_OWNERS

  ACCOUNT_OWNER_ID EXT_BANK_ACCOUNT_ID ACCOUNT_OWNER_PARTY_ ID END_DATE PRIMARY_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_ NUMBER 37361 58065 14419770   Y 19921 31-Jul-2012 19921 31-Jul-2012 19921 1

    1 row retrieved
  
  
• See SQL
  
  

  IBY_PMT_INSTR_USES_ALL

  INSTRUMENT_PAYMENT_ USE_ID PAYMENT_FLOW EXT_PMT_PARTY_ID INSTRUMENT_TYPE INSTRUMENT_ID PAYMENT_FUNCTION ORDER_OF_PREFERENCE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_ NUMBER START_DATE END_DATE DEBIT_AUTH_FLAG DEBIT_AUTH_METHOD DEBIT_AUTH_REFERENCE DEBIT_AUTH_BEGIN DEBIT_AUTH_END ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 91575 DISBURSEMENTS 134237 BANKACCOUNT 58065 PAYABLES_DISB 1 19921 31-Jul-2012 19921 31-Jul-2012 727680 1 20-Mar-2012

    1 row retrieved
  
  
• See SQL
  
  

  IBY_EXT_BANK_ACCOUNTS

  EXT_BANK_ACCOUNT_ID COUNTRY_CODE BRANCH_ID BANK_ID BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM_ HASH1 BANK_ACCOUNT_NUM_ HASH2 MASKED_BANK_ACCOUNT_ NUM BA_MASK_SETTING BA_UNMASK_LENGTH CURRENCY_CODE IBAN IBAN_HASH1 IBAN_HASH2 MASKED_IBAN CHECK_DIGITS BANK_ACCOUNT_TYPE ACCOUNT_ CLASSIFICATION ACCOUNT_SUFFIX AGENCY_LOCATION_CODE PAYMENT_FACTOR_FLAG FOREIGN_PAYMENT_USE_ FLAG EXCHANGE_RATE_ AGREEMENT_NUM EXCHANGE_RATE_ AGREEMENT_TYPE EXCHANGE_RATE HEDGING_CONTRACT_ REFERENCE SECONDARY_ACCOUNT_ REFERENCE BA_NUM_SEC_SEGMENT_ ID ENCRYPTED IBAN_SEC_SEGMENT_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 START_DATE END_DATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_ NUMBER BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME_ ALT SHORT_ACCT_NAME DESCRIPTION BANK_ACCOUNT_NUM_ ELECTRONIC BA_NUM_ELEC_SEC_ SEGMENT_ID SALT_VERSION CONTACT_NAME CONTACT_PHONE CONTACT_FAX CONTACT_EMAIL 58065 TW 14530094 14525581 5028366509 ��ğ�=8� ���+���29� XXXXXX6509 DISPLAY_LAST 4 USD             EXTERNAL     N Y             N                                           20-Mar-2012   19921 31-Jul-2012 1783 25-Feb-2013 7570667 3 BEST EVER INDUSTRIES LIMITED       5028366509   1

    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 ENABLE_ALL_SITES PAY_WHEN_PAID COMM_REV_NUM CLM_DOCUMENT_NUMBER OTM_STATUS_CODE OTM_RECOVERY_FLAG 122008 427 STANDARD 12-Mar-2013 26204 MT8767 N Y             -1 18-Oct-2012 21611 72951 185899 13042 221 221 10021 FOLLOW ROUTING GUIDE FOB COLLECT/3RD PARTY BILLING   USD                 APPROVED 1 12-Mar-2013 Y 12-Mar-2013           0     N                   N       Y N     N         N 4501159497                           OPEN     10632082 201 42585 19-Oct-2012 102                                           MSIPO_DOCS_INTF_PKG   MSIPOAPV 122008-195004             N                         N   PDOI 12-Mar-2013 NONE                         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 LCM_FLAG GROUP_LINE_ID UDA_TEMPLATE_ID DRAFT_ID AMOUNT_FUNDED FUNDED_VALUE PARTIAL_FUNDED_FLAG QUANTITY_FUNDED 94532 13-Mar-2013 26204 122008 59038 94527 2052 3082 920 26204 18-Oct-2012 21611   540 500 0       221       14245   N               INVENTORY 123                                                 2601 225405       INVENTORY 1   11688836 201 32766 13-Mar-2013             Y   102                                 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 GROUP_LINE_ID LINE_NUM_DISPLAY CLM_INFO_FLAG CLM_OPTION_INDICATOR CLM_BASE_LINE_NUM CLM_OPTION_NUM CLM_OPTION_FROM_DATE CLM_OPTION_TO_DATE CLM_FUNDED_FLAG CONTRACT_TYPE COST_CONSTRAINT CLM_IDC_TYPE UDA_TEMPLATE_ID USER_DOCUMENT_STATUS DRAFT_ID CLM_EXERCISED_FLAG CLM_EXERCISED_DATE 59038 19-Oct-2012 21611 122008 1 1 21611 19-Oct-2012 21611 65027 F 4233 IMGR:PICO,WVGA,2D FOCUS,CLASS 2 EACH 17509   N   28.69 28.49 17509                   28.69 N     N                     N N     10 XCAT                             FIXED OPEN       10632082 201 42585 19-Oct-2012         102                                                                                                     QUANTITY GOODS QUANTITY     28.49

    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 LCM_FLAG UDA_TEMPLATE_ID DRAFT_ID 94527 13-Mar-2013 26204 122008 59038 7614988 19-Oct-2012 21611 920 540 0 0 500 0 EACH   221     26-Oct-2012 26-Oct-2012 28.49 N         N                   0   Y 12-Mar-2013                   1                               N Y 0 REJECT NONE N     NONE 0 0 123 1   STANDARD OPEN 11688836 201 32766 13-Mar-2013     3 Y       102 0                                           US   P                                 0 14245 0                     0 QUANTITY QUANTITY                       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_HISTORY_ALL

PREPAY_HISTORY_ID PREPAY_INVOICE_ID PREPAY_LINE_NUM ACCOUNTING_EVENT_ID HISTORICAL_FLAG INVOICE_ID INVOICE_ADJUSTMENT_ EVENT_ID ORG_ID POSTED_FLAG RELATED_PREPAY_APP_ EVENT_ID TRANSACTION_TYPE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE PROGRAM_APPLICATION_ ID PROGRAM_ID PROGRAM_UPDATE_DATE REQUEST_ID INVOICE_LINE_NUMBER ACCOUNTING_DATE BC_EVENT_ID GAIN_LOSS_INDICATOR

  0 rows retrieved


• See SQL
  
  

  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
  
  

  Prepayment Invoices Applied to Invoice

  Vendor Name Invoice Num Invoice Id Invoice amount Invoice Line Num Prepay Invoice Id Prepay Invoice Num Prepay Invoice Line Num Prepay Amount Applied Tax amount Applied

    0 rows retrieved
  
  
• See SQL
  
  

R11i Payment Document and Bank Details    [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
  
  

R12 Payment Document and Bank Details    [Top]

HZ BANK INFO

BANKID BANKNAME ALTBANKNAME SHORTBANKNAME BANKNUMBER BANKCOUNTRY INSTITUTION_TYPE_ CODE END_DATE_ACTIVE

  0 rows retrieved


• See SQL
  
  

  HZ BRANCH INFO

  BANKID BANKNAME ALTBANKNAME SHORTBANKNAME BANKNUMBER BANKCOUNTRY BRANCHID BRANCHNAME ALTBRANCHNAME BRANCHNUMBER BANK_INSTITUTION_ TYPE EDILOCATION BANKCA_END_DATE BRANCHCA_END_DATE

    0 rows retrieved
  
  
• See SQL
  
  

  CE_BANK_ACCOUNTS

  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 BANK_ID CURRENCY_CODE DESCRIPTION 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 CHECK_DIGITS BANK_ACCOUNT_NAME_ ALT ACCOUNT_HOLDER_ID EFT_REQUESTER_ IDENTIFIER SECONDARY_ACCOUNT_ REFERENCE ACCOUNT_SUFFIX DESCRIPTION_CODE1 DESCRIPTION_CODE2 IBAN_NUMBER SHORT_ACCOUNT_NAME ACCOUNT_OWNER_PARTY_ ID ACCOUNT_OWNER_ORG_ID ACCOUNT_ CLASSIFICATION AP_USE_ALLOWED_FLAG AR_USE_ALLOWED_FLAG XTR_USE_ALLOWED_FLAG PAY_USE_ALLOWED_FLAG MULTI_CURRENCY_ ALLOWED_FLAG PAYMENT_MULTI_ CURRENCY_FLAG RECEIPT_MULTI_ CURRENCY_FLAG ZERO_AMOUNT_ALLOWED MAX_OUTLAY MAX_CHECK_AMOUNT MIN_CHECK_AMOUNT AP_AMOUNT_TOLERANCE AR_AMOUNT_TOLERANCE XTR_AMOUNT_TOLERANCE PAY_AMOUNT_TOLERANCE AP_PERCENT_TOLERANCE AR_PERCENT_TOLERANCE XTR_PERCENT_ TOLERANCE PAY_PERCENT_ TOLERANCE BANK_ACCOUNT_TYPE AGENCY_LOCATION_CODE START_DATE END_DATE ACCOUNT_HOLDER_NAME_ ALT ACCOUNT_HOLDER_NAME CASHFLOW_DISPLAY_ ORDER POOLED_FLAG MIN_TARGET_BALANCE MAX_TARGET_BALANCE EFT_USER_NUM MASKED_ACCOUNT_NUM MASKED_IBAN INTEREST_SCHEDULE_ID CASHPOOL_MIN_ PAYMENT_AMT CASHPOOL_MIN_ RECEIPT_AMT CASHPOOL_ROUND_ FACTOR CASHPOOL_ROUND_RULE CE_AMOUNT_TOLERANCE CE_PERCENT_TOLERANCE ASSET_CODE_ COMBINATION_ID CASH_CLEARING_CCID BANK_CHARGES_CCID BANK_ERRORS_CCID OBJECT_VERSION_ NUMBER NETTING_ACCT_FLAG POOL_PAYMENT_METHOD_ CODE POOL_BANK_CHARGE_ BEARER_CODE POOL_PAYMENT_REASON_ CODE POOL_PAYMENT_REASON_ COMMENTS POOL_REMITTANCE_ MESSAGE1 POOL_REMITTANCE_ MESSAGE2 POOL_REMITTANCE_ MESSAGE3 FX_CHARGE_CCID BANK_ACCOUNT_NUM_ ELECTRONIC STMT_LINE_FLOAT_ HANDLING_FLAG AUTORECON_AP_ MATCHING_ORDER AUTORECON_AR_ MATCHING_ORDER RECON_FOREIGN_BANK_ XRATE_TYPE RECON_FOR_BANK_ XRATE_DATE_TYPE RECON_ENABLE_OI_FLAG RECON_OI_FLOAT_ STATUS RECON_OI_CLEARED_ STATUS RECON_OI_MATCHING_ CODE RECON_OI_AMOUNT_ TOLERANCE RECON_OI_PERCENT_ TOLERANCE MANUAL_RECON_AMOUNT_ TOLERANCE MANUAL_RECON_ PERCENT_TOLERANCE RECON_AP_FOREIGN_ DIFF_HANDLING RECON_AR_FOREIGN_ DIFF_HANDLING RECON_CE_FOREIGN_ DIFF_HANDLING RECON_AP_TOLERANCE_ DIFF_ACCT RECON_CE_TOLERANCE_ DIFF_ACCT XTR_BANK_ACCOUNT_ REFERENCE AUTORECON_AP_ MATCHING_ORDER2 GAIN_CODE_ COMBINATION_ID LOSS_CODE_ COMBINATION_ID

    0 rows retrieved
  
  
• See SQL
  
  

  CE_BANK_ACCT_USES_ALL

  BANK_ACCT_USE_ID BANK_ACCOUNT_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN PRIMARY_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 ORG_ID ORG_PARTY_ID AP_USE_ENABLE_FLAG AR_USE_ENABLE_FLAG XTR_USE_ENABLE_FLAG PAY_USE_ENABLE_FLAG EDISC_RECEIVABLES_ TRX_ID UNEDISC_RECEIVABLES_ TRX_ID POOLED_FLAG END_DATE BR_STD_RECEIVABLES_ TRX_ID PAYMENT_DOC_CATEGORY LEGAL_ENTITY_ID INVESTMENT_LIMIT_ CODE FUNDING_LIMIT_CODE AP_DEFAULT_ SETTLEMENT_FLAG XTR_DEFAULT_ SETTLEMENT_FLAG PAYROLL_BANK_ ACCOUNT_ID PRICING_MODEL AUTHORIZED_FLAG EFT_SCRIPT_NAME PORTFOLIO_CODE DEFAULT_ACCOUNT_FLAG OBJECT_VERSION_ NUMBER AR_CLAIM_INV_ACT_ID NEW_AR_RCPTS_ RECEIVABLE_TRX_ID

    0 rows retrieved
  
  
• See SQL
  
  

  CE_GL_ACCOUNTS_CCID

  BANK_ACCT_USE_ID ASSET_CODE_ COMBINATION_ID AP_ASSET_CCID AR_ASSET_CCID CASH_CLEARING_CCID BANK_CHARGES_CCID BANK_ERRORS_CCID GAIN_CODE_ COMBINATION_ID LOSS_CODE_ COMBINATION_ID ON_ACCOUNT_CCID UNAPPLIED_CCID UNIDENTIFIED_CCID FACTOR_CCID RECEIPT_CLEARING_ CCID REMITTANCE_CCID AR_SHORT_TERM_ DEPOSIT_CCID BR_SHORT_TERM_ DEPOSIT_CCID FUTURE_DATED_ PAYMENT_CCID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN BR_REMITTANCE_CCID BR_FACTOR_CCID BANK_INTEREST_ EXPENSE_CCID BANK_INTEREST_ INCOME_CCID XTR_ASSET_CCID OBJECT_VERSION_ NUMBER AR_BANK_CHARGES_CCID CASH CLEARING ACCOUNT CASH ACCOUNT

    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
  
  

Expense Report Details    [Top]

AP_EXPENSE_REPORT_HEADERS_ALL

REPORT_HEADER_ID EMPLOYEE_ID WEEK_END_DATE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY VOUCHNO TOTAL VENDOR_ID VENDOR_SITE_ID EXPENSE_CHECK_ ADDRESS_FLAG REFERENCE_1 REFERENCE_2 INVOICE_NUM EXPENSE_REPORT_ID ACCTS_PAY_CODE_ COMBINATION_ID SET_OF_BOOKS_ID SOURCE PURGEABLE_FLAG ACCOUNTING_DATE MAXIMUM_AMOUNT_TO_ APPLY ADVANCE_INVOICE_TO_ APPLY APPLY_ADVANCES_ DEFAULT EMPLOYEE_CCID DESCRIPTION REJECT_CODE HOLD_LOOKUP_CODE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 DEFAULT_CURRENCY_ CODE DEFAULT_EXCHANGE_ RATE_TYPE DEFAULT_EXCHANGE_ RATE DEFAULT_EXCHANGE_ DATE LAST_UPDATE_LOGIN VOUCHER_NUM USSGL_TRANSACTION_ CODE USSGL_TRX_CODE_ CONTEXT DOC_CATEGORY_CODE AWT_GROUP_ID ORG_ID WORKFLOW_APPROVED_ FLAG FLEX_CONCATENATED 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 OVERRIDE_APPROVER_ID PAYMENT_CROSS_RATE_ TYPE PAYMENT_CROSS_RATE_ DATE PAYMENT_CROSS_RATE PAYMENT_CURRENCY_ CODE CORE_WF_STATUS_FLAG PREPAY_APPLY_FLAG PREPAY_NUM PREPAY_DIST_NUM PREPAY_APPLY_AMOUNT PREPAY_GL_DATE BOTHPAY_PARENT_ID SHORTPAY_PARENT_ID PAID_ON_BEHALF_ EMPLOYEE_ID OVERRIDE_APPROVER_ NAME AMT_DUE_CCARD_ COMPANY AMT_DUE_EMPLOYEE DEFAULT_RECEIPT_ CURRENCY_CODE MULTIPLE_CURRENCIES_ FLAG EXPENSE_STATUS_CODE EXPENSE_LAST_STATUS_ DATE EXPENSE_CURRENT_ APPROVER_ID REPORT_FILING_NUMBER RECEIPTS_RECEIVED_ DATE AUDIT_CODE REPORT_SUBMITTED_ DATE LAST_AUDITED_BY RETURN_REASON_CODE RETURN_INSTRUCTION RECEIPTS_STATUS HOLDING_REPORT_ HEADER_ID REQUEST_ID ADVANCES_ JUSTIFICATION IMAGE_RECEIPTS_ STATUS IMAGE_RECEIPTS_ RECEIVED_DATE MISSING_IMG_JUST APPROVAL_TYPE OVERDUE_REQUEST_ID

  0 rows retrieved


• See SQL
  
  

  AP_EXPENSE_REPORT_LINES_ALL

  REPORT_HEADER_ID LAST_UPDATE_DATE LAST_UPDATED_BY CODE_COMBINATION_ID ITEM_DESCRIPTION SET_OF_BOOKS_ID AMOUNT ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 CURRENCY_CODE EXCHANGE_RATE_TYPE EXCHANGE_RATE EXCHANGE_DATE VAT_CODE LINE_TYPE_LOOKUP_ CODE LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY STAT_AMOUNT USSGL_TRANSACTION_ CODE USSGL_TRX_CODE_ CONTEXT PROJECT_ACCOUNTING_ CONTEXT PROJECT_ID TASK_ID EXPENDITURE_ ORGANIZATION_ID EXPENDITURE_TYPE EXPENDITURE_ITEM_ DATE PA_QUANTITY DISTRIBUTION_LINE_ NUMBER REFERENCE_1 REFERENCE_2 AWT_GROUP_ID ORG_ID RECEIPT_VERIFIED_ FLAG JUSTIFICATION_ REQUIRED_FLAG RECEIPT_REQUIRED_ FLAG RECEIPT_MISSING_FLAG JUSTIFICATION EXPENSE_GROUP START_EXPENSE_DATE END_EXPENSE_DATE RECEIPT_CURRENCY_ CODE RECEIPT_CONVERSION_ RATE DAILY_AMOUNT RECEIPT_CURRENCY_ AMOUNT WEB_PARAMETER_ID GLOBAL_ATTRIBUTE_ CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 AMOUNT_INCLUDES_TAX_ FLAG GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 ADJUSTMENT_REASON POLICY_SHORTPAY_FLAG AWARD_ID MERCHANT_DOCUMENT_ NUMBER MERCHANT_NAME MERCHANT_REFERENCE MERCHANT_TAX_REG_ NUMBER MERCHANT_TAXPAYER_ID COUNTRY_OF_SUPPLY TAX_CODE_OVERRIDE_ FLAG TAX_CODE_ID CREDIT_CARD_TRX_ID ITEMIZE_ID PROJECT_NAME TASK_NAME COMPANY_PREPAID_ INVOICE_ID PA_INTERFACED_FLAG PROJECT_NUMBER TASK_NUMBER AWARD_NUMBER VEHICLE_CATEGORY_ CODE VEHICLE_TYPE FUEL_TYPE NUMBER_PEOPLE DAILY_DISTANCE DISTANCE_UNIT_CODE AVG_MILEAGE_RATE DESTINATION_FROM DESTINATION_TO TRIP_DISTANCE LICENSE_PLATE_NUMBER MILEAGE_RATE_ ADJUSTED_FLAG LOCATION_ID NUM_PDM_DAYS1 NUM_PDM_DAYS2 NUM_PDM_DAYS3 PER_DIEM_RATE1 PER_DIEM_RATE2 PER_DIEM_RATE3 DEDUCTION_ADDITION_ AMT1 DEDUCTION_ADDITION_ AMT2 DEDUCTION_ADDITION_ AMT3 NUM_FREE_BREAKFASTS1 NUM_FREE_LUNCHES1 NUM_FREE_DINNERS1 NUM_FREE_ ACCOMMODATIONS1 NUM_FREE_BREAKFASTS2 NUM_FREE_LUNCHES2 NUM_FREE_DINNERS2 NUM_FREE_ ACCOMMODATIONS2 NUM_FREE_BREAKFASTS3 NUM_FREE_LUNCHES3 NUM_FREE_DINNERS3 NUM_FREE_ ACCOMMODATIONS3 ATTENDEES NUMBER_ATTENDEES TRAVEL_TYPE TICKET_CLASS_CODE TICKET_NUMBER FLIGHT_NUMBER LOCATION_TO_ID ITEMIZATION_PARENT_ ID FLEX_CONCATENATED FUNC_CURRENCY_AMT LOCATION CATEGORY_CODE ADJUSTMENT_REASON_ CODE AP_VALIDATION_ERROR SUBMITTED_AMOUNT REPORT_LINE_ID ALLOCATION_REASON ALLOCATION_SPLIT_ CODE RATE_PER_PASSENGER PASSENGER_RATE_TYPE PASSENGER_AMOUNT RANGE_LOW RANGE_HIGH UOM_DAYS IMAGE_RECEIPT_ REQUIRED_FLAG RECEIPTS_ISSUE ADJUSTMENT_REASON_ COPY

    0 rows retrieved
  
  
• See SQL
  
  

  AP_EXP_REPORT_DISTS_ALL

  REPORT_HEADER_ID REPORT_LINE_ID REPORT_DISTRIBUTION_ ID ORG_ID SEQUENCE_NUM LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN CODE_COMBINATION_ID SEGMENT1 SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 SEGMENT6 SEGMENT7 SEGMENT8 SEGMENT9 SEGMENT10 SEGMENT11 SEGMENT12 SEGMENT13 SEGMENT14 SEGMENT15 SEGMENT16 SEGMENT17 SEGMENT18 SEGMENT19 SEGMENT20 SEGMENT21 SEGMENT22 SEGMENT23 SEGMENT24 SEGMENT25 SEGMENT26 SEGMENT27 SEGMENT28 SEGMENT29 SEGMENT30 PREPARER_MODIFIED_ FLAG AMOUNT PROJECT_ID TASK_ID AWARD_ID EXPENDITURE_ ORGANIZATION_ID COST_CENTER RECEIPT_CURRENCY_ CODE RECEIPT_CONVERSION_ RATE RECEIPT_CURRENCY_ AMOUNT WEB_PARAMETER_ID

    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 USD 24-Jun-2004 2 12-Jun-1997 1 0 Y Y   US 2 5 $         Y

  1 row retrieved


• See SQL
  
  

References    [Top]

• None at present
  

XML File Information    [Top]

• XMLEngine Version = 3.8
  
• File Name = APListXml.xml (File Version = 120.5.12010000.10, File Location = ap/diag, Date = 2012/10/24)
  

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.