Views Schema

This section provides detailed schema definitions for each Reporting Server DB view, including column names, and data types.

VW_LOCATION_INVENTORY_ALLOCATION_WITH_LOC_DETAILS

Column Name	Description
ITEM_INVENTORY_ID	Unique identifier for this inventory record (from TBL_ITEM_INVENTORY).
STORE_ID	Store identifier.
LOCN_ID	Location identifier within the store.
ITEM_ID	Item identifier.
ON_HAND_QTY	Total inventory quantity, including Not Available, Available..
NOT_AVAILABLE_QTY	Quantity that is unavailable due to damage or being unsellable at the specific location.
AVAILABLE_QTY	Quantity available for use (On Hand - Not Available - Allocated ).
QTY_ALLOCATED	Quantity already allocated for picking/waves.
NET_AVAILABLE	Available quantity after subtracting allocations (Available - Allocated).
LAST_COUNTED_BY	The user who last completed the cycle count.
LAST_COUNTED_DTTM	Date and time of the last inventory count.
ITEM_NUMBER	Item number from master.
DESCRIPTION	Item description.
ITEM_BARCODE	Barcode of the item.
ITEM_UPC	UPC of the item.
BASE_PART_NUMBER	Base part number from product header.
BASE_UOM_ID	Base unit of measure ID.
BASE_UOM_NAME	Name of base unit of measure.
ALTERNATIVE_ITEM_NUMBER1	Alternative item number 1.
ALTERNATIVE_ITEM_NUMBER2	Alternative item number 2.
ALTERNATIVE_ITEM_NUMBER3	Alternative item number 3.
TAGS	Item tags/labels.
ALERT_NOTE	Notes for alerts/warnings.
SALES_NOTES	Notes for sales.
SELL_UOM_ID	Selling unit of measure ID.
IS_SELLABLE_FLAG	Boolean flag indicating if the item is sellable. (Boolean : True/1 or False/0)
IS_BOM_ITEM_FLAG	Boolean flag indicating if the item is a BOM (Bill of Materials) item.
IS_RAW_MATERIAL_FLAG	Boolean flag for raw material.
IS_PURCHASABLE_FLAG	Boolean flag for purchasable item.
SELL_PKG_QTY	Quantity per selling package.
ACTIVE_FLAG	Boolean flag indicating active status.
STANDARD_UNIT_PRICE	Standard unit selling price.
STANDARD_UNIT_COST	Standard unit cost.
SEASON_VALUES	Season-related value or code.
CUSTOM_PRICE_1 … CUSTOM_PRICE_14	Custom pricing fields for flexibility.
IS_3A_ITEM	Boolean flag for 3A item classification.
ACCOUNT_3PL_ID	3PL account ID for this item.
GENDER_CODE	Gender classification code, if applicable.
ADJ_ACCNT_ID	Adjustment account ID.
DEFAULT_VENDOR_ID	Default vendor ID.
PRODUCT_HEADER_ID	Product header reference ID.
TITLE	Product title.
PRODUCT_CATEGORY_ID	Product category reference ID.
OPTION1_ID	Option 1 reference ID from product header.
OPTION2_ID	Option 2: reference ID from product header.
OPTION3_ID	Option 3: reference ID from product header.
OPTION1_VALUE_ID	Selected option 1 value ID.
OPTION2_VALUE_ID	Selected option 2 value ID.
OPTION3_VALUE_ID	Selected option 3 value ID.
GROUP_ID	Item group ID.
BRAND_ID	Item brand ID.
CATEGORY_ID	Item category ID.
SUB_CATEGORY_ID	Sub-category ID from item.
PRODUCT_IMAGE_ID	Reference ID for product image.
LOCN_BARCODE	Location barcode.
DISP_LOCN	Display the name of the location.
LOCN_CLASS_ID	Location class ID.
LOCATION_CLASS_NAME	Name of location class.
LOCN_TYPE_ID	Location type ID.
LOCATION_TYPE_NAME	Location type name.
LOCN_TYPE_NAME	Alias for location type name.
LPN_ID	LPN (License Plate Number) ID.
PICK_SEQ	Pick a sequence number from warehouse.
AREA	Area of the warehouse.
AISLE	Aisle number in warehouse.
BAY	Bay number in warehouse.
LVL	Level or shelf number in warehouse.
POSITION	Position within the shelf.
DEPTH	Depth of location.
LENGTH	Length of location.
WIDTH	Width of location.
HEIGHT	Height of location.
IS_VIRTUAL_LPN_LOCATION	Boolean flag if location is a virtual LPN.
IS_VIRTUAL_LPN	Boolean flag if LPN is virtual.
ZONE_ID	Zone identifier for the warehouse.
ZONE_NAME	Zone name.
LPN_NUMBER	LPN number.
MFG_DATE	Manufacturing date.
LOT_NUMBER	Lot number.
BATCH_NUMBER	Batch number.
PRIORITY_NUMBER	Picking priority.
EXP_DATE	Expiration date.
IS_MIXED_LPN	Boolean flag if LPN contains mixed items.
IS_SEALED_CASE	Boolean flag if LPN is a sealed case.
IS_FULL_CASE	Boolean flag if full case.
MASTER_LPN_ID	Reference to pallet ID.
CASE_QTY	Case quantity.
ITEM_MASTER_CASE_QTY	Item master case quantity.
LPN_CREATE_DTTM	LPN creation datetime.
LPN_CREATE_SOURCE	LPN creation source.
LPN_MODIFY_DTTM	LPN last modified datetime.
LPN_MODIFY_SOURCE	LPN last modified source.
PTO_ID	PTO reference ID if applicable.
PALLET	Pallet number.
QUALITY_ID	Item quality ID.
QUALITY_NAME	Item quality name.
QUALITY_CODE	Item quality code.
LPN_PICK_TYPE	Pick a type for LPN.
TOTAL_AMOUNT	Total monetary value of inventory.
TOTAL_QTY	Total quantity of inventory.
AVG_COST	Average cost of item.
STORE_NAME	Name of the store.
ACCOUNT_3PL_NAME	Name of 3PL account.
ACCOUNT_3PL_CODE	3PL account code.
DEFAULT_VENDOR_NAME	Vendor name.
IMAGE_SRC	Product image URL/source.
BATCH_NUMBER_FLAG	Boolean flag if batch number is tracked.
EXPIRY_DATE_FLAG	Boolean flag if expiry date is tracked.
LOT_NUMBER_FLAG	Boolean flag if lot number is tracked.
MANUFACTURE_DATE_FLAG	Boolean flag if the manufacture date is tracked.
QUALITY_FLAG	Boolean flag if quality is tracked.
DECIMAL_FLAG_BASE	Decimal flag for base UOM.
UOM_NAME	Selling unit of measure name.
DECIMAL_FLAG	Decimal flag for selling UOM.
MATERIAL_NAME	Material name from item.
CUSTOM_FIELD_VALUE1 … CUSTOM_FIELD_VALUE15	Custom attributes for extended use.
ITEM_PRODUCT_CATEGORY_NAME	Product category name.
OPTION_1_NAME	Option 1 name from item.
OPTION_2_NAME	Option 2 name from item.
OPTION_3_NAME	Option 3 name from item.
OPTION_1_VALUE	Option 1 selected value from item.
OPTION_1_SEQ	Option 1 sequence number from item.
OPTION_1_CODE	Option 1 code from item.
OPTION_2_VALUE	Option 2 selected value from item.
OPTION_2_SEQ	Option 2 sequence number from item.
OPTION_2_CODE	Option 2 code from item.
OPTION_3_VALUE	Option 3 selected value from item.
OPTION_3_SEQ	Option 3 sequence number from item.
OPTION_3_CODE	Option 3 code from item.
GROUP_NAME	Group name of item.
BRAND_NAME	Brand name from item.
CATEGORY_NAME	Category name from item.
SUB_CATEGORY_NAME	Sub-category name from item.
IS_SELLABLE_FLAG_STR	Y' if item is sellable, 'N' otherwise.
IS_BOM_ITEM_FLAG_STR	Y' if item is BOM, 'N' otherwise.
IS_RAW_MATERIAL_FLAG_STR	Y' if item is raw material, 'N' otherwise.
IS_PURCHASABLE_FLAG_STR	Y' if item is purchasable, 'N' otherwise.
ACTIVE_FLAG_STR	Y' if item is active, 'N' otherwise.
CUBIC_METERS	Volume of inventory in cubic meters.
CUBIC_CAPACITY_UOM_CODE	UOM code for cubic capacity.

VW_APP_COMMENT_INFO

Column Name	Description
ID	Unique ID for the comment.
IMAGE_URL	User profile image URL.
TXN_TYPE_ID	Type of transaction linked to the comment.
TXN_REF_ID	Reference ID for the transaction associated with the comment.
COMMENT_BODY	The text content of the comment.
CREATE_DTTM	Date and time when the comment was created.
CREATE_SOURCE	Source of creation
MODIFY_DTTM	Date and time when the comment was last updated.
MODIFY_SOURCE	Source responsible for the last modification.
READ_ONLY_FLAG	Indicates if the comment is read-only (cannot be edited).
USER_TYPE_ID	ID for the type of user who created the comment.
FIRST_NAME	First name of the user who made the comment.
LAST_NAME	Last name of the user who made the comment.
USER_TYPE	Type of user who made the comment (e.g., admin, regular user).
ACTION_ID	ID of the action related to the comment.
META_DATA	Additional metadata related to the activity or action.
ACTIVITY_TRACKING_ID	Unique ID for the activity tracking entry linked to the comment.

VW_ASN_DETAIL_INFO

Column Name	Description
ID	Unique ID for the ASN Detail.
ASN_ID	ID of the associated ASN (Advanced Shipping Notification).
ASN_NUMBER	ASN number from the ASN header.
STORE_ID	ID of the store associated with the ASN.
STORE	Name of the store associated with the ASN.
PO_ID	ID of the Purchase Order related to the ASN detail.
PO_LINE_ID	ID of the specific line in the Purchase Order.
ORDER_NUMBER	The order number from the Purchase Order header.
ITEM_NUMBER	Item number from the item master.
DESCRIPTION	Description of the item in the ASN.
QTY_TO_RECEIVE	Quantity of the item to be received according to the ASN.
QTY_RECEIVED	Quantity of the item that has already been received.
QTY_REMAINING	Quantity remaining to be received (calculated as QTY_TO_RECEIVE - QTY_RECEIVED).
STATUS	Status of the ASN detail (e.g., open, received, etc.).
ITEM_ID	Unique identifier for the item in the ASN detail.
LINE_STATUS_ID	ID of the line status associated with the ASN detail.
SELL_UOM_ID	Unit of measure ID for the selling unit of the item.
DECIMAL_FLAG	Flag indicating if the unit of measure requires decimals
DATE	Date and time when the ASN detail was created.
STORE_NAME	Name of the store associated with the ASN.
MODIFY_DTTM	Date and time when the ASN detail was last modified.
ASN_CLOSE_DTTM	Date and time when the ASN was closed.
DATE_EXPECTED_DELIVERY	Expected delivery date for the Purchase Order line.
EXPECTED_SHIP_DATE	Expected shipment date for the Purchase Order line.
NOTES	Additional notes or comments related to the Purchase Order line.

VW_ASN_HEADER_INFO

Column Name	Description
ID	Unique identifier for the ASN header.
STORE	Name of the store associated with the ASN.
ASN_NUMBER	ASN number.
STATUS	Current status of the ASN (e.g., open, closed, etc).
PRIORITY	Priority level for the ASN.
NOTE	Additional notes or comments for the ASN.
CREATE_SOURCE	Source of creation
DATE	Date the ASN header was created.
CREATE_DTTM	Timestamp when the ASN header was created.
STORE_ID	ID of the store associated with the ASN.
ASN_STATUS_ID	Status ID for the ASN.
ASN_CLOSE_DTTM	Timestamp when the ASN was closed.
ASN_CLOSE_DATE	Date when the ASN was closed (formatted as DATE).
RETURN_ASN_FLAG	Flag indicating whether the ASN is a return ASN.
ITEM_RECEIPT_DATE	Date when items are expected to be received.
RECEIVE_AS_NOT_AVAILABLE_FLAG	Flag indicating if the ASN should be considered as "not available" for receiving.
JOB_SCHEDULE_RUN_FLAG	Flag indicating if a job schedule run is associated with the ASN.
JOB_SCHEDULE_RUN_FLAG_STR	A string representation of the JOB_SCHEDULE_RUN_FLAG (Y for Yes, N for No).
THIRD_PARTY_DISPLAY_NAME	Name of the third party associated with the ASN.
THIRD_PARTY_ICON_URL	URL to icon for third-party source display.
THIRD_PARTY_SOURCE	Name of the external system or partner providing the shipment data.
TOTAL_QTY	Total quantity expected in the shipment.
MODIFY_DTTM	Timestamp of the last modification to the ASN record.
MODIFY_SOURCE	System or user that last modified the record.
PO_NUMBER	Purchase order number associated with this shipment.
REF_NUMBER	General reference number for the shipment.
ASN_REF_NUMBER	Specific reference number for the ASN document.
RMA_NUMBER	Return merchandise authorization number, if applicable.
INVOICE_REF	Invoice reference number linked to the shipment.
DATE_EXPECTED_DELIVERY	Expected delivery date for the shipment.
EXPECTED_SHIP_DATE	Date shipment was expected to ship from the vendor.
RETURN_ASN_FLAG_STR	"Y" if return shipment, otherwise "N".
VENDOR_NAME	Name of the vendor or supplier sending the shipment.
TOTAL_RECEIVED_QTY	Total quantity actually received from the shipment.
REMAINING_QTY	Quantity still pending receipt (total expected minus received).
TOTAL_PUTAWAY_QTY	Total quantity moved to storage locations after receipt.
SHIPMENT_ARRIVAL_DATE	Date shipment physically arrived at the facility.
BOL_NUMBER	Bill of Lading number for the shipment.
TRACKING_NUMBER	Carrier tracking number for shipment monitoring.
TRAILER_NUMBER	Trailer or container number on the delivery vehicle.
EXPECTED_CARTON_COUNT	Number of cartons expected in the shipment.
ACTUAL_CARTON_COUNT	Number of cartons actually received.
EXPECTED_PALLET_COUNT	Number of pallets expected in the shipment.
ACTUAL_PALLET_COUNT	Number of pallets actually received.
IS_SHIPMENT_ARRIVED	Flag indicating if the shipment has arrived.
DOCK_LOCATION_ID	Identifier for the receiving dock or location.
DOCK_LOCATION	Display name of the dock or receiving area.
PO_THIRD_PARTY_REF_NUMBER	Third-party reference number for the purchase order.
DOCK_LOC_TYPE_ID	Type code for the dock location (e.g., loading dock, staging).
CARRIER_ID	Identifier for the shipping carrier.
CARRIER	Name of the carrier handling the shipment.
DOCK_LOC_TYPE_NAME	Description of the dock location type.
ACCOUNT_3PL_NAME	Name of the third-party logistics account, if applicable.
CUSTOM_FIELD_VALUE1…50	Custom fields for storing additional information related to headers (available in the Custom Field tab within the header section).
AUTO_CLOSE_PO_FLAG	Flag to automatically close the linked purchase order upon ASN completion.
CM_ID	Credit Memo identifier linking to specific detail records.
LPN_COUNT	Count of license plate numbers (LPNs) in the shipment.
LINE_COUNT	Number of line items in the ASN.
RECEIVED_PERCENTAGE	Percentage of expected quantity that has been received.
RMA_THIRD_PARTY_REF_NUMBER	Third-party reference for the return authorization.
RECEIPT_NUMBER	Receipt number generated for the shipment.
THIRD_PARTY_REF_NO	General third-party reference number (null if matches PO/RMA refs).
THIRD_PARTY_RETURN_REF_NO	Third-party reference for return shipments.
UNSCHEDULED_DELIVERY	Flag indicating if this is an unscheduled or unexpected delivery.
CONTAINER_TYPE_ID	Identifier for the container type (e.g., pallet, box).
CONTAINER_TYPE_CODE	Code for the container type.
BRAND_NAME	Brand associated with the shipment contents.
IS_PROCESSED	Flag indicating if the ASN has been fully processed.
IS_MERGED_FLAG	Flag showing if this ASN is merged from multiple sources.

VW_BANK_DEPOSIT_DETAIL_INFO

Column Name	Description
ID	Unique identifier for the bank deposit line entry.
STORE_ID	ID of the store associated with the bank deposit line.
STORE_NAME	Name of the store associated with the bank deposit line.
BANK_DEPOSIT_ID	Unique identifier for the bank deposit.
BANK_DEPOSIT_NUMBER	Bank deposit number from the bank deposit.
STATUS_ID	Status ID of the bank deposit.
STATUS_NAME	Name of the status
CURRENCY_NAME	Name of the currency used in the bank deposit.
TXN_ID	Unique identifier for the transaction associated with the bank deposit line.
TXN_TYPE_ID	Transaction type ID, identifying the type of transaction (e.g., deposit, refund, etc).
TXN_NO	Transaction number for the bank deposit line.
TXN_DATE	Date when the transaction for the bank deposit line occurred.
LINE_NUMBER	Sequential line number for this specific bank deposit entry.
ENTITY_TYPE_ID	ID indicating the type of entity involved in the transaction (e.g., customer, vendor).
ENTITY_NAME	Name of the entity involved in the bank deposit transaction.
DEPOSIT_FROM_ACCNT_ID	Account ID from which the deposit originated.
DEPOSIT_FROM_ACCNT_NAME	Name of the account from which the deposit originated.
LINE_REF_ID	Reference ID for the deposit line, linking to additional details if needed.
LINE_REF_NO	Reference number for the deposit line, used for tracking.
PAYMENT_METHOD_NAME	Name of the payment method used in the transaction (e.g., cheque, cash, etc).
PAYMENT_METHOD_ID	ID of the payment method used in the transaction.
CHEQUE_NO	Cheque number used for the bank deposit, if applicable.
AMOUNT	Amount of money deposited in this bank deposit line.
MEMO	Memo or description associated with the bank deposit line.
CREATE_DTTM	Date and time when the bank deposit line was created.
CREATE_SOURCE	Source or platform from which the bank deposit line was created.
MODIFY_DTTM	Date and time when the bank deposit line was last modified.
MODIFY_SOURCE	Source or platform from which the bank deposit line was last modified.
LINKED_FLAG	Flag indicating if the deposit line is linked to another transaction .
LINKED_TXN_ID	ID of the transaction linked to this deposit line, if applicable.
THIRD_PARTY_REF_NO	Third-party reference number from bank deposit.
THIRD_PARTY_SOURCE	Thir-party source linked to bank deposit.

VW_BANK_DEPOSIT_HEADER_INFO

Column Name	Description
ID	Unique identifier for the bank deposit header.
TXN_ID	Transaction ID associated with the bank deposit.
TXN_NO	Transaction number for the bank deposit.
TXN_DATE	Date when the bank deposit transaction occurred.
BANK_DEPOSIT_NUMBER	Bank deposit number from the deposit header.
DEPOSIT_TO_ACCNT_NAME	Name of the account where the deposit is made.
DEPOSIT_TO_ACCNT_ID	ID of the account where the deposit is made.
TOTAL_AMOUNT	Total amount deposited in the bank deposit.
CURRENCY_CODE	Currency code used for the bank deposit transaction.
CURRENCY_ID	ID of the currency used in the bank deposit transaction.
CREATE_DTTM	Date and time when the bank deposit header was created.
CREATE_SOURCE	Source or platform from which the bank deposit header was created.
MODIFY_DTTM	Date and time when the bank deposit header was last modified.
MODIFY_SOURCE	Source or platform from which the bank deposit header was last modified.
EXCHANGE_RATE	Exchange rate used for the deposit, if applicable (e.g., for currency conversion).
CASH_BACK_MEMO	Memo or description associated with cash back from the bank deposit.
CASH_BACK_ACCNT_NAME	Name of the account from which cash back is issued.
CASH_BACK_ACCNT_ID	ID of the account from which cash back is issued.
CASH_BACK_AMOUNT	Amount of cash back issued, if applicable (defaults to 0 if no cash back).
MEMO	Additional notes or description for the bank deposit header.
CURRENCY_SYMBOL	Unicode symbol for the currency used in the bank deposit.
STATUS_ID	Status ID of the bank deposit.
STATUS_NAME	Name of the status linked to STATUS_ID (e.g., completed, pending).
RECONCILED_FLAG_STR	String representation of the reconciliation status .
RECONCILED_FLAG	Flag indicating whether the bank deposit has been reconciled.
DEPOSITED_FLAG	Flag indicating whether the bank deposit has been successfully deposited.
THIRD_PARTY_REF_NO	Reference number for the third-party source associated with the deposit.
THIRD_PARTY_SOURCE	Source of the third-party (e.g., bank, vendor) associated with the deposit.

VW_BILL_DETAIL_INFO

Column Name	Description
ID	Unique identifier for the bill item line.
QTY_ORDERED	Ordered qty in bill item line.
QTY_RECEIVED	Received qty of bill item line.
QTY_REMAINING	Remaining quantity to be received.
RECEIPT_ID	Identifier for the receipt associated with the bill item.
TXN_ID	Identifier for the transaction.
TXN_NUMBER	Transaction number for reference.
LINE_SEQ	Sequence number for the bill line item.
PO_ID	Purchase Order identifier.
PO_NUMBER	Purchase Order number.
PO_LINE_ID	Purchase order line identifier.
ASN_ID	Advanced Shipping Notice identifier.
ASN_LINE_ID	ASN detail Line identifier.
ITEM_ID	Identifier for the item in the bill.
ITEM_TYPE_ID	Type identifier for the item.
ITEM_TYPE_NAME	Name of the item type.
ITEM_NUMBER	Number or code for the item.
DESCRIPTION	Description of the item.
RATE	Unit rate or price for the item.
UOM_NAME	Unit of measure for the item.
UOM_ID	Identifier for the unit of measure.
QTY	Quantity of the item in the bill item line.
AMOUNT	Total amount for the line item.
LANDED_UNIT_COST	Cost per unit including shipping and handling.
LANDED_AMOUNT	Total landed cost for the line item.
TAX_CODE_ID	Identifier for the tax code applied.
TAX_CODE_NAME	Name of the tax code applied.
TAX_AMT_NON_COLLECTABLE	Non-collectable tax amount for the item.
TAX_AMT_RC_NON_COLLECTABLE	Non-collectable tax amount for the returned item.
TAX_AMOUNT	Total tax amount for the item.
STATUS_ID	Status identifier for the bill item.
CUSTOMER_ID	Customer identifier related to the item.
ITEM_BILLABLE_FLAG	Indicates if the item is billable.
RECONCILE_ITEM_FLAG	Flag indicating if the item is reconciled.
RECONCILED_ROW_FLAG	Flag indicating if the row is reconciled.
CREATE_DTTM	Date and time when the record was created.
CREATE_SOURCE	Source for the record creation.
MODIFY_DTTM	Date and time when the record was last modified.
MODIFY_SOURCE	Source for the record modification.
DECIMAL_FLAG	Flag indicating if the unit of measure uses decimals.
TYPE	Type of bill.
TXN_DATE	Date of the transaction.
SYMBOL_UNICODE_VAL	Unicode symbol for the currency.
RECEIPT_NUMBER	Receipt number for the bill.
PROJECT_CLASS_HEADER_ID	Project class ID from the bill header.
PROJECT_CLASS_ID	Project class ID for the bill line item.
PROJECT_CLASS_HEADER_NAME	Name of the project class from the bill header.
PROJECT_CLASS_NAME	Name of the project class for the bill line item.
IS_TAXABLE_ON_PURCHASE	Flag indicating if the item is taxable on purchase.
LINE_RECONCILE_ACCRUAL_ACCNT_ID	Account ID for accrual reconciliation.
LINE_RECONCILE_ACCRUAL_ACCNT_NAME	Name of the accrual reconciliation account.
LINE_RECONCILE_ACCRUAL_ENTITY_ACCNT_ID	Entity account ID for accrual reconciliation (e.g vendor Id).
LINE_RECONCILE_ACCRUAL_ENTITY_ACCNT_NAME	Entity account name for accrual reconciliation (e.g vendor Name).
DISCOUNT	Discount applied to the bill item.
DISCOUNT_TYPE_ID	Type identifier for the discount applied. (Fixed or Percentage)
EFFECTIVE_UNIT_PRICE	Effective unit price after discounts or adjustments.
EXPENSE_ACCOUNT_ID	Account ID associated with the expense.
EXPENSE_ACCOUNT_NAME	Name of the expense account.
VENDOR_PART_NUMBER	Vendor's part number for the item.
VENDOR_NAME	Name of the vendor.
BILL_DATE	Date the bill was generated.
VENDOR_ADDR	Vendor's address.
VENDOR_CITY	Vendor's city.
VENDOR_STATE	Vendor's state or region.
VENDOR_COUNTRY	Vendor's country.
VENDOR_ZIP_POSTAL_CODE	Vendor's postal or zip code.
TITLE	Title of the product.
JOB_SCHEDULE_RUN_FLAG_STR	Indicates if the job schedule has run (Y/N).
LINE_JOB_SCHEDULE_RUN_FLAG	Flag indicating if the line item job schedule has run.
LINE_JOB_SCHEDULE_RUN_FLAG_STR	Job schedule run flag for the line item (Y/N).
STORE	Name of the store where the item is purchased.
ACCOUNT_NAME	Name of the account related to the bill.
REF_NO	Reference number for the bill.
EXCHANGE_RATE	Exchange rate used for the transaction.
BUYER_NAME	Name of the buyer associated with the purchase.
MEMO	Memo or notes for the bill.
RECONCILE_CURRENCY_ID	Currency ID for reconciliation.
RECONCILE_CURRENCY_NAME	Currency name for reconciliation.
RECONCILE_EXCHANGE_RATE	Exchange rate used for reconciliation.
LINKED_SALE_ORDER	Sale orders linked to the purchase order.
RECONCILE_ADD_TO_VENDOR_BILL_FLAG	Flag indicating if the item should be added to the vendor's bill.
NOTES	Additional notes related to the bill item line.
PERMISSION_GROUP_ID	Identifier for the vendor's permission group.
TAX_DATA	Tax-related data for the bill item line.
TAX_CATEGORY_CODE	Tax category code for the item.
ESTIMATED_DUTY_AMOUNT	Estimated duty amount for the item.
ESTIMATED_DUTY_PERCENTAGE	Estimated duty percentage for the item.
BASE_QTY_ORDERED	Base quantity of the item ordered in the base unit of measure.
BASE_QTY_SHIPPED	Base quantity of the item shipped in the base unit of measure.
BASE_QTY_REMAINING_TO_SHIP	Remaining base quantity of the item to ship in the base unit of measure.
UOM_FACTOR	Conversion factor for the unit of measure.
BASE_UOM_ID	Base unit of measure ID for the item.
BASE_UOM_NAME	Name of the base unit of measure.
DEFAULT_PURCHASE_UOM_ID	Default unit of measure ID for purchases.
LINE_RECONCILE_METHOD_NAME	Method used to reconcile the line item.
DROPSHIP_SO_LINE_ID	Sales order line ID for dropshipping.
IS_DROPSHIP_FLAG	Flag indicating if the item is a dropship item.
INVOICE_ID	Identifier for the invoice related to the item.
INVOICE_LINE_ID	Invoice line item identifier.
INVOICE_NUMBER	Invoice number identifier.
BATCH_MO_SERVICE_LINE_ID	Batch service line ID for the item.
UNIT_CBM	Cubic meter volume per unit of the item.
LINE_CBM	Line item's cubic meter volume, calculated by multiplying quantity and unit CBM.
PO_THIRD_PARTY_REF_NO	Third-party reference number for the purchase order.
ACCOUNT_3PL_ID	ID for the third-party logistics account related to the vendor.
ACCOUNT_3PL_NAME	Name of the third-party logistics account.
CHARGE_CODE	Charge code for the third-party logistics service.
CHARGE_ENTRY_ID	ID for the charge entry related to third-party logistics.
INVOICE_3PL_ID	ID for the third-party logistics invoice.
INVOICE_3PL_NUMBER	Invoice number for the third-party logistics invoice.
DOC_TYPE	Document type for the charge entry.
CHARGE_ENTRY_REF_NUMBER	Reference number for the charge entry, if applicable.
CONTRACT_NUMBER	Contract number for the third-party logistics agreement.
ALTERNATIVE_ITEM_NUMBER1	First alternative item number for the item.
ALTERNATIVE_ITEM_NUMBER2	Second alternative item number for the item.
ALTERNATIVE_ITEM_NUMBER3	Third alternative item number for the item.
ITEM_CATEGORY_NAME	Category name for the item.
ITEM_SUB_CATEGORY_NAME	Subcategory name for the item.
STORE_ID	Store ID associated with the item.
ITEM_ACCOUNT_3PL_ID	3PL account ID associated with the item.
IMAGE_PATH	Path to the item's image file.
BRAND_NAME	Brand name of the item.
IMAGE_SRC	Source URL for the item image.
HS_CODE	Harmonized System code for the item.
BILL_ID	Receipt ID or bill ID for the item.
HEADER_CREATE_DTTM	Date and time when the bill header was created.
HEADER_MODIFY_DTTM	Date and time when the bill header was last modified.
HEADER_CREATE_SOURCE	Source system for the bill header creation.
HEADER_MODIFY_SOURCE	Source system for the bill header modification.
IS_POSTED	Flag indicating if the bill item is posted.
POSTED_BILL_ID	Bill ID for the posted bill item.
POSTED_BILL_NUMBER	Bill number for the posted bill.

VW_BILL_EXPENSE_LINE_DETAIL

Column Name	Description
ID	Unique identifier for the bill expense line detail record.
LINE_SEQ	Sequence number of the line within the bill/receipt.
RECEIPT_ID	Reference to the bill header or receipt this expense line belongs to.
TXN_ID	Internal transaction ID linked to this expense line.
TXN_NUMBER	Transaction number for the related bill/expense.
ACCOUNT_ID	Account identifier associated with the expense line.
ACCOUNT_NAME	Name of the account charged for this expense.
AMOUNT	Expense amount for this line (excluding or including tax depending on configuration).
TAX_CODE_ID	Identifier of the applied tax code.
TAX_AMOUNT	Total tax amount calculated for this line.
MEMO	Memo for the line item.
TAX_AMT_NON_COLLECTABLE	Non-collectible portion of the tax amount, if any.
CREATE_DTTM	Timestamp when the record was created.
CREATE_SOURCE	Source of creation
MODIFY_DTTM	Timestamp of the last modification.
MODIFY_SOURCE	Source responsible for the last modification.
STATUS_ID	Status identifier for the expense line
TYPE	Bill/receipt type from bill header
TAX_CODE	Tax code value
TXN_DATE	Transaction date of the bill or expense.
SYMBOL_UNICODE_VAL	Currency symbol in Unicode (e.g., $, €, ¥).
PROJECT_CLASS_ID	Reference to associated project class.
PROJECT_CLASS_NAME	Name of the associated project class.
TAX_CODE_NAME	Descriptive name of the tax code.
LINKED_TXN_TYPE_ID	Type ID of a linked transaction (e.g., PO, SO, Invoice).
LINKED_TXN_TYPE_NAME	Name of the linked transaction type.
LINKED_REF_NUMBER	Reference/number of the linked transaction.
LINKED_REF_ID	ID of the linked transaction.
CURRENCY_CODE	Code of the currency used (e.g., USD, CAD).
VENDOR_ADDR	Vendor address from bill header.
VENDOR_CITY	Vendor city.
VENDOR_STATE	Vendor state/province.
VENDOR_COUNTRY	Vendor country.
VENDOR_ZIP_POSTAL_CODE	Postal/ZIP code of the vendor.
REF_NO	Vendor reference number on the bill.
EXCHANGE_RATE	Exchange rate applied for foreign-currency transactions.
VENDOR_ID	Vendor identifier.
VENDOR_NAME	Name of the vendor.
STORE_ID	Store/location ID where the expense is recorded.
STORE_CODE	Code of the store.
STORE_NAME	Name of the store.
PERMISSION_GROUP_ID	Vendor permission/security group ID.
ENTITY_ID	Entity identifier (customer/vendor).
ENTITY_TYPE_ID	Entity type identifier determining the entity category.
ENTITY_NAME	Display name of the entity.
ENTITY_TYPE_NAME	Entity type name (e.g., Customer, Vendor).
ENTITY_CURRENCY_ID	Currency ID associated with the entity.
INT_ACCNT_ID	Internal account ID linked with the entity.
RECEIPT_NUMBER	Receipt number from bill header.

VW_BILL_HEADER_INFO

Column Name	Description
RECEIPT_NUMBER	Bill/receipt number.
ID	Unique identifier for the bill header.
STORE_NAME	Name of the store the bill is associated with.
VENDOR_NAME	Vendor name.
VENDOR_ID	Identifier for the vendor.
STORE_ID	Identifier for the store.
TYPE	Bill type (Bill/Item Receipt).
ACCOUNT_NAME	Name of the accounts payable account.
TXN_DATE	Transaction date of the bill.
CURRENCY_NAME	Name of the currency used.
EXCHANGE_RATE	Exchange rate applied to convert foreign currency values.
REF_NO	Reference number.
VENDOR_ADDR	Vendor address.
VENDOR_CITY	Vendor city.
VENDOR_STATE	Vendor state or region.
VENDOR_COUNTRY	Vendor country.
VENDOR_ZIP_POSTAL_CODE	Vendor ZIP or postal code.
DISCOUNT_DATE	Discount eligibility date (if payment discount applies).
DUE_DATE	Due date of the bill.
TOTAL_AMOUNT	Total amount of the bill.
PAYMENT_TERM_NAME	Name of the payment term.
SYMBOL_UNICODE_VAL	Currency symbol in Unicode.
CREATE_DTTM	Timestamp of record creation.
CREATE_SOURCE	Source that created the bill.
MODIFY_DTTM	Timestamp of the last modification.
MODIFY_SOURCE	Source of the last modification.
STATUS_ID	Status identifier for the bill.
STATUS_NAME	Status name (e.g., Open, Partially Paid, Paid,Closed, Void).
DISCOUNTABLE_AMOUNT	Amount eligible for discount.
TXN_ID	Internal transaction ID.
TXN_NO	Transaction number.
ACCNT_PAYABLE_ID	Accounts payable account ID.
CURRENCY_ID	Identifier for the currency.
RECONCILE_FLAG	Indicates if the bill is reconciled.
MEMO	Memo associated with the bill.
TOTAL_TAX_AMOUNT	Total tax amount on the bill.
PAYMENT_TERM_ID	Identifier for the payment term.
AMOUNT_PAID	Total amount already paid.
AMOUNT_DUE	Remaining amount due.
CREDIT_USED	Vendor credit applied to the bill.
DISCOUNT_USED	Discount applied.
BILL_PAID	Flag indicating whether the bill is fully paid.
RECONCILE_ADD_TO_VENDOR_BILL_FLAG	Flag indicating if reconciliation should add to vendor bill.
RECONCILE_ACCRUAL_ACCNT_ID	Accrual account ID for reconciliation.
RECONCILE_ACCRUAL_ACCNT_NAME	Accrual account name for reconciliation.
RECONCILE_ACCRUAL_ENTITY_ACCNT_ID	Entity accrual account ID for reconciliation.
RECONCILE_ACCRUAL_ENTITY_ACCNT_NAME	Entity accrual account name for reconciliation.
TAX_SUMMARY_DATA	JSON containing detailed tax summary.
NON_BILLED_AMOUNT	Amount recorded but not yet billed.
REPORTING_DATA	Reporting metadata for BI/reporting.
OPENING_BALANCE_FLAG	Flag indicating if this is an opening balance bill.
SYS_LOCK_FLAG	Flag indicating if the bill is system-locked.
UNPOST_TRANS_FLAG	Flag indicating unposted transaction status.
VENDOR_BILL_NUMBER	Vendor-provided bill number.
TAX_ADJ_ARR_JSON	JSON structure for tax adjustments.
BILL_DATE	Date of the bill (may differ from transaction date).
PROJECT_CLASS_ID	Identifier for the Project class.
RECONCILE_CURRENCY_ID	Reconciliation currency ID.
RECONCILE_EXCHANGE_RATE	Exchange rate applied for reconciliation.
PROJECT_CLASS_NAME	Project class name.
STORE_CODE	Store code.
CODE	Currency code.
PO_NUMBER	Comma-separated list of linked purchase order numbers.
BILL_FROM_FIRST_NAME	First name of the billed-from contact.
BILL_FROM_LAST_NAME	Last name of the billed-from contact.
BILL_FROM_COMPANY_NAME	Company name of the bill origin.
BILL_FROM_ADDR2	Additional address line.
BILL_FROM_PHONE_NUMBER	Phone number of billed-from contact.
BILL_FROM_EMAIL	Email of billed-from contact.
BILL_FROM_ADDR_NAME	Billing address name.
BUYER_ID	Buyer ID linked to the bill.
BUYER_NAME	Name of the buyer.
ON_HOLD_MESSAGE	Message associated with on-hold status.
ON_HOLD_FLAG	Numeric flag for hold state (0/1).
ON_HOLD_FLAG_STR	'Y' or 'N' representation of hold status.
VENDOR_CREDIT_APPLIED	Vendor credit applied to bill.
PREPAYMENT_APPLIED	Prepayment amount applied.
LINKED_RECONCILED_RECEIPT_NUMBER	Receipt number of the reconciled linked bill.
PERMISSION_GROUP_ID	Vendor permission group ID.
TOTAL_ESTIMATED_DUTY_AMOUNT	Estimated duty amount for imports.
LINKED_INVOICE_NUMBER_STATUS_NAME	Comma-separated list of linked invoice numbers with status.
BATCH_NUMBER	Manufacturing batch number (if applicable).
BATCH_ID	Batch ID.
TOTAL_CBM	Total CBM (cubic meter) of goods.
APPROVAL_STATUS_NAME	Name of approval status.
APPROVAL_STATUS_CHANGE_DTTM	Timestamp of approval status change.
APPROVAL_STATUS_CHANGE_SOURCE	Source of approval status change.
DEFAULT_PAYMENT_METHOD_NAME	Default payment method name for vendor.
DEFAULT_PAYMENT_METHOD_ID	Payment method ID from vendor.
APPROVAL_STATUS_ID	Approval status ID.
THIRD_PARTY_REF_NO	Third-party reference number.
THIRD_PARTY_SOURCE	Third-party source system.
TOTAL_QTY	Total quantity involved in the bill.
CUSTOM_FIELD_VALUE1–CUSTOM_FIELD_VALUE50	Custom field values associated with this bill.
VENDOR_TYPE	Vendor type name.
SUSPENSE_RECEIPT_ID	Suspense bill reference ID.
SUSPENSE_RECEIPT_NUMBER	Suspense bill receipt number.
IS_POSTING_BILL	Indicates whether this is a posting bill.

