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: OZF.OZF_SD_BATCH_LINES_INT_ALL#

Source

View Text - Preformatted


select BATCH_LINE_INT_ID BATCH_LINE_INT_ID, FRM_CONTACT1_NAME FRM_CONTACT1_NAME, FRM_CONTACT1_EMAIL FRM_CONTACT1_EMAIL, FRM_CONTACT1_FAX FRM_CONTACT1_FAX, FRM_CONTACT1_PHONE FRM_CONTACT1_PHONE, FRM_GBL_PTNR_ROLE_CLASS_CODE FRM_GBL_PTNR_ROLE_CLASS_CODE, FRM_BUSINESS_NAME FRM_BUSINESS_NAME, FRM_GBL_BUSINESS_ID FRM_GBL_BUSINESS_ID, FRM_GBL_SUPPLY_CHAIN_CODE FRM_GBL_SUPPLY_CHAIN_CODE, FRM_PROP_BUSINESS_ID FRM_PROP_BUSINESS_ID, FRM_PROP_DOMAIN_ID1 FRM_PROP_DOMAIN_ID1, FRM_PROP_ID_AUTHORITY1 FRM_PROP_ID_AUTHORITY1, FRM_GBL_PARTNER_CLASS_CODE FRM_GBL_PARTNER_CLASS_CODE, FRM_CONTACT2_NAME FRM_CONTACT2_NAME, FRM_CONTACT2_EMAIL FRM_CONTACT2_EMAIL, FRM_CONTACT2_FAX FRM_CONTACT2_FAX, FRM_CONTACT2_PHONE FRM_CONTACT2_PHONE, FRM_GBL_LOCATION_ID FRM_GBL_LOCATION_ID, FRM_PROP_DOMAIN_ID2 FRM_PROP_DOMAIN_ID2, FRM_PROP_ID_AUTHORITY2 FRM_PROP_ID_AUTHORITY2, FRM_PROP_LOCATION_ID FRM_PROP_LOCATION_ID, FRM_ADDRESS_LINE1 FRM_ADDRESS_LINE1, FRM_ADDRESS_LINE2 FRM_ADDRESS_LINE2, FRM_ADDRESS_LINE3 FRM_ADDRESS_LINE3, FRM_CITY_NAME FRM_CITY_NAME, FRM_GBL_COUNTRY_CODE FRM_GBL_COUNTRY_CODE, FRM_NATIONAL_POSTAL_CODE FRM_NATIONAL_POSTAL_CODE, FRM_POBOX_ID FRM_POBOX_ID, FRM_REGION_NAME FRM_REGION_NAME, GBL_DOC_FUNCTION_CODE GBL_DOC_FUNCTION_CODE, SHIP_FRM_SD_AUTHORIZATION_ID SHIP_FRM_SD_AUTHORIZATION_ID, DIST_BY_BUSINESS_NAME DIST_BY_BUSINESS_NAME, DIST_BY_GBL_BUSINESS_ID DIST_BY_GBL_BUSINESS_ID, DIST_BY_GBL_SUPPLY_CHAIN_CODE DIST_BY_GBL_SUPPLY_CHAIN_CODE, DIST_BY_PROP_BUSINESS_ID DIST_BY_PROP_BUSINESS_ID, DIST_BY_PROP_DOMAIN_ID1 DIST_BY_PROP_DOMAIN_ID1, DIST_BY_PROP_IDAUTHORITY1 DIST_BY_PROP_IDAUTHORITY1, DIST_BY_GBL_PARTNER_CLASS_CODE DIST_BY_GBL_PARTNER_CLASS_CODE, DIST_BY_CONTACT1_NAME DIST_BY_CONTACT1_NAME, DIST_BY_CONTACT1_EMAIL DIST_BY_CONTACT1_EMAIL, DIST_BY_CONTACT1_FAX DIST_BY_CONTACT1_FAX, DIST_BY_CONTACT1_PHONE DIST_BY_CONTACT1_PHONE, DIST_BY_GBL_LOCATION_ID DIST_BY_GBL_LOCATION_ID, DIST_BY_PROP_DOMAIN_ID2 DIST_BY_PROP_DOMAIN_ID2, DIST_BY_PROP_IDAUTHORITY2 DIST_BY_PROP_IDAUTHORITY2, DIST_BY_PROP_LOCATION_ID DIST_BY_PROP_LOCATION_ID, DIST_BY_ADDRESS_LINE1 DIST_BY_ADDRESS_LINE1, DIST_BY_ADDRESS_LINE2 DIST_BY_ADDRESS_LINE2, DIST_BY_ADDRESS_LINE3 DIST_BY_ADDRESS_LINE3, DIST_BY_CITY_NAME DIST_BY_CITY_NAME, DIST_BY_GBL_COUNTRY_CODE DIST_BY_GBL_COUNTRY_CODE, DIST_BY_NATIONAL_POSTAL_CODE DIST_BY_NATIONAL_POSTAL_CODE, DIST_BY_POBOX_ID DIST_BY_POBOX_ID, DIST_BY_REGION_NAME DIST_BY_REGION_NAME, SHIP_TO_BUSINESS_NAME SHIP_TO_BUSINESS_NAME, SHIP_TO_GBL_BUSINESS_ID SHIP_TO_GBL_BUSINESS_ID, SHIP_TO_GBL_SUPPLY_CHAIN_CODE SHIP_TO_GBL_SUPPLY_CHAIN_CODE, SHIP_TO_PROP_BUSINESS_ID SHIP_TO_PROP_BUSINESS_ID, SHIP_TO_PROP_DOMAIN_ID2 SHIP_TO_PROP_DOMAIN_ID2, SHIP_TO_PROP_ID_AUTHORITY2 SHIP_TO_PROP_ID_AUTHORITY2, SHIP_TO_GBL_PARTNER_CLASS_CODE SHIP_TO_GBL_PARTNER_CLASS_CODE, SHIP_TO_CONTACT1_NAME SHIP_TO_CONTACT1_NAME, SHIP_TO_CONTACT1_EMAIL SHIP_TO_CONTACT1_EMAIL, SHIP_TO_CONTACT1_FAX SHIP_TO_CONTACT1_FAX, SHIP_TO_CONTACT1_PHONE SHIP_TO_CONTACT1_PHONE, SHIP_TO_GBL_LOCATION_ID SHIP_TO_GBL_LOCATION_ID, SHIP_TO_PROP_DOMAIN_ID1 SHIP_TO_PROP_DOMAIN_ID1, SHIP_TO_PROP_ID_AUTHORITY1 SHIP_TO_PROP_ID_AUTHORITY1, SHIP_TO_PROP_LOCATION_ID SHIP_TO_PROP_LOCATION_ID, SHIP_TO_ADDRESS_LINE1 SHIP_TO_ADDRESS_LINE1, SHIP_TO_ADDRESS_LINE2 SHIP_TO_ADDRESS_LINE2, SHIP_TO_ADDRESS_LINE3 SHIP_TO_ADDRESS_LINE3, SHIP_TO_CITY_NAME SHIP_TO_CITY_NAME, SHIP_TO_GBL_COUNTRY_CODE SHIP_TO_GBL_COUNTRY_CODE, SHIP_TO_NATIONAL_POSTAL_CODE SHIP_TO_NATIONAL_POSTAL_CODE, SHIP_TO_POBOX_ID SHIP_TO_POBOX_ID, SHIP_TO_REGION_NAME SHIP_TO_REGION_NAME, SOLD_TO_BUSINESS_NAME SOLD_TO_BUSINESS_NAME, SOLD_TO_GBL_BUSINESS_ID SOLD_TO_GBL_BUSINESS_ID, SOLD_TO_GBL_SUPPLY_CHAIN_CODE SOLD_TO_GBL_SUPPLY_CHAIN_CODE, SOLD_TO_PROP_BUSINESS_ID SOLD_TO_PROP_BUSINESS_ID, SOLD_TO_PROP_DOMAIN_ID2 SOLD_TO_PROP_DOMAIN_ID2, SOLD_TO_PROP_ID_AUTHORITY2 SOLD_TO_PROP_ID_AUTHORITY2, SOLD_TO_GBL_PARTNER_CLASS_CODE SOLD_TO_GBL_PARTNER_CLASS_CODE, SOLD_TO_CONTACT1_NAME SOLD_TO_CONTACT1_NAME, SOLD_TO_CONTACT1_EMAIL SOLD_TO_CONTACT1_EMAIL, SOLD_TO_CONTACT1_FAX SOLD_TO_CONTACT1_FAX, SOLD_TO_CONTACT1_PHONE SOLD_TO_CONTACT1_PHONE, SOLD_TO_GBL_LOCATION_ID SOLD_TO_GBL_LOCATION_ID, SOLD_TO_PROP_DOMAIN_ID1 SOLD_TO_PROP_DOMAIN_ID1, SOLD_TO_PROP_ID_AUTHORITY1 SOLD_TO_PROP_ID_AUTHORITY1, SOLD_TO_PROP_LOCATION_ID SOLD_TO_PROP_LOCATION_ID, SOLD_TO_ADDRESS_LINE1 SOLD_TO_ADDRESS_LINE1, SOLD_TO_ADDRESS_LINE2 SOLD_TO_ADDRESS_LINE2, SOLD_TO_ADDRESS_LINE3 SOLD_TO_ADDRESS_LINE3, SOLD_TO_CITY_NAME SOLD_TO_CITY_NAME, SOLD_TO_GBL_COUNTRY_CODE SOLD_TO_GBL_COUNTRY_CODE, SOLD_TO_NATIONAL_POSTAL_CODE SOLD_TO_NATIONAL_POSTAL_CODE, SOLD_TO_POBOX_ID SOLD_TO_POBOX_ID, SOLD_TO_REGION_NAME SOLD_TO_REGION_NAME, USED_BY_BUSINESS_NAME USED_BY_BUSINESS_NAME, USED_BY_GBL_BUSINESS_ID USED_BY_GBL_BUSINESS_ID, USED_BY_GBL_SUPPLY_CHAIN_CODE USED_BY_GBL_SUPPLY_CHAIN_CODE, USED_BY_PROP_BUSINESS_ID USED_BY_PROP_BUSINESS_ID, USED_BY_PROP_DOMAIN_ID1 USED_BY_PROP_DOMAIN_ID1, USED_BY_PROP_ID_AUTHORITY1 USED_BY_PROP_ID_AUTHORITY1, USED_BY_GBL_PARTNER_CLASS_CODE USED_BY_GBL_PARTNER_CLASS_CODE, USED_BY_CONTACT1_NAME USED_BY_CONTACT1_NAME, USED_BY_CONTACT1_EMAIL USED_BY_CONTACT1_EMAIL, USED_BY_CONTACT1_FAX USED_BY_CONTACT1_FAX, USED_BY_CONTACT1_PHONE USED_BY_CONTACT1_PHONE, USED_BY_GBL_LOCATION_ID USED_BY_GBL_LOCATION_ID, USED_BY_PROP_DOMAIN_ID2 USED_BY_PROP_DOMAIN_ID2, USED_BY_PROP_ID_AUTHORITY2 USED_BY_PROP_ID_AUTHORITY2, USED_BY_PROP_LOCATION_ID USED_BY_PROP_LOCATION_ID, USED_BY_ADDRESS_LINE1 USED_BY_ADDRESS_LINE1, USED_BY_ADDRESS_LINE2 USED_BY_ADDRESS_LINE2, USED_BY_ADDRESS_LINE3 USED_BY_ADDRESS_LINE3, USED_BY_CITY_NAME USED_BY_CITY_NAME, USED_BY_GBL_COUNTRY_CODE USED_BY_GBL_COUNTRY_CODE, USED_BY_NATIONAL_POSTAL_CODE USED_BY_NATIONAL_POSTAL_CODE, USED_BY_POBOX_ID USED_BY_POBOX_ID, USED_BY_REGION_NAME USED_BY_REGION_NAME, SHIP_FRM_SD_CLAIM_REQUEST_DATE SHIP_FRM_SD_CLAIM_REQUEST_DATE, SHIP_FRM_SD_CLAIM_REQUEST_ID SHIP_FRM_SD_CLAIM_REQUEST_ID, CREDIT_REFERENCE_ID CREDIT_REFERENCE_ID, DEBIT_REFERENCE_ID DEBIT_REFERENCE_ID, BATCH_LINE_NUMBER BATCH_LINE_NUMBER, ORDER_DATE ORDER_DATE, ORDER_LINE_NUMBER ORDER_LINE_NUMBER, ORDER_NUMBER ORDER_NUMBER, INVOICE_DATE INVOICE_DATE, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER, INVOICE_NUMBER INVOICE_NUMBER, COST_CURRENCY_CODE COST_CURRENCY_CODE, COST_MONETARY_AMOUNT COST_MONETARY_AMOUNT, AUTH_COST_CURRENCY_CODE AUTH_COST_CURRENCY_CODE, AUTH_COST_MONETARY_AMOUNT AUTH_COST_MONETARY_AMOUNT, RESALE_CURRENCY_CODE RESALE_CURRENCY_CODE, RESALE_MONETARY_AMOUNT RESALE_MONETARY_AMOUNT, GBL_UOM GBL_UOM, GBL_CLAIM_DISPOSITION_CODE GBL_CLAIM_DISPOSITION_CODE, VENDOR_PRODUCT_ID VENDOR_PRODUCT_ID, DIST_PRODUCT_ID DIST_PRODUCT_ID, SHIP_DATE SHIP_DATE, SHIPPED_QUANTITY SHIPPED_QUANTITY, VENDOR_AUTH_LINEITEM_LINE_NBR VENDOR_AUTH_LINEITEM_LINE_NBR, VENDOR_AUTH_COST_CURRENCY_CODE VENDOR_AUTH_COST_CURRENCY_CODE, VENDOR_AUTH_COST_MONETARY_AMT VENDOR_AUTH_COST_MONETARY_AMT, THIS_DOC_GENERATION_DATE THIS_DOC_GENERATION_DATE, THIS_DOCUMENT_ID THIS_DOCUMENT_ID, TO_CONTACT1_NAME TO_CONTACT1_NAME, TO_CONTACT1_EMAIL TO_CONTACT1_EMAIL, TO_CONTACT1_FAX TO_CONTACT1_FAX, TO_CONTACT1_PHONE TO_CONTACT1_PHONE, TO_GBL_PARTNER_ROLE_CLASS_CODE TO_GBL_PARTNER_ROLE_CLASS_CODE, TO_BUSINESS_NAME1 TO_BUSINESS_NAME1, TO_GBL_BUSINESS_ID TO_GBL_BUSINESS_ID, TO_GBL_SUPPLY_CHAIN_CODE TO_GBL_SUPPLY_CHAIN_CODE, TO_PROP_BUSINESS_ID TO_PROP_BUSINESS_ID, TO_PROP_DOMAIN_ID1 TO_PROP_DOMAIN_ID1, TO_PROP_ID_AUTHORITY1 TO_PROP_ID_AUTHORITY1, TO_GBL_PARTNER_CLASS_CODE TO_GBL_PARTNER_CLASS_CODE, TO_CONTACT2_NAME TO_CONTACT2_NAME, TO_CONTACT2_EMAIL TO_CONTACT2_EMAIL, TO_CONTACT2_FAX TO_CONTACT2_FAX, TO_CONTACT2_PHONE TO_CONTACT2_PHONE, TO_GBL_LOCATION_ID TO_GBL_LOCATION_ID, TO_PROP_DOMAIN_ID2 TO_PROP_DOMAIN_ID2, TO_PROP_ID_AUTHORITY2 TO_PROP_ID_AUTHORITY2, TO_PROP_LOCATION_ID TO_PROP_LOCATION_ID, TO_ADDRESS_LINE1 TO_ADDRESS_LINE1, TO_ADDRESS_LINE2 TO_ADDRESS_LINE2, TO_ADDRESS_LINE3 TO_ADDRESS_LINE3, TO_CITY_NAME TO_CITY_NAME, TO_GBL_COUNTRY_CODE TO_GBL_COUNTRY_CODE, TO_NATIONAL_POSTAL_CODE TO_NATIONAL_POSTAL_CODE, TO_POBOX_ID TO_POBOX_ID, TO_REGION_NAME TO_REGION_NAME, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, REQUEST_ID REQUEST_ID, CREATED_BY CREATED_BY, CREATED_FROM CREATED_FROM, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_ID PROGRAM_ID, HEADER_ATTRIBUTE_CATEGORY HEADER_ATTRIBUTE_CATEGORY, HEADER_ATTRIBUTE1 HEADER_ATTRIBUTE1, HEADER_ATTRIBUTE2 HEADER_ATTRIBUTE2, HEADER_ATTRIBUTE3 HEADER_ATTRIBUTE3, HEADER_ATTRIBUTE4 HEADER_ATTRIBUTE4, HEADER_ATTRIBUTE5 HEADER_ATTRIBUTE5, HEADER_ATTRIBUTE6 HEADER_ATTRIBUTE6, HEADER_ATTRIBUTE7 HEADER_ATTRIBUTE7, HEADER_ATTRIBUTE8 HEADER_ATTRIBUTE8, HEADER_ATTRIBUTE9 HEADER_ATTRIBUTE9, HEADER_ATTRIBUTE10 HEADER_ATTRIBUTE10, HEADER_ATTRIBUTE11 HEADER_ATTRIBUTE11, HEADER_ATTRIBUTE12 HEADER_ATTRIBUTE12, HEADER_ATTRIBUTE13 HEADER_ATTRIBUTE13, HEADER_ATTRIBUTE14 HEADER_ATTRIBUTE14, HEADER_ATTRIBUTE15 HEADER_ATTRIBUTE15, LINE_ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY, LINE_ATTRIBUTE1 LINE_ATTRIBUTE1, LINE_ATTRIBUTE2 LINE_ATTRIBUTE2, LINE_ATTRIBUTE3 LINE_ATTRIBUTE3, LINE_ATTRIBUTE4 LINE_ATTRIBUTE4, LINE_ATTRIBUTE5 LINE_ATTRIBUTE5, LINE_ATTRIBUTE6 LINE_ATTRIBUTE6, LINE_ATTRIBUTE7 LINE_ATTRIBUTE7, LINE_ATTRIBUTE8 LINE_ATTRIBUTE8, LINE_ATTRIBUTE9 LINE_ATTRIBUTE9, LINE_ATTRIBUTE10 LINE_ATTRIBUTE10, LINE_ATTRIBUTE11 LINE_ATTRIBUTE11, LINE_ATTRIBUTE12 LINE_ATTRIBUTE12, LINE_ATTRIBUTE13 LINE_ATTRIBUTE13, LINE_ATTRIBUTE14 LINE_ATTRIBUTE14, LINE_ATTRIBUTE15 LINE_ATTRIBUTE15, PROCESSED_FLAG PROCESSED_FLAG, BATCH_ID BATCH_ID, BATCH_LINE_ID BATCH_LINE_ID, GBL_CLAIM_REJ_CODE1 GBL_CLAIM_REJ_CODE1, GBL_CLAIM_REJ_CODE2 GBL_CLAIM_REJ_CODE2, GBL_CLAIM_REJ_CODE3 GBL_CLAIM_REJ_CODE3, GBL_CLAIM_REJ_CODE4 GBL_CLAIM_REJ_CODE4, GBL_CLAIM_REJ_CODE5 GBL_CLAIM_REJ_CODE5, GBL_CLAIM_REJ_CODE6 GBL_CLAIM_REJ_CODE6, GBL_CLAIM_REJ_CODE7 GBL_CLAIM_REJ_CODE7, GBL_CLAIM_REJ_CODE8 GBL_CLAIM_REJ_CODE8, GBL_CLAIM_REJ_CODE9 GBL_CLAIM_REJ_CODE9, GBL_CLAIM_REJ_CODE10 GBL_CLAIM_REJ_CODE10, VALIDATION_TXT VALIDATION_TXT, VENDOR_AUTH_QUANTITY VENDOR_AUTH_QUANTITY, HEADER_ATTRIBUTE16 HEADER_ATTRIBUTE16, HEADER_ATTRIBUTE17 HEADER_ATTRIBUTE17, HEADER_ATTRIBUTE18 HEADER_ATTRIBUTE18, HEADER_ATTRIBUTE19 HEADER_ATTRIBUTE19, HEADER_ATTRIBUTE20 HEADER_ATTRIBUTE20, HEADER_ATTRIBUTE21 HEADER_ATTRIBUTE21, HEADER_ATTRIBUTE22 HEADER_ATTRIBUTE22, HEADER_ATTRIBUTE23 HEADER_ATTRIBUTE23, HEADER_ATTRIBUTE24 HEADER_ATTRIBUTE24, HEADER_ATTRIBUTE25 HEADER_ATTRIBUTE25, HEADER_ATTRIBUTE26 HEADER_ATTRIBUTE26, HEADER_ATTRIBUTE27 HEADER_ATTRIBUTE27, HEADER_ATTRIBUTE28 HEADER_ATTRIBUTE28, HEADER_ATTRIBUTE29 HEADER_ATTRIBUTE29, HEADER_ATTRIBUTE30 HEADER_ATTRIBUTE30, LINE_ATTRIBUTE16 LINE_ATTRIBUTE16, LINE_ATTRIBUTE17 LINE_ATTRIBUTE17, LINE_ATTRIBUTE18 LINE_ATTRIBUTE18, LINE_ATTRIBUTE19 LINE_ATTRIBUTE19, LINE_ATTRIBUTE20 LINE_ATTRIBUTE20, LINE_ATTRIBUTE21 LINE_ATTRIBUTE21, LINE_ATTRIBUTE22 LINE_ATTRIBUTE22, LINE_ATTRIBUTE23 LINE_ATTRIBUTE23, LINE_ATTRIBUTE24 LINE_ATTRIBUTE24, LINE_ATTRIBUTE25 LINE_ATTRIBUTE25, LINE_ATTRIBUTE26 LINE_ATTRIBUTE26, LINE_ATTRIBUTE27 LINE_ATTRIBUTE27, LINE_ATTRIBUTE28 LINE_ATTRIBUTE28, LINE_ATTRIBUTE29 LINE_ATTRIBUTE29, LINE_ATTRIBUTE30 LINE_ATTRIBUTE30 from "OZF"."OZF_SD_BATCH_LINES_INT_ALL"

