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
…
30
Next

Showing 1 to 50 of 1463 records

PM0022 - PMPROJS - Projects

Compositions

using (HuAPConnection Connection = new HuAPConnection())
using (HuView PMPROJS = Connection.GetView("PM0022"))
using (HuView PMCONTS = Connection.GetView("PM0021"))
using (HuView PMCATGT = Connection.GetView("PM0039"))
using (HuView PMCATGTO = Connection.GetView("PM0852"))
using (HuView PMRES = Connection.GetView("PM0120"))
using (HuView PMRESC = Connection.GetView("PM0121"))
using (HuView PMRESO = Connection.GetView("PM0853"))
using (HuView PMCONO = Connection.GetView("PM0850"))
using (HuView PMPROJSO = Connection.GetView("PM0851"))
{
	PMPROJS.Compose(PMCONTS, PMCATGT, PMRES, PMRESC, PMPROJSO);
	PMCONTS.Compose(PMPROJS, PMCATGT, PMRES, PMRESC, PMCONO);
	PMCATGT.Compose(PMPROJS, PMCONTS, PMCATGTO);
	PMCATGTO.Compose(PMCATGT);
	PMRES.Compose(PMPROJS, PMCONTS, PMCATGT, PMRESC, PMRESO);
	PMRESC.Compose(PMPROJS, PMCONTS, PMCATGT, PMRES);
	PMRESO.Compose(PMRES);
	PMCONO.Compose(PMCONTS);
	PMPROJSO.Compose(PMPROJS);
	
	// Code Here
	
}

Indexes

0 - Contract Uniquifier/Line Number

CTUNIQ,PLINENUM
1 - Contract Uniquifier/Detail Numbe

CTUNIQ,DETAILNUM
2 - Contract/Project

CONTRACT,PROJECT
3 - Customer/Contract/Project

CUSTOMER,CONTRACT,PROJECT

Fields

Search:

