Sage 300 View Documentor Online

A fully searchable Sage 300 View Doc on the web

Views

Search: Show:
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
Showing 1 to 50 of 1463 records

BK0845 - BKTRANH - Bank Transaction Header

Compositions

using (HuAPConnection Connection = new HuAPConnection())
using (HuView BKTRANH = Connection.GetView("BK0845"))
using (HuView BKACCT = Connection.GetView("BK0001"))
using (HuView BKCUR = Connection.GetView("BK0002"))
using (HuView CSCCD = Connection.GetView("CS0003"))
using (HuView CSCRT = Connection.GetView("CS0004"))
using (HuView GLAMF = Connection.GetView("GL0001"))
using (HuView GLFISC = Connection.GetView("GL0003"))
using (HuView GLAIS = Connection.GetView("GL0004"))
using (HuView GLAVC = Connection.GetView("GL0012"))
using (HuView GLRVAL = Connection.GetView("GL0020"))
using (HuView GLABRX = Connection.GetView("GL0023"))
using (HuView GLABK = Connection.GetView("GL0022"))
using (HuView GLCAS = Connection.GetView("GL0107"))
using (HuView GLAMFO = Connection.GetView("GL0400"))
using (HuView GLAMFTO = Connection.GetView("GL0401"))
using (HuView GLACHD = Connection.GetView("GL0057"))
using (HuView GLPACHD = Connection.GetView("GL0063"))
using (HuView GENSTUB = Connection.GetView("BK0999"))
using (HuView BKFORM = Connection.GetView("BK0008"))
using (HuView BKTT = Connection.GetView("BK0003"))
using (HuView BKTTX = Connection.GetView("BK0860"))
using (HuView BKUNMAT = Connection.GetView("BK0870"))
using (HuView BKTRAND = Connection.GetView("BK0840"))
{
	BKTRANH.Compose(BKACCT, BKTRAND);
	BKACCT.Compose(BKCUR, GENSTUB, BKTRANH, GENSTUB, GENSTUB, BKFORM, BKTT, GLAMF, CSCCD, BKUNMAT, BKTRAND);
	BKCUR.Compose(BKACCT, CSCCD, CSCRT, GLAMF);
	CSCCD.Compose();
	CSCRT.Compose();
	GLAMF.Compose(GLFISC, GLAIS, GLAVC, GLABRX, GLCAS, GLAMFO, GLAMFTO, GLACHD, GLPACHD);
	GLFISC.Compose();
	GLAIS.Compose(GLAMF);
	GLAVC.Compose(GLAMF, GLRVAL);
	GLRVAL.Compose(GLAMF);
	GLABRX.Compose(GLABK);
	GLABK.Compose();
	GLCAS.Compose(GLAMF);
	GLAMFO.Compose(GLAMF);
	GLAMFTO.Compose(GLAMF);
	GLACHD.Compose(GLAMF);
	GLPACHD.Compose(GLAMF);
	GENSTUB.Compose();
	BKFORM.Compose(BKACCT);
	BKTT.Compose(GLAMF, BKTTX);
	BKTTX.Compose(BKTT);
	BKUNMAT.Compose(BKACCT);
	BKTRAND.Compose(BKTRANH, BKACCT, CSCRT, BKCUR, BKTT);
	
	// Code Here
	
}

Indexes

  • 0 - Bank Transaction Uniquifier
    BANK,SERIAL
  • 1 - Bank Transaction Old Serial
    BANK,TRANSTYPE,OLDSERIAL
  • 2 - Bank Fiscal Transaction
    BANK,FSCYEAR,FSCPERIOD,SERIAL
  • 3 - Bank Transaction Date
    BANK,COMPLETED,TRANSDATE,SERIAL
  • 4 - Bank Transaction Number
    BANK,TRANSNUM,SERIAL
  • 5 - Bank Transaction Completed
    BANK,COMPLETED,TRANSNUM,SERIAL

Fields

