Send Supplier Service

Script	Description
wm_install_from_supplier.sql	Runs the scripts listed below, except the uninstall script.
wm_from_supplier_vw.sql	Creates the following required view components for PO outbound transactions: WM_PO_SUPPLIER_VW WM_PO_SUPPLIER_SITES_ALL_VW WM_PO_SUPPLIER_CONTACTS_VW WM_BANK_ACC_USE_SUPP_SITES_VW WM_BANK_ACCOUNT_USES_SUPP_VW WM_PO_SUPPLIER_QRY_VW
wm_from_supplier_trg.sql	Creates the following triggers to be used for writing to wm_trackchanges to indicate a new or updated document: WM_PO_SUPPLIER_IU_TRG WM_PO_SUPP_SITES_ALL_IU_TRG WM_PO_SUPP_CONTACTS_IUD_TRG WM_AP_BK_SUP_AC_USE_ALL_IU_TRG
wm_disable_from_supplier.sql	Disables the triggers installed by wm_from_supplier_trg.sql.
wm_enable_from_supplier.sql	Re-enables the triggers installed by wm_from_supplier_trg.sql.
wm_drop_from_supplier.sql	Uninstalls all components created by wm_install_from_supplier.sql.

Field Name	Oracle Applications Table/View Name	Column Name	Description
WEB_TRANSACTION_ ID			Populated from a sequence and used internally in the IS flow. Will contain NULL value for queried supplier data.
DOCUMENT_TYPE			Use SUPPLIER.
DOCUMENT_STATUS			Use INSERT, UPDATE, or QUERY.
VENDOR_ID	AP_SUPPLIERS	VENDOR_ID	Unique supplier identifier in Oracle Applications.
VENDOR_NUMBER	AP_SUPPLIERS	SEGMENT1	Supplier number.
VENDOR_NAME	AP_SUPPLIERS	VENDOR_NAME	Name of the supplier.
ALTERNATE_ VENDOR_NAME	AP_SUPPLIERS	VENDOR_NAME_ ALT	Alternate name for the supplier.
VENDOR_TYPE	AP_SUPPLIERS	VENDOR_TYPE_ LOOKUP_CODE	Type of supplier.
ACCOUNT_NUMBER	AP_SUPPLIERS	ACCOUNT_NUM	Customer number as set up on supplier’s system.
ONE_TIME_ FLAG	AP_SUPPLIERS	ONE_TIME_ FLAG	Indicates whether supplier is one time.
PARENT_VENDOR_ NUMBER	AP_SUPPLIERS	SEGMENT1	Parent supplier number.
PARENT_VENDOR_ NAME	AP_SUPPLIERS	VENDOR_NAME	Parent supplier name.
MINIMUM_ORDER_ AMOUNT	AP_SUPPLIERS	MIN_ORDER_ AMOUNT	Minimum order amount to order goods from the supplier.
BILL_LOC_ ADDRESS_ LINE1	HR_LOCATIONS	ADDRESS_LINE_1	REGION1 is the County, REGION2 is the State Code, BILL_LOC is the Billing Location, and SHIP_LOC is the Shipping Location.
BILL_LOC_ ADDRESS_ LINE2	HR_LOCATIONS	ADDRESS_LINE_2
BILL_LOC_ ADDRESS_ LINE3	HR_LOCATIONS	ADDRESS_LINE_3
BILL_LOC_ TOWN_OR_CITY	HR_LOCATIONS	TOWN_OR_CITY
BILL_LOC_ REGION2	HR_LOCATIONS	REGION_2
BILL_LOC_ POSTAL_CODE	HR_LOCATIONS	POSTAL_CODE
BILL_LOC_ COUNTRY	HR_LOCATIONS	COUNTRY
BILL_LOC_ REGION1	HR_LOCATIONS	REGION_1
SHIP_LOC_ ADDRESS_ LINE1	HR_LOCATIONS	ADDRESS_LINE_1
SHIP_LOC_ ADDRESS_ LINE2	HR_LOCATIONS	ADDRESS_LINE_2
SHIP_LOC_ ADDRESS_ LINE3	HR_LOCATIONS	ADDRESS_LINE_3
SHIP_LOC_ TOWN_OR_CITY	HR_LOCATIONS	TOWN_OR_CITY
SHIP_LOC_ REGION2	HR_LOCATIONS	REGION_2
SHIP_LOC_ POSTAL_CODE	HR_LOCATIONS	POSTAL_CODE
SHIP_LOC_ REGION1	HR_LOCATIONS	REGION_1
SHIP_LOC_ COUNTRY	HR_LOCATIONS	COUNTRY
SHIP_VIA	AP_SUPPLIERS	SHIP_VIA_LOOKUP_CODE	Shipping code.
FREIGHT_TERMS	AP_SUPPLIERS	FREIGHT_TERMS_ LOOKUP_CODE	Freight terms code.
FOB	AP_SUPPLIERS	FOB_LOOKUP _CODE	Free On Board code.
TERMS	AP_TERMS_TL	NAME
SET_OF_ BOOKS_NAME	GL_SETS_OF_ BOOKS	NAME	Set of books name as in Oracle Applications.
SET_OF_ BOOKS_SHORT_ NAME	GL_SETS_OF_ BOOKS	SHORT_NAME	Set of books short name.
CREDIT_STATUS	AP_SUPPLIERS	CREDIT_STATUS_ LOOKUP_CODE	Credit status of the supplier.
CREDIT_LIMIT	AP_SUPPLIERS	CREDIT_LIMIT	Credit limit.
ALWAYS_ DISCOUNT_ FLAG	AP_SUPPLIERS	ALWAYS_TAKE_ DISC_FLAG
PAY_DATE_BASIS	AP_SUPPLIERS	PAY_DATE_BASIS_ LOOKUP_CODE	Type of payment date basis.
PAY_GROUP	AP_SUPPLIERS	PAY_GROUP_ LOOKUP_CODE
PAYMENT_ PRIORITY	AP_SUPPLIERS	PAYMENT_PRIORITY
INVOICE_ CURRENCY_ CODE	AP_SUPPLIERS	INVOICE_ CURRENCY_ CODE
PAYMENT_ CURRENCY_ CODE	AP_SUPPLIERS	PAYMENT_ CURRENCY_ CODE
INVOICE_ AMOUNT_ LIMIT	AP_SUPPLIERS	INVOICE_ AMOUNT_ LIMIT
EXCHANGE_ DATE_CODE	AP_SUPPLIERS	EXCHANGE_ DATE_LOOKUP_ CODE
HOLD_ALL_ PAYMENTS	AP_SUPPLIERS	HOLD_ALL_ PAYMENTS_FLAG
HOLD_FUTURE_ PAYMENTS	AP_SUPPLIERS	HOLD_FUTURE_ PAYMENTS_FLAG
HOLD_REASON	AP_SUPPLIERS	HOLD_REASON
DISTRIBUTION_ SET_NAME	AP_DISTRIBUTION_ SETS	DISTRIBUTION_ SET_NAME
SUPPLIER_ LIABILITY_ ACCOUNT	GL_CODE_ COMBINATIONS_ KFV	CONCATENATED_ SEGMENTS	Concatenated general ledger code combination.
NUMBER_1099	AP_SUPPLIERS	NUM_1099	Tax payer ID.
TYPE_1099	AP_SUPPLIERS	TYPE_1099	Type of 1099.
WITHHOLDING_ STATUS	AP_SUPPLIERS	WITHHOLDING_ STATUS_ LOOKUP_CODE
WITHHOLDING_ START_DATE	AP_SUPPLIERS	WITHHOLDING_ START_DATE
IRS_ ORGANIZATION_ TYPE	AP_SUPPLIERS	ORGANIZATION_ TYPE_LOOKUP_ CODE
VAT_CODE	AP_SUPPLIERS	VAT_CODE
START_DATE_ ACTIVE	AP_SUPPLIERS	START_DATE_ ACTIVE	Active starting date.
END_DATE_ ACTIVE	AP_SUPPLIERS	END_DATE_ ACTIVE	Active ending date.
MINORITY_GROUP	AP_SUPPLIERS	MINORITY_GROUP_ LOOKUP_CODE
PAYMENT_METHOD	AP_SUPPLIERS	PAYMENT_METHOD_ LOOKUP_CODE
BANK_ACCOUNT_ NAME	AP_SUPPLIERS	BANK_ACCOUNT_ NAME	Supplier’s bank account name.
BANK_ACCOUNT_ NUMBER	AP_SUPPLIERS	BANK_ACCOUNT_ NUM	Supplier’s bank account number.
BANK_NUMBER	AP_SUPPLIERS	BANK_NUM	Supplier’s bank number.
BANK_ACCOUNT_ TYPE	AP_SUPPLIERS	BANK_ACCOUNT_ TYPE	Type of bank account.
WOMEN_OWNED	AP_SUPPLIERS	WOMEN_OWNED_ FLAG	Indicates whether the supplier is a woman– owned business.
SMALL_BUSINESS	AP_SUPPLIERS	SMALL_BUSINESS_ FLAG	Indicates whether the supplier is a small business.
STANDARD_ INDUSTRY_ CLASS	AP_SUPPLIERS	STANDARD_ INDUSTRY_ CLASS	Standard industry classification number.
HOLD_FLAG	AP_SUPPLIERS	HOLD_FLAG
PURCHASING_ HOLD_REASON	AP_SUPPLIERS	PURCHASING_ HOLD_REASON	Reason for placing the supplier on purchasing hold.
HOLD_BY_ EMPLOYEE_ NUMBER	PER_ALL_ PEOPLE_F	EMPLOYEE_ NUMBER
PER_HOLD_BY_ FULL_NAME	PER_ALL_ PEOPLE_F	FULL_NAME
HOLD_DATE	AP_SUPPLIERS	HOLD_DATE	Date the supplier was placed on purchasing hold.
TERMS_DATE_ BASIS	AP_SUPPLIERS	TERMS_DATE_ BASIS	Type of invoice payment schedule basis.
PRICE_ TOLERANCE	AP_SUPPLIERS	PRICE_ TOLERANCE
INSPECTION_ REQUIRED	AP_SUPPLIERS	INSPECTION_ REQUIRED_ FLAG	Indicates whether inspection is required.
RECEIPT_ REQUIRED_ FLAG	AP_SUPPLIERS	RECEIPT_ REQUIRED_ FLAG	Indicates whether shipment must be received before the invoice is paid.
QUANTITY_ RECEIVED_ TOLERANCE	AP_SUPPLIERS	QTY_RCV_ TOLERANCE	Quantity received tolerance percentage.
DAYS_EARLY_ RECEIPT_ ALLOWED	AP_SUPPLIERS	DAYS_EARLY_ RECEIPT_ ALLOWED	Maximum acceptable number of days items can be received early.
DAYS_LATE_ RECEIPT_ ALLOWED	AP_SUPPLIERS	DAYS_LATE_ RECEIPT_ ALLOWED	Maximum acceptable number of days items can be received late.
ALLOW_ SUBSTITUTE_ RECEIPTS	AP_SUPPLIERS	ALLOW_ SUBSTITUTE_ RECEIPTS_ FLAG	Indicates whether substitute items can be received instead of the ordered items.
ALLOW_ UNORDERED_ RECEIPTS	AP_SUPPLIERS	ALLOW_ UNORDERED_ RECEIPTS_FLAG	Indicates whether unordered receipts are allowed.
HOLD_ UNMATCHED_ INVOICES	AP_SUPPLIERS	HOLD_ UNMATCHED_ INVOICES_FLAG	Indicates whether unmatched invoices should be put on hold.
EXCLUSIVE_ PAYMENT	AP_SUPPLIERS	EXCLUSIVE_ PAYMENT_FLAG
TAX_ VERIFICATION_ DATE	AP_SUPPLIERS	TAX_ VERIFICATION_ DATE
STATE_ REPORTABLE	AP_SUPPLIERS	STATE_ REPORTABLE_ FLAG
FEDERAL_ REPORTABLE	AP_SUPPLIERS	FEDERAL_ REPORTABLE_ FLAG
OFFSET_VAT	AP_SUPPLIERS	OFFSET_VAT_ CODE	Offset VAT Code.
VAT_ REGISTRATION_ NUMBER	AP_SUPPLIERS	VAT_ REGISTRATION_ NUMBER
AUTO_ CALCULATE_ INTEREST	AP_SUPPLIERS	AUTO_ CALCULATE_ INTEREST_ FLAG	Indicates whether interest is automatically calculated.
VALIDATION_ NUMBER	AP_SUPPLIERS	VALIDATION_ NUMBER
EXCLUDE_ FREIGHT_FROM_ DISCOUNT	AP_SUPPLIERS	EXCLUDE_ FREIGHT_FROM_ DISCOUNT	Indicates whether to exclude supplier freight from discount amount.
TAX_REPORTING_ NAME	AP_SUPPLIERS	TAX_REPORTING_ NAME	Tax reporting method name.
CHECK_DIGITS	AP_SUPPLIERS	CHECK_DIGITS	Check number used by the Accounts Payable department.
BANK_NUM	AP_SUPPLIERS	BANK_NUM	Bank number for Accounts Payable department.
AUTO_TAX_ CALCULATION	AP_SUPPLIERS	AUTO_TAX_ CALC_FLAG
AUTO_TAX_ CALCULATION_ OVERRIDE	AP_SUPPLIERS	AUTO_TAX_ CALC_OVERRIDE	Allow calculation level override.
AMOUNT_INCLUDES_ TAX	AP_SUPPLIERS	AMOUNT_INCLUDES_ TAX_FLAG	Distribution amounts include tax.
BANK_CHARGE_ BEARER	AP_SUPPLIERS	BANK_CHARGE_ BEARER	Indicates whether this supplier bears bank charges.
BANK_BRANCH_ TYPE	AP_SUPPLIERS	BANK_BRANCH_ TYPE	Identifies the list that contains the bank routing number. Use ABA, CHIPS, SWIFT, or OTHER.
MATCH_OPTION	AP_SUPPLIERS	MATCH_OPTION	Indicate whether to match invoices to the purchase order or the receipt for this supplier.
FUTURE_ DATED_ PAYMENTS_ ACCOUNT	GL_CODE_ COMBINATIONS_ KFV	CONCATENATED_ SEGMENTS	Accounting flexfield identifier for the future dated payment account.
CREATE_DEBIT_ MEMO	AP_SUPPLIERS	CREATE_DEBIT_ MEMO_FLAG	Indicates whether a debit memo should be created.
OFFSET_FLAG	AP_SUPPLIERS	OFFSET_TAX_ FLAG	Indicates whether the supplier uses offset taxes.

