Send Vendor Service

Database Script	Description
wm_install_from_vendor.sql	Runs all the scripts listed below, except the uninstall script.
wm_from_vendor_vw.sql	Creates the following required view components for customer outbound transactions: WM_PO_VENDOR_SITES_ALL_VW WM_PO_VENDOR_CONTACTS_VW WM_BANK_ACCOUNT_USES_VENDOR_VW WM_PO_VENDORS_QRY_VW WM_BANK_ACC_USE_VEND_SITES_VW WM_PO_VENDORS_VW
wm_triggers.trg	Creates the following trigger components: WM_PO_VENDORS_IU_TRG WM_PO_VENDOR_SITES_ALL_IU_TRG WM_PO_VENDOR_CONTACTS_IUD_TRG WM_AP_BANK_ACC_USE_ALL_IU_TRG
wm_disable_from_vendor.sql	Disables the triggers installed by wm_from_vendor_trg.sql.
wm_enable_from_vendor.sql	Re-enables the triggers installed by wm_from_vendor_trg.sql.
wm_drop_from_vendor.sql	Uninstalls all components created by wm_install_from_vendor.sql.

Document Field	Oracle Applications Table/View Name	Column Name	Description
WEB_ TRANSACTION_ID			Populated from a sequence and used internally in the flow. Contains a null value for Queried Vendor data.
DOCUMENT_TYPE			Value is VENDOR.
DOCUMENT_ STATUS			Valid values are INSERT, UPDATE, and QUERY.
VENDOR_ID	AP_SUPPLIERS	VENDOR_ID	Unique vendor identifier in Oracle Applications.
VENDOR_ NUMBER	AP_SUPPLIERS	SEGMENT1
VENDOR_NAME	AP_SUPPLIERS	VENDOR_NAME
ALTERNATE_ VENDOR_NAME	AP_SUPPLIERS	VENDOR_ NAME_ALT
VENDOR_TYPE	AP_SUPPLIERS	VENDOR_TYPE_ LOOKUP_CODE
EMPLOYEE_ NUMBER	PER_ALL_ PEOPLE_F	EMPLOYEE_ NUMBER	Employee Number of the Employee if the same employee is set up as a supplier.
EMPLOYEE_NAME	PER_ALL_ PEOPLE_F	FULL_NAME	Full name of the employee.
PARENT_VENDOR_ NUMBER	AP_SUPPLIERS	SEGMENT1	Parent vendor number.
PARENT_VENDOR_ NAME	AP_SUPPLIERS	VENDOR_NAME	Parent vendor name.
ACCOUNT_ NUMBER	AP_SUPPLIERS	CUSTOMER_NUM	Customer number as setup in vendor’s system.
ONE_TIME_FLAG	AP_SUPPLIERS	ONE_TIME_FLAG	If vendor is one-time.
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	Region 1 stores county information. Region 2 stores state code information. BILL_LOC is Billing Location SHIP_LOC is 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_ COUNTRY	HR_LOCATIONS	COUNTRY
BILL_LOC_ POSTAL_CODE	HR_LOCATIONS	POSTAL_CODE
BILL_LOC_ REGION1	HR_LOCATIONS	REGION_1
BILL_LOC_ REGION1	HR_LOCATIONS	REGION_2
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_ COUNTRY	HR_LOCATIONS	COUNTRY
SHIP_LOC_ POSTAL_CODE	HR_LOCATIONS	POSTAL_CODE
SHIP_LOC_ REGION1	HR_LOCATIONS	REGION_1
SHIP_LOC_ REGION2	HR_LOCATIONS	REGION_2
SHIP_VIA	AP_SUPPLIERS	SHIP_VIA_ LOOKUP_CODE	Stores shipping code.
FREIGHT_TERMS	AP_SUPPLIERS	FREIGHT_TERMS_ LOOKUP_CODE	Stores freight terms code.
FOB	AP_SUPPLIERS	FOB_LOOKUP_ CODE	Freight on board code.
TERMS	AP_TERMS_TL	NAME	Term 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 vendor.
CREDIT_LIMIT	AP_SUPPLIERS	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
HOLD_REASON	AP_SUPPLIERS	HOLD_REASON
DISTRIBUTION_ SET_NAME	AP_ DISTRIBUTION_ SETS	DISTRIBUTION_ SET_NAME
SUPPLIER_ LIABILITY_ ACCOUNT	GL_CODE_ COMBINATIONS_ KFV	CONCATENATED_ SEGMENT	Concatenated GL Code Combination.
NUMBER_1099	AP_SUPPLIERS	NUM_1099	Tax payer ID.
TYPE_1099	AP_SUPPLIERS	TYPE_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
END_DATE_ ACTIVE	AP_SUPPLIERS	END_DATE_ ACTIVE
MINORITY_GROUP	AP_SUPPLIERS	MINORITY_ GROUP_ LOOKUP_CODE
PAYMENT_METHOD	AP_SUPPLIERS	PAYMENT_ METHOD LOOKUP_CODE
BANK_ACCOUNT_ NAME	AP_SUPPLIERS	BANK_ACCOUNT_ NAME	Name of the supplier bank account.
BANK_ACCOUNT_ NUMBER	AP_SUPPLIERS	BANK_ACCOUNT_ NUM	Number of the supplier bank account.
BANK_NUMBER	AP_SUPPLIERS	BANK_NUM	Bank number for the supplier.
BANK_ACCOUNT_ TYPE	AP_SUPPLIERS	BANK_ACCOUNT_ TYPE
WOMEN_OWNED	AP_SUPPLIERS	WOMEN_OWNED_ FLAG	Indicates whether the supplier is a woman-owned business.
SMALL_BUSINESS	AP_SUPPLIERS	SMALL_BUSINESS_ FLAG	Indicates that 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	Full name of employee.
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 of 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 in place 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	Federal Reportable Flag.
OFFSET_VAT	AP_SUPPLIERS	OFFSET_VAT_ CODE	Offset VAT Code.
VAT_REGISTRATION_ NUMBER	AP_SUPPLIERS	VAT_ REGISTRATION_ NUM	Tax registration number.
AUTO_CALCULATE_ INTEREST	AP_SUPPLIERS	AUTO_ CALCULATE_ INTEREST_ FLAG	Indicates whether interest is to be automatically calculated.
VALIDATION_ NUMBER	AP_SUPPLIERS	VALIDATION_ NUMBER
EXCLUDE_FREIGHT_ FROM_DISCOUNT	AP_SUPPLIERS	EXCLUDE_ FREIGHT_ FROM_DISCOUNT
TAX_REPORTING_ NAME	AP_SUPPLIERS	TAX_ REPORTING_ NAME	Tax reporting method name.
CHECK_DIGITS	AP_SUPPLIERS	CHECK_DIGITS	Check number used by Payables.
BANK_NUM	AP_SUPPLIERS	BANK_NUM	Bank number for Accounts Payable.
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 gets bank charges.
BANK_BRANCH_ TYPE	AP_SUPPLIERS	BANK_BRANCH_ TYPE	Indicates list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT, and OTHER.
MATCH_OPTION	AP_SUPPLIERS	MATCH_OPTION	Indicates whether to match invoices to the purchase order or the receipt for this supplier.
FUTURE_DATED_ PAYMENTS_ACCOUNT	GL_CODE_ COMBINATIONS_ KFV	CONCATENATED_ SEGMENT	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.

