Sage 300 View Documentor Online

A fully searchable Sage 300 View Doc on the web

Views

ID Name Description
AP0001 APP01 Company Options View
AP0002 APP02 Invoicing Options View
AP0003 APP03 Payment and Aging Options View
AP0004 APP04 Integration Options View
AP0005 APRDC Distribution Codes View
AP0006 APRAS Account Sets View
AP0007 APCLX 1099 / CPRS Codes View
AP0008 APDSD Distribution Set Details View
AP0009 APDSH Distribution Sets View
AP0010 APPTP Payment Codes View
AP0011 APRTB Terms Payment Schedule View
AP0012 APRTA Terms View
AP0013 APCCS 1099 / CPRS Amounts View
AP0014 APVCM Vendor Comments View
AP0015 APVEN Vendors View
AP0016 APVGR Vendor Groups View
AP0017 APVGS Vendor Group Statistics View
AP0018 APVNR Remit-To Locations View
AP0019 APVSM Vendor Statistics View
AP0020 APIBC Invoice Batches View
AP0021 APIBH Invoices View
AP0022 APIBD Invoice Details View
AP0023 APIBS Invoice Payment Schedules View
AP0024 APIBT Invoice Detail Comments View
AP0025 APOBL Documents View
AP0026 APOBS Document Sched. Payments View
AP0027 APOBP Document Payments View
AP0029 APPYM Posted Payments View
AP0030 APBTA Payment and Adjustment Batches View
AP0031 APTCR Payments/Adjustments View
AP0032 APTCN Miscellaneous Payments View
AP0033 APTCP Applied Payments View
AP0034 APTCU Adjustment G/L Distributions View
AP0035 APSLH Selection Criteria Header View
AP0036 APSLD Selection Criteria Details View
AP0037 APTRK Payment G/L Distributions View
AP0038 APPTER Posting Error Messages View
AP0039 APIVPT Post Invoices View
AP0040 APPYPT Post Payments and Adjustments View
AP0041 APUNGL Revaluation View
AP0042 APGLTR Create G/L Batch View
AP0043 APAGE Age Documents View
AP0044 APYREN Process Year End View
AP0045 APINTCK Integrity Checker View
AP0047 APSTAT Update Statistics View
AP0048 APPOOP Create Open Document List View
AP0049 APPREN Clear Fully Paid Documents View
AP0050 APPGCM Clear Vendor Comments View
AP0051 APPGST Clear Statistics View
AP0052 APPGIA Delete Inactive Records View
AP0054 APPYRV Return Payments View
AP0055 APBPPU Update Print Status View
AP0056 APSYGN Generate System Batch View
AP0057 APCTRL Control Payments View
AP0058 APCHKS Print Checks View
AP0059 APBCTU Clear Deleted and Posted Batches View
AP0060 APADV Payment Advices View
AP0061 APRSTRT Restart View
AP0062 APDLDN AP Drill Down View
AP0063 APRVL Revaluation Details View
AP0064 APRPH Recurring Payables View
AP0065 APRPD Recurring Payable Details View
AP0066 APRCUR Create Recurring Payable Batch View
AP0067 APDDDR AP Drill Down Driver View
AP0068 APSCHED Scheduler Interface View
AP0090 APBAL Company Balance View
AP0100 APINIT Accounts Payable Activation View
AP0110 APDOCS Documents View
AP0111 APITN 1099 / CPRS Amount Checking View
AP0112 APCPRSX T5018 (CPRS) Electronic Filing View
AP0120 APMSG E-mail Messages View
AP0121 APGLREF G/L Reference Integration View
AP0125 APAGED Aged Documents View
AP0135 APVCMD Vendor Comment Details View
AP0136 APCMMTP Comment Types View
AP0137 APATB Aged Payable Porlet Processor View
AP0138 APDPO Days Payable Outstanding View
AP0139 APP05 Vendor Options View
AP0170 APTCC Advance Credits View
AP0171 APOBLJP Document Detail Payments View
AP0180 APIBDA Invoice Detail Sage Fixed Assets View
AP0181 APRVLLOG Revaluation History View
AP0200 APOBLJ Open Document Details View
AP0202 APPMRES Job Resource Validation View
AP0204 APJTR Job Costing Transactions View
AP0300 APIRTNG Create Retainage Document Batch View
AP0310 APAGERTG Age Retainage Documents View
AP0311 APRTG Retainage Open Documents View
AP0401 APIBDO Invoice Detail Optional Fields View
AP0402 APIBHO Invoice Optional Fields View
AP0403 APOBLO Open Document Optional Fields View
AP0404 APRPDO Recurring Payable Detail Fields View
AP0405 APRPHO Recurring Payable Optional Field View
AP0406 APTCRO Payment/Adjustment Optional Fiel View
AP0407 APVENO Vendor Optional Field Values View
AP0408 APVGRO Vendor Group Optional Field Valu View
AP0409 APVNRO Remit-To Location Optional Field View
AP0410 APRVLO Revaluation Optional Fields View
AP0411 APSLHO Selection Criteria Opt. Fields View
AP0420 APSLVEN Selected Vendors View
AP0421 APSELECT Select Vendors View
AP0500 APOFD Optional Fields View
AP0501 APOFH Optional Field Locations View
AP0502 APOFCMD AP Optional Field Callbacks View
AP0510 APPJD Posting Journal Details View
AP0511 APPJH Posting Journal Entries View
AP0512 APPJS Posting Journals View
AP0513 APPJDO Posting Journal Detail Optional View
AP0514 APPJHO Posting Journal Entry Optional F View
AP0515 APOBLJO Open Doc. Detail Optional Fields View
AP0516 APPJAIH Posting Journal Generated AP Ent View
AP0517 APPJAID Posting Journal Generated AP Det View
AP0519 APPJGID Posting Journal Generated GL Det View
AP0949 APVSYR Yearly Vendor Statistics View
AP0950 APVGYR Yearly Vendor Group Statistics View
AP0951 APVSPR Yearly Vendor Statistics View
AP0952 APVGPR Vendor Group Statistics View
AR0001 ARR01 Company Options View
AR0002 ARR02 Invoicing Options View
AR0003 ARR03 Receipt and Adjustment Options View
AR0004 ARR04 Statement Processing Options View
AR0005 ARR05 Customer and Ship-To Options View
AR0006 ARR06 G/L Integration Options View
AR0008 ARDUN Dunning Messages View
AR0009 ARITD Item Pricing View
AR0010 ARITH Items View
AR0011 ARITT Item Tax Classes View
AR0012 ARPTP Payment Codes View
AR0013 ARRAS Account Sets View
AR0014 ARRBC Billing Cycles View
AR0015 ARRDC Distribution Codes View
AR0016 ARRTA Terms Codes View
AR0017 ARRTB Terms Payment Schedules View
AR0018 ARSAP Salespersons View
AR0019 ARSVC Interest Rates by Currency View
AR0020 ARSVD Interest Profiles View
AR0021 ARCMM Customer Comments View
AR0022 ARCSM Customer Statistics View
AR0023 ARCSP Ship-To Locations View
AR0024 ARCUS Customers View
AR0025 ARGRO Customer Groups View
AR0026 ARGSM Customer Group Statistics View
AR0027 ARITS Item Statistics View
AR0028 ARNAT National Accounts View
AR0029 ARNSM National Account Statistics View
AR0030 ARSPS Salesperson Statistics View
AR0031 ARIBC Invoice Batches View
AR0032 ARIBH Invoices View
AR0033 ARIBD Invoice Details View
AR0034 ARIBS Invoice Payment Schedules View
AR0035 ARIBT Invoice Detail Comments View
AR0036 AROBL Documents View
AR0037 AROBS Document Sched. Payments View
AR0038 AROBP Document Payments View
AR0040 ARRRH Posted Receipts View
AR0041 ARBTA Receipt and Adjustment Batches View
AR0042 ARTCR Receipts/Adjustments View
AR0043 ARTCN Miscellaneous Receipts View
AR0044 ARTCP Applied Receipts/Adjustments View
AR0045 ARTCU Adjustment G/L Distributions View
AR0046 ARSIA Recurring Charges View
AR0047 ARSID Recurring Charge Details View
AR0048 ARIVPT Post Invoices View
AR0049 ARPYPT Post Receipts and Adjustments View
AR0050 ARINTR Create Interest Batch View
AR0051 ARWROF Create Write-Off Batch View
AR0052 ARUNGL Revaluation View
AR0053 ARGLTR Create G/L Batch View
AR0054 ARRRD Receipt G/L Distributions View
AR0055 ARAGE Age Documents View
AR0056 ARYREN Process Year End View
AR0057 ARINTCK Integrity Checker View
AR0059 ARRCUR Create Recurring Charge View
AR0060 ARSTAT Update Statistics View
AR0061 ARPOOP Create Open Document List View
AR0062 ARPTER Posting Error Messages View
AR0063 ARPREN Clear Fully Paid Documents View
AR0064 ARPGCM Clear Customer Comments View
AR0065 ARPGST Clear Statistics View
AR0066 ARPGIA Delete Inactive Record View
AR0067 ARBCTU Clear Deleted and Posted Batches View
AR0072 ARPYRV Reconcile Receipts/Payments View
AR0076 ARBPPU Update Print Status View
AR0077 ARSTMT Create Statements View
AR0078 ARRSTRT Restart View
AR0079 ARRVL Revaluation Details View
AR0080 ARDLDN AR Drill Down View
AR0081 ARURC Update Recurring Chrgs Instrns View
AR0082 ARURCP Process Update Recurring Chrgs View
AR0083 ARDDDR AR Drill Down Driver View
AR0084 ARSCHED Scheduler Interface View
AR0087 ARSPMI Set Prepayment Matching Invoice View
AR0088 AROBLJP Document Detail Payments View
AR0089 ARRVLLOG Revaluation History View
AR0090 ARBAL Company Balance View
AR0094 ARCMMTP Comment Types View
AR0095 ARUNPSTH Unposted Entries View
AR0096 ARUNPSTD Unposted Details View
AR0097 ARSLLST Select Lists View
AR0100 ARINIT Accounts Receivable Activation View
AR0110 ARSTRUN Reprint Statement Header View
AR0111 ARSTCUS Reprint Statement Customers View
AR0112 ARSTOBL Reprint Statement Customer Invoi View
AR0113 ARSTOBP Reprint Statement Customer Recei View
AR0114 ARSTNAT Reprint Statement NAT Customers View
AR0120 ARMSG E-mail Messages View
AR0125 ARAGED Aged Documents View
AR0130 ARDOCS Documents View
AR0135 ARCMMD Customer Comment Details View
AR0137 ARATB Aged Receivable Porlet Processor View
AR0138 ARDRO Days Receivable Outstanding Proc View
AR0139 ARPYM Payments View
AR0140 ARRFB Refund Batches View
AR0141 ARRFH Refund Entries View
AR0142 ARRFD Refund Details View
AR0143 ARRFHO Refund Optional Fields View
AR0145 ARRFDJ Refund Detail Jobs View
AR0146 ARGLREF G/L Reference Integration View
AR0150 ARRFPT Post Refunds View
AR0160 ARCBAL Customer Balances View
AR0170 ARTCC Advance Credits View
AR0180 ARLABEL Generate Labels View
AR0190 ARSLLBL Generated Labels View
AR0200 AROBLJ Open Document Details View
AR0202 ARPMRES Job Resource Validation View
AR0204 ARJTR Job Costing Transactions View
View
AR0211 ARCCRECD Create Credit Card Receipts Dtl View
AR0300 ARIRTNG Create Retainage Document Batch View
AR0310 ARAGERTG Age Retainage Documents View
AR0311 ARRTG Retainage Open Documents View
AR0400 ARCUSO Customer Optional Field Values View
AR0401 ARIBDO Invoice Detail Optional Fields View
AR0402 ARIBHO Invoice Optional Fields View
AR0403 AROBLO Open Document Optional Fields View
AR0404 ARSIDO Rec. Charge Detail Opt. Fields View
AR0405 ARSIAO Recurring Charge Optional Fields View
AR0406 ARTCRO Receipt/Adjustment Optional Fiel View
AR0407 ARPJD Posting Journal Details View
AR0408 ARPJH Posting Journal Entries View
AR0409 ARPJS Posting Journals View
AR0410 ARGROO Customer Group Optional Field Va View
AR0411 ARNATO National Account Optional Field View
AR0412 ARCSPO Ship-To Locations Optional Field View
AR0413 ARPJDO Posting Journal Detail Optional View
AR0414 ARPJHO Posting Journal Entry Optional F View
AR0415 ARRVLO Revaluation Optional Fields View
AR0420 ARSLCUS Selected customers View
AR0421 ARSELECT Select customers View
AR0450 ARPEND Calculate Document Pending Balan View
AR0460 ARADV Payment Advices View
AR0461 ARCHKS Print Checks View
AR0500 AROFD Optional Fields View
AR0501 AROFH Optional Field Locations View
AR0502 AROFCMD AR Optional Field Callbacks View
AR0503 AROFPD Function Parameters Detail View
AR0504 AROFPH Function Parameters Header View
AR0506 ARSTCUSO Customer Statement Optional Fiel View
AR0507 ARSTOBLO Statement Customer Invoice Optio View
AR0515 AROBLJO Open Doc. Detail Optional Fields View
AS0001 CSSEC Security Groups View
AS0002 CSAUTH User Authorizations View
AS0003 A4WUSER Users View
AS0004 A4WCUST Customization Directories View
AS0005 CSUICSH UI Cust. Profile Headers View
AS0006 CSUICST UI Cust. Profile Details View
AS0007 CSUSCST User UI Customizations View
AS0010 ASINTCHK Administrative Services Data Int View
AS0020 ASORGS Companies View
AS0021 ASRST Restart Records View
AS0022 ASSRSC Application Security Resources View
AS0023 ASINTPR Data Integrity SuperView View
AS0025 ASCOPY Database Dump/Load/Copy View
AS0030 ASACTIV Product Activation View
AS0034 ASACTLOG Activation Log View
View
AS0040 ASRPTH Custom Reports View
AS0050 ASWPCR Working Profile Custom Reports View
AS0051 ASCUSTH UI Customization Headers View
AS0052 ASCUSTD UI Customization Details View
AS0053 ASWPCST Working Profile UI Customization View
AS0060 CSPKGH Customization Package Header View
AS0061 CSPKGD Customization Package Detail View
AS0062 CSPKGASN Customization Package Assignment View
View
BK0001 BKACCT Banks View
BK0002 BKCUR Bank Currencies View
BK0003 BKTT Bank Distribution Codes View
View
View
View
BK0008 BKFORM Check Stocks View
BK0009 BKREG Bank Check Register View
BK0010 BKOPT Bank Options View
BK0011 BKJRNL Bank Posting Journal View
BK0012 BKJERR Bank Posting Error Journal View
View
View
View
BK0018 BKJZGL G/L Audit Summary View
BK0020 BKJCTL Bank Posting Journal Control View
BK0021 BKTNUM Bank Transaction Numbers View
View
BK0033 BKJTFR Transfer Audit View
BK0036 BKTFRH Transfers View
BK0100 BKDCHK Bank Services Integrity Check View
BK0101 BKPOST Bank Reconciliation Posting View
BK0102 BKRTRN Bank Reconciliation Returns View
BK0103 BKCLEAR Bank Reconciliation Clearing View
BK0104 BKDCI Bank Reconciliation View
BK0105 BKPROC Bank Process Control View
BK0107 BKPRFUN Bank Check Printing Functions View
BK0240 BKCCTYP Credit Card Types View
BK0370 BKDDDR BK Drill Down Driver View
View
View
BK0430 BKDLDN BK Drill Down View
BK0440 BKDISTD Bank Distribution Set Detail View
BK0445 BKDISTH Bank Distribution Set Header View
BK0450 BKENTH Bank Entries Header View
BK0460 BKENTD Bank Entries View
BK0465 BKEPOST Bank Transaction Entry Posting View
BK0470 BKGLREF Bank G/L Integration View
View
View
BK0645 BKJTFRD Transfer Audit Charge View
BK0650 BKJTRAND Bank Journal Transaction Details View
BK0655 BKJTRANH Bank Journal Transaction Header View
BK0660 BKJENTD Bank Entries Journal Detail View
BK0665 BKJENTH Bank Entries Journal Header View
BK0680 BKMATCH OFX Transaction Matching View
BK0765 BKPRDEP Bank Deposit Printing Functions View
View
BK0800 BKRECON Bank Transaction Entry Reconcili View
BK0820 BKRSTRT Bank Process Restart View
BK0835 BKTFRD Transfer Details View
BK0840 BKTRAND Bank Transaction Details View
BK0845 BKTRANH Bank Transaction Header View
BK0850 BKTRANS Bank Transaction Portal Supervie View
BK0855 BKTRANR Bank Transaction Reversals View
BK0860 BKTTX Bank Distribution Codes Tax Deta View
BK0870 BKUNMAT OFX Transactions View
BK0900 BKINIT Bank Services Activation View
BK0996 GENSTUB View
BK0997 GENSTUB View
BK0998 GENSTUB View
BK0999 GENSTUB View
BX0140 BXINIT Intelligence Reporting Activatio View
CS0001 CSCOM Company Profile View
CS0002 CSFSC Fiscal Calendars View
CS0003 CSCCD Currency Codes View
CS0004 CSCRT Rate Types View
CS0005 CSCRH Currency Tables View
CS0006 CSCRD Currency Rates View
CS0007 CSOPT Optional Tables View
CS0008 CSOPTH Optional Tables View
CS0009 CSDCHK Common Services Integrity Check View
CS0010 CSEUR Euro Conversion Rates View
CS0011 CSOPTFH Optional Fields View
CS0012 CSOPTFD Optional Field Values View
CS0013 CSOPTFP Optional Fields Processing Funct View
CS0014 CSOPTCM Opt. Fields Conversion Mapping View
CS0015 CSOPTCC Opt. Fields Conversion Creation View
CS0020 CSSEQN Sequence number dispenser View
CS0030 CSSKTB Schedules View
CS0032 CSSKAP Schedule Application Links View
CS0034 CSSKCB Schedules View
CS0036 CSSKID Schedules View
CS0040 CSPFLOW Process Flows View
CS0041 CSPFUTL Process Flow Utilities View
CS0050 CSCBSK View
CS0060 CSFSCST Fiscal Statuses View
View
CS0120 CSQRY View
CS0370 CSDDDR CS Drill Down Driver View
CS0900 CSINIT Common Services Activation View
GL0001 GLAMF Accounts View
GL0002 GLSRCE Source Codes View
GL0003 GLFISC Fiscal Sets View
GL0004 GLAIS Account Allocation Instructions View
GL0005 GLOPT General Ledger Options View
GL0006 GLJEH Journal Headers View
GL0007 GLJEC Journal Comments View
GL0008 GLBCTL Batches View
GL0009 GLBGT Account Budget Calculator View
GL0010 GLJED Journal Details View
GL0011 GLCFSC Compute Fiscal Set Comparison View
GL0012 GLAVC Account Valid Currencies View
GL0013 GLPPER Provisional Posting Errors View
GL0014 GLPPD Prov. Posting Journal Details View
GL0015 GLPERR Posting Errors View
GL0016 GLPJD Posting Journal Details View
GL0017 GLPJC Posting Journal Comments View
GL0018 GLPOST Posted Transactions View
GL0019 GLSJN Source Journal Profiles View
GL0020 GLRVAL Revaluation Codes View
GL0021 GLASV Segment Codes View
GL0022 GLABK Account Segments View
GL0023 GLABRX Structure Codes View
GL0024 GLYRM Period End Maintenance View
GL0025 GLCSL Consolidate Posted Transactions View
GL0026 GLYRN Create New Year View
GL0027 GLRVLU Currency Revaluation View
GL0028 GLPPC Prov. Posting Journal Comments View
GL0029 GLJAL Auto Allocation Processor View
GL0030 GLJPST Post Journal View
GL0031 FRFISC Financial Report Information View
GL0032 GLBCTU Batch Status View
GL0033 GLPJDU Posting Journal Update/Clear View
GL0034 GLINTCK Integrity Checker View
GL0038 GLPSTT Posted Transaction Totals View
GL0039 GLDRDN Drill Downs View
GL0040 GLRSTRT General Ledger Restart View
GL0041 GLREH Recurring Journal Headers View
GL0042 GLRED Recurring Entry Details View
GL0043 GLCRE Create Recurring Entries Batch View
GL0044 GLSCHED Scheduler Interface View
GL0045 GLCAMF Create Accounts View
GL0046 GLWAMF Preview Accounts View
GL0047 GLWAVC Preview A/C Valid Currencies View
GL0048 GLWCAS Preview Control A/C Subledgers View
GL0049 GLPAMF Create Accounts Input Criteria View
GL0050 FR2FISC FRFISC Helper View
GL0051 GLRJNL Create Reverse Entry View
GL0052 GLGSSEG Segment Permissions View
GL0053 GLGSACC Account Permissions View
GL0054 GLGSUSR Users View
GL0055 GLACGRP Account Groups View
GL0056 GLCHAGP Account Group-Sort Orders View
GL0057 GLACHD Rollup Groups View
GL0058 GLADSD Rollup Group Relationship View
GL0059 GLACHDU Rollup Group Processor View
GL0060 GLSCURI Source Currency Inq. Processor View
GL0061 GLRVNET Recognized Revaluation Restart View
GL0062 GLRVRAT Recognized Reval. Rate Restart View
GL0063 GLPACHD Rollup Member Preview View
GL0065 FRRAMF FR RollUP Tester View
GL0066 GLRPOST Rollup Posted Transactions View
GL0067 GLFSUM Financial Summary Processor View
GL0100 GLAMF Accounts View
GL0101 GLFISC Fiscal Sets View
GL0102 GLOPT General Ledger Options View
GL0103 GLAFS Account Fiscal Sets View
GL0104 GLRVL Revaluation Details View
GL0106 GLINIT General Ledger Activation View
GL0107 GLCAS Control Account Subledgers View
GL0108 GLPJIH Posting Journal ICT Generated He View
GL0109 GLPJID Posting Journal ICT Generated De View
GL0110 FRAMF Accounts View
GL0111 FRDRILL Drill Down From FR View
GL0400 GLAMFO Account Optional Fields View
GL0401 GLAMFTO Account Trans. Optional Fields View
GL0402 GLJEDO Journal Detail Optional Fields View
GL0403 GLREDO Recur. Entry Optional Fields View
GL0404 GLPJDO Posting Journal Optional Fields View
GL0405 GLPOSTO Posted Trans. Optional Fields View
GL0406 GLPPDO Prov. Post Journal Opt. Fields View
GL0407 GLWAMFO Account Optional Fields View
GL0408 GLWAMTO Account Trans. Optional Fields View
GL0409 GLJALO Auto Alloc. Optional Fields View
GL0410 GLRVLGO Reval. Dtls Gain Optional Flds View
GL0411 GLRVLLO Reval. Dtls Loss Optional Flds View
GL0500 GLOFD Optional Fields View
GL0501 GLOFH Optional Field Locations View
GL0502 GLOFCMD GL Optional Field Callbacks View
GP0099 GPDCHK G/L Services Integrity Checker View
GP0100 GPGLBB GL Subledger Transactions View
GP0110 GPGLBD GL Subledger Details View
GP0120 GPGLBH GL Subledger Entries View
GP0130 GPGLBO GL Subledger Detail Opt. Fields View
GP0140 GPRSTRT GL Subledger Restart View
GP0800 GPGLFMT Segment Substitution View
GP0900 GPINIT G/L Subledger Services Activatio View
GP0930 GPGLPE Transaction Transfer View
GP0950 GPGLPO Transaction Posting View
GP0999 GENSTUB View
View
View
View
View
TX0001 TXCLASS Tax Classes View
TX0002 TXAUTH Tax Authorities View
TX0003 TXGRP Tax Groups View
TX0004 TXRATE Tax Rates View
TX0005 TXAUDIT Tax Tracking Details View
TX0011 TXAUDH Tax Tracking View
TX0012 TXAUDD Tax Tracking Item Class View
TX0013 TXSTATEH Tax State Headers View
TX0014 TXSTATED Tax State Details View
TX0015 TXRCODE Tax Rate Codes View
TX0021 TXRSTRT Tax Services Restart View
TX0900 TXINIT Tax Services Activation View
TX0901 TXCALC Tax Calculation View
TX0902 TXMATX Tax Rate Matrix View
TX0903 TXCLEAR Tax Audit Clearing View
TX0904 TXALLOC Tax allocation View
TX0910 TXDCALC Tax Document Calculation View
TX0990 TXDCHK Tax Services Integrity Check View
ZC0001 ZCESPHV G/L Consol. Export Header View
ZC0002 ZCESPDV G/L Consol. Export Detail View
ZC0003 ZCMAPTV Mapping Table Details View
ZC0004 ZCETBDV Temporary Export For Budgets View
ZC0006 ZCIUMNV Import Unit Maintenance View
ZC0007 ZCEXPTV Export Parameters View
ZC0008 ZCIMPTV Import Options View
ZC0009 ZCEAUDV Export Audit View
ZC0010 ZCIAUDV Import Audit View
ZC0011 ZCSEQSV Sequence Numbers View
ZC0012 ZCXMAPV Mapping Tables View
ZC0013 ZCETPSV Temporary Posting Sequence View
ZC0014 ZCSEGSV Segment Number Substitution View
ZC0015 ZCINIT G/L Consolidation Activation View
ZC0016 ZCRSTRT Restart View