Field Name	Oracle Applications Table/View Name	Column Name	Description
VENDOR_ID	AP_SUPPLIER_ SITES_ALL	VENDOR_ID	Unique vendor identifier in Oracle Applications.
VENDOR_ SITE_ID	AP_SUPPLIER_ SITES_ALL	VENDOR_ SITE_ID	Unique supplier site unique identifier.
VENDOR_ SITE_CODE	AP_SUPPLIER_ SITES_ALL	VENDOR_ SITE_CODE	Supplier site name.
PURCHASING_ SITE	AP_SUPPLIER_ SITES_ALL	PURCHASING_ SITE_FLAG	Indicates whether you can purchase from this site.
RFQ_ONLY_SITE	AP_SUPPLIER_ SITES_ALL	RFQ_ONLY_ SITE_FLAG	Indicates whether you can only send RFQs to this site.
PAY_SITE	AP_SUPPLIER_ SITES_ALL	PAY_SITE_FLAG	Indicates whether you can send payments to this site.
ATTENTION_AR	AP_SUPPLIER_ SITES_ALL	ATTENTION_ AR_FLAG	Indicates whether the payments should be sent to the Account Receivables department.
ADDRESS_LINE1	AP_SUPPLIER_ SITES_ALL	ADDRESS_LINE1	Supplier site address line 1.
ADDRESS_LINE2	AP_SUPPLIER_ SITES_ALL	ADDRESS_LINE2	Supplier site address line 2.
ADDRESS_LINE3	AP_SUPPLIER_ SITES_ALL	ADDRESS_LINE3	Supplier site address line 3.
CITY	AP_SUPPLIER_ SITES_ALL	CITY
STATE	AP_SUPPLIER_ SITES_ALL	STATE
ZIP	AP_SUPPLIER_ SITES_ALL	ZIP
PROVINCE	AP_SUPPLIER_ SITES_ALL	PROVINCE
COUNTRY	AP_SUPPLIER_ SITES_ALL	COUNTRY
AREA_CODE	AP_SUPPLIER_ SITES_ALL	AREA_CODE
PHONE	AP_SUPPLIER_ SITES_ALL	PHONE
ACCOUNT_ NUMBER	AP_SUPPLIER_ SITES_ALL	ACCOUNT_ NUMBER	Customer number with the supplier.
BILL_TO_ LOCATION_ CODE	HR_LOCATIONS	LOCATION_ CODE	REGION1 is the County, REGION2 is the State Code, BILL_LOC is the Billing Location, and SHIP_LOC is the Shipping Location.
BILL_LOC_ ADDRESS_LINE1	HR_LOCATIONS	ADDRESS_LINE_1
BILL_LOC_ ADDRESS_LINE2	HR_LOCATIONS	ADDRESS_LINE_2
BILL_LOC_ ADDRESS_LINE3	HR_LOCATIONS	ADDRESS_LINE_3
BILL_LOC_ TOWN_OR_CITY	HR_LOCATIONS	TOWN_OR_CITY
BILL_LOC_ REGION2	HR_LOCATIONS	REGION_2
BILL_LOC_ POSTAL_CODE	HR_LOCATIONS	POSTAL_CODE
BILL_LOC_ COUNTRY	HR_LOCATIONS	COUNTRY
BILL_LOC_ REGION1	HR_LOCATIONS	REGION_1
SHIP_TO_ LOCATION_CODE	HR_LOCATIONS	LOCATION_ CODE
SHIP_LOC_ ADDRESS_LINE1	HR_LOCATIONS	ADDRESS_LINE_1
SHIP_LOC_ ADDRESS_LINE2	HR_LOCATIONS	ADDRESS_LINE_2
SHIP_LOC_ ADDRESS_LINE3	HR_LOCATIONS	ADDRESS_LINE_3
SHIP_LOC_ TOWN_OR_CITY	HR_LOCATIONS	TOWN_OR_CITY
SHIP_LOC_ REGION2	HR_LOCATIONS	REGION_2
SHIP_LOC_ POSTAL_CODE	HR_LOCATIONS	POSTAL_CODE
SHIP_LOC_REGION1	HR_LOCATIONS	REGION_1
SHIP_LOC_ COUNTRY	HR_LOCATIONS	COUNTRY
SHIP_VIA	AP_SUPPLIER_ SITES_ALL	SHIP_VIA_ LOOKUP_CODE	Shipping code.
FREIGHT_TERMS	AP_SUPPLIER_ SITES_ALL	FREIGHT_TERMS_ LOOKUP_CODE	Freight terms code.
FOB	AP_SUPPLIER_ SITES_ALL	FOB_LOOKUP_ CODE	Default Free on Board Type.
INACTIVE_DATE	AP_SUPPLIER_ SITES_ALL	INACTIVE_DATE	Inactive date for the record.
FAX	AP_SUPPLIER_ SITES_ALL	FAX
FAX_AREA_CODE	AP_SUPPLIER_ SITES_ALL	FAX_AREA_CODE
TELEX	AP_SUPPLIER_ SITES_ALL	TELEX
PAYMENT_METHOD	AP_SUPPLIER_ SITES_ALL	PAYMENT_ METHOD_ LOOKUP_CODE
BANK_ACCOUNT_ NAME	AP_SUPPLIER_ SITES_ALL	BANK_ACCOUNT_ NAME	Supplier’s bank account name.
BANK_ACCOUNT_ NUMBER	AP_SUPPLIER_ SITES_ALL	BANK_ACCOUNT_ NUMBER	Supplier’s bank account name number of the supplier bank.
BANK_NUM	AP_SUPPLIER_ SITES_ALL	BANK_NUM	Bank branch number.
BANK_ACCOUNT_ TYPE	AP_SUPPLIER_ SITES_ALL	BANK_ACCOUNT_ TYPE	Type of bank account.
TERMS_DATE_ BASIS	AP_SUPPLIER_ SITES_ALL	TERMS_DATE_ BASIS	Type of payment date basis.
VAT_CODE	AP_SUPPLIER_ SITES_ALL	VAT_CODE
DISTRIBUTION_ SET_NAME	AP_DISTRIBUTION_ SETS	DISTRIBUTION_ SET_NAME
SUPPLIER_ LIABILITY_ ACCOUNT	GL_CODE_ COMBINATIONS_ KFV	CONCATENATED_ SEGMENTS	Concatenated general ledger code combination.
PREPAY_ACCOUNT	GL_CODE_ COMBINATIONS_ KFV	CONCATENATED_ SEGMENTS	Concatenated general ledger code combination.
PAY_GROUP	AP_SUPPLIER_ SITES_ALL	PAY_GROUP_ LOOKUP_CODE
PAYMENT_ PRIORITY	AP_SUPPLIER_ SITES_ALL	PAYMENT_PRIORITY
TERMS	AP_TERMS_TL	NAME
INVOICE_ AMOUNT_ LIMIT	AP_SUPPLIER_ SITES_ALL	INVOICE_ AMOUNT_ LIMIT
PAY_DATE_BASIS	AP_SUPPLIER_ SITES_ALL	PAY_DATE_ BASIS_LOOKUP_ CODE	Type of payment date basis.
ALWAYS_ DISCOUNT_ FLAG	AP_SUPPLIER_ SITES_ALL	ALWAYS_TAKE_ DISC_FLAG	Indicates whether discount is applicable for the site.
INVOICE_ CURRENCY_ CODE	AP_SUPPLIER_ SITES_ALL	INVOICE_ CURRENCY_ CODE
PAYMENT_ CURRENCY_ CODE	AP_SUPPLIER_ SITES_ALL	PAYMENT_ CURRENCY_ CODE
HOLD_ALL_ PAYMENTS	AP_SUPPLIER_ SITES_ALL	HOLD_ALL_ PAYMENTS_FLAG
HOLD_FUTURE_ PAYMENTS	AP_SUPPLIER_ SITES_ALL	HOLD_FUTURE_ PAYMENTS_FLAG
HOLD_REASON	AP_SUPPLIER_ SITES_ALL	HOLD_REASON
HOLD_ UNMATCHED_ INVOICES	AP_SUPPLIER_ SITES_ALL	HOLD_ UNMATCHED_ INVOICES_FLAG	Indicates whether unmatched invoices should be put on hold.
EXCLUSIVE_ PAYMENT	AP_SUPPLIER_ SITES_ALL	EXCLUSIVE_ PAYMENT_ FLAG
TAX_REPORTING_ SITE	AP_SUPPLIER_ SITES_ALL	TAX_REPORTING_ SITE_FLAG
VALIDATION_ NUMBER	AP_SUPPLIER_ SITES_ALL	VALIDATION_ NUMBER
EXCLUDE_FREIGHT_ FROM_DISCOUNT	AP_SUPPLIER_ SITES_ALL	EXCLUDE_FREIGHT_ FROM_DISCOUNT	Indicates whether to exclude supplier freight from discount amount.
VAT_ REGISTRATION_ NUMBER	AP_SUPPLIER_ SITES_ALL	VAT_ REGISTRATION_ NUMBER
OFFSET_VAT	AP_SUPPLIER_ SITES_ALL	OFFSET_ VAT_CODE	Offset VAT Code.
ORGANIZATION_ NAME	ORG_ ORGANIZATION_ DEFINITIONS	ORGANIZATION_ NAME	Name of organization corresponding to the operating unit.
ORGANIZATION_ CODE	ORG_ ORGANIZATION_ DEFINITIONS	ORGANIZATION_ CODE	Organization code for operating unit.
CHECK_DIGITS	AP_SUPPLIER_ SITES_ALL	CHECK_DIGITS	Check number used by Accounts Payable department.
BANK_NUMBER	AP_SUPPLIER_ SITES_ALL	BANK_NUM	Supplier’s bank number.
ADDRESS_LINE4	AP_SUPPLIER_ SITES_ALL	ADDRESS_LINE4
COUNTY	AP_SUPPLIER_ SITES_ALL	COUNTY
ADDRESS_STYLE	AP_SUPPLIER_ SITES_ALL	ADDRESS_STYLE
ALLOW_AWT	AP_SUPPLIER_ SITES_ALL	ALLOW_AWT_FLAG	Allow withholding tax.
WITHOLDING_ TAX_GROUP	AP_AWT_GROUPS	NAME	Withholding tax group name.
ALTERNATE_ VENDOR_SITE_ CODE	AP_SUPPLIER_ SITES_ALL	VENDOR_SITE_ CODE_ALT
ALTERNATE_ ADDRESS_ LINE	AP_SUPPLIER_ SITES_ALL	ADDRESS_ LINES_ALT
AP_TAX_ ROUNDING_ RULE	AP_SUPPLIER_ SITES_ALL	AP_TAX_ ROUNDING_RULE
AUTO_TAX_ CALCULATION	AP_SUPPLIER_ SITES_ALL	AUTO_TAX_ CALC_FLAG
AUTO_TAX_ CALCULATION_ OVERRIDE	AP_SUPPLIER_ SITES_ALL	AUTO_TAX_ CALC_OVERRIDE
AMOUNT_ INCLUDES_TAX	AP_SUPPLIER_ SITES_ALL	AMOUNT_ INCLUDES_TAX_ FLAG
BANK_CHARGE_ BEARER	AP_SUPPLIER_ SITES_ALL	BANK_CHARGE_ BEARER	Indicator of whether the supplier bears bank charges.
BANK_BRANCH_ TYPE	AP_SUPPLIER_ SITES_ALL	BANK_BRANCH_ TYPE	Identifies the list that contains the bank routing number. Use ABA, CHIPS, SWIFT, or OTHER.
PAY_ON_CODE	AP_SUPPLIER_ SITES_ALL	PAY_ON_CODE
PAY_ON_ RECEIPT_ SUMMARY_ CODE	AP_SUPPLIER_ SITES_ALL	PAY_ON_ RECEIPT_ SUMMARY_ CODE	Identifies how to consolidate receipts to create invoices.
PCARD_SITE	AP_SUPPLIER_ SITES_ALL	PCARD_SITE_ FLAG	Indicates whether the site allows use of PCard.
MATCH_OPTION	AP_SUPPLIER_ SITES_ALL	MATCH_OPTION	Indicates whether the invoice should be matched to the purchase order or the receipt.
COUNTRY_OF_ ORIGIN	AP_SUPPLIER_ SITES_ALL	COUNTRY_OF_ ORIGIN_CODE	Manufacturer’s country code.
FUTURE_DATED_ PAYMENT_ ACCOUNT	GL_CODE_ COMBINATIONS_ KFV	CONCATENATED_ SEGMENTS	Accounting flexfield for future dated payment.
CREATE_DEBIT_MEMO	AP_SUPPLIER_ SITES_ALL	CREATE_DEBIT_ MEMO_FLAG	Indicates whether the debit memo should be created.
OFFSET_TAX	AP_SUPPLIER_ SITES_ALL	OFFSET_TAX_ FLAG	Indicates whether the offset tax should be used.
SELLING_COMPANY_IDENTIFIER	AP_SUPPLIER_ SITES_ALL	SELLING_ COMPANY_ IDENTIFIER
GAPLESS_INV_NUM_FLAG	AP_SUPPLIER_ SITES_ALL	GAPLESS_INV_ NUM_FLAG

