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

Pages:
Previous
1
2
3
…
11
Next

Showing 1 to 50 of 513 records

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

Search:

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
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
ORIGCOMP	Char	6	0	Originator	%-6N	155	EA
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