VW_BOM_HEADER_INFO

Column Name	Description
ID	Unique identifier of the BOM header
BOM_ITEM_ID	Item ID for the BOM parent item
BOM_ITEM_NUMBER	Item number for the BOM parent item
TYPE_ID	BOM type identifier
REVISION	Numeric or textual revision value
MEMO	Memo associated with the BOM.
BOM_NAME	Name of the Bill of Materials
AUTO_TRIGGER_TYPE	Auto-trigger configuration type
ESTIMATED_TIME_MINUTES	Estimated production time in minutes
VALID_FROM_DATE	BOM valid-from effective date
VALID_TO_DATE	BOM valid-to expiration date
CREATE_DTTM	Creation timestamp
CREATE_SOURCE	Source/system that created the record
MODIFY_DTTM	Last modified timestamp
MODIFY_SOURCE	Source/system that modified last
ACTIVE_FLAG	1/0 indicating if BOM is active
BOM_TYPE_NAME	Name of the BOM type
ACTIVE_FLAG_STR	'Y' or 'N' representation of ACTIVE_FLAG
DESCRIPTION	Description of BOM parent item
MASTER_BOM_ID	Reference to master BOM version
REVISION_NAME	revision label
IS_REVISION	Indicates if the BOM is a revision (0/1)
IS_REVISION_STR	'Y' or 'N' representation of IS_REVISION
HAS_REVISION	Indicates if BOM has revisions (0/1)
UOM_NAME	Selling UOM name
UOM_CODE	Selling UOM code
BOM_INSTRUCTION	BOM instructions text
PPE_NOTES	PPE-related notes (if applicable)
LATEST_REVISION_FLAG	1 if this is the latest revision
BASE_UOM_NAME	Base UOM name
BASE_UOM_CODE	Base UOM code
JOB_SCHEDULE_RUN_FLAG	Indicates if job schedule automation is enabled
CUSTOM_FIELD_VALUE1–50	Custom field values associated with this BOM header
IS_BOM_ITEM_ACTIVE	Active flag of the BOM item (from item master)

VW_BOM_ITEM_LINE_INFO

Column Name	Description
ID	Unique identifier of the BOM item line
BOM_ID	Reference to the parent BOM header
ITEM_ID	Item ID of the component
ITEM_NUMBER	Item number of the component
DESCRIPTION	Description of the component item
ITEM_TYPE_ID	Item type identifier
QTY	Quantity required for the component
UOM_ID	UOM ID for the component
IS_ONE_TIME_ITEM	Indicates if the item is used only once (0/1)
SEQ_NUMBER	Sequence number of the line
INSTRUC_NOTES	Instruction notes related to the line
INSTRUC_NOTES_SEQ_NUMBER	Sequence number for instruction notes
CREATE_DTTM	Line creation timestamp
CREATE_SOURCE	Source/system that created the line
MODIFY_DTTM	Last modified timestamp
MODIFY_SOURCE	Source/system that modified the line
UOM_NAME	Name of the component UOM (unit of measure)
ITEM_UNIT_COST	Unit cost of the component item
DECIMAL_FLAG	Decimal allowance flag for UOM
ITEM_TYPE_NAME	Item type descriptive name
BOM_ITEM_NUMBER	BOM parent item number
BOM_NAME	BOM parent name
IS_ITEM_BOM	Indicates if the component is itself a BOM (0/1)
ITEM_BOM_ID	ID of the BOM associated with the component item
IS_REVISION	Indicates if BOM is a revision (0/1)
REVISION_NAME	Name/label of the BOM revision
MASTER_BOM_ID	Link to master BOM
REVISION	Revision code
VALID_FROM_DATE	BOM valid-from effective date
VALID_TO_DATE	BOM valid-to expiration date
BOM_UOM_CODE	UOM code of BOM parent item
UOM_CODE	UOM code of component item
BOM_UOM_NAME	UOM name of BOM parent item
ALTERNATIVE_ITEM_NUMBER1	Alternative item number 1
ALTERNATIVE_ITEM_NUMBER2	Alternative item number 2
ALTERNATIVE_ITEM_NUMBER3	Alternative item number 3
ITEM_BARCODE	Barcode of the component item
DEFAULT_VENDOR_ID	Default vendor ID from item master
VENDOR_NAME	Vendor name
BOM_BASE_UOM_CODE	Base UOM code of BOM parent item
BOM_BASE_UOM_NAME	Base UOM name of BOM parent item
PREVENT_SUB_MO	Prevent creation of sub manufacturing orders (0/1)
LATEST_REVISION_FLAG	Flag indicating latest revision (0/1)
ACTIVE_FLAG	Active flag of BOM header
MEMO	BOM header memo
PPE_NOTES	PPE-related notes
BOM_INSTRUCTION	BOM instruction text
CREATE_DTTM_HEADER	BOM header creation timestamp
CREATE_SOURCE_HEADER	BOM header creation source
MODIFY_DTTM_HEADER	BOM header modification timestamp
MODIFY_SOURCE_HEADER	BOM header modification source
LINE_JOB_SCHEDULE_RUN_FLAG	Auto job scheduling flag at line level
BOM_LATEST_REVISION_ID	Latest revision BOM ID for component item
CUSTOM_FIELD_VALUE1–50	Header-level custom field values
DETAIL_CUSTOM_FIELD_VALUE1–50	Line-level custom field values
SUB_BOM_REVISION_ID	Sub-BOM revision ID if present
SUB_BOM_REVISION_NAME	Sub-BOM name with revision text
TAGS	Item tags list
DEFAULT_LOCATION_NAME	Default location name from location master

VW_CREDIT_MEMO_DETAIL_INFO

Column Name	Description
ID	Unique ID of the credit memo line.
CREDIT_MEMO_ID	Header ID of the credit memo.
TXN_ID	Internal transaction ID associated with credit memo.
TXN_NUMBER	Transaction number for the credit memo line.
LINE_NUMBER	Line number of the credit memo.
ITEM_ID	Linked item’s internal ID.
ITEM_TYPE_ID	Item type ID (Inventory, Service, etc.).
ITEM_TYPE_NAME	Name of the item type.
ITEM_NUMBER	Item’s SKU/Number.
DESCRIPTION	Description of the credit memo line.
RATE	Rate or unit price of the item.
UOM_NAME	Unit of measure name.
UOM_ID	Unit of measure ID.
QTY	Quantity entered on return/credit line.
AMOUNT	Line amount (after qty × rate ± adjustments).
TAX_CODE_ID	Tax code ID applied to the line.
TAX_CODE_NAME	Tax code name.
TAX_AMOUNT	Calculated tax amount for the line.
STATUS_ID	Status of the credit memo line.
CREATE_DTTM	Created timestamp.
CREATE_SOURCE	Created source.
MODIFY_DTTM	Last modified timestamp.
MODIFY_SOURCE	Credit memo header last modification source.
INVOICE_LINE_ID	Original invoice line linked to this credit.
DISCOUNT	Discount value applied on the line.
DISCOUNT_TYPE_ID	Discount type (percentage/fixed).
EFFECTIVE_UNIT_PRICE	Net price after discount calculation.
DECIMAL_FLAG	Whether UOM supports decimals.
RETURN_CODE_ID	Return code selected for the line.
RETURN_CODE_NAME	Return code name.
RETURN_NOTES	Notes added for the return.
PROJECT_CLASS_ID	Linked project class ID.
PROJECT_CLASS_NAME	Project class name.
THIRD_PARTY_REF_NO	Reference number from 3rd-party system.
THIRD_PARTY_SOURCE	Source name of the 3rd-party system.
TAX_DATA	JSON-based tax computation data.
IS_TAXABLE_ON_SALE	Whether the item is taxable on sales.
CREDIT_MEMO_NUMBER	Credit memo document number.
TXN_DATE	Credit memo date.
REF_NO	Reference number entered by user.
TYPE_ID	Type of credit memo (e.g., item return, discount).
CUSTOMER_NAME	Customer name linked to the credit memo.
SALES_REP_ID	Sales representative ID.
TRACKING_BY_SERIAL_NUMBER_FLAG	Indicates if item is serial-tracked.
PERMISSION_GROUP_ID	Customer permission group.
TAX_CATEGORY_CODE	Item tax category code.
RMA_ID	RMA header ID from return process.
RMA_LINE_ID	RMA line ID.
RMA_NUMBER	RMA number.
ASN_ID	ASN header ID linked to the return.
ASN_LINE_ID	ASN line detail ID.
TOTAL_QTY	Total quantity on RMA.
QTY_ORDERED	RMA ordered quantity.
QTY_RECEIVED	RMA received quantity.
QTY_REMAINING	Remaining quantity on RMA.
ASN_NUMBER	ASN number.
RETURN_STORE_ID	Store where return was processed.
RETURN_STORE_NAME	Name of return store.
SALE_STORE_ID	Original sale store ID.
SALE_STORE_NAME	Name of sale store.
UOM_FACTOR	Conversion factor for UOM.
BASE_QTY_ORDERED	Ordered quantity in base UOM.
BASE_QTY_SHIPPED	Shipped quantity in base UOM.
BASE_QTY_REMAINING_TO_SHIP	Remaining qty to ship in base UOM.
BASE_UOM_NAME	Name of base UOM.
BASE_UOM_ID	Base UOM ID.
DEFAULT_SELL_UOM_ID	Default selling UOM.
STATUS_NAME	Status of line.
VAS_ITEM_ID	VAS item ID (value-added service).
VAS_ITEM_NAME	VAS item name.
VAS_ITEM_COST	Cost of VAS item.
VAS_ITEM_COST_TOTAL	Total VAS cost.
VAS_TAXABLE_FLAG	Whether VAS is taxable.
VAS_DISCOUNTABLE_FLAG	Whether VAS is discountable.
FORCE_SALES_TAX_CODE	Enforced sales tax code for item.
TAX_STATE_MAPPING_PROFILE_ID	State-based tax profile ID.
SALES_TAX_CODE_ID	Item sales tax code.
SALE_TAX_CODE_NAME	Sales tax code name.
TXN_TYPE_ID	Custom field transaction type.
DETAIL_CUSTOM_FIELD_VALUE1–50	50 custom field values stored at line level.
CUSTOM_FIELD_VALUE1–50	50 custom field values stored at header level.
ACCOUNT_3PL_TYPE_ID	Customer’s 3PL account type.
ACCOUNT_3PL_ID	Customer’s 3PL account ID.
ACCOUNT_3PL_NAME	3PL account name.
CHARGE_CODE	3PL charge code.
CHARGE_ENTRY_ID	3PL charge entry header ID.
INVOICE_3PL_ID	3PL billing invoice ID.
INVOICE_3PL_NUMBER	3PL billing invoice number.
DOC_TYPE	Document type of 3PL charge entry.
CHARGE_ENTRY_REF_NUMBER	Reference number if part of 3PL charge.
CONTRACT_NUMBER	3PL contract reference.
ALTERNATIVE_ITEM_NUMBER1	Alternative item number 1.
ALTERNATIVE_ITEM_NUMBER2	Alternative item number 2.
ALTERNATIVE_ITEM_NUMBER3	Alternative item number 3.
ITEM_CATEGORY_NAME	Item category name.
ITEM_SUB_CATEGORY_NAME	Item sub-category name.
ITEM_ACCOUNT_3PL_ID	Item-level 3PL account ID.
ITEM_INCOME_RETURN_ACCNT_ID	GL account for income/returns.
ITEM_INCOME_RETURN_ACCOUNT_NAME	GL account full name.
RECEIVED_QUALITY	Received item quality on ASN.
EXPECTED_QUALITY	Expected quality from RMA.

VW_CREDIT_MEMO_HEADER_INFO

Column Name	Description
ID	Unique identifier of the credit memo.
CREDIT_MEMO_NUMBER	System-generated credit memo number.
TXN_ID	Internal transaction identifier linked to the credit memo.
TXN_NUMBER	Transaction number associated with the credit memo.
STORE_ID	Store where the credit memo was created.
ACCNT_RECEIVABLE_ID	Accounts receivable account associated with the credit memo.
CUSTOMER_ID	Customer linked to the credit memo.
TXN_DATE	Date when the credit memo was issued.
CURRENCY_ID	Currency ID used for the credit memo.
EXCHANGE_RATE	Exchange rate applicable at the time of credit memo creation.
REF_NO	Reference number provided for the credit memo.
AMOUNT	Total amount of the credit memo.
STATUS_ID	Status indicator for the credit memo.
MEMO	Memo text associated with the Credit Memo.
CREATE_DTTM	Date and time when the record was created.
CREATE_SOURCE	Source of creation.
MODIFY_DTTM	Last modification timestamp.
MODIFY_SOURCE	Source of last modification.
ACCOUNT_RECEIVABLE_NAME	Name of the AR account.
CUSTOMER_NAME	Customer’s display name.
INT_ACCNT_ID	Customer’s internal account ID.
CUSTOMER_FULL_NAME	Full name of the customer.
CURRENCY_NAME	Name of the currency used.
CURRENCY_CODE	Short currency code (e.g., USD, CAD).
CURRENCY_SYMBOL	Currency symbol value.
STORE_NAME	Name of the store associated with the credit memo.
STATUS_NAME	Status for the credit memo.
CREDIT_ID	Identifier linking to credit transactions.
AMOUNT_APPLIED	Portion of the credit memo already applied.
AMOUNT_REMAINING	Remaining balance of the credit memo.
AMOUNT_REFUNDED	Amount refunded from the credit memo.
TOTAL_AMOUNT	Total computed amount inclusive of adjustments.
INVOICE_NUMBER	Original invoice number tied to the credit memo.
INVOICE_ID	ID of the invoice related to the credit memo.
TYPE_ID	Credit memo type identifier.
TYPE_NAME	Name of the credit memo type.
INVOICE_DISCOUNT_USED	Discount amount from invoice used in the credit memo.
INVOICE_DISCOUNT_EXP_ACCNT_ID	Expense account used for invoice discount adjustment.
INVOICE_SHIPPING_AMOUNT_USED	Shipping amount used from invoice.
INVOICE_SHIPPING_EXP_ACCNT_ID	Shipping expense account ID.
INVOICE_SHIPPING_TERM_ID	Shipping terms applied on invoice.
INVOICE_SHIP_METHOD_ID	Shipping method used on invoice.
INVOICE_SHIP_TAX_CODE_ID	Tax code applied on shipping.
TAX_SUMMARY_DATA	Tax summary in JSON or structured format.
REPORTING_DATA	Reporting-related structured data.
OPENING_BALANCE_FLAG	Flag indicating if this is an opening balance credit.
INVOICE_SALE_STORE_ID	Store where the original invoice sale was recorded.
INVOICE_SALE_STORE_NAME	Display name of the invoice sale store.
SYS_LOCK_FLAG	Indicates if the transaction is system-locked.
UNPOST_TRANS_FLAG	Indicates if unposted transactions exist.
CUSTOMER_CURRENCY_ID	Customer’s default currency.
CUSTOMER_MAIN_PHONE	Customer’s main phone number.
CUSTOMER_EMAIL_MAIN	Customer’s primary email address.
CUSTOMER_DEFAULT_ACCNT_RECEIVABLE_ID	Customer’s default AR account ID.
STORE_CODE	Store code associated with the credit memo.
RETURN_TYPE_ID	Return type identifier for credit memo.
ASN_CREATED	Flag indicating if an ASN was created.
ASN_NUMBER	ASN number linked to the credit memo.
ASN_ID	ASN identifier.
PROJECT_CLASS_ID	Project class assigned to the credit memo.
PROJECT_CLASS_NAME	Name of the project class.
THIRD_PARTY_REF_NO	Third-party reference number.
THIRD_PARTY_SOURCE	Source identifier for a third-party system.
THIRD_PARTY_DISPLAY_NAME	Display name of the third-party source.
THIRD_PARTY_ICON_URL	Icon URL representing the third-party system.
INVOICE_SHIPPING_TERMS_NAME	Shipping terms from invoice.
INVOICE_SHIP_METHOD_NAME	Shipping method name from invoice.
INVOICE_SHIP_TAX_CODE_NAME	Shipping tax code name.
SHIPPING_TAX_DATA	Tax data for shipping.
TOTAL_QTY	Total item quantity on the credit memo.
SUB_TOTAL_EXCL_DISCOUNT	Subtotal before applying discounts.
DISCOUNT_AMOUNT	Discount amount applied.
SUB_TOTAL	Final subtotal after discounts.
FULL_PAYMENT_DATE	Date when invoice was fully paid.
TAGS	Associated tags stored on invoice.
BILL_TO_FIRST_NAME	Bill-to first name.
BILL_TO_LAST_NAME	Bill-to last name.
BILL_TO_COMPANY_NAME	Bill-to company name.
BILL_TO_ADDR	Bill-to address line 1.
BILL_TO_ADDR2	Bill-to address line 2.
BILL_TO_CITY	Bill-to city.
BILL_TO_STATE	Bill-to state.
BILL_TO_COUNTRY	Bill-to country.
BILL_TO_ZIP_POSTAL_CODE	Bill-to zip/postal code.
BILL_TO_PHONE_NUMBER	Bill-to contact phone.
BILL_TO_EMAIL	Bill-to email.
SHIP_TO_FIRST_NAME	Ship-to first name.
SHIP_TO_LAST_NAME	Ship-to last name.
SHIP_TO_COMPANY_NAME	Ship-to company name.
SHIP_TO_ADDR	Ship-to address line 1.
SHIP_TO_ADDR2	Ship-to address line 2.
SHIP_TO_CITY	Ship-to city.
SHIP_TO_STATE	Ship-to state.
SHIP_TO_COUNTRY	Ship-to country.
SHIP_TO_ZIP_POSTAL_CODE	Ship-to zip/postal code.
SHIP_TO_PHONE_NUMBER	Ship-to phone.
SHIP_TO_EMAIL	Ship-to email.
TAX_ADDRESS_JSON	Tax address data in JSON format.
CUSTOMER_PO	Customer purchase order from invoice.
SALES_REP_ID	Sales representative ID resolved from credit memo or invoice.
RMA_ID	RMA identifier if linked.
RMA_NUMBER	RMA number.
INVOICE_BILL_TO_*	Various bill-to fields from the invoice (first name, last name, company, etc.).
INVOICE_SHIP_TO_*	Various ship-to fields from the invoice.
REF_NO_2	Additional reference number.
SHIP_FROM_*	Ship-from address fields.
TAX_SERVICE_HASH_CODE	Hash value used by tax service.
TAX_SERVICE_REF_NAME	Tax service reference name.
ENTITY_USE_CODE	Customer’s exemption/use code.
NO_TAX_SERVICE_REQUEST_FLAG	Indicates if tax service should be bypassed.
PERMISSION_GROUP_ID	Permission group assigned to customer.
ACCNT_NUMBER	Customer account number.
SALES_REP_NAME	Name of the sales representative.
LINKED_SO_NUMBERS	Sales orders linked to the credit memo.
SALES_ORDER_NUMBERS	Sales order numbers listed on the credit memo.
CONTACT_FIRST_NAME	Customer contact first name.
CONTACT_LAST_NAME	Customer contact last name.
THIRD_PARTY_NOTES	Notes from third-party integration.
SHIP_TO_NAME	Combined ship-to name for credit memo.
RETURN_TYPE_NAME	Name of the return type.
AMOUNT_TRANSFERRED	Amount transferred to another document.
TXN_TYPE_ID	Transaction type identifier for custom fields.
CUSTOM_FIELD_VALUE1–50	Custom field values for the credit memo.
CUSTOMER_ACCOUNT_NUMBER	Customer’s account number.
CHARGE_ENTRY_ID	Charge entry ID for 3PL billing.
ACCOUNT_3PL_TYPE_ID	Customer’s 3PL account type.
ACCOUNT_3PL_ID	Customer’s 3PL account ID.
ACCOUNT_3PL_NAME	Name of the customer's 3PL account.
ACCOUNT_3PL_CODE	Code of the customer's 3PL account.
SERVICE_3PL_CHARGES	Total service-related 3PL charges.
SERVICE_CHARGE_ENTRY_TYPE	Charge entry type for service charges.
MISC_3PL_CHARGES	Miscellaneous 3PL charges.
MISC_CHARGE_ENTRY_TYPE	Charge entry type for miscellaneous charges.
DOC_TYPE	Document type for 3PL entry.
CHARGE_ENTRY_REF_NUMBER	Charge entry reference number (credit memo number).
INVOICE_3PL_NUMBER	3PL invoice numbers linked to the entry.
INVOICE_3PL_ID	3PL invoice ID.
CONTRACT_NUMBER	3PL contract number.
IS_PROCESSED	Flag showing if credit memo is processed.
ORDER_TYPE_NAME	Name of the order subtype (from RMA).

VW_CUSTOMER_DEPOSIT_INFO

Column Name	Description
ID	Unique identifier for the customer deposit record.
STORE_ID	Store identifier where the deposit was made.
STORE_NAME	Name of the store.
DEPOSIT_NUMBER	Customer deposit number/reference.
SO_ID	Sales order ID associated with the deposit.
SO_NUMBER	Sales order number.
TXN_ID	Transaction ID linked to the deposit.
TXN_NUMBER	Transaction number.
TXN_DATE	Date of the transaction.
AMOUNT	Total amount of the deposit.
DEPOSIT_ACCOUNT_ID	Account ID where the deposit is recorded.
LIABILITY_ACCOUNT_ID	Liability account ID for the deposit.
CUSTOMER_ID	Customer identifier.
CUSTOMER_NAME	Full name of the customer.
STATUS_ID	Status ID of the deposit.
CREATE_DTTM	Date and time the deposit record was created.
CREATE_SOURCE	ID of the user or system that created the deposit.
MODIFY_DTTM	Date and time the deposit record was last modified.
MODIFY_SOURCE	ID of the user or system that modified the deposit.
CURRENCY_ID	Currency identifier for the deposit.
EXCHANGE_RATE	Exchange rate applied for currency conversion.
MEMO	Notes or memo for the deposit.
REF_NO	Reference number for tracking.
DEPOSIT_ACCNT_NAME	Full name of the deposit account.
LIABILITY_ACCNT_NAME	Full name of the liability account.
CURRENCY_CODE	Currency code (e.g., USD, EUR).
CURRENCY_SYMBOL	Currency symbol (Unicode).
AMOUNT_APPLIED	Amount of the deposit already applied to invoices.
AMOUNT_REMAINING	Remaining amount after applied and refunded amounts.
STATUS_NAME	Name/description of the deposit status.
AMOUNT_REFUNDED	Total amount refunded for this deposit.
CC_REFUND_AMOUNT	Amount refunded via credit card.
RECONCILED_FLAG	Boolean flag indicating if deposit is reconciled.
DEPOSITED_FLAG	Boolean flag indicating if deposit is posted/deposited.
PAYMENT_METHOD_ID	Payment method identifier.
PAYMENT_METHOD_NAME	Payment method name.
PAYMENT_METHOD_TYPE_ID	Payment method type identifier.
PAYMENT_METHOD_TYPE_NAME	Payment method type name.
PROCESS_CREDIT_CARD_FLAG	Boolean flag if credit card processing was done.
MERCHANT_TYPE_ID	Merchant type identifier.
CHARGE_TYPE_ID	Charge type identifier.
CHARGE_ID	Charge identifier.
MERCHANT_RET_REF_NUMBER	Merchant reference/return number.
CARD_LAST_4_DIGIT	Last 4 digits of the card used.
MERCHANT_RESPONSE_DATA	Response data from merchant/processor.
REF_NO_2	Secondary reference number for tracking.
PAYMENT_RECEIPT	Payment receipt identifier or number.
PAYMENT_SERVICE_ACCOUNT_ID	Payment service account identifier.
DD_REFUND_AMOUNT	Amount refunded via direct debit.

VW_CUSTOMER_INFO

Column Name	Description
ID	ID of the customer record.
CUSTOMER_NUMBER	Unique customer number assigned by the ERP system.
NAME	Customer display name.
FULL_NAME	Full legal name of the customer.
ACCNT_NUMBER	Customer account number.
ALERT_NOTE	Internal alert or warning notes for the customer.
INT_ACCNT_ID	Internal account ID linked to the customer.
CREDIT_LIMIT	Approved credit limit for the customer.
TYPE	Customer type code.
CUSTOMER_SINCE_DATE	Date when the customer was first created in the ERP.
COMPANY_NAME	Company name associated with the customer.
JOB_TITLE	Contact’s job title.
CONTACT_FIRST_NAME	Primary contact’s first name.
CONTACT_LAST_NAME	Primary contact’s last name.
DEFAULT_BILLING_EMAIL	Email address used by default for billing communication.
DEFAULT_SHIPMENT_UPDATES_EMAIL	Email address used for shipment notifications.
MAIN_PHONE	Main phone number.
WORK_PHONE	Work phone number.
MOBILE_PHONE	Mobile phone number.
FAX	Fax number.
EMAIL_MAIN	Primary email address.
EMAIL_CC	CC email address for notifications.
OTHER_CONACT_INFO	Additional contact information.
CURRENCY_CODE	Preferred currency code for transactions.
CURRENCY_SYMBOL	Display symbol of the customer’s currency.
SALES_REP	Name of the assigned sales representative.
BILL_TO_ADDR_NAME	Billing address name.
BILL_TO_ADDR	Billing street address.
BILL_TO_CITY	Billing city.
BILL_TO_STATE	Billing state or province.
BILL_TO_POSTAL_CODE	Billing postal or ZIP code.
BILL_TO_COUNTRY	Billing country.
BILL_TO_ADDR_2	Billing address line 2.
BILL_TO_COMPANY_NAME	Billing company name.
BILL_TO_FIRST_NAME	Billing contact first name.
BILL_TO_LAST_NAME	Billing contact last name.
BILL_TO_EMAIL	Billing email address.
BILL_TO_PHONE_NUMBER	Billing phone number.
SHIP_TO_ADDR_NAME	Shipping address name.
SHIP_TO_ADDR	Shipping street address.
SHIP_TO_ADDR_CITY	Shipping city.
SHIP_TO_ADDR_STATE	Shipping state or province.
SHIP_TO_POSTAL_ZIP_CODE	Shipping postal or ZIP code.
SHIP_TO_ADDR_COUNTRY	Shipping country.
SHIP_TO_ADDR_2	Shipping address line 2.
SHIP_TO_COMPANY_NAME	Shipping company name.
SHIP_TO_FIRST_NAME	Shipping contact first name.
SHIP_TO_LAST_NAME	Shipping contact last name.
SHIP_TO_EMAIL	Shipping email address.
SHIP_TO_PHONE_NUMBER	Shipping phone number.
DEFAULT_FOB_ID	Default FOB (Freight on Board) ID.
DEFAULT_BILLING_METHOD_TYPE_ID	Default billing method type ID.
INDENTED_NAME	Customer name..(Parent name:child name)
TAX_NBR_1	Primary tax number for tax compliance.
TAX_NBR_2	Secondary tax number.
CARRIER_NAME	Default carrier name for shipments.
PAYMENT_METHOD_NAME	Default payment method name.
SHIP_SERVICE_NAME	Default shipping service name.
PAYMENT_TERM_NAME	Payment terms assigned to the customer.
DELIVERY_METHOD_NAME	Default delivery method.
SHIPPING_TERM_NAME	Shipping terms applicable to the customer.
PARENT_NAME	Parent customer or parent company name.
CUSTOMER_TYPE_NAME	Customer type(Individual or Company).
ACCNT_RECEIVABLE_NAME	Accounts receivable account name.
ACCNT_LIABILITY_NAME	Liability account name.
ACCNT_DEPOSIT_NAME	Deposit account name.
BILLING_METHOD_NAME	Billing method description.
CUSTOMER_GROUP_NAME	Customer group name.
BUSINESS_NO	Business registration number.
SALES_REP_ID	ID of the assigned sales representative.
WEB_URL	Customer website URL.
TAX_CODE	Tax code used for transactions.
FOB_NAME	Default FOB name.
ACTIVE_FLAG	Flag indicating if the customer is active.
ACTIVE_FLAG_STR	‘Y’ or ‘N’ value for active status.
IS_CUSTOMER_JOB_FLAG	Flag indicating if the record is a customer job.
PORTAL_ACCOUNT_NUMBER	Customer’s portal account number.
PORTAL_ACTIVE_FLAG	Flag indicating if the portal account is active.
PORTAL_ACTIVE_FLAG_STR	‘Y’ or ‘N’ value for portal activity.
ACCNT_LOCK_FLAG	Flag indicating if the account is locked.
CURRENCY_ID	Currency ID assigned to the customer.
LINKED_PAYMENT_GATEWAY_TYPE_ID	Linked payment gateway type ID.
LINKED_PAYMENT_GATEWAY_ID	Linked payment gateway ID.
IS_TAXABLE_FLAG	Flag indicating if the customer is taxable.
IS_TAXABLE_FLAG_STR	‘Y’ or ‘N’ value for the taxable flag.
CREATE_DTTM	Date and time the record was created.
CREATE_SOURCE	ID of the user or system that created the record.
MODIFY_DTTM	Date and time the record was last modified.
MODIFY_SOURCE	ID of the user or system that last modified the record.
SHIPPING_ACCOUNT_NUMBER	Shipping account number stored for customer.
TAGS	Tags or labels associated with the customer.
IS_PORTAL_USER	Flag indicating if a customer has a portal login.
SHOW_INVOICE_CREDIT_DEPOSIT	Flag to show invoices/credits/deposits in the portal.
IS_PORTAL_USER_STR	‘Y’ or ‘N’ for portal user flag.
FORCE_CUSTOMER_TAX_CODE	Flag to prioritise customer tax code on orders.
CSR_ID	Customer service representative ID.
CSR_REP	Name of assigned CSR.
SAVED_CARDS	List or count of saved payment cards.
IS_CARD_ON_FILE	Flag indicating if a customer has a card on file.
CARD_EXP_STATUS	Status of stored card expiration.
CARD_EXP	Card expiration date.
CARD_BRAND	Card brand (Visa, MC, etc.).
CARD_MASK	Masked card number.
DEPOSIT_REQUIRED_AMOUNT_TYPE	Required deposit type id
DEPOSIT_REQUIRED_AMOUNT	Deposit amount required.
DEPOSIT_REQUIRED_AMOUNT_TYPE_NAME	Required deposit type name(Percentage or Amount)
LAST_ORDER_DATE	Date of most recent order from customer.
SHOW_PAY_BALANCE	Flag controlling balance visibility.
PROJECT_CLASS_NAME	Project class name.
DEFAULT_ORDER_TYPE_NAME	Default order type for the customer.
DEFAULT_PROJECT_CLASS_ID	Default project class ID.
LAST_ACTIVITY_DTTM	Date/time of last activity by or for the customer.
CUSTOM_FIELD_VALUE1–50	Custom user-defined fields for extended attributes. (Note :- user can access all the custom fields from 1 to 50)
DEFAULT_CUSTOMER_MESSAGE	Default message shown on customer documents.
CUSTOMER_LAST_COMMENT	Last comment recorded.
CUSTOMER_LAST_COMMENT_CREATE_DTTM	Date and time of last comment creation.
AVG_DAYS_TO_PAY	Average number of days the customer takes to pay.
ON_HOLD	Flag indicating if a customer is on hold.
ON_HOLD_MESSAGE	Reason for the hold.
ON_HOLD_STR	‘Y’ or ‘N’ value for hold status.
CARD_STATUS	Status of stored card(s).
IS_RESTRICTED_FLAG	Flag indicating if the customer is restricted.
DISABLE_SELL_PACKAGE_ALLOCATION_STR	‘Y’ or ‘N’ for package allocation restriction.
IS_RESTRICTED_FLAG_STR	‘Y’ or ‘N’ for restricted flag.
BRANDS	Associated brands for the customer.
WAVE_TEMPLATE_NAME	Default wave template name.
PERMISSION_GROUP_ID	Permission group ID assigned to the customer.
PERMISSION_GROUP_NAME	Permission group name.
ENTITY_USE_CODE	Tax entity use code.
CUSTOMER_TYPE_ID	Customer type ID. (company or individual)
RESTRICT_DAILY_INVOICE_EMAIL_FLAG	Restrict daily invoice emails.
RESTRICT_DUE_INVOICE_EMAIL_FLAG	Restrict due invoice emails.
RESTRICT_OVERDUE_INVOICE_EMAIL_FLAG	Restrict overdue invoice emails.
RESTRICT_RELEASE_SO_EMAIL_FLAG	Restrict sales order release emails.
RESTRICT_SHIP_CONFIRMATION_EMAIL_FLAG	Restrict ship confirmation emails.
DEFAULT_DEPOSIT_ACCOUNT_ID	Default deposit account ID.
DEFAULT_PAYMENT_METHOD_ID	Default payment method ID.
IS_BC_PST_TAX_EXEMPT	PST exempt flag for British Columbia.
IS_MB_PST_TAX_EXEMPT	PST exempt flag for Manitoba.
IS_QB_PST_TAX_EXEMPT	PST exempt flag for Quebec.
IS_SK_PST_TAX_EXEMPT	PST exempt flag for Saskatchewan.
THIRD_PARTY_DISPLAY_NAME	External system display name.
THIRD_PARTY_ICON_URL	External system icon URL.
THIRD_PARTY_REF_NO	External system reference number.
THIRD_PARTY_SOURCE	Source system name.
ACH_SETUP_STATUS_NAME	ACH setup status.
ACH_SETUP_STATUS_ID	ACH setup status ID.
AUTO_PROCESS_PAYMENT	Flag indicating auto-payment processing.
AUTO_PROCESS_PAYMENT_METHOD_NAME	Name of auto-processing payment method.
SET_PROCESS_CARD_AS_DEFAULT	Flag to set processed card as default.
ACCOUNT_3PL_NAME	3PL account name.
ACCOUNT_3PL_CODE	3PL account code.
ACCOUNT_3PL_DESC	Description of 3PL account.
CARTON_BREAK_RULE_NAME	Carton break rule applied to customer.
SHIPPING_NOTES	Shipping notes or instructions.
ACCOUNT_3PL_TYPE_ID	3PL account type ID.
ACCOUNT_3PL_TYPE_NAME	3PL account type name.
IS_VAS_REQUIRED	Flag indicating value-added services required.
VAS_INSTRUCTION	Instructions for value-added services.
ACCOUNT_3PL_ID	3PL account ID.
IS_PACK_AND_HOLD_REQUIRED	Flag for pack-and-hold requirement.
SALES_REP_EMAIL	Email of the sales representative.
INCOME_ACCOUNT_NAME	Income account name.
INCOME_RETURN_ACCOUNT_NAME	Return income account name.
ENABLE_CUSTOMER_STATEMENT_EMAIL_FLAG	Flag to enable statement emails.
ADDR_SHIPPING_ACCOUNT_NUMBER	Shipping-account number for addresses.
IMAGE_URLS	URLs of customer images/files.
STATEMENT_EMAIL	Email used for statements.
REMINDER_EMAIL	Email used for reminders.
IS_CONTACT_REMINDER_EMAIL_FLAG	Flag for reminder email contact preference.
PAYMENT_EMAIL	Email used for payment communications.
IS_CONTACT_PAYMENT_EMAIL_FLAG	Flag for payment email contact preference.
SHIPMENT_EMAIL	Email used for shipment notifications.
IS_CONTACT_SHIPMENT_EMAIL_FLAG	Flag for shipment email contact preference.
ORDER_PROCESSING_EMAIL	Email used for order-processing notifications.
IS_CONTACT_ORDER_PROCESSING_EMAIL_FLAG	Flag for order-processing email preference.
DEFAULT_SALES_STORE_NAME	Default sales store name.
DEFAULT_SHIP_STORE_NAME	Default ship store name.
DEFAULT_SALES_STORE_ID	Default sales store ID.
DEFAULT_SHIP_STORE_ID	Default ship store ID.

