Internal Reconciliation - Rows

Table Name: ITR1

Table Description: Internal Reconciliation - Rows

Field	Description	Type	Size	Related	Default Value	Constraints
ReconNum	Reconciliation Number	Int	11	OITR
LineSeq	Row Number	Int	11	-
ShortName	BP/Account Code	nVarChar	15	-
TransId	Transaction Internal ID	Int	11	OJDT
TransRowId	Transaction Row Number	Int	11	-
SrcObjTyp	Source Object Type	nVarChar	20	-		30	Journal Transactions
						13	Invoices
						18	Purchases
						24	Receipts
						46	Outgoing Payments
						14	Revert Invoices
						19	Revert Purchases
						203	Down Payment Incoming
						204	Down Payment Outgoing
						163	Correction A/P Invoice
						164	Correction A/P Invoice Reversals
						165	Correction A/R Invoice
						166	Correction A/R Invoice Reversals
SrcObjAbs	Source Object Internal ID	Int	11	-
ReconSum	Reconciliation Amount	Num	19.6	-
ReconSumFC	Reconciliation Amount (FC)	Num	19.6	-
ReconSumSC	Reconciliation Amount (SC)	Num	19.6	-
FrgnCurr	Foreign Currency	nVarChar	3	OCRN
SumMthCurr	Amt in Reconciliation Currency	Num	19.6	-
IsCredit	Credit or Debit	VarChar	1	-		C	Credit
						D	Debit
Account	Account Code	nVarChar	15	OACT
CashDisSum	Cash Discount Amount	Num	19.6	-
WTSum	Withholding Tax Amount	Num	19.6	-
WTSumFC	Withholding Tax Amount (FC)	Num	19.6	-
WTSumSC	Withholding Tax Amount (SC)	Num	19.6	-
ExpSum	Freight Amount	Num	19.6	-
ExpSumFC	Freight Amount (FC)	Num	19.6	-
ExpSumSC	Freight Amount (SC)	Num	19.6	-
netBefDisc	Net Before Discount Sum	Num	19.6	-
MIEntry	MI Entry Include this Recon.	Int	11	-	0
MIType	MI Type Include this Recon.	nVarChar	20	-		270	A/R Monthly Invoice
						140000014	A/P Monthly Invoice
InstID	Installment ID	Int	11	-	0
IntrsStat	Interest Letter Status	VarChar	1	-	U	U	Not Sent
						S	Sent
						C	Closed