Order and Inventory Management – Accounting Connector Data Dictionary

SCMC__AP_Voucher_Line__c

Label: AP Voucher Line

The lines on the incoming invoice.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Dimension_1__c Dimension 1 Summer 2023 Dimension 1 record that relates to the AP voucher line. This is automatically populated from the Dimension 1 field on the relevant product group record. If the record type of the AP voucher line is Item, the product group of the item on the related purchase order is used. If the record type is Accounting, the product group of the accounting item is used.

Looks up to: c2g__codaDimension1__c

Lookup
Dimension_2__c Dimension 2 Summer 2023 Dimension 2 record that relates to the AP voucher line. This is automatically populated from the Dimension 2 field on the relevant product group record. If the record type of the AP voucher line is Item, the product group of the item on the related purchase order is used. If the record type is Accounting, the product group of the accounting item is used.

Looks up to: c2g__codaDimension2__c

Lookup
Dimension_3__c Dimension 3 Summer 2023 Dimension 3 record that relates to the AP voucher line. This is automatically populated from the Dimension 3 field on the relevant product group record. If the record type of the AP voucher line is Item, the product group of the item on the related purchase order is used. If the record type is Accounting, the product group of the accounting item is used.

Looks up to: c2g__codaDimension3__c

Lookup
Dimension_4__c Dimension 4 Summer 2023 Dimension 4 record that relates to the AP voucher line. This is automatically populated from the Dimension 4 field on the relevant product group record. If the record type of the AP voucher line is Item, the product group of the item on the related purchase order is used. If the record type is Accounting, the product group of the accounting item is used.

Looks up to: c2g__codaDimension4__c

Lookup
General_Ledger_Account__c General Ledger Account Summer 2023 General ledger account that relates to the AP voucher line. This is automatically populated based on the record type of the related purchase order line item. If the record type is Category, this is set to the Purchase Analysis Account for Category of the related product group. Otherwise, this is set to the General Ledger Account field of the purchase order line item.

Looks up to: c2g__codaGeneralLedgerAccount__c

Lookup
Item__c Item Summer 2023 Item record that relates to the AP voucher line. This is automatically populated based on the record type. If the record type of the AP voucher line is Accounting, this is set to the accounting item. Otherwise, this is set to the item being procured on the related purchase order line item.

Looks up to: SCMC__Item__c

Lookup
Payable_Invoice_Expense_Line_Item__c Payable Invoice Expense Line Item Summer 2023 The payable invoice expense line item that relates to the AP voucher line. Automatically populated when an expense line item is created from the AP voucher line.

Looks up to: c2g__codaPurchaseInvoiceExpenseLineItem__c

Lookup
Payable_Invoice_Line_Item__c Payable Invoice Line Item Summer 2023 The payable invoice line item that relates to the AP voucher line. Automatically populated when a line item is created from the AP voucher line.

Looks up to: c2g__codaPurchaseInvoiceLineItem__c

Lookup
Product_Line__c Product Line Summer 2023 Determines whether the AP voucher line represents a product line or an expense line. If this is selected, when you create a payable invoice from the related AP voucher, a payable invoice line item is created for this line. If this is deselected, a payable invoice expense line item is created for this line.

Formula:
IF( OR( OR( RecordType.DeveloperName == 'Tax',RecordType.DeveloperName == 'Accounting' ), AND( SCMC__Purchase_Order_Line_Item__r.SCMC__Item_Master__c != null, SCMC__Purchase_Order_Line_Item__r.RecordType.DeveloperName != 'Description', SCMC__Purchase_Order_Line_Item__r.RecordType.DeveloperName != 'Category' ) ), true, false)
Checkbox
Product__c Product Summer 2023 Product that relates to the AP voucher line. This is automatically populated based on the record type. If the record type of the AP voucher line is Item, this is set to the product of the product group related to the item being procured. If the record type is Accounting, this is set to the product of the product group related to the accounting item. If the record type is Tax, this is set from the OIM line type to product mappings.

Looks up to: Product2

Lookup


© Copyright 2009–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.