VW_CYCLE_COUNT_DETAIL_INFO

Column Name	Description
ID	Unique identifier for the cycle count detail line.
CYCLE_COUNT_ID	Reference ID of the cycle count.
LOCATION_ID	Inventory location id.
LOCATION_DISP	Display name of the location.
LOCN_BARCODE	Barcode associated with the location.
ITEM_ID	Id of the Item
ITEM_NUMBER	Item number/SKU.
ITEM_DESCRIPTION	Description of the item.
CREATE_DTTM	Date and time when the record was created.
CREATE_SOURCE	Id of the user who created the record.
MODIFY_DTTM	Date and time when the record was last modified.
MODIFY_SOURCE	Id of the user who last modified the record.
STATUS_ID	Status Id for the count line.
QTY_TO_COUNT	Expected quantity at the location.
QTY_COUNTED	Quantity entered during the count.
LINKED_RECOUNT_DETAIL_ID	Reference to recount detail line, if applicable.
NOTES	Any notes entered for this count line.
CC_BATCH_NUMBER	Cycle count batch number.
STORE_NAME	Name of the store where count occurred.
STORE_ID	Store identifier.
STANDARD_UNIT_COST	Cost per unit for valuation.
UOM_CODE	Unit of measure code (e.g., EA, BOX).
IS_COUNTED	Flag indicating whether the item was counted.
IS_COUNTED_STR	Readable version of the counted flag (Yes/No).
ALTERNATIVE_ITEM_NUMBER1	Alternative item number 1.
ALTERNATIVE_ITEM_NUMBER2	Alternative item number 2.
ALTERNATIVE_ITEM_NUMBER3	Alternative item number 3.
ITEM_GROUP_NAME	Name of the item group.
ITEM_CATEGORY_NAME	Name of the Item category.
QTY_DIFF	Difference between expected and counted quantity.
QTY_ADJUSTMENTS	Quantity adjustments applied before count.
QTY_ADJUSTMENTS_AFTER_COUNT	Quantity adjustments applied after count.
LPN_ID	Id of the assigned LPN
LPN_NUMBER	Assigned LPN
IS_VIRTUAL_LPN	Indicates whether LPN is virtual.
BATCH_NUMBER	Batch number associated with the LPN.
LOT_NUMBER	Lot number associated with the LPN.
MFG_DATE	Manufacturing date.
PRIORITY_NUMBER	Priority assigned to the count line.
COUNT_ID	ID of the count within the cycle count event.
ITEM_UPC	UPC code for the item.
INNER_CASE_UPC	Inner case UPC code.
MASTER_CASE_UPC	Master case UPC code.
REASON_CODE_NAME	Reason code linked to adjustments or differences.
STATUS_NAME	Status of the count line.
CC_GEN_TYPE_NAME	Count generation type.
CC_GEN_TYPE_ID	Id of the count generation type.
ZONES	Zone(s) associated with the location.
IS_ADJUSTMENT_EXISTS_AFTER_COUNT	Flag indicating if any adjustments exist after the count.
IS_MOVED_COUNT_LINE	Indicates whether the count line was moved from another location.
ACCEPTED_DTTM	Timestamp when the count was accepted.
ITEM_QUALITY_ID	Item quality classification ID.
EXP_DATE	Item expiration date.
ACCOUNT_3PL_NAME	Name of the 3PL account associated with the item.
ACCOUNT_3PL_CODE	Code of the 3PL account.
BRAND_NAME	Brand name of the item.
ASSIGNED_USER	User assigned to perform the count.
ASSIGNED_DTTM	Timestamp when the count line was assigned.
TOTAL_VARIANCE	Total variance value based on cost × quantity difference.
VALUE_VARIANCE_COUNTED	Value variance based only on counted quantity.
QTY_VARIANCE_COUNTED	Quantity variance based on count entry.
QTY_VARIANCE_COUNTED_ABS	Absolute quantity variance.
VALUE_VARIANCE_COUNTED_ABS	Absolute value variance.

VW_CYCLE_COUNT_HEADER_INFO_EXT

Column Name	Description
CYCLE_COUNT_ID	Unique ID of the cycle count event.
POSTIVE_QTY_VARIANCE_COUNTED	Positive quantity variance based on counted quantity.
NEGATIVE_QTY_VARIANCE_COUNTED	Negative quantity variance based on counted quantity.
POSTIVE_QTY_VARIANCE	Total positive quantity variance.
NEGATIVE_QTY_VARIANCE	Total negative quantity variance.
POSTIVE_VALUE_VARIANCE_COUNTED	Positive value variance based on counted quantity.
NEGATIVE_VALUE_VARIANCE_COUNTED	Negative value variance based on counted quantity.
POSTIVE_VALUE_VARIANCE	Total positive value variance.
NEGATIVE_VALUE_VARIANCE	Total negative value variance.
COUNTED_RECORDS	Number of lines that have been counted.
TOTAL_RECORDS	Total number of lines in the cycle count.
TOTAL_QTY_VARIANCE_COUNTED	Net quantity variance from counted lines.
TOTAL_ABS_QTY_VARIANCE_COUNTED	Absolute quantity variance from counted lines.
TOTAL_VALUE_VARIANCE_COUNTED	Net value variance from counted lines.
TOTAL_ABS_VALUE_VARIANCE_COUNTED	Absolute value variance from counted lines.
TOTAL_QTY_VARIANCE	Net total quantity variance.
TOTAL_VALUE_VARIANCE	Net total value variance.
TOTAL_ABS_QTY_VARIANCE	Absolute total quantity variance.
TOTAL_ABS_VALUE_VARIANCE	Absolute total value variance.
PROGRESS	Completion percentage of the cycle count.
ID	Unique identifier for the cycle count header record.
CC_BATCH_NUMBER	Cycle count batch number.
STORE_ID	Identifier for the store.
COUNT_CODE_ID	Cycle count code Id.
TYPE_ID	Count type identifier.
CC_GEN_TYPE_ID	Count generation type Id.
GEN_CRITERIA_STR	Generation criteria used to create the count.
COUNT_SEQ	Sequence number of the count event.
STATUS_ID	Id of the status code.
IS_RECOUNT	Indicates whether the count is a recount.
CREATE_DTTM	When the record was created.
CREATE_SOURCE	User or system that created the record.
MODIFY_DTTM	When the record was last modified.
MODIFY_SOURCE	User or system that last modified the record.
NOTES	Notes related to the count.
CC_GEN_TYPE_NAME	Name of the count generation type.
CC_CODE_NAME	Name of the count code.
CC_STATUS_NAME	Status name of the count.
STORE_NAME	Name of the store.
ZONES	Zone(s) included in the CC batch.
ACCEPTED_DTTM	When the cycle count was accepted.
ASSIGNED_USERS	Users assigned to the cycle count batch.

VW_INVENTORY_MOVEMENT_DETAIL

Column Name	Description
ID	Unique identifier for the inventory movement record.
FROM_STORE_ID	Source store Id from where the inventory is moved.
ITEM_ID	Id of the item being moved.
ITEM_NUMBER	Item number/SKU.
TO_STORE_ID	Destination store Id.
FROM_LOC_ID	Source location Id.
TO_LOC_ID	Destination location Id.
QTY	Quantity of item moved.
TXN_TYPE_ID	Transaction type Id.
DISP_NAME	Display name for the transaction/movement.
TXN_REF_ID	Reference Id for the related transaction.
TXN_REF_NO	Reference number of the related transaction.
FROM_LPN_ID	Source LPN Id.
TO_LPN_ID	Destination LPN Id.
CREATE_DTTM	Date and time the movement record was created.
CREATE_SOURCE	User or system that created the record.
TO_STORE_NAME	Name of the destination store.
FROM_STORE_NAME	Name of the source store.
TO_LOCATION	Display name of the destination location.
FROM_LOCATION	Display name of the source location.
TO_LPN_NUMBER	Destination LPN number.
FROM_LPN_NUMBER	Source LPN number.
MOVE_TYPE	Type of inventory movement.
STORE_NAME	Name of the store associated with the record.
LOCATION_NAME	Name of the location associated with the record.
LPN_NUMBER	LPN number associated with the movement.
STORE_ID	Store Id linked to the record.
TXN_DATE	Date of the movement transaction.
IMAGE_SRC	Image URL/source of the item, if applicable.
DESCRIPTION	Item description.
SEASON_VALUES	Season code for the item.
BRAND_NAME	Brand of the item.
STANDARD_UNIT_COST	Standard cost per unit.
STANDARD_UNIT_PRICE	Standard selling price per unit.
CUSTOM_PRICE_1–14	Custom price fields associated with the item.
ITEM_UPC	UPC code for the item.
TAGS	Tags or labels associated with the item.
GROUP_NAME	Item group name.
ITEM_CATEGORY_NAME	Item category name.
ITEM_BARCODE	Barcode of the item.
MEMO	Notes related to the movement.
ALTERNATIVE_ITEM_NUMBER1	Alternative item number 1.
ALTERNATIVE_ITEM_NUMBER2	Alternative item number 2.
ALTERNATIVE_ITEM_NUMBER3	Alternative item number 3.
INVENTORY_TYPE_ID	Inventory type Id.
INVENTORY_TYPE	Inventory type description.
UOM_NAME	Unit of measure name.
FROM_PALLET	Source pallet number.
TO_PALLET	Destination pallet number.
WMS_MODULE	WMS module associated with the movement.
WMS_FUNCTION	WMS function associated with the movement.
FROM_LPN_LOT_NUMBER	Source LPN lot number.
FROM_LPN_BATCH_NUMBER	Source LPN batch number.
FROM_QUALITY_NAME	Source quality description.
FROM_LPN_MFG_DATE	Source LPN manufacturing date.
TO_LPN_LOT_NUMBER	Destination LPN lot number.
TO_LPN_BATCH_NUMBER	Destination LPN batch number.
TO_QUALITY_NAME	Destination quality description.
TO_LPN_MFG_DATE	Destination LPN manufacturing date.
STATUS	Status of the movement record.
FROM_OLPN	Source order LPN number.
TO_OLPN	Destination order LPN number.
TO_LPN_EXP_DATE	Expiration date of destination LPN.
FROM_LPN_EXP_DATE	Expiration date of source LPN.
REF_NUMBER_2	Secondary reference number.
LOT_NUMBER	Combine ( FROM & TO LPN) of Lot number of the LPN.
MFG_DATE	Combine ( FROM & TO LPN) of Manufacturing date of the LPN.
BATCH_NUMBER	Combine ( FROM & TO LPN) of Batch number of the LPN.
EXP_DATE	Combine ( FROM & TO LPN) of Expiration date of the LPN.
QUALITY	Combine ( FROM & TO LPN) of Quality name of the LPN.
SO_NUMBER	Sales order number associated with the movement.
OLPN_NUMBER	Out LPN number.
TO_ZONE_NAME	Destination zone name.
FROM_ZONE_NAME	Source zone name.
ZONE_NAME	Zone name associated with the movement.
CUSTOMER_NAME	Customer name, if applicable.
ACCOUNT_3PL_NAME	3PL account name associated with the movement.
ACCOUNT_3PL_CODE	3PL account code.
SHIPPED_BY	Person or entity responsible for shipping.
FROM_OLPN_ID	Source OLPN ID.
TO_OLPN_ID	Destination OLPN ID.
FROM_PALLET_ID	Source pallet ID.
TO_PALLET_ID	Destination pallet ID.
FROM_LPN_QUALITY_ID	Source LPN quality ID.
TO_LPN_QUALITY_ID	Destination LPN quality ID.

OM_AT

Column Name	Description
ID	Unique identifier for the inventory snapshot record.
STORE_ID	Store identifier.
STORE_NAME	Name of the store.
ITEM_ID	Id of the item.
ITEM_NUMBER	Item number/SKU.
IS_BOM_ITEM_FLAG	Flag indicating if the item is a BOM (Bill of Materials) item.
RE_ORDER_POINT_QTY	Minimum quantity to trigger reorder.
RE_ORDER_QTY	Quantity to reorder when below reorder point.
DEFAULT_VENDOR_ID	Default vendor Id for the item.
ITEM_BRAND_NAME	Brand name of the item.
ITEM_BRAND_ID	Brand Id of the item.
DEFAULT_VENDOR	Name of default vendor.
VENDOR_DISCOUNT	Vendor discount percentage.
VENDOR_PART_NUMBER	Vendor’s item number.
LEAD_TIME_DAYS	Lead time in days from the vendor.
VENDOR_LIST_PRICE	Vendor’s list price.
IS_STOCKING_ITEM_FLAG	Flag indicating if item is regularly stocked.
SEASON_VALUES	Season code for the item.
DESCRIPTION	Item description.
OPTION_1_NAME	Name of option 1.
OPTION_1_VALUE	Selected value for option 1.
OPTION_2_NAME	Name of option 2.
OPTION_2_VALUE	Selected value for option 2.
OPTION_3_NAME	Name of option 3.
OPTION_3_VALUE	Selected value for option 3.
OPTION_1_CODE	Code for option 1.
OPTION_2_CODE	Code for option 2.
OPTION_3_CODE	Code for option 3.
BASE_PART_NUMBER	Base part number from product header.
PRODUCT_HEADER_ID	Product header reference Id.
TITLE	Product title.
STANDARD_UNIT_COST	Standard unit cost.
STANDARD_UNIT_PRICE	Standard selling price per unit.
IMAGE_SRC	Item image URL or source.
CUSTOM_PRICE_1–14	Custom price fields for flexibility.
ITEM_BARCODE	Barcode of the item.
ITEM_UPC	UPC code of the item.
GROUP_NAME	Item group name.
STORE_CODE	Store code..
ITEM_CATEGORY_NAME	Item category name.
TAGS	Item tags or labels.
ACTIVE_FLAG_STR	‘Y’ or ‘N’ for active flag.
ON_HAND_QTY	Total inventory quantity, including Not Available, Available.
NOT_AVAILABLE_QTY	Quantity that is unavailable due to damage or being unsellable at the specific location.
AVAILABLE_QTY	Quantity available for use (On Hand - Not Available - Allocated ).
QTY_ON_SO	Quantity on released sales orders.
QTY_ON_SO_DRAFT	Quantity on open sales orders.
QTY_TO_PICK	Quantity allocated for picking.
NET_AVAILABLE	Available quantity after subtracting allocations (Available - Allocated).
QTY_ON_PO	Quantity on released purchase orders.
QTY_ON_PO_DRAFT	Quantity on open purchase orders.
QTY_TO_RECEIVE	Quantity to be received from PO.
ATS_QTY	Available to sell quantity. (Available – On Released SO)
ATS_QTY_INC_PO	ATS including purchase orders.(Available – On Released SO + On Released PO)
QTY_ON_MO	Quantity on manufacturing orders.
QTY_TO_PRODUCE	Quantity to produce.
STORE_RE_ORDER_POINT_QTY	Store-level reorder point.
STORE_RE_ORDER_QTY	Store-level reorder quantity.
LESS_THAN_REORDER_POINT	Flag if on-hand quantity is below reorder point.
GENDER_CODE	Gender classification for item, if applicable.
HS_CODE	Harmonized system code for customs.
ISO_COUNTRY_NAME	Country name associated with item or vendor.
LENGTH	Item length.
WIDTH	Item width.
HEIGHT	Item height.
WEIGHT	Item weight.
SELL_UOM_NAME	Selling unit of measure name.
SIZE_UOM_NAME	Unit of measure for size.
WEIGHT_UOM_NAME	Unit of measure for weight.
WARRANTY_TIME	Warranty period.
SHELF_LIFE	Shelf life of the item.
EXPIRATION_DATE	Expiration date.
CARB	CARB compliance information.
ALERT_NOTE	Notes for alerts/warnings.
SALES_NOTES	Notes for sales.
IS_PURCHASABLE_FLAG	Flag indicating if the item is purchasable.
IS_SELLABLE_FLAG_STR	‘Y’ or ‘N’ for sellable flag.
IS_SELLABLE_FLAG	Flag indicating if item is sellable.
ALTERNATIVE_ITEM_NUMBER1	Alternative item number 1.
ALTERNATIVE_ITEM_NUMBER2	Alternative item number 2.
ALTERNATIVE_ITEM_NUMBER3	Alternative item number 3.
FORECAST_QTY_SALES	Forecasted sales quantity.
SELL_UOM_CODE	Selling unit of measure code.
CUBIC_CAPACITY_UOM_CODE	Unit of measure code for cubic capacity.
BOM_ATS_QTY	Maximum number of units of the finished good that can be produced based on the “Available to Sell (ATS)” qty of the Raw materials.
BOM_ATS_QTY_INC_PO	Maximum number of finished goods that can be produced based on the available raw material quantity ("ATS Inc PO and MO")
BOM_AVAILABLE_QTY	Maximum number of finished goods that can be produced based on the “Available” inventory of raw materials.
BOM_NET_AVAILABLE	BOM net available quantity. (Net Available + Producible Net Available)
BOM_ON_HAND_QTY	BOM on-hand quantity. (On Hand + Producible On Hand)
TOTAL_BOM_ATS_QTY	Total BOM ATS quantity . (ATS + BOM ATS Qty)
TOTAL_BOM_ATS_QTY_INC_PO	Total BOM ATS including PO. (ATS (Inc PO) + BOM ATS Including PO)
TOTAL_BOM_AVAILABLE_QTY	Sum of available units of the item and the maximum number of finished goods that can be produced based on the “Available” inventory of raw materials. (Available + BOM ATS Qty)
TOTAL_BOM_NET_AVAILABLE	Sum of the “Net Available” units of the finished good and the maximum number of units of the finished good that can be produced based on the “Net Available” inventory of the raw material (Net Available + BOM Net Available)
TOTAL_BOM_ON_HAND_QTY	Sum of On Hand units of the item (finished goods) and the maximum number of finished goods that can be produced based on the “On Hand” inventory of raw materials. (On Hand + BOM On Hand Qty)
ATS_QTY_INC_MO	ATS including released manufacturing orders.
ATS_QTY_INC_PO_MO	ATS including released SO, released PO and released MO.
BOM_ATS_QTY_INC_MO	BOM ATS including MO.
BOM_ATS_QTY_INC_PO_MO	BOM ATS including PO & MO.
TOTAL_BOM_ATS_QTY_INC_MO	Total BOM ATS including MO.
TOTAL_BOM_ATS_QTY_INC_PO_MO	Total BOM ATS including PO & MO.
BASE_UOM_NAME	Base unit of measure name.
QTY_ON_RMA	Quantity on RMA.
QTY_ON_RMA_DRAFT	Quantity on draft RMA.
FORECAST_QTY_CURRENT_YEAR	Forecasted sales quantity for current year.
FORECAST_QTY_NEXT_YEAR	Forecasted sales quantity for next year.
IS_RAW_MATERIAL_FLAG	Flag indicating item is a raw material
IS_BOM_ITEM_FLAG_STR	‘Y’ or ‘N’ for the BOM item flag.
LAST_UNIT_COST	Last recorded unit cost.
LAST_LANDED_UNIT_COST	Last landed unit cost.
LAST_LANDED_UNIT_COST_HOME_CURRENCY	Last landed unit cost in home currency.
ACTIVE_FLAG	Boolean active flag.
SELL_UOM_ID	Selling UOM Id.
BASE_UOM_ID	Base UOM Id.
IS_3A_ITEM	Flag for 3A item classification.
ACCOUNT_3PL_ID	3PL account Id.
CUBIC_METERS	Volume in cubic meters.
LAST_PURCHASED_QTY	Quantity purchased in the last transaction.
LAST_RECEIPT_DATE	Date of last receipt.
LAST_RECEIPT_CURRENCY_CODE	Currency code of last receipt.
LAST_RECEIPT_RECONCILE_FLAG	Flag if the last receipt is reconciled.
PROJECT_CLASS_NAME	Project class name.
TOTAL_LINKED_QTY	Total quantity linked to other transactions.
CUSTOM_FIELD_VALUE1–50	Custom attribute fields for extended use.
SEARCH_KEYWORDS	Keywords for searching the item.
ITEM_PRODUCT_CATEGORY_NAME	Product category name.
AVG_COST	Average cost of the item.
MANUFACTURER	Item manufacturer.
SUB_CATEGORY_NAME	Sub-category name.
MATERIAL_NAME	Material name of the item.
SHORT_QTY	Quantity marked as short.
SALES_HISTORY_QTY_SOLD	Quantity sold historically.
SUGGESTED_ORDER_QTY	Suggested reorder quantity.
TOTAL_AVAILABLE_QTY	Total available quantity.
ACTIVE_LINKED_QTY	Linked quantity in PO in unreceived state.
QTY_NOT_LINKED	Quantity not linked in the SO
TO_ORDER_QTY	Quantity recommended to order.
ATS_QTY_INC_SO_DRAFT	ATS including draft sales orders.

VW_INVOICE_HEADER_INFO

Column Name	Description
ACCNT_NUMBER	Customer accounting number.
ACCNT_RECEIVABLE_ID	Accounts receivable ledger account identifier.
ACCOUNT_3PL_CODE	3PL account code.
ACCOUNT_3PL_ID	3PL account identifier.
ACCOUNT_3PL_NAME	3PL account display name.
ACCOUNT_3PL_TYPE_ID	Customer 3PL account type identifier.
ACCOUNT_NAME	Receivable account full name.
AMOUNT_DUE	Remaining balance due.
AMOUNT_PAID	Amount already paid against invoice.
AUTO_PROCESS_PAYMENT	Flag for auto payment processing.
AUTO_PROCESS_PAYMENT_ID	Auto processing payment account id.
AUTO_PROCESS_PAYMENT_METHOD_NAME	Masked bank/card name used for autopay.
BILL_TO_ADDR	Billing address line 1.
BILL_TO_ADDR_NAME	Billing address name label.
BILL_TO_ADDR2	Billing address line 2.
BILL_TO_CITY	Billing city.
BILL_TO_COMPANY_NAME	Billing company name.
BILL_TO_COUNTRY	Billing country.
BILL_TO_EMAIL	Billing contact email address.
BILL_TO_FIRST_NAME	Billing contact first name.
BILL_TO_INSTRUCTION_FIELD_1 - 10	Bill-to instruction field data from 1 to 10.
BILL_TO_LAST_NAME	Billing contact last name.
BILL_TO_PHONE_NUMBER	Billing contact phone number.
BILL_TO_STATE	Billing state/province.
BILL_TO_ZIP_POSTAL_CODE	Billing postal or ZIP code.
BOL_NUMBER	Bill of lading number.
BRAND_ID	Brand identifier for invoice items.
BRAND_NAME	Item brand display name.
BUSINESS_NO	Customer business number (tax/registration).
BUYER_ID	Buyer identifier associated with invoice.
BUYER_NAME	Buyer display name.
CARD_EXP	Card expiration date.
CARD_EXP_STATUS	Card expiration status.
CARD_LAST_4_DIGIT	Last 4 digits of payment card.
CARD_MASK	Masked card number representation.
CARRIER_CODE	Carrier code identifier.
CARRIER_ID	Shipping carrier identifier.
CARRIER_NAME	Carrier display name.
CHEQUE_NO	Cheque number used for payment.
CONTACT_EMAIL	Contact email address.
CONTACT_FIRST_NAME	Contact first name.
CONTACT_ID	Contact identifier linked to invoice.
CONTACT_LAST_NAME	Contact last name.
CONTACT_NAME	Contact full name (concatenated).
CONTACT_PHONE_NUMBER	Contact phone number.
CONTACT_TITLE	Contact job title.
CONTAINER_REF_NUMBER	Container reference number.
CONTRACT_NUMBER	3PL contract number.
CREATE_DTTM	Invoice creation timestamp.
CREATE_SOURCE	Source system that created invoice.
CREDIT_APPLIED	Credit memos applied amount.
CURRENCY_CODE	Currency ISO or code.
CURRENCY_ID	Currency identifier used for invoice.
CURRENCY_NAME	Currency display name.
CURRENCY_SYMBOL	Currency symbol unicode value.
CUSTOM_FIELD_VALUE1 - 50	Custom field value 1 for invoice.
CUSTOMER_ACCOUNT_NUMBER	Customer account number (accounting).
CUSTOMER_BILLING_METHOD_NAME	Billing method type display name.
CUSTOMER_FIRST_NAME	Customer contact first name.
CUSTOMER_FULL_NAME	Customer full name (first + last).
CUSTOMER_GROUP_ID	Customer grouping identifier.
CUSTOMER_ID	Customer unique identifier.
CUSTOMER_LAST_NAME	Customer contact last name.
CUSTOMER_MAIN_PHONE	Customer main phone number.
CUSTOMER_MESSAGE	Message shown to customer on invoice.
CUSTOMER_NAME	Customer display name.
CUSTOMER_PARENT_ID	Parent customer ID (if account hierarchy).
CUSTOMER_PARENT_NAME	Parent customer display name.
CUSTOMER_PO	Customer purchase order number.
CUSTOMER_SERVICE_REP_EMAIL	Customer service rep email address.
CUSTOMER_SERVICE_REP_FULL_NAME	Customer service rep full name.
CUSTOMER_SERVICE_REP_ID	Customer service representative user id.
CUSTOMER_TAGS	Customer tags for segmentation.
CUSTOMER_TAX_CODE_ID	Customer tax code identifier.
DATE_ORDER	Sales order date.
DATE_TO_BE_SHIPPED	Requested ship date from sales order.
DEFAULT_BILLING_EMAIL	Customer default billing email address.
DEFAULT_BILLING_METHOD_TYPE_ID	Customer default billing method type id.
DEFAULT_PAYMENT_METHOD	Customer default payment method name.
DEFAULT_SHIPMENT_UPDATES_EMAIL	Customer default shipment updates email.
DEFAULT_TAX_CODE_ID	Customer default tax code id.
DEPOSIT_APPLIED	Deposits applied to invoice amount.
DISCOUNT_AMOUNT	Total discount amount applied.
DISCOUNT_APPLIED	Discount amount applied (ISNULL handled).
DISCOUNT_DATE	Date discount is applied or valid until.
DISCOUNT_DAYS	Payment terms discount applicable days.
DISCOUNT_FACTOR	Payment terms discount factor (numeric).
DISCOUNT_PERCENTAGE	Discount factor as percentage.
DISCOUNTABLE_TOTAL	Portion of total eligible for discount.
DUE_DATE	Payment due date for the invoice.
DUE_DAYS	Payment net days from payment terms.
DUE_REMINDER_EMAIL_SENT_DTTM	Timestamp due reminder email last sent.
EDI_DOC_RESP_MESSAGE	EDI response message text.
EDI_DOC_STATUS	EDI document status text (Error/Success).
EMAIL_CC	Customer CC email addresses.
EMAIL_MAIN	Customer primary email.
EMAILED_FLAG	Numeric flag if invoice emailed.
EMAILED_FLAG_STR	Y'/'N' if invoice emailed.
ENTITY_USE_CODE	Customer entity use/tax exemption code.
EXCHANGE_RATE	Exchange rate applied to invoice currency.
Expr1	Duplicate of MAX_DISCOUNT_ALLOWED (alias).
Expr2	Duplicate of DISCOUNT_APPLIED (alias).
FOB_POINT_ID	Free-on-board point identifier.
FOB_POINT_NAME	FOB point display name.
FULL_PAYMENT_DATE	Date invoice fully paid.
GROUP_NAME	Customer group display name.
HASH_CODE_JSON	Hash or integrity JSON data.
ID	Invoice unique identifier.
INT_ACCNT_ID	Customer internal account identifier.
INVALID_ADDRESS_FLAG	Flag indicating invalid address detected.
INVOICE_BATCH_ID	Invoice batch identifier.
INVOICE_BATCH_NUMBER	Invoice batch reference number.
INVOICE_NUMBER	Customer-facing invoice number.
IS_3PL_ACCOUNT_CUSTOMER	1 if customer is 3PL account type 20.
IS_3PL_BILLING_INVOICE	Flag if invoice billed to 3PL.
IS_3PL_INVOICE	Y'/'N' indicating 3PL invoice.
IS_CARD_ON_FILE	Y'/'N' if card is on file.
IS_CONTACT_ORDER_PROCESSING_EMAIL_FLAG	Flag if contact receives processing emails.
IS_CONTACT_PAYMENT_EMAIL_FLAG	Flag if contact receives payment emails.
IS_CONTACT_REMINDER_EMAIL_FLAG	Flag for reminder email to contact.
IS_CONTACT_SHIPMENT_EMAIL_FLAG	Flag if contact receives shipment emails.
IS_CREATED_FROM_THIRD_PARTY	Flag if created via third-party integration.
IS_EDI_FLAG	Numeric flag if invoice is EDI.
IS_EDI_FLAG_STR	Y'/'N' if invoice is EDI.
IS_FIRST_INVOICE	Flag marking first invoice for customer.
IS_OVERDUE_STR	Y'/'N' if invoice overdue and status not 520.
IS_PROCESSED	Flag if invoice processed.
IS_SHIPPING_BILL_CREATED	Flag if shipping bill created.
JOB_SCHEDULE_RERUN_FLAG	Job schedule rerun flag numeric.
JOB_SCHEDULE_RERUN_FLAG_STR	Y'/'N' if job schedule rerun.
JOB_SCHEDULE_RUN_FLAG	Job schedule run flag numeric.
JOB_SCHEDULE_RUN_FLAG_STR	Y'/'N' if job schedule run.
LADING_QTY	Number of cartons/lading quantity.
LAST_EMAIL_DTTM	Last email sent timestamp.
LAST_INVOICE_PAYMENT_NUMBER	Last invoice payment reference number.
LAST_OVERDUE_EMAIL_SENT_DTTM	Last overdue email sent timestamp.
LAST_PAYMENT_EMAIL_SENT_DTTM	Timestamp of last payment email sent.
LAST_PAYMENT_EMAIL_SENT_SOURCE	Source of last payment email.
LINKED_SHIPPING_BILL_ID	Linked shipping bill identifier.
MAIN_PHONE	Customer primary phone number.
MARK_AS_SHIPPED	Flag indicating invoice marked shipped.
MASTER_BOL_NUMBER	Master bill of lading number.
MASTER_TRACKING_NUMBER	Master tracking number for shipment.
MATCHED_FLAG	Numeric matched flag (0/1).
MATCHED_FLAG_STR	Y'/'N' matched flag string representation.
MAX_DISCOUNT_ALLOWED	Maximum discount allowed for this invoice.
MEMO	Invoice memo or internal notes.
META_DATA	Invoice metadata (structured JSON).
MODIFY_DTTM	Last modification timestamp.
MODIFY_SOURCE	Source that last modified invoice.
NO_TAX_SERVICE_REQUEST_FLAG	Flag to disable external tax request.
OPENING_BALANCE_FLAG	Flag indicating opening balance invoice.
ORDER_PROCESSING_EMAIL	Customer order processing email.
ORDER_SUB_TYPE_CODE	Sales order sub-type code.
ORDER_SUB_TYPE_NAME	Sales order sub-type display name.
PACKING_SLIP_NUMBER	Associated packing slip number.
PAYMENT_EMAIL	Customer payment email address.
PAYMENT_EMAIL_SENT_COUNT	Count of payment emails sent.
PAYMENT_EMAIL_SENT_FLAG	Numeric flag if payment email sent.
PAYMENT_EMAIL_SENT_FLAG_STR	Y'/'N' if payment email sent.
PAYMENT_LINK_COUNT	Count of valid payment links.
PAYMENT_METHOD	Payment method display name.
PAYMENT_METHOD_TYPE	Payment method type display name.
PAYMENT_METHOD_TYPE_ID	Payment method type identifier.
PAYMENT_REF_NO	Payment reference number.
PAYMENT_REF_NO2	Secondary payment reference number.
PAYMENT_TERM_NAME	Payment terms display name.
PAYMENT_TERMS_ID	Payment terms identifier.
PERMISSION_GROUP_ID	Customer permission group identifier.
PORTAL_ACCOUNT_NUMBER	Customer portal account identifier.
PROJECT_CLASS_ID	Project class identifier.
PROJECT_CLASS_NAME	Project class display name.
RECEIPT_NUMBER	Linked receipt number from bill header.
REF_NO	External reference number (customer/vendor).
REMINDER_EMAIL	Customer reminder email address.
REPORTING_DATA	Reporting metadata or JSON.
RESTRICT_DAILY_INVOICE_EMAIL_FLAG	Flag restricting daily invoice emails.
RESTRICT_DUE_INVOICE_EMAIL_FLAG	Flag restricting due invoice emails.
RESTRICT_OVERDUE_INVOICE_EMAIL_FLAG	Flag restricting overdue emails.
RISK_ANALYSIS	Risk analysis summary or score.
SALE_STORE_ADDR	Sale store address line 1.
SALE_STORE_ADDR_NAME	Sale store address name.
SALE_STORE_ADDR2	Sale store address line 2.
SALE_STORE_CITY	Sale store city.
SALE_STORE_CODE	Sale store code identifier.
SALE_STORE_COMPANY_NAME	Sale store company name.
SALE_STORE_COUNTRY	Sale store country.
SALE_STORE_EMAIL	Sale store email address.
SALE_STORE_FIRST_NAME	Sale store contact first name.
SALE_STORE_ID	ID of store that made the sale.
SALE_STORE_LAST_NAME	Sale store contact last name.
SALE_STORE_NAME	Sale store display name.
SALE_STORE_PHONE_NUMBER	Sale store phone number.
SALE_STORE_STATE	Sale store state/province.
SALE_STORE_ZIP_POSTAL_CODE	Sale store postal or ZIP code.
SALES_ORDER_DATE	Sales order creation date.
SALES_REP_EMAIL	Sales rep email address.
SALES_REP_FULL_NAME	Sales rep full name (first + last).
SALES_REP_GROUPS	Sales rep groups from VW_USER_INFO_W_GROUPS.
SALES_REP_ID	Sales representative user identifier.
SAVED_CARDS	Number of saved payment cards for customer.
SHIP_CONFIRMATION_EMAIL_SENT	Flag if ship confirmation email sent.
SHIP_CONFIRMATION_EMAIL_SENT_DTTM	Timestamp ship confirmation email sent.
SHIP_DATE	Date the invoice was shipped.
SHIP_FROM_ADDR	Ship-from address line 1.
SHIP_FROM_ADDR_NAME	Ship-from address display name.
SHIP_FROM_ADDR2	Ship-from address line 2.
SHIP_FROM_CITY	Ship-from city.
SHIP_FROM_COMPANY_NAME	Ship-from company name.
SHIP_FROM_COUNTRY	Ship-from country.
SHIP_FROM_EMAIL	Ship-from contact email.
SHIP_FROM_FIRST_NAME	Ship-from contact first name.
SHIP_FROM_LAST_NAME	Ship-from contact last name.
SHIP_FROM_PHONE_NUMBER	Ship-from contact phone number.
SHIP_FROM_POSTAL_ZIP_CODE	Ship-from postal or ZIP code.
SHIP_FROM_STATE	Ship-from state/province.
SHIP_METHOD_ID	Shipping method identifier.
SHIP_METHOD_NAME	Shipping method display name.
SHIP_SERVICE_ID	Specific ship service identifier.
SHIP_SERVICE_NAME	Ship service display name.
SHIP_TO_ADDR	Shipping address line 1.
SHIP_TO_ADDR_NAME	Shipping address name label.
SHIP_TO_ADDR2	Shipping address line 2.
SHIP_TO_CITY	Shipping city.
SHIP_TO_COMPANY_NAME	Recipient company name for shipping.
SHIP_TO_COUNTRY	Shipping country.
SHIP_TO_EMAIL	Recipient email for shipping.
SHIP_TO_FIRST_NAME	Recipient first name for shipping.
SHIP_TO_INSTRUCTION_FIELD_1 to 12	Ship-to instruction field 1 to 12.
SHIP_TO_LAST_NAME	Recipient last name for shipping.
SHIP_TO_PHONE_NUMBER	Recipient phone number for shipping.
SHIP_TO_STATE	Shipping state/province.
SHIP_TO_ZIP_POSTAL_CODE	Shipping postal or ZIP code.
SHIPMENT_EMAIL	Customer shipment email address.
SHIPMENT_ID	Shipment header identifier.
SHIPMENT_REF_NUMBER	Shipment reference identifier.
SHIPPING_ACCOUNT_NUMBER	Shipping account number used.
SHIPPING_AMOUNT	Shipping taxable amount.
SHIPPING_AMOUNT_CREDITED	Credited shipping amount.
SHIPPING_COST	Shipping cost amount.
SHIPPING_COST_CARRIER	Carrier-charged shipping cost amount.
SHIPPING_EXPENSE_ACCNT_ID	Shipping expense account identifier.
SHIPPING_EXPENSE_ACCNT_NAME	Shipping expense account full name.
SHIPPING_NOTES	Shipping-related notes or instructions.
SHIPPING_TAX_CODE	Shipping tax code identifier.
SHIPPING_TAX_CODE_NAME	Shipping tax code display name.
SHIPPING_TAX_DATA	Serialized shipping tax information.
SHIPPING_TERM_NAME	Shipping term display name (disp or name).
SHIPPING_TERMS_ID	Shipping terms identifier.
SHIPPING_TYPE_ID	Shipping type identifier.
SHIPPING_TYPE_NAME	Shipping type display name.
SO_ID	Related sales order ID.
SO_NUMBER	Related sales order number.
SO_REF_NO	Sales order reference number.
SSCC	Serial Shipping Container Code.
STATUS_ID	Invoice status identifier.
STATUS_NAME	Invoice status display name.
STORE_CODE	Store code from main store join.
STORE_ID	ID of store where invoice was created.
STORE_NAME	Store display/name from store join.
SUB_TOTAL	Invoice subtotal before tax and discounts.
SUB_TOTAL_EXCL_DISCOUNT	Subtotal excluding discounts.
SUB_TYPE_ID	Sales order sub-type identifier.
SYS_LOCK_FLAG	System lock flag for edits.
TAGS	Free-form invoice tags.
TAX_ADDRESS_JSON	Tax address structured data (JSON).
TAX_SERVICE_HASH_CODE	Tax service hash or id.
TAX_SERVICE_REF_NAME	Tax service reference name.
TAX_SUMMARY_DATA	Serialized tax summary details.
THIRD_PARTY_DISPLAY_NAME	Third-party display name.
THIRD_PARTY_ICON_URL	Third-party icon URL.
THIRD_PARTY_NOTES	Third-party related notes.
THIRD_PARTY_ORDER_DTTM	Third-party order datetime.
THIRD_PARTY_REF_NAME	Third-party reference display name.
THIRD_PARTY_REF_NO	Third-party reference number.
THIRD_PARTY_SHIPMENT_METADATA	Third-party shipment metadata JSON.
THIRD_PARTY_SOURCE	Third-party source identifier/name.
TOTAL_AMOUNT	Invoice total amount (including taxes).
TOTAL_QTY	Total quantity of items invoiced.
TOTAL_TAX_AMOUNT	Total tax amount on invoice.
TRACKING_NUMBERS	Shipment tracking numbers.
TXN_DATE	Invoice transaction date.
TXN_ID	Internal transaction identifier.
TXN_NO	Transaction number (alternate internal reference).
TYPE_ID	Invoice type identifier.
UNPOST_TRANS_FLAG	Flag indicating unposted transaction.
VAS_TOTAL	Value-added services total amount.
WAVE_NUMBERS	Fulfillment wave numbers.
WEIGHT	Total shipment weight.
WEIGHT_UOM_CODE	Weight unit of measure code (upper).
WEIGHT_UOM_NAME	Weight unit of measure name.

