|
METALINK 如是說:早看到就好了,希望后來者慎重
11i Changes in the Architecture Design
The accounting tables ap_accounting_events_all, ap_ae_headers_all and ap_ae_lines_all
were created along with the concurrent process Payables Create Accounting. This allows
the accounting to be created in AP and transferred to the GL as a whole package.
11i Pre FIN_D
Base Tables for Invoice
Ap_invoices_all
Ap_invoice_distributions_all
Base Tables for Payments
Ap_checks_all
Ap_invoice_payments_all
A new column ap_accounting_events_all has been added to ap_invoice_distributions_all
and ap_invoice_payments_all.
Once the Payables Create Accounting Process is run the posted_flag in
ap_invoice_distributions_all or ap_invoice_payments_all gets set to Y.
The information creates in -
Ap_accounting_events_all
Ap_ae_headers_all
Ap_ae_lines_all
The accounting_event_id created is populated in the cooresponding base table
ap_invoice_distributions_all or ap_invoice_payments_all.
FIN_D and later
The accounting process was changed.
At the time of invoice approval and payment confirmation a line in
ap_accounting_events_all gets populated with an event_status of CREATED.
The cooresponding accounting_event_id gets populated and the posted_flag remains N
in the base table of ap_invoice_distributions or ap_invoice_payments_all.
Run the concurrent process Payables Create Accounting, the posted_flag switches
to Y and the event status in ap_accounting_events_all table changes to ACCCOUNTED
or ACCOUNTED WITH ERROR. Then the ap_ae_headers_all and ap_ae_lines_all get created.
When the data gets transferred to the GL the transfer_flag = Y and the transfer_run_id
gets populated in ap_ae_headers_all. The detail data in ap_ae_lines_all gets tranferred
to the GL and the gl_sl_link_id in ap_ae_lines_all gets populated.
The Trial Balance prior to AP.I –
Each time the Trail Balance Report runs it uses the data in ap_ae_lines_all and
populates the temp table of ap_trial_bal. |
|