bod mapping and descriptions
Post on 27-Apr-2015
126 Views
Preview:
DESCRIPTION
TRANSCRIPT
Copyright © 2009 InforAll rights reserved. The word and design marks set forth herein are trademarks and/or registered trademarks of Inforand/or related affiliates and subsidiaries. All rights reserved. All other trademarks listed herein are the property oftheir respective owners.
Important NoticesThe material contained in this publication (including any supplementary information) constitutes and containsconfidential and proprietary information of Infor.By gaining access to the attached, you acknowledge and agree that the material (including any modification,translation or adaptation of the material) and all copyright, trade secrets and all other right, title and interest therein,are the sole property of Infor and that you shall not gain right, title or interest in the material (including anymodification, translation or adaptation of the material) by virtue of your review thereof other than the non-exclusiveright to use the material solely in connection with and the furtherance of your license and use of software madeavailable to your company from Infor pursuant to a separate agreement (“Purpose”).In addition, by accessing the enclosed material, you acknowledge and agree that you are required to maintain suchmaterial in strict confidence and that your use of such material is limited to the Purpose described above.Although Infor has taken due care to ensure that the material included in this publication is accurate and complete,Infor cannot warrant that the information contained in this publication is complete, does not contain typographical orother errors, or will meet your specific requirements. As such, Infor does not assume and hereby disclaims all liability,consequential or otherwise, for any loss or damage to any person or entity which is caused by or relates to errors oromissions in this publication (including any supplementary information), whether such errors or omissions result fromnegligence, accident or any other cause.
Publication InformationRelease: Infor ERP VISUAL Enterprise 6.5.4
Publication Date: August 13, 2009
Version: VE6.5.4
August 13, 2009 3
CodeDefinitionCodeDefinition/DocumentID/ID
If ListID=Dimension, then soa_code_lise.code+soa_code_list.agency_idIf ListID=HoldReasonCodes, CommodityCodes, ProductLines, then soa_code_list.codeElse soa_code_list.list_id+soa_code_list.agency_id+soa_code_list.code
If ListID=Dimension, then Code Mapping Maintenance, SOA Codes, List ID '~' Code Mapping Maintenance, SOA Codes, Agency IDIf ListID=HoldReasonCodes, CommodityCodes, ProductLines, then SOA Codes, LIst IDElse Code Mapping Maintenance, SOA Codes, List ID '~' Code Mapping Maintenance, SOA Codes, List ID '~' Code Mapping Maintenance SOA Codes, Code
CodeDefinition/EffectiveTimePeriod/StartDateTimeIf list ID=dimension: soa_dimension.effective_dateOtherwise: soa_code_list.effective_date
CodeDefinition/EffectiveTimePeriod/EndDateTimeIf list ID=dimension: soa_dimension.expiration_dateOtherwise: soa_code_list.expiration_date
CodeDefinition/Status/CodeIf listID=dimension: soa_dimension.statusIf listID=HoldReasonCodes: OpenIf listID=CommodityCodes: OpenIf listID=ProductLines: OpenIf listID=Departments: OpenIf listID=Territory: OpenIf listID=InvAdjReasonCodes: OpenIf listID=PackagingTypes: OpenOtherwise: soa_code_list.status
If listID=dimension: SOA_DIMENSION.STATUSIf listID=HoldReasonCodes: OpenIf listID=CommodityCodes: OpenIf listID=ProductLines: OpenIf listID=Departments: OpenIf listID=Territory: OpenIf listID=InvAdjReasonCodes: OpenIf listID=PackagingTypes: OpenOtherwise: SOA Code Maintenance, SOA Codes, Status.If code has been deleted, then status=Deleted
CodeDefinition/ReadOnlyIndicatorIf listID=diemnsion: soa_dimension.read_onlyIf listID=HoldReasonCodes: FalseIf listID=CommodityCodes: FalseIf listID=ProductLines: FalseIf listID=Departments: FalseIf listID=Territory: FalseIf listID=InvAdjReasonCodes: FalseIf listID=PackagingTypes: FalseOtherwise: soa_code_list.read_only
If listID=diemnsion: SOA_DIMENSION.READ_ONLYIf listID=HoldReasonCodes: FalseIf listID=CommodityCodes: FalseIf listID=ProductLines: FalseIf listID=Departments: FalseIf listID=Territory: FalseIf listID=InvAdjReasonCodes: FalseIf listID=PackagingTypes: FalseOtherwise: SOA Code Maintenance, SOA Codes, Read Only
CodeDefinition/ListIDsoa_code_list.list_id SOA Code Maintenance, SOA Codes, List ID or
listID=HoldReasonCodeslistID=CommodityCodeslistID=ProductLineslistID=DepartmentslistID=TerritorylistID=InvAdjReasonCodeslistID=PackagingTypes
CodeDefinition/CodeValueIf ListID=Dimension: soa_dimension.idIf listID=HoldReasonCodes: hold_reason.idIf listID=CommodityCodes: commodity.codeIf listID=ProductLines: product.code
If ListID=Dimension: SOA_DIMENSION.IDIf listID=HoldReasonCodes: Part Maintenance, Hold Reasons, Hold Reason IDIf listID=CommodityCodes: Application Global Maintenance, Tables Maintenance, Commodities, CodeIf listID=ProductLines: Part Maintenance, Product Codes, Product CodeIf listID=Departments: Application Global Maintenance, Accounting Maintenance, Department Maintenance, IDIf listID=Territory: Application Global Maintenance, Tables Maintenance, Territory, CodeIf listID=InvAdjReasonCodes: Application Global Maintenance, Reasons Maintenance, Adjustment Reason Maintenance, CodeIf listID=PackagingTypes: Application Global Maintenance, Package Type Maintenance, Code
August 13, 2009 4
CodeDefinitionIf listID=Departments: department.idIf listID=Territory: territory.codeIf listID=InvAdjReasonCodes: adj_reason.codeIf listID=PackagingTypes: package_type.codeFor all other listIDs: soa_code_list.code
For all other listIDs=SOA Code Maintenance, SOA Codes, Code
CodeDefinition/NameIf ListID=Dimension: soa_dimension.idIf listID=HoldReasonCodes: hold_reason.idIf listID=CommodityCodes: commodity.codeIf listID=ProductLines: product.codeIf listID=Departments: department.idIf listID=Territory: territory.codeIf listID=InvAdjReasonCodes: adj_reason.codeIf listID=PackagingTypes: package_type.codeFor all other listIDs: soa_code_list.code
If ListID=Dimension: SOA_DIMENSION.IDIf listID=HoldReasonCodes: Part Maintenance, Hold Reasons, Hold Reason IDIf listID=CommodityCodes: Application Global Maintenance, Tables Maintenance, Commodities, CodeIf listID=ProductLines: Part Maintenance, Product Codes, Product CodeIf listID=Departments: Application Global Maintenance, Accounting Maintenance, Department Maintenance, IDIf listID=Territory: Application Global Maintenance, Tables Maintenance, Territory, CodeIf listID=InvAdjReasonCodes: Application Global Maintenance, Reasons Maintenance, Adjustment Reason Maintenance, CodeIf listID=PackagingTypes: Application Global Maintenance, Package Type Maintenance, CodeFor all other listIDs: SOA Code Maintenance, SOA Codes, Name
CodeDefinition/DescriptionIf ListID=Dimension: soa_dimension.descriptionIf listID=HoldReasonCodes: hold_reason.descriptionIf listID=CommodityCodes: commodity.codeIf listID=ProductLines: product.descriptionIf listID=Departments: department.descriptionIf listID=Territory: territory.codeIf listID=InvAdjReasonCodes: adj_reason.descriptionIf listID=PackagingTypes: package_type.codeFor all other listIDs: soa_code_list.code_desc
If ListID=Dimension: SOA_DIMENSION.DESCRIPTIONIf listID=HoldReasonCodes: Part Maintenance, Hold Reasons, DescriptionIf listID=CommodityCodes: Application Global Maintenance, Tables Maintenance, Commodities, CodeIf listID=ProductLines: Part Maintenance, Product Codes, DescriptionIf listID=Departments: Application Global Maintenance, Accounting Maintenance, Department Maintenance, DescriptionIf listID=Territory: Application Global Maintenance, Tables Maintenance, Territory, CodeIf listID=InvAdjReasonCodes: Application Global Maintenance, Reasons Maintenance, Adjustment Reason Maintenance, DescriptionIf listID=PackagingTypes: Application Global Maintenance, Package Type Maintenance, CodeFor all other listIDs: SOA Code Maintenance, SOA Codes, Description
August 13, 2009 5
CustomerPartyMasterCustomerPartyMaster@category
Organization@role
Customer, Bill-to, or Ship-to. One BOD is sent for each customer address. When the Sold To address is sent, then role=Customer. When the Bill To address is sent, then role=Ship-to. When alternate shipping addresses are sent, then role=ship-to
CustomerPartyMaster/PartyIDs/IDcustomer.idcustomer.id+~Bill-Tocustomer.id+~Ship-To
When CustomerPartyMaster@role=Customer, then Customer Maintenance, Customer IDWhen CustomerPartyMaster@role=Bill-to, then Customer Maintenance, Customer ID~Bill-toWhen CustomerPartyMaster@role=Ship-to, then Customer Maintenance, Customer ID~Ship-to
@schemeName System
@schemeAgencyID The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID
CustomerPartyMaster/PartyIDs/TaxIDcustomer.tax_id_number Customer Maintenance, Accounting tab, Tax ID Number
CustomerPartyMaster/Namecustomer.customer_name Customer Maintenance, Customer Name
CustomerPartyMaster/Location/Namecustomer.customer_name Customer Maintenance, Customer Name
CustomerPartyMaster/Location/Address/AddressLine@sequence
1: customer.addr_12: customer.addr_23: customer.addr_3
Customer Maintenance, Sold To Street Address
CustomerPartyMaster/Location/Address/CitySubDivisionName unknown
CustomerPartyMaster/Location/Address/CityNamecustomer.city Customer Maintenance, City
CustomerPartyMaster/Location/Address/CountrySubDivisionCodecustomer.state Customer Maintenance, State
@listID Country Sub-divisions
CustomerPartyMaster/Location/Address/CountryCodecustomer.country Customer Maintenance, Country
@listID Countries
CustomerPartyMaster/Location/Address/PostalCodecustomer.zipcode Customer Maintenance, Zip
@listID Postal/Zip Codes
CustomerPartyMaster/FinancialParty/Namecustomer_bank.name Customer Maintenance, Banks, Name
@languageIDsettings.lanugage_id SOA Maintenance, Language ID
CustomerPartyMaster/FinancialParty/Location/Address/AddressLinecustomer_bank.addr_1customer_bank.addr_2customer_bank.addr_3
Customer Maintenance, Banks, Street Address
@sequence1: customer_bank.addr_12: customer_bank.addr_23: customer_bank.addr_3
Customer Maintenance, Banks, Street Address
CustomerPartyMaster/FinancialParty/Location/Address/CityNamecustomer_bank.city Customer Maintenance, Banks, City
CustomerPartyMaster/FinancialParty/Location/Address/CountrySubDivisionCodecustomer_bank.state Customer Maintenance, Banks, State
@listID Country Sub-divisions
CustomerPartyMaster/FinancialParty/Location/Address/CountryCodecustomer_bank.country Customer Maintenance, Banks, Country
August 13, 2009 6
CustomerPartyMaster@listID
Countries
CustomerPartyMaster/FinancialParty/Location/Address/PostalCodecustomer_bank.zipcode Customer Maintenance, Banks, Zip
@listID Postal/Zip Codes
CustomerPartyMaster/FinancialParty/FinancialAccount/IBANIDcustomer_bank.iban Customer Maintenance, Banks, IBAN
CustomerPartyMaster/FinancialParty/FinancialAccount/AccountIDs/IDcustomer_bank.account_no Customer Maintenance, Banks, Account #
CustomerPartyMaster/RequesterContact/Namecustomer.contact_name Customer Maintenance, Contact tab, Contact
CustomerPartyMaster/PlannerContact/Namecustomer.contact_name Customer Maintenance, Contact tab, Contact
CustomerPartyMaster/BuyerContact/Namecustomer.contact_name Customer Maintenance, Contact tab, Contact
CustomerPartyMaster/ReceivingContact/Namecustomer.contact_name Customer Maintenance, Contact tab, Contact
CustomerPartyMaster/Status/Codecustomer.active_flag Customer Maintenance, Active check box. When selected, status is Open. When clear, status is Closed.
@listID Customer Status
CustomerPartyMaster/DaysEarlyAllowedcustomer.days_early Customer Maintenance, Shipping tab, Accepts Early Orders check box and field
CustomerPartyMaster/Classification/Codes/Code1: customer.customer_type2: customer.territory3: cust_address.ship_price_grp4: customer.market_id
1: Customer Maintenance, Order Mgt tab, Customer Type2: Customer Maintenance, General tab, Territory3: Customer Maintenance, Shipping Addresses, Price Group4: Customer Maintenance, General tab, Market
@sequence1234
@listID1: Customer Account Type2: Territories3: ShipAdr Price Groups4: Markets
August 13, 2009 7
CustomerPartyMasterCustomerPartyMaster/DefaultShipFromWarehouseLocation/ID
customer.warehouse_id Customer Maintenance, Order Management tab, Primary Warehouse
CustomerPartyMaster/CustomerAccount/Term/Descriptioncustomer.terms_description Customer Maintenance, Accounting tab, Terms
CustomerPartyMaster/CustomerAccount/Term/Duration P9999D
CustomerPartyMaster/CustomerAccount/OrderLimitAmountcustomer.credit_limit Customer Maintenance, Credit Limit tab, Credit Limit
@currencyIDcustomer.iso_curr_code Customer Maintenance, Accounting tab, Currency ID translated to the ISO code based on your settings in Code Mapping
Maintenance
CustomerPartyMaster/CustomerAccount/TotalCreditLimitAmountcustomer.credit_limit Customer Maintenance, Credit Limit tab, Credit Limit
@currencyIDcustomer.iso_curr_code Customer Maintenance, Accounting tab, Currency ID translated to the ISO code based on your settings in Code Mapping
Maintenance
CustomerPartyMaster/CustomerAccount/MaxAgingDurationcustomer.recv_age_limit Customer Maintenance, Credit Limit tab, Recv Age Limit expressed as P[RECV_AGE_LIMIT]D, for example P30D
CustomerPartyMaster/CustomerAccount/StatementPeriodDurationcustomer.recv_age_limit Customer Maintenance, Credit Limit tab, Recv Age Limit expressed as P[RECV_AGE_LIMIT]D, for example P30D
CustomerPartyMaster/CustomerAccount/AccountOpenedDateTimecustomer.open_date Customer Maintenance, General tab, Account Open
CustomerPartyMaster/CustomerAccount/LastModificationDateTimecustomer.modify_date Customer Maintenance, General tab, Account Modified
CustomerPartyMaster/CarrierParty/PartyIDs/IDcustomer.carrier_id Customer Maintenance, Shipping tab, Carrier ID
CustomerPartyMaster/CarrierParty/Namecarrier.carrier_name Application Global Maintenance, Carrier Maintenance, Carrier Name
CustomerPartyMaster/CarrierParty/Location/Address/AddressLinecarrier.carrier_addr_1carrier.carrier_addr_2carrier.carrier_addr_3
Application Global Maintenance, Carrier Maintenance, Addr 1, 2, and 3
@sequence1 carrier.carrier_addr_12 carrier.carrier_addr_23 carrier.carrier_addr_3
Application Global Maintenance, Carrier Maintenance, Addr 1, 2, and 3
CustomerPartyMaster/CarrierParty/Location/Address/CityNamecarrier.carrier_city Application Global Maintenance, Carrier Maintenance, City
CustomerPartyMaster/CarrierParty/Location/Address/CountrySubDivisionCodecarrier.carrier_state Application Global Maintenance, Carrier Maintenance, State/Province
@listID Country Sub-divisions
CustomerPartyMaster/CarrierParty/Location/Address/CountryCodecarrier.carrier_country Application Global Maintenance, Carrier Maintenance, Country
@listID Countries
CustomerPartyMaster/CarrierParty/Location/Address/PostalCodecarrier.carrier_zipcode Application Global Maintenance, Carrier Maintenance, Zip/Postal Code
CustomerPartyMaster/CarrierParty/Contact/Communication/UseCode email
@listID Communication Use Codes
CustomerPartyMaster/CarrierParty/Contact/Communication/URIcarrier.carrier_web_url Application Global Maintenance, Carrier Maintenance, Web URL
CustomerPartyMaster/SalesPersonReference/IDs/IDcustomer.salesrep_id Customer Maintenance, General tab, Sales Rep ID
@schemeName System
CustomerPartyMaster@category
August 13, 2009 8
CustomerPartyMaster Organization
@role Customer
CustomerPartyMaster/PartyIDs/IDv_account.id Account, Account ID
@schemeName System
@schemeAgencyID The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID
CustomerPartyMaster/PartyIDs/TaxIDv_account.tax_id_nbr Account, Accounting tab, Tax ID #
CustomerPartyMaster/Namev_account.name Account, Account tab, Name
CustomerPartyMaster/Location/Namev_account.name Account, Account tab, Name
CustomerPartyMaster/Location/Address/AddressLine@sequence
1 v_address.addr_12 v_address.addr_23 v_address.addr_3
Address, General tab, Address fields
CustomerPartyMaster/Location/Address/CityNamev_address.city Address, General tab, City
CustomerPartyMaster/Location/Address/CountrySubDivisionCodev_address.state Address, General tab, State
@listID Country Sub-divisions
CustomerPartyMaster/Location/Address/CountryCodev_address.country Address, General tab, Country
@listID Countries
August 13, 2009 9
CustomerPartyMasterCustomerPartyMaster/Location/Address/PostalCode
v_address.zipcode Address, General tab, Zip@listID
Postal/Zip Codes
CustomerPartyMaster/Location/Description Sold To
CustomerPartyMaster/FinancialParty/Namecustomer_bank.name Customer Maintenance, Banks, Name
@languageID SOA Maintenance, Language ID
CustomerPartyMaster/FinancialParty/Location/Address/AddressLinecustomer_bank.addr_1customer_bank.addr_2customer_bank.addr_3
Customer Maintenance, Banks, Street Address
@sequence1: customer_bank.addr_12: customer_bank.addr_23: customer_bank.addr_3
Customer Maintenance, Banks, Street Address
CustomerPartyMaster/FinancialParty/Location/Address/CityNamecustomer_bank.city Customer Maintenance, Banks, City
CustomerPartyMaster/FinancialParty/Location/Address/CountrySubDivisionCodecustomer_bank.state Customer Maintenance, Banks, State
@listID Country Sub-divisions
CustomerPartyMaster/FinancialParty/Location/Address/CountryCodecustomer_bank.country Customer Maintenance, Banks, Country
@listID Countries
CustomerPartyMaster/FinancialParty/Location/Address/PostalCodecustomer_bank.zipcode Customer Maintenance, Banks, Zip
@listID Postal/Zip Codes
CustomerPartyMaster/FinancialParty/FinancialAccount/IBANIDcustomer_bank.iban Customer Maintenance, Banks, IBAN
CustomerPartyMaster/FinancialParty/FinancialAccount/AccountIDs/IDcustomer_bank.account_no Customer Maintenance, Ban ks, Account #
CustomerPartyMaster/RequesterContact/Namev_account.contact_first_name+v_account.contact_initial+v_account.contact_last_name
Account, Contact tab, Primary Contact
CustomerPartyMaster/PlannerContact/Namev_account.contact_first_name+v_account.contact_initial+v_account.contact_last_name
Account, Contact tab, Primary Contact
CustomerPartyMaster/BuyerContact/Namev_account.contact_first_name+v_account.contact_initial+v_account.contact_last_name
Account, Contact tab, Primary Contact
CustomerPartyMaster/ReceivingContact/Namev_account.contact_first_name+v_account.contact_initial+v_account.contact_last_name
Account, Contact tab, Primary Contact
CustomerPartyMaster/Status/Codev_account.inactive_account Account, General tab, Inactive check box
@listID Customer Status
CustomerPartyMaster/DaysEarlyAllowedv_account.days_early Account, Shipping tab, Accepts Early Orders
CustomerPartyMaster/Classification/Codes/Codecustomer.customer_type Customer Maintenance, OrderMgt, Customer Type
August 13, 2009 10
CustomerPartyMastercustomer.territory Customer Maintenance, General tab, Territory
@sequence1: customer.customer_type2: customer.territory
1: Customer Maintenance, Order Mgt tab, Customer Type2: Customer Maintenance, General tab, Territory
@listID Customer Account Type, Territories
CustomerPartyMaster/DefaultShipFromWarehouseLocation/IDv_account.warehouse_id Account, Ordr Mgt, Primary Warehouse
CustomerPartyMaster/CustomerAccount/Term/Descriptionv_account..terms_disc_datev_account.terms_disc_daysv_account.terms_disc_percentv_account.terms_disc_typev_account.terms_net_datev_account.terms_net_daysv_account.terms_net_type
Account, Accounting tab, Terms
CustomerPartyMaster/CustomerAccount/Term/Duration P9999D
CustomerPartyMaster/CustomerAccount/OrderLimitAmountv_account.credit_limit Account, Accounting tab, Credit Limit
@currencyIDcustomer.iso_curr_code Customer Maintenance, Accounting tab, Currency ID translated to the ISO code based on your settings in Code Mapping
Maintenance
CustomerPartyMaster/CustomerAccount/TotalCreditLimitAmountv_account..credit_limit Account, Accounting tab, Credit LImit
@currencyIDcustomer.iso_curr_code Customer Maintenance, Accounting tab, Currency ID translated to the ISO code based on your settings in Code Mapping
Maintenance
CustomerPartyMaster/CustomerAccount/MaxAgingDurationv_account.recv_age_limit Account, Accounting tab, Recv Age Limit expressed as P[RECV_AGE_LIMIT]D, for example P30D
CustomerPartyMaster/CustomerAccount/StatementPeriodDurationv_account.recv_age_limit Account, Accounting tab, Recv Age Limit expressed as P[RECV_AGE_LIMIT]D, for example P30D
CustomerPartyMaster/CustomerAccount/AccountOpenedDateTimev_account.open_date Account, Account tab, Open
CustomerPartyMaster/CustomerAccount/LastModificationDateTimev_account.last_modified Account, Account tab, Modified
CustomerPartyMaster/CarrierParty/PartyIDs/IDcustomer.carrier_id Customer Maintenance, Shipping tab, Carrier ID
CustomerPartyMaster/CarrierParty/Namecarrier.carrier_name Application Global Maintenance, Carrier Maintenance, Carrier Name
CustomerPartyMaster/CarrierParty/Location/Address/AddressLinecarrier.carrier_addr_1carrier.carrier_addr_2carrier.carrier_addr_3
Application Global Maintenance, Carrier Maintenance, Addr 1, 2, and 3
August 13, 2009 11
CustomerPartyMaster@sequence
1 carrier.carrier_addr_12 carrier.carrier_addr_23 carrier.carrier_addr_3
Application Global Maintenance, Carrier Maintenance, Addr 1, 2, and 3
CustomerPartyMaster/CarrierParty/Location/Address/CityNamecarrier.carrier_city Application Global Maintenance, Carrier Maintenance, City
CustomerPartyMaster/CarrierParty/Location/Address/CountrySubDivisionCodecarrier.carrier_state Application Global Maintenance, Carrier Maintenance, State/Province
@listID Country Sub-divisions
CustomerPartyMaster/CarrierParty/Location/Address/CountryCodecarrier.carrier_country Application Global Maintenance, Carrier Maintenance, Country
@listID Countries
CustomerPartyMaster/CarrierParty/Location/Address/PostalCodecarrier.carrier_zipcode Application Global Maintenance, Carrier Maintenance, Zip/Postal Code
CustomerPartyMaster/CarrierParty/Contact/Communication/UseCode email
@listID Communication Use Codes
CustomerPartyMaster/CarrierParty/Contact/Communication/URIcarrier.carrier_web_url Application Global Maintenance, Carrier Maintenance, Web URL
CustomerPartyMaster/SalesPersonReference/IDs/IDv_account.salesrep_id Account, Sales Rep tab, Default Sales Rep
@schemeName System
August 13, 2009 12
InvoiceInvoice/InvoiceHeader@type
payable.typereceivable.type
If type = M then for payables, "CreditMemo"; for receivables, "DebitMemo"If type = I then "Invoice" for payables and receivables
Invoice/InvoiceHeader/DocumentID/IDpayable.voucher_idreceivable.invoice_id
For payables, payable.voucher_idFor receivables, receivable.invoice_id
Invoice/InvoiceHeader/DocumentID@agencyRole
For payables, "Customer"For receivables, "Supplier"
@accountingEntityapplication_global.entity_id Application Global Maintenance, Default Mfg Entity ID
@location SOA Maintenance, SOA Location
@lid The system combines lid://infor.visual with the value in SOA Maintenance, Visual Instance ID
Invoice/InvoiceHeader/LastModificationDateTime The system inserts the date and time the BOD was created
Invoice/InvoiceHeader/DocumentDateTimepayable.create_datereceivable.create_date
For payables, is not displayed in Payables Invoice Entry. Available in Invoice ID browse table.For receivables, is not displayed in Receivables Invoice Entry. Available in Invoice ID browse table.
Invoice/InvoiceHeader/Notenotation.note Payables Invoice Entry, Invoice Notations
Receivables Invoice Entry, Invoice Notations@languageID
settings.language_id SOA Maintenance, Language ID
Invoice/InvoiceHeader/TotalAmountpayable.total_amountreceivable.total_amount
For payables, Payables Invoice Entry, Total AmountFor receivables, Receivables Invoice Entry, Total AmountIf invoice is void, then 0.
@currencyIDpayable.currency_idreceivable.currency_id
For payables, Payables Invoice Entry, Currency IDFor receivables, Receivables Invoice Entry, Currency IDThe system translates the currency ID to an ISO code based on your settings in Code Mapping.
Invoice/InvoiceHeader/SupplierParty/PartyIDs/IDvendor.id For payables, Payable Invoice Entry, Vendor ID
For receivables, null
Invoice/InvoiceHeader/SupplierParty/PartyIDs/TaxIDvendor.tax_id_numberapplication_global.tax_id_number
For payables, Vendor Maintenance, Tax ID NumberFor receivables, Application Global Maintenance, Tax ID Number
Invoice/InvoiceHeader/SupplierParty/Namevendor.nameapplication_global.company_name
For payables, Vendor Maintenance, NameFor receivables, Application Global Maintenance, Company Name
@languageIDsettings.language_id SOA Maintenance, Language ID
Invoice/InvoiceHeader/SupplierParty/Location/Namevendor.nameapplication_global.company_name
For payables, Vendor Maintenance, NameFor receivables, Application Global Maintenance, Company Name
Invoice/InvoiceHeader/SupplierParty/Location/Address/AddressLine@sequence
1: vendor.addr_12: vendor.addr_23: vendor.addr_3
1: application_global.company_addr_12: application_global.company_addr_23: application_global.
For payables, Vendor Maintenance, Address 1, Address 2, Address 3For receivables, Application Global Mainteance, Company Address 1, Company Address 2, Company Address 3
August 13, 2009 13
Invoicecompany_addr_3
Invoice/InvoiceHeader/SupplierParty/Location/Address/CityNamevendor.cityapplication_global.company_city
For payables, Vendor Maintenance, CityFor receivables, Application Global Maintenance, City
Invoice/InvoiceHeader/SupplierParty/Location/Address/CountrySubDivisionCodevendor.stateapplication_global.company_state
For payables, Vendor Maintenance, StateFor receivables, Application Global Maintenance, StateThe system translates the VISUAL code to the ISO country code based on your settings in Code Mapping Maintenance
@listID Country Sub-divisions
Invoice/InvoiceHeader/SupplierParty/Location/Address/CountryCodevendor.countryapplication_global.company_country
For payables, Vendor Maintenance, CountryFor receivables, Application Global Maintenance, CountryThe system translates the VISUAL code to the ISO country code based on your settings in Code Mapping Maintenance
@listID Countries
Invoice/InvoiceHeader/SupplierParty/Location/Address/PostalCodevendor.zipcodeapplication_global.company_zipcode
For payables, Vendor Maintenance, ZipFor receivables, Application Global Maintenance, Zip
Invoice/InvoiceHeader/SupplierParty/Location/Address/PostalCodeCode@listID
Postal/Zip Codes
Invoice/InvoiceHeader/SupplierParty/Contact/Namevendor.contact_first_name+vendor.contact_initial+vendor.contact_last_name
For payables, Vendor Maintenance, First Name, Initial and Last NameFor receivables, n/a
Invoice/InvoiceHeader/SupplierParty/Contact/JobTitlevendor.position For payables, Vendor Maintenance, Position
For receivables, n/a
Invoice/InvoiceHeader/SupplierParty/Contact/Communication/UseCodevendor.contact_phonevendor.contact_mobilevendor.contact_faxvendor.contact_email
For payables:For Vendor Maintenance, Contact tab, Phone, UseCode="phone"For Vendor Maintenance, Contact tab, Mobile Phone, UseCode="phone"For Vendor Maintenance, Contact tab, FAX, UseCode="Fax"For Vendor Maintenance, Contact tab, E-mail Address, UseCode="email"For receivables, n/a
Invoice/InvoiceHeader/SupplierParty/Contact/Communication/DialNumbervendor.contact_phonevendor.contact_mobilevendor.contact_fax
For payablesVendor Maintenance, Contact tab, PhoneVendor Maintenance, Contact tab, Mobile PhoneVendor Maintenance, Contact tab, FAXFor receivables, n/a
Invoice/InvoiceHeader/SupplierParty/Contact/Communication/URIvendor.contact_email For payables, Vendor Maintenance, Contact tab, E-mail address
For receivables, n/a
Invoice/InvoiceHeader/SupplierParty/SalesContact/Namesalesrep.name For payables, n/a
For receivables, Customer Maintenance, Sales Rep, Name for the sales rep ID in the invoice.
Invoice/InvoiceHeader/CustomerParty/PartyIDs/IDreceivable.customer_id For payables, n/a
For receivables, then Receivables Invoice Entry, Customer ID@schemeName
System
Invoice/InvoiceHeader/CustomerParty/PartyIDs/TaxIDapplication_global.tax_id_numbercustomer.tax_id_number
For payables, Application Global Maintenance, Tax ID NumberFor receivables, Customer Maintenance, Tax ID Number
Invoice/InvoiceHeader/CustomerParty/Nameapplication_global.company_namecustomer.name
For payables, then Application Global Maintenance, NameFor receivables, then Customer Maintenance, Name
August 13, 2009 14
Invoice@languageID
settings.language_id SOA Maintenance, Language ID
Invoice/InvoiceHeader/CustomerParty/Location/Nameapplication_global.company_namecustomer.name
For payables, Application Global Maintenance, NameFor receivables, Customer Maintenance, Name
@languageIDsettings.language_id SOA Maintenance, Language ID
Invoice/InvoiceHeader/CustomerParty/Location/Address/AddressLine@sequence
1: application_global.company_addr_12: application_global.company_addr_23: application_global.company_addr_3
1: customer.addr_12: customer.addr_23: customer.addr_3
For payables, Application Global Maintenance, Address fieldsFor receivables, Customer Maintenance, Address fields
Invoice/InvoiceHeader/CustomerParty/Location/Address/CityNameif payables then application_global.company_city else customer.city
For payables, Application Global Maintenance, CityFor receivables, Customer Maintenance, City
August 13, 2009 15
InvoiceInvoice/InvoiceHeader/CustomerParty/Location/Address/CountrySubDivisionCode
application_global.company_statecustomer.state
For payables, Application Global Maintenance StateFor receivables, Customer Maintenance, StateThe system translates the VISUAL code to the ISO code based on your settings in Code Mapping Maintenance.
@listID Country Sub-divisions
Invoice/InvoiceHeader/CustomerParty/Location/Address/CountryCodeapplication_global.company_countrycustomer.country
For payables, then Application Global Maintenance, CountryFor receivables, then Customer Maintenance, Country.The system translates the VISUAL code to the ISO code based on your settings in Code Mapping Maintenance.
@listID Countries
Invoice/InvoiceHeader/CustomerParty/Location/Address/PostalCodeapplication_global.company_zipcodecustomer.zipcode
For payables, then Application Global Maintenance, ZipFor receivables, then Customer Maintenance, Zip
@listID Postal/Zip Codes
Invoice/InvoiceHeader/CustomerParty/Contact/Namecustomer.first_name+customer.initial+customer.last_name
For payables, n/a. For receivables, then Customer Maintenance, Contact tab, Contact
Invoice/InvoiceHeader/CustomerParty/Contact/JobTitlecustomer.position For payables, then n/a. For
For receivables, then Customer Maintenance, Contact tab, Position
Invoice/InvoiceHeader/CustomerParty/Contact/Communication/UseCodecustomer.contact_phonecustomer.contact_mobilecustomer.contact_faxcustomer.contact_email
For payables, n/aFor receivables:For Customer Maintenance, Contact tab, Phone, UseCode="phone"For Customer Maintenance, Contact tab, Mobile Phone,UseCode="phone"For Customer Maintenance, Contact tab, FAX, UseCode="Fax"For Customer Maintenance, Contact tab, E-mail Address, UseCode="email"
Invoice/InvoiceHeader/CustomerParty/Contact/Communication/DialNumbercustomer.contact_phonecustomer.contact_mobilecustomer.contact_fax
For payables, n/aFor Receivables, Customer Maintenance, Contact tab, PhoneCustomer Maintenance, Contact tab, Mobile PhoneCustomer Maintenance, Contact tab, FAX
Invoice/InvoiceHeader/CustomerParty/Contact/Communication/URIcustomer.contact_email For Payables, n/a
For receivables: Customer Maintenance, Contact tab, E-Mail Address
Invoice/InvoiceHeader/RemitToParty/PartyIDs/IDvendor.id For payables, Payable Invoice Entry, Vendor ID
For receivables, n/a@accountingEntity
System@location
SOA Maintenance, SOA Location
Invoice/InvoiceHeader/RemitToParty/PartyIDs/TaxIDvendor.tax_id_numberapplication_global.tax_id_number
For payables, Vendor Maintenance, Tax ID NumberFor receivables, Application Global Maintenance, Tax ID Number
Invoice/InvoiceHeader/RemitToParty/Namevendor.nameapplication_global.company_name
For payables, Vendor Maintenance, NameFor receivables, Application Global Maintenance, Company Name
@languageIDsettings.language_id SOA Maintenance, Language ID
Invoice/InvoiceHeader/RemitToParty/Location/Namevendor.nameapplication_global.company_name
For payables, Vendor Maintenance, NameFor receivables, Application Global Maintenance, Company Name
@languageIDsettings.language_id SOA Maintenance, Language ID
August 13, 2009 16
InvoiceInvoice/InvoiceHeader/RemitToParty/Location/Address/AddressLine
vendor.remit_to_addr_1vendor.remit_to_addr_2vendor.remit_to_addr_3
application_global.company_addr_1application_global.company_addr_2application_global.company_addr_3
For payables, Vendor Maintenance, Remit to Address 1, Address 2, Address 3For receivables, Application Global Mainteance, Company Address 1, Company Address 2, Company Address 3
@sequence1: vendor.remit_to_addr_12: vendor.remit_to_addr_23: vendor.remit_to_addr_3
1: application_global.company_addr_12: application_global.company_addr_23: application_global.company_addr_3
For payables, Vendor Maintenance, Remit to Address 1, Address 2, Address 3For receivables, Application Global Mainteance, Company Address 1, Company Address 2, Company Address 3
Invoice/InvoiceHeader/RemitToParty/Location/Address/CityNamevendor.remit_to_cityapplication_global.company_city
For payables, Vendor Maintenance, Remit to CityFor receivables, Application Global Maintenance, City
Invoice/InvoiceHeader/RemitToParty/Location/Address/CountrySubDivisionCodevendor.remit_to_stateapplication_global.company_state
For payables, Vendor Maintenance, Remit To StateFor receivables, Application Global Maintenance, StateThe system translates the VISUAL code to the ISO code based on your settings in Code Mapping Maintenance.
@listID Country Sub-divisions
Invoice/InvoiceHeader/RemitToParty/Location/Address/CountryCodevendor.remit_to_countryapplication_global.company_country
For payables, Vendor Maintenance, Remit To CountryFor receivables, Application Global Maintenance, Country. The system translates the VISUAL code to the ISO code based on your settings in Code Mapping Maintenance.
@listID Countries
Invoice/InvoiceHeader/RemitToParty/Location/Address/PostalCodevendor.remit_to_zipcodeapplication_global.company_zipcode
For payables, Vendor Maintenance, Remit to ZipFor receivables, Application Global Maintenance, Zip
@listID Postal/Zip Codes
Invoice/InvoiceHeader/RemitToParty/Contact/Namevendor.contact_first_name+vendor.contact_initial+vendor.contact_last_name
For payables, Vendor Maintenance, First Name, Initial and Last NameFor receivables, n/a
Invoice/InvoiceHeader/RemitToParty/Contact/JobTitlevendor.position For payables, Vendor Maintenance, Position
For receivables, n/a@languageID
settings.language_id SOA Maintenance, Language ID
Invoice/InvoiceHeader/RemitToParty/Contact/Communication/UseCodevendor.contact_phonevendor.contact_mobilevendor.contact_faxvendor.contact_email
For payables:For Vendor Maintenance, Contact tab, Phone, UseCode="phone"For Vendor Maintenance, Contact tab, Mobile Phone, UseCode="phone"For Vendor Maintenance, Contact tab, FAX, UseCode="Fax"For Vendor Maintenance, Contact tab, E-mail Address, UseCode="email"For receivables, n/a
@listID Communication Use Codes
Invoice/InvoiceHeader/RemitToParty/Contact/Communication/DialNumber
August 13, 2009 17
Invoicevendor.contact_phonevendor.contact_mobilevendor.contact_fax
For payablesVendor Maintenance, Contact tab, PhoneVendor Maintenance, Contact tab, Mobile PhoneVendor Maintenance, Contact tab, FAXFor receivables, n/a
Invoice/InvoiceHeader/RemitToParty/Contact/Communication/URIvendor.contact_email For payables, Vendor Maintenance, Contact tab, E-mail address
For receivables, n/a
Invoice/InvoiceHeader/PaymentTerm/Term/DueDateTimecalculation:receivable.invoice_date+receivable.terms_net_dayspayable.invoice_date+payable.terms_net_days
For receivables and payables, the system adds the net days value from the terms box to the invoice date.
Invoice/InvoiceHeader/Status/Codepayable.statusreceivable.status
For payables, if Payables Invoice Entry, Status Field equals Void, then Void. Otherwise, status equals OpenFor Receivables, if Receivables Invoice Entry, Status field equals Void, then Void Otherwise, status equals Open
@listID For payables, Invoice Status (Supplier)
For receivables, Invoice Status (Customer)
Invoice/InvoiceHeader/BaseCurrencyAmount@type
ExtendedAmount, TotalAmount
Invoice/InvoiceHeader/BaseCurrencyAmount/Amountfor type=ExtendedAmountcalculation:payable.total_amount+payable.discount_takenreceivable.total_amount+receivable.discount_givenfor type=TotalAmountpayable.total_amountreceivable.total_amount
for type=ExtendedAmountcalculation:For payables, Payable Invoice Entry, Invoice Total plus payable.discount_taken. Discount Taken is not displayed in Invoice Entry window. Available in Invioce ID browse table.For receivables, Receivable Invoice Entry, Invoice Total plus receivable.discount_given. Discount Given is not displayed in Invoice Entry window. Available in Invoice ID browse table.If invoice is void, then amount is 0for type=TotalAmountFor payables, Payable Invoice Entry, Invoice TotalFor receivables, Receivable Invoice Entry, Invoice TotalIf invoice is void, then amount is 0
August 13, 2009 18
Invoice@currencyID
currency.currency_id Exchange Rate Maintenance, Currency Maintenance, Currency ID marked as system currency
Invoice/InvoiceLine/LineNumberpayable.line_noreceivable.line_no
For payables, Payables Invoice Entry, Line NumberFor receivables, Receivables Invoice Entry, Line Number
Invoice/InvoiceLine/Item/ItemID/IDpurchase_order_line.part_idpurchase_order_line.service_idcustomer_ order_line.part_id
For payables, Purchase Order Entry, Lines table, Part ID or, if null, Service IDFor receivables, Customer Order Entry, Lines, Part ID
Invoice/InvoiceLine/Item/ServiceIndicatorpurchase_order_line.service_idcustomer_order_line.service_charge_id
For payables, if Purchase Order Entry, Lines, Service ID is populated, then servicechargeindicator=YFor receivables, if Customer Order Entry, Lines, Service Charge is populated, then servicechargeindicator=Y
Invoice/InvoiceLine/Item/Notenotation.note Part Maintenance, Part ID notations
Invoice/InvoiceLine/Quantityreceivable_line.line_qty For payables, N/A
For receivables, Receivable Invoice Entry, Lines, Qty@unitCode
receivable_line.line_uom For payables, N/AFor receivables, Receivable Invoice Entry, Lines, U/M. If null, then EA.The system translates the VISUAL UOM code to the ISO code.
Invoice/InvoiceLine/PurchaseOrderReference/DocumentID/IDpayable_line.purc_order_id For payables, Payables Invoice Entry, Lines, Purchase Order Ln#
For receivables, n/a
Invoice/InvoiceLine/PurchaseOrderReference/LineNumberpayable_line.purc_order_line_no For payables, Payables Invoice Entry, Lines, Purchase Order Ln#
For receivables, n/a
Invoice/InvoiceLine/ExtendedAmountpayable_line.amountreceivable_line.amount
For payables, Payables Invoice Entry, Lines, AmountFor receivables, Receivables Invoice Entry, Lines, Amount
@currencyIDpayable.currency_idreceivable.currency_id
For payables, Payables Invoice Entry, Currency IDFor receivables, Receivables Invoice Entry, Currency IDThe system translates the currency ID to an ISO code based on your settings in Code Mapping.
Invoice/InvoiceLine/TotalAmountpayable_line.amountreceivable_line.amount
For payables, Payables Invoice Entry, Lines, AmountFor receivables, Receivables Invoice Entry, Lines, AmountIf invoice is void, then amount is 0
@currencyIDpayable.currency_idreceivable.currency_id
For payables, Payables Invoice Entry, Currency IDFor receivables, Receivables Invoice Entry, Currency IDThe system translates the currency ID to an ISO code based on your settings in Code Mapping.
Invoice/InvoiceLine/RequestedDeliveryDatepurchase_order_line.promise_datepurchase_order.promise_datepurchase_order_line.desired_recv_datepurchase_order.desired_recv_date
customer_order_line.promise_datecustomer_order.promise_datecustomer_order_line.desired_recv_datecustomer.order_desired_recv_date
For payables, Purchase Order Entry, Lines, Promise Date; If null, then Purchase Order Entry, Promise Date; if null, then Purchase Order Entry, Lines, Desired Recv Date; if null, then current date. For recevables, Customer Order Entry, Lines, Promise Date; If null, then Customer Order Entry, Promise Date; if null, then Customer Order Entry, Lines, Desired Recv Date; if null, then current date.
Invoice/InvoiceLine/CustomerParty/PartyIDs/IDreceivable.customer_id For payables, n/a
For receivables, then Receivables Invoice Entry, Customer ID
August 13, 2009 19
Invoice@schemeName
System@accountingEntity
application_global.entity_id Application Global Maintenance, Default Mfg Entity ID@location
SOA Maintenance, SOA Location
Invoice/InvoiceLine/CustomerParty/PartyIDs/TaxIDapplication_global.tax_id_numbercustomer.tax_id_number
For payables, Application Global Maintenance, Tax ID NumberFor receivables, Customer Maintenance, Tax ID Number
Invoice/InvoiceLine/CustomerParty/Nameapplication_global.company_namecustomer.name
For payables, Application Global Maintenance, NameFor receivables, Customer Maintenance, Name
@languageIDsettings.language_id SOA Maintenance, Language ID
Invoice/InvoiceLine/CustomerParty/Location/Nameapplication_global.company_namecustomer.name
For payables, Application Global Maintenance, NameFor receivables, Customer Maintenance, Name
@languageIDsettings.language_id SOA Maintenance, Language ID
Invoice/InvoiceLine/CustomerParty/Location/Address/AddressLine1: application_global.company_addr_12: application_global.company_addr_23: application_global.company_addr_3
1: customer.addr_12: customer.addr_23: customer.addr_3
For payables, Application Global Maintenance, Address fieldsFor receivables, Customer Maintenance, Address fields
@sequence1: application_global.company_addr_12: application_global.company_addr_23: application_global.company_addr_3
1: customer.addr_12: customer.addr_23: customer.addr_3
For payables, Application Global Maintenance, Address fieldsFor receivables, Customer Maintenance, Address fields
Invoice/InvoiceLine/CustomerParty/Location/Address/CityNameif payables then application_global.company_city else customer.city
For payables, Application Global Maintenance, CityFor receivables, Customer Maintenance, CityThe system translates the VISUAL code to the ISO code based on your settings in Code Mapping Maintenance.
Invoice/InvoiceLine/CustomerParty/Location/Address/CountrySubDivisionCodeapplication_global.company_statecustomer.state
For payables, Application Global Maintenance, StateFor receivables, Customer Maintenance, State
@listID Country Sub-divisions
Invoice/InvoiceLine/CustomerParty/Location/Address/CountryCodeapplication_global.company_countrycustomer.country
For payables, Application Global Maintenance, CountryFor receivables, Customer Maintenance, Country. The system translates the VISUAL code to the ISO code based on your settings in Code Mapping Maintenance.
@listID Countries
Invoice/InvoiceLine/CustomerParty/Location/Address/PostalCodeapplication_global.company_zipcodecustomer.zipcode
For payables, Application Global Maintenance, ZipFor receivables, Customer Maintenance, Zip
@listID
August 13, 2009 20
Invoice Postal/Zip Codes
Invoice/InvoiceLine/CustomerParty/Contact/Namecustomer.first_name+customer.initial+customer.last_name
For payables, n/aFor receivables, Customer Maintenance, Contact tab, Contact
Invoice/InvoiceLine/CustomerParty/Contact/JobTitlecustomer.position For payables, n/a
For receivables, then Customer Maintenance, Contact tab, Position
Invoice/InvoiceLine/CustomerParty/Contact/Communication/UseCodecustomer.contact_phonecustomer.contact_mobilecustomer.contact_faxcustomer.contact_email
For payables, n/aFor receivables:For Customer Maintenance, Contact tab, Phone, UseCode="phone"For Customer Maintenance, Contact tab, Mobile Phone,UseCode="phone"For Customer Maintenance, Contact tab, FAX, UseCode="Fax"For Customer Maintenance, Contact tab, E-mail Address, UseCode="email"
Invoice/InvoiceLine/CustomerParty/Contact/Communication/DialNumbercustomer.contact_phonecustomer.contact_mobilecustomer.contact_fax
For payables, n/aFor Receivables, Customer Maintenance, Contact tab, PhoneCustomer Maintenance, Contact tab, Mobile PhoneCustomer Maintenance, Contact tab, FAX
Invoice/InvoiceLine/CustomerParty/Contact/Communication/URIcustomer.contact_email For payables, n/a
For receivables: Customer Maintenance, Contact tab, E-Mail Address
Invoice/InvoiceLine/SalesOrderReference/DocumentID/IDreceivable_line.order_id For payables n/a
For receivables, Receivable Invoice Entry, Lines, Order ID
Invoice/InvoiceLine/SalesOrderReference/LineNumberreceivable_line.cust_order_line_no
For payables n/aFor receivables, Receivable Invoice Entry, Lines, Order ID Ln #
Invoice/InvoiceLine/ExtendedCost/Amountcalculation: inventory_trans.act_material_cost+inventory_trans.act_labor_cost+inventory_trans.act_burden_cost+inventory_trans.act_service_cost
For payables, n/aFor receivables, Inventory Transaction Entry, Material+Inventory Transaction Entry, Labor+Inventroy Transaction Entry, Burden+Inventory Transaction Entry, ServiceIf invoice is void, then amount is 0
August 13, 2009 21
Invoice@currencyID
receivable.currency_id For payables, n/aFor receivables, Receivables Invoice Entry, Currency IDThe system translates the currency ID to an ISO code based on your settings in Code Mapping.
August 13, 2009 22
ItemMasterItemMaster/ItemMasterHeader/ItemID/ID
part.idpart.mfg_part_id
Part Maintenance, IDIf the part has a manufacturer, Part Maintenance, Defaults tab, Manufacturer Part ID is also used
@schemeName System
If the part has a manufacturer, then Manufacturer@schemeAgencyID
part.mfg_name The system combines infor.visual with the value in SOA Maintenance, Visual Instance IDIf the part has a manufacturer, then Part Maintenance, Defaults tab, Manufacturer
@schemeAgencyNamepart.mfg_name Part Maintenance, Defaults tab, Manufacturer
ItemMaster/ItemMasterHeader/ServiceIndicator False
ItemMaster/ItemMasterHeader/Descriptionpart.description Part Maintenance, Description
ItemMaster/ItemMasterHeader/Notenotation.note Part Maintenance, Part ID Notations
@languageID SOA Maintenance, Language ID
@author The system uses the User ID associated with the notation.
@entryDateTime The system uses the time-date stamp from the notation
@status Open
ItemMaster/ItemMasterHeader/Classification/Codes/Codepart.ABCCodepart.commodity_codepart.product_codepart.hts_codepart.material_codepart.nmfc_codepart.tariff_codepart.vat_codepart.purchasedpart.consumablepart.primary_whs_idpart.primary_loc_idpart.drawing_id
Part Maintenance, Costing tab, ABC CodePart Maintenance, Commodity CodePart Maintenance, Product CodePart Maintenance, Order Mgt tab, HTS CodePart Maintenance, Order Mgt tab, Material CodePart Maintenance, Default NMFC Code IDPart Maintenance, Intrastat tab, Tariff CodePart Maintenance, Intrastat tab, VAT CodePart Maintenance, Purchased Check BoxPart Maintenance, Consumable check boxPart Maintenance, Defaults tab, Primary Warehouse IDPart Maintenance, Defaults tab, Primary Location IDPart Maintenance, Config Mgt tab, Drawing #
@sequence1: part.ABCCode2: part.commodity_code3: part.product_code4: part.hts_code5: part.material_code6: part.nmfc_code7: part.tariff_code8: part.vat_code9: part.purchased10: part.consumable11: part.primary_whs_id12: part.primary_loc_id13: part.drawing_id
1: Part Maintenance, Costing tab, ABC Code2: Part Maintenance, Commodity Code3: Part Maintenance, Product Code4: Part Maintenance, Order Mgt tab, HTS Code5: Part Maintenance, Order Mgt tab, Material Code6: Part Maintenance, Default NMFC Code ID7: Part Maintenance, Intrastat tab, Tariff Code8: Part Maintenance, Intrastat tab, VAT Code9: Part Maintenance, Purchased Check Box10: Part Maintenance, Consumable check box11: Part Maintenance, Defaults tab, Primary Warehouse ID12: Part Maintenance, Defaults tab, Primary Location ID13: Part Maintenance, Config Mgt tab, Drawing #
@listID 1: ABCCode
2: Commodity Codes3: Product Lines4:HTS_CODE5: MATERIAL_CODE6: NMFC_CODE7: TARIFF_CODE8: VAT_CODE9: Item Type
August 13, 2009 23
ItemMaster10: Item Type11: VisualWH12: VisualLOC13: VisualDrawingID14: Part Pricing Group
ItemMaster/ItemMasterHeader/Specification/Property@sequence
Sequenced 1 through 4 to get specifications from four places within the VISUAL database
ItemMaster/ItemMasterHeader/Specification/Property/Notepart.part_binary; part.part_co_binary; part.part_po_binary; part.part_mfg_binary
@type Type 1: Part
Type 2: Part_COType 3: Part_POType 4: PART_MFG
@languageID SOA Maintenance, Language ID
ItemMaster/ItemMasterHeader/LeadTimeDurationpart.planning_leadtime Part Maintenance, Lead Time (in days)
ItemMaster/ItemMasterHeader/BackFlushedIndicatorpart.auto_backflush Part Maintenance, Auto Issue check box
ItemMaster/ItemMasterHeader/TrackingIndicatorpart.stocked Part Maintenance, Stocked check box
ItemMaster/ItemMasterHeader/ItemStatus/Codepart.statuspart.inventory_locked
If Part Maintenance, Config Mnt, Obsolete check box is selected, then status is Obsolete.If Part Maintenance, Inv Tx Locked check box is selected, then status is Hold.In all other cases, status is open.
@listID Item Status
ItemMaster/ItemMasterHeader/BaseUOMCodepart.stock_um Part Maintenance, Stock UM
ItemMaster/ItemMasterHeader/StorageUOMCodepart.stock_um Part Maintenance, Stock UM
ItemMaster/ItemMasterHeader/ShippingUOMCodepart.weight_um Part Maintenance, Weight UM
ItemMaster/ItemMasterHeader/LastModificationDateTime The system inserts the date and time the BOD was generated.
ItemMaster/ItemMasterHeader/AlternateUOMCodepart_units_conv.to_um Part Maintenance, Unit of Measure Conversion, To Unit of Measure
ItemMaster/ItemMasterHeader/UOMCodeConversion/FromUOMPackage/UOMCodepart_units_conv.from_um Part Maintenance, Unit of Measure Conversion, From Unit of Measure
ItemMaster/ItemMasterHeader/UOMCodeConversion/RateNumericpart_units_conv.conversion_factorPart Maintenance, Unit of Measure Conversion, Conversion Factor
ItemMaster/ItemMasterHeader/UOMCodeConversion/ToUOMPackage/UOMCodepart_units_conv.to_um Part Maintenance, Unit of Measure Conversion, To Unit of Measure
ItemMaster/ItemMasterHeader/ItemValue/UnitValue/Amountpart.unit_cost Part Maintenance, Costing Tab, Unit Price
ItemMaster/ItemMasterHeader/ItemValue/UnitValue/PerQuantity 1
ItemMaster/ItemMasterHeader/BOMReference/DocumentID/IDrequirement.part_id Manufacturing Window, Material Card, Part ID for the Engineering Master associated with the part in Part Maintenance, ID.
ItemMaster/ItemMasterHeader/DrawingAttachment/FileNamepart.drawing_rev_no Part Maintenance, Config Mnt tab, Drawing Revision
ItemMaster/ItemMasterHeader/SellableIndicator True
ItemMaster/ItemMasterHeader/ProcurementParameters/ProcurementMethodCode
August 13, 2009 24
ItemMaster Manufacturer
ItemMaster/ItemMasterHeader/ProcurementParameters/PlanningMethodCodepart.order_policy Part Maintenance, Planning tab, Order Policy
@listID Planning Methods
ItemMaster/ItemMasterHeader/ProcurementParameters/LinePointQuantitypart.order_point Part Maintenance, Planning tab, Order Qty
August 13, 2009 25
ItemMaster@unitCode
part.stock_um Part Maintenance, Stock UM
ItemMaster/ItemMasterHeader/ProcurementParameters/OrderPointQuantitypart.order_point Part Maintenance, Planning tab, Order Qty
@unitCodepart.stock_um Part Maintenance, Stock UM
ItemMaster/ItemMasterHeader/ProcurementParameters/MinQuantitypart.minimum_order_qty Part Maintenance, Planning tab, Min Order Qty
ItemMaster/ItemMasterHeader/ProcurementParameters/MaxQuantitypart.maximum_order_qty Part Maintenance, Planning tab, Max Order Qty
ItemMaster/ItemMasterHeader/ProcurementParameters/SafetyStockQuantitypart.safety_stock_qty Part Maintenance, Planning tab, Safety Stock Qty
ItemMaster/ItemMasterHeader/ProcurementParameters/EOQQuantitypart.fixed_order_qty Part Maintenance, Planning tab, Order Point Qty
ItemMaster/ItemMasterHeader/ProcurementParameters/LeadTimeDurationpart.planning_leadtime Part Maintenance, Planning tab,Lead Time (in days)
ItemMaster/ItemMasterHeader/ProcurementParameters/OrderCycleDurationpart.days_of_supply Part Maintenance, Planning tab, Days of Supply. The system inserts a P before the field value and a D after the field value.
ItemMaster/ItemMasterHeader/ProcurementParameters/Horizons/HorizonDurationpart.days_of_supply Part Maintenance, Planning tab, Days of Supply. The system inserts a P before the field value and a D after the field value.
ItemMaster/ItemMasterHeader/Substitutions/ItemID/IDpart_substitute.substitute_part_id Part Maintenance, Order Management, Substitute Parts
ItemMaster/ItemMasterHeader/AddOns/ItemID/IDpart_cross_selling.cross_sell_part_id
Part Maintenance, Order Management, Cross Sellling Parts
ItemMaster/ItemMasterHeader/AddOns/ServiceIndicator False
August 13, 2009 26
LocationLocation@type
Site, Warehouse, Vendor, Customer, Office
Location/IDFor type=site or officeapplication_global.manufacturing_entity_IDshipto_address.shipto_id+shipto_address.addr_nosettings.location_id
For type=Warehousewarehouse.warehouse_ID+warehouse_address.addr_no
For type=Customercustomer.customer_ID+customer_address.addr_nov_account.acct_id+0
For type=Vendorvendor.vendor_ID+vendor_address.addr_no
For type=Site or officesite ~ Application Global Maintenance, Default Mfg Entity IDsite ~ Purchase Order Entry, Ship to Address, Ship To ID ~ Purchase Order Entry, Ship to Address, #site ~ SOA Maintenance, Location ID
For type=Warehouse:warehouse ~ Warehouse Maintenance, Warehouse ID ~ 0warehouse ~ Warehouse Maintenance, Warehouse ID ~ Warehouse Maintenance, Alternate Warehouse Address, #
For type=Customercustomer ~ Customer Maintenance, Customer ID ~ 0customer ~ Customer Maintenance, Customer ID ~ Customer Maintenance, Shipping Addresses, #
For CRM: customer ~ Account Maintenance, Account ID ~ 0
For type=Vendorvendor ~ Vendor Maintenance, Vendor ID ~ 0vendor ~ Vendor Maintenance, Vendor ID ~ Vendor Maintenance, Shipping Addresses, #
@schemeName System
@schemeAgencyID infor.visual
Location/NameFor type=site or officeapplication_global.company_nameorshipto_address.name
For type=Warehousewarehouse_address.name
For type=Customercustomer.nameorcustomer_address.nameorv_account.name
For type=Vendorvendor.nameorvendor_address.name
For type=Site or officeApplication Global Maintenance, Company NameorPurchase Order Entry, Ship To Address, Name
For type=Warehouse:Warehouse Maintenance, Warehouse Address, Name
For type=CustomerCustomer Maintenance, NameorCustomer Maintenance, Shipping Addresses, NameorFor CRM: Account Maintenance, Name
For type=VendorVendor Maintenance, NameorVendor Maintenance, Shipping Addresses, Name
Location/Address/AddressLineFor type=site or officeapplication_global.company_addr_1application_global.company_addr_2application_global.company_addr_3orshipto_address.addr_1shipto_address.addr_2shipto_address.addr_3
For type=Warehousewarehouse_address.addr_1warehouse_address.addr_2
For type=Site or OfficeApplication Global Maintenance, Street Address fieldsorPurchase Order Entry, Ship to Address, Street Address fields
For type=Warehouse:Warehouse Maintenance, Warehouse Address, Street Address fields
For type=CustomerCustomer Maintenance, Sold To Street Address fieldsorCustomer Maintenance, Shipping Addresses, Address fieldsorFor CRM: Account Maintenance, Street Address fields
August 13, 2009 27
Locationwarehouse_address.addr_3
For type=Customercustomer.addr_1customer.addr_2customer.addr_3orcustomer_address.addr_1customer_address.addr_2customer_address.addr_3orv_account.addr_1v_account.addr_2v_account.addr_3
For type=Vendorvendor.addr_1vendor.addr_2vendor.addr_3orvendor_address.addr_1vendor_address.addr_2vendor_address.addr_3
For type=VendorVendor Maintenance, Purchase From Address fieldsorVendor Maintenance, Shipping Addresses, Address fields
@sequenceFor type=site or office1: application_global.company_addr_12: application_global.company_addr_23: application_global.company_addr_3
1: shipto_address.addr_12: shipto_address.addr_23: shipto_address.addr_3
For type=Warehouse1: warehouse_address.addr_12: warehouse_address.addr_23: warehouse_address.addr_3
For type=Customer1: customer.addr_12: customer.addr_23: customer.addr_3or1: customer_address.addr_12: customer_address.addr_23: customer_address.addr_3or1: v_account.addr_12: v_account.addr_23: v_account.addr_3
For type=Vendor1: vendor.addr_12: vendor.addr_23: vendor.addr_3or1: vendor_address.addr_12: vendor_address.addr_23: vendor_address.addr_3
For type=Site or OfficeApplication Global Maintenance, Street Address fieldsorPurchase Order Entry, Ship to Address, Street Address fields
For type=Warehouse:Warehouse Maintenance, Warehouse Address, Street Address fields
For type=CustomerCustomer Maintenance, Sold To Street Address fieldsorCustomer Maintenance, Shipping Addresses, Address fieldsorFor CRM: Account Maintenance, Street Address fields
For type=VendorVendor Maintenance, Purchase From Address fieldsorVendor Maintenance, Shipping Addresses, Address fields
Location/Address/CityNameFor type=site or office For type=Site or Office
August 13, 2009 28
Locationapplication_global.company_cityorshipto_address.city
For type=Warehousewarehouse_address.city
For type=Customercustomer.cityorcustomer_address.cityorv_account.city
For type=Vendorvendor.cityorvendor_address.city
Application Global Maintenance, CityorPurchase Order Entry, Ship To Address, City
For type=Warehouse:Warehouse Maintenance, Warehouse Address, City
For type=CustomerCustomer Maintenance, CityorCustomer Maintenance, Shipping Addresses, CityorFor CRM: Account Maintenance, City
For type=VendorVendor Maintenance, CityorVendor Maintenance, Shipping Addresses, City
Location/Address/CountrySubDivisionCodeFor type=site or officeapplication_global.company_stateorshipto_address.state
For type=Warehousewarehouse_address.state
For type=Customercustomer.stateorcustomer_address.stateorv_account.state
For type=Vendorvendor.stateorvendor_address.state
For type=Site or officeApplication Global Maintenance, StateorPurchase Order Entry, Ship To Address, State
For type=Warehouse:Warehouse Maintenance, Warehouse Address, State
For type=CustomerCustomer Maintenance, StateorCustomer Maintenance, Shipping Addresses, StateorFor CRM: Account Maintenance, State
For type=VendorVendor Maintenance, StateorVendor Maintenance, Shipping Addresses, State
@listID Country Sub-divisions
Location/Address/CountryCodeFor type=site or officeapplication_global.company_countryorshipto_address.country
For type=Warehousewarehouse_address.country
For type=Customercustomer.countryorcustomer_address.countryorv_account.country
For type=Vendorvendor.countryorvendor_address.country
For type=Site or officeApplication Global Maintenance, CountryorPurchase Order Entry, Ship To Address, Country
For type=Warehouse:Warehouse Maintenance, Warehouse Address, Country
For type=CustomerCustomer Maintenance, CountryorCustomer Maintenance, Shipping Addresses, CountryorFor CRM: Account Maintenance, Country
For type=VendorVendor Maintenance, CountryorVendor Maintenance, Shipping Addresses, Country
@listID Countries
Location/Address/PostalCode
August 13, 2009 29
LocationFor type=site or officeapplication_global.company_zipcodeorshipto_address.zipcode
For type=Warehousewarehouse_address.zipcode
For type=Customercustomer.zipcodeorcustomer_address.zipcodeorv_account.zipcode
For type=Vendorvendor.zipcodeorvendor_address.zipcode
For type=Site or officeApplication Global Maintenance, ZiporPurchase Order Entry, Ship To Address, Zip
For type=Warehouse:Warehouse Maintenance, Warehouse Address, Zip
For type=CustomerCustomer Maintenance, ZiporCustomer Maintenance, Shipping Addresses, ZiporFor CRM: Account Maintenance, Zip
For type=VendorVendor Maintenance, ZiporVendor Maintenance, Shipping Addresses, Zip
@listID Postal/Zip Codes
August 13, 2009 30
OpportunityOpportunity/OpportunityHeader/DocumentID/ID
v_opportunity.id Opportunity, Opportunity ID@accountingEntity
application_global.entity_id Application Global Maintenance, Default Mfg Entity ID@location
settings.location_id SOA Maintenance, SOA Location@lid
settings.instance_id The system combines lid://infor.visual with the value in SOA Maintenance, Visual Instance ID
Opportunity/OpportunityHeader/DocumentDateTimev_opportunity.open_date Opportunity, General tab, Open
Opportunity/OpportunityHeader/Descriptionv_opportunity.description Opportunity, Description
Opportunity/OpportunityHeader/Status/Codev_opportunity.status Opportunity, General tab, Status
Opportunity/OpportunityHeader/Status/EffectiveDateTime The system inserts the date and time that the BOD was generated.
Opportunity/OpportunityHeader/TotalAmountv_opportunity.opty_amount Opportunity, General tab, Amount
@currencyIDv_opportunity.currency_id Opportunity, Details tab, Currency
Opportunity/OpportunityHeader/CustomerParty/PartyIDs/IDv_account.cust_id Account, Account ID
Opportunity/OpportunityHeader/CustomerParty/Namecustomer.name Customer Maintenance, Name
Opportunity/OpportunityHeader/MarketingProgram/IDv_opportunity.lead_source Opportunity, General tab, Lead Source
Opportunity/OpportunityHeader/SalesStageCodev_opportunity.cur_stage_idv_sales_stage.soa_code
Sales Plan, Sales Stage, SOA Code for the sales stage in Opportunity, General tab, Current Stage.
Opportunity/OpportunityHeader/DecisionDateTimev_opportunity.est_close_date Opportunity, General tab, Est Close
Opportunity/OpportunityHeader/DocumentPurposev_opportunity.sales_lead Opportunity, General tab, Sales Lead/Opportunity option buttons
Opportunity/OpportunityHeader/ForecastIndicatorv_opportunity.forecast Opportunity, Details tab, Forecast check box. If selected, then indicator=true. If cleared, then indicator=false
Opportunity/OpportunityHeader/SalesPersonReference/IDs/IDSales_Rep~v_opportunity.salesrep_id
Sales_Rep~Opportunity, General tab, Sales Rep
Opportunity/OpportunityHeader/BaseCurrencyAmount@type
Extended Amount, Total Amount
Opportunity/OpportunityHeader/BaseCurrencyAmount/AmountFor type=Extended Amount, Total Amountv_opportunity.opty_amount
Oppurtunity, General tab, Amount. If the amount is not in the system currency, the system converts the amount.
@currencyIDcurrency.currency_id Currency Maintenance (VF), Currency ID marked as system.
Opportunity/OpportunityDetail/BaseCurrencyAmount@type
Extended Amount, Total Amount
Opportunity/OpportunityDetail/BaseCurrencyAmount/AmountFor type=Extended Amount, Total Amountv_opportunity.opty_amount
Oppurtunity, General tab, Amount. If the amount is not in the system currency, the system converts the amount.
@currencyIDcurrency.currency_id Currency Maintenance (VF), Currency ID marked as system.
August 13, 2009 31
PayableTransactionPayableTransaction/PayableTransactionHeader/DocumentID/ID
payable.voucher_id Payables Invoice Entry, Voucher ID@accountingEntity
payable.entity_id Payables Invoice Entry, Entity ID@location
payable.entity_id Site~Payables Invoice Entry, Entity ID@lid
settings.instance_id The system combines lid://infor.visual with the value in SOA Maintenance, Visual Instance ID
PayableTransaction/PayableTransactionHeader/AlternateDocumentID@agencyRole
Supplier
PayableTransaction/PayableTransactionHeader/AlternateDocumentID/IDpayable.invoice_id Payables Invoice Entry, Invoice ID
PayableTransaction/PayableTransactionHeader/DocumentDateTimepayable.create_date Is not displayed on Payables Invoice Entry window. Available in the Voucher ID browse table.
PayableTransaction/PayableTransactionHeader/Status/Codepayable.pay_statuspayable.paid_amountpayable.total_amount
If Payables Invoice Entry, General Tab, Status = Log, then status = UnapprovedIf Payables Invoice Entry, General Tab, Status = Pay and Paid to Date = 0, then status = OpenIf Payables Invoice Entry, General Tab, Status = Pay and Paid to Date is greater than zero but not equal to Invoice Total, then status = PartialPaidIf Payables Invoice Entry, General Tab, Status = Pay and Paid to Date = Invoice Total, then status = PaidIn all other cases when Payables Invoice Entry, General Tab, Status = Pay, status = VoucheredIf Payables Invoice Entry, General Tab, Status = Hold, then status = HoldIf Payables Invoice Entry, General Tab, Status = Void, then status = ClosedIf there is unapplied cash (PAY_STATUS = U is not displayed in Payables Invoice Entry), then status = UnappliedCash
PayableTransaction/PayableTransactionHeader/Status/EffectiveDateTimepayable.zero_datepayable.create_date
If status=Paid, then payable.zero_date. Is not displayed in Payables Invoice Entry. Available in Voucher ID browse.For all other statuses, payable.create_date. Available in Voucher ID broswe
PayableTransaction/PayableTransactionHeader/SupplierParty/PartyIDs/IDpayable.vendor_id Payables Invoice Entry, Vendor ID
PayableTransaction/PayableTransactionHeader/SupplierParty/PartyIDs/TaxIDvendor.tax_id_number Vendor Maintenance, Accounting Tab, Tax ID number
PayableTransaction/PayableTransactionHeader/SupplierParty/Location/Namevendor.name Vendor Maintenance, Name
PayableTransaction/PayableTransactionHeader/SupplierParty/Location/Address/AttentionOfNamevendor.name Vendor Maintenance, Name
PayableTransaction/PayableTransactionHeader/SupplierParty/Location/Address/AddressLine@sequence
1: vendor.addr_12: vendor.addr_23: vendor.addr_3
Vendor Maintenance, Address fields
PayableTransaction/PayableTransactionHeader/SupplierParty/Location/Address/CityNamevendor.city Vendor Maintenance, City
PayableTransaction/PayableTransactionHeader/SupplierParty/Location/Address/CountrySubDivisionCodevendor.state Vendor Maintenance, State
@listID Country Sub-divisions
PayableTransaction/PayableTransactionHeader/SupplierParty/Location/Address/CountryCodevendor.country Vendor Maintenance, Country
PayableTransaction/PayableTransactionHeader/SupplierParty/Location/Address/PostalCodevendor.zipcode Vendor Maintenance, Zip field
PayableTransaction/PayableTransactionHeader/SupplierParty/Contact/Namevendor.contact_name Vendor Maintenance, Contact tab, Contact fields
PayableTransaction/PayableTransactionHeader/SupplierParty/Contact/JobTitlevendor.contact_position Vendor Maintenance, Contact tab, Position
PayableTransaction/PayableTransactionHeader/SupplierParty/Contact/Communication/UseCode phone
faxmobileemail
August 13, 2009 32
PayableTransaction@listID
Communication Use Codes
PayableTransaction/PayableTransactionHeader/SupplierParty/Contact/Communication/DialNumbervendor.contact_phonevendor.contact_faxvendor.contact_mobile
Vendor Maintenance, Contact tab, PhoneVendor Maintenance, Contact tab, FaxVendor Maintenance, Contact tab, Mobile Phone
PayableTransaction/PayableTransactionHeader/SupplierParty/Contact/Communication/URIvendor.contact_email Vendor Maintenance, Contact tab, E-mail Address
PayableTransaction/PayableTransactionHeader/SupplierParty/SalesContact/Namepurchase_order.contact_honorificpurchase_order.contact_first_namepurchase_order.contact_initialpurchase_order.contact_last_name
Purchase Order Entry, Contact tab, Contact fields
PayableTransaction/PayableTransactionHeader/SupplierParty/SalesContact/JobTitlepurchase_order.contact_position Purchase Order Entry, Contact tab, Position
PayableTransaction/PayableTransactionHeader/SupplierParty/SalesContact/Communication/DialNumberpurchase_order.contact_phone Purchase Order Entry, Contact tab, Phone
PayableTransaction/PayableTransactionHeader/SupplierParty/ShippingContact/Namepurchase_order.contact_honorificpurchase_order.contact_first_namepurchase_order.contact_initialpurchase_order.contact_last_name
Purchase Order Entry, Contact tab, Contact fields
PayableTransaction/PayableTransactionHeader/SupplierParty/ShippingContact/JobTitlepurchase_order.contact_position Purchase Order Entry, Contact tab, Position
PayableTransaction/PayableTransactionHeader/SupplierParty/ShippingContact/Communication/DialNumberpurchase_order.contact_phone Purchase Order Entry, Contact tab, Phone
PayableTransaction/PayableTransactionHeader/SupplierParty/CustomerServiceContact/Namepurchase_order.contact_honorificpurchase_order.contact_first_namepurchase_order.contact_initialpurchase_order.contact_last_name
Purchase Order Entry, Contact tab, Contact fields
PayableTransaction/PayableTransactionHeader/SupplierParty/CustomerServiceContact/JobTitlepurchase_order.contact_position Purchase Order Entry, Contact tab, Position
PayableTransaction/PayableTransactionHeader/SupplierParty/CustomerServiceContact/Communication/DialNumberpurchase_order.contact_phone Purchase Order Entry, Contact tab, Phone
PayableTransaction/PayableTransactionHeader/RemitToParty/PartyIDs/IDpayable.vendor_id Payables Invoice Entry, Vendor ID
PayableTransaction/PayableTransactionHeader/RemitToParty/PartyIDs/TaxIDvendor.tax_id_number Vendor Maintenance, Accounting Tab, Tax ID number
PayableTransaction/PayableTransactionHeader/RemitToParty/Namevendor.name Vendor Maintenance, Name
@languageIDsettings.language_id SOA Maintenance, Language ID
PayableTransaction/PayableTransactionHeader/RemitToParty/Location/Address/AttentionOfNamevendor.remit_to_name Vendor Maintenance, Remit To Name
PayableTransaction/PayableTransactionHeader/RemitToParty/Location/Address/AddressLine@sequence
1: vendor.remit_to_addr_12: vendor.trmit_to_addr_23: vendor.remit_to_addr_3
Vendor Maintenance, Remit To Address fields
August 13, 2009 33
PayableTransactionPayableTransaction/PayableTransactionHeader/RemitToParty/Location/Address/CityName
vendor.remit_to_city Vendor Maintenance, Remit To City
PayableTransaction/PayableTransactionHeader/RemitToParty/Location/Address/CountrySubDivisionCodevendor.remit_to_state Vendor Maintenance, Remit To State
PayableTransaction/PayableTransactionHeader/RemitToParty/Location/Address/CountryCodevendor.remit_to_country Vendor Maintenance, Remit To Country
PayableTransaction/PayableTransactionHeader/RemitToParty/Location/Address/PostalCodevendor.remit_to_zipcode Vendor Maintenance, Remit To Zip
PayableTransaction/PayableTransactionHeader/RemitToParty/Contact/Namevendor.contact_name Vendor Maintenance, Contact tab, Contact fields
PayableTransaction/PayableTransactionHeader/RemitToParty/Contact/JobTitlevendor.contact_position Vendor Maintenance, Contact tab, Position
PayableTransaction/PayableTransactionHeader/RemitToParty/Contact/Communication/UseCode 1: Phone
2: Fax3: Mobile4: Email
@listID Communication Use Codes
PayableTransaction/PayableTransactionHeader/RemitToParty/Contact/Communication/DialNumbervendor.contact_phonevendor.contact_faxvendor.contact_mobile
Vendor Maintenance, Contact tab, PhoneVendor Maintenance, Contact tab, FaxVendor Maintenance, Contact tab, Mobile Phone
PayableTransaction/PayableTransactionHeader/RemitToParty/Contact/Communication/URIvendor.contact_email Vendor Maintenance, Contact tab, E-mail Address
PayableTransaction/PayableTransactionHeader/PayableStylepayable.type Payables Invoice Entry, Type. If type is Invoice, then payablestyle=invoice. If type is Memo or Unapplied Case, then payablestyle
=CreditMemo
PayableTransaction/PayableTransactionHeader/InvoiceReference/DocumentID@agencyRole
Supplier
PayableTransaction/PayableTransactionHeader/InvoiceReference/DocumentID/IDpayable.invoice_id Payable Invoice Entry, Invoice ID
PayableTransaction/PayableTransactionHeader/Supplier1099Indicatorvendor.report_1099_misc If Vendor Maintenance, Accounting Tab, Report 1099-Misc is selected, then "True." If the check box is clear, then "False"
PayableTransaction/PayableTransactionHeader/ExtendedAmountpayble.total_amount Payables Invoice Entry, Invoice Total. The system converts the amount to system currency. If the invoice is void, then the
amount is 0.@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionHeader/TotalAmountpayble.total_amount Payables Invoice Entry, Invoice Total. The system converts the amount to the system currency. If the status is Void, then the
amount is 0.@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionHeader/Tax/Amount@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionHeader/Allowance/BasisAmountpayable.total_amount Payables Invoice Entry, Invoice Total. The system converts the amount to the system currency. If the status is Void, then the
amount is 0.@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionHeader/Allowance/Amountpayable.discount_taken Payables Invoice Entry, Discount Taken. The system converts the amount to the system currency. If the status is Void, then the
amount is 0.
August 13, 2009 34
PayableTransaction@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionHeader/Charge/BasisAmountpayable.total_amount Payables Invoice Entry, Invoice Total. The system converts the amount to the system currency. If the status is Void, then the
amount is 0.@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionHeader/Charge/Amountpayable.discount_taken Payables Invoice Entry, Discount Taken. The system converts the amount to the system currency. If the status is Void, then the
amount is 0.@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionHeader/DiscountStatus/DiscountAllowedAmountpayable.discount_taken Payables Invoice Entry, Discount Taken. The system converts the amount to the system currency. If the status is Void, then the
amount is 0.
PayableTransaction/PayableTransactionHeader/DiscountStatus/DiscountTakenAmountpayable.discount_taken Payables Invoice Entry, Discount Taken. The system converts the amount to the system currency. If the status is Void, then the
amount is 0.
PayableTransaction/PayableTransactionHeader/PayableAmountpayble.total_amount Payables Invoice Entry, Invoice Total. The system converts the amount to the system currency. If the status is Void, then the
amount is 0.@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionHeader/PaymentAmountpayble.total_amount Payables Invoice Entry, Invoice Total. The system converts the amount to the system currency. If the status is Void, then the
amount is 0.@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionHeader/PaidAmountpayable.paid_amount Payables Invoice Entry, Paid Amount. The system converts the amount to the system currency. If the status is Void, then the
amount is 0.@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionHeader/PaymentMethodCodecash_disbursement.payment_method
Payment Entry, Output Type. If type is check, then paymentmethod is Cheque. Otherwise, paymentmethod is ElectronicFundsTransfer
PayableTransaction/PayableTransactionHeader/PaymentTerm/Term/Descriptionpayable.terms Payables Invoice Entry, Terms, Term ID
PayableTransaction/PayableTransactionHeader/PaymentTerm/Term/DueDateTimeCalculation:payable.invoice_date+payables.terms_net_daysorpayable_inst.due_date
Calculation:Payables Invoice Entry, Invoice Date plus Payables Invoice Entry, Terms, Net DaysIf payments are made in installments, then Invoice Entry, Installments, Due Date of last installment
PayableTransaction/PayableTransactionHeader/PaymentTerm/Discount/Descriptionpayable.terms Payables Invoice Entry, Terms, Term ID
@languageIDsettings.language_id SOA Maintenance, Language ID
August 13, 2009 35
PayableTransactionPayableTransaction/PayableTransactionHeader/PaymentTerm/Discount/EffectiveDateTime
payable.discount_dateorpayables.invoice_date
Payables Invoice Entry, Terms, Discount Fixed DateIf discount date is null, then Payables Invoice Entry, Invoice Date
PayableTransaction/PayableTransactionHeader/BaseCurrencyAmount@type
ExtendedAmount, TotalAmount
PayableTransaction/PayableTransactionHeader/BaseCurrencyAmount/Amountcalculation:(payables.total_amount*payables.terms_disc_percent/100)*payable.sell_rate
Calculation:(Payables Invoice Entry, Invoice Total multiplied by Payables Invoice Entry, Terms,Discount % divided by 100) multiplied by payables.sell_rate. The system converts the amount to the system currency. If the status is Void, then the amount is 0.
@currencyIDcurrency.currency_id Currency Maintenance, Currency ID marked as system currency
PayableTransaction/PayableTransactionLine/LineNumberpayable.line_no Payables Invoice Entry, Lines table, Ln#
PayableTransaction/PayableTransactionLine/Descriptionpayable.reference Payables Invoice Entry, Lines table, Reference
PayableTransaction/PayableTransactionLine/DocumentReference@type
Receive Delivery, Purchase Order
PayableTransaction/PayableTransactionLine/DocumentReference/LineNumberpayable_line.receiver_line_nopayable_line.purc_order_line_no
Payables Invoice Entry, Lines table, Receiver Ln #Payables Invoice Entry, Lines table, Order Ln #
PayableTransaction/PayableTransactionLine/DocumentReference/ItemIDs/ItemID/IDreceiver.part_idpuchase_order.part_id
Purchase Receipt Entry, Part IDPurchase Order Entry, Part ID
PayableTransaction/PayableTransactionLine/Status/Codepayable.pay_status Payables Invoice Entry, Status. If Payables Invoice Entry, General Tab, Status = Void, then status = Closed. Otherwise, status=
Open
PayableTransaction/PayableTransactionLine/Item/ItemID/IDpurc_order_line.part_id Purchase Order Entry, Lines, Part ID
PayableTransaction/PayableTransactionLine/Quantitypayable_line.qty Payables Invoice Entry, Lines table, Qty
@unitCodepurc_order_line.purchase_um Purchase Order Entry, Lines, UM
PayableTransaction/PayableTransactionLine/ExtendedAmountpayable_line.amount Payables Invoice Entry, Lines table, Amount. If total is not in system currency, the system converts the amount to the system
currency using the current exchange rate in Currency Exchange Rate Maintenance. If the invoice has been voided, then the amount is 0.
@currencyIDpayable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping
Maintenance.
PayableTransaction/PayableTransactionLine/TotalAmountpayable_line.amount Payables Invoice Entry, Lines table, Amount. The system converts the amount to the system currency. If the status is Void, then
the amount is 0.@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionLine/Tax/Amount@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionLine/Allowance/BasisAmountpayable_line.amount Payables Invoice Entry, Lines table, Amount. The system converts the amount to the system currency. If the status is Void, then
the amount is 0.@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionLine/Allowance/Amountpayable.discount_taken Payables Invoice Entry, Discount Taken. The system converts the amount to the system currency. If the status is Void, then the
August 13, 2009 36
PayableTransactionamount is 0.
@currencyIDpayable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping
Maintenance.
PayableTransaction/PayableTransactionLine/Charge/BasisAmountpayable_line.amount Payables Invoice Entry, Lines table, Amount. The system converts the amount to the system currency. If the status is Void, then
the amount is 0.@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionLine/Charge/Amountpayable.discount_taken Payables Invoice Entry, Discount Taken
@currencyIDpayable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping
Maintenance.
PayableTransaction/PayableTransactionLine/DiscountStatus/DiscountTakenAmountpayable.po_disc_percent Payables Invoice Entry, Lines table, P/O Recv Disc%. The system converts the amount to the system currency. If the status is
Void, then the amount is 0.
PayableTransaction/PayableTransactionLine/PayableAmountpayable_line.amount Payables Invoice Entry, Lines table, Amount. The system converts the amount to the system currency. If the status is Void, then
the amount is 0.@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionLine/PaymentAmountpayable_line.amount Payables Invoice Entry, Lines table, Amount. The system converts the amount to the system currency. If the status is Void, then
the amount is 0.@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionLine/PaidAmountpayable_line.amount Payables Invoice Entry, Lines table, Amount. The system converts the amount to the system currency. If the status is Void, then
the amount is 0.@currencyID
payable.currency_id Payables Invoice Entry, Currency ID. The system translates the code into an ISO code based on your settings in Code Mapping Maintenance.
PayableTransaction/PayableTransactionLine/BaseCurrencyAmount@type
ExtendedAmount, TotalAmount
PayableTransaction/PayableTransactionLine/BaseCurrencyAmount/Amountcalculation: payable_line.amount*payable.sell_rate
Payables Invoice Entry, Lines table, Amount multiplied by payable.sell_rate. The system converts the amount to the system currency. If the status is Void, then the amount is 0.
@currencyIDcurrency.currency_id Currency Maintenance, Currency ID marked as system currency
August 13, 2009 37
PersonPerson/ID
SalesRep~+sales_rep.IDBuyer~purc_requisition.requestorPlanner~work_order.engineered_byPlanner~part.planner_user_idPlanner~part_warehouse.planner_user_idBuyer~part.buyer_user_idBuyer~part_warehouse.buyer_user_idEmployee~employee.id
The BOD appends a type to the ID. SalesRep~Sales Reps Maintenance, IDPlanner~Manufacturing Window, General tab, Engineered ByPlanner~Part Maintenance, Planning tab, Planner User IDPlanner~Material Planning Window, Warehouse Locations, Planner User IDBuyer~Part Maintenance, Planning, Buyer User IDBuyer~Material Planning Window, Warehouse Locations, Buyer User IDEmployee~Employee Maintenance, Employee ID
Person/Namesales_rep.name Sales Reps Maintenance, Name
@languageIDsettings.language_id SOA Maintenance, Language ID
Person/GenderCode Not Specified
@listID Genders
Person/PersonnelReference/IDsales_rep.employee_ID Sales Rep Maintenance, Employee ID
Person/ContractualPartyContact/PartyIDs/IDsales_rep.vendor_ID Sales Rep Maintenance, Vendor ID
Person/SalesRepDefinition/Quota/FinancialPeriod/FinancialCalendarReference/IDsettings.calendar_name SOA Maintenance, Calendar Name
Person/SalesRepDefinition/Quota/FinancialPeriod/PeriodIDv_quota.month Sales Quotas, Month (CRM)
Person/SalesRepDefinition/Quota/FinancialPeriod/Yearv_quota.year Sales Quotas, Year (CRM)
Person/SalesRepDefinition/Quota/Amountv_quota.quota_amount Sales Quotas, Amount (CRM)
@currencyIDcurrency.currency_id Exchange Rate Maintenance, Currency Maintenance, Currency ID marked as system currency.
August 13, 2009 38
PersonnelPersonnel/ID
employee.id Employee Maintenance, Employee ID@lid
settings.instance_id The system combines lid://infor.visual with the value in SOA Maintenance, Visual Instance ID
Personnel/GivenNameemployee.first_name Employee Maintenance, First
@languageIDsettings.language_id SOA Maintenance, Language ID
Personnel/MiddleNameemployee.middle_initial Employee Maintenance, Mi
@languageIDsettings.language_id SOA Maintenance, Language ID
Personnel/FamilyNameemployee.last_name Employee Maintenance, Last
@languageID SOA Maintenance, Language ID
Personnel/GenderCode Not Specified
@listID Genders
Personnel/Address/AddressLine1: employee.addr_12: employee.addr_23. employee.addr_3
Employee Maintenance, Street Address fields
@sequence1: employee.addr_12: employee.addr_23. employee.addr_3
Employee Maintenance, Street Address fields
Personnel/Address/CityNameemployee.city Employee Maintenance, City
Personnel/Address/CountrySubDivisionCodeemployee.state Employee Maintenance, State
@listID Country Sub-divisions
Personnel/Address/CountryCodeemployee.country Employee Maintenance, Country
@listID Countries
Personnel/Address/PostalCodeemployee.zipcode Employee Maintenance, Zip
@listID Postal/Zip Codes
Personnel/Communication/UseCode 1: phone
2: email@listID
Communication Use Codes
Personnel/Communication/DialNumberemployee.phone Employee Maintenance, Phone. Use for Communciation Sequence 1
Personnel/Communication/URIemployee.email_addr Employee Maintenance, Email Address. Use for Communication Sequence 2
Personnel/DepartmentIDemployee.department_ID Employee Maintenance, Department
Personnel/Status/Codeemployee.active If Employee Maintenance, Active check box is selected, then code = Y. If it is not selected, then code = N
@listID Personnel Status
Personnel/WorkShiftIDemployee.shift_ID Employee Maintenance, Default Shift ID
Personnel/WageType
August 13, 2009 39
Personnelemployee.type Employee Maintenance, Type options
@listID Wage Types
Personnel/WageGroupCodeemployee.earning_code_ID Employee Maintenance, Earning Code
@listID WageGroupCode
August 13, 2009 40
ProductionOrderProductionOrder/DocumentID/ID
work_order.type'~'work_order.base_id'~'work_order.lot_id'~'work_order.split_id'~'0
The system concatenates the following:Manufacturing Window, Work Order Header, Type ~ Manufacturing Window, Work Order Header, Base ID/Job ID ~ Manufacturing Window, Work Order Header, Eng ID/Lot ID ~ Manufacturing Window, Work Order Header, Split ID ~ 0
@accountingEntityapplication_global.entity_id Application Global Maintenance, Default Mfg Entity
@lidsettings.instance_id The system combines lid://infor.visual with the value in SOA Maintenance, Visual Instance ID
ProductionOrder/LastModificationDateTimeapplication_global.sysdatetime The system inserts the date and time that the BOD was created.
ProductionOrder/DocumentDateTimework_order.create_date Work Order browse, Create Date
ProductionOrder/Description Work Order Header, Specifications
@languageIDsettings.language_id SOA Maintenance, Language ID
ProductionOrder/Status/Codework_order.status The system translates Work Order status codes as follows:
If Work Order status=unreleased, then status=plannedIf Work Order status=firmed, then status=firmIf Work Order status=released and the date of the earliest transaction against the work order is greater than the status effective date, then status=ActiveIf Work Order status=cancelled, then status=cancelledIf Work Order status=closed, then status=closed
@listID ProductionOrderStatus
ProductionOrder/Status/Descriptionwork_order.status The system translates Work Order status codes as follows:
If Work Order status=unreleased, then status=plannedIf Work Order status=firmed, then status=firmIf Work Order status=released and the date of the earliest transaction against the work order is greater than the status effective date, then status=ActiveIf Work Order status=cancelled, then status=cancelledIf Work Order status=closed, then status=closed
ProductionOrder/Status/EffectiveDateTimework_order.status_eff_date Work Order browse, Status Eff Date
ProductionOrder/Site@type
Site
ProductionOrder/Site/IDSite~work_order.entity_id Site~Work Order browse, Entity ID
ProductionOrder/Site/Nameapplication_global.name Application Global Maintenance, Name
ProductionOrder/Site/Address/AddressLineapplication_global.addr_1application_global.addr_2application_global.addr_3
Application Global Maintenance, Address fields
@sequence1: application_global.addr_12: application_global.addr_23: application_global.addr_3
Application Global Maintenance, Address fields
ProductionOrder/Site/Address/CityNameapplication_global.city Application Global Maintenance, City
ProductionOrder/Site/Address/CountrySubDivisionCodeapplication_global.state Application Global Maintenance, State
@listID Country Sub-divisions
ProductionOrder/Site/Address/CountryCodeapplication_global.country Application Global Maintenance, Country
@listID Countries
August 13, 2009 41
ProductionOrderProductionOrder/Site/Address/PostalCode
application_global.zipcode Application Global Maintenance, Zip@listID
Postal/Zip Codes
ProductionOrder/OrderQuantitywork_order.desired_quantity Manufacturing Window, Work Order Header, Quantity
@unitCodepart.stock_um Part Maintenance, Stock UM
ProductionOrder/DueQuantitywork_order.desired_quantity-work_order.received_quantity
Manufacturing Window, Work Order Header, Quantity minus Manufacturing Window, Work Order Voew Panel, Received Quantity
@unitCodepart.stock_um Part Maintenance, Stock UM
ProductionOrder/ExecutionTimePeriod/StartDateTime The system uses the earliest transaction date against the Work Order. The system only sends this information if the work order is
closed.
ProductionOrder/ExecutionTimePeriod/EndDateTimework_order.close_date The system uses the date that the Work Order status changed to close. The system only sends this information if the work order
is closed.
ProductionOrder/ForecastedTimePeriod/StartDateTimework_order.sched_start_datework_order.desired_rls_date
Manufacturing Window, Scheduled Start Date (in parantheses after Desired Start Date. The last date in the third column (text display) or row (card display))If Scheduled Start Date is null, then Manufacturing Window, Work Order Header, Release Date
ProductionOrder/ForecastedTimePeriod/EndDateTimework_order.sched_finish_datework_order.desired_want_date
Manufacturing Window, Scheduled Finish Date (in parantheses after the Desired Want Date)If Scheduled Finish Date is null, then Manufacturing Window, Desired Want Date (after Days Late)
ProductionOrder/DueDateTimework_order.sched_finish_datework_order.desired_want_date
Manufacturing Window, Scheduled Finish Date (in parantheses after the Desired Want Date)If Scheduled Finish Date is null, then Manufacturing Window, Desired Want Date (after Days Late)
ProductionOrder/RequiredDateTimework_order.desired_want_Date Manufacturing Window, Desired Want Date (after Days Late)
ProductionOrder/ReworkIndicator False
ProductionOrder/PlannerPersonReference/IDs/IDwork_order.engineered_by Work Order, Work Order Header, General tab, Engineered By.
ProductionOrder/ShopFloorPlannerPersonReference/IDs/IDpart.planner_user_id Part Maintenance, Planning tab, Planner User ID
ProductionOrder/ForwardScheduleIndicatorwork_order.forward_schedule If Manufacturing Window, Work Order Header, Forward Schedule From Release Date is selected, then True. If it is not selected,
then False.
ProductionOrder/PlannedDueDatework_order.sched_finish_datework_order.desired_want_date
Manufacturing Window, Scheduled Finish Date (in parantheses after the Desired Want Date)If Scheduled Finish Date is null, then Manufacturing Window, Desired Want Date (after Days Late)
ProductionOrder/RequestedDeliveryDatework_order.desired_want_date Manufacturing Window, Desired Want Date (after Days Late)
ProductionOrder/Costing@rateCode
Machine, Material, Labor, Burden, Contractor, Total
August 13, 2009 42
ProductionOrder@type
Actual, Estimated, Planned
ProductionOrder/Costing/AmountFor type=ActualMachine: 0Material: work_order.act_material_costLabor: work_order.act_labor_costBurden: work_order.act_burden_costContractor: work_order.act_service_costTotal: work_order.act_material_cost+work_order.act_labor_cost+work_order.act_burden_cost+work_order.act_service_cost
For type=EstimatedMachine: 0Material: work_order.est_material_costLabor: work_order.est_labor_costBurden: work_order.est_burden_costContractor: work_order.est_service_costTotal: work_order.est_material_cost+work_order.est_labor_cost+work_order.est_burden_cost+work_order.est_service_cost
For type=PlannedMachine: 0Material: work_order.est_material_costLabor: work_order.est_labor_costBurden: work_order.est_burden_costContractor: work_order.est_service_costTotal: work_order.est_material_cost+work_order.est_labor_cost+work_order.est_burden_cost+work_order.est_service_cost
@currencyIDcurrency.currency_ID Currency Maintenance, Currency ID. Uses currency marked as system currency.
ProductionOrder/ProductionOrderDetail/Sequence 1
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/IDwork_order.type+work_order.base_id+work_order.lot_id+work_order.split_id+work_order.sub_id
The system concatenates the following:Manufacturing Window, Work Order Header, Type ~ Manufacturing Window, Work Order Header, Base ID/Job ID ~ Manufacturing Window, Work Order Header, Eng ID/Lot ID ~ Manufacturing Window, Work Order Header, Split ID ~ Manufacturing Window, Operation Card, Operation Seq #
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/NextIDwork_order.type+work_order.base_id+work_order.lot_id+work_order.split_id+work_order.sub_id
The system uses the next operation in the work order and concatenates the following:Manufacturing Window, Work Order Header, Type ~ Manufacturing Window, Work Order Header, Base ID/Job ID ~ Manufacturing Window, Work Order Header, Eng ID/Lot ID ~ Manufacturing Window, Work Order Header, Split ID ~ Manufacturing Window, Operation Card, Operation Seq #
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/Descriptionrequirement.long_description Manufacturing Window, Operations Card, Description
August 13, 2009 43
ProductionOrderProductionOrder/ProductionOrderDetail/BillOfResources/Operations/Status/Code
requirement.status Manufacturing Window, Status. You can view the status code in the Operation View panel, in the text display mode (the status code precedxes the release date, and in the graphic display more (the status precedes the release date).
@listID ProductionOrderStatus
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/Status/Descriptionrequirement.status Manufacturing Window, Status. You can view the status code in the Operation View panel, in the text display mode (the status
code precedxes the release date, and in the graphic display more (the status precedes the release date).
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/Status/EffectiveDateTimerequirement.eff_status_date
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/OutputItem/ItemID/IDwork_order.part_id Manufacturing Window, Work Order Header, Part ID
@accountingEntitywork_order.entity_id Work Order browse, Entity ID
@locationSite~work_order.entity_id Site~'Work Order browse, Entity ID
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/OutputItem/TrackingIndicator False
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/OutputItem/ProducedQuantitywork_order.desired_qty - work_order.work_order.received.quantity
Calculated by subtracting the Work Order, Received Qty from the Work Order, Desired Qty, both available on the Manufacturing Window, Work Order View panel. The Desired Quantity is also displayed in the Quantity field on Manufacturing Window, Work Order Header Card.
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/OutputItem/Rejection/RejectQuantityoperation.deviated_qty Manufacturing Window, Labor Tickets, Qty (Deviated) for the operation.
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/OutputItem/Costing@rateCode
Material, Labor, Burden, Contractor@type
Planned, Estimated, Actual
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/OutputItem/Costing/AmountFor type=Estimatedrate code=Material: work_order.est_material_costrate code=Labor: work_order.est_labor_costrate code=Burden: work_order.est_burden_costrate code=Contractor: work_order.est_service_costFor type=Actualrate code=Material: work_order.act_material_costrate code=Labor: work_order.act_labor_costrate code=Burden: work_order.act_burden_costrate code=Contractor: work_order.act_service_cost
For type=Estimatedrate code=Material: Manufacturing Window, Costs, Est Material for work order headerrate code=Labor: Manufacturing Window, Costs, Est Labor for work order headerrate code=Burden: Manufacturing Window, Costs, Est Burden for work order headerrate code=Contractor: Manufacturing Window, Costs, Est Service for work order headerFor type=Actualrate code=Material: Manufacturing Window, Costs, Act Material for work order headerrate code=Labor: Manufacturing Window, Costs, Act Labor for work order headerrate code=Burden: Manufacturing Window, Costs, Act Burden for work order headerrate code=Contractor: Manufacturing Window, Costs, Act Service for work order header
@currencyIDcurrency.currency_ID Currency Maintenance, Currency ID. Uses currency marked as system currency.
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/ConstrainedResourceReference/ResourceID/IDoperation.resource_idoperation_resource.resource_id
Manufacturing Window, Operations Card, Resource IDManufacturing Window, Operations Card, Advanced tab, Resource ID
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/ProcessCodeoperation.service_id Manufacturing Window, Operations Card, Service ID
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/FixedRejectQuantityoperation.fixed_scrap_units Manufactuirng Window, Operations Card, Scrap/Yield tab, Fixed Scrap
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/RejectQuantityoperation.deviated_qty Manufacturing Window, Labor Tickets, Qty (Deviated) for the operation.
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/BatchSizeQuantityoperation.calc_end_qty Manufacturing Window, Operations Card, Scrap/Yield tab, End Qty
August 13, 2009 44
ProductionOrderProductionOrder/ProductionOrderDetail/BillOfResources/Operations/TransferLotQuantity
operation.minimum_move_qty Manufacturing Window, Operations Card, Setup/Run, Min Move Qty
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/SetupTimeDurationoperation.setup_hrs Manufacturing Window, Operations Card, Setup/Run, Setup Hrs
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/WaitTimeDurationoperation.max_gap_prev_op The value in Manufacturing Window, Operations Card, Other tab, Max gap from previous op divided by 60.
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/RunTimeDurationoperation.run_hrsoperation.run_type, operation.run, operation.calc_end_qty, operation.load_size_qty
Manufacturing Window, Operations Card, Setup/Run tab, Run
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/BatchDurationoperation.transit_daysoperation.setup_hours+ (operation.run_type, operation.run, operation.calc_end_qty, operation.load_size_qty)
If Manufacturing Window, Operations Card, Service ID is populated, then Setup/Run tab, Transit Days multiplied by 24
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/RejectPercentoperation.scrap_yield_pct If Manufacturing Window, Operations Card, Scrap option is selected, then 100 minus the value in Scrap/Yield%
If Yield option is selected, then Scrap/Yield%
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/Site@type
Site
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/Site/IDapplication_global.enitity_id Site~Application Global Maintenance, Default Mfg Entity
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/Site/Nameapplication_global.name Application Global Maintenance, Name
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/Site/Address/AddressLineapplication_global.addr_1application_global.addr_2application_global.addr_3
Application Global Maintenance, Address fields
@sequence1: application_global.addr_12: application_global.addr_23: application_global.addr_3
Application Global Maintenance, Address fields
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/Site/Address/CityNameapplication_global.city Application Global Maintenance, City
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/Site/Address/CountrySubDivisionCodeapplication_global.state Application Global Maintenance, State
@listID Country Sub-divisions
August 13, 2009 45
ProductionOrderProductionOrder/ProductionOrderDetail/BillOfResources/Operations/Site/Address/CountryCode
application_global.country Application Global Maintenance, Country@listID
Countries
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/Site/Address/PostalCodeapplication_global.zipcode Application Global Maintenance, Zip
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/YieldPercentoperation.scrap_yield_pct If Manufacturing Window, Operations Card, Scrap option is selected, then Scrap/Yield%
If Yield option is selected, then 100 minus the value in Scrap/Yield%
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/ScrapQuantityoperation.fixed_scrap_units Manufactuirng Window, Operations Card, Scrap/Yield tab, Fixed Scrap
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/OperationPersonReference/ResourceID/IDlabor_ticket.employee_id Labor Ticket Entry, Employee ID for the labor ticket associated with the work order. Can also review in Manufacturing Window,
Labor Tickets.@accountingEntity
application_global.mfg_entity_id Application Global Maintenance, Default Mfg Entity@location
application_global.mfg_enitity_id Site~Application Global Maintenance, Default Mfg Entity@lid
The system combines the information in the Tenant ID and Visual Instance ID fields in Infor Enterprise Service Bus Maintenance
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/EquipmentReference/ResourceID/IDoperation.resource_idoperation_resource.resource_id
Manufacturing Window, Operations Card, Resource IDManufacturing Window, Operations Card, Advanced tab, Resource ID
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/WorkCenterIDoperation.resource_id Manufacturing Window, Operations Card, Resource ID
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/Costing@rateCode
Labor, Burden, Contractor@type
Estimated, Actual
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/Costing/AmountFor type=Estimated, rate code=Labor: operation.est_atl_lab_costFor type=Estimated, rate code=Burden: operation.est_atl_burd_costFor type=Estimated, rate code=Contractor: operation.est_atl_ser_costFor type=Actual, rate code=Labor: operation.act_atl_lab_costFor type=Actual, rate code=Burden: operation.act_atl_bur_costFor type=Actual, rate code=Contractor: operation.act_atl_ser_cost
For type=Estimated, rate code=Labor: Manufacturing Window, Est Labor for operationFor type=Estimated, rate code=Burden: Manufacturing Window, Est Burden for operationFor type=Estimated, rate code=Contractor: Manufacturing Window, Est Service for operationFor type=Actual, rate code=Labor: Manufacturing Window, Act Labor for work order operationFor type=Actual, rate code=Burden: Manufacturing Window, Act Burden for work order operationFor type=Actual, rate code=Contractor: Manufacturing Window, Act Service for work order operation
@currencyIDcurrency.currency_ID Currency Maintenance, Currency ID. Uses currency marked as system currency.
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/ExecutionTimePeriod/StartDateTimelabor_ticket.start_date
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/ForecastedTimePeriod/StartDateTimeoperation.sched_start_date Manufacturing Window, Operation View Panel, Sched Start Date
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/ForecastedTimePeriod/EndDateTimeoperation.sched_end_date Manufacturing Window, Operation View Panel, Sched Finish Date
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/RunTimePeriod/StartDateTimelabor_ticket.start_date
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/RunTimePeriod/EndDateTimelabor_ticket.end_date
ProductionOrder/ProductionOrderDetail/BillOfResources/Operations/SetupTimePeriod/StartDateTimelabor_ticket.start_date
August 13, 2009 46
ProductionOrderProductionOrder/ProductionOrderDetail/BillOfResources/Operations/SetupTimePeriod/EndDateTime
labor_ticket.end_date
August 13, 2009 47
PurchaseOrderPurchaseOrder/PurchaseOrderHeader/DocumentID@agencyRole
Supplier
PurchaseOrder/PurchaseOrderHeader/DocumentID/IDpurchase_order.id Purchase Order Entry, Our Order ID
@accountingEntityapplication_global.entity_id Application Global Maintenance, Default Mfg Entity
@locationsettings.location_id SOA Maintenance, SOA Location
@lidsettings.instance_id The system combines lid://infor.visual with the value in SOA Maintenance, Visual Instance ID
PurchaseOrder/PurchaseOrderHeader/AlternateDocumentID/IDpurchase_order.sales_order_id Purchase Order Entry, Other tab, Sales Order ID
@accountingEntityapplication_global.entity_id Application Global Maintenance, Default Mfg Entity
@location SOA Maintenance, SOA Location
@agencyRoleSite ~'application_global.entity_id Site ~ Application Global Maintenance, Default Mfg Entity
PurchaseOrder/PurchaseOrderHeader/LastModificationDateTime The system inserts the date and time that the BOD was generated
PurchaseOrder/PurchaseOrderHeader/DocumentDateTimepurchase_order.order_date Purchase Order Entry, Order Date
PurchaseOrder/PurchaseOrderHeader/Notenote.notation Purchase Order Entry, Order Notations
@languageIDsettings.language_id SOA Maintenance, Language ID
@author Purchase Order Entry, Order Notations. The system inserts the user ID stamped on the entry.
@entryDateTime Purchase Order Entry, Order Notations. The system inserts the date/time stamped on the entry.
@status Open
PurchaseOrder/PurchaseOrderHeader/Status/Codepurchase_order.status Purchase Order codes are translated as follows:
Purchase Order Entry, Status=Firmed, then status=OpenPurchase Order Entry, Status=Released, then status=OrderedPurchase Order Entry, Status=Closed, then status=ClosedPurchase Order Entry, Status=Cancelled/Void, then status=Cancelled
PurchaseOrder/PurchaseOrderHeader/Status/Description Order codes are translated as follows:
Purchase Order Entry, Status=Released, then status=OrderedPurchase Order Entry, Status=Firmed, then status=PlannedPurchase Order Entry, Status=Closed, then status=ClosedPurchase Order Entry, Status=Cancelled/Void, then status=Cancelled
PurchaseOrder/PurchaseOrderHeader/Status/EffectiveDateTimepurchase_order.status_eff_date If status equals Closed or Cancelled/Void, then status effective date is the Last Received Date (PURCHASE_ORDER .
LAST_RECEIPT_DATE).If the Last Receipt Date is blank and in all other cases, then the status effective date is the date the purchase order was created (PURCHASE_ORDER.CREATE_DATE).
PurchaseOrder/PurchaseOrderHeader/CustomerParty/PartyIDs/IDpurchase_order.entity_ID Purchase Order Entry, Other tab, Entity ID
@schemeName System
@schemeAgencyIDsettings.instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID
PurchaseOrder/PurchaseOrderHeader/CustomerParty/Nameapplication_global.company_name
Application Global Maintenance, Name
@languageIDsettings.language_id SOA Maintenance, Langauge ID
PurchaseOrder/PurchaseOrderHeader/CustomerParty/Location/ID
August 13, 2009 48
PurchaseOrderSite ~' application_global.entity_idor'Site ~' shipto_addr.shipto_ID':'shipto_AddrNo
Application Global Maintenance, Default Mfg Entity IDorShip To Addresses, Shipto ID and #
PurchaseOrder/PurchaseOrderHeader/CustomerParty/Location/Nameapplication_global.company_nameorshipto_addr.name
Application Global Maintenance, NameorShip To Addresses, Name
PurchaseOrder/PurchaseOrderHeader/CustomerParty/Location/Address/AddressLine@sequence
1: application_global.addr12: application_global.addr23: application_global.addr3or1: shipto_addr.addr12: shipto_addr.addr23: shipto_addr.addr3
Application Global Maintenance, Street Address fieldsorShip To Addresses, Street Address fields
PurchaseOrder/PurchaseOrderHeader/CustomerParty/Location/Address/CityNameapplication_global.cityorshipto_addr.city
Application Global Maintenance, CityorShip To Addresses, City
PurchaseOrder/PurchaseOrderHeader/CustomerParty/Location/Address/CountrySubDivisionCodeapplication_global.stateorshipto_addr.state
Application Global Maintenance, StateorShip To Addresses, State
@listID Country Sub-divisions
@listAgencyID OAGIS
PurchaseOrder/PurchaseOrderHeader/CustomerParty/Location/Address/CountryCodeapplication_global.countryorshipto_addr.country
Application Global Maintenance, CountryorShip To Addresses, Country
@listID Countries
@listAgencyID OAGIS
PurchaseOrder/PurchaseOrderHeader/CustomerParty/Location/Address/PostalCodeapplication_global.zipcodeorshipto_addr.zipcode
Application Global Maintenance, ZiporShip To Addresses, Zip
@listID Postal/Zip Codes
@listAgencyID OAGIS
PurchaseOrder/PurchaseOrderHeader/SupplierParty/PartyIDs/IDpurchase_order.vendor_ID Purchase Order Entry, Vendor ID
@schemeName System
@schemeAgencyIDsettings.instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID
August 13, 2009 49
PurchaseOrderPurchaseOrder/PurchaseOrderHeader/SupplierParty/Name
vendor.name Vendor Maintenance, Name@languageID
settings.language_id SOA Maintenance, Langauge ID
PurchaseOrder/PurchaseOrderHeader/SupplierParty/Contact/Namepurchase_order.contact_first_namepurchase_order.contact_initialpurchase_order.contact_last_name
Purchase Order Entry, Contact tab, Contact fields
PurchaseOrder/PurchaseOrderHeader/SupplierParty/Contact/JobTitlepurchase_order.contact_position Purchase Order Entry, Contact tab, Pos.
PurchaseOrder/PurchaseOrderHeader/SupplierParty/Contact/Communication/UseCode 1: phone
2: mobile3: fax4. email
PurchaseOrder/PurchaseOrderHeader/SupplierParty/Contact/Communication/DialNumberpurchase_order.contact_phonepurchase_order.contact_mobilepurchase_order.contact_fax
Purchase Order Entry, Contact tab, PhonePurchase Order Entry, Contact tab, MobilePurchase Order Entry, Contact tab, Fax
PurchaseOrder/PurchaseOrderHeader/SupplierParty/Contact/Communication/URIpurchase_order.contact_email Purchase Order Entry, Contact tab, Email
PurchaseOrder/PurchaseOrderHeader/ShipToParty/PartyIDs/IDpurchase_order.entity_ID Purchase Order Entry, Other tab, Entity ID
@schemeName System
@schemeAgencyIDsettings.instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID
PurchaseOrder/PurchaseOrderHeader/ShipToParty/Nameapplication_global.company_name
Application Global Maintenance, Name
@languageIDsettings.language_id SOA Maintenance, Langauge ID
PurchaseOrder/PurchaseOrderHeader/ShipToParty/Location@type
Site, Warehouse, Customer, Vendor
PurchaseOrder/PurchaseOrderHeader/ShipToParty/Location/IDFor type=sitesite ~ application_global.entity_ID
For type=Warehousewarehouse ~ purchase_order.warehouse_ID ~ warehouse_address.addr_no
For type=Site'site ~' Application Global Maintenance, Default Mfg Entity ID
For type=Warehouse:'warehouse ~' Warehouse Maintenance, Warehouse ID '~' '0''warehouse ~' Warehouse Maintenance, Warehouse ID '~' Warehouse Maintenance, Alternate Warehouse Address, #
@schemeName System
PurchaseOrder/PurchaseOrderHeader/ShipToParty/Location/NameFor type=siteapplication_global.company_name
For type=Warehousewarehouse_address.warehouse_name
For type=SiteApplication Global Maintenance, Name
For type=Warehouse:Warehouse Address, Name
PurchaseOrder/PurchaseOrderHeader/ShipToParty/Location/Address/AddressLine@sequence
For type=site1: application_global.company_addr_12: application_global.company_addr_2
For type=SiteApplication Global Maintenance, Street Address fields
For type=Warehouse:Warehouse Maintenance, Warehouse Address, Street Address fields
August 13, 2009 50
PurchaseOrder3: application_global.company_addr_3
For type=Warehouse1: warehouse_address.addr_12: warehouse_address.addr_23: warehouse_address.addr_3
PurchaseOrder/PurchaseOrderHeader/ShipToParty/Location/Address/CityNameFor type=siteapplication_global.company_city
For type=Warehousewarehouse_address.city
For type=SiteApplication Global Maintenance, City
For type=Warehouse:Warehouse Maintenance, Warehouse Address, City
PurchaseOrder/PurchaseOrderHeader/ShipToParty/Location/Address/CountrySubDivisionCodeFor type=siteapplication_global.company_state
For type=Warehousewarehouse_address.state
For type=SiteApplication Global Maintenance, State
For type=Warehouse:Warehouse Maintenance, Warehouse Address, State
@listID Country Sub-divisions
@listAgencyID OAGIS
PurchaseOrder/PurchaseOrderHeader/ShipToParty/Location/Address/CountryCodeFor type=siteapplication_global.company_country
For type=Warehousewarehouse_address.country
For type=SiteApplication Global Maintenance, Country
For type=Warehouse:Warehouse Maintenance, Warehouse Address, Country
@listID Countries
@listAgencyID OAGIS
PurchaseOrder/PurchaseOrderHeader/ShipToParty/Location/Address/PostalCodeFor type=siteapplication_global.company_zipcode
For type=Warehousewarehouse_address.zipcode
For type=SiteApplication Global Maintenance, Zip
For type=Warehouse:Warehouse Maintenance, Warehouse Address, Zip
@listID Postal/Zip Codes
@listAgencyID OAGIS
PurchaseOrder/PurchaseOrderHeader/ContractReference/DocumentID/IDpurchase_order.contract_ID Purchase Order Entry, EDI tab, Contract ID
@schemeName System
@schemeAgencyIDsettings.instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID
PurchaseOrder/PurchaseOrderHeader/ExtendedAmountCalculation:Sum of all purchase_order_line.unit_price*purchase_order_line.user_order_quantity
The system adds the sum for each line in the Purchase Order as follows:Purchase Order Entry, Lines, Purchase Price multiplied by Purchase Order Entry, Lines, Quantity)
@currencyIDpurchase_order.currency_ID Purchase Order Entry, Currency ID. The system translates the Currency ID to the SOA code based on your settings in Code
Mapping Maintenance.
PurchaseOrder/PurchaseOrderHeader/TotalAmountcalculation:((purchase_order_line.unit_price*puchase_order_line.
The system adds the sum for each line in the Purchase Order as follows:(Purchase Order Entry, Lines, Purchase Price multiplied by Purchase Order Entry, Lines, Quantity) multiplied by (1 minus Purchase Order Entry, Lines\, Disc % divided by 100) plus Purchase Order Entry, Lines, Fixed Charge
August 13, 2009 51
PurchaseOrderuser_order_qty)*(1-purchase_order_line.trade_disc_percent/100)+purchase_order_line.fixed_charge
@currencyIDpurchase_order.currency_ID Purchase Order Entry, Currency ID. The system translates the Currency ID to the SOA code based on your settings in Code
Mapping Maintenance.
PurchaseOrder/PurchaseOrderHeader/BillToParty/PartyIDs/IDSite~purchase_order.entity_ID Site~Purchase Order Entry, Other tab, Entity ID
PurchaseOrder/PurchaseOrderHeader/BillToParty/Nameapplication_global.company_name
Application Global Maintenance, Name
@languageIDsettings.language_id SOA Maintenance, Langauge ID
PurchaseOrder/PurchaseOrderHeader/BillToParty/Location/Nameapplication_global.company_name
Application Global Maintenance, Name
PurchaseOrder/PurchaseOrderHeader/BillToParty/Location/Address/AddressLine@sequence
1: application_global.company_addr_12: application_global.company_addr_23: application_global.company_addr_3
Application Global Maintenance, Street Address fields
PurchaseOrder/PurchaseOrderHeader/BillToParty/Location/Address/CityNameapplication_global.company_city Application Global Maintenance, City
August 13, 2009 52
PurchaseOrderPurchaseOrder/PurchaseOrderHeader/BillToParty/Location/Address/CountrySubDivisionCode
application_global.company_state
For type=Warehousewarehouse_address.state
Application Global Maintenance, State
@listID Country Sub-divisions
@listAgencyID OAGIS
PurchaseOrder/PurchaseOrderHeader/BillToParty/Location/Address/CountryCodeapplication_global.company_country
Application Global Maintenance, Country
@listID Countries
@listAgencyID OAGIS
PurchaseOrder/PurchaseOrderHeader/BillToParty/Location/Address/PostalCodeapplication_global.company_zipcode
Application Global Maintenance, Zip
@listID Postal/Zip Codes
@listAgencyID OAGIS
PurchaseOrder/PurchaseOrderHeader/CarrierParty/Namecarrier.carrier_name
PurchaseOrder/PurchaseOrderHeader/CarrierParty/Location/Address/AddressLinecarrier.addr_1carrier.addr_2carrier.addr_3
Application Global Maintenance, Carriers, Addr 1Application Global Maintenance, Carriers, Addr 2Application Global Maintenance, Carriers, Addr 3
@sequence1: carrier.addr_12: carrier.addr_23: carrier.addr_3
1: Application Global Maintenance, Carriers, Addr 12: Application Global Maintenance, Carriers, Addr 23: Application Global Maintenance, Carriers, Addr 3
PurchaseOrder/PurchaseOrderHeader/CarrierParty/Location/Address/CityNamecarrier.city Application Global Maintenance, Carriers, City
PurchaseOrder/PurchaseOrderHeader/CarrierParty/Location/Address/CountrySubDivisionCodecarrier.state Application Global Maintenance, Carriers, State/Province
@listID Country Sub-divisions
@listAgencyID OAGIS
PurchaseOrder/PurchaseOrderHeader/CarrierParty/Location/Address/CountryCodecarrier.country Application Global Maintenance, Carriers, Country
@listID Countries
@listAgencyID OAGIS
PurchaseOrder/PurchaseOrderHeader/CarrierParty/Location/Address/PostalCodecarrier.zipcode Application Global Maintenance, Carriers, Zip/Postal Code
@listID OAGIS
@listAgencyID Postal/Zip Codes
PurchaseOrder/PurchaseOrderHeader/PaymentTerm/Descriptionpurchase_order.terms_net_typepurchase_order.terms_net_dayspurchase_order.terms_net_datepurchase_order.terms_disc_typepurchase_order.terms_disc_dayspurchase_order.terms_disc_datepurchase_order.terms_disc_percent
Purchase Order Entry, Terms
August 13, 2009 53
PurchaseOrderpurchase_order.terms_description
@languageIDsettings.language_id SOA Maintenance, Langauge ID
PurchaseOrder/PurchaseOrderHeader/PromisedShipDateTimepurchase_order.promise_ship_date
Purchase Order Entry, Promise Ship Date
PurchaseOrder/PurchaseOrderHeader/PromisedDeliveryDateTimepurchase_order.promise_date Purchase Order Entry, Promise Delivery Date
PurchaseOrder/PurchaseOrderHeader/PaymentMethodCodevendor.payment_method Vendor Maintenance, Payment tab, Payment Method
PurchaseOrder/PurchaseOrderHeader/OrderDateTimepurchase_order.order_date Purchase Order Entry, Order Date
PurchaseOrder/PurchaseOrderHeader/QuoteReference/DocumentID/IDrfq_vendor.supplier_quote_id
@schemeName System
@schemeAgencyIDsettings.instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID
PurchaseOrder/PurchaseOrderHeader/BaseCurrencyAmount@type
ExtendedAmount, TotalAmount
PurchaseOrder/PurchaseOrderHeader/BaseCurrencyAmount/Amountcalculation:For type=ExtendedAmount(purchase_order_line.unit_price*(1-purchase_order_line.trade_disc_percent/100))*purchase_order_line.user_order_quantity
For type=TotalAmount(purchase_order_line.unit_price*purchase_order_line.user_order_quantity)*(1-purchase_order_line.trade_disc_percent/100)+purchase_order_line.fixed_charge
For type=ExtendedAmountThe system adds the sum for each line in the Purchase Order as follows:Purchase Order Line, Purchase Price multiplied by ((1 minus (Purchase Order Line, Disc % divided by 100)) multiplied by Purchase Order Entry, Quantity)
For type=TotalAmountThe system adds the sum for each line in the Purchase Order as follows:(Purchase Order Line, Purchase Price multiplied by Purchase Order Line, Quantity) multiplied by (1 minus Purchase Order Line, Disc % divided by 100) plus Purchase Order Line, Fixed Charge
@currencyIDcurrency.id Currency Maintenance, ID marked as system currency.
PurchaseOrder/PurchaseOrderLine/LineNumberpurc_order_line.line_no Purchase Order Entry, purchase order line table, Line #
PurchaseOrder/PurchaseOrderLine/Descriptionpart.descriptionservice.description
If the line item is a part, then Part Maintenance, DescriptionIf the line item is a service, then Outside Service Maintenance, Description
@languageIDsettings.language_id SOA Maintenance, Langauge ID
PurchaseOrder/PurchaseOrderLine/Status/Codepurc_order_line.line_status The system translates Line Status Codes as follows:
If the line status is closed, then the status=closedIn all other cases, line status equals purchase_order.status.
@listID Purchase Order Status
@listAgencyID Infor
August 13, 2009 54
PurchaseOrderPurchaseOrder/PurchaseOrderLine/Status/EffectiveDateTime
purc_order_line.ln_status_eff_date
If the line status is closed, then the Purchase Order Line Status Effective Date equals the date items from the line were last received (purc_order_lin.last_received_date). In all other cases, the Purchase Order Line Status Effective Date equals the Purchase Order Status Effective Date.
PurchaseOrder/PurchaseOrderLine/Item/ItemID/IDpurc_order_line.part_idpurc_order_line.service_id
If the item is a part, then Purchase Order Entry, purchase order line table, Part IDIf the item is a service, then Purchase Order Entry, purchase order line table, Service ID
@schemeName System
@schemeAgencyIDsettings.instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID
PurchaseOrder/PurchaseOrderLine/Item/ServiceIndicatorpurc_order_line.service_id If Purchase Order Entry, purchase order line table, Service ID is populated, then true. If the field is empty, then false.
PurchaseOrder/PurchaseOrderLine/Item/Descriptionpart.descriptionservice.description
If the line item is a part, then Part Maintenance, DescriptionIf the line item is a service, then Outside Service Maintenance, Description
@languageIDsettings.language_id SOA Maintenance, Language ID
PurchaseOrder/PurchaseOrderLine/Item/Classification@type
Commodity Codes, Product Lines
PurchaseOrder/PurchaseOrderLine/Item/Classification/Codes/Codepart.commodity_codepart.product_code
If type=Commodity Code, then Part Maintenance, Commodity CodeIf type=ProductLine, then Part Maintenance, Product Code
@listID Commodity Codes, Product Lines
@listAgencyID Infor
PurchaseOrder/PurchaseOrderLine/Item/Specification/Property/NameValuepart.eng_mstrpart.drawing_id
If name=Engineering Reference, then Part Maintenance, Eng Master Eng IDIf name=DrawingNumber, then Part Maintenance, Config Mgt tab, Drawing #
@name Engineering Reference, Drawing Number
PurchaseOrder/PurchaseOrderLine/Quantitypurc_order_line.user_order_qty Purchase Order Entry, purchase order line table, Quantity
@unitCodepurc_order_line.purchase_um Purchase Order Entry, purchase order line table, U/M
PurchaseOrder/PurchaseOrderLine/UnitPrice/Amountpurc_order_line.unit_price Purchase Order Entry, purchase order line table, Unit Price
@currencyIDpurchase_order.currency_ID Purchase Order Entry, Currency ID. The system translates the Currency ID to the SOA code based on your settings in Code
Mapping Maintenance.
PurchaseOrder/PurchaseOrderLine/UnitPrice/PerQuantity 1
@unitCodepurc_order_line.purchase_um Purchase Order Entry, purchase order line table, U/M
PurchaseOrder/PurchaseOrderLine/ExtendedAmountcalculation:(purchase_order_line.unit_price*(1-purchase_order_line.trade_disc_percent/100))*purchase_order_line.user_order_quantity
The system adds the sum as follows:Purchase Order Line, Unit Price multiplied by ((1 minus (Purchase Order Line, Disc % divided by 100)) multiplied by Purchase Order Line, Quantity)
@currencyIDpurchase_order.currency_ID Purchase Order Entry, Currency ID. The system translates the Currency ID to the SOA code based on your settings in Code
Mapping Maintenance.
PurchaseOrder/PurchaseOrderLine/TotalAmountcalculation:(purchase_order_line.unit_price*purchase_order_line.user_order_quantity)*(1-purchase_order_line.
The system adds the sum as follows:(Purchase Order Line, Unit Price multiplied by Purchase Order Line, Quantity) multiplied by (1 minus Purchase Order Line, Disc % divided by 100) plus Purchase Order Line, Fixed ChargeIf line item is a service and the extended amount is less than the Purchase Order Lines, Minimum Charge, then the system uses the minimum charge.
August 13, 2009 55
PurchaseOrdertrade_disc_percent/100)+purchase_order_line.fixed_chargepurchase_order_line.minimum_charge
@currencyIDpurchase_order.currency_ID Purchase Order Entry, Currency ID. The system translates the Currency ID to the SOA code based on your settings in Code
Mapping Maintenance.
PurchaseOrder/PurchaseOrderLine/RequiredDeliveryDateTimepurc_order_line.desired_recv_datepurchase_order.desired_recv_date
Purchase Order Entry, purchase order line table, Recv Date field.If field is empty, then Purchase Order Entry, Desired Recv Date
PurchaseOrder/PurchaseOrderLine/AllowSubstitutionIndicator True
PurchaseOrder/PurchaseOrderLine/ShipToParty/Location/IDFor type=sitesite ~ application_global.manufacturing_entity_ID
For type=Warehousewarehouse ~ purchase_order.warehouse_ID ~ warehouse_address.addr_no
For type=Site'site ~' Application Global Maintenance, Default Mfg Entity ID
For type=Warehouse:'warehouse ~' Warehouse Maintenance, Warehouse ID '~' '0''warehouse ~' Warehouse Maintenance, Warehouse ID '~' Warehouse Maintenance, Alternate Warehouse Address, #
PurchaseOrder/PurchaseOrderLine/ShipToParty/Location/NameFor type=siteapplication_global.company_name
For type=Warehousewarehouse_address.warehouse_name
For type=SiteApplication Global Maintenance, Name
For type=Warehouse:Warehouse Address, Name
PurchaseOrder/PurchaseOrderLine/ShipToParty/Location/Address/AddressLine@sequence
For type=site1: application_global.company_addr_12: application_global.company_addr_23: application_global.company_addr_3
For type=Warehouse1: warehouse_address.addr_12: warehouse_address.addr_23: warehouse_address.addr_3
For type=SiteApplication Global Maintenance, Street Address fields
For type=Warehouse:Warehouse Maintenance, Warehouse Address, Street Address fields
PurchaseOrder/PurchaseOrderLine/ShipToParty/Location/Address/CityNameFor type=siteapplication_global.company_city
For type=Warehousewarehouse_address.city
For type=SiteApplication Global Maintenance, City
For type=Warehouse:Warehouse Maintenance, Warehouse Address, City
PurchaseOrder/PurchaseOrderLine/ShipToParty/Location/Address/CountrySubDivisionCodeFor type=siteapplication_global.company_state
For type=Warehousewarehouse_address.state
For type=SiteApplication Global Maintenance, State
For type=Warehouse:Warehouse Maintenance, Warehouse Address, State
PurchaseOrder/PurchaseOrderLine/ShipToParty/Location/Address/CountryCodeFor type=siteapplication_global.company_country
For type=Warehouse
For type=SiteApplication Global Maintenance, Country
For type=Warehouse:Warehouse Maintenance, Warehouse Address, Country
August 13, 2009 56
PurchaseOrderwarehouse_address.country
PurchaseOrder/PurchaseOrderLine/ShipToParty/Location/Address/PostalCodeFor type=siteapplication_global.company_zipcode
For type=Warehousewarehouse_address.zipcode
For type=SiteApplication Global Maintenance, Zip
For type=Warehouse:Warehouse Maintenance, Warehouse Address, Zip
PurchaseOrder/PurchaseOrderLine/SpecialPriceAuthorizationCodepurc_order_line.special_price_auth
Purchase Order Entry, purchase order lines, Special Price Authorization
PurchaseOrder/PurchaseOrderLine/RequisitionReference/DocumentID/IDpurc_order_req.purc_ord_line_no Purchase Requisition Entry, Ln # for the requisition ID that corresponds to the purchase order.
PurchaseOrder/PurchaseOrderLine/PromisedShipDateTimepurc_order_line.promise_ship_datepurchase_order.promise_ship_date
Purchase Order Entry, Lines, Promise Ship Date. If field is blank, then Purchase Order Entry, Promise Ship Date
PurchaseOrder/PurchaseOrderLine/PromisedDeliveryDateTimepurc_order_line.promise_datepurchase_order.promise_date
Purchase Order Entry, Lines, Promise Delivery Date. If field is blank, then Purchase Order, Promise Delivery Date
PurchaseOrder/PurchaseOrderLine/ReceivedQuantitypurc_order_line.total_received_qty
Purchase Order Entry, Lines, Stock UM Rec'd Qty
@unitCodepurc_order_line.purchase_um Purchase Order Entry, Lines, U/M
PurchaseOrder/PurchaseOrderLine/OpenQuantitycalculation:purc_order_line.user_order_qty-purc_order_line.total_received_qty
The system subtracts the amount in Purchase Order Entry, Lines, Stock UM Rec'd Qty from Purchase Order Entry, Lines, Quantity
@unitCodepurc_order_line.purchase_um Purchase Order Entry, Lines, U/M
August 13, 2009 57
PurchaseOrderPurchaseOrder/PurchaseOrderLine/BuyerParty/Name@languageID
settings.language_id SOA Maintenance, Language ID
PurchaseOrder/PurchaseOrderLine/BuyerParty/Location/IDapplication_global.entity_id Site~Application Global Maintenance, Default Mfg Entity ID
PurchaseOrder/PurchaseOrderLine/BuyerParty/Location/Nameapplication_global.company_name
Application Global Maintenance, Name
PurchaseOrder/PurchaseOrderLine/BuyerParty/Location/Address/AddressLine1: application_global.company_addr_12: application_global.company_addr_23: application_global.company_addr_3
Application Global Maintenance, Street Address fields
PurchaseOrder/PurchaseOrderLine/BuyerParty/Location/Address/CityNameapplication_global.company_city Application Global Maintenance, City
PurchaseOrder/PurchaseOrderLine/BuyerParty/Location/Address/CountrySubDivisionCodeapplication_global.company_state Application Global Maintenance, State
PurchaseOrder/PurchaseOrderLine/BuyerParty/Location/Address/CountryCodeapplication_global.company_country
Application Global Maintenance, Country
PurchaseOrder/PurchaseOrderLine/BuyerParty/Location/Address/PostalCodeapplication_global.company_zipcode
Application Global Maintenance, Zip
PurchaseOrder/PurchaseOrderLine/PriceOverrideIndicator False
PurchaseOrder/PurchaseOrderLine/ContractApplicableIndicatorpurchase_order.contract_ID If Purchase Order Entry, EDI tab, Contract ID is populated, then True. If Contract ID is blank, then False
PurchaseOrder/PurchaseOrderLine/ContractReference/DocumentID/IDpurchase_order.contract_ID Purchase Order Entry, EDI tab, Contract ID
PurchaseOrder/PurchaseOrderLine/AllocatedQuantitypurc_order_line.allocated_qty Purchase Order Entry, Lines, Allocate Qty
@unitCodepurc_order_line.purchase_um Purchase Order Entry, Lines, U/M
PurchaseOrder/PurchaseOrderLine/ShipToParty/Location/IDFor type=sitesite ~ application_global.manufacturing_entity_ID
For type=Warehousewarehouse ~ purchase_order.warehouse_ID ~ warehouse_address.addr_no
For type=Site'site ~' Application Global Maintenance, Default Mfg Entity ID
For type=Warehouse:'warehouse ~' Warehouse Maintenance, Warehouse ID '~' '0''warehouse ~' Warehouse Maintenance, Warehouse ID '~' Warehouse Maintenance, Alternate Warehouse Address, #
PurchaseOrder/PurchaseOrderLine/ShipToParty/Location/NameFor type=siteapplication_global.company_name
For type=Warehousewarehouse_address.warehouse_name
For type=SiteApplication Global Maintenance, Name
For type=Warehouse:Warehouse Address, Name
PurchaseOrder/PurchaseOrderLine/ShipToParty/Location/Address/AddressLine@sequence
For type=site1: application_global.company_addr_12: application_global.company_addr_23: application_global.company_addr_3
For type=SiteApplication Global Maintenance, Street Address fields
For type=Warehouse:Warehouse Maintenance, Warehouse Address, Street Address fields
August 13, 2009 58
PurchaseOrder
For type=Warehouse1: warehouse_address.addr_12: warehouse_address.addr_23: warehouse_address.addr_3
PurchaseOrder/PurchaseOrderLine/ShipToParty/Location/Address/CityNameFor type=siteapplication_global.company_city
For type=Warehousewarehouse_address.city
For type=SiteApplication Global Maintenance, City
For type=Warehouse:Warehouse Maintenance, Warehouse Address, City
PurchaseOrder/PurchaseOrderLine/ShipToParty/Location/Address/CountrySubDivisionCodeFor type=siteapplication_global.company_state
For type=Warehousewarehouse_address.state
For type=SiteApplication Global Maintenance, State
For type=Warehouse:Warehouse Maintenance, Warehouse Address, State
PurchaseOrder/PurchaseOrderLine/ShipToParty/Location/Address/CountryCodeFor type=siteapplication_global.company_country
For type=Warehousewarehouse_address.country
For type=SiteApplication Global Maintenance, Country
For type=Warehouse:Warehouse Maintenance, Warehouse Address, Country
PurchaseOrder/PurchaseOrderLine/ShipToParty/Location/Address/PostalCodeFor type=siteapplication_global.company_zipcode
For type=Warehousewarehouse_address.zipcode
For type=SiteApplication Global Maintenance, Zip
For type=Warehouse:Warehouse Maintenance, Warehouse Address, Zip
PurchaseOrder/PurchaseOrderLine/RFQReference/DocumentIDpurc_order_rfq.purc_rfq_idvendor.id
Purchase Order Entry, Show PO RFQs, RFQ ID ~ Vendor Maintenance, ID
PurchaseOrder/PurchaseOrderLine/BaseCurrencyAmount@type
Extended, Total
PurchaseOrder/PurchaseOrderLine/BaseCurrencyAmount/Amountcalculation:For type=Extended(purchase_order_line.unit_price*purchase_order_line.user_order_quantity
For type=Total(purchase_order_line.unit_price*purchase_order_line.user_order_quantity)*(1-purchase_order_line.trade_disc_percent/100)+purchase_order_line.fixed_charge
For type=ExtendedThe system calcualtes the sum as follows and converts to system currency:Purchase Order Entry, Lines, Purchase Price multiplied by Purchase Order Entry, Lines, Quantity
For type=TotalThe system calcualtes the sum as follows and converts to system currency:(Purchase Order Entry, Lines, Purchase Price multiplied by Purchase Order Entry, Lines, Quantity) multiplied by (1 minus Purchase Order Line, Disc % divided by 100) plus Purchase Order Entry, Lines, Fixed Charge
@currencyIDcurrency.id Currency Maintenance, ID marked as system currency.
PurchaseOrder/PurchaseOrderLine/PurchaseOrderSchedule/LineNumberpurc_line_del.del_sched_line_no Purchase Order Entry, Delivery Schedule table, Ln#
PurchaseOrder/PurchaseOrderLine/PurchaseOrderSchedule/Quantitypurc_line_del.user_order_qty Purchase Order Entry, purchase order line table, Qty
@unitCodepurc_order_line.purchase_um Purchase Order Entry, Lines, U/M
PurchaseOrder/PurchaseOrderLine/PurchaseOrderSchedule/RequiredDeliveryDateTimepurc_line_del.desired_recv_date Purchase Order Entry, Delivery Schedule table, Desired Recv Date
PurchaseOrder/PurchaseOrderLine/PurchaseOrderSchedule/ReceivedQuantity
August 13, 2009 59
PurchaseOrderpurc_line_del.received_qty Purchase Order Entry, Delivery Schedule table, Qty Received
@unitCodepurc_order_line.purchase_um Purchase Order Entry, Lines, U/M
August 13, 2009 60
QuoteQuote/QuoteHeader/DocumentID@agencyRole
Supplier
Quote/QuoteHeader/DocumentID/IDquote.id Estimating Window, Quote ID
@accountingEntityapplication_global.entity_id Application Global Maintenance, Default Mfg Entity
@locationapplication_global.entity_id Site~Application Global Maintenance, Default Mfg Entity
@lidsettings.instance_id The system combines lid://infor.visual with the value in SOA Maintenance, Visual Instance ID
Quote/QuoteHeader/LastModificationDateTime The system inserts the date it created the BOD
Quote/QuoteHeader/DocumentDateTimequote.create_date Not in Estimating Window. Information available in Quote ID browse table.
Quote/QuoteHeader/Descriptionquote.name Estimating Window, Address tab, Name
Quote/QuoteHeader/Notequote.quote_specs Estimating Window, Notes, Quote Specs
@status Open
Quote/QuoteHeader/Status/Codequote.status Estimating Window, Status box
Quote/QuoteHeader/CustomerParty/PartyIDs/IDquote.customer_id Estimating Window, Customer ID
Quote/QuoteHeader/CustomerParty/Namequote.name Estimating Window, Address tab, Name
@languageIDsettings.language_id SOA Maintenance, Lanugage ID
Quote/QuoteHeader/CustomerParty/Location/Address/AddressLinequote.addr_1quote.addr_2quote.addr_3
Estimating Window, Address tab, Street Address fields
Quote/QuoteHeader/CustomerParty/Location/Address/CityNamequote.city Estimating Window, Address Tab, City
Quote/QuoteHeader/CustomerParty/Location/Address/CountrySubDivisionCodequote.state Estimating Window, Address Tab, State
Quote/QuoteHeader/CustomerParty/Location/Address/CountrySubDivisionCode/Code@listID
Country Sub-divisions
Quote/QuoteHeader/CustomerParty/Location/Address/CountryCodequote.country Estimating Window, Address tab, Country
Quote/QuoteHeader/CustomerParty/Location/Address/CountryCode/Code@listID
Countries
Quote/QuoteHeader/CustomerParty/Location/Address/PostalCodequote.zipcode Estimating Window, Address tab, Zip
Quote/QuoteHeader/CustomerParty/Location/Address/PostalCode/Code@listID
Postal/Zip Codes
Quote/QuoteHeader/CustomerParty/Contact/Namequote.contact_first_namequote.contact_initialquote.contact_last_name
Estimating Window, Contact tab, First, MI and Last Name fields
Quote/QuoteHeader/CustomerParty/Contact/JobTitlequote.contact_position Estimating Window, Contact tab, Position
Quote/QuoteHeader/CustomerParty/Contact/Communication/UseCode/Code@listID
Communication Use Codes
August 13, 2009 61
QuoteQuote/QuoteHeader/CustomerParty/Contact/Communication/DialNumber
quote.contact_phonequote.contact_fax
Estimating Window, Contact tab, PhoneEstimating Window, Contact tab, Fax
Quote/QuoteHeader/CustomerParty/Contact/Communication/URIquote.contact_email Estimating Window, Contact tab, E-Mail
Quote/QuoteHeader/ExtendedAmountquote_price.qtyquote_price.unit_pricequote_price.trade_disc_percent
The system calculates the amount for each quote line and adds them together to derive the total amount. The system calcuates the quote line amount as follows: Estimating Window, Quote Line Item Price, Quantity multiplied by Estimating Window, Quote Line Item Price, Quoted Unit Price, multiplied by (1 minus (Estimating Window, Quote LIne Item Price, Trade Discount% divided by 100))
@currencyIDquote.currency_id Estimating Window, Other tab, Currency ID
The system converts the currency code to the ISO code using the settings in Code Mapping Maintenance
Quote/QuoteHeader/TotalAmountquote_price.qtyquote_price.unit_pricequote_price.trade_disc_percent
The system calculates the amount for each quote line and adds them together to derive the total amount. The system calcuates the quote line amount as follows: Estimating Window, Quote Line Item Price, Quantity multiplied by Estimating Window, Quote Line Item Price, Quoted Unit Price, multiplied by (1 minus (Estimating Window, Quote LIne Item Price, Trade Discount% divided by 100))
@currencyIDquote.currency_id Estimating Window, Other tab, Currency ID
The system converts the currency code to the ISO code using the settings in Code Mapping Maintenance
Quote/QuoteHeader/TransportationTerm/FrieghtTermCodequote.freight_terms Estimating Window, Other tab, Terms dialog, Freight Terms
Quote/QuoteHeader/PaymentTerm/Descriptionquote.terms_description Estimating Window, Other tab, Terms
Quote/QuoteHeader/EffectiveTimePeriod/EndDateTimequote.expiration_date Estimating Window, Dates tab, Expires
Quote/QuoteHeader/OrderCommission/SalesPerson/IDquote.salesrep_id Estimating Window, Other tab, Sales Rep
Quote/QuoteHeader/OrderCommission/SalesPerson/Namesales_rep.name Sales Reps Maintenance, Name
Quote/QuoteHeader/OrderCommission/SalesPerson/DepartmentNameemployee.department For sales reps who are employees, Employee Maintenance, Department
For sales reps who are vendors, n/a
Quote/QuoteHeader/OrderCommission/SalesPerson/Communication/DialNumberemployee.phonevendor.phone
For sales reps who are employees: Employee Maintenance, Phone For sales reps who are vendors: Vendor Maintenance, Contact tab, Phone
Quote/QuoteHeader/OrderCommission/SalesPerson/Communication/URIemployee.email_addrvendor.email_addr
For sales reps who are employees: Employee Maintenance, E-mail AddressFor sales reps who are vendors: Vendor Maintenance, Contact tab, Email Address
Quote/QuoteHeader/OrderCommission/Percentagesales_rep.commission_percentsales_rep.share_percent
If the sales rep does not share commissions, then Sales Reps Maintenance, Def Comm%.If the sales rep does share commissions, then Sales Reps Maintenance, Def Comm% prorated by the value in Sales Reps Maintenance, Commission Sharing, Share %
August 13, 2009 62
QuoteQuote/QuoteHeader/FollowUpDate
quote.followup_date Estimating Window, Dates tab, Followup
Quote/QuoteHeader/LeadTimeDurationquote.quoted_leadtime Estimating Window, Dates tab, Quoted Leadtime. The system inserts a P before the field value and a D after the field value.
Quote/QuoteHeader/ProbabilityPercentquote.win_probability Estimating Window, Dates tab, Win probability%
Quote/QuoteHeader/BaseCurrencyAmount@type
Extended, Total
Quote/QuoteHeader/BaseCurrencyAmount/AmountFor type=total and extended: (quote_price.qty*quote_price.unit_price*(1-quote_price.trade_disc_percent/100)
For type=total and extended: The system calculates the amount for each quote line and adds them together to derive the total amount. The system calcuates the quote line amount as follows: Estimating Window, Quote Line Item Price, Quantity multiplied by Estimating Window, Quote Line Item Price, Quoted Unit Price, multiplied by (1 minus (Estimating Window, Quote LIne Item Price, Trade Discount% divided by 100)) multiplied by the Sell Rate to exchange the native currency to the system currency.
@currencyIDcurrency.currency_id Exchange Rate Maintenance, Currency ID Maintenance, Currency ID marked as system currency.
Quote/QuoteLine/LineNumberquote_line.line_no Estimating Window, Lines, Line #
Quote/QuoteLine/Descriptionquote_line.description Estimating Window, Lines Description
Quote/QuoteLine/Status/Codequote.status If Estimating Window, Status=Lost, then Line Status=Lost. If Estimating Window, Status=any other status, then Line Status=
Quote@listID
Quote Status (Supplier)
Quote/QuoteLine/Status/EffectiveDateTime The system uses the date and time it generated the BOD
Quote/QuoteLine/Item/ItemID/IDquote_line.part_id Estimating Window, Lines, Part ID
Quote/QuoteLine/Item/ServiceIndicator False
Quote/QuoteLine/Quantityquote_price.qty Estimating Window, Quote line item price, Quantity
@unitCodequote_price.selling_um Estimating Window, Quote line item price, U/M
Quote/QuoteLine/UnitPrice/Amountquote_price.unit_price Estimating Window, Quote line item price, Unit Price
@currencyIDquote.currency_id Estimating Window, Other tab, Currency ID
The system converts the currency code to the ISO code using the settings in Code Mapping Maintenance
Quote/QuoteLine/UnitPrice/PerQuantity 1
Quote/QuoteLine/ExtendedAmountcalculation:quote_price.unit_price*quote_price.qty*(1-(quote_price.trade_disc_percent/100))
Equals Estimating Window, Quote line item price, Unit Price multiplied by Estimating Window, Quote line item price, Quantity multiplied by (1 minus (Estimating window, Quote line item price, Trade Discount % divided by 100))
@currencyIDquote.currency_id Estimating Window, Other tab, Currency ID
The system converts the currency code to the ISO code using the settings in Code Mapping Maintenance
Quote/QuoteLine/TotalAmountcalculation:quote_price.unit_price*quote_price.qty*(1-(quote_price.trade_disc_percent/100))
Equals Estimating Window, Quote line item price, Unit Price multiplied by Estimating Window, Quote line item price, Quantity multiplied by (1 minus (Estimating window, Quote line item price, Trade Discount % divided by 100))
@currencyIDquote.currency_id Estimating Window, Other tab, Currency ID
The system converts the currency code to the ISO code using the settings in Code Mapping Maintenance
Quote/QuoteLine/OrderCommission/SalesPerson/IDSales_Rep~sales_rep.id Sales_Rep~Sales Rep Maintenance, ID
August 13, 2009 63
QuoteQuote/QuoteLine/OrderCommission/SalesPerson/Name
sales_rep.name Sales Reps Maintenance, Name
Quote/QuoteLine/OrderCommission/SalesPerson/DepartmentNameemployee.department For sales reps who are employees, Employee Maintenance, Department
For sales reps who are vendors, n/a
Quote/QuoteLine/OrderCommission/SalesPerson/Communication 1: phone
2: email
Quote/QuoteLine/OrderCommission/SalesPerson/Communication/UseCode Communication Use Codes
Quote/QuoteLine/OrderCommission/SalesPerson/Communication/UseCode/Code@listID
Phone
Quote/QuoteLine/OrderCommission/SalesPerson/Communication/DialNumberemployee.phonevendor.phone
For sales reps who are employees: Employee Maintenance, Phone For sales reps who are vendors: Vendor Maintenance, Contact tab, Phone
Quote/QuoteLine/OrderCommission/SalesPerson/Communication/URIemployee.email_addrvendor.email_addr
For sales reps who are employees: Employee Maintenance, E-mail AddressFor sales reps who are vendors: Vendor Maintenance, Contact tab, Email Address
Quote/QuoteLine/OrderCommission/Percentagesales_rep.commission_percentsales_rep.share_percent
If the sales rep does not share commissions, then Sales Reps Maintenance, Def Comm%.If the sales rep does share commissions, then Sales Reps Maintenance, Def Comm% prorated by the value in Sales Reps Maintenance, Commission Sharing, Share %
Quote/QuoteLine/QuoteSubline/LineNumber The first subline=1. The system increases the subline number by 1 for each subsequent subline
Quote/QuoteLine/BaseCurrencyAmount@type
Extended, Total
Quote/QuoteLine/BaseCurrencyAmount/AmountFor type=total and extended: (quote_price.qty*quote_price.unit_price*(1-quote_price.trade_disc_percent/100)
For type=total and extended: The system calcuates the quote line amount as follows: Estimating Window, Quote Line Item Price, Quantity multiplied by Estimating Window, Quote Line Item Price, Quoted Unit Price, multiplied by (1 minus (Estimating Window, Quote LIne Item Price, Trade Discount% divided by 100)) multiplied by the Sell Rate to exchange the native currency to the system currency.
@currencyIDcurrency.currency_id Exchange Rate Maintenance, Currency ID Maintenance, Currency ID marked as system currency.
Quote/QuoteHeader/DocumentID@agencyRole
Supplier
Quote/QuoteHeader/DocumentID/IDv_quote.id Quote, Quote ID
@accountingEntityapplication_global.entity_id Application Global Maintenance, Default Mfg Entity
@locationsettings.location_id SOA Maintenance, Location ID
@lidsettings.instance_id The system combines lid://infor.visual with the value in SOA Maintenance, Visual Instance ID
August 13, 2009 64
QuoteQuote/QuoteHeader/LastModificationDateTime
The system inserts the date it created the BOD
Quote/QuoteHeader/DocumentDateTimev_quote.create_date
Quote/QuoteHeader/Descriptionv_account.name Account, Name
Quote/QuoteHeader/Note Quote, Specifications
@status Open
Quote/QuoteHeader/Status/Code R
Quote/QuoteHeader/CustomerParty/PartyIDs/IDv_quote.customer_id Quote, Quote ID
Quote/QuoteHeader/CustomerParty/Namev_quote.name Estimating Window, Address tab, Name
@languageIDsettings.language_id SOA Maintenance, Language ID
Quote/QuoteHeader/CustomerParty/Location/Address/AddressLinev_quote.addr_1v_quote.addr_2v_quote.addr_3
Quote, Address, Sold To Address
Quote/QuoteHeader/CustomerParty/Location/Address/CityNamev_quote.city Quote, Address, Sold To Address
Quote/QuoteHeader/CustomerParty/Location/Address/CountrySubDivisionCodev_quote.state Quote, Address, Sold To Address
Quote/QuoteHeader/CustomerParty/Location/Address/CountrySubDivisionCode/Code@listID
CountrySubDivision. The system gets the listID name from Code Mapping Maintenance.
Quote/QuoteHeader/CustomerParty/Location/Address/CountryCodev_quote.country Quote, Address, Sold To Address
Quote/QuoteHeader/CustomerParty/Location/Address/CountryCode/Code@listID
CountryCode. The system gets the listID name from Code Mapping Maintenance.
Quote/QuoteHeader/CustomerParty/Location/Address/PostalCodev_quote.zipcode Quote, Address, Sold To Address
Quote/QuoteHeader/CustomerParty/Location/Address/PostalCode/Code@listID
PostalCode. The system gets the listID name from Code Mapping Maintenance.
Quote/QuoteHeader/CustomerParty/Contact/Namev_contact.contact_first_namev_contact.contact_initialv_contact.contace_last_name
Contact, Name fields
Quote/QuoteHeader/CustomerParty/Contact/JobTitlev_contact.contact_position Contact, General tab, Position
Quote/QuoteHeader/CustomerParty/Contact/Communication/UseCode/Code@listID
CommunicationUseCode. The system gets the listID name from Code Mapping Maintenance.
Quote/QuoteHeader/CustomerParty/Contact/Communication/DialNumberv_contact.bus_phonev_contact.fax_phone
Contact, General tab, Bus PhoneEstimating Window, Contact tab, Fax
Quote/QuoteHeader/CustomerParty/Contact/Communication/URIv_contact.email_addr Contact, General tab, E-Mail
Quote/QuoteHeader/ExtendedAmountv_quote_line.qtyv_quote_line.unit_pricev_quote_line.cust_disc_percent
The system calculates each line as follows and adds the sums from each line to derive the total:Quote, Line Items, Qty multiplied by Quote, Line Items, Unit Price multiplied by (1 minus (Quote, Line Items, Disc%/100))
@currencyIDv_quote.currency_id Quote, Details tab, Currency ID. The system converts the currency code to the iSO code using the settings in Code Mapping
August 13, 2009 65
QuoteMaintenance.
Quote/QuoteHeader/TotalAmountv_quote_line.qtyv_quote_line.unit_pricev_quote_line.cust_disc_percent
The system calculates each line as follows and adds the sums from each line to derive the total:Quote, Line Items, Qty multiplied by Quote, Line Items, Unit Price multiplied by (1 minus (Quote, Line Items, Disc%/100))
@currencyIDv_quote.currency_id Quote, Details tab, Currency ID. The system converts the currency code to the iSO code using the settings in Code Mapping
Maintenance.
Quote/QuoteHeader/TransportationTerm/FrieghtTermCodev_quote.frt_terms Quote, Details tab, Terms dialog, Freight Terms
Quote/QuoteHeader/PaymentTerm/Descriptionv_quote.terms_description Quote, Details tab, Terms
Quote/QuoteHeader/EffectiveTimePeriod/EndDateTimev_quote.expiration_date Quote, General tab, Effective end date
Quote/QuoteHeader/OrderCommission/SalesPerson/IDv_quote.salesrep_id Quote, General tab, Sales Rep
Quote/QuoteHeader/OrderCommission/SalesPerson/Namesales_rep.name Sales Reps Maintenance (VE), Name
Quote/QuoteHeader/OrderCommission/SalesPerson/DepartmentNameemployee.department For sales reps who are employees, Employee Maintenance (VE), Department
For sales reps who are vendors, n/a
Quote/QuoteHeader/OrderCommission/SalesPerson/Communication/DialNumberemployee.phonevendor.phone
For sales reps who are employees: Employee Maintenance (VE), Phone For sales reps who are vendors: Vendor Maintenance (VE), Contact tab, Phone
Quote/QuoteHeader/OrderCommission/SalesPerson/Communication/URIemployee.email_addrvendor.email_addr
For sales reps who are employees: Employee Maintenance (VE), E-mail AddressFor sales reps who are vendors: Vendor Maintenance (VE), Contact tab, Email Address
Quote/QuoteHeader/OrderCommission/Percentagesales_rep.commission_percentsales_rep.share_percent
If the sales rep does not share commissions, then Sales Reps Maintenance (VE), Def Comm%.If the sales rep does share commissions, then Sales Reps Maintenance (VE), Def Comm% prorated by the value in Sales Reps Maintenance, Commission Sharing, Share %
Quote/QuoteHeader/FollowUpDatev_quote.follow_up_date
Quote/QuoteHeader/LeadTimeDurationv_quote.quoted_leadtime Quote, General tab, Leadtime
Quote/QuoteHeader/BaseCurrencyAmount@type
Extended, Total
Quote/QuoteHeader/BaseCurrencyAmount/AmountFor type=extended and total:v_quote_line.qtyv_quote_line.unit_pricev_quote_line.cust_disc_percent
The system calculates each line as follows and adds the sums from each line to derive the total:Quote, Line Items, Qty multiplied by Quote, Line Items, Unit Price multiplied by (1 minus (Quote, Line Items, Disc%/100))
@currencyIDcurrency.currency_id Exchange Rate Maintenance (VE), Currency Maintenance, Currency ID marked as system currency.
August 13, 2009 66
QuoteQuote/QuoteLine/LineNumber
quote_line.line_no Estimating Window (VE), Lines, Line #
Quote/QuoteLine/Descriptionquote_line.description Estimating Window (VE), Lines Description
Quote/QuoteLine/Status/Code R
@listID QuoteStatus. The system gets the listID name from Code Mapping Maintenance.
Quote/QuoteLine/Status/EffectiveDateTime The system uses the date and time it generated the BOD
Quote/QuoteLine/Item/ServiceIndicator False
Quote/QuoteLine/Quantityv_quote_line.qty Quote, Line Items, Qty
@unitCodev_quote_line.selling_um Quote, Line Items, U/M
Quote/QuoteLine/UnitPrice/Amountv_quote_line.unit_price Quote, Line Items, Unit Price
@currencyIDv_quote.currency_id Quote, Details tab, Currency ID. The system converts the currency code to the iSO code using the settings in Code Mapping
Maintenance.
Quote/QuoteLine/UnitPrice/PerQuantity 1
Quote/QuoteLine/ExtendedAmountv_quote_line.qtyv_quote_line.unit_pricev_quote_line.cust_disc_percent
The system calculates each line as follows:Quote, Line Items, Qty multiplied by Quote, Line Items, Unit Price multiplied by (1 minus (Quote, Line Items, Disc%/100))
@currencyIDv_quote.currency_id Quote, Details tab, Currency ID. The system converts the currency code to the iSO code using the settings in Code Mapping
Maintenance.
Quote/QuoteLine/TotalAmountv_quote_line.qtyv_quote_line.unit_pricev_quote_line.cust_disc_percent
The system calculates each line as follows:Quote, Line Items, Qty multiplied by Quote, Line Items, Unit Price multiplied by (1 minus (Quote, Line Items, Disc%/100))
@currencyIDv_quote.currency_id Quote, Details tab, Currency ID. The system converts the currency code to the iSO code using the settings in Code Mapping
Maintenance.
Quote/QuoteLine/OrderCommission/SalesPerson/IDSales_Rep~sales_rep.id Sales_Rep~Sales Rep Maintenance, ID
Quote/QuoteLine/OrderCommission/SalesPerson/Namesales_rep.name Sales Reps Maintenance, Name
Quote/QuoteLine/OrderCommission/SalesPerson/DepartmentNameemployee.department For sales reps who are employees, Employee Maintenance, Department
For sales reps who are vendors, n/a
Quote/QuoteLine/OrderCommission/SalesPerson/Communication 1: phone
2: email
Quote/QuoteLine/OrderCommission/SalesPerson/Communication/UseCode Communication Use Codes
Quote/QuoteLine/OrderCommission/SalesPerson/Communication/UseCode/Code@listID
Phone
Quote/QuoteLine/OrderCommission/SalesPerson/Communication/DialNumberemployee.phonevendor.phone
For sales reps who are employees: Employee Maintenance, Phone For sales reps who are vendors: Vendor Maintenance, Contact tab, Phone
Quote/QuoteLine/OrderCommission/SalesPerson/Communication/URIemployee.email_addrvendor.email_addr
For sales reps who are employees: Employee Maintenance, E-mail AddressFor sales reps who are vendors: Vendor Maintenance, Contact tab, Email Address
Quote/QuoteLine/OrderCommission/Percentagesales_rep.commission_percent If the sales rep does not share commissions, then Sales Reps Maintenance, Def Comm%.
August 13, 2009 67
Quotesales_rep.share_percent If the sales rep does share commissions, then Sales Reps Maintenance, Def Comm% prorated by the value in Sales Reps
Maintenance, Commission Sharing, Share %
Quote/QuoteLine/QuoteSubline/LineNumber The first subline=1. The system increases the subline number by 1 for each subsequent subline
Quote/QuoteLine/BaseCurrencyAmount@type
Extended, Total
Quote/QuoteLine/BaseCurrencyAmount/AmountFor type=extended and total:v_quote_line.qtyv_quote_line.unit_pricev_quote_line.cust_disc_percent
For type=extended and total: The system calculates each line as follows:Quote, Line Items, Qty multiplied by Quote, Line Items, Unit Price multiplied by (1 minus (Quote, Line Items, Disc%/100)). The system converts the amount to the system currency based on the exchange rate.
@currencyID Exchange Rate Maintenance (VE), Currency Maintenance, Currency ID marked as system currency.
August 13, 2009 68
RFQRFQ/RFQHeader/DocumentID@agencyRole
Supplier, Customer
RFQ/RFQHeader/DocumentID/IDrequest_for_quote.idrfq_vendor.vendor_id
Vendor RFQ Entry, Request ID ~ Vendor RFQ Entry, Vendor Quote, Vendor ID
@accountingEntityapplication_global.mfg_entity Application Global Maintenance, Default Mfg Entity
@locationsettings.location_id SOA Maintenance, SOA Location
@lidsettings.instance_id The system combines lid://infor.visual with the value in SOA Maintenance, Visual Instance ID
RFQ/RFQHeader/LastModificationDateTime The system inserts the date and time it created the BOD.
RFQ/RFQHeader/DocumentDateTimerequest_for_quote.create_date Does not appear in the Vendor RFQ Entry window. Available in Request ID browse.
RFQ/RFQHeader/Note Vendor RFQ Entry, RFQ Notations
RFQ/RFQHeader/Status/Coderequest_for_quote.status Vendor RFQ Entry, Status
If VISUAL status = Cancelled/Void, then status = LostIf VISUAL Status = Closed and Vendor RFQ Entry, Vendor Quote, Status = Accepted, then status = Processed. Otherwise, Status = Lost.In all other cases, status = Open
@listID RFQ Status (Customer)
RFQ/RFQHeader/Status/Descriptionrequest_for_quote.status If Vendor RFQ Entry, Status is Active, then RFQStatus=Working
If Vendor RFQ Entry, Status is Closed, then RFQStatus=LostIf Vendor RFQ Entry, Status is Cancelled, then RFQStatus=Cancelled
RFQ/RFQHeader/Status/EffectiveDateTimerequest_for_quote.status_eff_dateDoes not appear in the Vendor RFQ Entry window. Available in Request ID browse.
RFQ/RFQHeader/CustomerParty/Location/Nameapplication_global.company_name
Application Global Maintenance, Name
RFQ/RFQHeader/CustomerParty/Location/Address/AddressLineapplication_global.company_addr1application_global.company_addr2application_global.company_addr3
Application Global Maintenance, Street Address fields
@sequence1: application_global.company_addr12: application_global.company_addr23: application_global.company_addr3
Application Global Maintenance, Street Address fields
RFQ/RFQHeader/CustomerParty/Location/Address/CityNameapplication_global.company_city Application Global Maintenance, City
RFQ/RFQHeader/CustomerParty/Location/Address/CountrySubDivisionCodeapplication_global.company_state Application Global Maintenance, State
RFQ/RFQHeader/CustomerParty/Location/Address/CountryCodeapplication_global.company_country
Application Global Maintenance, Country
RFQ/RFQHeader/CustomerParty/Location/Address/PostalCodeapplication_global.company_zipcode
Application Global Maintenance, Zip
RFQ/RFQHeader/CustomerParty/BuyerContact/Namerequest_for_quote.buyer Vendor RFQ Entry, Buyer
August 13, 2009 69
RFQRFQ/RFQHeader/CustomerParty/BuyerContact/DepartmentName
employee.department_id Employee Maintenance, Department ID for Employee ID inserted in Vendor RFQ Maintenance, Buyer
RFQ/RFQHeader/SupplierParty/PartyIDs/IDrfq_vendor.vendor_id Vendor RFQ Entry, Vendor Quote, Vendor ID
RFQ/RFQHeader/SupplierParty/Namevendor.name Vendor Maintenance, Name
@languageIDsettings.language_id SOA Maintenance, Language ID
RFQ/RFQHeader/SupplierParty/Location/Namevendor.name Vendor Maintenance, Name
RFQ/RFQHeader/SupplierParty/Location/Address/AddressLinerfq_vendor.addr_1rfq_vendor.addr_2rfq_vendor.addr_3
Vendor RFQ Entry, Address tab, Street Address fields
@sequence1: rfq_vendor.addr_12: rfq_vendor.addr_23: rfq_vendor.addr_3
Vendor RFQ Entry, Address tab, Street Address fields
RFQ/RFQHeader/SupplierParty/Location/Address/CityNamerfq_vendor.city Vendor RFQ Entry, Address tab, City
RFQ/RFQHeader/SupplierParty/Location/Address/CountrySubDivisionCoderfq_vendor.state Vendor RFQ Entry, Address tab, State
RFQ/RFQHeader/SupplierParty/Location/Address/CountryCoderfq_vendor.country Vendor RFQ Entry, Address tab, Country
RFQ/RFQHeader/SupplierParty/Location/Address/PostalCoderfq_vendor.zipcode Vendor RFQ Entry, Address tab, Zip
RFQ/RFQHeader/SupplierParty/Contact/Namerfq_vendor.contact_first_namerfq_vendor.contact_initialrfq_vendor.contact_last_name
Vendor RFQ Entry, Contact tab, Contact
RFQ/RFQHeader/SupplierParty/Contact/JobTitlerfq_vendor.contact_position Vendor RFQ Entry, Contact tab, Position
RFQ/RFQHeader/SupplierParty/Contact/Communication/UseCode Phone, Fax
RFQ/RFQHeader/SupplierParty/Contact/Communication/DialNumberrfq_vendor.contact_phonerfq_vendor.contact_fax
Vendor RFQ Entry, Contact tab, PhoneVendor RFQ Entry, Contact tab, Fax
RFQ/RFQHeader/ShipToParty/PartyIDs/IDrequest_for_quote.warehouse_id Vendor RFQ Entry, Warehouse ID
RFQ/RFQHeader/ShipToParty/Location/Namewarehouse_address.name Warehouse Maintenance, Warehouse Address, Name
RFQ/RFQHeader/ShipToParty/Location/Address/AddressLinewarehouse_address.addr_1warehouse_address.addr_2warehouse_address.addr_3
Warehouse Maintenance, Warehouse Address, Address fields
RFQ/RFQHeader/ShipToParty/Location/Address/CityNamewarehouse_address.city Warehouse Maintenance, Warehouse Address, City
RFQ/RFQHeader/ShipToParty/Location/Address/CountrySubDivisionCodewarehouse_address.state Warehouse Maintenance, Warehouse Address, State
August 13, 2009 70
RFQRFQ/RFQHeader/ShipToParty/Location/Address/CountryCode
warehouse_address.country Warehouse Maintenance, Warehouse Address, Country
RFQ/RFQHeader/ShipToParty/Location/Address/PostalCodewarehouse_address.zipcode Warehouse Maintenance, Warehouse Address, Zip
RFQ/RFQHeader/BillToParty/Namecustomer.bill_to_name Customer Maintenance, Bill to Name
@languageIDsettings.language_id SOA Maintenance, Language ID
RFQ/RFQHeader/BillToParty/Location/Address/AddressLinecustomer.bill_to_addr_1customer.bill_to_addr_2customer.bill_to_addr_3
Customer Maintenance, Bill to Address fields
@sequence1: customer.bill_to_addr_12: customer.bill_to_addr_23: customer.bill_to_addr_3
Customer Maintenance, Bill to Address fields
RFQ/RFQHeader/BillToParty/Location/Address/CityNamecustomer.bill_to_city Customer Maintenance, Bill to City
RFQ/RFQHeader/BillToParty/Location/Address/CountrySubDivisionCodecustomer.bill_to_state Customer Maintenance, Bill to State
@listID Country Sub-divisions
RFQ/RFQHeader/BillToParty/Location/Address/CountryCodecustomer.bill_to_country Customer Maintenance, Bill to Country
@listID Countries
RFQ/RFQHeader/BillToParty/Location/Address/PostalCodecustomer.bill_to_zipcode Customer Maintenance, Bill to Zipcode
@listID Postal/Zip Codes
RFQ/RFQHeader/PaymentTerm/Descriptionvendor.terms_net_typevendor.terms_net_daysvendor.terms_net_datevendor.terms_disc_typevendor.terms_disc_daysvendor.terms_disc_datevendor.terms_disc_percentvendor.terms_description
Vendor Maintenance, Accounting tab, Terms
@languageIDsettings.language_id SOA Maintenance, Language ID
RFQ/RFQHeader/BuyerParty/Location@type
Site
RFQ/RFQHeader/BuyerParty/Location/IDsettings.location_id Site~SOA Maintenance, Location ID
@schemeName System
@schemeAgencyIDsettings.visual_instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID
RFQ/RFQHeader/BuyerParty/Location/Nameapplication_global.company_name
Application Global Maintenance, Name
RFQ/RFQHeader/BuyerParty/Location/Address/AddressLineapplication_global.company_addr1application_global.company_addr2application_global.company_addr3
Application Global Maintenance, Street Address fields
@sequence
August 13, 2009 71
RFQ1: application_global.company_addr12: application_global.company_addr23: application_global.company_addr3
Application Global Maintenance, Street Address fields
RFQ/RFQHeader/BuyerParty/Location/Address/CityNameapplication_global.company_city Application Global Maintenance, City
RFQ/RFQHeader/BuyerParty/Location/Address/CountrySubDivisionCodeapplication_global.company_state Application Global Maintenance, State
@listID Country Sub-divisions
RFQ/RFQHeader/BuyerParty/Location/Address/CountryCodeapplication_global.company_country
Application Global Maintenance, Country
@listID Countries
RFQ/RFQHeader/BuyerParty/Location/Address/PostalCodeapplication_global.company_zipcode
Application Global Maintenance, Zip
@listID Postal/Zip Codes
RFQ/RFQHeader/EffectiveTimePeriod/StartDateTimerfq_vendor.quoted_date Vendor RFQ Entry, Vendor Quote, Quote date
RFQ/RFQHeader/EffectiveTimePeriod/EndDateTimerfq_vendor.expiration_date
RFQ/RFQHeader/BaseCurrencyAmount@type
ExtendedAmount, TotalAmount
RFQ/RFQHeader/BaseCurrencyAmount/Amountrfq_vendor_quote.default_unit_price
Vendor RFQ Entry, Vendor Quote, Default Unit Price. If the default unit price is not in the system currency, the system converts the currency amount to the system currency based on the exchange rate in effect on the date of the vendor quote.
@currencyIDcurrency.currency_id Exchange Rate Maintenance, Currency Maintenance, Currency ID marked as system currency
RFQ/RFQLine/LineNumberrfq_line.line_no Vendor RFQ Entry, Lines, Ln#
RFQ/RFQLine/Descriptionrfq_line.description Vendor RFQ Entry, Lines, Description
@languageIDsettings.language_id SOA Maintenance, Language ID
RFQ/RFQLine/Status/Coderfq_vendor_quote.quote_status Vendor RFQ Entry, Vendor Quote, Status
The system translates VISUAL codes as follows: If Vendor RFQ Entry, Status is Active and Vendor RFQ Entry, Vendor Quote, Status is Printed, then status=Working.If Vendor RFQ Entry, Status is Active and Vendor RFQ Entry, Vendor Quote, Status not printed, then status=Unapproved.If Vendor RFQ Entry, Status is Closed and Vendor RFQ Entry, Vendor Quote, Status is Approved, then status=Converted.If Vendor RFQ Entry, Status is Closed and Vendor RFQ Entry, Vendor Quote, Status is not Approved, then status=Rejected.If Vendor RFQ Entry, Status is Cancelled, then status=Rejected.
@listID RFQ Status (Customer)
RFQ/RFQLine/Status/EffectiveDateTimerfq_vendor_quote.status_eff_date
August 13, 2009 72
RFQRFQ/RFQLine/Item/ItemID/ID
rfq_line.part_idrfq_line.service_id
Vendor RFQ Entry, Lines, Part IDVendor RFQ Entry, Lines, Service ID
RFQ/RFQLine/Item/ServiceIndicatorrfq_line.service_id If Vendor RFQ Entry, Lines, Service ID is populated, then serviceindicator=true. If it is blank, then serviceindicator=false.
RFQ/RFQLine/Item/Descriptionpart.descriptionservice.description
Part Maintenance, DescriptionOutside Service Maintenance, Description
@languageIDsettings.language_id SOA Maintenance, Language ID
RFQ/RFQLine/Quantity 1
RFQ/RFQLine/UnitPrice/Amountrfq_vendor_quote.default_unit_price
Vendor RFQ Entry, Vendor Quote, Default Unit Price. If the default unit price is not in the system currency, the system converts the currency amount to the system currency based on the exchange rate in effect on the date of the vendor quote.
@currencyIDrfq_vendor_quote.rvq_currency_idVendor RFQ Entry, Vendor Quote. Displays at bottom of dialog box.
RFQ/RFQLine/UnitPrice/PerQuantity 1
@unitCoderfq_vendor_quote.rvq_purchase_um
Vendor RFQ Entry, Vendor Quote, Purchase U/M
RFQ/RFQLine/ExtendedAmountcalculation:rfq_vendor_quote.unit_price_1*rfq_vendor_quote.qty_break_1
Vendor RFQ Entry, Vendor Quote, Up to 1 Quantity multiplied by Vendor RFQ Entry, Vendor Quote, Up to 1 Price
@currencyIDrfq_vendor_quote.rvq_purchase_um
Vendor RFQ Entry, Vendor Quote, Purchase U/M
RFQ/RFQLine/TotalAmountcalculation:rfq_vendor_quote.unit_price_1*rfq_vendor_quote.qty_break_1
Vendor RFQ Entry, Vendor Quote, Up to 1 Quantity multiplied by Vendor RFQ Entry, Vendor Quote, Up to 1 Price
@currencyIDrfq_vendor_quote.rvq_purchase_um
Vendor RFQ Entry, Vendor Quote, Purchase U/M
RFQ/RFQLine/ShipToParty/PartyIDs/IDrfq_line.warehouse_id Vendor RFQ Entry, Lines, Warehouse ID
RFQ/RFQLine/ShipToParty/Location/Namewarehouse_address.name Warehouse Maintenance, Warehouse Address, Name
RFQ/RFQLine/ShipToParty/Location/Address/AddressLinewarehouse_address.addr_1warehouse_address.addr_2warehouse_address.addr_3
Warehouse Maintenance, Warehouse Address, Address fields
@sequence1: warehouse_address.addr_12: warehouse_address.addr_23: warehouse_address.addr_3
Warehouse Maintenance, Warehouse Address, Address fields
RFQ/RFQLine/ShipToParty/Location/Address/CityNamewarehouse_address.city Warehouse Maintenance, Warehouse Address, City
RFQ/RFQLine/ShipToParty/Location/Address/CountrySubDivisionCodewarehouse_address.state Warehouse Maintenance, Warehouse Address, State
RFQ/RFQLine/ShipToParty/Location/Address/CountryCodewarehouse_address.country Warehouse Maintenance, Warehouse Address, Country
RFQ/RFQLine/ShipToParty/Location/Address/PostalCodewarehouse_address.zipcode Warehouse Maintenance, Warehouse Address, Zip
RFQ/RFQLine/BuyerParty/Location@type
Site
RFQ/RFQLine/BuyerParty/Location/ID
August 13, 2009 73
RFQsettings.location_id Site~SOA Maintenance, Location ID
RFQ/RFQLine/BuyerParty/Location/Nameapplication_global.company_name
Application Global Maintenance, Name
RFQ/RFQLine/BuyerParty/Location/Address/AddressLineapplication_global.company_addr1application_global.company_addr2application_global.company_addr3
Application Global Maintenance, Street Address fields
@sequence1: application_global.company_addr12: application_global.company_addr23: application_global.company_addr3
Application Global Maintenance, Street Address fields
RFQ/RFQLine/BuyerParty/Location/Address/CityNameapplication_global.company_city Application Global Maintenance, City
RFQ/RFQLine/BuyerParty/Location/Address/CountrySubDivisionCodeapplication_global.company_state Application Global Maintenance, State
RFQ/RFQLine/BuyerParty/Location/Address/CountryCodeapplication_global.company_country
Application Global Maintenance, Country
RFQ/RFQLine/BuyerParty/Location/Address/PostalCodeapplication_global.company_zipcode
Application Global Maintenance, Zip
RFQ/RFQLine/BuyerParty/BuyerContact/Namecalculation:employee.first_name+employee.middle_initial+employee.last_name
Employee Maintenance, First Name+Employee Maintenance, MI+Employee Maintenance, Last Name for Employee ID inserted in Vendor RFQ Maintenance, Buyer
RFQ/RFQLine/BuyerParty/BuyerContact/DepartmentNameemployee.department_id Employee Maintenance, Department ID for Employee ID inserted in Vendor RFQ Maintenance, Buyer
RFQ/RFQLine/RequisitionReference/DocumentID/IDpurc_rfq_req.purc_req_id Vendor RFQ Entry, Show RFQ Requisitions, Requisition ID
August 13, 2009 74
ReceivableTransactionReceivableTransaction/ReceivableTransactionHeader/DocumentID/ID
receivable.invoice_id Receivable Invoice Entry, Invoice ID@accountingEntity
application_global.entity_id Application Global Maintenance, Default Mfg Entity@location
settings.location_id SOA Maintenance, SOA Location@lid
settings.instance_id The system combines lid://infor.visual with the value in SOA Maintance, Visual Instance ID
ReceivableTransaction/ReceivableTransactionHeader/LastModificationDateTime The system uses the date and time it created the BOD.
ReceivableTransaction/ReceivableTransactionHeader/DocumentDateTimereceivable.create_date
ReceivableTransaction/ReceivableTransactionHeader/Status/Codereceivable.statusreceivable.paid_amountreceivable.total_amountreceivable.zero_datereceivable.void_datereceivable.type
The system calculates the status as follows:Open = receivable.status ='A' and receivable.paid_amount = 0 receivable.zero_date is null. Fields are not displayed in Receivables Invoice Entry window. Available in Invoice ID browse table.Paid=receivable.status = 'A' and Receivable Invoice Entry, Paid to Date and receivable.zero_date are not null, and Receivable Invoice Entry, Invoice Total equals Receivable Invoice Entry, Paid to Date. Receivable.status and receivable.zero_date are not displayed in Receivables Invoice Entry window. Available in Invoice ID browse table.PartialPaid = receivable.status = 'A' and Receivables Invoice Entry, Paid to Date does not equal zero and receivable.zero_date is null and Receivables Invoice Entry, Invoice Total does not equal Receivables Invoice Entry, Paid to Date. Receivable.status and receivable.zero_date are not displayed in Receivables Invoice Entry window. Available in Invoice ID browse table.Unapplied Cash = Receivables Invoice Entry, Type = 'U' and Receivables Invoice Entry, Invoice Total does not equal Receivables Invoice Entry, Paid to Date and receivable.zero_date is null. Receivable.zero_date is not displayed in Receivables Invoice Entry window. Available in Invoice ID browse table.Late = Receivables Invoice Entry, Invoice Total does not equal Receivables Invoice Entry, Paid to DateVoid = Receivable.type=Void
ReceivableTransaction/ReceivableTransactionHeader/Status/EffectiveDateTimereceivable.zero_datereceivable.create_datereceivable.last_paid_date
If status is Paid, then status effective date is receivable.zero_date. Field is not displayed in Receivables Invoice Entry window. Available in Invoice ID browse table.If status is PartialPaid, then status effective date is receivable.last_paid_date. Field is not displayed in Receivables Invoice Entry window. Available in Invoice ID browse table.For all other statuses, status effective date is receivable.create_date. Field is not displayed in Receivable Invoice Entry window. Available in Invoice ID browse table.
ReceivableTransaction/ReceivableTransactionHeader/Status/ReasonCodereceivable.status If receivable status meets the criteria for WriteOff, then ReasonCode is BD
@listID ReasonCode
ReceivableTransaction/ReceivableTransactionHeader/Status/Reason If receivable status meets the criteria for WriteOff, then Reason is Bad Debt
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/PartyIDs/IDreceivable.customer_id Receivable Invoice Entry, Customer ID field
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/PartyIDs/TaxIDcustomer.tax_id_number Customer Maintenance, Accounting tab, Tax ID Number
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/Namecustomer.name Customer Maintenance, Customer Name
@languageIDcustomer. bill_language_id Customer Maintenance, Language Forms tab, Language ID (Bill to)
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/Location/IDcustomer.id Customer Maintenance, Customer ID
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/Location/Namecustomer.bill_to_name Customer Maintenance, Bill To Customer Name
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/Location/Address/AttentionOfNamecustomer.bill_to_namecustomer.name
Customer Maintenance, Bill To Customer Name. If Blank, then Customer Maintenance, Customer Name.
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/Location/Address/AddressLinecustomer.bill_to_addr_1customer.bill_to_addr_2customer.bill_to_addr_3 orcustomer.addr1
Customer Maintenance, Bill To Street Address fields. If Bill to Street Address fields are blank, Sold To Street Address fields.
August 13, 2009 75
ReceivableTransactioncustomer.addr2customer.addr3
@sequence1: customer.bill_to_addr12: customer.bill_to_addr23: customer.bill_to_addr3
Customer Maintenance, Bill To Street Address fields
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/Location/Address/CityNamecustomer.bill_to_citycustomer.city
Customer Maintenance, Bill To City. If blank, then Sold To City.
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/Location/Address/CountrySubDivisionCodecustomer.bill_to_statecustomer.state
Customer Maintenance, Bill To State. If blank, then Sold To State.
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/Location/Address/CountryCodecustomer.bill_to_countrycustomer.country
Customer Maintenance, Bill To Country. If blank, then Sold To Country.
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/Location/Address/PostalCodecustomer.bill_to_zipcodecustomer.zipcode
Customer Maintenance, Bill To Zip. If blank, then Sold To Zip.
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/Contact/Namecustomer.contact_hornorificcustomer.contact_first_namecustomer.contact_initialcustomer.contact_last_name
Customer Maintenance, Contact tab, Contact fields
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/Contact/JobTitlecustomer.contact_position Customer Maintenance, Contact tab, Position/Salutation
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/Contact/Communication/DialNumbercustomer.contact_phone Customer Maintenance, Contact tab, Phone
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/RequesterContact/Namecustomer_order.contact_honorificcustomer_order.contact_first_namecustomer_order_contact_initialcustomer_order.contact_last_name
Customer Order Entry, Contact tab, Contact fields
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/RequesterContact/JobTitlecustomer_order.contact_position Customer Order Entry, Contact tab, Pos/Sal
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/RequesterContact/Communication/DialNumbercustomer_order.contact_phone Customer Order Entry, Contact tab, Phone
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/BuyerContact/Namecustomer_order.contact_honorificcustomer_order.contact_first_namecustomer_order_contact_initialcustomer_order.contact_last_name
Customer Order Entry, Contact tab, Contact fields
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/BuyerContact/JobTitlecustomer_order.contact_position Customer Order Entry, Contact tab, Pos/Sal
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/BuyerContact/Communication/DialNumbercustomer_order.contact_phone Customer Order Entry, Contact tab, Phone
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/ReceivingContact/Namecustomer_order.contact_honorificcustomer_order.contact_first_namecustomer_order_contact_initialcustomer_order.contact_last_name
Customer Order Entry, Contact fields
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/ReceivingContact/JobTitlecustomer_order.contact_position Customer Order Entry, Pos/Sal
ReceivableTransaction/ReceivableTransactionHeader/CustomerParty/ReceivingContact/Communication/DialNumbercustomer_order.contact_phone Customer Order Entry, Contact tab, Phone
August 13, 2009 76
ReceivableTransactionReceivableTransaction/ReceivableTransactionHeader/BillToParty/PartyIDs/ID
receivable.customer_id Receivable Invoice Entry, Customer ID
ReceivableTransaction/ReceivableTransactionHeader/BillToParty/PartyIDs/TaxIDcustomer.tax_id_number Customer Maintenance, Accounting tab, Tax ID Number
ReceivableTransaction/ReceivableTransactionHeader/BillToParty/Namecustomer.bill_to_name Customer Maintenance, Bill to Customer Name; If Bill to Customer Name.
ReceivableTransaction/ReceivableTransactionHeader/BillToParty/Location/IDcustomer.id Customer Maintenance, Customer ID
August 13, 2009 77
ReceivableTransactionReceivableTransaction/ReceivableTransactionHeader/BillToParty/Location/Name
customer.bill_to_name Customer Maintenance, Bill To Customer Name
ReceivableTransaction/ReceivableTransactionHeader/BillToParty/Location/Address/AttentionOfNamecustomer.bill_to_name Customer Maintenance, Bill To Customer Name
ReceivableTransaction/ReceivableTransactionHeader/BillToParty/Location/Address/AddressLinecustomer.bill_to_addr_1customer.bill_to_addr_2customer.bill_to_addr_3
Customer Maintenance, Bill To Street Address fields
@sequence1: customer.bill_to_addr_12: customer.bill_to_addr_23: customer.bill_to_addr_3
Customer Maintenance, Bill To Street Address fields
ReceivableTransaction/ReceivableTransactionHeader/BillToParty/Location/Address/CityNamecustomer.bill_to_city Customer Maintenance, Bill To City
ReceivableTransaction/ReceivableTransactionHeader/BillToParty/Location/Address/CountrySubDivisionCodecustomer.bill_to_state Customer Maintenance, Bill To State
ReceivableTransaction/ReceivableTransactionHeader/BillToParty/Location/Address/CountryCodecustomer.bill_to_country Customer Maintenance, Bill To Country
ReceivableTransaction/ReceivableTransactionHeader/BillToParty/Location/Address/PostalCodecustomer.bill_to_zipcode Customer Maintenance, Bill To Zip
ReceivableTransaction/ReceivableTransactionHeader/BillToParty/Contact/Namecustomer.contact_hornorificcustomer.contact_first_namecustomer.contact_initialcustomer.contact_last_name
Customer Maintenance, Contact tab, Contact fields
ReceivableTransaction/ReceivableTransactionHeader/BillToParty/Contact/JobTitlecustomer.contact_position Customer Maintenance, Contact tab, Position/Salutation
ReceivableTransaction/ReceivableTransactionHeader/BillToParty/Contact/Communication/DialNumbercustomer.contact_phone Customer Maintenance, Contact tab, Phone
ReceivableTransaction/ReceivableTransactionHeader/ShipToParty/PartyIDs/IDcust_address.name Customer Maintenance, Maintain Shipping Addresses, Name
ReceivableTransaction/ReceivableTransactionHeader/ShipToParty/PartyIDs/TaxIDcust_address.tax_id_number Customer Maintenance, Maintain Shipping Addresses, Tax ID Number
ReceivableTransaction/ReceivableTransactionHeader/ShipToParty/Namecust_address.name Customer Maintenance, Maintain Shipping Addresses, Name
ReceivableTransaction/ReceivableTransactionHeader/ShipToParty/Location/IDcust_address.shipto_id Customer Maintenance, Maintain Shipping Addresses, #
ReceivableTransaction/ReceivableTransactionHeader/ShipToParty/Location/Namecust_address.name Customer Maintenance, Maintain Shipping Addresses, Name
ReceivableTransaction/ReceivableTransactionHeader/ShipToParty/Location/Address/AttentionOfNamecust_address.name Customer Maintenance, Maintain Shipping Addresses, Name
ReceivableTransaction/ReceivableTransactionHeader/ShipToParty/Location/Address/AddressLinecust_address.addr_1cust_address.addr_2cust_address.addr_3
Customer Maintenance, Maintain Shipping Addresses, Street Address Fields
ReceivableTransaction/ReceivableTransactionHeader/ShipToParty/Location/Address/CityNamecust_address.city Customer Maintenance, Maintain Shipping Addresses, City
ReceivableTransaction/ReceivableTransactionHeader/ShipToParty/Location/Address/CountrySubDivisionCodecust_address.state Customer Maintenance, Maintain Shipping Addresses, State
ReceivableTransaction/ReceivableTransactionHeader/ShipToParty/Location/Address/CountryCodecust_address.country Customer Maintenance, Maintain Shipping Addresses, Country
ReceivableTransaction/ReceivableTransactionHeader/ShipToParty/Location/Address/PostalCodecust_address.zipcode Customer Maintenance, Maintain Shipping Addresses, Zip
ReceivableTransaction/ReceivableTransactionHeader/ShipToParty/Contact/Namecustomer_order.contact_honorificcustomer_order.contact_first_namecustomer_order.contact_initialcustomer_order.
Customer Order Entry, Contact tab, Contact fields
August 13, 2009 78
ReceivableTransactioncontact_last_name
ReceivableTransaction/ReceivableTransactionHeader/ShipToParty/Contact/JobTitlecustomer_order.contact_position Customer Order Entry, Contact tab, Pos/Sal
ReceivableTransaction/ReceivableTransactionHeader/ShipToParty/Contact/Communication/DialNumbercustomer_order.contact_phone Customer Order Entry, Contact tab, Phone
ReceivableTransaction/ReceivableTransactionHeader/PayFromParty/PartyIDs/IDcustomer.bill_to_name Customer Maintenance, Bill To Customer Name
ReceivableTransaction/ReceivableTransactionHeader/PayFromParty/PartyIDs/TaxIDcustomer.tax_id_number Customer Maintenance, Accounting tab, Tax ID Number
ReceivableTransaction/ReceivableTransactionHeader/PayFromParty/Namecustomer.bill_to_name Customer Maintenance, Bill To Customer Name
ReceivableTransaction/ReceivableTransactionHeader/PayFromParty/Location/IDcustomer.id Customer Maintenance, Customer ID
ReceivableTransaction/ReceivableTransactionHeader/PayFromParty/Location/Namecustomer.bill_to_name Customer Maintenance, Bill To Customer Name
ReceivableTransaction/ReceivableTransactionHeader/PayFromParty/Location/Address/AttentionOfNamecustomer.bill_to_name Customer Maintenance, Bill To Customer Name
ReceivableTransaction/ReceivableTransactionHeader/PayFromParty/Location/Address/AddressLinecustomer.bill_to_addr_1customer.bill_to_addr_2customer.bill_to_addr_3
Customer Maintenance, Bill to Street Address fields
ReceivableTransaction/ReceivableTransactionHeader/PayFromParty/Location/Address/CityNamecustomer.bill_to_city Customer Maintenance, Bill to City
ReceivableTransaction/ReceivableTransactionHeader/PayFromParty/Location/Address/CountrySubDivisionCodecustomer.bill_to_state Customer Maintenance, Bill to State
ReceivableTransaction/ReceivableTransactionHeader/PayFromParty/Location/Address/CountryCodecustomer.bill_to_country Customer Maintenance, Bill to Country
ReceivableTransaction/ReceivableTransactionHeader/PayFromParty/Location/Address/PostalCodecustomer.bill_to_zipcode Customer Maintenance, Bill to Zip
ReceivableTransaction/ReceivableTransactionHeader/PayFromParty/Contactcustomer.contact_hornorificcustomer.contact_first_namecustomer.contact_initialcustomer.contact_last_name
Customer Maintenance, Contact tab, Contact fields
ReceivableTransaction/ReceivableTransactionHeader/PayFromParty/Contact/JobTitlecustomer.contact_position Customer Maintenance, Contact tab, Position/Salutation
ReceivableTransaction/ReceivableTransactionHeader/PayFromParty/Contact/Communication/DialNumbercustomer.contact_phone Customer Maintenance, Contact tab, Phone
ReceivableTransaction/ReceivableTransactionHeader/SalesLocation/IDcustomer.territory Customer Maintenance, General tab, Territory
August 13, 2009 79
ReceivableTransactionReceivableTransaction/ReceivableTransactionHeader/PaymentTerm/Description
receivable.terms_descriptionreceivable.terms_net_typereceivable.terms_net_daysreceivable.terms_net_datereceivable.terms_disc_typereceivable.terms_disc_daysreceivable.terms_disc_datereceivable.terms_disc_percent
Receivable Invoice Entry, Terms
ReceivableTransaction/ReceivableTransactionHeader/PaymentTerm/Term/DueDateTimecalculation: receivable.invoice_date+receivable.terms_net_days
The system adds the days in the Receivable Invoice Entry, Terms, Net Days to Receivble Invoice Entry, Invoice Date
ReceivableTransaction/ReceivableTransactionHeader/PaymentTerm/Discount/Descriptionreceivable.terms_descriptionreceivable.terms_net_typereceivable.terms_net_daysreceivable.terms_net_datereceivable.terms_disc_typereceivable.terms_disc_daysreceivable.terms_disc_datereceivable.terms_disc_percent
Receivable Invoice Entry, Terms
ReceivableTransaction/ReceivableTransactionHeader/ReceivableStylereceivable.type Receivable Invoice Entry, General tab, Type
If Type = Invoice, then ReceivableStyle is InvoiceIf Type = Unapplied Cash or Memo, then Receivable Style is CreditMemo
ReceivableTransaction/ReceivableTransactionHeader/InvoiceReference/DocumentID@agencyRole
receivable.customer_id Receivable Invoice Entry, Customer ID
ReceivableTransaction/ReceivableTransactionHeader/InvoiceReference/DocumentID/IDreceivable.invoice_id Receivable Invoice Entry, Invoice ID
ReceivableTransaction/ReceivableTransactionHeader/ExtendedAmountreceivable.total_amount Receivable Invoice Entry, Invoice Total. The system converts the total into the system currency. If the invoice is void, then the
amount is 0.@currencyID
receivable.currency_id Receivable Invoice Entry, Currency ID
ReceivableTransaction/ReceivableTransactionHeader/TotalAmountreceivable.total_amount Receivable Invoice Entry, Invoice Total. The system converts the total into the system currency. If the invoice is void, then the
amount is 0.@currencyID
receivable.currency_id Receivable Invoice Entry, Currency ID
ReceivableTransaction/ReceivableTransactionHeader/Tax/Amount 0
ReceivableTransaction/ReceivableTransactionHeader/DiscountStatus/DiscountAllowedAmountreceivale.total_amountreveivable.terms_disc_percent
The system calculates the amount as follows:Receivable Invoice Entry, Invoice Total multiplied by (Receivable Invoice Entry, General tab, Terms button box divided by 100)
@currencyIDreceivable.currency_id Receivable Invoice Entry, Currency ID
ReceivableTransaction/ReceivableTransactionHeader/DiscountStatus/DiscountTakenAmountreceivable.discount_given
@currencyIDreceivable.currency_id Receivable Invoice Entry, Currency ID
ReceivableTransaction/ReceivableTransactionHeader/DiscountStatus/LateDiscountIndicatorreceivable.zero_datereceivable.discount_date
If RECEIVABLE.ZERO_DATE is greater than RECEIVABLE.DISCOUNT_DATE, then LateDiscountIndicator is True. In all other cases, False.
ReceivableTransaction/ReceivableTransactionHeader/ReceivableAmountcalculation:receivable.total_amount-receivable.paid_amount
Receivable Invoice Entry, Invoice Total minus Receivable Invoice Entry, Paid to Date. The system converts the total into the system currency. If the invoice is void, then the amount is 0.
@currencyIDreceivable.currency_id Receivable Invoice Entry, Currency ID
August 13, 2009 80
ReceivableTransactionReceivableTransaction/ReceivableTransactionHeader/ReceiptAmount
calculation:receivable.total_amount-receivable.paid_amount
Receivable Invoice Entry, Invoice Total minus Receivable Invoice Entry, Paid to Date. The system converts the total into the system currency. If the invoice is void, then the amount is 0.
@currencyIDcurrency.currency_id Exchange Rate Maintenance, Currency Maintenance, Currency ID marked as system currency
ReceivableTransaction/ReceivableTransactionHeader/ReceivedAmountreceivable.paid_amount Receivable Invoice Entry, Paid to Date. The system converts the total into the system currency. If the invoice is void, then the
amount is 0.@currencyID
receivable.currency_id Receivable Invoice Entry, Currency ID
ReceivableTransaction/ReceivableTransactionHeader/PaymentMethodCodecash_receipt.payment_method Cash Application, Payment Method for Payment ID associated with Receivable ID
If Payment Method=Check, then PaymentMethodCode is ChequeIf PaymentMethod=Bacs or Export File, then PaymentMethodCode is ElectronicFundsTransferIf no cash receipt is associated with the receivable ID, the system inserts empty spaces.
@listID PaymentMethodCode. The system gets the listID name from Code Mapping Maintenance.
ReceivableTransaction/ReceivableTransactionHeader/CurrencyExchangeRatereceivable.currency_id Receivable Invoice Entry, Currency ID
ReceivableTransaction/ReceivableTransactionLine/LineNumberreceivable_line.line_no Receivable Invoice Entry, invoice entry table, Ln#
ReceivableTransaction/ReceivableTransactionLine/Descriptionreceivable_line.reference Receivable Invoice Entry, invoice entry table, Reference
ReceivableTransaction/ReceivableTransactionLine/DocumentReference@type
SalesOrder
ReceivableTransaction/ReceivableTransactionLine/DocumentReference/LineNumberreceivable_line.cust_order_line_no
Receivable Invoice Entry, Lines, Customer Order Ln #
ReceivableTransaction/ReceivableTransactionLine/Status/Code Open
ReceivableTransaction/ReceivableTransactionLine/Typereceivable.type Receivable Invoice Entry, General tab, Type options
ReceivableTransaction/ReceivableTransactionLine/Amountreceivable_line.amount Receivable Invoice Entry, invoice line table, Amount. The system converts the total into the system currency. If the invoice is
void, then the amount is 0.@currencyCode
receivable.currency_id Receivable Invoice Entry, General tab, Currency ID
ReceivableTransaction/ReceivableTransactionLine/Tax/Amount 0
August 13, 2009 81
ReceiveDeliveryReceiveDelivery/ReceiveDeliveryHeader/DocumentID@agencyRole
For type=Receiver, Shipper, CNSNReceiverSupplierFor type=WOIssRtn, IBTReceiverManufacturer
ReceiveDelivery/ReceiveDeliveryHeader/DocumentID/IDfor type=receiverreceiver.id+receiver_line.line_nofor type=shippershipper.packlist_id+shipper_line.line_nofor type=woreceipt, woissrtninventory_transaction.transcation_idfor type=ibtreceiveribt_receiver.id+ibt_receiver_line.line_nofor type=cnsnreceiverconsign_receiver.id+consign_rcvr_line.line_no
For type=Receiver:Receiver~Purchase Receipt Entry, Receiver ID~Purchase Receipt Entry, Lines, Ln#For type=ShipperShipper~Shipping Entry, Packlist ID~Shipping Entry, Lines, Ln#For type=WOReceipt, WOIssRtnWOReceipt~Inventory Transaction, Transaction ID~0For type=IBTReceiverIBTReceiver~Inter Branch Transfer Receipt Entry, Receiver ID~Inter Branch Transfer Receipt Entry, Lines, Ln#For type=CNSNReceiverCNSNReceiver~Consignment Receiving, Receiver ID~Consignment Receiving, Lines, Ln#
@accountingEntityapplication_global.entity_id Application Global Maintenance, Default Mfg Entity
@locationsettings.location_id SOA Maintenance, SOA Location
@lidsettings.instance_id The system combines lid://infor.visual with the value in SOA Maintenance, Visual Instance ID
ReceiveDelivery/ReceiveDeliveryHeader/LastModifiedDateTimefor type=shippershipper.create_datefor type=woreceipt, woissrtninventory_transaction.transaction_datefor type=ibtreceiveribt_receiver.create_datefor type=cnsnreceiverconsign_receiver.create_date
For type=ReceiverThe system inserts the date and time it created the BOD.For type=ShipperIs not displayed on the Shipping Entry window. Available in the Packlist ID browse tableFor type=WOReceiptInventory Transaction, Transaction DateFor type=CNSNReceiverConsignment Receiver Create Date is available on the Receiver ID browse
ReceiveDelivery/ReceiveDeliveryHeader/DocumentDateTimefor type=receiverreceiver.received_datefor type=shippershipper.create_datefor type=woreceipt, woissrtninventory_transaction.transaction_datefor type=ibtreceiveribt_receiver.receive_datefor type=cnsnreceiverconsign_receiver.received_date
For type=ReceiverPurchase Receipt Entry, Act Recv DateFor type=ShipperIs not displayed on the Shipping Entry window. Available in the Packlist ID browse tableFor type=WOReceiptInventory Transaction, Transaction DateFor type=IBTReceiverInter Branch Transfer Receipt Entry, Actual Recv DateFor type=CNSNReceiverConsignment Receiving, Receive Date
ReceiveDelivery/ReceiveDeliveryHeader/Notenote.notations For type=Receiver
Purchase Receipt Entry, Receiver NotationsFor type=ShipperShipping Entry, Packlist Notations
@languageIDsettings.language_id SOA Maintenance, Language ID
@author The system inserts the user ID stamped on the notation.
@entryDateTime The system inserts the time-date stamped on the notiation
@status Open
ReceiveDelivery/ReceiveDeliveryHeader/Status/Code
August 13, 2009 82
ReceiveDelivery For type=Receiver, WOReceipt, WOIssRtn, CNSNReceiver
If transaction is deleted, then Status equals Canceled. Otherwise, Status equals ReceivedFor type=Shipper, IBTReceiverNetable
@listID Receive Delivery Status
@listAgencyID Infor
ReceiveDelivery/ReceiveDeliveryHeader/Status/EffectiveDateTimefor type=receiverreceiver.received_datefor type=shippershipper.create_datefor type=woreceipt, woissrtninventory_transaction.transaction_datefor type=ibtreceiveribt_receiver.receive_datefor type=cnsnreceiverconsign_receiver.received_date
For type=ReceiverPurchase Receipt Entry, Act Recv DateFor type=ShipperShipper Create Date is available on the Packlist ID browse tableFor type=WOReceipt, WOIssRtnInventory Transaction, Transaction DateFor type=IBTReceiverInter Branch Transfer Receipt Entry, Actual Recv DateFor type=CNSNReceiverConsignment Receiving, Receive Date
ReceiveDelivery/ReceiveDeliveryHeader/WarehouseLocation@type
Warehouse
ReceiveDelivery/ReceiveDeliveryHeader/WarehouseLocation/IDfor type=receiverreceiver_line.warehouse_idfor type=shipperinventory_trans.warehouse_idfor type=woreceiptinventory_transaction.warehouse_idfor type=ibtreceiveribt_receiver_line.warehouse_idibt.ship_to_addr_nofor type=cnsnrecieverconsign_rcvr_line.warehouse_id
For type=ReceiverPurchase Receipt, Lines, Warehouse IDFor type=ShipperInventory Transaction, Warehouse ID for the inventory transaction ID associated with the Packlist IDFor type=WOReceiptInventory Transaction Entry, Warehouse IDFor type=ibtreceiverInter Branch Transfer, Ship To Address that corresponds to Inter Branch Transfer Receipt Entry, Lines, Warehouse IDFor type=CNSNReceiverConsignment Receiving, Warehouse ID
ReceiveDelivery/ReceiveDeliveryHeader/WarehouseLocation/Namewarehouse_address.name Warehouse Maintenance, Warehouse Address, Name
ReceiveDelivery/ReceiveDeliveryHeader/WarehouseLocation/Address/CityNamewarehouse_address.city Warehouse Maintenance, Warehouse Address, City
ReceiveDelivery/ReceiveDeliveryHeader/WarehouseLocation/Address/CountrySubDivisionCodewarehouse_address.state Warehouse Maintenance, Warehouse Address, State
@listID Country Sub-divisions
@listAgencyID Infor
ReceiveDelivery/ReceiveDeliveryHeader/WarehouseLocation/Address/CountryCodewarehouse_address.country Warehouse Maintenance, Warehouse Address, Country
@listID Countries
@listAgencyID Infor
ReceiveDelivery/ReceiveDeliveryHeader/WarehouseLocation/Address/PostalCodewarehouse_address.zipcode Warehouse Maintenance, Warehouse Address, Zip
@listID Postal/Zip Codes
@listAgencyID Infor
ReceiveDelivery/ReceiveDeliveryHeader/ActualShipDateTimefor type=receiverpurchase_order.vend_pack_datefor type=shipper
For type=receiverPurchase Receipt Entry, Vendor Packlist DateFor type=Shipper
August 13, 2009 83
ReceiveDeliveryshipper.create_datefor type=ibtreceiveribt_receiver.create_datefor type=cnsnreceiverpurchase_order.vend_pack_date
Shipper Create Date is available on the Packlist ID browse tableFor type=IBTReceiverIBT Receiver create date is available in the Inter Branch Transfer Receipt Entry IBT ID browse table.For type-CNSNReceiverPurchase Receipt Entry, Vendor Packlist Date
ReceiveDelivery/ReceiveDeliveryHeader/ScheduledDeliveryDateTimefor type=receiverpurchase_order.promise_datefor type=shippershipper.create_datefor type=woreceiptwork_order.desired_want_datefor type=woissrtninventory_transaction.transaction_datefor type=ibtreceiveribt.desired_recv_datefor type=cnsnreceiver purchase_order.desired_recv_date
For type=ReceiverPurchase Order Entry, Promise Delivery DateFor type=ShipperShipper Create Date is available on the Packlist ID browse tableFor type=WOReceiptManufacturing Window, Work Order Header, Want DateFor type=WOIssRtnInventroy Transaction Entry, Transaction DateFor type=ibtreceiverInter Branch Transfer Entry, Desired Recv DateFor type=CNSNReceiverPurchase Order Entry, Desired Recv Date
ReceiveDelivery/ReceiveDeliveryHeader/ActualDeliveryDateTimefor type=receiverreceiver.received_datefor type=shippershipper.create_datefor type=woreceipt, woissrtninventory_transaction.transaction_datefor type=ibtreceiveribt_receiver.received_datefor type=cnsnreceiverconsignment_receiver.received_date
For type=ReceiverPurchase Receipt Entry, Act Recv DateFor type=ShipperShipper Create Date is available on the Packlist ID browse tableFor type=WOReceipt, WOIssRtnInventory Transaction, Transaction DateFor type=ibtreceiverInter Branch Transfer Receipt Entry, Actual Received DateFor type=CNSNReceiverConsignment Receiving, Receive Date
ReceiveDelivery/ReceiveDeliveryHeader/TransportationMethodCodefor type=receiver, cnsnreceiverpurchase_order.ship_viafor type=shippercustomer_order.ship_viafor type=ibtreceiveribt_shipper.ship_via
For type=Receiver, CNSNReceiverPurchase Order Entry, Ship ViaFor type=ShipperShipping Entry, Ship ViaFor type=ibtreceiverInter Branch Transfer Shipping Entry, Other tab, Ship Via
@listID Transportation Method
@listAgencyID OAGIS
ReceiveDelivery/ReceiveDeliveryHeader/CarrierParty/PartyIDs/IDfor type=receiverreceiver.carrier_idfor type=shippercustomer_order.carrier_idfor type=ibtreceiveribt.carrier_idfor type=cnsnreceiverconsign_receiver.carrier_id
For type=ReceiverPurchase Receipt Entry, Carrier IDFor type=ShipperCustomer Order Entry, Carrier IDFor type=ibtreceiverInter Branch Transfer Entry, Carrier IDFor type=CNSNReceiverConsignment Receiving, Carrier ID
@schemeName System
@schemeAgencyIDsettings.instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID fields
ReceiveDelivery/ReceiveDeliveryHeader/CarrierParty/Namecarrier.name Application Global Maintenance, Carriers, Name
ReceiveDelivery/ReceiveDeliveryHeader/CarrierParty/Location/Address/AddressLinecarrier.addr_1; carrier.addr_2; carrier.addr_3
Application Global Maintenance, Carriers, Addr 1, Addr 2, Addr 3 fields
August 13, 2009 84
ReceiveDeliveryReceiveDelivery/ReceiveDeliveryHeader/CarrierParty/Location/Address/CityName
carrier.city Application Global Maintenance, Carriers, City field
ReceiveDelivery/ReceiveDeliveryHeader/CarrierParty/Location/Address/CountrySubDivisionCodecarrier.state Application Global Maintenance, Carriers, State field
ReceiveDelivery/ReceiveDeliveryHeader/CarrierParty/Location/Address/CountryCodecarrier.country Application Global Maintenance, Carriers, Country field
ReceiveDelivery/ReceiveDeliveryHeader/CarrierParty/Location/Address/PostalCodecarrier.zipcode Application Global Maintenance, Carriers, Zip / Postal Code field
ReceiveDelivery/ReceiveDeliveryHeader/ReceivedDateTimefor type=receiverreceiver.received_datefor type=shippershipper.create_datefor type=woreceipt, woissrtninventory_transaction.transaction_datefor type=ibtreceiveribt_receiver.received_datefor type=cnsnreceiverconsign_receiver.receive_date
For type=ReceiverPurchase Receipt Entry, Act Recv DateFor type=ShipperShipper Create Date is available on the Packlist ID browse tableFor type=WOReceipt, WOIssRtnInventorty Transaction Entry, Transaction DateFor type=ibtreceiverInter Branch Transfer Receipt Entry, Actual Received DateFor type=CNSNReceiverConsignment Receiving, Receive Date
ReceiveDelivery/ReceiveDeliveryHeader/BillOfLadingIDfor type=receiverreceiver.bol_idfor type=shippershipper.bol_idfor type=ibtreceiveribt_shipper.bol_idfor type=cnsnreceiverconsign_receiver.bol_id
For type=ReceiverPurchase Receipt Entry, Bill of Lading IDFor type=ShipperField is not displays in Shipping Entry window.For type=IBTReceiverField is not displayed in Inter Branch Transfer Shipping Entry window.For type=CNSNReceiverConsignment Receiving, Bill of Lading ID
ReceiveDelivery/ReceiveDeliveryHeader/ASNReference/DocumentID/IDfor type=ibtreceiveribt_shipper.shipper_id
For type=ibtreceiverInter Branch Transfer Shipping Entry, Shipper ID
@schemeName System
@schemeAgencyIDsettings.instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID fields
ReceiveDelivery/ReceiveDeliveryItem/ItemID/IDfor type=receiver, cnsnreceiverpurc_order_line.part_idfor type=receiverpurc_order_line.service_idfor type=shippercust_order_line.part_idfor type=woreceipt, woissrtninventory_transaction.part_idfor type=ibtreceiveribt_line.part_id
For type=Receiver, CNSNReceiverPurchase Order Entry, Lines, Part IDFor type=ReceiverPurchase Order Entry, Lines, Service IDFor type=ShipperCustomer Order Entry, Lines, Part IDFor type=WOReceipt, WOIssRtnInventory Transaction Entry, Part IDFor type=ibtreceiverInter Branch Transfer Entry, Lines, Part ID
@schemeName System
@schemeAgencyIDsettings.instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID fields
ReceiveDelivery/ReceiveDeliveryItem/Descriptionpart.descriptionservice.description
Part Maintenance, DescriptionOutside Service Maintenance, Description
ReceiveDelivery/ReceiveDeliveryItem/Classification@type
COMMODITY, PRODUCTLINE
ReceiveDelivery/ReceiveDeliveryItem/Classification/Codes/Codeif type=commodity: part.commodity_codeif type=productline: part.product_code
If type=commodity: Part Maintenance, Commodity CodeIf type=productline: Part Maintenance, Product Code
August 13, 2009 85
ReceiveDelivery@sequence
1@listID
Commodity Codes, Product Lines@listAgencyID
Infor
ReceiveDelivery/ReceiveDeliveryItem/Classification/Description The system inserts the SOA code description associated with the commodity or productline code.
ReceiveDelivery/ReceiveDeliveryItem/CountryOfOriginCodefor type=receiverreceiver_line.orig_country_idfor type=shippershipper_line.orig_country_idfor type=cnsnreceiverconsign_rcvr_line.orig_country_id
For type=ReceiverPurchase Receipt Entry, Lines, Orig CountryFor type=ShipperShipping Entry, Lines, Country of OriginFor type=CNSNReceiverConsignment Receiving, Lines, Country of Origin
ReceiveDelivery/ReceiveDeliveryItem/ImportLicenseRequiredIndicator False
ReceiveDelivery/ReceiveDeliveryItem/OrderQuantityfor type=receiver, cnsnreceiverpurc_order_line.user_order_qtyfor type=shippercust_order_line.user_order_qtyfor type=woreceipt, woissrtnwork_order.desired_qtyfor type=ibtreceiveribt_line.user_order_qty
For type=Receiver, CNSN ReceiverPurchase Order Entry, Lines, QuantityFor type=ShipperCustomer Order Entry, Lines, QuantityFor type=WOReceiptManufacturing Window, Work Order Header, QuantityFor type=ibtreceiverInter Branch Transfer, Lines, Quantity
@unitCodefor type=receiver, cnsnreceiverpurc_order_line.purchase_umservice.usage_umfor type=shippercust_order_line.selling_umfor type=woreceipt, woissrtnpart.stock_umfor type=ibtreceiveribt_line.ibt_um
For type=Receiver, CNSNReceiverPurchase Order Entry, Lines, U/M fieldIf item is a service and U/M field is blank, then use Outside Service Maintenance, Usage UMFor type=ShipperCustomer Order Entry, Lines, U/MFor type=WOReceipt, WOIssRtnPart Maintenance, Stock UMFor type=ibtreceiverInter Branch Transfer Entry, Lines, U/M
ReceiveDelivery/ReceiveDeliveryItem/ShippedQuantityfor type=ibtreceiveribt_shipper_line.user_shipped_qty
For type=ibtreceiverInter Branch Transfer Shipping Entry, Lines, Ship Qty
@unitCodefor type=ibtreceiveribt_line.ibt_um
For type=ibtreceiverInter Branch Transfer Entry, Lines, U/M
ReceiveDelivery/ReceiveDeliveryItem/OpenQuantityfor type=receiver, cnsnreceiverpurc_order_line.user_order_qty-purc_order_line.total_usr_recv_qtyfor type=shippercust_order_line.user_order_qty-cust_order_line.user_shipped_qtyfor type=woreceipt, woissrtnwork_order.desired_qty-work_order.received_qtyfor type=ibtreceiveribt_line.user_order_qty-ibt_line.usr_recd_qty
For type=Receiver, CNSNReceiverPurchase Order Entry, Lines, Quantity minus Purchase Order Entry, Lines, Dispatch QuantityFor type=ShipperCustomer Order Entry, LInes, Quantity minus Customer Order Entry, Lines, Shipped QtyFor type=WOReceipt, WOIssRtnManufacturing Window, Work Order Header, Quantity minus Manufacturing Window, Work Order View panel, Received QtyFor type=ibtreceiverInter Branch Transfer Entry, Lines, Quantity minus Inter Branch Transfer Entry, LInes, Qty Received
@unitCodefor type=receiver, cnsnreceiverpurc_order_line.purchase_umservice.usage_umfor type=shippercust_order_line.selling_umfor type=woreceipt, woissrtn
For type=Receiver, CNSNReceiverPurchase Order Entry, Lines, U/M fieldIf item is a service and U/M field is blank, then use Outside Service Maintenance, Usage UMFor type=ShipperCustomer Order Entry, Lines, U/MFor type=WOReceipt, WOIssRtn
August 13, 2009 86
ReceiveDeliverypart.stock_umfor type=ibtreceiveribt_line.ibt_um
Part Maintenance, Stock UMFor type=ibtreceiverInter Branch Transfer Entry, Lines, U/M
ReceiveDelivery/ReceiveDeliveryItem/LoadingWeightMeasurefor type=receiverreceiver_line.gross_weightfor type=ibtreceiveribt_shipper_line.shipping_weightfor type=cnsnreceiverconsign_rcvr_line.gross_weight
For type=ReceiverPurchase Receipt Entry, Lines, Gross WeightFor type=Shippern/aFor type=ibtreceiverInter Branch Transfer Shipping Entry, Lines, Per Unit Ship WeightFor type=CNSNReceiverConsignment Receiving, Lines, Gross Weight
@unitCodefor type=receiver, shipper, CNSNReceiverpart.weight_umfor type=ibtreceiveribt_line.weight_um
For type=Reciever, Shipper, CNSNReceiverPart Maintenance, Weight UMFor type=ibtreceiverInter Branch Transfer Entry, Lines, Weight U/M
ReceiveDelivery/ReceiveDeliveryItem/PurchaseOrderReference/DocumentID/IDfor type=receiverreceiver_line.purc_order_idfor type=cnsnreceiverconsign_receiver.purc_order_id
For type=CNSNReceiverConsignment Receiving, Order ID
@accountingEntityapplication_global.entity_id Application Global Maintenance, Default Mfg Entity
@location SOA Maintenance, SOA Location
ReceiveDelivery/ReceiveDeliveryItem/PurchaseOrderReference/LineNumberfor type=receiverreceiver_line.purc_order_line_nofor type=cnsnreceiverconsign_rcvr_line.purc_order_line_no
ReceiveDelivery/ReceiveDeliveryItem/PurchaseOrderReference/ScheduleLineNumberFor type=receiverpurc_line_del.del_sched_line_no
For type=ReceiverPurchase Order Entry, Delivery Schedule, Ln#
ReceiveDelivery/ReceiveDeliveryItem/PurchaseOrderReference/QuantityFor type=receiverpurc_line_del.user_received_qtyreceiver_line.user_received_qty
For type=ReceiverPurchase Order Entry, Deliver Schedule, Qty. If null, then Purchase Receipt Entry, Lines, Quantity Received
ReceiveDelivery/ReceiveDeliveryItem/SalesOrderReference/DocumentID/IDshipper.cust_order_id Shipping Entry, Order ID
ReceiveDelivery/ReceiveDeliveryItem/PurchaseOrderReference/DocumentID/ID@accountingEntity
application_global.entity_id Application Global Maintenance, Default Mfg Entity@location
SOA Maintenance, SOA Location
ReceiveDelivery/ReceiveDeliveryItem/SalesOrderReference/LineNumbershipper_line.cust_order_line_no Shipping Entry, Lines, C/O Ln#
ReceiveDelivery/ReceiveDeliveryItem/Status/Codefor type=receiver, woreceipt, woissrtn, cnsnreceiverpart_location.loc_status
For type=ReceiverIf Warehouse Maintenance, Location/Parts is Available, then status is Available. Otherwise, status is OnHoldFor type=Shipper, ibtreceiverAvailableFor type=WOReceipt, WOIssRtnIf Warehouse Maintenance, Location/Parts, Status equals Available, then status is Available. Otherwise, status is OnHold
August 13, 2009 87
ReceiveDelivery@listID
Receive Delivery Status@listAgencyID
Infor
ReceiveDelivery/ReceiveDeliveryItem/Status/ReasonCodeFor type=receiver, WOReceipt, WOIssRtn, CNSNReceiverpart_location.hold_reason_id
For type=receiver, WOReceipt, WOIssRtn, CNSNReceiverIf status is OnHold, then Part Maintenance, Warehouse Locations, Hold Reason ID
@listID Hold Reason Code
@listAgencyID Infor
ReceiveDelivery/ReceiveDeliveryItem/ReceivedQuantityfor type=receiverreceiver_line.user_received_qty, if positivefor type=shippershipper_line.user_shipped_qtyfor type=woreceipt, woissrtninventory_transaction.qtyfor type=ibtreceiveribt_receiver_line.user_received_qtyfor type=cnsnreceiverconsign_rcvr_line.user_received_qty
For type=ReceiverPurchase Receipt Entry, Lines, Quantity Received, if positiveFor type=ShipperShipping Entry, Lines, Qty Shipper multiplied by -1For type=WOReceipt, WOIssRtnInventory Transaction Entry, QuantityFor type=ibtreceiverInter Branch Transfer Receipt Entry, Lines, Quantity ReceivedFor type=CNSNReceiverConsignment Receiving, Lines, Quantity Received
@unitCodefor type=receiver, cnsnreceiverpurc_order_line.purchase_umfor type=shippercust_order_line.selling_umfor type=woreceipt, WOIssRtnpart.stock_umfor type=ibtreceiveribt_line.ibt_um
For type=Receiver, CNSNReceiverPurchase Order Entry, Lines, U/MFor type=ShipperCustomer Order Entry, Lines, UMFor type=WOReceiptPart Maintenance, Stock UMFor type=ibtreceiverInter Branch Transfer Entry, Lines, UM
ReceiveDelivery/ReceiveDeliveryItem/ReturnedQuantityfor type=receiverreceiver_line.user_received_qtyfor type=WOIssRtninventory_transaction.qtyfor type=cnsnreceiverconsign_rcvr_line.user_received_qty
For type=ReceiverPurchase Receipt Entry, Lines, Quantity Received multiplied by -1, if Quantity Received is negative For type=Shipper, ibtreceiver0For type=WOIssRtnInventory Transaction Entry, QuantityFor type=CNSNReceiverIf Received Quantity is less than zero, then Consignment Receiving, Lines, Quantity Received mulitplied by -1
@unitCodefor type=receiver, cnsnreceiverpurc_order_line.purchase_umfor type=shippercust_order_line.selling_umFor type=WOIssRtnpart.stock_um
For type=Receiver, CNSNReceiverPurchase Order Entry, Lines, U/MFor type=ShipperCustomer Order Entry, Lines, UMFor type=WOIssRtnPart Maintenance, Stock U/M
ReceiveDelivery/ReceiveDeliveryItem/DamagedQuantityfor type=receiverreceiver_line.rejected_qtyfor type=cnsnreceiverconsign_rcvr_line.rejected_qty
For type=ReceiverPuchase Receipt Entry, Lines, Rejected QtyFor type=Shipper, ibtreceiver0
@unitCodefor type=receiver, cnsnreceiverpurc_order_line.purchase_umfor type=shippercust_order_line.selling_um
For type=Receiver, CNSNReceiverPurchase Order Entry, Lines, U/MFor type=ShipperCustomer Order Entry, Lines, UM
ReceiveDelivery/ReceiveDeliveryItem/LineNumberreceiver_line.line_no Purchase Receipt Entry, Lines, #
August 13, 2009 88
ReceiveDeliveryReceiveDelivery/ReceiveDeliveryItem/CountSequence
part_warehouse.count_sequenceinventory_trans.count_sequence
If the transaction is deleted, then part_warehouse.count_sequence. Otherwise, inventory_trans.count_sequence
ReceiveDelivery/ReceiveDeliveryUnit/ScheduledDeliveryDateTimefor type=receiver, cnsnreceiverpurc_line_del.desired_recv_datefor type=shippershipper.create_date
For type=Receiver, CNSNReceiverPurchase Order Entry, Edit Delivery Schedule, Desired Receive DateFor type=ShipperCreate Date is available on the Packlist ID browse
ReceiveDelivery/ReceiveDeliveryUnit/ActualDeliveryDateTimefor type=receiverreceiver_line.received_datefor type=shippershipper.create_datefor type=cnsnreceiverconsign_receiver.received_date
For type=ReceiverPurchase Receipt Entry, Lines, Last Received DateFor type=ShipperCreate Date is available on the Packlist ID browseFor type=CNSNReceiverConsignment Receiving, Receive Date
ReceiveDelivery/ReceiveDeliveryUnit/ReceiveDeliveryUnitItem/OrderQuantityfor type=receiver, cnsnreceiverpurc_line_del.user_order_qtyfor type=shippercust_line_del.user_order_qty
For type=Receiver, CNSNReceiverPurchase Order Entry, Edit Delivery Schedule, QtyFor type=ShipperCustomer Order Entry, Edit Delivery Schedule, Qty
@unitCodefor type=receiver, CNSNRecieverpurc_order_line.purchase_umfor type=shippercust_order_line.selling_um
For type=Receiver, CNSNReceiverPurchase Order Entry, Lines, U/MFor type=ShipperCustomer Order Entry, Lines, UM
ReceiveDelivery/ReceiveDeliveryUnit/ReceiveDeliveryUnitItem/OpenQuantityfor type=receiverpurc_line_del.user_order_qty-receiver_line_del.user_received_qtyfor type=shippercust_line_del.user_order_qty-cust_line_del.user_shipped_qtyfor type=cnsnreceiverpurc_line_del.user_order_qtypurc_line_del.user_received_qty
For type=ReceiverPurchase Order Entry, Edit Delivery Schedule, Qty Received minus the sum of Purchase Receipt Entry, Edit Delivery Schedule, Received QtyFor type=ShipperCustomer Order Entry, Edit Delivery Schedule, Qty minus Customer Order Entry, Edit Delivery Schedule, Shipped QtyFor type=ReceiverPurchase Order Entry, Edit Delivery Schedule, Qty Received minus the sum of Purchase Order Entry, Edit Delivery Schedule, Received Qty
@unitCodefor type=receiver, CNSNReceiverpurc_order_line.purchase_umfor type=shippercust_order_line.selling_um
For type=Receiver, CNSNReceiverPurchase Order Entry, Lines, U/MFor type=ShipperCustomer Order Entry, Lines, UM
ReceiveDelivery/ReceiveDeliveryUnit/ReceiveDeliveryUnitItem/PurchaseOrderReference/LineNumberFor type=receiver:purc_line.line_nofor type=shipper:shipping_lines.cust_order_line_nofor type=cnsnreceiverconsign_rcvr_line.purc_order_line_no
For type=ReceiverPurchase Order Entry, Lines, Ln#For type=ShipperShipping Entry, Lines, C/O Ln#
ReceiveDelivery/ReceiveDeliveryUnit/ReceiveDeliveryUnitItem/PurchaseOrderReference/ScheduleLineNumberfor type=receiverreceiver_line_del.purc_del_line_nofor type=shippershipper_line_del.line_nofor type=cnsnreceivercnsn_rcvr_line_del.line_no
For type=ReceiverPurchase Receipt Entry, Edit Delivery Schedule, Line #For type=ShipperShipping Entry, Edit Deliver Schedule, Line #
ReceiveDelivery/ReceiveDeliveryUnit/ReceiveDeliveryUnitItem/ReceivedQuantityfor type=receiverreceiver_line_del.user_received_qty if qty is positive otherwise 0.0for type=shipper
For type=ReceiverPurchase Receipt Entry, Edit Delivery Schedule, Received Quantity.For type=ShipperShipping Entry, Edit Delivery Schedule, Shipped Qty multiplied by -1
August 13, 2009 89
ReceiveDeliveryshipper_line_del.user_shipped_qtyfor type=cnsnreceivercnsn_rcvr_line.user_received_qty
@unitCodepurc_order_line.purchase_um Purchase Order Entry, purchase order line table, U/M field
ReceiveDelivery/ReceiveDeliveryUnit/ReceiveDeliveryUnitItem/ReturnedQuantityfor type=receiverreceiver_line_del.user_received_qty * -1 if qty is negative otherwise 0.0for type=cnsnreceivercnsn_rcvr_line.user_received_qty * -1 if qty is negative; otherwise, 0.0
For type=ReceiverPurchase Receipt Entry, Edit Delivery Schedule, Received Quantity multiplied by -1 if quantity is negative; otherwise, 0.0For type=Shipper0
@unitCodepurc_order_line.purchase_um Purchase Order Entry, purchase order line table, U/M field
August 13, 2009 90
RequisitionRequisition/RequisitionHeader/DocumentID/ID
purc_requisition.id Purchase Requisition Entry, Requisition ID@accountingEntity
application_global.entity_id Application Global Maintenance, Default Mfg Entity@location
settings.location_id SOA Maintenance, SOA Location@lid
settings.instance_id The system combines lid://infor.visual with the value in SOA Maintenance, VISUAL Instance ID
Requisition/RequisitionHeader/LastModificationDateTime The system uses the date and time it created the BOD.
Requisition/RequisitionHeader/DocumentDateTimepurc_requisition.requisition_date Purchase Requisition Entry, Requisition Date
Requisition/RequisitionHeader/Note Purchase Requistion Entry, Requisition Notations
@languageID SOA Maintenance, Language ID
Requisition/RequisitionHeader/Status/Codepurc_requisition.status Purchase Requisition Entry, Status. The system translates VISUAL codes as follows:
If VISUAL status=Draft, then status=OpenIf VISUAL status=Ordered, then status=ConvertedIf VISUAL status=In Process, then status=OpenIf VISUAL status=Approved, then status=ApprovedIf VISUAL status=Cancelled/Void, then status=CanceledIf VISUAL status=Closed, then status=Rejected
Requisition/RequisitionHeader/Status/Description Purchase Requisition Entry, Status. The system translates VISUAL codes as follows:
If VISUAL status=Draft, then status=OpenIf VISUAL status=Ordered, then status=ConvertedIf VISUAL status=In Process, then status=OpenIf VISUAL status=Approved, then status=ApprovedIf VISUAL status=Cancelled/Void, then status=CanceledIf VISUAL status=Closed, then status=Rejected
Requisition/RequisitionHeader/Status/EffectiveDateTimepurc_requisition.status_eff_date Not in Purchase Requistion Entry window. You can display the information in the Requisition ID browse.
If you deleted the requistion, then the effecitve date is the date and time the system created the BOD.
Requisition/RequisitionHeader/CustomerParty/PartyIDs/ID Company
@schemeName System
@schemeAgencyIDsettings.instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID field
Requisition/RequisitionHeader/CustomerParty/Nameapplication_global.company_name
Application Global Maintenance, Name
@languageIDsettings.language_id SOA Maintenance, Language ID
Requisition/RequisitionHeader/CustomerParty/Location@type
Site
Requisition/RequisitionHeader/CustomerParty/Location/IDpurc_requisition.purc_req_addr_no
Purchase Requisition Entry, Shipto ID. If field is null, then Site~SOA Maintenance, SOA Location
Requisition/RequisitionHeader/CustomerParty/Location/Nameapplication_global.nameshipto_address.name
Application Global, NamePurchase Order Entry, Ship to Address, Name
Requisition/RequisitionHeader/CustomerParty/Location/Address/AddressLineshipto_address.addr_1shipto_address.addr_2shipto_address.addr_3orapplication_global.addr_1
Purchase Order Entry, Ship to Address Street Address fieldsorApplication Global Maintenance, Address fields
August 13, 2009 91
Requisitionapplication_global.addr_2application_global.addr_3
@sequence1: shipto_address.addr_12: shipto_address.addr_23: shipto_address.addr_3or1: application_global.addr_12: application_global.addr_23: application_global.addr_3
Purchase Order Entry, Shipto Address, Street Address fieldsorApplication Global Maintenance, Address fields
Requisition/RequisitionHeader/CustomerParty/Location/Address/CityNameshipto_address.cityapplication_global.city
Purchase Order Entry, Shipto Address, CityorApplication Global Maintenance, City
Requisition/RequisitionHeader/CustomerParty/Location/Address/CountrySubDivisionCodeshipto_address.stateapplication_global.state
Purchase Order Entry, Shipto Address, StateApplication Global Maintenance, State
Requisition/RequisitionHeader/CustomerParty/Location/Address/CountryCodeshipto_address.countryapplication_global.country
Purchase Order Entry, Shipto Address, CountryorApplication Global Maintenance, Country
Requisition/RequisitionHeader/CustomerParty/Location/Address/PostalCodeshipto_address.zipcodeapplication_global.zipcode
Purchase Order Entry, Shipto Address, ZipcodeorApplication Global Maintenance, Zip
Requisition/RequisitionHeader/CustomerParty/BuyerContact/Namepurc_requisition.buyer Purchase Requisition Entry, Buyer
Requisition/RequisitionHeader/SupplierParty/PartyIDs/IDpurc_requistion.vendor_ID Purchase Requistion Entry, Vendor ID
Requisition/RequisitionHeader/SupplierParty/Namevendor.name Vendor Maintenance, Name
@languageIDsettings.language_id SOA Maintenance, Language ID
Requisition/RequisitionHeader/SupplierParty/Location@type
Site
Requisition/RequisitionHeader/SupplierParty/Location/Namevendor.name Vendor Maintenance, Name
Requisition/RequisitionHeader/SupplierParty/Location/Address/AddressLinevendor.addr_1vendor.addr_2vendor.addr_3
Vendor Maintenance, Address fields
@sequence1: vendor.addr_12: vendor.addr_23: vendor.addr_3
Vendor Maintenance, Address fields
Requisition/RequisitionHeader/SupplierParty/Location/Address/CityNamevendor.city Vendor Maintenance, City
Requisition/RequisitionHeader/SupplierParty/Location/Address/CountrySubDivisionCodevendor.state Vendor Maintenance, State
Requisition/RequisitionHeader/SupplierParty/Location/Address/CountryCodevendor.country Vendor Maintenance, Country
Requisition/RequisitionHeader/SupplierParty/Location/Address/PostalCodevendor.zipcode Vendor Maintenance, Zip
Requisition/RequisitionHeader/SupplierParty/Contact/Namepurc_requisition.contact_first_namepurc_requistion.contact_initialpurc_requistion.contact_last_name
Purchase Requistion Entry, Contact tab, Contact fields
Requisition/RequisitionHeader/SupplierParty/Contact/JobTitle
August 13, 2009 92
Requisitionpurc_requistion.contact_position Purchase Requistion Entry, Contact tab, Pos field
Requisition/RequisitionHeader/SupplierParty/Contact/Communication/UseCode Phone, Fax, Email
August 13, 2009 93
RequisitionRequisition/RequisitionHeader/SupplierParty/Contact/Communication/UseCode/Code@listID
Communication Use Codes
Requisition/RequisitionHeader/SupplierParty/Contact/Communication/DialNumberpurc_requisition.contact_phonepurc_requistion.contact_mobilepurc_requisition.contact_fax
Purchase Requisition Entry, Contact tab, PhonePurchase Requistion Entry, Contact tab, MobilePurchase Requistion Entry, Contact tab, Fax
Requisition/RequisitionHeader/SupplierParty/Contact/Communication/URIpurc_requistion.contact_email Purchase Requistion, Entry, Contact tab, E-mail
Requisition/RequisitionHeader/ExtendedAmountpurc_requistion.total_amt_orderedPurchase Requistion Entry, Order Total
@currencyIDpurc_requistion.currency_id Purchase Requistion Entry, Currency ID. The system translates the currency ID to an ISO code using Code Mapping
Maintenance.
Requisition/RequisitionHeader/TotalAmountpurc_requistion.total_amt_orderedPurchase Requistion Entry, Order Total
@currencyIDpurc_requistion.currency_id Purchase Requistion Entry, Currency ID. The system translates the currency ID to an ISO code using Code Mapping
Maintenance.
Requisition/RequisitionHeader/BuyerParty/PartyIDs/ID@schemeName
System@schemeAgencyID
settings.instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID field
Requisition/RequisitionHeader/BuyerParty/Location/Address/CountrySubDivisionCode Country Sub-divisions
Requisition/RequisitionHeader/BuyerParty/Location/Address/CountryCode Countries
Requisition/RequisitionHeader/RequesterParty/PartyIDs/IDRequester~purc_requistion.requestor
Requester~Purchase Requistion Entry, Requestor
@accountingEntityapplication_global.mfg_entity_id Application Global Maintenance, Default Mfg Entity
@locationsettings.location_id SOA Maintenance, SOA Location
Requisition/RequisitionHeader/RequesterParty/Nameemployee.first_nameemployee.middle_initialemployee.last_name
Employee Maintenance, First/Mi/Last
@languageIDsettings.language_id SOA Maintenance, Language ID
Requisition/RequisitionHeader/RequesterParty/Contact/Nameemployee.first_nameemployee.middle_initialemployee.last_name
Employee Maintenance, First/Mi/Last
Requisition/RequisitionHeader/Approvers/SequencedApprover@sequence
1: Purchase Requisition Entry, Approvals, Approval 12: Purchase Requisition Entry, Approvals, Approval 23: Purchase Requisition Entry, Approvals, Approval 34: Purchase Requisition Entry, Approvals, Approval 4
Requisition/RequisitionLine/LineNumberpurc_req_line.line_no Purchase Requistion Entry, Lines, Ln#
Requisition/RequisitionLine/Descriptionpurc_req_line.part_idpart.descriptionpurc_req_line.service_idservice.description
If the item on the line is a part, then Purchase Requisition Entry, Lines, Part ID ~ Part Maintenance, Description.If the item on the line is a service, then Purchase Requisition Entry, Lines, Service ID ~ Outside Service Maintenance, Description
Requisition/RequisitionLine/Status/Codepurc_req_line.line_status Purchase Requisition Entry, Lines, Status. The system translates VISUAL codes as follows:
If VISUAL status=Draft, then status=Open
August 13, 2009 94
RequisitionIf VISUAL status=Ordered, then status=ConvertedIf VISUAL status=In Process, then status=OpenIf VISUAL status=Approved, then status=ApprovedIf VISUAL status=Cancelled/Void, then status=CanceledIf VISUAL status=Closed, then status=Rejected
@listID Requisition Status
Requisition/RequisitionLine/Status/Description Purchase Requisition Entry, Lines, Status. The system translates VISUAL codes as follows:
If VISUAL status=Draft, then status=OpenIf VISUAL status=Ordered, then status=ConvertedIf VISUAL status=In Process, then status=OpenIf VISUAL status=Approved, then status=ApprovedIf VISUAL status=Cancelled/Void, then status=CanceledIf VISUAL status=Closed, then status=Rejected
@languageIDsettings.language_id SOA Maintenance, Language ID
Requisition/RequisitionLine/Status/EffectiveDateTimepurc_req_line.status_eff_date
Requisition/RequisitionLine/Item/ServiceIndicatorpurc_req_line.service_id If field is blank, then serviceindicator=false. If field is populate, then service indicator=true
Requisition/RequisitionLine/Item/Descriptionpart.descriptionservice.description
If the item on the line is a part, then Part Maintenance, Description.If the item on the line is a service, then Outside Service Maintenance, Description
@languageIDsettings.language_id SOA Maintenance, Language ID
Requisition/RequisitionLine/Item/Classification@type
COMMODITY, PRODUCTLINE
Requisition/RequisitionLine/Item/Specification/Property/NameValuepart.eng_mstrpart.drawing_id
If name-EngineeringReference, then Part Maintenance, Eng Master Eng IDIf name=DrawingNumber, then Part Maintenance, Config Mgt tab, Drawing #
@name EngineeringReference, DrawingNumber
Requisition/RequisitionLine/Quantitypur_req_line.user_order_qty Purchase Requistion Entry, Lines, Quantity
@unitCodepur_req_line.purchase_um Purchase Requisition Entry, Lines, U/M
Requisition/RequisitionLine/UnitPrice/Amountpurc_req_line.unit_price Purchase Requisition, Entry, Lines, Unit Price
@currencyIDpurchase_req.currency_id Purchase Requistion Entry, Currency ID. The system translates the currency ID to an ISO code using Code Mapping
Maintenance.
Requisition/RequisitionLine/UnitPrice/PerQuantity 1
@unitCodepur_req_line.purchase_um Purchase Requisition Entry, Lines, U/M
Requisition/RequisitionLine/RequiredDeliveryDateTimepur_req_line.desired_recv_datepurchase_req.desired_recv_date
Purchase Requisition Entry, Lines, Desired Recv DateIf field is null, Purchase Requisition Entry, Desired Recv Date
Requisition/RequisitionLine/ShipToParty/Nameapplication_global.namepurc_req_line.warehouse_id
Application Global, NamePurchase Requisition Entry, Lines, Warehouse
Requisition/RequisitionLine/ShipToParty/Location/Address/AddressLinewarehouse_address.addr_1warehouse_address.addr_2warehouse_address.addr_3orapplication_global.addr_1application_global.addr_2application_global.addr_3
Warehouse Maintenance, Warehouse Address, Street Address fieldsorApplication Global Maintenance, Address fields
August 13, 2009 95
RequisitionRequisition/RequisitionLine/ShipToParty/Location/Address/CityName
warehouse_address.cityapplication_global.city
Warehouse Maintenance, Warehouse Address, CityorApplication Global Maintenance, City
Requisition/RequisitionLine/ShipToParty/Location/Address/CountrySubDivisionCodewarehouse_address.stateapplication_global.state
Application Global Maintenance, State
Requisition/RequisitionLine/ShipToParty/Location/Address/CountryCodewarehouse_address.countryapplication_global.country
Warehouse Maintenance, Warehouse Address, CountryorApplication Global Maintenance, Country
Requisition/RequisitionLine/ShipToParty/Location/Address/PostalCodewarehouse_address.zipcodeapplication_global.zipcode
Warehouse Maintenance, Warehouse Address, ZipcodeorApplication Global Maintenance, Zip
Requisition/RequisitionLine/FixedPriceItemIndicator False
Requisition/RequisitionLine/ShipToParty/Nameapplication_global.namepurc_req_line.warehouse_id
Application Global, NamePurchase Requisition Entry, Lines, Warehouse
Requisition/RequisitionLine/ShipToParty/Location/Address/AddressLinewarehouse_address.addr_1warehouse_address.addr_2warehouse_address.addr_3orapplication_global.addr_1application_global.addr_2application_global.addr_3
Warehouse Maintenance, Warehouse Address, Street Address fieldsorApplication Global Maintenance, Address fields
Requisition/RequisitionLine/ShipToParty/Location/Address/CityNamewarehouse_address.cityapplication_global.city
Warehouse Maintenance, Warehouse Address, CityorApplication Global Maintenance, City
Requisition/RequisitionLine/ShipToParty/Location/Address/CountrySubDivisionCodewarehouse_address.stateapplication_global.state
Application Global Maintenance, State
Requisition/RequisitionLine/ShipToParty/Location/Address/CountryCodewarehouse_address.countryapplication_global.country
Warehouse Maintenance, Warehouse Address, CountryorApplication Global Maintenance, Country
Requisition/RequisitionLine/ShipToParty/Location/Address/PostalCodewarehouse_address.zipcodeapplication_global.zipcode
Warehouse Maintenance, Warehouse Address, ZipcodeorApplication Global Maintenance, Zip
Requisition/RequisitionLine/RFQReference/DocumentIDpurc_rfq_req.rfq_id Purchase Requisition Entry, Show RFQs, RFQ ID
August 13, 2009 96
SalesOrderSalesOrder/SalesOrderHeader/DocumentID@agencyRole
Customer, Supplier on outbound BODs
SalesOrder/SalesOrderHeader/DocumentID/IDcustomer_order.id Customer Order Entry, Our Order ID
@accountingEntityapplication_global.default_mfg_entity
Application Global Maintenance, Default Mfg Entity
@locationsettings.location_id SOA Maintenance, SOA Location
@lidsettings.instance_id The system combines lid://infor.visual with the value in SOA Maintenance, Visual Instance ID
SalesOrder/SalesOrderHeader/DocumentID/RevisionIDcustomer_order.revision_id Not displayed in Customer Order Entry window. Available in Order ID browse table.
SalesOrder/SalesOrderHeader/LastModificationDateTime The system uses the date that it created the BOD
SalesOrder/SalesOrderHeader/DocumentDateTimecustomer_order.create_date Not displayed in Customer Order Entry window. Available in Order ID browse table.
SalesOrder/SalesOrderHeader/Notecustomer_order.notations Customer Order Entry, Order Notations
@languageID Customer Order Entry, Order Notations
@author Customer Order Entry, Order Notations
@entryDateTime Customer Order Entry, Order Notations
SalesOrder/SalesOrderHeader/Status/Codecustomer_order.status Customer Order Entry, Status.
@listID Sales Order Status
@listAgencyID Infor
SalesOrder/SalesOrderHeader/Status/EffectiveDateTimecustomer_order.status_eff_date Not displayed in Customer Order Entry window. Available in Order ID browse table.
SalesOrder/SalesOrderHeader/CustomerParty/PartyIDs/ID@schemeName
System
SalesOrder/SalesOrderHeader/CustomerParty/Namecustomer_order.customer_id Customer Order Entry, Customer ID
@languageIDsettings.language_id SOA Maintenance, Language ID
SalesOrder/SalesOrderHeader/CustomerParty/Location/Address/AddressLinecustomer.bill_to_addr1customer.bill_to_addr2customer.bill_to_addr3
customer.addr1customer.addr2customer.addr3
Customer Maintenance, Bill To Address fields
If Bill To Address fields are null, then Customer Maintenance, Address fields
@sequence1: customer.bill_to_addr12: customer.bill_to_addr23: customer.bill_to_addr3
1: customer.addr12: customer.addr23. customer.addr3
Customer Maintenance, Bill To Address fields
If Bill To Address fields are null, then Customer Maintenance, Address fields
SalesOrder/SalesOrderHeader/CustomerParty/Location/Address/CityNamecustomer.bill_to_city
customer.city
Customer Maintenance, Bill To City
If Bill To City field is null, then Customer Maintenance, City
August 13, 2009 97
SalesOrderSalesOrder/SalesOrderHeader/CustomerParty/Location/Address/CountrySubDivisionCode
customer.bill_to_state
customer.state
Customer Maintenance, Bill To State
If Bill To State field is null, then Customer Maintenance, State@listID
Country Sub-divisions@listAgencyID
ISO
SalesOrder/SalesOrderHeader/CustomerParty/Location/Address/CountryCodecustomer.bill_to_country
customer.country
Customer Maintenance, Bill To Country
If Bill To Country field is null, then Customer Maintenance, Country@listID
Countries@listAgencyID
ISO
SalesOrder/SalesOrderHeader/CustomerParty/Location/Address/PostalCodecustomer.bill_to_zipcode
customer.zipcode
Customer Maintenance, Bill To Zip
If Bill To City field is null, then Customer Maintenance, City@listID
Postal/Zip Code@listAgencyID
ISO
SalesOrder/SalesOrderHeader/CustomerParty/Contact/Namecustomer_order.contact_first_namecustomer_order.contact_initialcustomer_order.contact_last_name
Customer Order Entry, Contact tab, Contact fields
SalesOrder/SalesOrderHeader/CustomerParty/Contact/JobTitlecustomer_order.contact_position Customer Order Entry, Contact Tab, Pos
SalesOrder/SalesOrderHeader/CustomerParty/Contact/Communication/UseCode UseCode=phone, fax, or email
SalesOrder/SalesOrderHeader/CustomerParty/Contact/Communication/DialNumber1: customer_order.contact_phone2: customer_order.contact_mobile3: customer_order.contact_fax
1: Customer Order Entry, Contact tab, Phone2: Customer Order Entry, Contact tab, Mobile3: Customer Order Entry, Contact tab, Fax
SalesOrder/SalesOrderHeader/CustomerParty/Contact/Communication/URIcustomer_order.contact_email Customer Order Entry, Contact tab, Email
SalesOrder/SalesOrderHeader/SupplierParty/Location/Nameapplication_global.name Application Global, Name
SalesOrder/SalesOrderHeader/SupplierParty/Location/Address/AddressLine1: application_global.addr_12: application_global.addr_23: application_global.addr_3
Application Global Maintenance, Address fields
@sequenceapplication_global.addr_1application_global.addr_2application_global.addr_3
Application Global Maintenance, Address fields
SalesOrder/SalesOrderHeader/SupplierParty/Location/Address/CityNameapplication_global.city Application Global Maintenance, City
August 13, 2009 98
SalesOrderSalesOrder/SalesOrderHeader/SupplierParty/Location/Address/CountrySubDivisionCode
application_global.state Application Global Maintenance, State@listID
Country Sub-divisions@listAgencyID
ISO
SalesOrder/SalesOrderHeader/SupplierParty/Location/Address/CountryCodeapplication_global.country Application Global Maintenance, Country
@listID Countries
@listAgencyID ISO
SalesOrder/SalesOrderHeader/SupplierParty/Location/Address/PostalCodeapplication_global.zipcode Application Global Maintenance, Zip
@listID Postal/Zip Codes
@listAgencyID ISO
SalesOrder/SalesOrderHeader/SupplierParty/SalesContact/Namesales_rep.name Sales Reps, Name
SalesOrder/SalesOrderHeader/ShipToParty/Location/Namecustomer_order.customer_id Customer Order Entry, Customer ID
SalesOrder/SalesOrderHeader/ShipToParty/Location/Address/AddressLine1: customer_address.addr_12: customer_address.addr_23: customer_address.addr_3
Customer Order Entry, Shipping Address, Address fields for the corresponding Ship To ID
@sequence1: customer_address.addr_12: customer_address.addr_23: customer_address.addr_3
Customer Order Entry, Shipping Address, Address fields
SalesOrder/SalesOrderHeader/ShipToParty/Location/Address/CityNamecustomer_address.city Customer Order Entry, Shipping Address, City for the corresponding Ship To ID
SalesOrder/SalesOrderHeader/ShipToParty/Location/Address/CountrySubDivisionCodecustomer_address.state Customer Order Entry, Shipping Address, State for the corresponding Ship To ID
@listID Country Sub-divisions
@listAgencyID ISO
SalesOrder/SalesOrderHeader/ShipToParty/Location/Address/CountryCodecustomer_address.country Customer Order Entry, Shipping Address, Country for the corresponding Ship To ID
@listID Countries
@listAgencyID ISO
SalesOrder/SalesOrderHeader/ShipToParty/Location/Address/PostalCodecustomer_address.zipcode Customer Order Entry, Shipping Address, Zip for the corresponding Ship To ID
@listID Postal/Zip Codes
@listAgencyID ISO
SalesOrder/SalesOrderHeader/ContractReference/IDcustomer_order.contract_id Customer Order Entry, EDI tab, Contract ID
SalesOrder/SalesOrderHeader/ExtendedAmountcustomer_order_line.extension The system adds the Extended Amounts for each line in the Customer Order. The system displays the total under the lines table.
@currencyIDcustomer_order.currency_id Customer Order Entry, Monetary tab, Currency ID. The system translates this code to the ISO code based on your settings in
Code Mapping Maintenance.
SalesOrder/SalesOrderHeader/TotalAmount The system adds the extension, freight, and tax amounts for all lines in Customer Order Entry and subtracts the discounts for all
lines. The system displays the total as the Grand Total (under the Lines table)@currencyID
August 13, 2009 99
SalesOrdercustomer_order.currency_id Customer Order Entry, Monetary tab, Currency ID. The system translates this code to the ISO code based on your settings in
Code Mapping Maintenance.
SalesOrder/SalesOrderHeader/BillToParty/PartyIDs/IDcustomer_order.customer_id Customer Order Entry, Customer ID
@schemeName System
SalesOrder/SalesOrderHeader/BillToParty/Location/Namecustomer.bill_nameif null, then customer.name
Customer Maintenance, Bill To Name
If null, then Customer Maintenance, Sold To Name
SalesOrder/SalesOrderHeader/BillToParty/Location/Address/AddressLinecustomer.bill_to_addr1, customer.bill_to_addr2, customer.bill_to_addr3.
if bill to address fields are null, then customer.addr1, customer.addr2, customer.addr3
Customer Maintenance, Bill To Address fields
If Bill To Address fields are null, then Customer Maintenance, Address fields
@sequence1: customer.bill_to_addr12: customer.bill_to_addr23: customer.bill_to_addr3
if bill to address fields are null, then:1: customer.addr12: customer.addr23. customer.addr3
Customer Maintenance, Bill To Address fields
If Bill To Address fields are null, then Customer Maintenance, Address fields
SalesOrder/SalesOrderHeader/BillToParty/Location/Address/CityNamecustomer.bill_to_city
if bill to city field is null, then:customer.city
Customer Maintenance, Bill To City
If Bill To City field is null, then Customer Maintenance, City
SalesOrder/SalesOrderHeader/BillToParty/Location/Address/CountrySubDivisionCodecustomer.bill_to_state
if bill to country field is null, then:customer.state
Customer Maintenance, Bill To State
If Bill To State field is null, then Customer Maintenance, State
@listID Country Sub-divisions
@listAgencyID ISO
SalesOrder/SalesOrderHeader/BillToParty/Location/Address/CountryCodecustomer.bill_to_country
if bill to country field is null, then:customer.country
Customer Maintenance, Bill To Country
If Bill To Country field is null, then Customer Maintenance, Country
@listID Countries
@listAgencyID ISO
August 13, 2009 100
SalesOrderSalesOrder/SalesOrderHeader/BillToParty/Location/Address/PostalCode
customer.bill_to_zipcode
if bill to zip field is null, then:customer.zipcode
Customer Maintenance, Bill To Zip
If Bill To City field is null, then Customer Maintenance, City
@listID Postal/Zip Codes
@listAgencyID ISO
SalesOrder/SalesOrderHeader/CarrierParty/PartyIDs/IDcustomer_order.carrier_id Customer Order Entry, Carrier ID
@schemeName System
SalesOrder/SalesOrderHeader/CarrierParty/Location/Namecarrier.name Application Global Maintenance, Carriers, Name based on the Carrier ID selected in Customer Order Entry, Carrier ID or, if null,
Customer Maintenance, Shipping Tab, Carrier ID
SalesOrder/SalesOrderHeader/CarrierParty/Location/Address/AddressLine1: carrier.addr12: carrier.addr23: carrier.addr3
Application Global Maintenance, Carriers, Address fields based on the Carrier ID selected in Customer Order Entry, Carrier ID or, if null, Customer Maintenance, Shipping Tab, Carrier ID
@sequence1: carrier.addr12: carrier.addr23: carrier.addr3
Application Global Maintenance, Carriers, Address fields based on the Carrier ID selected in Customer Order Entry, Carrier ID or, if null, Customer Maintenance, Shipping Tab, Carrier ID
SalesOrder/SalesOrderHeader/CarrierParty/Location/Address/CityNamecarrier.city Application Global Maintenance, Carriers, City based on the Carrier ID selected in Customer Order Entry, Carrier ID or, if null,
Customer Maintenance, Shipping Tab, Carrier ID
SalesOrder/SalesOrderHeader/CarrierParty/Location/Address/CountrySubDivisionCodecarrier.state Application Global Maintenance, Carriers, State based on the Carrier ID selected in Customer Order Entry, Carrier ID or, if null,
Customer Maintenance, Shipping Tab, Carrier ID@listID
Country Sub-divisions@listAgencyID
ISO
SalesOrder/SalesOrderHeader/CarrierParty/Location/Address/CountryCodecarrier.country Application Global Maintenance, Carriers, Country based on the Carrier ID selected in Customer Order Entry, Carrier ID or, if
null, Customer Maintenance, Shipping Tab, Carrier ID@listID
Countries@listAgencyID
ISO
SalesOrder/SalesOrderHeader/CarrierParty/Location/Address/PostalCodecarrier.zip Application Global Maintenance, Carriers, Zip based on the Carrier ID selected in Customer Order Entry, Carrier ID or, if null,
Customer Maintenance, Shipping Tab, Carrier ID@listID
Postal/Zip Codes@listAgencyID
ISO
SalesOrder/SalesOrderHeader/EarlyShipmentAllowedIndicatorcustomer_order.accept_early Customer Order Entry, Other tab, Accept Early. If selected, then EarlyShipmentAllowedIndicator="True". All else="False"
SalesOrder/SalesOrderHeader/PaymentTerm/Descriptioncustomer_order.terms_net_typecustomer_order.terms_net_dayscustomer_order.terms_net_datecustomer_order.terms_disc_typecustomer_order.terms_disc_dayscustomer_order.terms_disc_datecustomer_order.terms_disc_percentcustomer_order.terms_description
Customer Order Entry, Monetary tab, Terms
@languageIDsettings.language_id SOA Maintenance, Language ID
August 13, 2009 101
SalesOrderSalesOrder/SalesOrderHeader/RequestedShipDateTime
customer_order.desired_ship_date
Customer Order Entry, Desired Ship Date
SalesOrder/SalesOrderHeader/PromisedShipDateTimecustomer_order.promised_date Customer Order Entry, Promised Ship Date
SalesOrder/SalesOrderHeader/BackOrderIndicatorcustomer_order.back_order If Customer Order Entry, Other tab, Is separate Back order is selected, then indicator=true. Otherwise, indicator=false
SalesOrder/SalesOrderHeader/PurchaseOrderReference/DocumentID/IDcustomer_order.customer_po_ref Customer Order Entry, Customer PO
SalesOrder/SalesOrderHeader/SalesPersonReference/IDs/IDSales_rep~customer_order.salesrep_id
Sales_rep~Customer Order Entry, Other tab, Sales Rep
@accountingEntityapplication_global.entity_id Application Global Maintenance, Default Mfg Entity
@locationsettings.location_id SOA Maintenance, SOA Location
SalesOrder/SalesOrderHeader/SalesPersonReference/Namesales_rep.name Sales Reps, Name
@languageIDsettings.language_id SOA Maintenance, Language ID
SalesOrder/SalesOrderHeader/ExtendedPretaxAmount The system subtracts total of the tax amount for all lines from the total of extended amounts for all lines.
@currencyIDcurrency.currency_id Exchange Rate Maintenance, Currency Maintenance, Currency ID marked as system currency
SalesOrder/SalesOrderHeader/SubTotalAmount The system subtracts total of the tax amount for all lines from the total of extended amounts for all lines.
@currencyIDcurrency.currency_id Exchange Rate Maintenance, Currency Maintenance, Currency ID marked as system currency
SalesOrder/SalesOrderHeader/BaseCurrencyAmount@type
TotalAmount, ExtendedAmount, ExtendedPretaxAmount, SubtotalAmount,
SalesOrder/SalesOrderHeader/BaseCurrencyAmount/AmountFor type=TotalAmountFor type=ExtendedAmountFor type-ExtendedPretaxAmountFor type=SubtotalAmount
For type=TotalAmount: The system adds the extension, freight, and tax amounts for all lines in Customer Order Entry and subtracts the discounts for all lines. The system displays the total as the Grand Total (under the Lines table). If the invoice currency is not the same as the system currency, the system converts the amounts to the system currency based on the exchange rate in effect at the time of the transaction.For type=ExtendedAmount: The system adds the Extended Amounts for each line in the Customer Order. The system displays the total under the lines table. If the invoice currency is not the same as the system currency, the system converts the amounts to the system currency based on the exchange rate in effect at the time of the transaction.For type-ExtendedPretaxAmount: The system subtracts total of the tax amount for all lines from the total of extended amounts for all lines. The system subtracts total of the tax amount for all lines from the total of extended amounts for all lines. If the invoice currency is not the same as the system currency, the system converts the amounts to the system currency based on the exchange rate in effect at the time of the transaction.For type=SubtotalAmount: The system subtracts total of the tax amount for all lines from the total of extended amounts for all lines. If the invoice currency is not the same as the system currency, the system converts the amounts to the system currency based on the exchange rate in effect at the time of the transaction.
@currencyIDcurrency.currency_id Exchange Rate Maintenance, Currency Maintenance, Currency ID marked as system currency
SalesOrder/SalesOrderLine/LineNumbercust_order_line.line_no Customer Order Entry, Lines, Ln#
SalesOrder/SalesOrderLine/Status/Codecust_order_line.line_satus Defaults to Customer Order Entry, Status.
Customer Order Entry, Lines, Ln Closed Short If the Customer Order is active and the amount in Customer Order Entry, Lines, User Shipped Quantity is greater than zero but less than the Quantity, then status=PartialShipped. Otherwise, status=Shipped. If the line has been fully invoiced, then status=Invoiced.
@listID Sales Order Status
August 13, 2009 102
SalesOrder@listAgencyID
Infor
SalesOrder/SalesOrderLine/Status/EffectiveDateTime If the Line Closed Short check box is selected, use the Actual Ship Date (CUST_ORDER_LINE.ACTUAL_SHIP_DATE) where
the Last Shipped Date (CUSTOMER_ORDER_LINE.LAST_SHIPPED_DATE) is not null.
SalesOrder/SalesOrderLine/Item/ItemID/IDcust_order_line.part_id If Last Shipped Date is blank, use the date the Customer Order was created (CUSTOMER_ORDER.CREATE_DATE).
SalesOrder/SalesOrderLine/Item/ServiceIndicatorcust_order_line.service_charge_idCustomer Order Entry, Lines, Service Charge ID. If populated, then ServiceIndicator=True. If null, then ServiceIndicator=False
SalesOrder/SalesOrderLine/Item/Descriptionpart.descriptionservice.description
Part Maintenance, DescriptionOutside Service Maintenance, Description
SalesOrder/SalesOrderLine/Quantitycust_order_line.user_order_qty Customer Order Entry, Lines, Quantity
@unitCodecust_order_line.selling_um Customer Order Entry, Lines, UM
SalesOrder/SalesOrderLine/UnitPrice/Amountcust_order_line.unit_price Customer Order Entry, Lines, Unit Price
@currencyIDcustomer_order.currency_id Customer Order Entry, Currency ID
SalesOrder/SalesOrderLine/UnitPrice/PerQuantity 1
@unitCodecust_order_line.selling_um Customer Order Entry, Lines, UM
SalesOrder/SalesOrderLine/ExtendedAmountcust_order_line.user_order_qtycust_order_line.unit_pricecust_order_line.trade_disc_percent
The system calculates as follows:Customer Order Entry, Lines, Qty multiplied by Customer Order Entry, Lines, Unit Price multiplied by (1 minus Customer Order Entry, Lines, Disc%/100)
@currencyIDcustomer_order.currency_id Customer Order Entry, Currency ID
SalesOrder/SalesOrderLine/TotalAmountcust_order_line.user_order_qtycust_order_line.unit_pricecust_order_line.trade_disc_percentcust_order_line.sales_tax_group_id
The system calculates as follows:(Customer Order Entry, Lines, Qty multiplied by Customer Order Entry, Lines, Unit Price multiplied by (1 minus Customer Order Entry, Lines, Disc%/100)) plus ((Customer Order Entry, Lines, Qty multiplied by Customer Order Entry, Lines, Unit Price multiplied by (1 minus Customer Order Entry, Lines, Disc%/100)) multiplied by Sales Tax Group Maintenance, Sales Tax Percent)
@currencyIDcustomer_order.currency_id Customer Order Entry, Currency ID
SalesOrder/SalesOrderLine/ShipToParty/Location/Namecustomer_order.customer_id Customer Order Entry, Shipping Address, Name for the corresponding Ship To ID. If Ship To ID on Customer Order Entry, Lines
is null, then use Shipto ID on header.
SalesOrder/SalesOrderLine/ShipToParty/Location/Address/AddressLine1: customer_address.addr_12: customer_address.addr_23: customer_address.addr_3
Customer Order Entry, Shipping Address, Address fields for the corresponding Ship To ID
@sequence1: customer_address.addr_12: customer_address.addr_23: customer_address.addr_3
1: Customer Order Entry, Shipping Address, Address fields
SalesOrder/SalesOrderLine/ShipToParty/Location/Address/CityNamecustomer_address.city Customer Order Entry, Shipping Address, City for the corresponding Ship To ID
SalesOrder/SalesOrderLine/ShipToParty/Location/Address/CountrySubDivisionCodecustomer_address.state Customer Order Entry, Shipping Address, State for the corresponding Ship To ID
SalesOrder/SalesOrderLine/ShipToParty/Location/Address/CountryCodecustomer_address.country Customer Order Entry, Shipping Address, Country for the corresponding Ship To ID
SalesOrder/SalesOrderLine/ShipToParty/Location/Address/PostalCodecustomer_address.zipcode Customer Order Entry, Shipping Address, Zip for the corresponding Ship To ID
SalesOrder/SalesOrderLine/EarlyShipmentAllowedIndicatorcust_order_line.accept_early Customer Order Entry, Lines, Accept Early. If null, then Customer Order Entry, Accept Early
August 13, 2009 103
SalesOrder
or
customer_order.accept_early
SalesOrder/SalesOrderLine/RequiredDeliveryDateTimecust_line_del.desired_ship_date Customer Order Entry, Delivery Schedule, Desired Ship Date
SalesOrder/SalesOrderLine/PromisedShipDateTimecust_order_line.promise_date
or
customer_order.promise_date
Customer Order Entry, Lines, Promise Ship Date. If null, then Customer Order, Promise Ship Date
SalesOrder/SalesOrderLine/ActualShipDateTimecust_order_line.last_shipped_dateCustomer Order Entry, Lines, Ship Date
SalesOrder/SalesOrderLine/ShipFromParty/Location@type
Warehouse
SalesOrder/SalesOrderLine/ShipFromParty/Location/IDcust_order_line.warehouse_id Customer Order Entry, Lines, Warehouse ID
@schemeName System
SalesOrder/SalesOrderLine/ShipFromParty/Location/Namewarehouse_address.name
SalesOrder/SalesOrderLine/ShipFromParty/Location/Address/AddressLinewarehouse_address.addr_1warehouse_address.addr_2warehuose_address.addr_3
Warehouse Maintenance, Warehouse Address, Street Addres fields
@sequence1: warehouse_address.addr_12: warehouse_address.addr_23: warehuose_address.addr_3
Warehouse Maintenance, Warehouse Address, Street Addres fields
SalesOrder/SalesOrderLine/ShipFromParty/Location/Address/CityNamewarehouse_address.city Warehouse Maintenance, Warehouse Address, City
SalesOrder/SalesOrderLine/ShipFromParty/Location/Address/CountrySubDivisionCodewarehouse_address.state Warehouse Maintenance, Warehouse Address, State
@listID Country Sub-divisions
SalesOrder/SalesOrderLine/ShipFromParty/Location/Address/CountryCodewarehouse_address.country Warehouse Maintenance, Warehouse Address, Country
@listID Countries
@listAgencyID ISO
SalesOrder/SalesOrderLine/ShipFromParty/Location/Address/PostalCodewarehouse_address.zipcode Warehouse Maintenance, Warehouse Address, Zip
@listID Postal/Zip Codes
August 13, 2009 104
SalesOrder@listAgencyID
ISO
SalesOrder/SalesOrderLine/AllocatedQuantitycust_order_line.allocate_qty Customer Order Entry, Lines, Allocate Qty
@unitCodecust_order_line.selling_um Customer Order Entry, Lines, UM
SalesOrder/SalesOrderLine/SalesOrderSchedule/LineNumbercust_line_del.del_sched_line_no Customer Order Entry, Delivery Schedule, Ln#
If no delivery schedule exists for the line, then 0
SalesOrder/SalesOrderLine/SalesOrderSchedule/Quantitycust_line_del.user_order_qtycust_order_line.user_order_qty
If no delivery schedule exists for the line, then Customer Order Entry, Lines, Qty
@unitCodecust_order_line.selling_um Customer Order Entry, Lines, UM
SalesOrder/SalesOrderLine/SalesOrderSchedule/Status/Codecust_order_line.line_status Customer Order Entry, Lines, Ln Closed Short
If the Customer Order is active and the amount in Customer Order Entry, Lines, User Shipped Quantity is greater than zero but less than the Quantity, then status=PartialShipped. Otherwise, status=Shipped. If the line has been fully invoiced, then status=Invoiced.Defaults to Customer Order Entry, Status.
@listID Sales Order Status
@listAgencyID Infor
SalesOrder/SalesOrderLine/SalesOrderSchedule/Status/EffectiveDateTime If the Line Closed Short check box is selected, use the Actual Ship Date (CUST_ORDER_LINE.ACTUAL_SHIP_DATE) where
the Last Shipped Date (CUSTOMER_ORDER_LINE.LAST_SHIPPED_DATE) is not null.
SalesOrder/SalesOrderLine/SalesOrderSchedule/RequiredDeliveryDateTimecust_line_del.desired_ship_datecust_order_line.desired_ship_Date
Customer Order Entry, Delivery Schedule, Desired Ship DateIf no delivery schedule existis for the line, Customer Order Entry, Lines, Desired Ship Date
SalesOrder/SalesOrderLine/SalesOrderSchedule/PromisedShipDateTimecust_order_line.promise_date Customer Order Entry, Lines, Promise Ship Date
SalesOrder/SalesOrderLine/SalesOrderSchedule/PromisedDeliveryDateTimecust_order_line.promise_del_date Customer Order Entry, Lines, Promised Del Date
August 13, 2009 105
ShipmentShipment/ShipmentHeader/DocumentID@agencyRole
Shipper
Shipment/ShipmentHeader/DocumentID/IDfor type=shipper: shipper+shipper.packlist_id+shipper_line.line_nofor type=ibtshipper: ibtshipper+ibt_shipper.shipper_id+ibt_shipper_line.line_nofor type=poreturnreceipt: poreturnreceipt+receiver_line.receiver_id+receiver_line.line_nofor type=woissue: woissue+inventory_transaction.transaction_idfor type=woreceiptrtn: woreceiptrtn+inventory_transaction.transaction_idfor type=cnsnreciptrtn: consign_receiver.receiver_id+consign_receiver_line.line_no
For type=shipper: Shipper ~ Shipping Entry, Packlist ID ~ Shipping Entry, Lines, Line No. For example, Shipper~00006~1For type=IBTShipper: Inter Branch Transfer Shipping Entry, Shipper ID ~ Inter Branch Transfer Shipping Entry, IBT Ln #For type=POReturnReceipt: POReturnReceipt ~ Purchase Receipt Entry, Lines, Receiver ID ~ Purchase Receipt Entry, Line NoFor type=WOIssue: WOIssue ~ Inventory Transaction Entry, Transaction IDFor type=WOReceiptRtn: WOIssue ~ Inventory Transaction Entry, Transaction IDFor type=CNSNReceiptRtn: CNSNReceiptRtn ~ Consignment Receiving Entry, Receiver ID ~ Consignment Receiving Entry, Lines, Ln #
@locationsettings.location_id SOA Maintenance, SOA Location
@lidsettings.instance_id The system combines lid://infor.visual with the value in SOA Maintenance, Visual Instance ID.
Shipment/ShipmentHeader/LastModificationDateTime The system uses the date and time it created the BOD
Shipment/ShipmentHeader/DocumentDateTimefor type=shipper: shipper.create_datefor type=ibtshipper: ibt_shipper.create_datefor type=poreturnreceipt: receiver.received_datefor type=woissue, worecieptrtn: inventory_transaction.transaction_datefor type=cnsnreceiptrtn: consign_receiver.received_date
For type=shipper: Is not displayed on Shipping Entry window. Available in Packlist ID browse table.For type=IBTshipper: Is not dispalyed on Inter Branch Transfer Shipping Entrywindow. Available in Shipper ID browse tableFor type=POReturnReceipt: Purchase Receipt Entry, Act Recv DateFor type=WOIssue, WOReceiptRtn: Inventory Transaction Entry, Transaction DateFor type=CNSNReceiptRtn: Consignment Receiving, Receive Date
Shipment/ShipmentHeader/Notefor type=shipper: notations.note For type=shipper: Shipping Entry, Packlist Notations
Shipment/ShipmentHeader/Status/Codefor type=shipper: shipper.status For type=shipper: Displays below RMA ID
For type=IBTShipper, POReturnReceipt, WOIssue, WOReceiptRtn, CNSNReceiptRtn: If the transaction is deleted, then status is Cancelled. Otherwise, status is shipped
@listID Shipment Status (Supplier)
Shipment/ShipmentHeader/Status/Description For type=shipper: the system translates the code in shipper.status based on the settings in Code Mapping Maintenance.
For type=IBTshipper, POReturnReceipt, WOIssue, WOReceiptRtn, CNSNReceiptRtn: Cancelled or Shipped
Shipment/ShipmentHeader/Status/EffectiveDateTimefor type=shipper: shipper.status_eff_datefor type=ibtshipper: ibt.shipped_datefor type=poreturnreceipt: receiver.received_datefor type=woissue, woreceiptrtn: inventory_transaction.transaction_datefor type=cnsnreceiptrtn: consign_receiver.received_date
For type=shipper: Field not displayed on window. Available in Packlist ID browse table.For type=IBTshipper: If status is Shipped, then Inter Branch Transfer Entry, Other tab, Last Shipped. If status is cancelled, then the system uses the current date and time.For type=POReturnReceipt: Purchase Receipt Entry, Act Recv DateFor type=WOIssue, WOReceiptRtn: If status is shipped, then Inventory Transaction Entry, Transaction Date. If status is cancelled, then the system uses the current date and time.For type=CNSNReceiptRtn: If status is shipped, then Consignment Receiving, Receive Date. If status is cancelled, then the system uses the current date and time.
August 13, 2009 106
ShipmentShipment/ShipmentHeader/WarehouseLocation@type
type=warehouse
Shipment/ShipmentHeader/WarehouseLocation/IDfor type=shipper, ibtshipper, woissue, woreceiptrtn: inventory_transaction.warehouse_idfor type=poreturnreceipt: receiver_line.warehouse_idfor type=cnsnreceiptrtn: consign_rcvr_line.warehouse_id
For type=shipper, IBTshipper, WOIssue, WOReceiptRtn: Inventory Transaction Entry, Warehouse ID for transaction ID associated with shipment.For type=POReturnReceipt: Purchase Receipt Entry, Lines, Warehouse IDFor type=CNSNReceiverRtn: Consignment Receiving, Lines, Warehouse ID
Shipment/ShipmentHeader/WarehouseLocation/Namewarehouse_address.name Warehouse Maintenance, Warehouse Address, Name
Shipment/ShipmentHeader/WarehouseLocation/Address/AddressLinewarehouse_address.addr_1warehouse_address.addr_2warehouse_address.addr_3
Warehouse Maintenance, Warehouse Address, Address fields
@sequence1: warehouse_address.addr_12: warehouse_address.addr_23: warehouse_address.addr_3
Shipment/ShipmentHeader/WarehouseLocation/Address/CityNamewarehouse_address.city Warehouse Maintenance, Warehouse Address, City
Shipment/ShipmentHeader/WarehouseLocation/Address/CountrySubDivisionCodewarehouse_address.state Warehouse Maintenance, Warehouse Address, State
Shipment/ShipmentHeader/WarehouseLocation/Address/CountryCodewarehouse_address.country Warehouse Maintenance, Warehouse Address, Country
@listID Countries
Shipment/ShipmentHeader/WarehouseLocation/Address/PostalCodewarehouse_address.zip Warehouse Maintenance, Warehouse Address, Zip
@listID Postal/Zip Codes
Shipment/ShipmentHeader/ActualShipDateTimefor type=shipper: shipper.shipped_dateshipper.shipped_timefor type=poreturnreceipt: receiver.received_datefor type=woissue, woreceiptrtn: inventory_transaction.transaction_datefor type=cnsnreceiptrtn: consign_receiver.received_date
For type=shipper: Shipping Entry, Actual Ship Date plus shipper.shipped_time. Shipper.shipped_time not displayed on the Shipping Entry window. Available in the Packlist ID browse table.For type=POReturnReceipt: Purchase Receipt Entry, Act Recv DateFor type=WOIssue, WOReceiptRtn: Inventory Transaction Entry, Transaction DateFor type=CNSNReceiptRtn: Consignment Receiving, Receive Date
Shipment/ShipmentHeader/ScheduledDeliveryDateTimefor type=shipper: shipper.expected_del_dateshipper.expected_del_timeshipper.sched_del_date
For type=shipper: Shipping Entry, Edit Packlist, Expected Del Date. Shipper.expected_del_time not displayed on Shipping Entry window. Available in Packlist ID browse table.If fields are null, then Shipper, Promise Ship Date
Shipment/ShipmentHeader/ActualDeliveryDateTimefor type=shipper:shipper.actual_del_dateshipper.expected_del_date
For type=shipper: Shipping Entry, Edit Packlist, Act Del Date. If null, then Shipping Entry, Edit Packlist, Exp Del Date.
Shipment/ShipmentHeader/TareWeightMeasurefor type=shipper: shipper.tare_weightfor type=ibtshipper: ibt_shipper_line.tare_weight
For type=shipper: Field not displayed on window. Available in Packlist ID browse table.For type=IBTshipper: Inter Branch Transfer Shipping Entry, Lines,
@unitCodefor type=shipper: shipper_line.weight_um
For type=shipper: Shipping Entry, Lines, Weight U/M. Translated to ISO code based on settings in Code Mapping Maintenance.For type=IBTShipper: IBT Shipping Entry, Lines, Weight U/M. Translated to ISO code based on settings in Code Mapping
August 13, 2009 107
Shipmentfor type=ibtshipper:ibt_shipper_line.weight_um
Maintenance.
Shipment/ShipmentHeader/NetWeightMeasurefor type=shipper: shipper.total_net_weightfor type=ibtshipper: ibt_shipper_line.net_ship_weight
For type=shipper: Field not displayed on window. Available in Packlist ID browse table.
@unitCodefor type=shipper: shipper_line.weight_umfor type=ibtshipper:ibt_shipper_line.weight_um
For type=shipper: Shipping Entry, Lines, Weight U/M. Translated to ISO code based on settings in Code Mapping Maintenance.For type=IBTShipper: IBT Shipping Entry, Lines, Weight U/M. Translated to ISO code based on settings in Code Mapping Maintenance.
Shipment/ShipmentHeader/GrossWeightMeasurefor type=shipper: shipper.total_gross_weightfor type=ibtshipper: ibt_shipper_line.shipping_weightfor type=poreturnreceipt: receiver_line.gross_weightfor type=cnsnreceiptrtn: consign_rcvr_line.gross_weight
For type=Shipper: Shipping Entry, Lines, Shipping WeightFor type=IBTShipper: IBT Shipping Entry, Lines, Per Unit Shipping WeightFor type=POReturnReceipt: Purchase Receipt Entry, Lines, Gross WeightFor type=CNSNReceiptRtn: Consignment Receiving, Lines, Gross Weight
@unitCodefor type=shipper: shipper_line.weight_umfor type=ibtshipper:ibt_shipper_line.weight_umfor type=poreturnreceipt:
For type=shipper: Shipping Entry, Lines, Weight U/M. Translated to ISO code based on settings in Code Mapping Maintenance.For type=IBTShipper: IBT Shipping Entry, Lines, Weight U/M. Translated to ISO code based on settings in Code Mapping Maintenance.
Shipment/ShipmentHeader/CountryOfOriginCodefor type=poreturnreceipt: receiver_line.orig_countryfor type=cnsnreceiptrtn: consign_rcvr_line.orig_country_id
For type=POReturnReceipt: Purchase Receipt Entry, Lines, Country of OriginFor type=CNSNReceiptRtn: Consignment Receiving, Lines, Orig Country
Shipment/ShipmentHeader/TransportationMethodCodefor type=shipper: shipper.ship_viafor type=ibtshipper: ibt_shipper.sihp_viafor type=poreturnreceipt: receiver.ship_viafor type=cnsnreceiptrtn: consign_receiver.ship_via
For type=shipper: Shipping Entry, Ship ViaFor type=IBTShipper: IBT Shipping Entry, Ship ViaFor type=POReturnReceipt: Purchase Receipt Entry, Other tab, Ship ViaFor type=CNSNReceiptRtn: Consignment Receiving, Ship Via
Shipment/ShipmentHeader/ShipFromParty/PartyIDs/ID For type=shipper, IBTshipper, CNSNReceiptRtn: COMPANY
@schemeName System
Shipment/ShipmentHeader/ShipFromParty/Namefor type=shipper, ibtshipper, woissue, woreceiptrtn, cnsnreceiptrtn: application_global.company_name
For type=shipper, IBTShipper, WOIssue, WOReceiptRtn, CNSNReceiptRtn: Application Global Maintenance, General Tab, Name
@languageIDsettings.language_id SOA Maintenance, Language ID
Shipment/ShipmentHeader/ShipFromParty/Location@type
For type=shipper: Warehouse
Shipment/ShipmentHeader/ShipFromParty/Location/IDfor type=shipper: inventory_transaction.warehouse_idfor type=ibtshipper: ibt.from_whse_id
For type=shipper: Location Type ~ Inventory Transaction Entry, Warehouse IDFor type=IBTshipper: Location Type ~ Inter Branch Transfer Entry, From Whse ID ~ IBT.SHIP_FROM_ADDR_NO (no is not displayed in window)For type=POReturnReceipt, WOIssue, WOReceiptRtn, CNSNReceiptRtn: Location Type ~ Application Global Maintenance, Name
August 13, 2009 108
Shipmentibt.ship_from_addr_nofor type=poreturnreceipt, woissue, woreceiptrtn, cnsnreceiptrtn: location type ~ application_global.company_name
@schemeName System
August 13, 2009 109
Shipment@schemeAgencyName
settings.instance_id The system combines infor.visual with the value in the Visual Instance ID field.
Shipment/ShipmentHeader/ShipFromParty/Location/Namefor type=shipper, ibtshipper: warehouse_address.namefor type=poreturnreceipt, woissue, woreceiptrtn, cnsnreceptrtn: application_global.company_name
For type=shipper, IBTShipper: Warehouse Maintenance, Warehouse Address, NameFor type=POReturnReceipt, WOIssue, WOReceiptRtn, CNSNReceiptRtn: Application Global Maintenance, General Tab, Name
Shipment/ShipmentHeader/ShipFromParty/Location/Address/AddressLine@sequence
for type=shipper, ibtshipper: 1: warehouse_address.addr_12: warehouse_address.addr_23: warehouse_address.addr_3
for type=poreturnreceipt, woissue, woreturnreceipt, cnsnreceiptrtn:1: application_global.addr_12: application_global.addr_23: application_global.addr_3
For type=shipper, IBTshipper: Warehouse Maintenance, Warehouse Address, Street Address fieldsFor type=POReturnReceipt, WOIssue, WOReturnReceipt, CNSNReceiptRtn: Application Global Maintenance, General Tab, Street Address fields
Shipment/ShipmentHeader/ShipFromParty/Location/Address/CityNamefor type=shipper, ibtshipper: warehouse_address.cityfor type=poreturnreceipt, woissue, woreceiptrtn: application_global.city
For type=Shipper: Warehouse Maintenance, Warehouse Address, CityFor type=POReturnReceipt, WOIssue, WOReceiptRtn: Application Global Maintenance, City
Shipment/ShipmentHeader/ShipFromParty/Location/Address/CountrySubDivisionCodefor type=shipper, ibtshipper: warehouse_address.statefor type=poreturnreceipt, woissue, woreceiptrtn, cnsnreceiptrtn: application_global.state
For type=shipper: Warehouse Maintenance, Warehouse Address, StateFor type=POReturnReceipt, WOIssue, WOReceiptRtn, CNSNReceiptRtn: Application Global Maintenance, General tab, State
@listID Country Sub-divisions
Shipment/ShipmentHeader/ShipFromParty/Location/Address/CountryCodefor type=shipper, ibtshipper: warehouse_address.countryfor type=poreturnreceipt, woissue, woreceiptrtn, cnsnreceiptrtn: application_global.country
For type=shipper: Warehouse Maintenance, Warehouse Address, CountryFor type=POReturnReceipt, WOIssue, WOReceiptRtn, CNSNReceiptRtn: Application Global Maintenance, General tab, Country
@listID Countries
Shipment/ShipmentHeader/ShipFromParty/Location/Address/PostalCodefor type=shipper, ibtshipper: warehouse_address.zipfor type=poreturnreceipt, woissue, woreceiptrtn, cnsnreceiptrtn: application_global.zipcode
For type=shipper: Warehouse Maintenance, Warehouse Address, ZipFor type=POReturnReceipt, WOIssue, WOReceiptRtn, CNSNReceiptRtn: Application Global Maintenance, General tab, Zip
@listID Postal/Zip Codes
Shipment/ShipmentHeader/CarrierParty/PartyIDs/IDfor type=shipper: customer_order.carrier_idfor type=ibtshipper: ibt.carrier_idfor type=poreturnreceipt: receiver.carrier_idfor type=cnsnreceiptrtn: consign_receiver.carrier_id
For type=shipper: Customer Order Entry, Sold to/Ship to tab, Carrier IDFor type=IBTShipper: Inter Branch Transfer Entry, Carrier IDFor type=POReturnReceipt: Purchase Receipt Entry, Carrier IDFor type=CNSNReceiptRtn: Consignment Receiving, Carrier ID
August 13, 2009 110
ShipmentShipment/ShipmentHeader/CarrierParty/Name
carrier.carrier_name Application Global Maintenance, Carriers, Name
Shipment/ShipmentHeader/CarrierParty/Location/Address/AddressLine1: carrier.addr_12: carrier.addr_23: carrier.addr_3
1: Application Global Maintenance, Carriers, Addr 12: Application Global Maintenance, Carriers, Addr 23: Application Global Maintenance, Carriers, Addr 3
@sequencecarrier.addr_1carrier.addr_2carrier.addr_3
Application Global Maintenance, Carriers, Addr 1Application Global Maintenance, Carriers, Addr 2Application Global Maintenance, Carriers, Addr 3
Shipment/ShipmentHeader/CarrierParty/Location/Address/CityNamecarrier.city Application Global Maintenance, Carriers, City
Shipment/ShipmentHeader/CarrierParty/Location/Address/CountrySubDivisionCodecarrier.state Application Global Maintenance, Carriers, State/Province
@listID Country Sub-divisions
Shipment/ShipmentHeader/CarrierParty/Location/Address/CountryCodecarrier.country Application Global Maintenance, Carriers, Country
@listID Countries
Shipment/ShipmentHeader/CarrierParty/Location/Address/PostalCodecarrier.zipcode Application Global Maintenance, Carriers, Zip/Postal Code
@listID Postal/Zip Codes
Shipment/ShipmentHeader/ShipToParty/PartyIDs/IDfor type=shipper: customer_order.customer_id
for type=poreturnreceipt: purchase_order.vendor_idfor type=cnsnreceiptrtn: consign_receiver.customer_id
For type=shipper: Customer Order Entry, Customer IDFor type=IBTShipper, WOIssue, WOReturnReceipt: COMPANYFor type=POReturnReceipt: Purchase Order Entry, Vendor IDFor type=CNSNReceiptRtn: Consignment Receiving, Customer tab, Customer ID
@schemeAgencyIDsettings.instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID.
Shipment/ShipmentHeader/ShipToParty/Namefor type=shipper, cnsnreceiptrtn: customer.customer_namefor type=ibtshipper, woissue, woreturnreceipt: application_global.company_namefor type=poreturnreceipt, cnsnreceiptrtn: vendor.vendor_name
For type=shipper, CNSNReceiptRtn: Customer Maintenance, NameFor type=IBTShipper, WOIssue, WOReturnReceipt: Application Global Maintenance, NameFor type=POReturnReceipt, CNSNReceiptRtn: Vendor Maintenance, Name
@languageID SOA Maintenance, Language ID
Shipment/ShipmentHeader/ShipToParty/Location/IDfor type=shipper: shipping_address.shipto_nofor type=ibtshipper: ibt.to_whse_idibt.ship_to_addr_nofor type=poreturnreceipt: purchase_order.purc_ord_addr_no
For type=shipper: Shipping Entry, Lines, Shipto #For type=IBTshipper: Inter Branch Transfer Entry, To Whse ID, IBT.SHIP_TO_ADDR_ID
@schemeAgencyNamesettings.instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID.
Shipment/ShipmentHeader/ShipToParty/Location/Namefor type=shipper: shipping_address.namefor type=ibtshipper: warehouse_address.namefor type=poreturnreceipt: vendor.
For type=shipper: Shipping Entry, Shipping Address, NameFor type IBTShipper: Warehouse Maintenance, Warehouse Address, NameFor type=POReturnReceipt: Vendor, Name or Purchase Order Entry, Purchase Addresses, Name
August 13, 2009 111
Shipmentname or purchase_address.name
Shipment/ShipmentHeader/ShipToParty/Location/Address/AddressLinefor type=ibtshipper: 1: warehouse_address.addr_12: warehouse_address.addr_23: warehouse_address.addr_3for type=poreturnreceipt:1: vendor.addr_12: vendor.addr_23. vendor.addr_3
1: purchase_address.addr_12: purchase_address.addr_23. purchase_address.addr_3for type=woissue, woreturnreceipt1: application_global.addr_12: application_global.addr_23: application_global.addr_3
For type=IBTShipper: Warehouse Mainteance, Warehouse Address, Street Address fieldsFor type=POReturn Receipt: Purchase Order Entry, Purchase Addresses, Street Address fieldsFor type=WOIssue, WOReturnReceipt: Application Global Maintenance, Street Address fields
Shipment/ShipmentHeader/ShipToParty/Location/Address/CityNamefor type=shipper: shipping_address.cityfor type=ibtshipper: warehouse_address.cityfor type=poreturnreceipt: purchase_address.cityfor type=woissue, woreturnreceipt: application_global.city
For type=shipper: Shipping Entry, Shipping Address, CityFor type=IBTShipper: Warehouse Maintenance, Warehouse Address, CityFor type=POReturnReceipt: Purchase Order Entry, Purchase Addresses, CityFor type=WOIssue, WOReturnReceipt: Application Global Maintenance, City
Shipment/ShipmentHeader/ShipToParty/Location/Address/CountrySubDivisionCodefor type=shipper: shipping_address.statefor type=ibtshipper: warehouse_address.statefor type=poreturnreceipt: purchase_address.statefor type=woissue, woreturnreceipt: application_global.state
For type=shipper: Shipping Entry, Shipping Address, StateFor type=IBTShipper: Warehouse Maintenance, Warehouse Address, StateFor type=POReturnReceipt: Purchase Order Entry, Purchase Addresses, StateFor type=WOIssue, WOReturnReceipt: Application Global Maintenance, State
@listID Country Sub-divisions
Shipment/ShipmentHeader/ShipToParty/Location/Address/CountryCodefor type=shipper: shipping_address.countryfor type=ibtshipper: warehouse_address.countryfor type=poreturnreceipt: purcase_address.countryfor type=woissue, woreturnreceipt: application_global.country
For type=shipper: Shipping Entry, Shipping Address, CountryFor type=IBTshipper: Warehouse Maintenance, Warehouse Address, CountryFor type=POReturnReceipt: Purchase Order Entry, Purchase Address, CountryFor type=WOIssue, WOReturnReceipt: Application Global Maintenance, Country
@listID Countries
Shipment/ShipmentHeader/ShipToParty/Location/Address/PostalCodefor type=shipper: shipping_address.zipfor type=ibtshipper: warehouse_address.zipfor type=poreturnreceipt: purchase_address.zipfor type=woissue, woreturnreceipt: application_global.zip
For type=shipper: Shipping Entry, Shipping Address, ZipFor type=IBTshipper: Warehouse Maintenance, Warehouse Address, ZipcodeFor type=POReturnReceipt: Purchase Order Entry, Purchase Address, ZipcodeFor type=WOIssue, WOReturnReceipt: Application Global Maintenance, Zipcode
@listID
August 13, 2009 112
Shipment Postal/Zip Codes
Shipment/ShipmentHeader/ScheduledShipDateTimefor type=shipper: shipping.desired_ship_date
For type=shipper: Shipping Entry, Desired Ship Date
Shipment/ShipmentItem/ItemID/IDfor type=shipper: customer_order_line.part_idfor type=ibtshipper: ibt_line.part_idfor type=poreturnreceipt: purc_order_line.part_idpurc_order_line.service_idfor type=woissue, woreturnreceipt: inventory_transaction.part_idfor type=cnsnreceiptrtn: consign_rcvr_line.part_id
For type=shipper: Customer Order Entry, Lines, Part IDFor type=IBTshipper: Inter Branct Transfer Entry, Lines, Part IDFor type=POReturnReceipt: Purchase Order Entry, Lines, Part ID or Service IDFor type=WOIssue, WOReturnReceipt: Inventory Transaction Entry, Part IDFor type=CNSNReceiptRtn: Consignment Receiving, Lines, Part ID
@accountingEntityapplication_global.entity_id Application Global Maintenance, Default Manufacturing Entity
@locationsettings.location_id SOA Maintenance, Location ID
August 13, 2009 113
ShipmentShipment/ShipmentItem/ServiceIndicator
For type=WOIssue, WOReturnReceipt, CNSNReceiptRtn: False
Shipment/ShipmentItem/Classification@type
Type=PRODUCTLINE, COMMODITY
Shipment/ShipmentItem/Classification/Codes/Codefor type=productline: part.product_codefor type=commodity: part.commodity_code
For type=PRODUCTLINE: Part Maintenance, Product CodeFor type=COMMODITY: Part Maintenance, Commodity Code
@listID Product Lines, Commodity Codes
Shipment/ShipmentItem/ImportLicenseRequiredIndicator False
Shipment/ShipmentItem/OrderQuantityfor type=shipper: cust_order_line.user_order_qtyfor type=ibtshipper: ibt_line.user_order_qty
For type=shipper: Customer Order Entry, Lines, QuantityFor type=IBTshipper: Inter Branch Transfer Entry, Lines, Quantity
@unitCodefor type=shipper: cust_order_line.selling_umfro type=ibtshipper: ibt_line.ibt_um
For type=shipper: Customer Order Entry, Lines, U/M
Shipment/ShipmentItem/ShippedQuantityfor type=shipper: shipper_line.usr_shipped_qtyfor type=ibtshipper: ibt_line.usr_shipped_qtyfor type=poreturnreceipt: for type=woissue, woreturnreceipt: inventory_transaction.qtyfor type=cnsnreceiptrtn:
For type=shipper: Shipping Entry, Lines, Qty ShippedFor type=IBTshipper: Inter Branch Transfer Entry, Lines, Qty ShippedFor type=WOIssue, WOReturnReceipt: Inventory Transaction, Quantity
@unitCodefor type=shipper: cust_order_line.selling_umfor type=ibtshipper: ibt_line.ibt_umfor type=woissue, woreturnreceipt: part.stock_um
For type=shipper: Customer Order Entry, Lines, U/MFor type=WOIssue, WOReturnReceipt: Part Maintenance, Stock U/M
Shipment/ShipmentItem/OpenQuantityfor type=ibtshipper: ibt_line.user_order_qtyibt_line.user_shipped_qty
For type=IBTshipper: The performs the following calculation: Inter Branch Transfer Entry, Lines, Quantity minus Inter Branch Transfer Entry, Lines, Qty Shipped. If Quantity is not greater than Qty Shipped, then 0.
@unitCodefor type=ibtshipper: ibt_line.ibt_um
Shipment/ShipmentItem/BackOrderedQuantity For type=IBTshipper: 0
@unitCodefor type=ibtshipper: ibt_line.ibt_um
Shipment/ShipmentItem/PurchaseOrderReference/DocumentID/IDfor type=poreturnreceipt: receiver_line.purc_order_idfor type=cnsnreceiptrtn: consign_rcvr_line.purc_order_id
@schemeAgencyIDsettings.instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID.
Shipment/ShipmentItem/PurchaseOrderReference/LineNumberfor type=poreturnreceipt: receiver_line.purc_order_line_nofor type=cnsnreceiptrtn: consign_rcvr_line.purc_order_line_no
August 13, 2009 114
ShipmentShipment/ShipmentItem/SalesOrderReference/DocumentID/ID
shipping.cust_order_id Shipping Entry, Order ID@schemeAgencyID
settings.instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID.
Shipment/ShipmentItem/SalesOrderReference/LineNumbershipper_line.cust_order_line_no Shipping Entry, Lines, C/O Ln#
Shipment/ShipmentItem/Costing@rateCode
material, labor, burden, contractor@type
Actual
Shipment/ShipmentItem/Costing/AmountFor type=material: inventory_transaction.act_material_costFor type=labor: inventory_transaction.act_labor_costFor type=burden: inventory_transaction.act_burden_costFor type=contractor: inventory_transaction.act_service_cost
Inventory Transaction Entry, Material Unit CostInventory Transaction Entry, Labor Unit CostInventory Transaction Entry, Burden Unit CostInventory Transaction Entry, Service Unit Cost
@currencyIDcurrency.currency_id Exchange Rate Maintenance, Currency Maintenance, Currency ID marked as system.
Shipment/ShipmentItem/SerializedLot/ItemQuantitytrace_inv_trans.trace_qty Inventory Transaction Entry, Part Traceability, Qty
Shipment/ShipmentItem/SerializedLot/Lot/LotIDs/IDtrace_inv_trans.trace_id Inventory Transaction Entry, Part Traceability, field name as specified in Part Trace Profile Maintenance, Label
Shipment/ShipmentItem/LineNumberconsign_rcvr_line.line_no Consignment Receipt Entry, Lines, Ln #
Shipment/ShipmentItem/CountSequencepart_warehouse.count_sequence
August 13, 2009 115
SupplierPartyMasterSupplierPartyMaster@role
Supplier
SupplierPartyMaster/PartyIDs/IDvendor.id Vendor Maintenance, Vendor ID
@schemeName System
@schemeAgencyIDsettings.instance_id The system combines infor.visual with the value in SOA Maintenance, Visual Instance ID.
SupplierPartyMaster/PartyIDs/TaxIDvendor.tax_id_number Vendor Maintenance, Accounting tab, Tax ID Number
SupplierPartyMaster/Namevendor.name Vendor Maintenance, Name
@languageIDsettings.language_id SOA Mainenace, Language ID
SupplierPartyMaster/Location/Address/AddressLine1: vendor.addr_12: vendor.addr_23: vendor.addr_3
Vendor Maintenance, Purchase From Street Address fields
SupplierPartyMaster/Location/Address/CityNamevendor.city Vendor Maintenance, Purchase From City
SupplierPartyMaster/Location/Address/CountrySubDivisionCodevendor.state Vendor Maintenance, Purchase From State.
@listID Country Sub-divisions
SupplierPartyMaster/Location/Address/CountryCodevendor.country Vendor Maintenance, Purchase From Country.
@listID Countries
SupplierPartyMaster/Location/Address/PostalCodevendor.zipcode Vendor Maintenance, Purchase From Zip
@listID Postal/Zip Codes
SupplierPartyMaster/SalesContact/Namevendor.contact_first_namevendor.contact_initialvendor.contact_last_name
Vendor Maintenance, Contact tab, First, Initial, and Last Name fields
SupplierPartyMaster/SalesContact/JobTitlevendor.contact_position Vendor Maintenance, Contact tab, Position/Salutation
SupplierPartyMaster/SalesContact/Communication/UseCode Phone
FaxEmail
SupplierPartyMaster/SalesContact/Communication/UseCode/Code@listID
Communication Use Codes
SupplierPartyMaster/SalesContact/Communication/DialNumbervendor.contact_phonevendor.contact_mobilevendor.contact_fax
Vendor Maintenance, Contact tab, PhoneVendor Maintenance, Contact tab, Mobile PhoneVendor Maintenance, Contact tab, FAX
SupplierPartyMaster/SalesContact/Communication/URIvendor.contact_email Vendor Maintenance, Contact tab, E-Mail Address
SupplierPartyMaster/Supplier1099Indicatorvendor.report_1099_misc If Vendor Maintenance, Accounting tab, Report 1099 Misc.check box is selected, then true. If it is not selected, then false
SupplierPartyMaster/SupplierAccount/Status/Codevendor.active_flag If Vendor Maintenance, Active check box is selected, then Open. If check box is not selected, then Closed
SupplierPartyMaster/SupplierAccount/Term/Descriptionvendor.terms_net_typevendor.terms_net_daysvendor.terms_net_date
Vendor Maintenance, Accounting tab, Terms
top related