VW_INVOICE_ITEM_LINE_DETAIL

Column Name	Description
ACCNT_NUMBER	Customer's internal account identifier
ACCOUNT_3PL_CODE	Third-party logistics provider code
ACCOUNT_3PL_ID	Third-party logistics provider unique ID
ACCOUNT_3PL_NAME	Third-party logistics provider name
ACCOUNT_3PL_TYPE_ID	Type/category of 3PL account
ACCOUNT_NAME	Customer or business account name
ALTERNATIVE_ITEM_NUMBER1	First alternate product identifier
ALTERNATIVE_ITEM_NUMBER2	Second alternate product identifier
ALTERNATIVE_ITEM_NUMBER3	Third alternate product identifier
AMOUNT_DUE	Outstanding amount customer must pay
AMOUNT_PAID	Amount already paid toward invoice
BASE_QTY_ORDERED	Ordered quantity in base unit
BASE_QTY_REMAINING_TO_SHIP	Remaining quantity yet to ship in the base unit of measure
BASE_QTY_SHIPPED	Quantity shipped in the base unit of measure
BASE_UOM_CODE	Code for base unit of measure
BASE_UOM_ID	ID for base unit of measure
BASE_UOM_NAME	Name of base unit of measure
BILL_TO_ADDR	Billing street address
BILL_TO_ADDR_NAME	Billing address display name
BILL_TO_ADDR2	Additional billing address line
BILL_TO_CITY	Billing city
BILL_TO_COMPANY_NAME	Billing company name
BILL_TO_COUNTRY	Billing country
BILL_TO_EMAIL	Billing contact email
BILL_TO_FIRST_NAME	Billing contact first name
BILL_TO_LAST_NAME	Billing contact last name
BILL_TO_PHONE_NUMBER	Billing contact phone number
BILL_TO_STATE	Billing state or province
BILL_TO_ZIP_POSTAL_CODE	Billing postal or ZIP code
BOL_NUMBER	Bill of Lading number
BRAND_NAME	Product or item brand
CARRIER_CODE	Shipping carrier code
CARRIER_NAME	Shipping carrier name
CHARGE_CODE	Applied charge code
CONTAINER_REF_NUMBER	Container reference identifier
CONTRACT_LINE_TYPE_ID	Contract line classification
CONTRACT_NUMBER	Associated contract number
CREATE_DTTM	Record creation date and time
CREATE_SOURCE	System or process that created record
CREDIT_APPLIED	Credit amount applied to invoice
CURRENCY_CODE	Currency code (USD, EUR, etc.)
CURRENCY_ID	Internal currency identifier
CURRENCY_NAME	Currency name
CURRENCY_SYMBOL	Currency symbol
CUSTOMER_ACCOUNT_NUMBER	Customer's account reference number
CUSTOMER_FULL_NAME	Customer's full name
CUSTOMER_ID	Customer unique identifier
CUSTOMER_ITEM_NUMBER	Customer-specific item number
CUSTOMER_MESSAGE	Message or note from customer
CUSTOMER_NAME	Customer's display or business name
CUSTOMER_PO	Customer purchase order number
CUSTOMER_SERVICE_REP_EMAIL	Customer service rep email
CUSTOMER_SERVICE_REP_FULL_NAME	Customer service rep name
CUSTOMER_SERVICE_REP_ID	Customer service rep ID
CUSTOMER_TAX_CODE_ID	Customer's assigned tax code
DATE_ORDER	Date the order was placed
DATE_TO_BE_SHIPPED	Requested ship date
DECIMAL_FLAG	Indicates decimal-based quantity usage
DEFAULT_BILLING_EMAIL	Primary billing email address
DEPOSIT_APPLIED	Deposit amount applied
DESCRIPTION	Item or transaction description
DETAIL_CUSTOM_FIELD_VALUE1 - 50	Custom detail field value 1 to 50.
DISCOUNT	Discount applied to the line
DISCOUNT_AMOUNT	Total discount amount
DISCOUNT_APPLIED	Discount actually given
DISCOUNT_DATE	Date when discount becomes valid
DISCOUNT_DAYS	Number of days discount is eligible
DISCOUNT_FACTOR	Formula factor used for discount
DISCOUNT_PER_QTY	Discount amount per unit
DISCOUNT_PER_QTY_PERCENTAGE	Percentage discount per unit
DISCOUNT_PERCENTAGE	Discount percentage for the line
DISCOUNT_TYPE_ID	Discount type identifier
DISCOUNTABLE_TOTAL	Amount eligible for discount
DROPSHIP_TYPE_ID	Type of dropship arrangement
DUE_DATE	Date payment is due
DUE_DAYS	Number of due days allowed
EFFECTIVE_UNIT_PRICE	Final unit price after adjustments
EMAIL_MAIN	Main contact email
EXCHANGE_RATE	Currency exchange rate applied
FOB_POINT_NAME	Shipping FOB point
FULL_PAYMENT_DATE	Date when invoice was fully paid
GENDER_CODE	Gender classification of customer/product
GL_CODE_NAME	General ledger code name
GROUP_NAME	Assigned group name
HAS_RESTRICTION_FLAG	Indicates restrictions on selling/shipping
HEADER_CUSTOM_FIELD_VALUE1 - 50	Custom header field value 1
HEADER_TOTAL_AMOUNT	Total amount for the entire document/header
HS_CODE	Harmonized system code for item classification
HS_CODE_NAME	Description of the HS code
ID	Internal identifier for the record
INVOICE_BATCH_ID	Batch ID associated with invoices
INVOICE_BATCH_NUMBER	Batch number assigned to the invoice batch
INVOICE_ID	Unique identifier for the invoice
INVOICE_NUMBER	The invoice's display/official number
IS_3PL_INVOICE_LINE	Indicates if the line is related to 3PL billing
IS_DROPSHIP_FLAG	Indicates if the order is dropshipped
IS_OVERDUE_STR	"Yes/No" text showing if payment is overdue
IS_TAXABLE_ON_SALE	Indicates if the item is taxable at sale
ISO_CODE_2	Two-letter country ISO code
ISO_COUNTRY_NAME	Country name based on ISO standards
ITEM_CATEGORY_NAME	Item's category name
ITEM_ID	Unique item identifier
ITEM_NUMBER	Item's SKU or product number
ITEM_SUB_CATEGORY_NAME	Item sub-category name
ITEM_TYPE_ID	Item type identifier
ITEM_TYPE_NAME	Name of the item type
ITEM_UPC	Item UPC barcode
JOB_SCHEDULE_RERUN_FLAG	Indicates if job should rerun
JOB_SCHEDULE_RERUN_FLAG_STR	"Yes/No" text for rerun flag
JOB_SCHEDULE_RUN_FLAG	Indicates if job should run
JOB_SCHEDULE_RUN_FLAG_STR	"Yes/No" text for run flag
LADING_QTY	Quantity listed on the bill of lading
LINE_JOB_SCHEDULE_RERUN_FLAG_STR	"Yes/No" rerun flag for line
LINE_JOB_SCHEDULE_RUN_FLAG	Indicates if line job runs
LINE_JOB_SCHEDULE_RUN_FLAG_STR	"Yes/No" text for line run flag
LINE_NUMBER	Line number in the document
LINE_STATUS_NAME	Status of the line
MASTER_BOL_NUMBER	Master bill of lading number
MASTER_TRACKING_NUMBER	Master tracking/shipment number
MATCHED_FLAG	Indicates whether the line has been matched or reconciled
MATCHED_FLAG_STR	"Yes/No" version of matched status
MATERIAL_NAME	Material or fabric name for the item
MAX_DISCOUNT_ALLOWED	Maximum discount permitted for the line
MEMO	Additional notes or comments
MODIFY_DTTM	Date and time the record was last updated
MODIFY_SOURCE	Source that performed the last update
NOTES	Extra notes related to the order or line
ORDER_UOM_CODE	Unit of measure code used for ordering
ORDER_UOM_NAME	Unit of measure name used for ordering
PACKING_SLIP_NUMBER	Packing slip number for the shipment
PAYMENT_TERM_NAME	Name of the payment terms
PERMISSION_GROUP_ID	Permission group used for approval or access
PRODUCT_CUSTOMIZATION_DATA_JSON	Custom product options in JSON format
PROJECT_CLASS_ID	Project classification identifier
PROJECT_CLASS_NAME	Name of the project class
QTY	Quantity for the line
QTY_ORDERED	Total quantity ordered
RECEIPT_ID	Receipt identifier
RECEIPT_LINE_ID	Receipt line identifier
RECEIPT_NUMBER	Receipt number
RECEIPT_QTY	Quantity received
REF_NO	Reference number provided by customer or system
RESTRICTION_OVERRIDE_FLAG	Indicates if restrictions were overridden
RESTRICTION_OVERRIDE_PRICE	Price applied when restriction override is used
RESTRICTION_OVERRIDE_USER	User who performed the restriction override
SALE_STORE_ADDR	Selling store address
SALE_STORE_ADDR_NAME	Selling store address name
SALE_STORE_ADDR2	Selling store address line 2
SALE_STORE_CITY	Selling store city
SALE_STORE_CODE	Selling store code
SALE_STORE_COMPANY_NAME	Selling store company name
SALE_STORE_COUNTRY	Selling store country
SALE_STORE_EMAIL	Selling store email
SALE_STORE_FIRST_NAME	First name of store contact
SALE_STORE_LAST_NAME	Last name of store contact
SALE_STORE_NAME	Selling store name
SALE_STORE_PHONE_NUMBER	Selling store phone number
SALE_STORE_STATE	Selling store state
SALE_STORE_ZIP_POSTAL_CODE	Zip or postal code of the selling store
SALES_REP_EMAIL	Email address of the sales representative
SALES_REP_FULL_NAME	Full name of the sales representative
SALES_REP_ID	Unique identifier of the sales representative
SEASON_VALUES	Seasonal labels or values linked to the item or transaction
SELL_UOM_CODE	Code of the unit of measure used for selling
SELL_UOM_ID	Unique identifier of the selling unit of measure
SELL_UOM_NAME	Name of the selling unit of measure
SHIP_DATE	Date the order was shipped
SHIP_FROM_ADDR	Primary address line of the shipment origin
SHIP_FROM_ADDR_NAME	Name associated with the shipment origin address
SHIP_FROM_ADDR2	Second address line of the shipment origin
SHIP_FROM_CITY	City from where the shipment originates
SHIP_FROM_COMPANY_NAME	Company name at the shipment origin
SHIP_FROM_COUNTRY	Country from where the shipment originates
SHIP_FROM_EMAIL	Email of the shipment origin contact
SHIP_FROM_FIRST_NAME	First name of the shipment origin contact
SHIP_FROM_LAST_NAME	Last name of the shipment origin contact
SHIP_FROM_PHONE_NUMBER	Phone number of the shipment origin contact
SHIP_FROM_POSTAL_ZIP_CODE	Postal or zip code of the shipment origin
SHIP_FROM_STATE	State or region of the shipment origin
SHIP_METHOD_ID	Unique identifier of the shipping method
SHIP_METHOD_NAME	Name of the shipping method
SHIP_SERVICE_NAME	Name of the specific shipping service used
SHIP_TO_ADDR	Primary address line of the destination
SHIP_TO_ADDR_NAME	Name associated with the destination address
SHIP_TO_ADDR2	Second address line of the destination
SHIP_TO_CITY	Destination city
SHIP_TO_COMPANY_NAME	Company name at the destination
SHIP_TO_COUNTRY	Destination country
SHIP_TO_EMAIL	Email of the receiving contact
SHIP_TO_FIRST_NAME	First name of the receiving contact
SHIP_TO_INSTRUCTION_FIELD_1 TO 12	Ship instruction from field 1 to 50.
SHIP_TO_LAST_NAME	Last name of the receiving contact
SHIP_TO_PHONE_NUMBER	Phone number of the receiving contact
SHIP_TO_STATE	State or region of the destination
SHIP_TO_ZIP_POSTAL_CODE	Postal or zip code of the destination
SHIPMENT_REF_NUMBER	Shipment reference number
SHIPPING_ACCOUNT_NUMBER	Carrier account number used for shipping
SHIPPING_AMOUNT	Total shipping fee charged
SHIPPING_AMOUNT_CREDITED	Shipping amount refunded or credited
SHIPPING_COST	Actual shipping cost incurred
SHIPPING_COST_CARRIER	Cost charged by the shipping carrier
SHIPPING_TAX_CODE	Tax code applied to shipping charges
SHIPPING_TAX_CODE_NAME	Name of the shipping tax code
SHIPPING_TAX_DATA	Detailed tax information for shipping
SHIPPING_TERM_NAME	Shipping terms (e.g., prepaid, collect)
SHIPPING_TYPE_NAME	Type/category of shipping service
SO_ID	Internal sales order identifier
SO_LINE_ID	Internal sales order line identifier
SO_NUMBER	Sales order number
SO_REF_NO	Reference number for the sales order
SO_THIRD_PARTY_REF_NO	Third-party reference linked to the sales order
SSCC	Serialized shipping container code
STATUS_ID	Numeric identifier for the status
STATUS_NAME	Name of the order or line status
STORE_CODE	Store identification code
STORE_ID	Internal store identifier
STORE_NAME	Name of the store
SUB_TOTAL	Order subtotal before tax and other charges
SUB_TOTAL_EXCL_DISCOUNT	Subtotal before discounts
SYS_LOCK_FLAG	Indicates whether the record is locked by the system
TAGS	Tags or labels associated with the record
TAX_AMOUNT	Total tax applied
TAX_CODE_ID	Identifier of the tax code
TAX_CODE_NAME	Name of the tax code
TAX_DATA	Detailed tax breakdown
TAXABLE_FLAG	Indicates whether the item/order is taxable
THIRD_PARTY_DISPLAY_NAME	Display name of the associated third-party provider
THIRD_PARTY_ICON_URL	URL for the third-party provider's icon
THIRD_PARTY_REF_NO	Reference number from a third-party system
THIRD_PARTY_SOURCE	Name of the third-party source system
THIRD_PARTY_SOURCE_HEADER	Header reference from the third-party source
TITLE	Title or label associated with the record
TOTAL_AMOUNT	Final total amount including all charges
TOTAL_CREDIT_AMOUNT	Total credited monetary amount
TOTAL_CREDIT_QTY	Total credited quantity
TOTAL_LINE_COUNT	Number of lines associated with the record
TOTAL_QTY	Total quantity across all lines
TOTAL_TAX_AMOUNT	Total tax applied across all items
TRACKING_NUMBERS	Shipment tracking numbers
TXN_DATE	Transaction date
TXN_ID	Unique transaction identifier
TXN_NO	Transaction number
UNIT_COST	Cost per unit
UNIT_PRICE	Selling price per unit
UOM_FACTOR	Conversion factor between units of measure
UOM_TYPE_ID	Identifier for the unit of measure type
VAS_ITEM_COST	Value-added service item cost
VAS_ITEM_COST_TOTAL	Total cost for value-added service items
VAS_ITEM_ID	Identifier for the value-added service item
VAS_ITEM_NAME	Name of the value-added service item
WAVE_NUMBERS	Picking or shipping wave numbers
WEIGHT	Weight of the item or shipment
WEIGHT_UOM_CODE	Weight unit of measure code
WEIGHT_UOM_NAME	Weight unit of measure name

VW_ITEM_CURRENCY_PRICE_INFO_INC_HOME

Column Name	Description
ACTIVE_FLAG	Indicates whether the item is active
BASE_PART_NUMBER	Primary part number for the product
BRAND_NAME	Brand associated with the product
CARB	CARB compliance or classification information
CURRENCY_CODE	Code of the currency used for pricing
CURRENCY_ID	Identifier of the currency used
CUSTOM_PRICE_1 - 14	Custom price field 1 to 14
DESCRIPTION	Description of the item
EXPIRATION_DATE	Expiry date for the item
GROSS_PROFIT	Gross profit amount
GROSS_PROFIT_MARGIN	Gross profit margin percentage
GROUP_NAME	Group or category assigned to the item
HEIGHT	Height dimension of the item
HS_CODE	Harmonized system code for customs
ID	Unique identifier for the record
IS_HOME_CURRENCY	Indicates whether pricing uses the home currency
ISO_COUNTRY_NAME	ISO country name associated with the item
ITEM_CATEGORY_NAME	Category name for the item
ITEM_ID	Internal identifier of the item
ITEM_NUMBER	Item number or SKU
ITEM_UPC	UPC code of the item
LENGTH	Length dimension of the item
MARKUP_PERCENTAGE	Markup percentage applied
OVERHEAD_PERCENTAGE	Overhead cost percentage applied
PRICE_UOM_ID	Identifier for the pricing unit of measure
PRICE_UOM_NAME	Name of the pricing unit of measure
PRODUCT_HEADER_ID	Identifier for the product header/master
RAW_COST	Raw cost before adjustments
ROW_ID	Row identifier for the record
SEASON_VALUES	Seasonal attributes for the item
SELL_UOM_NAME	Selling unit of measure name
SHELF_LIFE	Shelf life duration
SIZE_UOM_NAME	Size unit of measure name
STANDARD_UNIT_COST	Standard unit cost
STANDARD_UNIT_PRICE	Standard unit price
TAGS	Tags or labels associated with the item
WARRANTY_TIME	Warranty duration
WARRANTY_UOM	Unit of measure for warranty duration
WEIGHT	Weight of the item
WEIGHT_UOM_NAME	Weight unit of measure name
WIDTH	Width dimension of the item

VW_ITEM_DETAIL

Column Name	Description
ACCOUNT_3PL_CODE	Code identifying the third-party logistics provider
ACCOUNT_3PL_DESC	Description of the third-party logistics account
ACCOUNT_3PL_ID	Identifier of the third-party logistics account
ACCOUNT_3PL_NAME	Name of the third-party logistics provider
ACTIVE_FLAG	Indicates whether the item is active
ACTIVE_FLAG_STR	Text version of the active status
ADJ_ACCNT_ID	Identifier of the adjustment account
ADJ_ACCOUNT_NAME	Name of the adjustment account
ALERT_NOTE	Warning or alert note for the item
ALLOW_BACKORDER_FLAG	Indicates whether backorders are allowed
ALTERNATIVE_ITEM_NUMBER1	First alternate item number
ALTERNATIVE_ITEM_NUMBER2	Second alternate item number
ALTERNATIVE_ITEM_NUMBER3	Third alternate item number
ASSET_ACCNT_ID	Identifier of the asset account
ASSET_ACCOUNT_NAME	Name of the asset account
BASE_PART_NUMBER	Main part number used as the base reference
BASE_UOM_CODE	Code of the base unit of measure
BASE_UOM_ID	Identifier of the base unit of measure
BASE_UOM_NAME	Name of the base unit of measure
BATCH_NUMBER_FLAG	Indicates whether batch numbering is used
BATCH_NUMBER_REQUIRED_FLAG	Indicates whether batch numbering is required
BODY_HTML	HTML description of the item
BOM_JSON	Components of the item in JSON format
BRAND_ID	Identifier of the brand
BRAND_NAME	Name of the brand
CARB	CARB regulatory information
CATEGORY_ID	Identifier of the item category
COGS_ACCNT_ID	Identifier of the cost-of-goods-sold account
COGS_ACCOUNT_NAME	Name of the cost-of-goods-sold account
COO_CODE_ISO_2	Two-letter country-of-origin code
CREATE_DTTM	Date and time when the record was created
CREATE_SOURCE	Source that created the record
CUBIC_CAPACITY_UOM_CODE	Code of the cubic capacity unit
CUBIC_CAPACITY_UOM_ID	Identifier of the cubic capacity unit
CUBIC_CAPACITY_UOM_NAME	Name of the cubic capacity unit
CUBIC_METERS	Volume in cubic meters
CUSTOM_DESCRIPTION	Custom item description
CUSTOM_FIELD_VALUE1 - 50	Custom user-defined field from 1 to 50.
CUSTOM_PRICE_1 - 14	Custom price field 1 to 14.
CUSTOM_PRICE_FORMULA	Formula for calculating custom price
CUSTOM_PRICE_FORMULA_PROFILE_ID	Identifier for the price formula profile
CUSTOM_PRICE_FORMULA_PROFILE_NAME	Name of the price formula profile
DEFAULT_LOCATION_CLASS_NAME	Default location class name
DEFAULT_LOCATION_ID	Identifier for default location
DEFAULT_LOCATION_NAME	Name of default location
DEFAULT_STORE_ID	Identifier of the default store
DEFAULT_STORE_NAME	Name of the default store
DEFAULT_VENDOR_ID	Identifier of the default vendor
DESCRIPTION	Item description
DISCONTINUED_DATE	Date when the item was discontinued
DROP_SHIP_ITEM_FLAG	Indicates if item is for drop ship
DROP_SHIP_ITEM_FLAG_STR	Text version of drop ship flag
EXP_DATE_REQUIRED_FLAG	Indicates if expiration date is required
EXPENSE_ACCNT_ID	Identifier of the expense account
EXPENSE_ACCOUNT_NAME	Name of the expense account
EXPIRATION_DATE	Expiration date of the item
EXPIRY_DATE_FLAG	Flag indicating if expiry date is tracked
FORCE_SALES_TAX_CODE	Sales tax code to enforce
FORCE_SALES_TAX_CODE_STR	Text version of sales tax code
GENDER_CODE	Gender code applicable to item
GROUP_ID	Identifier of the item group
GROUP_NAME	Name of the item group
HANDLE	Item handle or unique identifier string
HAS_MULTI_CUR_PRICE	Indicates if multiple currency prices exist
14HAZMAT_CODE	Hazardous material code
HAZMAT_ID	Identifier of hazardous material
HAZMAT_NAME	Name of hazardous material
HEIGHT	Height of the item
HS_CODE	Harmonized System code for customs
HS_CODE_ID	Identifier for HS code
ID	Unique identifier for the item
IMAGE_PATH	File path of the item image
IMAGE_SRC	Source of the item image
IMAGE_URLS	URLs of item images
INCOME_ACCNT_ID	Identifier of income account
INCOME_ACCOUNT_NAME	Name of income account
INCOME_RETURN_ACCNT_ID	Identifier of income return account
INCOME_RETURN_ACCOUNT_NAME	Name of income return account
INNER_CASE_QTY	Quantity in inner case
INNER_CASE_UPC	UPC code for inner case
INTERNAL_NOTES	Internal notes about the item
IS_3A_ITEM	Indicates if item is 3A
IS_BOM_CREATED_STR	Text indicating if BOM is created
IS_BOM_ITEM_FLAG	Flag indicating BOM item
IS_BOM_ITEM_FLAG_STR	Text version of BOM item flag
IS_CUSTOMIZATION_MANDATORY	Indicates if customization is mandatory
IS_MULTIBOX	Indicates if item is multibox
IS_PRE_SELL_FLAG	Indicates if item is pre-sell
IS_PRE_SELL_FLAG_STR	Text version of pre-sell flag
IS_PRODUCIBLE_FLAG	Indicates if item can be produced
IS_PRODUCIBLE_FLAG_STR	Text version of producible flag
IS_PURCHASABLE_FLAG	Indicates if item can be purchased
IS_PURCHASABLE_FLAG_STR	Text version of purchasable flag
IS_RAW_MATERIAL_FLAG	Indicates if item is raw material
IS_RAW_MATERIAL_FLAG_STR	Text version of raw material flag
IS_RESTRICT_TO_PURCHASE_FLAG	Restriction flag for purchase
IS_RESTRICT_TO_PURCHASE_FLAG_STR	Text version of purchase restriction
IS_SELLABLE_FLAG	Indicates if item is sellable
IS_SELLABLE_FLAG_STR	Text version of sellable flag
IS_STOCKING_ITEM_FLAG	Indicates if item is stocked
IS_TAXABLE_ON_PURCHASE	Indicates if item is taxable on purchase
IS_TAXABLE_ON_SALE	Indicates if item is taxable on sale
IS_TRANSFERABLE_FLAG	Indicates if item is transferable
IS_TRANSFERABLE_FLAG_STR	Text version of transferable flag
ISO_COUNTRY_NAME	ISO country name
ITEM_BARCODE	Item barcode
ITEM_CATEGORY_NAME	Name of item category
ITEM_GTIN	Global Trade Item Number
ITEM_ID	Unique identifier for item
ITEM_NUMBER	Item number
ITEM_PRODUCT_CATEGORY_NAME	Name of product category
ITEM_TRACKING_TYPE_ID	Identifier for tracking type
ITEM_TRACKING_TYPE_NAME	Name of tracking type
ITEM_TYPE_ID	Identifier of item type
ITEM_TYPE_NAME	Name of item type
ITEM_UPC	Universal Product Code
ITEM_VENDOR_DISCOUNT	Vendor discount for item
ITEM_VENDOR_LEAD_TIME_DAYS	Vendor lead time in days
ITEM_VENDOR_LIST_PRICE	Vendor list price
LAST_ACTIVITY_DTTM	Date/time of last activity
LAST_COUNTED_BY	User who last counted item
LAST_COUNTED_DTTM	Date/time item was last counted
LAST_LANDED_UNIT_COST	Last landed unit cost
LAST_LANDED_UNIT_COST_HOME_CURRENCY	Last landed cost in home currency
LAST_PURCHASED_QTY	Last purchased quantity
LAST_RECEIPT_CURRENCY_CODE	Currency code of last receipt
LAST_RECEIPT_DATE	Date of last receipt
LAST_RECEIPT_RECONCILE_FLAG	Flag for last receipt reconciliation
LAST_UNIT_COST	Last unit cost
LAUNCH_DATE	Item launch date
LENGTH	Length of item
LOT_NUMBER_FLAG	Indicates if lot number is used
LOT_NUMBER_REQUIRED_FLAG	Indicates if lot number is required
MANUFACTURE_DATE_FLAG	Indicates if manufacture date is used
MANUFACTURE_DATE_REQUIRED_FLAG	Indicates if manufacture date is required
MANUFACTURER	Manufacturer name
MANUFACTURER_ID	Manufacturer identifier
MASTER_CASE_QTY	Quantity per master case
MASTER_CASE_UPC	UPC of master case
MATERIAL_ID	Identifier of material
MATERIAL_NAME	Name of material
MID	Material identifier
MINIMUM_SELL_QTY	Minimum quantity to sell
MODIFY_DTTM	Last modification date/time
MODIFY_SOURCE	Source of modification
MULTIPLE_UOM_FLAG	Indicates multiple UOMs exist
NEEDS_TRACKING_FLAG	Indicates if item requires tracking
NOTES_TO_VENDOR	Notes for vendor
OPTION_1_CODE	Code for option 1
OPTION_1_NAME	Name for option 1
OPTION_1_SEQ	Sequence of option 1
OPTION_1_VALUE	Value of option 1
OPTION_2_CODE	Code for option 2
OPTION_2_NAME	Name for option 2
OPTION_2_SEQ	Sequence of option 2
OPTION_2_VALUE	Value of option 2
OPTION_3_CODE	Code for option 3
OPTION_3_NAME	Name for option 3
OPTION_3_SEQ	Sequence of option 3
OPTION_3_VALUE	Value of option 3
OPTION1_VALUE_ID	Identifier for option 1 value
OPTION2_VALUE_ID	Identifier for option 2 value
OPTION3_VALUE_ID	Identifier for option 3 value
PRODUCT_CATEGORY_ID	Identifier of product category
PRODUCT_CUSTOMIZATION_PROFILE_ID	Profile ID for customization
PRODUCT_CUSTOMIZATION_VAS_COST	Cost of customization VAS
PRODUCT_CUSTOMIZATION_VAS_ID	Identifier for customization VAS
PRODUCT_DEFAULT_IMAGE_URL	Default image URL for product
PRODUCT_HEADER_ID	Product header identifier
PRODUCT_IMAGE_ID	Product image identifier
PRODUCT_TAGS	Tags associated with product
PROJECT_CLASS_ID	Project class identifier
PROJECT_CLASS_NAME	Project class name
PURCHASE_NOTES	Notes for purchase
PURCHASE_TAX_CODE	Tax code for purchase
PURCHASE_TAX_CODE_ID	Identifier for purchase tax code
PURCHASE_TAX_CODE_NAME	Name of purchase tax code
PURCHASE_UOM_CODE	Unit of measure code for purchase
PURCHASE_UOM_ID	Identifier for purchase unit of measure
PURCHASE_UOM_NAME	Name of purchase unit of measure
QTY_DECIMAL_FLAG	Indicates if quantity can be decimal
QUALITY_FLAG	Indicates quality status
QUALITY_REQUIRED_FLAG	Indicates if quality check is required
RE_ORDER_POINT_QTY	Quantity at which reorder is triggered
RE_ORDER_QTY	Quantity to reorder
READONLY_FLAG	Indicates if field/item is read-only
RESTOCKING_FEE_PERCENTAGE	Percentage of restocking fee
RETURNABLE_FLAG	Indicates if item is returnable
RETURNABLE_FLAG_STR	Text version of returnable flag
SALE_TAX_CODE	Sales tax code
SALE_TAX_CODE_NAME	Name of sales tax code
SALES_NOTES	Notes related to sales
SALES_TAX_CODE_ID	Identifier of sales tax code
SCRAP_ACCNT_ID	Identifier for scrap account
SCRAP_ACCOUNT_NAME	Name of scrap account
SEARCH_KEYWORDS	Keywords for search
SEASON_VALUES	Applicable season values
SELL_PKG_QTY	Quantity per selling package
SELL_UOM_CODE	Selling unit of measure code
SELL_UOM_ID	Identifier for selling unit of measure
SELL_UOM_NAME	Name of selling unit of measure
SHELF_LIFE	Shelf life of item
SIZE_UOM_CODE	Unit of measure code for size
SIZE_UOM_ID	Identifier for size unit of measure
SIZE_UOM_NAME	Name of size unit of measure
SORT_ORDER	Sorting order for item
STANDARD_UNIT_COST	Standard unit cost
STANDARD_UNIT_PRICE	Standard unit price
SUB_CATEGORY_CODE	Sub-category code
SUB_CATEGORY_ID	Sub-category identifier
SUB_CATEGORY_NAME	Sub-category name
TAGS	Tags associated with item
TAX_CATEGORY_CODE	Tax category code
TAX_STATE_MAPPING_PROFILE_ID	Identifier for tax state mapping profile
TAX_STATE_MAPPING_PROFILE_NAME	Name of tax state mapping profile
THIRD_PARTY_DISPLAY_NAME	Third party display name
THIRD_PARTY_ICON_URL	URL of third party icon
THIRD_PARTY_REF_NO	Third party reference number
THIRD_PARTY_SOURCE	Source of third party data
TITLE	Item title
TRACKING_BY_SERIAL_NUMBER_FLAG	Indicates if tracked by serial number
TRACKING_BY_SERIAL_NUMBER_FLAG_STR	Text version of serial number tracking flag
UNIQUE_ID	Unique identifier for getting the item type (using for misc item only)
USE_IMAGE_FOR_PRODUCT_PREVIEW_FLAG	Flag to use image for preview
USE_IMAGE_FOR_PRODUCT_PREVIEW_FLAG_STR	Text version of preview image flag
VELOCITY_CODE_ID	Identifier for velocity code
VENDOR_NAME	Vendor name
VENDOR_PART_NUMBR	Vendor part number
WARRANTY_TIME	Warranty period
WARRANTY_UOM	Unit of measure for warranty
WEB_URL	Product web URL
WEIGHT	Weight of item
WEIGHT_UOM_CODE	Weight unit of measure code
WEIGHT_UOM_ID	Weight unit of measure identifier
WEIGHT_UOM_NAME	Name of weight unit of measure
WIDTH	Width of item
WIP_ACCNT_ID	Identifier for work-in-progress account
WIP_ACCOUNT_NAME	Name of work-in-progress account

