Product: | GML - Process Manufacturing Logistics |
---|---|
Description: | View on vendor master table. |
Implementation/DBA Data: |
![]() |
SELECT "CO_CODE"
, "VENDOR_ID"
, "VENDOR_NO"
, "ALTVEND_NO"
, "VENDSORT_NO"
, "VENDOR_NAME"
, "ADDR_ID"
, "REMIT_NAME"
, "MAILADDR_ID"
, "PHONE_NO"
, "FAX_NO"
, "TELEX_NO"
, "DEFAULT_CURRENCY"
, "CHANGE_CURRENCY"
, "TIMELINESS_RATING"
, "PRICE_RATING"
, "MISC_RATING"
, "BUS_START_DATE"
, "BUS_END_DATE"
, "BUS_AMOUNT"
, "MIN_PURCHASE"
, "APPROVED_IND"
, "INACTIVE_IND"
, "SHIP_IND"
, "PAYMENT_IND"
, "INFORM_GOVT"
, "TAXABLE_IND"
, "TERMS_CODE"
, "TERMS_VARY"
, "VENDOR_TYPE"
, "SIC_CODE"
, "SPLC_CODE"
, "FRTBILL_MTHD"
, "CREDIT_LIMIT"
, "VEND_CLASS"
, "VENDTRADE_CLASS"
, "VENDGL_CLASS"
, "CREATION_DATE"
, "CREATED_BY"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_LOGIN"
, "TRANS_CNT"
, "TEXT_CODE"
, "DELETE_MARK"
, "ATTRIBUTE1"
, "ATTRIBUTE2"
, "ATTRIBUTE3"
, "ATTRIBUTE4"
, "ATTRIBUTE5"
, "ATTRIBUTE6"
, "ATTRIBUTE7"
, "ATTRIBUTE8"
, "ATTRIBUTE9"
, "ATTRIBUTE10"
, "ATTRIBUTE11"
, "ATTRIBUTE12"
, "ATTRIBUTE13"
, "ATTRIBUTE14"
, "ATTRIBUTE15"
, "ATTRIBUTE16"
, "ATTRIBUTE17"
, "ATTRIBUTE18"
, "ATTRIBUTE19"
, "ATTRIBUTE20"
, "ATTRIBUTE21"
, "ATTRIBUTE22"
, "ATTRIBUTE23"
, "ATTRIBUTE24"
, "ATTRIBUTE25"
, "ATTRIBUTE26"
, "ATTRIBUTE27"
, "ATTRIBUTE28"
, "ATTRIBUTE29"
, "ATTRIBUTE30"
, "ATTRIBUTE_CATEGORY"
FROM PO_VEND_MST