GL Accounts - Delete

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

Software Version: 2023.05.31 and newer

Page Header

Table

Field

Table

Field

ERPx_APDeliveryTicketItem

PurchaseAccountSK

ERPx_APDeliveryTicketLine

PurchaseGLAccountSK

ERPx_APDeliveryTicketLineProgram

CompanyExpenseAccountSK

ERPx_APDeliveryTicketLineProgram

CRAccountSK

ERPx_APDeliveryTicketLineProgram

DRAccountSK

ERPx_APPoLine

AccountSK

ERPx_APPProgram

CompanyExpenseAccountSK

ERPx_APPProgram

CRAccountSK

ERPx_APPProgram

DRAccountSK

ERPx_APPProgramEntity

ExpenseAccountSK

ERPx_APPProgramEntity

LiabilityAccountSK

ERPx_APSettlementTransaction

AccruedToGLAccountSK

ERPx_APSpecie

PurchaseAcctSK

ERPx_APTransactionLine

AccountSK

ERPx_APTransactionTax

AccountSK

ERPx_APVendor

APGLAcctRef

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 

ERPx_DW_FNJournalLine

AccountSK

ERPx_GLAccountPeriodSummary

AccountSK

ERPx_GLJournalLine

GLAccountSK

ERPx_GLJournalLineDetail

GLAccountSK

ERPx_IMItem

BrokerageAccrualActSK

ERPx_IMItem

BrokerageExpActSK

ERPx_IMItem

BrokerageWriteOffActSK

ERPx_IMItem

COGSActSK

ERPx_IMItem

FreightAccrualCreditActSK

ERPx_IMItem

FreightAccrualDebitActSK

ERPx_IMItem

FreightRevenueActSK

ERPx_IMItem

InventoryActSK

ERPx_IMItem

InventoryProductionOffsetGLAccountSK

ERPx_IMItem

InventoryValuationGainLossGLAccountSK

ERPx_IMItem

InvOffsetActSK

ERPx_IMItem

PurchaseClearingGLAccountSK

ERPx_IMItem

PurchaseGLAccountSK

ERPx_IMItem

PurchasePriceVarianceGLAccountSK

ERPx_IMItem

SalesActSK

ERPx_IMItem

SalesReturnsActSK

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 

ERPx_SOOrderTypeDocument

FreightVarianceGLAccountSKForDeliveredFreight

ERPx_SOOrderTypeDocument

SalesFreightAccrualGLAccountSK

ERPx_SOTransactionTax

AccountSK

ERPx_SPProgramHeader

CRAccountSK

ERPx_SPProgramHeader

DRAccountSK

ERPx_SPProgramSettlementItem

AccruedCRAccountSK

ERPx_SPProgramSettlementItem

AccruedDRAccountSK

ERPx_SPProgramSettlementItem

SettleCRAccountSK 

ERPx_SPProgramSettlementItem

SettleDRAccountSK





Page Definitions





Technical Details