VW_ITEM_DETAIL_EXT

Column Name	Description
ACCOUNT_3PL_CODE	Code identifying the third-party logistics provider
ACCOUNT_3PL_DESC	Description of the third-party logistics account
ACCOUNT_3PL_ID	Identifier of the third-party logistics account
ACCOUNT_3PL_NAME	Name of the third-party logistics provider
ACTIVE_FLAG	Indicates whether the item is active
ACTIVE_FLAG_STR	Text version of the active status
ADJ_ACCNT_ID	Identifier of the adjustment account
ADJ_ACCOUNT_NAME	Name of the adjustment account
ALERT_NOTE	Warning or alert note for the item
ALLOW_BACKORDER_FLAG	Indicates whether backorders are allowed
ALTERNATIVE_ITEM_NUMBER1	First alternate item number
ALTERNATIVE_ITEM_NUMBER2	Second alternate item number
ALTERNATIVE_ITEM_NUMBER3	Third alternate item number
ASSET_ACCNT_ID	Identifier of the asset account
ASSET_ACCOUNT_NAME	Name of the asset account
BASE_PART_NUMBER	Main part number used as the base reference
BASE_UOM_CODE	Code of the base unit of measure
BASE_UOM_ID	Identifier of the base unit of measure
BASE_UOM_NAME	Name of the base unit of measure
BATCH_NUMBER_FLAG	Indicates whether batch numbering is used
BATCH_NUMBER_REQUIRED_FLAG	Indicates whether batch numbering is required
BODY_HTML	HTML description of the item
BOM_JSON	Components of the item in JSON format
BRAND_ID	Identifier of the brand
BRAND_NAME	Name of the brand
CARB	CARB regulatory information
CATEGORY_ID	Identifier of the item category
COGS_ACCNT_ID	Identifier of the cost-of-goods-sold account
COGS_ACCOUNT_NAME	Name of the cost-of-goods-sold account
COO_CODE_ISO_2	Two-letter country-of-origin code
CREATE_DTTM	Date and time when the record was created
CREATE_SOURCE	Source that created the record
CUBIC_CAPACITY_UOM_CODE	Code of the cubic capacity unit
CUBIC_CAPACITY_UOM_ID	Identifier of the cubic capacity unit
CUBIC_CAPACITY_UOM_NAME	Name of the cubic capacity unit
CUBIC_METERS	Volume in cubic meters
CUSTOM_DESCRIPTION	Custom item description
CUSTOM_FIELD_VALUE1 - 50	Custom user-defined field from 1to 50.
CUSTOM_PRICE_1 - 14	Custom price field 1 to 14.
CUSTOM_PRICE_FORMULA	Formula for calculating custom price
CUSTOM_PRICE_FORMULA_PROFILE_ID	Identifier for the price formula profile
CUSTOM_PRICE_FORMULA_PROFILE_NAME	Name of the price formula profile
DEFAULT_LOCATION_CLASS_NAME	Default location class name
DEFAULT_LOCATION_ID	Identifier for default location
DEFAULT_LOCATION_NAME	Name of default location
DEFAULT_STORE_ID	Identifier of the default store
DEFAULT_STORE_NAME	Name of the default store
DEFAULT_VENDOR_ID	Identifier of the default vendor
DESCRIPTION	Item description
DISCONTINUED_DATE	Date when the item was discontinued
DROP_SHIP_ITEM_FLAG	Indicates if item is for drop ship
DROP_SHIP_ITEM_FLAG_STR	Text version of drop ship flag
EXP_DATE_REQUIRED_FLAG	Indicates if expiration date is required
EXPENSE_ACCNT_ID	Identifier of the expense account
EXPENSE_ACCOUNT_NAME	Name of the expense account
EXPIRATION_DATE	Expiration date of the item
EXPIRY_DATE_FLAG	Flag indicating if expiry date is tracked
FORCE_SALES_TAX_CODE	Sales tax code to enforce
FORCE_SALES_TAX_CODE_STR	Text version of sales tax code
GENDER_CODE	Gender code applicable to item
GROUP_ID	Identifier of the item group
GROUP_NAME	Name of the item group
HANDLE	Item handle or unique identifier string
HAS_MULTI_CUR_PRICE	Indicates if multiple currency prices exist
HAZMAT_CODE	Hazardous material code
HAZMAT_ID	Identifier of hazardous material
HAZMAT_NAME	Name of hazardous material
HEIGHT	Height of the item
HS_CODE	Harmonized System code for customs
HS_CODE_ID	Identifier for HS code
ID	Unique identifier for the item
IMAGE_PATH	File path of the item image
IMAGE_SRC	Source of the item image
IMAGE_URLS	URLs of item images
INCOME_ACCNT_ID	Identifier of income account
INCOME_ACCOUNT_NAME	Name of income account
INCOME_RETURN_ACCNT_ID	Identifier of income return account
INCOME_RETURN_ACCOUNT_NAME	Name of income return account
INNER_CASE_QTY	Quantity in inner case
INNER_CASE_UPC	UPC code for inner case
INTERNAL_NOTES	Internal notes about the item
IS_3A_ITEM	Indicates if item is 3A
IS_BOM_CREATED_STR	Text indicating if BOM is created
IS_BOM_ITEM_FLAG	Flag indicating BOM item
IS_BOM_ITEM_FLAG_STR	Text version of BOM item flag
IS_CUSTOMIZATION_MANDATORY	Indicates if customization is mandatory
IS_MULTIBOX	Indicates if item is multibox
IS_PRE_SELL_FLAG	Indicates if item is pre-sell
IS_PRE_SELL_FLAG_STR	Text version of pre-sell flag
IS_PRODUCIBLE_FLAG	Indicates if item can be produced
IS_PRODUCIBLE_FLAG_STR	Text version of producible flag
IS_PURCHASABLE_FLAG	Indicates if item can be purchased
IS_PURCHASABLE_FLAG_STR	Text version of purchasable flag
IS_RAW_MATERIAL_FLAG	Indicates if item is raw material
IS_RAW_MATERIAL_FLAG_STR	Text version of raw material flag
IS_RESTRICT_TO_PURCHASE_FLAG	Restriction flag for purchase
IS_RESTRICT_TO_PURCHASE_FLAG_STR	Text version of purchase restriction
IS_SELLABLE_FLAG	Indicates if item is sellable
IS_SELLABLE_FLAG_STR	Text version of sellable flag
IS_STOCKING_ITEM_FLAG	Indicates if item is stocked
IS_TAXABLE_ON_PURCHASE	Indicates if item is taxable on purchase
IS_TAXABLE_ON_SALE	Indicates if item is taxable on sale
IS_TRANSFERABLE_FLAG	Indicates if item is transferable
IS_TRANSFERABLE_FLAG_STR	Text version of transferable flag
ISO_COUNTRY_NAME	ISO country name
ITEM_BARCODE	Item barcode
ITEM_CATEGORY_NAME	Name of item category
ITEM_GTIN	Global Trade Item Number
ITEM_ID	Unique identifier for item
ITEM_NUMBER	Item number
ITEM_PRODUCT_CATEGORY_NAME	Name of product category
ITEM_TRACKING_TYPE_ID	Identifier for tracking type
ITEM_TRACKING_TYPE_NAME	Name of tracking type
ITEM_TYPE_ID	Identifier of item type
ITEM_TYPE_NAME	Name of item type
ITEM_UPC	Universal Product Code
ITEM_VENDOR_DISCOUNT	Vendor discount for item
ITEM_VENDOR_LEAD_TIME_DAYS	Vendor lead time in days
ITEM_VENDOR_LIST_PRICE	Vendor list price
LAST_ACTIVITY_DTTM	Date/time of last activity
LAST_COUNTED_BY	User who last counted item
LAST_COUNTED_DTTM	Date/time item was last counted
LAST_LANDED_UNIT_COST	Last landed unit cost
LAST_LANDED_UNIT_COST_HOME_CURRENCY	Last landed cost in home currency
LAST_PURCHASED_QTY	Last purchased quantity
LAST_RECEIPT_CURRENCY_CODE	Currency code of last receipt
LAST_RECEIPT_DATE	Date of last receipt
LAST_RECEIPT_RECONCILE_FLAG	Flag for last receipt reconciliation
LAST_UNIT_COST	Last unit cost
LAUNCH_DATE	Item launch date
LENGTH	Length of item
LOT_NUMBER_FLAG	Indicates if lot number is used
LOT_NUMBER_REQUIRED_FLAG	Indicates if lot number is required
MANUFACTURE_DATE_FLAG	Indicates if manufacture date is used
MANUFACTURE_DATE_REQUIRED_FLAG	Indicates if manufacture date is required
MANUFACTURER	Manufacturer name
MANUFACTURER_ID	Manufacturer identifier
MASTER_CASE_QTY	Quantity per master case
MASTER_CASE_UPC	UPC of master case
MATERIAL_ID	Identifier of material
MATERIAL_NAME	Name of material
MID	Material identifier
MINIMUM_SELL_QTY	Minimum quantity to sell
MODIFY_DTTM	Last modification date/time
MODIFY_SOURCE	Source of modification
MULTIPLE_UOM_FLAG	Indicates multiple UOMs exist
NEEDS_TRACKING_FLAG	Indicates if item requires tracking
NOTES_TO_VENDOR	Notes for vendor
OPTION_1_CODE	Code for option 1
OPTION_1_NAME	Name for option 1
OPTION_1_SEQ	Sequence of option 1
OPTION_1_VALUE	Value of option 1
OPTION_2_CODE	Code for option 2
OPTION_2_NAME	Name for option 2
OPTION_2_SEQ	Sequence of option 2
OPTION_2_VALUE	Value of option 2
OPTION_3_CODE	Code for option 3
OPTION_3_NAME	Name for option 3
OPTION_3_SEQ	Sequence of option 3
OPTION_3_VALUE	Value of option 3
OPTION1_VALUE_ID	Identifier for option 1 value
OPTION2_VALUE_ID	Identifier for option 2 value
OPTION3_VALUE_ID	Identifier for option 3 value
PRODUCT_CATEGORY_ID	Identifier of product category
PRODUCT_CUSTOMIZATION_PROFILE_ID	Profile ID for customization
PRODUCT_CUSTOMIZATION_VAS_COST	Cost of customization VAS
PRODUCT_CUSTOMIZATION_VAS_ID	Identifier for customization VAS
PRODUCT_DEFAULT_IMAGE_URL	Default image URL for product
PRODUCT_HEADER_ID	Product header identifier
PRODUCT_IMAGE_ID	Product image identifier
PRODUCT_TAGS	Tags associated with product
PROJECT_CLASS_ID	Project class identifier
PROJECT_CLASS_NAME	Project class name
PURCHASE_NOTES	Notes for purchase
PURCHASE_TAX_CODE	Tax code for purchase
PURCHASE_TAX_CODE_ID	Identifier for purchase tax code
PURCHASE_TAX_CODE_NAME	Name of purchase tax code
PURCHASE_UOM_CODE	Unit of measure code for purchase
PURCHASE_UOM_ID	Identifier for purchase unit of measure
PURCHASE_UOM_NAME	Name of purchase unit of measure
QTY_DECIMAL_FLAG	Indicates if quantity can be decimal
QUALITY_FLAG	Indicates quality status
QUALITY_REQUIRED_FLAG	Indicates if quality check is required
RE_ORDER_POINT_QTY	Quantity at which reorder is triggered
RE_ORDER_QTY	Quantity to reorder
READONLY_FLAG	Indicates if field/item is read-only
RESTOCKING_FEE_PERCENTAGE	Percentage of restocking fee
RETURNABLE_FLAG	Indicates if item is returnable
RETURNABLE_FLAG_STR	Text version of returnable flag
SALE_TAX_CODE	Sales tax code
SALE_TAX_CODE_NAME	Name of sales tax code
SALES_NOTES	Notes related to sales
SALES_TAX_CODE_ID	Identifier of sales tax code
SCRAP_ACCNT_ID	Identifier for scrap account
SCRAP_ACCOUNT_NAME	Name of scrap account
SEARCH_KEYWORDS	Keywords for search
SEASON_VALUES	Applicable season values
SELL_PKG_QTY	Quantity per selling package
SELL_UOM_CODE	Selling unit of measure code
SELL_UOM_ID	Identifier for selling unit of measure
SELL_UOM_NAME	Name of selling unit of measure
SHELF_LIFE	Shelf life of item
SIZE_UOM_CODE	Unit of measure code for size
SIZE_UOM_ID	Identifier for size unit of measure
SIZE_UOM_NAME	Name of size unit of measure
SORT_ORDER	Sorting order for item
STANDARD_UNIT_COST	Standard unit cost
STANDARD_UNIT_PRICE	Standard unit price
SUB_CATEGORY_CODE	Sub-category code
SUB_CATEGORY_ID	Sub-category identifier
SUB_CATEGORY_NAME	Sub-category name
TAGS	Tags associated with item
TAX_CATEGORY_CODE	Tax category code
TAX_STATE_MAPPING_PROFILE_ID	Identifier for tax state mapping profile
TAX_STATE_MAPPING_PROFILE_NAME	Name of tax state mapping profile
THIRD_PARTY_DISPLAY_NAME	Third party display name
THIRD_PARTY_ICON_URL	URL of third party icon
THIRD_PARTY_REF_NO	Third party reference number
THIRD_PARTY_SOURCE	Source of third party data
TITLE	Item title
TRACKING_BY_SERIAL_NUMBER_FLAG	Indicates if tracked by serial number
TRACKING_BY_SERIAL_NUMBER_FLAG_STR	Text version of serial number tracking flag
UNIQUE_ID	Unique identifier
USE_IMAGE_FOR_PRODUCT_PREVIEW_FLAG	Flag to use image for preview
USE_IMAGE_FOR_PRODUCT_PREVIEW_FLAG_STR	Text version of preview image flag
VELOCITY_CODE_ID	Identifier for velocity code
VENDOR_NAME	Vendor name
VENDOR_PART_NUMBR	Vendor part number
WARRANTY_TIME	Warranty period
WARRANTY_UOM	Unit of measure for warranty
WEB_URL	Product web URL
WEIGHT	Weight of item
WEIGHT_UOM_CODE	Weight unit of measure code
WEIGHT_UOM_ID	Weight unit of measure identifier
WEIGHT_UOM_NAME	Name of weight unit of measure
WIDTH	Width of item
WIP_ACCNT_ID	Identifier for work-in-progress account
WIP_ACCOUNT_NAME	Name of work-in-progress account
TOTAL_AMOUNT	Total amount for the transaction
TOTAL_QTY	Total quantity for the transaction
AVG_COST	Average cost of the items
LAST_INVOICE_DATE	Date of the last invoice
LAST_INVOICE_DAYS_SINCE	Days since the last invoice
LAST_INVOICE_MONTH_SINCE	Months since the last invoice
LAST_QTY_SOLD	Quantity sold in the last invoice

VW_ITEM_PRODUCT_HEADER_INFO

Column Name	Description
ACTIVE_FLAG	Indicates if the item is active
ACTIVE_FLAG_STR	String representation of the active flag
BASE_PART_NUMBER	Base part number of the product
BODY_HTML	HTML content for item description or details
CREATE_DTTM	Date and time the record was created
CREATE_SOURCE	Source from which the record was created
DEFAULT_IMAGE_SRC	Default image source URL for the product
DEFAULT_ITEM_ID	Identifier for the default item
GENERATE_VARIANTS_CONFIG_JSON	JSON configuration for generating variants
HANDLE	Unique handle or slug for the product
ID	Unique identifier for the product
IS_VARIANT_CONFIG_JSON_EXISTS	Flag indicating if variant config JSON exists
MINIMUM_SELL_QTY	Minimum quantity allowed for sale
MODIFY_DTTM	Date and time the record was last modified
MODIFY_SOURCE	Source of the last modification
OPTION1_ID	Identifier for option 1
OPTION1_NAME	Name of option 1
OPTION1_VALUE_CODES	Codes for option 1 values
OPTION1_VALUES	List of values for option 1
OPTION2_ID	Identifier for option 2
OPTION2_NAME	Name of option 2
OPTION2_VALUE_CODES	Codes for option 2 values
OPTION2_VALUES	List of values for option 2
OPTION3_ID	Identifier for option 3
OPTION3_NAME	Name of option 3
OPTION3_VALUE_CODES	Codes for option 3 values
OPTION3_VALUES	List of values for option 3
PRODUCT_CATEGORY_ID	Identifier for the product category
PRODUCT_CATEGORY_NAME	Name of the product category
PRODUCT_CUSTOMIZATION_PROFILE_ID	Identifier for the product customization profile
PRODUCT_CUSTOMIZATION_PROFILE_NAME	Name of the product customization profile
PRODUCT_IMAGE	Image of the product
PRODUCT_TAGS	Tags associated with the product
PURCHASE_RATIO_JSON	JSON containing purchase ratio details
SEASONS	Applicable seasons for the product
TITLE	Title or name of the product

VW_ITEM_REORDER_POINTQTY_INFO

Column Name	Description
ID	Unique identifier for the reorder quantity linking record.
ITEM_ID	Identifier of the item associated with reorder quantities.
STORE_ID	Store identifier linked to this reorder configuration.
RE_ORDER_POINT_QTY	Quantity threshold at which the item needs to be reordered.
RE_ORDER_QTY	Quantity to reorder once the reorder point is reached.
STORE_NAME	Name of the store.
ITEM_NUMBER	Item number from the item master.
STORE_CODE	Code representing the store.

VW_ITEM_VENDOR_MAP

Column Name	Description
ID	Unique identifier of the item–vendor mapping record.
ITEM_ID	Item identifier linked to the vendor.
VENDOR_NAME	Name of the vendor.
VENDOR_LIST_PRICE	Vendor’s list price for the item.
VENDOR_DISCOUNT_DISP	Vendor discount displayed as a percentage string.
VENDOR_PART_NUMBER	Vendor’s internal part number for the item.
LEAD_TIME_DAYS	Lead time required by the vendor in days.
ITEM_LIST_PRICE	Calculated price after applying vendor discount.
ITEM_NUMBER	Item number from item master.
VENDOR_ID	Vendor identifier.
CREATE_DTTM	Timestamp when the mapping record was created.
CREATE_SOURCE	Source of record creation.
MODIFY_DTTM	Timestamp when the record was last modified.
MODIFY_SOURCE	Source of last modification.
VENDOR_DISCOUNT	Vendor discount percentage (numeric).
ACTIVE_FLAG	Indicates whether the mapping is active (0/1).
DEFAULT_FLAG	Indicates whether this vendor is the default vendor (0/1).
ACTIVE_FLAG_STR	“Y” or “N” form of the active flag.
DEFAULT_FLAG_STR	“Y” or “N” form of the default flag.
VENDOR_PART_DESCRIPTION	Description of the vendor part.
SELL_UOM_ID	Selling unit of measure ID.
SELL_UOM_CODE	Selling unit of measure code.
SELL_UOM_NAME	Selling unit of measure name.
PERMISSION_GROUP_ID	Permission group assigned to the vendor.
NOTES_TO_VENDOR	Notes associated with the vendor for this item.
INTERNAL_NOTES	Internal notes related to vendor–item mapping.
INVENTORY	Vendor inventory value or linked data.
VENDOR_CURRENCY_ID	Currency ID used by the vendor.
EXCHANGE_RATE	Exchange rate associated with the vendor’s currency.
CUSTOM_FIELD_VALUE1 … CUSTOM_FIELD_VALUE50	Custom field values 1–50 for flexible data storage.

VW_LOCATION_INVENTORY_ALLOCATION

Column Name	Description
ITEM_INVENTORY_ID	Unique identifier for this inventory record (from TBL_ITEM_INVENTORY).
STORE_ID	Store identifier.
LOCN_ID	Location identifier within the store.
ITEM_ID	Item identifier.
ON_HAND_QTY	Total inventory quantity, including Not Available, Available.
NOT_AVAILABLE_QTY	Quantity that is unavailable due to damage or being unsellable at the specific location.
AVAILABLE_QTY	Quantity available for use (On Hand - Not Available - Allocated ).
QTY_ALLOCATED	Quantity already allocated for picking/waves.
NET_AVAILABLE	Available quantity after subtracting allocations (Available - Allocated).
LAST_COUNTED_BY	The user who last completed the cycle count.
LAST_COUNTED_DTTM	Date and time of the last inventory count.
ITEM_NUMBER	Item number from master.
DESCRIPTION	Item description.
ITEM_BARCODE	Barcode of the item.
ITEM_UPC	UPC of the item.
BASE_PART_NUMBER	Base part number from product header.
BASE_UOM_ID	Base unit of measure ID.
BASE_UOM_NAME	Name of base unit of measure.
ALTERNATIVE_ITEM_NUMBER1	Alternative item number 1.
ALTERNATIVE_ITEM_NUMBER2	Alternative item number 2.
ALTERNATIVE_ITEM_NUMBER3	Alternative item number 3.
TAGS	Item tags/labels.
ALERT_NOTE	Notes for alerts/warnings.
SALES_NOTES	Notes for sales.
SELL_UOM_ID	Selling unit of measure ID.
IS_SELLABLE_FLAG	Boolean flag indicating if the item is sellable.
IS_BOM_ITEM_FLAG	Boolean flag indicating if the item is a BOM (Bill of Materials) item.
IS_RAW_MATERIAL_FLAG	Boolean flag for raw material.
IS_PURCHASABLE_FLAG	Boolean flag for purchasable item.
SELL_PKG_QTY	Quantity per selling package.
ACTIVE_FLAG	Boolean flag indicating active status.
STANDARD_UNIT_PRICE	Standard unit selling price.
STANDARD_UNIT_COST	Standard unit cost.
SEASON_VALUES	Season-related value or code.
CUSTOM_PRICE_1 … CUSTOM_PRICE_14	Custom pricing fields for flexibility.
IS_3A_ITEM	Boolean flag for 3A item classification.
ACCOUNT_3PL_ID	3PL account ID for this item.
GENDER_CODE	Gender classification code, if applicable.
ADJ_ACCNT_ID	Adjustment account ID.
DEFAULT_VENDOR_ID	Default vendor ID.
PRODUCT_HEADER_ID	Product header reference ID.
TITLE	Product title.
PRODUCT_CATEGORY_ID	Product category reference ID.
OPTION1_ID	Option 1 reference ID from product header.
OPTION2_ID	Option 2: reference ID from product header.
OPTION3_ID	Option 3: reference ID from product header.
OPTION1_VALUE_ID	Selected option 1 value ID.
OPTION2_VALUE_ID	Selected option 2 value ID.
OPTION3_VALUE_ID	Selected option 3 value ID.
GROUP_ID	Item group ID.
BRAND_ID	Item brand ID.
CATEGORY_ID	Item category ID.
SUB_CATEGORY_ID	Sub-category ID.
PRODUCT_IMAGE_ID	Reference ID for product image.
LOCN_BARCODE	Location barcode.
DISP_LOCN	Display the name of the location.
LOCN_CLASS_ID	Location class ID.
LOCATION_CLASS_NAME	Name of location class.
LOCN_TYPE_ID	Location type ID.
LOCATION_TYPE_NAME	Location type name.
LOCN_TYPE_NAME	Alias for location type name.
LPN_ID	LPN (License Plate Number) ID.
PICK_SEQ	Pick a sequence number.
AREA	Area of the warehouse.
AISLE	Aisle number.
BAY	Bay number.
LVL	Level or shelf number.
POSITION	Position within the shelf.
DEPTH	Depth of location.
LENGTH	Length of location.
WIDTH	Width of location.
HEIGHT	Height of location.
IS_VIRTUAL_LPN_LOCATION	Boolean flag if location is a virtual LPN.
IS_VIRTUAL_LPN	Boolean flag if LPN is virtual.
ZONE_ID	Zone identifier for the warehouse.
ZONE_NAME	Zone name.
LPN_NUMBER	LPN number.
MFG_DATE	Manufacturing date.
LOT_NUMBER	Lot number.
BATCH_NUMBER	Batch number.
PRIORITY_NUMBER	Picking priority.
EXP_DATE	Expiration date.
IS_MIXED_LPN	Boolean flag if LPN contains mixed items.
IS_SEALED_CASE	Boolean flag if LPN is a sealed case.
IS_FULL_CASE	Boolean flag if full case.
MASTER_LPN_ID	Reference to master LPN ID.
CASE_QTY	Case quantity.
ITEM_MASTER_CASE_QTY	Standard master case quantity.
LPN_CREATE_DTTM	LPN creation datetime.
LPN_CREATE_SOURCE	LPN creation source.
LPN_MODIFY_DTTM	LPN last modified datetime.
LPN_MODIFY_SOURCE	LPN last modified source.
PTO_ID	PTO reference ID if applicable.
PALLET	Pallet LPN number.
QUALITY_ID	Item quality ID.
QUALITY_NAME	Item quality name.
QUALITY_CODE	Item quality code.
LPN_PICK_TYPE	Pick a type for LPN.
TOTAL_AMOUNT	Total monetary value of inventory.
TOTAL_QTY	Total quantity of inventory.
AVG_COST	Average cost of item.
STORE_NAME	Name of the store.
ACCOUNT_3PL_NAME	Name of 3PL account.
ACCOUNT_3PL_CODE	3PL account code.
DEFAULT_VENDOR_NAME	Vendor name.
IMAGE_SRC	Product image URL/source.
BATCH_NUMBER_FLAG	Boolean flag if batch number is tracked.
EXPIRY_DATE_FLAG	Boolean flag if expiry date is tracked.
LOT_NUMBER_FLAG	Boolean flag if lot number is tracked.
MANUFACTURE_DATE_FLAG	Boolean flag if the manufacture date is tracked.
QUALITY_FLAG	Boolean flag if quality is tracked.
DECIMAL_FLAG_BASE	Decimal flag for base UOM.
UOM_NAME	Selling unit of measure name.
DECIMAL_FLAG	Decimal flag for selling UOM.
MATERIAL_NAME	Material name.
CUSTOM_FIELD_VALUE1 … CUSTOM_FIELD_VALUE15	Custom attributes for extended use.
ITEM_PRODUCT_CATEGORY_NAME	Product category name.
OPTION_1_NAME	Option 1 name.
OPTION_2_NAME	Option 2 name.
OPTION_3_NAME	Option 3 name.
OPTION_1_VALUE	Option 1 selected value.
OPTION_1_SEQ	Option 1 sequence number.
OPTION_1_CODE	Option 1 code.
OPTION_2_VALUE	Option 2 selected value.
OPTION_2_SEQ	Option 2 sequence number.
OPTION_2_CODE	Option 2 code.
OPTION_3_VALUE	Option 3 selected value.
OPTION_3_SEQ	Option 3 sequence number.
OPTION_3_CODE	Option 3 code.
GROUP_NAME	Group name of item.
BRAND_NAME	Brand name.
CATEGORY_NAME	Category name.
SUB_CATEGORY_NAME	Sub-category name.
IS_SELLABLE_FLAG_STR	Y' if item is sellable, 'N' otherwise.
IS_BOM_ITEM_FLAG_STR	Y' if item is BOM, 'N' otherwise.
IS_RAW_MATERIAL_FLAG_STR	Y' if item is raw material, 'N' otherwise.
IS_PURCHASABLE_FLAG_STR	Y' if item is purchasable, 'N' otherwise.
ACTIVE_FLAG_STR	Y' if item is active, 'N' otherwise.
CUBIC_METERS	Volume of inventory in cubic meters.
CUBIC_CAPACITY_UOM_CODE	UOM code for cubic capacity.

VW_LOCATION_MASTER_INFO

Column Name	Description
LOCATION_TYPE_NAME	Name of the location type.
LOCATION_ZONE_NAME	Name of the location zone.
LOCATION_CLASS_NAME	Name of the location class.
ID	Unique identifier of the location record.
LOCN_CLASS_ID	Location class ID.
STORE_ID	Store identifier where the location exists.
ZONE_ID	Zone identifier associated with the location.
LOCN_TYPE_ID	Location type ID.
LOCN_BARCODE	Barcode assigned to the location.
DISP_LOCN	Display name of the location.
AREA	Area number/identifier.
AISLE	Aisle number/identifier.
BAY	Bay identifier.
LVL	Level identifier.
POSITION	Position identifier
DEPTH	Depth dimension of the location.
LENGTH	Length dimension of the location.
WIDTH	Width dimension of the location.
HEIGHT	Height dimension of the location.
CREATE_DTTM	Timestamp when the location record was created.
CREATE_SOURCE	Source of location creation.
MODIFY_DTTM	Timestamp when the record was last modified.
MODIFY_SOURCE	Source of modification.
PICK_SEQ	Pick sequence for picking operations.
PTWY_SEQ	Putaway sequence.
LAST_COUNT_DTTM	Timestamp of last count.
LOCK_CODE_ID	Identifier for lock code applied to this location.
LOCK_STATUS_FLAG	Lock status flag (0/1).
CYCLE_PENDING_FLAG	Indicates if a cycle count is pending (0/1).
X_CORD	X coordinate of the location.
Y_CORD	Y coordinate of the location.
Z_CORD	Z coordinate of the location.
ACTIVE_FLAG	Active status flag (0/1).
STORE_NAME	Name of the store.
LOCK_STATUS_FLAG_STR	“Y” or “N” string for lock status.
CYCLE_PENDING_FLAG_STR	“Y” or “N” string for cycle pending flag.
ACTIVE_FLAG_STR	“Y” or “N” string for active flag.
STORE_CODE	Store code.
AREA_SEP	Area separator character or value.
AISLE_SEP	Aisle separator character or value.
BAY_SEP	Bay separator character or value.
LVL_SEP	Level separator character or value.
DEPTH_SEP	Depth separator character or value.
POSITION_SEP	Position separator character or value.
IS_VIRTUAL_LPN	Indicates whether this is a virtual LPN location.
LAST_COUNTED_DTTM	Datetime when the location was last cycle counted.
LAST_COUNTED_BY	User who performed the last cycle count.

VW_MO_HEADER_INFO

Column Name	Description
ID	Unique identifier for the manufacturing order header record.
MO_NUMBER	Manufacturing order number.
BOM_ID	Bill of Materials identifier.
SCHEDULE_DATE	Scheduled date for the manufacturing order.
BOM_ITEM_ID	Item identifier for the BOM finished good item.
BOM_ITEM_NUMBER	Item number for the BOM finished good.
BOM_QTY	Quantity to be produced according to the BOM.
MEMO	Notes or memo for the manufacturing order.
STATUS_ID	Status identifier for the manufacturing order.
WIP_TXN_NO	Work-in-progress transaction number.
WIP_TXN_ID	Work-in-progress transaction identifier.
STORE_ID	Store identifier where the MO is being processed.
FG_TXN_ID	Finished goods transaction identifier.
FG_TXN_NO	Finished goods transaction number.
CREATE_DTTM	Date and time when the manufacturing order was created.
CREATE_SOURCE	Source or user who created the manufacturing order.
MODIFY_DTTM	Date and time of last modification.
MODIFY_SOURCE	Source or user who last modified the manufacturing order.
RELEASED_DTTM	Date and time when the manufacturing order was released.
PICKED_DTTM	Date and time when raw materials were picked.
PRODUCED_DTTM	Date and time when production was completed.
FG_LOCATION_ID	Finished goods location identifier.
FG_LOCATION_NAME	Finished goods location name.
BOM_UOM_NAME	Unit of measure name for the BOM item.
LOCN_CLASS_ID	Location class identifier for finished goods location.
FG_LOCATION_CLASS_NAME	Finished goods location class name.
STATUS_NAME	Manufacturing order status name.
STORE_NAME	Store name where the MO is being processed.
BOM_NAME	Bill of Materials name.
WIP_LOCATION_ID	Work-in-progress location identifier.
WIP_LOCATION_NAME	Work-in-progress location name.
ALLOC_WAVE_NUMBER	Allocation wave number for raw material picking.
ALLOC_WAVE_ID	Allocation wave identifier.
ORDER_DEPTH	Order depth level in the manufacturing hierarchy.
ORDER_GROUP_ID	Order group identifier for related MOs.
SO_REF_NUMBERS	Comma-separated list of linked sales order reference numbers.
ITEM_DESCRIPTION	Description of the BOM item.
TOTAL_QTY_LINKED	Total quantity linked to sales orders.
ASSIGNED_USER_ID	User identifier for the assigned user.
ASSIGNED_USER_NAME	Full name of the assigned user.
BOM_TO_BE_PRODUCED_QTY	Quantity to be produced (uses override if set, otherwise BOM_QTY).
PRODUCTION_DATE	Actual production date.
LPN_ID	License plate number identifier for the finished good.
LPN_NUMBER	License plate number for the finished good.
LPN_BATCH_NUMBER	Batch number for the LPN.
LPN_LOT_NUMBER	Lot number for the LPN.
LPN_PRIORITY_NUMBER	Priority number for the LPN.
PROJECT_CLASS_ID	Project class identifier.
PROJECT_CLASS_NAME	Project class name.
BATCH_ID	Manufacturing order batch identifier.
BATCH_NUMBER	Manufacturing order batch number.
ADD_LATER_PROCESSES	Flag for processes to be added later.
ADD_LATER_SERVICES	Flag for services to be added later.
CUSTOM_FIELD_VALUE1 … CUSTOM_FIELD_VALUE50	Custom field values 1-50 for flexible data storage.
TITLE	Product title from product header.
LINKED_SO_DYNAMIC_MO	Sales order number linked to dynamic MO.
LINKED_SO_ID_DYNAMIC_MO	Sales order identifier linked to dynamic MO.
PO_NUMBERS	Purchase order numbers associated with the MO.
BASE_UOM_NAME	Base unit of measure name for the BOM item.
PRODUCTION_OFFSET_QTY	Production offset quantity adjustment.
CREATE_SUB_MO_FLAG	Flag indicating if sub-manufacturing orders should be created.
ITEM_CATEGORY	Item category name.
REVISION	BOM revision number.
LPN_QUALITY_ID	Quality identifier for the LPN.
QUALITY_NAME	Quality name for the LPN.
LPN_EXP_DATE	Expiration date for the LPN.
BATCH_NUMBER_FLAG	Flag indicating if batch number is required for the item.
EXPIRY_DATE_FLAG	Flag indicating if expiry date is required for the item.
LOT_NUMBER_FLAG	Flag indicating if lot number is required for the item.
MANUFACTURE_DATE_FLAG	Flag indicating if manufacture date is required for the item.
QUALITY_FLAG	Flag indicating if quality attribute is required for the item.
DEFAULT_RAW_MATERIAL_LOC_ID	Default location identifier for raw materials.
DEFAULT_RAW_MATERIAL_LOC_NAME	Default location name for raw materials.
DEFAULT_FINISHED_GOOD_LOC_ID	Default location identifier for finished goods.
DEFAULT_FINISHED_GOOD_LOC_NAME	Default location name for finished goods.
DEFAULT_RAW_MATERIAL_LOC_CLASS	Default location class name for raw materials.
DEFAULT_FINISHED_GOOD_LOC_CLASS	Default location class name for finished goods.
THIRD_PARTY_SOURCE	Third-party source information.
MO_TYPE	Manufacturing order type identifier.
MO_HEADER_TYPE_NAME	Manufacturing order type name.
BOM_INSTRUCTION	Instructions for executing the BOM.
PPE_NOTES	Personal protective equipment notes.
DISASSEMBLE_OFFSET_ACCNT_ID	Account identifier for disassembly offset transactions.
LPN_ATTRIBUTE_JSON	JSON data containing LPN attributes.
REPORTING_DATA	Additional reporting data for the manufacturing order.
LPN_ATTRIBUTE_MAPPING_EXISTS	Boolean flag indicating if LPN attribute mapping exists for the item.
DECIMAL_FLAG	Flag indicating if the UOM allows decimal quantities.
SPECIFICATION_ID	Specification identifier for the item.
SPECIFICATION_NAME	Specification name for the item.
WMS_PICKED_DTTM	Date and time when WMS picking was completed.
STAGED_DTTM	Date and time when the manufacturing order was staged.

