Back

Accounts Payable (AP) - APOPENST

Name Type Length Decimal Relation Description
VENDNUM String 10 AP VENDNUM
INVNUM String 20 AP INVNUM
TERMCODE String 2 AP TERMCODE
FORM1099 String 1 AP FORM1099
BOX1099 String 2 AP BOX1099
TAKEDISC Boolean 1 AP TAKEDISC
HLDSTATUS Boolean 1 AP OPEN INVOICE HLDSTATUS - Hold Status (Y=Hold Payment)
INVDATE DateTime 8 AP INVDATE
DUEDATE DateTime 8 AP DUEDATE
DISCDATE DateTime 8 AP DISCDATE
INVCOMMENT String 4 AP INVCOMMENT
INVTOT Decimal 12 2 AP INVTOT
FINVTOT Decimal 12 2 AP FINVTOT
DISCAMT Decimal 8 2 AP DISCAMT
FDISCAMT Decimal 8 2 AP FDISCAMT
DISCOUNT Decimal 8 2 AP OPEN INVOICE DISCOUNT - Discount taken
FDISCOUNT Decimal 8 2 AP OPEN INVOICE FDISCOUNT - Foreign Discount taken
GAINLOSS Decimal 8 2 AP OPEN INVOICE GAINLOSS - Realized foreign currency gain/loss amount
AMTOPEN Decimal 12 2 AP AMTOPEN
FAMTOPEN Decimal 12 2 AP FAMTOPEN
PAYMENTS Decimal 12 2 AP OPEN INVOICE PAYMENTS - Total payments
FPAYMENTS Decimal 12 2 AP OPEN INVOICE FPAYMENTS - Total foreign payments
TOBEPAID Boolean 1 AP TOBEPAID
AMTAPPRVD Decimal 12 2 AP AMTAPPRVD
BALANCEDUE Decimal 12 2 AP BALANCEDUE
DISCAPPRVD Decimal 12 2 AP DISCAPPRVD
VOID Boolean 1 AP VOID
DIVISION String 10 AP DIVISION
DEFAP String 12 AP DEFAP