Table Name
|
Unique Key of the Table/Viewused in
Incremental load
|
AP_BATCHES_ALL
|
BATCH_ID
|
AP_CHECKS_ALL
|
CHECK_ID
|
AP_HOLDS_V
|
HLD_HOLD_ID
|
AP_INVOICE_DISTRIBUTION_ALL
|
ID_INVOICE_DISTRIBUTION_ID
|
AP_INVOICE_LINES_ALL
|
IL_INVOICE_LINE_ID
|
AP_INVOICE_PAYMENTS_ALL
|
IPAY_INVOICE_PAYMENT_ID
|
AP_INVOICES_ALL
|
INVOICE_ID
|
AP_PAYMENT_SCHEDULES_ALL
|
PS_PAYMENT_SCHEDULES_ID
|
AP_SUPPLIERS
|
VEN_VENDOR_ID
|
AP_TERMS_LINES, AP_TERMS_TL
|
TERM_ID
|
Based on View xx_sav_vendor_bank_details
|
|
GL_CODE_COMNINATIONS
|
CODE_COMBINATION_ID
|
PO_DISTRIBUTIONS_ALL
|
|
PO_HEADERS_ALL
|
PO_HEADER_ID
|
PO_LINE_LOCATIONS_ALL
|
|
PO_LINES_ALL
PO_LINE_LOCATIONS_ALLPO_DISTRIBUTIONS_ALL
|
POL_LINE_LOC_DIST_UNQ_ID (Incremental
load is done using revision number instead of Last Update Date)
|
Vendor Site bank details, View used by XX_AP_VENDOR_BANK_DETAILS
|
|
PO_REQUISITION_HEADERS_ALL
|
RH_REQUISITION_HEADER_ID
|
PO_REQUISITION_LINES_ALL
|
RL_REQUISITION_LINE_ID
|
RCV_SHIPMENT_HEADERS
|
RCH_SHIPMENT_HEADER_ID
|
RCV_SHIPMENT_LINES
|
RCL_SHIPMENT_LINE_ID
|
No comments:
Post a Comment