Thursday 14 July 2011

Purchasing and Payables links

AP_INVOICES                       AIA,
AP_INVOICE_DISTRIBUTIONS               AID,
AP_HOLDS                          APH,
AP_BATCHES                        APB,
AP_PAYMENT_SCHEDULES              APS,
AP_LOOKUP_CODES                  ALC,
AP_TERMS                          APT,
PO_HEADERS                        PH,
PO_LINES                         PL,
PO_DISTRIBUTIONS                  PD,
PO_LINE_LOCATIONS                 PLL,
PO_VENDORS                        PV,
PO_RELEASES                       PR,

ü  AIA.INVOICE_ID=AID.INVOICE_ID
ü  AIA.VENDOR_ID=PH.VENDOR_ID
ü  PD.PO_DISTRIBUTION_ID=AID.PO_DISTRIBUTION_ID
ü  APH.LINE_LOCATION_ID=PLL.LINE_LOCATION_ID
ü  AIA.VENDOR_ID=PV.VENDOR_ID
ü  PLL.PO_HEADER_ID=PH.PO_HEADER_ID
ü  PLL.PO_LINE_ID=PL.PO_LINE_ID
ü  PR.PO_HEADER_ID=PH.PO_HEADER_ID
ü  PD.PO_HEADER_ID=PH.PO_HEADER_ID
ü  PH.PO_HEADER_ID=PL.PO_HEADER_ID
ü  PD.PO_LINE_ID=PL.PO_LINE_ID
ü  APB.BATCH_ID=AIA.BATCH_ID
ü  ALC.LOOKUP_CODE=APH.HOLD_LOOKUP_CODE
ü  APS.INVOICE_ID=AIA.INVOICE_ID
ü  APH.INVOICE_ID=AIA.INVOICE_ID
ü  APT.TERM_ID=AIA.TERMS_ID

No comments:

Post a Comment