Navigation:  Product Use > How Tables are Consolidated >

Accounts Payable Module

 Previous pageReturn to chapter overviewNext page

 

AP_Options – use Consolidated Company AP_Options table.

•Divisions – set to “Y” in the Consolidated Company if it is “Y” in any Source Company

 

AP_Division – combined.

•AccountsPayableAcctKey - G/L account conversion
•DiscountsEarnedOrTakenAcctKey - - G/L account conversion
•CashAcctKey - G/L account conversion
•DiscountsLostAcctKey - G/L account conversion
•RetentionPayableAcctKey - G/L account conversion
•FreightAcctKey - G/L account conversion
•SalesTaxAcctKey - G/L account conversion
•NonRecoverableTaxAcctKey - G/L account conversion
•UseTaxAcctKey - G/L account conversion

 

AP_Vendor – combined.

•APDivisionNo – convert A/P division
•AccountKey - G/L account conversion
•LastPurchaseDate - maximum
•LastPaymentDate - maximum
•BalanceDue - summed

 

AP_VendorMemo - increment sequence.

•APDivisionNo – convert A/P division
•SeqNo - incremented

 

AP_OpenInvoice - change to create unique key.

•APDivisionNo – convert A/P division
•InvoiceNo - changed to create unique key
•InvoiceHistoryHeaderSeqNo$ - changed to match invoice sequence number in AP_InvoiceHistoryHeader

 

AP_OpenInvoiceTaxSummary - change to create unique key.

•APDivisionNo – convert A/P division
•InvoiceNo - changed to match invoice number in AP_OpenInvoice

 

AP_CheckHistoryHeader - increment sequence.

•APDivisionNo – convert A/P division
•TransferAPDivisionNo - convert A/P division
•CheckSeqNo - incremented

 

AP_CheckHistoryDetail - change to create unique key.

•APDivisionNo – convert A/P division
•CheckSeqNo - changed to match check sequence number in AP_CheckHistoryHeader
•InvoiceNo – changed to match invoice number in AP_OpenInvoice
•InvoiceSeqNo - changed to match invoice sequence number in AP_InvoiceHistoryHeader

 

AP_InvoiceHistoryHeader - increment sequence.

•InvoiceNo – changed to match invoice number in AP_OpenInvoice
•HeaderSeqNo - increment sequence
•APDivisionNo – convert A/P division
•PrepaidApplyToInvoiceNo – changed to match invoice number in AP_OpenInvoice
•WarehouseCode – convert warehouse
•ARDivisionNo – convert A/R division
•PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader

 

AP_TransactionPaymentHistory - increment sequence.

•APDivisionNo – convert A/P division
•InvoiceNo – changed to match invoice number in AP_OpenInvoice
•InvoiceHistoryHeaderSeqNo$ - changed to match sequence number in AP_InvoiceHistoryHeader
•CheckHistoryHeaderSeqNo$ - changed to match sequence number in AP_CheckHistoryHeader
•SequenceNo - increment sequence
•ApplyToInvoice – changed to match invoice number in AP_OpenInvoice
•ApplyHistoryHeaderSeqNo - changed to match sequence number in AP_InvoiceHistoryHeader

 

AP_InvoiceHistoryMemo - change to create unique key.

•InvoiceNo - changed to match invoice number in AP_OpenInvoice
•HeaderSeqNo - changed to match sequence number in AP_InvoiceHistoryHeader

 

AP_InvoiceHistoryTaxSummary- change to create unique key.

•InvoiceNo - changed to match invoice number in AP_OpenInvoice
•HeaderSeqNo - changed to match sequence number in AP_InvoiceHistoryHeader

 

AP_InvoiceHistoryAsset - change to create unique key.

•InvoiceNo - changed to match invoice number in AP_OpenInvoice
•HeaderSeqNo - changed to match sequence number in AP_InvoiceHistoryHeader
•APDivisionNo – convert A/P division
•AccountKey - G/L account conversion
•PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader

         

AP_InvoiceHistoryMemoSettings - change to create unique key.

•InvoiceNo - changed to match invoice number in AP_OpenInvoice
•HeaderSeqNo - changed to match sequence number in AP_InvoiceHistoryHeader

 

AP_InvoiceHistoryDetail - increment sequence.

•InvoiceNo - changed to match invoice number in AP_OpenInvoice
•HeaderSeqNo - changed to match sequence number in AP_InvoiceHistoryHeader
•DetailSeqNo - increment sequence
•AccountKey - G/L account conversion
•TransferAPDivisionNo – convert A/P division
•TransferInvoiceNo - changed to match invoice number in AP_OpenInvoice
•ExtendedDescriptionKey - convert extended description key
•WarehouseCode – convert warehouse code
•POWarehouseCode - convert warehouse code
•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader

 

