Columns

The A_CUSTOMERWITHHOLDINGTAX table contains the following columns. Columns marked with an asterisk comprise the primary key.

Column Name Data Type
CUSTOMER* STRING(10)
COMPANYCODE* STRING(4)
WITHHOLDINGTAXTYPE* STRING(2)
AUTHORIZATIONGROUP STRING(4)
EXEMPTIONDATEBEGIN DATETIME(0)
EXEMPTIONDATEEND DATETIME(0)
EXEMPTIONREASON STRING(2)
OBLIGATIONDATEBEGIN DATETIME(0)
OBLIGATIONDATEEND DATETIME(0)
WITHHOLDINGTAXAGENT BOOLEAN
WITHHOLDINGTAXCERTIF​ICATE STRING(25)
WITHHOLDINGTAXCODE STRING(2)
WITHHOLDINGTAXEXMPTP​ERCENT DECIMAL(5, 2)
WITHHOLDINGTAXNUMBER STRING(16)