Order Entry attributes

Attribute name Attribute Source
Account Category ACCT_CATEGORY CUSTORDER
Account Category ACCT_CATEGORY COLINE
Account Category ACCT_CATEGORY RETURNLINE
Active Status ACTIVE_STATUS ARCUSTOMER
Activity ACTIVITY CUSTORDER
Activity ACTIVITY RETURNLINE
Allocated Date ALLOCATE_DT COLINE
AtnObjIdC ATN_OBJ_ID_C RETURNLINE
Authorization Approved AUTH_APPROVED CUSTORDER
Authorization Required AUTH_REQUIRED CUSTORDER
Automatic Cash Application AUTO_APP_FL RETURNHDR
Back Order BACK_ORD_FL CUSTORDER
Backordered BACK_ORD_FL COLINE
Bank Payment Code BANK_INST_CODE CUSTORDER
Bank Payment Code Desc BANK_INST_DESC CBBANKINST
Bill Country BILL_CNTRY CUSTORDER
Bill Name BILL_NAME CUSTORDER
Bill Region BILL_REGION CUSTORDER
Bill State BILL_STATE CUSTORDER
Billing Company COMPANY OECOMPANY
Billing Freight Code FREIGHT_CODE CUSTORDER
Billing Freight Desc FRT_DESC OEFRTCODE
Billing Invoice Type INVC_TYPE RETURNHDR
Billing Invoice Type Desc INVC_DESC OEINVCTYPE
Billing Process Level PROCESS_LEVEL CUSTORDER
Billing Process Level PROCESS_LEVEL COLINE
Billing Process Level PROCESS_LEVEL RETURNHDR
Booked By Sale Analysis BOOKED_FL COLINE
Booked Date BOOKED_DATE COLINE
Cancelled Date CXL_DATE CUSTORDER
Cancelled Date CXL_DATE COLINE
Cancelled Operator CXL_OPR COLINE
Cancelled Reason CXL_REASON COLINE
Carrier CARRIER CUSTORDER
Carrier CARRIER COLINE
Cash On Delivery COD_FL CUSTORDER
CashIn Adv Req Percent CIA_PCT CUSTORDER
CashIn Adv Required CIA_FL CUSTORDER
Check Number CHECK_NBR CUSTORDER
Company COMPANY COLINE
Company COMPANY RETURNHDR
Company COMPANY RETURNLINE
Company Name NAME OECOMPANY
Contact CONTACT RETURNHDR
Contract Number CONTRACT_NBR COLINE
Cost Activity ACTIVITY_C CUSTORDER
Cost Activity ACTIVITY_C RETURNLINE
Cost Of Goods Sold Account CGS_ACCOUNT RETURNLINE
Cost Variance Acc Acct Unit CV_ACCT_UNIT RETURNLINE
Cost Variance Account CV_ACCOUNT RETURNLINE
CostOfGoods Sold Acc Acct Unit CGS_ACCT_UNIT RETURNLINE
Country COUNTRY OECOMPANY
Create Credit Memo CREATE_CM_CD RETURNHDR
Create Credit Memo CREATE_CM_CD RETURNLINE
Create Purchase Order CREATE_PO COLINE
Credit WorkFlow CREDIT_WF_FL CUSTORDER
Currency CURRENCY_CODE CUSTORDER
Currency CURRENCY_CODE RETURNHDR
Currency CURRENCY_CODE OECOMPANY
Currency Override CURR_OVR_FL CUSTORDER
Customer CUSTOMER COLINE
Customer CUSTOMER RETURNHDR
Customer CUSTOMER RETURNLINE
Customer BillTo BILL_TO CUSTORDER
Customer BillTo BILL_TO RETURNHDR
Customer Item CUST_ITEM COLINE
Customer Item Entered CUST_ITEM_FL COLINE
Customer Name CUSTOMER ARCUSTOMER
Customer Order ORDER_NBR CUSTORDER
Customer Order ORDER_NBR RETURNLINE
Customer order ORDER_NBR COLINE
Customer Order Return AUTH_NO RETURNHDR
Customer Order Return AUTH_NO RETURNLINE
Customer Order Return Line LINE_NBR RETURNLINE
Customer Purchase Order CUST_PO_NBR CUSTORDER
Customer Requested Action CUST_REQ_ACT RETURNLINE
Customer Requested Action Cod CUST_REQ_ACT RETURNLINE
Customer Return Reference CUST_RET_REF RETURNHDR
Customer Ship To SHIP_TO RETURNLINE
Customer ShipTo SHIP_TO CUSTORDER
Customer ShipTo CUST_SHIP_TO COLINE
Customer ShipTo SHIP_TO RETURNHDR
Date R_DATE RETURNLINE
Description DESCRIPTION RETURNLINE
Discount Account DSC_ACCOUNT OECOMPANY
Discount Accounting Unit DSC_ACCT_UNIT OECOMPANY
Discount AddOn Charge DISC_AOC_FL OECOMPANY
Discount Code DISC_CODE COLINE
Discount SubAccount DSC_SUB_ACCT OECOMPANY
Dropship DROPSHIP_FL COLINE
Dropship DROPSHIP_FL RETURNHDR
Early Delivery Date EARLY_DL_DATE COLINE
EDI OE Interface EDI_OE_FLAG CUSTORDER
Electronic Payment Type EP_TYPE RETURNHDR
EP Expiration Date EP_EXP_DATE CUSTORDER
EPayment Type EP_TYPE CUSTORDER
Expected Ship Date EXP_SHIP_DT CUSTORDER
Expected Ship Date EXP_SHIP_DT COLINE
Expense Account EXP_ACCOUNT COLINE
Expense Account Acc Unit EXP_ACCT_UNIT COLINE
Expense SubAccount EXP_SUB_ACCT OECOMPANY
Expiration Date EP_EXP_DATE RETURNHDR
Firm FIRM_FL COLINE
Freight Code FREIGHT_CDE RETURNHDR
Freight Code Description FRT_DESC OEFRTCODE
Freight Taxable FRT_TAXABLE_FL CUSTORDER
Future Order FUTURE_FL CUSTORDER
Future Order FUTURE_FL COLINE
Global Document Type GLBL_DOC_TYPE RETURNHDR
Global Line Type GLBL_LINE_TYPE COLINE
Global Line Type GLBL_LINE_TYPE RETURNLINE
Global Line Type Description DESCRIPTION INLINETYPE
Global Line Type Description DESCRIPTION INLINETYPE
Hold Code HOLD_CODE CUSTORDER
Hold Code HOLD_CODE COLINE
Hold Code Approve HOLD_APR_FL CUSTORDER
ICN Code ICN_CODE COLINE
ICN Code Description DESCRIPTION INSTCMDTY
International Prefix INT_PREFIX RETURNHDR
IntraStat Number INTRASTAT_NBR CUSTORDER
Inventory Disposition INV_DISP_CD RETURNLINE
Inventory Disposition Code INV_DISP_CD RETURNLINE
Inventory Location INV_LOCATION CUSTORDER
Inventory Location INV_LOC COLINE
Inventory Location LOCATION RETURNHDR
Inventory Location LOCATION RETURNLINE
Invoice Number INVC_NUMBER RETURNHDR
Invoice Prefix INVC_PREFIX RETURNHDR
ISO Country ISO_CTRY_NBR OECOMPANY
Item ITEM COLINE
Item ITEM RETURNLINE
Item Description ITEM_DESC COLINE
Kit Type KIT_FL COLINE
Last AddOn Charge Seq LAST_MISC_SEQ CUSTORDER
Last AddOn Charge Seq LAST_MISC_SEQ COLINE
Last AddOn Charge Sequence LAST_MISC_SEQ RETURNLINE
Last Comment Sequence LAST_COMM_SEQ COLINE
Last Comment Sequence LAST_COMM_SEQ RETURNHDR
Last Comment Sequence LAST_COMM_SEQ RETURNLINE
Last Line Number LAST_LINE_NBR CUSTORDER
Last Line Number LAST_LINE_NBR RETURNHDR
Last Sequence LAST_SEQ RETURNHDR
Last Shipment Number LAST_SHIP_NBR COLINE
Late Delivery Date LATE_DL_DATE COLINE
Line Number LINE_NBR COLINE
Line Type LINE_TYPE COLINE
Line Type LINE_TYPE RETURNLINE
Line Type Code LINE_TYPE COLINE
Line Type Code LINE_TYPE RETURNLINE
List Name LIST_NAME CUSTORDER
List Name LIST_NAME COLINE
Major Sales Class SALES_MAJCL COLINE
Material Safety Data Sheet MSDS_REQ_FL COLINE
Minor Sales Class SALES_MINCL COLINE
Multiple Sell Price MULT_SPR_FL COLINE
Municipality CITY OECOMPANY
Nature Of Transaction Code NOTC COLINE
No Charge NO_CHARGE_FL COLINE
OE Cancelled Operator CXL_OPR CUSTORDER
Offset Account OFF_ACCOUNT RETURNLINE
Offset Account Accounting Unit OFF_ACCT_UNIT RETURNLINE
Order Cancel Credit Reason CXL_REASON CUSTORDER
Order Date ORDER_DATE CUSTORDER
Order Date ORDER_DATE CUSTORDER
Order Discount ORD_DISC_FL COLINE
Order Discount Code ORD_DISC_CODE CUSTORDER
Order Discount Percentage PCT CUSTORDER
Order Entry Change Operator CHG_OPR CUSTORDER
Order Entry Credit Operator CRED_OPR CUSTORDER
Order Entry Operator OPR_CODE CUSTORDER
Order Entry Order Source ORDER_SOURCE CUSTORDER
Order Entry Order Type ORDER_TYPE CUSTORDER
Order Number ORDER_NBR RETURNHDR
Order Reference Number ORDER_REF_NBR CUSTORDER
Order Reference Number User REF_NBR_FLAG CUSTORDER
Order Reference Number User REF_NBR_FLAG CUSTORDER
Order Source Desc SRC_DESC OESOURCE
Order Type Description DESCRIPTION ORDERTYPE
Original Invoice Number ORIG_INVC_NBR RETURNHDR
Original Invoice Prefix ORIG_INVC_PRE RETURNHDR
Original Item ORIG_ITEM COLINE
Original Line ORIG_LINE COLINE
Override Taxable OVR_TAXABLE COLINE
Picking List Printed PK_PRT_FL CUSTORDER
PO Code PO_CODE COLINE
PO Code PO_CODE RETURNLINE
PO Delivery Grace Period POD_GRACE_PER CUSTORDER
PO Delivery Required POD_REQ_FL CUSTORDER
Port Code PORT_CD COLINE
Posting Date POSTING_DATE RETURNHDR
Price Date PRICE_DATE CUSTORDER
Price Date PRICE_DATE COLINE
Price Status PRICE_STATUS COLINE
Price Status Code PRICE_STATUS COLINE
Promotion PROMOTION COLINE
Purchase Order PO_NUMBER COLINE
Purchase Order PO_NUMBER RETURNLINE
Quantity Break QTY_BREAK_FL COLINE
Rate Freeze RATE_FRZ_CD CUSTORDER
Rate Freeze Code RATE_FRZ_CD CUSTORDER
Rate Override RATE_OVR_FL COLINE
Reason Code REASON_CODE RETURNHDR
Reason Code REASON_CODE RETURNLINE
Reason Code Description DESCRIPTION OEREASON
Reason Code Description DESCRIPTION OEREASON
Region REGION OECOMPANY
Remit Country RMT_COUNTRY OECOMPANY
Remit EC Country Code RMT_CTRY_CODE OECOMPANY
Remit Name RMT_NAME OECOMPANY
Remit Region RMT_REGION OECOMPANY
Remit State RMT_STATE OECOMPANY
Remit To European Community Country RMT_EC_CTRY OECOMPANY
Remit To ISO Country RMT_ISO_CTRY OECOMPANY
Requested Date RQST_DATE CUSTORDER
Return Days RETURN_DAYS OECOMPANY
Rounding Account RND_ACCOUNT OECOMPANY
Rounding Accounting Unit RND_ACCT_UNIT OECOMPANY
Rounding SubAccount RND_SUB_ACCT OECOMPANY
Route Header Date EXP_DELIV_DT COLINE
Sales Account SLS_ACCOUNT COLINE
Sales Account SLS_ACCOUNT RETURNLINE
Sales Account SLS_ACCOUNT OECOMPANY
Sales Account Acc Unit SLS_ACCT_UNIT COLINE
Sales Account Accounting Unit SLS_ACCT_UNIT RETURNLINE
Sales Account Project ACTIVITY COLINE
Sales Accounting Unit SLS_ACCT_UNIT OECOMPANY
Sales Quote SLS_QUOTE_FL CUSTORDER
Sales SubAccount SLS_SUB_ACCT OECOMPANY
Secondary UOM SEC_UOM COLINE
Sell To Stock SELL_TO_STOCK RETURNLINE
Sell UOM SELL_UOM COLINE
Selling Price Unit Of Measure SPR_UOM RETURNLINE
Selling Price UOM SPR_UOM COLINE
Selling Unit Of Measure SELL_UOM RETURNLINE
Ship Complete SHIP_COMP_FL CUSTORDER
Ship Complete SHIP_COMP_FL COLINE
Ship Immediate IMMEDIATE_FL CUSTORDER
Ship Term FOB_CODE COLINE
Shipping Method METHOD CUSTORDER
Shipping Method METHOD CUSTORDER
ShipTo Name SHIP_TO_NAME CUSTORDER
ShipTo State SHIP_TO_STATE CUSTORDER
Special Order COGS Accounting Unit MCG_ACCT_UNIT OECOMPANY
Special Order COGS Acct Unit MCG_ACCOUNT OECOMPANY
Special Order COGS SubAccount MCG_SUB_ACCT OECOMPANY
Special Order Sales Account MI_ACCOUNT OECOMPANY
Special Order Sales Acct Unit MI_ACCT_UNIT OECOMPANY
Special Order Sales SubAccount MI_SUB_ACCT OECOMPANY
State Province STATE OECOMPANY
Statistical Procedure STAT_PROC CUSTORDER
Statistical Procedure STAT_PROC COLINE
Status STATUS CUSTORDER
Status STATUS COLINE
Status STATUS RETURNHDR
Status STATUS RETURNLINE
Status Code STATUS COLINE
Status Code STATUS RETURNHDR
Status Code STATUS RETURNLINE
Subscriber Number PHONE_NMBR RETURNHDR
Supplementary UOM SUPLMNTARY_UOM COLINE
Tax Code TAX_CODE CUSTORDER
Tax Code TAX_CODE COLINE
Tax Code Description DESCRIPTION TXCODEMAST
Tax Code Description DESCRIPTION TXCODEMAST
Tax Date TAX_DATE CUSTORDER
Tax Status TAX_EXEMPT_CD CUSTORDER
Tax Status TAX_EXEMPT_CD COLINE
Taxable Amount Currency TAXABLE_CURR COLINE
Terms Code TERMS_CD CUSTORDER