Output Parameters for Test Tax Calculation 
Output Parameters for Test Tax Calculation
Structure: O_EXT_CONTROL_DATA (External System Control Info)
Parameter |
Definition |
Example |
API_VERSION |
External system API version |
|
SYST_VERSION |
External system version |
|
DB_VERSION |
Ext. system rate data file version |
Structure: O_COM_ERR_DOC (External System Error Info)
Parameter |
Definition |
Example |
RETCODE |
<> 0 if error in at least one item or header |
|
ERROR_LINE |
First line item number which contains error (if any) |
|
ERRCODE |
External system specific error code |
|
ERRMSG |
Error message |
Table: O_TAX_CAL_ITEM_OUT (Tax results for item)
Parameter |
Definition |
Example |
ITEM_NO |
External tax document item number (1) |
000001, 000002, 000003, etc. |
TXJCD_IND |
Jurisdiction indicator used for tax calculation |
|
TAXPCOV |
Total item tax percentage rate |
|
TAXAMOV |
Total item tax amount |
|
EXMATFLAG |
Reason Code for material exemption |
|
EXCUSFLG |
Reason Code for customer tax exemption |
|
EXT_EXCERTIF |
Ship-to exemption certificate number defined in External tax system |
|
EXT_EXREASON |
Reason Code for tax exemption defined in External tax system |
|
NR_JUR_LEVELS |
Total number of tax lines by jurisdiction level for each item (2) |
Table: O_TAX_CAL_JUR_LEVEL_OUT (Tax results by jurisdiction level for item)
Parameter |
Definition |
Example |
ITEM_NO |
External tax document item number (1) |
000001, 000002, 000003, etc |
TXJLV |
Jurisdiction Level |
1 – State 2 – County 3 – City 4 – District 5 – Secondary City 6 – Secondary District |
TAXPCT |
Actual tax percentage by level |
|
TAXAMT |
Actual tax amount by level |
|
TAXBAS |
Actual tax base amount per level if different than TAXAMT |
|
EXAMT |
Exempt amount by level |
|
EXCODE |
Exempt Code by level |