Payables Invoice attributes

Attribute name Attribute Table name
Accrual code ACCR_CODE APINVOICE
AP Due date DUE_DATE APINVOICE
AP Invoice Date INVOICE_DTE APINVOICE
AP Invoice number INVOICE APINVOICE
AP Invoice source INVOICE_SOURCE APINVOICE
AP Invoice status REC_STATUS APINVOICE
AP Operator OPERATOR APINVOICE
AP Operator name NAME OPERATOR
AP Process level PROC_LEVEL APINVOICE
Authority code AUTH_CODE APINVOICE
Bank transaction code BANK_INST_CODE APINVOICE
Bank transaction description BANK_INST_DESC CBBANKINST
Batch Date BATCH_DATE APINVOICE
Batch Number BATCH_NUM APINVOICE
Buyer BUYER APINVOICE
Bypass Match BYPASS_MATCH APINVOICE
Cancel Date CANCEL_DATE APINVOICE
Cancel sequence CANCEL_SEQ APINVOICE
Cash code CASH_CODE APINVOICE
Create date CREATE_DATE APINVOICE
Creation time CREATION_TIME APINVOICE
Cross reference vendor XREF_VENDOR APINVOICE
customer ID CUSTOMER_ID APINVOICE
Description DESCRIPTION APINVOICE
Discount Date DISC_DATE APINVOICE
Distrubtion code DIST_CODE APINVOICE
Diverse code DIVERSE_CODE APINVOICE
Dropship Flag DROPSHIP_FL APINVOICE
Final Distribution Flag FINAL_DST_FLAG APINVOICE
Flex Flag FLEX_FLAG APINVOICE
Income Code INCOME_CODE APINVOICE
Intrastat Number INTRASTAT_NBR APINVOICE
Invoice currency INV_CURRENCY APINVOICE
Invoice Reference type INVC_REF_TYPE APINVOICE
Invoice type INVOICE_TYPE APINVOICE
Journal Book Number JRNL_BOOK_NBR APINVOICE
Last distribution sequence LAST_DIST_SEQ APINVOICE
Last payment sequence LAST_PMT_SEQ APINVOICE
Location LOCATION APINVOICE
Match date MATCH_DATE APINVOICE
Match object ID MATCH_OBJ_ID APINVOICE
Match prepay Flag MTCH_PREPAY_FL APINVOICE
Match status MATCH_STATUS APINVOICE
Match table MATCH_TABLE APINVOICE
Pay currency PAY_CURRENCY APINVOICE
Payment category code PMT_CAT_CODE APINVOICE
PO Code PO_CODE APINVOICE
PO Number PO_NUMBER APINVOICE
PO Release PO_RELEASE APINVOICE
Purchase from location PURCH_FR_LOC APINVOICE
Reason Code REASON_CODE APINVOICE
Rebate Due Date REBATE_DUE_DTE APINVOICE
Rebate type REBATE_TYPE APINVOICE
Reciept Invoice date RECEIPT_INVOICE_DATE APINVOICE
Reconciliation Date RECON_DATE APINVOICE
Recurring Frequency RECUR_FREQ APINVOICE
Reference Number REFERENCE_NO APINVOICE
Retainage Accural Code RET_ACCR_CODE APINVOICE
Return Number RETURN_NUMBER APINVOICE
Rule Group RULE_GROUP APINVOICE
Secodary Withholding Code SEC_WITHHOLD APINVOICE
Shipping method SHIP_VIA APINVOICE
Split payment Schedule SPLITPAYMENT_SCHEDULE APINVOICE
Suffix SUFFIX APINVOICE
Tax code TAX_CODE APINVOICE
Tax Type TAX_TYPE APINVOICE
Terms Code TERMS_CD APINVOICE
Voucher Number VOUCHER_NBR APINVOICE