Document Field	Oracle Applications Table/View Name	Column Name	Description
VENDOR_ SITE_ID	AP_SUPPLIER_ SITES_ALL	VENDOR_ SITE_ID	Vendor site unique identifier.
VENDOR_ SITE_CODE	AP_SUPPLIER_ SITES_ALL	VENDOR_ SITE_CODE	Vendor site name.
ADDRESS_LINE1	AP_SUPPLIER_ SITES_ALL	ADDRESS_ LINE1
ADDRESS_LINE2	AP_SUPPLIER_ SITES_ALL	ADDRESS_ LINE2
ADDRESS_LINE3	AP_SUPPLIER_ SITES_ALL	ADDRESS_ LINE3
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
ALTERNATE_ ADDRESS_LINE	AP_SUPPLIER_ SITES_ALL	ADDRESS_ LINES_ALT
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.
CUSTOMER_ NUMBER	AP_SUPPLIER_ SITES_ALL	ACCOUNT_ NUMBER	Customer number with the supplier.
BILL_LOC_ ADDRESS_LINE1	HR_LOCATIONS	ADDRESS_ LINE_1	Region 1 stores county information. Region 2 stores the state code information. BILL_LOC is Billing Location. SHIP_LOC is 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_ COUNTRY	HR_LOCATIONS	COUNTRY
BILL_LOC_ POSTAL_CODE	HR_LOCATIONS	POSTAL_CODE
BILL_LOC_ REGION1	HR_LOCATIONS	REGION_1
BILL_LOC_ REGION2	HR_LOCATIONS	REGION_2
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_ COUNTRY	HR_LOCATIONS	COUNTRY
SHIP_LOC_ POSTAL_CODE	HR_LOCATIONS	POSTAL_CODE
SHIP_LOC_ REGION1	HR_LOCATIONS	REGION_1
SHIP_LOC_ REGION2	HR_LOCATIONS	REGION_2
SHIP_VIA	AP_SUPPLIER_ SITES_ALL	SHIP_VIA_ LOOKUP_CODE	Stores shipping code.
FREIGHT_TERMS	AP_SUPPLIER_ SITES_ALL	FREIGHT_ TERMS_ LOOKUP_ CODE	Stores 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 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	Name of the supplier bank Account.
BANK_ACCOUNT_ NUMBER	AP_SUPPLIER_ SITES_ALL	BANK_ ACCOUNT_ NUMBER	Number of the supplier bank Account.
BANK_NUM	AP_SUPPLIER_ SITES_ALL	BANK_NUM	Bank Branch Number.
BANK_ACCOUNT_ TYPE	AP_SUPPLIER_ SITES_ALL	BANK_ ACCOUNT_ TYPE
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 GL Code Combination.
PREPAY_ACCOUNT	GL_CODE_ COMBINATIONS_KFV	CONCATENATED_ SEGMENTS	Concatenated GL 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 the discount applies to this 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	Excludes supplier freight from discount amount.
VAT_REGISTRATION_ NUMBER	AP_SUPPLIER_ SITES_ALL	VAT_ REGISTRATION_ NUM
OFFSET_VAT	AP_SUPPLIER_ SITES_ALL	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 Payables.
BANK_NUMBER	AP_SUPPLIER_ SITES_ALL	BANK_NUM	Bank number for the supplier.
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	Withholding tax.
WITHOLDING_ TAX_GROUP	AP_AWT_GROUPS	NAME
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 if this supplier bears bank charges.
BANK_BRANCH_ TYPE	AP_SUPPLIER_ SITES_ALL	BANK_ BRANCH_ TYPE	The list the bank routing number is on. Valid type are: ABA CHIPS SWIFT 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 site allows use of P Card.
MATCH_OPTION	AP_SUPPLIER_ SITES_ALL	MATCH_OPTION	Indicates whether the invoices match to POs or receipts.
COUNTRY_OF_ ORIGIN	AP_SUPPLIER_ SITES_ALL	COUNTRY_OF_ ORIGIN_CODE	Country code of manufacturer.
FUTURE_DATED_ PAYMENT_ACCOUNT	GL_CODE_ COMBINATIONS_KFV	CONCATENATED_ SEGMENT	Accounting flexfield for future dated payment.
CREATE_DEBIT_ MEMO	AP_SUPPLIER_ SITES_ALL	CREATE_DEBIT_ MEMO_FLAG	Indicates whether debit memo should be created.
OFFSET_TAX	AP_SUPPLIER_ SITES_ALL	OFFSET_TAX_ FLAG	Indicates whether offset tax should be used.
SELLING_COMPANY_ IDENTIFIER	AP_SUPPLIER_ SITES_ALL	SELLING_ COMPANY_ IDENTIFIER	Selling company identifier.
GAPLESS_INV_ NUM_FLAG	AP_SUPPLIER_ SITES_ALL	GAPLESS_INV_ NUM_FLAG	The gapless invoice number.

