Wednesday, November 23, 2011

RCV_HEADERS_INTERFACE

Purchasing
Table Or View: Table
Important columns: 
HEADER_INTERFACE_ID :  Interface EDI header unique identifier
GROUP_ID :  Interface group for set processing
ASN_TYPE :  The document type: values are ASN, ASBN, or RECEIVE
TRANSACTION_TYPE :  The transaction purpose code: values are NEW, REPLACE, ADD, or CANCEL
RECEIPT_NUM :  Receipt number
RECEIPT_HEADER_ID :  Receipt system ID
VENDOR_NAME : Supplier name from ASN; used to derive VENDOR_ID
VENDOR_NUM :  Supplier Num from ASN; used to derive VENDOR_ID
VENDOR_ID : Source supplier unique ID
VENDOR_SITE_CODE :  Supplier site code from ASN; used to derive VENDOR_SITE_ID
VENDOR_SITE_ID : Source supplier site unique identifier
FROM_ORGANIZATION_CODE :  Source organization code; used to derive from ORGANIZATION_ID
FROM_ORGANIZATION_ID :  Source organization unique identifier (internal transfers only)
INVOICE_NUM : EDI transaction 857 invoice number associated with the shipment/billing notice (ASN with billing information)
INVOICE_DATE : EDI transaction 857 invoice date associated with the shipment/billing notice
TOTAL_INVOICE_AMOUNT : EDI transaction 857 invoice amount associated with the shipment/billing notice
TAX_NAME : EDI transaction 857 tax name associated with the shipment/billing notice
TAX_AMOUNT : EDI transaction 857 tax amount associated with the shipment/billing notice name indicated at the header level
FREIGHT_AMOUNT : EDI transaction 857 freight bill amount associated with the shipment/billing notice
ORG_ID :  Operational Unit Unique Identifier
OPERATING_UNIT : Operating Unit Name used to derive ORG_ID
VALIDATION_FLAG : Marked after open interface validation

Description: 
RCV_HEADERS_INTERFACE is an interface table that stores receiving header information.

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect