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

CP0142 - CPMCJO - Manual Cheque Jobs Opt Fields

Compositions

using (HuAPConnection Connection = new HuAPConnection())
using (HuView CPMCJO = Connection.GetView("CP0142"))
using (HuView CPMCJB = Connection.GetView("CP0043"))
using (HuView CPMCDT = Connection.GetView("CP0020"))
using (HuView CPMCHD = Connection.GetView("CP0019"))
using (HuView CPMCHO = Connection.GetView("CP0129"))
using (HuView CPMCDO = Connection.GetView("CP0130"))
{
	CPMCJO.Compose(CPMCJB);
	CPMCJB.Compose(CPMCDT, CPMCJO);
	CPMCDT.Compose(CPMCHD, CPMCDO, CPMCJB);
	CPMCHD.Compose(CPMCDT, CPMCHO);
	CPMCHO.Compose(CPMCHD);
	CPMCDO.Compose(CPMCDT);
	
	// Code Here
	
}

Indexes

  • 0 - Jobs Optional Field Value
    EMPLOYEE,BANK,CHECKNUM,PEREND,CHECKDATE,LINENUM,JOBLINE,OPTFIELD
  • 1 - Optional Field/Jobs
    OPTFIELD,EMPLOYEE,BANK,CHECKNUM,PEREND,CHECKDATE,LINENUM,JOBLINE

Fields

Field Name Type Size Precision Description Mask Index Attribute
EMPLOYEE Char 12 0 Employee %-12N 1 RKEA
BANK Char 8 0 Bank ID %-8N 2 RKEA
CHECKNUM Decimal 5 0 Cheque Number 3 RKEA
PEREND Date 5 0 Period End Date 4 RKEA
CHECKDATE Date 5 0 Cheque Date 5 RKEA
LINENUM Int 2 0 Line Number 6 RKEA
JOBLINE Int 2 0 Job Line Number 7 RKEA
OPTFIELD Char 12 0 Optional Field %-12N 8 RKEA
VALUE Char 60 0 Value %-60c 9 EAP
TYPE Int 2 0 Type
1 - Text
100 - Amount
6 - Number
8 - Integer
9 - Yes/No
3 - Date
4 - Time 		10 CEA
LENGTH Int 2 0 Length 11 CEA
DECIMALS Int 2 0 Decimals 12 CEA
ALLOWNULL Bool 2 0 Allow Blank
False - No
True - Yes 		13 CEA
VALIDATE Bool 2 0 Validate
False - No
True - Yes 		14 CEA
SWSET Int 2 0 Value Set
0 - No
1 - Yes
99 - Not Applicable 		15 EA
KEYACTION Int 2 0 INTERNAL USE - Key Action 19 CEA
VALINDEX Long 4 0 Typed Value Field Index 20 CEA
VALIFTEXT Char 60 0 Text Value %-60c 21 CEAP
VALIFMONEY Decimal 10 3 Amount Value 22 CEA
VALIFNUM Decimal 10 0 Number Value 23 CEA
VALIFLONG Long 4 0 Integer Value 24 CEA
VALIFBOOL Bool 2 0 Yes/No Value
False - No
True - Yes 		25 CEA
VALIFDATE Date 5 0 Date Value 26 CEA
VALIFTIME Time 5 0 Time Value 27 CEA
FDESC Char 60 0 Optional Field Description 28 CEA
VDESC Char 60 0 Value Description 29 CEA