|
转自：http://www.linkedin.com/pulse/20140701051803-19818376-oracle-projects-ap-integration-part3
Release 11i
|
AP_INVOICES_ALL
|
PA_EXPENDITURE_ITEMS_ALL
|
PA_COST_DISTRIBUTION_LINES_ALL
|
|
INVOICE_NUM
|
ORIG_USER_EXP_TXN_REFERENCE
|
|
|
INVOICE_ID
|
ORIG_EXP_TXN_REFERENCE1
|
SYSTEM_REFERENCE2
|
|
VENDOR_ID
|
VENDOR_ID
|
SYSTEM_REFERENCE1
|
|
ORG_ID
|
ORG_ID
|
ORG_ID
|
|
AP_INVOICE_DISTRIBUTIONS_ALL
|
PA_EXPENDITURE_ITEMS_ALL
|
PA_COST_DISTRIBUTION_LINES_ALL
|
|
DISTRIBUTION_LINE_NUMBER
|
|
SYSTEM_REFERENCE3
|
|
DIST_CODE_COMBINATION_ID
|
|
DR_CODE_COMBINATION_ID
|
|
INVOICE_ID
|
|
SYSTEM_REFERENCE2
|
|
EXPENDITURE_TYPE
|
EXPENDITURE_TYPE
|
|
|
EXPENDITURE_ORGANIZATION_ID
|
EXPENDITURE_ORGANIZATION_ID
|
|
|
PROJECT_ID
|
PROJECT_ID
|
PROJECT_ID
|
|
TASK_ID
|
TASK_ID
|
TASK_ID
|
|
EXPENDITURE_ITEM_DATE
|
EXPENDITURE_ITEM_DATE
|
GL_DATE
|
|
ORG_ID
|
ORG_ID
|
ORG_ID
|
|
PA_QUANTITY
|
QUANTITY
|
QUANTITY
|
|
AMOUNT
|
RAW_COST
|
AMOUNT
|
|