sage 300 erp 6.0 technical information · 4/6/2011 · csopt optional tables csoptcc optional...

Sage ERP Accpac 6.0A

Technical Information

© 2011 Sage Software, Inc. All rights reserved. Sage, the Sage logos, and all Sage ERP Accpacproduct and service names mentioned herein are registered trademarks or trademarks of SageSoftware, Inc., or its affiliated entities. All other trademarks are the property of their respectiveowners.

Sage Software, Inc.Publisher

From Sage Accpac Development Partner Wiki

< Documentation:Technical Information for System Manager

Notes:

Files denoted with an asterisk (*) are duplicated in the system and company databases.Files denoted with a plus sign (+) were added in Version 6.0A.

Table DescriptionASACTLOG Activation logCSAPP* List of actived applicationsCSAUTH* User authorizationsCSCCD* Currency codesCSCOM Company profileCSCRD* Currency ratesCSCRH* Currency rate tablesCSCRT* Currency rate typesCSEUR* Euro conversion ratesCSFSC Fiscal calendarCSFSCST+ Fiscal StatusesCSOPT Optional tablesCSOPTCC Optional fields conversion creationCSOPTCM Optional fields conversion mappingCSOPTFD Optional field valuesCSOPTFH Optional fieldsCSSEC* Security GroupsCSSEQN Sequence number dispenserCSSKAP Schedule application linksCSSKTB SchedulesCSUICSH* UI customization profile headersCSUICST* UI customization profile details

CSUSCST* UI customization profile assignments

New table added: CSFSCST, Fiscal StatusesFields removed from table CSFSC: STATUS1, STATUS2, STATUS3, STATUS4, STATUS5, STATUS6,STATUS7, STATUS8, STATUS9, STATUS10, STATUS11, STATUS12, STATUS13.

No change.

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_System_Manager/v6.0"Category: Accpac 6.0

This page was last modified on 10 February 2011, at 18:48.


< Documentation:Technical Information for Bank Services

1 Data Tables2 Database Changes

2.1 Changes in Version 6.0A PU12.2 Changes in Version 6.0A

3 Report Changes3.1 Changes in Version 6.0A PU13.2 Changes in Version 6.0A

Notes: Files denoted with an asterisk (*) are temporary files, that are usually empty, or the data is replaced uponprocessing.

Table DescriptionBKACCT BanksBKCUR Bank currency informationBKFORM Check stocks by bankBKGLREF G/L IntegrationBKJCTL Bank posting journal audit control informationBKJERR Listing of posting errorsBKJRNL Bank posting journal (posted reconciliation information)BKJTFR Transfer AuditBKJZGL G/L audit summaryBKOPT optionsBKREG Bank check registerBKTNUM Next available number audit listingBKTT Bank Distribution CodesBKTTX Bank Distribution Code Tax DetailBKUNMAT Unmatched OFX Transactions

BKENTH Bank Entries HeaderBKENTD Bank Entries DetailBKDISTH Bank Distribution Set HeaderBKDISTD Bank Distribution Set DetailBKTRANH Bank Transaction HeaderBKTRAND Bank Transaction DetailBKJTRANH Bank Journal Transaction HeaderBKJTRAND Bank Journal Transaction DetailBKJENTH Bank Entries Journal HeaderBKJENTD Bank Entries Journal Detail

Changes in Version 6.0A PU1

BKOPT:Added the following field:

DTLSORTBY, Sort Reconciliation Details By

BKJRNL:Added the following fields:

RECWFCLR, Fiscal Remaining OutStandingRECDFCLR, Fiscal Remaining In Transit

BKJTRAND:Added the following field:

RECLEVEL, Reconciled By (Header or Detail)

BKJTRANH:Added the following fields:

AMTDTLREC, Reconcile by Detail ReconciledAMTDTLOUT, Reconcile by Detail Outstanding

BKTRAND:Added the following field:

RECLEVEL, Reconciled By (Header or Detail)

BKTRANH:Added the following fields:

AMTDTLREC, Reconcile by Detail ReconciledAMTDTLOUT, Reconcile by Detail Outstanding

Changes in Version 6.0A

BKENTH: removed fields CCTYPE, CCNUMBER, CCNAME, CCAUTHCODE, CCEXPBKJENTH: removed fields CCTYPE, CCNUMBER, CCNAME, CCAUTHCODE, CCEXP, CCTYPED,XCCNUMBER

BKJTRAND: removed fields CCTYPE, CCNUMBER, CCNAME, CCAUTHCODE, CCEXPBKTRAND: removed fields CCTYPE, CCNUMBER, CCNAME, CCAUTHCODE, CCEXPBKTRANH: Modified index #3 and added a new index #5.


BK1460 (Reconciliation Status)

BK1470 (Reconciliation Posting Journal Report)

BK1480 (Bank Options Report)

BK3010 (Bank Reconciliation Report)

BK3040 (Deposit Register Report)

BK3130 (G/L Integration Report)


No change.

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_Bank_Services/v6.0"Category: Accpac 6.0

This page was last modified on 6 April 2011, at 23:28.


< Documentation:Technical Information for Tax Services

Note: Files denoted with an asterisk (*) are temporary files, that are usually empty, or the data is replaced uponprocessing.

Table DescriptionTXAUDD Tax Tracking Item ClassTXAUDH Tax TrackingTXAUTH Tax AuthoritiesTXCLASS Tax ClassesTXGRP Tax GroupsTXRATE Tax RatesTXRSTRT Tax Services RestartTXSTATED Tax State DetailsTXSTATEH Tax State Headers

No change.

No change.

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_Tax_Services/v6.0"Category: Accpac 6.0



< Documentation:Technical Information for G/L Subledger Services


Table DescriptionGPGLBB GL Subledger TransactionsGPGLBH GL Subledger EntriesGPGLBD GL Subledger DetailsGPGLBO GL Subledger Detail Optional FieldsGPRSTRT GL Subledger Restart

No change.

No change.

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_G/L_Subledger_Services/v6.0"Category: Accpac 6.0



< Documentation:Technical Information for General Ledger


Field DescriptionGL01 G/L optionsGLABK Segment codesGLABRX Structure codesGLACGRP Account groupsGLACHD Account rollup child accounts (next level)GLACHDU* Account rollup processorGLADSD Account rollup child accounts (all levels)GLAFS Account (net change) values by fiscal set (year and period)GLAIS Account allocation instructionsGLAMF Account master fileGLAMFO Account optional fieldsGLAMFTO Account transaction optional fieldsGLASV Segment codesGLAVC Account currenciesGLBCTL Journal entry batchesGLCAS Control account subledgersGLCHAGP* Account group-Sort ordersGLGSACC Account permissions for G/L SecurityGLGSSEG Segment permissions for G/L SecurityGLGSUSER Users for G/L SecurityGLJAL* Create allocation batch instructionsGLJALO* Create allocation batch instructions optional fieldsGLJEC Journal entry commentsGLJED Journal entry details

