List of Bases
Bases represent a source or target in the field mapping of a tax request and response. They either represent an entity in SAP or a Determination XML structure such as Batch, Invoice, Line, or Tax. Some complex XML structures like User Attributes, Quantities, Registrations, Currency Conversions, etc. require special processing described at the end of this section. Not all of the sources are available for all Journeys.
Source Bases | |||
Base | Description | Journey supported | |
SAP_HEADER | Fields from the following SAP document header tables: BKPF, EKKO,ESSR, KNA1, LFA1, T001, T001Z, T180, TVAK, TVAP, TVFK, TVKO, TVTA, VBAK, VBKD, VBUK, VBRK, KOMK, CALC_HDR*,J_1BBRANCH, J_1IMOVEND, J_1IMOCUST, J_1IMOCOMP, MKPF, MSEG, T156, DM07M, VM07M | /IDT/JOURNEY_HEADER_REQUEST /IDT/JOURNEY_HEADER_REQ_BR_GM /IDT/JOURNEY_FB05_COMPANY_ROLE | |
BKPF (FI/LIV) VBRK (SD) T001 for both processes | /IDT/JOURNEY_AUDIT_UPD_DB_GL /IDT/JOURNEY_AUDIT_UPD_DB_BILL /IDT/JOURNEY_AUDIT_UPD_DB_SETL | ||
MKPF, BKPF, KOMK, KOMP, MSEG, EKKO, LFA1, CALC_HDR | /IDT/JOURNEY_HEADER_REQ_BR_GM | ||
SAP_ITEM | Fields from the following SAP document item tables:BSEG, CSKS, DRSEG, EINA, EINE, EKKNU, EKPO, KOMP, KOMV_INDEX, MAKT, MARA, MARC, MARD, MBEW, MT06E, MVKE, PRICE_COND, T001W, T001Z ,TVAP, VBAP, VBAPF, VBRP, VBUP, CALC_ITEM*,J_1BBRANCH, J_1IMOVEND, J_1IMOCUST, J_1IMOCOMP, MKPF, MSEG, T156, DM07M, VM07M Header fields :Any field listed in the SAP_HEADER section above, use prefix HDR-> when mapping a header table at line level | /IDT/JOURNEY_ITEM_REQUEST /IDT/JOURNEY_NG_ITEM_REQUEST /IDT/JOURNEY_ITEM_REQ_BR_GM /IDT/JOURNEY_NG_ITEM_DOWN_PAYM /IDT/JOURNEY_NG_ITEM_FB05 /IDT/JOURNEY_NG_ITEM_SERV_ENTR | |
BSEG (FI/LIV) VBRP (SD) WBRP (SD, MM) | /IDT/JOURNEY_AUDIT_UPD_DB_GL /IDT/JOURNEY_AUDIT_UPD_DB_BILL /IDT/JOURNEY_AUDIT_UPD_DB_SETL | ||
MKPF, MSEG, EKPO, KOMP, LFA1, MBEW, J_1BBRANCH, LIKP | /IDT/JOURNEY_ITEM_REQ_BR_GM | ||
SAP_FIELD | SYST GC_XS_FALSE – translates an SAP check box value to a XSD true/false value GC_VERSION – represents the XSD | All | |
DET_TAX | All fields in the Tax level of the Determination response (OUTDATA) message | /IDT/JOURNEY_STANDARD_RESPONSE /IDT/JOURNEY_TAX_TAB_RESPONSE | |
CONSTANT | Any constant value | All | |
Target Bases | ||
Base | Description | Journey supported |
DET_BATCH | All fields in Batch level of Determination request (INDATA) message | /IDT/JOURNEY_HEADER_REQUEST /IDT/JOURNEY_FB05_COMPANY_ROLE /IDT/JOURNEY_HEADER_REQ_BR_GM |
DET_INVOICE | All fields in Invoice level of Determination request (INDATA) message | /IDT/JOURNEY_HEADER_REQUEST /IDT/JOURNEY_FB05_COMPANY_ROLE /IDT/JOURNEY_HEADER_REQ_BR_GM /IDT/JOURNEY_AUDIT_UPD_DB_BILL /IDT/JOURNEY_AUDIT_UPD_DB_GL |
DET_LINE | All fields in the Item level of the Determination request (INDATA) message | /IDT/JOURNEY_ITEM_REQUEST /IDT/JOURNEY_NG_ITEM_REQUEST /IDT/JOURNEY_ITEM_REQ_BR_GM /IDT/JOURNEY_NG_ITEM_DOW N_PAYM /IDT/JOURNEY_NG_ITEM_FB05 /IDT/JOURNEY_NG_ITEM_SERV_ENTR |
SAP_TAX_LINE | All fields in table /IDT/D_TAX_DATA, including custom appended fields | /IDT/JOURNEY_TAX_TAB_RESPONSE /IDT/JOURNEY_FB05_RESPONSE |
All fields of the SAP pricing lines as defined in structure KOMV_INDEX NOTE: used for backwards compatibility only | /IDT/JOURNEY_STANDARD_RESPONSE | |
Special Purpose Operands | ||
Operand | Description | Journey supported |
CALC_HDR | ROLE, EXTERNAL_COMPANY_ID, UNIQUE_INVOICE_NUMBER, TAX_CATEGORY | /IDT/JOURNEY_HEADER_REQUEST |
CALC_ITEM | DET_TAX_CODE, IS_EXEMPT, AMOUNT, QUANTITY, IS_CREDIT | /IDT/JOURNEY_ITEM_REQUEST /IDT/JOURNEY_NG_ITEM_REQUEST |
PARTNER_TAB | Used to reference a partner address in field mappings. Can be used in combination with partner function type. | /IDT/JOURNEY_HEADER_REQUEST /IDT/JOURNEY_ITEM_REQUEST /IDT/JOURNEY_NG_ITEM_REQUEST |
HDR-> | Pointer use in Item level request mapping to indicate that the field used is at header level, i.e. HDR->T001W-WERKS would indicate the plant from the header table to be mapped at the item level. | /IDT/JOURNEY_ITEM_REQUEST /IDT/JOURNEY_NG_ITEM_REQUEST /IDT/JOURNEY_FB05_RESPONSE |
ANCESTOR-> | Pointer used in response mapping to indicate that the field used is at a higher level in the structure, i.e. ANCESTOR->ANCESTOR->CALLING_SYSTEM_NUMBER would be used to map from Invoice level field in the tax data level. NOTE: At this time we don’t support mapping from the BATCH level of the Determination XML, all fields are available on the INVOICE level too. | /IDT/JOURNEY_TAX_TAB_RESPONSE /IDT/JOURNEY_STANDARD_RESPONSE /IDT/JOURNEY_FB05_RESPONSE |
ITEMS-> | Pointer used to determine at the header level a field that is stored at the line-item level in order to pass that to the request. | /IDT/JOURNEY_HEADER_REQUEST |
XSD Tables | ||
Table | Description | Journey supported |
USER_ELEMENT | A custom field in the XSD comprised of the XML element USER_ELEMENT and field ATTRIBUTE#, where # is any number between 1-40 at Invoice or Item level. NOTE: Attributes 41-50 are reserved by Thomson Reuters. | /IDT/JOURNEY_HEADER_REQUEST /IDT/JOURNEY_ITEM_REQUEST /IDT/JOURNEY_NG_ITEM_REQUEST /IDT/JOURNEY_STANDARD_RESPONSE /IDT/JOURNEY_TAX_TAB_RESPONSE |
REGISTRATIONS | A structure of registration numbers for different roles; SELLER_ROLE, BUYER_ROLE, MIDDLEMAN_ROLE. | /IDT/JOURNEY_HEADER_REQUEST /IDT/JOURNEY_ITEM_REQUEST /IDT/JOURNEY_NG_ITEM_REQUEST |
QUANTITIES | A complex structure to represent a list of quantities and unit of measures. | /IDT/JOURNEY_ITEM_REQUEST /IDT/JOURNEY_NG_ITEM_REQUEST |
CURRENCY_CONVERSION | Represents a result set of one or two currency conversion steps in the TAX block of the tax response. | /IDT/JOURNEY_STANDARD_RESPONSE /IDT/JOURNEY_TAX_TAB_RESPONSE |
Special Purpose Operands in Tables | |
Operand | Description |
NAME | A field value within a table like NAME=ATTRIBUTE1 |
ROW | A field value to point to a specific place in a table i.e. ROW=3 would point to the third row |
ADD | An action, i.e. to add a row to the table |
CREATE_IF_NOT_EXIST | A control flag to only add the mapping if none already exists |