| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | PymntRsnCd | Payment Reason Code | nvarchar | 2 | 0 | | | A=A, B=B, C=C, D=D, E=E, G=G, H=H, I=I, L1=L1, L=L, M1=M1, M=M, N=N, O1=O1, O=O, P=P, Q=Q, R=R, S=S, T=T, U=U, V=V, W=W, X=X, Y=Y, Z=Z | Allow NULL? |
| 2 | CardCode | BP Code | nvarchar | 15 | 0 | | | | Allow NULL? |
| 3 | FllTxInAdv | Full WTax Taxation in Advance | num | 19 | 6 | | | | Allow NULL? |
| 4 | AmntsOnhld | WTax Amount on Hold | num | 19 | 6 | | | | Allow NULL? |
| 5 | RTAsWth | Regional IRPEF Held as WTax | num | 19 | 6 | | | | Allow NULL? |
| 6 | RTAsAdv | Regional IRPEF - In Advance | num | 19 | 6 | | | | Allow NULL? |
| 7 | SspndRegTx | Regional Suspend Tax - IRPEF | num | 19 | 6 | | | | Allow NULL? |
| 8 | MTAsWth | Municipal Tax as WTax - IRPEF | num | 19 | 6 | | | | Allow NULL? |
| 9 | MTAsAdv | Municipal Tax Held as Advance | num | 19 | 6 | | | | Allow NULL? |
| 10 | SspndMTTx | Suspended Municipal Tax | num | 19 | 6 | | | | Allow NULL? |
| 11 | TxblPrYr | Taxable Amt - Previous Year | num | 19 | 6 | | | | Allow NULL? |
| 12 | WTHPrYr | WTax Amount - Previous Year | num | 19 | 6 | | | | Allow NULL? |
| 13 | ScrtyCntrP | Social Security Tax Payer | num | 19 | 6 | | | | Allow NULL? |
| 14 | ScrtyCntrS | Social Security Supplier | num | 19 | 6 | | | | Allow NULL? |
| 15 | ExpsRmbrsd | Expenses Reimbursed | num | 19 | 6 | | | | Allow NULL? |
| 16 | WTHRmbrsd | WTax Reimbursed | num | 19 | 6 | | | | Allow NULL? |
| 17 | DlvryIdNo | Delivery Identification No. | nvarchar | 100 | 0 | | | | Allow NULL? |
| 18 | SnglCrtfNo | Single Certification No. | nvarchar | 17 | 0 | | | | Allow NULL? |
| 19 | ErnYr | Earning Year | int | 6 | 0 | | | | Allow NULL? |
| 20 | Advanced | Advanced | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 21 | WTHTypCd | WTax Type Code | char | 1 | 0 | | | 1=Teachers or Researchers, 2=Workers, 3=Other | Allow NULL? |
| 22 | GrssAmount | Gross Amount Due to Supplier | num | 19 | 6 | | | | Allow NULL? |
| 23 | NtSbjctFrg | Amount Not Subject to WT | num | 19 | 6 | | | | Allow NULL? |
| 24 | TxblAmnt | Taxable Amount | num | 19 | 6 | | | | Allow NULL? |
| 25 | WTHAmnt | Withholding Tax Amount | num | 19 | 6 | | | | Allow NULL? |