GLJEDO Journal entry detail optional fieldsGLJEH Journal entry headersGLOFD Optional field detailsGLOFH Optional field headers (locations)GLPACHD* Preview rollup member tableGLPAMF* Parameters for the Create Accounts superviewGLPERR Posting errorsGLPJC Posting journal comments (uncleared posting journals only)GLPJD Posting journal details (uncleared posting journals only)GLPJDO Posting journal details optional fields (uncleared posting journals only)GLPJID Posting journal details (ICT generated detail)GLPJIH Posting journal details (ICT generated header)GLPOST Posted transactions (file is cleared when clearing transaction history)GLPOSTO Posted transactions optional fields (file is cleared when clearing transaction history)GLPPC Provisional posting journal commentsGLPPD Provisional posting journal detailsGLPPDO Provisional posting journal details optional fieldsGLPPER Provisional posting errorsGLRED Recurring entries detailGLREDO Recurring entries detail optional fieldsGLREH Recurring entries headerGLRPOST* Transaction history rollup inquiry dataGLRSTRT* Restart dataGLRVAL Revaluation codesGLRVL* Currency revaluationsGLRVLGO* Currency revaluations - gain account optional fieldsGLRVLLO* Currency revaluations - loss account optional fieldsGLRVNET* Recognized revaluation restart dataGLRVRAT* Recognized revaluation rate restart dataGLSJN Source journal profilesGLSRCE Source codesGLWAMF* Accounts workfile for Create Accounts superviewGLWAMFO* Accounts optional fields workfile for Create Accounts superviewGLWAMTO* Accounts transaction optional fields workfile for Create Accounts superviewGLWAVC* Account currencies workfile for Create Accounts superviewGLWCAS* Control account subledgers workfile for Create Accounts superview

GLACGRP: added field GRPCOD

New reports added: glbalsht.rpt, glbalshtdetails, glbalshtnetasset.rpt, glincstm.rpt, glisdetails.rpt, andglisprofit.rpt

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_General_Ledger/v6.0"Category: Accpac 6.0



< Documentation:Technical Information for Accounts Payable

Notes:

Files denoted with an asterisk (*) are temporary files, that are usually empty, or the data is replaced uponprocessing.Files denoted with a plus sign (+) were added in Version 6.0A.

Field DescriptionAPADV* Advice information for checks being printed but not accepted yet. Populated by APCHKS.APAGED* Temporary table storing data for the aging reports. Populated by APAGE.APBTA Payment and adjustment batchesAPCCS 1099 / Contract Payment Reporting System information by codeAPCLX 1099 / Contract Payment Reporting System codesAPDPO+ Days Payable OutstandingAPDSD Distribution set detailsAPDSH Distribution set headersAPGLREF G/L Integration optionsAPIBC Invoice batchesAPIBD Invoice detailsAPIBDA Invoice detail FAS dataAPIBDO Invoice detail optional fieldsAPIBH InvoicesAPIBHO Invoice optional fieldsAPIBS Invoice payment schedule informationAPIBT Invoice detail commentsAPINTCK Integrity checker optionsAPJTR Posting journal job transactionsAPMSG Message templates used when emailing lettersAPOBL Posted documentsAPOBLO Posted document optional fields

APOBLJ Posted document detailsAPOBLJO Posted document detail optional fieldsAPOBLJP Posted document detail paymentsAPOBP Posted document paymentsAPOBS Posted document payment schedule detailsAPOFD Optional fieldsAPOFH Optional field locationsAPPJAID Posting journal - generated AP details (used by ICT only)APPJAIH Posting journal - generated AP entries (used by ICT only)APPJD Posting journal detailsAPPJDO Posting journal detail optional fieldsAPPJGID Posting journal - generated GL details (used by ICT only)APPJH Posting journal headersAPPJHO Posting journal header optional fieldsAPPJS Posting journal sequencesAPP01 Company optionsAPP02 Invoicing optionsAPP03 Payment and aging optionsAPP04 Integration optionsAPPOOP* Temporary table storing unpaid documents. Used by Payment Entry.APPTER Posting error messagesAPPTP Payment codesAPPYM Posted paymentsAPRAS Account setsAPRDC Distribution codesAPRPD Recurring payable detailsAPRPDO Recurring payable detail optional fieldsAPRPH Recurring payablesAPRPHO Recurring payable optional fieldsAPRSTRT* Restart informationAPRTA Payment termsAPRTB Payment terms schedulesAPRTG* Temporary table storing data for the aged retainage report. Populated by APAGERTG.APRVL Revaluation instructionsAPRVLLOG Revaluation LogAPRVLO Revaluation instruction optional fields

APSLD Payment selection code vendor exclusionsAPSLH Payment selection codesAPSLHO Payment selection code optional fieldsAPSLVEN* Selected vendors. Populated by APSELECT.APTCC Advance Credit ClaimsAPTCN G/L distribution information for miscellaneous paymentsAPTCP Payment and adjustment detailsAPTCR Payments and adjustmentsAPTCRO Payment and adjustment optional fieldsAPTCU G/L and job distribution information for payments/adjustmentsAPTRK G/L and job distribution information for posted miscellaneous payments/adjustmentsAPVCM Vendor commentsAPVEN VendorsAPVENO Vendor optional fieldsAPVGR Vendor groupsAPVGRO Vendor group optional fieldsAPVGS Vendor group statisticsAPVNR Vendor remit-to locationsAPVNRO Vendor remit-to location optional fieldsAPVSM Vendor statistics

New table added: APDPO, Days Payable OutstandingAPOBL: Key 1 changed from DM to M (i.e. no longer allow duplicate keys)APPJH: removed field CCTYPEAPPYM: removed fields CCTYPE, CCNUMBER, CCNAME, CCAUTHCODEAPTCR: removed fields CCTYPE, CCNUMBER, CCNAME, CCEXP, CCAUTHCODE

New reports added: APATB01 and APATB02, Aged Payables Reports

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_Accounts_Payable/v6.0"Category: Accpac 6.0



< Documentation:Technical Information for Accounts Receivable



3 Report Changes

Notes:


Table DescriptionARADV* Advice information for checks being printed but not accepted yet. Populated by ARCHKS.ARAGED* Temporary table storing data for the aging reports. Populated by ARAGE.ARBTA Receipt and Adjustment BatchesARCMM Customer commentsARCMMTP Comment typesARCSM Customer statisticsARCSP Customer ship-to locationsARCSPO Customer ship-to location optional fieldsARCUS CustomersARCUSO Customer optional fieldsARDRO+ Days Receivable OutstandingARDUN Dunning messagesARGLREF G/L Integration optionsARGRO Customer groups

ARGROO Customer group optional fieldsARGSM Customer group statisticsARIBC Invoice batchesARIBD Invoice detailsARIBDO Invoice detail optional fieldsARIBH InvoicesARIBHO Invoice optional fieldsARIBS Invoice payment schedule informationARIBT Invoice detail commentsARINTCK Integrity checker optionsARITD Item pricesARITH ItemsARITS Item statisticsARITT Item tax class informationARJTR Posting journal job detailsARMSG Message templates used when emailing/faxing invoices, statements, and letters.ARNAT National accountsARNATO National account optional fieldsARNSM National account statisticsAROBL Posted documentsAROBLO Posted document optional fieldsAROBLJ Posted document detailsAROBLJO Posted document detail optional fieldsAROBLJP Posted document detail paymentsAROBP Posted document payments detailsAROBS Posted document payment schedulesAROFD Optional FieldsAROFH Optional Field LocationsAROFPD Optional Field Parameter DetailsAROFPH Optional Field Parameter HeadersARPJD Posting Journal DetailsARPJDO Posting Journal Detail Optional FieldsARPJH Posting Journal HeadersARPJHO Posting Journal Header Optional FieldsARPJS Posting Journal SequencesARPOOP* Temporary table storing unpaid documents. Used by Receipt Entry.