View Text - HTML Formatted

SELECT BATCH_LINE_INT_ID BATCH_LINE_INT_ID
, FRM_CONTACT1_NAME FRM_CONTACT1_NAME
, FRM_CONTACT1_EMAIL FRM_CONTACT1_EMAIL
, FRM_CONTACT1_FAX FRM_CONTACT1_FAX
, FRM_CONTACT1_PHONE FRM_CONTACT1_PHONE
, FRM_GBL_PTNR_ROLE_CLASS_CODE FRM_GBL_PTNR_ROLE_CLASS_CODE
, FRM_BUSINESS_NAME FRM_BUSINESS_NAME
, FRM_GBL_BUSINESS_ID FRM_GBL_BUSINESS_ID
, FRM_GBL_SUPPLY_CHAIN_CODE FRM_GBL_SUPPLY_CHAIN_CODE
, FRM_PROP_BUSINESS_ID FRM_PROP_BUSINESS_ID
, FRM_PROP_DOMAIN_ID1 FRM_PROP_DOMAIN_ID1
, FRM_PROP_ID_AUTHORITY1 FRM_PROP_ID_AUTHORITY1
, FRM_GBL_PARTNER_CLASS_CODE FRM_GBL_PARTNER_CLASS_CODE
, FRM_CONTACT2_NAME FRM_CONTACT2_NAME
, FRM_CONTACT2_EMAIL FRM_CONTACT2_EMAIL
, FRM_CONTACT2_FAX FRM_CONTACT2_FAX
, FRM_CONTACT2_PHONE FRM_CONTACT2_PHONE
, FRM_GBL_LOCATION_ID FRM_GBL_LOCATION_ID
, FRM_PROP_DOMAIN_ID2 FRM_PROP_DOMAIN_ID2
, FRM_PROP_ID_AUTHORITY2 FRM_PROP_ID_AUTHORITY2
, FRM_PROP_LOCATION_ID FRM_PROP_LOCATION_ID
, FRM_ADDRESS_LINE1 FRM_ADDRESS_LINE1
, FRM_ADDRESS_LINE2 FRM_ADDRESS_LINE2
, FRM_ADDRESS_LINE3 FRM_ADDRESS_LINE3
, FRM_CITY_NAME FRM_CITY_NAME
, FRM_GBL_COUNTRY_CODE FRM_GBL_COUNTRY_CODE
, FRM_NATIONAL_POSTAL_CODE FRM_NATIONAL_POSTAL_CODE
, FRM_POBOX_ID FRM_POBOX_ID
, FRM_REGION_NAME FRM_REGION_NAME
, GBL_DOC_FUNCTION_CODE GBL_DOC_FUNCTION_CODE
, SHIP_FRM_SD_AUTHORIZATION_ID SHIP_FRM_SD_AUTHORIZATION_ID
, DIST_BY_BUSINESS_NAME DIST_BY_BUSINESS_NAME
, DIST_BY_GBL_BUSINESS_ID DIST_BY_GBL_BUSINESS_ID
, DIST_BY_GBL_SUPPLY_CHAIN_CODE DIST_BY_GBL_SUPPLY_CHAIN_CODE
, DIST_BY_PROP_BUSINESS_ID DIST_BY_PROP_BUSINESS_ID
, DIST_BY_PROP_DOMAIN_ID1 DIST_BY_PROP_DOMAIN_ID1
, DIST_BY_PROP_IDAUTHORITY1 DIST_BY_PROP_IDAUTHORITY1
, DIST_BY_GBL_PARTNER_CLASS_CODE DIST_BY_GBL_PARTNER_CLASS_CODE
, DIST_BY_CONTACT1_NAME DIST_BY_CONTACT1_NAME
, DIST_BY_CONTACT1_EMAIL DIST_BY_CONTACT1_EMAIL
, DIST_BY_CONTACT1_FAX DIST_BY_CONTACT1_FAX
, DIST_BY_CONTACT1_PHONE DIST_BY_CONTACT1_PHONE
, DIST_BY_GBL_LOCATION_ID DIST_BY_GBL_LOCATION_ID
, DIST_BY_PROP_DOMAIN_ID2 DIST_BY_PROP_DOMAIN_ID2
, DIST_BY_PROP_IDAUTHORITY2 DIST_BY_PROP_IDAUTHORITY2
, DIST_BY_PROP_LOCATION_ID DIST_BY_PROP_LOCATION_ID
, DIST_BY_ADDRESS_LINE1 DIST_BY_ADDRESS_LINE1
, DIST_BY_ADDRESS_LINE2 DIST_BY_ADDRESS_LINE2
, DIST_BY_ADDRESS_LINE3 DIST_BY_ADDRESS_LINE3
, DIST_BY_CITY_NAME DIST_BY_CITY_NAME
, DIST_BY_GBL_COUNTRY_CODE DIST_BY_GBL_COUNTRY_CODE
, DIST_BY_NATIONAL_POSTAL_CODE DIST_BY_NATIONAL_POSTAL_CODE
, DIST_BY_POBOX_ID DIST_BY_POBOX_ID
, DIST_BY_REGION_NAME DIST_BY_REGION_NAME
, SHIP_TO_BUSINESS_NAME SHIP_TO_BUSINESS_NAME
, SHIP_TO_GBL_BUSINESS_ID SHIP_TO_GBL_BUSINESS_ID
, SHIP_TO_GBL_SUPPLY_CHAIN_CODE SHIP_TO_GBL_SUPPLY_CHAIN_CODE
, SHIP_TO_PROP_BUSINESS_ID SHIP_TO_PROP_BUSINESS_ID
, SHIP_TO_PROP_DOMAIN_ID2 SHIP_TO_PROP_DOMAIN_ID2
, SHIP_TO_PROP_ID_AUTHORITY2 SHIP_TO_PROP_ID_AUTHORITY2
, SHIP_TO_GBL_PARTNER_CLASS_CODE SHIP_TO_GBL_PARTNER_CLASS_CODE
, SHIP_TO_CONTACT1_NAME SHIP_TO_CONTACT1_NAME
, SHIP_TO_CONTACT1_EMAIL SHIP_TO_CONTACT1_EMAIL
, SHIP_TO_CONTACT1_FAX SHIP_TO_CONTACT1_FAX
, SHIP_TO_CONTACT1_PHONE SHIP_TO_CONTACT1_PHONE
, SHIP_TO_GBL_LOCATION_ID SHIP_TO_GBL_LOCATION_ID
, SHIP_TO_PROP_DOMAIN_ID1 SHIP_TO_PROP_DOMAIN_ID1
, SHIP_TO_PROP_ID_AUTHORITY1 SHIP_TO_PROP_ID_AUTHORITY1
, SHIP_TO_PROP_LOCATION_ID SHIP_TO_PROP_LOCATION_ID
, SHIP_TO_ADDRESS_LINE1 SHIP_TO_ADDRESS_LINE1
, SHIP_TO_ADDRESS_LINE2 SHIP_TO_ADDRESS_LINE2
, SHIP_TO_ADDRESS_LINE3 SHIP_TO_ADDRESS_LINE3
, SHIP_TO_CITY_NAME SHIP_TO_CITY_NAME
, SHIP_TO_GBL_COUNTRY_CODE SHIP_TO_GBL_COUNTRY_CODE
, SHIP_TO_NATIONAL_POSTAL_CODE SHIP_TO_NATIONAL_POSTAL_CODE
, SHIP_TO_POBOX_ID SHIP_TO_POBOX_ID
, SHIP_TO_REGION_NAME SHIP_TO_REGION_NAME
, SOLD_TO_BUSINESS_NAME SOLD_TO_BUSINESS_NAME
, SOLD_TO_GBL_BUSINESS_ID SOLD_TO_GBL_BUSINESS_ID
, SOLD_TO_GBL_SUPPLY_CHAIN_CODE SOLD_TO_GBL_SUPPLY_CHAIN_CODE
, SOLD_TO_PROP_BUSINESS_ID SOLD_TO_PROP_BUSINESS_ID
, SOLD_TO_PROP_DOMAIN_ID2 SOLD_TO_PROP_DOMAIN_ID2
, SOLD_TO_PROP_ID_AUTHORITY2 SOLD_TO_PROP_ID_AUTHORITY2
, SOLD_TO_GBL_PARTNER_CLASS_CODE SOLD_TO_GBL_PARTNER_CLASS_CODE
, SOLD_TO_CONTACT1_NAME SOLD_TO_CONTACT1_NAME
, SOLD_TO_CONTACT1_EMAIL SOLD_TO_CONTACT1_EMAIL
, SOLD_TO_CONTACT1_FAX SOLD_TO_CONTACT1_FAX
, SOLD_TO_CONTACT1_PHONE SOLD_TO_CONTACT1_PHONE
, SOLD_TO_GBL_LOCATION_ID SOLD_TO_GBL_LOCATION_ID
, SOLD_TO_PROP_DOMAIN_ID1 SOLD_TO_PROP_DOMAIN_ID1
, SOLD_TO_PROP_ID_AUTHORITY1 SOLD_TO_PROP_ID_AUTHORITY1
, SOLD_TO_PROP_LOCATION_ID SOLD_TO_PROP_LOCATION_ID
, SOLD_TO_ADDRESS_LINE1 SOLD_TO_ADDRESS_LINE1
, SOLD_TO_ADDRESS_LINE2 SOLD_TO_ADDRESS_LINE2
, SOLD_TO_ADDRESS_LINE3 SOLD_TO_ADDRESS_LINE3
, SOLD_TO_CITY_NAME SOLD_TO_CITY_NAME
, SOLD_TO_GBL_COUNTRY_CODE SOLD_TO_GBL_COUNTRY_CODE
, SOLD_TO_NATIONAL_POSTAL_CODE SOLD_TO_NATIONAL_POSTAL_CODE
, SOLD_TO_POBOX_ID SOLD_TO_POBOX_ID
, SOLD_TO_REGION_NAME SOLD_TO_REGION_NAME
, USED_BY_BUSINESS_NAME USED_BY_BUSINESS_NAME
, USED_BY_GBL_BUSINESS_ID USED_BY_GBL_BUSINESS_ID
, USED_BY_GBL_SUPPLY_CHAIN_CODE USED_BY_GBL_SUPPLY_CHAIN_CODE
, USED_BY_PROP_BUSINESS_ID USED_BY_PROP_BUSINESS_ID
, USED_BY_PROP_DOMAIN_ID1 USED_BY_PROP_DOMAIN_ID1
, USED_BY_PROP_ID_AUTHORITY1 USED_BY_PROP_ID_AUTHORITY1
, USED_BY_GBL_PARTNER_CLASS_CODE USED_BY_GBL_PARTNER_CLASS_CODE
, USED_BY_CONTACT1_NAME USED_BY_CONTACT1_NAME
, USED_BY_CONTACT1_EMAIL USED_BY_CONTACT1_EMAIL
, USED_BY_CONTACT1_FAX USED_BY_CONTACT1_FAX
, USED_BY_CONTACT1_PHONE USED_BY_CONTACT1_PHONE
, USED_BY_GBL_LOCATION_ID USED_BY_GBL_LOCATION_ID
, USED_BY_PROP_DOMAIN_ID2 USED_BY_PROP_DOMAIN_ID2
, USED_BY_PROP_ID_AUTHORITY2 USED_BY_PROP_ID_AUTHORITY2
, USED_BY_PROP_LOCATION_ID USED_BY_PROP_LOCATION_ID
, USED_BY_ADDRESS_LINE1 USED_BY_ADDRESS_LINE1
, USED_BY_ADDRESS_LINE2 USED_BY_ADDRESS_LINE2
, USED_BY_ADDRESS_LINE3 USED_BY_ADDRESS_LINE3
, USED_BY_CITY_NAME USED_BY_CITY_NAME
, USED_BY_GBL_COUNTRY_CODE USED_BY_GBL_COUNTRY_CODE
, USED_BY_NATIONAL_POSTAL_CODE USED_BY_NATIONAL_POSTAL_CODE
, USED_BY_POBOX_ID USED_BY_POBOX_ID
, USED_BY_REGION_NAME USED_BY_REGION_NAME
, SHIP_FRM_SD_CLAIM_REQUEST_DATE SHIP_FRM_SD_CLAIM_REQUEST_DATE
, SHIP_FRM_SD_CLAIM_REQUEST_ID SHIP_FRM_SD_CLAIM_REQUEST_ID
, CREDIT_REFERENCE_ID CREDIT_REFERENCE_ID
, DEBIT_REFERENCE_ID DEBIT_REFERENCE_ID
, BATCH_LINE_NUMBER BATCH_LINE_NUMBER
, ORDER_DATE ORDER_DATE
, ORDER_LINE_NUMBER ORDER_LINE_NUMBER
, ORDER_NUMBER ORDER_NUMBER
, INVOICE_DATE INVOICE_DATE
, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER
, INVOICE_NUMBER INVOICE_NUMBER
, COST_CURRENCY_CODE COST_CURRENCY_CODE
, COST_MONETARY_AMOUNT COST_MONETARY_AMOUNT
, AUTH_COST_CURRENCY_CODE AUTH_COST_CURRENCY_CODE
, AUTH_COST_MONETARY_AMOUNT AUTH_COST_MONETARY_AMOUNT
, RESALE_CURRENCY_CODE RESALE_CURRENCY_CODE
, RESALE_MONETARY_AMOUNT RESALE_MONETARY_AMOUNT
, GBL_UOM GBL_UOM
, GBL_CLAIM_DISPOSITION_CODE GBL_CLAIM_DISPOSITION_CODE
, VENDOR_PRODUCT_ID VENDOR_PRODUCT_ID
, DIST_PRODUCT_ID DIST_PRODUCT_ID
, SHIP_DATE SHIP_DATE
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, VENDOR_AUTH_LINEITEM_LINE_NBR VENDOR_AUTH_LINEITEM_LINE_NBR
, VENDOR_AUTH_COST_CURRENCY_CODE VENDOR_AUTH_COST_CURRENCY_CODE
, VENDOR_AUTH_COST_MONETARY_AMT VENDOR_AUTH_COST_MONETARY_AMT
, THIS_DOC_GENERATION_DATE THIS_DOC_GENERATION_DATE
, THIS_DOCUMENT_ID THIS_DOCUMENT_ID
, TO_CONTACT1_NAME TO_CONTACT1_NAME
, TO_CONTACT1_EMAIL TO_CONTACT1_EMAIL
, TO_CONTACT1_FAX TO_CONTACT1_FAX
, TO_CONTACT1_PHONE TO_CONTACT1_PHONE
, TO_GBL_PARTNER_ROLE_CLASS_CODE TO_GBL_PARTNER_ROLE_CLASS_CODE
, TO_BUSINESS_NAME1 TO_BUSINESS_NAME1
, TO_GBL_BUSINESS_ID TO_GBL_BUSINESS_ID
, TO_GBL_SUPPLY_CHAIN_CODE TO_GBL_SUPPLY_CHAIN_CODE
, TO_PROP_BUSINESS_ID TO_PROP_BUSINESS_ID
, TO_PROP_DOMAIN_ID1 TO_PROP_DOMAIN_ID1
, TO_PROP_ID_AUTHORITY1 TO_PROP_ID_AUTHORITY1
, TO_GBL_PARTNER_CLASS_CODE TO_GBL_PARTNER_CLASS_CODE
, TO_CONTACT2_NAME TO_CONTACT2_NAME
, TO_CONTACT2_EMAIL TO_CONTACT2_EMAIL
, TO_CONTACT2_FAX TO_CONTACT2_FAX
, TO_CONTACT2_PHONE TO_CONTACT2_PHONE
, TO_GBL_LOCATION_ID TO_GBL_LOCATION_ID
, TO_PROP_DOMAIN_ID2 TO_PROP_DOMAIN_ID2
, TO_PROP_ID_AUTHORITY2 TO_PROP_ID_AUTHORITY2
, TO_PROP_LOCATION_ID TO_PROP_LOCATION_ID
, TO_ADDRESS_LINE1 TO_ADDRESS_LINE1
, TO_ADDRESS_LINE2 TO_ADDRESS_LINE2
, TO_ADDRESS_LINE3 TO_ADDRESS_LINE3
, TO_CITY_NAME TO_CITY_NAME
, TO_GBL_COUNTRY_CODE TO_GBL_COUNTRY_CODE
, TO_NATIONAL_POSTAL_CODE TO_NATIONAL_POSTAL_CODE
, TO_POBOX_ID TO_POBOX_ID
, TO_REGION_NAME TO_REGION_NAME
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, REQUEST_ID REQUEST_ID
, CREATED_BY CREATED_BY
, CREATED_FROM CREATED_FROM
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_ID PROGRAM_ID
, HEADER_ATTRIBUTE_CATEGORY HEADER_ATTRIBUTE_CATEGORY
, HEADER_ATTRIBUTE1 HEADER_ATTRIBUTE1
, HEADER_ATTRIBUTE2 HEADER_ATTRIBUTE2
, HEADER_ATTRIBUTE3 HEADER_ATTRIBUTE3
, HEADER_ATTRIBUTE4 HEADER_ATTRIBUTE4
, HEADER_ATTRIBUTE5 HEADER_ATTRIBUTE5
, HEADER_ATTRIBUTE6 HEADER_ATTRIBUTE6
, HEADER_ATTRIBUTE7 HEADER_ATTRIBUTE7
, HEADER_ATTRIBUTE8 HEADER_ATTRIBUTE8
, HEADER_ATTRIBUTE9 HEADER_ATTRIBUTE9
, HEADER_ATTRIBUTE10 HEADER_ATTRIBUTE10
, HEADER_ATTRIBUTE11 HEADER_ATTRIBUTE11
, HEADER_ATTRIBUTE12 HEADER_ATTRIBUTE12
, HEADER_ATTRIBUTE13 HEADER_ATTRIBUTE13
, HEADER_ATTRIBUTE14 HEADER_ATTRIBUTE14
, HEADER_ATTRIBUTE15 HEADER_ATTRIBUTE15
, LINE_ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY
, LINE_ATTRIBUTE1 LINE_ATTRIBUTE1
, LINE_ATTRIBUTE2 LINE_ATTRIBUTE2
, LINE_ATTRIBUTE3 LINE_ATTRIBUTE3
, LINE_ATTRIBUTE4 LINE_ATTRIBUTE4
, LINE_ATTRIBUTE5 LINE_ATTRIBUTE5
, LINE_ATTRIBUTE6 LINE_ATTRIBUTE6
, LINE_ATTRIBUTE7 LINE_ATTRIBUTE7
, LINE_ATTRIBUTE8 LINE_ATTRIBUTE8
, LINE_ATTRIBUTE9 LINE_ATTRIBUTE9
, LINE_ATTRIBUTE10 LINE_ATTRIBUTE10
, LINE_ATTRIBUTE11 LINE_ATTRIBUTE11
, LINE_ATTRIBUTE12 LINE_ATTRIBUTE12
, LINE_ATTRIBUTE13 LINE_ATTRIBUTE13
, LINE_ATTRIBUTE14 LINE_ATTRIBUTE14
, LINE_ATTRIBUTE15 LINE_ATTRIBUTE15
, PROCESSED_FLAG PROCESSED_FLAG
, BATCH_ID BATCH_ID
, BATCH_LINE_ID BATCH_LINE_ID
, GBL_CLAIM_REJ_CODE1 GBL_CLAIM_REJ_CODE1
, GBL_CLAIM_REJ_CODE2 GBL_CLAIM_REJ_CODE2
, GBL_CLAIM_REJ_CODE3 GBL_CLAIM_REJ_CODE3
, GBL_CLAIM_REJ_CODE4 GBL_CLAIM_REJ_CODE4
, GBL_CLAIM_REJ_CODE5 GBL_CLAIM_REJ_CODE5
, GBL_CLAIM_REJ_CODE6 GBL_CLAIM_REJ_CODE6
, GBL_CLAIM_REJ_CODE7 GBL_CLAIM_REJ_CODE7
, GBL_CLAIM_REJ_CODE8 GBL_CLAIM_REJ_CODE8
, GBL_CLAIM_REJ_CODE9 GBL_CLAIM_REJ_CODE9
, GBL_CLAIM_REJ_CODE10 GBL_CLAIM_REJ_CODE10
, VALIDATION_TXT VALIDATION_TXT
, VENDOR_AUTH_QUANTITY VENDOR_AUTH_QUANTITY
, HEADER_ATTRIBUTE16 HEADER_ATTRIBUTE16
, HEADER_ATTRIBUTE17 HEADER_ATTRIBUTE17
, HEADER_ATTRIBUTE18 HEADER_ATTRIBUTE18
, HEADER_ATTRIBUTE19 HEADER_ATTRIBUTE19
, HEADER_ATTRIBUTE20 HEADER_ATTRIBUTE20
, HEADER_ATTRIBUTE21 HEADER_ATTRIBUTE21
, HEADER_ATTRIBUTE22 HEADER_ATTRIBUTE22
, HEADER_ATTRIBUTE23 HEADER_ATTRIBUTE23
, HEADER_ATTRIBUTE24 HEADER_ATTRIBUTE24
, HEADER_ATTRIBUTE25 HEADER_ATTRIBUTE25
, HEADER_ATTRIBUTE26 HEADER_ATTRIBUTE26
, HEADER_ATTRIBUTE27 HEADER_ATTRIBUTE27
, HEADER_ATTRIBUTE28 HEADER_ATTRIBUTE28
, HEADER_ATTRIBUTE29 HEADER_ATTRIBUTE29
, HEADER_ATTRIBUTE30 HEADER_ATTRIBUTE30
, LINE_ATTRIBUTE16 LINE_ATTRIBUTE16
, LINE_ATTRIBUTE17 LINE_ATTRIBUTE17
, LINE_ATTRIBUTE18 LINE_ATTRIBUTE18
, LINE_ATTRIBUTE19 LINE_ATTRIBUTE19
, LINE_ATTRIBUTE20 LINE_ATTRIBUTE20
, LINE_ATTRIBUTE21 LINE_ATTRIBUTE21
, LINE_ATTRIBUTE22 LINE_ATTRIBUTE22
, LINE_ATTRIBUTE23 LINE_ATTRIBUTE23
, LINE_ATTRIBUTE24 LINE_ATTRIBUTE24
, LINE_ATTRIBUTE25 LINE_ATTRIBUTE25
, LINE_ATTRIBUTE26 LINE_ATTRIBUTE26
, LINE_ATTRIBUTE27 LINE_ATTRIBUTE27
, LINE_ATTRIBUTE28 LINE_ATTRIBUTE28
, LINE_ATTRIBUTE29 LINE_ATTRIBUTE29
, LINE_ATTRIBUTE30 LINE_ATTRIBUTE30
FROM "OZF"."OZF_SD_BATCH_LINES_INT_ALL"