Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
PONUMBER | PO Number |
String | 18 | View | |
POSTATUS | PO Status 1 – New |
Integer | 2 | View | |
STATGRP | Status Group |
Integer | 2 | View | |
POTYPE | PO Type 1 = Standard |
Integer | 2 | View | |
USER2ENT | User To Enter |
String | 16 | View | |
CONFIRM1 | Confirm With |
String | 22 | View | |
DOCDATE | Document Date |
Date | 4 | View | |
LSTEDTDT | Last Edit Date |
Date | 4 | View | |
LSTPRTDT | Last Printed Date |
Date | 4 | View | |
PRMDATE | Promised Date |
Date | 4 | View | |
PRMSHPDTE | Promised Ship Date |
Date | 4 | View | |
REQDATE | Required Date |
Date | 4 | View | |
REQTNDT | Requisition Date |
Date | 4 | View | |
SHIPMTHD | Shipping Method |
String | 16 | View | |
TXRGNNUM | Tax Registration Number |
String | 26 | View | |
REMSUBTO | Remaining Subtotal |
Currency | 10 | View | |
SUBTOTAL | Subtotal |
Currency | 10 | View | |
TRDISAMT | Trade Discount Amount |
Currency | 10 | View | |
TRDPCTPR | Trade Discount Percent (Precise) |
Currency (Variable) | 12 | View | |
FRTAMNT | Freight Amount |
Currency | 10 | View | |
MSCCHAMT | Misc Charges Amount |
Currency | 10 | View | |
TAXAMNT | Tax Amount |
Currency | 10 | View | |
VENDORID | Vendor ID |
String | 16 | View | |
VENDNAME | Vendor Name |
String | 66 | View | |
MINORDER | Minimum Order |
Currency | 10 | View | |
VADCDPAD | Vendor Address Code - Purchase Address |
String | 16 | View | |
CMPANYID | Company ID |
Integer | 2 | View | |
PRBTADCD | Primary Billto Address Code |
String | 16 | View | |
PRSTADCD | Primary Shipto Address Code |
String | 16 | View | |
CMPNYNAM | Company Name |
String | 66 | View | |
CONTACT | Contact |
String | 62 | View | |
ADDRESS1 | Address 1 |
String | 62 | View | |
ADDRESS2 | Address 2 |
String | 62 | View | |
ADDRESS3 | Address 3 |
String | 62 | View | |
CITY | City |
String | 36 | View | |
STATE | State |
String | 30 | View | |
ZIPCODE | Zip Code |
String | 12 | View | |
CCode | Country Code |
String | 8 | View | |
COUNTRY | Country |
String | 62 | View | |
PHONE1 | Phone 1 |
String | 22 | View | |
PHONE2 | Phone 2 |
String | 22 | View | |
PHONE3 | Phone 3 |
String | 22 | View | |
FAX | Fax |
String | 22 | View | |
PYMTRMID | Payment Terms ID |
String | 22 | View | |
DSCDLRAM | Discount Dollar Amount |
Currency | 10 | View | |
DSCPCTAM | Discount Percent Amount |
Integer | 2 | View | |
DISAMTAV | Discount Amount Available |
Currency | 10 | View | |
DISCDATE | Discount Date |
Date | 4 | View | |
DUEDATE | Due Date |
Date | 4 | View | |
CUSTNMBR | Customer Number |
String | 16 | View | |
TIMESPRT | Times Printed |
Integer | 2 | View | |
CREATDDT | Created Date |
Date | 4 | View | |
MODIFDT | Modified Date |
Date | 4 | View | |
PONOTIDS_1 | PO Note ID Array[1] |
Currency | 10 | View | |
PONOTIDS_2 | PO Note ID Array[2] |
Currency | 10 | View | |
PONOTIDS_3 | PO Note ID Array[3] |
Currency | 10 | View | |
PONOTIDS_4 | PO Note ID Array[4] |
Currency | 10 | View | |
PONOTIDS_5 | PO Note ID Array[5] |
Currency | 10 | View | |
PONOTIDS_6 | PO Note ID Array[6] |
Currency | 10 | View | |
PONOTIDS_7 | PO Note ID Array[7] |
Currency | 10 | View | |
PONOTIDS_8 | PO Note ID Array[8] |
Currency | 10 | View | |
PONOTIDS_9 | PO Note ID Array[9] |
Currency | 10 | View | |
PONOTIDS_10 | PO Note ID Array[10] |
Currency | 10 | View | |
PONOTIDS_11 | PO Note ID Array[11] |
Currency | 10 | View | |
PONOTIDS_12 | PO Note ID Array[12] |
Currency | 10 | View | |
PONOTIDS_13 | PO Note ID Array[13] |
Currency | 10 | View | |
PONOTIDS_14 | PO Note ID Array[14] |
Currency | 10 | View | |
PONOTIDS_15 | PO Note ID Array[15] |
Currency | 10 | View | |
TRXSORCE | TRX Source |
String | 14 | View | |
COMMNTID | Comment ID |
String | 16 | View | |
CANCSUB | Canceled Subtotal |
Currency | 10 | View | |
CURNCYID | Currency ID |
String | 16 | View | |
CURRNIDX | Currency Index |
Integer | 2 | View | |
RATETPID | Rate Type ID |
String | 16 | View | |
EXGTBLID | Exchange Table ID |
String | 16 | View | |
XCHGRATE | Exchange Rate |
Currency (Variable) | 10 | View | |
EXCHDATE | Exchange Date |
Date | 4 | View | |
TIME1 | Time |
Time | 4 | View | |
RATECALC | Rate Calc Method |
Integer | 2 | View | |
DENXRATE | Denomination Exchange Rate |
Currency (Variable) | 10 | View | |
MCTRXSTT | MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. |
Integer | 2 | View | |
OREMSUBT | Originating Remaining Subtotal |
Currency | 10 | View | |
ORSUBTOT | Originating Subtotal |
Currency | 10 | View | |
Originating_Canceled_Sub | Originating Canceled Subtotal |
Currency | 10 | View | |
ORTDISAM | Originating Trade Discount Amount |
Currency | 10 | View | |
ORFRTAMT | Originating Freight Amount |
Currency | 10 | View | |
OMISCAMT | Originating Misc Charges Amount |
Currency | 10 | View | |
ORTAXAMT | Originating Tax Amount |
Currency | 10 | View | |
ORDDLRAT | Originating Discount Dollar Amount |
Currency | 10 | View | |
ODISAMTAV | Originating Discount Amount Available |
Currency | 10 | View | |
BUYERID | Buyer ID |
String | 16 | View | |
ALLOWSOCMTS | Allow SO Commitments |
Boolean | 2 | View | |
DISGRPER | Discount Grace Period |
Integer | 2 | View | |
DUEGRPER | Due Date Grace Period |
Integer | 2 | View | |
Revision_Number | Revision Number |
Integer | 2 | View | |
TAXSCHID | Tax Schedule ID |
String | 16 | View | |
TXSCHSRC | Tax Schedule Source |
Integer | 2 | View | |
BSIVCTTL | Based On Invoice Total |
Boolean | 2 | View | |
Purchase_Freight_Taxable | Purchase Freight Taxable |
Integer | 2 | View | |
Purchase_Misc_Taxable | Purchase Misc Taxable |
Integer | 2 | View | |
FRTSCHID | Freight Schedule ID |
String | 16 | View | |
MSCSCHID | Misc Schedule ID |
String | 16 | View | |
FRTTXAMT | Freight Tax Amount |
Currency | 10 | View | |
ORFRTTAX | Originating Freight Tax Amount |
Currency | 10 | View | |
MSCTXAMT | Misc Tax Amount |
Currency | 10 | View | |
ORMSCTAX | Originating Misc Tax Amount |
Currency | 10 | View | |
BCKTXAMT | Backout Tax Amount |
Currency | 10 | View | |
OBTAXAMT | Originating Backout Tax Amount |
Currency | 10 | View | |
BackoutFreightTaxAmt | Backout Freight Tax Amount |
Currency | 10 | View | |
OrigBackoutFreightTaxAmt | Originating Backout Freight Tax Amount |
Currency | 10 | View | |
BackoutMiscTaxAmt | Backout Misc Tax Amount |
Currency | 10 | View | |
OrigBackoutMiscTaxAmt | Originating Backout Misc Tax Amount |
Currency | 10 | View | |
Flags | Flags |
Integer | 2 | View | |
POPCONTNUM | POP Contract Number |
String | 22 | View | |
CONTENDDTE | Contract End Date |
Date | 4 | View | |
CNTRLBLKTBY | Control Blanket By |
Integer | 2 | View | |
PURCHCMPNYNAM | Purchase Company Name |
String | 66 | View | |
PURCHCONTACT | Purchase Contact |
String | 62 | View | |
PURCHADDRESS1 | Purchase Address 1 |
String | 62 | View | |
PURCHADDRESS2 | Purchase Address 2 |
String | 62 | View | |
PURCHADDRESS3 | Purchase Address 3 |
String | 62 | View | |
PURCHCITY | Purchase City |
String | 36 | View | |
PURCHSTATE | Purchase State |
String | 30 | View | |
PURCHZIPCODE | Purchase Zip Code |
String | 12 | View | |
PURCHCCode | Purchase Country Code |
String | 8 | View | |
PURCHCOUNTRY | Purchase Country |
String | 62 | View | |
PURCHPHONE1 | Purchase Phone 1 |
String | 22 | View | |
PURCHPHONE2 | Purchase Phone 2 |
String | 22 | View | |
PURCHPHONE3 | Purchase Phone 3 |
String | 22 | View | |
PURCHFAX | Purchase Fax |
String | 22 | View | |
BLNKTLINEEXTQTYSUM | Total Blanket Line Ext Qty |
Currency | 10 | View | |
Workflow_Approval_Status | Workflow Approval Status 1 – Not Submitted |
Integer | 2 | View | |
Workflow_Priority | Workflow Priority |
Integer | 2 | View | |
Print_Phone_NumberGB | Print Phone Number GB |
Integer | 2 | View | |
PrepaymentAmount | Prepayment Amount |
Currency | 10 | View | |
OriginatingPrepaymentAmt | Originating Prepayment Amount |
Currency | 10 | View |