ARPTER Posting error messagesARPTP Payment codes (called Receipt Types in 5.3 and earlier)ARPYM Posted payments (refunds)ARR01 Company optionsARR02 Invoicing optionsARR03 Receipt and adjustment optionsARR04 Statement processing optionsARR05 Customer and ship-to optionsARR06 Integration optionsARRAS Account setsARRBC Billing cyclesARRDC Distribution codesARRFB Refund batchesARRFD Refund detailsARRFDJ Refund detail jobsARRFH RefundsARRRD G/L and job distribution information for posted miscellaneous receipts/adjustmentsARRRH Posted receiptsARRSTRT* Restart informationARRTA Terms codesARRTB Terms code payment schedulesAPRTG* Temporary table storing data for the aged retainage report. Populated by ARAGERTG.ARRVL Revaluation instructionsARRVLLOG Revaluation LogARRVLO Revaluation instruction optional fieldsARSAP SalespersonsARSIA Recurring chargesARSIAO Recurring charge optional fieldsARSID Recurring charge detailsARSIDO Recurring charge detail optional fieldsARSLCUS* Temporary table storing selected customers. Populated by ARSELECT.ARSLLBL* Temporary table storing selected labels. Populated by ARLABEL.ARSLLST* Temporary table storing selected lists. Populated by itself.ARSPS Salesperson statisticsARSTCUS Statement customersARSTCUSO Statement customer optional fields

ARSTNAT Statement national accountsARSTOBL Statement documentsARSTOBLO Statement document optional fieldsARSTOBP Statement document paymentsARSTRUN Statement run dataARSVC Interest rates by currencyARSVD Interest profilesARTCC Receipt advance credit claimsARTCN G/L distributions for miscellaneous receiptsARTCP Receipt and adjustment detailsARTCR Receipts and adjustmentsARTCRO Receipts and adjustment optional fieldsARTCU G/L and job distribution information for receipts/adjustmentsARUNPSTD* Temporary table storing unposted document details. Populated by itself.ARUNPSTH* Temporary table storing unposted document. Populated by itself.ARURC Update recurring charge instructions.


ARPYMAdded fields CCTRANID, PROCESSCOD

ARRFHAdded fields CCSPSCNT, CCORIGID, CCPREVID, CCPREVSTTS, CCTRANID, CCTRANSTTS,PROCESSCOD

ARRRHAdded fields CCTRANID, PROCESSCOD

ARTCRAdded fields CCPREVID, CCPREVSTTS, CCTRANID, CCTRANSTTS, PROCESSCOD


ARCUS: removed fields CCNUMBER, CCEXP, CCNAME, CCTYPENew table added: ARDRO, Days Receivable OutstandingAROBL:

added field CODETERRKey 6 changed from DM to M (i.e. no longer allow duplicate keys)Key 6 added segment IDINVC

ARPJD: removed field CCTYPEARPJH: removed field CCTYPE

ARPYM: removed fields CCTYPE, CCNUMBER, CCNAME, CCAUTHCODEARRFD: removed fields CCTYPE, CCNUMBER, CCNAME, CCEXP, CCAUTHCODEARRRH: removed fields CCTYPE, CCNUMBER, CCNAME, CCAUTHCODEARTCR: removed fields CCTYPE, CCNUMBER, CCNAME, CCEXP, CCAUTHCODE

New reports added: ARATB01 and ARATB02, Aged Receivables Reports

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_Accounts_Receivable/v6.0"Category: Accpac 6.0

This page was last modified on 31 March 2011, at 21:51.


< Documentation:Technical Information for Inventory Control


Table DescriptionICACCT Account SetsICADED Adjustment DetailsICADEDL Adjustment Details LotsICADEDO Adjustment Details Optional FieldsICADEDS Adjustment Details SerialsICADEH Adjustment HeadersICADEHO Adjustment Headers Optional FieldsICADJD Adjustment Posting Journal - DetailsICADJDP Adjustment Posting Journal - Details Optional FieldsICADJH Adjustment Posting Journal - HeadersICADJHP Adjustment Posting Journal - Headers Optional FieldsICASCST Assembly Component CostsICASEN AssembliesICASENL Assemblies LotsICASENO Assemblies Optional FieldsICASENS Assemblies SerialsICASMDP Assembly Posting Journal - Details Optional FieldsICASMHP Assembly Posting Journal - Headers Optional FieldsICASSMD Assembly Posting Journal - DetailsICASSMH Assembly Posting Journal - HeadersICBOMD Bills of Material ComponentsICBOMH Bills of Material HeadersICCATG CategoriesICCATTX Category Tax Classes

ICCOST Receipt CostICCUPR Contract PricingICGLREF G/L Reference IntegrationICHIST Transaction HistoryICICED Internal Usage DetailsICICEDA Internal Usage FAS DetailsICICEDL Internal Usage Details LotsICICEDO Internal Usage Details Optional FieldsICICEDS Internal Usage Details SerialsICICEH Internal Usage HeadersICICEHO Internal Usage Headers Optional FieldsICILOC Location DetailsICINCAD Internal Usage Audit List DetailsICINCAH Internal Usage Audit List HeadersICINCDP Internal Usage Audit List Details Optional FieldsICINCHP Internal Usage Audit List Headers Optional FieldsICIOTH Manufacturer's Item NumberICITEM ItemsICITEMLO Items Lots Optional FieldsICITEMO Items Optional FieldsICITEMSO Items Serials Optional FieldsICITMAP Item MappingsICITMC Customer Item NumbersICITMS Item StructuresICITMTX Item Tax ClassesICITMV VendorsICIVAL Item ValuationICKITD Kitting Items ComponentsICKITH Kitting Items HeadersICLBL LabelICLOC LocationsICOFD Optional Fields DetailsICOFH Optional Fields HeadersICOPT OptionsICPCOD Price List CodesICPCODC Price List Codes Check

ICPCTX Price List Code Tax AuthoritiesICPRIC Item PricingICPRICC Item Pricing Price CheckICPRICP Item Pricing DetailsICPRTX Price List Tax AuthoritiesICPSCBD Assembly Detail CostsICPSCBH Assembly Header CostsICPSCID Internal Usage Detail CostsICPSCRD Receipt Detail CostsICPSCRH Receipt Headers CostsICRCPD* Receipt Details Not CostedICRCPDL* Receipt Details Lots Not CostedICRCPDP* Receipt Details Not Costed Optional FieldsICRCPDS* Receipt Details Serials Not CostedICRCPH* Receipt Not Costed HeaderICRCPHP* Receipt Not Costed Header Optional FieldsICRECDP Receipt Posting Journal - Details Optional FieldsICRECHP Receipt Posting Journal - Headers Optional FieldsICRECPD Receipt Posting Journal - DetailsICRECPH Receipt Posting Journal - HeadersICREED Receipt DetailsICREEDL Receipt Details LotsICREEDO Receipt Details Optional FieldsICREEDS Receipt Details SerialsICREEH Receipt HeadersICREEHO Receipt Headers Optional FieldsICREOR Reorder Quantities HeadersICREORD Reorder Quantities DetailsICREORO Reorder Quantities Optional FieldsICRSTRT RestartICSEG Item SegmentsICSEGV Segment CodesICSHED Shipment DetailsICSHEDL Shipment Details LotsICSHEDO Shipment Details Optional FieldsICSHEDS Shipment Details Serials

