POPRCTNM | char(17) | Yes | Receipt Number | IN |
VNDDOCNM | char(20) | Yes | Vendor Document Number | IN |
receiptdate | datetime | Yes | Receipt Date | IN |
BACHNUMB | char(15) | Yes | Batch Number | IN |
VENDORID | char(15) | Yes | Vendor ID | IN |
VENDNAME | char(64) | No | Vendor Name | IN |
SUBTOTAL | numeric(19,5) | Yes | Subtotal- set to 0 if using AUTOCOST option | IN |
TRDISAMT | numeric(19,5) | No | Trade Discount Amount | IN |
FRTAMNT | numeric(19,5) | No | Freight Amount | IN |
MISCAMNT | numeric(19,5) | No | Misc Amount | IN |
TAXAMNT | numeric(19,5) | No | Tax Amount | IN |
TEN99AMNT | numeric(19,5) | No | 1099 Amount | IN |
PYMTRMID | char(20) | No | Payment Terms Id | IN |
DSCPCTAM | numeric(19,5) | No | Discount Percent Amount | IN |
DSCDLRAM | numeric(19,5) | No | Discount Dollar Amount | IN |
DISAVAMT | numeric(19,5) | No | Discount Available Amount | IN |
USER2ENT | char(15) | No | User who Entered | IN |
TIME1 | datetime | No | Time | IN |
AUTOCOST | int | No | Parameter to auto fill cost based on PO. 0=enter manually, 1=automatic | IN |
TAXSCHID | char(15) | No | Tax Schedule ID | IN |
Purchase_Freight_Taxable | smallint | No | Purchase Freight Taxable - 1=Taxable, 2=Nontaxable, 3=Base on Vendor | IN |
Purchase_Misc_Taxable | smallint | No | Purchase Misc Taxable - 1=Taxable, 2=Nontaxable, 3=Base on Vendor | IN |
FRTSCHID | char(15) | No | Freight Tax Schedule ID | IN |
MSCSCHID | char(15) | No | Misc Tax Schedule ID | IN |
FRTTXAMT | numeric(19,5) | No | Freight Tax Amount | IN |
MSCTXAMT | numeric(19,5) | No | Misc Tax Amount | IN |
USINGHEADERLEVELTAXES | smallint | No | Header Level Taxes - used if no line taxes and assigning tax at the header level - 0=false; 1=true | IN |
CURNCYID | char(15) | No | Currency ID - Added for Multi-Currency | IN |
XCHGRATE | numeric(19,5) | No | Exchange Rate - Added for Multi-Currency - MC020103 | IN |
RATETPID | char(15) | No | Rate Type ID - Added for Multi-Currency - MC020103 | IN |
EXPNDATE | datetime | No | Expiration Date - Added for Multi-Currency - MC00100 | IN |
EXCHDATE | datetime | No | Exchange Date - Added for Multi-Currency - MC00100 | IN |
EXGTBDSC | char(30) | No | Exchange ID Desc. - Added for Multi-Currency - MC40300 | IN |
EXTBLSRC | char(50) | No | Exchange Rate Source - Added for Multi-Currency - MC40300 | IN |
RATEEXPR | smallint | No | Rate Expiration - Added for Multi-Currency - MC40300 | IN |
DYSTINCR | smallint | No | Days to Increment - Added for Multi-Currency - MC40300- only used when RATEEXPR = 8 | IN |
RATEVARC | numeric(19,5) | No | Rate Variance - Added for Multi-Currency - MC40300 | IN |
TRXDTDEF | smallint | No | Trx Date Default - Added for Multi-Currency - MC40300 | IN |
RTCLCMTD | smallint | No | Rate Calc. Method - 0=Multiply, 1= Divide - Added for Multi-Currency - MC40300 | IN |
PRVDSLMT | smallint | No | Previous Days Limits - Added for Multi-Currency - MC40300 | IN |
DATELMTS | smallint | No | Date Limits - 0=Unlimited, 1=Limited - Added for Multi-Currency - MC40300 | IN |
DUEDATE | datetime | No | Due Date | IN |
DISCDATE | datetime | No | Discount Date | IN |
NOTETEXT | varchar(8000) | No | PO Receipt Note Text | IN |
RequesterTrx | smallint | No | Requester Transaction - 0=false,1=true - if true than populates Requester shadow table | IN |
CREATEDIST | smallint | No | Flag to auto create distributions: 0=Manual; 1=Automatic | IN |
BackoutTradeDiscTax | numeric(19,5) | No | Backout Trade Disc Tax Amount | IN |
VADCDTRO | char(15) | No | Remit to Address ID | 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 | Create Custom Business Logic | INOUT |
oErrString | varchar(255) | No | Create Custom Business Logic | INOUT |