Document Field	Oracle Applications Table/View Name	Column Name	Description
VENDOR_SITE_ID	AP_SUPPLIER_ CONTACTS	VENDOR_SITE_ID	Vendor site unique identifier.
PERSON_FIRST_ NAME	AP_SUPPLIER_ CONTACTS	PERSON_ FIRST_NAME
MIDDLE_NAME	AP_SUPPLIER_ CONTACTS	MIDDLE_NAME
PERSON_LAST_ NAME	AP_SUPPLIER_ CONTACTS	PERSON_ LAST_NAME
PREFIX	AP_SUPPLIER_ CONTACTS	PREFIX
TITLE	AP_SUPPLIER_ CONTACTS	TITLE
MAIL_STOP	AP_SUPPLIER_ CONTACTS	MAIL_STOP
AREA_CODE	AP_SUPPLIER_ CONTACTS	AREA_CODE
PHONE	AP_SUPPLIER_ CONTACTS	PHONE
ALTERNATE_ CONTACT_NAME	AP_SUPPLIER_ CONTACTS	CONTACT_ NAME_ALT
INACTIVE_DATE	AP_SUPPLIER_ CONTACTS	INACTIVE_DATE	Date when the contact becomes inactive.
EMAIL_ADDRESS	AP_SUPPLIER_ CONTACTS	EMAIL_ADDRESS
URL	AP_SUPPLIER_ CONTACTS	URL
ALTERNATE_ AREA_CODE	AP_SUPPLIER_ CONTACTS	ALT_AREA_CODE
ALTERNATE_PHONE	AP_SUPPLIER_ CONTACTS	ALT_PHONE