ICSHEH Shipment HeadersICSHEHO Shipment Headers Optional FieldsICSHIPD Shipment Posting Journal - DetailsICSHIPH Shipment Posting Journal - HeadersICSHPDP Shipment Posting Journal - Details Optional FieldsICSHPHP Shipment Posting Journal - Headers Optional FieldsICSTAT Transaction StatisticsICSTATI Sales StatisticsICTRAND* Transfer Posting Journal - DetailsICTRANH* Transfer Posting Journal - HeadersICTRED Transfer DetailsICTREDL Transfer Details LotsICTREDO Transfer Details Optional FieldsICTREDS Transfer Details SerialsICTREH Transfer HeadersICTREHO Transfer Headers Optional FieldsICTRID Transit Transfer/Receipt DetailICTRIDL Transit Transfer/Receipt Detail LotsICTRIDS Transit Transfer/Receipt Detail SerialsICTRIH Transit Transfer/Receipt HeaderICTRIR Transit Transfer/Receipt DocumentICTRNDP Transfer Posting Journal - Details Optional FieldsICTRNHP Transfer Posting Journal - Headers Optional FieldsICUCOD UnitsICUNIQ Document UniquifiersICUNIT Units of MeasureICWCOD Weight Units of MeasureICWKL Inventory WorksheetICWKLO Inventory Worksheet Optional FieldsICWKUD Inventory Worksheet DetailICWKUH Inventory Worksheet HeaderICWKUHL Inventory Worksheet Header LotsICWKUHO Inventory Worksheet Header Optional FieldsICWKUHS Inventory Worksheet Header SerialsICXCONT Contract CodesICXLHIS Lot History

ICXLOT LotsICXLOTO Lot Optional FieldsICXMASK Mask StructuresICXRCD Recall/Release DetailsICXRCH Recall/Release HeadersICXRECN Reconciliation HeadersICXRECNL Reconciliation LotsICXRECNS Reconciliation SerialsICXSCD Split/Combine DetailsICXSCH Split/Combine HeadersICXSER SerialsICXSERO Serial Optional FieldsICXSHIS Serial HistoryICXWARY Warranty Codes

No change.

No change.

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_Inventory_Control/v6.0"Category: Accpac 6.0



< Documentation:Technical Information for Order Entry



3 Report Changes

Notes:


Table DescriptionOEAUDD Posting Journals - DetailsOEAUDDD Posting Journals - Kitting DetailsOEAUDDP Posting Journal Details Optional FieldsOEAUDH Posting JournalsOEAUDHP Posting Journal Optional FieldsOECOINC Cred. Note Comments/InstructionOECOINI Invoice Comments/InstructionsOECOINO Order Comments/InstructionsOECOINS Shipment Comments/InstructionsOECOMM CommissionsOECRDD Credit/Debit DetailsOECRDDB Credit/Debit BOM DetailsOECRDDD Credit/Debit Kitting DetailsOECRDDDL Credit/Debit Kitting Lots

OECRDDDS Credit/Debit Kitting Serial NumbersOECRDDL Credit/Debit Details LotsOECRDDO Credit/Debit Details Optional FieldsOECRDDS Credit/Debit Details SerialsOECRDH Credit/DebitsOECRDHO Credit Debit Optional FieldsOEGLREF G/L Reference IntegrationOEINPP Invoice PrepaymentsOEINVD Invoice DetailsOEINVDB Invoice BOM DetailsOEINVDD Invoice Kitting DetailsOEINVDDL Invoice Kitting LotsOEINVDDS Invoice Kitting Serial NumbersOEINVDL Invoice Details LotsOEINVDO Invoice Details Optional FieldsOEINVDS Invoice Details SerialsOEINVH InvoicesOEINVHO Invoice Optional FieldsOEINVR Multiple Shipments to InvoiceOEMISC Miscellaneous ChargesOEMISCO Miscellaneous Charge Optional FieldsOEMISCT Miscellaneous Charge TaxesOEMSG E-mail MessagesOEOFD Optional FieldsOEOFH Optional Field LocationsOEOPT OptionsOEORDD Order DetailsOEORDDB Order BOM DetailsOEORDDD Kitting DetailsOEORDDDL Order Kitting LotsOEORDDDS Order Kitting Serial NumbersOEORDDL Order Details LotsOEORDDO Order Details Optional FieldsOEORDDS Order Details SerialsOEORDH Orders (Part 1 of headers)OEORDH1 Orders (Part 2 of headers)

OEORDHO Order Optional FieldsOEORDQ Order from QuotesOEORPP Order PrepaymentsOEPAUTH Order Pre-AuthorizationOEPLAT TemplatesOEPPRE PrepaymentsOEPPRED Prepayment Job-related DetailsOEPSPT* Picking Slip Printing Temporary TableOEQTOD+ Promote Quote to Order DetailsOEQTOH+ Promote Quote to Order HeaderOESHCD Shipment Cost-To-Clear DetailsOESHCDD Shipment Cost-To-Clear Kitting DetailsOESHCH Shipment Cost-To-ClearOESHDT Sales History DetailsOESHHD Sales HistoryOESHID Shipment DetailsOESHIDB Shipment BOM DetailsOESHIDD Shipment Kitting DetailsOESHIDDL Shipment Kitting LotsOESHIDDS Shipment Kitting Serial NumbersOESHIDL Shipment Details LotsOESHIDO Shipment Details Optional FieldsOESHIDS Shipment Details SerialsOESHIH ShipmentsOESHIHO Shipment Optional FieldsOESHIR Multiple Orders to ShipmentOESHPP Shipment PrepaymentsOESHTD Shipment Day End DetailsOESHTDD Shipment Day End Kitting DetailsOESHTDDL Shipment Day End Kitting Details LotsOESHTDDS Shipment Day End Kitting Details SerialsOESHTDL Shipment Day End Details LotsOESHTDS Shipment Day End Details SerialsOESHTH Shipments Day EndOESTATS Sales StatisticsOETERMI Invoice Payment Schedules

OETERMO Order Payment SchedulesOETERMS Shipment Payment SchedulesOEVIA Ship-via codes


OEINPPAdded fields PAUTHCURR, TRANIDPRE, TRANIDCAP, TRANIDVOID, PAUTHAMT,CHARGESTTS, YPPROCCODE

OEORDH1Added fields PAYMONORD, PAYMCODE, IDCARD

OEORPPAdded fields PAUTHCURR, TRANIDPRE, TRANIDCAP, TRANIDVOID, PAUTHAMT,CHARGESTTS, YPPROCCODE

OEPAUTHNew table: Order Pre-Authorization

OEPPREAdded fields TRANIDPRE, TRANIDCAP, PAUTHAMT

OESHPPAdded fields PAUTHCURR, TRANIDPRE, TRANIDCAP, TRANIDVOID, PAUTHAMT,CHARGESTTS, YPPROCCODE


OEINPP: removed fields CCTYPE, CCNUMBER, CCNAME, CCEXP, CCAUTHCODEOEINVD: added fields COMPANYID, OPPOIDOEINVH: added field OPPOLINESOEOPT: added fields PURGEEXPQT, QTPURGEDAYOEORDH:

added fields COMPANYID, OPPOID, PERSONID, INCOPPOTOT, QTEXPIRED,QUOORDUNIQ, QUOORDNUMKey 4 changed from none to M (i.e. allow duplicate keys)added key 8 with segments COMPANYID, OPPOID

OEORPP: removed fields CCTYPE, CCNUMBER, CCNAME, CCEXP, CCAUTHCODEOEPPRE: removed fields CCTYPE, CCNUMBER, CCNAME, CCAUTHCODENew tables added:

OEQTOD, Promote Quote to Order DetailsOEQTOH, Promote Quote to Order Header

OESHID: added fields COMPANYID, OPPOIDOESHIH: added field OPPOLINESOESHPP: removed fields CCTYPE, CCNUMBER, CCNAME, CCEXP, CCAUTHCODE

