Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This page shows the list of database fields that are checked during the GL Account Item Delete

Software Version: 2023.05.31 and newer

Page Header

ERPx_APDeliveryTicketLineProgram

Table

Field

ERPx_APDeliveryTicketItem

PurchaseAccountSK

ERPx_APDeliveryTicketLine

PurchaseGLAccountSK

ERPx_APDeliveryTicketLineProgram

CompanyExpenseAccountSK

ERPx_APDeliveryTicketLineProgram

CRAccountSK

DRAccountSK

ERPx_APPoLine

AccountSKItemSK 

ERPx_APPProgram

CompanyExpenseAccountSK

ERPx_APPProgram

CRAccountSK

ERPx_APPProgram

DRAccountSK

ERPx_APPProgramEntity

ExpenseAccountSK

ERPx_APPProgramEntity

LiabilityAccountSK

ERPx_APSettlementTransaction

AccruedToGLAccountSK

ERPx_APSpecie

PurchaseAcctSKAPTransactionClass

DefaultItemSK 

ERPx_APTransactionLine

AccountSKItemSK 

ERPx_APTransactionTaxAPVendorFavorite

AccountSKItemSK 

ERPx_APVendorARCustomerFavorite

APGLAcctRefItemSK 

ERPx_APVendor

CashGLAcctRef

ERPx_APVendor

DisctTakenGLAcctRef

ERPx_APVendor

FinanceChargeGLAcctRef

ERPx_APVendor

PurchGLAcctRef

ERPx_APVendor

SAGLAcctRef

ERPx_APVendor

WriteOffGLAcctRef 

ERPx_APVendorClass

APGLAcctRef

ERPx_APVendorClass

CashGLAcctRef

ERPx_APVendorClass

DistTakenGLAcctRef

ERPx_APVendorClass

FinanceChargeGLAcctRef

ERPx_APVendorClass

PurchGLAcctRef

ERPx_APVendorClass

SAGLAcctRef

ERPx_APVendorClass

WriteOffGLAcctRef 

ERPx_APVendorInterestCalculationLine

FinanceChargeGLAccountSK 

ERPx_ARCustomer

COGSActSK

ERPx_ARCustomer

FinanceChgActSK

ERPx_ARCustomer

GLARAccountSK

ERPx_ARCustomer

InventoryActSK

ERPx_ARCustomer

OverPmtWriteOffActSK

ERPx_ARCustomer

SalesActSK

ERPx_ARCustomer

SalesReturnActSK

ERPx_ARCustomer

TermsDiscAvailActSK

ERPx_ARCustomer

TermsDiscTakenActSK

ERPx_ARCustomer

WriteOffActSK

ERPx_ARCustomerClass

ARGLAcctRef

ERPx_ARCustomerClass

COGSActSK

ERPx_ARCustomerClass

FinanceChgActSK

ERPx_ARCustomerClass

InventoryActSK

ERPx_ARCustomerClass

OverPmtWriteOffActSK

ERPx_ARCustomerClass

SalesActSK

ERPx_ARCustomerClass

SalesReturnActSK

ERPx_ARCustomerClass

TermsDiscAvailActSK

ERPx_ARCustomerClass

TermsDiscTakenActSK

ERPx_ARCustomerClass

WriteOffActSK

ERPx_ARSettlementApplication

WriteoffAccountSK 

ERPx_ARTransactionLine

AccountSK

ERPx_CPAccrual

CRAccountSK

ERPx_CPAccrual

DRAccountSK

ERPx_CPCharge

CRAccountSK

ERPx_CPCharge

DRAccountSK

ERPx_CPItem

PurchaseGLAccountSK 

ERPx_CPTicketItem

PurchaseGLAccountSK ARCustomerSubstituteItem

SubstituteItemSK 

ERPx_ARTransactionLine

ItemSK 

ERPx_CPItem

IMItemSK 

ERPx_DW_FNJournalLineIMLotHistory

AccountSKItemSK 

ERPx_GLAccountPeriodSummary

AccountSK

ERPx_GLJournalLine

GLAccountSKDW_SOItemHistory

ItemSK 

ERPx_GLJournalLineDetailIMBinBalance

GLAccountSKItemSK 

ERPx_IMItemIMLotBalance

BrokerageAccrualActSKItemSK 

ERPx_IMItemIMLotBalanceRollupLog

BrokerageExpActSKItemSK 

ERPx_IMItemIMProductionLot

BrokerageWriteOffActSKItemSK 

