> For the complete documentation index, see [llms.txt](https://docs.xorosoft.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.xorosoft.com/xoroerp-1/reporting-server-db-guide/views-schema.md).
# 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 |
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.
Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:
```
GET https://docs.xorosoft.com/xoroerp-1/reporting-server-db-guide/views-schema.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.