BACHNUMB | char(15) | Yes | Batch Number* | IN |
VCHNUMWK | char(17) | Yes | Voucher Number* | IN |
VENDORID | char(15) | Yes | Vendor ID* | IN |
DOCNUMBR | char(20) | Yes | Document Number* | IN |
DOCTYPE | smallint | Yes | 1=Invoice
2=Finance Charge
3=Miscellaneous Charge
4=Return
5=Credit Memo | IN |
DOCAMNT | numeric(19,5) | Yes | Document Amount* <@I_vDOCAMNT = @I_vMSCCHAMT + @I_vPRCHAMNT + @I_vTAXAMNT + @I_vFRTAMNT - @I_vTRDISAMT> | IN |
DOCDATE | datetime | Yes | Document Date* | IN |
PSTGDATE | datetime | No | Posting Date* | IN |
VADCDTRO | char(15) | No | Remit To Address ID* | IN |
VADDCDPR | char(15) | No | Primary Address ID* | IN |
PYMTRMID | char(20) | No | Payment Terms ID* | IN |
TAXSCHID | char(15) | No | Tax Schedule ID* | IN |
DUEDATE | datetime | No | Due Date* | IN |
DSCDLRAM | numeric(19,5) | No | Discount Dollar Amt* | IN |
DISCDATE | datetime | No | Discount Date* | IN |
PRCHAMNT | numeric(19,5) | Yes | Document Date* | IN |
CHRGAMNT | numeric(19,5) | Yes | Charge Amount* (@I_vDOCAMNT-@I_vCASHAMNT-@I_vCHEKAMNT-@I_vCRCRDAMT-@I_vDISTKNAM> | IN |
CASHAMNT | numeric(19,5) | No | Cash Amount* | IN |
CAMCBKID | char(15) | No | Cash Amount Checkbook ID* | IN |
CDOCNMBR | char(20) | Yes | Cash Document Number* | IN |
CAMTDATE | datetime | No | Cash Amount Date* | IN |
CAMPMTNM | char(20) | Yes | Cash Amount Payment Number* | IN |
CHEKAMNT | numeric(19,5) | No | Cash Amount* | IN |
CHAMCBID | char(15) | No | Check Amount Checkbook ID* | IN |
CHEKDATE | datetime | No | Check Amount Date* | IN |
CAMPYNBR | char(20) | Yes | Check Payment Number* <> | IN |
CRCRDAMT | numeric(19,5) | No | Cash Amount* | IN |
CCAMPYNM | char(20) | Yes | Credit Card Pyment Number* <> | IN |
CHEKNMBR | char(20) | Yes | Check Document Number* | IN |
CARDNAME | char(15) | Yes | Credit Card Name* 0 | IN |
CCRCTNUM | char(20) | Yes | Credit Card Receipt Number* 0 | IN |
CRCARDDT | datetime | No | Credit Card Amount Date* | IN |
CHEKBKID | char(15) | Yes | CheckBook ID* | IN |
TRXDSCRN | char(30) | No | Transaction Description* | IN |
TRDISAMT | numeric(19,5) | Yes | Document Date* | IN |
TAXAMNT | numeric(19,5) | Yes | Document Date* | IN |
FRTAMNT | numeric(19,5) | Yes | Document Date* | IN |
TEN99AMNT | numeric(19,5) | No | 1099 Amount* | IN |
MSCCHAMT | numeric(19,5) | Yes | Document Date* | IN |
PORDNMBR | char(20) | No | Purchase Order Number* | IN |
SHIPMTHD | char(15) | No | Shipping Method* | IN |
DISAMTAV | numeric(19,5) | No | Discount Amount Available* | IN |
DISTKNAM | numeric(19,5) | No | Cash Amount* | IN |
APDSTKAM | numeric(19,5) | No | Applied Discount Taken Amount* | IN |
MDFUSRID | char(15) | No | Modified User ID* | IN |
POSTEDDT | datetime | No | Posted Date* | IN |
PTDUSRID | char(15) | No | Posted User ID* | IN |
PCHSCHID | char(15) | No | Purchase Schedule ID* | IN |
FRTSCHID | char(15) | No | Freight Schedule ID* | IN |
MSCSCHID | char(15) | No | Misc Schedule ID* | IN |
PRCTDISC | numeric(19,5) | No | Percent Discount | IN |
Tax_Date | datetime | No | Tax Date* | IN |
CURNCYID | char(15) | No | Currency ID - 08/20/01 - Added for Multi-Currency | IN |
XCHGRATE | numeric(19,5) | No | Exchange Rate - 08/20/01 - Added for Multi-Currency - MC020103 | IN |
RATETPID | char(15) | No | Rate Type ID - 08/20/01 - Added for Multi-Currency - MC020103 | IN |
EXPNDATE | datetime | No | Expiration Date - 08/20/01 - Added for Multi-Currency - MC00100 | IN |
EXCHDATE | datetime | No | Exchange Date - 08/20/01 - Added for Multi-Currency - MC00100 | IN |
EXGTBDSC | char(30) | No | Exchange ID Desc. - 08/20/01 - Added for Multi-Currency - MC40300 | IN |
EXTBLSRC | char(50) | No | Exchange Rate Source - 08/20/01 - Added for Multi-Currency - MC40300 | IN |
RATEEXPR | smallint | No | Rate Expiration - 08/20/01 - Added for Multi-Currency - MC40300 | IN |
DYSTINCR | smallint | No | Days to Increment - 08/20/01 - Added for Multi-Currency - MC40300 - only used when RATEEXPR = 8 | IN |
RATEVARC | numeric(19,5) | No | Rate Variance - 08/20/01 - Added for Multi-Currency - MC40300 | IN |
TRXDTDEF | smallint | No | Trx Date Default - 08/20/01 - Added for Multi-Currency - MC40300 | IN |
RTCLCMTD | smallint | No | Rate Calc. Method - 08/20/01 - Added for Multi-Currency - MC40300 | IN |
PRVDSLMT | smallint | No | Previous Days Limits - 08/20/01 - Added for Multi-Currency - MC40300 | IN |
DATELMTS | smallint | No | Date Limits - 08/20/01 - Added for Multi-Currency - MC40300 | IN |
TIME1 | datetime | No | Time 1 - 08/20/01 - 03/11/02 - Added for Multi-Currency - MC40300 | IN |
BatchCHEKBKID | char(15) | No | Checkbook ID for the batch | IN |
CREATEDIST | smallint | No | Flag to auto create distributions: 0=Manual; 1=Automatic - use if not calling taPMDistribution node | IN |
RequesterTrx | smallint | No | Requester Transaction - 0=false,1=true - if true than populates Requester shadow table | IN |
USRDEFND1 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND2 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND3 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND4 | varchar(8000) | No | User Defined field - developer use only | IN |
USRDEFND5 | varchar(8000) | No | User Defined field - developer use only | IN |
ErrorState | int | No | | INOUT |
oErrString | varchar(255) | No | | INOUT |