ERPx_IMItemIMProductionOrderDetail

COGSActSKItemSK 

ERPx_IMItemIMTransactionClass

FreightAccrualCreditActSKFreightAndSurchargeItemSKForDeliveredFreightPurchaseOrder

ERPx_IMItemIMTransactionClass

FreightAccrualDebitActSKHandlingItemSKForDeliveredFreightPurchaseOrder

ERPx_IMItemIMTransactionClass

FreightRevenueActSKOtherChargeItemSKForDeliveredFreightPurchaseOrder

ERPx_IMItemIMTransactionDetail

InventoryActSKItemSK 

ERPx_IMItemIMWarehouseLotAllowedItems

InventoryProductionOffsetGLAccountSKItemSK 

ERPx_IMItemMFPriceListItem 

InventoryValuationGainLossGLAccountSKItemSK 

ERPx_IMItemMFPriceListItemHistory 

InvOffsetActSKItemSK 

ERPx_IMItemMPBOMOutput

PurchaseClearingGLAccountSKItemSK 

ERPx_IMItemSCContractItem

PurchaseGLAccountSKItemSK 

ERPx_IMItemSOOrderItem

PurchasePriceVarianceGLAccountSKItemSK 

ERPx_IMItemSOOrderItemSubstitution

SalesActSKParentItemSK

ERPx_IMItemSOOrderItemSubstitution

SalesReturnsActSKSubstituteItemSK 

ERPx_IMItem

TransferFrtAccrualGLAccountSK

ERPx_IMItem

TransferFrtExpenseGLAccountSK

ERPx_IMItemClass

BrokerageAccrualActSK

ERPx_IMItemClass

BrokerageExpActSK

ERPx_IMItemClass

BrokerageWriteOffActSK

ERPx_IMItemClass

COGSActSK

ERPx_IMItemClass

FreightAccrualCreditActSK

ERPx_IMItemClass

FreightAccrualDebitActSK

ERPx_IMItemClass

FreightRevenueActSK

ERPx_IMItemClass

InventoryActSK

ERPx_IMItemClass

InventoryProductionOffsetGLAccountSK

ERPx_IMItemClass

InventoryValuationGainLossGLAccountSK

ERPx_IMItemClass

InvOffsetActSK

ERPx_IMItemClass

PurchaseClearingGLAccountSK

ERPx_IMItemClass

PurchaseGLAccountSK

ERPx_IMItemClass

PurchasePriceVarianceGLAccountSK

ERPx_IMItemClass

SalesActSK

ERPx_IMItemClass

SalesReturnsActSK

ERPx_IMItemClass

TransferFrtAccrualGLAccountSK

ERPx_IMItemClass

TransferFrtExpenseGLAccountSK

ERPx_IMLotCostPostingLog

GLAccountSKCredit 

ERPx_IMLotCostPostingLog

GLAccountSKDebit

ERPx_IMTransactionClass

FreightVarianceGLAccountSKForDeliveredFreight

ERPx_IMTransactionClass

TransferFreightAccrualGLAccountSK

ERPx_MFCheckbook

CashAccountSK 

ERPx_MFCheckbookDetail

AccountSK 

ERPx_MFSysPreferences

DefaultSettlementAccrualAcct 

ERPx_MFSysPreferences

InterestPaymentGLAccount 

ERPx_MFSysPreferences

InterestRevenueGLAccount

ERPx_MFSysPreferences

RetainedEarningsGLAcct

ERPx_MFTaxDetail

GLAccountSK 

SOOrderTypeDocument

FreightAndSurchargeItemSKForDeliveredFreightPurchaseOrder

ERPx_SOOrderTypeDocument

FreightVarianceGLAccountSKForDeliveredFreightHandlingItemSKForDeliveredFreightPurchaseOrder

ERPx_SOOrderTypeDocument

SalesFreightAccrualGLAccountSKOtherChargeItemSKForDeliveredFreightPurchaseOrder

ERPx_SOTransactionTax

AccountSK

ERPx_SPProgramHeader

CRAccountSK

ERPx_SPProgramHeader

DRAccountSK

SPProgramItemSet

PromoProgramItemSK 

ERPx_SPProgramSettlementItem

AccruedCRAccountSK

ERPx_SPProgramSettlementItem

AccruedDRAccountSK

ERPx_SPProgramSettlementItem

SettleCRAccountSK 

ERPx_SPProgramSettlementItem

SettleDRAccountSKItemSK 

Related Topics



Expand
titlePage Definitions

Page Definitions


...