| 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 | PAYMENTITEM | Claim Payment Item | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | CHANGETIME | Changed: Date + Time | decimal | 15 | 0 | | | | |
| 8 | CHANGEDBY | Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 9 | DELETED | Database Line Status (Original, Changed, Deleted) | char | 1 | 0 | | | | Allow NULL? |
| 10 | ITEMSUBCL | Subclaim to Which a Payment Item Is Assigned | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | PAYITEMCAT | Claim Payment Item Category | char | 1 | 0 | | | | Allow NULL? |
| 12 | PAMPAID | Payment Amount | decimal | 15 | 2 | | | | |
| 13 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | COVTYPE | Coverage Type | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | PYMTYPE | Tax Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | PAYTYPEI | Payment Type (Final Payment, Payment After Closure of Claim) | char | 1 | 0 | | | | Allow NULL? |
| 17 | TREASONSET | Payment Reason Group | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | TREASON | Payment Reason | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | GROSS_NET | Tax Category of Amount (Gross/Net) | char | 1 | 0 | | | | Allow NULL? |
| 20 | TXCOD | Tax Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | TAXCODE_ID | Tax Code for Other Taxes | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | REQUESTED | Amount Requested | decimal | 15 | 2 | | | | |
| 23 | POSTDATEI | Posting Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | ITEM | Claim Item | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | REFNO | External Reference Number | nvarchar | 15 | 0 | | | | Allow NULL? |
| 26 | PAYITY | Payment Item Type | nvarchar | 10 | 0 | | | | Allow NULL? |
| 27 | REPID | Coinsurance Key | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | VALIDFROM | Payment Item: Valid From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | VALIDTO | Payment Item: Valid To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | | | Allow NULL? |
| 31 | CDDOCITEM | Item Number in Payment Plan Document | nvarchar | 4 | 0 | | | | Allow NULL? |
| 32 | REQUESTED_ORIG | Original Amount Requested | decimal | 15 | 2 | | | | |
| 33 | DUP_PAMPAID | Payment Amount | decimal | 15 | 2 | | | | |
| 34 | COUNTRY | Key of Tax Country | nvarchar | 3 | 0 | | | | Allow NULL? |
| 35 | REGION | Key of Tax Region | nvarchar | 3 | 0 | | | | Allow NULL? |
| 36 | TXJCD | Tax Jurisdiction Code | nvarchar | 15 | 0 | | | | Allow NULL? |
| 37 | TXBSAMT | Tax Base Amount | decimal | 13 | 2 | | | | |