No change.

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_Order_Entry/v6.0"Category: Accpac 6.0



< Documentation:Technical Information for Purchase Orders


Table DescriptionPOAAPC Payables Clearing AuditPOACD Additional Cost TaxesPOACST Additional CostsPOACSTO Additional Costs Optional FieldsPOCOCA Committed Costs AuditPOCOSTZ* Generic Cost DataPOCRAHO Credit/Debit Note Audit Headers Optional FieldsPOCRALO Credit/Debit Note Audit Lines Optional FieldsPOCRASO CR/DR Note Audit Costs Optional FieldsPOCRNAH Credit/Debit Note Audit HeadersPOCRNAL Credit/Debit Note Audit LinesPOCRNAQ CR/DR Note Audit Prorate LinesPOCRNAS CR/DR Note Audit CostsPOCRNC Credit/Debit Note CommentsPOCRND Credit/Debit Note Cost DistributionsPOCRNE* Credit/Debit Note Posting Cost DistributionsPOCRNF* Credit/Debit Note Day-end Cost DistributionsPOCRNH1 Credit/Debit Notes (part 1 of headers)POCRNH2 Credit/Debit Notes (part 2 of headers)POCRNHO Credit/Debit Notes Optional FieldsPOCRNI* Credit/Debit Note PostingsPOCRNJ* Credit/Debit Note Day EndPOCRNL Credit/Debit Note LinesPOCRNLL Credit/Debit Note Lines Lots

POCRNLO Credit/Debit Note Lines Optional FieldsPOCRNLS Credit/Debit Note Lines SerialsPOCRNM* Credit/Debit Note Posting LinesPOCRNML* Credit/Debit Posting Lines LotsPOCRNMS* Credit/Debit Posting Lines SerialsPOCRNN* Credit/Debit Note Day End LinesPOCRNS CR/DR Note Additional CostsPOCRNSO CR/DR Note Additional Costs Optional FieldsPOCRNT* CR/DR Note Posting Add. CostsPOCRNU* CR/DR Note Day End Add. CostsPODISTZ* Generic Distribution DataPOGLREF G/L Reference IntegrationPOGNLOC* Item Quantities On HandPOGNOE* Create POs from OEPOGNOEB* Create POs from OEPOGNVD* Create POs from RequisitionsPOHSTH Purchase HistoryPOHSTL Purchase History DetailPOINAHO Invoice Audit Headers Optional FieldsPOINALO Invoice Audit Lines Optional FieldsPOINASO Invoice Audit Costs Optional FieldsPOINVAH Invoice Audit HeadersPOINVAL Invoice Audit LinesPOINVAQ Invoice Audit Prorate LinesPOINVAS Invoice Audit CostsPOINVC Invoice CommentsPOINVD Invoice Cost DistributionsPOINVE* Invoice Posting Cost DistributionsPOINVF* Invoice Day-end Cost DistributionsPOINVH1 Invoices (part 1 of headers)POINVH2 Invoices (part 2 of headers)POINVHO Invoices Optional FieldsPOINVI* Invoice PostingsPOINVJ* Invoice Day EndPOINVL Invoice LinesPOINVLL Invoice Lines Lots

POINVLO Invoice Lines Optional FieldsPOINVLS Invoice Lines SerialsPOINVM* Invoice Posting LinesPOINVML* Invoice Posting Lines LotsPOINVMS* Invoice Posting Lines SerialsPOINVN* Invoice Day End LinesPOINVP Invoice Payment SchedulesPOINVR Invoice ReceiptsPOINVS Invoice Additional CostsPOINVSO Invoice Additional Costs Optional FieldsPOINVT* Invoice Posting Cost LinesPOINVU* Invoice Day End Additional CostsPOLINEZ* Generic Line DataPOMSG E-mail MessagesPOOFD Optional FieldsPOOFH Optional Field LocationsPOOPT Purchase Orders OptionsPOPLAT Purchase Order TemplatesPOPOAHO Purchase Order Audit Headers Optional FieldsPOPOALO Purchase Order Audit Lines Optional FieldsPOPOGH* Create POs HeaderPOPOGHO* Create POs Header Optional FieldsPOPOGL* Create POs DetailPOPOGLO* Create POs Detail Optional FieldsPOPORAH Purchase Order Audit HeadersPOPORAL Purchase Order Audit LinesPOPORC Purchase Order CommentsPOPORH1 Purchase Orders (part 1 of headers)POPORH2 Purchase Orders (part 2 of headers)POPORHO Purchase Orders Optional FieldsPOPORI* Purchase Order PostingsPOPORJ* Purchase Order Day-endsPOPORL Purchase Order LinesPOPORLO Purchase Order Lines Optional FieldsPOPORM* Purchase Order Posting LinesPOPORN* Purchase Order Day-end Lines

POPORR Purchase Order RequisitionsPOPRXC* Line Cost Proration DetailsPOPRXH* Cost Proration HeadersPOPRXL* Cost Proration DetailsPOPRXP* Line Cost Proration DetailsPORCAHO Receipt Audit Headers Optional FieldsPORCALO Receipt Audit Lines Optional FieldsPORCASO Receipt Audit Costs Optional FieldsPORCPAH Receipt Audit HeadersPORCPAL Receipt Audit LinesPORCPAQ Receipt Audit Prorate LinesPORCPAS Receipt Audit CostsPORCPC Receipt CommentsPORCPD Receipt Cost DistributionsPORCPE* Receipt Posting Cost DistributionsPORCPF* Receipt Day-end Cost DistributionsPORCPH1 Receipts (part 1 of headers)PORCPH2 Receipts (part 2 of headers)PORCPHO Receipts Optional FieldsPORCPI* Receipt PostingsPORCPJ* Receipt Day EndPORCPL Receipt LinesPORCPLF Receipt FAS DetailsPORCPLL Receipt Lines LotsPORCPLO Receipt Lines Optional FieldsPORCPLS Receipt Lines SerialsPORCPM* Receipt Posting LinesPORCPML* Receipt Posting Lines LotsPORCPMS* Receipt Posting Lines SerialsPORCPN* Receipt Day End LinesPORCPR Receipt Purchase OrdersPORCPS Receipt Additional CostsPORCPSO Receipt Additional Costs Optional FieldsPORCPT* Receipt Posting Additional CostPORCPU* Receipt Day End Additional CostPORCPV Receipt Vendors

PORCPVO Receipt Vendors Optional FieldsPOREAHO Return Audit Headers Optional FieldsPOREALO Return Audit Lines Optional FieldsPORETAH Return Audit HeadersPORETAL Return Audit LinesPORETAQ Return Audit Prorate LinesPORETAS Return Audit CostsPORETC Return CommentsPORETH1 Returns (part 1 of headers)PORETH2 Returns (part 2 of headers)PORETHO Returns Optional FieldsPORETI* Return PostingsPORETJ* Return Day EndPORETL Return LinesPORETLL Return Lines LotsPORETLO Return Lines Optional FieldsPORETLS Return Lines SerialsPORETM* Return Posting LinesPORETML* Return Posting Lines LotsPORETMS* Return Posting Lines SerialsPORETN* Return Day End LinesPORQNC Requisition CommentsPORQNH1 Requisitions (part 1 of headers)PORQNH2 Requisitions (part 2 of headers)PORQNHO Requisitions Optional FieldsPORQNL Requisition LinesPORQNLO Requisition Lines Optional FieldsPORQNLV Requisition VendorsPOSTTL StatisticsPOVIA Ship-Via AddressesPOVUMB Vendor Contract Cost Base UnitsPOVUMS Vendor Contract Cost Sales UnitsPOVUPR Vendor Contract CostsPOVUTX Vendor Contract Included Taxes

