Oracle Projects- AP Integration Part3

Oracle Projects- AP Integration Part3

转自: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