Field Name	Type	Size	Precision	Description	Mask	Index	Attribute
CTUNIQ	Decimal	10	0	Contract Uniq		1	RKEA
PLINENUM	Long	4	0	Line Number		2	RKEA
CONTRACT	Char	16	0	Contract	%-16C	3	EA
PROJECT	Char	16	0	Project	%-16N	4	EA
DETAILNUM	Long	4	0	Detail Number		5	EA
DATELASTMN	Date	5	0	Last Maintained		6	CA
STARTDATE	Date	5	0	Projected Start Date		7	EA
ORJENDDATE	Date	5	0	Projected End Date		8	EA
CURENDDATE	Date	5	0	Current End Date		9	A
CLOSEDDATE	Date	5	0	Date Closed		10	A
DESC	Char	60	0	Description		11	EA
PROJTYPE	Int	2	0	Project Type 1 - Time and Materials 2 - Fixed Price 3 - Cost Plus		12	A
REVREC	Int	2	0	Accounting Method 1 - Completed Project 2 - Total Cost Percentage Complete 3 - Labor Hours Percentage Complete 4 - Billings and Costs 5 - Project Percentage Complete 6 - Category Percentage Complete 8 - Accrual-Basis		13	AP
COSTPLUSP	Decimal	5	5	Cost Plus Percentage		14	A
CLOSEBILL	Int	2	0	Closed to Billings 1 - Yes 0 - No		15	EA
CLOSECOST	Int	2	0	Closed to Costs 1 - Yes 0 - No		16	EA
PROJSTAT	Int	2	0	Project Status 10 - Estimate 20 - Approved 30 - Open 40 - On Hold 70 - Inactive 60 - Completed 50 - Closed		17	EA
USEDEFREV	Int	2	0	Revenue Type 0 - Revenue 1 - Deferred Revenue		18	EA
BILLTYPE	Int	2	0	Billing Type 2 - Billable 3 - No Charge 1 - Non-billable		19	EA
PERRETREC	Decimal	5	5	A/R Retainage Percentage		20	EA
RETRECD	Int	2	0	A/R Retention Period		21	EA
BILLACCT	Char	45	0	Billings	%-45C	22	EA
DEFRACCT	Char	45	0	Deferred Revenue	%-45C	23	A
REVACCT	Char	45	0	Revenue	%-45C	24	EA
PROFITACCT	Char	45	0	Profit	%-45C	25	A
LOSSACCT	Char	45	0	Loss	%-45C	26	A
GAINACCT	Char	45	0	Gain	%-45C	27	A
WIPACCT	Char	45	0	Work in Progress	%-45C	28	A
COGSACCT	Char	45	0	Cost of Sales	%-45C	29	A
PONUMBER	Char	22	0	P/O Number	%-22C	30	EA
FORMCODE	Char	6	0	Form Code	%-6N	31	EA
INVTYPE	Int	2	0	A/R Invoice Type 1 - Item 2 - Summary		32	A
ORATE	Decimal	8	7	Original Exchange Rate		33	A
ORATETYPE	Char	2	0	Original Rate Type	%-2N	34	A
ORATEDATE	Date	5	0	Original Rate Date		35	A
RATE	Decimal	8	7	Exchange Rate		36	EA
RATETYPE	Char	2	0	Rate Type	%-2N	37	EA
RATEOP	Int	2	0	Rate Operator 1 - Multiply 2 - Divide		38	EA
RATEDATE	Date	5	0	Rate Date		39	EA
RATESPREAD	Decimal	8	7	Rate Spread		40	EA
ESTBILLCCY	Int	2	0	Revenue And Cost Currency 1 - Revenue and Costs in Functional Currency 2 - Revenue in Customer Currency 3 - Revenue and Costs in Customer Currency		41	EA
COSTCCY	Char	3	0	Cost Currency	%-3N	42	EA
REVCCY	Char	3	0	Revenue Currency	%-3N	43	EA
INVSTATE	Int	2	0	Invoice Status 1 - Not Processed 2 - On Worksheet 3 - On Invoice		44	EA
NUMCATS	Long	4	0	Number of Categories		45	EA
ORJTIMECSR	Decimal	10	3	Reserved		46	A
ORJTIMECHM	Decimal	10	3	Orig. Labor Cost Est.		47	A
CURTIMECSR	Decimal	10	3	Reserved		48	A
CURTIMECHM	Decimal	10	3	Cur. Labor Cost Est.		49	A
ACTTIMECSR	Decimal	10	3	Reserved		50	A
ACTTIMECHM	Decimal	10	3	Actual Labor Costs		51	A
RECTIMECSR	Decimal	10	3	Reserved		52	A
RECTIMECHM	Decimal	10	3	Reserved		53	A
ORJTIMEBSR	Decimal	10	3	Orig. Labor Billing Est.		56	A
ORJTIMEBHM	Decimal	10	3	Orig. Labor Billing Est.		57	A
CURTIMEBSR	Decimal	10	3	Cur. Labor Billing Est.		58	A
CURTIMEBHM	Decimal	10	3	Cur. Labor Billing Est.		59	A
ACTTIMEBSR	Decimal	10	3	Actual Labor Billings		60	A
ACTTIMEBHM	Decimal	10	3	Actual Labor Billings		61	A
RECTIMEBSR	Decimal	10	3	Reserved		62	A
RECTIMEBHM	Decimal	10	3	Reserved		63	A
ORJTIMEQTY	Decimal	10	5	Orig. Labor Qty Est.		66	A
CURTIMEQTY	Decimal	10	5	Cur. Labor Qty Est.		67	A
ACTTIMEQTY	Decimal	10	5	Actual Labor Qty		68	A
PERTIMEQTY	Decimal	5	5	Labor Percentage Complete		69	A
ORJMATECSR	Decimal	10	3	Reserved		70	A
ORJMATECHM	Decimal	10	3	Orig. Material Estimated Cost		71	A
CURMATECSR	Decimal	10	3	Reserved		72	A
CURMATECHM	Decimal	10	3	Current Material Estimated Cost		73	A
ACTMATECSR	Decimal	10	3	Reserved		74	A
ACTMATECHM	Decimal	10	3	Actual Material Cost		75	A
RECMATECSR	Decimal	10	3	Reserved		76	A
RECMATECHM	Decimal	10	3	Reserved		77	A
ORJMATEBSR	Decimal	10	3	Orig. Material Billing Est.		80	A
ORJMATEBHM	Decimal	10	3	Orig. Material Billing Est.		81	A
CURMATEBSR	Decimal	10	3	Cur. Material Billing Est.		82	A
CURMATEBHM	Decimal	10	3	Cur. Material Billing Est.		83	A
ACTMATEBSR	Decimal	10	3	Actual Material Billed		84	A
ACTMATEBHM	Decimal	10	3	Actual Material Billed		85	A
RECMATEBSR	Decimal	10	3	Reserved		86	A
RECMATEBHM	Decimal	10	3	Reserved		87	A
ORJMATEQTY	Decimal	10	5	Orig. Material Qty Est.		90	A
CURMATEQTY	Decimal	10	5	Cur. Material Est.		91	A
ACTMATEQTY	Decimal	10	5	Actual Material Qty		92	A
ORJEQUICSR	Decimal	10	3	Reserved		94	A
ORJEQUICHM	Decimal	10	3	Orig. Estimated Equipment Cost		95	A
CUREQUICSR	Decimal	10	3	Reserved		96	A
CUREQUICHM	Decimal	10	3	Cur. Estimated Equipment Cost		97	A
ACTEQUICSR	Decimal	10	3	Reserved		98	A
ACTEQUICHM	Decimal	10	3	Actual Equipment Cost		99	A
RECEQUICSR	Decimal	10	3	Reserved		100	A
RECEQUICHM	Decimal	10	3	Reserved		101	A
ORJEQUIBSR	Decimal	10	3	Orig. Equipment Billing Est.		104	A
ORJEQUIBHM	Decimal	10	3	Orig. Equipment Billing Est.		105	A
CUREQUIBSR	Decimal	10	3	Cur. Equipment Billing Est.		106	A
CUREQUIBHM	Decimal	10	3	Cur. Equipment Billing Est.		107	A
ACTEQUIBSR	Decimal	10	3	Actual Equipment Amount Billed		108	A
ACTEQUIBHM	Decimal	10	3	Actual Equipment Amount Billed		109	A
RECEQUIBSR	Decimal	10	3	Reserved		110	A
RECEQUIBHM	Decimal	10	3	Reserved		111	A
ORJEQUIQTY	Decimal	10	5	Orig. Equipment Qty Est.		114	A
CUREQUIQTY	Decimal	10	5	Cur. Equipment Est.		115	A
ACTEQUIQTY	Decimal	10	5	Actual Equipment Qty		116	A
ORJSUBCCSR	Decimal	10	3	Reserved		118	A
ORJSUBCCHM	Decimal	10	3	Orig. Subcontractor Est. Cost		119	A
CURSUBCCSR	Decimal	10	3	Reserved		120	A
CURSUBCCHM	Decimal	10	3	Cur. Subcontractor Est. Cost		121	A
ACTSUBCCSR	Decimal	10	3	Reserved		122	A
ACTSUBCCHM	Decimal	10	3	Actual Subcontractor Cost		123	A
RECSUBCCSR	Decimal	10	3	Reserved		124	A
RECSUBCCHM	Decimal	10	3	Reserved		125	A
ORJSUBCBSR	Decimal	10	3	Orig. Subcontract Billing Est.		128	A
ORJSUBCBHM	Decimal	10	3	Orig. Subcontract Billing Est.		129	A
CURSUBCBSR	Decimal	10	3	Cur. Subcontract Billing Est.		130	A
CURSUBCBHM	Decimal	10	3	Cur. Subcontract Billing Est.		131	A
ACTSUBCBSR	Decimal	10	3	Actual Subcontract Amt Billed		132	A
ACTSUBCBHM	Decimal	10	3	Actual Subcontract Amt Billed		133	A
RECSUBCBSR	Decimal	10	3	Reserved		134	A
RECSUBCBHM	Decimal	10	3	Reserved		135	A
ORJSUBCQTY	Decimal	10	5	Orig. Subcontractor Qty Est.		138	A
CURSUBCQTY	Decimal	10	5	Cur. Subcontractor Est.		139	A
ACTSUBCQTY	Decimal	10	5	Actual Subcontractor Qty		140	A
ORJOHEXCSR	Decimal	10	3	Reserved		142	A
ORJOHEXCHM	Decimal	10	3	Orig. Est Overhead Expense Cost		143	A
CUROHEXCSR	Decimal	10	3	Reserved		144	A
CUROHEXCHM	Decimal	10	3	Cur. Est. Overhead Expense Cost		145	A
ACTOHEXCSR	Decimal	10	3	Reserved		146	A
ACTOHEXCHM	Decimal	10	3	Actual Overhead Expense Cost		147	A
RECOHEXCSR	Decimal	10	3	Reserved		148	A
RECOHEXCHM	Decimal	10	3	Reserved		149	A
ORJOHEXBSR	Decimal	10	3	Orig. Overhead Billing Est.		152	A
ORJOHEXBHM	Decimal	10	3	Orig. Overhead Billing Est.		153	A
CUROHEXBSR	Decimal	10	3	Cur. Overhead Billing Est.		154	A
CUROHEXBHM	Decimal	10	3	Cur. Overhead Billing Est.		155	A
ACTOHEXBSR	Decimal	10	3	Actual Overhead Amount Billed		156	A
ACTOHEXBHM	Decimal	10	3	Actual Overhead Billing Est.		157	A
RECOHEXBSR	Decimal	10	3	Reserved		158	A
RECOHEXBHM	Decimal	10	3	Reserved		159	A
ORJOHEXQTY	Decimal	10	5	Orig. Overhead Qty Est.		162	A
CUROHEXQTY	Decimal	10	5	Cur. Overhead Est.		163	A
ACTOHEXQTY	Decimal	10	5	Actual Overhead Qty		164	A
ORJMISCCSR	Decimal	10	3	Reserved		166	A
ORJMISCCHM	Decimal	10	3	Orig. Est. Miscellaneous Cost		167	A
CURMISCCSR	Decimal	10	3	Reserved		168	A
CURMISCCHM	Decimal	10	3	Cur. Est. Miscellaneous Cost		169	A
ACTMISCCSR	Decimal	10	3	Reserved		170	A
ACTMISCCHM	Decimal	10	3	Actual Miscellaneous Cost		171	A
RECMISCCSR	Decimal	10	3	Reserved		172	A
RECMISCCHM	Decimal	10	3	Reserved		173	A
ORJMISCBSR	Decimal	10	3	Orig. Miscellaneous Billing Est		176	A
ORJMISCBHM	Decimal	10	3	Orig. Miscellaneous Billing Est		177	A
CURMISCBSR	Decimal	10	3	Cur. Miscellaneous Billing Est.		178	A
CURMISCBHM	Decimal	10	3	Cur. Miscellaneous Billing Est.		179	A
ACTMISCBSR	Decimal	10	3	Actual Miscellaneous Amt Billed		180	A
ACTMISCBHM	Decimal	10	3	Actual Miscellaneous Amt Billed		181	A
RECMISCBSR	Decimal	10	3	Reserved		182	A
RECMISCBHM	Decimal	10	3	Reserved		183	A
ORJMISCQTY	Decimal	10	5	Orig. Miscellaneous Qty Est.		186	A
CURMISCQTY	Decimal	10	5	Cur. Miscellaneous Qty Est.		187	A
ACTMISCQTY	Decimal	10	5	Actual Miscellaneous Qty		188	A
ORJOHEADSR	Decimal	10	3	Reserved		190	A
ORJOHEADHM	Decimal	10	3	Original Overhead Estimate		191	A
CUROHEADSR	Decimal	10	3	Reserved		192	A
CUROHEADHM	Decimal	10	3	Current Overhead Estimate		193	A
ACTOHEADSR	Decimal	10	3	Reserved		194	A
ACTOHEADHM	Decimal	10	3	Actual Overhead		195	A
ORJLABSR	Decimal	10	3	Reserved		199	A
ORJLABHM	Decimal	10	3	Original Labor Amount Estimate		200	A
CURLABSR	Decimal	10	3	Reserved		201	A
CURLABHM	Decimal	10	3	Current Labor Amount Estimate		202	A
ACTLABSR	Decimal	10	3	Reserved		203	A
ACTLABHM	Decimal	10	3	Actual Labor Amount		204	A
ORJCHRGSR	Decimal	10	3	Reserved		208	A
ORJCHRGHM	Decimal	10	3	Reserved		209	A
CURCHRGSR	Decimal	10	3	Reserved		210	A
CURCHRGHM	Decimal	10	3	Reserved		211	A
ACTCHRGSR	Decimal	10	3	Actual Charge Amount		212	A
ACTCHRGHM	Decimal	10	3	Actual Charge Amount		213	A
ACTCHRGDSR	Decimal	10	3	Act Chrg Amt Billed & Deferred		214	A
ACTCHRGDHM	Decimal	10	3	Act Chrg Amt Billed & Deferred		215	A
RECCHRGSR	Decimal	10	3	Reserved		216	A
RECCHRGHM	Decimal	10	3	Reserved		217	A
ACTSTKRESR	Decimal	10	3	Reserved		220	A
ACTSTKREHM	Decimal	10	3	Act Cost Stock Ret to Inventory		221	A
ACTSTKRQTY	Decimal	10	5	Act Qty Stock Ret to Inventory		222	A
TARRECTSSR	Decimal	10	3	Total A/R Customer Receipts		223	A
TARRECTSHM	Decimal	10	3	Total A/R Customer Receipts		224	A
TAPPAYMTS	Decimal	10	3	Total A/P Vendor Payments		225	A
TORJCOSTSR	Decimal	10	3	Reserved		226	A
TORJCOSTHM	Decimal	10	3	Total Orig. Cost Est.		227	A
TCURCOSTSR	Decimal	10	3	Reserved		228	A
TCURCOSTHM	Decimal	10	3	Total Cur. Cost Est.		229	A
TACTCOSTSR	Decimal	10	3	Reserved		230	A
TACTCOSTHM	Decimal	10	3	Total Actual Cost		231	A
TRECCOSTSR	Decimal	10	3	Reserved		232	A
TRECCOSTHM	Decimal	10	3	Total Cost Recognized		233	A
PERTCOST	Decimal	5	5	Percent Total Cost		234	A
PERTREV	Decimal	5	5	Percent Total Revenue		235	EA
TORJREVSR	Decimal	10	3	Total Orig. Revenue Est.		236	A
TORJREVHM	Decimal	10	3	Total Orig. Revenue Est.		237	A
TCURREVSR	Decimal	10	3	Total Cur. Revenue Est.		238	A
TCURREVHM	Decimal	10	3	Total Cur. Revenue Est.		239	A
TACTREVSR	Decimal	10	3	Total Actual Revenue		240	A
TACTREVHM	Decimal	10	3	Total Actual Revenue		241	A
TRECREVSR	Decimal	10	3	Total Revenue Recognized		242	A
TRECREVHM	Decimal	10	3	Total Revenue Recognized		243	A
RETARAMTSR	Decimal	10	3	Retainage Receivable		246	A
RETARAMTHM	Decimal	10	3	Retainage Receivable		247	A
RETARRECSR	Decimal	10	3	Retainage Amount Received in A/R		248	A
RETARRECHM	Decimal	10	3	Retainage Amount Received in A/R		249	A
RETAPAMT	Decimal	10	3	Retainage Payable		250	A
RETAPPAID	Decimal	10	3	Retainage Amount Paid in A/P		251	A
POAMOUNTSR	Decimal	10	3	Reserved		252	A
POAMOUNTHM	Decimal	10	3	Reserved		253	A
POQTY	Decimal	10	5	Committed P/O Quantity		254	CA
OEAMOUNTSR	Decimal	10	3	Reserved		255	A
OEAMOUNTHM	Decimal	10	3	Recognized Loss		256	A
OEQTY	Decimal	10	5	Reserved		257	A
PCOMPLETEB	Decimal	5	5	Billings Percent Complete		260	A
PCOMPLETER	Decimal	5	5	RR Percent Complete		262	A
FPAMOUNTSR	Decimal	10	3	Fixed Price Amount		263	A
FPAMOUNTHM	Decimal	10	3	Fixed Price Amount		264	A
LSTBILLPER	Decimal	5	5	Last Billings Percent Complete		265	A
BILLAMTRSR	Decimal	10	3	Recognized Amount to Bill		266	EA
BILLAMTRHM	Decimal	10	3	Recognized Amount to Bill		267	EA
COSTDATE	Date	5	0	Last Cost Posting Date		268	A
BILLDATE	Date	5	0	Last Billings Posting Date		269	A
OHDATE	Date	5	0	Last Overhead Posting Date		270	A
CHARGEDATE	Date	5	0	Last Charge Posting Date		271	A
REVRECDATE	Date	5	0	Last Revenue Rec Posting Date		272	A
ARRECDATE	Date	5	0	Last A/R Receipt Posting Date		273	A
APPAYDATE	Date	5	0	Last A/P Payment Posting Date		274	A
TIMEDATE	Date	5	0	Last Timecard Posting Date		275	A
STKTRDATE	Date	5	0	Last Material Usage Posting Date		276	A
STKRETDATE	Date	5	0	Last Material Return Posting Dat		277	A
EQUIPDATE	Date	5	0	Last Equipment Posting Date		278	A
PODATE	Date	5	0	Last Purchase Order Date		279	A
PORECDATE	Date	5	0	Last P/O Receipt Date		280	A
PORETDATE	Date	5	0	Last P/O Return Date		281	A
OEORDDATE	Date	5	0	Reserved		282	A
OEINVDATE	Date	5	0	Last O/E Invoice Date		283	A
PTAXTOTAL	Decimal	10	3	Project tax total		284	EA
TAUTH1	Char	12	0	Tax Authority 1	%-12N	285	A
TAUTH2	Char	12	0	Tax Authority 2	%-12N	286	A
TAUTH3	Char	12	0	Tax Authority 3	%-12N	287	A
TAUTH4	Char	12	0	Tax Authority 4	%-12N	288	A
TAUTH5	Char	12	0	Tax Authority 5	%-12N	289	A
TCLASS1	Int	2	0	Tax Class 1		290	A
TCLASS2	Int	2	0	Tax Class 2		291	A
TCLASS3	Int	2	0	Tax Class 3		292	A
TCLASS4	Int	2	0	Tax Class 4		293	A
TCLASS5	Int	2	0	Tax Class 5		294	A
TINCLUDED1	Bool	2	0	Tax Included 1		295	A
TINCLUDED2	Bool	2	0	Tax Included 2		296	A
TINCLUDED3	Bool	2	0	Tax Included 3		297	A
TINCLUDED4	Bool	2	0	Tax Included 4		298	A
TINCLUDED5	Bool	2	0	Tax Included 5		299	A
TAXBASES1	Decimal	10	3	Tax Base 1		300	EA
TAXBASES2	Decimal	10	3	Tax Base 2		301	EA
TAXBASES3	Decimal	10	3	Tax Base 3		302	EA
TAXBASES4	Decimal	10	3	Tax Base 4		303	EA
TAXBASES5	Decimal	10	3	Tax Base 5		304	EA
TAXBASEH1	Decimal	10	3	Tax Base 1		305	EA
TAXBASEH2	Decimal	10	3	Tax Base 2		306	EA
TAXBASEH3	Decimal	10	3	Tax Base 3		307	EA
TAXBASEH4	Decimal	10	3	Tax Base 4		308	EA
TAXBASEH5	Decimal	10	3	Tax Base 5		309	EA
TAXAMTS1	Decimal	10	3	Tax Amount 1		310	EA
TAXAMTS2	Decimal	10	3	Tax Amount 2		311	EA
TAXAMTS3	Decimal	10	3	Tax Amount 3		312	EA
TAXAMTS4	Decimal	10	3	Tax Amount 4		313	EA
TAXAMTS5	Decimal	10	3	Tax Amount 5		314	EA
TAXAMTH1	Decimal	10	3	Tax Amount 1		315	EA
TAXAMTH2	Decimal	10	3	Tax Amount 2		316	EA
TAXAMTH3	Decimal	10	3	Tax Amount 3		317	EA
TAXAMTH4	Decimal	10	3	Tax Amount 4		318	EA
TAXAMTH5	Decimal	10	3	Tax Amount 5		319	EA
ONBW	Bool	2	0	On Billing Worksheet		320	EA
OPENED	Bool	2	0	Project Has Been Opened False - No True - Yes		321	EA
BILLAMT	Decimal	10	3	Expected Billings		322	A
ORATEOP	Int	2	0	Rate Operator 1 - Multiply 2 - Divide		323	EA
LSTRRPER	Decimal	5	5	Last Rev. Recognition Percentage		324	A
PRFTLOSSSR	Decimal	10	3	Recognized Profit / Loss		325	EA
PRFTLOSSHM	Decimal	10	3	Recognized Profit / Loss		326	EA
REVESTDATE	Date	5	0	Last Revised Posting Date		327	A
ONRW	Bool	2	0	On RR Worksheet		328	EA
OLABEMHM	Decimal	10	3	Original Employee Labor		329	A
CLABEMHM	Decimal	10	3	Current Employee Labor		330	A
ALABEMHM	Decimal	10	3	Actual Employee Labor		331	A
OOHEMHM	Decimal	10	3	Original Employee Overhead		332	A
COHEMHM	Decimal	10	3	Current Employee Overhead		333	A
AOHEMHM	Decimal	10	3	Actual Employee Overhead		334	A
OOHEQHM	Decimal	10	3	Original Equipment Overhead		335	A
COHEQHM	Decimal	10	3	Current Equipment Overhead		336	A
AOHEQHM	Decimal	10	3	Actual Equipment Overhead		337	A
OOHSUHM	Decimal	10	3	Original Subcontractor Overhead		338	A
COHSUHM	Decimal	10	3	Current Subcontractor Overhead		339	A
AOHSUHM	Decimal	10	3	Actual Subcontractor Overhead		340	A
OOHOHHM	Decimal	10	3	Original Overhead Overhead		341	A
COHOHHM	Decimal	10	3	Current Overhead Overhead		342	A
AOHOHHM	Decimal	10	3	Actual Overhead Overhead		343	A
OOHMIHM	Decimal	10	3	Original Miscellaneous Overhead		344	A
COHMIHM	Decimal	10	3	Current Miscellaneous Overhead		345	A
AOHMIHM	Decimal	10	3	Actual Miscellaneous Overhead		346	A
OOHMAHM	Decimal	10	3	Original Material Overhead		347	A
COHMAHM	Decimal	10	3	Current Material Overhead		348	A
AOHMAHM	Decimal	10	3	Actual Material Overhead		349	A
CDATEFROM	Date	5	0	Current Start Date		350	A
PROJSTYLE	Int	2	0	Project Style 1 - Standard 2 - Basic		351	EA
APTAXEXPHM	Decimal	10	3	Reserved		352	A
APTAXRECHM	Decimal	10	3	Reserved		353	A
APTAXEXCHM	Decimal	10	3	Reserved		354	A
APDISCHM	Decimal	10	3	Reserved		355	A
APINTHM	Decimal	10	3	Reserved		356	A
ARTAXHM	Decimal	10	3	Reserved		357	A
ARTAXSR	Decimal	10	3	Reserved		358	A
ARDISCHM	Decimal	10	3	Reserved		359	A
ARDISCSR	Decimal	10	3	Reserved		360	A
ARINTHM	Decimal	10	3	Reserved		361	A
ARINTSR	Decimal	10	3	Reserved		362	A
ARWRITEHM	Decimal	10	3	Reserved		363	A
ARWRITESR	Decimal	10	3	Reserved		364	A
PLCODE	Char	16	0	Reserved		365	A
BILLAMTC	Decimal	10	3	Current Billings (AR and on BW)		366	A
POCOSTHM	Decimal	10	3	Committed P/O Cost		367	CA
POOHHM	Decimal	10	3	Committed P/O Overhead		368	CA
POLABORHM	Decimal	10	3	Committed P/O Labor		369	CA
POTCOSTHM	Decimal	10	3	Committed P/O Total Cost		370	CA
POEMQTY	Decimal	10	5	P/O Employee Quantity		371	A
POEMOHHM	Decimal	10	3	P/O Employee Overhead		372	A
POEMLABHM	Decimal	10	3	P/O Employee Labor		373	A
POEMTCOSTH	Decimal	10	3	P/O Employee Total Cost		374	A
POEQQTY	Decimal	10	5	P/O Equipment Quantity		375	A
POEQOHHM	Decimal	10	3	P/O Equipment Overhead		376	A
POEQTCOSTH	Decimal	10	3	P/O Equipment Total Cost		377	A
POSUQTY	Decimal	10	5	P/O Subcontractor Quantity		378	A
POSUOHHM	Decimal	10	3	P/O Subcontractor Overhead		379	A
POSUTCOSTH	Decimal	10	3	P/O Subcontractor Total Cost		380	A
POOHQTY	Decimal	10	5	P/O Overhead Quantity		381	A
POOHOHHM	Decimal	10	3	P/O Overhead Overhead		382	A
POOHTCOSTH	Decimal	10	3	P/O Overhead Total Cost		383	A
POMIQTY	Decimal	10	5	P/O Miscellaneous Quantity		384	A
POMIOHHM	Decimal	10	3	P/O Miscellaneous Overhead		385	A
POMITCOSTH	Decimal	10	3	P/O Miscellaneous Total Cost		386	A
POMAQTY	Decimal	10	5	P/O Material Quantity		387	A
POMAOHHM	Decimal	10	3	P/O Material Overhead		388	A
POMATCOSTH	Decimal	10	3	P/O Material Total Cost		389	A
VALUES	Long	4	0	Optional Fields		390	CEA
CLEARED	Int	2	0	Transactions have been cleared 0 - No 1 - Yes		391	EA
CODETAXGRP	Char	12	0	Tax Group	%-12N	392	EA
CTCLASS1	Int	2	0	Customer Tax Class 1		393	EA
CTCLASS2	Int	2	0	Customer Tax Class 2		394	EA
CTCLASS3	Int	2	0	Customer Tax Class 3		395	EA
CTCLASS4	Int	2	0	Customer Tax Class 4		396	EA
CTCLASS5	Int	2	0	Customer Tax Class 5		397	EA
CTAUTH1	Char	12	0	Customer Tax Authority 1		398	EA
CTAUTH2	Char	12	0	Customer Tax Authority 2		399	EA
CTAUTH3	Char	12	0	Customer Tax Authority 3		400	EA
CTAUTH4	Char	12	0	Customer Tax Authority 4		401	EA
CTAUTH5	Char	12	0	Customer Tax Authority 5		402	EA
LUPDATE	Date	5	0	Last US Payroll Posting Date		403	A
LCPDATE	Date	5	0	Last Canadian Payroll Posting Da		404	A
STRDCOSTHM	Decimal	10	3	Stored Cost		405	A
STRDBILLSR	Decimal	10	3	Stored Billable Amount		406	A
PRECOLEDSR	Decimal	10	3	Previous D + E		407	A
STRDOHHM	Decimal	10	3	Overhead Amount		408	A
STRDTCSTHM	Decimal	10	3	Total Stored Cost		409	A
TXEXPCOMHM	Decimal	10	3	Tax (exp) Committed (func)		410	A
TXALLCOMHM	Decimal	10	3	Tax (all) Committed (func)		411	A
STRDQTY	Decimal	10	5	Stored Quantity		412	A
PREAIAPAY	Decimal	10	3	Previous Certificates for Paymen		413	A
PRESTORED	Decimal	10	3	G703 Column F from Last AIA Repo		414	A
PRERETAIN	Decimal	10	3	G703 Column I from Last AIA Repo		415	A
CUSTOMER	Char	12	0	Customer	%-12C	416	EA
IDACCTSET	Char	6	0	Account Set	%-6N	417	EA
CUSTCCY	Char	3	0	Customer Currency		418	EA
CUSCONTACT	Char	60	0	Contact		419	EA
CTACTITTLE	Char	60	0	Position		420	EA
CTACPHONE	Char	30	0	Phone	(%-3C) %-3C-%-24C	421	EA
OTHERPHONE	Char	30	0	Other Phone	(%-3C) %-3C-%-24C	422	EA
CTACFAX	Char	30	0	Fax	(%-3C) %-3C-%-24C	423	EA
CTACEMAIL	Char	60	0	E-mail		424	EA
MULTICUST	Int	2	0	Invoice to Multiple Customers 1 - Yes 0 - No		425	EA
BILLED	Int	2	0	Has this Project been billed?		426	EA
OESHPDATE	Date	5	0	Last O/E Shipment Date		427	A
PRICEOPT	Int	2	0	Default Billing Rate 1 - Billing Rate 2 - Use Customer Price List 3 - Use Specified Price List		428	EA
PRICELIST	Char	6	0	Price List	%-6N	429	A
OEMCHGOPT	Int	2	0	O/E Miscellaneous Charges 0 - Default Cost from Contract 1 - Default Cost from Misc. Charges		430	EA
ARACCTSET	Char	6	0	A/R Account Set	%-6N	431	EA
UPCP	Int	2	0	Update Category Cost Plus %		1001	CEA
FUNCTION	Int	2	0	Function 0 - None 2 - Can insert categories? 3 - Reload Blank Accounts 10 - Load Optional Fields		1002	CEA
RATEERR	Int	2	0	Rate Error Code 0 - No rate error 1 - Rate type is invalid 2 - Rate is zero 3 - Rate is outside spread 4 - No rate information exists		1003	CEA
BILLDESC	Char	60	0	Billing Account Description		1004	CA
REVDESC	Char	60	0	Revenue Account Description		1005	CA
WIPDESC	Char	60	0	WIP Account Description		1006	CA
COGSDESC	Char	60	0	COGS Account Description		1007	CA
RCOSTPLUSP	Decimal	5	5	Cost Plus % at Read		1008	CA
ORJQTY	Decimal	10	5	Quantity		1010	CA
CURQTY	Decimal	10	5	Current Quantity Estimate		1011	CA
ACTQTY	Decimal	10	5	Actual Quantity		1012	CA
ORJCOSTHM	Decimal	10	3	Extended Cost		1013	CA
CURCOSTHM	Decimal	10	3	Current Cost Estimate		1014	CA
ACTCOSTHM	Decimal	10	3	Actual Cost		1015	CA
SNAPCALC	Int	2	0	Extended Cost		1016	EA
SNAPOFROM	Date	5	0	Extended Cost		1017	EA
SNAPOTO	Date	5	0	Extended Cost		1018	EA
SNAPCFROM	Date	5	0	Extended Cost		1019	A
SNAPCTO	Date	5	0	Extended Cost		1020	A
HASOPT	Bool	2	0	Optional Fields True - Yes False - No		1021	CEA
OPENING	Int	2	0	Optional Fields 0 - Not opening 1 - Contract opening 2 - Project opening		1022	CEA
UPDATE	Int	2	0	Optional Fields		1023	CEA
CUSTNAME	Char	60	0	Customer Name		1024	CA