Field Name	Oracle Applications Table/View Name	Column Name	Description
VENDOR_ SITE_ID	PO_VENDOR_ CONTACTS	VENDOR_ SITE_ID	Unique vendor site identifier.
INACTIVE_DATE	PO_VENDOR_ CONTACTS	INACTIVE_DATE	Date from which the contact is inactive.
PERSON_ FIRST_NAME	PO_VENDOR_ CONTACTS	PERSON_ FIRST_NAME
MIDDLE_NAME	PO_VENDOR_ CONTACTS	MIDDLE_NAME
PERSON_ LAST_NAME	PO_VENDOR_ CONTACTS	PERSON_ LAST_NAME
PREFIX	PO_VENDOR_ CONTACTS	PREFIX
TITLE	PO_VENDOR_ CONTACTS	TITLE
MAIL_STOP	PO_VENDOR_ CONTACTS	MAIL_STOP
AREA_CODE	PO_VENDOR_ CONTACTS	AREA_CODE	Contact’s area code.
PHONE	PO_VENDOR_ CONTACTS	PHONE	Contact’s phone number.
ALTERNATE_ CONTACT_ NAME	PO_VENDOR_ CONTACTS	CONTACT_ NAME_ALT	Contact’s alternate name.
EMAIL_ADDRESS	PO_VENDOR_ CONTACTS	EMAIL_ADDRESS	Contact’s e-mail address.
URL	PO_VENDOR_ CONTACTS	URL	Contact’s URL.
ALTERNATE_ AREA_CODE	PO_VENDOR_ CONTACTS	ALT_AREA_ CODE	Alternate area code for the contact.
ALTERNATE_ PHONE	PO_VENDOR_ CONTACTS	ALT_PHONE	Alternate phone number for the contact.