Document Field	Oracle Applications Table/View Name	Column Name	Description
BANK_ACCOUNT_ NAME	AP_BANK_ ACCOUNTS_ALL	BANK_ACCOUNT_ NAME
BANK_ACCOUNT_ NUM	AP_BANK_ ACCOUNTS_ALL	BANK_ACCOUNT_ NUM
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	Bank number.
START_DATE	AP_BANK_ ACCOUNTS_ USES_ALL	START_DATE
END_DATE	AP_BANK_ ACCOUNTS_ USES_ALL	END_DATE
PRIMARY	AP_BANK_ ACCOUNTS_ USES_ALL	PRIMARY_FLAG	Indicates whether it is the Primary Bank.
ORG_ID	AP_BANK_ ACCOUNTS_ USES_ALL	ORG_ID
ORGANIZATION_ CODE	ORG_ ORGANIZATION_ DEFINITIONS	ORGANIZATION_ CODE
ORGANIZATION_ NAMES	ORG_ ORGANIZATION_ DEFINITIONS	ORGANIZATION_ NAMES

Document Field	Oracle Applications Table/View Name	Column Name	Description
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_ ACCOUNTS_ USES_ALL	START_DATE
START_DATE	AP_BANK_ ACCOUNTS_ USES_ALL	END_DATE
PRIMARY	AP_BANK_ ACCOUNTS_ USES_ALL	PRIMARY_FLAG	Primary Bank Account flag.
ORG_ID	AP_BANK_ ACCOUNTS_ USES_ALL	ORG_ID	Organization ID.
ORGANIZATION_ CODE	ORG_ ORGANIZATION_ DEFINITIONS	ORGANIZATION_ CODE
ORGANIZATION_ NAMES	ORG_ ORGANIZATION_ DEFINITIONS	ORGANIZATION_ NAMES