No change.

No change.

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_Purchase_Orders/v6.0"Category: Accpac 6.0



< Documentation:Technical Information for Project and Job Costing


Table DescriptionPMACCT Account SetsPMADJD Adjustments DetailPMADJDA Adjustments Audit DetailPMADJDAO Adjustment Audit Detail OFPMADJDO Adjustment Detail Optional FieldPMADJH AdjustmentsPMADJHA Adjustments AuditPMADJHAO Adjustment Audit Optional FieldPMADJHO Adjustment Optional FieldPMAGET* Age WIP Report Temporary FilePMAIAT* AIA Report Temporary FilePMAIAST* AIA Superview Temporary FilePMAP* A/P SuperviewPMAPO* A/P Optional FieldPMAR* A/R SuperviewPMARO* A/R Optional FieldPMBUDA Budget AuditPMBUDD Budget DetailPMBUDH Budget HeaderPMBWC Billing Worksheet CustomerPMBWD Billing Worksheet DetailPMBWDO Billing Detail Optional FieldPMBWH Billing WorksheetPMBWHO Billing Optional Field

PMCATGT Contract CategoriesPMCATGTO Category Optional FieldPMCED Cost Entries DetailPMCEDA Cost Entries Detail AuditPMCEDAO Cost Entries Detail Audit Opt.PMCEDO Cost Entries Detail Optional FiePMCEH Cost Entries HeaderPMCEHA Cost Entries AuditPMCEHAO Cost Entries Audit Optional FldPMCEHO Cost Entries Optional FieldPMCHARG Charge CodesPMCHARGD Charges Codes Detail ViewPMCHARGO Charges Optional FieldPMCHGDA Charges Audit DetailPMCHGDAO Charges Audit Detail Opt. FieldPMCHGDO Charges Detail Optional FieldPMCHGHA Charges AuditPMCHGHAO Charges Audit Optional FieldPMCHGHO Charges Optional FieldPMCHNDA Revise Estimates Audit DetailPMCHNGD Revise Estimates DetailPMCHNGH Revise EstimatesPMCHNHA Revise Estimates AuditPMCHRGD Charges DetailPMCHRGH ChargesPMCLOSE G/L Closing EntriesPMCOCA Committed Costs AuditPMCONO Contract Optional FieldPMCONTS ContractsPMCONTT ContractsPMCOST Cost TypesPMCP* Canadian Payroll Superview !PMCPO* C/P Optional Field !PMCTG Cost CategoriesPMCTGD Categories Detail ViewPMCTGO Category Optional Fields

PMEQDAO Equipment Audit Detail OFPMEQDO Equipment Detail Optional FieldPMEQHAO Equipment Audit Optional FieldPMEQHO Equipment Optional FieldPMEQIPD Equipment DetailPMEQIPH EquipmentPMEQMT EquipmentPMEQMTD Equipment Detail ViewPMEQMTO Equipment Optional FieldsPMEQPDA Equipment Audit DetailPMEQPHA Equipment AuditPMGLIT G/L IntegrationPMIC* IC SuperviewPMICO* I/C Optional FieldPMMATD Material Usage DetailPMMATDL Material Usage Detail Lot NumberPMMATDO Material Usage Detail Opt. FieldPMMATDS Material Usage Detail Serial NumberPMMATH Material UsagePMMATHO Material Usage Optional FieldPMMATRD Material Returns DetailPMMATRDL Material Return Detail Lot NumberPMMATRDO Material Return Detail Opt. FldPMMATRDS Material Return Detail Serial NumberPMMATRH Material ReturnPMMATRHO Material Return Optional FieldPMMIEXP Miscellaneous ExpensesPMMIEXPD Misc. Expenses Detail ViewPMMIEXPO Miscellaneous Expenses OptionalPMMTAD Material Allocation DetailPMMTADA Material Allocation DetailPMMTADAO Material Allocation Detail OptionalPMMTADO Material Allocation Detail OptionalPMMTAH Material AllocationPMMTAHA Material Allocation Optional FieldPMMTAHAO Material Allocation Optional Field

PMMTAHO Material Allocation OptionalPMOBD Opening Balances DetailPMOBDA Opening Balances Audit DetailPMOBH Opening BalancesPMOBHA Opening Balances AuditPMOE* O/E Superview NEW!PMOEO* O/E Optional Field NEW!PMOFD Optional Fields DetailPMOFH Optional Fields HeaderPMOHEXP Overhead CodesPMOHEXPD Overhead Codes Detail ViewPMOHEXPO Overhead Optional FieldsPMOPT OptionsPMOPT2 OptionsPMOPT3 OptionsPMOPT4 OptionsPMPERR Posting ErrorsPMPO* P/O SuperviewPMPOO* P/O Optional FieldPMPROJ Project CodePMPROJO Project Optional FieldsPMPROJS ProjectsPMPROJSO Project Optional FieldPMPROJT ProjectsPMRES Contract ResourcesPMRESC Contract Resource CategoriesPMRESO Resource Optional FieldPMREVDAO Revise Estimates Audit Detail OFPMREVDO Revise Estimates Detail Opt. FldPMROD Reopen Worksheet DetailPMRODA Reopen Worksheet Detail AuditPMRODD Reopen Worksheet AccountsPMRODDA Reopen Worksheet Accounts AuditPMRODO Reopen Detail Optional FieldPMRODOA Reopen Detail OF AuditPMROH Reopening Projects Worksheet

PMROHA Reopen Worksheet Header AuditPMRWD RR Worksheet DetailPMRWDA RR Worksheet Detail AuditPMRWDAO RR Detail OF AuditPMRWDD RR Worksheet AccountsPMRWDDA RR Worksheet Accounts AuditPMRWDO RR Detail Optional FieldPMRWH Revenue Recognition WorksheetPMRWHA RR Worksheet Header AuditPMSEG SegmentsPMSEGV Segment CodesPMSTAFF EmployeePMSTAFFD Employee Detail ViewPMSTAFFO Employee Optional FieldsPMSTRUC Contract StructuresPMSUBCN SubcontractorsPMSUBCND Subcontractors Detail ViewPMSUBCNO Subcontractor Optional FieldsPMTIMDA Timecard Time Detail AuditPMTIMDAO Timecard Audit Detail OFPMTIMDO Timecard Detail Optional FieldPMTIMEA Timecard Expense Detail AuditPMTIMEAO imecard Audit Expense OFPMTIMED Timecard Time DetailPMTIMEE Timecard Expense DetailPMTIMEH TimecardPMTIMEO Timecard Expense Optional FieldPMTIMET Timecard Time TotalsPMTIMHA Timecard AuditPMTIMHAO Timecard Audit Optional FieldPMTIMHO Timecard Optional FieldPMTIMTA Timecard Time AuditPMTRAN Contract TransactionsPMTRANO Transaction Optional FieldPMUP* US Payroll SuperviewPMUPO* U/P Optional Field

PMURD Update Retainage DetailPMURDA Update Retainage Detail AuditPMURH Update RetainagePMURHA Update Retainage Audit

No change.

No change.

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_Project_and_Job_Costing/v6.0"Category: Accpac 6.0



< Documentation:Technical Information for Canadian Payroll


