Powered by InfoCaptor


Previous Page   Next Page

Invoice Distributions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.APFG_AP_INVOICE_DISTRIBUTIONSUnknown
NoneNone.APFG_AP_INVOICE_DISTRIBUTIONSUnknown
NoneNone.APFG_AP_INVOICE_DISTRIBUTIONSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Accounting DateThe accounting date.Invoice Distributions.Accounting DateACCOUNTING_DATEACCOUNTING_DATE114084
Accounting Date - Day Invoice Distributions.Accounting Date ACCOUNTING_DATE_DAY168319
Accounting Date - Month Invoice Distributions.Accounting Date ACCOUNTING_DATE_MONTH168331
Accounting Date - Quarter Invoice Distributions.Accounting Date ACCOUNTING_DATE_QUARTER168343
Accounting Date - Year Invoice Distributions.Accounting Date ACCOUNTING_DATE_YEAR168355
Amount Includes Tax FlagIndicates whether the amount in the amount column includes tax. Used for automatic tax calculation.Invoice Distributions.Amount Includes Tax FlagAMOUNT_INCLUDES_TAX_FLAGAMOUNT_INCLUDES_TAX_FLAG115900
Asset Related FlagFlag that indicates if distribution line is flagged as an asset type line.Invoice Distributions.Asset Related FlagASSET_RELATED_FLAGASSET_RELATED_FLAG116586
Automatic Withholding Tax FlagFlag to determine if distribution is subject to withholding tax.Invoice Distributions.Automatic Withholding Tax FlagAWT_FLAGAWT_FLAG118771
Automatic Withholding Tax Gross AmountAmount subject to withholding tax.Invoice Distributions.Automatic Withholding Tax Gross AmountAWT_GROSS_AMOUNTAWT_GROSS_AMOUNT118772
Context Value Invoice Distributions.Context ValueGLBL_CONTEXT_VALUEGLBL_CONTEXT_VALUE266383
Created ByStandard Who column.Invoice Distributions.Created ByCREATED_BYCREATED_BY124516
Creation DateStandard WHO column.Invoice Distributions.Creation DateCREATION_DATECREATION_DATE125948
Currency Exchange Rate VarianceAmount of exchange rate variance for invoice distribution line matched to a purchase order.Invoice Distributions.Currency Exchange Rate VarianceCRNCY_EXCHANGE_RATE_VARIANCECRNCY_EXCHANGE_RATE_VARIANCE126823
Deferred Expense Invoice Distributions.Deferred ExpenseGLBL_DEFERRED_EXPENSE_9GLBL_DEFERRED_EXPENSE_9266390
Deferred Expense Account Invoice Distributions.Deferred Expense AccountGLBL_DEFERRED_EXPENSE_ACCOUN_9GLBL_DEFERRED_EXPENSE_ACCOUN_9266391
Deferred Expense Date Invoice Distributions.Deferred Expense DateGLBL_DEFERRED_EXPENSE_DATE_9GLBL_DEFERRED_EXPENSE_DATE_9266392
Dist Line Type Descr Invoice Distributions.Dist Line Type DescrDIST_LINE_TYPE_DESCRDIST_LINE_TYPE_DESCR266399
Dist Match Type Descr Invoice Distributions.Dist Match Type DescrDIST_MATCH_TYPE_DESCRDIST_MATCH_TYPE_DESCR266382
Distribution Approval StatusApproval status of distribution.Invoice Distributions.Distribution Approval StatusDISTRIBUTION_APPROVAL_STATUSDISTRIBUTION_APPROVAL_STATUS130226
Distribution Line Encumbrance StatusFlag indicating encumbrance status of distribution line.Invoice Distributions.Distribution Line Encumbrance StatusDIST_LINE_ENCUMBRANCE_STATUSDIST_LINE_ENCUMBRANCE_STATUS130274
Distribution Line NumberLine number of the distribution.Invoice Distributions.Distribution Line NumberDISTRIBUTION_LINE_NUMBERDISTRIBUTION_LINE_NUMBER130233
Distribution Line Type Code Invoice Distributions.Distribution Line Type CodeDIST_LINE_TYPE_CODEDIST_LINE_TYPE_CODE130275
Distribution Match Type Code Invoice Distributions.Distribution Match Type CodeDIST_MATCH_TYPE_CODEDIST_MATCH_TYPE_CODE130276
Expense Account ID Invoice Distributions.Expense Account IDEXPENSE_ACCOUNT_IDEXPENSE_ACCOUNT_ID134057
Expense Account Num Invoice Distributions.Expense Account NumEXPENSE_ACCOUNT_NUMEXPENSE_ACCOUNT_NUM266402
Final Match Status Descr Invoice Distributions.Final Match Status DescrFINAL_MATCH_STATUS_DESCRFINAL_MATCH_STATUS_DESCR266381
Final Matching StatusFinal match indicator for distribution line matched to purchase order.Invoice Distributions.Final Matching StatusFINAL_MATCHING_STATUS_CODEFINAL_MATCHING_STATUS134298
Final VAT Register Request ID Invoice Distributions.Final VAT Register Request IDGLBL_FINAL_VAT_REGISTER_REQ_10GLBL_FINAL_VAT_REGISTER_REQ_10266393
Final VAT Register Request ID 1 Invoice Distributions.Final VAT Register Request ID 1GLBL_FINAL_VAT_REGISTER_REQ_11GLBL_FINAL_VAT_REGISTER_REQ_11266394
Final VAT Register Request ID 2 Invoice Distributions.Final VAT Register Request ID 2GLBL_FINAL_VAT_REGISTER_REQ_12GLBL_FINAL_VAT_REGISTER_REQ_12266395
Final VAT Register Request ID 3 Invoice Distributions.Final VAT Register Request ID 3GLBL_FINAL_VAT_REGISTER_REQ_13GLBL_FINAL_VAT_REGISTER_REQ_13266396
Functional Quantity Variance AmountQuantity variance amount in functional currency for invoice distribution lines matched to purchase order distribution lines.Invoice Distributions.Functional Quantity Variance AmountFUNCTIONAL_QTY_VARIANCE_AMTFUNCTIONAL_QTY_VARIANCE_AMT134926
Income Tax RegionReporting region for distribution line for 1099 reportable supplier.Invoice Distributions.Income Tax RegionINCOME_TAX_REGIONINCOME_TAX_REGION136241
Invoice Distribution AmountAmount of invoice distribution.Invoice Distributions.Invoice Distribution AmountINVOICE_DIST_AMTINVOICE_DIST_AMT137426
Invoice Distribution DescriptionDescription of invoice distribution.Invoice Distributions.Invoice Distribution DescriptionINVOICE_DIST_DESCRIPTIONINVOICE_DIST_DESCRIPTION137427
Invoice Distribution Functional AmountAmount of invoice distribution in functional currency. Only used for foreign currency invoices.Invoice Distributions.Invoice Distribution Functional AmountINVOICE_DIST_FUNC_AMTINVOICE_DIST_FUNC_AMT137428
Invoice IdInvoice unique identifier.Invoice Distributions.Invoice IdINVOICE_IDINVOICE_ID137437
Justification Invoice Distributions.JustificationJUSTIFICATIONJUSTIFICATION138358
Last Update DateStandard WHO column.Invoice Distributions.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140479
Last Updated ByStandard WHO column.Invoice Distributions.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139140
Operation Fiscal Code Invoice Distributions.Operation Fiscal CodeGLBL_CFO_CODE_7GLBL_CFO_CODE_7266386
PA Transfer Status FlagFlag that indicates if project related invoice distributions have been transferred to Oracle Projects.Invoice Distributions.PA Transfer Status FlagPA_TRANSFER_STATUS_FLAGPA_TRANSFER_STATUS_FLAG152600
PO Distribution ID Invoice Distributions.PO Distribution IDPO_DISTRIBUTION_IDPO_DISTRIBUTION_ID155011
Pa Transfer Descr Invoice Distributions.Pa Transfer DescrPA_TRANSFER_DESCRPA_TRANSFER_DESCR266401
Posted FlagFlag that indicates if invoice distribution has been transferred to general ledger.Invoice Distributions.Posted FlagPOSTED_FLAGPOSTED_FLAG154949
Posted To GL AmountAmount transferred to General Ledger in invoice currency (populated only if cash or combined basis accounting is used).Invoice Distributions.Posted To GL AmountPOSTED_TO_GL_AMOUNTPOSTED_TO_GL_AMOUNT154951
Posted To GL Functional AmountAmount transferred to General Ledger in functional currency (populated only if cash or combined basis accounting is used).Invoice Distributions.Posted To GL Functional AmountPOSTED_TO_GL_FUNCTIONAL_AMOUNTPOSTED_TO_GL_FUNCTIONAL_AMOUNT154952
Prc Var Account Num Invoice Distributions.Prc Var Account NumPRC_VAR_ACCOUNT_NUMPRC_VAR_ACCOUNT_NUM266400
Prepay Amount RemainingAmount of prepayment that is still available to be applied to an invoice.Invoice Distributions.Prepay Amount RemainingPREPAY_AMOUNT_REMAININGPREPAY_AMOUNT_REMAINING155225
Price Variance Account ID Invoice Distributions.Price Variance Account IDPRICE_VARIANCE_ACCOUNT_IDPRICE_VARIANCE_ACCOUNT_ID155394
Price Variance AmountAmount of price variance in invoice currency for invoice distribution line matched to purchase order.Invoice Distributions.Price Variance AmountPRICE_VARIANCE_AMTPRICE_VARIANCE_AMT155395
Price Variance Functional AmountPrice variance amount in functional currency for invoice distribution line matched to purchase order.Invoice Distributions.Price Variance Functional AmountPRICE_VARIANCE_FUNCTIONAL_AMTPRICE_VARIANCE_FUNCTIONAL_AMT155396
Purchase Order Matched Distribution Quantity BilledQuantity billed for purchase order matched invoice distributions.Invoice Distributions.Purchase Order Matched Distribution Quantity BilledPO_MATCHED_DIST_QTY_BILLEDPO_MATCHED_DIST_QTY_BILLED155077
Purchase Order Matched Distribution Unit PriceUnit price for purchase order matched invoice items.Invoice Distributions.Purchase Order Matched Distribution Unit PricePO_MATCHED_DIST_UNIT_PRICEPO_MATCHED_DIST_UNIT_PRICE155078
Quantity VarianceQuantity variance amount for invoice distribution lines matched to purchase order distribution lines.Invoice Distributions.Quantity VarianceQUANTITY_VARIANCEQUANTITY_VARIANCE157329
Rate Var Account Num Invoice Distributions.Rate Var Account NumRATE_VAR_ACCOUNT_NUMRATE_VAR_ACCOUNT_NUM266398
Rate Variance Account ID Invoice Distributions.Rate Variance Account IDRATE_VARIANCE_ACCOUNT_IDRATE_VARIANCE_ACCOUNT_ID157673
Ship to Locations Invoice Distributions.Ship to LocationsGLBL_SHIP_TO_LOCATION_4GLBL_SHIP_TO_LOCATION_4266384
Ship to Locations 1 Invoice Distributions.Ship to Locations 1GLBL_SHIP_TO_LOCATION_8GLBL_SHIP_TO_LOCATION_8266387
Statistical Code Invoice Distributions.Statistical CodeGLBL_STATISTICAL_CODE_13GLBL_STATISTICAL_CODE_13266397
Statistical QuantityAmount associated with a distribution line for measuring statistical quantities.Invoice Distributions.Statistical QuantitySTATISTICAL_QUANTITYSTATISTICAL_QUANTITY163450
Tax Inclusive Amounts Invoice Distributions.Tax Inclusive AmountsGLBL_TAX_INCLUSIVE_AMOUNT_4GLBL_TAX_INCLUSIVE_AMOUNT_4266385
Taxable Amount Invoice Distributions.Taxable AmountGLBL_TAXABLE_AMOUNT_9GLBL_TAXABLE_AMOUNT_9266389
Taxpayer ID Invoice Distributions.Taxpayer IDGLBL_TAXPAYER_ID_8GLBL_TAXPAYER_ID_8266388
Transferred To Assets FlagFlag that indicates if distribution has been transferred to Oracle Assets.Invoice Distributions.Transferred To Assets FlagTRANSFERRED_TO_ASSETS_FLAGTRANSFERRED_TO_ASSETS_FLAG165900
Type 10991099 type.Invoice Distributions.Type 1099TYPE_1099TYPE_1099166150
US Standard GL Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Invoice Distributions.US Standard GL Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167041
Accounting DateThe accounting date.Invoice Distributions.Accounting DateACCOUNTING_DATEACCOUNTING_DATE114084
Accounting Date - Day Invoice Distributions.Accounting Date ACCOUNTING_DATE_DAY168319
Accounting Date - Month Invoice Distributions.Accounting Date ACCOUNTING_DATE_MONTH168331
Accounting Date - Quarter Invoice Distributions.Accounting Date ACCOUNTING_DATE_QUARTER168343
Accounting Date - Year Invoice Distributions.Accounting Date ACCOUNTING_DATE_YEAR168355
Amount Includes Tax FlagIndicates whether the amount in the amount column includes tax. Used for automatic tax calculation.Invoice Distributions.Amount Includes Tax FlagAMOUNT_INCLUDES_TAX_FLAGAMOUNT_INCLUDES_TAX_FLAG115900
Asset Related FlagFlag that indicates if distribution line is flagged as an asset type line.Invoice Distributions.Asset Related FlagASSET_RELATED_FLAGASSET_RELATED_FLAG116586
Automatic Withholding Tax FlagFlag to determine if distribution is subject to withholding tax.Invoice Distributions.Automatic Withholding Tax FlagAWT_FLAGAWT_FLAG118771
Automatic Withholding Tax Gross AmountAmount subject to withholding tax.Invoice Distributions.Automatic Withholding Tax Gross AmountAWT_GROSS_AMOUNTAWT_GROSS_AMOUNT118772
Context Value Invoice Distributions.Context ValueGLBL_CONTEXT_VALUEGLBL_CONTEXT_VALUE266383
Created ByStandard Who column.Invoice Distributions.Created ByCREATED_BYCREATED_BY124516
Creation DateStandard WHO column.Invoice Distributions.Creation DateCREATION_DATECREATION_DATE125948
Currency Exchange Rate VarianceAmount of exchange rate variance for invoice distribution line matched to a purchase order.Invoice Distributions.Currency Exchange Rate VarianceCRNCY_EXCHANGE_RATE_VARIANCECRNCY_EXCHANGE_RATE_VARIANCE126823
Deferred Expense Invoice Distributions.Deferred ExpenseGLBL_DEFERRED_EXPENSE_9GLBL_DEFERRED_EXPENSE_9266390
Deferred Expense Account Invoice Distributions.Deferred Expense AccountGLBL_DEFERRED_EXPENSE_ACCOUN_9GLBL_DEFERRED_EXPENSE_ACCOUN_9266391
Deferred Expense Date Invoice Distributions.Deferred Expense DateGLBL_DEFERRED_EXPENSE_DATE_9GLBL_DEFERRED_EXPENSE_DATE_9266392
Dist Line Type Descr Invoice Distributions.Dist Line Type DescrDIST_LINE_TYPE_DESCRDIST_LINE_TYPE_DESCR266399
Dist Match Type Descr Invoice Distributions.Dist Match Type DescrDIST_MATCH_TYPE_DESCRDIST_MATCH_TYPE_DESCR266382
Distribution Approval StatusApproval status of distribution.Invoice Distributions.Distribution Approval StatusDISTRIBUTION_APPROVAL_STATUSDISTRIBUTION_APPROVAL_STATUS130226
Distribution Line Encumbrance StatusFlag indicating encumbrance status of distribution line.Invoice Distributions.Distribution Line Encumbrance StatusDIST_LINE_ENCUMBRANCE_STATUSDIST_LINE_ENCUMBRANCE_STATUS130274
Distribution Line NumberLine number of the distribution.Invoice Distributions.Distribution Line NumberDISTRIBUTION_LINE_NUMBERDISTRIBUTION_LINE_NUMBER130233
Distribution Line Type Code Invoice Distributions.Distribution Line Type CodeDIST_LINE_TYPE_CODEDIST_LINE_TYPE_CODE130275
Distribution Match Type Code Invoice Distributions.Distribution Match Type CodeDIST_MATCH_TYPE_CODEDIST_MATCH_TYPE_CODE130276
Expense Account ID Invoice Distributions.Expense Account IDEXPENSE_ACCOUNT_IDEXPENSE_ACCOUNT_ID134057
Expense Account Num Invoice Distributions.Expense Account NumEXPENSE_ACCOUNT_NUMEXPENSE_ACCOUNT_NUM266402
Final Match Status Descr Invoice Distributions.Final Match Status DescrFINAL_MATCH_STATUS_DESCRFINAL_MATCH_STATUS_DESCR266381
Final Matching StatusFinal match indicator for distribution line matched to purchase order.Invoice Distributions.Final Matching StatusFINAL_MATCHING_STATUS_CODEFINAL_MATCHING_STATUS134298
Final VAT Register Request ID Invoice Distributions.Final VAT Register Request IDGLBL_FINAL_VAT_REGISTER_REQ_10GLBL_FINAL_VAT_REGISTER_REQ_10266393
Final VAT Register Request ID 1 Invoice Distributions.Final VAT Register Request ID 1GLBL_FINAL_VAT_REGISTER_REQ_11GLBL_FINAL_VAT_REGISTER_REQ_11266394
Final VAT Register Request ID 2 Invoice Distributions.Final VAT Register Request ID 2GLBL_FINAL_VAT_REGISTER_REQ_12GLBL_FINAL_VAT_REGISTER_REQ_12266395
Final VAT Register Request ID 3 Invoice Distributions.Final VAT Register Request ID 3GLBL_FINAL_VAT_REGISTER_REQ_13GLBL_FINAL_VAT_REGISTER_REQ_13266396
Functional Quantity Variance AmountQuantity variance amount in functional currency for invoice distribution lines matched to purchase order distribution lines.Invoice Distributions.Functional Quantity Variance AmountFUNCTIONAL_QTY_VARIANCE_AMTFUNCTIONAL_QTY_VARIANCE_AMT134926
Income Tax RegionReporting region for distribution line for 1099 reportable supplier.Invoice Distributions.Income Tax RegionINCOME_TAX_REGIONINCOME_TAX_REGION136241
Invoice Distribution AmountAmount of invoice distribution.Invoice Distributions.Invoice Distribution AmountINVOICE_DIST_AMTINVOICE_DIST_AMT137426
Invoice Distribution DescriptionDescription of invoice distribution.Invoice Distributions.Invoice Distribution DescriptionINVOICE_DIST_DESCRIPTIONINVOICE_DIST_DESCRIPTION137427
Invoice Distribution Functional AmountAmount of invoice distribution in functional currency. Only used for foreign currency invoices.Invoice Distributions.Invoice Distribution Functional AmountINVOICE_DIST_FUNC_AMTINVOICE_DIST_FUNC_AMT137428
Invoice IdInvoice unique identifier.Invoice Distributions.Invoice IdINVOICE_IDINVOICE_ID137437
Justification Invoice Distributions.JustificationJUSTIFICATIONJUSTIFICATION138358
Last Update DateStandard WHO column.Invoice Distributions.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140479
Last Updated ByStandard WHO column.Invoice Distributions.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139140
Operation Fiscal Code Invoice Distributions.Operation Fiscal CodeGLBL_CFO_CODE_7GLBL_CFO_CODE_7266386
PA Transfer Status FlagFlag that indicates if project related invoice distributions have been transferred to Oracle Projects.Invoice Distributions.PA Transfer Status FlagPA_TRANSFER_STATUS_FLAGPA_TRANSFER_STATUS_FLAG152600
PO Distribution ID Invoice Distributions.PO Distribution IDPO_DISTRIBUTION_IDPO_DISTRIBUTION_ID155011
Pa Transfer Descr Invoice Distributions.Pa Transfer DescrPA_TRANSFER_DESCRPA_TRANSFER_DESCR266401
Posted FlagFlag that indicates if invoice distribution has been transferred to general ledger.Invoice Distributions.Posted FlagPOSTED_FLAGPOSTED_FLAG154949
Posted To GL AmountAmount transferred to General Ledger in invoice currency (populated only if cash or combined basis accounting is used).Invoice Distributions.Posted To GL AmountPOSTED_TO_GL_AMOUNTPOSTED_TO_GL_AMOUNT154951
Posted To GL Functional AmountAmount transferred to General Ledger in functional currency (populated only if cash or combined basis accounting is used).Invoice Distributions.Posted To GL Functional AmountPOSTED_TO_GL_FUNCTIONAL_AMOUNTPOSTED_TO_GL_FUNCTIONAL_AMOUNT154952
Prc Var Account Num Invoice Distributions.Prc Var Account NumPRC_VAR_ACCOUNT_NUMPRC_VAR_ACCOUNT_NUM266400
Prepay Amount RemainingAmount of prepayment that is still available to be applied to an invoice.Invoice Distributions.Prepay Amount RemainingPREPAY_AMOUNT_REMAININGPREPAY_AMOUNT_REMAINING155225
Price Variance Account ID Invoice Distributions.Price Variance Account IDPRICE_VARIANCE_ACCOUNT_IDPRICE_VARIANCE_ACCOUNT_ID155394
Price Variance AmountAmount of price variance in invoice currency for invoice distribution line matched to purchase order.Invoice Distributions.Price Variance AmountPRICE_VARIANCE_AMTPRICE_VARIANCE_AMT155395
Price Variance Functional AmountPrice variance amount in functional currency for invoice distribution line matched to purchase order.Invoice Distributions.Price Variance Functional AmountPRICE_VARIANCE_FUNCTIONAL_AMTPRICE_VARIANCE_FUNCTIONAL_AMT155396
Purchase Order Matched Distribution Quantity BilledQuantity billed for purchase order matched invoice distributions.Invoice Distributions.Purchase Order Matched Distribution Quantity BilledPO_MATCHED_DIST_QTY_BILLEDPO_MATCHED_DIST_QTY_BILLED155077
Purchase Order Matched Distribution Unit PriceUnit price for purchase order matched invoice items.Invoice Distributions.Purchase Order Matched Distribution Unit PricePO_MATCHED_DIST_UNIT_PRICEPO_MATCHED_DIST_UNIT_PRICE155078
Quantity VarianceQuantity variance amount for invoice distribution lines matched to purchase order distribution lines.Invoice Distributions.Quantity VarianceQUANTITY_VARIANCEQUANTITY_VARIANCE157329
Rate Var Account Num Invoice Distributions.Rate Var Account NumRATE_VAR_ACCOUNT_NUMRATE_VAR_ACCOUNT_NUM266398
Rate Variance Account ID Invoice Distributions.Rate Variance Account IDRATE_VARIANCE_ACCOUNT_IDRATE_VARIANCE_ACCOUNT_ID157673
Ship to Locations Invoice Distributions.Ship to LocationsGLBL_SHIP_TO_LOCATION_4GLBL_SHIP_TO_LOCATION_4266384
Ship to Locations 1 Invoice Distributions.Ship to Locations 1GLBL_SHIP_TO_LOCATION_8GLBL_SHIP_TO_LOCATION_8266387
Statistical Code Invoice Distributions.Statistical CodeGLBL_STATISTICAL_CODE_13GLBL_STATISTICAL_CODE_13266397
Statistical QuantityAmount associated with a distribution line for measuring statistical quantities.Invoice Distributions.Statistical QuantitySTATISTICAL_QUANTITYSTATISTICAL_QUANTITY163450
Tax Inclusive Amounts Invoice Distributions.Tax Inclusive AmountsGLBL_TAX_INCLUSIVE_AMOUNT_4GLBL_TAX_INCLUSIVE_AMOUNT_4266385
Taxable Amount Invoice Distributions.Taxable AmountGLBL_TAXABLE_AMOUNT_9GLBL_TAXABLE_AMOUNT_9266389
Taxpayer ID Invoice Distributions.Taxpayer IDGLBL_TAXPAYER_ID_8GLBL_TAXPAYER_ID_8266388
Transferred To Assets FlagFlag that indicates if distribution has been transferred to Oracle Assets.Invoice Distributions.Transferred To Assets FlagTRANSFERRED_TO_ASSETS_FLAGTRANSFERRED_TO_ASSETS_FLAG165900
Type 10991099 type.Invoice Distributions.Type 1099TYPE_1099TYPE_1099166150
US Standard GL Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Invoice Distributions.US Standard GL Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167041
Accounting DateThe accounting date.Invoice Distributions.Accounting DateACCOUNTING_DATEACCOUNTING_DATE114084
Accounting Date - Day Invoice Distributions.Accounting Date ACCOUNTING_DATE_DAY168319
Accounting Date - Month Invoice Distributions.Accounting Date ACCOUNTING_DATE_MONTH168331
Accounting Date - Quarter Invoice Distributions.Accounting Date ACCOUNTING_DATE_QUARTER168343
Accounting Date - Year Invoice Distributions.Accounting Date ACCOUNTING_DATE_YEAR168355
Amount Includes Tax FlagIndicates whether the amount in the amount column includes tax. Used for automatic tax calculation.Invoice Distributions.Amount Includes Tax FlagAMOUNT_INCLUDES_TAX_FLAGAMOUNT_INCLUDES_TAX_FLAG115900
Asset Related FlagFlag that indicates if distribution line is flagged as an asset type line.Invoice Distributions.Asset Related FlagASSET_RELATED_FLAGASSET_RELATED_FLAG116586
Automatic Withholding Tax FlagFlag to determine if distribution is subject to withholding tax.Invoice Distributions.Automatic Withholding Tax FlagAWT_FLAGAWT_FLAG118771
Automatic Withholding Tax Gross AmountAmount subject to withholding tax.Invoice Distributions.Automatic Withholding Tax Gross AmountAWT_GROSS_AMOUNTAWT_GROSS_AMOUNT118772
Context Value Invoice Distributions.Context ValueGLBL_CONTEXT_VALUEGLBL_CONTEXT_VALUE266383
Created ByStandard Who column.Invoice Distributions.Created ByCREATED_BYCREATED_BY124516
Creation DateStandard WHO column.Invoice Distributions.Creation DateCREATION_DATECREATION_DATE125948
Currency Exchange Rate VarianceAmount of exchange rate variance for invoice distribution line matched to a purchase order.Invoice Distributions.Currency Exchange Rate VarianceCRNCY_EXCHANGE_RATE_VARIANCECRNCY_EXCHANGE_RATE_VARIANCE126823
Deferred Expense Invoice Distributions.Deferred ExpenseGLBL_DEFERRED_EXPENSE_9GLBL_DEFERRED_EXPENSE_9266390
Deferred Expense Account Invoice Distributions.Deferred Expense AccountGLBL_DEFERRED_EXPENSE_ACCOUN_9GLBL_DEFERRED_EXPENSE_ACCOUN_9266391
Deferred Expense Date Invoice Distributions.Deferred Expense DateGLBL_DEFERRED_EXPENSE_DATE_9GLBL_DEFERRED_EXPENSE_DATE_9266392
Dist Line Type Descr Invoice Distributions.Dist Line Type DescrDIST_LINE_TYPE_DESCRDIST_LINE_TYPE_DESCR266399
Dist Match Type Descr Invoice Distributions.Dist Match Type DescrDIST_MATCH_TYPE_DESCRDIST_MATCH_TYPE_DESCR266382
Distribution Approval StatusApproval status of distribution.Invoice Distributions.Distribution Approval StatusDISTRIBUTION_APPROVAL_STATUSDISTRIBUTION_APPROVAL_STATUS130226
Distribution Line Encumbrance StatusFlag indicating encumbrance status of distribution line.Invoice Distributions.Distribution Line Encumbrance StatusDIST_LINE_ENCUMBRANCE_STATUSDIST_LINE_ENCUMBRANCE_STATUS130274
Distribution Line NumberLine number of the distribution.Invoice Distributions.Distribution Line NumberDISTRIBUTION_LINE_NUMBERDISTRIBUTION_LINE_NUMBER130233
Distribution Line Type Code Invoice Distributions.Distribution Line Type CodeDIST_LINE_TYPE_CODEDIST_LINE_TYPE_CODE130275
Distribution Match Type Code Invoice Distributions.Distribution Match Type CodeDIST_MATCH_TYPE_CODEDIST_MATCH_TYPE_CODE130276
Expense Account ID Invoice Distributions.Expense Account IDEXPENSE_ACCOUNT_IDEXPENSE_ACCOUNT_ID134057
Expense Account Num Invoice Distributions.Expense Account NumEXPENSE_ACCOUNT_NUMEXPENSE_ACCOUNT_NUM266402
Final Match Status Descr Invoice Distributions.Final Match Status DescrFINAL_MATCH_STATUS_DESCRFINAL_MATCH_STATUS_DESCR266381
Final Matching StatusFinal match indicator for distribution line matched to purchase order.Invoice Distributions.Final Matching StatusFINAL_MATCHING_STATUS_CODEFINAL_MATCHING_STATUS134298
Final VAT Register Request ID Invoice Distributions.Final VAT Register Request IDGLBL_FINAL_VAT_REGISTER_REQ_10GLBL_FINAL_VAT_REGISTER_REQ_10266393
Final VAT Register Request ID 1 Invoice Distributions.Final VAT Register Request ID 1GLBL_FINAL_VAT_REGISTER_REQ_11GLBL_FINAL_VAT_REGISTER_REQ_11266394
Final VAT Register Request ID 2 Invoice Distributions.Final VAT Register Request ID 2GLBL_FINAL_VAT_REGISTER_REQ_12GLBL_FINAL_VAT_REGISTER_REQ_12266395
Final VAT Register Request ID 3 Invoice Distributions.Final VAT Register Request ID 3GLBL_FINAL_VAT_REGISTER_REQ_13GLBL_FINAL_VAT_REGISTER_REQ_13266396
Functional Quantity Variance AmountQuantity variance amount in functional currency for invoice distribution lines matched to purchase order distribution lines.Invoice Distributions.Functional Quantity Variance AmountFUNCTIONAL_QTY_VARIANCE_AMTFUNCTIONAL_QTY_VARIANCE_AMT134926
Income Tax RegionReporting region for distribution line for 1099 reportable supplier.Invoice Distributions.Income Tax RegionINCOME_TAX_REGIONINCOME_TAX_REGION136241
Invoice Distribution AmountAmount of invoice distribution.Invoice Distributions.Invoice Distribution AmountINVOICE_DIST_AMTINVOICE_DIST_AMT137426
Invoice Distribution DescriptionDescription of invoice distribution.Invoice Distributions.Invoice Distribution DescriptionINVOICE_DIST_DESCRIPTIONINVOICE_DIST_DESCRIPTION137427
Invoice Distribution Functional AmountAmount of invoice distribution in functional currency. Only used for foreign currency invoices.Invoice Distributions.Invoice Distribution Functional AmountINVOICE_DIST_FUNC_AMTINVOICE_DIST_FUNC_AMT137428
Invoice IdInvoice unique identifier.Invoice Distributions.Invoice IdINVOICE_IDINVOICE_ID137437
Justification Invoice Distributions.JustificationJUSTIFICATIONJUSTIFICATION138358
Last Update DateStandard WHO column.Invoice Distributions.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140479
Last Updated ByStandard WHO column.Invoice Distributions.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139140
Operation Fiscal Code Invoice Distributions.Operation Fiscal CodeGLBL_CFO_CODE_7GLBL_CFO_CODE_7266386
PA Transfer Status FlagFlag that indicates if project related invoice distributions have been transferred to Oracle Projects.Invoice Distributions.PA Transfer Status FlagPA_TRANSFER_STATUS_FLAGPA_TRANSFER_STATUS_FLAG152600
PO Distribution ID Invoice Distributions.PO Distribution IDPO_DISTRIBUTION_IDPO_DISTRIBUTION_ID155011
Pa Transfer Descr Invoice Distributions.Pa Transfer DescrPA_TRANSFER_DESCRPA_TRANSFER_DESCR266401
Posted FlagFlag that indicates if invoice distribution has been transferred to general ledger.Invoice Distributions.Posted FlagPOSTED_FLAGPOSTED_FLAG154949
Posted To GL AmountAmount transferred to General Ledger in invoice currency (populated only if cash or combined basis accounting is used).Invoice Distributions.Posted To GL AmountPOSTED_TO_GL_AMOUNTPOSTED_TO_GL_AMOUNT154951
Posted To GL Functional AmountAmount transferred to General Ledger in functional currency (populated only if cash or combined basis accounting is used).Invoice Distributions.Posted To GL Functional AmountPOSTED_TO_GL_FUNCTIONAL_AMOUNTPOSTED_TO_GL_FUNCTIONAL_AMOUNT154952
Prc Var Account Num Invoice Distributions.Prc Var Account NumPRC_VAR_ACCOUNT_NUMPRC_VAR_ACCOUNT_NUM266400
Prepay Amount RemainingAmount of prepayment that is still available to be applied to an invoice.Invoice Distributions.Prepay Amount RemainingPREPAY_AMOUNT_REMAININGPREPAY_AMOUNT_REMAINING155225
Price Variance Account ID Invoice Distributions.Price Variance Account IDPRICE_VARIANCE_ACCOUNT_IDPRICE_VARIANCE_ACCOUNT_ID155394
Price Variance AmountAmount of price variance in invoice currency for invoice distribution line matched to purchase order.Invoice Distributions.Price Variance AmountPRICE_VARIANCE_AMTPRICE_VARIANCE_AMT155395
Price Variance Functional AmountPrice variance amount in functional currency for invoice distribution line matched to purchase order.Invoice Distributions.Price Variance Functional AmountPRICE_VARIANCE_FUNCTIONAL_AMTPRICE_VARIANCE_FUNCTIONAL_AMT155396
Purchase Order Matched Distribution Quantity BilledQuantity billed for purchase order matched invoice distributions.Invoice Distributions.Purchase Order Matched Distribution Quantity BilledPO_MATCHED_DIST_QTY_BILLEDPO_MATCHED_DIST_QTY_BILLED155077
Purchase Order Matched Distribution Unit PriceUnit price for purchase order matched invoice items.Invoice Distributions.Purchase Order Matched Distribution Unit PricePO_MATCHED_DIST_UNIT_PRICEPO_MATCHED_DIST_UNIT_PRICE155078
Quantity VarianceQuantity variance amount for invoice distribution lines matched to purchase order distribution lines.Invoice Distributions.Quantity VarianceQUANTITY_VARIANCEQUANTITY_VARIANCE157329
Rate Var Account Num Invoice Distributions.Rate Var Account NumRATE_VAR_ACCOUNT_NUMRATE_VAR_ACCOUNT_NUM266398
Rate Variance Account ID Invoice Distributions.Rate Variance Account IDRATE_VARIANCE_ACCOUNT_IDRATE_VARIANCE_ACCOUNT_ID157673
Ship to Locations Invoice Distributions.Ship to LocationsGLBL_SHIP_TO_LOCATION_4GLBL_SHIP_TO_LOCATION_4266384
Ship to Locations 1 Invoice Distributions.Ship to Locations 1GLBL_SHIP_TO_LOCATION_8GLBL_SHIP_TO_LOCATION_8266387
Statistical Code Invoice Distributions.Statistical CodeGLBL_STATISTICAL_CODE_13GLBL_STATISTICAL_CODE_13266397
Statistical QuantityAmount associated with a distribution line for measuring statistical quantities.Invoice Distributions.Statistical QuantitySTATISTICAL_QUANTITYSTATISTICAL_QUANTITY163450
Tax Inclusive Amounts Invoice Distributions.Tax Inclusive AmountsGLBL_TAX_INCLUSIVE_AMOUNT_4GLBL_TAX_INCLUSIVE_AMOUNT_4266385
Taxable Amount Invoice Distributions.Taxable AmountGLBL_TAXABLE_AMOUNT_9GLBL_TAXABLE_AMOUNT_9266389
Taxpayer ID Invoice Distributions.Taxpayer IDGLBL_TAXPAYER_ID_8GLBL_TAXPAYER_ID_8266388
Transferred To Assets FlagFlag that indicates if distribution has been transferred to Oracle Assets.Invoice Distributions.Transferred To Assets FlagTRANSFERRED_TO_ASSETS_FLAGTRANSFERRED_TO_ASSETS_FLAG165900
Type 10991099 type.Invoice Distributions.Type 1099TYPE_1099TYPE_1099166150
US Standard GL Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Invoice Distributions.US Standard GL Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167041
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Invoice Distributions -> Cstfv Rcv Acq Cost Details 1Invoice Distributions.Invoice Id = Receiving Acquisiton Cost Details.Invoice Identifier Of The Top Parent Invoice Invoice Distributions.Distribution Line Number = Receiving Acquisiton Cost Details.Distribution Line Number of top parent invoiceAlways exist in master folderNoneNo
Invoice Distributions -> PA Cost DistributionsInvoice Distributions.Invoice Id = PA Cost Distributions.AP Invoice Id Invoice Distributions.Distribution Line Number = PA Cost Distributions.AP Distribution Line NumberAlways exist in master folderNoneNo
Invoice Distributions -> Receiving Acquisiton Cost DetailsInvoice Distributions.Invoice Id = Receiving Acquisiton Cost Details.Invoice Identifier Of The Immediate Parent Invoice Invoice Distributions.Distribution Line Number = Receiving Acquisiton Cost Details.Distribution Line Number of immediate parent invoiceAlways exist in master folderNoneNo
Invoice Distributions -> Receiving Acquisiton Cost Details 1Invoice Distributions.Invoice Id = Receiving Acquisiton Cost Details.Invoice Identifier Invoice Distributions.Distribution Line Number = Receiving Acquisiton Cost Details.Distribution Line Number of InvoiceAlways exist in master folderNoneNo