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

GL0031 - FRFISC - Financial Report Information

Compositions

using (HuAPConnection Connection = new HuAPConnection())
using (HuView FRFISC = Connection.GetView("GL0031"))
{
	FRFISC.Compose();
	
	// Code Here
	
}

Indexes

  • 0 - Financial Account Number
    ACCTID,RPTYR,DESIGNATOR,CURID,CURTYPE

Fields

Field Name Type Size Precision Description Mask Index Attribute
ACCTID Char 45 0 Account Number %-45C 1 RKEA
RPTYR Char 4 0 Reporting Year %04D 2 RKEA
DESIGNATOR Char 1 0 Fiscal Set Designator 3 RKEA
CURID Char 3 0 Currency Code %-3N 4 RKEA
CURTYPE Char 1 0 Currency Type 5 RKEA
AMTTYPE Char 1 0 Fiscal Set Type 6 EA
RPTYROFF Int 2 0 Reporting Year Offset 7 EA
RPTPERIOD Int 2 0 Reporting Period 8 EA
BALP Decimal 10 3 Balance Current Period 9 CEA
BALLP Decimal 10 3 Balance Last Period 10 CEA
BAL1P Decimal 10 3 Balance Period 1 11 CEA
BAL2P Decimal 10 3 Balance Period 2 12 CEA
BAL3P Decimal 10 3 Balance Period 3 13 CEA
BAL4P Decimal 10 3 Balance Period 4 14 CEA
BAL5P Decimal 10 3 Balance Period 5 15 CEA
BAL6P Decimal 10 3 Balance Period 6 16 CEA
BAL7P Decimal 10 3 Balance Period 7 17 CEA
BAL8P Decimal 10 3 Balance Period 8 18 CEA
BAL9P Decimal 10 3 Balance Period 9 19 CEA
BAL10P Decimal 10 3 Balance Period 10 20 CEA
BAL11P Decimal 10 3 Balance Period 11 21 CEA
BAL12P Decimal 10 3 Balance Period 12 22 CEA
BAL13P Decimal 10 3 Balance Period 13 23 CEA
BAL1PA Decimal 10 3 Balance 1 Period Ago 24 CEA
BAL2PA Decimal 10 3 Balance 2 Periods Ago 25 CEA
BAL3PA Decimal 10 3 Balance 3 Periods Ago 26 CEA
BAL4PA Decimal 10 3 Balance 4 Periods Ago 27 CEA
BAL5PA Decimal 10 3 Balance 5 Periods Ago 28 CEA
BAL6PA Decimal 10 3 Balance 6 Periods Ago 29 CEA
BAL7PA Decimal 10 3 Balance 7 Periods Ago 30 CEA
BAL8PA Decimal 10 3 Balance 8 Periods Ago 31 CEA
BAL9PA Decimal 10 3 Balance 9 Periods Ago 32 CEA
BAL10PA Decimal 10 3 Balance 10 Periods Ago 33 CEA
BAL11PA Decimal 10 3 Balance 11 Periods Ago 34 CEA
BAL12PA Decimal 10 3 Balance 12 Periods Ago 35 CEA
BAL13PA Decimal 10 3 Balance 13 Periods Ago 36 CEA
BALQ Decimal 10 3 Balance Current Quarter 37 CEA
BALLQ Decimal 10 3 Balance Last Quarter 38 CEA
BAL1Q Decimal 10 3 Balance Quarter 1 39 CEA
BAL2Q Decimal 10 3 Balance Quarter 2 40 CEA
BAL3Q Decimal 10 3 Balance Quarter 3 41 CEA
BAL4Q Decimal 10 3 Balance Quarter 4 42 CEA
BAL1QTD Decimal 10 3 Balance Quarter 1 to Date 43 CEA
BAL2QTD Decimal 10 3 Balance Quarter 2 to Date 44 CEA
BAL3QTD Decimal 10 3 Balance Quarter 3 to Date 45 CEA
BAL4QTD Decimal 10 3 Balance Quarter 4 to Date 46 CEA
BAL1QA Decimal 10 3 Balance 1 Quarter Ago 47 CEA
BAL2QA Decimal 10 3 Balance 2 Quarters Ago 48 CEA
BAL3QA Decimal 10 3 Balance 3 Quarters Ago 49 CEA
BAL4QA Decimal 10 3 Balance 4 Quarters Ago 50 CEA
BALS Decimal 10 3 Balance Current Half Year 51 CEA
BALLS Decimal 10 3 Balance Last Half Year 52 CEA
BAL1S Decimal 10 3 Balance Half Year 1 53 CEA
BAL2S Decimal 10 3 Balance Half Year 2 54 CEA
BAL1STD Decimal 10 3 Balance Half Year 1 to Date 55 CEA
BAL2STD Decimal 10 3 Balance Half Year 2 to Date 56 CEA
BAL1SA Decimal 10 3 Balance 1 Half Year Ago 57 CEA
BAL2SA Decimal 10 3 Balance 2 Half Years Ago 58 CEA
BALY Decimal 10 3 Balance Total Year 59 CEA
BALYTD Decimal 10 3 Balance Year to Date 60 CEA
BALOPEN Decimal 10 3 Balance Beginning of Year 61 CEA
NETP Decimal 10 3 Net Current Period 62 CEA
NETLP Decimal 10 3 Net Last Period 63 CEA
NET1P Decimal 10 3 Net Period 1 64 CEA
NET2P Decimal 10 3 Net Period 2 65 CEA
NET3P Decimal 10 3 Net Period 3 66 CEA
NET4P Decimal 10 3 Net Period 4 67 CEA
NET5P Decimal 10 3 Net Period 5 68 CEA
NET6P Decimal 10 3 Net Period 6 69 CEA
NET7P Decimal 10 3 Net Period 7 70 CEA
NET8P Decimal 10 3 Net Period 8 71 CEA
NET9P Decimal 10 3 Net Period 9 72 CEA
NET10P Decimal 10 3 Net Period 10 73 CEA
NET11P Decimal 10 3 Net Period 11 74 CEA
NET12P Decimal 10 3 Net Period 12 75 CEA
NET13P Decimal 10 3 Net Period 13 76 CEA
NET1PA Decimal 10 3 Net 1 Period Ago 77 CEA
NET2PA Decimal 10 3 Net 2 Periods Ago 78 CEA
NET3PA Decimal 10 3 Net 3 Periods Ago 79 CEA
NET4PA Decimal 10 3 Net 4 Periods Ago 80 CEA
NET5PA Decimal 10 3 Net 5 Periods Ago 81 CEA
NET6PA Decimal 10 3 Net 6 Periods Ago 82 CEA
NET7PA Decimal 10 3 Net 7 Periods Ago 83 CEA
NET8PA Decimal 10 3 Net 8 Periods Ago 84 CEA
NET9PA Decimal 10 3 Net 9 Periods Ago 85 CEA
NET10PA Decimal 10 3 Net 10 Periods Ago 86 CEA
NET11PA Decimal 10 3 Net 11 Periods Ago 87 CEA
NET12PA Decimal 10 3 Net 12 Periods Ago 88 CEA
NET13PA Decimal 10 3 Net 13 Periods Ago 89 CEA
NETQ Decimal 10 3 Net Current Quarter 90 CEA
NETLQ Decimal 10 3 Net Last Quarter 91 CEA
NET1Q Decimal 10 3 Net Quarter 1 92 CEA
NET2Q Decimal 10 3 Net Quarter 2 93 CEA
NET3Q Decimal 10 3 Net Quarter 3 94 CEA
NET4Q Decimal 10 3 Net Quarter 4 95 CEA
NET1QTD Decimal 10 3 Net Quarter 1 to Date 96 CEA
NET2QTD Decimal 10 3 Net Quarter 2 to Date 97 CEA
NET3QTD Decimal 10 3 Net Quarter 3 to Date 98 CEA
NET4QTD Decimal 10 3 Net Quarter 4 to Date 99 CEA
NETPQ Decimal 10 3 Net Preceeding Quarter 100 CEA
NETPQ1PA Decimal 10 3 Net Preceeding Quarter 1P Ago 101 CEA
NETPQ2PA Decimal 10 3 Net Preceeding Quarter 2P Ago 102 CEA
NETPQ3PA Decimal 10 3 Net Preceeding Quarter 3P Ago 103 CEA
NETPQ4PA Decimal 10 3 Net Preceeding Quarter 4P Ago 104 CEA
NETPQ5PA Decimal 10 3 Net Preceeding Quarter 5P Ago 105 CEA
NETPQ6PA Decimal 10 3 Net Preceeding Quarter 6P Ago 106 CEA
NETPQ7PA Decimal 10 3 Net Preceeding Quarter 7P Ago 107 CEA
NETPQ8PA Decimal 10 3 Net Preceeding Quarter 8P Ago 108 CEA
NETPQ9PA Decimal 10 3 Net Preceeding Quarter 9P Ago 109 CEA
NETPQ10PA Decimal 10 3 Net Preceeding Quarter 10P Ago 110 CEA
NETPQ11PA Decimal 10 3 Net Preceeding Quarter 11P Ago 111 CEA
NETPQ12PA Decimal 10 3 Net Preceeding Quarter 12P Ago 112 CEA
NETPQ13PA Decimal 10 3 Net Preceeding Quarter 13P Ago 113 CEA
NET1QA Decimal 10 3 Net 1 Quarter Ago 114 CEA
NET2QA Decimal 10 3 Net 2 Quarters Ago 115 CEA
NET3QA Decimal 10 3 Net 3 Quarters Ago 116 CEA
NET4QA Decimal 10 3 Net 4 Quarters Ago 117 CEA
NETS Decimal 10 3 Net Current Half Year 118 EA
NETLS Decimal 10 3 Net Last Half Year 119 EA
NET1S Decimal 10 3 Net Half Year 1 120 EA
NET2S Decimal 10 3 Net Half Year 2 121 EA
NETPS Decimal 10 3 Net Preceeding Half Year 122 EA
NET1STD Decimal 10 3 Net Half Year 1 to Date 123 EA
NET2STD Decimal 10 3 Net Half Year 2 to Date 124 EA
NETPS1PA Decimal 10 3 Net Preceeding Half Year 1P Ago 125 EA
NETPS2PA Decimal 10 3 Net Preceeding Half Year 2P Ago 126 EA
NETPS3PA Decimal 10 3 Net Preceeding Half Year 3P Ago 127 EA
NETPS4PA Decimal 10 3 Net Preceeding Half Year 4P Ago 128 EA
NETPS5PA Decimal 10 3 Net Preceeding Half Year 5P Ago 129 EA
NETPS6PA Decimal 10 3 Net Preceeding Half Year 6P Ago 130 EA
NETPS7PA Decimal 10 3 Net Preceeding Half Year 7P Ago 131 EA
NETPS8PA Decimal 10 3 Net Preceeding Half Year 8P Ago 132 EA
NETPS9PA Decimal 10 3 Net Preceeding Half Year 9P Ago 133 EA
NETPS10PA Decimal 10 3 Net Preceeding Half Year 10P Ago 134 EA
NETPS11PA Decimal 10 3 Net Preceeding Half Year 11P Ago 135 EA
NETPS12PA Decimal 10 3 Net Preceeding Half Year 12P Ago 136 EA
NETPS13PA Decimal 10 3 Net Preceeding Half Year 13P Ago 137 EA
NET1SA Decimal 10 3 Net 1 Half Year Ago 138 EA
NET2SA Decimal 10 3 Net 2 Half Years Ago 139 EA
NETY Decimal 10 3 Net Total Year 140 EA
NETYTD Decimal 10 3 Net Year to Date 141 EA
NETPY Decimal 10 3 Net Preceeding Year 142 EA
NETPY1PA Decimal 10 3 Net Preceeding Year 1P Ago 143 EA
NETPY2PA Decimal 10 3 Net Preceeding Year 2P Ago 144 EA
NETPY3PA Decimal 10 3 Net Preceeding Year 3P Ago 145 EA
NETPY4PA Decimal 10 3 Net Preceeding Year 4P Ago 146 EA
NETPY5PA Decimal 10 3 Net Preceeding Year 5P Ago 147 EA
NETPY6PA Decimal 10 3 Net Preceeding Year 6P Ago 148 EA
NETPY7PA Decimal 10 3 Net Preceeding Year 7P Ago 149 EA
NETPY8PA Decimal 10 3 Net Preceeding Year 8P Ago 150 EA
NETPY9PA Decimal 10 3 Net Preceeding Year 9P Ago 151 EA
NETPY10PA Decimal 10 3 Net Preceeding Year 10P Ago 152 EA
NETPY11PA Decimal 10 3 Net Preceeding Year 11P Ago 153 EA
NETPY12PA Decimal 10 3 Net Preceeding Year 12P Ago 154 EA
NETPY13PA Decimal 10 3 Net Preceeding Year 13P Ago 155 EA
NETADJ Decimal 10 3 Net Adjustments 156 EA
BALCLOSE Decimal 10 3 Closing Balance 157 EA
NETCLOSE Decimal 10 3 Net Closing Amount 158 EA
BALQTD Decimal 10 3 Balance Quarter to Date 159 EA
BALLQTD Decimal 10 3 Balance Last Quarter to Date 160 EA
BAL1QATD Decimal 10 3 Balance 1 Quarter Ago to Date 161 EA
BAL2QATD Decimal 10 3 Balance 2 Quarters Ago to Date 162 EA
BAL3QATD Decimal 10 3 Balance 3 Quarters Ago to Date 163 EA
BAL4QATD Decimal 10 3 Balance 4 Quarters Ago to Date 164 EA
BALSTD Decimal 10 3 Balance Half Year to Date 165 EA
BALLSTD Decimal 10 3 Balance Last Half Year to Date 166 EA
BAL1SATD Decimal 10 3 Balance 1 Half Year Ago to Date 167 EA
BAL2SATD Decimal 10 3 Balance 2 Half Years Ago to Date 168 EA
NETQTD Decimal 10 3 Net Quarter to Date 169 EA
NETLQTD Decimal 10 3 Net Last Quarter to Date 170 EA
NET1QATD Decimal 10 3 Net 1 Quarter Ago to Date 171 EA
NET2QATD Decimal 10 3 Net 2 Quarters Ago to Date 172 EA
NET3QATD Decimal 10 3 Net 3 Quarters Ago to Date 173 EA
NET4QATD Decimal 10 3 Net 4 Quarters Ago to Date 174 EA
NETSTD Decimal 10 3 Net Half Year to Date 175 EA
NETLSTD Decimal 10 3 Net Last Half Year to Date 176 EA
NET1SATD Decimal 10 3 Net 1 Half Year Ago to Date 177 EA
NET2SATD Decimal 10 3 Net 2 Half Years Ago to Date 178 EA
BALPQ Decimal 10 3 Bal Preceeding Quarter 179 EA
BALPQ1PA Decimal 10 3 Bal Preceeding Quarter 1P Ago 180 EA
BALPQ2PA Decimal 10 3 Bal Preceeding Quarter 2P Ago 181 EA
BALPQ3PA Decimal 10 3 Bal Preceeding Quarter 3P Ago 182 EA
BALPQ4PA Decimal 10 3 Bal Preceeding Quarter 4P Ago 183 EA
BALPQ5PA Decimal 10 3 Bal Preceeding Quarter 5P Ago 184 EA
BALPQ6PA Decimal 10 3 Bal Preceeding Quarter 6P Ago 185 EA
BALPQ7PA Decimal 10 3 Bal Preceeding Quarter 7P Ago 186 EA
BALPQ8PA Decimal 10 3 Bal Preceeding Quarter 8P Ago 187 EA
BALPQ9PA Decimal 10 3 Bal Preceeding Quarter 9P Ago 188 EA
BALPQ10PA Decimal 10 3 Bal Preceeding Quarter 10P Ago 189 EA
BALPQ11PA Decimal 10 3 Bal Preceeding Quarter 11P Ago 190 EA
BALPQ12PA Decimal 10 3 Bal Preceeding Quarter 12P Ago 191 EA
BALPQ13PA Decimal 10 3 Bal Preceeding Quarter 13P Ago 192 EA
BALPS Decimal 10 3 Bal Preceeding Half Year 193 EA
BALPS1PA Decimal 10 3 Bal Preceeding Half Year 1P Ago 194 EA
BALPS2PA Decimal 10 3 Bal Preceeding Half Year 2P Ago 195 EA
BALPS3PA Decimal 10 3 Bal Preceeding Half Year 3P Ago 196 EA
BALPS4PA Decimal 10 3 Bal Preceeding Half Year 4P Ago 197 EA
BALPS5PA Decimal 10 3 Bal Preceeding Half Year 5P Ago 198 EA
BALPS6PA Decimal 10 3 Bal Preceeding Half Year 6P Ago 199 EA
BALPS7PA Decimal 10 3 Bal Preceeding Half Year 7P Ago 200 EA
BALPS8PA Decimal 10 3 Bal Preceeding Half Year 8P Ago 201 EA
BALPS9PA Decimal 10 3 Bal Preceeding Half Year 9P Ago 202 EA
BALPS10PA Decimal 10 3 Bal Preceeding Half Year 10P Ago 203 EA
BALPS11PA Decimal 10 3 Bal Preceeding Half Year 11P Ago 204 EA
BALPS12PA Decimal 10 3 Bal Preceeding Half Year 12P Ago 205 EA
BALPS13PA Decimal 10 3 Bal Preceeding Half Year 13P Ago 206 EA
BALPY Decimal 10 3 Bal Preceeding Year 207 EA
BALPY1PA Decimal 10 3 Bal Preceeding Year 1P Ago 208 EA
BALPY2PA Decimal 10 3 Bal Preceeding Year 2P Ago 209 EA
BALPY3PA Decimal 10 3 Bal Preceeding Year 3P Ago 210 EA
BALPY4PA Decimal 10 3 Bal Preceeding Year 4P Ago 211 EA
BALPY5PA Decimal 10 3 Bal Preceeding Year 5P Ago 212 EA
BALPY6PA Decimal 10 3 Bal Preceeding Year 6P Ago 213 EA
BALPY7PA Decimal 10 3 Bal Preceeding Year 7P Ago 214 EA
BALPY8PA Decimal 10 3 Bal Preceeding Year 8P Ago 215 EA
BALPY9PA Decimal 10 3 Bal Preceeding Year 9P Ago 216 EA
BALPY10PA Decimal 10 3 Bal Preceeding Year 10P Ago 217 EA
BALPY11PA Decimal 10 3 Bal Preceeding Year 11P Ago 218 EA
BALPY12PA Decimal 10 3 Bal Preceeding Year 12P Ago 219 EA
BALPY13PA Decimal 10 3 Bal Preceeding Year 13P Ago 220 EA
BUDGETSW Int 2 0 Budget Opening Balance Switch 221 EA
QTYSW Int 2 0 Quantity Opening Balance Switch 222 EA
GLPOSTFIL Char 1024 0 Additional FRTRN Filter 223 EA
ACCESSSW Int 2 0 Table GLPOST Switch 224 EA
GETSW Int 2 0 FRTRN Switch 225 EA
ACCTBAL Char 1 0 Account Bal of 1st FRTRN Record 226 EA
GLPOSTORD Int 2 0 FRTRN Browsing Order 227 EA
ROLLUPSW Int 2 0 Rollup Switch 228 EA