Powered by InfoCaptor


Previous Page   Next Page

Expense Reports
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.APFG_EXPENSE_REPORTSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Account Expense Reports.AccountACCOUNT_50214ACCOUNT_50214266299
Account Name Expense Reports.Account NameACCOUNT_NAMEACCOUNT_NAME266297
CAI_DUE_DATE Expense Reports.CAI_DUE_DATEINV_GLBL_CAI_DUE_DATE_13INV_GLBL_CAI_DUE_DATE_13266262
CAI_NUMBER Expense Reports.CAI_NUMBERINV_GLBL_CAI_NUMBER_13INV_GLBL_CAI_NUMBER_13266261
Check VAT Amount Paid Expense Reports.Check VAT Amount PaidINV_GLBL_CHECK_VAT_AMOUNT_PA_3INV_GLBL_CHECK_VAT_AMOUNT_PA_3266224
Check VAT Amount Paid 1 Expense Reports.Check VAT Amount Paid 1INV_GLBL_CHECK_VAT_AMOUNT_P_22INV_GLBL_CHECK_VAT_AMOUNT_P_22266279
Class Expense Reports.ClassINV_GLBL_CLASS_12INV_GLBL_CLASS_12266247
Collection Document Association Expense Reports.Collection Document AssociationINV_GLBL_COLLECTION_DOCUMEN_12INV_GLBL_COLLECTION_DOCUMEN_12266244
Company Expense Reports.CompanyCOMPANY_50214COMPANY_50214266298
Consolidated Invoice Number Expense Reports.Consolidated Invoice NumberINV_GLBL_CONSOLIDATED_INVOI_12INV_GLBL_CONSOLIDATED_INVOI_12266252
Context Expense Reports.ContextINV_CONTEXTINV_CONTEXT266215
Context Value Expense Reports.Context ValueINV_GLBL_CONTEXT_VALUEINV_GLBL_CONTEXT_VALUE266219
Context Value 1 Expense Reports.Context Value 1LINE_GLBL_CONTEXT_VALUELINE_GLBL_CONTEXT_VALUE266282
Correction Period Expense Reports.Correction PeriodINV_GLBL_CORRECTION_PERIOD_6INV_GLBL_CORRECTION_PERIOD_6266229
Correction Year Expense Reports.Correction YearINV_GLBL_CORRECTION_YEAR_6INV_GLBL_CORRECTION_YEAR_6266228
Cost Center Expense Reports.Cost CenterCOST_CENTER_50214COST_CENTER_50214266300
Country Expense Reports.CountryCOUNTRY_50214COUNTRY_50214266301
Country Code Expense Reports.Country CodeINV_GLBL_JEDK_EDI_COUNTRY_CO_9INV_GLBL_JEDK_EDI_COUNTRY_CO_9266237
Customer Expense Reports.CustomerCUSTOMER_50214CUSTOMER_50214266303
Customs Codes Expense Reports.Customs CodesINV_GLBL_CUSTOMS_CODE_13INV_GLBL_CUSTOMS_CODE_13266256
Customs Issue Date Expense Reports.Customs Issue DateINV_GLBL_CUSTOMS_ISSUE_DATE_13INV_GLBL_CUSTOMS_ISSUE_DATE_13266257
Customs Issue Numbers Expense Reports.Customs Issue NumbersINV_GLBL_CUSTOMS_ISSUE_NUMB_13INV_GLBL_CUSTOMS_ISSUE_NUMB_13266258
DESTINATION_CODE Expense Reports.DESTINATION_CODEINV_GLBL_DESTINATION_CODE_13INV_GLBL_DESTINATION_CODE_13266263
Deductible Type Expense Reports.Deductible TypeINV_GLBL_DEDUCTIBLE_TYPE_17INV_GLBL_DEDUCTIBLE_TYPE_17266272
Deduction Tax Rule Expense Reports.Deduction Tax RuleINV_GLBL_DEDUCTION_TAX_RULE_14INV_GLBL_DEDUCTION_TAX_RULE_14266264
Deferred Expense Expense Reports.Deferred ExpenseLINE_GLBL_DEFERRED_EXPENSE_9LINE_GLBL_DEFERRED_EXPENSE_9266289
Deferred Expense Account Expense Reports.Deferred Expense AccountLINE_GLBL_DEFERRED_EXPENSE_A_9LINE_GLBL_DEFERRED_EXPENSE_A_9266290
Deferred Expense Date Expense Reports.Deferred Expense DateLINE_GLBL_DEFERRED_EXPENSE_D_9LINE_GLBL_DEFERRED_EXPENSE_D_9266291
Distribution Line NumberThe line number of the invoice distribution line created from the expense report line.Expense Reports.Distribution Line NumberDISTRIBUTION_LINE_NUMBERDISTRIBUTION_LINE_NUMBER130232
Document Types Expense Reports.Document TypesINV_GLBL_DOCUMENT_TYPE_11INV_GLBL_DOCUMENT_TYPE_11266243
Dummy Expense Reports.DummyINV_GLBL_JEDK_EDI_DUMMY_9INV_GLBL_JEDK_EDI_DUMMY_9266236
Employee First NameThe first name of the employee submitting the expense report.Expense Reports.Employee First NameEMPLOYEE_FIRST_NAMEEMPLOYEE_FIRST_NAME131872
Employee Full NameThe employees full name consisting of a concatentation of their last and first name, and a middle initial if applicable.Expense Reports.Employee Full NameEMPLOYEE_FULL_NAMEEMPLOYEE_FULL_NAME131875
Employee IDThe system ID of the employee submitting the expense report.Expense Reports.Employee IDEMPLOYEE_IDEMPLOYEE_ID131879
Employee Last NameThe last name (surname, family name) of the employee submitting the expense report.Expense Reports.Employee Last NameEMPLOYEE_LAST_NAMEEMPLOYEE_LAST_NAME131884
Employee NumberThe number assigned to a person if they have even been an employee.Expense Reports.Employee NumberEMPLOYEE_NUMBEREMPLOYEE_NUMBER131897
Exchange DateThe date the exchange rate is effective, this is usually the accounting date of the transactionExpense Reports.Exchange DateEXCHANGE_DATEEXCHANGE_DATE133776
Exchange Date Day Expense Reports.Exchange Date EXCHANGE_DATE_DAY179135
Exchange Date Month Expense Reports.Exchange Date EXCHANGE_DATE_MONTH179139
Exchange Date Quarter Expense Reports.Exchange Date EXCHANGE_DATE_QUARTER179143
Exchange Date Year Expense Reports.Exchange Date EXCHANGE_DATE_YEAR179147
Exchange RateThe exchange rate for a foreign currency.Expense Reports.Exchange RateEXCHANGE_RATEEXCHANGE_RATE133784
Exchange Rate TypeThe exchange rate type for an item on a foreign currency expense report. The possible list of values are; Corporate, Spot, EMU and User Defined.Expense Reports.Exchange Rate TypeEXCHANGE_RATE_TYPEEXCHANGE_RATE_TYPE133800
Final VAT Register Request ID Expense Reports.Final VAT Register Request IDLINE_GLBL_FINAL_VAT_REGISTE_10LINE_GLBL_FINAL_VAT_REGISTE_10266292
Final VAT Register Request ID 1 Expense Reports.Final VAT Register Request ID 1LINE_GLBL_FINAL_VAT_REGISTE_11LINE_GLBL_FINAL_VAT_REGISTE_11266293
Final VAT Register Request ID 2 Expense Reports.Final VAT Register Request ID 2LINE_GLBL_FINAL_VAT_REGISTE_12LINE_GLBL_FINAL_VAT_REGISTE_12266294
Final VAT Register Request ID 3 Expense Reports.Final VAT Register Request ID 3LINE_GLBL_FINAL_VAT_REGISTE_13LINE_GLBL_FINAL_VAT_REGISTE_13266295
GUI Type Expense Reports.GUI TypeINV_GLBL_GUI_TYPE_17INV_GLBL_GUI_TYPE_17266270
ICMS Amount Expense Reports.ICMS AmountINV_GLBL_ICMS_AMOUNT_12INV_GLBL_ICMS_AMOUNT_12266250
ICMS Base Amount Expense Reports.ICMS Base AmountINV_GLBL_ICMS_BASE_AMOUNT_12INV_GLBL_ICMS_BASE_AMOUNT_12266248
ICMS Name Expense Reports.ICMS NameINV_GLBL_ICMS_NAME_12INV_GLBL_ICMS_NAME_12266249
IMPORT_DOC_DATE Expense Reports.IMPORT_DOC_DATEINV_GLBL_IMPORT_DOC_DATE_2INV_GLBL_IMPORT_DOC_DATE_2266222
IMPORT_DOC_NUM Expense Reports.IMPORT_DOC_NUMINV_GLBL_IMPORT_DOC_NUM_2INV_GLBL_IMPORT_DOC_NUM_2266221
IPI Amount Expense Reports.IPI AmountINV_GLBL_IPI_AMOUNT_12INV_GLBL_IPI_AMOUNT_12266251
Import Code Expense Reports.Import CodeINV_GLBL_JEDK_EDI_IMPORT_COD_9INV_GLBL_JEDK_EDI_IMPORT_COD_9266240
Import Code Specification Expense Reports.Import Code SpecificationINV_GLBL_JEDK_EDI_IMPORT_TEX_9INV_GLBL_JEDK_EDI_IMPORT_TEX_9266241
Insurance Premium Type Expense Reports.Insurance Premium TypeINV_GLBL_INSURANCE_PREMIUM__23INV_GLBL_INSURANCE_PREMIUM__23266280
Invoice IdUnique system ID for this invoiceExpense Reports.Invoice IdINVOICE_IDINVOICE_ID137434
Invoice Type Expense Reports.Invoice TypeINV_GLBL_INVOICE_TYPE_5INV_GLBL_INVOICE_TYPE_5266226
Invoice Type 1 Expense Reports.Invoice Type 1INV_GLBL_INVOICE_TYPE_6INV_GLBL_INVOICE_TYPE_6266227
Invoice Type 2 Expense Reports.Invoice Type 2INV_GLBL_INVOICE_TYPE_7INV_GLBL_INVOICE_TYPE_7266230
Invoice Type 3 Expense Reports.Invoice Type 3INV_GLBL_INVOICE_TYPE_8INV_GLBL_INVOICE_TYPE_8266231
Invoice Type 4 Expense Reports.Invoice Type 4INV_GLBL_INVOICE_TYPE_19INV_GLBL_INVOICE_TYPE_19266275
Invoice Type 5 Expense Reports.Invoice Type 5INV_GLBL_INVOICE_TYPE_20INV_GLBL_INVOICE_TYPE_20266276
Invoice Type 6 Expense Reports.Invoice Type 6INV_GLBL_INVOICE_TYPE_21INV_GLBL_INVOICE_TYPE_21266277
JustificationThe justification given for an expense line.Expense Reports.JustificationJUSTIFICATIONJUSTIFICATION138357
Legal Transaction Categories Expense Reports.Legal Transaction CategoriesINV_GLBL_LEGAL_TRANSACTION__13INV_GLBL_LEGAL_TRANSACTION__13266253
Line AmountAmount of the line item.Expense Reports.Line AmountLINE_AMOUNTLINE_AMOUNT144583
Line Currency CodeThe currency code of the line item.Expense Reports.Line Currency CodeLINE_CURRENCY_CODELINE_CURRENCY_CODE144612
Line Item DescriptionThe description of the expense report item.Expense Reports.Line Item DescriptionLINE_ITEM_DESCRIPTIONLINE_ITEM_DESCRIPTION144663
Line TypeThe name of the line type on an expense report. The names are included in Oracle Payables as a list of values.Expense Reports.Line TypeLINE_TYPELINE_TYPE144784
Line Type Description Expense Reports.Line Type DescriptionLINE_TYPE_DESCRIPTIONLINE_TYPE_DESCRIPTION266281
Line VATThe value added tax code. This list of values is delivered with Oracle Payables and is not delivered with this view. Values include; 1099-Backup, Non-Taxable.Expense Reports.Line VATLINE_VATLINE_VAT144808
MES Permit Number Expense Reports.MES Permit NumberINV_MES_PERMIT_NUMBERINV_MES_PERMIT_NUMBER266216
Manager Employee IDThe system ID of the manager that approves the expense report.Expense Reports.Manager Employee IDMANAGER_EMPLOYEE_IDMANAGER_EMPLOYEE_ID146050
Manager Employee NumberThe employee number of the manager that approves the expense report.Expense Reports.Manager Employee NumberMANAGER_EMPLOYEE_NUMBERMANAGER_EMPLOYEE_NUMBER146051
Manager First NameThe first name of the manager that approves the expense report.Expense Reports.Manager First NameMANAGER_FIRST_NAMEMANAGER_FIRST_NAME146052
Manager Full NameThe managers full name, consisting of a concatenation of the last and first name, and middle initial if applicable.Expense Reports.Manager Full NameMANAGER_FULL_NAMEMANAGER_FULL_NAME146070
Manager Last NameThe last name (surname, family name) of the manager approving the expense report.Expense Reports.Manager Last NameMANAGER_LAST_NAMEMANAGER_LAST_NAME146098
Operation Fiscal Code Expense Reports.Operation Fiscal CodeINV_GLBL_CFO_12INV_GLBL_CFO_12266245
Operation Fiscal Code 1 Expense Reports.Operation Fiscal Code 1LINE_GLBL_CFO_CODE_7LINE_GLBL_CFO_CODE_7266285
Organization IdThe organization in which the employee belongs.Expense Reports.Organization IdORGANIZATION_IDORGANIZATION_ID150258
Party ID Expense Reports.Party IDINV_GLBL_JEDK_EDI_PARTY_ID_9INV_GLBL_JEDK_EDI_PARTY_ID_9266238
Payment Category Expense Reports.Payment CategoryINV_GLBL_JEDK_EDI_PAYMENT_CA_9INV_GLBL_JEDK_EDI_PAYMENT_CA_9266232
Payment Channel Expense Reports.Payment ChannelINV_GLBL_JEDK_EDI_PAYMENT_CH_9INV_GLBL_JEDK_EDI_PAYMENT_CH_9266235
Payment Means Expense Reports.Payment MeansINV_GLBL_JEDK_EDI_PAYMENT_ME_9INV_GLBL_JEDK_EDI_PAYMENT_ME_9266234
Payment categoryID Expense Reports.Payment categoryIDINV_GLBL_JEDK_EDI_SEQUENCE_N_9INV_GLBL_JEDK_EDI_SEQUENCE_N_9266233
Print Date Expense Reports.Print DateINV_GLBL_PRINT_DATE_17INV_GLBL_PRINT_DATE_17266273
Project Expense Reports.ProjectPROJECT_50214PROJECT_50214266304
Receipt Missing FlagIndicates that the employee does not posses a receipt for an expense line. (Y or N)Expense Reports.Receipt Missing FlagRECEIPT_MISSING_FLAGRECEIPT_MISSING_FLAG158008
Receipt Required FlagIndicates that your payables department requires that a receipt be sent to them for the expense line. (Y or N)Expense Reports.Receipt Required FlagRECEIPT_REQUIRED_FLAGRECEIPT_REQUIRED_FLAG158026
Report DescriptionThe description of the expense report.Expense Reports.Report DescriptionREPORT_DESCRIPTIONREPORT_DESCRIPTION158628
Report HoldThe name of the hold placed on an expense report. The names are delivered in Oracle Payables as a list of value.Expense Reports.Report HoldREPORT_HOLDREPORT_HOLD158632
Report Hold Description Expense Reports.Report Hold DescriptionREPORT_HOLD_DESCRIPTIONREPORT_HOLD_DESCRIPTION266214
Report Invoice Number Expense Reports.Report Invoice NumberREPORT_INVOICE_NUMBERREPORT_INVOICE_NUMBER158635
Report TotalThe total amount of the expense report.Expense Reports.Report TotalREPORT_TOTALREPORT_TOTAL158646
Report Week End DateThe period ending date of the expense report, used as invoice_date and GL date of the expense report.Expense Reports.Report Week End DateREPORT_WEEK_END_DATEREPORT_WEEK_END_DATE158649
Report Week End Date Day Expense Reports.Report Week End Date REPORT_WEEK_END_DATE_DAY189716
Report Week End Date Month Expense Reports.Report Week End Date REPORT_WEEK_END_DATE_MONTH189718
Report Week End Date Quarter Expense Reports.Report Week End Date REPORT_WEEK_END_DATE_QUARTER189720
Report Week End Date Year Expense Reports.Report Week End Date REPORT_WEEK_END_DATE_YEAR189722
SHIP_TO_LOCATION Expense Reports.SHIP_TO_LOCATIONINV_GLBL_SHIP_TO_LOCATION_13INV_GLBL_SHIP_TO_LOCATION_13266260
SHIP_TO_LOCATION 1 Expense Reports.SHIP_TO_LOCATION 1INV_GLBL_SHIP_TO_LOCATION_18INV_GLBL_SHIP_TO_LOCATION_18266274
Sales Channel Expense Reports.Sales ChannelSALES_CHANNEL_50214SALES_CHANNEL_50214266302
Series Expense Reports.SeriesINV_GLBL_SERIES_12INV_GLBL_SERIES_12266246
Set Of Books IdThe set of books in which the line distribution is posted.Expense Reports.Set Of Books IdSET_OF_BOOKS_IDSET_OF_BOOKS_ID161469
Settlement Code Expense Reports.Settlement CodeINV_GLBL_JEDK_EDI_SETTLEMENT_9INV_GLBL_JEDK_EDI_SETTLEMENT_9266242
Ship to Locations Expense Reports.Ship to LocationsLINE_GLBL_SHIP_TO_LOCATION_4LINE_GLBL_SHIP_TO_LOCATION_4266283
Ship to Locations 1 Expense Reports.Ship to Locations 1LINE_GLBL_SHIP_TO_LOCATION_8LINE_GLBL_SHIP_TO_LOCATION_8266286
SourceThe source of the expense report, used by Invoice Import, possible values include Oracle Project Accounting and XpenseXpress.Expense Reports.SourceSOURCESOURCE162311
Statistical Code Expense Reports.Statistical CodeLINE_GLBL_STATISTICAL_CODE_13LINE_GLBL_STATISTICAL_CODE_13266296
Supplier Exchange Rate Expense Reports.Supplier Exchange RateINV_GLBL_SUPPLIER_EXCHANGE__15INV_GLBL_SUPPLIER_EXCHANGE__15266265
Supplier Message Expense Reports.Supplier MessageINV_GLBL_JEDK_EDI_SUPPLIER_M_9INV_GLBL_JEDK_EDI_SUPPLIER_M_9266239
Supplier Tax Invoice Number Expense Reports.Supplier Tax Invoice NumberINV_GLBL_SUPPLIER_TAX_INVOI_16INV_GLBL_SUPPLIER_TAX_INVOI_16266268
TAX_DATE Expense Reports.TAX_DATEINV_GLBL_TAX_DATE_2INV_GLBL_TAX_DATE_2266220
TAX_DATE 1 Expense Reports.TAX_DATE 1INV_GLBL_TAX_DATE_3INV_GLBL_TAX_DATE_3266223
Tax Accounting Period Expense Reports.Tax Accounting PeriodINV_GLBL_TAX_ACCOUNTING_PER_16INV_GLBL_TAX_ACCOUNTING_PER_16266269
Tax Date Expense Reports.Tax DateINV_GLBL_TAX_DATE_4INV_GLBL_TAX_DATE_4266225
Tax Date 1 Expense Reports.Tax Date 1INV_GLBL_TAX_DATE_22INV_GLBL_TAX_DATE_22266278
Tax Inclusive Expense Reports.Tax InclusiveINV_GLBL_TAX_INCLUSIVE_WITH_13INV_GLBL_TAX_INCLUSIVE_WITH_13266259
Tax Inclusive Amounts Expense Reports.Tax Inclusive AmountsLINE_GLBL_TAX_INCLUSIVE_AMOU_4LINE_GLBL_TAX_INCLUSIVE_AMOU_4266284
Tax Invoice Date Expense Reports.Tax Invoice DateINV_GLBL_TAX_INVOICE_DATE_16INV_GLBL_TAX_INVOICE_DATE_16266267
Tax Invoice Number Expense Reports.Tax Invoice NumberINV_GLBL_TAX_INVOICE_NUMBER_16INV_GLBL_TAX_INVOICE_NUMBER_16266266
Tax authority transaction types Expense Reports.Tax authority transaction typesINV_GLBL_TAX_AUTHORITY_TRAN_13INV_GLBL_TAX_AUTHORITY_TRAN_13266255
Taxable Amount Expense Reports.Taxable AmountLINE_GLBL_TAXABLE_AMOUNT_9LINE_GLBL_TAXABLE_AMOUNT_9266288
Taxpayer ID Expense Reports.Taxpayer IDLINE_GLBL_TAXPAYER_ID_8LINE_GLBL_TAXPAYER_ID_8266287
Total GST tax in SGD Expense Reports.Total GST tax in SGDINV_TOTAL_GST_TAX_IN_SGDINV_TOTAL_GST_TAX_IN_SGD266218
Transaction Letters Expense Reports.Transaction LettersINV_GLBL_TRANSACTION_LETTER_13INV_GLBL_TRANSACTION_LETTER_13266254
Vendor Invoice Tax Amt Expense Reports.Vendor Invoice Tax AmtINV_VENDOR_INVOICE_TAX_AMTINV_VENDOR_INVOICE_TAX_AMT266217
Voucher NumberThe voucher number of the expense report.Expense Reports.Voucher NumberVOUCHER_NUMBERVOUCHER_NUMBER167568
Wine/Cigarette Expense Reports.Wine/CigaretteINV_GLBL_WINE/CIGARETTE_17INV_GLBL_WINECIGARETTE_17266271
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Expense Reports -> HoldsExpense Reports.Invoice Id = Holds.Invoice IdAlways exist in master folderOuter join on detail No
Expense Reports -> Invoice DistributionsExpense Reports.Invoice Id = Invoice Distributions.Invoice Id Expense Reports.Distribution Line Number = Invoice Distributions.Distribution Line NumberAlways exist in master folderOuter join on detail No
Expense Reports -> InvoicesExpense Reports.Invoice Id = Invoices.Invoice IdAlways exist in master folderNoneNo