VW_MO_ITEM_LINE_INFO

Column Name	Description
ID	Unique identifier for the manufacturing order item line record.
MO_ID	Manufacturing order identifier that this line belongs to.
ITEM_ID	Item identifier for the raw material or component.
ITEM_NUMBER	Item number for the raw material or component.
DESCRIPTION	Description of the item on this line.
ITEM_TYPE_ID	Identifier of the item type.
QTY	Quantity required for this item line.
UOM_ID	Unit of measure identifier for this item line.
IS_ONE_TIME_ITEM	Indicates whether this is a one-time item.
SEQ_NUMBER	Sequence number for ordering item lines.
INSTRUC_NOTES	Instruction notes for this item line.
INSTRUC_NOTES_SEQ_NUMBER	Sequence number for instruction notes.
CREATE_DTTM	Date and time when the item line was created.
CREATE_SOURCE	Source or user who created the item line.
MODIFY_DTTM	Date and time of last modification.
MODIFY_SOURCE	Source or user who last modified the item line.
UOM_NAME	Unit of measure name for this item line.
QTY_FACTOR	Quantity factor for calculating total quantity.
TOTAL_QTY_TO_PICK	Total quantity that needs to be picked for this line.
TOTAL_QTY_PICKED	Total quantity already picked for this line.
ITEM_UNIT_COST	Unit cost of the item.
ITEM_TOTAL_COST	Total cost for this item line (unit cost × quantity).
BOM_REF_MO_NUMBER	Reference MO number if this line is linked to another MO.
BOM_REF_MO_ID	Reference MO identifier if this line is linked to another MO.
MO_NUMBER	Manufacturing order number.
BOM_ITEM_NUMBER	Item number of the finished good being produced.
BOM_QTY	Ordered quantity of finished good
BOM_TO_BE_PRODUCED_QTY	Quantity to be produced.
FG_LOCATION_NAME	Finished goods location name.
MEMO	Notes or memo for the manufacturing order.
ALLOC_WAVE_NUMBER	Allocation wave number for raw material picking.
STATUS_NAME	Manufacturing order status name.
STATUS_ID	Status identifier for the manufacturing order.
STORE_ID	Store identifier where the MO is being processed.
STORE_NAME	Store name where the MO is being processed.
DECIMAL_FLAG	Flag indicating if the UOM allows decimal quantities.
ITEM_TYPE_NAME	Item type name.
IS_ITEM_BOM	Flag indicating if this item has a BOM (Bill of Materials).
ITEM_BOM_ID	BOM item identifier if this item is a BOM item.
SCHEDULE_DATE	Scheduled date for the manufacturing order.
RELEASED_DTTM	Date and time when the manufacturing order was released.
PICKED_DTTM	Date and time when raw materials were picked.
PRODUCED_DTTM	Date and time when production was completed.
PRODUCTION_DATE	Actual production date.
LPN_NUMBER	License plate number for the finished good.
LPN_BATCH_NUMBER	Batch number for the finished good LPN.
LPN_LOT_NUMBER	Lot number for the finished good LPN.
LPN_PRIORITY_NUMBER	Priority number for the finished good LPN.
ADD_LATER_PROCESSES	Flag or data for processes to be added later.
ADD_LATER_SERVICES	Flag or data for services to be added later.
BATCH_ID	Manufacturing order batch identifier.
BATCH_NUMBER	Manufacturing order batch number.
PROJECT_CLASS_ID	Project class identifier for this item line.
PROJECT_CLASS_NAME	Project class name for this item line.
TITLE	Product title for this item from product header.
BOM_ITEM_TITLE	Product title for the finished good being produced.
DEFAULT_VENDOR_ID	Default vendor identifier for this item.
DEFAULT_VENDOR_NAME	Default vendor name for this item.
BOM_UOM_NAME	Unit of measure name for the finished good BOM item.
BOM_ITEM_DESCRIPTION	Description of the finished good being produced.
ASSIGNED_USER_ID	User identifier for the assigned user.
ASSIGNED_USER_NAME	Full name of the assigned user.
SO_REF_NUMBERS	Comma-separated list of linked sales order reference numbers.
TOTAL_QTY_LINKED	Total quantity linked to sales orders.
PREVENT_SUB_MO	Flag preventing creation of sub-manufacturing orders for this line.
MO_LINE_LPN_LOT_NUMBER	Lot number specific to this item line.
MO_LINE_LPN_BATCH_NUMBER	Batch number specific to this item line.
BOM_ID	Bill of Materials identifier for this item if it has a BOM.
RAW_MATERIAL_ITEM_LOCATION_ID	Location identifier for this raw material item.
RAW_MATERIAL_ITEM_LOCATION_NAME	Location name for this raw material item.
RAW_MATERIAL_ITEM_LOCATION_CLASS	Location class name for this raw material item.
PPE_NOTES	Personal protective equipment notes from the MO header.
BOM_INSTRUCTION	Instructions for executing the BOM from the MO header.
ALTERNATIVE_ITEM_NUMBER1	Alternative item number 1 for this item.
ALTERNATIVE_ITEM_NUMBER2	Alternative item number 2 for this item.
ALTERNATIVE_ITEM_NUMBER3	Alternative item number 3 for this item.
DETAIL_CUSTOM_FIELD_VALUE1 … DETAIL_CUSTOM_FIELD_VALUE50	Custom field values 1-50 for the MO line detail level.
CUSTOM_FIELD_VALUE1 … CUSTOM_FIELD_VALUE50	Custom field values 1-50 for the MO header level.
SUB_BOM_REVISION_ID	Sub-BOM revision identifier if this item uses a specific BOM revision.
SUB_BOM_REVISION_NAME	Sub-BOM revision name with revision number in parentheses.

VW_PO_ASN_DETAIL

Column Name	Description
ITEM_INVENTORY_ID	Unique identifier for this inventory record (from TBL_ITEM_INVENTORY).
STORE_ID	Store identifier associated with the PO.
ORDER_NUMBER	External/internal PO number for tracking and referencing purchase orders.
PO_ID	Unique identifier for the Purchase Order (from TBL_PO_HEADER).
PO_DETAIL_ID	Unique identifier for a single PO line item (from TBL_PO_DETAIL).
STORE_NAME	Name of the store as listed in TBL_STORE.
ITEM_ID	Unique item identifier (links to TBL_ITEM_MASTER).
ITEM_NUMBER	Item number used for internal/reference/lookup purposes.
PO_ITEM_TYPE_ID	Type/category ID of the PO item (from TBL_PO_DETAIL).
PO_ITEM_TYPE_NAME	PO Item Type name.
VENDOR_PART_NUMBER	Vendor’s assigned part number; useful for supplier communication.
LINE_STATUS_ID	Identifies the current status of the PO line (links to TBL_PO_DETAIL_STATUS).
DESCRIPTION	Description of the item on the PO line.
QTY_ORDERED	Quantity ordered for this PO line/item.
QTY_RECEIVED	Amount received against the ordered quantity.
QTY_REMAINING	Quantity remaining to be received for this PO line/item.
UOM_NAME	Name of the Unit of Measure (e.g., Box, Each, Kg).
QTY_OPEN_ASN	Quantity pending in Advanced Shipment Notifications (ASN) not yet received.
QTY_AVAILABLE_TO_RECEIVE	Quantity available to receive: remaining ordered minus quantity open in ASN.
PO_DETAIL_STATUS_NAME	Name representing the PO detail status (from TBL_PO_DETAIL_STATUS).
UOM_ID	Unique identifier for the Unit of Measure.
DECIMAL_FLAG	Flag indicating if quantity supports/uses decimal values.
PO_HEADER_STATUS_ID	Status identifier for the parent PO (from TBL_PO_HEADER).
BASE_UOM_ID	Identifier for the base unit of measure.
UOM_FACTOR	Conversion factor from base unit to specified unit (default: 1).
ALTERNATIVE_ITEM_NUMBER1	Alternate item number for reference/substitute/compatibility.
ALTERNATIVE_ITEM_NUMBER2	Additional alternate item number.
ALTERNATIVE_ITEM_NUMBER3	Additional alternate item number.
PURCHASE_NOTES	Any purchase-related notes or remarks about the item.
BASE_PART_NUMBER	Core item/part number (typically for product family grouping).
OPTION_1_VALUE	First option/detail value for product customization.
OPTION_2_VALUE	Second option/detail value for product customization.
OPTION_3_VALUE	Third option/detail value for product customization.

VW_PROJECT_CLASS_INFO

Column Name	Description
ID	Unique identifier for the project class record (from TBL_PROJECT_CLASS).
level	Hierarchical level within the indented project class structure (from VW_PROJECT_CLASS_INDENTED).
ROOT_ID	ID of the root (top-most) project class for the current hierarchy branch.
NAME	Project class name for identification and reporting.
DESCRIPTION	Description of the project class; more context about its function or scope.
CODE	Code assigned to the project class, used for referencing and integration.
PARENT_ID	ID of the parent project class (links for hierarchy structure).
SORT_COLUMN	Value for sorting and displaying project class records in a logical order.
INDENTED_NAME	Indented display name, visually denoting hierarchy level (from VW_PROJECT_CLASS_INDENTED).
STATUS_NAME	Name of the current status of the project class (from TBL_PROJECT_STATUS).
CATEGORY_NAME	Name of the category assigned to the project class (from TBL_PROJECT_CATEGORY).
CATEGORY_ID	Unique ID for the project category, used for lookup and filtering.
STATUS_ID	Unique ID for the status of the project class, used for filtering or workflow management.
PARENT_NAME	Name of the parent project class (from joined TBL_PROJECT_CLASS_1).
ACTIVE_FLAG	Flag (1/0) indicating whether the project class is currently active.
ACTIVE_FLAG_STR	'Y' if active, 'N' if inactive – status for reports and UI.
ROOT_PROJECT_CLASS_NAME	Name of the root project class in the hierarchy (from TBL_PROJECT_CLASS as R).

VW_PURCHASE_ORDER_DETAIL_INFO

Column Name	Description
ORDER_NUMBER	An identifier for the purchase order, for tracking among transactions.
STORE_ID	Unique store identifier where the order is processed.
STORE_NAME	Name of the store.
VENDOR_NAME	Name of the vendor or supplier for the PO.
PO_STATUS_ID	Numeric status for the purchase order (e.g., open, closed, received, partial received, cancelled).
PO_STATUS_NAME	Status as a readable string, from PO header status table. (e.g., open, closed, Received, Partial Received, Cancelled).
PO_RELEASE_DATE	Date the purchase order was released to the vendor.
PO_DELIVERY_DATE	Expected date for delivery of the purchase order.
LINE_STATUS_NAME	Status of each PO line (e.g., pending, received, cancelled).
DISCOUNT	String showing discount applied (percentage sign added for type 10, value otherwise negated).
DATE_ORDER	Date when the order was created.
ID	Unique identifier for the PO line item.
PO_ID	Header reference of the purchase order for line-level aggregation.
PO_ITEM_TYPE_ID	Identifies line item type.
PO_ITEM_TYPE_NAME	Item type for the PO line.
LINE_NUMBER	Sequential number of the PO line for ordering.
ITEM_ID	Unique item identifier, linked to master data.
ITEM_NUMBER	Item number as stored in the master table.
VENDOR_PART_NUMBER	Vendor’s catalog or part reference for the item.
LINE_STATUS_ID	Numeric code for PO line status.
DESCRIPTION	Descriptive text for the PO line item.
DATE_LAST_FULFILLED	Date when the line item was last marked as fulfilled.
DATE_EXPECTED_DELIVERY	Date when delivery is expected for the PO line.
QTY_ORDERED	Ordered quantity for the PO line.
QTY_RECEIVED	Quantity received so far for this PO line.
QTY_REMAINING	Remaining quantity to be received for the line item.
DISCOUNT_TYPE_ID	Indicates type of discount (percentage/fixed).
DISCOUNT_AMOUNT	Discount value.
UNIT_PRICE	Original price per unit.
EFFECTIVE_UNIT_PRICE	Unit price after discounts are applied.
TOTAL_PRICE	Total calculated price for the PO line.
UOM_ID	ID for unit of measure used in this line.
UOM_NAME	Unit of measure name (e.g., kg, box).
TAXABLE_FLAG	Marks if item is taxable (1) or not (0).
TAX_CODE_ID, TAX_CODE_NAME	Tax code applied to PO line item; name for reporting.
TAX_AMOUNT	Tax amount calculated for the PO line.
OPEN_FLAG, CLOSE_FLAG	Indicates whether the line is open or closed.
CANCELLED_FLAG	Indicates whether the PO line item has been cancelled.
PROJECT_CLASS_ID, PROJECT_CLASS_NAME	Project association for the PO line, allows categorization.
ITEM_UPC	Universal product code for retail/barcoding workflows.
BASE_PART_NUMBER	Master part for grouping/family of items.
TITLE	Main title/description for product.
OPTION_1_NAME, OPTION_1_VALUE, OPTION_1_CODE	Option/variant information for product customization (first option).
OPTION_2_NAME, OPTION_2_VALUE, OPTION_2_CODE	Option/variant information for product customization (second option).
OPTION_3_NAME, OPTION_3_VALUE, OPTION_3_CODE	Option/variant information for product customization (third option).
SEASON_VALUES	Season tag/classification for seasonal items.
IS_KIT_HEADER, IS_KIT_ITEM	Flags for kit items, marking if item is kit parent/child.
MASTER_KIT_ID, MASTER_KIT_KEY	References to master kit/grouping if item belongs to a kit.
KIT_ITEM_FACTOR	Quantity factor for kit item calculation in parent/child relationships.
REF_NUMBER, THIRD_PARTY_REF_NO	External references for PO integration (third-party or memo reference numbers).
BUYER_ID, BUYER_NAME	Buyer assigned to the PO, links to customer table for reporting.
NOTES	Miscellaneous notes related to PO line item.
ASN_NUMBERS	CSV aggregate of all ASN numbers associated with PO line, for tracking receipts.
ITEM_CATEGORY_NAME	Item category for reporting/grouping purposes.
ITEM_GROUP_NAME	Item group/category for additional classification.
ITEM_BRAND_NAME	Brand information for each item.
ALTERNATIVE_ITEM_NUMBER1/2/3	Alternate item numbers for substitutes/alternates for master item.
PERMISSION_GROUP_ID	Security/grouping information for permission filtering.
TAX_DATA	Extended tax data for calculations.
ESTIMATED_DUTY_AMOUNT	Expected duty amount for the PO line.
ESTIMATED_DUTY_PERCENTAGE	Percentage duty estimate for the PO line.
UOM_FACTOR	Conversion factor from base unit to specified unit.
BASE_UOM_NAME	Name of base unit of measure.
BASE_QTY_ORDERED, BASE_QTY_SHIPPED, BASE_QTY_REMAINING_TO_SHIP	Quantities in the base UOM for tracking shipment flow.
TYPE_NAME	PO type (Purchase, Dropship, Transfer) for business logic.
ITEM_DESCRIPTION	Main description from item master, overrides line description if needed.
DROPSHIP_SO_NUMBER, DROPSHIP_SO_ID	Associated sales order for dropship items.
DROP_SHIP_ITEM_FLAG/STR	Indicates item is drop shipped (Y/N or 1/0).
DROPSHIP_QTY	Quantity dropshipped out of total PO.
LAST_RECEIPT_DTTM	Last receipt date/time for PO line (aggregated).
VENDOR_INTERNAL_NOTES, NOTES_TO_VENDOR	Vendor-specific remarks for internal/external communication.
TOTAL_IN_RECEIVING	Quantity currently in receiving according to ASN aggregation.
UNIT_CBM, LINE_CBM	Cubic meter calculation for unit and total line item volume.
QTY_RECEIVED_PERCENTAGE	Percentage of PO quantity received for status tracking.
ITEM_SUB_CATEGORY_NAME	Sub-category name for item grouping.
ACCOUNT_3PL_CODE, ACCOUNT_3PL_NAME	3PL (third-party logistics) code and name for logistics workflows.
QUALITY_NAME, QUALITY_CODE, QUALITY_ID	Quality classification and codes for line item.
ACCOUNT_3PL_TYPE_ID	Type identifier for 3PL account.
PAYMENT_TERMS_NAME	Payment terms on PO for accounts payable teams.
ORDER_CLASS_NAME, ORDER_CLASS_CODE	PO order class for further legal/regulatory reporting.
JOB_SCHEDULE_RUN_FLAG_STR	Flag for job schedule run on PO header (Y/N).
LINE_JOB_SCHEDULE_RUN_FLAG/STR	Line-level job schedule run flag and readable value (Y/N).
SHIP_TO_ADDR_NAME, SHIP_TO_ADDRESS2, SHIP_TO_FIRST_NAME, SHIP_TO_LAST_NAME, SHIP_TO_COMPANY_NAME, SHIP_TO_PHONE_NUMBER, SHIP_TO_EMAIL	Detailed destination address information for shipping.
TAGS	Additional tags applied to PO for categorization/custom reporting.
FOB_NAME	Freight-on-board point name for shipping terms.
SHIPPING_TERMS_NAME	Shipping terms assigned to PO.
CARRIER_CODE, CARRIER_NAME	Carrier details for logistics.
SHIP_SERVICE_CODE, SHIP_SERVICE_NAME	Shipping service type and name for reporting.
ITEM_PRODUCT_CATEGORY_NAME	Product category group for item/product.
WEIGHT, WEIGHT_UOM_NAME, WEIGHT_UOM_ID	Weight value, unit, and ID for item logistics calculations.
PTO_ID	PTO (purchase transfer order) related identifier.
RECEIVED_QUALITY	Received item quality from inspection.
BRAND_NAME	Brand tied to PO header, if present.
CUSTOM_FIELD_VALUE1...CUSTOM_FIELD_VALUE50	Custom user-defined fields on PO header, for flexible business requirements.
DETAIL_CUSTOM_FIELD_VALUE1...DETAIL_CUSTOM_FIELD_VALUE50	Custom user-defined fields at detail (line) level, for line-specific extensions.

VW_PURCHASE_ORDER_HEADER_INFO

Column Name	Description
STORE_NAME	Name of the store linked to the purchase order.
STATUS_NAME	Status for the purchase order, such as Open or Closed.
VENDOR_NAME	Name of the company providing goods or services.
DROP_SHIP_CUSTOMER_NAME	Customer for drop ship purchase orders.
CURRENCY_SYMBOL	Symbol for the currency used in the purchase order.
TRANSFER_FROM_STORE_NAME	Name of the originating store in case of transfer.
TYPE_NAME	Type of the purchase order, such as Standard, Transfer, Dropship.
ID	Unique identifier for the purchase order record.
ORDER_NUMBER	Number for tracking the purchase order.
STORE_ID	Identifier for the related store.
TYPE_ID	Code indicating the type of the purchase order.
STATUS_ID	Code for the current status of the purchase order.
PAYMENT_TERMS_ID	Reference to payment agreement for the purchase order.
BILL_FROM_ADDR	Address where the bill will be sent.
BILL_FROM_CITY	City of the billing address.
BILL_FROM_STATE	State or province of the billing address.
BILL_FROM_COUNTRY	Country for the billing address.
BILL_FROM_ZIP_POSTAL_CODE	Zip or postal code of the billing location.
SHIP_TO_ADDR	Destination address for the order’s delivery.
SHIP_TO_CITY	Destination city for the order’s delivery.
SHIP_TO_STATE	Destination state or province.
SHIP_TO_COUNTRY	Destination country.
SHIP_TO_ZIP_POSTAL_CODE	Destination postal code.
CURRENCY_ID	Reference code for the currency used in the order.
CURRENCY_RATE	Exchange rate applied for the purchase order.
CURRENCY_CODE	Standard currency code, such as USD or EUR.
VENDOR_ID	Unique identifier for the supplier.
VENDOR_CONTACT	Contact person or detail for the supplier.
CREATE_DTTM	Date and time when the order was created.
CREATE_SOURCE	Origin system or method for PO creation.
MODIFY_DTTM	Last date and time the order was updated.
MODIFY_SOURCE	Source system for modifications.
DATE_ORDER	Date the order was placed.
DATE_RELEASED	Date the order was sent for fulfillment.
DATE_FULFILLED	Date the order was fully completed.
DATE_EXPECTED_DELIVERY	Expected delivery date for the order.
VENDOR_MSG	Any message sent to the vendor related to the order.
MEMO	Notes or memo attached to the order.
RESIDENTIAL_FLAG	Indicates if the ship-to address is residential.
DROP_SHIP_CUSTOMER_ID	Reference to the drop ship customer.
TRANSFER_FROM_STORE_ID	Reference to the originating store for transfer orders.
TRANSFER_SO_ID	Transfer sales order identifier, if applicable.
TRANSFER_SO_NUMBER	Transfer sales order number, if applicable.
TAX_SUMMARY_DATA	Aggregated tax information for the order.
TOTAL_AMOUNT	Total monetary value of the order.
REPORTING_DATA	Data used for reporting on the order.
SHIPPING_TERMS_ID	Reference for the shipping terms applied.
FOB_ID	Free-on-board (FOB) point reference for the order.
VENDOR_REQ_DATE	Date requested by vendor for processing/delivery.
IS_CLOSED	Indicates if the purchase order is closed.
PROJECT_CLASS_ID	Project classification for the order if applicable.
PROJECT_CLASS_NAME	Name of the project class linked to the order.
REF_NUMBER	External reference number provided for the order.
THIRD_PARTY_REF_NO	Reference number for third-party systems.
THIRD_PARTY_SOURCE	Source system identifier for integration.
THIRD_PARTY_DISPLAY_NAME	Display name for third-party integration.
THIRD_PARTY_ICON_URL	URL for icon or logo for third-party integration.
TOTAL_QTY	Total quantity ordered across all lines.
SUB_TOTAL_EXCL_DISCOUNT	Subtotal before discount is applied.
DISCOUNT_AMOUNT	Amount deducted as discount for the order.
SUB_TOTAL	Subtotal after discounts.
TOTAL_PREPAYMENT	Total prepayment collected for the purchase order.
CARRIER_ID	Reference to the carrier responsible for shipping.
SHIP_METHOD_ID	Ship method identifier used for delivery.
SHIPPING_ACCOUNT_NUMBER	Account number used for shipping and deliveries.
CARRIER_NAME	Carrier name handling the shipment.
QTY_RECEIVED	Quantity already received against the order.
QTY_ASN_PENDING	Quantity pending in advanced shipment notification.
QTY_ON_ASN	Quantity listed on advanced shipment notification.
QTY_REMAINING_TO_RECEIVE	Quantity yet to be received.
SHIP_METHOD_NAME	Name of ship method chosen for delivery.
TAGS	Keywords or tags added for organization or search.
SHIP_SERVICE_ID	Reference for the ship service used.
SHIP_SERVICE_NAME	Name of the ship service.
EXPECTED_SHIP_DATE	Date expected for shipment to leave origin.
JOB_SCHEDULE_RUN_FLAG	Indicates if the PO was generated via job scheduler.
JOB_SCHEDULE_RUN_FLAG_STR	Flag value for job scheduler as Y (yes) or N (no).
TRANSFER_PROCESSED_FLAG	Indicates if transfer processing is complete.
TRANSFER_PROCESSED_FLAG_STR	Text value for transfer processed flag: Y or N.
SUB_TYPE_NAME	Sub-type name for the order (such as Standard, Return, etc.).
ORDER_TYPE_CODE	Code prefix for order type.
SUB_TYPE_ID	Identifier for the sub-type of order.
SHIP_TO_ADDRESS2	Second line of the shipping address.
SHIP_TO_FIRST_NAME	Recipient first name at the ship-to address.
SHIP_TO_LAST_NAME	Recipient last name at the ship-to address.
SHIP_TO_COMPANY_NAME	Company name at the ship-to address.
SHIP_TO_PHONE_NUMBER	Phone number for the ship-to recipient.
SHIP_TO_EMAIL	Email address for the ship-to recipient.
SHIP_TO_ADDR_NAME	Label or contact for the ship-to address.
BILL_FROM_FIRST_NAME	First name of the billing contact.
BILL_FROM_LAST_NAME	Last name of the billing contact.
BILL_FROM_COMPANY_NAME	Company name for billing.
BILL_FROM_ADDR2	Second line for billing address.
BILL_FROM_PHONE_NUMBER	Phone number for billing contact.
BILL_FROM_EMAIL	Email address for billing contact.
BILL_FROM_ADDR_NAME	Label or contact for the billing address.
BUYER_ID	Identifier for the buyer of the order.
BUYER_NAME	Name of the buyer.
DEFAULT_LOCATION_ID	Identifier for the default inventory location.
DEFAULT_LOCATION_NAME	Display name for the default location.
ASN_NUMBERS	List of shipment notifications associated with the order.
LINE_COUNT	Number of product lines on the order.
TO_STORE_DEFAULT_LOCATION_ID	Identifier for the default location of the destination store, in case of transfers.
TO_STORE_DEFAULT_LOCATION_NAME	Name for the default location of the destination store.
RECEIPT_NUMBER	List of receiving document numbers and statuses.
CUSTOM_FIELD_VALUE1...50	Custom fields for storing additional information related to headers (available in the Custom Field tab within the header section).
PERMISSION_GROUP_ID	Permission group for data access and filtering.
MO_NUMBERS	List of manufacturing order numbers linked to the PO.
TAX_SERVICE_HASH_CODE	Code for tax calculation service used on the order.
SHIP_FROM_ADDR	Address from where goods are shipped.
SHIP_FROM_ADDR2	Second address line for the shipping origin.
SHIP_FROM_CITY	City of the shipping origin.
SHIP_FROM_STATE	State or province of the shipping origin.
SHIP_FROM_COUNTRY	Country of the shipping origin.
SHIP_FROM_ZIP_POSTAL_CODE	Zip code of the shipping origin.
TOTAL_ESTIMATED_DUTY_AMOUNT	Estimated total duties and taxes for the order.
IS_DROP_SHIP_FLAG	Marks the order as a drop ship (yes/no).
SHIP_FROM_INSTRUCTION_FIELD_1...12	Special instructions for shipping origin, up to twelve fields.
BILL_FROM_INSTRUCTION_FIELD_1...12	Special instructions for billing, up to twelve fields.
IS_APPROVED	Marks if the order has final approval (yes/no).
IS_APPROVAL_REQUIRED_FLAG	Marks if approval is needed for processing the order.
APPROVED_FLAG_STR	“Y” or “N” value for approval status.
LAST_APPROVED_AMOUNT	Amount most recently approved.
LAST_APPROVED_DTTM	Last approval date and time.
LAST_APPROVED_SOURCE	Source of last approval activity.
LAST_APPROVAL_REQUEST_AMOUNT	Amount requested in most recent approval.
PO_APPROVAL_STATUS	Status name for the approval process (such as Approved, Pending, Cancelled, etc.).
EMAIL_MAIN	Primary email for the vendor.
VENDOR_EMAIL_CC	Carbon-copy email for the vendor.
DROPSHIP_FREIGHT_AMOUNT	Freight charge for drop ship orders.
SO_NUMBERS	Numbers of linked sales orders.
ENTITY_USE_CODE	Code for how the vendor’s entity is used.
BALANCE_AMOUNT	Amount still outstanding or to be paid.
RECEIVED_AMOUNT	Amount received for the order so far.
LAST_RECEIPT_DTTM	Date of the last time goods were received on the order.
INVALID_ADDRESS_FLAG	Marks if there is an invalid address related to the order.
HASH_CODE_JSON	Hash value for address or metadata.
TOTAL_CBM	Total cubic meter volume for order shipments.
DEFAULT_PAYMENT_METHOD_ID	Reference to standard payment method used.
DEFAULT_PAYMENT_METHOD_NAME	Name of the standard payment method.
ACCOUNT_3PL_NAME	Name for third-party logistics account.
ACCOUNT_3PL_CODE	Code for third-party logistics account.
ACCOUNT_3PL_DESC	Description for the third-party logistics account.
QUALITY_NAME	Name for a quality grade or category.
QUALITY_CODE	Code for a quality grade or category.
QUALITY_ID	Identifier for quality category.
RECEIVING_STATUS_NAME	Name for receipt status on the purchase order.
RECEIVING_STATUS_ID	Identifier for receipt status on the purchase order.
ACCOUNT_3PL_TYPE_ID	Type reference for the third-party logistics account.
ACCOUNT_3PL_ID	Identifier for the third-party logistics account.
CUSTOMER_3PL_EMAIL_MAIN	Main customer email for the third-party logistics contact.
ASN_CREATED_DTTM	Date and time when ASN (advance shipment) was created.
RECEIVING_COMPLETED_DTTM	Date and time when receiving was completed for the order.
PUTAWAY_COMPLETED_DTTM	Date and time when items were put away in inventory.
FULFILLED_DTTM	Date and time when the purchase order was marked fulfilled.
LAST_ASN_CLOSED_DTTM	Date and time when the last ASN was closed.
FOB_POINT_NAME	Name displaying the freight-on-board point for the order.
SHIPPING_TERM_NAME	Name for the shipping terms attached to the order.
PAYMENT_TERMS_NAME	Name for agreed payment terms.
CANCEL_REASON_NAME	Reason name for why the order was cancelled, if applicable.
CANCEL_REASON_CODE	Reason code for order cancellation, if applicable.
BRAND_ID	Identifier for the product or supplier brand.
BRAND_NAME	Name for the brand linked to the order.
IS_PROCESSED	Marks if the order has been fully processed.
META_DATA	Metadata and extra details for the purchase order.

VW_RECEIPT_HEADER_INFO

Column Name	Description
ID	Unique identifier for the receipt record.
STORE_ID	Identifier for the store where goods are received.
VENDOR_ID	Identifier for the vendor who supplied the goods.
ACCNT_PAYABLE_ID	Identifier for the accounts payable linked to this receipt.
CURRENCY_ID	Code pointing to the currency used.
RECEIPT_NUMBER	Number given to the receipt for tracking.
REF_NO	Reference number for external systems or matching.
VENDOR_NAME	Name of the company supplying the goods.
STORE_NAME	Name of the store where goods are received.
TXN_DATE	Date when the receipt transaction happened.
CURRENCY_CODE	Standard code for the currency, like USD or INR.
MEMO	Notes or remarks about the receipt.
TOTAL_AMOUNT	Total amount for this receipt transaction.
CREATE_DTTM	Date and time when the record was created.
TXN_NO	Transaction number for financial or system tracking.
TXN_ID	Transaction identifier used for linking across systems.
EXCHANGE_RATE	Exchange rate applied for currency conversions.
RECONCILE_FLAG	Indicates if the receipt has been reconciled (yes/no).
CREATE_SOURCE	Source or system where the receipt was first created.
MODIFY_DTTM	Most recent date and time the record was updated.
MODIFY_SOURCE	System or user that made the last update.
SYMBOL_UNICODE_VAL	Unicode symbol for the currency (like ₹, €, $).
STATUS_ID	Code used to indicate the current status of the receipt.
STATUS_NAME	Status name for the receipt, such as Paid or Pending.
REPORTING_DATA	Data used for business reporting for this receipt.
TAX_SUMMARY_DATA	Aggregated tax details for the receipt.
AMOUNT_DUE	Amount still remaining to be paid for this receipt.
DISCOUNT_AMOUNT	Amount discounted for this transaction.
SUB_TOTAL_EXCL_DISCOUNT	Subtotal before discounts are applied.
PO_NUMBER	List of purchase order numbers connected to this receipt.
BUYER_ID	Unique identifier for the buyer who handled the receipt.
BUYER_NAME	Name of the buyer for the receipt transaction.
JOB_SCHEDULE_RUN_FLAG_STR	Shows “Y” if created by a scheduled job, otherwise “N”.
PROJECT_CLASS_NAME	Name categorizing the project for this receipt.
PERMISSION_GROUP_ID	Code for permissions and visibility.
TOTAL_ESTIMATED_DUTY_AMOUNT	Estimated total duty amount for the receipt.
CHARGE_ENTRY_ID	Reference for charge entry linked to the receipt.
ACCOUNT_3PL_TYPE_ID	Type identifier for third-party logistics accounts.
IS_3PL_ACCOUNT_VENDOR	Shows 1 if the vendor is a third-party logistics account, else 0.
ACCOUNT_3PL_ID	Identifier for the third-party logistics account.
ACCOUNT_3PL_NAME	Name of third-party logistics provider if relevant.
SERVICE_3PL_CHARGES	Charge amount for 3PL service charges (logistics costs).
SERVICE_CHARGE_ENTRY_TYPE	Type/category for the service charge entry.
MISC_3PL_CHARGES	Charge amount for miscellaneous 3PL charges.
MISC_CHARGE_ENTRY_TYPE	Type/category for miscellaneous charge entry.
DOC_TYPE	Document type for charge entry.
CHARGE_ENTRY_REF_NUMBER	Reference number if tied to charge entry.
CONTRACT_NUMBER	Contract number tied to third-party logistics.
INVOICE_3PL_NUMBER	List of 3PL invoice numbers related to logistics charges.
INVOICE_3PL_ID	Identifies the 3PL invoice document.
TOTAL_CBM	Total volume in cubic meters for items on this receipt.
DEFAULT_PAYMENT_METHOD_NAME	Name of the standard payment method used for this vendor.
DEFAULT_PAYMENT_METHOD_ID	Identifier for the standard payment method.
VENDOR_BILL_NUMBER	Number for the bill as provided by the vendor(comes from Item Receipt Header).
TOTAL_QTY	Total quantity of items received.
CUSTOM_FIELD_VALUE1...50	Custom fields for storing additional information related to headers (available in the Custom Field tab within the header section).

VW_RMA_DETAIL_INFO