Field Name Type Size Precision Description Mask Index Attribute
BANK Char 8 0 Bank Code %-8N 1 RKEA
SERIAL Long 4 0 Transaction Header Serial 2 RKEA
TRANSNUM Decimal 5 0 Transaction Number 3 EA
SRCEAPP Char 2 0 Source Application %-2N 4 EA
TRANSTYPE Int 2 0 Transaction Type
1 - Withdrawals
2 - Deposits
5 EA
OLDSERIAL Long 4 0 Old Serial Number 6 EA
ENTRYTYPE Int 2 0 Entry Type
1 - Bank Entered
2 - Miscellaneous
3 - Subledger
4 - Transfer
5 - Returned Customer Check
6 - Alignment
7 - Non Negotiable
7 EA
REFERENCE Char 60 0 Transaction Reference 8 EA
DESC Char 60 0 Transaction Description 9 EA
TRANSDATE Date 5 0 Transaction Date 10 EA
FSCYEAR Char 4 0 Fiscal Year %04D 11 EA
FSCPERIOD Int 2 0 Fiscal Period
1 - 1
2 - 2
3 - 3
4 - 4
5 - 5
6 - 6
7 - 7
8 - 8
9 - 9
10 - 10
11 - 11
12 - 12
12 EAP
PRINTED Int 2 0 Transaction Slip Printed
0 - No
1 - Yes
13 EA
TOTAMOUNT Decimal 10 3 Transaction Total 14 CA
TOTBALAMT Decimal 10 3 Transaction Total in Statement 15 CA
TOTCLEARED Decimal 10 3 Fiscal Transaction Total 16 CA
NXTLINE Long 4 0 Next Transaction Detail Line 17 CEA
LINES Long 4 0 Lines 18 CEA
LINESPOST Long 4 0 Lines Outstanding 19 CEA
LINESREC Long 4 0 Lines Reconciled 20 CEA
STATUS Int 2 0 Transaction Status
1 - Not posted
2 - Partially Outstanding
3 - Outstanding
4 - Partially Reconciled
5 - Reconciled
6 - Pending Journal
7 - Posted
8 - Purged
21 CA
RECERR Decimal 10 3 Reconciliation Error 22 CEA
RECERRPEND Decimal 10 3 Reconciliation Error Pending 23 CEA
RECEXGAIN Decimal 10 3 Reconciliation Exchange Gain 24 CEA
RECEXLOSS Decimal 10 3 Reconciliation Exchange Loss 25 CEA
RECAMOUNT Decimal 10 3 Reconciliation Amount 26 CEA
RECOUTSTND Decimal 10 3 Reconciliation Outstanding Amt 27 CEA
SUMMARY Int 2 0 Transaction Recorded in Summary
0 - Detail
1 - Summary
2 - Transfer
3 - Bank Error
28 EA
RECCCC Decimal 10 3 Reconciliation Credit Card Charg 29 CEA
RECCLEARED Decimal 10 3 Amount Cleared 30 CEA
RECFUNCAMT Decimal 10 3 Functional Transaction Amount 31 CEA
TOTFUNCAMT Decimal 10 3 Functional Transaction Total 32 CA
TOCLEAR Decimal 10 3 Reconciliation Cleared Amount 33 A
TOWRITEOFF Decimal 10 3 Write-Off Amount 34 A
TOREMAIN Decimal 10 3 Outstanding Amount 35 A
VARIANCE Int 2 0 Variance Type
0 - None
36 AP
LINESREVIN Long 4 0 Lines Can Reverse Invoice 37 CA
POSTDATE Date 5 0 Reconciliation Date 38 A
RECSTATUS Int 2 0 Reconciliation Status
1 - Not Posted
2 - Void
9 - Printed
7 - Non-negotiable
8 - Continuation
39 EAP
RECCOMMENT Char 60 0 Reconciliation Description 40 A
LINESJOUR Long 4 0 Lines Journalled 41 CA
LINESPUR Long 4 0 Lines Purged 42 CA
LINESPROC Long 4 0 Lines Processed 43 CA
TOCLEARF Decimal 10 3 Clear To Future Period 44 A
RECFCLR Decimal 10 3 Fiscal Cleared To Future 45 CEA
RECRCLR Decimal 10 3 Fiscal Cleared To Current 46 CEA
COMPLETED Int 2 0 Reconciled and Journaled Transac
0 - Not Completed
10 - Completed
47 EA
PAYORNAME Char 60 0 Payment Payee Name 48 CEA
VENDORNAME Char 60 0 Payment Vendor Name 49 EA
ENTRYNBR Char 22 0 Bank Entry/Transfer Number %-22C 50 EA
LINESCCC Long 4 0 Lines Credit Card 51 CEA
LINESEXCH Long 4 0 Lines Exchange Difference 52 CEA
REVINVC Int 2 0 Reverse Invoice
0 - No
1 - Yes
53 A
AMTDTLREC Decimal 10 3 Reconcile by Detail Reconciled 54 CEA
AMTDTLOUT Decimal 10 3 Reconcile by Detail Outstanding 55 CEA
RECWOSUMR Decimal 10 3 Current Period's Write-Off 114 CA
TOCLEARR Decimal 10 3 Clear To Reconciliation Period 115 CA
RECRWOSUM Decimal 10 3 Fiscal Write-Off To This Period 116 CEA
RECPREM Decimal 10 3 Fiscal Remaining Outstanding 117 CEA
RECTWO Decimal 10 3 Total Delta Write Offs 118 CEA
RECTERR Decimal 10 3 Total Delta Bank Errors 119 CEA
RECTGAIN Decimal 10 3 Total Delta Exchange Gain 120 CEA
RECTLOSS Decimal 10 3 Total Delta Exchange Loss 121 CEA
RECTCCC Decimal 10 3 Total Delta Credit Card Charge 122 CEA
RECTCLR Decimal 10 3 Total Delta Cleared 123 CEA
RECTFUNAM Decimal 10 3 Total Delta Functional Amount 124 CEA
CURFUNC Char 3 0 Functional Currency 125 A
CURSTMT Char 3 0 Statement Currency 126 A
RECWOSUM Decimal 10 3 Reconciliation Write Off Sum 127 CA
POSTYEAR Char 4 0 Reconciliation posting Year %04D 128 EA
POSTPERIOD Int 2 0 Reconciliation posting Period 129 EAP
SUMDEPOSIT Decimal 10 3 Total Deposits 130 CA
RECINTRANS Decimal 10 3 Deposits in Transit 131 CA
FUNDTAMT Decimal 10 3 Deposit Functional Total 132 CA
RECDTWOSUM Decimal 10 3 Sum of Deposit Total Write Offs 133 CA
RECDTERR Decimal 10 3 Total Deposit Bank Errors 134 CA
RECDTGAIN Decimal 10 3 Total Deposit Exchange Gain 135 CA
RECDTLOSS Decimal 10 3 Total Deposit Exchange Loss 136 CA
RECDTCCC Decimal 10 3 Total Deposit Credit Card Charge 137 CA
RECDTCLR Decimal 10 3 Total Deposit Cleared 138 CA
RECDPWOSUM Decimal 10 3 Fiscal Deposit Write-Off To This 139 CA
RECDPERR Decimal 10 3 Fiscal Deposit Bank Errors 140 CA
RECDPGAIN Decimal 10 3 Fiscal Deposit Exchange Gain 141 CA
RECDPLOSS Decimal 10 3 Fiscal Deposit Exchange Loss 142 CA
RECDPCCC Decimal 10 3 Fiscal Deposit Credit Card Charg 143 CA
RECDPCLR Decimal 10 3 Fiscal Deposit Cleared 144 CA
RECDEXDIFF Decimal 10 3 Deposit Cleared with Exchange Ra 145 CA
RECFCDEPIT Decimal 10 3 Deposits In Transit To Fisc.Per. 146 CA
RECDFCLR Decimal 10 3 Fiscal Deposit Cleared To Future 147 CA
SUMCHECK Decimal 10 3 Total Checks 148 CA
RECWOUTSTD Decimal 10 3 Checks Outstanding 149 CA
FUNWTAMT Decimal 10 3 Withdrawal Functional Total 150 CA
RECWTWOSUM Decimal 10 3 Sum of Withdrawal Total Write Of 151 CA
RECWTERR Decimal 10 3 Total Withdrawal Bank Errors 152 CA
RECWTGAIN Decimal 10 3 Total Withdrawal Exchange Gain 153 CA
RECWTLOSS Decimal 10 3 Total Withdrawal Exchange Loss 154 CA
RECWTCCC Decimal 10 3 Total Withdrawal Credit Card Cha 155 CA
RECWTCLR Decimal 10 3 Total Withdrawal Cleared 156 CA
RECWPWOSUM Decimal 10 3 Fiscal Withdrawal Write-Off To T 157 CA
RECWPERR Decimal 10 3 Fiscal Withdrawal Bank Errors 158 CA
RECWPGAIN Decimal 10 3 Fiscal Withdrawal Exchange Gain 159 CA
RECWPLOSS Decimal 10 3 Fiscal Withdrawal Exchange Loss 160 CA
RECWPCCC Decimal 10 3 Fiscal Withdrawal Credit Card Ch 161 CA
RECWPCLR Decimal 10 3 Clear To Reconciliation Period 162 CA
RECWEXDIFF Decimal 10 3 Checks Cleared with Exch. Rate D 163 CA
RECFCCHKOS Decimal 10 3 Checks Outstanding To Fisc.Per. 164 CA
RECWFCLR Decimal 10 3 Fiscal Withdrawal Cleared To Fut 165 CA
RECFCMISC Decimal 10 3 Fiscal Miscellaneous Entry 166 CA
RECFCWMISC Decimal 10 3 Payment Misc. Entries To Fiscal 167 CA
RECFCDMISC Decimal 10 3 Deposit Misc. Entries To Fiscal 168 CA
RECFWMISC Decimal 10 3 Payment Misc. Entries To Future 169 CA
RECFDMISC Decimal 10 3 Deposit Misc. Entries To Future 170 CA
RECPDEPB Decimal 10 3 Fiscal Deposit Book Amount 171 CA
RECPCHKB Decimal 10 3 Fiscal Withdrawal Book Amount 172 CA
DTLACCESS Int 2 0 Detail Access Portal
0 - No
1 - Yes
173 EA
RECDELTA Decimal 10 3 Reconciliation Delta 174 CA
PROCESSCMD Int 2 0 Process Command Code
0 - Sum Details
1 - Apply Details Cleared
2 - Apply Details Outstanding
175 CEA