| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | P2UN_EGRT | NPO: EG Internal summary structure | 44 | PAYMENT | EG Payment(s) | decimal | 10 | 2 | ||
| Business Server Pages | ||||||||||
| 2 | AUOFFER | Auction Offer Table | 7 | PAYMENT | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | ||
| Claims Management | ||||||||||
| 3 | ICLPAY | Claim Payment | 5 | PAYMENT | Number of Claim Payment | nvarchar | 5 | 0 | ||
| 4 | ICLPAYEE | Additional Payee | 5 | PAYMENT | Number of Claim Payment | nvarchar | 5 | 0 | ||
| 5 | ICLPAYI | Claim Payment Item | 5 | PAYMENT | Number of Claim Payment | nvarchar | 5 | 0 | ||
| 6 | ICSPAY | Payment | 5 | PAYMENT | Number of Claim Payment | nvarchar | 5 | 0 | ||
| 7 | ICSPAYEE | Additional Payee | 5 | PAYMENT | Number of Claim Payment | nvarchar | 5 | 0 | ||
| 8 | ICSPAYI | Payment Item | 5 | PAYMENT | Number of Claim Payment | nvarchar | 5 | 0 | ||
| Funds Management | ||||||||||
| 9 | FMCDRBBS | FM Rev. Incr. Budget History - Government Canada | 10 | PAYMENT | Yes/No (X/ ) | nvarchar | 1 | 0 | ||
| 10 | TBUDVG | IS-PS Budget Types for Payment/Commitment Budget | 7 | PAYMENT | Payment budget | nvarchar | 1 | 0 | ||
| Localization | ||||||||||
| 11 | J_3RSEXTRACTD | Exctract details (obsolete) | 25 | PAYMENT | Payment number | nvarchar | 10 | 0 | ||
| Sales and Distribution | ||||||||||
| 12 | J_1USEXTRACTD | EXTRACTD | 25 | PAYMENT | nvarchar | 10 | 0 | |||