Column Name	Description
ID	Unique identifier for the RMA line item.
RMA_ID	Reference identifier for the RMA (Return Material Authorization).
TXN_ID	ID used for linking to related transactions.
TXN_NUMBER	Number assigned to the transaction for tracking.
LINE_NUMBER	Sequence number for the item line in the RMA.
ITEM_ID	Identifier for the item being returned.
ITEM_TYPE_ID	Code to classify the type of item.
ITEM_TYPE_NAME	Name describing the item type.
ITEM_NUMBER	Number given to the item for identification.
DESCRIPTION	Details or notes about the item being returned.
RATE	Unit price or rate for the item.
UOM_NAME	Name of the unit of measure for the item (e.g., Each, Box).
UOM_ID	Identifier for the unit of measure.
QTY	Quantity being returned.
AMOUNT	Total value being returned for the item line.
TAX_CODE_ID	Code indicating which tax applies.
TAX_CODE_NAME	Name describing the applied tax.
TAX_AMOUNT	Amount charged for tax on this item line.
STATUS_ID	Number used to show the current status of the line item.
CREATE_DTTM	Date and time this record was created.
CREATE_SOURCE	System or origin for this record.
MODIFY_DTTM	Date and time of the latest modification.
MODIFY_SOURCE	Origin or user for the latest modification.
INVOICE_LINE_ID	Link to the related invoice line, if any.
DISCOUNT	Discount applied to the item line, if applicable.
DISCOUNT_TYPE_ID	Number indicating discount type or calculation method. (Fixed or Percentage)
EFFECTIVE_UNIT_PRICE	Actual unit price after discounts are applied.
DECIMAL_FLAG	Shows if the unit allows decimal values.
RETURN_CODE_ID	Code indicating why the item is returned.
RETURN_CODE_NAME	Name or label for the reason code.
RETURN_NOTES	Notes or comments about why the return is happening.
PROJECT_CLASS_ID	Identifier for any project classification linked to this line.
PROJECT_CLASS_NAME	Name for the linked project class.
THIRD_PARTY_REF_NO	Reference number for external or third-party system.
THIRD_PARTY_SOURCE	Source or system name for external transactions.
TAX_DATA	All tax-related data for this line.
IS_TAXABLE_ON_SALE	Indicates if the item is taxable when sold (yes/no).
RMA_NUMBER	Number for the RMA associated with this line.
TXN_DATE	Date when this RMA transaction occurred.
REF_NO	Reference number for external systems or matching (comes from the header Part of the RMA).
TYPE_ID	Code showing RMA type or category.
CUSTOMER_NAME	Name of the customer making the return .
SALES_REP_ID	Identifier for the sales representative involved (comes from the RMA header)..
PERMISSION_GROUP_ID	Used for permission control and data access.
QTY_RECEIVED	Number of returned items received so far.
QTY_REMAINING	Number of items still to be received.
LINE_STATUS_ID	Shows the status of the item line in the return process.
BASE_UOM_ID	Identifier for the base unit of measure.
UOM_FACTOR	Factor used for converting to base unit.
TOTAL_IN_RECEIVING	Total items in the receiving process for this return.
VAS_ITEM_ID	Value-added service item identifier, if any.
VAS_ITEM_NAME	Name of the value-added service item.
VAS_ITEM_COST	Cost for the value-added service applied.
VAS_ITEM_COST_TOTAL	Total cost for the value-added services.
VAS_TAXABLE_FLAG	Indicates if value-added service is taxable (yes/no).
VAS_DISCOUNTABLE_FLAG	Indicates if value-added service gets a discount (yes/no).
QUALITY_NAME	Name describing the item’s quality level.
QUALITY_ID	Identifier for the quality category.
ACCOUNT_3PL_ID	Identifies the linked third-party logistics account.
ACCOUNT_3PL_NAME	Name for the linked third-party logistics provider.
SHIP_TO_FIRST_NAME	First name for delivery contact.
SHIP_TO_LAST_NAME	Last name for delivery contact.
SHIP_TO_ADDR	Delivery address.
SHIP_TO_ADDR2	Second line for delivery address.
SHIP_TO_CITY	Delivery city.
SHIP_TO_STATE	Delivery state or province.
SHIP_TO_COUNTRY	Delivery country.
SHIP_TO_ZIP_POSTAL_CODE	Postal code for delivery location.
DETAIL_CUSTOM_FIELD_VALUE1...50	Detail-level custom fields for items, maintained and modified from the Custom Fields tab in the Item module.
ITEM_ACCOUNT_3PL_ID	Account identifier for item’s 3PL logistics link.
ALTERNATIVE_ITEM_NUMBER1	Alternate number for the item.
ALTERNATIVE_ITEM_NUMBER2	Second alternate number for the item.
ALTERNATIVE_ITEM_NUMBER3	Third alternate number for the item.
STORE_ID	Identifier for the store linked to the RMA header.
PTO_ID	Reference number for purchase transfer order.
BRAND_NAME	Brand name for the returned item.
RECEIVED_QUALITY	Quality status of the received items.

VW_RMA_HEADER_INFO

Column Name	Description
ID	Unique identifier for the RMA record.
RMA_NUMBER	Number assigned for the return material authorization.
TXN_ID	ID for linking to related transactions.
TXN_NUMBER	Transaction number used for tracking financials.
STORE_ID	Identifier for the store handling the return.
ACCNT_RECEIVABLE_ID	Account receivable identifier related to the RMA.
CUSTOMER_ID	Identifier for the customer making the return.
TXN_DATE	Date when the RMA transaction happened.
CURRENCY_ID	ID for the currency used on the RMA.
EXCHANGE_RATE	Rate used if currency conversion applies.
REF_NO	Reference number for matching or external tracking.
AMOUNT	Amount for this return authorization.
STATUS_ID	Code showing the current RMA status.
MEMO	Notes or remarks about the RMA.
CREATE_DTTM	Date and time when RMA was created.
CREATE_SOURCE	System or method used for creation.
MODIFY_DTTM	Date and time of the latest update.
MODIFY_SOURCE	System or user responsible for the last modification.
ACCOUNT_RECEIVABLE_NAME	Name for the account receivable.
CUSTOMER_NAME	Name of the customer for the RMA.
CUSTOMER_FULL_NAME	Full name of the customer.
CURRENCY_NAME	Name describing the currency.
CURRENCY_CODE	Standard currency code, like USD or EUR.
CURRENCY_SYMBOL	Symbol representing the currency.
STORE_NAME	Name of the store handling the RMA.
STATUS_NAME	Name describing the current status of the RMA.
RMA_ID	Unique identifier for the RMA record.
AMOUNT_APPLIED	Amount linked or applied to the RMA.
AMOUNT_REMAINING	Amount still remaining to be processed or refunded.
AMOUNT_REFUNDED	Amount refunded for the RMA.
TOTAL_AMOUNT	Total monetary value for the RMA.
INVOICE_NUMBER	Number identifying the related invoice (When Invoice RMA is created, it will pull the Invoice).
INVOICE_ID	ID for the related invoice record.
TYPE_ID	Code to classify the type of RMA.
TYPE_NAME	Name of the RMA type or category.
INVOICE_DISCOUNT_USED	Amount of invoice discount used for the RMA.
INVOICE_DISCOUNT_EXP_ACCNT_ID	Account ID for invoice discount expenses.
INVOICE_SHIPPING_AMOUNT_USED	Shipping amount from invoice applied.
INVOICE_SHIPPING_EXP_ACCNT_ID	Account ID for shipping expense from invoice.
INVOICE_SHIPPING_TERM_ID	Shipping terms applied from invoice.
INVOICE_SHIP_METHOD_ID	Shipping method used on the invoice.
INVOICE_SHIP_TAX_CODE_ID	Tax code for shipping from the invoice.
TAX_SUMMARY_DATA	All tax calculations for the RMA.
REPORTING_DATA	Data used for reporting and analysis.
OPENING_BALANCE_FLAG	Shows if this RMA is used as an opening balance.
INVOICE_SALE_STORE_ID	ID for the store where the related invoice sale happened.
INVOICE_SALE_STORE_NAME	Name for the store where the invoice sale occurred.
SYS_LOCK_FLAG	Lock status for system processing.
UNPOST_TRANS_FLAG	Indicates if there are unposted transactions.
CUSTOMER_CURRENCY_ID	Customer Currency ID
CUSTOMER_MAIN_PHONE	Main phone number for customer contact.
CUSTOMER_EMAIL_MAIN	Email address for main customer contact.
CUSTOMER_DEFAULT_ACCNT_RECEIVABLE_ID	Default account for customer receivables.
STORE_CODE	Code assigned to the store.
RETURN_TYPE_ID	Code indicating type of return transaction.
ASN_CREATED	Shows if ASN (advance shipment notification) was created.
ASN_NUMBER	Number for associated ASN document, if any.
ASN_ID	Identifier for ASN record if linked.
PROJECT_CLASS_ID	Optional code for project classification.
PROJECT_CLASS_NAME	Name for the project class (comes from RMA header).
THIRD_PARTY_REF_NO	Reference number for external or third-party system.
THIRD_PARTY_SOURCE	System name for external reference.
THIRD_PARTY_DISPLAY_NAME	Display name for any third-party integration.
THIRD_PARTY_ICON_URL	Icon or logo for the third-party integration.
INVOICE_SHIPPING_TERMS_NAME	Name for invoice shipping terms.
INVOICE_SHIP_METHOD_NAME	Name identifying invoice shipping method.
INVOICE_SHIP_TAX_CODE_NAME	Name for invoice shipping tax code.
SHIPPING_TAX_DATA	Data used for shipping tax calculations.
TOTAL_QTY	Total quantity included in the RMA.
SUB_TOTAL_EXCL_DISCOUNT	Subtotal before any discounts are applied.
DISCOUNT_AMOUNT	Discount value applied to the RMA.
SUB_TOTAL	Subtotal after discounts are applied.
FULL_PAYMENT_DATE	Date when the invoice was fully paid.
TAGS	Tags or keywords for categorizing RMAs.
BILL_TO_FIRST_NAME	First name for billing contact.
BILL_TO_LAST_NAME	Last name for billing contact.
BILL_TO_COMPANY_NAME	Company associated with billing.
BILL_TO_ADDR	Billing address.
BILL_TO_ADDR2	Second line for billing address.
BILL_TO_CITY	Billing city.
BILL_TO_STATE	Billing state or province.
BILL_TO_COUNTRY	Billing country.
BILL_TO_ZIP_POSTAL_CODE	Billing postal code.
BILL_TO_PHONE_NUMBER	Billing phone number.
BILL_TO_EMAIL	Billing email address.
SHIP_TO_FIRST_NAME	First name for shipping contact.
SHIP_TO_LAST_NAME	Last name for shipping contact.
SHIP_TO_COMPANY_NAME	Company for shipping contact.
SHIP_TO_ADDR	Shipping address.
SHIP_TO_ADDR2	Second line for shipping address.
SHIP_TO_CITY	Shipping city.
SHIP_TO_STATE	Shipping state or province.
SHIP_TO_COUNTRY	Shipping country.
SHIP_TO_ZIP_POSTAL_CODE	Shipping postal code.
SHIP_TO_PHONE_NUMBER	Shipping phone number.
SHIP_TO_EMAIL	Email for shipping contact.
TAX_ADDRESS_JSON	JSON data for detailed tax address.
CUSTOMER_PO	Customer’s purchase order number for reference.
SALES_REP_ID	ID for the sales representative involved.
CREDIT_MEMO_ID	Identifier for related credit memo.
HEADER_TYPE_ID	Type identifier for the header.
THIRD_PARTY_NOTES	Notes for external or third-party integration.
RMA_HEADER_TYPE_NAME	Name for the RMA header type.
PERMISSION_GROUP_ID	Value for access restriction and permissions.
ASN_NUMBERS	List of linked ASN document numbers.
CREDIT_MEMO_NUMBER	List of linked credit memo numbers and their statuses.
QUALITY_NAME	Quality label for the returned items.
QUALITY_ID	Code identifying the item quality.
ACCOUNT_3PL_TYPE_ID	Third-party logistics account type (if present).
ACCOUNT_3PL_ID	Identifier for third-party logistics account.
ACCOUNT_3PL_NAME	Name of the third-party logistics account provider.
RECEIVING_STATUS	Current status for receiving the returned goods.
ASN_CREATED_DTTM	Date and time when ASN was created for the RMA.
RECEIVING_COMPLETED_DTTM	Date and time when receiving was finished.
PUTAWAY_COMPLETED_DTTM	Date and time when goods were put away after return.
FULFILLED_DTTM	Date and time when the RMA was fully processed.
LAST_ASN_CLOSED_DTTM	Date and time when the last ASN for this RMA was closed.
ORDER_TYPE_NAME	Name describing the order type.
SUB_TYPE_ID	Identifier for the sub-type of order.
CUSTOM_FIELD_VALUE1...50	Custom fields for storing additional information related to headers (available in the Custom Field tab within the header section).
CUSTOMER_ACCOUNT_NUMBER	Customer’s account number for reference.
BRAND_ID	Brand identifier for the returned item.
BRAND_NAME	Brand name for the returned item.
IS_PROCESSED	Indicates if the RMA is fully processed.
CUSTOMER_DEFAULT_SALES_STORE_ID	Default store for customer sales.
CUSTOMER_DEFAULT_SHIP_STORE_ID	Default store for customer shipping.

VW_SALES_ORDER_DETAIL_INFO

Column Name	Description
ORDER_NUMBER	Number used for tracking the sales order (SO Number ).
SHIP_STORE	Store name where the order will be shipped.
SO_ITEM_TYPE_NAME	Type name for the item on the sales order.
ITEM_NUMBER	Unique code used to identify the item.
STATUS	Status for the item line, such as Open, Shipped, or Cancelled.
DESCRIPTION	Details or notes about the item.
BRAND_NAME	Name of the brand for the item.
GROUPNAME	Name of the item’s group or category.
QTY_ORDERED	Quantity ordered for this line item.
TOTAL_PRICE	Total price for this line in the sales order.
BASE_UOM_NAME	Basic unit of measure for the item.
SELL_UOM_NAME	Selling unit of measure used for the item.
UOM_FACTOR	Conversion factor between units of measure.
TAX_CODE_NAME	Name for the tax code applied to this line.
TAX_AMOUNT	Amount of tax for the item line.
RATE_DISP	Display rate (could be price or discount rate) for the item.
SALE_STORE	Name of the store handling the sale.
CUSTOMER_NAME / CUSTOMER	Name of the customer buying the item.
CUSTOMER_ACCOUNT_NUMBER	Account number for the customer.
DATE_ORDER	Date the sales order was created.
ESTIMATE_FOLLOW_UP_DATE	Date for follow-up on sales order estimate.
ESTIMATE_VALID_UNTIL_DATE	Last date the order estimate is valid.
CREATE_SOURCE	Origin system or source of the order.
SO_ID	Identifier for the sales order header.
QTY_SHIPPED	Number of items shipped so far.
DATE_FIRST_SHIP	Date when first shipment occurred.
DATE_LAST_SHIP	Date when the last shipment was made.
DATE_FULFILLED	Date when the item line was fully fulfilled.
DATE_TO_BE_SHIPPED	Planned date to ship this item.
LAST_DATE_TO_BE_SHIPPED	Last allowed ship date for this item.
ID	Unique identifier for the item detail line.
BILL_TO_ADDR, BILL_TO_CITY, ...	Address details for billing to the customer.
SHIP_TO_ADDR, SHIP_TO_CITY, ...	Address details for shipping to the customer.
ORDER_DATE_TO_BE_SHIPPED	Planned ship date for the whole order.
ORDER_LAST_DATE_TO_BE_SHIPPED	Last allowed ship date for the whole order.
CUSTOMER_ID	Unique customer identifier.
ORDER_STATUS	Status name for the entire sales order.
ORDER_STATUS_ID	Status code for the whole order.
SHIP_STORE_ID	Identifier for the ship-from store.
TYPE_ID	Code indicating the type of sales order.
SALES_REP_ID	Identifier for the sales representative.
CUSTOMER_SERVICE_REP_ID	Identifier for the customer service representative.
LINE_STATUS_ID	Status code for the item detail line.
QTY_REMAINING_TO_SHIP	Number of items still left to ship.
STORE_ID	Identifier of the sale store.
TYPE_NAME	Name for the sales order type.
SHIP_METHOD_ID	Code for the shipping method used.
SHIP_METHOD_NAME	Name of the shipping method.
SALES_REP_FULL_NAME	Full name of the sales representative.
CUSTOMER_SERVICE_REP_FULL_NAME	Full name of the customer service representative.
CANCELLED_FLAG	Indicates if the item line is cancelled.
OPEN_FLAG	Indicates if the item line is open.
CLOSE_FLAG	Indicates if the item line is closed.
MAIN_PHONE	Main phone number for customer contact.
NOTES	Additional notes about this item line.
ITEM_ID	Unique identifier for the item.
BOM_ITEM_FLAG	Shows “Y” if item is a bill of materials header, otherwise “N”.
RAW_MATERIAL_FLAG	Shows “Y” if item is a raw material, otherwise “N”.
PURCHASABLE_FLAG	Shows “Y” if item can be purchased, otherwise “N”.
PROJECT_CLASS_ID	Identifier for linked project classification.
PROJECT_CLASS_NAME	Name of linked project classification.
THIRD_PARTY_REF_NO	Reference number for external or third-party system.
THIRD_PARTY_SOURCE	Source name for external transaction.
TAX_DATA	All tax-related details for this line.
CREATE_TIME	Time the item detail line was created.
IS_TAXABLE_ON_SALE	Shows if the item is taxable on sale (yes/no).
CUSTOMER_PO	Customer’s purchase order number (comes from Sales order Header).
BASE_PART_NUMBER, TITLE	Base number and title for the item.
OPTION_1_NAME, OPTION_1_VALUE, ...	Customizable options and values for the item.
SEASON_VALUES	Seasonal classification or notes for the item.
CUSTOM_PRICE_1...CUSTOM_PRICE_14	Custom price fields for specialized pricing or offers.
GENDER_CODE	Code for gender specification (apparel/fashion context).
MATERIAL_NAME	Name of material for the item.
HS_CODE	Harmonized system code for customs/tax use.
COO_CODE_ISO_2	ISO code for country of origin.
UNIT_PRICE, DISCOUNT, EFFECTIVE_UNIT_PRICE	Sales price, applied discount, and final price.
DATE_CANCELLED, DATE_TO_BE_CANCELLED	Cancellation dates for order and item lines.
SALES_NOTES	Additional sales-related notes attached to the item.
ITEM_BARCODE, ITEM_UPC	Barcode and universal product code for the item.
TAGS, REF_NO	User-defined tags and reference number for the order.
ISO_CODE_2, ISO_COUNTRY_NAME	ISO country code and country name for the item’s origin.
TOTAL_ALLOCATED	Total quantity allocated across waves for the item.
WAVE_NUMBERS	Numbers identifying associated shipment waves.
BILL_TO_ADDR2, ...	Extra fields for billing address (second line, first/last name, etc.).
SHIP_TO_ADDR2, ...	Extra fields for shipping address (second line, first/last name, etc.).
CUSTOMER_GROUP_NAME	Name of the customer group if grouped.
ITEM_CATEGORY_NAME	Name of the item’s category.
ITEM_GROUP_NAME	Name of the item’s group (for extra classification).
THIRD_PARTY_DISPLAY_NAME	Display name for any third-party integration.
JOB_SCHEDULE_RUN_FLAG	Shows “1” if created by a scheduled job (otherwise empty).
JOB_SCHEDULE_RUN_FLAG_STR	Value for job schedule, Y or N for the order header.
LINE_JOB_SCHEDULE_RUN_FLAG	Value for job schedule at the detail line level.
LINE_JOB_SCHEDULE_RUN_FLAG_STR	Text value Y or N for line schedule flag.
THIRD_PARTY_SOURCE_HEADER	Source name for external integration at the order header level.
DETAIL_CUSTOM_FIELD_VALUE1...50	Detail-level custom fields for items, maintained and modified from the Custom Fields tab in the Item module
LINE_CREATE_DTTM	Time when this item line was created.
VAS_ITEM_ID, VAS_ITEM_COST	Identifiers and costs for value-added service items.
VAS_ITEM_NAME	Name of the value-added service item.
SHIPPING_COST_REMAINING	Remaining shipping cost still to be invoiced.
SHIP_TO_ADDR_NAME, BILL_TO_ADDR_NAME	Name and contact for ship/bill-to addresses.
SHIPPING_TERMS_ID, SHIPPING_TERM_NAME	Shipping terms identifier and name.
FOB_POINT_ID, FOB_POINT_NAME	Free-on-board point identifier and name.
PAYMENT_TERM_NAME	Name for payment terms.
MODIFY_DTTM, MODIFY_SOURCE	Last modified time and person/system for item line.
ORDER_MODIFY_DTTM, ORDER_MODIFY_SOURCE	Last modified time and person/system for sales order.
BASE_QTY_ORDERED, BASE_QTY_SHIPPED, BASE_QTY_REMAINING_TO_SHIP	Quantities in base unit for ordered, shipped, remaining.
QUALITY	Item quality label or build level.
QTY_NOT_LINKED, ACTIVE_LINKED_QTY	Unlinked and currently linked quantities for this line.
PRIORITY_ID, PRIORITY_CODE_NAME, COLOR_HEX	Priority and color codes for the order.
MEMO, SHIPPING_NOTES, CUSTOMER_MSG	Notes attached to the order or shipping messages.
ORDER_TYPE_ID, ORDER_TYPE_NAME	Order type identifier and order type name.

VW_SALES_ORDER_HEADER_INFO

Column Name	Description
ID	Unique identifier for the sales order.
ORDER_NUMBER	Number used to track and reference the sales order.
STORE_ID	Identifier for the originating store of the order.
SALE_STORE_ID	Identifier for the store making the sale.
STATUS_ID	Code indicating the order’s current status.
BILL_TO_ADDR, BILL_TO_CITY, ...	Address details where the bill will be sent.
SHIP_TO_ADDR, SHIP_TO_CITY, ...	Address information where the goods are shipped.
CURRENCY_ID	Currency reference code for the order.
CURRENCY_RATE	Exchange rate for currency conversion on the order.
CUSTOMER_ID	Identifier for the customer making the purchase.
CUSTOMER_CONTACT	Contact information for the customer.
CUSTOMER_PO	Customer’s purchase order reference or number (comes from Sales Order header).
CREATE_DTTM, CREATE_SOURCE	Date/time and source system when the order was created.
MODIFY_DTTM, MODIFY_SOURCE	Date/time and source system for the last update.
DATE_ORDER	Date when the sales order was created.
DATE_RELEASE	Date when the order was released for processing.
DATE_FIRST_SHIP	First date any goods related to this order were shipped.
DATE_LAST_SHIP	Last date shipping happened for this order.
DATE_FULFILLED	Date when the order was fully completed.
DATE_TO_BE_SHIPPED	Planned or requested ship date for the order.
CUSTOMER_MSG	Message or special instructions from the customer.
PRIORITY_ID, PRIORITY_NAME	Priority code and name for this order.
TYPE_ID, TYPE_NAME	Sales order type code and display name.
RESIDENTIAL_FLAG	Indicates if the shipping address is residential.
VENDOR_PO	Purchase order reference for vendors, if any.
TO_BE_PRINTED_FLAG, TO_BE_MAILED_FLAG, TO_BE_EMAILED_FLAG	Flags to show if this order needs to be printed, mailed, or emailed.
TEMPLATE_ID	Reference for printing or communication templates.
CUSTOMER_CURRENCY_CODE	Code for the customer’s currency.
CUSTOMER_GROUP_ID, CUSTOMER_GROUP_NAME	Identifier and name for the customer’s group classification.
MEMO	Notes or remarks about the order.
SALES_REP_ID, SALES_REP_FULL_NAME	ID and full name of the sales representative.
CUSTOMER_SERVICE_REP_FULL_NAME	Name of the customer service representative for the order.
FOB_POINT_ID, FOB_POINT_NAME	Free-on-board point identifier and description.
CARRIER_ID, CARRIER_NAME	Shipping carrier’s identifier and display name.
SHIPPING_TERMS_ID, SHIPPING_TERM_NAME	Reference and name for terms agreed for shipping.
PAYMENT_TERMS_ID, PAYMENT_TERM_NAME	Reference and name for the payment terms.
SHIP_METHOD_ID, SHIP_METHOD_NAME	Shipping method reference and display name.
SHIP_SERVICE_ID, SHIP_SERVICE_NAME	Service code and name for shipping details.
SHIPPING_TYPE_ID, SHIPPING_TYPE_NAME	Shipping type and description.
SHIPPING_TAX_CODE, SHIPPING_TAX_CODE_NAME	Shipping-related tax code and description.
SHIPPING_COST, SHIPPING_AMOUNT	Cost of shipping and the actual amount collected for shipping.
INVOICE_COUNTER	Counter for how many invoices have been issued against this order.
STORE_NAME, SALE_STORE_NAME	Name for the store that originated or processed the sale.
STATUS_NAME	Status name indicating the current state of the order.
CURRENCY_NAME, CURRENCY_CODE, CURRENCY_SYMBOL	Name, code, and symbol for the currency.
CUSTOMER_NAME, CUSTOMER_ACCOUNT_NUMBER, CUSTOMER_FULL_NAME	Name and account/reference details for the customer.
DEFAULT_CUSTOMER_MESSAGE	Default customer message used for this group or customer profile.
CUSTOMER_TAGS	Tags, keywords, or labels attached to the customer for grouping.
TOTAL_AMOUNT	Full amount to be collected for the sales order before invoicing deductions.
TOTAL_TAX_AMOUNT	Total tax calculated for the sales order.
TOTAL_DEPOSIT	Amount received as deposit for the order.
SHIPPING_TAX_DATA	All tax-related details relevant to shipping.
THIRD_PARTY_DISPLAY_NAME, THIRD_PARTY_ICON_URL, THIRD_PARTY_SOURCE, THIRD_PARTY_REF_NO	Fields for external/partner system integrations.
DATE_TO_BE_CANCELLED, DATE_CANCELLED	Planned and actual cancelled dates for the order.
SHIPPING_THIRD_PARTY_REF_NO	Reference for third-party shipping.
SHIPPING_ACCOUNT_NUMBER	Shipping account on file for this sales order.
ORDER_TYPE_NAME, ORDER_TYPE_CODE	Subtype name and code for order categorization.
DEPOSIT_EMAIL_SENT_FLAG, DEPOSIT_EMAIL_SENT_FLAG_STR	Flags for whether deposit email was sent (with friendly Y/N version).
DEPOSIT_REQUIRED, DEPOSIT_REQUIRED_AMOUNT, DEPOSIT_REQUIRED_AMOUNT_TYPE	Deposit policy/status fields for the order.
ALLOCATION_STATUS_ID, ALLOCATION_STATUS_NAME	Allocation status and name.
ALLOCATION_PERCENTAGE, FULLFILLMENT_PERCENTAGE, ALLOCATION, FULLFILLMENT	Percentage/metrics for allocation and fulfillment.
SUB_TOTAL_EXCL_DISCOUNT	Subtotal before discounts and taxes.
DISCOUNT_AMOUNT, SUB_TOTAL	Value of all discounts applied, and final subtotal after discounts.
TOTAL_QTY	Quantity of all items on the order.
BUYER_ID, BUYER_NAME	ID and name of the assigned buyer.
PROJECT_CLASS_NAME, PROJECT_CLASS_CODE	Project classification details if relevant.
SHIP_TO_FIRST_NAME, ... SHIP_TO_EMAIL	Contact details for shipping destination.
BILL_TO_FIRST_NAME, ... BILL_TO_EMAIL	Contact details for billing.
TAGS	Keywords or labels for categorizing orders.
SALES_REP_GROUPS	List or description of sales rep’s assigned groups.
CAMPAIGN_ID, CAMPAIGN_NAME	Campaign or marketing program associated with the B2B order.
APPROVAL_STATUS_ID, ...	Status of approval workflow, who changed it, and when.
CARD_PAYMENT_PROCESSED_FLAG, CARD_PAYMENT_PROCESSED_FLAG_STR	Was card payment processed (and yes/no display).
RISK_ANALYSIS, THIRD_PARTY_FULFILLMENT_ACCOUNT, ...	Risk and partner fulfillment status flags.
SAVED_CARDS, IS_CARD_ON_FILE, CARD_EXP_STATUS, ...	Saved and default card/payment info for the customer.
JOB_SCHEDULE_RUN_FLAG, JOB_SCHEDULE_RUN_FLAG_STR	Order scheduled for automated processing (and yes/no display).
TRANSFER_PROCESSED_FLAG, TRANSFER_PROCESSED_FLAG_STR	Was transfer processing completed for this order.
TOTAL_AMOUNT_INVOICED, AMOUNT_REMAINING_TO_INVOICE	Invoiced total and what’s left to invoice.
CUSTOM_FIELD_VALUE1...50	Custom fields for storing additional information related to headers (available in the Custom Field tab within the header section).
BRAND_NAME, BRAND_ID	Brand name and identifier linked to order or products.
PRESENTATION_NAME	B2B Presentation name if linked.
IS_CREATED_FROM_B2B_FLAG, ... STR	B2B portal or salesrep creation flags (raw and yes/no text).
LAST_DATE_TO_BE_SHIPPED	Final date allowed to ship items.
DEFAULT_LOCATION_NAME	Name of default warehouse or fulfillment location.
SHIPPING_COST_REMAINING	Shipping costs not yet invoiced.
BILL_TO_ADDR_NAME, ...	Additional details for billing address/contact.
EDI_DOC_STATUS, ...	EDI (electronic document integration) processing status and responses.
IS_PRE_SELL_FLAG_STR	Yes/No indicator if the sales order is flagged as “pre-sell”.
SHIP_TO_INSTRUCTION_FIELD_1...12, ...	Special instructions for shipment and billing (up to 12).
IS_EDI_FLAG, IS_EDI_FLAG_STR	Indicates if the order uses EDI integration (and as Y/N).
IS_EDI_CONFIRMATION_SENT_FLAG, ... STR	Shows if EDI confirmation was sent (and as Y/N text).
PROMISE_DATE, LINE_COUNT	Promise date for delivery and total item lines.
LINKED_MO_ID, LINKED_MO_NUMBER, ...	Manufacturing order links, numbers, and statuses if present.
DEPOSIT_LINK_COUNT, IS_COMBINED	Info on deposit/combined payment applications.
THIRD_PARTY_REF_NAME, THIRD_PARTY_NOTES,	Names and notes for third-party referencing/integration.
WAVE_NUMBERS, INVOICE_NUMBERS_STATUS_NAME, ...	Numbers and statuses for waves, invoices, shipments, credit memos.
CREDIT_MEMO_LINKING, ...	Links and totals for credit memo amounts.
CUSTOMER_EMAIL_MAIN, CUSTOMER_MAIN_PHONE, FAX, CUSTOMER_SERVICE_REP_ID	Main contact info for the customer.
SUB_TYPE_CODE_PREFIX, SUB_TYPE_NAME	Order subtype code and name.
TOTAL_WEIGHT, CARRIER_CODE, SHIP_SERVICE_CODE,	Weight, carrier/service details of order
IS_DROPSHIP	order is drop ship (Y/N).
AUTO_PROCESS_PAYMENT, AUTO_PROCESS_PAYMENT_ID, AUTO_PROCESS_PAYMENT_METHOD_NAME	Auto payment and related details.
SET_PROCESS_CARD_AS_DEFAULT	Flag for card payment settings.
DEFAULT_PAYMENT_METHOD_ID	Default payment option for the customer.
THIRD_PARTY_PAYMENT_GATEWAY_NAME	Payment gateway used for processing.
INVALID_ADDRESS_FLAG	Shows whether the address related to order is invalid.
ACCOUNT_3PL_NAME, ACCOUNT_3PL_CODE, ...	Names and codes for third-party logistics providers.
ITEM_QUALITY_NAME, ITEM_QUALITY_CODE	Label and code for product quality on this order.
REQUIRE_PACK_AND_HOLD, IS_PACK_AND_HOLD	Flags for pack-and-hold fulfillment requirements.
PACK_AND_HOLD_SINCE_DTTM, ...	Timing and user fields around pack-and-hold processing.
CARTON_BREAK_RULE_ID, SO_BATCH_ID, SO_BATCH_NUMBER	Shipping/batching details for order handling.
PACKING_SLIP_NUMBERS	Packing slip document numbers for shipments.
TOTAL_CANCEL_QTY, IS_VAS_REQUIRED, ...	Cancelled quantity, value-added service instructions, flags, and notes.
LAST_WAVE_ATTEMPT_DTTM, PICKED_DTTM, ...	Timestamps for wave of order status changes.
IS_PACK_AND_HOLD_RELEASED, LOCK_FLAG	Status for pack-and-hold release and lock flag.
MINIMUM_ATS_PERCENT, FILL_RATE, FILL_RATE_FAILED_FLAG	Fill rate percentage and fail flag.
LAST_LOCATION_NAME	Last known location for shipping or inventory.
EIN, DUTY_PAYMENT_TERMS, ...	Employer ID Number and duty/tax payment term info.
OLPN_COUNT, PALLET_COUNT	Packing and pallet statistics for the shipment.
CUSTOM_COMMENT	Special comment about this order.
PRIORITY_CODE, DC_ADDR_*, ...	Priority, address, and delivery center contact fields.
VAS_TOTAL, CANCEL_REASON_NAME, ...	Value-added service total, cancel reason name and code.
LINKED_PO_NUMBERS, ...	Related purchase order (PO) numbers for reference.
AUTO_LOCK_PARTIALLY_ALLOCATED_SO, ...	Flags for locking partially allocated/waved sales orders.
CONTACT_NAME	Contact person’s full name.
COLOR_HEX, ACTIVE_LINKED_QTY, ...	Color hex code for display/UI, order quantity statuses.
CUSTOMER_DEPOSIT_NUMBERS	List of deposit numbers assigned to this customer/order.
IS_PRINTED	Order printing flag (Y/N).
LAST_WAVE_DTTM	Timestamp for last wave processing.

VW_TRANSACTIONS

Column Name	Description
PRIMARY_TYPE_ID	Identifier for the main type of account linked to the transaction.
TXN_TYPE_NAME	Descriptive name for the transaction type (such as Payment, Sale, Refund).
TXN_TYPE_ID	Code for the specific transaction type.
TXN_NUMBER	Unique number assigned to this transaction for tracking.
TXN_ID	Unique identifier for this transaction record.
TXN_DATE	Date when the transaction occurred.
ENTITY_NAME	Name of the person, company, or entity involved in the transaction.
ENTITY_ACCOUNT_ID	Account identifier for the involved entity.
STORE_NAME	Name of the store or branch where the transaction happened.
ACCOUNT_ID	Identifier for the account impacted by this transaction.
ACCNT_NUMBER	Number associated with the financial account involved in the transaction.
ACCOUNT_NAME	Name for the financial account (such as “Cash”, “Sales Revenue”, etc.).
REF_ID	Identifier for any document or reference tied to this transaction.
REF_NUMBER	Reference number for a related document or system.
AMOUNT	Amount of money or value for the transaction.
CURRENCY_NAME	Name of the currency used in the transaction.
EXCHANGE_RATE	Exchange rate used if currency was converted.
AMOUNT_HOME_CURRENCY	Transaction amount expressed in the home (base) currency.
QTY	Quantity for items involved in the transaction.
MEMO	Notes or description about the transaction.
CREATE_DTTM	Date and time when this transaction was created.
CREATE_SOURCE	Source system or method of transaction creation.
MODIFY_DTTM	Date and time when the transaction was last changed.
MODIFY_SOURCE	Source system or user of last transaction update.
REF_NUMBER_2	Additional reference number for alternate tracking.
DEBIT	Debit side value for this transaction.
CREDIT	Credit side value for this transaction.
TAX_REF_ID	Reference identifier for any taxes applied.
F_ACCNT_TYPE_ID	Identifier for the financial account type used.
PRIMARY_TYPE_NAME	Main category name for the account (like “Asset”, “Liability”, etc.).
RECONCILED_FLAG	Shows whether this entry has been reconciled (yes/no).
DEBIT_AMOUNT	Amount recorded as debit in the account.
CREDIT_AMOUNT	Amount recorded as credit in the account.
STATUS	Status or current state for this transaction (e.g., Posted, Voided).
RECONCILE_BNK_TXN_ID	Reference to a bank reconciliation record, if any.
ID	Another unique identifier for the transaction row.
CUSTOM_FIELD	Space for custom data or notes specific to your business needs.
CURRENCY_ID	Reference code for the currency used.
PROJECT_CLASS_ID	ID for linked project class if the transaction is project-related.
PROJECT_CLASS_NAME	Name for the linked project classification.
ITEM_NUMBER	Item code or SKU involved in the transaction, if any.
STORE_ID	Identifier for the store location where the transaction occurred.
ITEM_TYPE_ID	Code for the type of item involved.
ITEM_ID	Unique identifier for any item involved in the transaction.
DEPOSITED_FLAG	Shows if the transaction amount was deposited.
TAX_CODE_ID	Tax code applied for this transaction.
SALES_REP_ID	Identifier for the sales or account rep related to this entry.
IS_CLOSING_ENTRY	Indicates if this is a closing (year-end) accounting entry.
RECONCILE_DTTM	Date/time when this transaction was reconciled.
RECONCILE_SOURCE	System/user that performed transaction reconciliation.
ENTITY_TYPE_NAME	Type or classification of the entity (such as Customer, Vendor, Store).
CURRENCY_CODE	Code for the transaction’s currency (USD, EUR, etc.).
CURRENCY_SYMBOL	Currency symbol for display (like $, €, ¥).
ACCOUNT_TYPE_NAME	Account type description (such as Checking, Credit, Revenues).
CUSTOMER_ID	Unique identifier for the customer involved.
HOME_CURRENCY_SYMBOL	Symbol for the organization’s main (base) currency.
HOME_CURRENCY_CODE	Code for the organization’s main (base) currency.
ITEM_CATEGORY_NAME	Name of the category for the relevant item.
ITEM_BRAND_NAME	Brand name for the relevant item.
BASE_PART_NUMBER	Base number or main product code.
PRODUCT_TITLE	Title or descriptive name for the product involved.
PRODUCT_CATEGORY_NAME	Product category descriptor or name.
ROOT_PROJECT_CLASS_NAME	Name for the highest-level project class in hierarchy.
PARENT_PROJECT_CLASS_NAME	Name for the parent project class within hierarchy.

