PORHSEQ |
BCD*10.0 |
Purchase Order Sequence Key |
|
PORLREV |
BCD*10.0 |
Line Number |
|
AUDTDATE |
Date |
|
|
AUDTTIME |
Time |
|
|
AUDTUSER |
String*8 |
|
|
AUDTORG |
String*6 |
|
|
PORLSEQ |
BCD*10.0 |
Purchase Order Line Sequence |
|
PORCSEQ |
BCD*10.0 |
Purchase Order Comment Sequence |
|
INDBTABLE |
Boolean |
Stored in Database Table |
List: 2 entries
|
CONSOLSEQ |
BCD*10.0 |
Consolidated to line |
|
RQNHSEQ |
BCD*10.0 |
Requisition Sequence Key |
|
RQNLSEQ |
BCD*10.0 |
Requisition Line Sequence |
|
OEONUMBER |
String*22 |
Order Number |
Mask: %-22C |
POSTEDTOIC |
Boolean |
Posted to I/C |
List: 2 entries
|
TOPOSTTOIC |
Boolean |
To Post to I/C |
List: 2 entries
|
STPRINT |
Boolean |
Print Status |
List: 2 entries
|
COMPLETION |
Integer |
Completion Status |
List: 3 entries
|
DTCOMPLETE |
Date |
Date Completed |
|
ITEMEXISTS |
Boolean |
Item Exists |
List: 2 entries
|
ITEMNO |
String*24 |
Item Number |
Mask: %-24C |
LOCATION |
String*6 |
Location |
Mask: %-6N |
ITEMDESC |
String*60 |
Item Description |
|
EXPARRIVAL |
Date |
Expected Arrival Date |
|
VENDITEMNO |
String*24 |
Vendor Item Number |
|
HASCOMMENT |
Boolean |
Comments/Instructions |
List: 2 entries
|
ORDERUNIT |
String*10 |
Unit of Measure |
Mask: %-10c |
ORDERCONV |
BCD*10.6 |
Order Unit Conversion |
|
ORDERDECML |
Integer |
Order Unit Decimals |
|
STOCKDECML |
Integer |
Stock Unit Decimals |
|
OQORDERED |
BCD*10.4 |
Quantity Ordered |
|
OQRECEIVED |
BCD*10.4 |
Quantity Received |
|
OQCANCELED |
BCD*10.4 |
Quantity Canceled |
|
OQRCPEXTRA |
BCD*10.4 |
Received Extra |
|
OQOUTSTAND |
BCD*10.4 |
Quantity Outstanding |
|
SQORDERED |
BCD*10.4 |
Stocking Quantity Ordered |
|
SQRECEIVED |
BCD*10.4 |
Stocking Quantity Received |
|
SQCANCELED |
BCD*10.4 |
Stocking Quantity Canceled |
|
SQRCPEXTRA |
BCD*10.4 |
Stocking Quantity Received Extra |
|
SQSETTLED |
BCD*10.4 |
Stocking Quantity Settled |
|
SQOUTSTAND |
BCD*10.4 |
Stocking Quantity Outstanding |
|
UNITWEIGHT |
BCD*10.4 |
Unit Weight |
|
EXTWEIGHT |
BCD*10.4 |
Extended Weight |
|
OQRCPDAYS |
BCD*10.4 |
Days * Quantity Received |
|
EXTRECEIVE |
BCD*10.3 |
Extended Received Amount |
|
EXTCANCEL |
BCD*10.3 |
Extended Canceled Amount |
|
SRRECEIVED |
BCD*10.3 |
Amount Received To Date |
|
UNITCOST |
BCD*10.6 |
Unit Cost |
|
EXTENDED |
BCD*10.3 |
Extended Cost |
|
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 |
|
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 |
|
TAXRATE1 |
BCD*8.5 |
Tax Rate 1 |
|
TAXRATE2 |
BCD*8.5 |
Tax Rate 2 |
|
TAXRATE3 |
BCD*8.5 |
Tax Rate 3 |
|
TAXRATE4 |
BCD*8.5 |
Tax Rate 4 |
|
TAXRATE5 |
BCD*8.5 |
Tax Rate 5 |
|
TAXINCLUD1 |
Boolean |
Tax Includable 1 |
List: 2 entries
|
TAXINCLUD2 |
Boolean |
Tax Includable 2 |
List: 2 entries
|
TAXINCLUD3 |
Boolean |
Tax Includable 3 |
List: 2 entries
|
TAXINCLUD4 |
Boolean |
Tax Includable 4 |
List: 2 entries
|
TAXINCLUD5 |
Boolean |
Tax Includable 5 |
List: 2 entries
|
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 |
|
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 |
|
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 |
|
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 |
Recoverable Tax |
|
TXEXPSAMT |
BCD*10.3 |
Expensed Tax |
|
TXALLOAMT |
BCD*10.3 |
Allocated Tax |
|
FCEXTENDED |
BCD*10.3 |
Rcp. Ext. Amt. |
|
GLACEXPENS |
String*45 |
Expense Account |
Mask: %-45C |
HASDROPSHI |
Boolean |
Drop-Ship |
List: 2 entries
|
DROPTYPE |
Integer |
Drop-Ship Type |
List: 4 entries
2 | = | Address Entered | 3 | = | Inventory Location Address | 4 | = | Customer Address | 5 | = | Customer Ship-To Address |
|
IDCUST |
String*12 |
Drop-Ship Customer |
Mask: %-12C |
IDCUSTSHPT |
String*6 |
Customer Ship-To Address |
Mask: %-6C |
DLOCATION |
String*6 |
Drop-Ship Location |
Mask: %-6N |
DESC |
String*60 |
Drop-Ship Description |
|
ADDRESS1 |
String*60 |
Drop-Ship Address 1 |
|
ADDRESS2 |
String*60 |
Drop-Ship Address 2 |
|
ADDRESS3 |
String*60 |
Drop-Ship Address 3 |
|
ADDRESS4 |
String*60 |
Drop-Ship Address 4 |
|
CITY |
String*30 |
Drop-Ship City |
|
STATE |
String*30 |
Drop-Ship State/Province |
|
ZIP |
String*20 |
Drop-Ship Zip/Postal Code |
|
COUNTRY |
String*30 |
Drop-Ship Country |
|
PHONE |
String*30 |
Drop-Ship Phone Number |
Mask: (%-3C) %-3C-%-24C |
FAX |
String*30 |
Drop-Ship Fax Number |
Mask: (%-3C) %-3C-%-24C |
CONTACT |
String*60 |
Drop-Ship Contact |
|
STOCKITEM |
Boolean |
Stock Item |
List: 2 entries
|
EMAIL |
String*50 |
Drop-Ship E-mail |
|
PHONEC |
String*30 |
Drop-Ship Contact Phone |
Mask: (%-3C) %-3C-%-24C |
FAXC |
String*30 |
Drop-Ship Contact Fax |
Mask: (%-3C) %-3C-%-24C |
EMAILC |
String*50 |
Drop-Ship Contact E-mail |
|
GLNONSTKCR |
String*45 |
Non-Stock Clearing Account |
Mask: %-45C |
MANITEMNO |
String*24 |
Manufacturer's Item Number |
Mask: %-24C |
DISCPCT |
BCD*5.5 |
Discount Percentage |
|
DISCOUNT |
BCD*10.3 |
Discount Amount |
|
VALUES |
Long |
Optional Fields |
|
DISCOUNTF |
BCD*10.3 |
Func. Discount Amount |
|
ISRECEIVED |
Boolean |
Received |
List: 2 entries
|
AGENTLSEQ |
BCD*10.0 |
Agent Line Sequence |
|
CONTRACT |
String*16 |
Contract |
Mask: %-16C |
PROJECT |
String*16 |
Project |
Mask: %-16N |
CCATEGORY |
String*16 |
(Cost) Category |
Mask: %-16N |
COSTCLASS |
Integer |
Cost Class |
List: 7 entries
0 | = | | 1 | = | Labor | 2 | = | Material | 3 | = | Equipment | 4 | = | Subcontractor | 5 | = | Overhead | 6 | = | Miscellaneous |
|
BILLTYPE |
Integer |
Billing Type |
List: 4 entries
0 | = | | 1 | = | Non-billable | 2 | = | Billable | 3 | = | No Charge |
|
BILLRATE |
BCD*10.6 |
Billing Rate |
|
BILLCURR |
String*3 |
Billing Currency |
Mask: %-3N |
ARITEMNO |
String*16 |
A/R Item Number |
Mask: %-16C |
ARUNIT |
String*10 |
A/R Unit of Measure |
Mask: %-10C |
TFBASEALLO |
BCD*10.3 |
Func. Net of Tax |
|
TFINCLUDE1 |
BCD*10.3 |
Func. Tax Included Amount 1 |
|
TFINCLUDE2 |
BCD*10.3 |
Func. Tax Included Amount 2 |
|
TFINCLUDE3 |
BCD*10.3 |
Func. Tax Included Amount 3 |
|
TFINCLUDE4 |
BCD*10.3 |
Func. Tax Included Amount 4 |
|
TFINCLUDE5 |
BCD*10.3 |
Func. Tax Included Amount 5 |
|
TFALLOAMT1 |
BCD*10.3 |
Func. Tax Allocated Amount 1 |
|
TFALLOAMT2 |
BCD*10.3 |
Func. Tax Allocated Amount 2 |
|
TFALLOAMT3 |
BCD*10.3 |
Func. Tax Allocated Amount 3 |
|
TFALLOAMT4 |
BCD*10.3 |
Func. Tax Allocated Amount 4 |
|
TFALLOAMT5 |
BCD*10.3 |
Func. Tax Allocated Amount 5 |
|
TFRECVAMT1 |
BCD*10.3 |
Func. Tax Recoverable Amount 1 |
|
TFRECVAMT2 |
BCD*10.3 |
Func. Tax Recoverable Amount 2 |
|
TFRECVAMT3 |
BCD*10.3 |
Func. Tax Recoverable Amount 3 |
|
TFRECVAMT4 |
BCD*10.3 |
Func. Tax Recoverable Amount 4 |
|
TFRECVAMT5 |
BCD*10.3 |
Func. Tax Recoverable Amount 5 |
|
TFEXPSAMT1 |
BCD*10.3 |
Func. Tax Expense Amount 1 |
|
TFEXPSAMT2 |
BCD*10.3 |
Func. Tax Expense Amount 2 |
|
TFEXPSAMT3 |
BCD*10.3 |
Func. Tax Expense Amount 3 |
|
TFEXPSAMT4 |
BCD*10.3 |
Func. Tax Expense Amount 4 |
|
TFEXPSAMT5 |
BCD*10.3 |
Func. Tax Expense Amount 5 |
|
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 |
|
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 |
|
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 |
|
UCISMANUAL |
Boolean |
Unit Cost is Manual |
List: 2 entries
|
WEIGHTUNIT |
String*10 |
Weight Unit of Measure |
|
WEIGHTCONV |
BCD*10.6 |
Weight Conversion |
|
DEFUWEIGHT |
BCD*10.4 |
Default Unit Weight |
|
DEFEXTWGHT |
BCD*10.4 |
Default Extended Weight |
|
COPYDETAIL |
Boolean |
Copy This Detail Line? |
List: 2 entries
|
|