| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | AbsEntry | Header Internal ID | int | 11 | 0 | CASE | | | Allow NULL? |
| 2 | LineId | Inconsistent Amt Number | int | 11 | 0 | | 0 | | Allow NULL? |
| 3 | ShortName | BP Code | nvarchar | 15 | 0 | | | | Allow NULL? |
| 4 | Account | Account Code | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 5 | OrigAbsEnt | Original Doc. Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 6 | OrigObjTyp | Original Doc. Type | int | 11 | 0 | | 0 | 0=All, 13=A/R Invoice, 14=A/R Credit Memo, 163=A/P Correction Invoice, 165=A/R Correction Invoice, 18=A/P Invoice, 19=A/P Credit Memo, 203=A/R Down Payment, 204=A/P Down Payment, 24=Incoming Payment, 30=Journal Entry, 46=Outgoing Payment | Allow NULL? |
| 7 | OrigDocNum | Original Document Number | int | 11 | 0 | | | | Allow NULL? |
| 8 | OrigInsNum | Original Installment Number | int | 11 | 0 | | | | Allow NULL? |
| 9 | OrigTrnsId | Original JE Trans. No. | int | 11 | 0 | OJDT | | | Allow NULL? |
| 10 | OrigTrnsLn | Original JE Row No. | int | 11 | 0 | | | | Allow NULL? |
| 11 | LnkRecnAbs | Linked Recon. Doc. Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 12 | LnkRecnObj | Destination Object Type | int | 11 | 0 | | | | Allow NULL? |
| 13 | LnkRecnNum | Destination Document Number | int | 11 | 0 | | | | Allow NULL? |
| 14 | LnkRecnIns | Destination Installment Number | int | 11 | 0 | | | | Allow NULL? |
| 15 | LnkRecnTrn | Linked and Recon. JE Trans No. | int | 11 | 0 | OJDT | | | Allow NULL? |
| 16 | LnkRecnLn | Linked and Recon. JE Row No. | int | 11 | 0 | | | | Allow NULL? |
| 17 | InconsType | Type of Inconsistency | nvarchar | 2 | 0 | | | 0=None, 10=Canceled Payment or Journal Entry, 11=Cancellation of Payment/JE within Payment, 12=Unreconciled Balance Rows in Multiple BPs Reconciliation, 13=Missing Exchange Rate Difference behind Multiple BPs Reconciliation, 14=Double Application of Payments of Down Payment Request, 15=Exchange Difference Recognition of Payments of DPM Req | Allow NULL? |
| 18 | ReconNum | Reconciliation Number | int | 11 | 0 | | | | Allow NULL? |
| 19 | NewRcnNum | New Reconciliation No. | int | 11 | 0 | OITR | | | Allow NULL? |
| 20 | CredDeb | Credit or Debit | char | 1 | 0 | | | | Allow NULL? |
| 21 | Amount | Inconsistent Amount | num | 19 | 6 | | | | Allow NULL? |
| 22 | AmountFC | Inconsistent Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 23 | AmountSC | Inconsistent Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 24 | TransId | Balancing Trans. Internal ID | int | 11 | 0 | OJDT | | | Allow NULL? |
| 25 | TransLine | Balancing Transaction Row No. | int | 11 | 0 | | | | Allow NULL? |
| 26 | X | x | num | 19 | 6 | | | | Allow NULL? |
| 27 | Y | Y | num | 19 | 6 | | | | Allow NULL? |
| 28 | Z | Z | num | 19 | 6 | | | | Allow NULL? |
| 29 | LnkObjAbsE | Linked Doc. Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 30 | LinkObjTyp | Linked Document Type | int | 11 | 0 | | | | Allow NULL? |
| 31 | LinkDocNum | Linked Document Number | int | 11 | 0 | | | | Allow NULL? |
| 32 | LinkInsNum | Linked Doc. Installment Number | int | 11 | 0 | | | | Allow NULL? |
| 33 | LinkTrnsId | Linked Doc. JE Trans. No. | int | 11 | 0 | OJDT | | | Allow NULL? |
| 34 | LinkTrnsLn | Linked Doc. JE Row No. | int | 11 | 0 | | | | Allow NULL? |
| 35 | TrnsTtlAmt | Balancing Trans. Total Amount | num | 19 | 6 | | | | Allow NULL? |
| 36 | TrnsTtlFc | Balancing Trans. Total Amt FC | num | 19 | 6 | | | | Allow NULL? |