IM Posting Document Amounts

In Scope

Technical: IM_POSTING_DOC_AMOUNTS | ID: OR-IM-IM_POSTING_DOC_AMOUNTS-IM_POSTING_DOCUMENT_AMOUNTS

Stores document-related data for IM posting doc amounts in Oracle Retail Invoice Matching, supporting creation, validation, matching, or downstream processing of business documents used in invoice matching.

See how this object fits into Invoice Matching

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: IM_POSTING_DOC_AMOUNTS

Field Definitions(5)

Rules & Considerations(32)

constraint

validation

Sample Load Data(4)

_scenario	DOC_IDR	POSTING_IDR	AMOUNT_TYPER	DEPT	CLASS	AMOUNT	TAX_KEY	LOCATION	ORG_UNIT	SUBCLASS	TAX_CODE	TAX_RATE	GROUP_BY_1	GROUP_BY_2	GROUP_BY_3	GROUP_BY_4	GROUP_BY_5	GROUP_BY_6	GROUP_BY_7	GROUP_BY_8	ACCOUNT_CODE	ACCOUNT_TYPE	CURRENCY_RATE	LINE_GROUP_NO	POSTING_AMT_ID	SET_OF_BOOKS_ID	CURRENCY_RATE_TYPE	PRIM_CURRENCY_CODE	LOCAL_CURRENCY_CODE
Example values from field definitions	1	1	SAMPLE	1	1	1.0000	SAMPLE	1	1	1	SAMPLE	1.0000000000	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1.0000000000	1	1	1	SAMPLE	SAM	SAM
default	1000000003	1000000003	IM Posting Doc Amounts-002-ALT	1003	1103	12.5000	ALT-IM_POSTING-002	3	3	1113	ALT-IM	12.5000000000	IM Posting Doc Amounts-002-ALT	IM Posting Doc Amounts-002-ALT	IM Posting Doc Amounts-002-ALT	IM Posting Doc Amounts-002-ALT	IM Posting Doc Amounts-002-ALT	IM Posting Doc Amounts-002-ALT	IM Posting Doc Amounts-002-ALT	IM Posting Doc Amounts-002-ALT	ALT-IM_POSTING-002	IM Pos	12.5000000000	4	1000000003	1000000003	IM Posting Doc Amounts-002-ALT	ALT	ALT
default	1000000005	1000000005	IM Posting Doc Amounts-003-EDGE	1005	1105	14.0000	EDGE-IM_POSTING-003	5	5	1115	EDGE-I	14.0000000000	IM Posting Doc Amounts-003-EDG	IM Posting Doc Amounts-003-EDG	IM Posting Doc Amounts-003-EDG	IM Posting Doc Amounts-003-EDG	IM Posting Doc Amounts-003-EDG	IM Posting Doc Amounts-003-EDG	IM Posting Doc Amounts-003-EDG	IM Posting Doc Amounts-003-EDG	EDGE-IM_POSTING-003	IM Pos	14.0000000000	6	1000000005	1000000005	IM Posting Doc Amounts-003-EDG	EDG	EDG

Example values from field definitions

DOC_IDR: 1
POSTING_IDR: 1
AMOUNT_TYPER: SAMPLE
DEPT: 1
CLASS: 1
AMOUNT: 1.0000
TAX_KEY: SAMPLE
LOCATION: 1
ORG_UNIT: 1
SUBCLASS: 1
TAX_CODE: SAMPLE
TAX_RATE: 1.0000000000
GROUP_BY_1: SAMPLE
GROUP_BY_2: SAMPLE
GROUP_BY_3: SAMPLE
GROUP_BY_4: SAMPLE
GROUP_BY_5: SAMPLE
GROUP_BY_6: SAMPLE
GROUP_BY_7: SAMPLE
GROUP_BY_8: SAMPLE
ACCOUNT_CODE: SAMPLE
ACCOUNT_TYPE: SAMPLE
CURRENCY_RATE: 1.0000000000
LINE_GROUP_NO: 1
POSTING_AMT_ID: 1
SET_OF_BOOKS_ID: 1
CURRENCY_RATE_TYPE: SAMPLE
PRIM_CURRENCY_CODE: SAM
LOCAL_CURRENCY_CODE: SAM

default

DOC_IDR: 1000000003
POSTING_IDR: 1000000003
AMOUNT_TYPER: IM Posting Doc Amounts-002-ALT
DEPT: 1003
CLASS: 1103
AMOUNT: 12.5000
TAX_KEY: ALT-IM_POSTING-002
LOCATION: 3
ORG_UNIT: 3
SUBCLASS: 1113
TAX_CODE: ALT-IM
TAX_RATE: 12.5000000000
GROUP_BY_1: IM Posting Doc Amounts-002-ALT
GROUP_BY_2: IM Posting Doc Amounts-002-ALT
GROUP_BY_3: IM Posting Doc Amounts-002-ALT
GROUP_BY_4: IM Posting Doc Amounts-002-ALT
GROUP_BY_5: IM Posting Doc Amounts-002-ALT
GROUP_BY_6: IM Posting Doc Amounts-002-ALT
GROUP_BY_7: IM Posting Doc Amounts-002-ALT
GROUP_BY_8: IM Posting Doc Amounts-002-ALT
ACCOUNT_CODE: ALT-IM_POSTING-002
ACCOUNT_TYPE: IM Pos
CURRENCY_RATE: 12.5000000000
LINE_GROUP_NO: 4
POSTING_AMT_ID: 1000000003
SET_OF_BOOKS_ID: 1000000003
CURRENCY_RATE_TYPE: IM Posting Doc Amounts-002-ALT
PRIM_CURRENCY_CODE: ALT
LOCAL_CURRENCY_CODE: ALT