Technical Details of the Payables to Assets Interface Process

The Payables to Assets Interface process selects all voucher accounting lines with these values:

Field	Description	Value	Definition
VCHR_ACCTG_LINE.ASSET_FLG	Asset.	Y	Yes. Note: The value must be Y for each accounting entry to be distributed to PeopleSoft Asset Management.
VCHR_ACCTG_LINE.AM_DISTRIB_STATUS	Asset Management distribution status.	N or M	N (not yet distributed to asset management): The Voucher Posting process creates voucher accounting lines with this status, which indicates that the accounting lines have been posted. M (modified): The Voucher Unposting process creates reversal entries with this status, which indicates that the accounting lines have been unposted.
VCHR_ACCTG_LINE. POST_STATUS_AP	Account Payable Posting Status	P	Posted.
VCHR_ACCTG_LINE.PRIMARY_LEDGER	Primary ledger.	Y	Yes. Note: The value must be Y for each accounting entry to be distributed to PeopleSoft Asset Management.

Note:

For vouchers with receiving required, only vouchers with fully matched receivers are sent to PeopleSoft Asset Management.

The Payables to Assets Interface process copies the following information from the voucher distribution level in PeopleSoft Payables to the preinterface table (INTFC_PRE_AM) in PeopleSoft Asset Management:

