View: Generic Cost Data

RotoID: PO0295
Table: POCOSTZ
Protocol: Flat
DLL: POCOSTZ

Compositions: 0

Keys: 6

Title	Fields

Detail Key	PRORSEQ, COSTSEQ
Account Sets	COSTSEQ
Account Sets	CRNSSEQ
Account Sets	INVSSEQ
Account Sets	RCPSSEQ
Account Sets	RETSSEQ

Fields: 77

Field	Index	Type	Title	Attributes

PRORSEQ	1	BCD*10.0	Prorate Sequence	E A K R
COSTSEQ	2	BCD*10.0	Cost Sequence	E A K R
TRANSTYPE	3	Integer	Transaction Type	E A
RCPSSEQ	4	BCD*10.0	Receipt Cost Sequence	E A
INVSSEQ	5	BCD*10.0	Invoice Cost Sequence	E A
RETSSEQ	6	BCD*10.0	Return Cost Sequence	E A
CRNSSEQ	7	BCD*10.0	Credit/Debit Note Cost Sequence	E A
PONUMBER	8	String*22	Purchase Order Number	E A
RCPNUMBER	9	String*22	Receipt Number	E A
RETNUMBER	10	String*22	Return Number	E A
INVNUMBER	11	String*22	Invoice Number	E A
CRNNUMBER	12	String*22	Credit/Debit Note Number	E A
ADDCOST	13	String*6	Additional Cost	E A
DESCRIPTIO	14	String*60	Description	E A
PRORMETHOD	15	Integer	Proration Method	E A
REPRORATE	16	Integer	Reproration Method	E A
MTOPRORATE	17	BCD*10.3	Manual To Prorate	E A
VENDOR	18	String*12	Vendor	E A
VENDORNAME	19	String*60	Name	E A
FORPRIMARY	20	Integer	Primary Vendor	E A
TAXGROUP	21	String*12	Tax Group	E A
TAXAUTH1	22	String*12	Tax Authority 1	E A
TAXAUTH2	23	String*12	Tax Authority 2	E A
TAXAUTH3	24	String*12	Tax Authority 3	E A
TAXAUTH4	25	String*12	Tax Authority 4	E A
TAXAUTH5	26	String*12	Tax Authority 5	E A
TAXVCLASS1	27	Integer	Vendor Tax Class 1	E A
TAXVCLASS2	28	Integer	Vendor Tax Class 2	E A
TAXVCLASS3	29	Integer	Vendor Tax Class 3	E A
TAXVCLASS4	30	Integer	Vendor Tax Class 4	E A
TAXVCLASS5	31	Integer	Vendor Tax Class 5	E A
TAXICLASS1	32	Integer	Cost Tax Class 1	E A
TAXICLASS2	33	Integer	Cost Tax Class 2	E A
TAXICLASS3	34	Integer	Cost Tax Class 3	E A
TAXICLASS4	35	Integer	Cost Tax Class 4	E A
TAXICLASS5	36	Integer	Cost Tax Class 5	E A
CURRENCY	37	String*3	Currency	E A
EXRATE	38	BCD*8.7	Exchange Rate	E A
RATEDATE	39	Date	Rate Date	E A
RATETYPE	40	String*2	Rate Type	E A
RATEOPER	41	Integer	Rate Operation	E A
RATEOVER	42	Boolean	Rate Overridden	E A
SCURNDECML	43	Integer	Decimal Places	E A
GLEXPACCT	44	String*45	Expense Account	E A
GLRETACCT	45	String*45	Return Account	E A
TAXINCLUD1	46	Boolean	Tax Includable 1	E A
TAXINCLUD2	47	Boolean	Tax Includable 2	E A
TAXINCLUD3	48	Boolean	Tax Includable 3	E A
TAXINCLUD4	49	Boolean	Tax Includable 4	E A
TAXINCLUD5	50	Boolean	Tax Includable 5	E A
INVSSEQG	51	BCD*10.0	Invoice Cost Group Sequence	E A
NOPRORTOGL	52	Boolean	Exp. Add'l Cost G/L data posted?	E A
COMMENT	53	String*250	Comment	E A
CONTRACT	54	String*16	Contract	E A
PROJECT	55	String*16	Project	E A
CCATEGORY	56	String*16	(Cost) Category	E A
COSTCLASS	57	Integer	Cost Class	E A
RESOURCE	58	String*24	Resource	E A
BILLTYPE	59	Integer	Billing Type	E A
BILLCURR	60	String*3	Billing Currency	E A
BCRATEDATE	61	Date	Billing Currency Conv. Rate Date	E A
ARITEMNO	62	String*16	A/R Item Number	E A
ARUNIT	63	String*10	A/R Unit of Measure	E A
CALCOVRHD	64	Boolean	Calculate Overhead	E A
CALCLABOR	65	Boolean	Calculate Labor	E A
HASRTG	66	Boolean	Has Retainage	E A
RTGRATE	67	Integer	Retainage Exchange Rate	E A
RTGPERCENT	68	BCD*5.5	Retainage Percentage	E A
RTGDAYS	69	Integer	Retention Period	E A
PMTRANSNUM	70	Long	PJC Transaction Number	E A
TRCURRENCY	71	String*3	Tax Reporting Currency	E A
EXRATERC	72	BCD*8.7	Tax Reporting Exchange Rate	E A
RATEDATERC	73	Date	Tax Reporting Rate Date	E A
RATETYPERC	74	String*2	Tax Reporting Rate Type	E A
RATEOPERRC	75	Integer	Tax Reporting Rate Operation	E A
RATERCOVER	76	Boolean	Tax Reporting Rate Overridden	E A
RCURNDECML	77	Integer	Tax Reporting Decimal Places	E A

This page was generated on 2009-Nov-19