POPRCTNM | char(17) | Yes | Receipt Number | IN |
POPTYPE | smallint | Yes | Receipt Type 1=Shipment 3=Shipment/Invoice | IN |
VNDDOCNM | char(20) | Yes | Vendor Document Number | IN |
receiptdate | datetime | Yes | Receipt Date | IN |
ACTLSHIP | datetime | No | Actual Ship 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 |
REFRENCE | char(30) | No | Reference | IN |
USER2ENT | char(15) | No | User who Entered | IN |
VCHRNMBR | char(20) | No | Voucher Number | IN |
Tax_Date | datetime | No | Tax Date | IN |
TIME1 | datetime | No | Time | IN |
WITHHAMT | numeric(19,5) | No | Withholding amount | IN |
TXRGNNUM | char(25) | No | Tax Registration Number | 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 | IN |
Purchase_Misc_Taxable | smallint | No | Purchase Misc Taxable | 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 |
BCKTXAMT | numeric(19,5) | No | Back Tax Amount | IN |
BackoutTradeDiscTax | numeric(19,5) | No | Backout Trade Disc Tax Amount | IN |
SHIPMTHD | char(15) | No | Shipping method | IN |
USINGHEADERLEVELTAXES | smallint | No | Using Header Level Taxes Flag | IN |
CREATEDIST | smallint | No | Flag to auto create distributions: 0 = Manual; 1 = Automatic | IN |
CURNCYID | char(15) | No | Currency ID | IN |
XCHGRATE | numeric(19,5) | No | Exchange Rate | IN |
RATETPID | char(15) | No | Rate Type ID | IN |
EXPNDATE | datetime | No | Expiration Date | IN |
EXCHDATE | datetime | No | Exchange Date | IN |
EXGTBDSC | char(30) | No | Exchange ID Desc. | IN |
EXTBLSRC | char(50) | No | Exchange Rate Source | IN |
RATEEXPR | smallint | No | Rate Expiration | IN |
DYSTINCR | smallint | No | Days to Increment | IN |
RATEVARC | numeric(19,5) | No | Rate Variance | IN |
TRXDTDEF | smallint | No | Trx Date Default - 0=Exact Date, 1=Next Date, 2=Previous Date | IN |
RTCLCMTD | smallint | No | Rate Calc. Method - 0=Multiply, 1= Divide | IN |
PRVDSLMT | smallint | No | Previous Days Limits | IN |
DATELMTS | smallint | No | Date Limits - 0=Unlimited, 1=Limited | IN |
DUEDATE | datetime | No | Due Date | IN |
DISCDATE | datetime | No | Discount Date | IN |
NOTETEXT | varchar(8000) | No | PO Receipt Note Text | IN |
VADCDTRO | char(15) | No | Remit to Address ID | IN |
CASHAMNT | numeric(19,5) | No | Cash Amount - | IN |
CAMCBKID | char(15) | No | Cash Amount Checkbook ID - | IN |
CDOCNMBR | char(21) | No | Cash Document Number - | IN |
CAMTDATE | datetime | No | Cash Amount Date - | IN |
CAMPMTNM | char(21) | No | Cash Amount Payment Number - | IN |
CHEKAMNT | numeric(19,5) | No | Check Amount - | IN |
CHAMCBID | char(15) | No | Check Amount Checkbook ID - | IN |
CHEKNMBR | char(21) | No | Check Number - | IN |
CHEKDATE | datetime | No | Check Date - | IN |
CAMPYNBR | char(21) | No | Check Amount Payment Number - | IN |
CRCRDAMT | numeric(19,5) | No | Credit Card Amount - | IN |
CARDNAME | char(15) | No | Credit Card Name - | IN |
CCRCTNUM | char(21) | No | Credit Card Receipt Number - | IN |
CRCARDDT | datetime | No | Credit Card Date - | IN |
CCAMPYNM | char(21) | No | Credit Card Amount Payment Number - | IN |
DISTKNAM | numeric(19,5) | No | Discount Taken Amoun - | IN |
RequesterTrx | smallint | No | Requester Transaction - 0=false,1=true | 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 | Error Code | INOUT |
oErrString | varchar(255) | No | List of errors encountered | INOUT |
|