|
|
|
|
|
|
|
|
| Previous | Next | Contents | Index | Glossary | Library |
Approved Withholding Tax transactions
Paid Withholding Tax transactions
To insert external withholding tax transactions into the interface table:
1. Log into SQL*PLUS to your Oracle Financials database APPS account.
SQLPLUS <APPS_USER>/<APPS_PASSWORD>
where APPS_USER is your APPS account username and APPS_PASSWORD is your APPS account password.
2. Enable messaging by entering the command:
SET SERVEROUTPUT ON
3. To insert approved external withholding tax transactions, use the API with these parameters:
| je_es_whtax.ins_trans(
|
|
|
| P_ORG_NAME
| =>
| '<Org Name>',
|
| P_FIN_IND
| =>
| '<Fin Ind>',
|
| P_REMUN_TYPE
| =>
| '<Remun Type>',
|
| P_VENDOR_NIF
| =>
| '<Supplier NIF>',
|
| P_ VENDOR_NAME
| =>
| '<Supplier Name>',
|
| P_GL_DATE
| =>
| '<Approved Date>',
|
| P_NET_AMOUNT
| =>
| <Net amount>,
|
| P_WITHHOLDING_TAX_AMOUNT
| =>
| <Tax amount>,
|
| P_ZIP_ELECTRONIC
| =>
| '<Zip>',
|
| P_NUM_CHILDREN
| =>
| <Children>,
|
| P_SIGN
| =>
| '<Sign>',
|
| P_TAX_RATE
| =>
| <Tax Rate>,
|
| P_YEAR_DUE
| =>
| <Year Due>);
|
execute je_es_whtax.ins_trans(P_ORG_NAME =>'Spanish Operating Unit ABC', P_FIN_IND=>'X', P_REMUN_TYPE =>'G', P_VENDOR_NIF=>'ES12345', P_VENDOR_NAME=>'ABC COMPANY', P_GL_DATE=>'01_JAN-90', P_NET_AMOUNT =>100, P_WITHHOLDING_TAX_AMOUNT=>10, P_ZIP_ELECTRONIC=> '94065', P_NUM_CHILDREN=>0, P_SIGN=>' ', P_TAX_RATE =>10, P_YEAR_DUE=>1997);
Note: P_ORG_NAME Parameter
In Multi-Org installations, the API must be passed the organization operating unit name. In non Multi-Org installations, this parameter must be passed the value NULL or ''.
4. To insert paid external withholding tax transactions, use the API with the parameters listed below:
| je_es_whtax.ins_trans(
|
|
|
| P_ORG_NAME
| =>
| '<Org Name>',
|
| P_FIN_IND
| =>
| '<Fin Ind>',
|
| P_REMUN_TYPE
| =>
| '<Remun Type>',
|
| P_ VENDOR _NIF
| =>
| '<Supplier NIF>',
|
| P_ VENDOR _NAME
| =>
| '<Supplier Name>',
|
| P_ DATE _ PAID
| =>
| '<Paid Date>',
|
| P_NET_AMOUNT
| =>
| <Net amount>,
|
| P_WITHHOLDING_TAX_AMOUNT
| =>
| <Tax amount>,
|
| P_ZIP_ELECTRONIC
| =>
| '<Zip>',
|
| P_NUM_CHILDREN
| =>
| <Children>,
|
| P_SIGN
| =>
| '<Sign>',
|
| P_TAX_RATE
| =>
| <Tax Rate>,
|
| P_YEAR_DUE
| =>
| <Year Due>);
|
execute je_es_whtax.ins_trans(P_ORG_NAME =>'Spanish Operating Unit ABC', P_FIN_IND=>'X', P_REMUN_TYPE =>'G', P_VENDOR_NIF=>'ES12345', P_VENDOR_NAME=>'ABC COMPANY', P_DATE_PAID =>'01_JAN-90', P_NET_AMOUNT =>100, P_WITHHOLDING_TAX_AMOUNT=>10, P_ZIP_ELECTRONIC=> '94065', P_NUM_CHILDREN=>0, P_SIGN=>' ', P_TAX_RATE =>10, P_YEAR_DUE=>1997);
Note: P_ORG_NAME Parameter
In Multi-Org installations, the API must be passed the organization operating unit name. In non Multi-Org installations, this parameter must be passed the value NULL or ''.
| Previous | Next | Contents | Index | Glossary | Library |