VW_USER_DETAIL

Column Name	Description
ID	Unique identifier for the user record.
USER_ID	System login ID or username for the user.
ROLE_ID	Identifier for the role assigned to the user.
FIRST_NAME	User’s first name.
LAST_NAME	User’s last name.
EMAIL_ADDR	User’s email address.
ACTIVE_FLAG	Flag (1 or 0) showing if the user is active.
ACTIVE_FLAG_STR	“Y” if user is active, “N” if not.
TEMP_PASS_FLAG	Indicates if the user is currently using a temporary password.
ACCNT_LOCK_FLAG	Shows if the user account is locked.
ACCNT_LOCK_DTTM	Date and time when the account was locked.
UNSUCCESSFUL_LOGIN_COUNT	Number of failed login attempts.
LAST_LOGIN_ATTEMPT_DTTM	Timestamp of the last login attempt.
CREATE_DTTM	Date and time when the user record was created.
CREATE_SOURCE	Source system or origin of the user record.
MODIFY_DTTM	Date and time when the record was last modified.
MODIFY_SOURCE	Source or user responsible for the last modification.
ROLE_NAME	Descriptive name of the user’s role.
RESET_KEY	Key used to reset the user’s password.
ACCESS_TYPE	Identifier for the user's access type.
ACCESS_TYPE_NAME	Descriptive name for the user’s access type.
DASHBOARD_ID	ID of the dashboard linked to the user's role.
DASHBOARD_NAME	Name of the dashboard the user sees upon login.
IMAGE_URL	URL to the user’s profile or avatar image.
AUTO_WATCHER_FLAG	Flag indicating if the user has automatic watcher privileges.
USER_TYPE	Type code of the user (e.g., internal, external).
EMAIL_VERIFY_FLAG	Flag indicating if the user’s email is verified.
ACCOUNT_NUMBER	Account number linked to the user.
IS_SILENT_USER	Flag showing if the user is silent (non-active) 1/0.
IS_SILENT_USER_STR	“Y” or “N” string version of the silent user flag.
DEFAULT_PAGE	Page shown by default when the user logs in.
CUSTOMER_ID	Customer ID associated with the user.
PHONE_NUMBER	User’s phone number.

VW_VENDOR_CREDIT_EXPENSE_LINE

Column Name	Description
ID	Unique identifier for this vendor credit expense line.
LINE_SEQ	Sequence number for ordering lines within the vendor credit document.
VENDOR_CREDIT_ID	Reference to the vendor credit document this line belongs to.
TXN_ID	Transaction identifier for this line.
TXN_NUMBER	Transaction number associated with this line.
ACCOUNT_ID	Identifier for the financial account used in this expense line.
ACCOUNT_NAME	Name of the financial account for this expense.
AMOUNT	Amount of the expense on this line.
TAX_CODE_ID	Tax code applied to this expense line.
TAX_AMOUNT	Amount of tax charged on this expense line.
MEMO	Notes or comments related to this expense line.
TAX_AMT_NON_COLLECTABLE	Portion of tax amount not collectible (e.g., exempt).
CREATE_DTTM	Date and time when this line was created.
CREATE_SOURCE	System or process that created this entry.
MODIFY_DTTM	Date and time when this line was last modified.
MODIFY_SOURCE	System or person who last modified this line.
STATUS_ID	Status code indicating state of this line (e.g., posted, pending).
PROJECT_CLASS_ID	Identifier linking this line to a specific project classification.
VENDOR_CREDIT_NUMBER	Number identifying the vendor credit document.
REF_NO	Reference number associated with this vendor credit (comes from Vendor Credit Header).
TXN_DATE	Date of the vendor credit transaction.
VENDOR_NAME	Name of the vendor issuing the credit.
PERMISSION_GROUP_ID	Identifier for permission or security group related to vendor.

VW_VENDOR_CREDIT_HEADER_INFO

Column Name	Description
ID	Unique identifier for the vendor credit document.
VENDOR_CREDIT_NUMBER	Number assigned to the vendor credit for tracking.
TXN_ID	Identifier for the transaction within the system.
TXN_NO	Transaction number for the vendor credit.
STORE_ID	Store identifier related to the vendor credit.
VENDOR_ID	Identifier for the vendor who issued the credit.
ACCNT_PAYABLE_ID	Identifier for accounts payable account linked to this credit.
TXN_DATE	Date of the vendor credit transaction.
CURRENCY_ID	Currency identifier associated with the credit.
EXCHANGE_RATE	Exchange rate applied to the credit amount, if relevant.
REF_NO	Reference number for external or internal use.
MEMO	Notes or remarks related to the credit.
TOTAL_AMOUNT	Total amount credited by the vendor.
CREATE_DTTM	Date and time when this credit was created.
CREATE_SOURCE	Source system or process creating the record.
MODIFY_DTTM	Date and time of the last modification of this credit record.
MODIFY_SOURCE	Source or user that modified the record.
STATUS_ID	Current status code of the vendor credit.
AMOUNT_USED	Amount of the credit that has been applied or used.
AMOUNT_REMAINING	Remaining credit amount available for use.
STATUS_NAME	Descriptive name of the credit's status.
STORE_NAME	Name of the store linked to the credit.
ACCOUNT_NAME	Name of the accounts payable account related to the credit.
CURRENCY_CODE	Currency code such as USD, EUR.
CURRENCY_SYMBOL	Symbol for the currency (like $, €, ¥).
VENDOR_NAME	Name of the vendor issuing the credit.
TAX_SUMMARY_DATA	Summary of tax information related to this credit.
REPORTING_DATA	Data fields used for reporting or analytics.
OPENING_BALANCE_FLAG	Flag showing if this is an opening balance transaction.
SYS_LOCK_FLAG	Flag indicating if the credit is locked for system processes.
UNPOST_TRANS_FLAG	Flag whether transactions related to this credit are unposted.
AMOUNT_REFUNDED	Amount refunded by the vendor on this credit.
CURRENCY_NAME	Full name of the currency (e.g., United States Dollar).
VENDOR_INT_ACCNT_ID	Internal account identifier for the vendor.
STORE_CODE	Code for the store linked to the credit.
PROJECT_CLASS_ID	Identifier for the project classification, if applicable.
PROJECT_CLASS_NAME	Name for the linked project classification.
DISCOUNT_AMOUNT	Total discounts included in the credit.
TAX_ADJ_ARR_JSON	JSON formatted tax adjustment details.
RECONCILED_FLAG	Indicates whether the credit is reconciled.
DEPOSITED_FLAG	Flag indicating if the credit amount is deposited.
PERMISSION_GROUP_ID	Security or permission group related to the vendor.
SHIP_FROM_ADDR	Shipping origin address line 1.
SHIP_FROM_ADDR2	Shipping origin address line 2.
SHIP_FROM_CITY	City of the shipping origin.
SHIP_FROM_STATE	State or province of the shipping origin.
SHIP_FROM_COUNTRY	Country of the shipping origin.
SHIP_FROM_ZIP_POSTAL_CODE	Zip or postal code of the shipping origin.
SHIP_TO_ADDR	Shipping destination address line 1.
SHIP_TO_ADDR2	Shipping destination address line 2.
SHIP_TO_CITY	City of the shipping destination.
SHIP_TO_STATE	State or province of the shipping destination.
SHIP_TO_COUNTRY	Country of the shipping destination.
SHIP_TO_ZIP_POSTAL_CODE	Zip or postal code of the shipping destination.
ENTITY_USE_CODE	Code related to vendor's entity use or tax classification.
TAX_SERVICE_REF_NAME	Reference name for tax services related to this credit.
TAX_SERVICE_HASH_CODE	Hash code used for tax service identification or tracking.

VW_VENDOR_CREDIT_LINE_INFO

Column Name	Description
ID	Unique identifier for each vendor credit line item.
VENDOR_CREDIT_ID	Identifier for the parent vendor credit document.
TXN_ID	Transaction ID for this credit line.
TXN_NUMBER	Transaction number associated with this credit line.
LINE_SEQ	Sequence number for line ordering within the credit document.
ITEM_ID	Identifier for the item referenced in this credit line.
ITEM_TYPE_ID	Code for the item type.
ITEM_TYPE_NAME	Name describing the type of item.
ITEM_NUMBER	Item’s unique identifying number or SKU.
DESCRIPTION	Text describing details about this line item.
RATE	Unit price or rate applied to this line item.
QTY	Quantity associated with this line item.
AMOUNT	Total amount for this credit line.
TAX_CODE_ID	Code for tax applied on this line item.
TAX_CODE_NAME	Tax code name for the applied tax.
TAX_AMT_NON_COLLECTABLE	Tax amount that is not collectible.
TAX_AMOUNT	Total tax amount for this line item.
CREATE_DTTM	Date and time this line was first created.
CREATE_SOURCE	System or method used originally to create this line.
MODIFY_DTTM	Date and time of the most recent update to this line.
MODIFY_SOURCE	System or user who last updated this line.
STATUS_ID	Status code representing current state of the line.
UOM_ID	Identifier for the unit of measure used.
UOM_NAME	Name of the unit of measure (e.g., each, box).
PROJECT_CLASS_ID	Project classification identifier related to this line.
DECIMAL_FLAG	Indicator if unit of measure supports decimal quantities.
PROJECT_CLASS_NAME	Name of the linked project classification.
IS_TAXABLE_ON_PURCHASE	Flag indicating if the item is taxable on purchase.
VENDOR_CREDIT_NUMBER	Number for the associated vendor credit document.
TXN_DATE	Date of the vendor credit transaction document.
REF_NO	Reference number related to the vendor credit.
VENDOR_NAME	Name of the vendor issuing the credit.
DISCOUNT	Discount value applied to this line item.
DISCOUNT_TYPE_ID	Type of discount applied (percentage, fixed, etc.).
NOTES	Additional notes or comments for this credit line.
PERMISSION_GROUP_ID	Security group ID restricting access to this vendor’s data.
TAX_DATA	Detailed tax information for this line.
TAX_CATEGORY_CODE	Code classifying the tax category for the item.
UOM_FACTOR	Conversion factor to base unit of measure.
BASE_QTY_ORDERED	Quantity originally ordered in the base unit of measure.
BASE_QTY_SHIPPED	Quantity shipped in the base unit of measure.
BASE_QTY_REMAINING_TO_SHIP	Remaining quantity to ship in base unit of measure.
BASE_UOM_ID	Identifier for the base unit of measure.
BASE_UOM_NAME	Name of the base unit of measure.
DEFAULT_PURCHASE_UOM_ID	Item’s default unit of measure for purchase transactions.
ALTERNATIVE_ITEM_NUMBER1	First alternate item number for substitutions or mapping.
ALTERNATIVE_ITEM_NUMBER2	Second alternate item number.
ALTERNATIVE_ITEM_NUMBER3	Third alternate item number.

VW_VENDOR_INFO

Column Name	Description
NAME	Name of the vendor or supplier.
ID	Unique identifier for the vendor.
ALERT_NOTE	Important alert or notification related to the vendor.
PAYMENT_TERM	Terms of payment agreed with the vendor.
LEAD_TIME_DAYS	Average lead time (in days) for vendor to fulfill orders.
TAX_CODE	Default tax code associated with the vendor.
CREDIT_LIMIT	Maximum credit amount allowed for vendor transactions.
MIN_ORD_AMOUNT	Minimum order amount required by the vendor.
CURRENCY_CODE	Currency code used for transactions with this vendor.
VENDOR_TYPE	Classification or type of vendor.
COMPANY_NAME	Registered company name of the vendor.
CONTACT_FIRST_NAME	First name of the vendor contact person.
CONTACT_LAST_NAME	Last name of the vendor contact person.
MAIN_PHONE	Main telephone number of the vendor.
WORK_PHONE	Optional work phone number of the vendor.
MOBILE_PHONE	Mobile phone number for the vendor contact.
FAX	Fax number, if used by the vendor.
EMAIL_MAIN	Primary email address for the vendor.
EMAIL_CC	Carbon copy email, if vendor communications copy others.
OTHER_CONACT_INFO	Additional contact information.
NAME_ON_CHEQUE	Name to put on cheque payments.
BUSINESS_NUMBER	Registered business number (tax ID, VAT number, etc.).
IS_T4A_ELIGIBLE	Indicates if vendor is eligible for T4A tax form reporting.
IS_T5018_ELIGIBLE	Indicates if vendor is eligible for T5018 tax form reporting.
SALE_TAX_AGENCY	Indicates if vendor is a sales tax agency.
COUNTRY	Country of the vendor.
BILLED_FROM_ADDR	Billing address line 1.
BILLED_FROM_CITY	Billing city.
BILLED_FROM_STATE	Billing state or province.
BILLED_FROM_COUNTRY	Billing country.
SHIPPED_FROM_ADDR	Physical shipping address line 1.
SHIPPED_FROM_CITY	Shipping city.
SHIPPED_FROM_STATE	Shipping state or province.
SHIPPED_FROM_POSTAL_CODE	Shipping postal/zip code.
SHIPPED_FROM_COUNTRY	Shipping country.
ACCNT_NUMBER	Vendor’s internal account number.
BILLED_FROM_POSTAL_CODE	Postal code for billing address.
SHIPPED_FROM_ADDR_ID	Identifier for shipping address record.
BILLED_FROM_ADDR_ID	Identifier for billing address record.
INT_ACCNT_ID	Internal accounting ID for the vendor.
ACTIVE_FLAG	Flag indicating if vendor is active.
ACCNT_PAYABLE_NAME	Name of accounts payable account linked to this vendor.
ACCNT_EXPENSE_NAME	Name of expense account for vendor-related costs.
VENDOR_SINCE_DATE	Date the vendor was first added to the system.
JOB_TITLE	Vendor’s contact job title.
CREATE_DTTM	Date and time when vendor record was created.
CREATE_SOURCE	Source system or person creating the vendor record.
MODIFY_DTTM	Date and time of last vendor record modification.
MODIFY_SOURCE	Source or person responsible for last modification.
BILLING_PHONE	Phone number for billing contact.
BILLING_EMAIL	Email address for billing contact.
BILLED_FROM_ADDR_2	Second line for billing address.
BILLED_FROM_FIRST_NAME	First name of billing contact.
BILLED_FROM_LAST_NAME	Last name of billing contact.
BILLED_FROM_COMPANY_NAME	Billing company name.
BILLED_FROM_PHONE_NUMBER	Billing contact phone number.
BILLED_FROM_EMAIL	Billing contact email.
IS_1099_VENDOR	Indicates if vendor receives 1099 tax reporting form.
IS_1099_VENDOR_STR	“Yes” if vendor is 1099 eligible, otherwise “No”.
SHIPPED_FROM_ADDR_2	Second line of shipping address.
SHIPPED_FROM_FIRST_NAME	First name of shipping contact.
SHIPPED_FROM_LAST_NAME	Last name of shipping contact.
SHIPPED_FROM_COMPANY_NAME	Company name for shipping contact.
SHIPPED_FROM_PHONE_NUMBER	Phone number for shipping contact.
SHIPPED_FROM_EMAIL	Email for shipping contact.
AVERAGE_LEAD_TIME_DAYS	Calculated average lead time for the vendor’s last purchase orders.
PERMISSION_GROUP_ID	Security group identifier for controlling access.
PERMISSION_GROUP_NAME	Name of the permission group.
ENTITY_USE_CODE	Tax or entity classification code for vendor (used in tax reporting).
CUSTOM_FIELD_VALUE1…50	Custom fields for storing additional information related to headers (available in the Custom Field tab within the header section).
IS_ACTIVE_FLAG_STR	“Y” if the vendor is active, otherwise “N”.
DEFAULT_PAYMENT_METHOD_NAME	Vendor’s preferred payment method name.
CARRIER_NAME	Name of the default shipping carrier used by the vendor.
SHIP_SERVICE_NAME	Name of default shipping service.
SHIPPING_ACCOUNT_NUMBER	Account number for vendor shipping.
DELIVERY_METHOD_NAME	Name of the delivery method.
SHIPPING_TERM_NAME	Name of the shipping terms.
FOB_NAME	Name of freight on board point (FOB).
ACCOUNT_3PL_NAME	Name of the third-party logistics account associated with the vendor.
ACCOUNT_3PL_CODE	Code for the third-party logistics account.
ACCOUNT_3PL_DESC	Description of the third-party logistics account.
VENDOR_3PL_TYPE_NAME	Type description of the vendor's third-party logistics provider.
ACCOUNT_3PL_TYPE_ID	Identifier for the vendor’s third-party logistics account type.
ACCOUNT_3PL_ID	Identifier for the vendor’s third-party logistics account.
DEFAULT_ORDER_TYPE_NAME	Vendor’s default order type name.
DEFAULT_ACCNT_PAYABLE_SUSPENSE_NAME	Name of the default accounts payable suspense account.
DEFAULT_ACCNT_PAYABLE_SUSPENSE_FLAG	Flag indicating use of payable suspense account.
DEFAULT_ACCNT_PAYABLE_SUSPENSE_ID	Identifier of the default payable suspense account.
SOCIAL_SECURITY_NUMBER	Vendor’s social security number, if applicable.
FEDERAL_ID	Federal tax ID for the vendor.

VW_WAVE_DETAIL_ALLOCATION_INFO

Column Name	Description
STORE_NAME	Name of the store related to the wave allocation.
STORE_CODE	Code identifying the store.
UNIT_PRICE	Effective unit price for the sales order line item.
ORDER_NUMBER	Order number if the wave is linked to a sales order (ID=10 type).
MO_NUMBER	Manufacturing order number.
REF_NO	Reference number for the sales order (comes from the Sales Order Header)
DISP_LOCN	Display location name for picking or shipping.
WAVE_NUMBER	Identifier for the shipment wave.
TYPE_NAME	Name describing the wave type (e.g., shipping, transfer).
TYPE_ID	ID for the wave type.
CUSTOMER_NAME	Name of the customer associated with the order.
DESCRIPTION	Product description.
ITEM_TYPE_NAME	The category or type name for the item.
ITEM_UPC	Universal Product Code (UPC) for the item.
ITEM_TAGS	Tags or keywords attached for item identification.
LOCK_FLAG_STR	"Y" if the wave is locked, otherwise "N".
JOB_SCHEDULE_RUN_FLAG_STR	"Y" if scheduled for job processing, otherwise "N".
LINE_JOB_SCHEDULE_RUN_FLAG_STR	"Y" if the line item is scheduled for job processing, otherwise "N".
TOTAL_AMOUNT	Total value for the order or shipment.
TOTAL_DEPOSIT	Deposit amount paid on the order.
TAGS	Tags added for categorization.
BILL_TO_FIRST_NAME	First name of the billing contact.
BILL_TO_LAST_NAME	Last name of the billing contact.
SHIP_TO_FIRST_NAME	First name of the shipping contact.
SHIP_TO_LAST_NAME	Last name of the shipping contact.
PLANNED_SHIP_DATE	Date planned for shipment.
CREATE_DATE	Date when the wave detail was created.
STATUS_NAME	Name of the current allocation status.
PERMISSION_GROUP_ID	Security group ID for access control.
ZONE_NAME	Zone name within the location (e.g., zone in warehouse).
CUSTOMER_TYPE	Type of customer (e.g., regular, VIP).
ALLOC_JOB_SCHEDULE_RUN_FLAG_STR	"Y" if job scheduled for allocation, otherwise "N".
ILPN_NUMBER	Internal LPN (License Plate Number) for pallets.
ILPN_IS_VIRTUAL_LPN	Flag if the LPN is virtual.
LOT_NUMBER	Lot number for traceability.
LPN_BATCH_NUMBER	Batch number for the pallet or license plate.
MFG_DATE	Manufacturing date of the product.
EXP_DATE	Expiry date of the product.
SHIP_TO_ADDR	Shipping address details.
SHIP_TO_CITY	Shipping city.
SHIP_TO_STATE	Shipping state or region.
SHIP_TO_COUNTRY	Shipping country.
SHIP_TO_ZIP_POSTAL_CODE	Shipping postal or zip code.
SHIP_TO_EMAIL	Shipping email contact.
SHIP_TO_PHONE_NUMBER	Shipping phone number.
SHIP_TO_ADDR2	Second line of the shipping address.
SHIP_TO_COMPANY_NAME	Shipping company.
DATE_ORDER	Order date.
AUTO_CLOSE_SO_LINE	Flag for auto-closing sales order lines.
PICK_STRATEGY_ID	Picking strategy ID.
CARTON_BREAK_RULE_ID	Carton break rule ID for splitting shipments.
FORCE_PICK_STRATEGY_FLAG	Flag to enforce pick strategy.
ALLOCATION_TYPE	Type of allocation (e.g., shipping, transfer).
PICK_TYPE_NAME	Name of the picking method.
PALLET_NAME	Pallet license plate number.
OLPN	Out License Plate Number, for legacy or tracking.
TASK_ID	Task identifier linked to the pick or move.
BASE_PART_NUMBER	Product base part number.
OPTION_1_VALUE	First option value (e.g., size, color).
OPTION_2_VALUE	Second option value.
OPTION_3_VALUE	Third option value.
LPN_NUMBER	License plate number, based on pick type (shipping or transfer).
ACCOUNT_3PL_NAME	Name of third-party logistics provider.
ACCOUNT_3PL_CODE	Third-party logistics account code.
ACCOUNT_3PL_DESC	Description of third-party logistics account.
BRAND_NAME	Brand associated with the item.
CUSTOMER_PO	Customer purchase order number.
SHIPPING_NOTES	Additional notes for shipping instructions.
SHIP_SERVICE_NAME	Name of the shipping service.
IS_PRINTED_FLAG	Flag indicating if the label/tag is printed.
QUALITY_NAME	Name of the quality grade or type.
QUALITY_CODE	Code for the quality grade.

VW_WAVE_DETAIL_INFO

Column Name	Description
ID	Unique identifier for the wave detail record.
STORE_NAME	Name of the store related to the wave detail.
STORE_ID	Identifier for the store.
WAVE_ID	Identifier linking this detail to a shipment wave.
SO_ID	Sales order ID linked to this wave detail (if applicable).
SO_LINE_ID	Sales order line item ID for this wave detail.
ITEM_NUMBER	Master item number or SKU.
ITEM_ID	Unique identifier of the product item.
QTY_TO_PICK	Quantity of items to be picked in this wave.
QTY_ALLOCATED	Quantity allocated for picking.
QTY_PICKED	Quantity already picked.
STATUS_ID	Current status code for the wave detail.
CREATE_DTTM	Timestamp when wave detail was created.
CREATE_DATE	Date part of the creation timestamp.
CREATE_TIME	Time part of the creation timestamp.
CREATE_SOURCE	System or user who created the record.
MODIFY_DTTM	Timestamp of the latest modification.
MODIFY_TIME	Time part of modification timestamp.
MODIFY_SOURCE	System or user who last modified the record.
NOTE	Any notes or special comments related to the wave detail.
CLOSE_FLAG	Flag indicating if the wave detail is closed.
SHIP_FLAG	Flag indicating if the wave detail has been shipped.
STATUS_NAME	Text description of the current status.
LINKED_WAVE_LINE_ID	ID linking to another wave line if applicable.
THIRD_PARTY_SHIPMENT_ID	External ID for third-party logistics or shipment tracking.
WAVE_NUMBER	Identifier for the wave shipment of SO.
ORDER_NUMBER	Order number from linked sales or manufacturing order.
ITEM_TYPE_ID	Item type code.
ITEM_TYPE_NAME	Name describing the item type.
DECIMAL_FLAG	Flag indicating if the unit allows decimal quantities.
MO_ID	Manufacturing order linked to this wave detail.
MO_LINE_ID	Manufacturing order line linked to this wave detail.
TYPE_ID	Type ID of the wave (shipping, transfer, etc.).
TYPE_NAME	Description of the wave type.
WAVE_STATUS_ID	Status ID of the wave header.
WAVE_STATUS_NAME	Description of the wave status.
THIRD_PARTY_SOURCE	Source system name for third-party integration.
ITEM_UPC	Universal Product Code for the item.
DESCRIPTION	Item description.
UNIT_PRICE	Effective unit price for the item.
LOCK_FLAG	Indicator if the wave is locked.
LOCK_FLAG_STR	“Y” or “N” for lock flag.
JOB_SCHEDULE_RUN_FLAG_STR	Indicates if the wave is part of a scheduled job (Y/N).
CUSTOMER_NAME	Name of the customer associated with the order.
TOTAL_AMOUNT	Total amount of the sales order.
TOTAL_DEPOSIT	Total deposit amount paid for the order.
REF_NO	Reference number for the sales order.
ITEM_PRODUCT_CATEGORY_NAME	Category name for the item.
ITEM_TAGS	Tags or keywords associated with the item.
TAGS	Tags or keywords associated with the order.
LINE_JOB_SCHEDULE_RUN_FLAG	Flag if the line item is scheduled for job processing.
LINE_JOB_SCHEDULE_RUN_FLAG_STR	“Y” / “N” for line job schedule flag.
PREVIEW_FLAG_STR	“Y” if preview flag is set for the wave, otherwise “N”.
CUSTOMER_TYPE	Type of customer (e.g., regular, VIP).
BILL_TO_FIRST_NAME	Billing contact first name.
BILL_TO_LAST_NAME	Billing contact last name.
SHIP_TO_FIRST_NAME	Shipping contact first name.
SHIP_TO_LAST_NAME	Shipping contact last name.
SHIP_METHOD_ID	Shipping method code.
CARRIER_ID	Carrier code for the shipment.
SHIP_SERVICE_ID	Shipping service code.
SHIP_METHOD_NAME	Name of the shipping method.
PLANNED_SHIP_DATE	Scheduled date for shipment.
SHIPPING_COST_REMAINING	Remaining amount of shipping costs not invoiced yet.
BUYER_NAME	Name of the buyer associated with the order.
DEFAULT_LOCATION	Name of the default warehouse or location.
CUSTOMER_ON_HOLD	Flag indicating if the customer is on hold.
BILL_TO_ADDR_NAME	Billing address label for easy identification.
SHIP_TO_ADDR_NAME	Shipping address label for easy identification.
ACCNT_NUMBER	Customer’s account number.
HS_CODE	Harmonized system (customs) code for the item.
IMAGE_PATH	Path to item image or photo.
SALES_NOTES	Sales notes related to the item.
ALTERNATIVE_ITEM_NUMBER1,2,3	Other item numbers for substitutions or mapping.
CUSTOMER_NUMBER	Padded customer ID for display or lookup.
DATE_ORDER	Date when the order was placed.
TO_STORE	Destination store for the transfer, if any.
TO_STORE_LOCATION	Location name of the destination store.
TRANSFER_PO_NUMBER	Purchase order number for transfer.
CUSTOMER_ITEM_NUMBER	Customer’s item number, overrides item default if present.
EXTERNAL_ITEM_NUMBER	External item reference number.
THIRD_PARTY_DISPLAY_NAME	Display name for third-party ERP or integrations.
BASE_UOM_ID	ID for the base unit of measure.
UOM_FACTOR	Quantity conversion factor.
BASE_QTY_TO_PICK	Quantity to pick measured in base unit of measure.
BASE_QTY_ALLOCATED	Quantity allocated for pick in base unit of measure.
BASE_QTY_PICKED	Quantity already picked in base unit of measure.
BASE_UOM_NAME	Name for the base unit of measure.
ITEM_NOTES	Notes attached to the specific item line.
THIRD_PARTY_NOTES	Notes for third-party systems or fulfillment.
THIRD_PARTY_REF_NAME	Reference name for third-party system.
ORDER_TYPE_NAME, ORDER_TYPE_CODE	Name and code for the order’s subtype.
BACK_ORDER_QTY	Quantity on backorder.
CONSUMED_LPNS	Number of license plate numbers consumed in picking.
PRODUCED_LPNS	Number of license plate numbers produced or generated.
ORIGINAL_WAVE_NUMBER	Original wave number for reference.
SALES_REP_GROUP	Groups or teams the sales representative belongs to.
OPTION1_CODE, OPTION2_CODE, OPTION3_CODE	Codes for customizable product options.
BASE_PART_NUMBER	Main product number or SKU base.
LOT_NUMBER	Lot number for batch tracking.
BATCH_NUMBER	Batch number related to the lot.
ITEM_STANDARD_UNIT_PRICE	Standard price per unit for the item.
ITEM_STANDARD_UNIT_COST	Standard cost per unit for the item.
AUTO_CLOSE_SO_LINE	Flag indicating if the sales order line auto-closes.
OPTION_1_VALUE, OPTION_2_VALUE, OPTION_3_VALUE	Values for customizable options on the item.
ITEM_SO_UNIT_PRICE	Unit price specifically from sales order detail.
ACCOUNT_3PL_NAME	Third-party logistics account name.
ACCOUNT_3PL_CODE	Third-party logistics account code.
ACCOUNT_3PL_DESC	Description for the third-party logistics account.
QTY_ON_REPLEN	Quantity currently on replenishment.
TOTAL_REPLEN_QTY_ALLOCATED	Total replenishment quantity allocated.
TOTAL_REPLEN_QTY_PICKED	Total replenishment quantity picked.
MISSING_ITEM_QTY	Quantity missing for the order or pick.
SO_BATCH_NUMBER	Batch number for the sales order.
SO_BATCH_ID	Batch identifier for the sales order.
CURRENT_OLPN_COUNT	Current count of outgoing license plate numbers.
ORIGINAL_MISSING_ITEM_QTY	Original missing quantity before adjustments.
SHIPPING_NOTES	Notes related to shipping instructions.
ITEM_GTIN, ITEM_BARCODE	Global trade item numbers and barcodes.
VAS_ITEM_COST_TOTAL	Total cost for value-added services.
DISCOUNT, DISCOUNT_PER_QTY, DISCOUNT_PER_QTY_TYPE, DISCOUNT_PERCENTAGE, DISCOUNT_TYPE_ID	Various discount details applied.
QTY_ORDERED	Quantity ordered for this item.
BRAND_NAME	Brand associated with the item.
CUSTOMER_ID	Customer’s unique identifier.
INVOICE_ID	Related invoice identifier.
CUSTOMER_CURRENCY_CODE	Currency code of the customer.
CURRENCY_RATE	Exchange rate applied in the transaction.
QUALITY_CODE	Quality code or classification for the item.
QUALITY_NAME	Quality name or description.
CUSTOMER_PO	Customer purchase order reference.
SHIP_SERVICE_NAME	Name of the shipping service used.
TAX_AMOUNT	Tax amount for the item or order line.
COO_CODE_ISO_2	Country of origin ISO code (2-letter).
ISO_CODE_3	3-letter ISO country code.
ISO_COUNTRY_NAME	Name of the country for ISO code.
IS_PRINTED_FLAG	Flag indicating if the wave labels or documents have been printed.
RESTRICT_LINE_ITEM_FOR_3PL	Flag restricting line item in third-party logistics.
ITEM_BRAND_NAME	Brand name linked to the item.

VW_WAVE_HEADER_INFO_EXT

Column Name	Description
LINE_COUNT	Total number of lines included in the wave.
UNIT_COUNT	Total quantity of units involved in the wave.
STORE_ID	Identifier for the store responsible for the wave.
WAVE_CREATED_VIA_QUICK_SHIP	Flag indicating if the wave was created using quick ship functionality.
ID	Unique identifier for the wave header record.
WAVE_NUMBER	Number used to identify and track the wave.
IS_PRINTED_FLAG	Flag indicating if the shipping documents or labels have been printed.
IS_PRINTED_FLAG_STR	User-friendly "Y" or "N" display for printed flag.
STATUS_ID	Code representing current status of the wave.
CREATE_SOURCE	Source or system from where the wave record was created.
CREATE_DTTM	Date and time when the wave record was created.
MODIFY_DTTM	Date and time of the most recent modification.
MODIFY_SOURCE	Source or user responsible for the latest modification.
PRIORITY_ID	Identifier for the priority level assigned to the wave.
NOTE	Notes or comments related to the wave operation.
STORE_NAME	Name of the store responsible for this wave.
STATUS_NAME	Text description of the wave’s current status.
PRIORITY_NAME	Name or description of the priority level.
TYPE_ID	Identifier for the wave type (e.g., sales order wave, manufacturing wave).
TYPE_NAME	Name describing the type of wave.
CREATE_DATE	Date part extracted from create timestamp.
WAVE_CLOSE_DTTM	Date and time when the wave was closed.
JOB_SCHEDULE_RUN_FLAG	Flag indicating if the wave was created via scheduled job.
AUTO_CLOSE_SO_FLAG	Flag indicating if sales order lines auto-close when wave completes.
IS_MERGED_FLAG	Flag showing if this wave is merged from multiple waves.
JOB_SCHEDULE_RUN_FLAG_STR	"Y/N" string for job schedule flag.
LOCK_FLAG_STR	"Y/N" string indicating if the wave is locked.
LOCK_FLAG	Numeric flag representing the lock status of the wave.
PLANNED_SHIP_DATE	Scheduled shipping date for the wave.
TAGS	Concatenated tags or keywords from linked sales orders.
REF_NO	Concatenated reference numbers from linked sales orders (Comes from Sales Order Header).
ORDER_NUMBER	Concatenated order numbers from linked sales orders.
CUSTOMER	Concatenated customer names from linked sales orders.
CUSTOMER_PO	Concatenated customer purchase order numbers from linked sales orders (comes from Sales Order Header).
PROJECT_CLASS_NAME	Concatenated project class names from linked sales orders.
PICK_STRATEGY_ID	Identifier for the pick strategy used in this wave.
CARTON_BREAK_RULE_ID	Identifier for carton break rules applied to this wave.
FORCE_PICK_STRATEGY_FLAG	Flag indicating if the pick strategy is forced
PRIORITY_CODE_ID	Identifier for a priority code associated with this wave
TOTAL_QTY_PENDING_ON_REPLEN	Total quantity pending on replenishment for this wave
REPLEN_PENDING_STR	User-friendly flag for replenishment pending status (Y/N)
MISSING_ITEM_QTY	Quantity of items missing or short in this wave
CURRENCY_CODE	Currency code used for values in this wave