| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ACTIVE | Table entry is active (A) or in suspense (S) | char | 1 | 0 | | | | Allow NULL? |
| 3 | CLAIM | Number of Claim | nvarchar | 17 | 0 | | | | Allow NULL? |
| 4 | SUBCLAIM | Subclaim of Payment | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | PAYMENT | Number of Claim Payment | nvarchar | 5 | 0 | | | | Allow NULL? |
| 6 | CHANGETIME | Changed: Date + Time | decimal | 15 | 0 | | | | |
| 7 | CHANGEDBY | Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | DELETED | Database Line Status (Original, Changed, Deleted) | char | 1 | 0 | | | | Allow NULL? |
| 9 | CREATEDBY | Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 10 | CREATETIME | Created: Date + Time | decimal | 15 | 0 | | | | |
| 11 | APPROVEDBY | Checked By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 12 | APPROVEDTIME | Date Checked (Date+Time) | decimal | 15 | 0 | | | | |
| 13 | TRANSFERTIME | Transfer Date to Collections/Disbursements (Date+Time) | decimal | 15 | 0 | | | | |
| 14 | DOCUMENTREF | Reference for Payment Document Created in Subledger | nvarchar | 14 | 0 | | | | Allow NULL? |
| 15 | POSTDATE | Posting Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | DOCDATE | Document Date of Payment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | DUEDATE | Due Date for Net Payment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | XALREADYPAID | Payment Already Made | char | 1 | 0 | | | | Allow NULL? |
| 19 | PAYCAT | Record Type of Payment | char | 1 | 0 | | | | Allow NULL? |
| 20 | PAYTYPE | Payment Type (Final Payment, Payment After Closure of Claim) | char | 1 | 0 | | | | Allow NULL? |
| 21 | SUBSAL | Subrogation/Salvage | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | XPAYEE | Additional Payee (ICLPAYEE) | char | 1 | 0 | | | | Allow NULL? |
| 23 | ADDRNUMBER | Address Number for Checks | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | CRECADDR | Address Number for Checks | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | BKID | Bank Details ID | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | CURR | Claim Payment Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 27 | EXCHRATE | Exchange Rate of Payment Currency into Policy Currency | decimal | 9 | 5 | | | | |
| 28 | STATUS | Internal Payment Status (Database Status) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | METHOD | Payment Method | char | 1 | 0 | | | | Allow NULL? |
| 30 | CHECKNUMBER | Check Number for Manual Check Payments | nvarchar | 13 | 0 | | | | Allow NULL? |
| 31 | NOTE | Payment Note | nvarchar | 50 | 0 | | | | Allow NULL? |
| 32 | INVOICEREF | External Invoice Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 33 | REFCLAIM | Claim Number (Reassignment Reference) | nvarchar | 17 | 0 | | | | Allow NULL? |
| 34 | REFSUBCLAIM | Subclaim (Reassignment Reference) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 35 | REFPAYMENT | Claim Payment (Reassignment Reference) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 36 | AMTDONE | Amount Paid or Received | decimal | 15 | 2 | | | | |
| 37 | LIABRATE | Negotiated Liability Rate in Percent | decimal | 5 | 2 | | | | |
| 38 | AMTNEG | Amount Negotiated | decimal | 15 | 2 | | | | |
| 39 | SUBROSTATUS | Legal Status of Subrogation/Recovery | char | 1 | 0 | | | | Allow NULL? |
| 40 | TAXROLE | Tax Role of Claim Payment Recipient | nvarchar | 4 | 0 | | | | Allow NULL? |
| 41 | TAX_RPT | Flag for Reportable Payments | char | 1 | 0 | | | | Allow NULL? |
| 42 | XTAXRPTCT | Code for Withholding Tax in Statutory Reporting Category | char | 1 | 0 | | | | Allow NULL? |
| 43 | MTAXRPTCT | Withholding Tax Code for Statutory Reporting | nvarchar | 2 | 0 | | | | Allow NULL? |
| 44 | OVRD_TAXRPTCT | Manual Withholding Tax Code | char | 1 | 0 | | | | Allow NULL? |
| 45 | FUNDSRECDT | Salvage: Funds Received | nvarchar | 8 | 0 | | | | Allow NULL? |
| 46 | XSALVESTEND | End Estimation of Salvage Value | char | 1 | 0 | | | | Allow NULL? |
| 47 | OWNERTYPE_GRP | Responsible Organization Category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 48 | OWNER_GRP | Responsible Organizational Unit | nvarchar | 12 | 0 | | | | Allow NULL? |
| 49 | REASONREJ | Rejection Reasons for Payments and Reserves | nvarchar | 2 | 0 | | | | Allow NULL? |
| 50 | REFEXTSDOC | Referenced Statistical Payment Entry | nvarchar | 5 | 0 | | | | Allow NULL? |
| 51 | MOS | Method of Settlement | nvarchar | 3 | 0 | | | | Allow NULL? |
| 52 | CL_PAYFREQPLAN | Payment Frequency of Scheduled Payment | nvarchar | 2 | 0 | | | | Allow NULL? |
| 53 | PMTTO | End Date of a Scheduled Payment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 54 | PMTFR | Start Date of a Scheduled Payment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 55 | SCHEDTYPE | Type of Scheduled Payment | nvarchar | 2 | 0 | | | | Allow NULL? |
| 56 | NROFINVREQ | Mininum Number of Inbound Invoices | nvarchar | 2 | 0 | | | | Allow NULL? |
| 57 | DAMAGEDOBJ | Damaged Object | nvarchar | 4 | 0 | | | | Allow NULL? |
| 58 | MIGRATION | Indicator for Migrated Payments | char | 1 | 0 | | | | Allow NULL? |
| 59 | REQEVALCAT | Determination Category of Receivable Amount | char | 1 | 0 | | | | Allow NULL? |
| 60 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | | | Allow NULL? |
| 61 | PAYOUT_SCENARIO | Repetitive Payment Scenario | char | 1 | 0 | | | | Allow NULL? |
| 62 | SERV_FROM | Service Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 63 | SERV_TO | Service End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 64 | XREPPAY | Payment Creation from Repetitive Payment Record | char | 1 | 0 | | | | Allow NULL? |
| 65 | ALTPOSTTARGET | Alternative Posting Target | nvarchar | 50 | 0 | | | | Allow NULL? |
| 66 | GROSS_NET_PAYMENT | Gross/Net payment indicator | char | 1 | 0 | | | | Allow NULL? |
| 67 | HCM_PAYMENT_STATE | Payment Processing State Indicator on the HCM system | char | 1 | 0 | | | | Allow NULL? |
