| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | ReconNum | Reconciliation Number | int | 11 | 0 | OITR | | | Allow NULL? |
| 2 | LineSeq | Row Number | int | 11 | 0 | | | | Allow NULL? |
| 3 | ShortName | BP/Account Code | nvarchar | 15 | 0 | | | | Allow NULL? |
| 4 | TransId | Transaction Internal ID | int | 11 | 0 | OJDT | | | Allow NULL? |
| 5 | TransRowId | Transaction Row Number | int | 11 | 0 | | | | Allow NULL? |
| 6 | SrcObjTyp | Source Object Type | nvarchar | 20 | 0 | | | 13=Invoices, 14=Revert Invoices, 163=Correction A/P Invoice, 164=Correction A/P Invoice Reversals, 165=Correction A/R Invoice, 166=Correction A/R Invoice Reversals, 18=Purchases, 19=Revert Purchases, 203=Down Payment Incoming, 204=Down Payment Outgoing, 24=Receipts, 30=Journal Transactions, 46=Outgoing Payments | Allow NULL? |
| 7 | SrcObjAbs | Source Object Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 8 | ReconSum | Reconciliation Amount | num | 19 | 6 | | | | Allow NULL? |
| 9 | ReconSumFC | Reconciliation Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 10 | ReconSumSC | Reconciliation Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 11 | FrgnCurr | Foreign Currency | nvarchar | 3 | 0 | OCRN | | | Allow NULL? |
| 12 | SumMthCurr | Amt in Reconciliation Currency | num | 19 | 6 | | | | Allow NULL? |
| 13 | IsCredit | Credit or Debit | char | 1 | 0 | | | C=Credit, D=Debit | Allow NULL? |
| 14 | Account | Account Code | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 15 | CashDisSum | Cash Discount Amount | num | 19 | 6 | | | | Allow NULL? |
| 16 | WTSum | Withholding Tax Amount | num | 19 | 6 | | | | Allow NULL? |
| 17 | WTSumFC | Withholding Tax Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 18 | WTSumSC | Withholding Tax Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 19 | ExpSum | Freight Amount | num | 19 | 6 | | | | Allow NULL? |
| 20 | ExpSumFC | Freight Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 21 | ExpSumSC | Freight Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 22 | netBefDisc | Net Before Discount Sum | num | 19 | 6 | | | | Allow NULL? |
| 23 | MIEntry | MI Entry Include this Recon. | int | 11 | 0 | | 0 | | Allow NULL? |
| 24 | MIType | MI Type Include this Recon. | nvarchar | 20 | 0 | | | 140000014=A/P Monthly Invoice, 270=A/R Monthly Invoice | Allow NULL? |
| 25 | InstID | Installment ID | int | 11 | 0 | | 0 | | Allow NULL? |
