eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: XNB.XNB_BILL_TO_PARTY_DETAILS#

Source

View Text - Preformatted


select PRIMARY_BILL_TO_FLAG PRIMARY_BILL_TO_FLAG, BILL_TO_OWNER_FLAG BILL_TO_OWNER_FLAG, BILL_TO_ADDRESS BILL_TO_ADDRESS, COUNTRY COUNTRY, STATE STATE, COUNTY COUNTY, CITY CITY, POSTAL_CODE POSTAL_CODE, ORDER_LINE_ID ORDER_LINE_ID, ACCOUNT_NUMBER ACCOUNT_NUMBER, ACCOUNT_NAME ACCOUNT_NAME, PARTY_NUMBER PARTY_NUMBER, PARTY_NAME PARTY_NAME, PARTY_ATTRIBUTE1 PARTY_ATTRIBUTE1, PARTY_ATTRIBUTE2 PARTY_ATTRIBUTE2, PARTY_ATTRIBUTE3 PARTY_ATTRIBUTE3, PARTY_ATTRIBUTE4 PARTY_ATTRIBUTE4, PARTY_ATTRIBUTE5 PARTY_ATTRIBUTE5, PARTY_ATTRIBUTE6 PARTY_ATTRIBUTE6, PARTY_ATTRIBUTE7 PARTY_ATTRIBUTE7, PARTY_ATTRIBUTE8 PARTY_ATTRIBUTE8, PARTY_ATTRIBUTE9 PARTY_ATTRIBUTE9, PARTY_ATTRIBUTE10 PARTY_ATTRIBUTE10, PARTY_ATTRIBUTE11 PARTY_ATTRIBUTE11, PARTY_ATTRIBUTE12 PARTY_ATTRIBUTE12, PARTY_ATTRIBUTE13 PARTY_ATTRIBUTE13, PARTY_ATTRIBUTE14 PARTY_ATTRIBUTE14, PARTY_ATTRIBUTE15 PARTY_ATTRIBUTE15, ACCT_ATTRIBUTE1 ACCT_ATTRIBUTE1, ACCT_ATTRIBUTE2 ACCT_ATTRIBUTE2, ACCT_ATTRIBUTE3 ACCT_ATTRIBUTE3, ACCT_ATTRIBUTE4 ACCT_ATTRIBUTE4, ACCT_ATTRIBUTE5 ACCT_ATTRIBUTE5, ACCT_ATTRIBUTE6 ACCT_ATTRIBUTE6, ACCT_ATTRIBUTE7 ACCT_ATTRIBUTE7, ACCT_ATTRIBUTE8 ACCT_ATTRIBUTE8, ACCT_ATTRIBUTE9 ACCT_ATTRIBUTE9, ACCT_ATTRIBUTE10 ACCT_ATTRIBUTE10, ACCT_ATTRIBUTE11 ACCT_ATTRIBUTE11, ACCT_ATTRIBUTE12 ACCT_ATTRIBUTE12, ACCT_ATTRIBUTE13 ACCT_ATTRIBUTE13, ACCT_ATTRIBUTE14 ACCT_ATTRIBUTE14, ACCT_ATTRIBUTE15 ACCT_ATTRIBUTE15 from "XNB"."XNB_BILL_TO_PARTY_DETAILS"

View Text - HTML Formatted

SELECT PRIMARY_BILL_TO_FLAG PRIMARY_BILL_TO_FLAG
, BILL_TO_OWNER_FLAG BILL_TO_OWNER_FLAG
, BILL_TO_ADDRESS BILL_TO_ADDRESS
, COUNTRY COUNTRY
, STATE STATE
, COUNTY COUNTY
, CITY CITY
, POSTAL_CODE POSTAL_CODE
, ORDER_LINE_ID ORDER_LINE_ID
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, ACCOUNT_NAME ACCOUNT_NAME
, PARTY_NUMBER PARTY_NUMBER
, PARTY_NAME PARTY_NAME
, PARTY_ATTRIBUTE1 PARTY_ATTRIBUTE1
, PARTY_ATTRIBUTE2 PARTY_ATTRIBUTE2
, PARTY_ATTRIBUTE3 PARTY_ATTRIBUTE3
, PARTY_ATTRIBUTE4 PARTY_ATTRIBUTE4
, PARTY_ATTRIBUTE5 PARTY_ATTRIBUTE5
, PARTY_ATTRIBUTE6 PARTY_ATTRIBUTE6
, PARTY_ATTRIBUTE7 PARTY_ATTRIBUTE7
, PARTY_ATTRIBUTE8 PARTY_ATTRIBUTE8
, PARTY_ATTRIBUTE9 PARTY_ATTRIBUTE9
, PARTY_ATTRIBUTE10 PARTY_ATTRIBUTE10
, PARTY_ATTRIBUTE11 PARTY_ATTRIBUTE11
, PARTY_ATTRIBUTE12 PARTY_ATTRIBUTE12
, PARTY_ATTRIBUTE13 PARTY_ATTRIBUTE13
, PARTY_ATTRIBUTE14 PARTY_ATTRIBUTE14
, PARTY_ATTRIBUTE15 PARTY_ATTRIBUTE15
, ACCT_ATTRIBUTE1 ACCT_ATTRIBUTE1
, ACCT_ATTRIBUTE2 ACCT_ATTRIBUTE2
, ACCT_ATTRIBUTE3 ACCT_ATTRIBUTE3
, ACCT_ATTRIBUTE4 ACCT_ATTRIBUTE4
, ACCT_ATTRIBUTE5 ACCT_ATTRIBUTE5
, ACCT_ATTRIBUTE6 ACCT_ATTRIBUTE6
, ACCT_ATTRIBUTE7 ACCT_ATTRIBUTE7
, ACCT_ATTRIBUTE8 ACCT_ATTRIBUTE8
, ACCT_ATTRIBUTE9 ACCT_ATTRIBUTE9
, ACCT_ATTRIBUTE10 ACCT_ATTRIBUTE10
, ACCT_ATTRIBUTE11 ACCT_ATTRIBUTE11
, ACCT_ATTRIBUTE12 ACCT_ATTRIBUTE12
, ACCT_ATTRIBUTE13 ACCT_ATTRIBUTE13
, ACCT_ATTRIBUTE14 ACCT_ATTRIBUTE14
, ACCT_ATTRIBUTE15 ACCT_ATTRIBUTE15
FROM "XNB"."XNB_BILL_TO_PARTY_DETAILS"