View: Opening Balances Audit Detail

RotoID: PM0404
Tables: PMOBDA
DLL: PMOBDA

Compositions: 0

Keys: 3

Title	Fields

	POSTSEQNO, LINENO
	POSTSEQNO, DETAILNUM
	SEQ, POSTSEQNO, DETAILNUM

Fields: 72

Field	Index	Type	Title	Attributes

POSTSEQNO	1	Long	POSTSEQNO	E A K R
LINENO	2	Integer	LINENO	E A K R
SEQ	3	Long	SEQ	E A
DOCNUM	4	String*16	DOCNUM	E A C
OPENTYPE	5	Integer	OPENTYPE	E A
FMTCONTNO	6	String*16	FMTCONTNO	E A
CONTRACT	7	String*16	CONTRACT	E A
PROJECT	8	String*16	PROJECT	E A
CATEGORY	9	String*16	CATEGORY	E A
RESOURCE	10	String*24	RESOURCE	E A
COSTTYPE	11	Integer	COSTTYPE	E A
DETAILNUM	12	Long	DETAILNUM	E A C
COMMENTS	13	String*250	COMMENTS	E A
CUSTOMER	14	String*12	CUSTOMER	E A C
BILLCCY	15	String*3	BILLCCY	E A C
RATETYPE	16	String*2	RATETYPE	E A
RATEOP	17	Integer	RATEOP	E A C
RATEDATE	18	Date	RATEDATE	E A
RATE	19	BCD*8.7	RATE	E A
RATESPREAD	20	BCD*8.7	RATESPREAD	E A C
OQTY	21	BCD*10.5	OQTY	E A C
AQTY	22	BCD*10.5	AQTY	E A
OARITEM	23	String*16	OARITEM	E A
OARUOM	24	String*10	OARUOM	E A C
OUNITCOST	25	BCD*10.6	OUNITCOST	E A C
OEXTCOSTSR	26	BCD*10.3	OEXTCOSTSR	E A C
OEXTCOSTHM	27	BCD*10.3	OEXTCOSTHM	E A C
AEXTCOSTSR	28	BCD*10.3	AEXTCOSTSR	E A
AEXTCOSTHM	29	BCD*10.3	AEXTCOSTHM	E A
OOHTYPE	30	Integer	OOHTYPE	E A C
OOHRATE	31	BCD*10.6	OOHRATE	E A C
OOHPER	32	BCD*5.5	OOHPER	E A C
OOHSR	33	BCD*10.3	OOHSR	E A C
OOHHM	34	BCD*10.3	OOHHM	E A C
AOHSR	35	BCD*10.3	AOHSR	E A
AOHHM	36	BCD*10.3	AOHHM	E A
OLABORTYPE	37	Integer	OLABORTYPE	E A C
OLABORRATE	38	BCD*10.6	OLABORRATE	E A C
OLABORPER	39	BCD*5.5	OLABORPER	E A C
OLABORSR	40	BCD*10.3	OLABORSR	E A C
OLABORHM	41	BCD*10.3	OLABORHM	E A C
ALABORSR	42	BCD*10.3	ALABORSR	E A
ALABORHM	43	BCD*10.3	ALABORHM	E A
OTOTCOSTSR	44	BCD*10.3	OTOTCOSTSR	E A C
OTOTCOSTHM	45	BCD*10.3	OTOTCOSTHM	E A C
ATOTCOSTSR	46	BCD*10.3	ATOTCOSTSR	E A C
ATOTCOSTHM	47	BCD*10.3	ATOTCOSTHM	E A C
OBILLTYPE	48	Integer	OBILLTYPE	E A C
OBILLRATE	49	BCD*10.6	OBILLRATE	E A C
OBILLSR	50	BCD*10.3	OBILLSR	E A C
OBILLHM	51	BCD*10.3	OBILLHM	E A C
ABILLSR	52	BCD*10.3	ABILLSR	E A
ABILLHM	53	BCD*10.3	ABILLHM	E A
RBILLSR	54	BCD*10.3	RBILLSR	E A
OPROFITSR	55	BCD*10.3	OPROFITSR	E A C
OPROFITHM	56	BCD*10.3	OPROFITHM	E A C
APROFITSR	57	BCD*10.3	APROFITSR	E A C
APROFITHM	58	BCD*10.3	APROFITHM	E A C
TARRECTSSR	300	BCD*10.3	None	E A
ARRECDATE	301	Date	- Hyphen	E A
TAPPAYMTS	302	BCD*10.3	/ Forward Slash	E A
APPAYDATE	303	Date	\ Back Slash	E A
COSTDATE	304	Date	* Asterisk	E A
BILLDATE	305	Date	. Period	E A
REVRECDATE	306	Date	( Left Parenthesis	E A
REVESTDATE	307	Date	) Right Parenthesis	E A
LSTBILLPER	308	BCD*5.5	# Number Sign	E A
CONTSTYLE	500	Integer	Non-billable	E A C
PROJTYPE	501	Integer	Billable	E A C
REVREC	502	Integer	No Charge	E A C
INVTYPE	503	Integer	INVTYPE	E A C
REVERSED	504	Integer	REVERSED	E A C

This page was generated on 2004-Oct-28