Functional Description
Purpose
This business function gets the Colombian Tax Set Up from the UDCs 76C/PI (Tax Parameters) and 76C/AE
(Economic Activity).
Setup Notes and Prerequisites
The UDCs 76C/PI and 76C/AE need to be set up before this business function is called.
The UDC 76C/PI indicates if a tax must be calculated. This UDC has the structure SCTII where :
S = Indicates the system code. Example :
2.A/P Accounts Payable
3.G/L General Ledger
T = Indicates what type of Tax Payer the Supplier or Customer is. This classification is given
by the DIAN.
II = Indicates the Tax to be calculated. It has to be equal to the two first characters of the
G/L Offset defined in the Tax Area.
The UDC 76C/AE is used to defined the percentages for the tax : "ICA". This UDC has the strcuture
IICCCAAA where :
the G/L Offset defined in the Tax Area.
CCC= Code of the city where the tax applied. This code has to be equal to the category code
20 of the Cost Center.
AAA= Code of the City and Economic Activity of the Supplier. This code has to be equal to
either the Address Book Category Code 007 or Voucher Category Code 007.
Special Logic
If the taxes, that make the tax area, must be calculated, a flag will take a value of 'Y'. This
flag will be used by the Colombian Tax Calculator .
If a percentage was defined in the field Special Handling Code of the UDCs, this percentage will be
returned, so the tax calculator will calculated taxes based on this rate when the rate specified in
the Tax Area has a value of 0.
Technical Specifications
Parameters:
AN8mnAddressNumberIRequired
AC07szReportCode007INo Required
EV01cSystemCodeFlagIRequired. Values:
'1' = A/P
'2' = A/R
'3' = G/L
COszCompanyIRequired
TXR1mnTaxRate1I/ONo Required
TXR2mnTaxRate2I/ONo Required
TXR3mnTaxRate3I/ONo Required
TXR4mnTaxRate4I/ONo Required
TXR5mnTaxRate5I/ONo Required
GL01szGlClassByTaxArea1IRequired
GL02szGlClassByTaxArea2IRequired
GL03szGlClassByTaxArea3IRequired
GL04szGlClassByTaxArea4IRequired
GL05szGlClassByTaxArea5IRequired
DTAIszErrorMessageONo Required
EV01cCalculateTax1FlagONo Required
EV01cCalculateTax2FlagONo Required
EV01cCalculateTax3FlagONo Required
EV01cCalculateTax4FlagONo Required
EV01cCalculateTax5FlagONo Required
MCUszCostCenterIRequired
EV01cManualTaxInputFlagONo Required
EV01cControlMinimTax1FlagONo Required
EV01cControlMinimTax2FlagONo Required
EV01cControlMinimTax3FlagONo Required
EV01cControlMinimTax4FlagONo Required
EV01cControlMinimTax5FlagONo Required
MATH01mnMaximumCostTax1ONo Required
MATH02mnMaximumCostTax2ONo Required
MATH03mnMaximumCostTax3ONo Required
MATH04mnMaximumCostTax4ONo Required
MATH05mnMaximumCostTax5ONo Required
2.2Related Tables
Table Table Description
F0010Company
F0101Address Book
F0006Cost Center
^
D76C0006 - Get Colombian Tax Set Up - COL - 00 - 76C
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnAddressNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
szReportCode007 | AC07 | char | NONE | NONE |
One of 30 reporting codes that you can assign to an address in the Address Book system. Category Code 07 is used in the 1099 process to
| ||||
cSystemCodeFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szCompany | CO | char | NONE | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
mnTaxRate1 | TXR1 | MATH_NUMERIC | NONE | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
| ||||
mnTaxRate2 | TXR2 | MATH_NUMERIC | NONE | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
| ||||
mnTaxRate3 | TXR3 | MATH_NUMERIC | NONE | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
| ||||
mnTaxRate4 | TXR4 | MATH_NUMERIC | NONE | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
| ||||
mnTaxRate5 | TXR5 | MATH_NUMERIC | NONE | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
| ||||
szGlClassByTaxArea1 | GL01 | char | NONE | NONE |
A code that indicates how to locate the tax account for general ledger entries. This field points to automatic accounting instructions (AAIs)
| ||||
szGlClassByTaxArea2 | GL02 | char | NONE | NONE |
Code that indicates how to locate the tax account for general ledger entries.
This field points to automatic accounting instructions (AAIs) that,
| ||||
szGlClassByTaxArea3 | GL03 | char | NONE | NONE |
Code that indicates how to locate the tax account for general ledger entries.
This field points to automatic accounting instructions (AAIs) that,
| ||||
szGlClassByTaxArea4 | GL04 | char | NONE | NONE |
Code that indicates how to locate the tax account for general ledger entries.
This field points to automatic accounting instructions (AAIs) that,
| ||||
szGlClassByTaxArea5 | GL05 | char | NONE | NONE |
Code that indicates how to locate the tax account for general ledger entries.
This field points to automatic accounting instructions (AAIs) that,
| ||||
szErrorMessage | DTAI | char | NONE | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
cCalculateTax1Flag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cCalculateTax2Flag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cCalculateTax3Flag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cCalculateTax4Flag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cCalculateTax5Flag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szCostCenter | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
cManualTaxInputFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cControlMinimTax1Flag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cControlMinimTax2Flag | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cControlMinimTax3Flag | EV03 | char | NONE | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
cControlMinimTax4Flag | EV04 | char | NONE | NONE |
PeopleSoft event point processing flag 04. | ||||
cControlMinimTax5Flag | EV05 | char | NONE | NONE |
A flag that indicates whether automatic spell check is turned on. | ||||
mnMaximumCostTax1 | MATH01 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance Low Value. | ||||
mnMaximumCostTax2 | MATH02 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance High Value. | ||||
mnMaximumCostTax3 | MATH03 | MATH_NUMERIC | NONE | NONE |
- - - Bad Performance Low Value. | ||||
mnMaximumCostTax4 | MATH04 | MATH_NUMERIC | NONE | NONE |
Event point for Math Numeric. | ||||
mnMaximumCostTax5 | MATH05 | MATH_NUMERIC | NONE | NONE |
Event point for Math Numeric. | ||||
jdDateServiceCurrency | DSVJ | JDEDATE | OPT | NONE |
A date that indicates when you purchased goods or services, or when you incurred a tax liability. |
None |
None |