Field DescriptionCPACCO Accrual carry-over log fileCPAUDA Assign earn/ded auditCPAUDAB Assign earn/ded audit billingCPAUDAD Assign earn/ded audit detailsCPAUDE Update earn/ded auditCPAUDED Update earn/ded audit detailsCPAUDM Delete inactive records auditCPAUDMH Delete audit transaction detailsCPAUDMI Delete audit inactive detailsCPAUDT Update taxes auditCPAUDTD Update taxes audit detailsCPCALA* Cost center allocation view (selections made when calculating payroll)CPCHDO Cheque details optional fieldsCPCHHO Cheque header optional fieldsCPCHJB Cheque job detailsCPCHJO Cheque jobs optional fields valuesCPCHKC Cheque comment informationCPCHKD Cheque details (employee details by period end date)CPCHKE Cheque EFT detailsCPCHKH Cheque header (employee totals by period end date)CPCHKL* Cheque selection listCPCHKO Cheque history run optional fieldsCPCHKR Options of field choices being selected during calculationCPCHKS Cheque printing summary information (cleared when printing Cheques next time)

CPCLAS Class codesCPCLCO* Calculate payroll optional fieldsCPCOBK Company bank EFT infoCPCPRJ* Certified payroll report jobs (US Payroll)CPDIST Pay factors and taxes G/L distributionsCPDTLB Earnings billing detailCPDTLM Earning/deduction master listCPDTLO Earning/deductions optional fieldsCPEDUP* Find duplicate SINCPELST* EFT combine file listCPEMBK Employee bank EFT infoCPEMDB Employee billing detailsCPEMDO Employee earning/deductions optional fieldsCPEMPC Employee notesCPEMPD Employee pay factorsCPEMPL Employee master listingCPEMPO Employee optional fieldsCPEMPT Employee taxesCPEMRGD EFT files combine setup detailCPEMRGH EFT files combine setup headerCPEMTF Employee tax information (from TD1, TP-1015.3-V, and other applicable forms)CPEMTO Employee tax optional fieldsCPEMULD EFT combine file detailCPEMULH EFT combine file headerCPEREG EFT run history headerCPESLD Employee selection list membersCPESLH Listing of employee selection listsCPETRN EFT run history detailsCPEUIC Employee unemployment insurance historyCPGLBM Pay factor and tax global change view (selections made while entering)CPGLDD* G/L acct desc report listCPGLREF G/L reference integrationCPHDAU Employee history audit details (lists all entries even if changed)CPHDOA History audit detail opt fieldsCPHHAU Employee history audit header (lists running net pay value of above file)CPHHOA History audit header opt fields

CPINCL Lists pay factors and taxes included in tax and pay factor definitionsCPMCDO Manual cheque detail optional fieldsCPMCDT Manual cheque detail (cleared when manual Cheque is posted)CPMCHD Manual cheque header (cleared when manual Cheque is posted)CPMCHO Manual cheque header optional fieldsCPMCJB Manual cheque job detailsCPMCJO Manual cheque jobs opt fieldsCPOFD Optional field detailsCPOFH Optional field headerCPOPTS C/P optionsCPOTSC Overtime schedulesCPPCKD* Temporary file used for the printing of Cheque detailsCPPCKH* Temporary file used for the printing of header informationCPPMCO* Process manual cheque optional fieldsCPSHFB Shift differential billing detailCPSHFD Shift differential detailCPSHFT Shift differential schedulesCPSTAT Payroll status information (last posting sequence number, and so forth)CPTCDO Timecard detail optional fieldsCPTCDT Timecard detailsCPTCHD Timecard headerCPTCHO Timecard header optional fieldsCPTCJB Timecard job detailsCPTCJO Timecard jobs optional field valuesCPTXMO Taxes optional fieldsCPTXMS Tax masterCPUSLD User selection list detailCPUSLH User selection listsCPUTCD Employee timecards detailsCPUTCH Employee timecards headerCPUTDO Employee timecard detail optional fieldsCPUTHO Employee timecard header optional fieldsCPUTJB Employee timecard job detailsCPUTJO Employee TC jobs opt field valuesCPWCCD Workers' compensation codes by provinceCPWCCH Workers' compensation code province configurations

CPWRKC Work classification codesCPXCPT Payroll calculation exceptionsCPYTDS Employee year-to-date summariesRRSTRT Restart table

No change.

No change.

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_Canadian_Payroll/v6.0"Category: Accpac 6.0



< Documentation:Technical Information for Canadian Payroll Tax

Field DescriptionCTR1PD T4 InformationCTROED Record of Employment DetailCTROEH Record of Employment HeaderCTT4PD Paper T4 InformationCTUTDA Update TD1 Claim AuditCTUDAD Update TD1 Claim Audit Details

No change.

No change.

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_Canadian_Payroll_Tax/v6.0"Category: Accpac 6.0



< Documentation:Technical Information for US Payroll


Field DescriptionUPACCO Accrual carry-over log fileUPAUDA Assign earn/ded auditUPAUDAB Assign earn/ded audit billingUPAUDAD Assign earn/ded audit detailsUPAUDE Update earn/ded auditUPAUDED Update earn/ded audit detailsUPAUDM Delete inactive records auditUPAUDMH Delete audit transaction detailsUPAUDMI Delete audit inactive detailsUPAUDT Update taxes auditUPAUDTD Update taxes audit detailsUPCALA* Cost center allocation view (selections made when calculating payroll)UPCHDO Check details optional fieldsUPCHHO Check header optional fieldsUPCHJB Check job detailsUPCHJO Check jobs optional fields valuesUPCHKC Check comment informationUPCHKD Check details (employee details by period end date)UPCHKE Check EFT detailsUPCHKH Check header (employee totals by period end date)UPCHKL* Check selection listUPCHKO Check history run optional fieldsUPCHKR Options of field choices being selected during calculationUPCHKS Check printing summary information (cleared when printing checks next time)

UPCLAS Class codesUPCLCO* Calculate payroll optional fieldsUPCOBK Company bank EFT infoUPCPRJ* Certified payroll report jobsUPDIST Pay factors and taxes G/L distributionsUPDTLB Earnings billing detailUPDTLM Earning/Deduction master listUPDTLO Earning/deductions optional fieldsUPEDUP* Find duplicate SSNUPELST* EFT combine file listUPEMBK Employee bank EFT infoUPEMDB Employee billing detailsUPEMDO Employee earning/deductions optional fieldsUPEMPC Employee notesUPEMPD Employee pay factorsUPEMPL Employee master listingUPEMPO Employee optional fieldsUPEMPT Employee taxesUPEMRGD EFT files combine setup detailUPEMRGH EFT files combine setup headerUPEMTF Employee tax information (FIT and SIT filing information)UPEMTO Employee tax optional fieldsUPEMULD EFT combine file detailUPEMULH EFT combine file headerUPEREG EFT run history headerUPESLD Employee selection list membersUPESLH Listing of employee selection listsUPETRN EFT run history detailsUPEUIC Employee unemployment insurance historyUPGLBM Pay factor and tax global change view (selections made while entering)UPGLDD* G/L acct desc report listUPGLREF G/L reference integrationUPHDAU Employee history audit details (lists all entries even if changed)UPHDOA History audit detail opt fieldsUPHHAU Employee history audit header (lists running net pay value of above file)UPHHOA History audit header opt fields