Description	Field Name
Transaction date.	VOUCHER.INVOICE_DT
Accounting date.	VCHR_ACCTG_LINE.ACCOUNTING_DT
Purchase order (PO) keys, if the voucher is a PO voucher:
• PO business unit.	VCHR_ACCTG_LINE.BUSINESS_UNIT_PO
• PO ID.	VCHR_ACCTG_LINE.PO_ID
• PO line number.	VCHR_ACCTG_LINE.LINE_NBR
• PO schedule number.	VCHR_ACCTG_LINE.SCHED_NBR
• PO distribution line number.	VCHR_ACCTG_LINE.PO_DIST_LINE_NUM
Receiver keys:
• Receiver business unit.	VCHR_ACCTG_LINE.BUSINESS_UNIT_RECV
• Receiver ID.	VCHR_ACCTG_LINE.RECEIVER_ID
• Receiver line number.	VCHR_ACCTG_LINE.RECV_LN_NBR
• Receiver ship sequence number.	VCHR_ACCTG_LINE.RECV_SHIP_SEQ_NBR
• Receiver distribution line number.	VCHR_ACCTG_LINE.RECV_DIST_LINE_NUM
Payables business unit.	VCHR_ACCTG_LINE.BUSINESS_UNIT
Voucher ID.	VCHR_ACCTG_LINE.VOUCHER_ID
Voucher line number.	VCHR_ACCTG_LINE.VOUCHER_LINE_NUM
Voucher distribution line number.	VCHR_ACCTG_LINE.DISTRIB_LINE_NUM
Asset Management business unit.	VCHR_ACCTG_LINE.BUSINESS_UNIT_AM
Asset ID.	VCHR_ACCTG_LINE.ASSET_ID
Profile ID.	VCHR_ACCTG_LINE.PROFILE_ID
Cost type.	VCHR_ACCTG_LINE.COST_TYPE
ChartFields. Note: Available ChartFields include ACCOUNT, ALTACCT, BOOK_CODE, ADJUST_TYPE, CATEGORY, ACTIVITY, SCENARIO, STATISTICS_TBL, OPERATING_UNIT, DEPTID, PRODUCT, PROJECT_ID, FUND_CODE, CLASS_FLD, PROGRAM_CD, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3.	VCHR_ACCTG_LINE."ChartField" Note: Because ChartFields are configurable, they are mapped to their respective ChartField name. For example, department ID is mapped to VCHR_ACCTG_LINE.DEPTID.
Description.	VCHR_ACCTG_LINE.DESCR
Supplier ID.	VOUCHER.VENDOR_ID
Voucher quantity.	VCHR_ACCTG_LINE.QTY_VCHR
Cost in General Ledger business unit's base currency.	MONETARY_AMOUNT + FREIGHT_AMT_NP_BSE + MISC_AMT_NP_BSE + SALETX_AMT_NP_BSE + USETAX_AMT_NP_BSE + DSCNT_AMT_BSE. If VOUCHER.VAT_NRCVR_PRO_FLG = 'N', then MONETARY_AMOUNT + FREIGHT_AMT_NP_BSE + MISC_AMT_NP_BSE + SALETX_AMT_NP_BSE + USETAX_AMT_NP_BSE + DSCNT_AMT_BSE + (A.VAT_INV_AMT_BSE + A.VAT_NONINV_AMT_BSE - A.VAT_RCVRY_AMT_BSE - A.VAT_REBATE_AMT_BSE). Note that all fields are from VCHR_ACCTG_LINE. Note: Monetary amount is calculated as follows: Merchandise Amount + Sales Tax (if prorating sales tax) + Use Tax (if prorating use tax) + Freight (if prorating freight) + Miscellaneous Charges + Nonrecoverable Prorated VAT − Discount (if accounting at net).
Transaction cost in transaction currency.	FOREIGN_AMOUNT + FREIGHT_AMT_NP + MISC_AMT_NP + SALETX_AMT_NP + USETAX_AMT_NP + DSCNT_AMT. If VOUCHER.VAT_NRCVR_PRO_FLG = 'N' then TXN_COST = FOREIGN_AMOUNT + FREIGHT_AMT_NP + MISC_AMT_NP + SALETX_AMT_NP + USETAX_AMT_NP + DSCNT_AMT + (VAT_INV_AMT + VAT_NONINV_AMT − VAT_RCVRY_AMT - VAT_REBATE_AMT). Note that all fields are from VCHR_ACCTG_LINE.
Sales tax amount in General Ledger business unit's base currency.	SALETX_AMT_BSE + SALETX_AMT_NP_BSE
Sales tax code.	VOUCHER.SALETX_CD
Use tax amount in General Ledger business unit's base currency.	USETAX_AMT_BSE + USETAX_AMT_NP_BSE
Use tax code.	VOUCHER.USETAX_CD
Freight amount in General Ledger business unit's base currency.	FREIGHT_AMT_BSE + FREIGHT_AMT_NP_BSE Note: If VOUCHER.FRGHT_PRORATE_FLG is 'N', FREIGHT_AMT_NP_BSE is not 0 while FREIGHT_AMT_BSE is 0.
Discount amount.	VCHR_ACCTG_LINE.DSCNT_AMT
Invoice ID.	VOUCHER.INVOICE_ID
Procurement Group ID	PO_GROUP_ID
Tag Number	TAG_NUMBER
Serial ID	SERIAL_ID
Distribution Sequence Number	DISTRIB_SEQ_NUM
General Ledger business unit's base currency code.	VCHR_ACCTG_LINE.CURRENCY_CD
Transaction currency code.	VCHR_ACCTG_LINE.FOREIGN_CURRENCY
Project Costing business unit.	VCHR_ACCTG_LINE.BUSINESS_UNIT_PC
Activity ID.	VCHR_ACCTG_LINE.ACTIVITY_ID
Analysis type.	VCHR_ACCTG_LINE.ANALYSIS_TYPE
Resource type.	VCHR_ACCTG_LINE.RESOURCE_TYPE
Resource category.	VCHR_ACCTG_LINE.RESOURCE_CATEGORY
Resource subcategory.	VCHR_ACCTG_LINE.RESOURCE_SUB_CAT
Merchandise amount.	VCHR_ACCTG_LINE.MERCH_AMT_VSE
VAT invoice amount.	VCHR_ACCTG_LINE.VAT_INV_AMT_BSE
VAT recovery amount.	VCHR_ACCTG_LINE.VAT_RCVRY_AMT_BSE
VAT nonrecoverable amount.	VAT_INV_AMT_BSE + VAT_NONINV_AMT_BSE -.VAT_RCVRY_AMT_BSE − VAT_REBATE_AMT_BSE. Note that all fields are from VCHR_ACCTG_LINE.

Note:

After the system copies the voucher information to the Pre-interface table, the Payables to Assets Interface process sets the AM_DISTRIB_STATUS field on the voucher accounting line for all the selected vouchers to D (distributed).

Once the voucher has been preloaded into the Pre-interface table using the Payables to Assets Interface process, you can view the information on the Load Preview - Pre-AM - Financial page and Pre-AM Physical page. See Asset Lifecycle Management Fundamentals: Processing Purchasing and Payables Transactions with Asset Management

Next, you complete the asset-loading process by running the Payables/Purchasing Interface Application Engine process (AMPS1000), which automatically calls the Transaction Loader Application Engine process (AMIF1000). The Payables/Purchasing Interface process creates interface IDs. The Transaction Loader process uses the interface IDs and creates an acquisition row for each asset. After you run the two processes, you can view the asset cost on the Asset Cost Adjust/Transfer page.