AP_RepetitiveInvoiceHeader - change to create unique key.

•APDivisionNo – convert A/P division
•ReferenceNo - change to create unique key

 

AP_RepetitiveInvoiceDetail - change to create unique key.

•APDivisionNo – convert A/P division
•ReferenceNo - changed to match reference number in AP_RepetitiveInvoiceHeader
•AccountKey - G/L account conversion

 

AP_RepetitiveInvoiceMemo - change to create unique key.

•APDivisionNo – convert A/P division
•ReferenceNo - changed to match reference number in AP_RepetitiveInvoiceHeader

 

AP_RepetitiveInvoiceTaxDetail - change to create unique key.

•APDivisionNo – convert A/P division
•ReferenceNo - changed to match reference number in AP_RepetitiveInvoiceHeader

 

AP_RepetitiveInvoiceTaxSummary - change to create unique key.

•APDivisionNo – convert A/P division
•ReferenceNo - changed to match reference number in AP_RepetitiveInvoiceHeader

 

AP_RepetitiveInvMemoSettings - change to create unique key.

•APDivisionNo – convert A/P division
•ReferenceNo - changed to match reference number in AP_RepetitiveInvoiceHeader

 

AP_Analysis – combined.

•CompanyCode - Set to consolidation company code
•CurrentNoOfInvs - summed
•CurrentTotalPayables - summed
•CurrentOver30Days - summed
•CurrentOver60Days - summed
•Period1NoOfInvs - summed
•Period1TotalPayables - summed
•Period1Over30Days - summed
•Period1Over60Days - summed
•Period2NoOfInvs - summed
•Period2TotalPayables - summed
•Period2Over30Days - summed
•Period2Over60Days - summed
•Period3NoOfInvs - summed
•Period3TotalPayables - summed
•Period3Over30Days - summed
•Period3Over60Days - summed
•Period4NoOfInvs - summed
•Period4TotalPayables - summed
•Period4Over30Days - summed
•Period4Over60Days - summed
•Period5NoOfInvs - summed
•Period5TotalPayables - summed
•Period5Over30Days - summed
•Period5Over60Days - summed
•Period6NoOfInvs - summed
•Period6TotalPayables - summed
•Period6Over30Days - summed
•Period6Over60Days - summed
•TotalNoOfDaysOld - summed
•TotalOfOriginalInvAmounts - summed
•LastUpdateDate – maximum

 

AP_LastBankUsed – combined.

 

AP_SalesTax – combined.

•APDivisionNo – convert A/P division
•InvoiceNo – changed to match invoice number in AP_OpenInvoice
•TaxablePurchasesAmt - summed
•NonTaxablePurchasesAmt - summed
•TaxableFreightAmt - summed
•NonTaxableFreightAmt - summed
•TaxAmt - summed
•UseTaxAmt - summed
•TaxableTaxAmt - summed
•ExemptPurchasesAmt - summed
•NonRecoverableAmt – summed

 

AP_TermsCode – combined.

 

AP_Vendor1099Payments – combined.

•APDivisionNo – convert A/P division
•BoxAmt – summed

 

AP_VendorContact – combined.

•APDivisionNo – convert A/P division

 

AP_VendorCustomerLink – combined.

•ARDivisionNo – convert A/R division
•APDivisionNo – convert A/P division

 

AP_VendorDocumentContacts – combined.

•APDivisionNo – convert A/P division

 

AP_VendorDocuments – combined.

•APDivisionNo – convert A/P division

 

AP_VendorMemoSettings - increment sequence.

•APDivisionNo – convert A/P division
•SeqNo - incremented

 

AP_VendorPDFLog - increment sequence.

•APDivisionNo – convert A/P division
•PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader
•Sequence - incremented

 

AP_VendorPurchasesHistory – combined.

•APDivisionNo – convert A/P division
•Purchases - summed
•Payments - summed
•DiscountsTaken - summed
•DiscountsLost – summed

 

AP_VendorRemit – combined.

•APDivisionNo – convert A/P division

 

AP_ACHInterface – combined.

 

AP_Audit - increment sequence.

•APDivisionNo – convert A/P division
•SequenceNo - incremented

 

AP_VendorElectronicPayHistory – combined.

•APDivisionNo – convert A/P division
•DepositedAmt – summed