Buyer Worksheet PO List (GTT)

Out of Scope

Technical: BUYER_WKSHT_PO_LIST_GTT | ID: OR-FND-BUYER_WKSHT_PO_LIST_GTT-BUYER_WKSHT_PO_LIST_GTT

Provides historical Buyer Wksht PO List Gtt records used for Oracle Retail reporting, reconciliation, and downstream processing in BUYER_WKSHT_PO_LIST_GTT.

See how this object fits into Foundation Data

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: gtt

Target Structure

Load Approach: Table
Target Objects: BUYER_WKSHT_PO_LIST_GTT

Field Definitions(5)

Rules & Considerations(10)

Sample Load Data(4)

_scenario	DEPT	LOCATION	LOC_NAME	LOC_TYPE	ORDER_NO	SUPPLIER	SUP_NAME	WRITTEN_DATE	POOL_SUPPLIER	FIRST_ORDER_TOTAL	SECOND_ORDER_TOTAL
Example values from field definitions	1	1	SAMPLE	S	1	1	SAMPLE	2026-01-01	1	1.0000	1.0000
default	1003	3	Buyer Wksht PO List Gtt Secondary	B	4	3	Buyer Wksht PO List Gtt Secondary	2026-01-03	3	12.5000	12.5000
default	1005	5	Buyer Wksht PO List Gtt Core	B	6	5	Buyer Wksht PO List Gtt Core	2026-01-05	5	14.0000	14.0000

Example values from field definitions

DEPT: 1
LOCATION: 1
LOC_NAME: SAMPLE
LOC_TYPE: S
ORDER_NO: 1
SUPPLIER: 1
SUP_NAME: SAMPLE
WRITTEN_DATE: 2026-01-01
POOL_SUPPLIER: 1
FIRST_ORDER_TOTAL: 1.0000
SECOND_ORDER_TOTAL: 1.0000

default

DEPT: 1003
LOCATION: 3
LOC_NAME: Buyer Wksht PO List Gtt Secondary
LOC_TYPE: B
ORDER_NO: 4
SUPPLIER: 3
SUP_NAME: Buyer Wksht PO List Gtt Secondary
WRITTEN_DATE: 2026-01-03
POOL_SUPPLIER: 3
FIRST_ORDER_TOTAL: 12.5000
SECOND_ORDER_TOTAL: 12.5000

default

DEPT: 1005
LOCATION: 5
LOC_NAME: Buyer Wksht PO List Gtt Core
LOC_TYPE: B
ORDER_NO: 6
SUPPLIER: 5
SUP_NAME: Buyer Wksht PO List Gtt Core
WRITTEN_DATE: 2026-01-05
POOL_SUPPLIER: 5
FIRST_ORDER_TOTAL: 14.0000
SECOND_ORDER_TOTAL: 14.0000

Rule Validation Summary

Source Rule Count: 13
Governed Rule Count: 10

All objects