Item Name | Description |
ORG_ID | Self explanatory. |
BILL_TO_CUSTOMER_NAME | Self explanatory. |
SITE_USE_CODE | Self explanatory. |
TRANSACTION_NUMBER | Self explanatory. |
CREATION_DATE_FROM | Inclusive beginning date for CREATION_DATE field. |
CREATION_DATE_TO | Inclusive ending date for CREATION_DATE field. |
Item Name | Field Description (As Needed) |
ORG_ID | |
DOCUMENT_TYPE | |
INVOICE_NAME | |
DOCUMENT_NUMBER | |
TRANSACTION_DATE | |
BILL_TO_CUSTOMER_CODE_INT | |
BILL_TO_CUSTOMER_NAME | |
BILL_TO_ADDRESS1 | |
BILL_TO_ADDRESS2 | |
BILL_TO_ADDRESS3 | |
BILL_TO_ADDRESS4 | |
BILL_TO_CITY | |
BILL_TO_POSTAL_CODE | |
BILL_TO_COUNTRY | |
BILL_TO_STATE | |
BILL_TO_PROVINCE | |
BILL_TO_COUNTY | |
BILL_TO_CUSTOMER_SIC_CODE | |
BILL_TO_CUSTOMER_SALES_CHANNEL | |
BILL_TO_CONTACT_LAST_NAME | |
BILL_TO_CONTACT_FIRST_NAME | |
BILL_TO_CONTACT_JOB_TITLE | |
BILL_TO_CUSTOMER_ATT_CATEGORY | |
BILL_TO_CUSTOMER_ATTRIBUTE1 | |
BILL_TO_CUSTOMER_ATTRIBUTE2 | |
BILL_TO_CUSTOMER_ATTRIBUTE3 | |
BILL_TO_CUSTOMER_ATTRIBUTE4 | |
BILL_TO_CUSTOMER_ATTRIBUTE5 | |
BILL_TO_CUSTOMER_ATTRIBUTE6 | |
BILL_TO_CUSTOMER_ATTRIBUTE7 | |
BILL_TO_CUSTOMER_ATTRIBUTE8 | |
BILL_TO_CUSTOMER_ATTRIBUTE9 | |
BILL_TO_CUSTOMER_ATTRIBUTE10 | |
BILL_TO_CUSTOMER_ATTRIBUTE11 | |
BILL_TO_CUSTOMER_ATTRIBUTE12 | |
BILL_TO_CUSTOMER_ATTRIBUTE13 | |
BILL_TO_CUSTOMER_ATTRIBUTE14 | |
BILL_TO_CUSTOMER_ATTRIBUTE15 | |
SITE_USE_CODE | |
BILL_TO_SITE_ATT_CATEGORY | |
BILL_TO_SITE_ATTRIBUTE1 | |
BILL_TO_SITE_ATTRIBUTE2 | |
BILL_TO_SITE_ATTRIBUTE3 | |
BILL_TO_SITE_ATTRIBUTE4 | |
BILL_TO_SITE_ATTRIBUTE5 | |
BILL_TO_SITE_ATTRIBUTE6 | |
BILL_TO_SITE_ATTRIBUTE7 | |
BILL_TO_SITE_ATTRIBUTE8 | |
BILL_TO_SITE_ATTRIBUTE9 | |
BILL_TO_SITE_ATTRIBUTE10 | |
BILL_TO_SITE_ATTRIBUTE11 | |
BILL_TO_SITE_ATTRIBUTE12 | |
BILL_TO_SITE_ATTRIBUTE13 | |
BILL_TO_SITE_ATTRIBUTE14 | |
BILL_TO_SITE_ATTRIBUTE15 | |
SHIP_TO_CUSTOMER_CODE_INT | |
SHIP_TO_CUSTOMER_NAME | |
SHIP_TO_ADDRESS1 | |
SHIP_TO_ADDRESS2 | |
SHIP_TO_ADDRESS3 | |
SHIP_TO_ADDRESS4 | |
SHIP_TO_CITY | |
SHIP_TO_POSTAL_CODE | |
SHIP_TO_COUNTRY | |
SHIP_TO_STATE | |
SHIP_TO_PROVINCE | |
SHIP_TO_COUNTY | |
SHIP_TO_CUSTOMER_SIC_CODE | |
SHIP_TO_CUSTOMER_SALES_CHANNEL | |
SHIP_TO_CONTACT_LAST_NAME | |
SHIP_TO_CONTACT_FIRST_NAME | |
SHIP_TO_CONTACT_JOB_TITLE | |
SOLD_TO_CUSTOMER_CODE_INT | |
SOLD_TO_CUSTOMER_NAME | |
SOLD_TO_ADDRESS1 | |
SOLD_TO_ADDRESS2 | |
SOLD_TO_ADDRESS3 | |
SOLD_TO_ADDRESS4 | |
SOLD_TO_CITY | |
SOLD_TO_POSTAL_CODE | |
SOLD_TO_COUNTRY | |
SOLD_TO_STATE | |
SOLD_TO_PROVINCE | |
SOLD_TO_COUNTY | |
SOLD_TO_CUSTOMER_SIC_CODE | |
SOLD_TO_CUSTOMER_SALES_CHANNEL | |
SOLD_TO_CONTACT_LAST_NAME | |
SOLD_TO_CONTACT_FIRST_NAME | |
SOLD_TO_CONTACT_JOB_TITLE | |
TRANSACTION_NUMBER | |
CREDITED_INVOICE_NUMBER | |
REFERENCE_INVOICE_NUMBER | |
PARENT_INVOICE_NUMBER | |
SHIPMENT_DATE | |
PURCHASE_ORDER_NUMBER | |
CREATION_DATE | |
PURCHASE_ORDER_REVISION_NUMBER | |
COMMITMENT_START_DATE | |
PURCHASE_ORDER_DATE | |
COMMITMENT_END_DATE | |
INV_TRANSACTION_DATE | |
LAST_UPDATE_DATE | |
DUE_DATE | |
CREDIT_MEMO_REASON | |
TRANSMISSION_LEAD_DAYS | |
TRANSACTION_SOURCE | |
INSTALLMENT_NUMBER | |
SHIPMENT_WAYBILL_NUMBER | |
SHIP_VIA | |
SHIPMENT_FOB_POINT | |
CURRENCY_CODE | |
CURRENCY_EXCHANGE_RATE | |
BASE_CURRENCY_CODE | |
PAYMENT_TERM_NAME | |
PRIMARY_SALESREP_NAME | |
COMMENTS | |
BILL_TO_ADDRESS_ID | |
BILL_TO_CUSTOMER_LOCATION | |
BILL_TO_CUSTOMER_NUMBER | |
SHIP_TO_ADDRESS_ID | |
SHIP_TO_CUSTOMER_LOCATION | |
SHIP_TO_CUSTOMER_NUMBER | |
SOLD_TO_ADDRESS_ID | |
SOLD_TO_CUSTOMER_LOCATION | |
SOLD_TO_CUSTOMER_NUMBER | |
TRANSACTION_ID | |
PAYMENT_TERM_ID | |
BILL_TO_CUSTOMER_ID | |
BILL_TO_SITE_USE_ID | |
SHIP_TO_CUSTOMER_ID | |
SHIP_TO_SITE_USE_ID | |
SOLD_TO_CUSTOMER_ID | |
SOLD_TO_SITE_USE_ID | |
TERM_DUE_CUTOFF_DAY | |
TERM_DUE_DATE | |
TERM_DUE_DAYS | |
TERM_DUE_DAY_OF_MONTH | |
TERM_DUE_MONTHS_FORWARD | |
TERM_DUE_PERCENT | |
REMIT_TO_ADDRESS1 | |
REMIT_TO_ADDRESS2 | |
REMIT_TO_ADDRESS3 | |
REMIT_TO_ADDRESS4 | |
REMIT_TO_CITY | |
REMIT_TO_COUNTY | |
REMIT_TO_STATE | |
REMIT_TO_PROVINCE | |
REMIT_TO_COUNTRY | |
REMIT_TO_CODE_INT | |
REMIT_TO_POSTAL_CODE | |
MULTIPLE_INSTALLMENTS_FLAG | |
MAXIMUM_INSTALLMENT_NUMBER | |
AMOUNT_TAX_DUE | |
AMOUNT_CHARGES_DUE | |
AMOUNT_FREIGHT_DUE | |
AMOUNT_LINE_INVITEMS_DUE | |
TOTAL_AMOUNT_DUE | |
DISCOUNT_PERCENT1 | |
DISCOUNT_DAYS1 | |
DISCOUNT_DATE1 | |
DISCOUNT_DAY_OF_MONTH1 | |
DISCOUNT_MONTHS_FORWARD1 | |
DISCOUNT_PERCENT2 | |
DISCOUNT_DAYS2 | |
DISCOUNT_DATE2 | |
DISCOUNT_DAY_OF_MONTH2 | |
DISCOUNT_MONTHS_FORWARD2 | |
DISCOUNT_PERCENT3 | |
DISCOUNT_DAYS3 | |
DISCOUNT_DATE3 | |
DISCOUNT_DAY_OF_MONTH3 | |
DISCOUNT_MONTHS_FORWARD3 |
Item Name | Field Description (as needed) |
ORG_ID | |
TRANSACTION_ID | |
LINE_NUMBER | |
SALES_ORDER_NUMBER | |
SALES_ORDER_REVISION_NUMBER | |
SALES_ORDER_LINE_NUMBER | |
SALES_ORDER_DATE | |
SALES_CHANNEL | |
ITEM_ID | |
CUSTOMER_ITEM_NUMBER | |
CUSTOMER_ITEM_DESC | |
ITEM_DESCRIPTION | |
UOM_CODE | |
ORDERED_QUANTITY | |
QUANTITY | |
UNIT_STANDARD_PRICE | |
UNIT_SELLING_PRICE | |
LINE_AMOUNT | |
CREDIT_MEMO_REASON | |
CREDITED_LINE_NUMBER | |
SHIP_ORDER_STATUS_INT | |
TRANSACTION_REFERENCE_KEY | |
INTERFACE_LINE_CATEGORY | |
INTERFACE_LINE_ATTRIBUTE1 | |
INTERFACE_LINE_ATTRIBUTE2 | |
INTERFACE_LINE_ATTRIBUTE3 | |
INTERFACE_LINE_ATTRIBUTE4 | |
INTERFACE_LINE_ATTRIBUTE5 | |
INTERFACE_LINE_ATTRIBUTE6 | |
INTERFACE_LINE_ATTRIBUTE7 | |
INTERFACE_LINE_ATTRIBUTE8 | |
INTERFACE_LINE_ATTRIBUTE9 | |
INTERFACE_LINE_ATTRIBUTE10 | |
INTERFACE_LINE_ATTRIBUTE11 | |
INTERFACE_LINE_ATTRIBUTE12 | |
INTERFACE_LINE_ATTRIBUTE13 | |
INTERFACE_LINE_ATTRIBUTE14 | |
INTERFACE_LINE_ATTRIBUTE15 | |
LINE_ATTRIBUTE_CATEGORY | |
LINE_ATTRIBUTE1 | |
LINE_ATTRIBUTE2 | |
LINE_ATTRIBUTE3 | |
LINE_ATTRIBUTE4 | |
LINE_ATTRIBUTE5 | |
LINE_ATTRIBUTE6 | |
LINE_ATTRIBUTE7 | |
LINE_ATTRIBUTE8 | |
LINE_ATTRIBUTE9 | |
LINE_ATTRIBUTE10 | |
LINE_ATTRIBUTE11 | |
LINE_ATTRIBUTE12 | |
LINE_ATTRIBUTE13 | |
LINE_ATTRIBUTE14 | |
LINE_ATTRIBUTE15 |
Item Name | Field Description (as needed) |
ORG_ID | |
TRANSACTION_ID | |
LINE_NUMBER | |
CUSTOMER_TRX_LINE_ID | |
TAX_LINE_NUMBER | |
LINE_TYPE | |
TAX_AMOUNT | |
TAX_RATE | |
TAX_PRECEDENCE | |
TAX_CODE | |
LINK_TO_CUST_TRX_LINE_ID | |
TAX_ATTRIBUTE_CATEGORY | |
TAX_ATTRIBUTE1 | |
TAX_ATTRIBUTE2 | |
TAX_ATTRIBUTE3 | |
TAX_ATTRIBUTE4 | |
TAX_ATTRIBUTE5 | |
TAX_ATTRIBUTE6 | |
TAX_ATTRIBUTE7 | |
TAX_ATTRIBUTE8 | |
TAX_ATTRIBUTE9 | |
TAX_ATTRIBUTE10 | |
TAX_ATTRIBUTE11 | |
TAX_ATTRIBUTE12 | |
TAX_ATTRIBUTE13 | |
TAX_ATTRIBUTE14 | |
TAX_ATTRIBUTE15 | |
TAX_EXEMPT_FLAG | |
TAX_EXEMPT_NUMBER | |
TAX_EXEMPT_REASON_CODE | |
TAX_TYPE | |
DESCRIPTION | |
LOCATION | |
TAX_CLASSIFICATION | |
VAT_TRANSACTION_TYPE | |
VAT_TAX_ATTRIBUTE_CATEGORY | |
VAT_TAX_ATTRIBUTE1 | |
VAT_TAX_ATTRIBUTE2 | |
VAT_TAX_ATTRIBUTE3 | |
VAT_TAX_ATTRIBUTE4 | |
VAT_TAX_ATTRIBUTE5 | |
VAT_TAX_ATTRIBUTE6 | |
VAT_TAX_ATTRIBUTE7 | |
VAT_TAX_ATTRIBUTE8 | |
VAT_TAX_ATTRIBUTE9 | |
VAT_TAX_ATTRIBUTE10 | |
VAT_TAX_ATTRIBUTE11 | |
VAT_TAX_ATTRIBUTE12 | |
VAT_TAX_ATTRIBUTE13 | |
VAT_TAX_ATTRIBUTE14 | |
VAT_TAX_ATTRIBUTE15 |