UPINCL Lists pay factors and taxes included in tax and pay factor definitionsUPMCDO Manual check detail optional fieldsUPMCDT Manual check detail (cleared when manual check is posted)UPMCHD Manual check header (cleared when manual check is posted)UPMCHO Manual check header optional fieldsUPMCJB Manual check job detailsUPMCJO Manual check jobs opt fieldsUPOFD Optional field detailsUPOFH Optional field headerUPOPTS U/P optionsUPOTSC Overtime schedulesUPPCKD* Temporary file used for the printing of check detailsUPPCKH* Temporary file used for the printing of header informationUPPMCO* Process manual check optional fieldsUPSHFB Shift differential billing detailUPSHFD Shift differential detailUPSHFT Shift differential schedulesUPSTAT Payroll status information (last posting sequence number, and so forth)UPTCDO Timecard detail optional fieldsUPTCDT Timecard detailsUPTCHD Timecard headerUPTCHO Timecard header optional fieldsUPTCJB Timecard job detailsUPTCJO Timecard jobs optional field valuesUPTXMO Taxes optional fieldsUPTXMS Tax masterUPUSLD User selection list detailUPUSLH User selection listsUPUTCD Employee timecards detailsUPUTCH Employee timecards headerUPUTDO Employee timecard detail optional fieldsUPUTHO Employee timecard header optional fieldsUPUTJB Employee timecard job detailsUPUTJO Employee TC jobs opt field valuesUPWCCD Workers' compensation codesUPWCCH Workers' compensation code master

UPWRKC Work classification codesUPXCPT Payroll calculation exceptionsUPYTDS Employee year-to-date summariesPRRSTRT Restart table

No change.

No change.

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_US_Payroll/v6.0"Category: Accpac 6.0



< Documentation:Technical Information for US Payroll Tax


2.1 Changes in Version 6.0D2.2 Changes in Version 6.0B

3 Report Changes

Field DescriptionUTAULT Local tax update audit headerUTAULTD Local tax update audit detailUTESID Employee suppl. info detailsUTESIH Employee suppl. info headerUTI941 941 informationUTLCTX Local Tax Repository TableUTW2PD Paper W-2 information

Changes in Version 6.0D

UTESID:Added the following field:

FAMILYSTAT, Family Status

UTESIH:Added the following field:

FAMILYSTAT, Family Status

UTI941:Added the following field:

UNRPTTIPS, Tax due on unreported tipsRemoved the follwing fields:

HIRE1NUM, No. of 1st paid exempt employeesHIREQNUM, No. of qtr paid exempt employeesHIREQWAGE, Exempt wages/tips paidHIREPNUM, No.of Mar.19-31 paid exem. emplsHIREPWAGE, Exempt wages/tips Mar.19-31HIREQTAX, Tax on exempt wageHIREPTAX, Tax on 19-31 exempt wageSSRPCNT, Employer Soc. Sec. Tax %

Changes in Version 6.0B

UTESID:Added the following fields:

LOCALCODE1, School District Code 1LOCALTAX1, Local Tax ID 1LOCALCODE2, School District Code 2LOCALTAX2, Local Tax ID 2LOCALCODE3, School District Code 3LOCALTAX3, Local Tax ID 3LOCALCODE4, School District Code 4LOCALTAX4, Local Tax ID 4LOCALCODE5, School District Code 5LOCALTAX5, Local Tax ID 5

UTESIH:Added the following fields:

LOCALCODE, School District CodeLOCALTAX, Local Tax ID

UT941 reports changed due to tax update.

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_US_Payroll_Tax/v6.0"Category: Accpac 6.0




Table DescriptionYPMID Merchant IDsYPPMTINF Payment InfoYPTRAN Transaction Info

No change.

No change.

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_Payment_Processing/v6.0"Category: Accpac 6.0



< Documentation:Technical Information for G/L Consolidations


Table DescriptionZCEAUD Export auditsZCESPD Export setup detailsZCESPH Export setup headersZCETBD* Temporary export for budgetsZCETPS* Temporary export by posting sequencesZCIAUD Import auditsZCIMPT* Import optionsZCIUMN Import unit maintenanceZCMAPT Mapping tables detailsZCRSTRT* Restart dataZCSEGS Segment numbers SubstitutionZCSEQS Sequence numbersZCXMAP Mapping tables

No change.

No change.

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_G/L_Consolidations/v6.0"Category: Accpac 6.0


< Documentation:Technical Information for Intercompany Transactions

1 Data Tables1.1 If Accounts Payable is Active1.2 If General Ledger is Active

2 Database Changes3 Report Changes


Table DescriptionZIAPDSD Distribution set detailsZIAPDSH Distribution set headersZIAPTAX Expensed Separately Tax AccountsZIGLAMF Company G/L AccountsZIGLPS1* Temporary data for ICT G/L posting. Populated by ZIGLPST.ZILARC* Temporary data for G/L accounts reconciliation.ZIORGS Company informationZIPROS* Temporary data for company information.ZIROUTD Route detailsZIROUTH Route headersZIRSTRT Restart informationZISTP OptionsZIUNPSP* Temporary data for printing unposted batches. Populated by ZIUNPST.ZIUNPST* Temporary data for printing unposted batches.

If Accounts Payable is Active

Table DescriptionAPP01 AP Company optionsAPP02 AP Invoice optionsAPIBC AP Invoice batchesAPIBD AP Invoice detailsAPIBDA AP Invoice detail FAS fieldsAPIBDO AP Invoice detail optional fieldsAPIBH AP InvoicesAPIBHO AP Invoice optional fieldsAPIBS AP Invoice payment schedulesAPIBT AP Invoice detail commentsAPPJAID AP Posting Journal generated remote company AP detailsAPPJAIH AP Posting Journal generated remote company AP headersAPPJD AP Posting Journal detailsAPPJDO AP Posting Journal detail optional fieldsAPPJGID AP Posting Journal generated GL detailsAPPJH AP Posting Journal headersAPPJHO AP Posting Journal header optional fieldsAPPJS AP Posting Journal sequencesAPPTER AP Posting Journal error messages

If General Ledger is Active

Table DescriptionGL01 GL OptionsGLBCTL GL Journal Entry batchesGLJEC GL Journal Entry commentsGLJED GL Journal Entry detailsGLJEH GL Journal Entry headersGLPERR GL Posting Journal error messagesGLPJC GL Posting Journal commentsGLPJD GL Posting Journal detailsGLPJID GL Posting Journal generated remote company GL detailsGLPJIH GL Posting Journal generated remote company GL headers

No change.

No change.

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_Intercompany_Transactions/v6.0"Category: Accpac 6.0



< Documentation:Technical Information for Return Material Authorization

Table DescriptionRAAUT Authorization CodesRABOMD RMA BOM DetailsRACOIN RMA Detail Comments/InstructionsRACOMD RMA Kitting DetailsRACOMDS RMA Kitting Serial NumbersRACOMDL RMA Kitting Lot NumbersRADET Return Material Authorizations DetailsRADETO RMA Detail Optional FieldsRAEXT External StatusRAFAU Fault CodesRAHEAD Return Material AuthorizationsRAHEADO RMA Header Optional FieldsRAINT Workflow StatusRAITEM RMA Item PolicyRALOTRA RMA Lot NumbersRAOFH RMA Optional Field LocationsRAOFD RMA Optional FieldsRAOPT RMA Setup OptionsRAREP Repair AgentRASELRA RMA Serial NumbersRATEMPL RMA Templates

RATEMPL: added field SWACTIVE

No change.

Retrieved from "http://dppwiki.accpac.com/wiki/Documentation:Technical_Information_for_Return_Material_Authorization/v6.0"Category: Accpac 6.0


sage 300 erp 6.0 technical information · 4/6/2011 · csopt optional tables csoptcc optional...

Documents