Field Name	Oracle Applications Table/View Name	Column Name	Description
ROW_ID			Unique row identifier.
VENDOR_ID	AP_BANK_ ACCOUNTS_ALL	VENDOR_ID	Unique vendor identifier in Oracle Applications.
VENDOR_ SITE_ID	AP_BANK_ ACCOUNT_ USES_ALL	VENDOR_ SITE_ID	Vendor site unique identifier.
BANK_ ACCOUNT_ NAME	AP_BANK_ ACCOUNTS_ALL	BANK_ ACCOUNT_ NAME
BANK_ ACCOUNT_ NUM	AP_BANK_ ACCOUNTS_ALL	BANK_ ACCOUNT_ NUM	Bank account number.
CURRENCY_ CODE	AP_BANK_ ACCOUNTS_ALL	CURRENCY_ CODE
BANK_NAME	AP_BANK_BRANCHES	BANK_NAME
BANK_NUMBER	AP_BANK_BRANCHES	BANK_NUMBER
BANK_ BRANCH_ NAME	AP_BANK_BRANCHES	BANK_ BRANCH_ NAME
BANK_NUM	AP_BANK_BRANCHES	BANK_NUM
END_DATE	AP_BANK_ ACCOUNT_ USES_ALL	START_DATE
START_DATE	AP_BANK_ ACCOUNT_ USES_ALL	END_DATE
PRIMARY	AP_BANK_ ACCOUNT_ USES_ALL	PRIMARY_FLAG	Indicates primary bank account.
ORG_ID	AP_BANK_ ACCOUNT_ USES_ALL	ORG_ID	Organization identifier.
ORGANIZATION_ CODE	ORG_ ORGANIZATION_ DEFINITIONS	ORGANIZATION_ CODE
ORGANIZATION_ NAME	ORG_ ORGANIZATION_ DEFINITIONS	ORGANIZATION_ NAME

