| PORHSEQ |
BCD*10.0 |
Purchase Order Sequence Key |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| NEXTLSEQ |
BCD*10.0 |
Next Line Sequence |
|
| LINES |
Long |
Lines |
|
| LINESCMPL |
Long |
Lines Complete |
|
| TAXLINES |
Long |
Lines Tax Calculation Sees |
|
| RQNS |
Long |
Requisitions |
|
| RQNSCMPL |
Long |
Requisitions Completed |
|
| ISPRINTED |
Boolean |
Printed |
List: 2 entries
|
| TAXAUTOCAL |
Boolean |
Auto. tax calculation on save |
List: 2 entries
|
| LABELPRINT |
Boolean |
Labels Printed |
List: 2 entries
|
| LABELCOUNT |
Integer |
Number of Labels |
|
| ISCOMPLETE |
Boolean |
Completed |
List: 2 entries
|
| DTCOMPLETE |
Date |
Date Completed |
|
| POSTDATE |
Date |
Last Posting Date |
|
| DATE |
Date |
Purchase Order Date |
|
| PONUMBER |
String*22 |
Purchase Order Number |
Mask: %-22C |
| TEMPLATE |
String*6 |
Template Code |
Mask: %-6N |
| FOBPOINT |
String*60 |
FOB Point |
|
| VDCODE |
String*12 |
Vendor |
Mask: %-12C |
| VDEXISTS |
Boolean |
Vendor Exists |
List: 2 entries
|
| VDNAME |
String*60 |
Name |
|
| VDADDRESS1 |
String*60 |
Address 1 |
|
| VDADDRESS2 |
String*60 |
Address 2 |
|
| VDADDRESS3 |
String*60 |
Address 3 |
|
| VDADDRESS4 |
String*60 |
Address 4 |
|
| VDCITY |
String*30 |
City |
|
| VDSTATE |
String*30 |
State/Province |
|
| VDZIP |
String*20 |
Zip/Postal Code |
|
| VDCOUNTRY |
String*30 |
Country |
|
| VDPHONE |
String*30 |
Phone Number |
Mask: (%-3C) %-3C-%-24C |
| VDFAX |
String*30 |
Fax Number |
Mask: (%-3C) %-3C-%-24C |
| VDCONTACT |
String*60 |
Contact |
|
| TERMSCODE |
String*6 |
Terms Code |
Mask: %-6N |
| HASRQNDATA |
Boolean |
Requisitions |
List: 2 entries
|
| PORTYPE |
Integer |
Purchase Order Type |
List: 4 entries
| 1 | = | Active | | 2 | = | Standing | | 3 | = | Future | | 4 | = | Blanket |
|
| ONHOLD |
Boolean |
On Hold |
List: 2 entries
|
| ORDEREDON |
Date |
Order Date |
|
| EXPARRIVAL |
Date |
Expected Arrival Date |
|
| VCORIGINAL |
BCD*10.3 |
Amount Originally Authorized |
|
| VCAVAILABL |
BCD*10.3 |
Amount Remaining |
|
| DESCRIPTIO |
String*60 |
Description |
|
| REFERENCE |
String*60 |
Reference |
|
| COMMENT |
String*250 |
Comment |
|
| VIACODE |
String*6 |
Ship-Via |
Mask: %-6N |
| VIANAME |
String*60 |
Ship-Via Name |
|
| LASTRECEIP |
String*22 |
Last Receipt Number |
Mask: %-22C |
| RCPDATE |
Date |
Receipt Date |
|
| RCPCOUNT |
Integer |
Number of Posted Receipts |
|
| CURRENCY |
String*3 |
Currency |
Mask: %-3N |
| RATE |
BCD*8.7 |
Exchange Rate |
|
| SPREAD |
BCD*8.7 |
Rate Spread |
|
| RATETYPE |
String*2 |
Rate Type |
Mask: %-2N |
| RATEMATCH |
Integer |
Rate Match Type |
|
| RATEDATE |
Date |
Rate Date |
|
| RATEOPER |
Integer |
Rate Operation |
List: 2 entries
|
| RATEOVER |
Boolean |
Rate Overridden |
List: 2 entries
|
| SCURNDECML |
Integer |
Decimal Places |
|
| EXTWEIGHT |
BCD*10.4 |
Extended Weight |
|
| EXTENDED |
BCD*10.3 |
Extended Cost |
|
| DOCTOTAL |
BCD*10.3 |
Total |
|
| EXTRECEIVE |
BCD*10.3 |
Extended Received Amount |
|
| EXTCANCEL |
BCD*10.3 |
Extended Canceled Amount |
|
| OQORDERED |
BCD*10.4 |
Quantity Ordered |
|
| TAXGROUP |
String*12 |
Tax Group |
Mask: %-12N |
| TAXAUTH1 |
String*12 |
Tax Authority 1 |
Mask: %-12N |
| TAXAUTH2 |
String*12 |
Tax Authority 2 |
Mask: %-12N |
| TAXAUTH3 |
String*12 |
Tax Authority 3 |
Mask: %-12N |
| TAXAUTH4 |
String*12 |
Tax Authority 4 |
Mask: %-12N |
| TAXAUTH5 |
String*12 |
Tax Authority 5 |
Mask: %-12N |
| TAXCLASS1 |
Integer |
Tax Class 1 |
|
| TAXCLASS2 |
Integer |
Tax Class 2 |
|
| TAXCLASS3 |
Integer |
Tax Class 3 |
|
| TAXCLASS4 |
Integer |
Tax Class 4 |
|
| TAXCLASS5 |
Integer |
Tax Class 5 |
|
| TAXBASE1 |
BCD*10.3 |
Tax Base 1 |
|
| TAXBASE2 |
BCD*10.3 |
Tax Base 2 |
|
| TAXBASE3 |
BCD*10.3 |
Tax Base 3 |
|
| TAXBASE4 |
BCD*10.3 |
Tax Base 4 |
|
| TAXBASE5 |
BCD*10.3 |
Tax Base 5 |
|
| TXINCLUDE1 |
BCD*10.3 |
Included Tax Amount 1 |
|
| TXINCLUDE2 |
BCD*10.3 |
Included Tax Amount 2 |
|
| TXINCLUDE3 |
BCD*10.3 |
Included Tax Amount 3 |
|
| TXINCLUDE4 |
BCD*10.3 |
Included Tax Amount 4 |
|
| TXINCLUDE5 |
BCD*10.3 |
Included Tax Amount 5 |
|
| TXEXCLUDE1 |
BCD*10.3 |
Excluded Tax Amount 1 |
|
| TXEXCLUDE2 |
BCD*10.3 |
Excluded Tax Amount 2 |
|
| TXEXCLUDE3 |
BCD*10.3 |
Excluded Tax Amount 3 |
|
| TXEXCLUDE4 |
BCD*10.3 |
Excluded Tax Amount 4 |
|
| TXEXCLUDE5 |
BCD*10.3 |
Excluded Tax Amount 5 |
|
| TAXAMOUNT1 |
BCD*10.3 |
Tax Amount 1 |
|
| TAXAMOUNT2 |
BCD*10.3 |
Tax Amount 2 |
|
| TAXAMOUNT3 |
BCD*10.3 |
Tax Amount 3 |
|
| TAXAMOUNT4 |
BCD*10.3 |
Tax Amount 4 |
|
| TAXAMOUNT5 |
BCD*10.3 |
Tax Amount 5 |
|
| TXRECVAMT1 |
BCD*10.3 |
Tax Recoverable Amount 1 |
|
| TXRECVAMT2 |
BCD*10.3 |
Tax Recoverable Amount 2 |
|
| TXRECVAMT3 |
BCD*10.3 |
Tax Recoverable Amount 3 |
|
| TXRECVAMT4 |
BCD*10.3 |
Tax Recoverable Amount 4 |
|
| TXRECVAMT5 |
BCD*10.3 |
Tax Recoverable Amount 5 |
|
| TXEXPSAMT1 |
BCD*10.3 |
Tax Expense Amount 1 |
|
| TXEXPSAMT2 |
BCD*10.3 |
Tax Expense Amount 2 |
|
| TXEXPSAMT3 |
BCD*10.3 |
Tax Expense Amount 3 |
|
| TXEXPSAMT4 |
BCD*10.3 |
Tax Expense Amount 4 |
|
| TXEXPSAMT5 |
BCD*10.3 |
Tax Expense Amount 5 |
|
| TXALLOAMT1 |
BCD*10.3 |
Tax Allocated Amount 1 |
|
| TXALLOAMT2 |
BCD*10.3 |
Tax Allocated Amount 2 |
|
| TXALLOAMT3 |
BCD*10.3 |
Tax Allocated Amount 3 |
|
| TXALLOAMT4 |
BCD*10.3 |
Tax Allocated Amount 4 |
|
| TXALLOAMT5 |
BCD*10.3 |
Tax Allocated Amount 5 |
|
| TXBASEALLO |
BCD*10.3 |
Net of Tax |
|
| TXINCLUDED |
BCD*10.3 |
Tax Included |
|
| TXEXCLUDED |
BCD*10.3 |
Tax Excluded |
|
| TAXAMOUNT |
BCD*10.3 |
Total Tax |
|
| TXRECVAMT |
BCD*10.3 |
Total Tax Recoverable |
|
| TXEXPSAMT |
BCD*10.3 |
Total Tax Expensed |
|
| TXALLOAMT |
BCD*10.3 |
Total Tax Allocated |
|
| DOCSOURCE |
Integer |
Document Source |
List: 2 entries
|
| VDEMAIL |
String*50 |
E-mail |
|
| VDPHONEC |
String*30 |
Contact Phone |
Mask: (%-3C) %-3C-%-24C |
| VDFAXC |
String*30 |
Contact Fax |
Mask: (%-3C) %-3C-%-24C |
| VDEMAILC |
String*50 |
Contact E-mail |
|
| DISCPCT |
BCD*5.5 |
Discount Percentage |
|
| DISCOUNT |
BCD*10.3 |
Discount Amount |
|
| VALUES |
Long |
Optional Fields |
|
| RQNNUMBER |
String*22 |
Requisition Number |
Mask: %-22C |
| RQNHSEQ |
BCD*10.0 |
Requisition Sequence Key |
|
| SCAMOUNT |
BCD*10.3 |
Conversion Source Amount |
|
| FCAMOUNT |
BCD*10.3 |
Conversion Functional Amount |
|
| JOBLINES |
Long |
Job Related Lines |
|
| TRCURRENCY |
String*3 |
Tax Reporting Currency |
Mask: %-3N |
| RATERC |
BCD*8.7 |
Tax Reporting Exchange Rate |
|
| SPREADRC |
BCD*8.7 |
Tax Reporting Rate Spread |
|
| RATETYPERC |
String*2 |
Tax Reporting Rate Type |
Mask: %-2N |
| RATEMTCHRC |
Integer |
Tax Reporting Rate Match Type |
|
| RATEDATERC |
Date |
Tax Reporting Rate Date |
|
| RATEOPERRC |
Integer |
Tax Reporting Rate Operation |
List: 2 entries
|
| RATERCOVER |
Boolean |
Tax Reporting Rate Overridden |
List: 2 entries
|
| RCURNDECML |
Integer |
Tax Reporting Decimal Places |
|
| TARAMOUNT1 |
BCD*10.3 |
Tax Reporting Amount 1 |
|
| TARAMOUNT2 |
BCD*10.3 |
Tax Reporting Amount 2 |
|
| TARAMOUNT3 |
BCD*10.3 |
Tax Reporting Amount 3 |
|
| TARAMOUNT4 |
BCD*10.3 |
Tax Reporting Amount 4 |
|
| TARAMOUNT5 |
BCD*10.3 |
Tax Reporting Amount 5 |
|
| TRINCLUDE1 |
BCD*10.3 |
Tax Reporting Included Amount 1 |
|
| TRINCLUDE2 |
BCD*10.3 |
Tax Reporting Included Amount 2 |
|
| TRINCLUDE3 |
BCD*10.3 |
Tax Reporting Included Amount 3 |
|
| TRINCLUDE4 |
BCD*10.3 |
Tax Reporting Included Amount 4 |
|
| TRINCLUDE5 |
BCD*10.3 |
Tax Reporting Included Amount 5 |
|
| TREXCLUDE1 |
BCD*10.3 |
Tax Reporting Excluded Amount 1 |
|
| TREXCLUDE2 |
BCD*10.3 |
Tax Reporting Excluded Amount 2 |
|
| TREXCLUDE3 |
BCD*10.3 |
Tax Reporting Excluded Amount 3 |
|
| TREXCLUDE4 |
BCD*10.3 |
Tax Reporting Excluded Amount 4 |
|
| TREXCLUDE5 |
BCD*10.3 |
Tax Reporting Excluded Amount 5 |
|
| TRRECVAMT1 |
BCD*10.3 |
Tax Reporting Recoverable Amt. 1 |
|
| TRRECVAMT2 |
BCD*10.3 |
Tax Reporting Recoverable Amt. 2 |
|
| TRRECVAMT3 |
BCD*10.3 |
Tax Reporting Recoverable Amt. 3 |
|
| TRRECVAMT4 |
BCD*10.3 |
Tax Reporting Recoverable Amt. 4 |
|
| TRRECVAMT5 |
BCD*10.3 |
Tax Reporting Recoverable Amt. 5 |
|
| TREXPSAMT1 |
BCD*10.3 |
Tax Reporting Expense Amount 1 |
|
| TREXPSAMT2 |
BCD*10.3 |
Tax Reporting Expense Amount 2 |
|
| TREXPSAMT3 |
BCD*10.3 |
Tax Reporting Expense Amount 3 |
|
| TREXPSAMT4 |
BCD*10.3 |
Tax Reporting Expense Amount 4 |
|
| TREXPSAMT5 |
BCD*10.3 |
Tax Reporting Expense Amount 5 |
|
| TRALLOAMT1 |
BCD*10.3 |
Tax Reporting Allocated Amount 1 |
|
| TRALLOAMT2 |
BCD*10.3 |
Tax Reporting Allocated Amount 2 |
|
| TRALLOAMT3 |
BCD*10.3 |
Tax Reporting Allocated Amount 3 |
|
| TRALLOAMT4 |
BCD*10.3 |
Tax Reporting Allocated Amount 4 |
|
| TRALLOAMT5 |
BCD*10.3 |
Tax Reporting Allocated Amount 5 |
|
|