Populated Tables

This table lists fields in the Billing Detail Workfile table (F4812) that relate to retainage and that are populated when you run Invoice Generation (R52121) with Journal Generation (R48131):

COCH	OPIM	TCLS	JTAX	ITOL	ITXA	ITAM	RGLC
000	001	8	105.00	3,105.00	3,000.00	105.00	RETN
000	002	8	2.73	80.73	78.00	2.73	RETN
000	003	8	9.63	284.63	275.00	9.63	RETN
000	004	8	15.93	470.93	455.00	15.93	RETN
000	005	8	9.63–	284.63–	275.00–	9.63–	RETN
000	006	8	4.55–	134.55–	130.00–	4.55–	RETN
000	007	Blank	26.25	776.25	750.00	26.25	RETN
001	001	8	3.50	103.50	100.00	3.50	RETN

This table lists fields in the Invoice Summary Work File table (F4822) that relate to retainage and that are populated when you run Invoice Generation (R52121) with Journal Generation (R48131):

COCH	OPIM	THPD	STAM	ATXA	RTNG	RGLC	RTNR
000	001	3,105.00	105.00	3,000.00	450.00	RETN	B
000	002	80.73	2.73	78.00	7.80	RETN	Blank
000	003	284.63	9.63	275.00	27.50	RETN	Blank
000	004	470.93	15.93	455.00	45.50	RETN	Blank
000	005	284.63–	9.63–	275.00–		RETN	Blank
000	006	134.55–	4.55–	130.00–		RETN	Blank
000	007	776.25	26.25	750.00	75.00	RETN	Blank
001	001	103.50	3.50	100.00	5.00	RETN	Blank

This table lists fields in the Billing Detail Journal Workfile table (F48S910) that relate to retainage and that are populated when you run Invoice Generation (R52121) with Journal Generation (R48131):

COCH	LNID	TCLS	AA
000	.100	8	3,105.00–
000	.200	8	80.73–
000	.300	8	284.63–
000	.400	8	470.93–
000	.500	8	284.63
000	.600	8	134.55
000	.700	Blank	776.25–
001	.100	8	103.50–

The AA field in the Summarized Journal Workfile table (F48S911) relates to retainage and is populated with 4,401.86– when you run Invoice Generation (R52121) with Journal Generation (R48131):

AA
4,401.86–