Field Name	Oracle Applications Table/View Name	Column Name	Description
ROW_ID		ROW_ID	Unique row identifier.
VENDOR_ID	AP_BANK_ ACCOUNTS_ALL	VENDOR_ID	Unique vendor identifier in Oracle Applications.
VENDOR_ SITE_ID	AP_BANK_ ACCOUNT_ USES_ALL	VENDOR_ SITE_ID	Unique vendor site identifier.
BANK_ ACCOUNT_ NAME	AP_BANK_ ACCOUNTS_ALL	BANK_ ACCOUNT_ NAME
BANK_ ACCOUNT_ NUM	AP_BANK_ ACCOUNTS_ALL	BANK_ ACCOUNT_ NUM	Bank Account Number.
CURRENCY_ CODE	AP_BANK_ ACCOUNTS_ALL	CURRENCY_ CODE
BANK_NAME	AP_BANK_BRANCHES	BANK_NAME
BANK_NUMBER	AP_BANK_BRANCHES	BANK_NUMBER
BANK_ BRANCH_ NAME	AP_BANK_BRANCHES	BANK_ BRANCH_ NAME
BANK_NUM	AP_BANK_BRANCHES	BANK_NUM
END_DATE	AP_BANK_ ACCOUNT_ USES_ALL	END_DATE
START_DATE	AP_BANK_ ACCOUNT_ USES_ALL	START_DATE
PRIMARY	AP_BANK_ ACCOUNT_ USES_ALL	PRIMARY_FLAG	Indicates primary bank account.
ORG_ID	AP_BANK_ ACCOUNT_ USES_ALL	ORG_ID	Organization identifier.
ORGANIZATION_ CODE	ORG_ ORGANIZATION_ DEFINITIONS	ORGANIZATION_ CODE	Organization code to identify the organization.
ORGANIZATION_ NAME	ORG_ ORGANIZATION_ DEFINITIONS	ORGANIZATION_ NAME	Name of the organization.