AP0021 - APIBH - Invoices

Compositions

using (HuAPConnection Connection = new HuAPConnection())
using (HuView APIBH = Connection.GetView("AP0021"))
using (HuView APIBC = Connection.GetView("AP0020"))
using (HuView APIBD = Connection.GetView("AP0022"))
using (HuView APIBDO = Connection.GetView("AP0401"))
using (HuView APIBS = Connection.GetView("AP0023"))
using (HuView APIBHO = Connection.GetView("AP0402"))
{
	APIBH.Compose(APIBC, APIBD, APIBS, APIBHO);
	APIBC.Compose(APIBH);
	APIBD.Compose(APIBH, APIBC, APIBDO);
	APIBDO.Compose(APIBD);
	APIBS.Compose(APIBH);
	APIBHO.Compose(APIBH);
	
	// Code Here
	
}

Indexes

  • 0 - Batch Number/Entry Number
    CNTBTCH,CNTITEM
  • 1 - Vendor Number/Document Number
    ORIGCOMP,IDVEND,IDINVC
  • 2 - Vendor Number/Total Distributed
    ORIGCOMP,IDVEND,AMTTOTDIST
  • 3 - Vendor Number/Document Date
    ORIGCOMP,IDVEND,DATEINVC

Fields

Field Name Type Size Precision Description Mask Index Attribute
CNTBTCH Decimal 5 0 Batch Number 1 RKEA
CNTITEM Decimal 4 0 Entry Number 2 RKEA
ORIGCOMP Char 6 0 Originator %-6N 155 EA
IDVEND Char 12 0 Vendor Number %-12C 3 REA
IDINVC Char 22 0 Document Number %-22C 4 REA
IDRMITTO Char 6 0 Remit-To Location %-6N 5 EA
TEXTTRX Int 2 0 Document Type 6 EA
IDTRX Int 2 0 Transaction Type 7 CEA
INVCSTTS Int 2 0 Reserved 8 E
ORDRNBR Char 22 0 Order Number %-22C 9 EA
PONBR Char 22 0 PO Number %-22C 10 EA
INVCDESC Char 60 0 Invoice Description 11 EA
SWPRTINVC Int 2 0 Reserved 12 E
INVCAPPLTO Char 22 0 Apply-to Document %-22C 13 EA
IDACCTSET Char 6 0 Account Set %-6N 14 EA
DATEINVC Date 5 0 Document Date 15 EA
DATEASOF Date 5 0 As of Date 16 EA
FISCYR Char 4 0 Fiscal Year %04D 17 CA
FISCPER Char 2 0 Fiscal Period %02D 18 CA
CODECURN Char 3 0 Currency Code %-3N 19 EA
RATETYPE Char 2 0 Rate Type %-2N 20 EA
SWMANRTE Int 2 0 Rate Overridden 21 EA
EXCHRATEHC Decimal 8 7 Exchange Rate 22 EA
ORIGRATEHC Decimal 8 7 Apply-to Exchange Rate 23 EA
TERMCODE Char 6 0 Terms %-6N 24 EA
SWTERMOVRD Int 2 0 Terms Overridden 25 EA
DATEDUE Date 5 0 Due Date 26 EA
DATEDISC Date 5 0 Discount Date 27 EA
PCTDISC Decimal 5 5 Discount Percentage 28 EA
AMTDISCAVL Decimal 10 3 Discount Amount Available 29 EA
LASTLINE Decimal 3 0 Number of Details 30 CEA
SWTAXBL Int 2 0 Taxable 31 CEA
SWCALCTX Int 2 0 Tax Amount Control 32 EA
CODETAXGRP Char 12 0 Tax Group %-12N 33 EA
CODETAX1 Char 12 0 Tax Authority 1 34 CEA
CODETAX2 Char 12 0 Tax Authority 2 35 CEA
CODETAX3 Char 12 0 Tax Authority 3 36 CEA
CODETAX4 Char 12 0 Tax Authority 4 37 CEA
CODETAX5 Char 12 0 Tax Authority 5 38 CEA
TAXCLASS1 Int 2 0 Tax Class 1 39 EA
TAXCLASS2 Int 2 0 Tax Class 2 40 EA
TAXCLASS3 Int 2 0 Tax Class 3 41 EA
TAXCLASS4 Int 2 0 Tax Class 4 42 EA
TAXCLASS5 Int 2 0 Tax Class 5 43 EA
BASETAX1 Decimal 10 3 Tax Base 1 44 EA
BASETAX2 Decimal 10 3 Tax Base 2 45 EA
BASETAX3 Decimal 10 3 Tax Base 3 46 EA
BASETAX4 Decimal 10 3 Tax Base 4 47 EA
BASETAX5 Decimal 10 3 Tax Base 5 48 EA
AMTTAX1 Decimal 10 3 Tax Amount 1 54 EA
AMTTAX2 Decimal 10 3 Tax Amount 2 55 EA
AMTTAX3 Decimal 10 3 Tax Amount 3 56 EA
AMTTAX4 Decimal 10 3 Tax Amount 4 57 EA
AMTTAX5 Decimal 10 3 Tax Amount 5 58 EA
AMT1099 Decimal 10 3 1099/CPRS Amount 67 EA
AMTDISTSET Decimal 10 3 Distribution Set Amount 68 EA
AMTTAXDIST Decimal 10 3 Total Distributed Tax 69 CEA
AMTINVCTOT Decimal 10 3 Document Total Before Taxes 70 CEA
AMTALLOCTX Decimal 10 3 Distributed Allocated Taxes 71 CEA
CNTPAYMSCH Decimal 3 0 Number of Scheduled Payments 72 CEA
AMTTOTDIST Decimal 10 3 Distributed Total Before Taxes 73 CEA
AMTGROSDST Decimal 10 3 Distributed Total Including Tax 74 CEA
IDPPD Char 22 0 Prepayment Number 75 CEA
TEXTRMIT Char 60 0 Location Name 76 EA
TEXTSTE1 Char 60 0 Address Line 1 77 EA
TEXTSTE2 Char 60 0 Address Line 2 78 EA
TEXTSTE3 Char 60 0 Address Line 3 79 EA
TEXTSTE4 Char 60 0 Address Line 4 80 EA
NAMECITY Char 30 0 City 81 EA
CODESTTE Char 30 0 State/Prov. 82 EA
CODEPSTL Char 20 0 Zip/Postal Code 83 EA
CODECTRY Char 30 0 Country 84 EA
NAMECTAC Char 60 0 Contact Name 85 EA
TEXTPHON Char 30 0 Phone Number %-30c 86 EAP
TEXTFAX Char 30 0 Fax Number %-30c 87 EAP
DATERATE Date 5 0 Rate Date 88 EA
AMTRECTAX Decimal 10 3 Recoverable Taxes 89 CEA
CODEPAYPPD Decimal 3 0 Reserved 90 E
CODEVNDGRP Char 6 0 Vendor Group Code %-6N 91 CEA
TERMSDESC Char 60 0 Terms Description 92 CEA
IDDISTSET Char 6 0 Distribution Set %-6N 93 EA
ID1099CLAS Char 6 0 1099/CPRS Code %-6N 94 EA
AMTDUE Decimal 10 3 Amount Due 95 CEA
CREATESCHD Int 2 0 Generate Payment Schedule 96 CEA
AMTTAXTOT Decimal 10 3 Tax Total 97 CEA
AMTGROSTOT Decimal 10 3 Document Total Including Tax 98 EA
CREATEDIST Int 2 0 Reserved 99 E
AMTUNDISTR Decimal 10 3 Undistributed Amount 100 CEA
SWTAXINCL1 Int 2 0 Tax Inclusive 1 101 EA
SWTAXINCL2 Int 2 0 Tax Inclusive 2 102 EA
SWTAXINCL3 Int 2 0 Tax Inclusive 3 103 EA
SWTAXINCL4 Int 2 0 Tax Inclusive 4 104 EA
SWTAXINCL5 Int 2 0 Tax Inclusive 5 105 EA
AMTEXPTAX Decimal 10 3 Expensed Separately Taxes 106 CEA
AMTAXTOBE Decimal 10 3 Tax Amount to be Allocated 107 CEA
TAXOUTBAL Decimal 10 3 Reserved 108 E
SWPROCTAX Int 2 0 Reserved 109 E
CODEOPER Int 2 0 Currency Code Operator 110 CEA
ACCTREC1 Char 45 0 Recoverable Account 1 %-45C 111 CEA
ACCTREC2 Char 45 0 Recoverable Account 2 %-45C 112 CEA
ACCTREC3 Char 45 0 Recoverable Account 3 %-45C 113 CEA
ACCTREC4 Char 45 0 Recoverable Account 4 %-45C 114 CEA
ACCTREC5 Char 45 0 Recoverable Account 5 %-45C 115 CEA
ACCTEXP1 Char 45 0 Expense Sep. Account 1 %-45C 116 CEA
ACCTEXP2 Char 45 0 Expense Sep. Account 2 %-45C 117 CEA
ACCTEXP3 Char 45 0 Expense Sep. Account 3 %-45C 118 CEA
ACCTEXP4 Char 45 0 Expense Sep. Account 4 %-45C 119 CEA
ACCTEXP5 Char 45 0 Expense Sep. Account 5 %-45C 120 CEA
DRILLAPP Char 2 0 Drill Down Application Source %-2A 121 CEA
DRILLTYPE Int 2 0 Drill Down Type 122 CEA
DRILLDWNLK Decimal 10 0 Drill Down Link Number 123 CEA
PRPTYCODE Int 2 0 Property Code 124 CEA
PRPTYVALUE Long 4 0 Property Value 125 CEA
PROCESSCMD Int 2 0 Process Command Code 126 CEA
SWJOB Int 2 0 Job Related 127 EA
AMTRECDIST Decimal 10 3 Dist. Recoverable Taxes 128 CEA
AMTEXPDIST Decimal 10 3 Dist. Exp. Separately Taxes 129 CEA
ERRBATCH Long 4 0 Error Batch 130 CEA
ERRENTRY Long 4 0 Error Entry 131 CEA
EMAIL Char 50 0 E-mail 132 EA
CTACPHONE Char 30 0 Contact's Phone %-30c 133 EAP
CTACFAX Char 30 0 Contact's Fax %-30c 134 EAP
CTACEMAIL Char 50 0 Contact's E-mail 135 EA
AMTPPD Decimal 10 3 Prepayment Amount 136 CEA
IDSTDINVC Char 16 0 Recurring Payable Code %-16C 137 CEA
DATEPRCS Date 5 0 Date Generated 138 CEA
AMTDSBWTAX Decimal 10 3 Discount Base With Tax 139 CEA
AMTDSBNTAX Decimal 10 3 Discount Base Without Tax 140 CEA
AMTDSCBASE Decimal 10 3 Discount Base 141 EA
SWRTGINVC Int 2 0 Retainage Invoice 142 EA
SWRTG Int 2 0 Has Retainage 143 EA
RTGAPPLYTO Char 22 0 Original Doc. No. %-22C 144 EA
RTGAMT Decimal 10 3 Retainage Amount 145 EA
RTGPERCENT Decimal 5 5 Percent Retained 146 EA
RTGDAYS Int 2 0 Days Retained 147 EA
RTGDATEDUE Date 5 0 Retainage Due Date 148 EA
RTGTERMS Char 6 0 Retainage Terms Code %-6N 149 EA
SWRTGDDTOV Int 2 0 Retainage Due Date Override 150 EA
SWRTGAMTOV Int 2 0 Retainage Amount Override 151 EA
SWRTGRATE Int 2 0 Retainage Exchange Rate 152 EA
SWTXBSECTL Int 2 0 Tax Base Control 153 EA
VALUES Long 4 0 Optional Fields 154 CEA
DETAILCNT Long 4 0 Number of Details 156 CEA
SRCEAPPL Char 2 0 Source Application %-2A 157 EA
SWHOLD Int 2 0 On Hold 158 EA
ORIGEXIST Int 2 0 Orig Exists 200 CEA
ORIGNAME Char 60 0 Orig Name 201 CEA
ORIGSTAT Int 2 0 Orig Status 202 CEA
VENEXIST Int 2 0 Vendor Exists 210 CEA
VENNAME Char 60 0 Vendor Name 211 CEA
VENDISTBY Int 2 0 Vendor Dist Type 212 CEA
VENDISTCOD Char 6 0 Vendor Dist Code 213 CEA
VENACCT Char 45 0 Vendor Account 214 CEA
VENTXRPTSW Int 2 0 Vendor Tax Report Type 215 CEA
RMTEXIST Int 2 0 Remit Exists 220 CEA
RMTNAME Char 60 0 Remit Name 221 CEA
CLSEXIST Int 2 0 1099/CPRS Exists 225 CEA
CLSDESC Char 60 0 1099/CPRS Description 226 CEA
DSETEXIST Int 2 0 Dist Set Exists 230 CEA
DSETDESC Char 60 0 Dist Set Description 231 CEA
DSETMETH Int 2 0 Dist Set Method 232 CEA
TERMEXIST Int 2 0 Term Exists 235 CEA
TERMMULPAY Int 2 0 Term Use Payment Schedule 236 CEA
RTERMEXIST Int 2 0 RTG Term Exists 240 CEA
RTERMDESC Char 60 0 RTG Term Description 241 CEA
PMLEV1NAME Char 30 0 PM Level 1 Name 245 CEA
PMLEV2NAME Char 30 0 PM Level 2 Name 246 CEA
PMLEV3NAME Char 30 0 PM Level 3 Name 247 CEA
TXGRPDESC Char 60 0 Tax Group Description 251 CEA
TXAU1DESC Char 60 0 Tax Auth 1 Description 260 CEA
TXAU2DESC Char 60 0 Tax Auth 2 Description 261 CEA
TXAU3DESC Char 60 0 Tax Auth 3 Description 262 CEA
TXAU4DESC Char 60 0 Tax Auth 4 Description 263 CEA
TXAU5DESC Char 60 0 Tax Auth 5 Description 264 CEA
APVERSION Char 3 0 A/P Version Created In 270 CEA
TAXVERSION Long 4 0 Tax State Version 271 CEA
SWTXRTGRPT Int 2 0 Report Retainage Tax 272 CEA
CODECURNRC Char 3 0 Tax Reporting Currency Code %-3N 273 EA
SWTXCTLRC Int 2 0 Tax Reporting Calculate Method 274 EA
RATERC Decimal 8 7 Tax Reporting Exchange Rate 275 EA
RATETYPERC Char 2 0 Tax Reporting Rate Type %-2N 276 EA
RATEDATERC Date 5 0 Tax Reporting Rate Date 277 EA
RATEOPRC Int 2 0 Tax Reporting Rate Operator 278 CEA
SWRATERC Int 2 0 Tax Reporting Rate Override 279 CEA
TXAMT1RC Decimal 10 3 Tax Reporting Amount 1 280 EA
TXAMT2RC Decimal 10 3 Tax Reporting Amount 2 281 EA
TXAMT3RC Decimal 10 3 Tax Reporting Amount 3 282 EA
TXAMT4RC Decimal 10 3 Tax Reporting Amount 4 283 EA
TXAMT5RC Decimal 10 3 Tax Reporting Amount 5 284 EA
TXTOTRC Decimal 10 3 Tax Reporting Total 285 CEA
TXALLRC Decimal 10 3 Tax Reporting Allocated Tax 286 CEA
TXEXPRC Decimal 10 3 Tax Reporting Expensed Tax 287 CEA
TXRECRC Decimal 10 3 Tax Reporting Recoverable Tax 288 CEA
TXBSERT1TC Decimal 10 3 Retainage Tax Base 1 289 EA
TXBSERT2TC Decimal 10 3 Retainage Tax Base 2 290 EA
TXBSERT3TC Decimal 10 3 Retainage Tax Base 3 291 EA
TXBSERT4TC Decimal 10 3 Retainage Tax Base 4 292 EA
TXBSERT5TC Decimal 10 3 Retainage Tax Base 5 293 EA
TXAMTRT1TC Decimal 10 3 Retainage Tax Amount 1 294 EA
TXAMTRT2TC Decimal 10 3 Retainage Tax Amount 2 295 EA
TXAMTRT3TC Decimal 10 3 Retainage Tax Amount 3 296 EA
TXAMTRT4TC Decimal 10 3 Retainage Tax Amount 4 297 EA
TXAMTRT5TC Decimal 10 3 Retainage Tax Amount 5 298 EA
TXBSE1HC Decimal 10 3 Func. Tax Base 1 299 CEA
TXBSE2HC Decimal 10 3 Func. Tax Base 2 300 CEA
TXBSE3HC Decimal 10 3 Func. Tax Base 3 301 CEA
TXBSE4HC Decimal 10 3 Func. Tax Base 4 302 CEA
TXBSE5HC Decimal 10 3 Func. Tax Base 5 303 CEA
TXAMT1HC Decimal 10 3 Func. Tax Amount 1 304 CEA
TXAMT2HC Decimal 10 3 Func. Tax Amount 2 305 CEA
TXAMT3HC Decimal 10 3 Func. Tax Amount 3 306 CEA
TXAMT4HC Decimal 10 3 Func. Tax Amount 4 307 CEA
TXAMT5HC Decimal 10 3 Func. Tax Amount 5 308 CEA
AMTGROSHC Decimal 10 3 Func. Distribution w/ Tax Total 309 CEA
RTGAMTHC Decimal 10 3 Func. Retainage Amount 310 CEA
AMTDISCHC Decimal 10 3 Func. Discount Amount 311 CEA
AMT1099HC Decimal 10 3 Func. 1099/CPRS Amount 312 CEA
AMTPPDHC Decimal 10 3 Func. Prepayment Amount 313 CEA
AMTDUETC Decimal 10 3 Amount Due 314 CEA
AMTDUEHC Decimal 10 3 Func. Amount Due 315 CEA
TEXTVEN Char 60 0 Vendor Name 316 EA
TXTOTRTTC Decimal 10 3 Retainage Tax Total 317 CEA
TXTOTAMT1 Decimal 10 3 Tax Amount 1 Total 318 CEA
TXTOTAMT2 Decimal 10 3 Tax Amount 2 Total 319 CEA
TXTOTAMT3 Decimal 10 3 Tax Amount 3 Total 320 CEA
TXTOTAMT4 Decimal 10 3 Tax Amount 4 Total 321 CEA
TXTOTAMT5 Decimal 10 3 Tax Amount 5 Total 322 CEA
RTGAMTDTL Decimal 10 3 Retainage Amount from Details 323 CEA
ENTEREDBY Char 8 0 Entered By 324 CEA
DATEBUS Date 5 0 Posting Date 325 EA
ASETDESC Char 60 0 Acct Set Description 326 CEA
IDN Char 30 0 Import Declaration Number 327 EA